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

Timestamp:

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

Author:

quyenla

Message:

paidlogs

Location:

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

Files:

• controllers/report.php (modified) (3 diffs)
• models/paidlog_model.php (modified) (3 diffs)
• views/report/listview.php (modified) (2 diffs)

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

@@ -6 +6 @@
 class Report extends MX_Controller {
 
+    const TOKENPW = 'violet';
     public function __construct() {
         parent::__construct();
@@ -140 +141 @@
         $data['num_links'] = 2;
         $data['paging'] = pagging($data);
-
+        foreach ($data['paidlogs'] as $index=>$paidlog)
+        {
+        $data['paidlogs'][$index]['username']= @$this->get_username($paidlog['us_id']);
+        }
+      
         if ($this->input->is_ajax_request()) {
             return $this->load->view('report/listview', $data);
@@ -146 +151 @@
         return $this->load->view('report/listview', $data, true);
     }
+    public function get_username($us_id)
+        {
+        $us_id=33;
+                $src = 'violet';
+                $token = md5($us_id.self::TOKENPW);
+                $this->load->model('user_model');
+                $data = $this->user_model->get_user_info($src, $us_id, $token);
+                if (strlen($data) > 0){
+                        $arr_users = explode("&", $data);
+                        $str_username = $arr_users[1];
+                        $arr_username = explode("=", $str_username);
+                        return $arr_username[1];
+                }else
+                {
+                        return "";
+                }
+
+        }
 
     public function addPaidlog() {

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']; 

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

@@ -48 +48 @@
                                     </label>
                                 </th>
-                                <th class="<?php if ($sorting_field == 'fullname') {echo $sorting_order;} else {echo "sorting";}?>" id="full_name" role="columnheader" tabindex="0" aria-controls="sample-table-2" rowspan="1" colspan="1" style="width: 176px;" aria-label="Số điện thoại: activate to sort column ascending">Họ tên</th>
+                                <th class="<?php if ($sorting_field == 'fullname') {echo $sorting_order;} else {echo "";}?>" id="full_name" role="columnheader" tabindex="0" aria-controls="sample-table-2" rowspan="1" colspan="1" style="width: 176px;" aria-label="Số điện thoại: activate to sort column ascending">Họ tên</th>
                                 <th class="<?php if ($sorting_field == 'cellphone') {echo $sorting_order;} else {echo "sorting";}?>" id="cellphone" role="columnheader" tabindex="0" aria-controls="sample-table-2" rowspan="1" colspan="1" style="width: 283px;" aria-label="Họ tên: activate to sort column ascending">Số điện thoại</th>
                                 <th class="<?php if ($sorting_field == 'amount') {echo $sorting_order;} else {echo "sorting";}?>" id="amount" role="columnheader" tabindex="0" aria-controls="sample-table-2" rowspan="1" colspan="1" style="width: 176px;" aria-label="Số điện thoại: activate to sort column ascending">Số tiền</th> 
@@ -71 +71 @@
 
                                 <td class=" ">
-                                    <a href="#">Ho va ten</a>
+                                    <a href="#"><?php echo $paidlog['username'];?></a>
                                 </td>
                                 <td class=" "><?php echo $paidlog['cellphone']?></td>