<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Reportprovince extends MX_Controller {

    const TOKENPW = 'violet';

    public function __construct() {
        parent::__construct();
        $this->load->helper('cookie');
        $this->load->helper('language');
        $this->lang->load('messages', 'message');
        $this->load->model('reportmodel');
    }

    public function index() {
        $data = array();
        $admin_info = $this->session->userdata('adminInfo');
        if ($admin_info) {
            $data['content'] = $this->getProvince();
            $this->load->view('reportprovince/index', $data);
        } else {
            $this->load->view('login');
        }
    }

    public function getProvince($filters = array()) {

        $this->load->model('reportmodel');
        $data['date'] = 1;
        $data['month'] = date("m");
        $data['year'] = date("Y");
        $data['to_date'] = 31; 
        $data['to_month'] = date("m");
        $data['to_year'] = date("Y");
        if ($this->input->post('month')) {
            $data['month'] = $this->input->post('month');
            $data['year'] = $this->input->post('year');
        }
        $data['provinces'] = $this->reportmodel->getProvinces($data);

        if ($this->input->is_ajax_request()) {
            return $this->load->view('reportprovince/province', $data);
        }
        return $this->load->view('reportprovince/province', $data, true);
    }

 

    public function export() {
        $this->load->model('reportmodel');
        $data['month'] = $this->uri->segment(4);
        $data['year'] = $this->uri->segment(5);
       
        $data['provinces'] = $this->reportmodel->getProvinces($data);

        $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(25);
        $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->getColumnDimension('I')->setWidth(15);
        $sheet->getColumnDimension('J')->setWidth(15);
        $sheet->setCellValue('A1', "Báo cáo thuê bao theo tỉnh");
        $sheet->setCellValue('A2', "Tháng: " . $data['month'] . " - " . $data['year']);
        //$sheet->setCellValue('C2', "Ngày: ".date('d')." - ".date('m')." - ". date('Y').""); 
        $sheet->setCellValue('A4', "STT");
        $sheet->setCellValue('B4', "Ngày");
        $sheet->setCellValue('C4', "Mã Tỉnh/Thành Phố");
        $sheet->setCellValue('D4', "Tỉnh/Thành phố");
        $sheet->setCellValue('E4', "TB Ngày");
        $sheet->setCellValue('F4', "Lũy kế TB tháng");
        $sheet->setCellValue('G4', "Tổng TB Ngày");
        $sheet->setCellValue('H4', "DT Ngày");
        $sheet->setCellValue('I4', "Lũy kế DT tháng");
        $sheet->setCellValue('J4', "Tổng DT năm");
        $dem=0;
        foreach ($data['provinces'] as $index => $provinces) {
            $sheet->setCellValue('A' . ($dem + 5), $provinces['stt']);
            $sheet->setCellValue('B' . ($dem + 5), date('d')." - ".date('m')." - ". date('Y'));
            $sheet->setCellValue('C' . ($dem + 5), $index);
            $sheet->setCellValue('D' . ($dem + 5), $provinces['province']);
            $sheet->setCellValue('E' . ($dem + 5), $provinces['tbng']);
            $sheet->setCellValue('F' . ($dem + 5), $provinces['tbt']);
            $sheet->setCellValue('G' . ($dem + 5), $provinces['tbn']);
            $sheet->setCellValue('H' . ($dem + 5), $provinces['dtng']);
            $sheet->setCellValue('I' . ($dem + 5), $provinces['dtt']);
            $sheet->setCellValue('J' . ($dem + 5), $provinces['dtn']);
            $dem++;
        }
        $writer = new PHPExcel_Writer_Excel5($this->phpexcel);
		header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment; filename="thue_bao_' . $data['month'] . "_" . $data['year'] . '.xls"');
        $writer->save('php://output');
    }
    
}