Changeset 401 for pro-violet-viettel/sourcecode/application/modules/admin/models

Timestamp:

Nov 4, 2014 4:14:22 PM (11 years ago)

Author:

quyenla

Message:

collaborator

File:

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

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

@@ -12 +12 @@
     }
 
-    function getCollaborator($data) {
+    function getCollaborators($data) {
         $sql = "SELECT * FROM " . $this->table_name;
         if ($data['keyword']) {
@@ -36 +36 @@
 
     function isExist($data) {
-        $sql = "SELECT COUNT(id) as total FROM " . $this->table_name . " WHERE " . $data['field'] . " = '" . $data['value'] . "' LIMIT 1";
-        if ($this->db->query($sql)->row_array()['total'] == 1) {
+        $sql = "SELECT COUNT(id) as total FROM " . $this->table_name . " WHERE " . $data['field'] . " = '" . $data['value'] . "'";
+        if (isset($data['id']))
+        {
+            $id=$data['id'];
+            $sql.=" AND id <> ".$id." LIMIT 1";
+        }
+        $result = $this->db->query($sql)->row_array();
+        if ($result['total'] == 1) {
             return true;
         } else {
@@ -53 +59 @@
             }
         }
-        if (isset($this->db->query($sql)->row_array()['total']))
-        {
-        return $this->db->query($sql)->row_array()['total'];
-        }
-        else
-        {
-            return 0;
-        }
+        $result = $this->db->query($sql)->row_array();
+        return $result['total']; 
+    }
+    function getCollaborator($id)
+    {
+        $sql="SELECT * FROM ".$this->table_name." WHERE id=".$id." LIMIT 1";
+        $result = $this->db->query($sql)->row_array();
+        return $result;
     }