Changeset 754

Timestamp:

Feb 10, 2015 10:46:51 AM (10 years ago)

Author:

quyenla

Message:

report update

File:

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

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

@@ -75 +75 @@
         $sheet->setCellValue('G4', "Lũy kế DT tháng");
         $sheet->setCellValue('H4', "Tổng DT năm");
-
+        $dem=0;
         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']);
+            $sheet->setCellValue('A' . ($dem + 5), $provinces['stt']);
+            $sheet->setCellValue('B' . ($dem + 5), $provinces['province']);
+            $sheet->setCellValue('C' . ($dem + 5), $provinces['tbng']);
+            $sheet->setCellValue('D' . ($dem + 5), $provinces['tbt']);
+            $sheet->setCellValue('E' . ($dem + 5), $provinces['tbn']);
+            $sheet->setCellValue('F' . ($dem + 5), $provinces['dtng']);
+            $sheet->setCellValue('G' . ($dem + 5), $provinces['dtt']);
+            $sheet->setCellValue('H' . ($dem + 5), $provinces['dtn']);
+            $dem++;
         }
         $writer = new PHPExcel_Writer_Excel5($this->phpexcel);
@@ -91 +92 @@
         $writer->save('php://output');
     }
+  
 
 }