<div align="RiGHT">
<h3>
<a href="?mnu=analisa">Per Barang</a> |
<a href="?mnu=analisa2">Per Waktu %Y%M</a>
</h3>
</div>
<?php
$sql0 = "SELECT * from `tb_barang` order by id_barang asc";
$no = 1;
$arr0 = getData($conn, $sql0);
foreach ($arr0 as $d0) {
$id_barang = $d0["id_barang"];
$nama_barang = $d0["nama_barang"];
$sql = "select `$tbpo`.`id_po`,`$tbpo`.`tanggal` ,`$tbdetail`.`jumlah_karton` from `$tbpo`,`$tbdetail`
where `$tbpo`.id_po=`$tbdetail`.id_po
and `$tbdetail`.id_barang='$id_barang'
order by `$tbpo`.`tanggal` asc";
$tot=0;
$jum = getJum($conn, $sql);
$gab="<b>$nama_barang ($id_barang)</b><ol>";
if ($jum > 0) {
$no = 1;
$arr = getData($conn, $sql);
foreach ($arr as $d) {
$id_po = $d["id_po"];
$tanggal = $d["tanggal"];
$jumlah_karton = $d["jumlah_karton"];
$tot+=$jumlah_karton;
$gab.="<li><a href='?mnu=detail&id=$id_po'>$id_po</a> $tanggal : <b>$jumlah_karton</b></li>";
}
$gab.="</ol><b>Total $tot</b><br>";
echo $gab;
}//jum
}
==================================
<div align="RiGHT">
<h3>
<a href="?mnu=analisa">Per Barang</a> |
<a href="?mnu=analisa2">Per Waktu %Y%M</a>
</h3>
</div>
<?php
$no = 1;
$tot=0;
$sql0 = "SELECT distinct(`id_barang`) from `$tbdetail` order by id_barang asc";
$arr0 = getData($conn, $sql0);
foreach ($arr0 as $d0) {
$id_barang = $d0["id_barang"];
$nama_barang = getBarang($conn,$id_barang);
$gab="<b>$no. $nama_barang ($id_barang)</b><ol>";
$sql00 = "SELECT `tb_po`.`tanggal` from
`tb_po`,`$tbdetail`
where
`tb_po`.id_po=`$tbdetail`.id_po
and
`$tbdetail`.id_barang='$id_barang'
GROUP BY DATE_FORMAT(`tb_po`.tanggal, '%Y%m') order by `tb_po`.tanggal asc";
$arr00 = getData($conn, $sql00);
foreach ($arr00 as $d00) {
$tanggal = $d00["tanggal"];
$TGL=setBul($tanggal);
$ar=explode("-",$tanggal);
$bln=$ar[1];
$thn=$ar[0];
$per1="$thn-$bln-01";
$per2="$thn-$bln-31";
$sql = "select sum(`$tbdetail`.`jumlah_karton`) as `subjumlah` from `$tbpo`,`$tbdetail`
where `$tbpo`.id_po=`$tbdetail`.id_po
and (`$tbpo`.tanggal between '$per1' and '$per2')
and `$tbdetail`.id_barang='$id_barang'
order by `$tbpo`.`tanggal` asc";
$jum = getJum($conn, $sql);
if ($jum > 0) {
$no = 1;
$d = getField($conn, $sql);
$subjumlah = $d["subjumlah"]+0;
$tot+=$subjumlah;
$gab.="<li><a href='?mnu=po2&tgl=$tanggal&id_barang=$id_barang'>Periode $TGL</a>:<b>$subjumlah</b></li>";
}//jum
}//distinct Bulan thn
$gab.="</ol>Total $tot Item<br>";
echo $gab;
$no++;
}
============
<?php
//error_reporting(0);
?>
<script type="text/javascript">
function PRINT() {
win = window.open('po/po_print.php', 'win', 'width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=0');
}
</script>
<?php
$tanggal = $_GET["tgl"];
$id_barang= $_GET["id_barang"];
$TGL=setBul($tanggal);
$ar=explode("-",$tanggal);
$bln=$ar[1];
$thn=$ar[0];
$per1="$thn-$bln-01";
$per2="$thn-$bln-31";
$w1=WKT($per1);
$w2=WKT($per2);
$NB=getBarang($conn,$id_barang);
?>
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-body">
<h6>Rekapitulasi <?php echo $TGL;?></h6>
<hr>
<div class="row">
<div class="col-md-6">
<label for="id_po">Nama Barang</label>
<input type="text" class="form-control" required name="id_po" id="id_po" value="<?php echo $NB; ?>" readonly>
</div>
<div class="col-md-6">
<label for="id_pelanggan">ID Barang</label>
<input type="text" class="form-control" required name="id_po" id="id_po" value="<?php echo $id_barang; ?>" readonly>
</div>
</div>
<div class="row">
<div class="col-md-12"><br>
<label for="status">Periode</label><br>
<input type="text" class="form-control" required name="id_po" id="id_po" value="<?php echo "$w1 s/d $w2"; ?>" readonly>
</div>
</div>
</div>
</div>
</div>
</div>
<hr>
<div class="card mb-4">
<div class="card-header">
<i class="fas fa-table me-1"></i>
Data PO :| <img src='ypathicon/print.png' title='PRINT' OnClick="PRINT()"> |
</div>
<div class="card-body">
<table class="table table-striped" id="myTable">
<thead>
<tr>
<th width="3%">No</td>
<th width="80%">Data Order</th>
<th width="15%">Status</th>
</tr>
</thead>
<tbody>
<?php
$tot=0;
$sql = "select `$tbpo`.id_po,`$tbpo`.tanggal,`$tbpo`.id_pelanggan,`$tbpo`.status from `$tbpo`
where (`$tbpo`.tanggal between '$per1' and '$per2')
order by `$tbpo`.`tanggal` asc";
$no = 1;
$arr = getData($conn, $sql);
foreach ($arr as $d) {
$stot=0;
$id_po = $d["id_po"];
$tanggal_po = WKT($d["tanggal"]);
$id_pelanggan = $d["id_pelanggan"];
$NP=getPelanggan($conn,$id_pelanggan);
$status= $d["status"];
$sqlv = "select id_barang,jumlah_karton,jumlah_pcs from `$tbdetail` where id_po='$id_po' and `id_barang`='$id_barang' order by `id_detail` desc";
if(getJum($conn,$sqlv)>0){
$gab = "<ul>";
$arrv = getData($conn, $sqlv);
foreach ($arrv as $dv) {
$jumlah_karton = $dv["jumlah_karton"];
$jumlah_pcs = $dv["jumlah_pcs"];
$id_barang = $dv["id_barang"];
$stot+=$jumlah_karton;
$tot+=$jumlah_karton;
$gab .= "<li><small>$id_barang |$NB</small> : <label title='PCS: $jumlah_pcs'>$jumlah_karton Item</label</li>";
}
$gab .= "</ul>";
echo "<tr>
<td>$no</td>
<td><b>$id_po ($tanggal_po)#$NP|$id_pelanggan </b>
<br>$gab
</td>
<td align='center'>$stot /$tot<br><br><br>$status</td>
</tr>";
$no++;
}//jumv
}
?>
</tbody>
</table>
<?php
echo "<big>Total Transaksi $NB : $tot Item</big>";
?>
</div>
</div>
<div align="RiGHT">
<h3>
<a href="?mnu=nb">Algoritma NB</a> |
<a href="?mnu=svm">Algoritma SVM</a>
</h3>
</div>
<hr>
<?php
$sql = "select * from `$tbpengujian` order by `id_pengujian` desc";
if(isset($_GET["id"])){
$id_pengujian=$_GET["id"];
$sql = "select * from `$tbpengujian` where id_pengujian='$id_pengujian'";
}
$d = getField($conn, $sql);
$id_pengujian = $d["id_pengujian"];
$tanggal = WKT($d["tanggal"]);
$jam = $d["jam"];
$id_barang = $d["id_barang"];
$nama_pengujian = $d["nama_pengujian"];
$group = $d["group"];
$durasi = $d["durasi"];
$sql = "select * from `$tbbarang` where `id_barang`='$id_barang'";
$d = getField($conn, $sql);
$nama_barang = $d["nama_barang"];
$deskripsi = $d["deskripsi"];
$gambar = $d["gambar"];
$harga = $d["harga"];
$satuan = $d["satuan"];
$pcs = $d["pcs"];
$berat = $d["berat"];
$ukuran = $d["ukuran"];
$arJ=array();
$i=0;
$sql = "SELECT `jumlah` from `tb_normalisasi` where `id_pengujian`='$id_pengujian' order by id_norm asc";
$arr = getData($conn, $sql);
foreach ($arr as $d) {
$jumlah = $d["jumlah"];
$arJ[$i]=$jumlah;
$i++;
}
$max=max($arJ);
$min=min($arJ);
$ARL=setLevel($min,$max,$group);
?>
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-body">
<h6>Data Pengujian UJI:<?php echo $id_pengujian;?></h6>
<hr>
<div class="row">
<div class="col-md-3">
<label for="id_barang">ID Pengujian</label>
<input type="text" class="form-control" required name="id_pengujian0" id="id_pengujian0" value="UJI:<?php echo $id_pengujian; ?>" readonly>
</div>
<div class="col-md-9">
<label for="nama_barang">Nama Pengujian</label>
<input type="text" class="form-control" required name="nama_pengujian" readonly id="nama_pengujian" value="<?php echo $nama_pengujian; ?>" placeholder="">
</div>
</div>
<div class="row">
<div class="col-md-3">
<label for="id_barang">ID Barang</label>
<input type="text" class="form-control" required name="id_barang" id="id_barang" value="<?php echo $id_barang; ?>" readonly>
</div>
<div class="col-md-9">
<label for="nama_barang">Nama Barang</label>
<input type="text" class="form-control" required name="nama_barang" id="nama_barang" value="<?php echo $nama_barang; ?>" readonly placeholder="">
</div>
</div>
<div class="row">
<div class="col-md-3">
<label for="id_barang">Group Pengujian</label>
<input type="text" class="form-control" required name="group" id="group" value="<?php echo $group; ?> Level" readonly placeholder="">
</div>
<div class="col-md-9">
<label for="nama_barang">Lama Prediksi</label>
<input type="text" class="form-control" required name="durasi" id="durasi" value="<?php echo $durasi; ?> Bulan Yang Akan Datang" readonly>
</div>
</div>
<div class="row">
<div class="col-md-12">
<table class="table table-striped" id="myTable">
<thead>
<tr>
<th width="3%">No</td>
<th width="15%">Periode</td>
<th width="7%">Jumlah</td>
<th width="7%">Level</td>
</tr>
</thead>
<tbody>
<?php
$arP=array();
$sql = "SELECT * from `tb_normalisasi` where `id_pengujian`='$id_pengujian' order by id_norm asc";
$jum = getJum($conn, $sql);
if ($jum > 0) {
$no = 1;
$arr = getData($conn, $sql);
foreach ($arr as $d) {
$id_barang = $d["id_barang"];
$jumlah = $d["jumlah"];
$periode = $d["periode"];
$keterangan = $d["keterangan"];
$id_norm = $d["id_norm"];
$level=getLevel($ARL,$jumlah);
$i=$no-1;
$arP[$i]=$level;
$sqlUP = "UPDATE `tb_normalisasi` set `level`='$level' where `id_norm`='$id_norm'";
process($conn, $sqlUP);
echo "<tr>
<td>$no</td>
<td>$periode</td>
<td>$jumlah</td>
<td>$level</td></tr>
";
$no++;
} //for dalam
} //if
else {
echo "<tr><td colspan='6'><blink>Maaf, Data Normalisasi belum tersedia...</blink></td></tr>";
}
?>
</tbody>
</table></div> </div>
<?php
$jiter=$i-$group;
$gab="<h3>Dataset @$group Item</h3><ol>";
$arUji=array();
$gabUji="<h3>Dataset @$group Item</h3><ol>";
for($i=0;$i<=$jiter;$i++){
$gab.="<li>";
for($j=$i;$j<$group+$i;$j++){
$gab.=$arP[$j]."|";
}
$gab.=" = ".$arP[$i+$group]."</li>";
}
$gab.="</ol>";
echo $gab;
$gab="<h3>Prediksi $durasi Bulan YAD</h3>";
$arN=setINC($periode, $durasi);
for($i=0;$i<count($arN);$i++){
$gab.="$i.".$arN[$i]."<br>";
}
echo $gab;
?>
</div>
</div>
</div>
</div>
