<?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>
