Changeset 441 for pro-violet-viettel/sourcecode/application/modules/admin/models

Timestamp:

Nov 10, 2014 10:10:32 AM (11 years ago)

Author:

quyenla

Message:

paidlogs

File:

• pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php (modified) (4 diffs)

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

@@ -11 +11 @@
                 parent::__construct();
         }
-        function getSmstemplates($data) {
+        function getPaidlogs($data) {
         $sql = "SELECT * FROM " . $this->table_name. " INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id ";
         if ($data['keyword']) {
@@ -50 +50 @@
     }
 
-    function countSmstemplate($data) {
+    function countPaidlog($data) {
         $sql = "SELECT COUNT(".$this->id_name.") as total FROM " . $this->table_name;
         if ($data['keyword']) {
@@ -62 +62 @@
         return $result['total']; 
     }
-    function getSmstemplate($id)
+    function getPaidlog($id)
     {
         $sql="SELECT * FROM ".$this->table_name." WHERE ".$this->id_name."=".$id." LIMIT 1";
@@ -68 +68 @@
         return $result;
     }
+    function getAllPaidlogs($from)
+    {
+        // get all paidlogs from the last years until now
+        $from = date("Y-m-d 00:00:00",$from); 
+        $sql="SELECT * FROM ".$this->table_name." WHERE paid_time > '".$from."'";
+        $result = $this->db->query($sql)->result_array();
+        foreach ($result as $index=>$paidlog)
+        {
+            $result[$index]['time']=  strtotime($paidlog['paid_time']);
+        }
+        return $result;
+    }
 }