Esempio n. 1
0
 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');
 }
Esempio n. 2
0
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 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;
 }
Esempio n. 4
0
 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;
 }
Esempio n. 6
0
<?php

// Use this PHP File As your Development
// ****************  Default include  ****************
// include All file
include_once '../all.php';
// New template engine object
$TBS = new clsTinyButStrong();
// Load Your HTML file
$TBS->LoadTemplate('index.html');
// <----- Place this script HTML
// ****************************************************
// **************  Write Your Code Here  **************
$title = 'Rojak Engine Examples';
$message = 'Examples';
// Scan All files in current directory
$links = scandir('./');
// Check each link for filter . .. index.php user and all .html
foreach ($links as $key => $link) {
    if (substr($link, -5) == '.html' || $link == '.' || $link == '..' || $link == 'index.php' || $link == 'user') {
        // Remove that array
        unset($links[$key]);
    }
}
// Merge array to HTML
$TBS->MergeBlock('blk1', $links);
// ****************************************************
// Show result
$TBS->Show();
Esempio n. 7
0
 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 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;
 }
Esempio n. 9
0
 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';
 }
Esempio n. 10
0
$data = array();
$data[] = array('rank' => 'A', 'firstname' => 'Sandra', 'name' => 'Hill', 'number' => '1523d', 'score' => 200, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
$data[] = array('rank' => 'A', 'firstname' => 'Roger', 'name' => 'Smith', 'number' => '1234f', 'score' => 800, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
$data[] = array('rank' => 'B', 'firstname' => 'William', 'name' => 'Mac Dowell', 'number' => '5491y', 'score' => 130, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
// Other single data items
$x_num = 3152.456;
$x_pc = 0.2567;
$x_dt = mktime(13, 0, 0, 2, 15, 2010);
$x_bt = true;
$x_bf = false;
$x_delete = 1;
// -----------------
// Load the template
// -----------------
$template = '%template%';
$TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
// Also merge some [onload] automatic fields (depends of the type of document).
// ----------------------
// Debug mode of the demo
// ----------------------
if (isset($_POST['debug']) && $_POST['debug'] == 'current') {
    $TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT, true);
}
// Display the intented XML of the current sub-file, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'info') {
    $TBS->Plugin(OPENTBS_DEBUG_INFO, true);
}
// Display information about the document, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
    $TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
Esempio n. 11
0
 function permohonan_export_kibf()
 {
     $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_mulai') {
                 $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->input->post('puskes') != '') {
         $this->db->where("id_cl_phc", $this->input->post('puskes'));
     } else {
         $this->db->where("id_cl_phc", $this->session->userdata('filter_cl_phc'));
     }
     $rows_all = $this->inv_barang_model->get_data_golongan_F();
     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_mulai') {
                 $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->input->post('puskes') != '') {
         $this->db->where("id_cl_phc", $this->input->post('puskes'));
     } else {
         $this->db->where("id_cl_phc", $this->session->userdata('filter_cl_phc'));
     }
     $rows = $this->inv_barang_model->get_data_golongan_F();
     $no = 1;
     $data_tabel = array();
     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, 'tanah' => $act->tanah, 'beton' => $act->beton, 'tingkat' => $act->tingkat, 'id_pengadaan' => $act->id_pengadaan, 'id_cl_phc' => $act->id_cl_phc, 'register' => $act->register, 'harga' => number_format($act->harga, 2), 'keterangan_pengadaan' => $act->keterangan_pengadaan, 'asal_usul' => $act->asal_usul, 'jumlah' => $act->jumlah, 'barang_kembar_proc' => $act->barang_kembar_proc, 'bangunan' => $act->bangunan, 'pilihan_konstruksi_bertingkat' => $act->pilihan_konstruksi_bertingkat, 'pilihan_konstruksi_beton' => $act->pilihan_konstruksi_beton, 'luas' => $act->luas, 'lokasi' => $act->lokasi, 'dokumen_tanggal' => $act->dokumen_tanggal, 'dokumen_nomor' => $act->dokumen_nomor, 'tanggal_mulai' => $act->tanggal_mulai, 'pilihan_status_tanah' => $act->pilihan_status_tanah, 'edit' => 1, 'delete' => 1);
     }
     $puskes = $this->input->post('puskes');
     $ruang = $this->input->post('ruang');
     $tanggal_export = $this->input->post('filter_tanggal');
     if (empty($puskes) or $puskes == 'Pilih Puskesmas') {
         $kode = 'P ' . $this->session->userdata('puskesmas');
         $kd_prov = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode, 2, 2));
         $kd_kab = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode, 2, 4));
         $kd_kec = 'KEC. ' . $this->inv_barang_model->get_nama('nama', 'cl_kec', 'code', substr($kode, 2, 7));
         $kd_upb = 'KEC. ' . $this->inv_barang_model->get_nama('nama', 'cl_kec', 'code', substr($kode, 2, 7));
     } else {
         $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));
         $kd_upb = $this->input->post('namepuskes');
         $kode = $this->input->post('puskes');
     }
     if (empty($ruang) or $ruang == 'Pilih Ruangan') {
         $namaruang = 'Semua Data Ruangan';
     } else {
         $namaruang = $this->input->post('ruang');
     }
     if (empty($tanggal_export) or $tanggal_export == '') {
         $tanggal_export = date('d-m-Y');
     } else {
         $tanggals = explode("-", $this->input->post('filter_tanggal'));
         $tanggal_export = $tanggals[2] . '-' . $tanggals[1] . '-' . $tanggals[0];
     }
     $data_puskesmas[] = array('kode' => $kode, 'namaruang' => $namaruang, 'kd_prov' => $kd_prov, 'kd_kab' => $kd_kab, 'kd_kec' => $kd_kec, 'kd_upb' => $kd_upb, 'tanggal_export' => $tanggal_export);
     $dir = getcwd() . '/';
     $template = $dir . 'public/files/template/inventory/kibf.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 = 'public/files/hasil/hasil_export_KIBF_' . $code . '.xlsx';
     $output = $dir . $output_file_name;
     $TBS->Show(OPENTBS_FILE, $output);
     // Also merges all [onshow] automatic fields.
     echo base_url() . $output_file_name;
 }
