예제 #1
0
function getNamaIzin($jenisIzin)
{
    $tabel = getTabelJenisPerizinan();
    return $tabel[$jenisIzin];
}
예제 #2
0
                            	<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">&nbsp;</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">&nbsp;&nbsp;&nbsp;<button type="button" id="filter_data" class="btn btn-info"><span class="fa fa-search">&nbsp;Cari</span></button>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<button type="button" id="preview_data" class="btn btn-success"><span class="fa fa-print"></span></button>&nbsp;<button type="button" id="export_data" class="btn btn-primary"><span class="fa fa-file-word-o"></span></button></td>
예제 #3
0
 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);
 }