<th class="border"><b>Jenis</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_penjualanjasadetail` WHERE `nofaktur` like '$kode'"); while ($datad = $koneksi_db->sql_fetchrow ($hasild)){ echo ' <tr> <td class="border">'.$no.'</td> <td class="border">'.getjenis($datad["jenis"]).'</td> <td class="border">'.$datad["kodejasa"].'</td> <td class="border">'.getnamajasa($datad["kodejasa"]).'</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>Total</b></td> <td >'.rupiah_format($total).'</td> </tr>'; /* echo ' <tr class="border">
$grandjumlah+=$jumlah; $grandsubdiscount+=$subdiscount; $grandtotal+=$subtotal; }else if($jenisproduk=='Semua'){ echo ' <tr class="border"> <td class="text-center">'.$no.'</td> <td>'.$nofaktur.'</td> <td>'.tanggalindo($tgl).'</td> <td>'.getnamacustomer($kodecustomer).'</td> <td>'.$carabayar.'</td> <td>'.getjenisdarijasa($kodejasa).'</td> <td>'.getjenjangjasa($kodejasa).'</td> <td>'.$kodejasa.'</td> <td>'.getnamajasa($kodejasa).'</td> <td>'.rupiah_format($harga).'</td> <td>'.$jumlah.'</td> <td>'.cekdiscountpersen($subdiscount).'</td> <td>'.rupiah_format($subtotal).'</td> <td>'.$user.'</td> </tr>'; $no++; $grandjumlah+=$jumlah; $grandsubdiscount+=$subdiscount; $grandtotal+=$subtotal; } } } echo '
<th><b>No</b></</th> <th><b>Jenis</b></</th> <th><b>Kode</b></</th> <th><b>Nama</b></td> <th><b>Harga</b></</th> <th><b>Discount</b></</th> <th><b>Subtotal</b></</th> </tr>'; $hasild = $koneksi_db->sql_query("SELECT * FROM `pos_penjualanjasadetail` WHERE `nofaktur` like '{$kodefaktur}'"); while ($datad = $koneksi_db->sql_fetchrow($hasild)) { $admin .= ' <tr> <td>' . $no . '</td> <td>' . getjenis($datad["jenis"]) . '</td> <td>' . $datad["kodejasa"] . '</td> <td>' . getnamajasa($datad["kodejasa"]) . '</td> <td>' . rupiah_format($datad["harga"]) . '</td> <td>' . cekdiscountpersen($datad["subdiscount"]) . '</td> <td>' . rupiah_format($datad["subtotal"]) . '</td> </tr>'; $no++; } $admin .= ' <tr> <td colspan="6" align="right"><b>Total</b></td> <td >' . rupiah_format($total) . '</td> </tr>'; $admin .= ' <tr> <td colspan="6" align="right"><b>Bayar</b></td> <td >' . rupiah_format($bayar) . '</td> </tr>