| | |
|---|
| | | $join = " LEFT JOIN ".get_table_name($this->db_groupmembers)." AS m". |
|---|
| | | " ON (m.contact_id = c.".$this->primary_key.")"; |
|---|
| | | |
|---|
| | | $order_col = (in_array($this->sort_col, $this->table_cols) ? $this->sort_col : 'name'); |
|---|
| | | $order_cols = array('c.'.$order_col); |
|---|
| | | if ($order_col == 'firstname') |
|---|
| | | $order_cols[] = 'c.surname'; |
|---|
| | | else if ($order_col == 'surname') |
|---|
| | | $order_cols[] = 'c.firstname'; |
|---|
| | | if ($order_col != 'name') |
|---|
| | | $order_cols[] = 'c.name'; |
|---|
| | | $order_cols[] = 'c.email'; |
|---|
| | | |
|---|
| | | $sql_result = $this->db->limitquery( |
|---|
| | | "SELECT * FROM ".get_table_name($this->db_name)." AS c" . |
|---|
| | | $join . |
|---|
| | |
|---|
| | | " AND c.user_id=?" . |
|---|
| | | ($this->group_id ? " AND m.contactgroup_id=?" : ""). |
|---|
| | | ($this->filter ? " AND (".$this->filter.")" : "") . |
|---|
| | | " ORDER BY ". $this->db->concat('c.name', 'c.email'), |
|---|
| | | " ORDER BY ". $this->db->concat($order_cols) . |
|---|
| | | " " . $this->sort_order, |
|---|
| | | $start_row, |
|---|
| | | $length, |
|---|
| | | $this->user_id, |
|---|
