Changeset 442 for pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php

Timestamp:

Nov 10, 2014 11:07:50 AM (11 years ago)

Author:

quyenla

Message:

paidlogs

File:

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

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

@@ -10 +10 @@
         {
                 parent::__construct();
+
         }
         function getPaidlogs($data) {
@@ -15 +16 @@
         if ($data['keyword']) {
             if ($data['search_field'] == "cellphone") {
-                $sql.=" WHERE (service_id LIKE '%" . $data['keyword'] . "%')";
-            } else {
-                $sql.=" WHERE (sms_content LIKE '%" . $data['keyword'] . "%' OR sms_reply LIKE '%" . $data['keyword'] . "%') ";
-            }
+                $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
+            } 
         }
 
@@ -51 +50 @@
 
     function countPaidlog($data) {
-        $sql = "SELECT COUNT(".$this->id_name.") as total FROM " . $this->table_name;
+        $sql = "SELECT COUNT(".$this->id_name.") as total FROM " . $this->table_name." INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id";
         if ($data['keyword']) {
             if ($data['search_field'] == "cellphone") {
-                $sql.=" WHERE (service_id LIKE '%" . $data['keyword'] . "%')";
-            } else {
-                $sql.=" WHERE (sms_content LIKE '%" . $data['keyword'] . "%' OR sms_reply LIKE '%" . $data['keyword'] . "%') ";
-            }
+                $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
+            } 
         }
+        
         $result = $this->db->query($sql)->row_array();
         return $result['total'];