Changeset 741

Timestamp:

Feb 3, 2015 6:14:25 PM (10 years ago)

Author:

quyenla

Message:

fixing charts

Location:

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

Files:

• controllers/reportAsistant.php (modified) (1 diff)
• models/collabolator_model.php (modified) (8 diffs)
• models/paidlog_model.php (modified) (1 diff)

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

@@ -73 +73 @@
         }
 
-        $data['max'] = 50000;
+        $data['max'] = $max;
         $chard[] = array("color" => "#e67e22", "label" => "Lượng người dùng giới thiệu bởi cộng tác viên theo từng tháng", "data" => $chart);
         $data['chard'] = $chard;
-
+         
         return $this->load->view('reportAsistant/statistics', $data, true);
     }

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

@@ -56 +56 @@
         }
         //$sql="SELECT *,tblcollaborator.created_time as collaborator_created_time, tbluser.created_time as user_created_time  FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.collaborator = tblcollaborator.id WHERE tbluser.created_time > '".$from."'".$where."";
-
                 $sql="SELECT *,tblcollaborator.created_time as collaborator_created_time, tbluser.created_time as user_created_time  FROM ".$this->table_name." INNER JOIN tbluser ON tbluser.collaborator = tblcollaborator.cellphone WHERE tbluser.created_time > '".$from."'".$where."";
 
@@ -64 +63 @@
             $result[$index]['time']=  strtotime($paidlog['user_created_time']);
         }
+        
         return $result;
     }
@@ -238 +238 @@
     function getStatistics()
     {
+      
+       $day = date('w');
         $data = array();
-        $last_month['start'] = strtotime(date("Y-m-d", strtotime("first day of previous month")) . " 00:00:00");
-        $last_month['end'] = strtotime(date("Y-m-d", strtotime("last day of previous month")) . " 23:59:59");
-
-        $last_week['start'] = strtotime(date("Y-m-d", strtotime("first day of previous week")) . " 00:00:00");
-        $last_week['end'] = strtotime(date("Y-m-d", strtotime("last day of previous week")) . " 23:59:59");
+        $last_month['start'] = strtotime(date("Y-m-d", strtotime(date("Y-m-d", mktime(0, 0, 0, date("m")-1, 1, date("Y"))))) . " 00:00:00");
+        $last_month['end'] = strtotime(date("Y-m-d", strtotime(date("Y-m-d", mktime(0, 0, 0, date("m"), 0, date("Y"))))) . " 23:59:59");
+
+        $last_week['start'] = strtotime(date("Y-m-d", strtotime(date('m-d-Y', strtotime('-'.$day.' days')))) . " 00:00:00");
+        $last_week['end'] = strtotime(date("Y-m-d", strtotime(date('m-d-Y', strtotime('+'.(6-$day).' days')))) . " 23:59:59");
 
         $last_week['end'] = strtotime('last sunday') + (24 * 60 * 60 - 1);
@@ -266 +268 @@
         $revenue['last_year'] = 0;
 
-        $lastmonth = strtotime("first day of previous month");
-        $thismonth = strtotime("first day of this month");
+        $lastmonth = strtotime(date("Y-m-d", mktime(0, 0, 0, date("m")-1, 1, date("Y"))));
+        $thismonth = strtotime(date('Y-m-01'));
         $charts['last_month'] = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0);
         $charts['this_month'] = array(0 => 0, 1 => 0, 2 => 0, 3 => 0, 4 => 0);
@@ -279 +281 @@
         $top['this_month']['card']=0;
         $top['this_month']['collaborator']=0;
+        
         foreach ($paidlogs as $paidlog) {
 
             
             if (($paidlog['time'] < $last_week['end']) && ($paidlog['time'] > $last_week['start'])) {
+                
                 $revenue['last_week']+=$paidlog['amount'];
             }
             if (($paidlog['time'] < $last_month['end']) && ($paidlog['time'] > $last_month['start'])) {
+           
                 $revenue['last_month']+=$paidlog['amount'];
             }
             if (($paidlog['time'] < $last_quarter['end']) && ($paidlog['time'] > $last_quarter['start'])) {
+             
                 $revenue['last_quarter']+=$paidlog['amount'];
             }
             if (($paidlog['time'] < $last_year['end']) && ($paidlog['time'] > $last_year['start'])) {
+              
                 $revenue['last_year']+=$paidlog['amount'];
             }
@@ -331 +338 @@
 
             if (($paidlog['time'] < $thismonth + (7 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth)) {
-                $charts['this_month'][0]+=$paidlog['amount'];
+              
+                $charts['this_month'][0] += $paidlog['amount'];
             }
             if (($paidlog['time'] < $thismonth + (14 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (7 * 24 * 60 * 60))) {
+                
                 $charts['this_month'][1]+=$paidlog['amount'];
             }
             if (($paidlog['time'] < $thismonth + (21 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (14 * 24 * 60 * 60))) {
+               
                 $charts['this_month'][2]+=$paidlog['amount'];
             }
             if (($paidlog['time'] < $thismonth + (28 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (21 * 24 * 60 * 60))) {
+                
                 $charts['this_month'][3]+=$paidlog['amount'];
             }
             if (($paidlog['time'] < $thismonth + (31 * 24 * 60 * 60)) && ($paidlog['time'] > $thismonth + (28 * 24 * 60 * 60))) {
+               
                 $charts['this_month'][4]+=$paidlog['amount'];
             }
@@ -361 +373 @@
             }
         }
+     
         $percent=array();
         foreach ($top['this_month'] as $index=>$value)
@@ -394 +407 @@
 
         $data['revenue'] = $revenue;
-        $data['max'] = 50000;
+        $data['max'] = $max;
         $chard[] = array("color" => "#e67e22", "label" => "Tháng hiện tại", "data" => $chart_this_month);
         $chard[] = array("color" => "#1abc9c", "label" => "Tháng trước", "data" => $chart_last_month);
-
+         
         $data['chard'] = $chard;
+        
         return $data;
     }

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

@@ -76 +76 @@
             $result[$index]['time']=  strtotime($paidlog['paid_time']);
         }
-        $file = fopen("/srv/www/sbg/log/dump.log","w");
-        fwrite($file,  serialize($result));
-        fclose($file); 
+         
         return $result;
     }