Ignore:
Timestamp:
Feb 10, 2015 10:47:29 AM (10 years ago)
Author:
quyenla
Message:

report update

File:
1 edited

Legend:

Unmodified
Added
Removed
  • pro-violet-viettel/sourcecode/application/modules/admin/controllers/reportpackage.php

    r751 r755  
    9090        $chars = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L");
    9191        $dem = 1;
     92        $stt=1;
    9293        foreach ($data['packages'] as $package) {
    9394            $dem++;
    94             $sheet->setCellValue($chars[$dem] . ($index + 4), $package['p_name']);
     95            $sheet->setCellValue($chars[$dem] . ($stt + 4), $package['p_name']);
    9596            $dem++;
    96             $sheet->setCellValue($chars[$dem] . ($index + 4), "Tỉ lệ %");
     97            $sheet->setCellValue($chars[$dem] . ($stt + 4), "Tỉ lệ %");
     98       
     99            $stt++;
    97100        }
    98101        $dem++;
    99102        $sheet->setCellValue($chars[$dem] . ($index + 4), "Tổng TB");
    100103
    101 
     104$stt=1;
    102105        foreach ($data['provinces'] as $index => $provinces) {
    103106
    104             $sheet->setCellValue('A' . ($index + 5), $provinces['stt']);
    105             $sheet->setCellValue('B' . ($index + 5), $provinces['province']);
     107            $sheet->setCellValue('A' . ($stt + 5), $provinces['stt']);
     108            $sheet->setCellValue('B' . ($stt + 5), $provinces['province']);
    106109            $dem = 1;
    107110            foreach ($provinces['packages'] as $package) {
    108111                $dem++;
    109                 $sheet->setCellValue($chars[$dem] . ($index + 5), $package['total']);
     112                $sheet->setCellValue($chars[$dem] . ($stt + 5), $package['total']);
    110113                $dem++;
    111                 $sheet->setCellValue($chars[$dem] . ($index + 5), $package['percent']);
     114                $sheet->setCellValue($chars[$dem] . ($stt + 5), $package['percent']);
    112115            }
    113116            $dem++;
    114             $sheet->setCellValue($chars[$dem] . ($index + 5), $provinces['total']);
     117           
     118            $sheet->setCellValue($chars[$dem] . ($stt + 5), $provinces['total']);
     119            $stt++;
    115120        }
    116121        $writer = new PHPExcel_Writer_Excel5($this->phpexcel);
Note: See TracChangeset for help on using the changeset viewer.