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); }
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); }
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); }
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); }
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); }