PHP clsTinyButStrong::ResetVarRef方法代码示例

 function excel()
 {
     $BulanIndo = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");
     $POST = array();
     $data['query'] = $this->admin_users_model->get_list();
     $userlist = $data['query'];
     for ($i = 0; $i < sizeof($userlist); $i++) {
         if ($userlist[$i]['birthdate'] != null) {
             $tgl_tmp = explode("/", $userlist[$i]['birthdate']);
             $userlist[$i]['birthdate'] = (int) $tgl_tmp[0] . " " . $BulanIndo[(int) $tgl_tmp[1] - 1] . " " . $tgl_tmp[2];
         }
         $userlist[$i]['last_login'] = "" . date("d-m-Y h:i:s", $userlist[$i]['last_login']);
         $userlist[$i]['last_active'] = "" . date("d-m-Y h:i:s", $userlist[$i]['last_active']);
     }
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = dirname(__FILE__) . '/../../public/files/excel/list_user.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('a,b', $userlist);
     $output_file_name = 'list_user.xlsx';
     $TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
 }

 function excel()
 {
     $this->authentication->verify('spkp_task_function', 'show');
     $data = $this->spkp_task_function_model->json_tugasfungsi();
     $rows = $data[0]['Rows'];
     $data['title'] = "Daftar Tugas Pokok dan Fungsi DIT SPKP";
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/profile_tugas_fungsi.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $output_file_name = $path . 'export/report_profile_tugas_fungsi.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     //echo $output_file_name;
     echo '../public/doc_xls_export/report_profile_tugas_fungsi.xlsx';
 }

 function excel_upload()
 {
     $this->authentication->verify('srikandi', 'show');
     $data = $this->srikandi_model->json_judul();
     $rows = $data[0]['Rows'];
     $data['title'] = "Informasi dan Kajian";
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/srikandi.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $output_file_name = $path . 'export/report_srikandi.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     echo $output_file_name;
 }

 function permohonan_detail_export()
 {
     $code_cl_phc = $this->input->post('code_cl_phc');
     $id = $this->input->post('kode');
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     //[data_tabel.no;block=tbs:row]	[data_tabel.tgl]	[data_tabel.ruangan]	[data_tabel.jumlah]	[data_tabel.keterangan]	[data_tabel.status]
     $this->authentication->verify('inventory', 'show');
     if ($_POST) {
         $fil = $this->input->post('filterscount');
         $ord = $this->input->post('sortdatafield');
         for ($i = 0; $i < $fil; $i++) {
             $field = $this->input->post('filterdatafield' . $i);
             $value = $this->input->post('filtervalue' . $i);
             if ($field == 'tanggal_permohonan') {
                 $value = date("Y-m-d", strtotime($value));
                 $this->db->where($field, $value);
             } elseif ($field != 'year') {
                 $this->db->like($field, $value);
             }
         }
         if (!empty($ord)) {
             $this->db->order_by($ord, $this->input->post('sortorder'));
         }
     }
     #$rows = $this->permohonanbarang_model->get_data($this->input->post('recordstartindex'), $this->input->post('pagesize'));
     $this->db->where('code_cl_phc', $code_cl_phc);
     $activity = $this->permohonanbarang_model->getItem('inv_permohonan_barang_item', array('id_inv_permohonan_barang' => $id))->result();
     $data = array();
     $no = 1;
     $data_tabel = array();
     foreach ($activity as $act) {
         $data_tabel[] = array('no' => $no++, 'nama_barang' => $act->nama_barang, 'jumlah' => $act->jumlah, 'keterangan' => $act->keterangan);
     }
     if (empty($this->input->post('nama_puskesmas')) or $this->input->post('nama_puskesmas') == 'Pilih Puskesmas') {
         $nama = 'Semua Data Puskesmas';
     } else {
         $nama = $this->input->post('nama_puskesmas');
     }
     $tanggal = $this->input->post('tanggal');
     $keterangan = $this->input->post('keterangan');
     $ruang = $this->input->post('ruang');
     $puskesmas = $nama;
     #$data_puskesmas[] = array('nama_puskesmas' => $nama, 'tanggal'=> $tanggal, 'keterangan'=>$keterangan, 'ruang'=>$ruang);
     $data_puskesmas['nama_puskesmas'] = $nama;
     $data_puskesmas['tanggal'] = $tanggal;
     $data_puskesmas['ruang'] = $ruang;
     $data_puskesmas['keterangan'] = $keterangan;
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data_puskesmas;
     $template = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\template\\inventory\\permohonan_barang_detail.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     // Merge data in the first sheet
     $TBS->MergeBlock('a', $data_tabel);
     #$TBS->MergeBlock('b', $data_puskesmas);
     $code = date('Y-m-d-H-i-s');
     $output_file_name = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\hasil\\hasil_detail_export_' . $code . '.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     // Also merges all [onshow] automatic fields.
     echo base_url() . 'public/files/hasil/hasil_detail_export_' . $code . '.xlsx';
 }

 function excel_upload($thn)
 {
     $this->authentication->verify('spkp_promotion_subdit', 'show');
     $data = $this->spkp_promotion_subdit_model->json_upload($thn);
     $rows = $data[0]['Rows'];
     $data['title'] = "Daftar File Kegiatan Subdit Promosi";
     $data['thn'] = "Tahun " . $thn;
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/kegiatan_subdit_promosi_file.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $output_file_name = $path . 'export/report_kegiatan_subdit_promosi_file.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     // echo $output_file_name;
     echo '../public/doc_xls_export/report_kegiatan_subdit_promosi_file.xlsx';
 }

 function excel()
 {
     $this->authentication->verify('spkp_renstra_dit', 'show');
     $data = $this->spkp_renstra_dit_model->json_renstra_dit();
     $rows = $data[0]['Rows'];
     $data['title'] = "Rencana Strategis DIT/SPKP";
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/renstra_dit.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $output_file_name = $path . 'export/report_renstra_dit.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     //echo $output_file_name;
     echo '../public/doc_xls_export/report_renstra_dit.xlsx';
 }

 function excel()
 {
     $this->authentication->verify('spkp_manajemen_dokumen_eksternal', 'show');
     $data = $this->spkp_manajemen_dokumen_eksternal_model->json_dokumen();
     $rows = $data[0]['Rows'];
     $data['title'] = "QMS DOKUMEN EKSTERNAL";
     $data['title_down'] = "DIREKTORAT SURVEILAN DAN PENYULUHAN KEAMANAN PANGAN";
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/qms_manajemen_dokumen_eksternal.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $output_file_name = $path . 'export/report_qms_manajemen_dokumen_eksternal.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     // echo $output_file_name;
     echo '../public/doc_xls_export/report_qms_manajemen_dokumen_eksternal.xlsx';
 }

 function pengadaan_detail_export()
 {
     $this->authentication->verify('inventory', 'show');
     $id = $this->input->post('kode');
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     if ($_POST) {
         $fil = $this->input->post('filterscount');
         $ord = $this->input->post('sortdatafield');
         for ($i = 0; $i < $fil; $i++) {
             $field = $this->input->post('filterdatafield' . $i);
             $value = $this->input->post('filtervalue' . $i);
             if ($field == 'tgl_pengadaan') {
                 $value = date("Y-m-d", strtotime($value));
                 $this->db->where($field, $value);
             } elseif ($field != 'year') {
                 $this->db->like($field, $value);
             }
         }
         if (!empty($ord)) {
             $this->db->order_by($ord, $this->input->post('sortorder'));
         }
     }
     $data = array();
     $activity = $this->pengadaanbarang_model->getItem('inv_inventaris_barang', array('id_pengadaan' => $id))->result();
     foreach ($activity as $act) {
         $data[] = array('id_inventaris_barang' => $act->id_inventaris_barang, 'id_mst_inv_barang' => substr(chunk_split($act->id_mst_inv_barang, 2, '.'), 0, 14), 'nama_barang' => $act->nama_barang, 'jumlah' => $act->jumlah, 'harga' => number_format($act->harga, 2), 'totalharga' => number_format($act->totalharga, 2), 'keterangan' => $act->keterangan_pengadaan, 'pilihan_status_invetaris' => $this->pengadaanbarang_model->getPilihan("status_inventaris", $act->pilihan_status_invetaris), 'barang_kembar_proc' => $act->barang_kembar_proc, 'tanggal_diterima' => date("d-m-Y", strtotime($act->tanggal_diterima)), 'waktu_dibuat' => $act->waktu_dibuat, 'terakhir_diubah' => $act->terakhir_diubah, 'value' => $act->value);
     }
     $data_puskesmas = $this->pengadaanbarang_model->get_data_row($id);
     $nama_puskesmas = $this->pengadaanbarang_model->get_data_nama($data_puskesmas['code_cl_phc']);
     $data_puskesmas['puskesmas'] = $nama_puskesmas['value'];
     $data_puskesmas['tgl_pengadaan'] = date("d-m-Y", strtotime($data_puskesmas['tgl_pengadaan']));
     $data_puskesmas['tgl_kwitansi'] = date("d-m-Y", strtotime($data_puskesmas['tgl_kwitansi']));
     $data_puskesmas['nomor_kwitansi'] = $data_puskesmas['nomor_kwitansi'];
     $data_puskesmas['nilai_pengadaan'] = number_format($data_puskesmas['nilai_pengadaan'], 2);
     $data_puskesmas['pilihan_status_pengadaan'] = $this->pengadaanbarang_model->getPilihan("status_pengadaan", $data_puskesmas['pilihan_status_pengadaan']);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data_puskesmas;
     $dir = getcwd() . '/';
     $template = $dir . 'public/files/template/inventory/pengadaan_barang_detail.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     $TBS->MergeBlock('a', $data);
     $code = date('Y-m-d-H-i-s');
     $output_file_name = 'public/files/hasil/hasil_detail_export_' . $code . '.xlsx';
     $output = $dir . $output_file_name;
     $TBS->Show(OPENTBS_FILE, $output);
     // Also merges all [onshow] automatic fields.
     echo base_url() . $output_file_name;
 }

 function export($id)
 {
     $this->authentication->verify('spkp_pjas_a019', 'show');
     $data = $this->spkp_pjas_a019_model->get_form($id);
     $data['title'] = "Form A019. Lembar Kendali Pelaksanaan KIE Keamanan PJAS Melalui Mobling";
     $data['title_up'] = "LEMBAR KENDALI";
     $data['title_down'] = "PELAKSANAAN KIE KEAMANAN PJAS MELALUI MOBLING TAHUN " . date('Y', strtotime($data['tanggal']));
     $data['balai'] = $this->spkp_pjas_a019_model->get_balai($data['id_balai']);
     $data['tanggal_form'] = $data['tempat'] . ", " . $this->authentication->indonesian_date($data['tanggal'], 'j F Y', '');
     $data_sdmi = $this->spkp_pjas_a019_model->get_all_sdmi($id);
     $x = 1;
     foreach ($data_sdmi as $row) {
         $main[] = array('no' => $x, 'tanggal' => $row->tanggal, 'nama' => $row->nama, 'npsn' => $row->npsn, 'alamat' => $row->alamat, 'kabkota' => ucwords(strtolower($row->nama_kota)), 'komunitas' => $row->komunitas, 'jenis' => $row->jenis, 'kie_peserta' => $row->kie_peserta, 'kie_materi' => $row->kie_materi, 'dokumentasi' => $row->dokumentasi, 'evaluasi' => $row->evaluasi);
         $x++;
     }
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/spkp_pjas_a019.docx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('main', $main);
     $output_file_name = $path . 'export/report_spkp_pjas_a019.docx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     echo $output_file_name;
 }

 function export($id)
 {
     $this->authentication->verify('spkp_pjas_a005', 'show');
     $data = $this->spkp_pjas_a005_model->get_form($id);
     $hari = $this->spkp_pjas_a005_model->get_max_hari($id);
     $data['title'] = "Form A005. Evaluasi dan pelaporan Bimtek KIE keamanan PJAS";
     $data['balai'] = $this->spkp_pjas_a005_model->get_balai($data['id_balai']);
     $data['tanggal_form'] = $this->authentication->indonesian_date($data['tanggal'], 'l, j F Y', '');
     $data['tanggal_pj'] = $data['penanggungjawab_tempat'] . ", " . $this->authentication->indonesian_date($data['penanggungjawab_tanggal'], 'j F Y', '');
     $data_sdmi = $this->spkp_pjas_a005_model->get_peserta_sdmi($id);
     $x = 1;
     foreach ($data_sdmi as $row_a) {
         $sdmi[] = array('no' => $x, 'nama' => $row_a->nama, 'status' => $row_a->status, 'akreditasi' => $row_a->akreditasi, 'kantin' => $row_a->kantin, 'internet' => $row_a->internet);
         $x++;
     }
     $data_komunitas = $this->spkp_pjas_a005_model->get_peserta_komunitas($id);
     $y = 1;
     foreach ($data_komunitas as $row_b) {
         $komunitas[] = array('no' => $y, 'hari' => "Hari ke - " . $row_b->hari, 'kepsek' => $row_b->kepsek, 'guru_uks' => $row_b->guru_uks, 'guru' => $row_b->guru, 'kantin' => $row_b->kantin, 'komite' => $row_b->komite, 'kelas4' => $row_b->kelas4, 'kelas5' => $row_b->kelas5, 'lainnya' => $row_b->lainnya, 'total' => $row_b->total);
         $y++;
     }
     for ($z = 1; $z <= $hari['max']; $z++) {
         $jml_hari[] = array('jml_hari' => "H" . $z);
     }
     $data_peserta = $this->spkp_pjas_a005_model->get_peserta_lintas_sektor($id);
     $a = 1;
     foreach ($data_peserta as $row_c) {
         $peserta_hari = $this->spkp_pjas_a005_model->get_hari_peserta_lintas($id, $row_c->id_peserta);
         $jml_hari_peserta = array();
         foreach ($peserta_hari as $row_hari) {
             $jml_hari_peserta[] = "H" . $row_hari->hari;
         }
         $peserta[] = array('no' => $a, 'nama' => $row_c->nama, 'jabatan' => $row_c->jabatan, 'hari' => implode(',', $jml_hari_peserta));
         $a++;
     }
     $data_materi = $this->spkp_pjas_a005_model->get_materi_bimtek($id);
     foreach ($data_materi as $row_d) {
         $materi[] = array('nama' => $row_d->nama, 'instansi' => $row_d->instansi, 'materi' => $row_d->materi);
     }
     //print_r($peserta);
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/spkp_pjas_a005.docx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('psr', $peserta);
     $TBS->MergeBlock('hari', $jml_hari);
     $TBS->MergeBlock('mtr', $materi);
     $TBS->MergeBlock('kmn', $komunitas);
     $TBS->MergeBlock('sdmi', $sdmi);
     $output_file_name = $path . 'export/report_spkp_pjas_a005.docx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     echo $output_file_name;
 }

 function export($id)
 {
     $this->authentication->verify('spkp_pjas_a007b', 'show');
     $data = $this->spkp_pjas_a007b_model->json_petugas($id);
     $data2 = $this->spkp_pjas_a007b_model->json_materi($id);
     $data3 = $this->spkp_pjas_a007b_model->json_peserta($id);
     $data4 = $this->spkp_pjas_a007b_model->json_pesertalintas($id);
     $data5 = $this->spkp_pjas_a007b_model->json_komposisi($id);
     $rows = $data[0]['Rows'];
     $rows2 = $data2[0]['Rows'];
     $rows3 = $data3[0]['Rows'];
     $rows4 = $data4[0]['Rows'];
     $rows5 = $data5[0]['Rows'];
     $val = $this->spkp_pjas_a007b_model->count_peserta($id);
     foreach ($val as $value) {
         $data['jml_peserta'] = $value->jml_peserta;
     }
     $data['balai'] = $this->input->post('balai');
     $data['kegiatan_nama'] = $this->input->post('kegiatan_nama');
     $angkabln = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');
     $indobln = array('Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember');
     $data['kegiatan_tgl'] = substr($this->input->post('kegiatan_tgl'), 8, 2);
     $data['kegiatan_tgl'] .= " " + str_ireplace($angkabln, $indobln, substr($this->input->post('kegiatan_tgl'), 5, 2));
     $data['kegiatan_tgl'] .= " " + substr($this->input->post('kegiatan_tgl'), 0, 4);
     $data['kegiatan_tmpt'] = $this->input->post('kegiatan_tmpt');
     $data['kegiatan_penyelenggara'] = $this->input->post('kegiatan_penyelenggara');
     $data['ttd_tmpt'] = $this->input->post('ttd_tmpt');
     $data['ttd_tgl'] = substr($this->input->post('ttd_tgl'), 8, 2);
     $data['ttd_tgl'] .= " " + str_ireplace($angkabln, $indobln, substr($this->input->post('ttd_tgl'), 5, 2));
     $data['ttd_tgl'] .= " " + substr($this->input->post('ttd_tgl'), 0, 4);
     $data['ttd_nama'] = $this->input->post('ttd_nama');
     $data['ttd_nip'] = $this->input->post('ttd_nip');
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     ($TBS->VarRef =& $data) & $data2 & $data3 & $data4 & $data5;
     $template = $path . 'templates/spkp_pjas_a007b.docx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $TBS->MergeBlock('data2', $rows2);
     $TBS->MergeBlock('data3', $rows3);
     $TBS->MergeBlock('data4', $rows4);
     $TBS->MergeBlock('data5', $rows5);
     $output_file_name = $path . 'export/report_spkp_pjas_a007b.docx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     echo $output_file_name;
 }

 function export($uid, $id, $kode)
 {
     $this->authentication->verify('spkp_personalia_form_pegawai', 'show');
     $data = $this->spkp_personalia_form_pegawai_model->get_user($uid);
     $izincuti = $this->spkp_personalia_form_pegawai_model->get_data_row($id);
     $posisi = $this->spkp_personalia_form_pegawai_model->get_posisi($uid);
     $data = array_merge($data, $izincuti, $posisi);
     if ($kode == "itm") {
         $data['frm_izin'] = $izincuti['stat_tm'] == "masuk" ? "terlambat masuk" : "pulang sebelum waktunya";
         $data['frm_tgl_izin'] = "pada hari " . $this->authentication->indonesian_date($izincuti['stat_tgl'], 'l', '') . " tanggal " . $this->authentication->indonesian_date($izincuti['stat_tgl'], 'j F Y', '');
         $data['frm_tgl'] = "Jakarta, " . $this->authentication->indonesian_date($izincuti['tgl'], 'j F Y', '');
     } else {
         if ($kode == "itk") {
             $data['frm_tgl_izin'] = $this->authentication->indonesian_date($izincuti['stat_tgl'], 'j F Y', '');
             $data['frm_tgl'] = "Jakarta, " . $this->authentication->indonesian_date($izincuti['tgl'], 'j F Y', '');
         } else {
             $data['frm_tgl_izin'] = $this->authentication->indonesian_date($izincuti['stat_tgl'], 'j F Y', '');
         }
     }
     $main = array();
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     if ($kode == "cl") {
         $doc_temp = $path . 'templates/personalia_cuti_cl.docx';
         $doc_output = $path . 'export/report_personalia_cuti_cl.docx';
     } else {
         if ($kode == "cp") {
             $doc_temp = $path . 'templates/personalia_cuti_cp.docx';
             $doc_output = $path . 'export/report_personalia_cuti_cp.docx';
         } else {
             if ($kode == "sk") {
                 $doc_temp = $path . 'templates/personalia_cuti_sk.docx';
                 $doc_output = $path . 'export/report_personalia_cuti_sk.docx';
             } else {
                 if ($kode == "ct") {
                     $doc_temp = $path . 'templates/personalia_cuti_ct.docx';
                     $doc_output = $path . 'export/report_personalia_cuti_ct.docx';
                 } else {
                     if ($kode == "icb") {
                         $doc_temp = $path . 'templates/personalia_cuti_icb.docx';
                         $doc_output = $path . 'export/report_personalia_cuti_icb.docx';
                     } else {
                         if ($kode == "itm") {
                             $doc_temp = $path . 'templates/personalia_cuti_itm.docx';
                             $doc_output = $path . 'export/report_personalia_cuti_itm.docx';
                         } else {
                             if ($kode == "itk") {
                                 $doc_temp = $path . 'templates/personalia_cuti_itk.docx';
                                 $doc_output = $path . 'export/report_personalia_cuti_itk.docx';
                             }
                         }
                     }
                 }
             }
         }
     }
     $TBS->LoadTemplate($doc_temp);
     $TBS->MergeBlock('main', $main);
     $TBS->Show(OPENTBS_FILE, $doc_output);
     echo $doc_output;
 }

 function excel()
 {
     $this->authentication->verify('spkp_budget', 'show');
     $data = $this->spkp_budget_model->json_budget();
     $rows = $data[0]['Rows'];
     $data['title'] = "Daftar Sumber Daya Anggaran";
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/sumberdaya_anggaran.xlsx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('data', $rows);
     $output_file_name = $path . 'export/report_sumberdaya_anggaran.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     // echo $output_file_name;
     echo '../public/doc_xls_export/report_sumberdaya_anggaran.xlsx';
 }

 function export_detail()
 {
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     //[data_tabel.no;block=tbs:row]	[data_tabel.tgl]	[data_tabel.ruangan]	[data_tabel.jumlah]	[data_tabel.keterangan]	[data_tabel.status]
     $this->authentication->verify('inventory', 'show');
     $activity = $this->inv_ruangan_model->get_data_detail();
     $kondisi = $this->inv_ruangan_model->get_pilihan_kondisi();
     $data_tabel = array();
     foreach ($activity as $act) {
         $data_tabel[] = array('kode_barang' => $no++, 'nama_barang' => $act->nama_barang, 'register' => $act->jumlah, 'tahun' => $act->keterangan);
     }
     if (empty($this->input->post('nama_puskesmas')) or $this->input->post('nama_puskesmas') == 'Pilih Puskesmas') {
         $nama = 'Semua Data Puskesmas';
     } else {
         $nama = $this->input->post('nama_puskesmas');
     }
     $tanggal = $this->input->post('tanggal');
     $keterangan = $this->input->post('keterangan');
     $ruang = $this->input->post('ruang');
     $puskesmas = $nama;
     #$data_puskesmas[] = array('nama_puskesmas' => $nama, 'tanggal'=> $tanggal, 'keterangan'=>$keterangan, 'ruang'=>$ruang);
     $data_puskesmas['nama_puskesmas'] = $nama;
     $data_puskesmas['tanggal'] = $tanggal;
     $data_puskesmas['ruang'] = $ruang;
     $data_puskesmas['keterangan'] = $keterangan;
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data_puskesmas;
     $template = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\template\\inventory\\permohonan_barang_detail.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     // Merge data in the first sheet
     $TBS->MergeBlock('a', $data_tabel);
     #$TBS->MergeBlock('b', $data_puskesmas);
     $code = date('Y-m-d-H-i-s');
     $output_file_name = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\hasil\\hasil_detail_export_' . $code . '.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     // Also merges all [onshow] automatic fields.
     echo base_url() . 'public/files/hasil/hasil_detail_export_' . $code . '.xlsx';
     echo "http://google.com";
 }

 function export($id)
 {
     $this->authentication->verify('spkp_pjas_a008', 'show');
     $data = $this->spkp_pjas_a008_model->get_form($id);
     $data['title'] = "Form A008. Pelaporan Pelaksanaan Audit PBKP-KS";
     $data['title_up'] = "FORMAT PELAPORAN *)";
     $data['title_down'] = "PELAKSANAAN AUDIT PBKP-KS";
     $data['tanggal_form'] = $this->authentication->indonesian_date($data['tanggal'], 'l, j F Y', '');
     $data_audit = $this->spkp_pjas_a008_model->get_all_auditor($id);
     $x = 1;
     foreach ($data_audit as $row_a) {
         $audit[] = array('no' => $x, 'tanggal' => $row_a->tanggal, 'nama' => $row_a->nama, 'nip' => $row_a->nip, 'gol' => $row_a->gol, 'jabatan' => $row_a->jabatan, 'instansi' => $row_a->instansi);
         $x++;
     }
     $data_sdmi = $this->spkp_pjas_a008_model->get_all_sdmi($id);
     $y = 1;
     foreach ($data_sdmi as $row) {
         $sdmi[] = array('no' => $y, 'nama_sekolah' => $row->nama_sekolah, 'kepsek_nama' => $row->kepsek_nama, 'kepsek_nip' => $row->kepsek_nip, 'alamat' => $row->alamat, 'nilai' => $row->nilai, 'temuan' => $row->temuan, 'kode_pbkpks' => $row->kode_pbkpks);
         $y++;
     }
     //print_r($audit);
     //print_r($sdmi);
     $path = dirname(__FILE__) . '/../../public/doc_xls_';
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $TBS->ResetVarRef(false);
     $TBS->VarRef =& $data;
     $template = $path . 'templates/spkp_pjas_a008.docx';
     $TBS->LoadTemplate($template);
     $TBS->MergeBlock('audit', $audit);
     $TBS->MergeBlock('sdmi', $sdmi);
     $output_file_name = $path . 'export/report_spkp_pjas_a008.docx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     echo $output_file_name;
 }