Changeset 426 for pro-violet-viettel/sourcecode/application/modules/admin/models/smslog_model.php

Timestamp:

Nov 6, 2014 5:31:13 PM (11 years ago)

Author:

namnd

Message:

 

File:

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

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

@@ -1 @@
-<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 
 class Smslog_model extends MY_Model
@@ -12 +12 @@
         }
         
+        function get_smslogs($data)
+        {
+                $sql = "SELECT * FROM " . $this->table_name;
+                if ($data['keyword'])
+                {
+                        $sql.=" WHERE (sender LIKE '%".$data['keyword']."%' OR mobody LIKE '%".$data['keyword']."%' OR mtbody LIKE '%".$data['keyword']."%') ";
+                }
+                $order = "";
+                if ($data['sorting_order'] != "sorting") {
+                        $sort = "DESC";
+                        if ($data['sorting_order'] == "sorting_asc")
+                                $sort = "ASC";
+                        $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
+                }
+                return $this->db->query($sql." ".$order." LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();
+        }
+        
+        function get_total_smslogs($data)
+        {
+                $sql="SELECT COUNT(".$this->id_name.") AS total FROM ".$this->table_name;
+                if (isset($data['keyword']))
+                {
+                        if (strlen($data['keyword'])>0)
+                                $sql.=" WHERE (sender LIKE '%".$data['keyword']."%' OR mobody LIKE '%".$data['keyword']."%' OR mtbody LIKE '%".$data['keyword']."%') ";
+                }
+                return $this->db->query($sql)->row_array()['total'];
+        }
 }