Changeset 713 for pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportprovince.php

Timestamp:

Jan 29, 2015 10:36:57 AM (10 years ago)

Author:

quyenla

Message:

Export Excel

File:

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

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

@@ -24 +24 @@
             $this->load->view('login');
         }
-    
     }
 
+    public function getProvince($filters = array()) {
 
-
-    public function getProvince($filters = array()) {
-        
         $this->load->model('reportmodel');
-        $data['month']=date("m");
-        $data['year']=date("Y");
+        $data['month'] = date("m");
+        $data['year'] = date("Y");
         if ($this->input->post('month')) {
-          $data['month']=$this->input->post('month');
-          $data['year']=$this->input->post('year');
+            $data['month'] = $this->input->post('month');
+            $data['year'] = $this->input->post('year');
         }
-        $data['month_days']=1;
-        if("".$data['year']."-".$data['month'].""==date("Y-m"))
-        {
-        $data['month_days']=date("d");
-        }
-        else
-        {
-        $data['month_days']=cal_days_in_month(CAL_GREGORIAN, $data['month'], $data['year']); // 31  
-        }
-        $data['year_days']=1;
-        if($data['year']== date("Y"))
-        {
-        $data['year_days']=date('z') + 1;
-        }
-        else
-        {
-        $data['year_days']=date("z", mktime(0,0,0,12,31,$data['year'])) + 1;
-        }
-        
-     
+        $data = $this->getdays($data);
         $data['provinces'] = $this->reportmodel->getProvinces($data);
-
-        foreach ($data['provinces'] as $index => $paidlog) {
-            $data['provinces'][$index]['username'] = @$this->get_fullname($paidlog['us_id']); 
-        }
 
         if ($this->input->is_ajax_request()) {
@@ -70 +44 @@
     }
 
-    private function get_fullname($us_id) {
-        $fullname="";
-        $src = 'violet';
-        $token = md5($us_id . self::TOKENPW);
-        $this->load->model('user_model');
-        $data = $this->user_model->get_user_info($src, $us_id, $token);
-        parse_str($data,$data);
-        if (isset($data['fullname']))
-        {
-            $fullname=$data['fullname'];
+    public function getdays($data) {
+        $data['month_days'] = 1;
+        if ("" . $data['year'] . "-" . $data['month'] . "" == date("Y-m")) {
+            $data['month_days'] = date("d");
+        } else {
+            $data['month_days'] = cal_days_in_month(CAL_GREGORIAN, $data['month'], $data['year']); // 31  
         }
-        return $fullname;
+        $data['year_days'] = 1;
+        if ($data['year'] == date("Y")) {
+            $data['year_days'] = date('z') + 1;
+        } else {
+            $data['year_days'] = date("z", mktime(0, 0, 0, 12, 31, $data['year'])) + 1;
+        }
+        return $data;
     }
 
-    public function test() {
+    public function export() {
+        $this->load->model('reportmodel');
+        $data['month'] = $this->uri->segment(4);
+        $data['year'] = $this->uri->segment(5);
+        $data = $this->getdays($data);
+        $data['provinces'] = $this->reportmodel->getProvinces($data);
 
-            $provinces=lang('_PROVINCES_');
-            $sql="SELECT * FROM tbluser";
-            $query = $this->db->query ($sql);
-                $result = $query->result_array();
-            foreach ($result as $user)
-            {
-                $p=$provinces[rand(0,62)];
-                $user['province']=$p;
-                $this->db->where('us_id', $user['us_id']);
-                $this->db->update('tbluser', $user);
-            }
+        $this->load->library("PHPExcel");
+        $sheet = $this->phpexcel->getActiveSheet();
+        $sheet->setTitle("bao cao thue bao " . $data['month'] . " - " . $data['year']);
+        $sheet->getColumnDimension('A')->setWidth(10);
+        $sheet->getColumnDimension('B')->setWidth(25);
+        $sheet->getColumnDimension('C')->setWidth(15);
+        $sheet->getColumnDimension('D')->setWidth(15);
+        $sheet->getColumnDimension('E')->setWidth(15);
+        $sheet->getColumnDimension('F')->setWidth(15);
+        $sheet->getColumnDimension('G')->setWidth(15);
+        $sheet->getColumnDimension('H')->setWidth(15);
+        $sheet->setCellValue('A1', "Báo cáo thuê bao theo tỉnh");
+        $sheet->setCellValue('A2', "Thời gian: " . $data['month'] . " - " . $data['year']);
+        $sheet->setCellValue('A4', "STT");
+        $sheet->setCellValue('B4', "Tỉnh/Thà nh phố");
+        $sheet->setCellValue('C4', "TB Ngà y");
+        $sheet->setCellValue('D4', "Lũy kế TB tháng");
+        $sheet->setCellValue('E4', "Tổng TB Ngà y");
+        $sheet->setCellValue('F4', "DT Ngà y");
+        $sheet->setCellValue('G4', "Lũy kế DT tháng");
+        $sheet->setCellValue('H4', "Tổng DT năm");
+
+        foreach ($data['provinces'] as $index => $provinces) {
+            $sheet->setCellValue('A' . ($index + 5), $provinces['stt']);
+            $sheet->setCellValue('B' . ($index + 5), $provinces['province']);
+            $sheet->setCellValue('C' . ($index + 5), $provinces['tbng']);
+            $sheet->setCellValue('D' . ($index + 5), $provinces['tbt']);
+            $sheet->setCellValue('E' . ($index + 5), $provinces['tbn']);
+            $sheet->setCellValue('F' . ($index + 5), $provinces['dtng']);
+            $sheet->setCellValue('G' . ($index + 5), $provinces['dtt']);
+            $sheet->setCellValue('H' . ($index + 5), $provinces['dtn']);
+        }
+        $writer = new PHPExcel_Writer_Excel5($this->phpexcel);
+        header('Content-Disposition: attachment; filename="thue_bao_' . $data['month'] . "_" . $data['year'] . '.xls"');
+        $writer->save('php://output');
     }