function table_created() { $sql = ''; $pri = 1; $zn = new zetro_manager(); $jml_field = $zn->Count($this->sec, $this->path); $sql = "CREATE TABLE IF NOT EXISTS `" . $this->name . "` (\n"; for ($i = 1; $i <= $jml_field; $i++) { $fld = explode(",", $zn->rContent($this->sec, $i, $this->path)); if ($fld[1] != 'N') { $sql .= "`" . $fld[2] . "` " . $fld[3] . ",\n"; } else { $sql = $sql; } } for ($z = 1; $z <= $jml_field; $z++) { $fld2 = explode(",", $zn->rContent($this->sec, $z, $this->path)); if ($fld2[1] == 'P') { $sql .= "PRIMARY KEY (" . $fld2[2] . ")\n"; $pri = 1; } else { $pri = 0; } } //($pri==0)?$sql2=substr($sql,0,(strlen($sql)-14)):$sql2=$sql; $sql .= " )\nCOLLATE='latin1_swedish_ci'\nENGINE=MyISAM;"; return mysql_query($sql) or die("<br>" . $sql . "<br/>" . mysql_error()); }
function BuildForm($section, $button = false, $width = '100%', $idTable = '', $buttonCount = '2') { $zm = new zetro_manager(); $jml = $zm->Count($section, $this->path); $idTable !== '' ? $idt = $idTable : ($idt = 'fmrTable'); //echo "<form id='frm1' name='frm1' method='post' action=''> echo "<table id='" . $idt . "' width='{$width}'>\n"; // add baris kosong echo $this->brs; for ($i = 1; $i <= $jml; $i++) { $fld = explode(',', $zm->rContent($section, $i, $this->path)); echo "<tr id='{$i}'>\n\r\n\t\t\t\t <td id='c1{$i}' "; if ($fld[0] == '') { echo "class=''"; } else { echo "class='border_b'"; } echo " width='42%'> " . $fld[0] . "</td>\n\r\n\t\t\t\t <td id='c2{$i}' width='60%' >"; //if ($fld[1]!='') switch ($fld[1]) { case 'input': echo "<" . $fld[1] . " type='" . $fld[2] . "' id='" . $fld[3] . "' name='" . $fld[3] . "' value='" . $fld[5] . "' class='" . $fld[4] . "'></td>"; break; case 'select': echo "<" . $fld[1] . " id='" . $fld[3] . "' name='" . $fld[3] . "' class='" . $fld[4] . "'>"; if (count($fld) == 9) { if ($fld[7] == 'RS') { echo "<option></option>"; for ($x = 1; $x <= $zm->Count($fld[8], $this->path); $x++) { $data = explode(",", $zm->rContent($fld[8], $x, $this->path)); echo "<option value='" . $data[0] . "'>" . $data[1] . "</option>\n\r"; } } } echo "</select>"; break; case 'textarea': echo "<" . $fld[1] . " id='" . $fld[3] . "' name='" . $fld[3] . "' class='" . $fld[4] . "'></textarea>"; break; case 'button': //echo "<".$fld[1]." type='".$fld[2]."' id='".$fld[3]."' value='".$fld[5]."' class='".$fld[4]."'></td>"; break; } echo "\n<td id='c3{$i}' width='8%'> </td>\n</tr>"; } if ($button == false) { echo "</table></form>"; } else { if ($fld[1] == 'button') { $this->BuildFormButton($fld[5], $fld[4], $buttonCount); } } }
function ListBuilder($section, $total = false, $tp = 'list') { $n = 0; $zm = new zetro_manager(); $jml = $zm->Count($section, $this->path); $this->rs = mysql_query($this->sql, $this->con) or die(mysql_error()); while ($row = mysql_fetch_array($this->rs)) { $n++; echo "<tr align='center' class='xx'>\n\r\n\t\t\t\t<td id='c00' class='kotak'>No.</td>"; for ($i = 1; $i <= $jml; $i++) { $fld = explode(',', $zm->rContent($section, $i, $this->path)); echo "<td id='c{$i}{$n}' class='kotak'>" . $row[$fld[3]] . "</td>"; } echo $this->tp == 'list' ? "<td id='c" . ($jml + 1) . "' class='kotak'>" . $this->event($n) . "</td></tr>" : "</tr>"; } echo "</table>"; }
function tab_head($section = 'Menu Utama', $bg = '', $file = 'asset/bin/zetro_menu.dll') { $data = array(); $zn = new zetro_manager(); $jml = $zn->Count($section, $file); for ($i = 1; $i <= $jml; $i++) { $mnu = explode("|", $zn->rContent($section, $i, $file)); if (strtolower($mnu[2]) == 'y') { $data[] = $mnu[0]; } } echo "<table width='100%' style='border-collapse:collapse' border='0' bordercolor='#CCC' id='tab'>\n\r\n\t\t\t<tr height='35px' align='center'>\n"; foreach ($data as $menu) { echo "<td width='100px' style='padding:5px' class='tab_button' id='" . strtolower(str_replace(" ", '', $menu)) . "'>" . $menu . "</td>\n"; } echo "<td class='tab_kosong' id='kosong' {$bg}> </td></tr></table>\r\n\t\t<div id='v_panel' class='pn_contents tab_content' style='height:75%; overflow:auto'>\r\n\t\t"; }
<div class='contents'> <div class="pn_content" align="center"> <hr><br><br><br><br> <img src="<?php echo base_url() . "asset/images/warning.png"; ?> "> <font style="font-family:'20th Century Font', Arial; color:#DD0000; font-size:xx-large"> <?php $zn = new zetro_manager(); echo $zn->rContent("Message", "NoAuth", "asset/bin/form.cfg"); echo !empty($msg) ? $msg : ''; ?> </font> </div> </div>
function Header() { $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_config.dll'; if ($this->kriteria == "transkip") { $co = $zn->rContent('InfoCo', 'subtitle', $nfile); $address = $zn->rContent('InfoCo', 'Address', $nfile); $kota = $zn->rContent('InfoCo', 'Kota', $nfile); $prop = $zn->rContent('InfoCo', 'Propinsi', $nfile); $telp = $zn->rContent('InfoCo', 'Telp', $nfile); $fax = $zn->rContent('InfoCo', 'Fax', $nfile); $BH = $zn->rContent('InfoCo', 'BH', $nfile); $this->Ln(2); //$this->Image(base_url().'asset/img/about.jpg',10,6,50,15); $this->Ln(2); //$this->SetFont('Arial','B',15); // $this->Cell(5); // $this->MultiCell(120,5,$co,0,1,'L'); //$this->Cell(5); $this->SetFont('Arial', 'B', 11); //$this->MultiCell(100,5,$BH,0,1,'C'); $this->SetFont('Arial', '', 10); //$this->Cell(3); $this->MultiCell(0, 6, "", 0, 1, 'C'); $this->SetFont('Arial', '', 10); //$this->Cell(5); $this->MultiCell(0, 6, $address . " " . $kota . " " . $prop, 0, 1, 'C'); $this->MultiCell(0, 4, $telp . " " . $fax, 0, 1, 'C'); $this->Ln(5); $this->SetFont('Arial', 'B', 10); $this->CurOrientation == 'P' ? $this->MultiCell(0, 4, str_repeat("_", 95), 0, 1, 'C') : $this->MultiCell(0, 4, str_repeat("_", 140), 0, 1, 'C'); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 10, $this->nama, 2, 1, 'C'); $this->SetFont('Arial', 'B', 10); $this->Ln(2); // spasi enter $this->SetFont('Arial', 'B', 11); // set font,size,dan properti (B=Bold) $n = 0; foreach ($this->refer as $rr) { $this->Cell(40, 6, $rr, 0, 0, 'L'); $this->Cell(130, 6, ': ' . $this->filter[$n], 0, 1, 'L'); $n++; } $this->Ln(2); // set nama header tabel transaksi $this->SetFillColor(225, 225, 225); $kol = $zn->Count($this->section, $this->nfilex); $this->Cell(10, 8, 'No.', 1, 0, 'C', true); for ($i = 1; $i <= $kol; $i++) { $d = explode(',', $zn->rContent($this->section, $i, $this->nfilex)); $this->Cell($d[9], 8, $d[0], 1, 0, 'C', true); } $this->Ln(); } if ($this->kriteria == 'faktur') { $co = $zn->rContent('InfoCo', 'Name', $nfile); $address = $zn->rContent('InfoCo', 'Address', $nfile); $kota = $zn->rContent('InfoCo', 'Kota', $nfile); $telp = $zn->rContent('InfoCo', 'Telp', $nfile); $fax = $zn->rContent('InfoCo', 'Fax', $nfile); $npwp = $zn->rContent('InfoCo', 'NPWP', $nfile); $nppkp = $zn->rContent('InfoCo', 'NPPKP', $nfile); $this->SetFont('Arial', 'B', 14); $this->Cell(110, 4, $co, 0, 0, 'L'); $this->SetFont('Arial', '', 10); $this->Cell(120, 6, $this->nama, 0, 1, 'L'); $this->Cell(110, 6, $address . " " . $kota, 0, 0, 'L'); $this->Cell(120, 6, 'Customer :', 0, 1, 'L'); $this->Cell(110, 6, $telp . " " . $fax, 0, 0, 'L'); $this->SetFont('Arial', 'IB', 10); $this->Cell(120, 6, ' ' . $this->refer, 0, 1, 'L'); $this->SetFont('Arial', '', 10); $this->Cell(110, 6, $npwp, 0, 0, 'L'); $this->SetFont('Arial', 'IB', 10); $this->Cell(125, 6, ' ' . $this->filter, 0, 1, 'L'); $this->SetFont('Arial', '', 10); $this->Cell(110, 6, $nppkp, 0, 0, 'L'); $this->Cell(120, 6, 'NPWP :', 0, 1, 'L'); $this->Cell(110, 4, 'Nomor Seri faktur: ' . $this->nofaktur, 0, 0, 'L'); $this->Cell(120, 6, 'Tanggal : ' . $this->dataset, 0, 1, 'L'); $this->SetFont('Arial', 'B', 10); $this->SetLineWidth(0.4); $this->Line(10, 50, 197, 50); $this->Ln(); $this->SetLineWidth(0.2); $this->SetFont('Arial', 'B', 12); //header table // set nama header tabel transaksi $this->Ln(2); $this->SetFillColor(225, 225, 225); $kol = $zn->Count($this->section, $this->nfilex); $this->Cell(10, 8, 'No.', 1, 0, 'C', true); for ($i = 1; $i <= $kol; $i++) { $d = explode(',', $zn->rContent($this->section, $i, $this->nfilex)); $this->Cell($d[9], 8, $d[0], 1, 0, 'C', true); } $this->Ln(); } if ($this->kriteria == 'neraca') { $co = $zn->rContent('InfoCo', 'subtitle', $nfile); $address = $zn->rContent('InfoCo', 'Address', $nfile); $kota = $zn->rContent('InfoCo', 'Kota', $nfile); $prop = $zn->rContent('InfoCo', 'Propinsi', $nfile); $telp = $zn->rContent('InfoCo', 'Telp', $nfile); $fax = $zn->rContent('InfoCo', 'Fax', $nfile); $BH = $zn->rContent('InfoCo', 'BH', $nfile); $this->Ln(2); $this->Image(base_url() . 'asset/img/about.jpg', 10, 6, 50, 15); $this->Ln(2); //$this->SetFont('Arial','B',15); // $this->Cell(5); // $this->MultiCell(120,5,$co,0,1,'L'); //$this->Cell(5); $this->SetFont('Arial', 'B', 11); //$this->MultiCell(100,5,$BH,0,1,'C'); $this->SetFont('Arial', '', 10); //$this->Cell(3); $this->MultiCell(0, 6, "", 0, 1, 'C'); $this->SetFont('Arial', '', 10); //$this->Cell(5); $this->MultiCell(0, 6, $address . " " . $kota . " " . $prop, 0, 1, 'C'); $this->MultiCell(0, 4, $telp . " " . $fax, 0, 1, 'C'); $this->Ln(5); $this->SetFont('Arial', 'B', 10); $this->CurOrientation == 'P' ? $this->MultiCell(0, 4, str_repeat("_", 95), 0, 1, 'C') : $this->MultiCell(0, 4, str_repeat("_", 140), 0, 1, 'C'); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 10, $this->nama, 2, 1, 'L'); $this->SetFont('Arial', 'B', 10); //$this->Ln(1); // spasi enter $this->SetFont('Arial', 'B', 11); // set font,size,dan properti (B=Bold) $n = 0; if (!empty($this->refer)) { foreach ($this->refer as $rr) { $this->Cell(30, 6, $rr, 0, 0, 'L'); $this->Cell(100, 6, ': ' . $this->filter[$n], 0, 1, 'L'); $n++; } } $this->Ln(1); $this->SetFont('Arial', 'B', 10); $this->CurOrientation == 'P' ? $this->MultiCell(0, 4, str_repeat("_", 95), 0, 1, 'C') : $this->MultiCell(0, 4, str_repeat("_", 140), 0, 1, 'C'); } }
?> application/views/admin/js/jquery.1.7.1.min.js" type="text/javascript"></script> <script language="javascript" src="<?php echo base_url(); ?> application/views/admin/js/jquery_print.js" type="text/javascript"></script> <script language="javascript"> $(document).ready(function(e) { $('.sample_attach').css('z-index','10000');$('img.menux').click(function(){var id=$(this).attr("id");document.location.href="<?php echo base_url(); ?> index.php/"+id;}) }); </script> <title><?php echo $zz->rContent("WebPage", "Title", $z_config) . "-" . $zz->rContent("WebPage", "subtitle", $z_config); ?> </title> </head> <body> <div id="menu-atas"> <div class='logo'> <?php echo $zz->rContent("InfoCo", "Name", $z_config); ?> </div> <div class="menu"> <?php if ($this->session->userdata('login') == true) { echo "<div class='welcome judul sorot' style='padding:5px;display:none'>Selamat datang \r\n <span class='sorot'>" . $this->session->userdata('username') . "</span></div>"; }
$('#ajax_display').show(); }) $(document).keypress(function(e){ if(e.keyCode==122){ //return false; }else if(e.keyCode==121){ return false; }else if(e.keyCode==114){ return false; } }) }); </script> <title><?php echo $zz->rContent("WebPage", "Title", $z_config) . "-" . $zz->rContent("WebPage", "subtitle", $z_config); ?> </title> </head> <body> <?php $menul = $this->session->userdata('menus'); $verses = addCopy() == '' ? $this->session->userdata('version') : ''; $menune = empty($menul) ? '' : base64_decode($menul); ?> <div id="menu-atas" style='z-index:9990'> <div class='logo' style=" vertical-align:middle"> <?php echo empty($menul) ? $zz->rContent("InfoCo", "Name", $z_config) : 'Modul ' . base64_decode($menul); ?> </div><?php
function no_auth() { echo "<img src='" . base_url() . "asset/images/warning.png'>"; ?> <font style="font-family:'20th Century Font', Arial; color:#DD0000; font-size:xx-large"> <?php $zn = new zetro_manager(); echo $zn->rContent("Message", "NoAuth", "asset/bin/form.cfg"); ?> </font> <?php }
" type="text/javascript"></script> <script language="javascript" src="<?php echo base_url() . 'application/views/admin/js/jquery_print.js'; ?> " type="text/javascript"></script> <?php //echo $scriptmce; ?> <script language="javascript"> $(document).ready(function(e) { // $('.panel').css('z-index','0'); $('.sample_attach').css('z-index','10000'); }); </script> <title><?php echo $zz->rContent("WebPage", "Title", $z_config) . "-" . $zz->rContent("WebPage", "subtitle", $z_config); ?> </title> </head></head> <body> <div id="menu-atas"> <div class='logo'> <img src='<?php echo base_url(); ?> application/views/admin/images/logo.png' /></div> <div class="menu"> <?php if ($this->session->userdata('login') == true) { echo "<div class='welcome judul'><img src='" . base_url() . "asset/images/icon/document.png'> <span class='sorot'>REPORTS</span></div>"; $jml = $zz->Count('Laporan', $file);
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $pajake = $zn->rContent('Prefference', 'Pajak', 'asset/bin/zetro_config.dll'); $a->setKriteria("transkip"); $a->setNama("LAPORAN KAS MASUK"); $a->setSection("labarugi"); $a->setFilter(array($sampai == '' ? $dari : $dari . ' s/d ' . $sampai)); $a->setReferer(array('Periode')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 30, 30, 30, 25, 30)); $a->SetAligns(array("C", "C", "R", "R", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $ppn = 0; $tppn = 0; $opr = 0; $lab = 0; $kotor = 0;
$file = 'asset/bin/zetro_menu.dll'; $z_config = 'asset/bin/zetro_config.dll'; ?> <div id="" style="display:; padding-top:70px;"> <table width="100%"><tr valign="bottom" align="center"><td width='100%'> <img src='<?php echo base_url(); ?> asset/images/about2.png' /> </td><tr> <td width='100%' align="left"> <table width="90%"> <tr><td width='100%' align="left"><div id="infoco"><b><u>License To :</u></b><p></p> <?php echo $zz->rContent('InfoCo', "Name", $z_config) . "<br>" . $zz->rContent('InfoCo', "Address", $z_config) . "," . $zz->rContent('InfoCo', "Kota", $z_config) . "<br>" . $zz->rContent('InfoCo', "Telp", $z_config) . "," . $zz->rContent('InfoCo', "Fax", $z_config) . "<br>"; ?> </div></td></tr> </table> </td></tr></table> </div> <?php function serial_no($namaco) { $pjg = 4; $jml = 4; $SN = ''; $charset = strtoupper(base64_encode(md5($namaco))); //$charset = "48C93F6H1JKLMN0PQR57UVWXY2"; for ($c = 0; $c < $jml; $c++) {
$z_config = 'asset/bin/zetro_config.dll'; ?> <div id="" style="display:block; padding-top:70px;"> <table width="100%"><tr valign="bottom" align="center"> <td width='100%' align="center"> <img src='<?php echo base_url(); ?> asset/img/zetropos.png' /><br /> <table width='50%' align="center"> <tr height='50px'><td> </td></tr> <tr><td width='100%' align="left">License To :</td></tr> <tr><td><font style="font-family:'Arial Black', Gadget, sans-serif; font-size:large"> <?php echo $zz->rContent('InfoCo', "Name", $z_config); ?> </font></td></tr> <tr><td><?php echo $zz->rContent('InfoCo', "Address", $z_config); ?> </td></tr> <tr><td><?php echo $zz->rContent('InfoCo', "Kota", $z_config) . " " . $zz->rContent('InfoCo', "Propinsi", $z_config); ?> </td></tr> <tr><td><?php echo empty($serial) ? "Not Licenced" : "Serial Number : " . $serial; ?> </td></tr> </table>
| multi-byte character set and are running versions lower than these. | Sites using Latin-1 or UTF-8 database character set and collation are unaffected. | ['swap_pre'] A default table prefix that should be swapped with the dbprefix | ['autoinit'] Whether or not to automatically initialize the database. | ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections | - good for ensuring strict SQL while developing | | The $active_group variable lets you choose which connection group to | make active. By default there is only one group (the 'default' group). | | The $active_record variables lets you determine whether or not to load | the active record class */ $active_group = 'default'; $active_record = TRUE; $db['default']['hostname'] = $zd->rContent("Server", "hostname", $z_config); $db['default']['username'] = $zd->rContent("Server", "username", $z_config); $db['default']['password'] = $zd->rContent("Server", "password", $z_config); $db['default']['database'] = $zd->rContent("Server", "dbname", $z_config); $db['default']['dbdriver'] = 'mysql'; $db['default']['dbprefix'] = ''; $db['default']['pconnect'] = TRUE; $db['default']['db_debug'] = TRUE; $db['default']['cache_on'] = FALSE; $db['default']['cachedir'] = ''; $db['default']['char_set'] = 'utf8'; $db['default']['dbcollat'] = 'utf8_general_ci'; $db['default']['swap_pre'] = ''; $db['default']['autoinit'] = TRUE; $db['default']['stricton'] = FALSE; /* End of file database.php */
asset/img/PoS.png' /></td><td> </td></td></tr> <tr valign="bottom" align="" style="padding:20px"> <td width='40%' align="center" valign="middle"><img src='<?php echo base_url(); ?> asset/img/about2.png' /></td> <td width='60%' valign="top"> <table width='70%' border="0" id='x'> <tr align="center" valign="middle"> <?php $mnu = $zz->Count('Menu Utama', $file); $x = 0; $klik = ''; $ver = $this->session->userdata('version'); for ($i = 1; $i <= $mnu; $i++) { $gbr = explode('|', $zz->rContent('Menu Utama', $i, $file)); if ($gbr[3] != '') { $x++; $klik = encode_php($ver) >= '100' ? '' : "onclick=\"kliked('" . base64_encode($gbr[4]) . "');\""; if ($x > 1) { echo tr('') . td("<img src='" . base_url() . "asset/img/" . $gbr[3] . "' class='menux' {$klik}>", 'left', ' \' height=\'69px\' valign=\'middle') . _tr(); } else { echo td("<img src='" . base_url() . "asset/img/" . $gbr[3] . "' class='menux' {$klik}>", 'left', ' \' height=\'69px\' valign=\'middle'); } } else { echo ''; } } ?> </tr> <?php
//$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN STOCK OBAT"); $a->setFilter(array($nm_jenis, $nm_kategori, $nm_golongan)); $a->setReferer(array('Jenis Obat', 'Kategori Obat', 'Sub Kategori')); $a->setFilename('asset/bin/zetro_inv.frm'); $a->setSection("liststock_rpt"); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $width = ''; $jml_record = $zn->Count($a->getSection(), $a->getFilename()); for ($i = 1; $i <= $jml_record; $i++) { $d = explode(',', $zn->rContent($a->getSection(), $i, $a->getFilename())); $width .= $d[9] . ","; } $a->SetWidths(array(10, 20, 20, 25, 55, 20, 15, 25)); $a->SetAligns(array("C", "L", "L", "L", "L", "R", "C", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_jenis, $r->nm_kategori, $r->nm_golongan, $r->nm_barang, number_format($r->stock, 2), $r->nm_satuan, number_format($r->harga_beli, 2))); //sub tlot $harga = $harga + $r->harga_beli; } $a->SetFont('Arial', 'B', 10);
?> asset/images/arrows/down.png' id='d1' style='display:'> <img src='<?php echo base_url(); ?> asset/images/arrows/right.png' id='d1' style='display:none'><?php echo nbs(2); ?> Control Menu</td> </tr> <?php $jml = $zz->Count('Menu', $file); //main-menu for ($i = 1; $i <= $jml; $i++) { $jml_sub = 0; $xx = explode('|', $zz->rContent('Menu', $i, $file)); $jml_sub = $zz->Count($xx[0], $file); $jml_sub == 0 ? $cs = 'colspan="3"' : ($cs = 'colspan="3"'); ?> <tr id='cd1' class='<?php echo $xx[0]; ?> isi' style='display:none'> <td width="20px" align="right"><img src='<?php echo base_url(); ?> asset/images/3.png'></td> <td <?php echo $cs; ?> class="sub-judul"><?php