<?php

if (isset($this)) {
    // We are under the TBS Subtemplate Mode => variables are local by default and the TBS object is referenced by variable $this.
    $TBS =& $this;
} else {
    // This sub-script can also be run under the normal mode => its corresponding template will be displayed like a main template.
    include_once 'tbs_class.php';
    $TBS = new clsTinyButStrong();
}
global $err_log;
// Don't forget that variables are local by default in the Subtemplate Mode.
if (isset($_POST['btn_ok'])) {
    // Imagine we check the login/password...
    $err_log = 1;
} else {
    $err_log = 0;
}
$TBS->LoadTemplate('tbs_us_examples_subtpl_login.htm');
$TBS->Show();
// When calling this method in Subtemplate Mode, the main script won't end, and this merged subtemplated will be inserted into the main template.
 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;
 }
Esempio n. 14
0
<?php

include_once 'tbs_class.php';
$TBS = new clsTinyButStrong();
include_once 'tbs_plugin_cache.php';
// Load the Cache System library
$TBS->PlugIn(TBS_INSTALL, TBS_CACHE, dirname(__FILE__));
// Install the plug-in
// Call the Cache System which is deciding wheter to continue and store the result into a cache file, or to display a cached page.
if ($TBS->PlugIn(TBS_CACHE, 'testcache', 10)) {
} else {
    $TBS->LoadTemplate('tbs_us_examples_cache.htm');
    $TBS->Show();
}
<?php

include_once 'tbs_class.php';
//Connexion to the database
/* Use the example below.
$cnx_id = sqlite_open('mydatabase.dat');
*/
$sql_ok = isset($cnx_id) && is_resource($cnx_id) ? 1 : 0;
if ($sql_ok == 0) {
    $cnx_id = 'clear';
}
// makes the block to be cleared instead of merged with an SQL query.
$TBS = new clsTinyButStrong();
$TBS->LoadTemplate('tbs_us_examples_datamysql.htm');
$TBS->MergeBlock('blk1', $cnx_id, 'SELECT * FROM t_tbs_exemples');
$TBS->Show();
Esempio n. 16
0
function die_with_msg($message)
{
    $show_notification = 1;
    $template = "templates/inner_upload_avatar.htm";
    $TBS = new clsTinyButStrong();
    $TBS->NoErr = true;
    $TBS->LoadTemplate("{$template}");
    $TBS->Render = TBS_OUTPUT;
    $TBS->tbs_show();
    @mysql_close();
    die;
}
<?php

include_once 'tbs_class.php';
$country = array('France', 'England', 'Spain', 'Italy', 'Germany');
$TBS = new clsTinyButStrong();
$TBS->LoadTemplate('tbs_us_examples_blocks.htm');
$TBS->MergeBlock('blk1,blk2,blk3,blk4,blk5,blk6,blk7', $country);
// Merge several blocks with the same data
$TBS->Show();
Esempio n. 18
0
                </script>\n";
            }
        }
    }
} else if ($affichage == 'ods') {
    // load the TinyButStrong libraries    
	include_once('../tbs/tbs_class.php'); // TinyButStrong template engine
    
    //include_once('../tbs/plugins/tbsdb_php.php');
    $TBS = new clsTinyButStrong; // new instance of TBS
    include_once('../tbs/plugins/tbs_plugin_opentbs.php');
    $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); // load OpenTBS plugin

    // Load the template
	$extraction_demi_journees=repertoire_modeles('absence_extraction_demi-journees.ods');
    $TBS->LoadTemplate($extraction_demi_journees, OPENTBS_ALREADY_UTF8);

    $titre = 'Extrait des demi-journées d\'absences du '.$dt_date_absence_eleve_debut->format('d/m/Y').' au '.$dt_date_absence_eleve_fin->format('d/m/Y');
    $classe = null;
    if ($id_classe != null && $id_classe != '') {
	$classe = ClasseQuery::create()->findOneById($id_classe);
	if ($classe != null) {
	    $titre .= ' pour la classe '.$classe->getNom();
	}
    }
    if ($nom_eleve != null && $nom_eleve != '' ) {
	$titre .= ' pour les élèves dont le nom ou le prénom contient '.$nom_eleve;
    }
    $TBS->MergeField('titre', $titre);

    $eleve_array_avec_data = Array();
Esempio n. 19
0
$data = array();
$data[] = array('rank' => 'A', 'firstname' => 'Sandra', 'name' => 'Hill', 'number' => '1523d', 'score' => 200, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
$data[] = array('rank' => 'A', 'firstname' => 'Roger', 'name' => 'Smith', 'number' => '1234f', 'score' => 800, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
$data[] = array('rank' => 'B', 'firstname' => 'William', 'name' => 'Mac Dowell', 'number' => '5491y', 'score' => 130, 'email_1' => '*****@*****.**', 'email_2' => '*****@*****.**', 'email_3' => '*****@*****.**');
// Other single data items
$x_num = 3152.456;
$x_pc = 0.2567;
$x_dt = mktime(13, 0, 0, 2, 15, 2010);
$x_bt = true;
$x_bf = false;
$x_delete = 1;
// -----------------
// Load the template
// -----------------
$template = 'demo_ms_powerpoint.pptx';
$TBS->LoadTemplate($template);
// Also merge some [onload] automatic fields (depends of the type of document).
// ----------------------
// Debug mode of the demo
// ----------------------
if (isset($_POST['debug']) && $_POST['debug'] == 'current') {
    $TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT, true);
}
// Display the intented XML of the current sub-file, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'info') {
    $TBS->Plugin(OPENTBS_DEBUG_INFO, true);
}
// Display information about the document, and exit.
if (isset($_POST['debug']) && $_POST['debug'] == 'show') {
    $TBS->Plugin(OPENTBS_DEBUG_XML_SHOW);
}
<?php

include_once 'tbs_class.php';
//Default value
if (!isset($_GET)) {
    $_GET =& $HTTP_GET_VARS;
}
if (isset($_GET['empty'])) {
    $empty = $_GET['empty'];
} else {
    $empty = 0;
}
if ($empty) {
    $url = '';
    $image = '';
    $line1 = '1 New Avenue';
    $line2 = '';
} else {
    $url = 'www.tinybutstrong.com';
    $image = 'tbs_us_examples_prmmagnet.gif';
    $line1 = '2 Main Street';
    $line2 = '3rd floor';
}
$TBS = new clsTinyButStrong();
$TBS->LoadTemplate('tbs_us_examples_prmmagnet.htm');
$TBS->Show();
 function laporan_opname($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);
             $this->db->like($field, $value);
         }
         if (!empty($ord)) {
             $this->db->order_by($ord, $this->input->post('sortorder'));
         }
     }
     if ($this->session->userdata('filter_jenisbarang') != '') {
         if ($this->session->userdata('filter_jenisbarang') == "all") {
         } else {
             //$this->db->where("jenis_bhp",$this->session->userdata('filter_jenisbarang'));
         }
     } 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'));
         }
     } 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'));
         }
     } else {
         //$this->db->where("mst_inv_barang_habispakai.id_mst_inv_barang_habispakai_jenis",$kode);
     }
     $rows_all = $this->bhp_opname_model->get_data();
     $filtername = '';
     $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;
 }
 function laporan_json_allopname($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 == '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 ($id != 0) {
         $this->db->where('inv_inventaris_habispakai_opname_item.id_inv_inventaris_habispakai_opname', $id);
     }
     if ($this->session->userdata('filter_jenisbarang') != '') {
         if ($this->session->userdata('filter_jenisbarang') == "all") {
         } else {
             $this->db->where("jenis_bhp", $this->session->userdata('filter_jenisbarang'));
         }
     } 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'));
         }
     } else {
         $this->db->where("MONTH(tgl_opname)", date("m"));
     }
     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'));
         }
     } else {
         $this->db->where("YEAR(tgl_opname)", date("Y"));
     }
     if ($this->session->userdata('filter_code_cl_phc') != '') {
         if ($this->session->userdata('filter_code_cl_phc') == 'all') {
             # code...
         } else {
             $this->db->where('code_cl_phc', $this->session->userdata('filter_code_cl_phc'));
         }
     }
     $rows_all_activity = $this->bhp_pemusnahan_model->getallopname();
     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 ($id != 0) {
         $this->db->where('inv_inventaris_habispakai_opname_item.id_inv_inventaris_habispakai_opname', $id);
     }
     if ($this->session->userdata('filter_jenisbarang') != '') {
         if ($this->session->userdata('filter_jenisbarang') == "all") {
         } else {
             $this->db->where("jenis_bhp", $this->session->userdata('filter_jenisbarang'));
         }
     } 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'));
         }
     } else {
         $this->db->where("MONTH(tgl_opname)", date("m"));
     }
     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'));
         }
     } else {
         $this->db->where("YEAR(tgl_opname)", date("Y"));
     }
     if ($this->session->userdata('filter_code_cl_phc') != '') {
         if ($this->session->userdata('filter_code_cl_phc') == 'all') {
             # code...
         } else {
             $this->db->where('code_cl_phc', $this->session->userdata('filter_code_cl_phc'));
         }
     }
     $activity = $this->bhp_pemusnahan_model->getallopname();
     $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_mst_inv_barang_habispakai' => $act->id_mst_inv_barang_habispakai, 'batch' => $act->batch, 'uraian' => $act->uraian, 'id_inv_inventaris_habispakai_opname' => $act->id_inv_inventaris_habispakai_opname, 'jml_awal' => $act->jml_awal, 'jml_akhir' => $act->jml_akhir, 'tipe' => ucfirst($act->tipe), 'harga' => $act->harga, 'merek_tipe' => $act->merek_tipe, 'tgl_opname' => date("d-m-Y", strtotime($act->tgl_opname)), 'jml_selisih' => ($act->jml_akhir - $act->jml_awal) * -1, 'edit' => 1, 'delete' => 1);
     }
     $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');
     $data_puskesmas[] = array('jenis_barang' => $jenis_barang, 'kd_prov' => $kd_prov, 'kd_kab' => $kd_kab, 'nama_puskesmas' => $nama_puskesmas, 'bulan' => $tgl, 'tahun' => $tahun);
     $dir = getcwd() . '/';
     $template = $dir . 'public/files/template/inventory/bhp_telahdimusnahkan.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_bhptelahdimusnahkan_' . $code . '.xlsx';
     $output = $dir . $output_file_name;
     $TBS->Show(OPENTBS_FILE, $output);
     // Also merges all [onshow] automatic fields.
     echo base_url() . $output_file_name;
 }
Esempio n. 23
0
}
$results = $traitements_col->getResults();
if ($affichage == 'tableur') {
    include_once 'lib/function.php';
    // load the TinyButStrong libraries
    include_once '../tbs/tbs_class.php';
    // TinyButStrong template engine
    //include_once('../tbs/plugins/tbsdb_php.php');
    $TBS = new clsTinyButStrong();
    // new instance of TBS
    include_once '../tbs/plugins/tbs_plugin_opentbs.php';
    $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
    // load OpenTBS plugin
    // Load the template
    $extraction_traitement = repertoire_modeles('absence_extraction_traitements.ods');
    $TBS->LoadTemplate($extraction_traitement, OPENTBS_ALREADY_UTF8);
    $titre = 'Extrait des traitement d\'absences';
    $TBS->MergeField('titre', $titre);
    $traitement_array_avec_data = array();
    foreach ($results as $traitement) {
        if (isset($_POST['envoye_depuis_liste_traitements'])) {
            if (isset($_POST['liste_traitements_id_traitement']) && in_array($traitement->getPrimaryKey(), $_POST['liste_traitements_id_traitement'])) {
                $extraire_ce_traitement = "y";
            } else {
                $extraire_ce_traitement = "n";
            }
        } else {
            $extraire_ce_traitement = "y";
        }
        if ($extraire_ce_traitement == "y") {
            $traitement_data = array();
 public function reporteAction($contratoproducto_id)
 {
     include_once 'tbs_us/tbs_class.php';
     // Load the TinyButStrong template engine
     include_once 'tbs_us/tbs_plugin_opentbs/tbs_plugin_opentbs.php';
     // Load the OpenTBS plugin
     $this->view->disable();
     $model = new Planpagos();
     $resul = $model->getcontrato($contratoproducto_id);
     $this->view->setVar('contratoproducto', $resul[0]);
     $garantia = Garantias::find(array('baja_logica=1 and contratoproducto_id = ' . $contratoproducto_id, 'order' => 'tipo,fecha_deposito ASC'));
     // $derechollave = Garantias::findFirst(array('baja_logica=1 and tipo=2 and contratoproducto_id = '.$contratoproducto_id, 'order'=>'tipo ASC'));
     $TBS = new clsTinyButStrong();
     // new instance of TBS
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     // load the OpenTBS plugin
     $TBS->VarRef['usuario'] = $this->_user->nombre . ' ' . $this->_user->paterno;
     $TBS->VarRef['contrato'] = $resul[0]->contrato;
     $TBS->VarRef['razon_social'] = $resul[0]->razon_social;
     $TBS->VarRef['fecha_inicio'] = date('d-m-Y', strtotime($resul[0]->fecha_inicio));
     $TBS->VarRef['fecha_fin'] = date('d-m-Y', strtotime($resul[0]->fecha_fin));
     $TBS->VarRef['grupo'] = $resul[0]->grupo;
     $TBS->VarRef['linea'] = $resul[0]->linea;
     $TBS->VarRef['estacion'] = $resul[0]->estacion;
     $TBS->VarRef['producto'] = $resul[0]->producto;
     $model = new Planpagos();
     $resul = $model->listacontrolpago($contratoproducto_id);
     $contrato = $model->datoscontrato($contratoproducto_id);
     $hoy = date("Y-m-d");
     // $dias =10;
     // $fecha_10 = date("Y-m-d",strtotime( '+'.$dias.' day' , strtotime($hoy)));
     $data = array();
     foreach ($resul as $v) {
         $html = $this->depositos($v->id, $v->diferencia, 1);
         $diff = $v->monto_programado - $v->monto_reprogramado;
         $diff_text = '';
         if ($diff > 0) {
             $diff_text = '<span class="label label-primary" style="float:left">' . number_format($diff, 2, ".", ",") . '</span>';
         }
         /* calculo de mora */
         $dias_atraso = '';
         $mora = '';
         $fecha_tolerancia = date("Y-m-d", strtotime('+' . $contrato[0]->dias_tolerancia . ' day', strtotime($v->fecha_programado)));
         if ($fecha_tolerancia < date("Y-m-d")) {
             if ($v->mora > 0) {
                 $dias_atraso = $v->dias_atraso;
                 $mora = $v->mora;
             } elseif ($v->deposito_total < $v->monto_reprogramado) {
                 $datetime1 = new DateTime($fecha_tolerancia);
                 $datetime2 = new DateTime(date("Y-m-d"));
                 $interval = $datetime1->diff($datetime2);
                 $dias_atraso = $interval->format('%R%a');
                 $mora = $contrato[0]->total / $contrato[0]->nro_dias * $contrato[0]->porcentaje_mora * $dias_atraso;
             }
         }
         /* fin calculo de mora*/
         $data[] = array('rank' => 'A', 'fecha_programado' => date("d-m-Y", strtotime($v->fecha_programado)), 'monto_programado' => $v->monto_reprogramado, 'nro_factura' => str_replace("</div>", "\n", str_replace("<div>", "", $html[6])), 'fecha_factura' => str_replace("</div>", "\n", str_replace("<div>", "", $html[7])), 'monto_factura' => str_replace("</div>", "\n", str_replace("<div>", "", $html[8])), 'nro_deposito' => str_replace("</div>", "\n", str_replace("<div>", "", $html[0])), 'fecha_deposito' => str_replace("</div>", "\n", str_replace("<div>", "", $html[1])), 'monto_deposito' => str_replace("</div>", "\n", str_replace("<div>", "", $html[2])), 'dias_atraso' => $v->dias_atraso, 'mora' => $mora, 'nro_deposito_mora' => str_replace("</div>", "\n", str_replace("<div>", "", $html[3])), 'fecha_deposito_mora' => str_replace("</div>", "\n", str_replace("<div>", "", $html[4])), 'monto_deposito_mora' => str_replace("</div>", "\n", str_replace("<div>", "", $html[5])), 'factura_total' => $v->factura_total, 'deposito_total' => $v->deposito_total, 'mora_total' => $v->mora_total);
     }
     $data1 = array();
     foreach ($garantia as $g) {
         $data1[] = array('rank' => 'C', 'tipo' => $this->tipo[$g->tipo], 'nro_deposito' => $g->nro_deposito, 'fecha_deposito' => date("d-m-Y", strtotime($g->fecha_deposito)), 'monto_deposito' => $g->monto_deposito);
     }
     $template = 'file/template/temp_reporte_planpagos.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     // Also merge some [onload] automatic fields (depends of the type of document).
     // ----------------------
     // Debug mode of the demo
     // ----------------------
     // if (isset($_POST['debug']) && ($_POST['debug']=='current')) $TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT, true); // Display the intented XML of the current sub-file, and exit.
     // if (isset($_POST['debug']) && ($_POST['debug']=='info'))    $TBS->Plugin(OPENTBS_DEBUG_INFO, true); // Display information about the document, and exit.
     // if (isset($_POST['debug']) && ($_POST['debug']=='show'))    $TBS->Plugin(OPENTBS_DEBUG_XML_SHOW); // Tells TBS to display information when the document is merged. No exit.
     // Merge data in the first sheet
     $TBS->MergeBlock('a,b', $data);
     $TBS->MergeBlock('c,d', $data1);
     // -----------------
     // Output the result
     // -----------------
     // $output_file_name = str_replace('.', '_'.date('Y-m-d').'.', $template);
     $output_file_name = date('Y-m-d') . ' ' . 'reporte.xlsx';
     $TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
     // Also merges all [onshow] automatic fields.
     exit;
 }
Esempio n. 25
0
 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';
 }
Esempio n. 26
0
<?php

// Use this PHP File As your Development
// ****************  Default include  ****************
// include All file
include_once '../all.php';
// New template engine object
$TBS = new clsTinyButStrong();
// Load Your HTML file
$TBS->LoadTemplate('main.html');
// <----- Place this script HTML
// ****************************************************
// **************  Write Your Code Here  **************
$title = 'Rojak Engine';
$message = 'Mix and Match';
// Include user Class
include 'user_class.php';
// Initial the class
$user = new user();
// Check the logged in email level
if (!$user->checkuser($_SESSION['member_email'], '1')) {
    // Goto Login Page
    header('location: openid.php');
    exit;
}
// Welcome logged in email
$message = 'Welcome home, ' . $_SESSION['member_email'];
// ****************************************************
// Show result
$TBS->Show();
// **************  Example Code Here  *****************
Esempio n. 27
0
 function data_export_dp3($id_pegawai = 0, $tahun = 0)
 {
     $TBS = new clsTinyButStrong();
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     $this->authentication->verify('kepegawaian', 'show');
     $rows = $this->drh_model->get_rowdataexport($id_pegawai, $tahun);
     $data_table = array();
     $no = 1;
     $data_table[] = array('skp' => $rows['skp'], 'nilaiskp' => $rows['skp'] * 60 / 100, 'id_pegawai' => $rows['id_pegawai'], 'tahun' => $rows['tahun'], 'id_pegawai_penilai' => $rows['id_pegawai_penilai'], 'id_pegawai_penilai_atasan' => $rows['id_pegawai_penilai_atasan'], 'pelayanan' => $rows['pelayanan'], 'nilai_pelayanan' => $this->nilaidata($rows['pelayanan']), 'integritas' => $rows['integritas'], 'nilai_integritas' => $this->nilaidata($rows['integritas']), 'komitmen' => $rows['komitmen'], 'nilai_komitmen' => $this->nilaidata($rows['komitmen']), 'disiplin' => $rows['disiplin'], 'nilai_disiplin' => $this->nilaidata($rows['disiplin']), 'kerjasama' => $rows['kerjasama'], 'nilai_kerjasama' => $this->nilaidata($rows['kerjasama']), 'kepemimpinan' => $rows['kepemimpinan'], 'nilai_kepemimpinan' => $this->nilaidata($rows['kepemimpinan']), 'jumlah' => $rows['jumlah'], 'nilai_jumlah' => $this->nilaidata($rows['jumlah']), 'ratarata' => $rows['ratarata'], 'nilai_ratarata' => $this->nilaidata($rows['ratarata']), 'nilai_rata' => $rows['ratarata'] * 40 / 100, 'nilai_prestasi' => $rows['nilai_prestasi'], 'nilai_nilai_prestasi' => $this->nilaidata($rows['nilai_prestasi']), 'keberatan' => $rows['keberatan'], 'keberatan_tgl' => $this->tgldatadp3($rows['keberatan_tgl']), 'tanggapan' => $rows['tanggapan'], 'tanggapan_tgl' => $this->tgldatadp3($rows['tanggapan_tgl']), 'keputusan' => $rows['keputusan'], 'keputusan_tgl' => $this->tgldatadp3($rows['keputusan_tgl']), 'rekomendasi' => $rows['rekomendasi'], 'tgl_diterima' => $this->tgldatadp3($rows['tgl_diterima']), 'tgl_dibuat' => $this->tgldatadp3($rows['tgl_dibuat']), 'tgl_diterima_atasan' => $this->tgldatadp3($rows['tgl_diterima_atasan']));
     // die(print_r($data_table));
     $datapenilai = $this->nipterakhirpenilaiprint($id_pegawai);
     $dataatasanpenilai = $this->atasannipterakhirpenilaiprint($id_pegawai);
     $pegawaiyangditilai = $this->yangditilai($id_pegawai);
     if ($datapenilai != '0') {
         $data_penilai[] = array('nama_penilai' => $datapenilai['gelar_depan'] . ' ' . $datapenilai['nama'] . ' ' . $datapenilai['gelar_belakang'], 'nip_nit_penilai' => $datapenilai['nip_nit'], 'pangkat_penilai' => $datapenilai['id_mst_peg_golruang'] . ' ' . $datapenilai['ruang'], 'jabatan_penilai' => $datapenilai['namajabatan'], 'unit_penilai' => 'Dinas Kesehatan ' . $datapenilai['value']);
     } else {
         $data_penilai[] = array('nama_penilai' => '-', 'nip_nit_penilai' => '-', 'pangkat_penilai' => '-', 'jabatan_penilai' => '-', 'unit_penilai' => '-');
     }
     if ($dataatasanpenilai != 0) {
         $dataatasan_penilai[] = array('nama_atasan_penilai' => $dataatasanpenilai['gelar_depan'] . ' ' . $dataatasanpenilai['nama'] . ' ' . $dataatasanpenilai['gelar_belakang'], 'nip_nit_atasan_penilai' => $dataatasanpenilai['nip_nit'], 'pangkat_atasan_penilai' => $dataatasanpenilai['id_mst_peg_golruang'] . ' ' . $dataatasanpenilai['ruang'], 'jabatan_atasan_penilai' => $dataatasanpenilai['namajabatan'], 'unit_atasan_penilai' => 'Dinas Kesehatan ' . $dataatasanpenilai['value']);
     } else {
         $dataatasan_penilai[] = array('nama_atasan_penilai' => '-', 'nip_nit_atasan_penilai' => '-', 'pangkat_atasan_penilai' => '-', 'jabatan_atasan_penilai' => '-', 'unit_atasan_penilai' => '-');
     }
     if ($pegawaiyangditilai != 0) {
         $data_yangdinilai[] = array('nama_pegawai' => $pegawaiyangditilai['gelar_depan'] . ' ' . $pegawaiyangditilai['nama'] . ' ' . $pegawaiyangditilai['gelar_belakang'], 'nip_nit_pegawai' => $pegawaiyangditilai['nip_nit'], 'pangkat_pegawai' => $pegawaiyangditilai['id_mst_peg_golruang'] . ' ' . $pegawaiyangditilai['ruang'], 'jabatan_pegawai' => $pegawaiyangditilai['namajabatan'], 'unit_pegawai' => 'Dinas Kesehatan ' . $pegawaiyangditilai['value']);
     } else {
         $data_yangdinilai[] = array('nama_pegawai' => '-', 'nama_pegawai' => '-', 'pangkat_pegawai' => '-', 'jabatan_pegawai' => '-', 'unit_pegawai' => '-');
     }
     $puskes = $this->input->post('puskes');
     $kode_sess = $this->session->userdata('puskesmas');
     $kd_prov = $this->drh_model->get_nama('value', 'cl_province', 'code', substr($kode_sess, 0, 2));
     $puskes = $this->drh_model->get_nama('value', 'cl_phc', 'code', 'P' . $kode_sess);
     $kd_kab = $this->drh_model->get_nama('value', 'cl_district', 'code', substr($kode_sess, 0, 4));
     $kd_kec = 'KEC. ' . $this->drh_model->get_nama('nama', 'cl_kec', 'code', substr($kode_sess, 0, 7));
     $tahun_ = date("Y");
     $data_puskesmas[] = array('nama_puskesmas' => $puskes, 'kd_prov' => $kd_prov, 'kd_kab' => $kd_kab, 'tahun' => $tahun_);
     $dir = getcwd() . '/';
     $template = $dir . 'public/files/template/kepegawaian/dppp_pengukuran_belakang.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     // Merge data in the first sheet
     $TBS->MergeBlock('d', $dataatasan_penilai);
     $TBS->MergeBlock('a', $data_table);
     $TBS->MergeBlock('b', $data_yangdinilai);
     $TBS->MergeBlock('c', $data_penilai);
     $code = date('Y-m-d-H-i-s');
     $output_file_name = 'public/files/hasil/hasil_export_penilaiandppp' . $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_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';
 }
Esempio n. 29
0
    $yearcount_as_string = $yearcount;
    settype($yearcount_as_string, "string");
    if ($yearcount_as_string == $year) {
        $yearselect = $yearselect . '<option value="' . $yearcount . '" selected>&nbsp;' . $yearcount . '&nbsp;</option>';
    } else {
        $yearselect = $yearselect . '<option value="' . $yearcount . '" ' . $selected . '>&nbsp;  ' . $yearcount . '&nbsp;  </option>';
    }
}
//Handle errors that may crash browser
$errors = 0;
if (mysql_error()) {
    $errors = 1;
    //this stops flash from loading
    $show_notification = 1;
    $message = $config["error_26"];
}
////////////////////////////////
//display form with error message
////////////////////////////////
$template = "templates/main.html";
$inner_template1 = "templates/inner_statistics.htm";
//middle of page
$TBS = new clsTinyButStrong();
$TBS->NoErr = true;
// no more error message displayed.
$TBS->LoadTemplate("{$template}");
//$TBS->MergeBlock('adminblk', $result);
$TBS->Render = TBS_OUTPUT;
$TBS->Show();
@mysql_close();
die;
 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;
 }