function getNamaIzin($jenisIzin)
{
$tabel = getTabelJenisPerizinan();
return $tabel[$jenisIzin];
}
<select id="per_kecamatan" name="per_kecamatan" class="form-control input-sm">
<option value="yes">Yes</option>
<option value="no">No</option>
</select>
</td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td>Jenis Perizinan</td>
<td>:</td>
<td>
<select class="form-control input-sm" id="jenis_perizinan" name="jenis_perizinan" required="required">
<?php
foreach (getTabelJenisPerizinan() as $key => $value) {
?>
<option value="<?php
echo $key;
?>
"><?php
echo $value;
?>
</option>
<?php
}
?>
</select>
</td>
<td></td>
<td width="300px"> <button type="button" id="filter_data" class="btn btn-info"><span class="fa fa-search"> Cari</span></button> <button type="button" id="preview_data" class="btn btn-success"><span class="fa fa-print"></span></button> <button type="button" id="export_data" class="btn btn-primary"><span class="fa fa-file-word-o"></span></button></td>
function downloadWord($jp)
{
$data['jenis_perizinan'] = $jp;
$data['tgl_awal'] = convert_tgl($this->input->get('tgl_awal'));
$data['tgl_akhir'] = convert_tgl($this->input->get('tgl_akhir'));
$data['tgl_bulan'] = $this->input->get('tgl_bulan');
$data['per_type'] = $this->input->get('per_type');
$data['per_kec'] = $this->input->get('per_kecamatan');
$data['filter_type'] = $this->input->get('filter_type');
//$data['results'] = $this->m_jenisizin->getData($data['jenis_perizinan'], $data['tgl_awal'], $data['tgl_akhir'], $data['tgl_bulan'],$data['filter_type']);
$data['typeIzin'] = getTypeIzin($data['jenis_perizinan']);
$data['nameIzin'] = getTabelJenisPerizinan()[$data['jenis_perizinan']];
$data['listKecamatan'] = $this->m_global->getKecamatan();
//debugy($data);
$columns = array();
$columns[KEY_COLUMN_ID] = getColumnNameID($data['jenis_perizinan']);
$columns[KEY_COLUMN_TYPE] = getColumnNameType($data['jenis_perizinan']);
$data['type'] = '';
$data['results'] = $this->m_jenisizin->getAllData($data['jenis_perizinan'], $columns, $data['tgl_awal'], $data['tgl_akhir'], $data['tgl_bulan'], $data['filter_type'], $data['per_type'], $data['per_kec']);
$data['row_total'] = count($data['results']);
$data['row_start'] = 1;
$data = mergeReportData($data, $columns);
$this->load->library('word');
// prepare template
if ($data['per_type'] == 'yes' && $data['per_kec'] == 'yes') {
$templateProcessor = new \PhpOffice\PhpWord\Template('./templates/Report_Per_Type_Template.docx');
} else {
if ($data['per_type'] == 'yes' || $data['per_kec'] == 'yes') {
$templateProcessor = new \PhpOffice\PhpWord\Template('./templates/Report_Per_Type_Template.docx');
} else {
$templateProcessor = new \PhpOffice\PhpWord\Template('./templates/Report_Template.docx');
}
}
// fill header
$templateProcessor->setValue('bidang', 'PERIZINAN USAHA');
$templateProcessor->setValue('periode_title', strtoupper($data['filter_type']));
if ($data['filter_type'] == 'bulan') {
$templateProcessor->setValue('periode', convert_to_id_month($data['tgl_bulan']));
} else {
$templateProcessor->setValue('periode', convert_to_id($data['tgl_awal']) . ' s/d ' . convert_to_id($data['tgl_akhir']));
}
$templateProcessor->setValue('jenis_izin', $data['nameIzin']);
$templateProcessor->setValue('jumlah_pelayanan_all', $data['row_total']);
//write report
if ($data['per_type'] == 'yes' && $data['per_kec'] == 'yes') {
$templateProcessor->cloneBlock('CLONEME', count($data['results']));
$parent_index = 1;
foreach ($data['results'] as $result) {
//add index on cloned var
$templateProcessor->setValue('block_name', '${block_name#' . $parent_index . '}', 1);
$templateProcessor->setValue('block_title', '${block_title#' . $parent_index . '}', 1);
$templateProcessor->setValue('jumlah_pelayanan', '${jumlah_pelayanan#' . $parent_index . '}', 1);
$templateProcessor->setValue('kecamatan_title', '${kecamatan_title#' . $parent_index . '}', 1);
$templateProcessor->setValue('no', '${no#' . $parent_index . '}', 1);
$templateProcessor->setValue('tanggal', '${tanggal#' . $parent_index . '}', 1);
$templateProcessor->setValue('nomor', '${nomor#' . $parent_index . '}', 1);
$templateProcessor->setValue('perusahaan', '${perusahaan#' . $parent_index . '}', 1);
$templateProcessor->setValue('pemohon', '${pemohon#' . $parent_index . '}', 1);
$templateProcessor->setValue('alamat', '${alamat#' . $parent_index . '}', 1);
$templateProcessor->setValue('kota', '${kota#' . $parent_index . '}', 1);
$templateProcessor->setValue('kecamatan', '${kecamatan#' . $parent_index . '}', 1);
$templateProcessor->setValue('keterangan', '${keterangan#' . $parent_index . '}', 1);
//fill data on cloned var
$templateProcessor->setValue('block_title#' . $parent_index, $data['title']);
$templateProcessor->setValue('block_name#' . $parent_index, $result['name']);
$templateProcessor->setValue('jumlah_pelayanan#' . $parent_index, $result['count']);
// $templateProcessor->cloneRow('kecamatan_title#'.$parent_index, $result['count']);
$templateProcessor->cloneRow('no#' . $parent_index, $result['count'] + count($result['data']));
$parent_kec_index = 1;
$index_row = 1;
foreach ($result['data'] as $child) {
$templateProcessor->setValue('no#' . $parent_index . '#' . $index_row, $child['name']);
$templateProcessor->setValue('tanggal#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('nomor#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('perusahaan#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('pemohon#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('alamat#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('kota#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('kecamatan#' . $parent_index . '#' . $index_row, '');
$templateProcessor->setValue('keterangan#' . $parent_index . '#' . $index_row, '');
$index = 1;
$index_row++;
foreach ($child['data'] as $row) {
$templateProcessor->setValue('no#' . $parent_index . '#' . $index_row, $index);
$templateProcessor->setValue('tanggal#' . $parent_index . '#' . $index_row, convert_to_id($row['tgl_pembuatan'], FALSE));
$templateProcessor->setValue('nomor#' . $parent_index . '#' . $index_row, $row['no_pelayanan']);
$templateProcessor->setValue('perusahaan#' . $parent_index . '#' . $index_row, $row['nama_perusahaan']);
$templateProcessor->setValue('pemohon#' . $parent_index . '#' . $index_row, $row['penanggung_jawab']);
$templateProcessor->setValue('alamat#' . $parent_index . '#' . $index_row, $row['alamat']);
$templateProcessor->setValue('kota#' . $parent_index . '#' . $index_row, $row['kota']);
$templateProcessor->setValue('kecamatan#' . $parent_index . '#' . $index_row, $row['nama_kecamatan']);
$templateProcessor->setValue('keterangan#' . $parent_index . '#' . $index_row, 'Non Retribusi');
$index++;
$index_row++;
}
$parent_kec_index++;
}
$parent_index++;
}
// break;
} else {
if ($data['per_type'] == 'yes' || $data['per_kec'] == 'yes') {
$templateProcessor->cloneBlock('CLONEME', count($data['results']));
$parent_index = 1;
foreach ($data['results'] as $result) {
//add index on cloned var
$templateProcessor->setValue('block_name', '${block_name#' . $parent_index . '}', 1);
$templateProcessor->setValue('block_title', '${block_title#' . $parent_index . '}', 1);
$templateProcessor->setValue('jumlah_pelayanan', '${jumlah_pelayanan#' . $parent_index . '}', 1);
$templateProcessor->setValue('no', '${no#' . $parent_index . '}', 1);
$templateProcessor->setValue('tanggal', '${tanggal#' . $parent_index . '}', 1);
$templateProcessor->setValue('nomor', '${nomor#' . $parent_index . '}', 1);
$templateProcessor->setValue('perusahaan', '${perusahaan#' . $parent_index . '}', 1);
$templateProcessor->setValue('pemohon', '${pemohon#' . $parent_index . '}', 1);
$templateProcessor->setValue('alamat', '${alamat#' . $parent_index . '}', 1);
$templateProcessor->setValue('kota', '${kota#' . $parent_index . '}', 1);
$templateProcessor->setValue('kecamatan', '${kecamatan#' . $parent_index . '}', 1);
$templateProcessor->setValue('keterangan', '${keterangan#' . $parent_index . '}', 1);
//fill data on cloned var
$templateProcessor->setValue('block_title#' . $parent_index, $data['title']);
$templateProcessor->setValue('block_name#' . $parent_index, $result['name']);
$templateProcessor->setValue('jumlah_pelayanan#' . $parent_index, $result['count']);
$templateProcessor->cloneRow('no#' . $parent_index, $result['count']);
$index = 1;
foreach ($result['data'] as $row) {
$templateProcessor->setValue('no#' . $parent_index . '#' . $index, $index);
$templateProcessor->setValue('tanggal#' . $parent_index . '#' . $index, convert_to_id($row['tgl_pembuatan'], FALSE));
$templateProcessor->setValue('nomor#' . $parent_index . '#' . $index, $row['no_pelayanan']);
$templateProcessor->setValue('perusahaan#' . $parent_index . '#' . $index, $row['nama_perusahaan']);
$templateProcessor->setValue('pemohon#' . $parent_index . '#' . $index, $row['penanggung_jawab']);
$templateProcessor->setValue('alamat#' . $parent_index . '#' . $index, $row['alamat']);
$templateProcessor->setValue('kota#' . $parent_index . '#' . $index, $row['kota']);
$templateProcessor->setValue('kecamatan#' . $parent_index . '#' . $index, $row['nama_kecamatan']);
$templateProcessor->setValue('keterangan#' . $parent_index . '#' . $index, 'Non Retribusi');
$index++;
}
$parent_index++;
}
} else {
$templateProcessor->cloneRow('no', $data['row_total']);
$index = 1;
foreach ($data['results'] as $row) {
$templateProcessor->setValue('no#' . $index, $index);
$templateProcessor->setValue('tanggal#' . $index, convert_to_id($row['tgl_pembuatan'], FALSE));
$templateProcessor->setValue('nomor#' . $index, $row['no_pelayanan']);
$templateProcessor->setValue('perusahaan#' . $index, $row['nama_perusahaan']);
$templateProcessor->setValue('pemohon#' . $index, $row['penanggung_jawab']);
$templateProcessor->setValue('alamat#' . $index, $row['alamat']);
$templateProcessor->setValue('kota#' . $index, $row['kota']);
$templateProcessor->setValue('kecamatan#' . $index, $row['nama_kecamatan']);
$templateProcessor->setValue('keterangan#' . $index, 'Non Retribusi');
$index++;
}
}
}
$file_temp = './templates/Report_Temp_' . round(microtime(true) * 1000) . '.docx';
$templateProcessor->saveAs($file_temp);
// Saving the document as OOXML file...
//$objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($templateProcessor, 'Word2007');
header('Pragma: public');
// required
header('Expires: 0');
// no cache
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s', now()) . ' GMT');
header('Cache-Control: private', false);
header("Content-Type: application/vnd.ms-word");
header("Content-disposition: attachment; filename=" . strtoupper($data['jenis_perizinan']) . '_' . date('Y-m-d') . ".docx");
header('Content-Transfer-Encoding: binary');
header('Connection: close');
//$objWriter->save('php://output');
readfile($file_temp);
unlink($file_temp);
}