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

Timestamp:

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

Author:

quyenla

Message:

paidlogs

File:

• pro-violet-viettel/sourcecode/application/modules/admin/controllers/report.php (modified) (8 diffs)

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

@@ -15 +15 @@
         $admin_info = $this->session->userdata('adminInfo');
         if ($admin_info) {
-            $data['statistics'] = $this->getStatistics();
-            $data['content'] = $this->getSmstemplates();
+            $data['statistics'] = $this->getStatistics();           
+            $data['content'] = $this->getPaidlogs();
             $this->load->view('report/index', $data);
         } else {
@@ -25 +25 @@
     {
         $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_week['end']=strtotime('last sunday')+(24*60*60-1);
+        $last_week['start']=($last_week['end']-7*24*60*60+1);
+        
+        $last_year['start']=  strtotime((date("Y")-1)."-01-01 00:00:00");
+        $last_year['end']=  strtotime((date("Y")-1)."-12-31 23:59:59");
+        
+        
+        
+        $last_quarter=$this->getLastquarter();
+        $last_quarter['start']=  $last_quarter['start'];
+        $last_quarter['end']=  $last_quarter['end'];
+        
+        
+        $this->load->model('paidlog_model');
+        $paidlogs = $this->paidlog_model->getAllPaidlogs($last_year['start']);
+        
+        $revenue['last_week']=0;
+        $revenue['last_month']=0;
+        $revenue['last_quarter']=0;
+        $revenue['last_year']=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'];
+            }
+        }
+        $data['revenue']=$revenue;
         return $this->load->view('report/statistics', $data, true);
     }
-    public function getSmstemplates($filters = array()) {
+    public function getLastquarter()
+    {
+        $current_month = date('m');
+          $current_year = date('Y');
+
+          if($current_month>=1 && $current_month<=3)
+          {
+            $start_date = strtotime('1-October-'.($current_year-1));  // timestamp or 1-October Last Year 12:00:00 AM
+            $end_date = strtotime('1-Janauary-'.$current_year);  // // timestamp or 1-January  12:00:00 AM means end of 31 December Last year
+          } 
+          else if($current_month>=4 && $current_month<=6)
+          {
+            $start_date = strtotime('1-January-'.$current_year);  // timestamp or 1-Janauray 12:00:00 AM
+            $end_date = strtotime('1-April-'.$current_year);  // timestamp or 1-April 12:00:00 AM means end of 31 March
+          }
+          else  if($current_month>=7 && $current_month<=9)
+          {
+            $start_date = strtotime('1-April-'.$current_year);  // timestamp or 1-April 12:00:00 AM
+            $end_date = strtotime('1-July-'.$current_year);  // timestamp or 1-July 12:00:00 AM means end of 30 June
+          }
+          else  if($current_month>=10 && $current_month<=12)
+          {
+            $start_date = strtotime('1-July-'.$current_year);  // timestamp or 1-July 12:00:00 AM
+            $end_date = strtotime('1-October-'.$current_year);  // timestamp or 1-October 12:00:00 AM means end of 30 September
+          }
+          return array("start"=>$start_date,"end"=>$end_date);
+    }
+    public function getPaidlogs($filters = array()) {
         $this->load->helper('pagging');
         $this->load->model('paidlog_model');
@@ -58 +133 @@
         }
         
-        $data['start'] = ($data['current_page'] - 1) * $data['perpage'];
-        $data['total'] = $this->paidlog_model->countSmstemplate($data);  
-       
-        $data['paidlogs'] = $this->paidlog_model->getSmstemplates($data);
-
-        $data['paging_url'] = base_url() . "/admin/mau_tin_nhan/trang/";
+        $data['start'] = ($data['current_page'] - 1) * $data['perpage'];    
+        $data['total'] = $this->paidlog_model->countPaidlog($data);  
+        $data['paidlogs'] = $this->paidlog_model->getPaidlogs($data);
+
+        $data['paging_url'] = base_url() . "/admin/doanh_thu_tong_hop/trang/";
         $data['num_links'] = 2;
         $data['paging'] = pagging($data);
@@ -73 +147 @@
     }
 
-    public function addSmstemplate() {
+    public function addPaidlog() {
         $result['success'] = 0;
         $result = array();
@@ -124 +198 @@
         $id=$this->uri->segment(4);
         $this->load->model('paidlog_model');
-        $data=$this->paidlog_model->getSmstemplate($id);
+        $data=$this->paidlog_model->getPaidlog($id);
         $this->load->view('report/viewSms',$data);
     }
@@ -131 +205 @@
         $id=$this->uri->segment(4);
         $this->load->model('paidlog_model');
-        $data=$this->paidlog_model->getSmstemplate($id);
+        $data=$this->paidlog_model->getPaidlog($id);
         $this->load->view('report/editSms',$data);
     }
@@ -147 +221 @@
         $id=$this->uri->segment(4);
         $this->load->model('paidlog_model');
-        $data=$this->paidlog_model->getSmstemplate($id);
+        $data=$this->paidlog_model->getPaidlog($id);
         $this->load->view('report/deleteSms',$data);
     }
@@ -198 +272 @@
     public function test() {
         
-      /*
-        for ($i = 1; $i <= 1500; $i++) {
+      
+        for ($i = 1; $i <= 5000; $i++) {
             $input['us_id']=rand(1,100);
             $input['paid_type']=rand(1,2);
             $input['amount']=rand(3,10)*1000;
-            $time=(rand((time()-(5*30*24*60*60)),time()));
+            $time=(rand((time()-(12*30*24*60*60)),time()));
             $input['paid_time']= date("Y-m-d H:i:s",$time);
             $this->load->model('paidlog_model');
             $this->paidlog_model->insert($input);
         }
-       * 
-       */
+        
+       die(); 
+      
         for ($i = 1; $i <= 100; $i++) {
             $input['us_id']=$i;