PHP clsTinyButStrong::Show方法代码示例

 public function actionTemplate2()
 {
     Yii::import('ext.heart.opentbs.EHeartOpenTBS', true);
     EHeartOpenTBS::init();
     // Initalize the TBS instance
     $TBS = new clsTinyButStrong();
     // new instance of TBS
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     // load the OpenTBS plugin
     $templatePath = Yii::getPathOfAlias('ext.heart.opentbs');
     $template = $templatePath . DIRECTORY_SEPARATOR . 'template.docx';
     $TBS->LoadTemplate($template);
     $modelPath = Yii::getPathOfAlias('application.models');
     $files = scandir($modelPath);
     $row = 2;
     $data = array();
     foreach ($files as $file) {
         if (is_file($modelPath . '/' . $file) && CFileHelper::getExtension($file) === 'php' && !in_array($file, array('ContactForm.php', 'LoginForm.php', 'Admin.php', 'User.php'))) {
             $file_arr = explode(".", $file);
             $filename = $file_arr[0];
             $data[$row - 2]['no'] = $row - 1;
             $data[$row - 2]['field1'] = $filename;
             $data[$row - 2]['field2'] = 'test/' . $filename;
             $row++;
         }
     }
     $data2[0]['title'] = "Template Generator";
     $data2[0]['field1'] = 'Model';
     $data2[0]['field2'] = 'Controller';
     $TBS->NoErr = true;
     $TBS->MergeBlock('data', 'array', $data);
     $TBS->MergeBlock('data2', 'array', $data2);
     $TBS->Show(OPENTBS_DOWNLOAD, 'template.docx');
 }

function module_admin_footer($main = "", $n = "")
{
    global $blocks, $main, $module_css, $module_menu;
    include_once XOOPS_ROOT_PATH . '/common/tbs/tbs_class_php5.php';
    $TBS = new clsTinyButStrong();
    $TBS->LoadTemplate(XOOPS_ROOT_PATH . "/common/themes/" . WEB_THEME . "/index.html", False);
    $TBS->Show();
}

function f_sidebar_getmerged()
{
    global $e, $m, $e_script, $e_template, $sidebar;
    include_once 'tbs_class.php';
    $TBS = new clsTinyButStrong();
    $TBS->Source = '[sidebar;file;getbody=body]';
    $TBS->MergeField('sidebar', $sidebar);
    $TBS->Show(TBS_NOTHING);
    return $TBS->Source;
}

 function getTemplateMerge($templateFileName, $vars = null)
 {
     $tbs = new clsTinyButStrong();
     $tbs->LoadTemplate($this->getTemplateDir() . $templateFileName);
     foreach ($vars as $name => $value) {
         if (is_array($value)) {
             $tbs->MergeBlock($name, $value);
         } else {
             $tbs->MergeField($name, $value);
         }
     }
     $tbs->Show(TBS_NOTHING);
     echo $tbs->Source;
 }

 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 permintaan_detail_export($id = 0)
 {
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $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 == 'harga') {
                 $this->db->where('inv_inventaris_habispakai_permintaan_item.harga', $value);
             } elseif ($field != 'year') {
                 $this->db->like($field, $value);
             }
         }
         if (!empty($ord)) {
             $this->db->order_by($ord, $this->input->post('sortorder'));
         }
     }
     $this->db->where('inv_inventaris_habispakai_permintaan_item.id_inv_hasbispakai_permintaan', $id);
     $rows_all_activity = $this->bhp_permintaan_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 == 'harga') {
                 $this->db->where('inv_inventaris_habispakai_permintaan_item.harga', $value);
             } elseif ($field != 'year') {
                 $this->db->like($field, $value);
             }
         }
         if (!empty($ord)) {
             $this->db->order_by($ord, $this->input->post('sortorder'));
         }
     }
     $this->db->where('inv_inventaris_habispakai_permintaan_item.id_inv_hasbispakai_permintaan', $id);
     $activity = $this->bhp_permintaan_model->getItem();
     $data_tabel = array();
     $kodepuskesmas = $this->session->userdata('puskesmas');
     if (substr($kodepuskesmas, -2) == "01") {
         $unlock = 1;
     } else {
         $unlock = 0;
     }
     $no = 1;
     foreach ($activity as $act) {
         $data_tabel[] = array('no' => $no++, 'id_inv_hasbispakai_permintaan' => $act->id_inv_hasbispakai_permintaan, 'id_mst_inv_barang_habispakai' => $act->id_mst_inv_barang_habispakai, 'uraian' => $act->uraian, 'jml' => $act->jml, 'harga' => number_format($act->harga, 2), 'subtotal' => number_format($act->jml * $act->harga, 2), 'tgl_permintaan' => $act->tgl_permintaan, 'status_permintaan' => $act->status_permintaan, 'pilihan_satuan' => $act->pilihan_satuan, 'merek_tipe' => $act->merek_tipe);
     }
     $kode_sess = $this->session->userdata('puskesmas');
     $kd_prov = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode_sess, 0, 2));
     $kd_kab = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode_sess, 0, 4));
     $kd_kec = 'KEC. ' . $this->inv_barang_model->get_nama('nama', 'cl_kec', 'code', substr($kode_sess, 0, 7));
     $namapus = $this->inv_barang_model->get_nama('value', 'cl_phc', 'code', 'P' . $kode_sess);
     $tahun = date("Y");
     $datautama = $this->bhp_permintaan_model->get_data_row($id);
     $tgl_permintaan = date("d-m-Y", strtotime($datautama['tgl_permintaan']));
     $kategori_barang = $this->inv_barang_model->get_nama('uraian', 'mst_inv_barang_habispakai_jenis', 'id_mst_inv_barang_habispakai_jenis', $datautama['id_mst_inv_barang_habispakai_jenis']);
     $status = $datautama['status_permintaan'];
     $jumlah_unit = $datautama['jumlah_unit'];
     $nilai_unit = number_format($datautama['nilai_pembelian'], 2);
     $data_puskesmas[] = array('nama_puskesmas' => $namapus, 'kd_prov' => $kd_prov, 'kd_kab' => $kd_kab, 'tahun' => $tahun, 'kategori_barang' => $kategori_barang, 'tgl_permintaan' => $tgl_permintaan, 'status' => $status, 'jumlah_unit' => $jumlah_unit, 'nilai_unit' => $nilai_unit);
     $dir = getcwd() . '/';
     if ($datautama['id_mst_inv_barang_habispakai_jenis'] == '8') {
         $template = $dir . 'public/files/template/inventory/bhp_permintaan_detail_obat.xlsx';
     } else {
         $template = $dir . 'public/files/template/inventory/bhp_permintaan_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 = uniqid();
     if ($datautama['id_mst_inv_barang_habispakai_jenis'] == '8') {
         $output_file_name = 'public/files/hasil/hasil_export_bhppermintaandetailobat_' . $code . '.xlsx';
     } else {
         $output_file_name = 'public/files/hasil/hasil_export_bhppermintaandetail_' . $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';
 }

            }
            $traitement_data['notification_str'] = '';
            foreach ($traitement->getAbsenceEleveNotifications() as $notification) {
                $traitement_data['notification_str'] .= $notification->getDescription() . '; ';
            }
            $traitement_data['creation_str'] = strftime("%a %d/%m/%Y %H:%M", $traitement->getCreatedAt('U'));
            $traitement_data['modification_str'] = strftime("%a %d/%m/%Y %H:%M", $traitement->getUpdatedAt('U'));
            $traitement_array_avec_data[] = $traitement_data;
        }
    }
    $TBS->MergeBlock('traitement_col', $traitement_array_avec_data);
    // Output as a download file (some automatic fields are merged here)
    $nom_fichier = 'extrait_traitement_';
    $now = new DateTime();
    $nom_fichier .= $now->format("d_m_Y") . '.ods';
    $TBS->Show(OPENTBS_DOWNLOAD + TBS_EXIT, $nom_fichier);
} elseif ('lot' == $imprime) {
    include 'lib/traitements_vers_imprime_lot.php';
}
//==================================
// Décommenter la ligne ci-dessous pour afficher les variables $_GET, $_POST, $_SESSION et $_SERVER pour DEBUG:
//debug_var();
require_once "../lib/header.inc.php";
//**************** FIN EN-TETE *****************
if (!$menu) {
    include 'menu_abs2.inc.php';
}
echo "<div class='css-panes' style='background-color:#ebedb5;' id='containDiv' style='overflow : none; float : left; margin-top : -1px; border-width : 1px;'>\n";
echo '<form method="post" action="liste_traitements.php" id="liste_traitements">';
// 20150404
echo "<input type='hidden' name='envoye_depuis_liste_traitements' value='y' />";

