PHP form_sort_order_as_sql示例

示例#1

文件： register_model.php 项目： anupkelkar02/FSM

 public function get_rows($filter, $sort_order = '', $limit_start = -1, $limit_count = 0)
 {
     $where_sql = $this->get_where_sql($filter, 'reg');
     $sql = "SELECT reg.*" . " FROM #__register AS reg" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) : '') . (($limit_start >= 0 and $limit_count > 0) ? " LIMIT {$limit_start} , " . $limit_count : "");
     $query = $this->db->query($sql);
     return $query->result();
 }

示例#2

文件： postal_district_model.php 项目： anupkelkar02/FSM

 public function get_rows($filter, $sort_order = '', $limit_start = -1, $limit_count = 0)
 {
     $where_sql = $this->get_where_sql($filter, 'ptd');
     $sql = "SELECT ptd.*" . " FROM #__postal_district AS ptd" . " INNER JOIN #__postal_district_sector AS pts ON pts.postal_district_number = ptd.number" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) : '') . (($limit_start >= 0 and $limit_count > 0) ? " LIMIT {$limit_start} , " . $limit_count : "");
     $query = $this->db->query($sql);
     return $query->result();
 }

示例#3

文件： site_shift_model.php 项目： anupkelkar02/FSM

 public function get_rows($filter, $sort_order = '', $limit_start = -1, $limit_count = 0)
 {
     $where_sql = $this->get_where_sql($filter, 'sts');
     $sql = "SELECT sts.*" . " FROM #__site_shift AS sts" . " INNER JOIN #__site AS ste ON ste.id = sts.site_id" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) : '') . (($limit_start >= 0 and $limit_count > 0) ? " LIMIT {$limit_start} , " . $limit_count : "");
     $query = $this->db->query($sql);
     return $query->result();
 }

示例#4

文件： user_model.php 项目： anupkelkar02/FSM

 public function get_rows($filter, $sort_order = '', $limit_start = -1, $limit_count = 0)
 {
     $where_sql = $this->get_where_sql($filter, 'u');
     $sql = "SELECT u.*" . ", g.title AS group_title, g.name AS group_name" . " FROM #__user AS u" . " LEFT JOIN #__user_group AS g ON u.group_id = g.id" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) : '') . (($limit_start >= 0 and $limit_count > 0) ? " LIMIT {$limit_start} , " . $limit_count : "");
     $query = $this->db->query($sql);
     return $query->result();
 }

示例#5

文件： duty_model_bk14-07.php 项目： anupkelkar02/FSM

 public function get_row_count($filter, $sort_order = '')
 {
     $where_sql = $this->get_where_sql($filter, 'd');
     $sql = "SELECT COUNT(d.id) AS count" . " FROM #__duty AS d" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) : '');
     $query = $this->db->query($sql);
     $row = $query->row();
     if ($row) {
         return $row->count;
     }
     return 0;
 }

示例#6

文件： schedule_model.php 项目： anupkelkar02/FSM

 public function get_schedule($where_sql, $sort_order = '', $limit_start = -1, $limit_count = 0)
 {
     $sql = "SELECT sch.*" . " FROM #__schedule AS sch" . " INNER JOIN #__site AS ste ON ste.id = sch.site_id" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) . " desc" : '') . (($limit_start >= 0 and $limit_count > 0) ? " LIMIT {$limit_start} , " . $limit_count : "");
     $query = $this->db->query($sql);
     return $query->result();
 }

示例#7

文件： site_model.php 项目： anupkelkar02/FSM

 public function get_workingdays_rows($filter, $sort_order = '')
 {
     $where_sql = $this->get_where_sql($filter, 'ste');
     $sql = "SELECT ste.*" . " FROM #__working_days AS ste" . ($where_sql ? " WHERE {$where_sql} " : '') . ($sort_order ? " ORDER BY " . form_sort_order_as_sql($sort_order) : '');
     $query = $this->db->query($sql);
     return $query->result();
 }