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

Timestamp:

Jan 6, 2015 11:52:00 AM (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

@@ -420 +420 @@
                 return $result;
         }
+        
+        
+        public function syncCollaborator($data){
+                if ($data){
+                        $sql = $this->db->insert_string('tblcollaborator', $data) . ' ON DUPLICATE KEY UPDATE address = "'.$data['address'].'", 
+                                                                                                                                                                                                code = "'.$data['code'].'", 
+                                                                                                                                                                                                district = "'.$data['district'].'", 
+                                                                                                                                                                                                email = "'.$data['email'].'", 
+                                                                                                                                                                                                full_name = "'.$data['full_name'].'", 
+                                                                                                                                                                                                cellphone = "'.$data['cellphone'].'", 
+                                                                                                                                                                                                precinct = "'.$data['precinct'].'", 
+                                                                                                                                                                                                province = "'.$data['province'].'",
+                                                                                                                                                                                                updated_time = "'.$data['updated_time'].'"';
+                        $this->db->query($sql);
+                        $id = $this->db->insert_id();
+                        if ($this->db->affected_rows()){
+                                echo "Collaborator ID: ".$id.". Sync Success !<br/>";
+                        }else{
+                                echo "Collaborator ID: ".$id.". Sync fail!. Sql = ".$sql."<br/>";
+                        }
+                }else {
+                        var_dump($data);
+                }
+        }
 }