$noretur = str_replace("_", " ", $_GET['noretur']); $petugas = str_replace("_", " ", $_GET['petugas']); $tanggal = $_GET['tanggal']; $nm_member = str_replace("_", " ", $_GET['nm_member']); $catatan = str_replace("_", " ", $_GET['catatan']); $_sql = "select nama_brng,h_retur, jml_retur, subtotal from tampreturjual "; $hasil = bukaquery($_sql); $_sqlins = "SELECT nama_instansi, alamat_instansi, kabupaten, propinsi from setting"; $hasilins = bukaquery($_sqlins); $barisins = mysql_fetch_array($hasilins); $_sqlset = "SELECT * from setnota"; $hasilset = bukaquery($_sqlset); $barisset = mysql_fetch_array($hasilset); if (mysql_num_rows($hasil) != 0) { echo "<table width='{$barisset['0']}' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi14'>\r\n <td width=50% colspan=4 align=left>\r\n <font color='000000' size='4' face='Tahoma'> </font><br/>\r\n <font color='000000' size='2' face='Tahoma'>\r\n <br/>\r\n </font>\r\n </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan='5' align='center'>\r\n <font color='000000' size='3' face='Tahoma'>TANDA TERIMA RETUR</font>\r\n </td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td colspan='3' align='center'>\r\n <font color='000000' size='2' face='Tahoma'> </font>\r\n </td>\r\n </tr> \r\n <tr>\r\n <td colspan='6'>\r\n <table width=100%>\r\n <tr class='isi14'>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'>No.Retur</font>\r\n </td>\r\n <td width='40%'>: {$noretur}</td>\r\n <td width='40%' colspan=2>{$barisins['2']}, " . substr($tanggal, 8, 2) . "-" . substr($tanggal, 5, 2) . "-" . substr($tanggal, 0, 4) . "</td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'>Sales</font>\r\n </td>\r\n <td width='40%'>: {$petugas}</td>\r\n <td width='40%' colspan=2>{$nm_member}</td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n <tr class='isi13'>\r\n <td colspan=4> </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=4 height='310px' valign=top>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class=isi15>\r\n <td width='5%' align=center>No</td>\r\n <td width='60%' align=center>Barang</td>\r\n <td width='10%' align=center>Harga</td>\r\n <td width='5%' align=center>Jml</td>\r\n <td width='10%' align=center>Total</td>\r\n </tr>"; $ttlpesan = 0; $i = 1; while ($barispesan = mysql_fetch_array($hasil)) { $ttlpesan = $ttlpesan + $barispesan[3]; echo "\r\n <tr class='isi15'>\r\n <td>{$i}</td>\r\n <td>{$barispesan['0']}</td>\r\n <td align=right>" . formatDuit2($barispesan[1]) . "</td>\r\n <td align=right>" . formatDuit2($barispesan[2]) . "</td>\r\n <td align=right>" . formatDuit2($barispesan[3]) . "</td>\r\n </tr>"; $i++; } echo " <tr class='isi14'>\r\n <td colspan=4 align=right><b>Total Retur</b></td>\r\n <td align='right'><b>" . formatDuit2($ttlpesan) . "</b></td>\r\n </tr> \r\n </table>\r\n <br/>\r\n </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=1 width='30%'>\r\n <table width='100%' cellpadding='0' cellspacing='0'>\r\n <tr class='isi15'>\r\n <td width='33%'>Sales </td><td width='33%'>Checking</td><td width='33%'>Gudang</td>\r\n </tr>\r\n <tr class='isi15'>\r\n <td height='40px'> </td><td> </td><td> </td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td colspan=3 width='70%'>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class='isi14'>\r\n <td width='80%'>Catatan</td><td align=center>Penerima</td>\r\n </tr>\r\n <tr class='isi14' valign=bottom>\r\n <td height='40px'>{$catatan}</td><td align=center>( {$petugas} )</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>"; } else { echo "<b>Data pesan masih kosong !</b>"; } ?> </body> </html>
$tgl_jual = $barisdata["tgl_jual"]; $kode_krywn = $barisdata["kode_krywn"]; $nama_krywn = $barisdata["nama_krywn"]; $ongkir = $barisdata["ongkir"]; $nama_member = $barisdata["nama_member"]; $catatan = $barisdata["keterangan"]; $hasil2 = bukaquery($_sql); $_sqlins = "SELECT nama_instansi, alamat_instansi, kabupaten, propinsi from setting"; $hasilins = bukaquery($_sqlins); $barisins = mysql_fetch_array($hasilins); $_sqlset = "SELECT * from setnota"; $hasilset = bukaquery($_sqlset); $barisset = mysql_fetch_array($hasilset); if (mysql_num_rows($hasil) != 0) { echo "<table width='{$barisset['1']}' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi14'>\r\n <td width=50% colspan=4 align=left>\r\n <font color='000000' size='4' face='Tahoma'> </font><br/>\r\n <font color='000000' size='2' face='Tahoma'>\r\n <br/>\r\n </font>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td colspan='6'>\r\n <table width=100%>\r\n <tr class='isi14'>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'>Faktur No</font>\r\n </td>\r\n <td width='30%'>: {$nota_jual}</td>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'></font>\r\n </td>\r\n <td width='30%'>{$barisins['2']}, " . substr($tgl_jual, 8, 2) . "-" . substr($tgl_jual, 5, 2) . "-" . substr($tgl_jual, 0, 4) . "</td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'>Sales</font>\r\n </td>\r\n <td width='30%'>: {$nama_krywn}</td>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'></font>\r\n </td>\r\n <td width='30%'>{$nama_member}</td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=4> </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=4 height='310px' valign=top>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class=isi15>\r\n <td width='5%' align=center>No</td>\r\n <td width='60%' align=center>Barang</td>\r\n <td width='10%' align=center>Harga</td>\r\n <td width='5%' align=center>Jml</td>\r\n <td width='10%' align=center>Diskon</td>\r\n <td width='110px' align=center>Total</td>\r\n </tr>"; $ttlpesan = 0; $i = 1; while ($barisdata = mysql_fetch_array($hasil2)) { $ttlpesan = $ttlpesan + $barisdata["total"]; echo "\r\n <tr class='isi15'>\r\n <td>{$i}</td>\r\n <td>" . $barisdata["nama_brng"] . "</td>\r\n <td align=right>" . formatDuit2($barisdata["h_jual"]) . "</td>\r\n <td align=right>" . formatDuit2($barisdata["jumlah"]) . "</td>\r\n <td align=right>" . formatDuit2($barisdata["bsr_dis"]) . "</td>\r\n <td align=right>" . formatDuit2($barisdata["total"]) . "</td>\r\n </tr>"; $i++; } echo " <tr class='isi14'>\r\n <td colspan=4></td>\r\n <td>Ttl.Beli</td>\r\n <td align='right'>" . formatDuit2($ttlpesan) . "</td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td colspan=4></td>\r\n <td>Ongkir</td>\r\n <td align='right'>" . formatDuit2($ongkir) . "<br/><hr/></td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td colspan=4></td>\r\n <td>Total</td>\r\n <td align='right'>" . formatDuit2($ongkir + $ttlpesan) . "</td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=1 width='30%'>\r\n <table width='100%' cellpadding='0' cellspacing='0'>\r\n <tr class='isi15'>\r\n <td width='33%'>Sales </td><td width='33%'>Checking</td><td width='33%'>Gudang</td>\r\n </tr>\r\n <tr class='isi15'>\r\n <td height='40px'> </td><td> </td><td> </td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td colspan=3 width='70%'>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class='isi14'>\r\n <td width='80%'>Catatan</td><td align=center>Penerima</td>\r\n </tr>\r\n <tr class='isi14' valign=bottom>\r\n <td height='40px'>{$catatan}</td><td align=center>(_______________)</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>"; } else { echo "<b>Data pesan masih kosong !</b>"; } ?> </body> </html>
</isi> <body> <?php reportsqlinjection(); $nonota = str_replace("_", " ", $_GET['nonota']); $tanggal = $_GET['tanggal']; $catatan = str_replace("_", " ", $_GET['catatan']); $petugas = str_replace("_", " ", $_GET['petugas']); $norm = str_replace("_", " ", $_GET['norm']); $pasien = str_replace("_", " ", $_GET['pasien']); $_sql = "SELECT no,temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8, temp9 from temporary order by no asc"; $hasil = bukaquery($_sql); if (mysql_num_rows($hasil) != 0) { echo "<table width='100%' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi14'>\r\n <td width=50% colspan=4 align=left>\r\n <table width='100%' bgcolor='#ffffff' padding='0' align='left' border='0' class='tbl_form'>\r\n\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t<td padding='0'>\r\n\t\t\t\t\t\t\t\t\t\t<img width='50' height='50' src='images/LOGO.png'/>\r\n\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\t\t<center>\r\n\t\t\t\t\t\t\t\t\t\t\t<font color='000000' size='2' face='Cambria'>RUMAH SAKIT AMAL SEHAT WONOGIRI</font> <br/>\r\n\t\t\t\t\t\t\t\t\t\t\t<font color='000000' size='2' face='Cambria'>\r\n\t\t\t\t\t\t\t\t\t\t\tJl.Ngerjopuro-Slogohimo, Slogohimo, Wonogiri 57694<br/>\r\n\t\t\t\t\t\t\t\t\t\t\tTelp. : 0273-5316677, 5316688, SMS AMAL SEHAT : 08132952199<br/>\r\n\t\t\t\t\t\t\t\t\t\t\tEmail : amal_sehat@telkom.net\r\n\t\t\t\t\t\t\t\t\t\t\t</font> \r\n\t\t\t\t\t\t\t\t\t</center>\r\n\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t </table>\r\n </td>\r\n </tr>\r\n <tr>\r\n\t\t\t\t\t <td colspan='6'><hr/>\r\n\t\t\t\t\t\t <table width=100%>\r\n\t\t\t\t\t\t\t <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>No.RM</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$norm}</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>No.Nota</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$nonota}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Nama Pasien</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$pasien}</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Tanggal</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$tanggal}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Alamat Pasien</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: " . getOne("select alamat from pasien where no_rkm_medis='{$norm}'") . "</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Petugas</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$petugas}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n \r\n <tr class='isi14'>\r\n\t\t\t\t\t\t\t\t<td width='25%'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>Catatan</font>\r\n\t\t\t\t\t\t\t\t</td>\r\n <td width='25%' colspan='3'>\r\n\t\t\t\t\t\t\t\t <font color='000000' size='2' face='Cambria'>: {$catatan}</font>\r\n\t\t\t\t\t\t\t\t</td> \r\n\t\t\t\t\t\t\t </tr> \r\n\t\t\t\t\t\t </table>\r\n\t\t\t\t\t </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=4 height='100%' valign=top>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class=isi15>\r\n <td width='5%' align=center><font color='000000' size='2' face='Cambria'>No</font></td>\r\n <td width='20%' align=center><font color='000000' size='2' face='Cambria'>Jml</font></td>\r\n <td width='55%' align=center><font color='000000' size='2' face='Cambria'>Nama Barang</font></td>\r\n <td width='20%' align=center><font color='000000' size='2' face='Cambria'>Total</font></td>\r\n </tr>"; $ttlpesan = 0; $i = 1; while ($barispesan = mysql_fetch_array($hasil)) { $ttlpesan = $ttlpesan + $barispesan[9]; echo "\r\n <tr class='isi15'>\r\n <td><font color='000000' size='2' face='Cambria'>{$i}</font></td>\r\n <td><font color='000000' size='2' face='Cambria'>{$barispesan['1']} {$barispesan['5']}</font></td>\r\n <td><font color='000000' size='2' face='Cambria'>{$barispesan['3']} </font></td>\r\n <td align=right><font color='000000' size='2' face='Cambria'>" . formatDuit2($barispesan[9]) . "</font></td>\r\n </tr>"; $i++; } echo " <tr class='isi14'>\r\n <td colspan=2></td>\r\n <td align='right'><font color='000000' size='2' face='Cambria'>Jumlah</font></td>\r\n <td align='right'><font color='000000' size='2' face='Cambria'>" . formatDuit2($ttlpesan) . "</font></td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>"; } else { echo "<b>Data pesan masih kosong !</b>"; } ?> </body> </html>
include 'conf/conf.php'; ?> <html> <isi> <link href="css/default.css" rel="stylesheet" type="text/css" /> </isi> <body> <?php reportsqlinjection(); $tgl1 = $_GET['tgl1']; $tgl2 = $_GET['tgl2']; $_sql = "select rawat_jl_dr.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien \r\n from rawat_jl_dr inner join reg_periksa inner join pasien\r\n on rawat_jl_dr.no_rawat=reg_periksa.no_rawat\r\n and reg_periksa.no_rkm_medis=pasien.no_rkm_medis\r\n where tgl_registrasi between '{$tgl1}' and '{$tgl2}'\r\n group by reg_periksa.no_rawat "; $hasil = bukaquery($_sql); if (mysql_num_rows($hasil) != 0) { echo "<table width='100%' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi13'>\r\n <td>\r\n <table width='100%' bgcolor='#ffffff' align='left' border='0' class='tbl_form' border=1>\r\n <tr>\r\n <td>\r\n <img width='80' height='70' src='images/LOGO.png'/>\r\n </td>\r\n <td>\r\n <center>\r\n <font color='333333' size='2' face='Tahoma'>RUMAH SAKIT AMAL SEHAT WONOGIRI</font><br/>\r\n <font color='333333' size='1' face='Tahoma'>\r\n Jl.Ngerjopuro-Slogohimo, Slogohimo, Wonogiri 57694<br/>\r\n Telp. : 0273-5316677, 5316688, SMS AMAL SEHAT : 08132952199<br/>\r\n Email : amal_sehat@telkom.net\r\n </font> \r\n </center>\r\n </td>\r\n <td>\r\n <center>\r\n <font color='333333' size='3' face='Tahoma'>DAFTAR BIAYA RAWAT JALAN</font>\r\n </center>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td height='310px' valign=top>\r\n <br/>\r\n <table width=100% cellpadding='0' cellspacing='0' >\r\n <tr class=isi15>\r\n <td width='2%' align=center rowspan='2'>No</td>\r\n <td width='20%' align=center colspan='2'>PASIEN</td>\r\n <td width='58%' align=center colspan='6'>BIAYA PENGOBATAN</td>\r\n <td width='10%' align=center rowspan='2'>DOKTER</td>\r\n <td width='10%' align=center rowspan='2'>KETERANGAN</td>\r\n </tr>\r\n <tr class=isi15>\r\n <td align=center>NO.RM</td>\r\n <td align=center>NAMA PASIEN</td>\r\n <td align=center>ADMINISTRASI</td>\r\n <td align=center>JASA MEDIS</td>\r\n <td align=center>OBAT</td>\r\n <td align=center>TINDAKAN</td>\r\n <td align=center>OKSIGEN</td>\r\n <td align=center>TOTAL</td>\r\n </tr>\r\n "; $i = 1; while ($barispesan = mysql_fetch_array($hasil)) { echo "<tr class=isi15>\r\n <td>{$i}</td>\r\n <td>" . $barispesan["no_rkm_medis"] . "</td>\r\n <td>" . $barispesan["nm_pasien"] . "</td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where status='Registrasi'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(jns_perawatan.total_byrdr) from jns_perawatan inner join rawat_inap_dr\r\n on rawat_inap_dr.kd_jenis_prw=jns_perawatan.kd_jenis_prw where\r\n no_rawat='" . $barispesan["no_rawat"] . "'")) . "\r\n </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where status='Obat'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where status='Ralan Dokter'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat") + getOne("select sum(billing.totalbiaya) from billing where status='Ralan Paramedis'\r\n and no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td> </td>\r\n <td align='right'> " . formatDuit2(getOne("select sum(billing.totalbiaya) from billing where no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat")) . "\r\n </td>\r\n <td align='left'> " . getOne("select nm_perawatan from billing where no_rawat='" . $barispesan["no_rawat"] . "' and status='Dokter' ") . "\r\n </td>\r\n <td> " . getOne("select if(sum(billing.totalbiaya)>0,'Lunas','Belum Lunas') from billing where no_rawat='" . $barispesan["no_rawat"] . "' group by billing.no_rawat") . "</td>\r\n <tr>"; $i++; } echo " \r\n </table>\r\n </td>\r\n </tr> \r\n\r\n </table>"; } else { echo "<b>Data pesan masih kosong !</b>"; } ?> </body> </html>
reportsqlinjection(); $noretur = str_replace("_", " ", $_GET['noretur']); $gudang1 = str_replace("_", " ", $_GET['gudang1']); $tanggal = $_GET['tanggal']; $gudang2 = str_replace("_", " ", $_GET['gudang2']); $_sql = "select mutasibarang.kode_brng,databarang.nama_brng,databarang.h_beli,mutasibarang.jml, \r\n mutasibarang.keterangan from mutasibarang inner join databarang \r\n on mutasibarang.kode_brng=databarang.kode_brng \r\n where (select nama_gudang from datagudang where kode_gudang=kode_gudangdari)='{$gudang1}' and\r\n (select nama_gudang from datagudang where kode_gudang=kode_gudangke)='{$gudang2}' and\r\n mutasibarang.tanggal='{$tanggal}'"; $hasil = bukaquery($_sql); $_sqlins = "SELECT nama_instansi, alamat_instansi, kabupaten, propinsi from setting"; $hasilins = bukaquery($_sqlins); $barisins = mysql_fetch_array($hasilins); $_sqlset = "SELECT * from setnota"; $hasilset = bukaquery($_sqlset); $barisset = mysql_fetch_array($hasilset); if (mysql_num_rows($hasil) != 0) { echo "<table width='{$barisset['1']}' border='0' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='isi14'>\r\n <td width=50% colspan=5 align=left>\r\n <font color='000000' size='4' face='Tahoma'>{$barisins['0']}</font><br/>\r\n <font color='000000' size='2' face='Tahoma'>\r\n {$barisins['1']}, {$barisins['2']}, {$barisins['3']}<br/>\r\n </font>\r\n </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan='5' align='center'>\r\n <font color='000000' size='3' face='Tahoma'>SURAT JALAN</font>\r\n </td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td colspan='5' align='center'>\r\n <font color='000000' size='2' face='Tahoma'> </font>\r\n </td>\r\n </tr> \r\n <tr>\r\n <td colspan='6'>\r\n <table width=100%>\r\n <tr class='isi14'>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'>Dari Gudang </font>\r\n </td>\r\n <td width='30%'>: {$gudang1}</td>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'></font>\r\n </td>\r\n <td width='30%'>{$barisins['2']}, " . substr($tanggal, 8, 2) . "-" . substr($tanggal, 5, 2) . "-" . substr($tanggal, 0, 4) . "</td>\r\n </tr> \r\n <tr class='isi14'>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'>Ke Gudang</font>\r\n </td>\r\n <td width='30%'>: {$gudang2}</td>\r\n <td width='20%'>\r\n <font color='000000' size='2' face='Tahoma'></font>\r\n </td>\r\n <td width='30%'></td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n <tr class='isi13'>\r\n <td colspan=4> </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=4 height='310px' valign=top>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class=isi15>\r\n <td width='5%' align=center>No</td>\r\n <td width='5%' align=center>Kode Barang</td>\r\n <td width='60%' align=center>Nama Barang</td>\r\n <td width='10%' align=center>Harga</td>\r\n <td width='5%' align=center>Jml</td>\r\n <td width='10%' align=center>Total</td>\r\n <td width='10%' align=center>Keterangan</td>\r\n </tr>"; $ttlpesan = 0; $i = 1; while ($barispesan = mysql_fetch_array($hasil)) { $ttlpesan = $ttlpesan + $barispesan[3] * $barispesan[2]; echo "\r\n <tr class='isi15'>\r\n <td>{$i}</td>\r\n <td>{$barispesan['0']}</td>\r\n <td>{$barispesan['1']}</td>\r\n <td align=right>" . formatDuit2($barispesan[2]) . "</td>\r\n <td align=right>" . formatDuit2($barispesan[3]) . "</td>\r\n <td align=right>" . formatDuit2($barispesan[2] * $barispesan[3]) . "</td>\r\n <td>{$barispesan['1']}</td>\r\n </tr>"; $i++; } echo " <tr class='isi14'>\r\n <td colspan=5 align=right><b>Total</b></td>\r\n <td align='right'><b>" . formatDuit2($ttlpesan) . "</b></td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n <tr class='isi14'>\r\n <td colspan=1 width='30%'>\r\n <table width='100%' cellpadding='0' cellspacing='0'>\r\n <tr class='isi15'>\r\n <td width='33%'>Ptg.Pengirim</td><td width='33%'>Checking</td><td width='33%'>Ptg.Penerima</td>\r\n </tr>\r\n <tr class='isi15'>\r\n <td height='40px'> </td><td> </td><td> </td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td colspan=3 width='70%'>\r\n <table width=100% cellpadding='0' cellspacing='0'>\r\n <tr class='isi14'>\r\n <td width='80%'>Catatan</td><td align=center>Penerima</td>\r\n </tr>\r\n <tr class='isi14' valign=bottom>\r\n <td height='40px'>{$catatan}</td><td align=center>(_______________)</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>"; } else { echo "<b>Data pesan masih kosong !</b>"; } ?> </body> </html>