Changeset 373 for pro-violet-viettel/sourcecode/application/modules/admin

Timestamp:

Nov 3, 2014 10:17:45 AM (11 years ago)

Author:

quyenla

Message:

collaborator order sourcecode

Location:

pro-violet-viettel/sourcecode/application/modules/admin

Files:

• controllers/collaborator.php (modified) (1 diff)
• models/collabolator_model.php (modified) (1 diff)
• views/collaborator/listview.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/modules/admin/controllers/collaborator.php

@@ -43 +43 @@
         }
         if ($this->input->post('keyword')) {
+            $data['search_field']="";
             $data['keyword'] = $this->input->post('keyword');
+            $data['search_field']="cellphone";
+            
+            if (preg_match("/[0-9]/", $data['keyword']))
+            {
+               $data['search_field']="cellphone"; 
+            }
+            
         }
         

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

@@ -1 @@
-<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+<?php
+if (!defined('BASEPATH'))
+    exit('No direct script access allowed');
 
-class Collabolator_model extends MY_Model
-{
-        
-        protected $table_name = 'tblcollaborator';
-        protected $id_name = 'id';
+class Collabolator_model extends MY_Model {
 
-        function __construct()
-        {
-                parent::__construct();
-        }
-        function getCollaborator($data)
-        {
-            $sql="SELECT * FROM ".$this->table_name;
-            $data['keyword']='';
+    protected $table_name = 'tblcollaborator';
+    protected $id_name = 'id';
 
-            if ($data['keyword'])
-            {
-            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%') ";
+    function __construct() {
+        parent::__construct();
+    }
+
+    function getCollaborator($data) {
+        $sql = "SELECT * FROM " . $this->table_name;
+        if ($data['keyword']) {
+            if ($data['search_field'] == "cellphone") {
+                $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
+            } else {
+                $sql.=" WHERE (full_name LIKE '%" . $data['keyword'] . "%' OR login_name 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;
-                }
+        }
+
+        $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;
             }
-           
-            return $this->db->query($sql." ".$order." LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();
+        }
+       
+        return $this->db->query($sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " ")->result_array();
+    }
 
+    function isExist($data) {
+        $sql = "SELECT COUNT(id) as total FROM " . $this->table_name . " WHERE " . $data['field'] . " = '" . $data['value'] . "' LIMIT 1";
+        if ($this->db->query($sql)->row_array()['total'] == 1) {
+            return true;
+        } else {
+            return false;
         }
-        function isExist($data)
-        {
-            $sql="SELECT COUNT(id) as total FROM ".$this->table_name." WHERE ".$data['field']." = '".$data['value']."' LIMIT 1";
-            if ($this->db->query($sql)->row_array()['total']==1)
-            {
-                return true;
-            }
-            else
-            {
-                return false;
-            }
-            
+    }
+
+    function countCollaborator($data) {
+        $sql = "SELECT COUNT(id) as total FROM " . $this->table_name;
+        if (isset($data['keyword'])) {
+            $sql.=" WHERE (full_name LIKE '%" . $data['keyword'] . "%' OR login_name LIKE '%" . $data['keyword'] . "%') ";
         }
-        function countCollaborator($data)
-        {
-            $sql="SELECT COUNT(id) as total FROM ".$this->table_name;
-            if (isset($data['keyword']))
-            {
-            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%') ";
-            }
 
-            return $this->db->query($sql)->row_array()['total'];
-            
-        }
+        return $this->db->query($sql)->row_array()['total'];
+    }
+
 }

pro-violet-viettel/sourcecode/application/modules/admin/views/collaborator/listview.php

@@ -51 +51 @@
             <div class="table-responsive">
                 <div role="grid" class="dataTables_wrapper" id="sample-table-2_wrapper">
-                    <form onsubmit="return false;" id="collaborator" >
+                    <form autocomplete="off" onsubmit="return false;" id="collaborator" >
                         <div class="row">
                             <div class="col-sm-6">