Kuma 熊本部

記錄：

CRM軟件| 客戶關係管理- Vtiger CRM

修正檔案位置： modules/Vtiger/actions/ExportData.php

修正函數名稱： output()

修正後函數內容：

    function output($request, $headers, $entries) {
        $moduleName = $request->get('source_module');
        $fileName = str_replace(' ','_',decode_html(vtranslate($moduleName, $moduleName)));
        $exportType = $this->getExportContentType($request);

        require_once("libraries/PHPExcel/PHPExcel.php");
        require_once("libraries/PHPExcel/PHPExcel/IOFactory.php");
        $fileName .= ".xls";
        $objPHPExcel = new PHPExcel();
        $objPHPExcel->setActiveSheetIndex(0);
        $objPHPExcel->getActiveSheet()->fromArray( $headers, null, 'A1' );
        $objPHPExcel->getActiveSheet()->fromArray( $entries, null, 'A2' );

        $fileName = iconv("utf-8", "big5", $fileName); 
        $objPHPExcel->setActiveSheetIndex(0);
        header('Content-Type: application/vnd.ms-excel');
        header("Content-Disposition: attachment;filename=$fileName");
        header('Cache-Control: max-age=0');
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output');
    }