PHP,
pasted
on Jan 18:
|
echo"<div class='w3-container w3-small w3-pale-green w3-leftbar w3-border-green'>
<h4 style='margin-bottom:0;padding-bottom:0;'>Transaksi Penjualan $_GET[jfaktur]</h4>
<p style='margin-top:0;padding-top:0;'><i>Menu Transaksi Penjualan $_GET[jfaktur]</i></p>
</div>
<div class='w3-row-padding'>
<div class='w3-col s5'>Data Barang
<div style='border-bottom:1px dashed #ccc;'></div>
<table style='margin-top:12px;'>
<tr>
<td>
<form class='w3-tiny' action='' method='GET'>
<input type='hidden' name='mod' value='penjualan'>
<div class='w3-row'>
<div class='w3-col s1'>
<label class='w3-label'>Search</label>
</div>
<div class='w3-col s3'>
<select name='field' class='w3-select w3-padding'>
<option value='kode'>KODE</option>
<option value='nama'>NAMA</option>
</select>
</div>
<div class='w3-col s3'>
<input type='text' name='cari' class='w3-input' placeholder='cari ...'>
</div>
<div class='w3-col s2'>
<button type='submit' class='w3-btn w3-tiny'><i class='fa fa-paper-plane'></i> GO</button>
</div>
<div class='w3-col s2'>
<a href='med.php?mod=penjualan&jfaktur=$_GET[jfaktur]' class='w3-btn w3-dark-grey w3-tiny'><i class='fa fa-refresh'></i> REFRESH</a>
</div>
</div>
</form>
</td>
</tr>
</table>
<div style='margin-top:12px;margin-bottom:12px;'>
<table class='w3-table w3-striped w3-bordered w3-tiny w3-hoverable tbl'>
<thead>
<tr class='w3-yellow'>
<th width='5px'>NO</th>
<th width='50px'>KODE</th>
<th width='320px'>DESKRIPSI</th>
<th width='200px'>BTG. + ADD</th>
</tr>
</thead>
<tbody>";
$p = new Paging;
$batas = 5;
if(isset($_GET['show']) && is_numeric($_GET['show'])){
$batas = (int)$_GET['show'];
$linkaksi .="&show=$_GET[show]";
}
$posisi = $p->cariPosisi($batas);
$query = "SELECT * FROM db_barang ";
$q = "SELECT * FROM db_barang";
if(!empty($_GET['field'])){
$hideinp = "<input type='hidden' name='field' value='$_GET[field]'>
<input type='hidden' name='cari' value='$_GET[cari]'>";
$linkaksi .= "&field=$_GET[field]&cari=$_GET[cari]";
$query .= " WHERE $_GET[field] LIKE '%$_GET[cari]%'";
$q .= " WHERE $_GET[field] LIKE '%$_GET[cari]%'";
}
$query .= " LIMIT $posisi, $batas";
$q .= " ";
$sql_kul = mysql_query($query);
$fd_kul = mysql_num_rows($sql_kul);
if($fd_kul > 0){
$no = $posisi + 1;
while ($m = mysql_fetch_assoc($sql_kul)){
echo"<tr>
<td>$no</td>
<td>$m[kode]</td>
<td>$m[nama]</br>UK. $m[p] x $m[l] x $m[t]</td>
<td><form action='$aksi'>
<input type='hidden' name='mod' value='penjualan'>
<input type='hidden' name='act' value='add'>
<input type='hidden' name='id' value='$m[kode]'>
<input type='hidden' name='jfaktur' value='$_GET[jfaktur]'>
<div class='w3-row'>
<div class='w3-col s6'><input type='text' name='btg' class='w3-select w3-border w3-hover-grey w3-right-align kanan' maxlength='8' placeholder='0' required></div>
<div class='w3-col s4'><button type='submit' class='w3-btn w3-red w3-tiny'><i class='fa fa-cart-plus'></i> ADD</button>
</div>
</div>
</form>
</td>
</tr>";
$no++;
}
$jmldata = mysql_num_rows(mysql_query($q));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET['halaman'], $jmlhalaman, $linkaksi);
}else{
echo"<tr>
<td colspan='4'><div class='w3-center'><i>Data Barang Not Found.</i></div></td>
</tr>";
}
echo"</tbody>
</table>
</div>
<div class='w3-row'>
<div class='w3-col s2'>
<form class='w3-tiny' action='' method='GET'>
<input type='hidden' name='mod' value='penjualan'>
<input type='hidden' name='jfaktur' value='$_GET[jfaktur]'>";
if(!empty($hideinp)){
echo $hideinp;
}
echo"<select class='w3-select w3-border' name='show' onchange='submit()'>
<option value=''>- Show -</option>
<option value='5'>5</option>";
$i=10;
while($i <= 100){
if(isset($_GET['show']) AND (int)$_GET['show'] == $i){
echo"<option value='$i' selected>$i</option>";
}else{
echo"<option value='$i'>$i</option>";
}
$i+=10;
}
echo"</select>
</form>
</div>
<div class='w3-col s10'>
<ul class='w3-pagination w3-right w3-tiny'>
$linkHalaman
</ul>
</div>
</div>
</div>";
$jp_temp = mysql_fetch_assoc(mysql_query("SELECT sum(ton) as ton
FROM db_detail_penjualan_tmp
WHERE jfaktur = '$_GET[jfaktur]' AND user = '$_SESSION[login_id]'
ORDER BY date ASC")) or die(mysql_error());
$n_ton = $jp_temp['ton'];
echo "
<div class='w3-col s7 w3-card'>Keranjang Penjualan
<div style='border-bottom:1px dashed #ccc;'></div>
<font color='red'><b>Nilai Tonase : ".number_format($n_ton,4,'.',',')."";
if($n_ton>=0.5){
echo " Masukan Harga Ton";
}elseif($n_ton<0.5){
echo " Masukan Harga Inchi";
}
echo "
</b></font>
<table class='w3-table w3-tiny w3-hoverable tbl'>
<tr class='w3-blue'>
<th width='5%'>#</th>
<th width='35%'>DESKRIPSI</th>
<th width='10%'>BTG</th>";
if($n_ton>=0.5){
echo "
<th width='10%'>TON</th>
<th width='20%'>HARGA</th>
<th width='18%'>T.HARGA</th>";
}elseif($n_ton<0.5){
echo "
<th width='10%'></th>
<th width='18%'>HARGA</th>
<th width='20%'>T.HARGA</th>";
}
echo "
<th width='2%'> </th>
</tr>
<tbody>";
$sql_tmp = mysql_query("SELECT a.kode_barang, a.qty, a.harga, b.nama, b.p, b.l, b.t, b.nilai, a.ton
FROM db_detail_penjualan_tmp a, db_barang b
WHERE a.kode_barang = b.kode AND a.jfaktur = '$_GET[jfaktur]' AND a.user = '$_SESSION[login_id]'
ORDER BY a.date ASC") or die(mysql_error());
$no = 1;
$t_qty = $t_ton = 0;
$jsql_temp = mysql_num_rows($sql_tmp);
if($jsql_temp > 0){
while($b = mysql_fetch_assoc($sql_tmp)) {
$t_ton = $t_ton + $b['ton'];
$t_qty = $t_qty + $b['qty'];
echo"<tr style='border-bottom:1px dashed #ccc;'>
<td>$no</td>
<td>$b[nama]</br>UK. $b[p] x $b[l] x $b[t]</td>
<td><input type='text' name='qty$no' id='qty$no' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($b['qty'])."' readonly></td>";
if($n_ton>=0.5){
echo "
<td><input type='text' name='ton$no' id='ton$no' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($b['ton'],4,'.',',')."' readonly><div align='right'></td>
<td><input type='text' name='harga$no' id='harga$no' class='w3-select w3-border w3-hover-grey w3-right-align kanan' value='0' onkeyup=penjualanB('ton$no','harga$no','tharga$no')></td>
<td><input type='text' name='tharga$no' id='tharga$no' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}elseif($n_ton<0.5){
echo "
<td></td>
<td><input type='text' name='harga$no' id='harga$no' class='w3-select w3-border w3-hover-grey w3-right-align kanan' value='0' onkeyup=penjualanA('qty$no','harga$no','tharga$no')></td>
<td><input type='text' name='tharga$no' id='tharga$no' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}
echo "
<td><div align='right'><a href='$aksi?mod=penjualan&act=batal&id=$b[kode_barang]' onclick=\"return confirm('Yakin ingin membatalkan?');\"><i class='fa fa-close w3-tiny w3-text-red'></i></a></div></td>
</tr>";
$no++;
}
}else{
echo"<tr>
<td colspan='4'><center><i>Keranjang Kosong</i></center></td>
</tr>";
}
echo"</tbody>
<tfoot><input type='text' name='nilai' id='nilai' value='".$jsql_temp."'>
<tr>
<td colspan='2'><b>TOTAL</b></td>
<td><input type='text' name='gqty' id='gqty' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($t_qty)."' readonly></td>";
if($n_ton>=0.5){
echo "
<td><input type='text' name='gton' id='gton' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($t_ton,4,'.',',')."' readonly></td>
<td><input type='text' name='gharga' id='gharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>
<td><input type='text' name='gtharga' id='gtharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}elseif($n_ton<0.5){
echo "
<td></td>
<td><input type='text' name='gharga' id='gharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>
<td><input type='text' name='gtharga' id='gtharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}
echo "
</tr>
<tr>
<td colspan='5'><b>POTONGAN HARGA (Rp.)<b></td>
<td><input type='text' name='potongan' id='potongan' class='w3-select w3-border w3-hover-grey w3-right-align' value='0'></td>
</tr>
<tr style='border-top:1px dashed #ccc;'>
<td colspan='4'><b class='w3-text-blue'>TOTAL BAYAR</b><td>
<td><input type='text' name='tot' id='tot' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>
</tr>
</tfoot>
</table><hr>
<div class='w3-card-2 w3-light-blue'>
<form action='$aksi?mod=penjualan&act=simpan' method='POST' class='w3-container'>
<input type='hidden' name='potongan2' id='potongan2' value='0'>
<input type='hidden' name='total' id='total' value='"?><?php echo isset($total_harga) ? $total_harga : 0; ?><?php echo"'>
<input type='hidden' name='jmlbayar2' id='bayar2'>
<label class='w3-label w3-text-black'>Nama Pelanggan :</label>
<input type='text' name='nama' id='nama' class='w3-input w3-tiny w3-border-0' required>
<label class='w3-label w3-text-black'>Bayar (Rp):</label>
<input type='text' name='jmlbayar' id='bayar' class='w3-input w3-tiny w3-border-0' required>
<label class='w3-label w3-text-black'>Status Pembayaran:</label>
<div class='w3-row'>
<div class='w3-col s6'>
<input type='radio' class='w3-radio' name='status' value='LUNAS' checked>
<label class='w3-validate'>LUNAS</label>
</div>
<div class='w3-col s6'>
<input type='radio' class='w3-radio' name='status' value='HUTANG'>
<label class='w3-validate'>HUTANG</label>
</div>
</div>
<p><button class='w3-btn w3-green' onclick=\"return confirm('Klik OK untuk melanjutkan');\"><i class='fa fa-save'></i> Simpan Transaksi</button></p>
</form>
</div><br>";
echo"</div>
</div>";
|
Output:
|
echo"<div class='w3-container w3-small w3-pale-green w3-leftbar w3-border-green'>
<h4 style='margin-bottom:0;padding-bottom:0;'>Transaksi Penjualan $_GET[jfaktur]</h4>
<p style='margin-top:0;padding-top:0;'><i>Menu Transaksi Penjualan $_GET[jfaktur]</i></p>
</div>
<div class='w3-row-padding'>
<div class='w3-col s5'>Data Barang
<div style='border-bottom:1px dashed #ccc;'></div>
<table style='margin-top:12px;'>
<tr>
<td>
<form class='w3-tiny' action='' method='GET'>
<input type='hidden' name='mod' value='penjualan'>
<div class='w3-row'>
<div class='w3-col s1'>
<label class='w3-label'>Search</label>
</div>
<div class='w3-col s3'>
<select name='field' class='w3-select w3-padding'>
<option value='kode'>KODE</option>
<option value='nama'>NAMA</option>
</select>
</div>
<div class='w3-col s3'>
<input type='text' name='cari' class='w3-input' placeholder='cari ...'>
</div>
<div class='w3-col s2'>
<button type='submit' class='w3-btn w3-tiny'><i class='fa fa-paper-plane'></i> GO</button>
</div>
<div class='w3-col s2'>
<a href='med.php?mod=penjualan&jfaktur=$_GET[jfaktur]' class='w3-btn w3-dark-grey w3-tiny'><i class='fa fa-refresh'></i> REFRESH</a>
</div>
</div>
</form>
</td>
</tr>
</table>
<div style='margin-top:12px;margin-bottom:12px;'>
<table class='w3-table w3-striped w3-bordered w3-tiny w3-hoverable tbl'>
<thead>
<tr class='w3-yellow'>
<th width='5px'>NO</th>
<th width='50px'>KODE</th>
<th width='320px'>DESKRIPSI</th>
<th width='200px'>BTG. + ADD</th>
</tr>
</thead>
<tbody>";
$p = new Paging;
$batas = 5;
if(isset($_GET['show']) && is_numeric($_GET['show'])){
$batas = (int)$_GET['show'];
$linkaksi .="&show=$_GET[show]";
}
$posisi = $p->cariPosisi($batas);
$query = "SELECT * FROM db_barang ";
$q = "SELECT * FROM db_barang";
if(!empty($_GET['field'])){
$hideinp = "<input type='hidden' name='field' value='$_GET[field]'>
<input type='hidden' name='cari' value='$_GET[cari]'>";
$linkaksi .= "&field=$_GET[field]&cari=$_GET[cari]";
$query .= " WHERE $_GET[field] LIKE '%$_GET[cari]%'";
$q .= " WHERE $_GET[field] LIKE '%$_GET[cari]%'";
}
$query .= " LIMIT $posisi, $batas";
$q .= " ";
$sql_kul = mysql_query($query);
$fd_kul = mysql_num_rows($sql_kul);
if($fd_kul > 0){
$no = $posisi + 1;
while ($m = mysql_fetch_assoc($sql_kul)){
echo"<tr>
<td>$no</td>
<td>$m[kode]</td>
<td>$m[nama]</br>UK. $m[p] x $m[l] x $m[t]</td>
<td><form action='$aksi'>
<input type='hidden' name='mod' value='penjualan'>
<input type='hidden' name='act' value='add'>
<input type='hidden' name='id' value='$m[kode]'>
<input type='hidden' name='jfaktur' value='$_GET[jfaktur]'>
<div class='w3-row'>
<div class='w3-col s6'><input type='text' name='btg' class='w3-select w3-border w3-hover-grey w3-right-align kanan' maxlength='8' placeholder='0' required></div>
<div class='w3-col s4'><button type='submit' class='w3-btn w3-red w3-tiny'><i class='fa fa-cart-plus'></i> ADD</button>
</div>
</div>
</form>
</td>
</tr>";
$no++;
}
$jmldata = mysql_num_rows(mysql_query($q));
$jmlhalaman = $p->jumlahHalaman($jmldata, $batas);
$linkHalaman = $p->navHalaman($_GET['halaman'], $jmlhalaman, $linkaksi);
}else{
echo"<tr>
<td colspan='4'><div class='w3-center'><i>Data Barang Not Found.</i></div></td>
</tr>";
}
echo"</tbody>
</table>
</div>
<div class='w3-row'>
<div class='w3-col s2'>
<form class='w3-tiny' action='' method='GET'>
<input type='hidden' name='mod' value='penjualan'>
<input type='hidden' name='jfaktur' value='$_GET[jfaktur]'>";
if(!empty($hideinp)){
echo $hideinp;
}
echo"<select class='w3-select w3-border' name='show' onchange='submit()'>
<option value=''>- Show -</option>
<option value='5'>5</option>";
$i=10;
while($i <= 100){
if(isset($_GET['show']) AND (int)$_GET['show'] == $i){
echo"<option value='$i' selected>$i</option>";
}else{
echo"<option value='$i'>$i</option>";
}
$i+=10;
}
echo"</select>
</form>
</div>
<div class='w3-col s10'>
<ul class='w3-pagination w3-right w3-tiny'>
$linkHalaman
</ul>
</div>
</div>
</div>";
$jp_temp = mysql_fetch_assoc(mysql_query("SELECT sum(ton) as ton
FROM db_detail_penjualan_tmp
WHERE jfaktur = '$_GET[jfaktur]' AND user = '$_SESSION[login_id]'
ORDER BY date ASC")) or die(mysql_error());
$n_ton = $jp_temp['ton'];
echo "
<div class='w3-col s7 w3-card'>Keranjang Penjualan
<div style='border-bottom:1px dashed #ccc;'></div>
<font color='red'><b>Nilai Tonase : ".number_format($n_ton,4,'.',',')."";
if($n_ton>=0.5){
echo " Masukan Harga Ton";
}elseif($n_ton<0.5){
echo " Masukan Harga Inchi";
}
echo "
</b></font>
<table class='w3-table w3-tiny w3-hoverable tbl'>
<tr class='w3-blue'>
<th width='5%'>#</th>
<th width='35%'>DESKRIPSI</th>
<th width='10%'>BTG</th>";
if($n_ton>=0.5){
echo "
<th width='10%'>TON</th>
<th width='20%'>HARGA</th>
<th width='18%'>T.HARGA</th>";
}elseif($n_ton<0.5){
echo "
<th width='10%'></th>
<th width='18%'>HARGA</th>
<th width='20%'>T.HARGA</th>";
}
echo "
<th width='2%'> </th>
</tr>
<tbody>";
$sql_tmp = mysql_query("SELECT a.kode_barang, a.qty, a.harga, b.nama, b.p, b.l, b.t, b.nilai, a.ton
FROM db_detail_penjualan_tmp a, db_barang b
WHERE a.kode_barang = b.kode AND a.jfaktur = '$_GET[jfaktur]' AND a.user = '$_SESSION[login_id]'
ORDER BY a.date ASC") or die(mysql_error());
$no = 1;
$t_qty = $t_ton = 0;
$jsql_temp = mysql_num_rows($sql_tmp);
if($jsql_temp > 0){
while($b = mysql_fetch_assoc($sql_tmp)) {
$t_ton = $t_ton + $b['ton'];
$t_qty = $t_qty + $b['qty'];
echo"<tr style='border-bottom:1px dashed #ccc;'>
<td>$no</td>
<td>$b[nama]</br>UK. $b[p] x $b[l] x $b[t]</td>
<td><input type='text' name='qty$no' id='qty$no' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($b['qty'])."' readonly></td>";
if($n_ton>=0.5){
echo "
<td><input type='text' name='ton$no' id='ton$no' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($b['ton'],4,'.',',')."' readonly><div align='right'></td>
<td><input type='text' name='harga$no' id='harga$no' class='w3-select w3-border w3-hover-grey w3-right-align kanan' value='0' onkeyup=penjualanB('ton$no','harga$no','tharga$no')></td>
<td><input type='text' name='tharga$no' id='tharga$no' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}elseif($n_ton<0.5){
echo "
<td></td>
<td><input type='text' name='harga$no' id='harga$no' class='w3-select w3-border w3-hover-grey w3-right-align kanan' value='0' onkeyup=penjualanA('qty$no','harga$no','tharga$no')></td>
<td><input type='text' name='tharga$no' id='tharga$no' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}
echo "
<td><div align='right'><a href='$aksi?mod=penjualan&act=batal&id=$b[kode_barang]' onclick=\"return confirm('Yakin ingin membatalkan?');\"><i class='fa fa-close w3-tiny w3-text-red'></i></a></div></td>
</tr>";
$no++;
}
}else{
echo"<tr>
<td colspan='4'><center><i>Keranjang Kosong</i></center></td>
</tr>";
}
echo"</tbody>
<tfoot><input type='text' name='nilai' id='nilai' value='".$jsql_temp."'>
<tr>
<td colspan='2'><b>TOTAL</b></td>
<td><input type='text' name='gqty' id='gqty' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($t_qty)."' readonly></td>";
if($n_ton>=0.5){
echo "
<td><input type='text' name='gton' id='gton' class='w3-select w3-border w3-light-grey w3-right-align' value='".number_format($t_ton,4,'.',',')."' readonly></td>
<td><input type='text' name='gharga' id='gharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>
<td><input type='text' name='gtharga' id='gtharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}elseif($n_ton<0.5){
echo "
<td></td>
<td><input type='text' name='gharga' id='gharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>
<td><input type='text' name='gtharga' id='gtharga' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>";
}
echo "
</tr>
<tr>
<td colspan='5'><b>POTONGAN HARGA (Rp.)<b></td>
<td><input type='text' name='potongan' id='potongan' class='w3-select w3-border w3-hover-grey w3-right-align' value='0'></td>
</tr>
<tr style='border-top:1px dashed #ccc;'>
<td colspan='4'><b class='w3-text-blue'>TOTAL BAYAR</b><td>
<td><input type='text' name='tot' id='tot' class='w3-select w3-border w3-light-grey w3-right-align' value='0' readonly></td>
</tr>
</tfoot>
</table><hr>
<div class='w3-card-2 w3-light-blue'>
<form action='$aksi?mod=penjualan&act=simpan' method='POST' class='w3-container'>
<input type='hidden' name='potongan2' id='potongan2' value='0'>
<input type='hidden' name='total' id='total' value='"?>0'>
<input type='hidden' name='jmlbayar2' id='bayar2'>
<label class='w3-label w3-text-black'>Nama Pelanggan :</label>
<input type='text' name='nama' id='nama' class='w3-input w3-tiny w3-border-0' required>
<label class='w3-label w3-text-black'>Bayar (Rp):</label>
<input type='text' name='jmlbayar' id='bayar' class='w3-input w3-tiny w3-border-0' required>
<label class='w3-label w3-text-black'>Status Pembayaran:</label>
<div class='w3-row'>
<div class='w3-col s6'>
<input type='radio' class='w3-radio' name='status' value='LUNAS' checked>
<label class='w3-validate'>LUNAS</label>
</div>
<div class='w3-col s6'>
<input type='radio' class='w3-radio' name='status' value='HUTANG'>
<label class='w3-validate'>HUTANG</label>
</div>
</div>
<p><button class='w3-btn w3-green' onclick="return confirm('Klik OK untuk melanjutkan');"><i class='fa fa-save'></i> Simpan Transaksi</button></p>
</form>
</div><br></div>
</div>
|
|