Changeset 574

Timestamp:

Nov 19, 2014 2:08:05 PM (10 years ago)

Author:

namnd

Message:

 

Location:

pro-violet-viettel/sourcecode

Files:

• application/config/routes.php (modified) (1 diff)
• application/modules/frontend/controllers/user.php (modified) (2 diffs)
• application/modules/frontend/models/user_model.php (modified) (2 diffs)
• application/modules/frontend/views/user_profile.php (modified) (4 diffs)
• application/views/layout/frontend/header.php (modified) (2 diffs)
• assets/js/frontend/user.js (modified) (2 diffs)

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

@@ -125 +125 @@
 $route['admin/card_log/trang/:any'] = 'admin/cardlog/get_cardlogs/$1';
 
+$route['frontend/user/trade_history/:num/page'] = 'frontend/user/trade_history/$1/1';
+$route['frontend/user/trade_history/:num/page/:any'] = 'frontend/user/trade_history/$1/$2';
 
 /* End of file routes.php */

pro-violet-viettel/sourcecode/application/modules/frontend/controllers/user.php

@@ -27 +27 @@
             $data['packages'] = $this->servicepackage_model->getAllPackages();
             $data['is_viettel'] = $user_info['is_viettel'];
-                        $paidlogs = $this->user_model->getPaidlog($us_id);
+                        //$paidlogs = $this->user_model->getPaidlog($us_id);
                         
-                        $data['paidlogs'] = $paidlogs;
+                        //$data['paidlogs'] = $paidlogs;
             parse_str($user, $info);
             $data = array_merge($data, $u);
@@ -287 +287 @@
         }
     }
+        
+        public function trade_history()
+        {
+                $this->load->helper('pagging');
+                $us_id = $this->uri->segment(4);
+        $user_info = $this->session->userdata('userInfo');
+        if ($user_info) 
+                {
+                        
+                        $data['us_id'] = $us_id;
+                        $data['perpage'] = 10;
+                        $data['current_page'] = $this->uri->segment(6, 1);
+                        $data['start'] = ($data['current_page'] - 1) * $data['perpage'];
+                        $this->load->model('user_model');
+                        $result = $this->user_model->getPaidlog($data);
+                        $data['total'] = $this->user_model->countPaiglogs($us_id);
+                        $data['num_links'] = 2;
+                        $data['paging_url'] = base_url() . "frontend/user/trade_history/".$us_id."/page/";
+                        $data['paging'] = pagging($data);
+                        $paidlogs = array();
+                        foreach ($result as $paidlog):
+                                $paidlog['amount'] = number_format($paidlog['amount'], 0);
+                                $paidlog['paid_time'] = date('d-m-Y H:i:s', strtotime($paidlog['paid_time']));
+                                array_push($paidlogs, $paidlog);
+                        endforeach;
+                        $data['paidlogs'] = $paidlogs;
+                        echo json_encode($data);
+                }else {
+            redirect('frontend/home');
+        }
+        }
 
 }

pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php

@@ -482 +482 @@
         }
         
