Postingan lainnya
menampilkan data menggunakan tanggal periode smpai dengan detail data perperiode tsb
salam gan! mau tanya gan saya mau tampilin data per periode tapi sampai ke detail data perperiode tsb
nah ini form periode ane gan
<form action="result-report-po.php" name="forminputtanggal" method="POST" enctype="multipart/form-data">
<div class="row">
<div class="col-lg-6">
<div class="card">
<div class="card-header">Periode</div>
<div class="card-body card-block">
<div class="col-lg-12" style="overflow-y: auto; height: 220;">
<div class="form-group">
<div class="form-group">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr height="36">
<td>Dari Tanggal </td>
<td>
<input name="tgl_awal" size="24" required> <a href="javascript:void(0)"
onClick="if(self.gfPop)gfPop.fPopCalendar(document.forminputtanggal.tgl_awal);return false;" >
<img name="popcal" align="absmiddle" src="calender/calbtn.gif" width="34" height="22" border="0" alt=""></a>
</td>
</tr>
</table>
<iframe width=174 height=189 name="gToday:normal:agenda.js" id="gToday:normal:agenda.js" src="calender/ipopeng.htm"
scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:fixed; top:-500px; left:-500px;">
</iframe>
</div>
<div class="form-group">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr height="36">
<td>Sampai Tanggal</td>
<td>
<input name="tgl_akhir" size="24" required> <a href="javascript:void(0)"
onClick="if(self.gfPop)gfPop.fPopCalendar(document.forminputtanggal.tgl_akhir);return false;" >
<img name="popcal" align="absmiddle" src="calender/calbtn.gif" width="34" height="22" border="0" alt=""></a>
</td>
</tr>
</table>
<iframe width=174 height=189 name="gToday:normal:agenda.js" id="gToday:normal:agenda.js" src="calender/ipopeng.htm"
scrolling="no" frameborder="0" style="visibility:visible; z-index:999; position:fixed; top:-500px; left:-500px;">
</iframe>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-6">
<div class="card">
<div class="card-header">Jenis Laporan </div>
<div class="card-body card-block" style="overflow-y: auto;height: 143px;">
<div class="col-lg-12">
<div class="form-group">
<label>
<input type="radio" name="supplier" value="supplier"> Jenis Laporan : Berdasarkan Supplier
</label><br>
<label>
<input type="radio" name="proyek" value="proyek"> Jenis Laporan : Berdasarkan Proyek
</label>
</div>
</div>
</div>
</div>
</div>
</div> <!--row-->
<div class="form-actions form-group">
<button type="submit" name="search" value="search" class="btn btn-primary btn-sm">
<i class="fa fa-dot-circle-o"></i> Submit
</button>
<button type="reset" class="btn btn-danger btn-sm">
<i class="fa fa-ban"></i> Reset
</button>
</div>
</form>
ini resultnya
<?php
include "config/config.php";
if (isset($_POST['search'])) {
if(isset($_POST['supplier'])){
$tgl_awal=$_POST['tgl_awal'];
$tgl_akhir=$_POST['tgl_akhir'];
if (empty($tgl_awal) || empty($tgl_akhir)){
?>
<script language="javascript">
alert('Tanggal Awal dan Tanggal Akhir Harap di Isi!');
document.location='report-purchase-order.php';
</script>
<?php
} else{ ?>
<div class="col-xl-12">
<div class="card-header">Purchase Order : Berdasarkan Supplier</div>
<div class="card">
<div class="col-xl-12">
<table class="table table-hover table-fixed">
<thead>
<tr style="font-size:10px; text-align: center">
<th>NO</th>
<th>KODE SUPPLIER</th>
<th>SUPPLIER</th>
<th>ORDER</th>
<th>ACTION</th>
</tr>
</thead>
<i>
<b>Informasi : </b> Hasil pencarian data berdasarkan periode Tanggal <b><?php echo $_POST['tgl_awal']?></b> s/d <b><?php echo $_POST['tgl_akhir']?></b>
</i>
<?php
$no=0;
$sql = "SELECT SUM(total_po) as total_po, E.nama_supplier, E.id_supplier, A.id_purchase_order, A.tgl_po, C.nama_jenis_po, D.nama_jenis_payment
FROM tbl_purchase_order AS A
INNER JOIN tbl_kontrak_proyek AS B ON B.id_proyek = A.id_proyek
INNER JOIN tbl_jenis_po AS C ON C.id_jenis_po = A.id_jenis_po
INNER JOIN tbl_jenis_payment AS D ON D.id_jenis_payment = A.id_jenis_payment
INNER JOIN tbl_supplier AS E ON E.id_supplier = A.id_supplier
INNER JOIN tbl_user AS F ON F.id_user = A.id_user WHERE A.tgl_po BETWEEN '$tgl_awal' AND '$tgl_akhir'
GROUP BY nama_supplier";
}
$qnews=$koneksi->query($sql);
$rownews=$qnews->fetch_array();
do{
$no++;
?>
<tbody>
<tr style="font-size:10px; text-align: center">
<td style="text-align:center;"><?php echo $no;?></td>
<td style="text-align:center;"><?php echo $rownews['id_supplier'];?></td>
<td style="text-align:center;"><?php echo $rownews['nama_supplier'];?></td>
<td style="text-align:center;">Rp. <?php echo number_format ($rownews['total_po'],0,".",".");?></td>
<td style="text-align:center;">
<a href="result-report-po.php?id_supplier=<?php echo $rownews['id_supplier'];?>" name="supplier_detail" value="supplier_detail" class="fa fa-edit fa-lg" title="Detail"></a>
</td>
</tr>
</tbody>
<?php
}while($rownews=$qnews->fetch_assoc()); ?>
<?php
$no=0;
$sql = "SELECT SUM(total_po) as total FROM tbl_purchase_order AS A
JOIN tbl_kontrak_proyek AS B ON B.id_proyek = A.id_proyek
JOIN tbl_jenis_po AS C ON C.id_jenis_po = A.id_jenis_po
JOIN tbl_jenis_payment AS D ON D.id_jenis_payment = A.id_jenis_payment
JOIN tbl_supplier AS E ON E.id_supplier = A.id_supplier
JOIN tbl_user AS F ON F.id_user = A.id_user WHERE A.tgl_po BETWEEN '$tgl_awal' AND '$tgl_akhir'
ORDER BY id_purchase_order";
$qnews=$koneksi->query($sql);
$rownews=$qnews->fetch_array();
?>
<tr style="font-size:15px;">
<td style="text-align:center;" colspan="3">Total</td>
<td style="text-align:center;" colspan="3">Rp. <?php echo number_format ($rownews['total'],0,".",".");?></td>
</tr>
</table>
<a href="report-purchase-order.php">
<button type="reset" class="btn btn-primary btn-sm" style="margin: 0px 0px 10px 0px">
<i class="fa fa-backward"></i> BACK
</button>
</a>
</div>
<?php
}
}
else{
unset($_POST['supplier']);
unset($_POST['search']);
}
?>
ane mau tampilin lagi data per row nya dengan action ini gan
<td style="text-align:center;">
<a href="result-report-po.php?id_supplier=<?php echo $rownews['id_supplier'];?>" name="supplier_detail" value="supplier_detail" class="fa fa-edit fa-lg" title="Detail"></a>
</td>
detail nya perperiode yang dipilih gan
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban