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 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); }
//request success } } } } //Display Results >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> if ($proceed == true) { $result = array(); $sql = "SELECT * FROM general_settings"; $query = @mysql_query($sql); while ($result1 = @mysql_fetch_array($query)) { $result[] = $result1; } } //////////////////////////////// //display form with error message //////////////////////////////// $show_content_menu = 0; //display top tabs as set in /includes/menuloader $template = "templates/main.html"; $inner_template1 = "templates/inner_settings.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;
<?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();
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; }
$error_code = errorcodes($codes); if (!empty($error_code)) { $message_type = $error_code['error_type']; $error_message = $error_code['error_message']; $error_height = '230px;'; // display error $template = "themes/{$user_theme}/templates/main_1.htm"; $inner_template1 = "themes/{$user_theme}/templates/inner_notification.htm"; $TBS = new clsTinyButStrong(); $TBS->NoErr = true; $TBS->LoadTemplate("{$template}"); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die; } // get members overall site ranking for badge display $member_id = $poster_id; $member_badge = member_site_ranking($member_id); $div_style_height = ($limit + $replies_count) * 160; $blog_url = $base_url . "/read_blog/" . $blog_id . "/" . $result[title_seo]; $template = "themes/{$user_theme}/templates/main_1.htm"; $inner_template1 = "themes/{$user_theme}/templates/inner_read_blog.htm"; $TBS = new clsTinyButStrong(); $TBS->NoErr = true; $TBS->LoadTemplate("{$template}"); $TBS->MergeBlock('blk1', $all_categories); $TBS->MergeBlock('blk3', $result_search3); $TBS->Render = TBS_OUTPUT; $TBS->show(); die;
$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. // -------------------------------------------- // Merging and other operations on the template // -------------------------------------------- // Merge data in a table (there is no need to select the slide with an ODP) $TBS->MergeBlock('b', $data); // Hide a slide $TBS->PlugIn(OPENTBS_DISPLAY_SLIDES, 'slide to hide', false); // Delete a slide $TBS->PlugIn(OPENTBS_DELETE_SLIDES, 'slide to delete'); // ----------------- // 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 {
<?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();
function excel() { $this->authentication->verify('spkp_renstra_dit', 'show'); $data = $this->spkp_renstra_dit_model->json_renstra_dit(); $rows = $data[0]['Rows']; $data['title'] = "Rencana Strategis DIT/SPKP"; $path = dirname(__FILE__) . '/../../public/doc_xls_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/renstra_dit.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_renstra_dit.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); //echo $output_file_name; echo '../public/doc_xls_export/report_renstra_dit.xlsx'; }
//$nom_fichier_xml_a_traiter ='content.xml'; //les chemins contenant les données $fb_gab_perso = getSettingValue("fb_gab_perso"); if ($fb_gab_perso == "1") { // Gestion du multisite if ($_SESSION['rne'] != '') { $rne = $_SESSION['rne'] . "/"; } else { $rne = ''; } $nom_dossier_modele_a_utiliser = "../../mod_ooo/mes_modeles/" . $rne; } else { $nom_dossier_modele_a_utiliser = "../../mod_ooo/modeles_gepi/"; } // TODO vérifier les chemins comme /mod_ooo/lib/chemin.inc.php // Création d'une classe TBS OOo class $OOo = new clsTinyButStrong(); $OOo->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $OOo->LoadTemplate($nom_dossier_modele_a_utiliser . $nom_fichier_modele_ooo, OPENTBS_ALREADY_UTF8); $OOo->MergeBlock('eleves', $tab_eleves_OOo); //Génération du nom du fichier $now = gmdate('d_M_Y_H:i:s'); $nom_fichier_modele = explode('.', $nom_fichier_modele_ooo); $nom_fic = $nom_fichier_modele[0] . "_" . $now . "." . $nom_fichier_modele[1]; $OOo->Show(OPENTBS_DOWNLOAD, $nom_fic); $OOo->remove(); //suppression des fichiers de travail $OOo->close(); //======================================= // FIN AFFICHAGE DES DONNÉES //=======================================
$OOo = new clsTinyButStrong; // new instance of TBS $OOo->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); // load OpenTBS plugin $OOo->LoadTemplate($nom_dossier_modele_a_utiliser.$nom_fichier_modele_ooo, OPENTBS_ALREADY_UTF8); // Traitement des tableaux // On insère ici les lignes concernant la gestion des tableaux if (!$page_garde) { //~ $OOo->mergeXml( //~ array( //~ 'name' => 'page_garde', //~ 'type' => 'clear')); $OOo->MergeBlock('page_garde','clear'); } else { //~ $OOo->mergeXmlBlock('page_garde',array('fake')); // Juste pour que le bloc s'initialise correctement $OOo->MergeBlock('page_garde',array('fake')); } if (!$releve) { //~ $OOo->mergeXml( //~ array( //~ 'name' => 'releve', //~ 'type' => 'clear')); $OOo->MergeBlock('releve','clear'); } else { //~ $OOo->mergeXmlBlock('releve',array('fake')); // Juste pour que le bloc s'initialise correctement $OOo->MergeBlock('releve',array('fake')); }
} if (sizeof($albums_list) > 0) { $show_albums = 1; } else { $show_albums = 0; } // PAGINATION PLUS >> start -- reusable code $hide_numbering = true; //show only <<previous Next>>> $url = 'javascript:void(0)" onClick="javascript:ahahscript.ahah(\'albums_ajax.php'; //the url to be put in links - EDIT ME $ahah_pagination = "', 'Ajax-Albums', '', 'GET', '', this);"; //for ajax pagination $additional_url_variable = '?page='; //add addtions information that goes in query string here include 'includes/pagination.inc.php'; $ablums_pagination = $show_pages; // PAGINATION PLUS >> end $template = "themes/{$user_theme}/templates/inner_albums_ajax.htm"; $TBS = new clsTinyButStrong(); $TBS->NoErr = true; $TBS->LoadTemplate("{$template}"); $TBS->MergeBlock('mp', $all_albums); $TBS->MergeBlock('blk1', $albums_list); $TBS->Render = TBS_OUTPUT; $TBS->tbs_show(); @mysql_close(); die; ?>
} else { $show_v = 2; } //PAGINATION PLUS >> start $url = 'genre'; $additional_url_variable = '/' . $channel . '/'; include_once 'includes/pagination.inc.php'; //PAGINATION PLUS >> end if ($codes == "") { $codes = $codes_internal; } $error_code = errorcodes($codes); if (!empty($error_code)) { $blk_code = $error_code['error_display']; $code_type = $error_code['error_type']; $code_message = $error_code['error_message']; } $blk_id = 0; //html table - error block $template = "themes/{$user_theme}/templates/main_1.htm"; $inner_template1 = "themes/{$user_theme}/templates/inner_genre_home.htm"; $TBS = new clsTinyButStrong(); $TBS->NoErr = true; $TBS->LoadTemplate("{$template}"); $TBS->MergeBlock('blkfeatured', $result_featured); $TBS->MergeBlock('blk1', $all_categories); $TBS->MergeBlock('blk2', $all_albums); $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; }
<?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();
$template = 'templates/demo_ms.xlsx'; $debug = 0; $suffix = ''; $fecha = date('d/m/Y'); // Load the template $TBS->LoadTemplate($template); if ($debug == 2) { // debug mode 2 $TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT); exit; } elseif ($debug == 1) { // debug mode 1 $TBS->Plugin(OPENTBS_DEBUG_INFO); exit; } $TBS->MergeBlock('a', $data); // Define the name of the output file // delete comments $TBS->PlugIn(OPENTBS_DELETE_COMMENTS); $file_name = str_replace('.', '_' . date('Y-m-d') . '.', $template); // Output as a download file (some automatic fields are merged here) if ($debug == 3) { // debug mode 3 $TBS->Plugin(OPENTBS_DEBUG_XML_SHOW); } elseif ($suffix === '') { // download $TBS->Show(OPENTBS_DOWNLOAD, $file_name); } else { // save as file $file_name = str_replace('.', '_' . $suffix . '.', $file_name); $TBS->Show(OPENTBS_FILE + TBS_EXIT, $file_name);
function permohonan_detail_export() { $code_cl_phc = $this->input->post('code_cl_phc'); $id = $this->input->post('kode'); $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); //[data_tabel.no;block=tbs:row] [data_tabel.tgl] [data_tabel.ruangan] [data_tabel.jumlah] [data_tabel.keterangan] [data_tabel.status] $this->authentication->verify('inventory', 'show'); if ($_POST) { $fil = $this->input->post('filterscount'); $ord = $this->input->post('sortdatafield'); for ($i = 0; $i < $fil; $i++) { $field = $this->input->post('filterdatafield' . $i); $value = $this->input->post('filtervalue' . $i); if ($field == 'tanggal_permohonan') { $value = date("Y-m-d", strtotime($value)); $this->db->where($field, $value); } elseif ($field != 'year') { $this->db->like($field, $value); } } if (!empty($ord)) { $this->db->order_by($ord, $this->input->post('sortorder')); } } #$rows = $this->permohonanbarang_model->get_data($this->input->post('recordstartindex'), $this->input->post('pagesize')); $this->db->where('code_cl_phc', $code_cl_phc); $activity = $this->permohonanbarang_model->getItem('inv_permohonan_barang_item', array('id_inv_permohonan_barang' => $id))->result(); $data = array(); $no = 1; $data_tabel = array(); foreach ($activity as $act) { $data_tabel[] = array('no' => $no++, 'nama_barang' => $act->nama_barang, 'jumlah' => $act->jumlah, 'keterangan' => $act->keterangan); } if (empty($this->input->post('nama_puskesmas')) or $this->input->post('nama_puskesmas') == 'Pilih Puskesmas') { $nama = 'Semua Data Puskesmas'; } else { $nama = $this->input->post('nama_puskesmas'); } $tanggal = $this->input->post('tanggal'); $keterangan = $this->input->post('keterangan'); $ruang = $this->input->post('ruang'); $puskesmas = $nama; #$data_puskesmas[] = array('nama_puskesmas' => $nama, 'tanggal'=> $tanggal, 'keterangan'=>$keterangan, 'ruang'=>$ruang); $data_puskesmas['nama_puskesmas'] = $nama; $data_puskesmas['tanggal'] = $tanggal; $data_puskesmas['ruang'] = $ruang; $data_puskesmas['keterangan'] = $keterangan; $TBS->ResetVarRef(false); $TBS->VarRef =& $data_puskesmas; $template = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\template\\inventory\\permohonan_barang_detail.xlsx'; $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8); // Merge data in the first sheet $TBS->MergeBlock('a', $data_tabel); #$TBS->MergeBlock('b', $data_puskesmas); $code = date('Y-m-d-H-i-s'); $output_file_name = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\hasil\\hasil_detail_export_' . $code . '.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); // Also merges all [onshow] automatic fields. echo base_url() . 'public/files/hasil/hasil_detail_export_' . $code . '.xlsx'; }
function export_detail() { $this->authentication->verify('inventory', 'show'); $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $filter_group = $this->session->userdata('filter_group'); $no = 1; $data_tabel = array(); if (!empty($filter_group) and $filter_group == '1') { $rows = $this->inv_ruangan_model->get_data_detail_group(); $data = array(); foreach ($rows as $act) { $act['no'] = $no++; $act['harga'] = number_format($act['harga']); $act['kode_barang'] = substr(chunk_split($act['id_mst_inv_barang'], 2, '.'), 0, 14); $act['keterangan'] = ""; $data_tabel[] = $act; } } else { $rows = $this->inv_ruangan_model->get_data_detail(); $data = array(); foreach ($rows as $act) { $act['no'] = $no++; $act['kode_barang'] = substr(chunk_split($act['id_mst_inv_barang'], 2, '.'), 0, 14); $act['harga'] = number_format($act['harga']); $data_tabel[] = $act; } } $code_cl_phc = $this->input->post('filter_code_cl_phc'); $ruang = $this->input->post('filter_id_ruang'); $tanggal = $this->input->post('filter_tanggal'); if (empty($code_cl_phc) or $code_cl_phc == 'Pilih Puskesmas') { $kode = "P" . $this->session->userdata('puskesmas'); $nama = "Data Seluruh Puskesmas"; } else { $kode = $this->input->post('filter_code_cl_phc'); $puskesmas = $this->inv_barang_model->get_nama('value', 'cl_phc', 'code', $kode); $nama = $puskesmas; } if (empty($ruang) or $ruang == 'Pilih Ruangan') { $namaruang = 'Data Seluruh Ruangan'; } else { $this->db->where('id_mst_inv_ruangan', $ruang); $this->db->where('code_cl_phc', $kode); $ruang = $this->db->get('mst_inv_ruangan')->row(); $namaruang = !empty($ruang) ? $ruang->nama_ruangan : "-"; } $propinsi = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode, 1, 2)); $kabkota = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode, 1, 4)); $kecamatan = $this->inv_barang_model->get_nama('nama', 'cl_kec', 'code', substr($kode, 1, 7)); $tanggals = explode("-", $tanggal); $tanggal_export = $tanggals[2] . '-' . $tanggals[1] . '-' . $tanggals[0]; $data_puskesmas['puskesmas'] = $nama; $data_puskesmas['tanggal'] = $tanggal_export; $data_puskesmas['ruangan'] = $namaruang; $data_puskesmas['kecamatan'] = $kecamatan; $data_puskesmas['kabkota'] = $kabkota; $data_puskesmas['propinsi'] = $propinsi; $TBS->ResetVarRef(false); $TBS->VarRef =& $data_puskesmas; $dir = getcwd() . '/'; $template = $dir . 'public/files/template/inventory/kir.xlsx'; $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8); $TBS->MergeBlock('a', $data_tabel); $code = date('Y-m-d-H-i-s'); $output_file_name = 'public/files/hasil/hasil_kir_' . $code . '.xlsx'; $output = $dir . $output_file_name; $TBS->Show(OPENTBS_FILE, $output); // Also merges all [onshow] automatic fields. echo base_url() . $output_file_name; }
function 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 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; }
} if ($traitement->getAbsenceEleveJustification() != null) { $traitement_data['justification_str'] = $traitement->getAbsenceEleveJustification()->getNom(); } else { $traitement_data['justification_str'] = ''; } $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';
$nb_retards = 0; foreach ($eleve_col as $eleve) { $eleve_array_avec_data[$eleve->getPrimaryKey()] = Array( 'eleve' => $eleve , 'getDemiJourneesAbsencePreRempli' => $eleve->getNbAbsences() , 'getDemiJourneesNonJustifieesPreRempli' => $eleve->getNbNonJustifiees() , 'getRetardsPreRempli' => $eleve->getNbRetards() ); $nb_demijournees = $nb_demijournees + $eleve->getNbAbsences(); $nb_nonjustifiees = $nb_nonjustifiees + $eleve->getNbNonJustifiees(); $nb_retards = $nb_retards + $eleve->getNbRetards(); } $TBS->MergeBlock('eleve_col', $eleve_array_avec_data); $TBS->MergeField('eleve_count', $eleve_col->count()); $TBS->MergeField('nb_demijournees',$nb_demijournees); $TBS->MergeField('nb_nonjustifiees', $nb_nonjustifiees); $TBS->MergeField('nb_retards', $nb_retards); // Output as a download file (some automatic fields are merged here) $nom_fichier = 'extrait_demi-journee_'; if ($classe != null) { $nom_fichier .= $classe->getNom().'_'; } $nom_fichier .= $dt_date_absence_eleve_fin->format("d_m_Y").'.ods'; $TBS->Show(OPENTBS_DOWNLOAD+TBS_EXIT, $nom_fichier); } ?>
function excel_tukin($id, $thn = "", $bln = "") { $this->authentication->verify('spkp_absen_tunjangan', 'show'); $data = $this->spkp_absen_tunjangan_model->json_absen($id, $thn, $bln); $rows = $data[0]['Rows']; if (!is_array($rows)) { $rows = array(); } $data['title'] = "Absensi - Tunjangan Kinerja " . $thn . "-" . $bln; $path = dirname(__FILE__) . '/../../public/doc_xls_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/absensi_tukin.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_absensi_tukin.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); echo '../public/doc_xls_export/report_absensi_tukin.xlsx'; }
function 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; }
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; }
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; }
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_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'; }