<td>Jatuh Tempo</td> <td width="10%">Aksi</td> </tr>'; $s = mysql_query( "SELECT * FROM `po_pembelian` where tgl >= '$tglmulai' and tgl <= '$tglakhir' $wherestatus order by tgltermin asc" ); while ($data = mysql_fetch_array($s)) { $noinvoice = $data['noinvoice']; $hutang = $data['hutang']; if($hutang>'0'){ $tombollunas = 'Hutang'; }else{ $tombollunas = 'Lunas'; } echo'<tr class="border"> <td>'.$data['noinvoice'].'</td> <td>'.tanggalindo($data['tgl']).'</td> <td>'.getnamasupplier($data['kodesupplier']).'</td> <td>'.rupiah_format($data['total']).'</td> <td>'.rupiah_format($data['bayar']).'</td> <td>'.rupiah_format($data['hutang']).'</td> <td>'.tanggalindo($data['tgltermin']).'</td> <td>'.$tombollunas.'</td> </tr>'; $ttotal += $data['total']; $tbayar += $data['bayar']; $thutang += $data['hutang']; } echo ' <tr class="border"> <td colspan="3">Grand Total</td> <td>'.rupiah_format($ttotal).'</td> <td>'.rupiah_format($tbayar).'</td>
<tr> <td>Nomor PO</td> <td>:</td> <td>'.$nopo.'</td> </tr>'; echo ' <tr> <td>Tanggal</td> <td>:</td> <td>'.tanggalindo($tgl).'</td> </tr>'; echo ' <tr> <td>Supplier</td> <td>:</td> <td>'.getnamasupplier($kodesupplier).'</td> </tr>'; echo '</table>'; echo '<b>Detail</b>'; echo ' <table>'; echo ' <tr> <th class="border"><b>No</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>
<td>:</td> <td><input type="text" id="tgl" name="tgl" value="' . $tgl . '" class="form-control"> </td> <td>Cara Pembayaran</td> <td>:</td> <td>' . $sel2 . '</td> </tr>'; $admin .= ' <tr> <td>Kode PO</td> <td>:</td> <td><select id="combobox" name="kodepo" class="form-control">'; $hasil = $koneksi_db->sql_query("SELECT * FROM pos_po order by id desc"); while ($data = $koneksi_db->sql_fetchrow($hasil)) { $pilihan = $data['nopo'] == $kodepo ? "selected" : ''; $admin .= ' <option value="' . $data['nopo'] . '" ' . $pilihan . '>' . $data['nopo'] . ' ~ ' . getnamasupplier($data['kodesupplier']) . ' ~ ' . rupiah_format($data['total']) . '</option>'; } $admin .= '</select> <input type="submit" value="Tambah INV" name="tambahpo"class="btn btn-success" > ' . $_SESSION['kodepo'] . '</td> <td>Termin</td> <td>:</td> <td><input type="text" name="termin" value="' . $termin . '" class="form-control"></td> </tr>'; $admin .= ' <tr><td colspan="5"><div id="Tbayar"></div></td> <td> </td> </tr> </table>'; $admin .= '</div>';