Advertisement
Guest User

Untitled

a guest
Nov 26th, 2015
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.96 KB | None | 0 0
  1. function get_all_program()
  2.     {
  3.         return $this->db->get('am_program');
  4.     }
  5.  
  6. function get_current_property()
  7. {
  8.     $this->db->select("am_program_property.property_id as property_id,
  9.         am_property.property_type_id as property_type_id,
  10.         am_property.name as property_name,
  11.          am_property.is_mandatory as is_mandatory");
  12.     $this->db->from('am_program_property');
  13.     $this->db->join('am_property', 'am_program_property.property_id = am_property.id');
  14.     return $this->db->get();
  15. }
  16.  
  17.     function get_all_value()
  18.     {
  19.         $this->db->select('am_program_has_property.program_id as program_id,
  20.             am_program_has_property.property_id as property_id,
  21.             am_program_has_property.property_value_id as property_value_id,
  22.          am_property_value.name as property_value');
  23.         $this->db->from('am_program_has_property');
  24.         $this->db->join('am_property_value', 'am_program_has_property.property_value_id = am_property_value.id');
  25.         return $this->db->get();
  26.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement