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

Timestamp:

Nov 20, 2014 4:49:30 PM (10 years ago)

Author:

quyenla

Message:

HOME

File:

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

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

@@ -57 +57 @@
         // 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."'";
+        $sql="SELECT * FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.us_id = ".$this->table_name.".us_id WHERE ".$this->table_name.".paid_time > '".$from."'";
         $result = $this->db->query($sql)->result_array();
         foreach ($result as $index=>$paidlog)