Home About Logout

Retur Kanvas

=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) and jns='2';"; } else { $query = "SELECT cabang,nobukti,darigd,kegd,tgl,kdslm,if(stat='0','Input','OK') as dstatus,stat from stokkanvasheader where cabang='$datasystem[cabang]' and tgl<=curdate() and tgl>=DATE_ADD(CURDATE(),INTERVAL -DAY(CURDATE())+1 DAY) and jns='2';"; } $sql0 = mysqli_query($con,$query); $satu=mysqli_num_rows($sql0); if ($satu >0 ){ $no = 1; // Untuk penomoran tabel, di awal set dengan 1 while($data = mysqli_fetch_array($sql0)){ $custno=$data['nobukti']; if ($data['nobukti'] <>'') { // $nilait=$nilait+$data['jumlah']; if ($data['stat']=='2') { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } elseif ($data['stat']=='3'){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } elseif ($data['stat']=='0') { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } elseif ($data['stat']=='1') { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } elseif ($data['stat']=='4') { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } $no++; // Tambah 1 setiap kali looping } } } else { echo""; } ?>
No Nobukti Tanggal Sales D.Gd K.Gd Status Aksi
".$no."".$data['nobukti']."".$data['kdslm']."".$data['custname']."".number_format($data['netto'])."SPV Detail
".$no."".$data['nobukti']."".$data['kdslm']."".$data['custname']."".number_format($data['netto'])."SM Detail
".$no."".$data['nobukti']."".$data['tgl']."".$data['kdslm']."".$data['darigd']."".$data['kegd']."Input Detail
".$no."".$data['nobukti']."".$data['tgl']."".$data['kdslm']."".$data['darigd']."".$data['kegd']."OK Detail
".$no."".$data['nobukti']."".$data['kdslm']."".$data['custname']."".number_format($data['netto'])."DIR Detail
Data Sales order Not Found.
NEW Kembali Kembali