Changeset 717 for pro-violet-viettel/sourcecode/application/modules/services/models/services_model.php

Timestamp:

Jan 29, 2015 5:32:13 PM (10 years ago)

Author:

namnd

Message:

 

File:

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

pro-violet-viettel/sourcecode/application/modules/services/models/services_model.php

@@ -481 +481 @@
                 }
         }
+        
+        public function deleteCollaborator($id){
+                $sql = "DELETE FROM tblcollaborator WHERE id = ". $id;
+                $this->db->query($sql);
+                if ($this->db->affected_rows()){
+                        $logMsg = date('Y-m-d H:i:s') . " Collaborator ID: ".$id.". Delete success! !\n";
+                        write_file('./log/delete_collaborator.log', $logMsg, FOPEN_WRITE_CREATE);
+                }else{
+                        $logMsg = date('Y-m-d H:i:s') . " Collaborator ID: ".$id.". Delete fail! !. Sql = ".$sql."\n";
+                        write_file('./log/delete_collaborator.log', $logMsg, FOPEN_WRITE_CREATE);
+                }
+        }
+        
+        public function getAllCollaboratorID(){
+                $sql = "Select id from tblcollaborator";
+                $query = $this->db->query($sql);
+                if ($this->db->affected_rows()){
+                        return $query->result();
+                }else
+                {
+                        return array();
+                }
+        }
 }