function module_admin_footer($main = "", $n = "") { global $blocks, $main, $module_css, $module_menu; include_once XOOPS_ROOT_PATH . '/common/tbs/tbs_class_php5.php'; $TBS = new clsTinyButStrong(); $TBS->LoadTemplate(XOOPS_ROOT_PATH . "/common/themes/" . WEB_THEME . "/index.html", False); $TBS->Show(); }
function f_sidebar_getmerged() { global $e, $m, $e_script, $e_template, $sidebar; include_once 'tbs_class.php'; $TBS = new clsTinyButStrong(); $TBS->Source = '[sidebar;file;getbody=body]'; $TBS->MergeField('sidebar', $sidebar); $TBS->Show(TBS_NOTHING); return $TBS->Source; }
function getTemplateMerge($templateFileName, $vars = null) { $tbs = new clsTinyButStrong(); $tbs->LoadTemplate($this->getTemplateDir() . $templateFileName); foreach ($vars as $name => $value) { if (is_array($value)) { $tbs->MergeBlock($name, $value); } else { $tbs->MergeField($name, $value); } } $tbs->Show(TBS_NOTHING); echo $tbs->Source; }
public function __construct() { // construct the TBS class parent::__construct(); // load the OpenTBS plugin $this->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); }
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 excel() { $BulanIndo = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember"); $POST = array(); $data['query'] = $this->admin_users_model->get_list(); $userlist = $data['query']; for ($i = 0; $i < sizeof($userlist); $i++) { if ($userlist[$i]['birthdate'] != null) { $tgl_tmp = explode("/", $userlist[$i]['birthdate']); $userlist[$i]['birthdate'] = (int) $tgl_tmp[0] . " " . $BulanIndo[(int) $tgl_tmp[1] - 1] . " " . $tgl_tmp[2]; } $userlist[$i]['last_login'] = "" . date("d-m-Y h:i:s", $userlist[$i]['last_login']); $userlist[$i]['last_active'] = "" . date("d-m-Y h:i:s", $userlist[$i]['last_active']); } $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = dirname(__FILE__) . '/../../public/files/excel/list_user.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('a,b', $userlist); $output_file_name = 'list_user.xlsx'; $TBS->Show(OPENTBS_DOWNLOAD, $output_file_name); }
function permintaan_detail_export($id = 0) { $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $this->authentication->verify('inventory', 'show'); if ($_POST) { $fil = $this->input->post('filterscount'); $ord = $this->input->post('sortdatafield'); for ($i = 0; $i < $fil; $i++) { $field = $this->input->post('filterdatafield' . $i); $value = $this->input->post('filtervalue' . $i); if ($field == 'harga') { $this->db->where('inv_inventaris_habispakai_permintaan_item.harga', $value); } elseif ($field != 'year') { $this->db->like($field, $value); } } if (!empty($ord)) { $this->db->order_by($ord, $this->input->post('sortorder')); } } $this->db->where('inv_inventaris_habispakai_permintaan_item.id_inv_hasbispakai_permintaan', $id); $rows_all_activity = $this->bhp_permintaan_model->getItem(); if ($_POST) { $fil = $this->input->post('filterscount'); $ord = $this->input->post('sortdatafield'); for ($i = 0; $i < $fil; $i++) { $field = $this->input->post('filterdatafield' . $i); $value = $this->input->post('filtervalue' . $i); if ($field == 'harga') { $this->db->where('inv_inventaris_habispakai_permintaan_item.harga', $value); } elseif ($field != 'year') { $this->db->like($field, $value); } } if (!empty($ord)) { $this->db->order_by($ord, $this->input->post('sortorder')); } } $this->db->where('inv_inventaris_habispakai_permintaan_item.id_inv_hasbispakai_permintaan', $id); $activity = $this->bhp_permintaan_model->getItem(); $data_tabel = array(); $kodepuskesmas = $this->session->userdata('puskesmas'); if (substr($kodepuskesmas, -2) == "01") { $unlock = 1; } else { $unlock = 0; } $no = 1; foreach ($activity as $act) { $data_tabel[] = array('no' => $no++, 'id_inv_hasbispakai_permintaan' => $act->id_inv_hasbispakai_permintaan, 'id_mst_inv_barang_habispakai' => $act->id_mst_inv_barang_habispakai, 'uraian' => $act->uraian, 'jml' => $act->jml, 'harga' => number_format($act->harga, 2), 'subtotal' => number_format($act->jml * $act->harga, 2), 'tgl_permintaan' => $act->tgl_permintaan, 'status_permintaan' => $act->status_permintaan, 'pilihan_satuan' => $act->pilihan_satuan, 'merek_tipe' => $act->merek_tipe); } $kode_sess = $this->session->userdata('puskesmas'); $kd_prov = $this->inv_barang_model->get_nama('value', 'cl_province', 'code', substr($kode_sess, 0, 2)); $kd_kab = $this->inv_barang_model->get_nama('value', 'cl_district', 'code', substr($kode_sess, 0, 4)); $kd_kec = 'KEC. ' . $this->inv_barang_model->get_nama('nama', 'cl_kec', 'code', substr($kode_sess, 0, 7)); $namapus = $this->inv_barang_model->get_nama('value', 'cl_phc', 'code', 'P' . $kode_sess); $tahun = date("Y"); $datautama = $this->bhp_permintaan_model->get_data_row($id); $tgl_permintaan = date("d-m-Y", strtotime($datautama['tgl_permintaan'])); $kategori_barang = $this->inv_barang_model->get_nama('uraian', 'mst_inv_barang_habispakai_jenis', 'id_mst_inv_barang_habispakai_jenis', $datautama['id_mst_inv_barang_habispakai_jenis']); $status = $datautama['status_permintaan']; $jumlah_unit = $datautama['jumlah_unit']; $nilai_unit = number_format($datautama['nilai_pembelian'], 2); $data_puskesmas[] = array('nama_puskesmas' => $namapus, 'kd_prov' => $kd_prov, 'kd_kab' => $kd_kab, 'tahun' => $tahun, 'kategori_barang' => $kategori_barang, 'tgl_permintaan' => $tgl_permintaan, 'status' => $status, 'jumlah_unit' => $jumlah_unit, 'nilai_unit' => $nilai_unit); $dir = getcwd() . '/'; if ($datautama['id_mst_inv_barang_habispakai_jenis'] == '8') { $template = $dir . 'public/files/template/inventory/bhp_permintaan_detail_obat.xlsx'; } else { $template = $dir . 'public/files/template/inventory/bhp_permintaan_detail.xlsx'; } $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8); // Merge data in the first sheet $TBS->MergeBlock('a', $data_tabel); $TBS->MergeBlock('b', $data_puskesmas); $code = uniqid(); if ($datautama['id_mst_inv_barang_habispakai_jenis'] == '8') { $output_file_name = 'public/files/hasil/hasil_export_bhppermintaandetailobat_' . $code . '.xlsx'; } else { $output_file_name = 'public/files/hasil/hasil_export_bhppermintaandetail_' . $code . '.xlsx'; } $output = $dir . $output_file_name; $TBS->Show(OPENTBS_FILE, $output); // Also merges all [onshow] automatic fields. echo base_url() . $output_file_name; }
function 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_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'; }
/** * Redefinition of TBS method to add parameter 'cell' to set value with native OpenDocument format in spreadsheet * * refactoring code from egroupware/perp_api/inc/report/ooo.inc.php * * @param string $Txt TBS source * @param string $Loc TBS locator * @param string $Value TBS data to merge * @param string $CheckSub TBS checksub ??? */ public function meth_Locator_Replace(&$Txt, &$Loc, &$Value, $CheckSub) { if (!isset($Loc->PrmLst['type']) && !isset($Loc->PrmLst['image']) && !isset($Loc->PrmLst['link'])) { return parent::meth_Locator_Replace($Txt, $Loc, $Value, $CheckSub); } // keep 'Loc' position for the end $posBeg = $Loc->PosBeg; $posEnd = $Loc->PosEnd; // get data $data = isset($Value) ? $Value : null; foreach ($Loc->SubLst as $sub) { $data = isset($Value[$sub]) ? $Value[$sub] : null; } // ----- parameter = type if (isset($Loc->PrmLst['type'])) { if ($data == '') { $Txt = substr_replace($Txt, '', $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; return $Loc->PosBeg; } // get container enlarged to table:table-cell $Loc->Enlarged = $this->f_Loc_EnlargeToStr($Txt, $Loc, '<table:table-cell', '/table:table-cell>'); $container = substr($Txt, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); if ($container == '') { throw new tinyDocException(sprintf('<table:table-cell not found in document "%s"', $this->getXmlFilename())); } // OpenOffice attributes cell - see : http://books.evc-cit.info/odbook/ch05.html#table-cells-section switch ($Loc->PrmLst['type']) { case 'datetime': case 'date': case 'dt': case 'd': $attribute = sprintf('office:value-type="date" office:date-value="%s"', str_replace(' ', 'T', $data)); break; case 'time': case 't': list($h, $m, $s) = split(":", $data); $attribute = sprintf('office:value-type="time" office:time-value="PT%sH%sM%sS"', $h, $m, $s); break; case 'percentage': case 'percent': case 'p': $attribute = sprintf('office:value-type="percentage" office:value="%s"', $data); break; case 'currency': case 'cur': case 'c': //$attribute = sprintf('office:value-type="currency" office:currency="EUR" office:value="%s"', $data); // still not necessary to fix the currency $attribute = sprintf('office:value-type="currency" office:value="%s"', $data); break; case 'number': case 'n': case 'float': case 'f': $attribute = sprintf('office:value-type="float" office:value="%s"', $data); break; case 'int': case 'i': $attribute = sprintf('office:value-type="float" office:value="%d"', $data); break; default: case 'string': case 's': $attribute = sprintf('office:value-type="string"'); break; } // new container $newContainer = preg_replace('/office:value-type="string"/', $attribute, $container); // replace the new cell containter in the main Txt $Txt = substr_replace($Txt, $newContainer, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); // correct 'Loc' to include the change of the new cell container $delta = strlen($newContainer) - strlen($container); $Loc->PosBeg = $posBeg + $delta; $Loc->PosEnd = $posEnd + $delta; $Loc->Enlarged = null; } // ----- parameter = image if (isset($Loc->PrmLst['image'])) { // get container enlarged to draw:frame $Loc->Enlarged = $this->f_Loc_EnlargeToStr($Txt, $Loc, '<draw:frame', '/draw:frame>'); $container = substr($Txt, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); if ($container == '') { throw new tinyDocException(sprintf('<draw:frame not found in document "%s"', $this->getXmlFilename())); } // test if data is empty or if file not exists if ($data == '' || !file_exists($data)) { $Txt = substr_replace($Txt, '', $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; $Loc->Enlarged = null; return $Loc->PosBeg; } $picture = 'Pictures/' . basename($data); // image size $size = @getimagesize($data); if ($size === false) { throw new tinyDocException(sprintf('Invalid image format "%"', $data)); } else { list($width, $height) = $size; } // image ratio $ratio = 1; switch (strtolower($Loc->PrmLst['image'])) { case 'fit': if (preg_match('/svg:width="(.*?)(cm|in|mm|px)" svg:height="(.*?)(cm|in|mm|px)"/', $container, $matches)) { $ratio_w = self::convertToCm($matches[1], $matches[2]) / self::convertToCm($width, 'px'); $ratio_h = self::convertToCm($matches[3], $matches[4]) / self::convertToCm($height, 'px'); $ratio = min($ratio_w, $ratio_h); } break; case 'max': if (preg_match('/svg:width="(.*?)(cm|in|mm|px)" svg:height="(.*?)(cm|in|mm|px)"/', $container, $matches)) { $ratio_w = self::convertToCm($matches[1], $matches[2]) / self::convertToCm($width, 'px'); $ratio_h = self::convertToCm($matches[3], $matches[4]) / self::convertToCm($height, 'px'); $ratio = min(1, $ratio_w, $ratio_h); } break; default: if (preg_match('/([0-9\\.]*)%/', $Loc->PrmLst['image'], $matches) > 0) { $ratio = $matches[1] / 100; } break; } // replace values $newContainer = $container; $newContainer = preg_replace('/svg:width="(.*?)"/', sprintf('svg:width="%scm"', self::convertToCm($width, 'px') * $ratio), $newContainer); $newContainer = preg_replace('/svg:height="(.*?)"/', sprintf('svg:height="%scm"', self::convertToCm($height, 'px') * $ratio), $newContainer); $newContainer = preg_replace('/xlink:href="(.*?)"/', sprintf('xlink:href="%s"', $picture), $newContainer); // add file $this->addFile($data, $picture); // replace the new cell containter in the main Txt $Txt = substr_replace($Txt, $newContainer, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; $Loc->Enlarged = null; } // ----- parameter = link if (isset($Loc->PrmLst['link'])) { if ($data == '') { $Txt = substr_replace($Txt, '', $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; return $Loc->PosBeg; } $container = substr($Txt, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); $title = $Loc->PrmLst['link'] != '1' ? $Loc->PrmLst['link'] : $data; $newContainer = sprintf('<text:a xlink:type="simple" xlink:href="%s">%s</text:a>', $data, $title); $Txt = substr_replace($Txt, $newContainer, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); // before return, restore 'Loc' with beginning values (to work with block) $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; return $Loc->PosEnd; } // call the parent method to insert the value $ret = parent::meth_Locator_Replace($Txt, $Loc, $Value, $CheckSub); // before return, restore 'Loc' with beginning values (to work with block) $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; return $ret; }
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;
<?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 *****************
$query = @mysql_query($sql); $result = @mysql_fetch_array($query); $title = $result["gallery_name"]; $description = $result["gallery_description"]; $tags = $result["gallery_tags"]; $allow_comments = 'allow_comments_' . $result["allow_comments"]; $allow_ratings = 'allow_ratings_' . $result["allow_ratings"]; $public_private = 'public_private_' . $result["public_private"]; //seting "selected" value for HTML pull down lists ${$allow_comments} = "selected"; ${$allow_ratings} = "selected"; ${$public_private} = "selected"; if (isset($_POST['submit'])) { //get form post (no mysql_real_escapE) $title = $_POST["title"]; $description = $_POST["description"]; $tags = $_POST["tags"]; } //////////// //disply page //////////// $template = "templates/inner_edit_album.htm"; //middle of page $TBS = new clsTinyButStrong(); $TBS->NoErr = true; // no more error message displayed. $TBS->LoadTemplate("{$template}"); $TBS->Render = TBS_OUTPUT; $TBS->tbs_show(); @mysql_close(); die;
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; }
<?php // Include classes include_once 'tbs_class.php'; // Load the TinyButStrong template engine include_once '../tbs_plugin_opentbs.php'; // Load the OpenTBS plugin // Initalize the TBS instance $TBS = new clsTinyButStrong(); // new instance of TBS $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); // load the OpenTBS plugin // ------------------------------ // Prepare some data for the demo // ------------------------------ // Retrieve the user name to display $yourname = isset($_POST['yourname']) ? $_POST['yourname'] : ''; $yourname = trim('' . $yourname); if ($yourname == '') { $yourname = "(no name)"; } // A recordset for merging tables $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;
function permohonan_detail_export() { $code_cl_phc = $this->input->post('code_cl_phc'); $id = $this->input->post('kode'); $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); //[data_tabel.no;block=tbs:row] [data_tabel.tgl] [data_tabel.ruangan] [data_tabel.jumlah] [data_tabel.keterangan] [data_tabel.status] $this->authentication->verify('inventory', 'show'); if ($_POST) { $fil = $this->input->post('filterscount'); $ord = $this->input->post('sortdatafield'); for ($i = 0; $i < $fil; $i++) { $field = $this->input->post('filterdatafield' . $i); $value = $this->input->post('filtervalue' . $i); if ($field == 'tanggal_permohonan') { $value = date("Y-m-d", strtotime($value)); $this->db->where($field, $value); } elseif ($field != 'year') { $this->db->like($field, $value); } } if (!empty($ord)) { $this->db->order_by($ord, $this->input->post('sortorder')); } } #$rows = $this->permohonanbarang_model->get_data($this->input->post('recordstartindex'), $this->input->post('pagesize')); $this->db->where('code_cl_phc', $code_cl_phc); $activity = $this->permohonanbarang_model->getItem('inv_permohonan_barang_item', array('id_inv_permohonan_barang' => $id))->result(); $data = array(); $no = 1; $data_tabel = array(); foreach ($activity as $act) { $data_tabel[] = array('no' => $no++, 'nama_barang' => $act->nama_barang, 'jumlah' => $act->jumlah, 'keterangan' => $act->keterangan); } if (empty($this->input->post('nama_puskesmas')) or $this->input->post('nama_puskesmas') == 'Pilih Puskesmas') { $nama = 'Semua Data Puskesmas'; } else { $nama = $this->input->post('nama_puskesmas'); } $tanggal = $this->input->post('tanggal'); $keterangan = $this->input->post('keterangan'); $ruang = $this->input->post('ruang'); $puskesmas = $nama; #$data_puskesmas[] = array('nama_puskesmas' => $nama, 'tanggal'=> $tanggal, 'keterangan'=>$keterangan, 'ruang'=>$ruang); $data_puskesmas['nama_puskesmas'] = $nama; $data_puskesmas['tanggal'] = $tanggal; $data_puskesmas['ruang'] = $ruang; $data_puskesmas['keterangan'] = $keterangan; $TBS->ResetVarRef(false); $TBS->VarRef =& $data_puskesmas; $template = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\template\\inventory\\permohonan_barang_detail.xlsx'; $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8); // Merge data in the first sheet $TBS->MergeBlock('a', $data_tabel); #$TBS->MergeBlock('b', $data_puskesmas); $code = date('Y-m-d-H-i-s'); $output_file_name = dirname(__FILE__) . '\\..\\..\\..\\public\\files\\hasil\\hasil_detail_export_' . $code . '.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); // Also merges all [onshow] automatic fields. echo base_url() . 'public/files/hasil/hasil_detail_export_' . $code . '.xlsx'; }
function excel_upload($thn) { $this->authentication->verify('spkp_promotion_subdit', 'show'); $data = $this->spkp_promotion_subdit_model->json_upload($thn); $rows = $data[0]['Rows']; $data['title'] = "Daftar File Kegiatan Subdit Promosi"; $data['thn'] = "Tahun " . $thn; $path = dirname(__FILE__) . '/../../public/doc_xls_'; $TBS = new clsTinyButStrong(); $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); $TBS->ResetVarRef(false); $TBS->VarRef =& $data; $template = $path . 'templates/kegiatan_subdit_promosi_file.xlsx'; $TBS->LoadTemplate($template); $TBS->MergeBlock('data', $rows); $output_file_name = $path . 'export/report_kegiatan_subdit_promosi_file.xlsx'; $TBS->Show(OPENTBS_FILE, $output_file_name); // echo $output_file_name; echo '../public/doc_xls_export/report_kegiatan_subdit_promosi_file.xlsx'; }
function 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 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; }
} } $query->distinct(); $traitements_col = $query->paginate($page_number, $item_per_page); $nb_pages = floor($traitements_col->getNbResults() / $item_per_page) + 1; if ($page_number > $nb_pages) { $page_number = $nb_pages; } $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 {
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; }
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; }
<?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();
<?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();
<?php // Include classes include_once 'tbs_class.php'; // Load the TinyButStrong template engine include_once '../tbs_plugin_opentbs.php'; // Load the OpenTBS plugin // Initalize the TBS instance $TBS = new clsTinyButStrong(); // new instance of TBS $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); // load the OpenTBS plugin // ------------------------------ // Prepare some data for the demo // ------------------------------ // Retrieve the user name to display $yourname = isset($_POST['yourname']) ? $_POST['yourname'] : ''; $yourname = trim('' . $yourname); if ($yourname == '') { $yourname = "(no name)"; } // A recordset for merging tables $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;
//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;
/** * Redefinition of TBS method to add parameter 'cell' to set value with native OpenDocument format in spreadsheet * * refactoring code from egroupware/perp_api/inc/report/ooo.inc.php * * @param string $Txt TBS source * @param string $Loc TBS locator * @param string $Value TBS data to merge * @param string $CheckSub TBS checksub ??? */ public function meth_Locator_Replace(&$Txt, &$Loc, &$Value, $CheckSub) { if (!isset($Loc->PrmLst['type'])) { return parent::meth_Locator_Replace($Txt, $Loc, $Value, $CheckSub); } // keep 'Loc' for the end $posBeg = $Loc->PosBeg; $posEnd = $Loc->PosEnd; // get data $data = $Value[$Loc->SubLst[0]]; // new cell attribute // see : http://books.evc-cit.info/odbook/ch05.html#table-cells-section switch ($Loc->PrmLst['type']) { case 'datetime': case 'date': case 'dt': case 'd': $cellAttribute = sprintf('office:value-type="date" office:date-value="%s"', str_replace(' ', 'T', $data)); break; case 'time': case 't': list($h, $m, $s) = split(":", $data); $cellAttribute = sprintf('office:value-type="time" office:time-value="PT%sH%sM%sS"', $h, $m, $s); break; case 'percentage': case 'percent': case 'p': $cellAttribute = sprintf('office:value-type="percentage" office:value="%s"', $data); break; case 'currency': case 'cur': case 'c': //$cellAttribute = sprintf('office:value-type="currency" office:currency="EUR" office:value="%s"', $data); // still not necessary to fix the currency $cellAttribute = sprintf('office:value-type="currency" office:value="%s"', $data); break; case 'float': case 'f': $cellAttribute = sprintf('office:value-type="float" office:value="%s"', $data); break; case 'int': case 'i': $cellAttribute = sprintf('office:value-type="float" office:value="%d"', $data); break; case 'boolean': case 'bool': case 'b': $cellAttribute = sprintf('office:value-type="float" office:value="%d"', $data); break; default: case 'string': case 's': $cellAttribute = sprintf('office:value-type="string"'); break; } // get cell container enlarged to table:table-cell $Loc->Enlarged = $this->f_Loc_EnlargeToStr($Txt, $Loc, '<table:table-cell', '>'); $cellContainer = substr($Txt, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); // new cell container $newCellContainer = preg_replace('/office:value-type="string"/', $cellAttribute, $cellContainer); // replace the new cell containter in the main Txt $Txt = substr_replace($Txt, $newCellContainer, $Loc->PosBeg, $Loc->PosEnd - $Loc->PosBeg + 1); // correct 'Loc' to include the change of the new cell container $delta = strlen($newCellContainer) - strlen($cellContainer); $Loc->PosBeg = $posBeg + $delta; $Loc->PosEnd = $posEnd + $delta; $Loc->Enlarged = null; // call the parent method to insert the value $ret = parent::meth_Locator_Replace($Txt, $Loc, $Value, $CheckSub); // before return, restore 'Loc' with beginning values (to work with block) $Loc->PosBeg = $posBeg; $Loc->PosEnd = $posEnd; return $ret; }
$yearcount_as_string = $yearcount; settype($yearcount_as_string, "string"); if ($yearcount_as_string == $year) { $yearselect = $yearselect . '<option value="' . $yearcount . '" selected> ' . $yearcount . ' </option>'; } else { $yearselect = $yearselect . '<option value="' . $yearcount . '" ' . $selected . '> ' . $yearcount . ' </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;
<?php // Include classes include_once 'tbs_class.php'; // Load the TinyButStrong template engine include_once '../tbs_plugin_opentbs.php'; // Load the OpenTBS plugin // prevent from a PHP configuration problem when using mktime() and date() if (version_compare(PHP_VERSION, '5.1.0') >= 0) { if (ini_get('date.timezone') == '') { date_default_timezone_set('UTC'); } } // Initialize the TBS instance $TBS = new clsTinyButStrong(); // new instance of TBS $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN); // load the OpenTBS plugin // ------------------------------ // Prepare some data for the demo // ------------------------------ // Retrieve the user name to display $yourname = isset($_POST['yourname']) ? $_POST['yourname'] : ''; $yourname = trim('' . $yourname); if ($yourname == '') { $yourname = "(no name)"; } // A recordset for merging tables $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' => '*****@*****.**');