function index() { $this->load->database(); $this->db->select('user_info.user_id,user_info.user_name,user_info.user_sex,hr_info.hr_center,hr_info.hr_department,user_info.user_college,user_info.user_major,user_info.user_phone,user_info.user_qq,user_info.user_remarks'); $this->db->from('hr_user'); $this->db->join('hr_info', 'hr_info.hr_id = hr_user.hr_id'); $this->db->join('user_info', 'user_info.user_id = hr_user.user_id'); $query = $this->db->get(); //$query = mb_convert_encoding("gb2312", "UTF-8", $query); if (!$query) { return false; } // Starting the PHPExcel library $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle('报名表单'); $objPHPExcel->getActiveSheet()->setCellValue('A1', '报名编号'); $objPHPExcel->getActiveSheet()->setCellValue('B1', '姓名'); //$objPHPExcel->getActiveSheet()->setCellValue('A1', 'String'); $objPHPExcel->getActiveSheet()->setCellValue('C1', '性别'); $objPHPExcel->getActiveSheet()->setCellValue('D1', '中心'); $objPHPExcel->getActiveSheet()->setCellValue('E1', '部门'); $objPHPExcel->getActiveSheet()->setCellValue('F1', '学院'); $objPHPExcel->getActiveSheet()->setCellValue('G1', '专业'); $objPHPExcel->getActiveSheet()->setCellValue('H1', '电话'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'QQ'); $objPHPExcel->getActiveSheet()->setCellValue('J1', '自我介绍'); // Field names in the first row $fields = $query->list_fields(); $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 2, $field); $col++; } // Fetching the table data $row = 2; foreach ($query->result() as $data) { $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field}); $col++; } $row++; } $objPHPExcel->setActiveSheetIndex(0); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); //发送标题强制用户下载文件 header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="Products_' . date('dMy') . '.xls"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
public function createXls() { $this->load->database(); $query = $this->db->query("select * from T_USER"); if (!$query) { return false; } $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("title")->setDescription("description"); $objPHPExcel->setActiveSheetIndex(0); // Field names in the first row $fields = $query->list_fields(); $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field); $col++; } $row = 2; foreach ($query->result() as $data) { $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field}); $col++; } $row++; } // Assign cell values // $objPHPExcel->setActiveSheetIndex(0); // $objPHPExcel->getActiveSheet()->setCellValue('A1', 'cell value here'); //$objPHPExcel->getActiveSheet()->setCellValue('A2', 'cell value here'); // Save it as an excel 2003 file $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save("nameoffile_2.xls"); }
function index() { $objPHPExcel = new PHPExcel(); $inputFileType = 'HTML'; $inputFileName = 'assets/file/sample4.html'; $outputFileType = 'Excel2007'; $outputFileName = 'assets/file/sample4.xls'; $filename = "DownloadReport.xls"; $objPHPExcelReader = IOFactory::createReader($inputFileType); $objPHPExcel = $objPHPExcelReader->load($inputFileName); $objget = $objPHPExcel->getActiveSheet(); $objget->getColumnDimension('A')->setWidth(5); $objget->getColumnDimension('B')->setWidth(5); $objget->getColumnDimension('C')->setWidth(5); $objget->getColumnDimension('D')->setWidth(20); $objget->getColumnDimension('E')->setWidth(50); $objget->getColumnDimension('F')->setWidth(50); $objget->getColumnDimension('G')->setWidth(20); ini_set('zlib.output_compression', 'Off'); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); //the folowing two lines make sure it is saved as a xls file header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $filename); //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); }
public function generateDoc() { $phpWord = new PhpWord(); $section = $phpWord->createSection(); $section->addText('Hello World!'); $file = 'HelloWorld.docx'; header("Content-Description: File Transfer"); header('Content-Disposition: attachment; filename="' . $file . '"'); header('Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document'); header('Content-Transfer-Encoding: binary'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Expires: 0'); $xmlWriter = IOFactory::createWriter($phpWord, 'Word2007'); $xmlWriter->save("prueba.docx"); }
function index() { $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("SMA Insan Cendekia Alkautsar")->setTitle("Jadwal pelajaran"); //file title $objset = $objPHPExcel->setActiveSheetIndex(0); //inisiasi set object $objget = $objPHPExcel->getActiveSheet(); //inisiasi get object $objget->setTitle('Sample Sheet'); //sheet title $objset->setCellValue('A1', "This is Sample Excel File"); //insert cell value $objget->getStyle('A1')->getFont()->setBold(true)->setSize(15); //set font size //query $query = $this->db->query("select get_npwpd(c.id, true) as npwpd,c.nama as customernm,c.alamat, c.telphone,c.kodepos,\r\n cd.reg_date as createdatecd, cd.notes as ket, kec.kode as kecamatankd,kec.nama as kecamatannm,\r\n kel.kode as kelurahankd, kel.nama as kelurahannm, cd.customer_status_id, u.nama as usahanm,\r\n cd.usaha_id, cd.konterid, cd.notes, kel2.kode as kel2kd, kel2.nama as kel2nm,\r\n kec2.kode as kec2kd, kec2.nama as kec2nm,\r\n c.kukuhtgl, c.kukuhno, cd.reg_date as reg_datecd\r\n ,(select count(*) FROM pad_customer_usaha cd2\r\n INNER JOIN pad_kelurahan k2 ON cd2.kelurahan_id=k2.id\r\n INNER JOIN pad_kecamatan k3 ON k2.kecamatan_id=k3.id\r\n WHERE cd2.customer_id=c.id and usaha_id=cd.usaha_id and k3.id=kec2.id) as jml\r\n from pad_customer c\r\n inner join pad_customer_usaha cd on c.id=cd.customer_id\r\n inner join pad_kelurahan kel on c.kelurahan_id=kel.id\r\n inner join pad_kecamatan kec on kel.kecamatan_id=kec.id\r\n inner join pad_usaha u on cd.usaha_id=u.id\r\n inner join pad_kelurahan kel2 on cd.kelurahan_id=kel2.id\r\n inner join pad_kecamatan kec2 on kel2.kecamatan_id=kec2.id\r\n order by c.npwpd"); //table header $cols = array("A", "B", "C", "D", "E", "F"); $val = array("NPWPD", "NAMA", "ALAMAT", "KETERANGAN", "KECAMATAN", "KELURAHAN"); for ($a = 0; $a < 6; $a++) { $objset->setCellValue($cols[$a] . '3', $val[$a]); //set borders $objget->getStyle($cols[$a] . '3')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '3')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '3')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '3')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //set alignment $objget->getStyle($cols[$a] . '3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //set font weight $objget->getStyle($cols[$a] . '3')->getFont()->setBold(true); } //taruh baris data disini $colsb = array("A", "B", "C", "D", "E", "F"); $i = 4; // baris ke foreach ($query->result() as $row) { $valb = array($row->npwpd, $row->customernm, $row->alamat, $row->ket, $row->kecamatannm, $row->kelurahannm); for ($b = 0; $b < 6; $b++) { $objset->setCellValue($colsb[$b] . $i, $valb[$b]); } $i = $i + 1; } //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('assets/file/sample2.xls'); }
/** * [index 导出excel方法,用来将query中的内容导出成excel并提供用户下载] * @return [type] [description] */ function index() { $query = $this->db->query("select b.firm as '厂商',b.tname as '类型',a.xhgg as '型号规格', \n\t\t\ta.sn as 'S/N',a.zcbh as '资产编号',a.zt as '状态',a.je as '金额',a.dhsj as '到货时间',\n\t\t\tc.pname as '地点',a.azsj as '安装时间',a.fph as '发票号',a.hth as '合同号',a.bz as '备注'\n\t\t\tfrom `t_main` a, `t_type` b,`t_place` c \n\t\t\twhere a.tid = b.tid and a.pid = c.pid\n\t\t\torder by a.pid,a.tid"); $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); //创建PHPExcel对象 $objPHPExcel->getProperties()->setTitle("设备总表")->setDescription("none"); //设置excel标题 $objPHPExcel->setActiveSheetIndex(0); // 设置活动表单 $fields = $query->list_fields(); // 获得数据库查询表头 $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->getStyle('A1:O1')->applyFromArray(array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'D1EEEE')))); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field); //输出表头内容 $col++; } // Fetching the table data $row = 2; foreach ($query->result() as $data) { $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field}); $col++; } $row++; } $objPHPExcel->setActiveSheetIndex(0); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $excelname = 'main' . date('YmdHis', time()); //用时间定义生成的excel文档 $objWriter->save('xls\\' . $excelname . '.xls'); header("Content-Type: application/force-download"); //跳出下载框强制用户下载 header("Content-Disposition: attachment; filename=" . $excelname . '.xls'); //设置下载框文件名 if (readfile('xls\\' . $excelname . '.xls')) { $data['main'] = $this->main->select_main(); $data['type'] = $this->main->select_distinct_type(); // print_r($data);die; $this->load->view('index/main.html', $data); } }
public function index() { //进行查询对应的数据并把相应的数据写在excel表上 $this->load->model('Page_model', 'page'); $data['userinfos'] = $this->page->getrelativion(); //导入对应的phpexcel库 $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("export")->setDescription("none"); // $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', iconv('gbk', 'utf-8', '中文Hello'))->setCellValue('B2', 'world!')->setCellValue('C1', 'Hello'); $col = 0; $arrgroup = array('id名称', 'rid名称'); // $arrgroup= array('id','rid'); foreach ($arrgroup as $v) { // iconv("UTF-8", "GB2312//IGNORE", $v); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $v); $col++; } // $row=count($data['userinfos']); $row = 2; // p($data['userinfos'][0]['id']); // p($data['userinfos']);die; // foreach ($data['userinfos'] as $data) { // $col=0; // foreach ($arrgroup as $field) { // $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data[$field]); // $col++; // } // $row++; // } $objPHPExcel->setActiveSheetIndex(0); // Excel这里有2种格式 // $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007'); //发送标题强制用户下载文件 // header('Content-Type: application/vnd.ms-excel'); header('Content-Type: application/vnd.ms-excel; charset="UTF-8"'); // header("Content-type: text/html; charset=utf-8"); // 2种格式 // header('Content-Disposition: attachment;filename="Products_'.date('dMy').'.xls"'); header('Content-Disposition: attachment;filename="Products_' . date('dMy') . '.xlsx"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
public function get($id = null) { header('Content-Type: application/json'); $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); $query = $this->product->get_products($id); if (!$query) { echo json_encode(array('status' => false, 'error' => 'Data not found')); return false; } $fields = $query->list_fields(); $result = $query->result(); if (empty($result)) { echo json_encode(array('status' => true, 'result' => 'Products not found')); return false; } $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field); $col++; } $row = 3; foreach ($result as &$data) { $col = 0; foreach ($fields as $field) { if ($field == 'created_date') { $data->{$field} = date('d/m/Y H:i', $data->{$field}); } $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field}); $col++; } $row++; } $objPHPExcel->setActiveSheetIndex(0); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $filepath = 'products/Products_' . date('dmyHis') . '.xls'; $objWriter->save($filepath); echo json_encode(array('status' => true, 'result' => $result, 'download_link' => base_url() . $filepath)); }
public function outportExcel() { //查出了全部的数据 $alldata = $this->register->getAllData(); $objPHPExcel = new PHPExcel(); //创建了3个工作簿 for ($i = 1; $i <= 3; $i++) { // 新建的objPHPExcel对象就已经新建的sheet对象 if ($i > 1) { //创建新的内置表 $objPHPExcel->createSheet(); } //把新创建的sheet设定为当前活动sheet $objPHPExcel->setActiveSheetIndex($i - 1); //获取当前活动sheet $objSheet = $objPHPExcel->getActiveSheet(); // p($objSheet);die(); //给当前活动sheet起个名称 $objSheet->setTitle('第' . $i . '个工作簿'); //位置居中 $objSheet->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //设置excel文件默认水平垂直方向居中 //字体的设置 //$objSheet->getDefaultStyle()->getFont()->setSize(14)->setName("微软雅黑");//设置默认字体大小和格式 //填充数据 [固定的数据] $objSheet->setCellValue("A1", "姓名")->setCellValue("B1", "校区")->setCellValue("C1", "学院")->setCellValue("D1", "专业")->setCellValue("E1", "年级")->setCellValue("F1", "班级")->setCellValue("G1", "分组"); $j = 2; foreach ($alldata as $key => $value) { //插入具体的数据 $objSheet->setCellValue("A" . $j, $value['user_name'])->setCellValue("B" . $j, $value['school_zone'])->setCellValue("C" . $j, $value['belong'])->setCellValue("D" . $j, $value['specialty'])->setCellValue("E" . $j, $value['ngrade'])->setCellValue("F" . $j, $value['class'])->setCellValue("G" . $j, $value['group']); $j++; } } $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007'); //在controller里面的方法的互相调用 $this->browser_export('Excel2007', '学生信息表.xlsx'); //输出到浏览器 $objWriter->save("php://output"); }
function index() { $query = $this->Excel_model->get(); if (!$query) { return false; } // StartingthePHPExcellibrary $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("export")->setDescription("none"); $objPHPExcel->setActiveSheetIndex(0); // Fieldnamesinthefirstrow $fields = $query->list_fields(); $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field); $col++; } // Fetchingthetabledata $row = 2; foreach ($query->result() as $data) { $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field}); $col++; } $row++; } $objPHPExcel->setActiveSheetIndex(0); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); // Sendingheaderstoforcetheusertodownloadthefile header('Content-Type:application/vnd.ms-excel'); header('Content-Disposition:attachment;filename="Products_' . date('dMy') . '.xls"'); header('Cache-Control:max-age=0'); $objWriter->save('php://output'); }
function index() { $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("SMA Insan Cendekia Alkautsar")->setTitle("Jadwal pelajaran"); //file title $objset = $objPHPExcel->setActiveSheetIndex(0); //inisiasi set object $objget = $objPHPExcel->getActiveSheet(); //inisiasi get object $objget->setTitle('Sample Sheet'); //sheet title $objset->setCellValue('A1', "This is Sample Excel File"); //insert cell value $objget->getStyle('A1')->getFont()->setBold(true)->setSize(15); //set font size //table header $cols = array("A", "B", "C", "D", "E", "F"); $val = array("No", "Member ID", "Member Username", "Member Address", "Member Phone", "Member Status"); for ($a = 0; $a < 6; $a++) { $objset->setCellValue($cols[$a] . '3', $val[$a]); //set borders $objget->getStyle($cols[$a] . '3')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '3')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '3')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '3')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //set alignment $objget->getStyle($cols[$a] . '3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //set font weight $objget->getStyle($cols[$a] . '3')->getFont()->setBold(true); } //taruh baris data disini //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('assets/file/sample.xls'); }
function ProsesUnduhFile() { // inisialisasi proses ekspor data $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $pPeriodecari = $this->input->post('periode'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("export")->setDescription("none"); $objPHPExcel->getDefaultStyle()->getFont()->setName('Arial'); $objPHPExcel->getDefaultStyle()->getFont()->setSize(11); // Proses ekspor data dari tabel-tabel database // Worksheet #0 - dishub $dtDishub = $this->dishub_model->getDishub(); $objPHPExcel->createSheet(0); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle('dishub'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'kode_dishub'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'nama_dishub'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'alamat_dishub'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'kode_provinsi'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'kode_kabkota'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'telp_dishub'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'email_dishub'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'nama_kadis'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'nip_kadis'); foreach (range('A', 'I') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtDishub as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->kode_dishub) ? $dt->kode_dishub : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->nama_dishub) ? $dt->nama_dishub : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->alamat_dishub) ? $dt->alamat_dishub : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->kode_provinsi) ? $dt->kode_provinsi : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->kode_kabkota) ? $dt->kode_kabkota : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->telp_dishub) ? $dt->telp_dishub : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->email_dishub) ? $dt->email_dishub : '-'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->nama_kadis) ? $dt->nama_kadis : '-'); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, !empty($dt->nip_kadis) ? $dt->nip_kadis : '-'); $i++; } // Worksheet #1 - unit_pkb $dtUnitPkb = $this->unitpkb_model->getUnitPKB(); $objPHPExcel->createSheet(1); $objPHPExcel->setActiveSheetIndex(1); $objPHPExcel->getActiveSheet()->setTitle('unit_pkb'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'kode_unit'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'jenis_unit'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'nama_unit'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'luas'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'kapasitas'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'alamat_unit'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'telp_unit'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'email_unit'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'nama_kanit'); $objPHPExcel->getActiveSheet()->setCellValue('J1', 'nip_kanit'); $objPHPExcel->getActiveSheet()->setCellValue('K1', 'kode_dishub'); $objPHPExcel->getActiveSheet()->setCellValue('L1', 'foto'); foreach (range('A', 'L') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtUnitPkb as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->jenis_unit) ? $dt->jenis_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->nama_unit) ? $dt->nama_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->luas) ? $dt->luas : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->kapasitas) ? $dt->kapasitas : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->alamat_unit) ? $dt->alamat_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->telp_unit) ? $dt->telp_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->email_unit) ? $dt->email_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, !empty($dt->nama_kanit) ? $dt->nama_kanit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, !empty($dt->nip_kanit) ? $dt->nip_kanit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('K' . $i, !empty($dt->kode_dishub) ? $dt->kode_dishub : '-'); $objPHPExcel->getActiveSheet()->setCellValue('L' . $i, !empty($dt->foto) ? $dt->foto : '-'); $i++; } // Worksheet #2 - fasilitas $dtFasilitas = $this->unitpkb_model->getFasilitas(); $objPHPExcel->createSheet(2); $objPHPExcel->setActiveSheetIndex(2); $objPHPExcel->getActiveSheet()->setTitle('fasilitas'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'kd_fasilitas'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'fasilitas'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'jumlah'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'satuan'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'kode_unit'); foreach (range('A', 'E') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtFasilitas as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->kd_fasilitas) ? $dt->kd_fasilitas : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->fasilitas) ? $dt->fasilitas : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->jumlah) ? $dt->jumlah : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->satuan) ? $dt->satuan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $i++; } // Worksheet #3 - penguji $dtPenguji = $this->penguji_model->getPenguji(); $objPHPExcel->createSheet(3); $objPHPExcel->setActiveSheetIndex(3); $objPHPExcel->getActiveSheet()->setTitle('penguji'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'nip_penguji'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'nama_penguji'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'gol_pangkat'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'jabatan_fungsional'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'kode_unit'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'tipe_penguji'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'foto'); foreach (range('A', 'H') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtPenguji as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->nip_penguji) ? $dt->nip_penguji : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->nama_penguji) ? $dt->nama_penguji : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $dt->gol_pangkat); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->jabatan_fungsional) ? $dt->jabatan_fungsional : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->tipe_penguji) ? $dt->tipe_penguji : '-'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->foto) ? $dt->foto : '-'); $i++; } // Worksheet #4 - sertifikat_penguji $dtSertifikat = $this->penguji_model->getAllSertifikat(); $objPHPExcel->createSheet(4); $objPHPExcel->setActiveSheetIndex(4); $objPHPExcel->getActiveSheet()->setTitle('sertifikat_penguji'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'no_sertifikat'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'tgl_terbit'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'lembaga_penerbit'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'jenis_sertifikat'); foreach (range('A', 'E') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtSertifikat as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->no_sertifikat) ? $dt->no_sertifikat : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->tgl_terbit) ? $dt->tgl_terbit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->lembaga_penerbit) ? $dt->lembaga_penerbit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->jenis_sertifikat) ? $dt->jenis_sertifikat : '-'); $i++; } // Worksheet #5 - riwayat_pendidikan $dtRiwayat = $this->penguji_model->getAllRiwayat(); $objPHPExcel->createSheet(5); $objPHPExcel->setActiveSheetIndex(5); $objPHPExcel->getActiveSheet()->setTitle('riwayat_pendidikan'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'kd_riwayat'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'periode'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'keterangan'); foreach (range('A', 'D') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtRiwayat as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->kd_riwayat) ? $dt->kd_riwayat : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->periode) ? $dt->periode : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->keterangan) ? $dt->keterangan : '-'); $i++; } // Worksheet #6 - penghargaan_penguji $dtPenghargaan = $this->penguji_model->getAllPenghargaan(); $objPHPExcel->createSheet(6); $objPHPExcel->setActiveSheetIndex(6); $objPHPExcel->getActiveSheet()->setTitle('penghargaan_penguji'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'kd_penghargaan'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'tahun'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'penghargaan'); foreach (range('A', 'D') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtPenghargaan as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->kd_penghargaan) ? $dt->kd_penghargaan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->tahun) ? $dt->tahun : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->penghargaan) ? $dt->penghargaan : '-'); $i++; } // Worksheet #7 - sanksi_penguji $dtSanksi = $this->penguji_model->getAllSanksi(); $objPHPExcel->createSheet(7); $objPHPExcel->setActiveSheetIndex(7); $objPHPExcel->getActiveSheet()->setTitle('sanksi_penguji'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'kd_sanksi'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'tahun'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'sanksi'); foreach (range('A', 'D') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtSanksi as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->kd_sanksi) ? $dt->kd_sanksi : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->tahun) ? $dt->tahun : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->sanksi) ? $dt->sanksi : '-'); $i++; } // Worksheet #8 - peralatan_uji $dtperalatanuji = $this->peralatanuji_model->getAlat(); $objPHPExcel->createSheet(8); $objPHPExcel->setActiveSheetIndex(8); $objPHPExcel->getActiveSheet()->setTitle('peralatan_uji'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'kode_alat'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'nama_alat'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'merk'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'kode_kelompok'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'jumlah_alat'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'status_alat'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'tahun_produksi'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'tahun_penggunaan'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'tahun_kalibrasi'); $objPHPExcel->getActiveSheet()->setCellValue('J1', 'kode_unit'); foreach (range('A', 'J') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtperalatanuji as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->kode_alat) ? $dt->kode_alat : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->nama_alat) ? $dt->nama_alat : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->merk) ? $dt->merk : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->kd_kelompok) ? $dt->kd_kelompok : '0'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->jumlah_alat) ? $dt->jumlah_alat : '0'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->status_alat) ? $dt->status_alat : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->tahun_produksi) ? $dt->tahun_produksi : '0000'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->tahun_penggunaan) ? $dt->tahun_penggunaan : '0000'); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, !empty($dt->tahun_kalibrasi) ? $dt->tahun_kalibrasi : '0000'); $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $i++; } // Worksheet #9 - kendaraan $dtKendaraan = $this->kendaraanmodel->getAllKendaraan(); $objPHPExcel->createSheet(9); $objPHPExcel->setActiveSheetIndex(9); $objPHPExcel->getActiveSheet()->setTitle('kendaraan'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'no_uji'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'no_srut'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'no_kendaraan'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'merek'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'tipe'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'id_jeniskendaraan'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'isi_silinder'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'daya_motor'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'satuan_daya'); $objPHPExcel->getActiveSheet()->setCellValue('J1', 'bahan_bakar'); $objPHPExcel->getActiveSheet()->setCellValue('K1', 'tahun_buat'); $objPHPExcel->getActiveSheet()->setCellValue('L1', 'id_statuskendaraan'); $objPHPExcel->getActiveSheet()->setCellValue('M1', 'no_chassis'); $objPHPExcel->getActiveSheet()->setCellValue('N1', 'no_mesin'); $objPHPExcel->getActiveSheet()->setCellValue('O1', 'no_ujitipe'); $objPHPExcel->getActiveSheet()->setCellValue('P1', 'tgl_ujitipe'); $objPHPExcel->getActiveSheet()->setCellValue('Q1', 'tgl_srut'); $objPHPExcel->getActiveSheet()->setCellValue('R1', 'tgl_ujipertama'); $objPHPExcel->getActiveSheet()->setCellValue('S1', 'tgl_ujiberikut'); $objPHPExcel->getActiveSheet()->setCellValue('T1', 'kode_unit'); $objPHPExcel->getActiveSheet()->setCellValue('U1', 'foto_depan'); $objPHPExcel->getActiveSheet()->setCellValue('V1', 'foto_belakang'); $objPHPExcel->getActiveSheet()->setCellValue('W1', 'foto_kiri'); $objPHPExcel->getActiveSheet()->setCellValue('X1', 'foto_kanan'); foreach (range('A', 'X') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtKendaraan as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->no_uji) ? $dt->no_uji : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->no_srut) ? $dt->no_srut : '-'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->no_kendaraan) ? $dt->no_kendaraan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->merek) ? $dt->merek : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->tipe) ? $dt->tipe : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->id_jeniskendaraan) ? $dt->id_jeniskendaraan : '0'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->isi_silinder) ? $dt->isi_silinder : '-'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->daya_motor) ? $dt->daya_motor : '-'); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, !empty($dt->satuan_daya) ? $dt->satuan_daya : '-'); $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, !empty($dt->bahan_bakar) ? $dt->bahan_bakar : '-'); $objPHPExcel->getActiveSheet()->setCellValue('K' . $i, !empty($dt->tahun_buat) ? $dt->tahun_buat : '-'); $objPHPExcel->getActiveSheet()->setCellValue('L' . $i, !empty($dt->id_statuskendaraan) ? $dt->id_statuskendaraan : '0'); $objPHPExcel->getActiveSheet()->setCellValue('M' . $i, !empty($dt->no_chassis) ? $dt->no_chassis : '-'); $objPHPExcel->getActiveSheet()->setCellValue('N' . $i, !empty($dt->no_mesin) ? $dt->no_mesin : '-'); $objPHPExcel->getActiveSheet()->setCellValue('O' . $i, !empty($dt->no_ujitipe) ? $dt->no_ujitipe : '-'); $objPHPExcel->getActiveSheet()->setCellValue('P' . $i, !empty($dt->tgl_ujitipe) ? $dt->tgl_ujitipe : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('Q' . $i, !empty($dt->tgl_srut) ? $dt->tgl_srut : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('R' . $i, !empty($dt->tgl_ujipertama) ? $dt->tgl_ujipertama : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('S' . $i, !empty($dt->tgl_ujiberikut) ? $dt->tgl_ujiberikut : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('T' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $objPHPExcel->getActiveSheet()->setCellValue('U' . $i, !empty($dt->foto_depan) ? $dt->foto_depan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('V' . $i, !empty($dt->foto_belakang) ? $dt->foto_belakang : '-'); $objPHPExcel->getActiveSheet()->setCellValue('W' . $i, !empty($dt->foto_kiri) ? $dt->foto_kiri : '-'); $objPHPExcel->getActiveSheet()->setCellValue('X' . $i, !empty($dt->foto_kanan) ? $dt->foto_kanan : '-'); $i++; } // Worksheet #10 - uraian_kendaraan $dtUraianKend = $this->exportsmodel->getAllDataUraianKendaraan($pPeriodecari); $objPHPExcel->createSheet(10); $objPHPExcel->setActiveSheetIndex(10); $objPHPExcel->getActiveSheet()->setTitle('uraian_kendaraan'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'no_srut'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'no_bap'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'panjang'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'lebar'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'tinggi'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'julur_belakang'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'julur_depan'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'sumbu_12'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'sumbu_23'); $objPHPExcel->getActiveSheet()->setCellValue('J1', 'sumbu_34'); $objPHPExcel->getActiveSheet()->setCellValue('K1', 'q'); $objPHPExcel->getActiveSheet()->setCellValue('L1', 'panjang_bak'); $objPHPExcel->getActiveSheet()->setCellValue('M1', 'lebar_bak'); $objPHPExcel->getActiveSheet()->setCellValue('N1', 'tinggi_bak'); $objPHPExcel->getActiveSheet()->setCellValue('O1', 'bahan_bak'); $objPHPExcel->getActiveSheet()->setCellValue('P1', 'model_tangki'); $objPHPExcel->getActiveSheet()->setCellValue('Q1', 'panjang_tangki'); $objPHPExcel->getActiveSheet()->setCellValue('R1', 'lebar_tangki'); $objPHPExcel->getActiveSheet()->setCellValue('S1', 'tinggi_tangki'); $objPHPExcel->getActiveSheet()->setCellValue('T1', 'volume_tangki'); $objPHPExcel->getActiveSheet()->setCellValue('U1', 'jenis_muatan'); $objPHPExcel->getActiveSheet()->setCellValue('V1', 'berat_jenis_muatan'); $objPHPExcel->getActiveSheet()->setCellValue('W1', 'bahan_tangki'); $objPHPExcel->getActiveSheet()->setCellValue('X1', 'sumbu_1'); $objPHPExcel->getActiveSheet()->setCellValue('Y1', 'sumbu_2'); $objPHPExcel->getActiveSheet()->setCellValue('Z1', 'sumbu_3'); $objPHPExcel->getActiveSheet()->setCellValue('AA1', 'sumbu_4'); $objPHPExcel->getActiveSheet()->setCellValue('AB1', 'jbb'); $objPHPExcel->getActiveSheet()->setCellValue('AC1', 'jbkb'); $objPHPExcel->getActiveSheet()->setCellValue('AD1', 'bk_sumbu_1'); $objPHPExcel->getActiveSheet()->setCellValue('AE1', 'bk_sumbu_2'); $objPHPExcel->getActiveSheet()->setCellValue('AF1', 'bk_sumbu_3'); $objPHPExcel->getActiveSheet()->setCellValue('AG1', 'bk_sumbu_4'); $objPHPExcel->getActiveSheet()->setCellValue('AH1', 'orang'); $objPHPExcel->getActiveSheet()->setCellValue('AI1', 'barang'); $objPHPExcel->getActiveSheet()->setCellValue('AJ1', 'JBI'); $objPHPExcel->getActiveSheet()->setCellValue('AK1', 'JBKI'); $objPHPExcel->getActiveSheet()->setCellValue('AL1', 'MST'); $objPHPExcel->getActiveSheet()->setCellValue('AM1', 'KJT'); foreach (range('A', 'Z') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AJ')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AK')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AL')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('AM')->setAutoSize(true); $i = 2; foreach ($dtUraianKend as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->no_srut) ? $dt->no_srut : '0'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->no_bap) ? $dt->no_bap : '0'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->panjang) ? $dt->panjang : '0'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->lebar) ? $dt->lebar : '0'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->tinggi) ? $dt->tinggi : '0'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->julur_belakang) ? $dt->julur_belakang : '0'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->julur_depan) ? $dt->julur_depan : '0'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->sumbu_12) ? $dt->sumbu_12 : '0'); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, !empty($dt->sumbu_23) ? $dt->sumbu_23 : '0'); $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, !empty($dt->sumbu_34) ? $dt->sumbu_34 : '0'); $objPHPExcel->getActiveSheet()->setCellValue('K' . $i, !empty($dt->q) ? $dt->q : '0'); $objPHPExcel->getActiveSheet()->setCellValue('L' . $i, !empty($dt->panjang_bak) ? $dt->panjang_bak : '0'); $objPHPExcel->getActiveSheet()->setCellValue('M' . $i, !empty($dt->lebar_bak) ? $dt->lebar_bak : '0'); $objPHPExcel->getActiveSheet()->setCellValue('N' . $i, !empty($dt->tinggi_bak) ? $dt->tinggi_bak : '0'); $objPHPExcel->getActiveSheet()->setCellValue('O' . $i, !empty($dt->bahan_bak) ? $dt->bahan_bak : '-'); $objPHPExcel->getActiveSheet()->setCellValue('P' . $i, !empty($dt->model_tangki) ? $dt->model_tangki : '-'); $objPHPExcel->getActiveSheet()->setCellValue('Q' . $i, !empty($dt->panjang_tangki) ? $dt->panjang_tangki : '0'); $objPHPExcel->getActiveSheet()->setCellValue('R' . $i, !empty($dt->lebar_tangki) ? $dt->lebar_tangki : '0'); $objPHPExcel->getActiveSheet()->setCellValue('S' . $i, !empty($dt->tinggi_tangki) ? $dt->tinggi_tangki : '0'); $objPHPExcel->getActiveSheet()->setCellValue('T' . $i, !empty($dt->volume_tangki) ? $dt->volume_tangki : '0'); $objPHPExcel->getActiveSheet()->setCellValue('U' . $i, !empty($dt->jenis_muatan) ? $dt->jenis_muatan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('V' . $i, !empty($dt->berat_jenis_muatan) ? $dt->berat_jenis_muatan : '0'); $objPHPExcel->getActiveSheet()->setCellValue('W' . $i, !empty($dt->bahan_tangki) ? $dt->bahan_tangki : '-'); $objPHPExcel->getActiveSheet()->setCellValue('X' . $i, !empty($dt->sumbu_1) ? $dt->sumbu_1 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('Y' . $i, !empty($dt->sumbu_2) ? $dt->sumbu_2 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('Z' . $i, !empty($dt->sumbu_3) ? $dt->sumbu_3 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('AA' . $i, !empty($dt->sumbu_4) ? $dt->sumbu_4 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('AB' . $i, !empty($dt->jbb) ? $dt->jbb : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AC' . $i, !empty($dt->jbkb) ? $dt->jbkb : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AD' . $i, !empty($dt->bk_sumbu_1) ? $dt->bk_sumbu_1 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('AE' . $i, !empty($dt->bk_sumbu_2) ? $dt->bk_sumbu_2 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('AF' . $i, !empty($dt->bk_sumbu_3) ? $dt->bk_sumbu_3 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('AG' . $i, !empty($dt->bk_sumbu_4) ? $dt->bk_sumbu_4 : '-'); $objPHPExcel->getActiveSheet()->setCellValue('AH' . $i, !empty($dt->orang) ? $dt->orang : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AI' . $i, !empty($dt->barang) ? $dt->barang : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AJ' . $i, !empty($dt->JBI) ? $dt->JBI : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AK' . $i, !empty($dt->JBKI) ? $dt->JBKI : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AL' . $i, !empty($dt->MST) ? $dt->MST : '0'); $objPHPExcel->getActiveSheet()->setCellValue('AM' . $i, !empty($dt->KJT) ? $dt->KJT : '0'); $i++; } // Worksheet #11 - pendaftaran $dtPendaftaran = $this->exportsmodel->getAllDataPendaftaran($pPeriodecari); $objPHPExcel->createSheet(11); $objPHPExcel->setActiveSheetIndex(11); $objPHPExcel->getActiveSheet()->setTitle('pendaftaran'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'no_pendaftaran'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'tgl_pendaftaran'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'nama_pendaftar'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'no_srut'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'tipe_pendaftaran'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'status'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'jumlah_bayar'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'retribusi'); foreach (range('A', 'H') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtPendaftaran as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->no_pendaftaran) ? $dt->no_pendaftaran : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->tgl_pendaftaran) ? $dt->tgl_pendaftaran : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->nama_pendaftar) ? $dt->nama_pendaftar : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->no_srut) ? $dt->no_srut : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->tipe_pendaftaran) ? $dt->tipe_pendaftaran : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->status) ? $dt->status : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->jumlah_bayar) ? $dt->jumlah_bayar : '0'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->retribusi) ? $dt->retribusi : '-'); $i++; } // Worksheet #12 - detail_hasil_pengujian $dtDetailHasilUji = $this->exportsmodel->getAllDataDetailHasilUji($pPeriodecari); $objPHPExcel->createSheet(12); $objPHPExcel->setActiveSheetIndex(12); $objPHPExcel->getActiveSheet()->setTitle('detail_hasil_pengujian'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'no bap'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'kd_itempengujian'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'hasil_uji'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'status_hasil'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'kode_unit'); foreach (range('A', 'F') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtDetailHasilUji as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->no_bap) ? $dt->no_bap : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->kd_itempengujian) ? $dt->kd_itempengujian : '0'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->hasil_uji) ? $dt->hasil_uji : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->status_hasil) ? $dt->status_hasil : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $i++; } // Worksheet #13 - hasil_pengujian $dtHasilUji = $this->exportsmodel->getAllDataHasilUji($pPeriodecari); $objPHPExcel->createSheet(13); $objPHPExcel->setActiveSheetIndex(13); $objPHPExcel->getActiveSheet()->setTitle('hasil_pengujian'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'no_bap'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'no_pendaftaran'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'no_srut'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'tgl_pengujian'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'hasil_pengujian'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'keterangan'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'NRP'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'kode_unit'); foreach (range('A', 'H') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtHasilUji as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->no_bap) ? $dt->no_bap : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->no_pendaftaran) ? $dt->no_pendaftaran : '0'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->no_srut) ? $dt->no_srut : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->tgl_pengujian) ? $dt->tgl_pengujian : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->hasil_pengujian) ? $dt->hasil_pengujian : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->keterangan) ? $dt->keterangan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->NRP) ? $dt->NRP : '-'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $i++; } // Worksheet #14 - keberatan $dtKeberatan = $this->exportsmodel->getAllKeberatan($pPeriodecari); $objPHPExcel->createSheet(14); $objPHPExcel->setActiveSheetIndex(14); $objPHPExcel->getActiveSheet()->setTitle('keberatan'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'no_keberatan'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'tgl_keberatan'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'nama_pemohon'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'id_pemohon'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'alamat_pemohon'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'keterangan'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'status'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'no_bap'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'kode_unit'); foreach (range('A', 'I') as $letter) { $objPHPExcel->getActiveSheet()->getColumnDimension($letter)->setAutoSize(true); } $i = 2; foreach ($dtKeberatan as $dt) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, !empty($dt->no_keberatan) ? $dt->no_keberatan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, !empty($dt->tgl_keberatan) ? $dt->tgl_keberatan : '0000-00-00'); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, !empty($dt->nama_pemohon) ? $dt->nama_pemohon : '-'); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, !empty($dt->id_pemohon) ? $dt->id_pemohon : '-'); $objPHPExcel->getActiveSheet()->setCellValue('E' . $i, !empty($dt->alamat_pemohon) ? $dt->alamat_pemohon : '-'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, !empty($dt->keterangan) ? $dt->keterangan : '-'); $objPHPExcel->getActiveSheet()->setCellValue('G' . $i, !empty($dt->status) ? $dt->status : '-'); $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, !empty($dt->no_bap) ? $dt->no_bap : '-'); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, !empty($dt->kode_unit) ? $dt->kode_unit : '-'); $i++; } // Create nama file hasil export $kodeUnit = $this->unitpkb_model->getKodeUnit(); $namaFile = $kodeUnit . '_' . $pPeriodecari; // Inisiasi create writter $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); // Sending headers to force the user to download the file header('Content-Type: application/vnd.ms-excel'); //header('Content-Disposition: attachment;filename="data_'.$pPeriodecari.'.xls"'); header('Content-Disposition: attachment;filename="data_' . $namaFile . '.xls"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
/** * * 导出会议室租用申请表 */ public function exportRoomBooking() { $data = array(); if (checkRight('room_booking_export') === FALSE) { $this->showView('denied', $data); exit; } $id = $this->input->get('id'); $this->load->model('MIS_Room'); $info = $this->MIS_Room->getBookingApplyInfo($id); $room_type = $this->config->item('room_type'); //加载PHPExcel库 require_once THIRD_PATH . 'PHPExcel.php'; require_once THIRD_PATH . 'PHPExcel/IOFactory.php'; $objPHPExcel = new PHPExcel(); //列宽 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12); //第一行 $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A1:H1'); $objPHPExcel->getActiveSheet()->setCellValue('A1', '创投大厦' . $room_type[$info['room_type']] . '租用申请表'); $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20); $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第二行 $objPHPExcel->getActiveSheet()->mergeCells('A2:F2'); $objPHPExcel->getActiveSheet()->mergeCells('G2:H2'); $objPHPExcel->getActiveSheet()->setCellValue('G2', '编号:'); $objPHPExcel->getActiveSheet()->getStyle('A2:H2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('A2:H2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A2:H2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第三行 $objPHPExcel->getActiveSheet()->getRowDimension(3)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A3', '申请单位'); $objPHPExcel->getActiveSheet()->mergeCells('B3:C3'); $objPHPExcel->getActiveSheet()->setCellValue('B3', $info['enterprise_name']); $objPHPExcel->getActiveSheet()->setCellValue('D3', '申请日期'); $objPHPExcel->getActiveSheet()->mergeCells('E3:H3'); $objPHPExcel->getActiveSheet()->setCellValue('E3', date('Y年m月d日', $info['start_time'])); $objPHPExcel->getActiveSheet()->getStyle('A3:H3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A3:H3')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A3:H3')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第四行 $objPHPExcel->getActiveSheet()->getRowDimension(4)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A4', '租用场地'); $objPHPExcel->getActiveSheet()->mergeCells('B4:H4'); $objPHPExcel->getActiveSheet()->setCellValue('B4', $info['room_name']); $objPHPExcel->getActiveSheet()->getStyle('A4:H4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A4:H4')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A4:H4')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第五行 $objPHPExcel->getActiveSheet()->getRowDimension(5)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A5', '租用事由'); $objPHPExcel->getActiveSheet()->mergeCells('B5:H5'); $objPHPExcel->getActiveSheet()->setCellValue('B5', $info['meeting_title']); $objPHPExcel->getActiveSheet()->getStyle('A5:H5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A5:H5')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A5:H5')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第六行 $objPHPExcel->getActiveSheet()->getRowDimension(6)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A6', '使用设备'); $objPHPExcel->getActiveSheet()->mergeCells('B6:H6'); $objPHPExcel->getActiveSheet()->setCellValue('B6', '口空调 口话筒 口投影 口其它:( )'); $objPHPExcel->getActiveSheet()->getStyle('A6:H6')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A6:H6')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A6:H6')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第七行 $objPHPExcel->getActiveSheet()->getRowDimension(7)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A7', '张贴物品'); $objPHPExcel->getActiveSheet()->mergeCells('B7:E7'); $objPHPExcel->getActiveSheet()->setCellValue('B7', '口无 口标示 口框架海报 口横幅 口其它'); $objPHPExcel->getActiveSheet()->setCellValue('F7', '张贴位置'); $objPHPExcel->getActiveSheet()->mergeCells('G7:H7'); $objPHPExcel->getActiveSheet()->getStyle('A7:H7')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A7:H7')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A7:H7')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第八行 $objPHPExcel->getActiveSheet()->getRowDimension(8)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A8', '与会人数'); $objPHPExcel->getActiveSheet()->mergeCells('C8:D8'); $objPHPExcel->getActiveSheet()->setCellValue('C8', '预计与会嘉宾(仅供参考)'); $objPHPExcel->getActiveSheet()->mergeCells('E8:H8'); $objPHPExcel->getActiveSheet()->getStyle('A8:H8')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A8:H8')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A8:H8')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第九行 $objPHPExcel->getActiveSheet()->getRowDimension(9)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A9:B9'); $objPHPExcel->getActiveSheet()->mergeCells('C9:D9'); $objPHPExcel->getActiveSheet()->mergeCells('E9:F9'); $objPHPExcel->getActiveSheet()->mergeCells('G9:H9'); $objPHPExcel->getActiveSheet()->setCellValue('A9', '申请人'); $objPHPExcel->getActiveSheet()->setCellValue('C9', '办公室电话'); $objPHPExcel->getActiveSheet()->setCellValue('E9', '移动电话'); $objPHPExcel->getActiveSheet()->setCellValue('G9', '单位地址'); $objPHPExcel->getActiveSheet()->getStyle('A9:H9')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A9:H9')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A9:H9')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第十行 $objPHPExcel->getActiveSheet()->getRowDimension(10)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A10:B10'); $objPHPExcel->getActiveSheet()->mergeCells('C10:D10'); $objPHPExcel->getActiveSheet()->mergeCells('E10:F10'); $objPHPExcel->getActiveSheet()->mergeCells('G10:H10'); $objPHPExcel->getActiveSheet()->setCellValue('A10', $info['contacts']); $objPHPExcel->getActiveSheet()->setCellValue('E10', $info['contacts_phone']); $objPHPExcel->getActiveSheet()->getStyle('A10:H10')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A10:H10')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A10:H10')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第十一行 $objPHPExcel->getActiveSheet()->getRowDimension(11)->setRowHeight(30); $objPHPExcel->getActiveSheet()->setCellValue('A11', '收费金额'); $objPHPExcel->getActiveSheet()->setCellValue('B11', '元'); $objPHPExcel->getActiveSheet()->mergeCells('C11:H11'); $objPHPExcel->getActiveSheet()->setCellValue('C11', '预先缴纳定金 元,场地保证金 元'); $objPHPExcel->getActiveSheet()->getStyle('A11:H11')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A11:H11')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A11:H11')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第十二行 $objPHPExcel->getActiveSheet()->getRowDimension(12)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A12:D12'); $objPHPExcel->getActiveSheet()->mergeCells('E12:H12'); $objPHPExcel->getActiveSheet()->setCellValue('A12', '申请单位负责人意见:'); $objPHPExcel->getActiveSheet()->setCellValue('E12', '运营部意见:'); $objPHPExcel->getActiveSheet()->getStyle('A12:H12')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('A12:H12')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A12:H12')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第十三行 $objPHPExcel->getActiveSheet()->mergeCells('A13:D16'); $objPHPExcel->getActiveSheet()->mergeCells('E13:H16'); $objPHPExcel->getActiveSheet()->getStyle('A13:H16')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A13:H16')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A13:A19')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('D13:D19')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle('H13:H19')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第十四行 $objPHPExcel->getActiveSheet()->getRowDimension(17)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A17:D17'); $objPHPExcel->getActiveSheet()->mergeCells('E17:H17'); $objPHPExcel->getActiveSheet()->setCellValue('A17', '申请单位盖章:'); $objPHPExcel->getActiveSheet()->setCellValue('E17', '部门负责人签字:'); $objPHPExcel->getActiveSheet()->getStyle('A17:H17')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A17:H17')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); //第十五行 $objPHPExcel->getActiveSheet()->mergeCells('A18:D18'); $objPHPExcel->getActiveSheet()->mergeCells('E18:H18'); $objPHPExcel->getActiveSheet()->getStyle('A18:H18')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A18:H18')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); //第十六行 $objPHPExcel->getActiveSheet()->getRowDimension(19)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A19:D19'); $objPHPExcel->getActiveSheet()->mergeCells('E19:H19'); $objPHPExcel->getActiveSheet()->setCellValue('A19', '日期: 年 月 日'); $objPHPExcel->getActiveSheet()->setCellValue('E19', '日期: 年 月 日'); $objPHPExcel->getActiveSheet()->getStyle('A19:H19')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A19:H19')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A19:H19')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //最后四行 $objPHPExcel->getActiveSheet()->getRowDimension(20)->setRowHeight(20); $objPHPExcel->getActiveSheet()->getRowDimension(21)->setRowHeight(20); $objPHPExcel->getActiveSheet()->getRowDimension(22)->setRowHeight(20); $objPHPExcel->getActiveSheet()->getRowDimension(23)->setRowHeight(20); $objPHPExcel->getActiveSheet()->mergeCells('A20:H20'); $objPHPExcel->getActiveSheet()->mergeCells('A21:H21'); $objPHPExcel->getActiveSheet()->mergeCells('A22:H22'); $objPHPExcel->getActiveSheet()->mergeCells('A23:H23'); $objPHPExcel->getActiveSheet()->setCellValue('A20', '备注:'); $objPHPExcel->getActiveSheet()->setCellValue('A21', '1、租用场地包含会后清洁服务,但不包含纸、笔、茶水及人员服务;'); $objPHPExcel->getActiveSheet()->setCellValue('A22', '2、请自备笔记本电脑,但需提前联系物业服务中心工程人员安装一软件方可使用;'); $objPHPExcel->getActiveSheet()->setCellValue('A23', '3、请爱惜会议室设备,若有损坏照价赔偿'); $objPHPExcel->getActiveSheet()->setTitle('创投大厦' . $room_type[$info['room_type']] . '租用申请表'); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007'); $file_name = '创投大厦' . $room_type[$info['room_type']] . '租用申请表_' . date("YmdHis") . ".xlsx"; header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $file_name . '"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
$objPHPExcel->getActiveSheet()->getStyle($active3)->applyFromArray($styleAlignHorizontalCenter); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $i, $data['id_obat']); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $i, $data['nbk_obat']); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $i, $data['satuan_obat']); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $i, $data['stok_awal']); if(isset($data['tambah'])){ $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, $i, $data['tambah']);} $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(37, $i, $formula1); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(39, $i, $formula1); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, $i, $formula2); $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(40, $i, $formula3); $x=5; $str=1; for($z=1;$z<=31;$z++){ $t=$x+$z; $obatn='obat'.$z; if(isset($data[$obatn])){ $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($t, $i, $data[$obatn]);} $str++; } $i++;} */ // $objPHPExcel->getActiveSheet()->getStyle('A6:F' . ($i-1))->applyFromArray($styleThinBlackBorderOutline); $objPHPExcel->getActiveSheet()->setTitle('Harian'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); header('Content-Type: application/vnd.ms-excel'); //header('Content-Disposition: attachment;filename="rekap_resep_bulanan_' . $namanya . '-' . $tahun . '.xls"'); $objWriter = IOFactory::createWriter($objPHPExcel, "Excel5"); $objWriter->save("php://output");
public function userExport() { $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $this->load->model('user_model'); $export_fields = $this->user_model->getFields(); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $export_fields['id'])->setCellValue('B1', $export_fields['name'])->setCellValue('C1', $export_fields['tel'])->setCellValue('D1', $export_fields['address'])->setCellValue('E1', $export_fields['type'])->setCellValue('F1', $export_fields['create_time'])->setCellValue('G1', $export_fields['create_ip']); $babies = $this->user_model->getAll(1000000000, 0); foreach ($babies as $key => $user) { $col = 0; foreach ($export_fields as $k => $v) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $key + 2, $user[$k]); $col++; } } $objPHPExcel->setActiveSheetIndex(0); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="users_' . date('ymd') . '.xls"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
/** * Create non-existing writer * * @expectedException \PhpOffice\PhpWord\Exception\Exception */ public function testNonexistentWriterCanNotBeCreated() { IOFactory::createWriter(new PhpWord(), 'Word2006'); }
function export_filtered($table_name, $filter1 = '', $filter2 = '', $filter3 = '') { if (sizeof(explode("_", $filter1)) != 1) { $filter1_exploded = explode("_", $filter1); $select_where = array("receipt_date >=" => $filter1_exploded[0], "receipt_date <=" => $filter1_exploded[1]); $filename = "SJ_Receipts_From_" . $filter1_exploded[0] . "_to_" . $filter1_exploded[1] . ".xls"; } else { $select_where = array("receipt_date" => $filter1); $filename = "SJ_Receipts_for_" . $filter1 . ".xls"; } if ($filter2 != "null") { $airlines = explode("-", $filter2); $this->db->where_in("airline", $airlines); } if ($filter3 != "null") { $this->db->where($agent, $filter3); } $this->db->select("id, airline, passenger_name, pnr, total_usd, payment_mode, currency, pos_amnt, cheque_no, receipt_no, receipt_date, coll, com, remarks, diff, tkt_agent"); $this->db->where($select_where); $query = $this->db->get($table_name); //,array('receipt_date >=' => $startdate,'receipt_date <='=>$enddate)); if (!$query) { return false; } // Starting the PHPExcel library $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("export")->setDescription("none"); $objPHPExcel->setActiveSheetIndex(0); // Field names in the first row $fields = $query->list_fields(); $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field); $col++; } // Fetching the table data $row = 2; foreach ($query->result() as $data) { $col = 0; foreach ($fields as $field) { $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->{$field}); $col++; } $row++; } $objPHPExcel->setActiveSheetIndex(0); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); // Sending headers to force the user to download the file header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $filename . '"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
/** * 区域用户导出 */ public function area_import() { $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); //要导出的数据 $aim = $this->session->area; //导出后第一行 $row = array('用户id', '姓名', '年龄', '身份证', '手机', '地址', '注册时间'); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getProperties()->setTitle("export")->setDescription("none"); foreach ($row as $key => $value) { $cwr = chr(65 + $key) . '1'; $objPHPExcel->getActiveSheet()->SetCellValue($cwr, $value); } /*"uid"]=> string(6) "123762" ["cell_phone"]=> string(11) "13822220003" ["idcard"]=> string(18) "330823191255550003" ["real_name"]=> string(9) "两句话" ["age"]=> string(1) "0" ["address"]=> string(0) "" ["reg_time"]=> string(10) "1441010603" }*/ foreach ($aim as $key => $value) { $arr[$key][] = $value['uid']; $arr[$key][] = $value['cell_phone']; $arr[$key][] = $value['idcard']; $arr[$key][] = $value['real_name']; $arr[$key][] = $value['age']; $arr[$key][] = $value['address']; $arr[$key][] = date('Y-m-d', $value['reg_time']); } $total = count($arr); //34 $cr = count($arr['0']); //获取每个数组有几个元素用来控制列 9 for ($i = 0; $i < $cr; $i++) { $cwr2 = chr(64 + $i + 1); for ($j = 2; $j < $total + 2; $j++) { $cwr = $cwr2 . $j; //abcdefg $objPHPExcel->getActiveSheet()->SetCellValue($cwr, ' ' . $arr[$j - 2][$i]); } } $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); //发送标题强制用户下载文件 $filename = '同一地区用户.xls'; header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); header("Content-Disposition:attachment;filename=" . $filename); header("Content-Transfer-Encoding:binary"); $objWriter->save('php://output'); }
/** * 学生报名信息核对 */ public function info_check() { if ($this->input->post('grade_id')) { $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $grade_id = intval($this->input->post('grade_id')); $school_id = intval($this->input->post('school_id')); if (!$grade_id) { message('请选择年级'); } if (!$school_id) { message('请选择学校'); } $file = $_FILES['infos']['name']; $desc = '../../cache/excel/' . $file; $tmp_name = $_FILES['infos']['tmp_name']; $extend = strrchr($file, '.'); if (!in_array($extend, array('.xlsx', '.xls'))) { message('文件类型不合法'); } if (!move_uploaded_file($tmp_name, $desc)) { message('文件移动失败,请联系管理员'); } $reader = new PHPExcel_Reader_Excel2007(); $reader_type = $extend == '.xlsx' ? 'Excel2007' : 'Excel5'; $obj = new IOFactory(); $objreader = $obj::createReader($reader_type)->load($desc); $sheet = $objreader->getSheet(0); $allRow = $sheet->getHighestRow(); $file2 = $file . '信息核对反馈表'; $objexcel = new PHPExcel(); $objexcel->setActiveSheetIndex(0)->setCellValue('A1', '姓名'); $objexcel->setActiveSheetIndex(0)->setCellValue('B1', '学号'); $objexcel->setActiveSheetIndex(0)->setCellValue('C1', '年级'); $objexcel->setActiveSheetIndex(0)->setCellValue('D1', '准考证号'); $objexcel->setActiveSheetIndex(0)->setCellValue('E1', '报名'); $objexcel->getActiveSheet()->setTitle($file2); $objwriter = IOFactory::createWriter($objexcel, $reader_type); for ($i = 2; $i <= $allRow; $i++) { $arr = array(); $student_name = $objreader->getActiveSheet()->getCell('A' . $i)->getValue(); $student_number = $objreader->getActiveSheet()->getCell('B' . $i)->getValue(); $student_grade = $objreader->getActiveSheet()->getCell('C' . $i)->getValue(); $space = " "; $student_name = str_ireplace($space, "", $student_name); $count = 0; $objexcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $student_name); $objexcel->setActiveSheetIndex(0)->setCellValue('B' . $i, $student_number); $objexcel->setActiveSheetIndex(0)->setCellValue('C' . $i, $student_grade); $student_search = array('school_id' => $school_id, 'grade_id' => $grade_id, 'keyword' => "CONCAT(last_name,first_name) LIKE '%" . trim($student_name) . "%'"); $student_list = CommonModel::get_list($student_search, 'rd_student', '*'); $number = count($student_list); if ($number) { if ($number > 1) { //2代表错误,一个学校一个年纪有多个重名学生情况 $objexcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '报名出错了(重名情况)'); $objexcel->setActiveSheetIndex(0)->setCellValue('E' . $i, 2); } else { $student_info = array_shift($student_list); $idcard = $student_info['idcard']; $objexcel->setActiveSheetIndex(0)->setCellValue('D' . $i, $student_info['exam_ticket']); $objexcel->setActiveSheetIndex(0)->setCellValue('E' . $i, 1); } } else { $objexcel->setActiveSheetIndex(0)->setCellValue('D' . $i, '未报名'); $objexcel->setActiveSheetIndex(0)->setCellValue('E' . $i, 0); } } $objwriter->save($desc); $data = array('url' => $desc, 'act' => 'update', 'name' => $file); } else { $grades = C('grades'); $data = array('act' => 'add', 'grades' => $grades); } $this->load->view('/student/info_check', $data); }
/** * * 导出会议室使用情况 */ public function export() { $data = array(); if (checkRight('room_used_export') === FALSE) { $this->showView('denied', $data); exit; } $this->load->model('MIS_Room'); $t = $this->input->get('t'); $info = $this->MIS_Room->getUsedList($t); $room_type = $this->config->item('room_type'); //加载PHPExcel库 require_once THIRD_PATH . 'PHPExcel.php'; require_once THIRD_PATH . 'PHPExcel/IOFactory.php'; $objPHPExcel = new PHPExcel(); //列宽 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(24); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(24); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(24); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(24); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(24); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(24); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(36); //第一行 $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(30); $objPHPExcel->getActiveSheet()->mergeCells('A1:H1'); $objPHPExcel->getActiveSheet()->setCellValue('A1', '创投大厦' . $room_type[$t] . '使用情况登记表'); $objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20); $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:H1')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //第二行 $objPHPExcel->getActiveSheet()->getRowDimension(2)->setRowHeight(20); $objPHPExcel->getActiveSheet()->setCellValue('A2', '序号'); $objPHPExcel->getActiveSheet()->setCellValue('B2', '日期 '); $objPHPExcel->getActiveSheet()->setCellValue('C2', '使用单位'); $objPHPExcel->getActiveSheet()->setCellValue('D2', '使用前电量'); $objPHPExcel->getActiveSheet()->setCellValue('E2', '使用后电量'); $objPHPExcel->getActiveSheet()->setCellValue('F2', '使用电量'); $objPHPExcel->getActiveSheet()->setCellValue('G2', '会议时长'); $objPHPExcel->getActiveSheet()->setCellValue('H2', '备注'); $objPHPExcel->getActiveSheet()->getStyle('A2:H2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A2:H2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A2:H2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $n = 3; foreach ($info as $k => $item) { $objPHPExcel->getActiveSheet()->getRowDimension($n)->setRowHeight(20); $objPHPExcel->getActiveSheet()->setCellValue('A' . $n, $k + 1); $objPHPExcel->getActiveSheet()->setCellValue('B' . $n, date('Y年m月d日', $item['start_time'])); $objPHPExcel->getActiveSheet()->setCellValue('C' . $n, $item['enterprise_name']); $objPHPExcel->getActiveSheet()->setCellValue('G' . $n, ($item['end_time'] - $item['start_time']) / 3600 . '小时'); $objPHPExcel->getActiveSheet()->getStyle("A{$n}:H{$n}")->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle("A{$n}:H{$n}")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle("A{$n}:H{$n}")->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $n++; } $objPHPExcel->getActiveSheet()->setTitle($room_type[$t] . '使用情况登记表'); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007'); $file_name = $room_type[$t] . "使用情况登记表_" . date("YmdHis") . ".xlsx"; header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $file_name . '"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output'); }
public function download($pkey, $method = "echo") { _has_user_access_permission(TRUE, array('admin')); $params = ($params = unserialize_object($pkey)) && is_array($params) ? $params : array(); $company_id = in_array($this->current_user->group_id, array(GROUP_ADMIN, GROUP_STAFF, GROUP_ENGINEER)) ? $this->_post_args('company_id', ARGS_TYPE_INT, array_key_exists(SYS_COMPANY_ID, $params) && gtzero_integer($params[SYS_COMPANY_ID]) ? to_int($params[SYS_COMPANY_ID]) : 0) : $this->current_user->company_id; $site_id = isset($params[SYS_SITE_ID]) && gtzero_integer($params[SYS_SITE_ID]) ? to_int($params[SYS_SITE_ID]) : 0; $redirect_url = $this->_post_args('redirect_url', ARGS_TYPE_STRING, $this->agent->referrer()); $site_statuses = array('' => '', 1 => 'OPEN', 2 => 'SUBMITTED', 3 => 'COMPLETED'); $site_info = $this->site_m->details($site_id, $company_id); if (!$site_info || _has_company_group_access($this->current_user->group_id) && $site_info->company_id != $this->current_user->company_id) { $this->show_permission_denied_error($method); } $company_id = in_array($this->current_user->group_id, array(GROUP_ADMIN, GROUP_STAFF, GROUP_ENGINEER)) ? $this->_post_args('company_id', ARGS_TYPE_INT, $site_info->company_id) : $this->current_user->company_id; $doc_key = $this->_post_args('doc_key', ARGS_TYPE_STRING) ? $this->_post_args('doc_key', ARGS_TYPE_STRING) : keygen(); $csrf = _get_csrf_nonce(); $headings = array("SITE", "FORM", "DATE ADDED", "ADDED BY", "STATUS", "DATE SUBMITTED", "SUBMITTED BY", "DATE COMPLETED", "COMPLETED BY"); $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); // Create a new PHPExcel object $objPHPExcel = new PHPExcel(); $objPHPExcel->getActiveSheet()->setTitle('List of Site Forms'); $rowNumber = 1; $col = 'A'; foreach ($headings as $heading) { $objPHPExcel->getActiveSheet()->setCellValue($col . $rowNumber, $heading); $col++; } // Loop through the result set $rowNumber = 2; foreach ($site_info->site_forms as $site_form) { $col = 'A'; $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, $site_info->site_code); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, $site_form->form_name); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, _validate_date($site_form->added_on, 'Y-m-d H:i:s') ? local_time($site_form->added_on, 'M d, Y @ h:ia') : ''); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, $site_form->added_by_name); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, $site_statuses[$site_form->status]); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, _validate_date($site_form->submitted_on, 'Y-m-d H:i:s') ? local_time($site_form->submitted_on, 'M d, Y @ h:ia') : ''); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, $site_form->submitted_by_name); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, _validate_date($site_form->completed_on, 'Y-m-d H:i:s') ? local_time($site_form->completed_on, 'M d, Y @ h:ia') : ''); $objPHPExcel->getActiveSheet()->setCellValue($col++ . $rowNumber, $site_form->completed_by_name); $rowNumber++; } $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); // We'll be outputting an excel file header('Content-type: application/vnd.ms-excel'); // It will be called file.xls header('Content-Disposition: attachment; filename="' . date('Ymd') . '.xls"'); // Write file to the browser $objWriter->save('php://output'); }
public function ExcelMethod($alldata, $size, $title, $ExcelTitle) { $objPHPExcel = new PHPExcel(); for ($i = 1; $i <= $size; $i++) { // 新建的objPHPExcel对象就已经新建的sheet对象 if ($i > 1) { //创建新的内置表 $objPHPExcel->createSheet(); } //把新创建的sheet设定为当前活动sheet $objPHPExcel->setActiveSheetIndex($i - 1); //获取当前活动sheet $objSheet = $objPHPExcel->getActiveSheet(); //set width $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30); // p($objSheet);die(); //给当前活动sheet起个名称 $objSheet->setTitle($title); //位置居中 $objSheet->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //设置excel文件默认水平垂直方向居中 //字体的设置 //$objSheet->getDefaultStyle()->getFont()->setSize(14)->setName("微软雅黑");//设置默认字体大小和格式 //填充数据 [固定的数据] $objSheet->setCellValue("A1", "序号")->setCellValue("B1", "座位")->setCellValue("C1", "学号")->setCellValue("D1", "姓名"); $j = 2; foreach ($alldata as $key => $value) { $objSheet->setCellValue("A" . $j, $j - 1)->setCellValue("B" . $j, $value['num'])->setCellValue("C" . $j, $value['idname'])->setCellValue("D" . $j, trim($value['username'])); $j++; } } // 困扰我一直的bug在这里 // 由于乱码的问题导致打不开Excel文件 ob_end_clean(); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007'); //在controller里面的方法的互相调用 $this->browser_export('Excel2007', $ExcelTitle . '.xlsx'); //输出到浏览器 $objWriter->save("php://output"); }
public function getExcel() { $result = $this->conn->CIT_SELECT($this->table); $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setTitle("title")->setDescription("description"); // Assign cell values $objPHPExcel->setActiveSheetIndex(0); $sheet = $objPHPExcel->getActiveSheet(); $sheet->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN))); $sheet->setShowGridlines(false); $sheet->getColumnDimension('A')->setWidth(10); $sheet->getColumnDimension('B')->setWidth(21.57); $sheet->getRowDimension('1')->setRowHeight(10); $sheet->setCellValue('A1', 'ID MANUFAKTUR'); $sheet->setCellValue('B1', 'NAMA MANUFAKTUR'); $counter = 2; foreach ($result as $row) { $sheet->setCellValue('A' . $counter, $row["manufakturID"]); $sheet->setCellValue('B' . $counter, $row["manufakturNama"]); $counter++; } // Save it as an excel 2003 file $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $filename = date('dmYHis') . "-manufaktur.xls"; $path = "./" . ASSETS . 'userfiles/' . $filename; $objWriter->save($path); $result = array(); $result = array("alert" => "<h4 class=\"alert_success\">FILE BERHASIL DI EXPORT. <a href=\"" . $path . "\">KLIK UNTUK MENGUNDUH FILE</a></h4>"); echo json_encode($result); //echo $filename; }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $kondisi = $this->input->get('kondisi'); if (!empty($kondisi)) { $kondisi = 'and s.type_id=' . $this->input->get('kondisi'); } $rpt = $this->input->get('rpt'); $tglawal = date('Y-m-d', strtotime($this->input->get('tglawal'))); $tglakhir = date('Y-m-d', strtotime($this->input->get('tglakhir'))); $tglawalbayar = date('Y-m-d', strtotime($this->input->get('tglawalbayar'))); $tglakhirbayar = date('Y-m-d', strtotime($this->input->get('tglakhirbayar'))); $tglcetak = date('Y-m-d', strtotime($this->input->get('tglcetak'))); $ignore_html_pg = TRUE; switch ($rpt) { case 'tap_register': case 'tap_register_airtanah': $type_id = intval($this->input->get('type_id')); if ($type_id > 0) { $kondisi = 'and s.type_id=' . $type_id; } else { $kondisi = ''; } $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali': case 'tap_kendali_blm_bayar': $type_id = intval($this->input->get('type_id')); if ($type_id > 0) { $kondisi = 'and s.type_id=' . $type_id; } else { $kondisi = ''; } $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali_self': case 'tap_kendali_self_sdh_bayar': // $kondisi = ' and s.type_id='.pad_dok_self_id(); $kondisi = ' and cd.usaha_id not in(' . pad_reklame_id() . ',' . pad_air_tanah_id() . ') '; $kondisi .= " and date(s.terimatgl) between '{$tglawal}' and '{$tglakhir}' "; $kondisi_bayar = " and date(ss.sspdtgl) between '{$tglawalbayar}' and '{$tglakhirbayar}' "; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi, 'kondisi_bayar' => $kondisi_bayar); break; case 'tap_kendali_blm_bayar_self': // $kondisi = 'and s.type_id='.pad_dok_self_id(); $kondisi = ' and cd.usaha_id not in(' . pad_reklame_id() . ',' . pad_air_tanah_id() . ') '; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali_airtanah': case 'tap_kendali_airtanah_sdh_bayar': $type_id = intval($this->input->get('type_id')); if ($type_id > 0) { $kondisi = 'and s.type_id=' . $type_id; } else { $kondisi = ''; } $kondisi .= " and date(k.kohirtgl) between '{$tglawal}' and '{$tglakhir}' "; $kondisi_bayar = " and date(ss.sspdtgl) between '{$tglawalbayar}' and '{$tglakhirbayar}' "; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi, 'kondisi_bayar' => $kondisi_bayar); break; case 'tap_kendali_airtanah_blm_bayar': $type_id = intval($this->input->get('type_id')); if ($type_id > 0) { $kondisi = 'and s.type_id=' . $type_id; } else { $kondisi = ''; } $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_register_reklame': $type_id = intval($this->input->get('type_id')); if ($type_id > 0) { $kondisi = 'and s.type_id=' . $type_id; } else { $kondisi = ''; } $naskah = trim($this->input->get('naskah')); $kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_register_reklame_jthtempo': $type_id = intval($this->input->get('type_id')); if ($type_id > 0) { $kondisi = 'and s.type_id=' . $type_id; } else { $kondisi = ''; } $naskah = trim($this->input->get('naskah')); $kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali_reklame': case 'tap_kendali_reklame_sdh_bayar': $insidentil = intval($this->input->get('insidentil')); $type_id = intval($this->input->get('type_id')); $kondisi = ''; if ($insidentil > -1) { $kondisi .= ' and r.insidentil=' . $insidentil; } if ($type_id > 0) { $kondisi .= ' and s.type_id=' . $type_id; } $naskah = trim($this->input->get('naskah')); $kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : ""; $kondisi .= " and date(k.kohirtgl) between '{$tglawal}' and '{$tglakhir}' "; $kondisi_bayar = " and date(ss.sspdtgl) between '{$tglawalbayar}' and '{$tglakhirbayar}' "; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi, 'kondisi_bayar' => $kondisi_bayar); // print_r($kondisi_bayar);exit; break; case 'tap_kendali_reklame_blm_bayar': $insidentil = intval($this->input->get('insidentil')); $type_id = intval($this->input->get('type_id')); $kondisi = ''; if ($insidentil > -1) { $kondisi .= ' and r.insidentil=' . $insidentil; } if ($type_id > 0) { $kondisi .= ' and s.type_id=' . $type_id; } $naskah = trim($this->input->get('naskah')); $kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali_reklame_jthtempo_tgl': $naskah = trim($this->input->get('naskah')); $kondisi = $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali_reklame_jthtempo': $naskah = trim($this->input->get('naskah')); $kondisi = $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'tap_kendali_reklame_jthtempo_rek': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'rekeningid' => (int) $this->input->get('rekeningid')); break; case 'tap_kendali_airtanah': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun')); break; case 'tap_kendali_airtanah_skpd': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'tap_kendali_airtanah_tgl': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'tap_kendali_airtanah_masa': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'tap_catat_vol_airtanah': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tahun' => (int) $this->input->get('tahun')); break; } $tambahan = array("daerah" => pad_pemda_daerah()); $params = array_merge($params, $tambahan); $ignore_html_pg = false; //paging aja semua $rpt = 'penetapan/' . $rpt; // var_dump($params); // die; $jasper = $this->load->library('Jasper'); if ($type == 'pdf') { echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); } else { if ($type == 'html') { $assetpath = 'assets/file'; $tmp = $assetpath . '/tmp/report' . sipkd_user_id() . '.html'; if (is_file($tmp)) { unlink($tmp); } ob_start(); echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); echo '1'; file_put_contents($tmp, ob_get_contents()); $objPHPExcel = new PHPExcel(); $inputFileType = 'HTML'; $inputFileName = $tmp; $outputFileType = 'Excel2007'; $outputFileName = $assetpath . '/Report.xls'; $filename = $rpt . date("d-m-Y") . ".xls"; $objPHPExcelReader = IOFactory::createReader($inputFileType); $objPHPExcel = $objPHPExcelReader->load($inputFileName); ini_set('zlib.output_compression', 'Off'); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); //the folowing two lines make sure it is saved as a xls file header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $filename); //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } } // echo $jasper->query_debug($rpt, $params); }
public function unduhexcel() { $objPHPExcel = new PHPExcel(); //array style $style_header = array('font' => array('bold' => true), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT), 'borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'top' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'right' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'left' => array('style' => PHPExcel_Style_Border::BORDER_THIN)), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR, 'rotation' => 90, 'startcolor' => array('argb' => 'FFA0A0A0'), 'endcolor' => array('argb' => 'FFFFFFFF'))); // Add some data $objset = $objPHPExcel->setActiveSheetIndex(0); //inisiasi set object $objget = $objPHPExcel->getActiveSheet(); //inisiasi get object // Merge cells $objPHPExcel->getActiveSheet()->mergeCells('A9:K9'); $objPHPExcel->getActiveSheet()->setCellValue('A9', "PENILAIAN PRESTASI KERJA"); $objPHPExcel->getActiveSheet()->getStyle('A9:K9')->getFont()->setName('Times New Roman'); $objPHPExcel->getActiveSheet()->getStyle('A9')->getFont()->setSize(14); $objPHPExcel->getActiveSheet()->getStyle('A9:K9')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('A9:K9')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->mergeCells('A10:K10'); $objPHPExcel->getActiveSheet()->setCellValue('A10', "PEGAWAI NEGERI SIPIL"); $objPHPExcel->getActiveSheet()->getStyle('A10:K10')->getFont()->setName('Times New Roman'); $objPHPExcel->getActiveSheet()->getStyle('A10')->getFont()->setSize(14); $objPHPExcel->getActiveSheet()->getStyle('A10:K10')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('A10:K10')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); // Nomor $objget->setCellValue('B16', '1.'); $objget->getStyle('B16')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B16:B21')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B16')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('B22', '2.'); $objget->getStyle('B22')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B22:B27')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B22')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('B28', '3.'); $objget->getStyle('B28')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B28:B33')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B28')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('B38', '4.'); $objget->getStyle('B38')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B38:B49')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B38')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C16', 'YANG DINILAI'); $objget->getStyle('C16')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C16')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(15); // set witdh colom $objget->getStyle('C16')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('C16:J16'); $objget->setCellValue('C22', 'PEJABAT PENILAI'); $objget->getStyle('C22')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C22')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(15); // set witdh colom $objget->getStyle('C22')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('C22:J22'); $objget->setCellValue('C28', 'ATASAN PEJABAT PENILAI'); $objget->getStyle('C28')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C28')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(15); // set witdh colom $objget->getStyle('C28')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('C28:J28'); $objget->setCellValue('C38', 'UNSUR YANG DINILAI'); $objget->getStyle('C38')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C38')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(15); // set witdh colom $objget->getStyle('C38')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('C38:I38'); $objget->setCellValue('J38', 'JUMLAH'); $objget->getStyle('J38')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J38')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(15); // set witdh colom $objget->getStyle('J38')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('J39', '53'); $objget->getStyle('J39')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J39')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(10); // set witdh colom $objget->getStyle('J39')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('J39:J40'); $objget->setCellValue('C17', 'a.'); $objget->getStyle('C17')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C17')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C17')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C18', 'b.'); $objget->getStyle('C18')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C18')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C18')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C19', 'c.'); $objget->getStyle('C19')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C19')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C19')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C20', 'd.'); $objget->getStyle('C20')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C20')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C20')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C21', 'e.'); $objget->getStyle('C21')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C21')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C21')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C23', 'a.'); $objget->getStyle('C23')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C23')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C23')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C24', 'b.'); $objget->getStyle('C24')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C24')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C24')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C25', 'c.'); $objget->getStyle('C25')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C25')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C25')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C26', 'd.'); $objget->getStyle('C26')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C26')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C26')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C27', 'e.'); $objget->getStyle('C27')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C27')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C27')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C29', 'a.'); $objget->getStyle('C29')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C29')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C29')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C30', 'b.'); $objget->getStyle('C30')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C30')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C30')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C31', 'c.'); $objget->getStyle('C31')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C31')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C31')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C32', 'd.'); $objget->getStyle('C32')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C32')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C32')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C33', 'e.'); $objget->getStyle('C33')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C33')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C33')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C39', 'a. Sasaran Kerja Pegawai/Nilai Prestasi Akademik'); $objget->getStyle('C39')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C39')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(10); // set witdh colom $objget->getStyle('C39')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('C39:I39'); $objPHPExcel->getActiveSheet()->mergeCells('C39:C40'); $objget->getStyle('C39')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('C41', 'b.'); $objget->getStyle('C41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('C41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('C')->setWidth(5); // set witdh colom $objget->getStyle('C41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('C41:C49'); $objget->setCellValue('D23', 'Nama'); $objget->getStyle('D23')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D23')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D23')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D23:F23'); $objget->setCellValue('D24', 'NIP'); $objget->getStyle('D24')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D24')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D24')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D24:F24'); $objget->setCellValue('D25', 'Pangkat, Golongan Ruang, TMT'); $objget->getStyle('D25')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D25')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D25')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D25:F25'); $objget->setCellValue('D26', 'Jabatan/Pekerjaan'); $objget->getStyle('D26')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D26')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D26')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D26:F26'); $objget->setCellValue('D27', 'Unit Organisasi'); $objget->getStyle('D27')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D27')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D27')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D27:F27'); $objget->setCellValue('D29', 'Nama'); $objget->getStyle('D29')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D29')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D29')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D29:F29'); $objget->setCellValue('D30', 'NIP'); $objget->getStyle('D30')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D30')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D30')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D30:F30'); $objget->setCellValue('D31', 'Pangkat, Golongan Ruang, TMT'); $objget->getStyle('D31')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D31')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D31')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D31:F31'); $objget->setCellValue('D32', 'Jabatan/Pekerjaan'); $objget->getStyle('D32')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D32')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D32')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D32:F32'); $objget->setCellValue('D33', 'Unit Organisasi'); $objget->getStyle('D33')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D33')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D33')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D33:F33'); $objget->setCellValue('D41', 'PRILAKU KERJA'); $objget->getStyle('D41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(20); // set witdh colom $objget->getStyle('D41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D41:D49'); $objget->setCellValue('D17', 'Nama'); $objget->getStyle('D17')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D17')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(10); // set witdh colom $objget->getStyle('D17')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D17:F17'); $objget->setCellValue('D18', 'NIP'); $objget->getStyle('D18')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D18')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(10); // set witdh colom $objget->getStyle('D18')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D18:F18'); $objget->setCellValue('D19', 'Pangkat, Golongan Ruang, TMT'); $objget->getStyle('D19')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D19')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(10); // set witdh colom $objget->getStyle('D19')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D19:F19'); $objget->setCellValue('D20', 'Jabatan/Pekerjaan'); $objget->getStyle('D20')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D20')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(10); // set witdh colom $objget->getStyle('D20')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D20:F20'); $objget->setCellValue('D21', 'Unit Organisasi'); $objget->getStyle('D21')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('D21')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('D')->setWidth(10); // set witdh colom $objget->getStyle('D21')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('D21:F21'); $objget->setCellValue('E41', '1.'); $objget->getStyle('E41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E42', '2.'); $objget->getStyle('E42')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E42')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E42')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E43', '3'); $objget->getStyle('E43')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E43')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E43')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E44', '4.'); $objget->getStyle('E44')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E44')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E44')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E45', '5.'); $objget->getStyle('E45')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E45')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E45')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E46', '6.'); $objget->getStyle('E46')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E46')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E46')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E47', '7.'); $objget->getStyle('E47')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E47')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E47')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E48', '8.'); $objget->getStyle('E48')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E48')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E48')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('E49', '9.'); $objget->getStyle('E49')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('E49')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('E')->setWidth(5); // set witdh colom $objget->getStyle('E49')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('F41', 'Orientasi Pelayanan'); $objget->getStyle('F41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F41:G41'); $objget->setCellValue('F42', 'Integritas'); $objget->getStyle('F42')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F42')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F42')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F42:G42'); $objget->setCellValue('F43', 'Komitmen'); $objget->getStyle('F43')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F43')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F43')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F43:G43'); $objget->setCellValue('F44', 'Disiplin'); $objget->getStyle('F44')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F44')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F44')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F44:G44'); $objget->setCellValue('F45', 'Kerjasama'); $objget->getStyle('F45')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F45')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F45')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F45:G45'); $objget->setCellValue('F46', 'Kepemimpinan'); $objget->getStyle('F46')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F46')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F46')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F46:G46'); $objget->setCellValue('F47', 'Jumlah'); $objget->getStyle('F47')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F47')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('E47')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F47:G47'); $objget->setCellValue('F48', 'Nilai Rata-rata'); $objget->getStyle('F48')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F48')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F48')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F48:G48'); $objget->setCellValue('F49', 'Nilai Perilaku Kerja'); $objget->getStyle('F49')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('F49')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('F')->setWidth(10); // set witdh colom $objget->getStyle('F49')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('F49:G49'); $objget->setCellValue('H41', '85.00'); $objget->getStyle('H41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H42', '85.00'); $objget->getStyle('H42')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H42')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H42')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H43', '85.00'); $objget->getStyle('H43')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H43')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H43')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H44', '85.00'); $objget->getStyle('H44')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H44')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H44')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H45', '85.00'); $objget->getStyle('H45')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H45')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H45')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H46', '85.00'); $objget->getStyle('H46')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H46')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H46')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H47', '85.00'); $objget->getStyle('H47')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H47')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H47')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H48', '85.00'); $objget->getStyle('H48')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H48')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H48')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('H49', '85.00'); $objget->getStyle('H49')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('H49')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('H')->setWidth(5); // set witdh colom $objget->getStyle('H49')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I41', ''); $objget->getStyle('I41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I42', ''); $objget->getStyle('I42')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I42')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I42')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I43', ''); $objget->getStyle('I43')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I43')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I43')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I44', ''); $objget->getStyle('I44')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I44')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I44')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I45', ''); $objget->getStyle('I45')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I45')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I45')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I46', ''); $objget->getStyle('I46')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I46')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I46')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I47', ''); $objget->getStyle('I47')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I47')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I47')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I48', ''); $objget->getStyle('I48')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I48')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I48')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('I49', 'X 40%'); $objget->getStyle('I49')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('I49')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('I')->setWidth(5); // set witdh colom $objget->getStyle('I49')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J41', ''); $objget->getStyle('J41')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J41')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J41')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J42', ''); $objget->getStyle('J42')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J42')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J42')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J43', ''); $objget->getStyle('J43')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J43')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J43')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J44', ''); $objget->getStyle('J44')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J44')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J44')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J45', ''); $objget->getStyle('J45')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J45')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J45')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J46', ''); $objget->getStyle('J46')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J46')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J46')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J47', ''); $objget->getStyle('J47')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J47')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J47')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J48', ''); $objget->getStyle('J48')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J48')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J48')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('J49', '34.00'); $objget->getStyle('J49')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J49')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J49')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('G17', ''); $objget->getStyle('G17')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G17')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G17')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G17:J17'); $objget->setCellValue('G18', ''); $objget->getStyle('G18')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G18')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G18')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G18:J18'); $objget->setCellValue('G19', ''); $objget->getStyle('G19')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G19')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G19')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G19:J19'); $objget->setCellValue('G20', ''); $objget->getStyle('G20')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G20')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G20')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G20:J20'); $objget->setCellValue('G21', ''); $objget->getStyle('G21')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G21')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G21')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G21:J21'); $objget->setCellValue('G23', ''); $objget->getStyle('G23')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G23')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G23')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G23:J23'); $objget->setCellValue('G24', ''); $objget->getStyle('G24')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G24')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G24')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G24:J24'); $objget->setCellValue('G25', ''); $objget->getStyle('G25')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G25')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G25')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G25:J25'); $objget->setCellValue('G26', ''); $objget->getStyle('G26')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G26')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G26')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G26:J26'); $objget->setCellValue('G27', ''); $objget->getStyle('G27')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G27')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G27')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G27:J27'); $objget->setCellValue('G29', ''); $objget->getStyle('G29')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G29')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G29')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G29:J29'); $objget->setCellValue('G30', ''); $objget->getStyle('G30')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G30')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G30')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G30:J30'); $objget->setCellValue('G31', ''); $objget->getStyle('G31')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G31')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G31')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G31:J31'); $objget->setCellValue('G32', ''); $objget->getStyle('G32')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G32')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G32')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G32:J32'); $objget->setCellValue('G33', ''); $objget->getStyle('G33')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('G33')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('G')->setWidth(10); // set witdh colom $objget->getStyle('G33')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('G33:J33'); $objget->setCellValue('B50', 'NILAI PRESTASI KERJA'); $objget->getStyle('B50')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B50')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B50')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objPHPExcel->getActiveSheet()->mergeCells('B50:I50'); $objPHPExcel->getActiveSheet()->mergeCells('B50:B53'); $objget->setCellValue('J51', '87.86 (BAIK)'); $objget->getStyle('J51')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('J50:J53')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('J')->setWidth(10); // set witdh colom $objget->getStyle('J51')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00); $objget->setCellValue('B55', '5.'); $objget->setCellValue('C55', 'KEBERATAN DARI PEGAWAI NEGERI SIPIL'); $objget->setCellValue('C56', 'YANG DINILAI (APABILA ADA)'); $objget->setCellValue('F60', 'Tanggal, .......'); $objget->getStyle('B54')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B54:J61')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B54')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('B69', '6'); $objget->setCellValue('C69', 'TANGGAPAN PEJABAT PENILAI'); $objget->setCellValue('C70', 'ATAS KEBERATAN )'); $objget->setCellValue('I78', 'Tanggal, .......'); $objget->getStyle('B69')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B69:J81')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B69')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('B83', '7.'); $objget->setCellValue('C83', 'KEPUTUSAN ATASAN PEJABAT'); $objget->setCellValue('C84', 'PENILAI ATAS KEBERATAN )'); $objget->setCellValue('I89', 'Tanggal, .......'); $objget->getStyle('B82')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B82:J92')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B82')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('B101', '8.'); $objget->setCellValue('C101', 'REKOMENDASI'); $objget->setCellValue('I110', 'Tanggal, .......'); $objget->getStyle('B100')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B100:J113')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('B100')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->setCellValue('G116', '9. DIBUAT TANGGAL, .........'); $objget->setCellValue('G117', 'PEJABAT PENILAI'); $objget->setCellValue('G122', 'Dra. Indriyati, MM'); $objget->setCellValue('G123', '195710231984032001'); $objget->setCellValue('B124', '10. DITERIMA TANGGAL, .........'); $objget->setCellValue('C125', 'PEGAWAI NEGERI SIPIL YANG'); $objget->setCellValue('D126', 'DINILAI'); $objget->setCellValue('D130', 'Drs Zulkifli., M.Si'); $objget->setCellValue('D131', '196802291994031001'); $objget->setCellValue('G133', '10. DITERIMA TANGGAL, …………………'); $objget->setCellValue('G134', 'ATASAN PEJABAT YANG MENILAI'); $objget->setCellValue('G138', 'Mochamad Teguh Pamudji, SH, MH'); $objget->setCellValue('G139', '195711121980031000'); $objget->getStyle('B114')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objget->getStyle('B114:J140')->applyFromArray($style_header); // set font weight $objget->getColumnDimension('B')->setWidth(10); // set witdh colom $objget->getStyle('G123')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->getStyle('D131')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $objget->getStyle('G139')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sharedStyle1 = new PHPExcel_Style(); $sharedStyle2 = new PHPExcel_Style(); $sharedStyle1->applyFromArray(array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'top' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'right' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'left' => array('style' => PHPExcel_Style_Border::BORDER_THIN)))); $sharedStyle2->applyFromArray(array('borders' => array('bottom' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'top' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'right' => array('style' => PHPExcel_Style_Border::BORDER_THIN), 'left' => array('style' => PHPExcel_Style_Border::BORDER_THIN)))); //Merge cell $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "B53:I53"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "B50:B53"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C16:J16"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C22:J22"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C28:J28"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C38:I38"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C39:I39"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C40:I40"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C39:C40"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "C41:C49"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F41:G41"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F42:G42"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F43:G43"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F44:G44"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F45:G45"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F46:G46"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F47:G47"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F48:G48"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "F49:G49"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "J38"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "J39"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "J39:J40"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D17:F17"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D18:F18"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D19:F19"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D20:F20"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D23:F23"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D24:F24"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D25:F25"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D26:F26"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D27:F27"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D29:F29"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D30:F30"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D31:F31"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D32:F32"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D33:F33"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D41:D49"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "D21:F21"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G17:J17"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G18:J18"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G19:J19"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G20:J20"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G21:J21"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G23:J23"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G24:J24"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G25:J25"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G26:J26"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G27:J27"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G29:J29"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G30:J30"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G31:J31"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G32:J32"); $objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1, "G33:J33"); // Rename sheet $objPHPExcel->getActiveSheet()->setTitle('Simple'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="DataPenilaianSKP.xls"'); header('Cache-Control: max-age=0'); $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $rpt = $this->input->get('rpt'); $ignore_html_pg = TRUE; switch ($rpt) { case 'dat_sptpd_masuk': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cd.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'dat_sptpd_masuk_masa': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cd.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_sptpd_masuk_tgl_all': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'dat_sptpd_masuk_masa_all': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun')); break; case 'dat_sptpd_blm_masuk_masa': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cu.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_sptpd_blm_masuk_masa_all': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun')); break; case 'dat_srt_pemberitahuan': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cu.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_srt_teguran': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cu.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_srt_teguran_global': $ignore_html_pg = FALSE; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usahaid' => (int) $this->input->get('usahaid')); break; } $tambahan = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "ttd" => base_url('assets/img/ttd.gif')); $params = array_merge($params, $tambahan); $ignore_html_pg = FALSE; //paging aja semua $rpt = 'pendataan/' . $rpt; $jasper = $this->load->library('Jasper'); if ($type == 'pdf') { echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); } else { if ($type == 'html') { $assetpath = 'assets/file'; $tmp = $assetpath . '/tmp/report' . sipkd_user_id() . '.html'; if (is_file($tmp)) { unlink($tmp); } ob_start(); echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); echo '1'; file_put_contents($tmp, ob_get_contents()); $objPHPExcel = new PHPExcel(); $inputFileType = 'HTML'; $inputFileName = $tmp; $outputFileType = 'Excel2007'; $outputFileName = $assetpath . '/Report.xls'; $filename = $rpt . date("d-m-Y") . ".xls"; $objPHPExcelReader = IOFactory::createReader($inputFileType); $objPHPExcel = $objPHPExcelReader->load($inputFileName); ini_set('zlib.output_compression', 'Off'); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); //the folowing two lines make sure it is saved as a xls file header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $filename); //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } } }
function download($spt_id) { $wp_id = $this->session->userdata('wp_id'); $customer_id = 0; //init $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("E-SPTPD KOTA TANGERANG")->setTitle("LAPORAN OMSET"); //file title $objset = $objPHPExcel->setActiveSheetIndex(0); //inisiasi set object $objget = $objPHPExcel->getActiveSheet(); //inisiasi get object $objget->setTitle('Sample Sheet'); //sheet title $objset->setCellValue('A1', "LAPORAN OMSET BULANAN"); //insert cell value $objget->getStyle('A1')->getFont()->setBold(true)->setSize(15); //set font size //query $query = $this->db->query("select c.id as customer_id, c.wpnama as pemiliknm, c.nama as customernm, c.alamat as customeralamat, get_sptpdno(s.id), get_nopd(cu.id,true) nopd, cu.opnm,\r\n get_npwpd(c.id,true) npwpd, u.nama as usahanm, p.nama as pajaknm, get_rekening(r.kode) as rekeningkd, r.nama as rekeningnm,\r\n get_bayarno(s.id,'pad_spt') as bayarno, s.tahun, s.id, s.customer_id, s.customer_usaha_id, s.pajak_id, ROW_NUMBER() OVER (ORDER BY urut) as nomor, urut, omset, keterangan,\r\n case\r\n when urut = 32 then 'Lainnya'\r\n when urut <> 32 then urut::text end no_urut,\r\n\r\n case\r\n when extract(month from s.masadari)=1 then 'JANUARI'\r\n when extract(month from s.masadari)=2 then 'PEBRUARI'\r\n when extract(month from s.masadari)=3 then 'MARET'\r\n when extract(month from s.masadari)=4 then 'APRIL'\r\n when extract(month from s.masadari)=5 then 'MEI'\r\n when extract(month from s.masadari)=6 then 'JUNI'\r\n when extract(month from s.masadari)=7 then 'JULI'\r\n when extract(month from s.masadari)=8 then 'AGUSTUS'\r\n when extract(month from s.masadari)=9 then 'SEPTEMBER'\r\n when extract(month from s.masadari)=10 then 'OKTOBER'\r\n when extract(month from s.masadari)=11 then 'NOPEMBER'\r\n when extract(month from s.masadari)=12 then 'DESEMBER'\r\n end masabulan,\r\n\r\n extract(year from s.masadari) masatahun,\r\n\r\n extract(day from current_timestamp) terimatgl,\r\n case\r\n when extract(dow from current_timestamp)=0 then 'Minggu'\r\n when extract(dow from current_timestamp)=1 then 'Senin'\r\n when extract(dow from current_timestamp)=2 then 'Selasa'\r\n when extract(dow from current_timestamp)=3 then 'Rabu'\r\n when extract(dow from current_timestamp)=4 then 'Kamis'\r\n when extract(dow from current_timestamp)=5 then 'Jumat'\r\n when extract(dow from current_timestamp)=6 then 'Sabtu'\r\n else 'Hari ###'\r\n end terimahari,\r\n\r\n case\r\n when extract(month from current_timestamp)=1 then 'Januari'\r\n when extract(month from current_timestamp)=2 then 'Pebruari'\r\n when extract(month from current_timestamp)=3 then 'Maret'\r\n when extract(month from current_timestamp)=4 then 'April'\r\n when extract(month from current_timestamp)=5 then 'Mei'\r\n when extract(month from current_timestamp)=6 then 'Juni'\r\n when extract(month from current_timestamp)=7 then 'Juli'\r\n when extract(month from current_timestamp)=8 then 'Agustus'\r\n when extract(month from current_timestamp)=9 then 'September'\r\n when extract(month from current_timestamp)=10 then 'Oktober'\r\n when extract(month from current_timestamp)=11 then 'Nopember'\r\n when extract(month from current_timestamp)=12 then 'Desember'\r\n end terimabulan,\r\n extract(year from current_timestamp) terimatahun\r\n\r\n\r\n from\r\n (\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 1 as urut, omset1 as omset, keterangan1 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 2 as urut, omset2 as omset, keterangan2 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 3 as urut, omset3 as omset, keterangan3 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 4 as urut, omset4 as omset, keterangan4 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 5 as urut, omset5 as omset, keterangan5 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 6 as urut, omset6 as omset, keterangan6 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 7 as urut, omset7 as omset, keterangan7 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 8 as urut, omset8 as omset, keterangan8 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 9 as urut, omset9 as omset, keterangan9 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 10 as urut, omset10 as omset, keterangan10 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 11 as urut, omset11 as omset, keterangan11 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 12 as urut, omset12 as omset, keterangan12 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 13 as urut, omset13 as omset, keterangan13 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 14 as urut, omset14 as omset, keterangan14 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 15 as urut, omset15 as omset, keterangan15 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 16 as urut, omset16 as omset, keterangan16 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 17 as urut, omset17 as omset, keterangan17 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 18 as urut, omset18 as omset, keterangan18 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 19 as urut, omset19 as omset, keterangan19 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 20 as urut, omset20 as omset, keterangan20 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 21 as urut, omset21 as omset, keterangan21 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 22 as urut, omset22 as omset, keterangan22 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 23 as urut, omset23 as omset, keterangan23 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 24 as urut, omset24 as omset, keterangan24 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 25 as urut, omset25 as omset, keterangan25 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 26 as urut, omset26 as omset, keterangan26 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 27 as urut, omset27 as omset, keterangan27 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 28 as urut, omset28 as omset, keterangan28 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 29 as urut, omset29 as omset, keterangan29 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 30 as urut, omset30 as omset, keterangan30 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 31 as urut, omset31 as omset, keterangan31 as keterangan from pad_spt\r\n union\r\n select id, customer_id, customer_usaha_id, pajak_id, masadari, tahun, 32 as urut, omset_lain as omset, keterangan_lain as keterangan from pad_spt\r\n ) s\r\n inner join pad_customer_usaha cu on cu.id=s.customer_usaha_id\r\n inner join pad_customer c on c.id=cu.customer_id\r\n inner join pad_kecamatan kec on kec.id=c.kecamatan_id\r\n inner join pad_kelurahan kel on kel.id=c.kelurahan_id and kel.kecamatan_id=c.kecamatan_id\r\n inner join pad_usaha u on u.id=cu.usaha_id\r\n inner join pad_jenis_pajak p on p.id=s.pajak_id\r\n inner join pad_rekening r on p.rekening_id=r.id\r\n where s.id={$spt_id} \r\n order by s.id, s.urut"); $objset->setCellValue('B3', 'Bulan'); $objset->setCellValue('B4', 'NOPD'); $objset->setCellValue('B5', 'Usaha'); $objset->setCellValue('B6', 'Perusahaan'); $objset->setCellValue('B7', 'Alamat'); $objset->setCellValue('C42', 'JUMLAH'); $objset->setCellValue('D42', '=SUM(D10:D41)'); $objget->getStyle('C42')->getFont()->setBold(true); $objget->getStyle('D42')->getFont()->setBold(true); foreach ($query->result() as $row) { $objset->setCellValue('D3', $row->masabulan . ' ' . $row->masatahun); $objset->setCellValue('D4', $row->nopd); $objset->setCellValue('D5', $row->usahanm); $objset->setCellValue('D6', $row->customernm); $objset->setCellValue('D7', $row->customeralamat); break; } //table header $cols = array("B", "C", "D", "E"); $val = array("No", "Tanggal", "Jumlah Omset(Rp.)", "Keterangan"); for ($a = 0; $a < 4; $a++) { $objset->setCellValue($cols[$a] . '9', $val[$a]); //set borders $objget->getStyle($cols[$a] . '9')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '9')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '9')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($cols[$a] . '9')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //set alignment $objget->getStyle($cols[$a] . '9')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //set font weight $objget->getStyle($cols[$a] . '9')->getFont()->setBold(true); $objget->getColumnDimension('D')->setWidth(20); $objget->getColumnDimension('E')->setWidth(30); } //taruh baris data disini $colsb = array("B", "C", "D", "E"); $i = 10; // baris ke foreach ($query->result() as $row) { if ($row->urut == 32) { $urut = 'Lainnya'; } else { $urut = $row->urut; } $valb = array($row->nomor, $urut, $row->omset, $row->keterangan); for ($b = 0; $b < 4; $b++) { $objset->setCellValue($colsb[$b] . $i, $valb[$b]); $objget->getStyle($colsb[$b] . $i)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($colsb[$b] . $i)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($colsb[$b] . $i)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objget->getStyle($colsb[$b] . $i)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); } $i = $i + 1; $customer_id = $row->customer_id; } if ($customer_id == $wp_id) { //cegah id lain download $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('assets/file/omsetxls/OmsetBulananID' . $wp_id . '.xls'); //simpan dalam file sample.xls sleep(3); //Save dulu $data = file_get_contents('assets/file/omsetxls/OmsetBulananID' . $wp_id . '.xls'); // Read the file's contents $name = 'Laporan Omset Bulanan.xls'; force_download($name, $data); } else { echo "<h1>ACCESS FORBIDDEN</h1>"; } }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $kondisi = ''; $status = $this->input->get('kondisi'); if ($status != '') { $kondisi = "AND cd.customer_status_id={$status}"; } $rpt = $this->input->get('rpt'); switch ($rpt) { case 'daf_induk_wp': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'kondisi' => $kondisi); break; case 'daf_induk_wp_perjenis': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usahaid' => (int) $this->input->get('usahaid'), 'kondisi' => $kondisi); break; case 'daf_induk_wp_perkec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'kecid' => (int) $this->input->get('kecid'), 'kondisi' => $kondisi); break; case 'daf_wp_baru': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'daf_wp_baru_jenis': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'usahaid' => (int) $this->input->get('usahaid'), 'kondisi' => $kondisi); break; case 'daf_wp_baru_kec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kecid' => (int) $this->input->get('kecid'), 'kondisi' => $kondisi); break; case 'daf_wp_jenis_perkec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usahaid' => (int) $this->input->get('usahaid'), 'kondisi' => $kondisi); break; case 'daf_wp_tutup': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'daf_wp_ijin_berakhir': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'daf_rekap_kec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak')))); break; } $tambahan = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama()); $params = array_merge($params, $tambahan); $rpt = 'pendaftaran/' . $rpt; // var_dump($params); // die; $jasper = $this->load->library('Jasper'); //IF PDF if ($type == 'pdf') { echo $jasper->cetak($rpt, $params, $type, false); } else { if ($type == 'html') { $assetpath = 'assets/file'; $tmp = $assetpath . '/tmp/report' . sipkd_user_id() . '.html'; if (is_file($tmp)) { unlink($tmp); } ob_start(); echo $jasper->cetak($rpt, $params, $type, false); echo '1'; file_put_contents($tmp, ob_get_contents()); $objPHPExcel = new PHPExcel(); $inputFileType = 'HTML'; $inputFileName = $tmp; $outputFileType = 'Excel2007'; $outputFileName = $assetpath . '/Report.xls'; $filename = $rpt . date("d-m-Y") . ".xls"; $objPHPExcelReader = IOFactory::createReader($inputFileType); $objPHPExcel = $objPHPExcelReader->load($inputFileName); ini_set('zlib.output_compression', 'Off'); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); //the folowing two lines make sure it is saved as a xls file header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $filename); //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } } }
$xls->getActiveSheet()->getStyle("F{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("G{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("H{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("I{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("J{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("K{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("L{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("M{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("N{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("O{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("P{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("Q{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("R{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("S{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("T{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("U{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("V{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("W{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("X{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("Y{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("Z{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("AA{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("AB{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("AC{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("AD{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("A{$i}:AD{$i}")->getFont()->setBold(true); $xls->getActiveSheet()->getRowDimension($i)->setRowHeight(25); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="R.Askes_' . $bulan . '_' . $tahun . '.xls"'); $objWriter = IOFactory::createWriter($xls, "Excel5"); $objWriter->save("php://output");
/** * 我的交易记录 */ public function deal_record() { //导入类库 $this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory'); //导出的是投标列表 $list = $this->session->userdata('deallist'); //设置excel表格标题行 $row = array(); $row[0] = array('交易时间', '交易类型', '影响金额', '代收金额', '说明', '可用余额'); $objPHPExcel = new PHPExcel(); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getProperties()->setTitle("export")->setDescription("none"); foreach ($row[0] as $key => $value) { $cwr = chr(65 + $key) . '1'; $objPHPExcel->getActiveSheet()->SetCellValue($cwr, $value); } foreach ($list as $key => $value) { $arr[$key][] = $value['date']; $arr[$key][] = $value['type']; $arr[$key][] = $value['affect_money']; $arr[$key][] = $value['collect_money']; $arr[$key][] = $value['desc']; $arr[$key][] = $value['account_money']; } $total = count($arr); //34 $cr = count($arr['0']); //获取每个数组有几个元素用来控制列 9 for ($i = 0; $i < $cr; $i++) { $cwr2 = chr(64 + $i + 1); for ($j = 2; $j < $total + 2; $j++) { $cwr = $cwr2 . $j; //abcdefg $objPHPExcel->getActiveSheet()->SetCellValue($cwr, $arr[$j - 2][$i]); } } $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); //发送标题强制用户下载文件 $filename = '交易记录.xls'; header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); header("Content-Disposition:attachment;filename=" . $filename); header("Content-Transfer-Encoding:binary"); $objWriter->save('php://output'); }