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; }
function excel_upload($departemen) { $this->authentication->verify('spkp_personalia_kerjasama_int', 'show'); $data = $this->spkp_personalia_kerjasama_int_model->json_upload($departemen); $rows = $data[0]['Rows']; $data['title'] = "Daftar File Kerjasama Internasional"; $data['departemen'] = "Departemen " . $this->spkp_personalia_kerjasama_int_model->get_departemen($departemen); $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_kerjasama_int_file.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_kegiatan_kerjasama_int_file.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); // echo $output_file_name; echo '../public/doc_xls_export/report_kegiatan_kerjasama_int_file.xlsx'; }
function excel() { $this->authentication->verify('spkp_absen_bulanan', 'show'); $data = $this->spkp_absen_bulanan_model->json(); $rows = array(); $dt = isset($data[0]['Rows']) ? $data[0]['Rows'] : array(); foreach ($dt as $r) { $r['bulan'] = $this->crud->bulan($r['bulan']); $rows[] = $r; } $data['title'] = "Absensi Bulanan"; $path = dirname(__FILE__) . '/../../public/doc_xls_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/absensi_bulanan.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_absensi_bulanan.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); //echo $output_file_name; echo '../public/doc_xls_export/report_absensi_bulanan.xlsx'; }
function excel_file($id) { $this->authentication->verify('spkp_director_history', 'show'); $data = $this->spkp_director_history_model->json_file($id); $rows = $data[0]['Rows']; $data['title'] = "Daftar File Dokumen Direktur"; $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_director_file.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_profile_director_file.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); //echo $output_file_name; echo '../public/doc_xls_export/report_profile_director_file.xlsx'; }
function export($id) { $this->authentication->verify('spkp_pjas_a016', 'show'); $arr_bulan = array("", "Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember"); $data = $this->spkp_pjas_a016_model->get_form($id); $data['title_form'] = "Form A016. Laporan Hasil Pengawasan Pangan dalam rangka Mobil Keliling"; $data['title_a'] = "LAPORAN HASIL PENGAWASAN PANGAN DALAM RANGKA MOBIL KELILING"; $data['title_b'] = "BULAN : " . $arr_bulan[$data['bulan']]; $data['title_c'] = "BBPOM/ BPOM : " . $this->spkp_pjas_a016_model->get_balai($data['id_balai']); $data['tanggal_form'] = $this->authentication->indonesian_date($data['tanggal'], 'l, j F Y', ''); $data_hasil = $this->spkp_pjas_a016_model->get_hasil_pengawasan($id); $x = 1; foreach ($data_hasil as $row_hasil) { $hasil_uji = $this->spkp_pjas_a016_model->get_hasil_uji($id, $row_hasil->id_hasil); $param = array(); $hasil_test = array(); $kesimpulan = array(); $y = 1; foreach ($hasil_uji as $row_uji) { $param[] = $y . ". " . $row_uji->parameter; $hasil_test[] = $y . ". " . $row_uji->hasil; $kesimpulan[] = $y . ". " . $row_uji->kesimpulan; $y++; } $hasil[] = array('no' => $x, 'lokasi' => $row_hasil->lokasi, 'alamat' => $row_hasil->alamat, 'kabkota' => ucwords(strtolower($this->spkp_pjas_a016_model->get_kota($row_hasil->kabkota))), 'kode_sampel' => $row_hasil->kode_sampel, 'produk' => $row_hasil->produk, 'pedagang' => $row_hasil->pedagang, 'pengolah' => $row_hasil->pengolah, 'jenis' => $row_hasil->jenis, 'no_pendaftaran' => $row_hasil->no_pendaftaran, 'kesimpulan_akhir' => $row_hasil->kesimpulan_akhir, 'tindaklanjut' => $row_hasil->tindaklanjut, 'parameter' => implode(', ', $param), 'hasil' => implode(', ', $hasil_test), 'kesimpulan' => implode(', ', $kesimpulan)); $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_a016.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('hasil', $hasil); $output_file_name = $path . 'export/report_spkp_pjas_a016.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo $output_file_name; }
function excel_upload($thn) { $this->authentication->verify('spkp_manajemen_learnorg', 'show'); $data = $this->spkp_manajemen_learnorg_model->json_judul($thn); $rows = $data[0]['Rows']; $data['title'] = "Daftar File Manajemen Mutu Learning Organization"; $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/spkp_manajemen_learnorg.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_spkp_manajemen_learnorg.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); // echo $output_file_name; echo '../public/doc_xls_export/report_spkp_manajemen_learnorg.xlsx'; }
function export($id) { $this->authentication->verify('spkp_pjas_f01', 'show'); $data = $this->spkp_pjas_f01_model->json_target($id); $rows = $data[0]['Rows']; $data['tmpt'] = $this->input->post('tmpt'); $data['tgl'] = substr($this->input->post('tanggal'), 8, 2); $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['bln'] = str_ireplace($angkabln, $indobln, substr($this->input->post('tanggal'), 5, 2)); $data['thn'] = substr($this->input->post('tanggal'), 0, 4); $data['nama'] = $this->input->post('penanggungjawab_nama'); $data['nip'] = $this->input->post('penanggungjawab_nip'); $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_f01.docx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_spkp_pjas_f01.docx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo $output_file_name; }
function word_kegiatan($propinsi, $thn) { $this->authentication->verify('spkp_pjas_a001', 'show'); $data = array(); $strategi = $this->spkp_pjas_a001_model->get_export_data($thn, $propinsi); $data['title'] = "Form A001. Matriks kegiatan Lintas Sektor dalam Rangka Aksi Nasional PJAS Tahun " . $thn . " di Provinsi " . $this->spkp_pjas_a001_model->get_propinsi($propinsi); $arr_abjad = array("", "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"); $x = 1; foreach ($strategi as $row_strategi) { $strategi = $row_strategi->nama_strategi != "" ? $row_strategi->nama_strategi : "-"; $program = $row_strategi->nama_program != "" ? $row_strategi->nama_program : "-"; $kegiatan = $row_strategi->nama != "" ? $row_strategi->nama : "-"; $instansi = $row_strategi->instansi != "" ? $row_strategi->instansi : "-"; $indikator = $row_strategi->indikator != "" ? $row_strategi->indikator : "-"; $target = $row_strategi->target != "" ? $row_strategi->target : "-"; $waktu = $row_strategi->waktu != "" ? $row_strategi->waktu : "-"; $dana = $row_strategi->sumber_dana != "" ? $row_strategi->sumber_dana : "-"; $main[] = array('strategi' => $strategi, 'program' => $program, 'kegiatan' => $kegiatan, 'instansi' => $instansi, 'indikator' => $indikator, 'target' => $target, 'waktu' => $waktu, 'sumber_dana' => $dana); $x++; } //print_r($main); $path = dirname(__FILE__) . '/../../public/doc_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/spkp_pjas_kegiatan_a001_b.docx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('main', $main); $output_file_name = $path . 'export/report_spkp_pjas_kegiatan_a001.docx'; $TBS->Show(OPENTBS_FILE, $output_file_name); // echo $output_file_name; echo '../public/doc_xls_export/report_spkp_pjas_kegiatan_a001.docx'; }
function export_detail() { $this->authentication->verify('inventory', 'show'); $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $filter_group = $this->session->userdata('filter_group'); $no = 1; $data_tabel = array(); if (!empty($filter_group) and $filter_group == '1') { $rows = $this->inv_ruangan_model->get_data_detail_group(); $data = array(); foreach ($rows as $act) { $act['no'] = $no++; $act['harga'] = number_format($act['harga']); $act['kode_barang'] = substr(chunk_split($act['id_mst_inv_barang'], 2, '.'), 0, 14); $act['keterangan'] = ""; $data_tabel[] = $act; } } else { $rows = $this->inv_ruangan_model->get_data_detail(); $data = array(); foreach ($rows as $act) { $act['no'] = $no++; $act['kode_barang'] = substr(chunk_split($act['id_mst_inv_barang'], 2, '.'), 0, 14); $act['harga'] = number_format($act['harga']); $data_tabel[] = $act; } } $code_cl_phc = $this->input->post('filter_code_cl_phc'); $ruang = $this->input->post('filter_id_ruang'); $tanggal = $this->input->post('filter_tanggal'); if (empty($code_cl_phc) or $code_cl_phc == 'Pilih Puskesmas') { $kode = "P" . $this->session->userdata('puskesmas'); $nama = "Data Seluruh Puskesmas"; } else { $kode = $this->input->post('filter_code_cl_phc'); $puskesmas = $this->inv_barang_model->get_nama('value', 'cl_phc', 'code', $kode); $nama = $puskesmas; } if (empty($ruang) or $ruang == 'Pilih Ruangan') { $namaruang = 'Data Seluruh Ruangan'; } else { $this->db->where('id_mst_inv_ruangan', $ruang); $this->db->where('code_cl_phc', $kode); $ruang = $this->db->get('mst_inv_ruangan')->row(); $namaruang = !empty($ruang) ? $ruang->nama_ruangan : "-"; } $propinsi = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode, 1, 2)); $kabkota = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode, 1, 4)); $kecamatan = $this->inv_barang_model->get_nama('nama', 'cl_kec', 'code', substr($kode, 1, 7)); $tanggals = explode("-", $tanggal); $tanggal_export = $tanggals[2] . '-' . $tanggals[1] . '-' . $tanggals[0]; $data_puskesmas['puskesmas'] = $nama; $data_puskesmas['tanggal'] = $tanggal_export; $data_puskesmas['ruangan'] = $namaruang; $data_puskesmas['kecamatan'] = $kecamatan; $data_puskesmas['kabkota'] = $kabkota; $data_puskesmas['propinsi'] = $propinsi; $TBS->ResetVarRef(false); $TBS->VarRef =& $data_puskesmas; $dir = getcwd() . '/'; $template = $dir . 'public/files/template/inventory/kir.xlsx'; $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8); $TBS->MergeBlock('a', $data_tabel); $code = date('Y-m-d-H-i-s'); $output_file_name = 'public/files/hasil/hasil_kir_' . $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_a015', 'show'); $data = $this->spkp_pjas_a015_model->get_form($id); $data['title'] = "Form A015. Pendataan SD/MI yang Mendapat Intervensi Tahun " . $data['tahun']; $data['propinsi'] = ucwords(strtolower($this->spkp_pjas_a015_model->get_propinsi($data['id_provinsi']))); $data['tanggal_form'] = $data['tempat'] . ", " . $this->authentication->indonesian_date($data['tanggal'], 'j F Y', ''); $data_sdmi = $this->spkp_pjas_a015_model->get_all_sdmi($id); $x = 1; foreach ($data_sdmi as $row) { $main[] = array('no' => $x, 'nama' => $row->nama, 'status' => $row->status, 'akreditasi' => $row->akreditasi, 'intervensi' => $row->intervensi, 'instansi' => $row->instansi); $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_a015.docx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('main', $main); $output_file_name = $path . 'export/report_spkp_pjas_a015.docx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo $output_file_name; }
function excel() { $this->authentication->verify('spkp_personalia_jadwal_kegiatan', 'show'); $data = $this->spkp_personalia_jadwal_kegiatan_model->json_kegiatan($id); $rows = $data[0]['Rows']; $data['title'] = "KP4 Pegawai"; $path = dirname(__FILE__) . '/../../public/doc_xls_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/personalia_cuti.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_personalia_cuti.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo $output_file_name; }
function pengadaan_detail_export() { $tgl_pengadaan = $this->input->post('tgl_pengadaan'); $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 == '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')); } } $rows_all = $this->pengadaanbarang_model->get_data(); 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')); } } $rows = $this->pengadaanbarang_model->get_data($this->input->post('recordstartindex'), $this->input->post('pagesize')); $rows = $this->pengadaanbarang_model->get_data(); $data = array(); $no = 1; $data_tabel = array(); foreach ($rows as $act) { $data_tabel[] = array('tgl_pengadaan' => $act->tgl_pengadaan, 'nomor_kontrak' => $act->nomor_kontrak, 'pilihan_status_pengadaan' => $act->pilihan_status_pengadaan, 'jumlah_unit' => $act->jumlah_unit, 'nilai_pengadaan' => $act->nilai_pengadaan, 'keterangan' => $act->keterangan, 'detail' => 1, 'edit' => 1, 'delete' => 1); } if (empty($this->input->post('tgl_pengadaan')) or $this->input->post('tgl_pengadaan') == 'Pilih Puskesmas') { $nama = 'Semua Data Puskesmas'; } else { $nama = $this->input->post('tgl_pengadaan'); } $pilihan_status_pengadaan = $this->input->post('pilihan_status_pengadaan'); $nomor_kontrak = $this->input->post('nomor_kontrak'); $keterangan = $this->input->post('keterangan'); $jumlah_unit = $this->input->post('jumlah_unit'); $nilai_pengadaan = $this->input->post('nilai_pengadaan'); $waktu_dibuat = $this->input->post('waktu_dibuat'); $terakhir_diubah = $this->input->post('terakhir_diubah'); // $puskesmas = $nama; #$data_puskesmas[] = array('nama_puskesmas' => $nama, 'tanggal'=> $tanggal, 'keterangan'=>$keterangan, 'ruang'=>$ruang); $data_puskesmas['pilihan_status_pengadaan'] = $pilihan_status_pengadaan; $data_puskesmas['nomor_kontrak'] = $nomor_kontrak; $data_puskesmas['keterangan'] = $keterangan; $data_puskesmas['jumlah_unit'] = $jumlah_unit; $data_puskesmas['nilai_pengadaan'] = $nilai_pengadaan; $data_puskesmas['waktu_dibuat'] = $waktu_dibuat; $data_puskesmas['terakhir_diubah'] = $terakhir_diubah; $TBS->ResetVarRef(false); $TBS->VarRef =& $data_puskesmas; $template = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\template\\inventory\\pengadaan_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 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_update') { $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')); } } $this->db->where('id_inv_hasbispakai_pembelian', $id); $rows_all_activity = $this->bhp_pengadaan_model->getItem(); 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_update') { $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')); } } if ($this->session->userdata('puskesmas') != '') { $this->db->where('inv_inventaris_habispakai_pembelian_item.code_cl_phc', 'P' . $this->session->userdata('puskesmas')); } $this->db->where('inv_inventaris_habispakai_pembelian_item.id_inv_hasbispakai_pembelian', $id); $activity = $this->bhp_pengadaan_model->getItem(); $no = 1; $datadetail = array(); foreach ($activity as $act) { $datadetail[] = array('no' => $no++, 'id_inv_hasbispakai_pembelian' => $act->id_inv_hasbispakai_pembelian, 'id_mst_inv_barang_habispakai' => $act->id_mst_inv_barang_habispakai, 'uraian' => $act->uraian, 'jml' => $act->jml, 'batch' => $act->batch, 'harga' => number_format($act->harga, 2), 'subtotal' => number_format($act->jml * $act->harga, 2), 'tgl_update' => date("d-m-Y", strtotime($act->tgl_update)), 'edit' => 1, 'delete' => 1); } $data_puskesmas = $this->bhp_pengadaan_model->get_data_row($id); $nama_puskesmas = $this->bhp_pengadaan_model->get_data_nama($data_puskesmas['code_cl_phc']); $onshow['puskesmas'] = $nama_puskesmas['value']; $onshow['tgl_permohonan'] = date("d-m-Y", strtotime($data_puskesmas['tgl_permohonan'])); $onshow['tgl_kwitansi'] = date("d-m-Y", strtotime($data_puskesmas['tgl_kwitansi'])); $onshow['nomor_kwitansi'] = $data_puskesmas['nomor_kwitansi']; $onshow['nomor_kontrak'] = $data_puskesmas['nomor_kontrak']; $onshow['keterangan'] = $data_puskesmas['keterangan']; $onshow['jumlah_unit'] = $data_puskesmas['jumlah_unit']; $onshow['nilai_pembelian'] = number_format($data_puskesmas['nilai_pembelian'], 2); $onshow['tahun'] = date("Y"); $onshow['pilihan_status_pembelian'] = $this->bhp_pengadaan_model->getPilihan("status_pembelian", $data_puskesmas['pilihan_status_pembelian']); $kode_sess = $this->session->userdata('puskesmas'); $onshow['kd_prov'] = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode_sess, 0, 2)); $onshow['kd_kab'] = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode_sess, 0, 4)); $TBS->ResetVarRef(false); $TBS->VarRef =& $onshow; $dir = getcwd() . '/'; if ($data_puskesmas['id_mst_inv_barang_habispakai_jenis'] == '8') { $template = $dir . 'public/files/template/inventory/bhp_pengadaanpermohonan_obat.xlsx'; } else { $template = $dir . 'public/files/template/inventory/bhp_pengadaanpermohonan.xlsx'; } $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8); $TBS->MergeBlock('a', $datadetail); $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 detail_sts_export() { $this->authentication->verify('keuangan', 'show'); $data = array(); $id = $this->input->post('id'); $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $activity = $this->sts_model->get_data_for_export('keu_sts', array('keu_sts.id_sts' => $id))->result(); foreach ($activity as $act) { $data[] = array('kode_anggaran' => $act->kode_anggaran, 'uraian' => $act->uraian, 'vol' => $act->vol, 'tarif' => $act->tarif, 'jumlah' => $act->jumlah); } $data_puskesmas = $this->sts_model->get_data_row($id); $nama_puskesmas = $this->sts_model->get_data_nama($data_puskesmas['code_pl_phc']); $data_puskesmas['puskesmas'] = $nama_puskesmas['value']; $data_puskesmas['tgl'] = date("d-m-Y", strtotime($data_puskesmas['tgl'])); $data_puskesmas['nomor'] = $data_puskesmas['nomor']; $data_puskesmas['pimpinan'] = $data_puskesmas['ttd_pimpinan_nama']; $data_puskesmas['penerima'] = $data_puskesmas['ttd_penerima_nama']; $data_puskesmas['penyetor'] = $data_puskesmas['ttd_penyetor_nama']; $data_puskesmas['total'] = $data_puskesmas['total']; $TBS->ResetVarRef(false); $TBS->VarRef =& $data_puskesmas; $dir = getcwd() . '/'; $template = $dir . 'public/files/template/keuangan/sts_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_export_keuangan_sts_detail' . $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 excel_tukin($id, $thn = "", $bln = "") { $this->authentication->verify('spkp_absen_tunjangan', 'show'); $data = $this->spkp_absen_tunjangan_model->json_absen($id, $thn, $bln); $rows = $data[0]['Rows']; if (!is_array($rows)) { $rows = array(); } $data['title'] = "Absensi - Tunjangan Kinerja " . $thn . "-" . $bln; $path = dirname(__FILE__) . '/../../public/doc_xls_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/absensi_tukin.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_absensi_tukin.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo '../public/doc_xls_export/report_absensi_tukin.xlsx'; }
function export($id) { $this->authentication->verify('spkp_pjas_a013', 'show'); $data = $this->spkp_pjas_a013_model->get_form($id); $data['title'] = "Form A013. Lembar Kendali Kegiatan KIE Keamanan Pangan Melalui Media Massa Elektronik (Talkshow di TV, radio) dan Pameran Keamanan PJAS di Daerah tahun " . $data['tahun']; $data['balai'] = $this->spkp_pjas_a013_model->get_balai($data['id_balai']); $data['tanggal_form'] = $data['ttd_tmpt'] . ", " . $this->authentication->indonesian_date($data['ttd_tgl'], 'j F Y', ''); $data_plk = $this->spkp_pjas_a013_model->get_all_pelaksanaan($id); $x = 1; foreach ($data_plk as $row_plk) { $plk[] = array('no' => $x, 'tgl' => $row_plk->tgl, 'jenis' => $row_plk->jenis, 'media' => $row_plk->media, 'kegiatan' => $row_plk->kegiatan, 'evaluasi' => $row_plk->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_a013.docx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('plk', $plk); $output_file_name = $path . 'export/report_spkp_pjas_a013.docx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo $output_file_name; }