function buildgrid($table, $field, $section, $aksi = true, $icon = '')
{
$zlb = new zetro_buildlist();
$zlb->config_file('asset/bin/zetro_master.frm');
$sql2 = "select * from {$table} order by {$field}";
//echo $sql2;
$zlb->section($section);
$zlb->aksi($aksi);
$zlb->icon($icon);
$zlb->query($sql2);
$zlb->sub_total(false);
$zlb->sub_total_field('stock,blokstok');
$zlb->Header('100%');
$zlb->list_data($section);
$zlb->BuildListData($field);
echo "</tbody></table>";
}
$path = 'application/views/inventory';
$kateg = "<select id='plh' name='plh' class='s100'></select>";
$jenis = "<select id='plh_jenis' name='plh_jenis' class='s100'></select>";
$stats = "<select id='plh_stat' name='plh_stat' class='s100'>\r\n\t\t<option value='all'>Semua</option>\r\n\t\t<option value='Continue'>Continue</option>\r\n\t\t<option value='Discontinue'>Discontinue</option></select>";
$cari = "<input id='plh_cari' name='plh_cari' class='w100 cari'>";
link_css('jquery.coolautosuggest.css', 'asset/css');
link_js('jquery.coolautosuggest.js,jquery_terbilang.js', 'asset/js,asset/js');
link_js('jquery.fixedheader.js,material_list.js', 'asset/js,' . $path . '/js');
panel_begin('Daftar Barang');
panel_multi('listbarang', 'block', false);
if ($e_listbarang != '' || $v_listbarang != '') {
addText(array('Filter by Kategori :', ' Jenis :', 'Status', ' Cari by nama'), array($kateg, $jenis, $stats, $cari));
/* $sql="select * from inv_barang order by nama_barang";*/
$zlb->section('BarangList');
$zlb->aksi($e_listbarang != '' ? true : false);
$zlb->Header('100%');
$zlb->icon();
/*
$zlb->query($sql);
$zlb->sub_total(false);
$zlb->sub_total_field('4,5');
$zlb->list_data($section);
$zlb->BuildListData('nama_barang');*/
echo "</tbody></table>";
} else {
no_auth();
}
echo "<hr><div id='bawahan' style='display:none;width:100%; height:25px; background:#AAA; border:1px outset #CCCC'></div>";
panel_multi_end();
panel_multi('hargabeli', 'none', false);
if ($c_hargabeli != '') {
$path = 'application/views/master';
link_js('jquery.fixedheader.js,master_general.js,jquery_terbilang.js', 'asset/js,' . $path . '/js,asset/js');
tab_select('');
panel_begin('Data General');
panel_multi('datakas', 'block', false);
$mk = '_kas';
if ($all_kas != '') {
$zfm->AddBarisKosong(true);
$zfm->Start_form(true, 'frm3');
$zfm->BuildForm('Kas', true, '50%');
$zfm->BuildFormButton('Simpan', 'kas');
echo "<hr>";
$zlb->section('Kas');
$zlb->aksi(true);
$zlb->icon('delete');
$zlb->Header('70%');
echo "</tbody></table>";
} else {
no_auth();
}
panel_multi_end();
auto_sugest();
tab_select('prs');
panel_end();
terbilang();
?>
<script language="javascript">
$(document).ready(function(e) {
});
</script>
}
} else {
no_auth();
}
panel_multi_end();
//tab user list
panel_multi('listuser', 'block', false);
if ($v_listuser != '') {
$e_listuser == '' ? $btn = false : ($btn = true);
$sql2 = "select * from users where userid !='superuser' order by userid";
$zlb->deskripsi('user_level', 'nmlevel', 'idlevel');
$zlb->section('userlist');
$zlb->aksi($btn);
$zlb->icon();
$zlb->query($sql2);
$zlb->Header('80%');
$zlb->list_data('userlist');
$zlb->BuildListData('userid');
echo "</tbody></table>\n";
} else {
no_auth();
}
panel_multi_end();
//tab user autorisation
panel_multi('authorisation', 'none', false);
//form select group
if ($all_authorisation != '') {
$zfm->AddBarisKosong(false);
$zfm->Start_form(true, 'frm2');
$zfm->BuildForm('usergroup', false, '40%');
echo "<hr/>\n";
$path = 'application/views/inventory';
link_js('material_inv.js', $path . '/js');
link_js('jquery.fixedheader.js', 'asset/js');
tab_select('');
panel_begin('Jenis Barang');
panel_multi('jenisbarang', 'block', false);
if ($all_jenisbarang != '') {
$zfm->AddBarisKosong(false);
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('Jenis', true, '50%');
$zfm->BuildFormButton('Simpan', 'jenis');
echo "<hr/>";
$zlb->section('Jenis');
$zlb->aksi($e_jenisbarang != '' ? true : false);
$zlb->icon('deleted');
$zlb->Header('100%', 'Jenis');
echo "</tbody></table>";
} else {
no_auth();
}
panel_multi_end();
panel_end();
?>
<script language="javascript">
$(document).ready(function(e) {
$('#jenisbarang').removeClass('tab_button');
$('#jenisbarang').addClass('tab_select');
});
</script>
panel_multi('stocklist', 'block');
if ($all_stocklist != '') {
$fld = "<input type='hidden' id='section' name='section' value='lapjuallist'>";
$fld .= "<input type='hidden' id='lap' name='lap' value='stock'>";
$fld .= "<input type='hidden' id='optional' name='optional' value='stock'>";
$zfm->Addinput($fld);
echo "Select Filter of list :";
$zfm->AddBarisKosong();
$zfm->Start_form(true, 'frm2');
$zfm->BuildForm('stoklist filter', true, '50%');
$zfm->BuildFormButton('Process', 'filter', 'button', 2);
echo "<hr>";
//<font style='color:#000; font-size:medium'><u>List Obat Filter by :<span id='nmj'></span><span id='kat'></span><span id='gol'></span></u></font>";
$zlb->section('stoklistview');
$zlb->aksi(false);
$zlb->Header('100%');
echo "</tbody></table>";
} else {
no_auth();
}
panel_multi_end();
panel_multi('dataexpire');
if ($all_dataexpire != '') {
$fld2 = "<input type='hidden' id='section' name='section' value='lapjuallist'>";
$fld2 .= "<input type='hidden' id='lap' name='lap' value='expired'>";
$fld2 .= "<input type='hidden' id='optional' name='optional' value=''>";
$zfm->Addinput($fld2);
$zfm->AddBarisKosong();
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('stoklist filter', true, '50%');
$zfm->BuildFormButton('Process', 'expired', 'button', 2);
Calender();
link_css('jquery.coolautosuggest.css', 'asset/css');
link_js('jquery.coolautosuggest.js', 'asset/js');
link_js('jquery.fixedheader.js', 'asset/js');
link_js('material_income_list.js', $path . '/js');
link_js('material_income.js,jquery_terbilang.js', $path . '/js,asset/js');
panel_begin('Penerimaan Barang');
panel_multi('inputpembelian', 'block', false);
if ($c_pembelian__index != '') {
$zfm->AddBarisKosong(false);
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('pembelian', false, '60%');
echo "<hr><form id='frm2' name='frm2' method='post' action=''>";
$zlb->section('pembelianlist');
$zlb->aksi(true);
$zlb->Header('97%');
echo "<tr><td class='kotak' colspan='8'> </td>";
echo "</tbody><tfoot>";
$zfm->section('pembelianlist');
$zfm->rowCount();
$zfm->button('simpan');
$zfm->BuildGrid();
echo "</tfoot></table></form>";
} else {
no_auth();
}
panel_multi_end();
panel_multi('listpembelian', 'none', false);
if ($all_listpembelian != '') {
addText(array('Periode Dari', 'Sampai', ''), array("<input type='text' id='dari_tanggal' value='' class='w100'>", "<input type='text' id='smp_tanggal' value='' class='w100'>", "<input type='button' id='okelah' value='OK'>"));
$zlb->section('lappembelian');
link_js('jquery.fixedheader.js,jquery.coolautosuggest.js', 'asset/js,asset/js');
link_js('buku_besar.js,jquery_terbilang.js', $path . '/js,asset/js');
panel_begin('Buku Besar', '', ',', ",,,,<input type='button' class='print' style='display:{$oto_p}' value='Cetak' id='cetak' title='Klik untuk print'>");
panel_multi('bukubesar', 'block', false);
if ($all_bukubesar != '') {
echo "<form name='frm_j' id='frm_j' method='post' action=''>";
echo "\r\n<table id='period' style='border-collapse:collapse'>\r\n\t<tr><td width='70px'>Periode :</td>\r\n \t<td width='20px'><input type='radio' name='periode' id='pertgl' /></td>\r\n <td width='70px'>Per Tanggal</td>\r\n <td width='100px'><input type='text' id='tgl_start' class='w100' value='' /></td>\r\n <td width='20px'>s/d</td>\r\n <td width='100px'><input type='text' id='tgl_stop' class='w100' value='' /></td>\r\n <td style='border-right:2px dotted #FFF' width='15px'></td>\r\n <td width='10px'> </td>\r\n <td width='80px'>Klasifikasi</td>\r\n <td width='170px'><select id='ID_Klas' class='S100'>";
dropdown("klasifikasi", 'ID', 'Klasifikasi');
echo "</select></td>\r\n <td width='5px'> </td>\r\n <td width='90px'>Sub Klasifikasi</td>\r\n <td width='250px'><select id='ID_SubKlas' class='S70'></select></td>\r\n </tr>\r\n\t<tr><td> </td>\r\n \t<td><input type='radio' name='periode' id='pertahun' /></td>\r\n <td>Per Tahun</td>\r\n <td><select id='tahun'></select></td>\r\n <td> </td>\r\n <td><input type='button' id='oke' value='OK'></td>\r\n <td style='border-right:2px dotted #FFF' width='15px'></td>\r\n <td > </td>\r\n <td >Departemen</td>\r\n <td ><select id='ID_Dept' class='S100'>";
dropdown("mst_departemen", 'ID', 'Departemen');
echo "</select></td>\r\n <td > </td>\r\n <td >Perkiraan</td>\r\n <td ><select id='ID_Agt' class='S100' style='float:left'></select></td>\r\n </tr>\r\n</table>\r\n<hr />";
echo "</form>";
echo "<div id='tgl' style='display:none'>";
$zlb->section('bukubesar');
$zlb->aksi(false);
$zlb->Header('100%');
$zlb->icon();
echo "</tbody></table>\n\r\n\t\t</div>\r\n\t\t<div id='thn' style='display:none'>";
$zlb->section('bukubesartahunan');
$zlb->aksi(false);
$zlb->Header('70%', 'bbTahunan');
$zlb->icon();
echo "</tbody></table></div>";
} else {
no_auth();
}
panel_multi_end();
panel_end();
loading_ajax();
terbilang();
?>
$path = 'application/views/inventory';
link_css('jquery.coolautosuggest.css', 'asset/css');
link_js('jquery.coolautosuggest.js,jquery_terbilang.js', 'asset/js,asset/js');
link_js('jquery.fixedheader.js,material_list.js', 'asset/js,' . $path . '/js');
panel_begin('Konversi Satuan');
panel_multi('konversisatuan', 'block', false);
if ($c_konversisatuan != '') {
$zfm->AddBarisKosong();
$zfm->Start_form(true, 'frm4');
$zfm->BuildForm('Konversi', true, '70%');
$zfm->BuildFormButton('Simpan', 'konv');
echo "<hr>";
$zlb->section('Konversi');
$zlb->aksi(true);
$zlb->icon('deleted');
$zlb->Header('70%', 'konversi');
echo "</tbody></table>";
} else {
no_auth();
}
panel_multi_end();
panel_end();
?>
<script language="javascript">
$(document).ready(function(e) {
$('#konversisatuan').removeClass('tab_button');
$('#konversisatuan').addClass('tab_select');
$('#add-nm_satuan').hide();
});
</script>
panel_begin('List Vendor');
panel_multi('addvendor', 'none', false);
if ($all_master__vendor_n != '') {
$zfm->AddBarisKosong(true);
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('produsen', true, '50%');
$zfm->BuildFormButton('Simpan', 'vendor');
} else {
no_auth();
}
panel_multi_end();
panel_multi('listvendor', 'block', false);
if ($all_listvendor != '') {
addText(array('Nama Vendor :', ''), array('<input type="text" id="finde" class="cari w100">', '<input type="button" id="oke" value="Cari">'));
$zlb->section('produsen');
$zlb->aksi($e_listvendor != '' ? true : false);
$zlb->icon('deleted');
$zlb->Header('100%');
echo "</tbody></table>";
} else {
no_auth();
}
panel_multi_end();
panel_end();
popup_start('v_detail', 'Transaksi Vendor :<span id="nmp"></span>', 750, 550);
$zlb->section('detailtransvendor');
$zlb->aksi(false);
$zlb->icon('deleted');
$zlb->Header('100%', 'vend_detail');
echo "</tbody></table>";
popup_end();
$zlb->config_file('asset/bin/zetro_beli.frm');
$path = 'application/views/pembelian';
link_css('jquery.coolautosuggest.css', 'asset/css');
link_js('jquery.coolautosuggest.js', 'asset/js');
link_js('jquery.fixedheader.js', 'asset/js');
link_js('material_income_return.js,auto_sugest.js,jquery_terbilang.js,jquery.sumfield.js', $path . '/js,asset/js,asset/js,asset/js');
panel_begin('Return Konsinyasi');
panel_multi('returnpembelian', 'block', false);
if ($c_returnpembelian != '') {
$zfm->AddBarisKosong(false);
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('pembelian', false, '60%');
echo "<hr><form id='frm2' name='frm2' method='post' action=''>";
$zlb->section('pembelianlist');
$zlb->aksi(true);
$zlb->Header('97%');
echo "<tr><td class='kotak' colspan='8'> </td>";
echo "</tbody><tfoot>";
$zfm->section('pembelianlist');
$zfm->rowCount();
$zfm->button('simpan');
$zfm->BuildGrid();
echo "</tfoot></table></form>";
} else {
no_auth();
}
panel_multi_end();
panel_end();
terbilang();
?>
<div id='kekata' style="display:none;padding:8px; background:#003; border:5px solid #F60;width:80%; height:50px; font-size:x-large;left:9%;top: 82%;color:#FFF; position:fixed; z-index:9997">
//$zfm->Addinput("<input type='text' id='No_Agt' name='No_Agt' value='".$no_anggota."'/>");
$zfm->AddBarisKosong(false);
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('registrasi', false, '100%');
echo "</td><td width='5%'> </td>\r\n\t <td width='50%'>";
$zfm->AddBarisKosong(false);
$zfm->Start_form(true, 'frm2');
$zfm->BuildForm('biodata', false, '100%');
echo "<!--hr><div id='pic' style='height:350px; border:1px inset #FFF'>\r\n\t<img src='' id='photone' width='500px' height='350px'></div>";
echo "</td></tr-->\r\n\t </table>\r\n\t\t<hr>\r\n\t\t<div id='btn' style='width:90%; border:0px outset #CCC;padding:5px; padding-right:20px' align='right'>\r\n\t\t<input type='button' id='update_b' value='Update Data'>\r\n\t\t<!--input type='button' id='cetak_b' value='Cetak'-->\r\n\t\t<input type='button' id='keluar_b' value='Tutup'></div>";
panel_multi_end();
panel_multi('membertrans', 'none', false);
addText(array('No. Anggota', 'Nama Lengkap', 'Department'), array("<input type='text' id='no_anggota' readonly value='{$no_anggota}'>", "<input type='text' id='nm_anggota' readonly value='{$nm_anggota}'>", "<input type='text' id='id_department' readonly value='{$id_department}' size='40'>"));
$zlb->section('detail');
$zlb->aksi(false);
$zlb->Header('90%', 'detail_tbl');
$zlb->icon();
$n = 0;
foreach ($transaksi->result() as $trn) {
$n++;
echo "<tr class='xx' id='t-" . $trn->ID . "' align='center' onclick=\"get_detail_trans('" . $trn->ID . "');\">\r\n\t\t\t\t <td class='kotak'>{$n}</td>\r\n\t\t\t\t <td class='kotak'>" . $trn->Kode . "</td>\r\n\t\t\t\t <td class='kotak' align='left'>" . $trn->Jenis . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($trn->SaldoAwal, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($trn->Debet, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($trn->Kredit, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($trn->SaldoAkhir, 2) . "</td>\r\n\t\t\t\t </tr>";
}
echo "</tbody></table><hr>";
echo "<div id='loading' style='display:none'>Loading data in progress ...please wait. <img src='" . base_url() . "asset/img/indicator.gif'></div>";
echo "<div id='dtl_trans' style='display:none'>";
echo "<p style='color:#000'>Detail transaksi <span id='dtl'></span> :</p>";
$zlb->section('DetailTrans');
$zlb->aksi(false);
$zlb->Header('100%', 'trans_tbl');
$zlb->icon();
$n = 0;
$zfm = new zetro_frmBuilder('asset/bin/zetro_inv.frm');
$zlb = new zetro_buildlist();
$zlb->config_file('asset/bin/zetro_inv.frm');
$path = 'application/views/inventory';
//$printer="<img src='".base_url()."asset/images/print.png' id='printsheet' title='Print count sheet'>";
link_css('autosuggest.css', 'asset/css');
link_js('material_opname.js,auto_sugest.js,jquery_terbilang.js,jquery.fixedheader.js', $path . '/js,asset/js,asset/js,asset/js');
panel_begin('Stock Opname', false, '', $p_countsheet != '' ? 'Print to printer' : '');
panel_multi('countsheet', 'block');
echo "<form id='frm2' name='frm2' method='post' action=''>";
addText(array('Kategori', 'Order By', 'Urutan', ''), array("<select id='Kategori' name='Kategori'></select>", "<select id='orderby' name='orderby'>" . selectTxt('SusunanStock') . "</select>", "<select id='urutan' name='urutan'>" . selectTxt('Urutan', true) . "</select>", "<input type='button' value='OK' id='okelah'/>"));
echo "</form>";
$zlb->section('stoklistview');
$zlb->aksi(false);
$zlb->Header('100%', 'sheet');
echo "</tbody></table>";
panel_multi_end();
panel_multi('stockadjustment', 'none', false);
if ($c_adjust != '' || $e_adjust != '') {
echo "Select Filter of list :";
$zfm->AddBarisKosong();
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('stoklist filter', true, '50%');
$zfm->BuildFormButton('Process', 'filter', 'button', 1);
echo "<hr>";
$zlb->inlineedit('y');
$zlb->section('stoklistview');
$zlb->aksi(true);
$zlb->Header('100%');
echo "</tbody></table>";
$zlb->config_file('asset/bin/zetro_inv.frm');
$path = 'application/views/inventory';
link_css('jquery.coolautosuggest.css', 'asset/css');
link_js('jquery.coolautosuggest.js', 'asset/js');
link_js('jquery.fixedheader.js,material_stock.js,auto_sugest.js,jquery_terbilang.js', 'asset/js,' . $path . '/js,asset/js,asset/js');
panel_begin('Stock');
panel_multi('stockoverview', 'block', false);
if ($v_stock__index != '') {
$zfm->AddBarisKosong(true);
$zfm->Start_form(true, 'frm1');
$zfm->BuildForm('stokoverview', false, '50%');
echo "<hr>";
$zlb->section('stokoverlist');
$zlb->aksi(false);
$zlb->icon();
$zlb->Header('60%', 'stoked');
echo "</tbody></table>";
} else {
no_auth();
}
panel_multi_end();
panel_multi('liststock', 'none', false);
if ($v_liststock != '') {
echo "<form id='frm2' name='frm2' method='post' action=''>";
addText(array('Filter by Kategori', 'Status', '', 'Nama Barang/Kode ', ''), array("<select id='id_kategori' name='id_kategori' class='s100'></select>", "<select id='stat_barang' name='stat_barang' class='s100'>\r\n\t\t\t\t\t <option value=''>Semua</option>\r\n\t\t\t\t\t<option value='Continue'>Continue</option>\r\n\t\t\t\t\t<option value='Discontinue'>Discontinue</option></select>", '<input type="button" id="saved-filter" value="Process">', '<input type="text" id="nam_barang" name="nam_barang" value="" class="w100 carix" title="Silahkan ketik nama barang atau kode barang">', '<input type="button" id="cari" value="Cari">'));
echo "</form>";
$zlb->section('stoklistview');
$zlb->aksi(true);
$zlb->icon();
$zlb->Header('100%');
echo "</tbody></table>";
exit('No direct script access allowed');
}
$zfm = new zetro_frmBuilder('asset/bin/zetro_master.frm');
$zlb = new zetro_buildlist();
$zlb->config_file('asset/bin/zetro_master.frm');
$path = 'application/views/master';
link_js('jquery.fixedheader.js,master_tools.js,jquery_terbilang.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Tools Akun');
panel_multi('settingneraca', 'block', false);
if ($all_settingneraca != '') {
$zlb->section('neraca');
$zlb->aksi(false);
$zlb->icon();
$zlb->sub_total(false);
$zlb->sub_total_field('stock,blokstok');
$zlb->Header('100%');
$n = 0;
foreach ($head as $lh) {
$n++;
echo "<tr class='xx' onClick=\"show_detail('" . $lh->ID . "');\" id='c-" . $lh->ID . "'>\r\n\t\t\t\t <td class='kotak' align='center'>{$n}</td>\r\n\t\t\t\t <td class='kotak'>" . $lh->Header2 . "</td>\r\n\t\t\t\t <td class='kotak'>" . $lh->Jenis1 . "</td>\r\n\t\t\t\t </tr>\n";
}
echo "</body></table><hr>\n";
$zlb->section('subneraca');
$zlb->aksi(false);
$zlb->icon();
$zlb->sub_total(false);
$zlb->sub_total_field('stock,blokstok');
$zlb->Header('100%', 'SubTable');
echo "</body></table>\n";
} else {
no_auth();