PHP MY_Model::_add_filter_item_to_where_expression примеры использования

Пример #1

Файл: duty_model_bk14-07.php Проект: anupkelkar02/FSM

 protected function _add_filter_item_to_where_expression($name, $value)
 {
     if ($name == 'name_match') {
         if ($value == '' or $value == '0') {
             return;
         }
         return $this->_add_where_expression("( (stf.first_name LIKE  '%{$value}%') OR ( stf.last_name LIKE  '%{$value}%') )");
     }
     parent::_add_filter_item_to_where_expression($name, $value);
 }

Пример #2

Файл: timesheet_model.php Проект: anupkelkar02/FSM

 protected function _add_filter_item_to_where_expression($name, $value)
 {
     if ($name == 'name_match') {
         if ($value == '' or $value == '0') {
             return;
         }
         return $this->_add_where_expression("ste.name like  '%{$value}%'");
     }
     parent::_add_filter_item_to_where_expression($name, $value);
 }

Пример #3

Файл: postal_district_model.php Проект: anupkelkar02/FSM

 protected function _add_filter_item_to_where_expression($name, $value)
 {
     if ($name == 'postcode') {
         if ($value == '') {
             return;
         }
         $value = intval(substr($value, 0, 2));
         return $this->_add_where_expression("pts.postal_sector = {$value}");
     }
     return parent::_add_filter_item_to_where_expression($name, $value);
 }

Пример #4

Файл: schedule_model.php Проект: anupkelkar02/FSM

 protected function _add_filter_item_to_where_expression($name, $value)
 {
     if ($name == 'site_id_match') {
         if ($value == '' or $value == '0') {
             return;
         }
         return $this->_add_where_expression("sch.site_id = " . intval($value));
     }
     if ($name == 'start_date') {
         if ($value == '' or $value == '0') {
             return;
         }
         return $this->_add_where_expression("sch.start_date >= '{$value}'");
     }
     parent::_add_filter_item_to_where_expression($name, $value);
 }

Пример #5

Файл: user_model.php Проект: anupkelkar02/FSM

 protected function _add_filter_item_to_where_expression($name, $value)
 {
     if ($name == 'username_match') {
         if ($value == '') {
             return;
         }
         return $this->_add_where_expression("u.username LIKE '%{$value}%'");
     }
     if ($name == 'name_match') {
         if ($value == '') {
             return;
         }
         return $this->_add_where_expression("u.name LIKE '%{$value}%'");
     }
     if ($name == 'group_id' and intval($value) == 0) {
         return;
     }
     if ($name == 'owner_type_in') {
         if ($value == '') {
             return;
         }
         return $this->_add_where_expression("u.owner_type IN ('" . implode("','", $value) . "')");
     }
     parent::_add_filter_item_to_where_expression($name, $value);
 }