Changeset 559 for pro-violet-viettel/sourcecode/application

Timestamp:

Nov 18, 2014 5:13:28 PM (11 years ago)

Author:

namnd

Message:

 

Location:

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

Files:

• controllers/user.php (modified) (1 diff)
• models/user_model.php (modified) (3 diffs)
• views/user_profile.php (modified) (2 diffs)

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);
+                        $data['paidlogs'] = $paidlogs;
             parse_str($user, $info);
             $data = array_merge($data, $u);
             $data = array_merge($data, $user_info);
+                        //var_dump($data);
+                        
             $this->load->view('frontend/user_profile', $data);
         } else {

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

@@ -365 +365 @@
                         $user ['updated_time'] = date ( 'Y-m-d H:i:s' );
                         $this->updateUser ( $us_id, $user );
-                        $sms = "Qui vi da nap thanh cong " . $amount . " VND vao tai khoan " . $username . " tren soanbaigiang.smas.vn";
+                        $sms = "Qui vi da nap thanh cong " . $amount . " VNĐ vao tai khoan " . $username . " tren soanbaigiang.smas.vn";
                         $status = 1;
                 } else {
@@ -445 +445 @@
                 $paidlog ['paidType'] = $paidType;
                 $paidlog ['amount'] = $amount;
+                $paidlog['source'] = "";
+                if ($paidType == 1)
+                {
+                        $paidlog['source'] = $sentNumber;
+                        
+                }else
+                {
+                        $paidlog['source'] = "Thẻ cà o";
+                }
                 $paidlog ['paidTime'] = $paidTime;
                 $this->db->query ( 'UNLOCK TABLES' );
-                $sql = 'INSERT INTO tblpaidlog(us_id, paid_type, amount, paid_time) VALUES (?,?,?,?)';
+                $sql = 'INSERT INTO tblpaidlog(us_id, paid_type, amount, source, paid_time) VALUES (?,?,?,?,?)';
                 $query = $this->db->query ( $sql, $paidlog );
         }
@@ -469 +478 @@
                 $query = $this->db->query ($sql, $cardlog);
         }
+        
+        public function getPaidlog($us_id)
+        {
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql = 'SELECT * FROM tblpaidlog where us_id = ?';
+                $query = $this->db->query ( $sql, array (
+                                $us_id
+                ) );
+                $row = $query->result_array();
+                return $row;
+        }
 }

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

@@ -328 +328 @@
                             <tr>
                                 <th class="center">
-                                    <label>
-                                        <input type="checkbox" class="ace" />
-                                        <span class="lbl"></span>
-                                    </label>
+                                                                        Từ
                                 </th>
                                 <th>Số tiền</th>
@@ -343 +340 @@
 
                         <tbody>
+                                                        <?php if ($paidlogs) {?>
+                                                        <?php foreach($paidlogs as $paidlog): ?>
                             <tr>
                                 <td class="center">
-                                    <label>
-                                        <input type="checkbox" class="ace" />
-                                        <span class="lbl"></span>
-                                    </label>
+                                                                <?php echo $paidlog['source']; ?>
                                 </td>
-                                <td>$45</td>
-                                <td>Feb 12</td>
+                                <td><?php echo $paidlog['amount']; ?></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>
                     </table>