<?php

class Buildexcel {
    public static function execute($arrData, $title = 'report', $merge = false){
		$root = Config::load()->root();
		require_once($root.'/Additional/PHPExcel.php');
        require_once($root.'/Additional/PHPExcel/IOFactory.php');
			
        $filename = $title;

        $styleArray1 = array(
                                'borders' => array(
                                                    'allborders' => array(
                                                    'style' => PHPExcel_Style_Border::BORDER_THIN
                                                     )
                                        )
                            );

        $styleArray = array(
                                'font' => array(
                                          'bold' 	=> true, 
                                          'size' => '12pt', 
                                          /*'color' => array(
                                                            'rgb' => 'fffff')*/
                                ),
                            );

        $bgColor = array(
                                'type'=>PHPExcel_Style_Fill::FILL_SOLID,
                                'startcolor' => array('rgb' => '40E0D0'),
                              );	
                              
        $objPHPExcel = new PHPExcel();
        $objPHPExcel->getProperties()->setTitle("export")->setDescription("none");
        $objPHPExcel->setActiveSheetIndex(0);
        $excel = $objPHPExcel->getActiveSheet();
		
        $row = 1;
        $colStart = 'A';
        $rowstart = $row;
        $total_col = count($arrData[0]);
        $colHeader = 'A';
        for($i=1;$i<$total_col;$i++)$colHeader++;
        
        $excel->fromArray($arrData, null, $colStart . $rowstart);
       
        
        $excel->getStyle($colStart . $rowstart . ':' . $colHeader . $rowstart)->getFill()->applyFromArray($bgColor);
		
		if(!empty($merge) && is_array($merge)) {
			foreach($merge as $kMerge => $vMerge) {
				$objPHPExcel->setActiveSheetIndex(0)->mergeCells($vMerge);
				 $excel->getStyle($vMerge)->getFill()->applyFromArray($bgColor);
			}
		}
		
		foreach($arrData as $key => $val) {
			if($key != 0) {
				$c = "A";
				foreach($val as $kV => $vV) {
					if(is_numeric($vV)) {
						$firstNum = substr($vV, 0, 1);
						if($firstNum == 0) {
							$objPHPExcel->getActiveSheet()->setCellValueExplicit($c.($key+1), $vV, PHPExcel_Cell_DataType::TYPE_STRING);
						}
						if(strlen($vV) > 11) {
							$objPHPExcel->getActiveSheet()->setCellValueExplicit($c.($key+1), $vV, PHPExcel_Cell_DataType::TYPE_STRING);
						}
						$objPHPExcel->getActiveSheet()->getStyle($c.($key+1))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
					}
					$c++;
				}
				/*if(isset($val['mpubPhone'])) {
					$objPHPExcel->getActiveSheet()->setCellValueExplicit('D'.($key+1), $val['mpubPhone'], PHPExcel_Cell_DataType::TYPE_STRING);
				}
				if(isset($val['mpubBankAccountNum'])) {
					$objPHPExcel->getActiveSheet()->setCellValueExplicit('F'.($key+1), $val['mpubBankAccountNum'], PHPExcel_Cell_DataType::TYPE_STRING);	
				}*/	
			}
		}
		
		
		//$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:E1');
		
		 /*
		$excel->getStyle($colStart . $rowstart . ':' . $colHeader . $rowstart)
              ->applyFromArray(array_merge_recursive($styleArray, $styleArray1));
        
        $excel->getStyle($colStart . $row . ':' . $colHeader . $row)
              ->applyFromArray(array_merge_recursive($styleArray1));*/
        
        $objPHPExcel->setActiveSheetIndex(0);
        
        $colHeader = 'A';
        for($i=0;$i<$total_col;$i++){
            $excel->getColumnDimension($colHeader)->setWidth(20);
            $colHeader++;
        }

        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

                header('Content-Type: application/vnd.ms-excel');
                header('Content-Disposition: attachment;filename="' . $filename . '.xlsx"');
                header('Cache-Control: max-age=0');

        $objWriter->save('php://output');
    }
}