![(please configure the [header_logo] section in trac.ini)](/space/chrome/site/your_project_logo.png){kind=logo}
- Timestamp:
- Mar 24, 2015 2:15:02 PM (10 years ago)
- Location:
- pro-violet-viettel/sourcecode/application/modules/admin/controllers
- Files:
-
- 3 edited
-
report.php (modified) (1 diff)
-
reportpackage.php (modified) (3 diffs)
-
reportprovince.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/admin/controllers/report.php
r777 r818 137 137 } 138 138 } 139 139 140 public function export(){ 141 $this->load->model('paidlog_model'); 142 $data ['paid_types'] = array ( 143 0 => "Tất cả", 144 1 => "SMS", 145 2 => "Card", 146 ); 147 $data ['paid_type'] = 0; 148 if ($this->input->post ( 'paid_type' )) { 149 $data ['paid_type'] = ( int ) $this->input->post ( 'paid_type' ); 150 } 151 152 $data['daterange_start'] = ""; 153 $data['daterange_end'] = ""; 154 if ($this->input->post('daterange')){ 155 $daterange = explode(" - ", $this->input->post('daterange')); 156 $data['daterange_start'] = date('Y-m-d H:i:s', strtotime($daterange[0])); 157 $data['daterange_end'] = date('Y-m-d 23:59:59', strtotime($daterange[1])); 158 } 159 $data['total'] = $this->paidlog_model->countPaidlog($data); 160 $data['paidlogs'] = $this->paidlog_model->getPaidlogs($data)['paid_logs']; 161 $data['total_amount'] = $this->paidlog_model->getPaidlogs($data)['total_amount']; 162 163 foreach ($data['paidlogs'] as $index => $paidlog) { 164 $data['paidlogs'][$index]['username'] = $this->get_fullname($paidlog['us_id']); 165 } 166 167 168 $this->load->library("PHPExcel"); 169 $sheet = $this->phpexcel->getActiveSheet(); 170 171 $sheet->setTitle("bao cao tong hop "); 172 $sheet->getColumnDimension('A')->setWidth(20); 173 $sheet->getColumnDimension('B')->setWidth(25); 174 $sheet->getColumnDimension('C')->setWidth(15); 175 $sheet->getColumnDimension('D')->setWidth(15); 176 $sheet->getColumnDimension('E')->setWidth(25); 177 178 179 180 $sheet->setCellValue('B1', "TẬP ÄOÃN VIá»N THÃNG QUÃN Äá»I"); 181 $style = array( 182 'font' => array('bold' => true, 'size' => 12, 'name' =>'Cambria', 'color' => array('rgb' => '0070bf')), 183 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 184 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 185 'wrap' => true ) 186 ); 187 $sheet->mergeCells('B1:E1'); 188 $sheet->getStyle('B1')->applyFromArray($style); 189 190 $sheet->setCellValue('B2', "Tá»NG CÃNG TY VIá»N THÃNG VIETTEL"); 191 $style = array( 192 'font' => array('size' => 12, 'name' =>'Cambria', 'color' => array('rgb' => '0070bf')), 193 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 194 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 195 'wrap' => true ) 196 ); 197 $sheet->mergeCells('B2:E2'); 198 $sheet->getStyle('B2')->applyFromArray($style); 199 200 201 $sheet->setCellValue('A4', "BÃO CÃO DOANH THU Tá»NG HỢP"); 202 203 $style = array( 204 'font' => array('size' => 11, 'name' =>'Cambria'), 205 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_LEFT, 206 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 207 'wrap' => true ), 208 'borders' => array( 209 'allborders' => array( 210 'style' => \PHPExcel_Style_Border::BORDER_THIN 211 ) 212 ) 213 ); 214 $sheet->setCellValue('B6', "Từ ngà y: ". $data['daterange_start']); 215 $sheet->setCellValue('C6', "Äến ngà y: ". $data['daterange_end']); 216 $sheet->setCellValue('B7', "Ngà y kết xuất: ".date("d")."/".date("m")."/".date("Y")); 217 $sheet->setCellValue('C7', "Nhân viên kết xuất: "); 218 219 $sheet->getStyle('B6')->applyFromArray($style); 220 $sheet->getStyle('C6')->applyFromArray($style); 221 $sheet->getStyle('B7')->applyFromArray($style); 222 $sheet->getStyle('C7')->applyFromArray($style); 223 224 225 $style = array( 226 'font' => array('bold' => true, 'size' => 14, 'name' =>'Cambria'), 227 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 228 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 229 'wrap' => true ) 230 ); 231 $sheet->mergeCells('A4:E4'); 232 $sheet->getStyle('A4')->applyFromArray($style); 233 234 $sheet->setCellValue('A9', 'Sá» Äiá»n thoại'); 235 $style = array( 236 'font' => array('bold' => true, 'size' => 11, 'name' =>'Cambria'), 237 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 238 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 239 'wrap' => true), 240 'borders' => array( 241 'allborders' => array( 242 'style' => \PHPExcel_Style_Border::BORDER_THIN 243 ) 244 ) 245 ); 246 247 $sheet->setCellValue('B9', 'Há» tên'); 248 $sheet->setCellValue('C9', "Sá» tiá»n (VNÄ)"); 249 $sheet->setCellValue('D9', "SMS/Card"); 250 $sheet->setCellValue('E9', "Ngà y"); 251 252 $sheet->getStyle('A9:E9')->applyFromArray($style); 253 254 $sheet->setCellValue('A10', "Tá»ng"); 255 $sheet->mergeCells('A10:B10'); 256 $sheet->getStyle('A10:B10')->applyFromArray($style); 257 258 $style = array( 259 'font' => array('bold' => true, 'size' => 11, 'name' =>'Cambria'), 260 'alignment' => array('vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER), 261 'borders' => array( 262 'allborders' => array( 263 'style' => \PHPExcel_Style_Border::BORDER_THIN 264 ) 265 ) 266 ); 267 268 $sheet->setCellValue('C10', $data['total_amount']); 269 $sheet->getStyle('C10:E10')->applyFromArray($style); 270 271 $style = array( 272 'font' => array('size' => 11, 'name' =>'Cambria'), 273 'alignment' => array('vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER), 274 'borders' => array( 275 'allborders' => array( 276 'style' => \PHPExcel_Style_Border::BORDER_THIN 277 ) 278 ) 279 ); 280 281 $dem=0; 282 foreach ($data['paidlogs'] as $index => $paidlog) { 283 $type = ""; 284 // $sheet->setCellValue('A' . ($dem + 11), $paidlog['cellphone']); 285 if ($paidlog['paid_type'] == 1) { 286 $type = "SMS"; 287 }else { 288 $type = "Card"; 289 } 290 $sheet->setCellValueExplicit('A' . ($dem + 11), $paidlog['cellphone'], PHPExcel_Cell_DataType::TYPE_STRING); 291 292 $sheet->setCellValue('B' . ($dem + 11), $paidlog['username']); 293 $sheet->setCellValue('C' . ($dem + 11), $paidlog['amount']); 294 $sheet->setCellValue('D' . ($dem + 11), $type); 295 $sheet->setCellValue('E' . ($dem + 11), $paidlog['paid_time']); 296 $sheet->getStyle('A'. ($dem + 11).':E'.($dem + 11))->applyFromArray($style); 297 $dem++; 298 } 299 $writer = new PHPExcel_Writer_Excel5($this->phpexcel); 300 header('Content-Type: application/vnd.ms-excel'); 301 header('Content-Disposition: attachment; filename="bao_cao_tong_hop_'.date('d-m-Y').'.xls"'); 302 $writer->save('php://output'); 303 } 140 304 } -
pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportpackage.php
r761 r818 32 32 $data['month'] = date("m"); 33 33 $data['year'] = date("Y"); 34 $data['to_date']= 31;34 $data['to_date']= 31; 35 35 $data['to_month'] = date("m"); 36 36 $data['to_year'] = date("Y"); … … 44 44 $data['provinces'] = $result['provinces']; 45 45 $data['packages'] = $result['packages']; 46 46 $data['totalVip'] = $result['totalVip']; 47 47 if ($this->input->is_ajax_request()) { 48 48 return $this->load->view('reportpackage/province', $data); … … 70 70 public function export() { 71 71 $this->load->model('reportmodel'); 72 $data['date']=1; 72 73 $data['month'] = $this->uri->segment(4); 73 74 $data['year'] = $this->uri->segment(5); 75 $data['to_date']=31; 76 $data['to_month'] = date("m"); 77 $data['to_year'] = date("Y"); 74 78 $data = $this->getdays($data); 75 79 $result = $this->reportmodel->getPackages($data); 76 80 $data['provinces'] = $result['provinces']; 77 81 $data['packages'] = $result['packages']; 82 $data['totalVip'] = $result['totalVip']; 78 83 79 84 $this->load->library("PHPExcel"); -
pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportprovince.php
r771 r818 30 30 31 31 $this->load->model('reportmodel'); 32 $data['date'] = 1;32 $data['date'] = date("d"); 33 33 $data['month'] = date("m"); 34 34 $data['year'] = date("Y"); 35 $data['to_date'] = 31;35 $data['to_date'] = date("d"); 36 36 $data['to_month'] = date("m"); 37 37 $data['to_year'] = date("Y"); 38 if ($this->input->post('month')) { 38 if ($this->input->post()) { 39 $data['date'] = $this->input->post('date'); 39 40 $data['month'] = $this->input->post('month'); 40 41 $data['year'] = $this->input->post('year'); 41 } 42 $data['provinces'] = $this->reportmodel->getProvinces($data); 43 42 $data['to_date'] = $this->input->post('to_date'); 43 $data['to_month'] = $this->input->post('to_month'); 44 $data['to_year'] = $this->input->post('to_year'); 45 } 46 $result = $this->reportmodel->getProvinces($data); 47 $data['provinces'] = $result['provinces']; 48 $data['totalTbng'] = $result['totalTbng']; 49 $data['totalTbth'] = $result['totalTbth']; 50 $data['totalTbn'] = $result['totalTbn']; 51 52 $data['totalDtng'] = $result['totalDtng']; 53 $data['totalDtth'] = $result['totalDtth']; 54 $data['totalDtn'] = $result['totalDtn']; 55 44 56 if ($this->input->is_ajax_request()) { 45 57 return $this->load->view('reportprovince/province', $data); … … 115 127 echo "</pre>"; 116 128 } 129 130 public function exportProvince(){ 131 $this->load->model('reportmodel'); 132 $data['date'] = date("d"); 133 $data['month'] = $this->uri->segment(4); 134 $data['year'] = $this->uri->segment(5); 135 $data['to_date'] = date("d"); 136 $data['to_month'] = date("m"); 137 $data['to_year'] = date("Y"); 138 if ($this->input->post()) { 139 $data['date'] = $this->input->post('date'); 140 $data['month'] = $this->input->post('month'); 141 $data['year'] = $this->input->post('year'); 142 $data['to_date'] = $this->input->post('to_date'); 143 $data['to_month'] = $this->input->post('to_month'); 144 $data['to_year'] = $this->input->post('to_year'); 145 } 146 147 $result = $this->reportmodel->getProvinces($data); 148 $data['provinces'] = $result['provinces']; 149 150 $data['totalTbng'] = $result['totalTbng']; 151 $data['totalTbth'] = $result['totalTbth']; 152 $data['totalTbn'] = $result['totalTbn']; 153 154 $data['totalDtng'] = $result['totalDtng']; 155 $data['totalDtth'] = $result['totalDtth']; 156 $data['totalDtn'] = $result['totalDtn']; 157 158 $this->load->library("PHPExcel"); 159 $sheet = $this->phpexcel->getActiveSheet(); 160 161 $sheet->setTitle("bao cao thue bao " . $data['month'] . " - " . $data['year']); 162 $sheet->getColumnDimension('A')->setWidth(10); 163 $sheet->getColumnDimension('B')->setWidth(25); 164 $sheet->getColumnDimension('C')->setWidth(25); 165 $sheet->getColumnDimension('D')->setWidth(15); 166 $sheet->getColumnDimension('E')->setWidth(15); 167 $sheet->getColumnDimension('F')->setWidth(15); 168 $sheet->getColumnDimension('G')->setWidth(15); 169 $sheet->getColumnDimension('H')->setWidth(15); 170 $sheet->getColumnDimension('I')->setWidth(15); 171 $sheet->getColumnDimension('J')->setWidth(15); 172 173 174 $sheet->setCellValue('B1', "TẬP ÄOÃN VIá»N THÃNG QUÃN Äá»I"); 175 $style = array( 176 'font' => array('bold' => true, 'size' => 12, 'name' =>'Cambria', 'color' => array('rgb' => '0070bf')), 177 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 178 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 179 'wrap' => true ) 180 ); 181 $sheet->mergeCells('B1:I1'); 182 $sheet->getStyle('B1')->applyFromArray($style); 183 184 $sheet->setCellValue('B2', "Tá»NG CÃNG TY VIá»N THÃNG VIETTEL"); 185 $style = array( 186 'font' => array('size' => 12, 'name' =>'Cambria', 'color' => array('rgb' => '0070bf')), 187 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 188 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 189 'wrap' => true ) 190 ); 191 $sheet->mergeCells('B2:I2'); 192 $sheet->getStyle('B2')->applyFromArray($style); 193 194 195 $sheet->setCellValue('A4', "BÃO CÃO Tá»NG HỢP PHÃT TRIá»N THUà BAO Và DOANH THU Dá»CH VỀ SBG THEO Tá»NH"); 196 197 $style = array( 198 'font' => array('size' => 11, 'name' =>'Cambria'), 199 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_LEFT, 200 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 201 'wrap' => true ), 202 'borders' => array( 203 'allborders' => array( 204 'style' => \PHPExcel_Style_Border::BORDER_THIN 205 ) 206 ) 207 ); 208 209 $sheet->setCellValue('B6', "Từ ngà y: ".$data['date']."/".$data['month']."/".$data['year']); 210 $sheet->setCellValue('C6', "Äến ngà y: ".$data['to_date']."/".$data['to_month']."/".$data['to_year']); 211 $sheet->setCellValue('B7', "Ngà y kết xuất: ".date("d")."/".date("m")."/".date("Y")); 212 $sheet->setCellValue('C7', "Nhân viên kết xuất: "); 213 214 $sheet->getStyle('B6')->applyFromArray($style); 215 $sheet->getStyle('C6')->applyFromArray($style); 216 $sheet->getStyle('B7')->applyFromArray($style); 217 $sheet->getStyle('C7')->applyFromArray($style); 218 219 220 $style = array( 221 'font' => array('bold' => true, 'size' => 14, 'name' =>'Cambria'), 222 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 223 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 224 'wrap' => true ) 225 ); 226 $sheet->mergeCells('A4:I4'); 227 $sheet->getStyle('A4')->applyFromArray($style); 228 229 $sheet->setCellValue('A9', 'STT'); 230 $style = array( 231 'font' => array('bold' => true, 'size' => 11, 'name' =>'Cambria'), 232 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 233 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER, 234 'wrap' => true), 235 'borders' => array( 236 'allborders' => array( 237 'style' => \PHPExcel_Style_Border::BORDER_THIN 238 ) 239 ) 240 ); 241 $sheet->mergeCells('A9:A10'); 242 $sheet->getStyle('A9')->applyFromArray($style); 243 244 $sheet->setCellValue('B9', 'Mã Tá»nh/Thà nh Phá»'); 245 $sheet->mergeCells('B9:B10'); 246 $sheet->getStyle('B9:B10')->applyFromArray($style); 247 248 $sheet->setCellValue('C9', "Tá»nh/Thà nh phá»"); 249 $sheet->mergeCells('C9:C10'); 250 $sheet->getStyle('C9:C10')->applyFromArray($style); 251 252 $sheet->setCellValue('D9', "THUà BAO"); 253 $sheet->mergeCells('D9:F9'); 254 $sheet->getStyle('D9:F9')->applyFromArray($style); 255 256 $sheet->setCellValue('G9', "DOANH THU"); 257 $sheet->mergeCells('G9:I9'); 258 $sheet->getStyle('G9:I9')->applyFromArray($style); 259 260 $sheet->setCellValue('A11', "Tá»ng"); 261 $sheet->mergeCells('A11:C11'); 262 $sheet->getStyle('A11:C11')->applyFromArray($style); 263 264 $style = array( 265 'font' => array('bold' => true, 'size' => 11, 'name' =>'Cambria'), 266 'alignment' => array('vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER), 267 'borders' => array( 268 'allborders' => array( 269 'style' => \PHPExcel_Style_Border::BORDER_THIN 270 ) 271 ) 272 ); 273 274 $sheet->setCellValue('D11', $data['totalTbng']); 275 $sheet->setCellValue('E11', $data['totalTbth']); 276 $sheet->setCellValue('F11', $data['totalTbn']); 277 $sheet->setCellValue('G11', $data['totalDtng']); 278 $sheet->setCellValue('H11', $data['totalDtth']); 279 $sheet->setCellValue('I11', $data['totalDtn']); 280 281 $sheet->getStyle('D11')->applyFromArray($style); 282 $sheet->getStyle('E11')->applyFromArray($style); 283 $sheet->getStyle('F11')->applyFromArray($style); 284 $sheet->getStyle('G11')->applyFromArray($style); 285 $sheet->getStyle('H11')->applyFromArray($style); 286 $sheet->getStyle('I11')->applyFromArray($style); 287 288 $styleSTT = array( 289 'font' => array('size' => 11, 'name' =>'Cambria'), 290 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 291 'vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER), 292 'borders' => array( 293 'allborders' => array( 294 'style' => \PHPExcel_Style_Border::BORDER_THIN 295 ) 296 ) 297 ); 298 299 $style = array( 300 'font' => array('size' => 11, 'name' =>'Cambria'), 301 'alignment' => array('vertical' => \PHPExcel_Style_Alignment::VERTICAL_CENTER), 302 'borders' => array( 303 'allborders' => array( 304 'style' => \PHPExcel_Style_Border::BORDER_THIN 305 ) 306 ) 307 ); 308 309 $sheet->setCellValue('D10', "Thá»±c hiá»n Ngà y"); 310 $sheet->getStyle('D10')->applyFromArray($style); 311 $sheet->setCellValue('E10', "LÅ©y kế Tháng"); 312 $sheet->getStyle('E10')->applyFromArray($style); 313 $sheet->setCellValue('F10', "LÅ©y kế NÄm"); 314 $sheet->getStyle('F10')->applyFromArray($style); 315 $sheet->setCellValue('G10', "Thá»±c hiá»n Ngà y"); 316 $sheet->getStyle('G10')->applyFromArray($style); 317 $sheet->setCellValue('H10', "LÅ©y kế Tháng"); 318 $sheet->getStyle('H10')->applyFromArray($style); 319 $sheet->setCellValue('I10', "LÅ©y kế NÄm"); 320 $sheet->getStyle('I10')->applyFromArray($style); 321 322 /* 323 $sheet->setCellValue('A1', "Báo cáo thuê bao theo tá»nh"); 324 $sheet->setCellValue('A2', "Tháng: " . $data['month'] . " - " . $data['year']); 325 //$sheet->setCellValue('C2', "Ngà y: ".date('d')." - ".date('m')." - ". date('Y').""); 326 $sheet->setCellValue('A4', "STT"); 327 $sheet->setCellValue('B4', "Ngà y"); 328 $sheet->setCellValue('C4', "Mã Tá»nh/Thà nh Phá»"); 329 $sheet->setCellValue('D4', "Tá»nh/Thà nh phá»"); 330 $sheet->setCellValue('E4', "TB Ngà y"); 331 $sheet->setCellValue('F4', "LÅ©y kế TB tháng"); 332 $sheet->setCellValue('G4', "Tá»ng TB Ngà y"); 333 $sheet->setCellValue('H4', "DT Ngà y"); 334 $sheet->setCellValue('I4', "LÅ©y kế DT tháng"); 335 $sheet->setCellValue('J4', "Tá»ng DT nÄm"); 336 */ 337 $dem=0; 338 foreach ($data['provinces'] as $index => $provinces) { 339 $sheet->setCellValue('A' . ($dem + 12), $provinces['stt']); 340 $sheet->setCellValue('B' . ($dem + 12), $index); 341 $sheet->setCellValue('C' . ($dem + 12), $provinces['province']); 342 $sheet->setCellValue('D' . ($dem + 12), $provinces['tbng']); 343 $sheet->setCellValue('E' . ($dem + 12), $provinces['tbt']); 344 $sheet->setCellValue('F' . ($dem + 12), $provinces['tbn']); 345 $sheet->setCellValue('G' . ($dem + 12), $provinces['dtng']); 346 $sheet->setCellValue('H' . ($dem + 12), $provinces['dtt']); 347 $sheet->setCellValue('I' . ($dem + 12), $provinces['dtn']); 348 349 $sheet->getStyle('A'. ($dem + 12))->applyFromArray($styleSTT); 350 $sheet->getStyle('B'. ($dem + 12))->applyFromArray($style); 351 $sheet->getStyle('C'. ($dem + 12))->applyFromArray($style); 352 $sheet->getStyle('D'. ($dem + 12))->applyFromArray($style); 353 $sheet->getStyle('E'. ($dem + 12))->applyFromArray($style); 354 $sheet->getStyle('F'. ($dem + 12))->applyFromArray($style); 355 $sheet->getStyle('G'. ($dem + 12))->applyFromArray($style); 356 $sheet->getStyle('H'. ($dem + 12))->applyFromArray($style); 357 $sheet->getStyle('I'. ($dem + 12))->applyFromArray($style); 358 359 $dem++; 360 } 361 362 $writer = new PHPExcel_Writer_Excel5($this->phpexcel); 363 header('Content-Type: application/vnd.ms-excel'); 364 header('Content-Disposition: attachment; filename="thue_bao_va_doanh_thu_theo_tinh_' .$data["date"]. $data['month'] . $data['year']."_".$data["to_date"]. $data['to_month']. $data['to_year'] . '.xls"'); 365 $writer->save('php://output'); 366 } 117 367 }
Note: See TracChangeset
for help on using the changeset viewer.
