<?php require_once(MODDIR.'control.php'); $tbl=stocktake_ctable(); $ncek_y=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='Y'")); $ncek=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl)); $wcek=intval($ncek_y*400/$ncek); stocktake_ptrack(2); //<button class="btn" onclick="stocktake_cek()">Reload</button> ?> <div style="padding:10px"> <div style="width:100%;float:left;margin-bottom:10px;margin-top:10px"> <div class="sfont" style="font-size:13px;">Cek buku:</div> </div> <div style="width:100%;float:left;padding-bottom:20px;border-bottom:1px solid #ccc;margin-bottom:10px"> <?=iText('barkode','','width:300px;height:26px;font-size:14px;float:left;margin-right:4px','barkode','onkeyup="stocktake_cekbarkode(event)"')?> <button class="btnz" style="height:26px;width:60px" onclick="stocktake_cek_barkode()">Cek</button> </div> <div class="sfont" style="float:left;width:100%;margin-bottom:10px">Item terpindai: <span id="scinfo"></span></div> <div class="sfont" style="float:left;width:100%;margin-bottom:10px;padding-bottom:20px;border-bottom:1px solid #ccc;"> <table cellspacing="0" cellpadding="0" border="0"> <tr> <td><button title="Batal" class="btn" style="border-radius:15px;margin-right:6px" onclick="stocktake_cancel()"><div class="bi_canb"> </div></button></td> <td><div id="scbcd" class="scbcd"></div><input type="hidden" id="buku_id" value="0"/></td> <td><button id="okbtn" class="btn" style="display:none;width:50px;height:30px;margin-right:20px" onclick="stocktake_cek_buku()"><b>OK</b></button></td> </tr> <tr><td></td> <td> <label id="oklbl" style="float:left;margin-top:10px;margin-left:6px;"><input type="checkbox" class="iCheck" id="aoke" style="float:left"><div class="sfont" style="color:#666;float:left"> OK otomatis untuk mengecek buku yang ditemukan belum di cek</div></label> </td> </table> </div> <div style="width:100%;float:left;margin-bottom:10px;margin-top:10px">
<?php require_once(MODDIR.'xform/xform.php'); require_once(MODDIR.'control.php'); $opt=gpost('opt'); $cid=gpost('cid'); if($cid=='')$cid=0; stocktake_ptrack(1); $tbl=stocktake_ctable(); $a=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl)); $b=mysql_num_rows(mysql_query("SELECT * FROM pus_buku")); $p=intval($a*400/$b); $c=intval($a*100/$b); ?> <div class="sfont" style="float:left;width:100%;margin-bottom:6px">Mempersiakan data base...</div> <div style="float:left;width:100%"> <table cellspacing="0" cellpadding="0" border="0"><tr> <td> <div id="pbar0" style="width:400px;height:9px;border:1px solid #008ee8;border-radius:3px"> <div id="pbar1" style="width:<?=$p?>px;height:9px;background:#008ee8"> </div> </div> </td> <td style="padding-left:6px"> <div id="pbarp" class="sfont"><?=$c?>%</div> </td> </table> </div>
<?php require_once(MODDIR.'control.php'); $opt=gpost('opt'); $cid=gpost('cid'); if($cid=='')$cid=0; $keyw=gpost('keyword'); $keyn=gpost('keyon'); $tbl=stocktake_ctable(); $tamp=gpost('tampil'); if($tamp=='')$tamp=0; $fmod='stocktake_note'; $xtable = new xtable($fmod,'Buku'); $xtable->pageorder=$tbl.".cek, pus_buku.barkode"; stocktake_ptrack(3); // Query if($tamp==0){ $f=" WHERE ".$tbl.".cek='N'"; } else if($tamp==1){ $f=" WHERE ".$tbl.".cek='Y'"; } else { $f=""; } if($keyw!=""){ if($f=="")$f=" WHERE josh.pus_buku.barkode='$keyw' OR josh.pus_katalog.judul LIKE '%$keyw%'"; else $f.=" AND ( josh.pus_buku.barkode='$keyw' OR josh.pus_katalog.judul LIKE '%$keyw%' )"; } $sql="SELECT ".$tbl.".*,josh.pus_buku.barkode,josh.pus_katalog.judul FROM ".$tbl." LEFT JOIN josh.pus_buku ON josh.pus_buku.replid=".$tbl.".buku LEFT JOIN josh.pus_katalog ON josh.pus_katalog.replid=josh.pus_buku.katalog".$f; $t=mysql_query($sql); $xtable->ndata=mysql_num_rows($t); $t=mysql_query($sql.$xtable->pageorder_sql('pus_buku.barkode','pus_katalog.judul',$tbl.'.cek')); //echo $sql.$xtable->pageorder_sql('pus_buku.barkode','pus_buku.judul',$tbl.'.cek');
<?php stocktake_ptrack(4); $tbl=stocktake_ctable(); $tot=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl)); $ncek=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='Y'")); $nnocek=$tot-$ncek; $nwn=mysql_num_rows(mysql_query("SELECT * FROM ".$tbl." WHERE cek='N' AND note<>''")); $nnn=$nnocek-$nwn; $t=mysql_query("SELECT * FROM pus_stockhist WHERE status='4' LIMIT 0,1"); $r=mysql_fetch_array($t); $tgl=date("Y-m-d"); mysql_query("UPDATE pus_stockhist SET status='5',nitem='$tot',nceky='$ncek',nnote='$nwn',tanggal2='$tgl' WHERE status='4' LIMIT 1"); ?> <div style="padding:10px"> <div class="infobox" style="width:100%;float:left;margin-top:10px;margin-bottom:20px;margin-left:-2px"> Proses stock opname telah selesai. </div> <div class="sfont" style="width:100%;float:left;margin-bottom:10px"> <b>Rangkuman proses stock opname:</b> </div> <div style="width:100%;float:left"> <table class="stable" cellspacing="0" cellpadding="0"> <tr height="24px"><td width="180px">Total item di database</td><td>: <?=$tot?> item</td></tr> <tr height="24px"><td>Item dicek</td><td>: <?=$ncek?> item</td></tr> <tr height="24px"><td>Item hilang</td><td>: <?=$nnocek?> item</td></tr> <tr height="24px"><td>Item hilang dengan keterangan</td><td>: <?=$nwn?> item</td></tr> <tr height="24px"><td>Item hilang tanpa keterangan</td><td>: <?=$nnn?> item</td></tr> </table> </div> <div style="width:100%;float:left;text-align:left;margin-top:20px">
<?php require_once(MODDIR.'control.php'); $cid=gpost('cid'); stocktake_ptrack(5); $t=mysql_query("SELECT * FROM pus_stockhist WHERE replid='$cid' LIMIT 0,1"); $r=mysql_fetch_array($t); $tbl="joshso.".$r['tabel']; $tot=$r['nitem']; $ncek=$r['nceky']; $nnocek=$tot-$ncek; $nwn=$r['nnote']; $nnn=$nnocek-$nwn; ?> <div style="padding:10px"> <div class="sfont" style="width:100%;font-size:14px;float:left;margin-bottom:10px"> Cetak laporan stock opname </div> <div class="sfont" style="width:100%;float:left;margin-bottom:20px"> <table class="stable" cellspacing="0" cellpadding="0"> <tr height="24px"> <td width="150px">Nama stock opname</td><td width="150px">: <?=$r['nama']?></td> <td></td><td></td> </tr> <tr height="24px"> <td>Tanggal mulai</td><td>: <?=fftgl($r['tanggal1'])?></td> <td></td><td></td> </tr> <tr height="24px"> <td>Tanggal selesai</td><td>: <?=fftgl($r['tanggal2'])?></td> <td></td><td></td> </tr>