//.........这里部分代码省略.........
     $order = '';
     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);
             $filtername = "and {$field} like " . '"%' . $value . '%"' . "";
         }
         if (!empty($ord)) {
             //$this->db->order_by($ord, $this->input->post('sortorder'));
             $val = $this->input->post('sortorder');
             $order = "order by {$ord} {$val}";
         }
     }
     $filbulan = date("m");
     $filtahun = date("Y");
     $filterbhp = "";
     if ($this->session->userdata('filter_jenisbarang') != '') {
         if ($this->session->userdata('filter_jenisbarang') == "all") {
             $filterbhp = "";
         } else {
             if ($this->session->userdata('filter_jenisbarang') == 'obat') {
                 $jenis = 'obat';
             } else {
                 $jenis = 'umum';
             }
             $filterbhp = " and inv_inventaris_habispakai_opname.jenis_bhp = " . '"' . $jenis . '"' . "";
         }
     } else {
         //$this->db->where("mst_inv_barang_habispakai.id_mst_inv_barang_habispakai_jenis",$kode);
     }
     if ($this->session->userdata('filter_bulan') != '') {
         if ($this->session->userdata('filter_bulan') == "all") {
         } else {
             //$this->db->where("MONTH(tgl_opname)",$this->session->userdata('filter_bulan'));
             $filbulan = $this->session->userdata('filter_bulan');
         }
     } else {
         //$this->db->where("mst_inv_barang_habispakai.id_mst_inv_barang_habispakai_jenis",$kode);
     }
     if ($this->session->userdata('filter_tahun') != '') {
         if ($this->session->userdata('filter_tahun') == "all") {
         } else {
             //$this->db->where("YEAR(tgl_opname)",$this->session->userdata('filter_tahun'));
             $filtahun = $this->session->userdata('filter_tahun');
         }
     } else {
         //$this->db->where("mst_inv_barang_habispakai.id_mst_inv_barang_habispakai_jenis",$kode);
     }
     $puskesmas = $this->input->post('puskesmas');
     $rows = $this->bhp_opname_model->get_data_lap_opname($filbulan, $filtahun, $filterbhp, $filtername, $order, $puskesmas);
     //die(print_r($rows));
     //	$get_jumlahawal = $this->bhp_opname_model->get_jumlahawal();
     $data = array();
     $no = 0;
     $data_tabel = array();
     $temp = '';
     $jml = 0;
     foreach ($rows as $key => $val) {
         $no++;
         foreach ($val as $act => $value) {
             if ($key == $temp) {
                 $data_tabel["{$key}"]["keluar{$act}"] = $value['pengeluaranperhari'] * -1;
                 $data_tabel["{$key}"]["harga"] = $value['harga'];
                 $data_tabel["{$key}"]["jumlah_op"] = $data_tabel["{$key}"]["jumlah_op"] + $value['pengeluaranperhari'];
                 $data_tabel["{$key}"]['nilai_aset_total'] = ($data_tabel["{$key}"]["jumlah_awal"] + $data_tabel["{$key}"]["jumlah_op"]) * $value['harga'];
                 $data_tabel["{$key}"]['total'] = $data_tabel["{$key}"]["jumlah_awal"] + $data_tabel["{$key}"]["jumlah_op"];
                 $data_tabel["{$key}"]['nilai_aset_awal'] = $value['jumlah_awal'] * $value['harga'];
             } else {
                 $temp = $key;
                 $data_tabel[$key] = array('no' => $no, 'uraian' => $key, 'harga' => $value['harga'], 'jumlah_op' => $value['pengeluaranperhari'], 'jumlah_awal' => $value['jumlah_awal'], 'nilai_aset_awal' => $value['jumlah_awal'] * $value['harga'], 'total' => $value['jumlah_awal'] + $value['pengeluaranperhari'], 'nilai_aset_total' => ($value['jumlah_awal'] + $value['pengeluaranperhari']) * $value['harga'], 'keluar1' => $act == 1 ? $value['pengeluaranperhari'] * -1 : '', 'keluar2' => $act == 2 ? $value['pengeluaranperhari'] * -1 : '', 'keluar3' => $act == 3 ? $value['pengeluaranperhari'] * -1 : '', 'keluar4' => $act == 4 ? $value['pengeluaranperhari'] * -1 : '', 'keluar5' => $act == 5 ? $value['pengeluaranperhari'] * -1 : '', 'keluar6' => $act == 6 ? $value['pengeluaranperhari'] * -1 : '', 'keluar7' => $act == 7 ? $value['pengeluaranperhari'] * -1 : '', 'keluar8' => $act == 8 ? $value['pengeluaranperhari'] * -1 : '', 'keluar9' => $act == 9 ? $value['pengeluaranperhari'] * -1 : '', 'keluar10' => $act == 10 ? $value['pengeluaranperhari'] * -1 : '', 'keluar11' => $act == 11 ? $value['pengeluaranperhari'] * -1 : '', 'keluar12' => $act == 12 ? $value['pengeluaranperhari'] * -1 : '', 'keluar13' => $act == 13 ? $value['pengeluaranperhari'] * -1 : '', 'keluar14' => $act == 14 ? $value['pengeluaranperhari'] * -1 : '', 'keluar15' => $act == 15 ? $value['pengeluaranperhari'] * -1 : '', 'keluar16' => $act == 16 ? $value['pengeluaranperhari'] * -1 : '', 'keluar17' => $act == 17 ? $value['pengeluaranperhari'] * -1 : '', 'keluar18' => $act == 18 ? $value['pengeluaranperhari'] * -1 : '', 'keluar19' => $act == 19 ? $value['pengeluaranperhari'] * -1 : '', 'keluar20' => $act == 20 ? $value['pengeluaranperhari'] * -1 : '', 'keluar21' => $act == 21 ? $value['pengeluaranperhari'] * -1 : '', 'keluar22' => $act == 22 ? $value['pengeluaranperhari'] * -1 : '', 'keluar23' => $act == 23 ? $value['pengeluaranperhari'] * -1 : '', 'keluar24' => $act == 24 ? $value['pengeluaranperhari'] * -1 : '', 'keluar25' => $act == 25 ? $value['pengeluaranperhari'] * -1 : '', 'keluar26' => $act == 26 ? $value['pengeluaranperhari'] * -1 : '', 'keluar27' => $act == 27 ? $value['pengeluaranperhari'] * -1 : '', 'keluar28' => $act == 28 ? $value['pengeluaranperhari'] * -1 : '', 'keluar29' => $act == 29 ? $value['pengeluaranperhari'] * -1 : '', 'keluar30' => $act == 30 ? $value['pengeluaranperhari'] * -1 : '', 'keluar31' => $act == 31 ? $value['pengeluaranperhari'] * -1 : '');
             }
         }
     }
     ///die(print_r($data_tabel));
     $kode_sess = $this->session->userdata('puskesmas');
     $kd_prov = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode_sess, 0, 2));
     $kd_kab = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode_sess, 0, 4));
     $nama_puskesmas = $this->input->post('nama_puskesmas');
     //$tgl = date("d-m-Y");
     $jenis_barang = $this->input->post('jenisbarang');
     $tgl = $this->input->post('bulan');
     $tahun = $this->input->post('tahun');
     $tgl1 = date("m-m-Y");
     $tgl2 = date("d-m-Y");
     $data_puskesmas[] = array('jenis_barang' => $jenis_barang, 'kd_prov' => $kd_prov, 'kd_kab' => $kd_kab, 'nama_puskesmas' => $nama_puskesmas, 'bulan' => $tgl, 'tahun' => $tahun, 'tgl1' => $tgl1, 'tgl2' => $tgl2, 'tanggal_export' => $tgl2);
     $dir = getcwd() . '/';
     $template = $dir . 'public/files/template/inventory/lap_bhp_pengeluaran.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 = 'public/files/hasil/hasil_daftarstokopname_' . $code . '.xlsx';
     $output = $dir . $output_file_name;
     $TBS->Show(OPENTBS_FILE, $output);
     // Also merges all [onshow] automatic fields.
     echo base_url() . $output_file_name;
 }

}
// Tells TBS to display information when the document is merged. No exit.
// --------------------------------------------
// Merging and other operations on the template
// --------------------------------------------
// Select slide #2
$TBS->Plugin(OPENTBS_SELECT_SLIDE, 2);
// Change a picture using the command (it can also be done at the template side using parameter "ope=changepic")
$TBS->Plugin(OPENTBS_CHANGE_PICTURE, '#merge_me#', 'pic_1234f.png');
// Merge a chart
$ChartRef = 'my_chart';
// Title of the shape that embeds the chart
$SeriesNameOrNum = 1;
$NewValues = array(array('Cat. A', 'Cat. B', 'Cat. C', 'Cat. D'), array(0.7, 1.0, 3.2, 4.8));
$NewLegend = "Merged";
$TBS->PlugIn(OPENTBS_CHART, $ChartRef, $SeriesNameOrNum, $NewValues, $NewLegend);
// -----------------
// Output the result
// -----------------
// Define the name of the output file
$save_as = isset($_POST['save_as']) && trim($_POST['save_as']) !== '' && $_SERVER['SERVER_NAME'] == 'localhost' ? trim($_POST['save_as']) : '';
$output_file_name = str_replace('.', '_' . date('Y-m-d') . $save_as . '.', $template);
if ($save_as === '') {
    // Output the result as a downloadable file (only streaming, no data saved in the server)
    $TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
    // Also merges all [onshow] automatic fields.
} else {
    // Output the result as a file on the server
    $TBS->Show(OPENTBS_FILE + TBS_EXIT, $output_file_name);
    // Also merges all [onshow] automatic fields.
}

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

       "$mulaipassport", 
       "$akhirpassport", 
       "$jenispembiayaan - $sumber_pembiayaan", 
       "$no_kitas", 
       "$tgl_kitas", 
       "$tgl_kitas_akhir", 
       "$no_skld", 
       "$tgl_update"]);
       */
    $data_opentbs[] = array("no" => "{$no}", "nama" => "{$namamahasiswa} {$namamahasiswa2}", "kelamin" => "{$jl}", "ttl" => "{$tempatlahir} / {$tanggallahir}", "negara" => "{$country}", "alamat" => "{$alamat}", "alamatindo" => "{$alamatind}", "institusi" => "{$universitas}", "prodi" => "{$fakultas_idfakultas} - {$penyelenggara_program}", "program" => "{$namajenjangstudi} <br/>{$keterangan_jenjang}", "jenisijin" => "{$status_doc}", "lama" => "{$lamaijin}", "tgl_awal" => "{$mulaibelajar}", "ijin_awal" => "{$periode_belajar_start}", "ijin_akhir" => "{$periode_belajar_end}", "passport" => "{$nmrpaspor}", "tgl_pasport" => "{$mulaipassport}", "tgl_akhir_pasport" => "{$akhirpassport}", "pendanaan" => "{$jenispembiayaan} - {$sumber_pembiayaan}", "kitas" => "{$no_kitas}", "tgl_awal_kitas" => "{$tgl_kitas}", "tgl_akhir_kitas" => "{$tgl_kitas_akhir}", "skld" => "{$no_skld}", "tgl_ijin_akhir" => "{$tgl_update}");
}
/**
 * Opent tbs command
 */
