Kodenya adalah sbb:
<input type='text' value='0' name='jum$i' style='width: 50px;'>
atau
<input type="text" style="font-size:18pt;height:420px;width:200px;">ATAU LEBIH LENGKAP KESELURUHAN CODE ONE TO MANY nya sbb:
<?php
$pro="simpan";
$tanggal=WKT(date("Y-m-d"));
?>
<link type="text/css" href="<?php echo "$PATH/base/";?>ui.all.css" rel="stylesheet" />
<script type="text/javascript" src="<?php echo "$PATH/";?>jquery-1.3.2.js"></script>
<script type="text/javascript" src="<?php echo "$PATH/";?>ui/ui.core.js"></script>
<script type="text/javascript" src="<?php echo "$PATH/";?>ui/ui.datepicker.js"></script>
<script type="text/javascript" src="<?php echo "$PATH/";?>ui/i18n/ui.datepicker-id.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#tanggal").datepicker({
dateFormat : "dd MM yy",
changeMonth : true,
changeYear : true
});
});
</script>
<link rel="stylesheet" href="accordion/js_biasa/jquery-ui.css">
<link rel="stylesheet" href="resources/demos/style.css">
<script src="accordion/js_biasa/jquery-1.12.4.js"></script>
<script src="accordion/js_biasa/jquery-ui.js"></script>
<script>
$( function() {
$( "#accordion" ).accordion({
collapsible: true
});
} );
</script>
<script type="text/javascript">
function PRINT(tgl){
win=window.open('penjualan/print.php?tgl='+tgl,'win','width=1000, height=400, menubar=0, scrollbars=1, resizable=0, location=0, toolbar=0, status=0'); }
</script>
<script language="JavaScript">
function buka(url) {window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');}
</script>
<?php
$keterangan="";
$sql="select `id_penjualan` from `$tbpenjualan` order by `id_penjualan` desc";
$q=mysqli_query($conn, $sql);
$jum=mysqli_num_rows($q);
$th=date("y");
$bl=date("m")+0;if($bl<10){$bl="0".$bl;}
$kd="PJL".$th.$bl;//KEG1610001
if($jum > 0){
$d=mysqli_fetch_array($q);
$id_penjualanax=$d["id_penjualan"];
$bul=substr($id_penjualanax,5,2);
$tah=substr($id_penjualanax,3,2);
if($bul==$bl && $tah==$th){
$urut=substr($id_penjualanax,7,3)+1;
if($urut<10){$id_penjualanax="$kd"."00".$urut;}
else if($urut<100){$id_penjualanax="$kd"."0".$urut;}
else{$id_penjualanax="$kd".$urut;}
}//==
else{
$id_penjualanax="$kd"."001";
}
}//jum>0
else{$id_penjualanax="$kd"."001";}
$id_penjualan=$id_penjualanax;
?>
<div id="accordion">
<h3>Input Data Invoice</h3>
<div>
<!-- Accordion -->
<form action="" method="post" enctype="multipart/form-data">
<table class="table table-hover">
<tr>
<th width="66"><label for="id_penjualan">ID Masuk</label>
<th width="9">:
<th colspan="2">
<input name="id_penjualan" class="form-control" type="text" id="id_penjualan" value="<?php echo $id_penjualan;?>" size="15"/>
</tr>
<tr>
<td><label for="tanggal">Tanggal</label>
<td>:
<td colspan="2">
<input name="tanggal" class="form-control" type="text" id="tanggal" value="<?php echo $tanggal;?>" size="30" />
</td>
</tr>
<tr>
<td height="24"><label for="id_prosuk">Pilih Batik</label>
<td>:<td colspan="2" valign='top'>
<table class="table table-bordered table-striped table-hover">
<tr bgcolor="#CCCCCC">
<th width="3%">No</th>
<th width="30%">Nama</th>
<th width="20%">Kategori</th>
<th width="10%">Harga</th>
<th width="5%">Jumlah</th>
<th width="15%">Catatan</th>
<th width="5%">Pilih</th>
</tr>
<?php
$sql="select * from `$tbbarang` order by `id_barang` asc";
$jum=getJum($conn,$sql);
if($jum > 0){
$no=1;
$arr=getData($conn,$sql);
foreach($arr as $d) {
$i=$no-1;
$id_barang=$d["id_barang"];
$nama_barang=$d["nama_barang"];
$deskripsi=$d["deskripsi"];
$kategori=$d["kategori"];
$harga0=($d["harga"]);
$harga=RP($d["harga"]);
$gambar=$d["gambar"];
$status=$d["status"];
$color="#dddddd";
if($no %2==0){$color="#eeeeee";}
echo"<input type='hidden' value='$id_barang' name='idp$i'>";
echo"<tr bgcolor='$color'>
<td>$no</td>
<td>$nama_barang ($id_barang)</td>
<td>$kategori</td>
<td>$harga</td>
<td><input type='text' value='0' name='jum$i' style='width: 50px;'>
<input type='hidden' value='$harga0' name='hrg$i'>
</td>
<td><input type='text' value='' name='cat$i'></td>
<td align='center'>
<input type='checkbox' value='1' name='pil$i'>
</tr>";
$no++;
}//while
}//if
else{echo"<tr><td colspan='7'><blink>Maaf, Data produk belum tersedia...</blink></td></tr>";}
?>
</table>
</td>
</tr>
<tr>
<td height="24"><label for="keterangan">Keterangan</label>
<td>:<td width="331"><textarea class="form-control" name="keterangan" style='width: 700px;' cols="100" type="text" id="keterangan"><?php echo $keterangan;?> </textarea></td>
</tr>
<tr>
<td>
<td>
<td colspan="2">
<input name="Simpan" type="submit" class="btn btn-success" id="Simpan" value="Simpan" />
<input name="pro" type="hidden" id="pro" value="<?php echo $pro;?>" />
<input name="i" type="hidden" id="i" value="<?php echo $i;?>" />
<input name="id_penjualan0" type="hidden" id="id_penjualan0" value="<?php echo $id_penjualan0;?>" />
<a href="?mnu=penjualan"><input name="Batal" class="btn btn-danger" type="button" id="Batal" value="Batal" /></a>
</td></tr>
</table>
</form>
</div>
<?php
$sqlc="select distinct(tanggal) from `$tbpenjualan` order by `tanggal` asc";
$arrc=getData($conn,$sqlc);
foreach($arrc as $dc) {
$tanggal=$dc["tanggal"];
?>
<h3>Data Pemasukan Barang <?php echo WKT($tanggal);?></h3>
<div>
<br />
<!-- Accordion -->
Data Penjualan Barang <?php echo WKT($tanggal);?>:
<img src='ypathicon/print.png' title='PRINT' OnClick="PRINT('<?php echo $tanggal;?>')">
<br>
<table class="table table-bordered table-striped table-hover">
<tr bgcolor="#CCCCCC">
<th width="3%">No</th>
<th width="10%">ID_INVOICE</th>
<th width="70%">List Barang</th>
<th width="10%">Menu</th>
</tr>
<?php
$sql="select distinct(id_penjualan) from `$tbpenjualan` where tanggal='$tanggal' order by `id_penjualan` desc ";
$jum=getJum($conn,$sql);
if($jum > 0){
$no=1;
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_penjualan=$d["id_penjualan"];
$gab="<ol>";
$sqlg="select * from `$tbpenjualandetail` where `id_penjualan`='$id_penjualan'";
$arrg=getData($conn,$sqlg);
foreach($arrg as $dg) {
$id_barang=$dg["id_barang"];
$np=getBarang($conn,$id_barang);
$jumlah=$dg["jumlah"];
$catatan=$dg["catatan"];
$subtotal=RP($dg["subtotal"]);
$gab.="<li>$np ($id_barang) : $jumlah item Rp. $subtotal $catatan</li>";
}
$gab.="</ol>";
$color="#dddddd";
if($no %2==0){$color="#eeeeee";}
echo"<tr bgcolor='$color'>
<td>$no</td>
<td>$id_penjualan</td>
<td>$gab</td>
<td align='center'>
<a href='?mnu=penjualan&pro=hapus&kode=$id_penjualan'><img src='ypathicon/h.png' alt='hapus'
onClick='return confirm(\"Apakah Anda benar-benar akan menghapus $id_penjualan pada data penjualan ?..\")'></a></td>
</tr>";
$no++;
}//while
}//if
else{echo"<tr><td colspan='7'><blink>Maaf, Data penjualan belum tersedia...</blink></td></tr>";}
?>
</table>
</div>
<?php } ?>
</div>
</div>
</body>
<!-- Accordion -->
<?php
if(isset($_POST["Simpan"])){
$jum=strip_tags($_POST["i"]);
$id_penjualan=strip_tags($_POST["id_penjualan"]);
$tanggal=BAL($_POST["tanggal"]);
$keterangan=strip_tags($_POST["keterangan"]);
$sql="delete from `$tbpenjualan` where `id_penjualan`='$id_penjualan'";
$hapus=process($conn,$sql);
$sql="delete from `$tbpenjualandetail` where `id_penjualan`='$id_penjualan'";
$hapus=process($conn,$sql);
$ada=0;
for($i=0;$i<=$jum;$i++){
$id_barang=strip_tags($_POST["idp$i"]);
$jumlah=strip_tags($_POST["jum$i"]);
$harga=strip_tags($_POST["hrg$i"]);
$pil=strip_tags($_POST["pil$i"]);
$catatan=strip_tags($_POST["cat$i"]);
if($pil==1 && isset($_POST["pil$i"]) && $jumlah>0){
$subtotal=$harga * $jumlah;
$ada++;
$sql=" INSERT INTO `$tbpenjualandetail` (
`id` ,
`id_penjualan` ,
`id_barang` ,
`jumlah` ,
`subtotal` ,
`catatan`
) VALUES (
'',
'$id_penjualan',
'$id_barang',
'$jumlah',
'$subtotal',
'$catatan'
)";
$simpan=process($conn,$sql);
}//isset
}//for
if($ada>0){
$sql=" INSERT INTO `$tbpenjualan` (
`id_penjualan` ,
`tanggal` ,
`keterangan`
) VALUES (
'$id_penjualan',
'$tanggal',
'$keterangan'
)";
$simpan=process($conn,$sql);
if($simpan) {echo "<script>alert('Data $id_penjualan berhasil disimpan !');document.location.href='?mnu=penjualan';</script>";}
else{echo"<script>alert('Data $id_penjualan gagal disimpan...');document.location.href='?mnu=penjualan';</script>";}
}
else{
echo"<script>alert('Silakan Lengkapi Data Anda DenganItem yang dipilih berikut Jumlahnya...');document.location.href='?mnu=penjualan';</script>";
}
}
?>
<?php
if($_GET["pro"]=="hapus"){
$id_penjualan=$_GET["kode"];
$sql="delete from `$tbpenjualan` where `id_penjualan`='$id_penjualan'";
$hapus=process($conn,$sql);
$sql="delete from `$tbpenjualandetail` where `id_penjualan`='$id_penjualan'";
$hapus=process($conn,$sql);
if($hapus) {echo "<script>alert('Data penjualan $id_penjualan berhasil dihapus !');document.location.href='?mnu=penjualan';</script>";}
else{echo"<script>alert('Data penjualan $id_penjualan gagal dihapus...');document.location.href='?mnu=penjualan';</script>";}
}
?>
<textarea style="height:120px; color: #ffffff;background-color:#222222;"
name="pertanyaan" required class="form-control" id="pertanyaan"/><?php echo $pertanyaan;?></textarea></td>
Tidak ada komentar:
Posting Komentar