// Sub SQL menghitung total harga, dan total barang yang dipesan
$my2Sql = "SELECT SUM(harga * jumlah) As total_harga,\n\t\t\t\t\tSUM(jumlah) As total_barang \n\t\t\t\t\tFROM pemesanan_item WHERE no_pemesanan='{$Kode}'";
$my2Qry = mysql_query($my2Sql, $koneksidb) or die("Gagal query" . mysql_error());
$my2Data = mysql_fetch_array($my2Qry);
// Menghitung Total Bayar dari harga setelah diskon, dikali jumlah barang
$totalBiayaKirim = $myData['biaya_kirim'] * $my2Data['total_barang'];
$totalBayar = $my2Data['total_harga'] + $totalBiayaKirim;
$unikTransfer = substr($totalBayar, 0, -3) . $digitHp;
?>
<tr>
<td><?php
echo $nomor;
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_pemesanan']);
?>
</td>
<td><?php
echo $myData['kd_pelanggan'];
?>
</td>
<td><?php
echo $myData['nm_pelanggan'];
?>
</td>
<td><?php
echo $my2Data['total_barang'];
?>
</td>
<td><?php
$myQry = mysql_query($mySql, $koneksidb) or die("Query salah : " . mysql_error());
$nomor = $hal;
while ($myData = mysql_fetch_array($myQry)) {
$nomor++;
?>
<tr>
<td><?php
echo $nomor;
?>
</td>
<td><?php
echo $myData['no_rawat'];
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_rawat']);
?>
</td>
<td><?php
echo $myData['nomor_rm'];
?>
</td>
<td><?php
echo $myData['nm_pasien'];
?>
</td>
<td align="right"><?php
echo format_angka($myData['uang_bayar']);
?>
</td>
<td><?php
</tr>
<tr>
<td colspan="5" align="right"><span class="table-list"><strong>Jumlah Uang Tunggakan (Rp) : </strong></span></td>
<td align="right" bgcolor="#999999"><span class="table-list"><b><?php
echo format_angka($totalBiaya);
?>
</b></span></td>
</tr>
<tr>
<td colspan="5" align="right"> </td>
<td align="right"> </td>
</tr>
<tr>
<td colspan="5" align="right"> </td>
<td align="left"><span class="table-list">Sumedang, <?php
echo IndonesiaTgl($kolomData['tgl_bayar']);
?>
</span></td>
</tr>
<tr>
<td colspan="5" align="right"> </td>
<td align="center"><span class="table-list">Yang Menerima,</span></td>
</tr>
<tr>
<td colspan="5" align="right"> </td>
<td align="center"><span class="table-list">TTD</span></td>
</tr>
<tr>
<td colspan="5" align="right"> </td>
<td align="center"><span class="table-list"><?php
echo $kolomData['nm_petugas'];
$jumData = mysql_num_rows($myQry);
$nomor = 0;
while ($myData = mysql_fetch_array($myQry)) {
$nomor++;
$subTotalJual = $myData['biaya'] - $myData['uang_bayar'];
$grandTotalJual = $grandTotalJual + $subTotalJual;
$jumlahbarang = $jumlahbarang + $myData['biaya'];
?>
<tr>
<td align="center"><?php
echo $nomor;
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_bayar']);
?>
</td>
<td><?php
echo $myData['kd_pembayaran'];
?>
</td>
<td><?php
echo $myData['jns_bayar'];
?>
</td>
<td align="left"><?php
echo $myData['no_induk'];
?>
</td>
<td align="right"><?php
</tr>
<?php
$mySql = "SELECT * FROM penjualan ORDER BY no_penjualan DESC LIMIT {$halaman}, {$baris}";
$myQry = mysql_query($mySql, $koneksidb) or die("Query salah : " . mysql_error());
$nomor = 0;
while ($myData = mysql_fetch_array($myQry)) {
$nomor++;
$Kode = $myData['no_penjualan'];
?>
<tr>
<td><?php
echo $nomor;
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_penjualan']);
?>
</td>
<td><?php
echo $myData['no_penjualan'];
?>
</td>
<td><?php
echo $myData['pelanggan'];
?>
</td>
<td><?php
echo $myData['keterangan'];
?>
</td>
<td width="45" align="center"><a href="penjualan_nota.php?noNota=<?php
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_daftar']);
?>
</td>
<td><?php
echo $myData['nomor_rm'];
?>
</td>
<td><?php
echo $myData['nm_pasien'];
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_janji']);
?>
</td>
<td><?php
echo $myData['jam_janji'];
?>
</td>
<td><?php
echo $myData['nm_tindakan'];
?>
</td>
<td align="center"><?php
echo $myData['nomor_antri'];
?>
</td>
</tr>
?>
</td>
<td><?php
echo $myData['nm_dokter'];
?>
</td>
<td><?php
echo $myData['spesialisasi'];
?>
</td>
<td><?php
echo $myData['tempat_lahir'];
?>
,
<?php
echo IndonesiaTgl($myData['tanggal_lahir']);
?>
</td>
<td><?php
echo $myData['alamat'];
?>
</td>
<td align="center"><a href="cetak/dokter_cetak.php?Kode=<?php
echo $myData['kd_dokter'];
?>
" target="_blank">Cetak</a></td>
</tr>
<?php
}
?>
</table>
<body onLoad="window.print()">
<table class="table-list" width="430" border="0" cellspacing="0" cellpadding="2">
<tr>
<td height="87" colspan="5" align="center">
<strong>APOTEK & KLINIK FITRIA</strong><br />
<strong>NPWP/ PKP : </strong>1.111111.11111<br />
<strong>Tanggal Pengukuhan : </strong>10-03-2010<br />
Kota Metro, Lampung </td>
</tr>
<tr>
<td colspan="2"><strong>No Nota :</strong> <?php
echo $kolomData['no_penjualan'];
?>
</td>
<td colspan="3" align="right"> <?php
echo IndonesiaTgl($kolomData['tgl_penjualan']);
?>
</td>
</tr>
<tr>
<td width="32" bgcolor="#F5F5F5"><strong>No</strong></td>
<td width="193" bgcolor="#F5F5F5"><strong>Daftar Obat </strong></td>
<td width="55" align="right" bgcolor="#F5F5F5"><strong>Harga@</strong></td>
<td width="27" align="right" bgcolor="#F5F5F5"><strong>Qty</strong></td>
<td width="97" align="right" bgcolor="#F5F5F5"><strong>Subtotal(Rp) </strong></td>
</tr>
<?php
# Baca variabel
$totalBayar = 0;
$jumlahObat = 0;
$uangKembali = 0;
}
exit;
}
}
// Penutup Tombol Simpan
# MENGAMBIL DATA YANG DIEDIT, SESUAI KODE YANG DIDAPAT DARI URL
$Kode = isset($_GET['Kode']) ? $_GET['Kode'] : $_POST['txtKode'];
$mySql = "SELECT pendaftaran.*, pasien.nm_pasien FROM pendaftaran \n\t\t\tLEFT JOIN pasien ON pendaftaran.nomor_rm = pasien.nomor_rm \n\t\t\tWHERE no_daftar='{$Kode}'";
$myQry = mysql_query($mySql, $koneksidb) or die("Query salah : " . mysql_error());
$myData = mysql_fetch_array($myQry);
# MASUKKAN DATA DARI FORM KE VARIABEL TEMPORARY (SEMENTARA)
$dataKode = $myData['no_daftar'];
$dataPasien = $myData['nm_pasien'];
$dataNomorRM = isset($_POST['txtNomorRM']) ? $_POST['txtNomorRM'] : $myData['nomor_rm'];
$dataTglDaftar = isset($_POST['txtTglDaftar']) ? $_POST['txtTglDaftar'] : IndonesiaTgl($myData['tgl_daftar']);
$dataTglJanji = isset($_POST['txtTglJanji']) ? $_POST['txtTglJanji'] : IndonesiaTgl($myData['tgl_janji']);
$dataJamJanji = isset($_POST['txtJamJanji']) ? $_POST['txtJamJanji'] : $myData['jam_janji'];
$dataKeluhan = isset($_POST['txtKeluhan']) ? $_POST['txtKeluhan'] : $myData['keluhan'];
$dataTindakan = isset($_POST['cmbTindakan']) ? $_POST['cmbTindakan'] : $myData['kd_tindakan'];
?>
<form action="<?php
$_SERVER['PHP_SELF'];
?>
" method="post" name="form1" target="_self">
<table class="table-list" width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<th colspan="3" scope="col">UBAH DATA PENDAFTARAN</th>
</tr>
<tr>
<td width="16%"><strong>Kode</strong></td>
<td width="1%"><strong>:</strong></td>
<body onLoad="window.print()">
<table class="table-list" width="600" border="0" cellspacing="0" cellpadding="2">
<tr>
<td height="87" colspan="4" align="center">
<strong>APOTEK & KLINIK FITRIA</strong><br />
<strong>NPWP/ PKP : </strong>1.111111.11111<br />
<strong>Tanggal Pengukuhan : </strong>10-03-2010<br />
Kota Metro, Lampung </td>
</tr>
<tr>
<td colspan="2"><strong>No. Nota :</strong> <?php
echo $kolomData['no_rawat'];
?>
</td>
<td colspan="2" align="right"> <?php
echo IndonesiaTgl($kolomData['tgl_rawat']);
?>
</td>
</tr>
<tr>
<td width="23" bgcolor="#F5F5F5"><strong>No</strong></td>
<td width="307" bgcolor="#F5F5F5"><strong>Daftar Tindakan </strong></td>
<td width="174" bgcolor="#F5F5F5"><strong>Dokter</strong></td>
<td width="80" align="right" bgcolor="#F5F5F5"><strong>Harga@</strong></td>
</tr>
<?php
# Baca variabel
$totalBayar = 0;
$uangKembali = 0;
# Menampilkan List Item tindakan yang dibeli untuk Nomor Transaksi Terpilih
$notaSql = "SELECT rawat_tindakan.*, tindakan.nm_tindakan, dokter.nm_dokter \n\t\t\tFROM rawat_tindakan\n\t\t\tLEFT JOIN tindakan ON rawat_tindakan.kd_tindakan=tindakan.kd_tindakan \n\t\t\tLEFT JOIN dokter ON rawat_tindakan.kd_dokter=dokter.kd_dokter\n\t\t\tWHERE rawat_tindakan.no_rawat='{$nomorRawat}'\n\t\t\tORDER BY tindakan.kd_tindakan ASC";
$subSotal = $tmpData['uang_bayar'];
$totalBayar = $tmpData['biaya'];
$totalBiaya = $totalBayar - $subSotal;
$jumlahbarang = $jumlahbarang + $tmpData['uang_bayar'];
?>
<tr>
<td><?php
echo $nomor;
?>
</td>
<td><?php
echo IndonesiaTgl($tmpData['tgl_bayar']);
?>
</td>
<td><?php
echo IndonesiaTgl($tmpData['periode_thn']);
?>
</td>
<td><?php
echo $tmpData['kode_jenis'];
?>
</b></td>
<td colspan="3"><?php
echo $tmpData['jns_bayar'];
?>
</td>
<td align="right"><?php
echo format_angka($tmpData['uang_bayar1']);
?>
</td>
<td align="right"><?php
<?php
// Menampilkan data Konfirmasi
$mySql = "SELECT * FROM konfirmasi ORDER BY konfirmasi.id DESC LIMIT {$hal}, {$baris}";
$myQry = mysql_query($mySql, $koneksidb) or die("Query salah : " . mysql_error());
$nomor = 0;
while ($myData = mysql_fetch_array($myQry)) {
$nomor++;
$Kode = $myData['id'];
?>
<tr>
<td><?php
echo $nomor;
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tanggal']);
?>
</td>
<td><?php
echo $myData['no_pemesanan'];
?>
</td>
<td><?php
echo $myData['nm_pelanggan'];
?>
</td>
<td align="right"><?php
echo format_angka($myData['jumlah_transfer']);
?>
</td>
<td><?php
?>
</td>
<td align="right"><?php
echo format_angka($myData['biaya']);
?>
</td>
<td align="right"><?php
echo format_angka($myData['uang_bayar']);
?>
</td>
<td align="right"><b><?php
echo format_angka($subSotal);
?>
</b></td>
<td align="center"><?php
echo IndonesiaTgl($myData['periode_thn']);
?>
</td>
<td><?php
echo $myData['ket'];
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="right" bgcolor="#F5F5F5"><strong>GRAND TOTAL : </strong></td>
<td align="right" bgcolor="#F5F5F5" > </td>
<td align="right" bgcolor="#00CCCC"><b><?php
</tr>
<?php
// Skrip untuk mengambil data Daftar Tindakan yang diambil Pasien
$mySql = "SELECT rawat_tindakan.*, tindakan.nm_tindakan, dokter.nm_dokter FROM rawat_tindakan \n\t\t LEFT JOIN tindakan ON rawat_tindakan.kd_tindakan=tindakan.kd_tindakan \n\t\t LEFT JOIN dokter ON rawat_tindakan.kd_dokter=dokter.kd_dokter\n\t\t WHERE rawat_tindakan.no_rawat='{$noRawat}' ORDER BY id_tindakan";
$myQry = mysql_query($mySql, $koneksidb) or die("Gagal Query Tmp" . mysql_error());
$nomor = 0;
while ($myData = mysql_fetch_array($myQry)) {
$nomor++;
?>
<tr>
<td align="center"><?php
echo $nomor;
?>
</td>
<td><?php
echo IndonesiaTgl($myData['tgl_tindakan']);
?>
</td>
<td><?php
echo $myData['kd_tindakan'];
?>
</td>
<td><?php
echo $myData['nm_tindakan'];
?>
</td>
<td><?php
echo $myData['nm_dokter'];
?>
</td>
</tr>
# TAMPILKAN DATA KE FORM
$dataTanggal = isset($_POST['txtTanggal']) ? $_POST['txtTanggal'] : date('d-m-Y');
$dataPeriode = isset($_POST['periode_thn']) ? $_POST['periode_thn'] : '';
$dataBiaya = isset($_POST['txtBiaya']) ? $_POST['txtBiaya'] : '';
$dataUang_bayar = isset($_POST['txtUang_bayar']) ? $_POST['txtUang_bayar'] : '';
$dataKode_jenis = isset($_POST['txtKode_jenis']) ? $_POST['txtKode_jenis'] : '';
$dataKet = isset($_POST['txtKet']) ? $_POST['txtKet'] : '';
$kd_pembayaran = isset($_POST['kd_pembayaran']) ? $_POST['kd_pembayaran'] : '';
if (isset($_GET['noNota'])) {
// Membaca nomor penjualan dari URL
$noNota = @mysql_real_escape_string($_GET['noNota']);
// Skrip untuk pembaca data dari database
$mySql = "SELECT pembayaran.*, admin.nm_petugas FROM pembayaran\n\t\t\t\tLEFT JOIN admin ON pembayaran.kd_petugas=admin.kd_petugas \n\t\t\t\tWHERE kd_pembayaran='{$noNota}'";
$myQry = mysql_query($mySql, $koneksidb) or die("Query salah : " . mysql_error());
$kolomData = mysql_fetch_array($myQry);
$dataTanggal = IndonesiaTgl($kolomData['tgl_bayar']);
$dataNama = $kolomData['nama_siswa'];
$dataKelas = $kolomData['kelas'];
$no_induk = $kolomData['no_induk'];
$kd_pembayaran = $kolomData['kd_pembayaran'];
$periode_thn = $myData['thn'] . "-" . $myData['bln'] . "-" . $myData['tgl'];
$cmbJns_bayar = $kolomData['jns_bayar'];
$biaya = $kolomData['biaya'];
$uang_bayar = $kolomData['uang_bayar'];
$ket = $kolomData['ket'];
} else {
if (isset($_GET['Edit'])) {
// Membaca nomor penjualan dari URL
$Edit = @mysql_real_escape_string($_GET['Edit']);
// Skrip untuk pembaca data dari database
$mySql = "SELECT * from pembayaran_item\n\t\t\t\tWHERE kode_jenis='{$Edit}'";