$TBS->MergeBlock('t2', $data_opentbs);
$TBS->Show(OPENTBS_FILE, $newFilePath);
/**
 * spout command
 */
/*
$reader->close();
$writer->close();
*/
//echo "</tbody></table></body></html>";
/*$tgl_update=date("Y-m-d");
$objPHPExcel->getActiveSheet()->removeRow( $baseRow, 1 );
$objWriter = PHPExcel_IOFactory::createWriter( $objPHPExcel, 'Excel5' );
$objWriter->save( "berkas/$tgl_update-rekapitulasi-ijin-belajar.xls" );
$UTILITY->location_goto("berkas/$tgl_update-rekapitulasi-ijin-belajar.xls");*/
//header("location:http://google.com");
$UTILITY->location_goto($newFilePath);

 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 permohonan_export()
 {
     $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 == 'status_sertifikat_tanggal') {
                 $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('filterruangan') != '') {
         $filter = $this->session->userdata('filterruangan');
         $this->db->where("id_ruangan", $filter);
     }
     if ($this->session->userdata('filter_cl_phc') != '') {
         $kodeplch = $this->session->userdata('filter_cl_phc');
         $this->db->where("id_cl_phc", $kodeplch);
     }
     if ($this->session->userdata('filterHAPUS') != '') {
         $this->db->where("pilihan_status_invetaris", "3");
     }
     if ($this->session->userdata('filterHAPUS') == '' || $this->session->userdata('filterGIB') != '') {
         $this->db->where("pilihan_status_invetaris !=", "3");
     }
     $rows_all = $this->inv_barang_model->get_data_golongan_A();
     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 == 'status_sertifikat_tanggal') {
                 $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('filterruangan') != '') {
         $filter = $this->session->userdata('filterruangan');
         $this->db->where("id_ruangan", $filter);
     }
     if ($this->session->userdata('filter_cl_phc') != '') {
         $kodeplch = $this->session->userdata('filter_cl_phc');
         $this->db->where("id_cl_phc", $kodeplch);
     }
     if ($this->session->userdata('filterHAPUS') != '') {
         $this->db->where("pilihan_status_invetaris", "3");
     }
     if ($this->session->userdata('filterHAPUS') == '' || $this->session->userdata('filterGIB') != '') {
         $this->db->where("pilihan_status_invetaris !=", "3");
     }
     $rows = $this->inv_barang_model->get_data_golongan_A();
     $data_tabel = array();
     $no = 1;
     foreach ($rows as $act) {
         $data_tabel[] = array('no' => $no++, 'id_inventaris_barang' => $act->id_inventaris_barang, 'id_mst_inv_barang' => $act->id_mst_inv_barang, 'uraian' => $act->uraian, 'id_pengadaan' => $act->id_pengadaan, 'barang_kembar_proc' => $act->barang_kembar_proc, 'satuan' => $act->satuan, 'id_ruangan' => $act->id_ruangan, 'hak' => $act->hak, 'id_cl_phc' => $act->id_cl_phc, 'register' => $act->register, 'asal_usul' => $act->asal_usul, 'keterangan_pengadaan' => $act->keterangan_pengadaan, 'harga' => number_format($act->harga, 2), 'jumlah' => $act->jumlah, 'jumlah_satuan' => $act->jumlah . ' ' . $act->satuan, 'penggunaan' => $act->penggunaan, 'luas' => $act->luas, 'alamat' => $act->alamat, 'pilihan_satuan_barang' => $act->pilihan_satuan_barang, 'pilihan_status_hak' => $act->pilihan_status_hak, 'status_sertifikat_tanggal' => date("d-m-Y", strtotime($act->status_sertifikat_tanggal)), 'status_sertifikat_nomor' => $act->status_sertifikat_nomor, 'pilihan_penggunaan' => $act->pilihan_penggunaan, 'edit' => 1, 'delete' => 1);
     }
     if (empty($this->input->post('puskes')) or $this->input->post('puskes') == 'Pilih Puskesmas') {
         $namapus = 'Semua Data Puskesmas';
     } else {
         $namapus = $this->input->post('puskes');
     }
     if (empty($this->input->post('ruang')) or $this->input->post('ruang') == 'Pilih Ruangan') {
         $namaruang = 'Semua Data Ruangan';
     } else {
         $namaruang = $this->input->post('ruang');
     }
     $data_puskesmas[] = array('nama_puskesmas' => $namapus, 'nama_puskesmas' => $namaruang);
     $template = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\template\\inventory\\kiba.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     // Merge data in the first sheet
     $TBS->MergeBlock('a', $data_tabel);
     $TBS->MergeBlock('b', $data_puskesmas);
     $code = uniqid();
     $output_file_name = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\hasil\\hasil_export_' . $code . '.xlsx';
     $TBS->Show(OPENTBS_FILE, $output_file_name);
     // Also merges all [onshow] automatic fields.
     echo base_url() . 'public/files/hasil/hasil_export_' . $code . '.xlsx';
 }