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');
}