-        public function getPaidlog($us_id)
+        public function getPaidlog($data)
         {
-                $this->db->query ( 'UNLOCK TABLES' );
-                $sql = 'SELECT * FROM tblpaidlog where us_id = ?';
+                $us_id = $data['us_id'];
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql = "SELECT * FROM tblpaidlog where us_id = ? ORDER BY paid_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
                 $query = $this->db->query ( $sql, array (
                                 $us_id
@@ -492 +493 @@
                 return $row;
         }
+        
+        public function countPaiglogs($us_id)
+        {
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql="SELECT COUNT(paid_id) AS total FROM tblpaidlog WHERE us_id = ?";
+                $query = $this->db->query ( $sql, array (
+                                $us_id
+                ) );
+                $result = $query->row_array();
+                return $result['total'];
+        }
 }

pro-violet-viettel/sourcecode/application/modules/frontend/views/user_profile.php

@@ -229 +229 @@
                                                                                         <label id="charging" style="display: none;"><span class="icon-refresh icon-refresh-animate"></span> Xin chờ...</label>
                                             <div class="space-4"></div>
-                                            <a href="#" data-toggle="modal" data-target="#trade-history"><i class="icon-archive"></i> Lịch sử giao dịch</a>
+                                            <a onclick="tradeHistory(<?php echo $us_id; ?>, 1);" data-toggle="modal"><i class="icon-archive"></i> Lịch sử giao dịch</a>
                                         </div>
                                         <div class="clearfix">
@@ -331 +331 @@
                                 </th>
                                 <th class="center">Số tiền (VNĐ)</th>
-
                                 <th>
                                     <i class="icon-time bigger-110 hidden-480"></i>
@@ -338 +337 @@
                             </tr>
                         </thead>
-
-                        <tbody>
-                                                        <?php if (isset($paidlogs)) {?>
-                                                        <?php foreach($paidlogs as $paidlog): ?>
-                            <tr>
-                                <td class="center">
-                                                                <?php echo $paidlog['source']; ?>
-                                </td>
-                                <td class="center"><?php echo number_format($paidlog['amount'], 0); ?></td>
-                                <td><?php echo date('d-m-Y H:i:s', strtotime($paidlog['paid_time']));?></td>
-                            </tr>
-                                                        <?php endforeach; ?>
-                                                        <?php }else{ ?>
-                                                        <tr>
-                                <td class="center" colspan=3>Quí vị chưa có giao dịch nà o!</td>
-                                                        </tr>
-                                                        <?php } ?>
+                        <tbody id="content-trade-histoty">
                         </tbody>
                     </table>
+                                        <div>
+                                                <div class="dataTables_paginate paging_bootstrap">
+                                                        <ul class="pagination">
+                                                        </ul>
+                                                </div>
+                                        </div>
                 </div><!-- /.table-responsive -->
             </div>
@@ -498 +487 @@
         var url="<?php echo base_url();?>";
         var current_tab="<?php echo $current_tab;?>";
+
 </script>
 <?php

pro-violet-viettel/sourcecode/application/views/layout/frontend/header.php

@@ -22 +22 @@
                         .sidebar:before, .sidebar {background-color: transparent;}
                         .icon-refresh-animate {
-                        -animation: spin .7s infinite linear;
-                        -webkit-animation: spin2 .7s infinite linear;
+                                -animation: spin .7s infinite linear;
+                                -webkit-animation: spin2 .7s infinite linear;
                         }
 
@@ -34 +34 @@
                                 from { transform: scale(1) rotate(0deg);}
                                 to { transform: scale(1) rotate(360deg);}
+                        }
+                        #frm3 a
+                        {
+                                cursor: pointer;
                         }
                 </style>

pro-violet-viettel/sourcecode/assets/js/frontend/user.js

@@ -66 +66 @@
             {
                 $("#package_register_modal").modal("hide");
-                $("#success_package_register_content").html("QuÃœ vị đã đăng kí sá»­ dụng CÃŽng cụ Soạn Bà i giảng trá»±c tuyến. Quí vị được sá»­ dụng dịch vụ đến hết 24h ngà y "+results.expire_date);
+                $("#success_package_register_content").html("QuÃœ vị đã đăng kí sá»­ dụng CÃŽng cụ Soạn Bà i giảng trức tuyến. Quí vị được sá»­ dụng dịch vụ đến hết 24h ngà y "+results.expire_date);
                 $("#success_package_register_modal").modal("show");
                 
@@ -161 +161 @@
 }
 
-
+function tradeHistory(id, page)
+{
+        $.ajax({
+                url: '/frontend/user/trade_history/'+id +'/page/'+page,
+                type: 'POST',
+                success: function(data)
+                {
+                        results = jQuery.parseJSON(data);
+                        paging = results.paging;
+                        result = results.paidlogs;
+                        content = "";
+                        if(result.length>0){
+                                for (var i in result)
+                                {
+                                        content += '<tr><td class="center">'+result[i].source+'</td><td class="center">'+result[i].amount+'</td><td>'+result[i].paid_time+'</td></tr>';
+                                        
+                                }
+                        }else
+                        {
+                                content += '<tr><td class="center" colspan=3>Quí vị chưa có giao dịch nà o!</td></tr>';
+                        }
+                        $("#trade-history").find("#content-trade-histoty").html(content);
+                        $("#trade-history").find(".pagination").html(paging);
+                         $(".ajax_paging").click(function ()
+                         {
+                                $.ajax({
+                                        url: $(this).attr("href"),
+                                        type: "POST",
+                                        success: function (data, textStatus, jqXHR)
+                                        {
+                                                results = jQuery.parseJSON(data);
+                                                tradeHistory(id, results.current_page);
+                                        },
+                                        error: function ()
+                                        {
+                                                $(".ajaxloading").hide();
+                                        }
+                                });
+                                return false;
+                         });
+                        $("#trade-history").modal('show');
+                }
+        });
+}