Changeset 374 for pro-violet-viettel/sourcecode/application/modules/admin

Timestamp:

Nov 3, 2014 11:06:12 AM (11 years ago)

Author:

quyenla

Message:

collaborator order sourcecode

File:

• pro-violet-viettel/sourcecode/application/modules/admin/models/collabolator_model.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/modules/admin/models/collabolator_model.php

@@ -46 +46 @@
     function countCollaborator($data) {
         $sql = "SELECT COUNT(id) as total FROM " . $this->table_name;
-        if (isset($data['keyword'])) {
-            $sql.=" WHERE (full_name LIKE '%" . $data['keyword'] . "%' OR login_name LIKE '%" . $data['keyword'] . "%') ";
+        if ($data['keyword']) {
+            if ($data['search_field'] == "cellphone") {
+                $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
+            } else {
+                $sql.=" WHERE (full_name LIKE '%" . $data['keyword'] . "%' OR login_name LIKE '%" . $data['keyword'] . "%') ";
+            }
         }
-
+        if (isset($this->db->query($sql)->row_array()['total']))
+        {
         return $this->db->query($sql)->row_array()['total'];
+        }
+        else
+        {
+            return 0;
+        }
     }