You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
148 lines
6.9 KiB
PHP
148 lines
6.9 KiB
PHP
<?php
|
|
include "../func_lib.php";
|
|
|
|
session_start();
|
|
if($_SESSION['validUser'] !== TRUE)
|
|
{
|
|
header("location: ./index.php");
|
|
exit();
|
|
}
|
|
echo "<style type='text/css'>";
|
|
echo "div#divprint{width:850px; border:1px solid #000; padding:20px 0; margin-bottom:25px;}";
|
|
echo "table.tbl {width:100%;border-width:0 0 1px 1px;border-spacing:0;border-collapse:collapse;font-size:9pt;text-align:center;}";
|
|
echo "table.tbl,table.tbl td {border-color:#000;border-style:solid;}";
|
|
echo "table.tbl td {margin:0;padding:2px;border-width:1px 1px 0 0;}";
|
|
echo "body {font-size:9pt;}";
|
|
echo "div.luar{text-align:left;margin-left:50px;}";
|
|
echo ".header{font-weight:bold;text-align:center;}";
|
|
echo ".isi{text-align:left;}";
|
|
echo ".warnaBarisKategori{font-weight : bold; background-color: #FFFF33;}";
|
|
echo ".warnaBarisTot{font-weight : bold; background-color: #FFCC00;}";
|
|
echo ".master{text-align:left;}";
|
|
echo "</style>";
|
|
|
|
$tgl = $_GET['tgl'];
|
|
|
|
if(bukaKoneksi()){
|
|
global $conn;
|
|
|
|
print("<center>");
|
|
print("<h2>Laporan AK.7 Rinci</h2><br/><br/>");
|
|
print("<div class='luar'>TOKO ".$_SESSION['namatoko']."<br/>");
|
|
print("Tanggal : ".$tgl."<br/>");
|
|
print("DICETAK TANGGAL : ".date('d-m-Y [H:i]')."<br/><br/>");
|
|
print("<span style='color: red;'> *) Stock Minus : Hanya sebagai <i>notifikasi</i>, tidak turut dalam proses perhitungan apapun </span>");
|
|
print("</div>");
|
|
print("<table border='1' class='tbl'>");
|
|
print("<tr class='header'>
|
|
<td>Lini</td>
|
|
<td>Stock Awal</td>
|
|
<td>Pembelian</td>
|
|
<td>Revisi</td>
|
|
<td>Retur</td>
|
|
<td>Transfer</td>
|
|
<td>Transfer Kembali</td>
|
|
<td>Penjualan</td>
|
|
<td>Bawa Dulu</td>
|
|
<td>Kembali Bawa Dulu</td>
|
|
<td>Stock Opname</td>
|
|
<td>Stock Minus<span style='color: red;'>*)</span></td>
|
|
<td>Stock(hsl perhitungan)</td>
|
|
<td>Stock(komp)</td>
|
|
<td>Selisih</td>
|
|
</tr>");
|
|
|
|
|
|
//Tampilkan AK7rinci
|
|
$queryView = "SELECT * FROM tempAK7rinci WHERE tanggal = '$tgl' order by id";
|
|
$resultView = runningQuery($queryView);
|
|
if($resultView->num_rows > 0){
|
|
$ttstockawal = 0;
|
|
$ttpembelian = 0;
|
|
$ttrevisi = 0;
|
|
$ttretur = 0;
|
|
$tttransfer = 0;
|
|
$tttransferkembali = 0;
|
|
$ttpenjualan = 0;
|
|
$ttbawa = 0;
|
|
$ttkembalibawa = 0;
|
|
$ttstockopname = 0;
|
|
$ttstockminus = 0;
|
|
$ttperhitungan = 0;
|
|
$ttstockakhir = 0;
|
|
$ttselisih = 0;
|
|
|
|
while($View = $resultView->fetch_array(MYSQLI_ASSOC)){
|
|
$tanggal = $View['tanggal'];
|
|
$lini = $View['lini'];
|
|
$stockawal = $View['stockawal'];
|
|
$pembelian = $View['pembelian'];
|
|
$revisi = $View['revisi'];
|
|
$retur = $View['retur'];
|
|
$transfer = $View['transfer'];
|
|
$transferkembali = $View['transferkembali'];
|
|
$penjualan = $View['penjualan'];
|
|
$bawa = $View['bawa'];
|
|
$kembalibawa = $View['kembalibawa'];
|
|
$stockopname = $View['stockopname'];
|
|
$stockmin = $View['stockminus'];
|
|
$perhitungan = $stockawal + $pembelian + $revisi - $retur - $transfer + $transferkembali - $penjualan - $bawa + $kembalibawa + $stockopname ;
|
|
$stockakhir = $View['stockakhir'];
|
|
$selisih = $perhitungan - $stockakhir;
|
|
|
|
$ttstockawal += $stockawal;
|
|
$ttpembelian += $pembelian;
|
|
$ttrevisi += $revisi;
|
|
$ttretur += $retur;
|
|
$tttransfer += $transfer;
|
|
$tttransferkembali += $transferkembali;
|
|
$ttpenjualan += $penjualan;
|
|
$ttbawa += $bawa;
|
|
$ttkembalibawa += $kembalibawa;
|
|
$ttstockopname += $stockopname;
|
|
$ttstockmin += $stockmin;
|
|
$ttperhitungan += $perhitungan;
|
|
$ttstockakhir += $stockakhir;
|
|
$ttselisih += $selisih;
|
|
|
|
echo "<tr><td>$lini</td>";
|
|
echo "<td align='right'>".number_format( $stockawal,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincibeli.php?tgllini=$tgl.$lini' target='blank'>".number_format($pembelian,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincirevisi.php?tgllini=$tgl.$lini' target='blank'>".number_format($revisi,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rinciretur.php?tgllini=$tgl.$lini' target='blank'>".number_format($retur,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincitransfer.php?tgllini=$tgl.$lini' target='blank'>".number_format($transfer,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincitransferkembali.php?tgllini=$tgl.$lini' target='blank'>".number_format($transferkembali,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincijual.php?tgllini=$tgl.$lini' target='blank'>".number_format($penjualan,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincirekapbawa.php?tgllini=$tgl.$lini' target='blank'>".number_format($bawa,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='kembalibawa.php?tgllini=$tgl.$lini' target='blank'>".number_format($kembalibawa,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincistockopname.php?tgllini=$tgl.$lini' target='blank'>".number_format($stockopname,0,",",".")."</td>";
|
|
echo "<td align='right'><a href='rincistokmin.php?tgllini=$tgl.$lini' target='blank'>".number_format($stockmin,0,",",".")."</td>";
|
|
echo "<td align='right'>".number_format( $perhitungan,0,",",".")."</td>";
|
|
echo "<td align='right'>".number_format( $stockakhir,0,",",".")."</td>";
|
|
echo "<td align='right'>".number_format( $selisih,0,",",".")."</td>";
|
|
echo "</tr>";
|
|
|
|
}
|
|
}
|
|
print("<tr style='font-weight: bold;'><td>T O T A L</b></td>
|
|
<td align='right'>".number_format( $ttstockawal,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttpembelian,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttrevisi,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttretur,0,",",".")."</td>
|
|
<td align='right'>".number_format( $tttransfer,0,",",".")."</td>
|
|
<td align='right'>".number_format( $tttransferkembali,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttpenjualan,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttbawa,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttkembalibawa,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttstockopname,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttstockmin,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttperhitungan,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttstockakhir,0,",",".")."</td>
|
|
<td align='right'>".number_format( $ttselisih,0,",",".")."</td>
|
|
</tr>");
|
|
|
|
print("</table><br/>");
|
|
print("</center>");
|
|
|
|
}
|
|
?>
|