Changeset 404

Timestamp:

Nov 4, 2014 6:13:26 PM (11 years ago)

Author:

quyenla

Message:

collaborator

Location:

pro-violet-viettel/sourcecode/application

Files:

• config/routes.php (modified) (1 diff)
• modules/admin/models/smstemplate_model.php (modified) (2 diffs)
• views/layout/admin/sidebar.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/config/routes.php

@@ -57 +57 @@
 
 $route['admin/mau_tin_nhan'] = 'admin/smstemplate';
-$route['admin/mau_tin_nhan/trang'] = 'admin/smstemplate/getCollaborators/1';
-$route['admin/mau_tin_nhan/them'] = 'admin/smstemplate/addCollaborator';
-$route['admin/mau_tin_nhan/trang/:any'] = 'admin/smstemplate/getCollaborators/$1';
+$route['admin/mau_tin_nhan/trang'] = 'admin/smstemplate/getSmstemplates/1';
+$route['admin/mau_tin_nhan/them'] = 'admin/smstemplate/addSmstemplate';
+$route['admin/mau_tin_nhan/trang/:any'] = 'admin/smstemplate/getSmstemplates/$1';
 $route['admin/mau_tin_nhan/test'] = 'admin/smstemplate/test';
 $route['admin/mau_tin_nhan/xem/:any'] = 'admin/smstemplate/viewUser';

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

@@ -5 +5 @@
         
         protected $table_name = 'tblsmstemplate';
-        protected $id_name = 'id';
+        protected $id_name = 'sms_id';
 
         function __construct()
@@ -11 +11 @@
                 parent::__construct();
         }
-        
+        function getSmstemplates($data) {
+        $sql = "SELECT * FROM " . $this->table_name;
+        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'] . "%') ";
+            }
+        }
+
+        $order = "";
+        if ($data['sorting_order'] != "sorting") {
+            if ($data['sorting_field'] != "money") {
+                $sort = "DESC";
+                if ($data['sorting_order'] == "sorting_asc")
+                    $sort = "ASC";
+                $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
+            }
+        }
+        $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
+       
+        return $this->db->query($sql)->result_array();
+    }
+
+    function isExist($data) {
+        $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 {
+            return false;
+        }
+    }
+
+    function countSmstemplate($data) {
+        $sql = "SELECT COUNT(".$this->id_name.") as total FROM " . $this->table_name;
+        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'] . "%') ";
+            }
+        }
+        $result = $this->db->query($sql)->row_array();
+        return $result['total']; 
+    }
+    function getSmstemplate($id)
+    {
+        $sql="SELECT * FROM ".$this->table_name." WHERE ".$this->id_name."=".$id." LIMIT 1";
+        $result = $this->db->query($sql)->row_array();
+        return $result;
+    }
 }

pro-violet-viettel/sourcecode/application/views/layout/admin/sidebar.php

@@ -138 +138 @@
                                                         </a>
                                                 </li>
+                                                <li class="<?php if(in_array($class,array("smstemplate"))) {echo "active";}?>">
+                                                        <a href="<?php echo $base_url;?>admin/mau_tin_nhan" class="dropdown-toggle">
+                                                                <i class="icon-cog"></i>
+                                                                <span class="menu-text"> Mẫu tin nhắn </span>
+                                                        </a>
+                                                </li>
 
                                         </ul><!-- /.nav-list -->