<td>Nama Barang</td> <td>Stok Awal</td> <td>Stok Akhir</td> </tr>'; $no =1; /****************************/ $st2 = mysql_query ("SELECT * FROM pos_alur_stok where transaksi like'Stok Awal'"); while($datast2 = mysql_fetch_array($st2)){ $idsa = $datast2['id']; $tglsa = $datast2['tgl']; $transaksi = $datast2['transaksi']; $kodebarangsa = $datast2['kodebarang']; $jumlahsa = $datast2['jumlah']; $getnamabarangsa = getnamabarang($kodebarangsa); $getjenisbarang = getjenisbarang($kodebarangsa); $getidjenisbarang=getidjenisbarang($kodebarangsa); $getstokbarang=getstokbarang($kodebarangsa); if($kodejenis!=''){ if($getidjenisbarang==$kodejenis){ echo ' <tr class="border"> <td class="text-center">'.$no.'</td> <td>'.tanggalindo($datast2['tgl']).'</td> <td>'.$datast2['transaksi'].'</td> <td>'.$datast2['kode'].'</td> <td>'.$kodebarangsa.'</td> <td>'.$getnamabarangsa.'</td> <td>'.$datast2['jumlah'].'</td> <td>'.$getstokbarang.'</td> </tr>';
$no++; $grandjumlah+=$jumlah; $grandsubdiscount+=$subdiscount; $grandtotal+=$subtotal; $grandrugilaba+=$rugilaba; $grandsubtotalbayar+=$subtotalbayar; }else if($jenisproduk=='Semua'){ echo ' <tr class="border"> <td class="text-center">'.$no.'</td> <td>'.$lihatslip.'</td> <td>'.tanggalindo($tgl).'</td> <td>'.getnamacustomer($kodecustomer).'</td> <td>'.$carabayar.'</td> <td>'.getjenisbarang($kodebarang).'</td> <td>'.getjenjangbarang($kodebarang).'</td> <td>'.$kodebarang.'</td> <td>'.getnamabarang($kodebarang).'</td> <td>'.rupiah_format($hargabeli).'</td> <td>'.rupiah_format($harga).'</td> <td>'.$jumlah.'</td> <td>'.cekdiscountpersen($subdiscount).'</td> <td>'.rupiah_format($subtotal).'</td> <td>'.rupiah_format($subtotalbayar).'</td> <td>'.rupiah_format($rugilaba).'</td> <td>'.$user.'</td> </tr>'; $no++; $grandjumlah+=$jumlah; $grandsubdiscount+=$subdiscount;
<th class="border"><b>No</b></</th> <th class="border"><b>Jenis</b></</th> <th class="border"><b>Jenjang</b></</th> <th class="border"><b>Kode</b></</th> <th class="border"><b>Nama</b></td> <th class="border"><b>Jumlah</b></</td> <th class="border"><b>Harga</b></</th> <th class="border"><b>Discount</b></</th> <th class="border"><b>Subtotal</b></</th> </tr>'; $hasild = $koneksi_db->sql_query("SELECT * FROM `pos_pembeliandetail` WHERE `noinvoice` like '$kode'"); while ($datad = $koneksi_db->sql_fetchrow ($hasild)){ echo ' <tr> <td class="border">'.$no.'</td> <td class="border">'.getjenisbarang($datad["kodebarang"]).'</td> <td class="border">'.getjenjangbarang($datad["kodebarang"]).'</td> <td class="border">'.$datad["kodebarang"].'</td> <td class="border">'.getnamabarang($datad["kodebarang"]).'</td> <td class="border">'.$datad["jumlah"].'</td> <td class="border">'.rupiah_format($datad["harga"]).'</td> <td class="border">'.cekdiscountpersen($datad["subdiscount"]).'</td> <td class="border">'.rupiah_format($datad["subtotal"]).'</td> </tr>'; $no++; } /* echo ' <tr class="border"> <td colspan="7" align="right"><b>Discount</b></td> <td >'.cekdiscountpersen($discount).'</td>