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