- Timestamp:
- Feb 11, 2015 4:08:09 PM (10 years ago)
- Location:
- pro-violet-viettel/sourcecode/application/modules/admin/controllers
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportpackage.php
r756 r761 29 29 30 30 $this->load->model('reportmodel'); 31 $data['date']=1; 31 32 $data['month'] = date("m"); 32 33 $data['year'] = date("Y"); 34 $data['to_date']=31; 35 $data['to_month'] = date("m"); 36 $data['to_year'] = date("Y"); 33 37 if ($this->input->post('month')) { 34 38 $data['month'] = $this->input->post('month'); -
pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportprovince.php
r757 r761 30 30 31 31 $this->load->model('reportmodel'); 32 $data['date'] = 1; 32 33 $data['month'] = date("m"); 33 34 $data['year'] = date("Y"); 35 $data['to_date'] = 31; 36 $data['to_month'] = date("m"); 37 $data['to_year'] = date("Y"); 34 38 if ($this->input->post('month')) { 35 39 $data['month'] = $this->input->post('month'); … … 64 68 $sheet->getColumnDimension('G')->setWidth(15); 65 69 $sheet->getColumnDimension('H')->setWidth(15); 66 $sheet->getColumnDimension('I')->setWidth(20); 70 $sheet->getColumnDimension('I')->setWidth(15); 71 $sheet->getColumnDimension('J')->setWidth(15); 67 72 $sheet->setCellValue('A1', "Báo cáo thuê bao theo tá»nh"); 68 73 $sheet->setCellValue('A2', "Tháng: " . $data['month'] . " - " . $data['year']); 69 $sheet->setCellValue('C2', "Ngà y: ".date('d')." - ".date('m')." - ". date('Y')."");74 //$sheet->setCellValue('C2', "Ngà y: ".date('d')." - ".date('m')." - ". date('Y').""); 70 75 $sheet->setCellValue('A4', "STT"); 71 $sheet->setCellValue('B4', "Mã Tá»nh/Thà nh Phá»"); 72 $sheet->setCellValue('C4', "Tá»nh/Thà nh phá»"); 73 $sheet->setCellValue('D4', "TB Ngà y"); 74 $sheet->setCellValue('E4', "LÅ©y kế TB tháng"); 75 $sheet->setCellValue('F4', "Tá»ng TB Ngà y"); 76 $sheet->setCellValue('G4', "DT Ngà y"); 77 $sheet->setCellValue('H4', "LÅ©y kế DT tháng"); 78 $sheet->setCellValue('I4', "Tá»ng DT nÄm"); 76 $sheet->setCellValue('B4', "Ngà y"); 77 $sheet->setCellValue('C4', "Mã Tá»nh/Thà nh Phá»"); 78 $sheet->setCellValue('D4', "Tá»nh/Thà nh phá»"); 79 $sheet->setCellValue('E4', "TB Ngà y"); 80 $sheet->setCellValue('F4', "LÅ©y kế TB tháng"); 81 $sheet->setCellValue('G4', "Tá»ng TB Ngà y"); 82 $sheet->setCellValue('H4', "DT Ngà y"); 83 $sheet->setCellValue('I4', "LÅ©y kế DT tháng"); 84 $sheet->setCellValue('J4', "Tá»ng DT nÄm"); 79 85 $dem=0; 80 86 foreach ($data['provinces'] as $index => $provinces) { 81 87 $sheet->setCellValue('A' . ($dem + 5), $provinces['stt']); 82 $sheet->setCellValue('B' . ($dem + 5), $index); 83 $sheet->setCellValue('C' . ($dem + 5), $provinces['province']); 84 $sheet->setCellValue('D' . ($dem + 5), $provinces['tbng']); 85 $sheet->setCellValue('E' . ($dem + 5), $provinces['tbt']); 86 $sheet->setCellValue('F' . ($dem + 5), $provinces['tbn']); 87 $sheet->setCellValue('G' . ($dem + 5), $provinces['dtng']); 88 $sheet->setCellValue('H' . ($dem + 5), $provinces['dtt']); 89 $sheet->setCellValue('I' . ($dem + 5), $provinces['dtn']); 88 $sheet->setCellValue('B' . ($dem + 5), date('d')." - ".date('m')." - ". date('Y')); 89 $sheet->setCellValue('C' . ($dem + 5), $index); 90 $sheet->setCellValue('D' . ($dem + 5), $provinces['province']); 91 $sheet->setCellValue('E' . ($dem + 5), $provinces['tbng']); 92 $sheet->setCellValue('F' . ($dem + 5), $provinces['tbt']); 93 $sheet->setCellValue('G' . ($dem + 5), $provinces['tbn']); 94 $sheet->setCellValue('H' . ($dem + 5), $provinces['dtng']); 95 $sheet->setCellValue('I' . ($dem + 5), $provinces['dtt']); 96 $sheet->setCellValue('J' . ($dem + 5), $provinces['dtn']); 90 97 $dem++; 91 98 } … … 95 102 $writer->save('php://output'); 96 103 } 104 97 105 }
Note: See TracChangeset
for help on using the changeset viewer.