?> <tr> <td> <?php echo $nomor; ?> </td> <td> <?php echo $myData['kd_obat']; ?> </td> <td> <?php echo $myData['nm_obat']; ?> </td> <td align="right"><?php echo format_angka($myData['harga_jual']); ?> </td> <td align="right"> <?php echo $myData['stok']; ?> </td> <td><?php echo $myData['keterangan']; ?> </td> </tr> <?php } ?> <tr>
//$SQL = "SELECT * FROM barang WHERE nm_barang like '$searchTerm' ORDER BY $sidx $sord"; $SQL = "SELECT\n\t\t\t\t\t\t\t\t\t*\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tjasa j,\n\t\t\t\t\t\t\t\t\tbahanbaku b\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tj.kd_bahan = b.kd_bahan\n\t\t\t\t\t\t\t\tAND j.nama_jasa LIKE '{$searchTerm}'\n\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t'{$sidx}' '{$sord}'"; } //var_dump($SQL);exit(); $result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error()); //var_dump($result);exit(); $response->page = $page; $response->total = $total_pages; $response->records = $count; $i = 0; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $response->rows[$i]['kd_jasa'] = $row['kd_jasa']; $response->rows[$i]['nama_jasa'] = $row['nama_jasa']; $response->rows[$i]['kd_bahan'] = $row['kd_bahan']; $response->rows[$i]['nm_bahan'] = $row['nm_bahan']; format_angka($response->rows[$i]['harga_jasa'] = $row['harga_jasa']); $response->rows[$i]['harga_bahan'] = $row['harga_bahan']; $response->rows[$i]['diskon'] = $row['diskon']; $response->rows[$i]['ppn'] = $row['ppn']; $response->rows[$i]['diskon'] = $row['diskon']; $i++; } echo json_encode($response); break; case 'transBeli': $page = $_GET['page']; // get the requested page $limit = $_GET['rows']; // get how many rows we want to have into the grid $sidx = $_GET['sidx']; // get index row - i.e. user click to sort
?> </td> <td align="right"><?php echo $my2Data['total_barang']; ?> </td> <td align="right"><?php echo format_angka($totalBayar); ?> </td> <td> </td> </tr> <?php } ?> <tr> <td colspan="5" align="right"><strong> TOTAL : </strong></td> <td align="right"> <strong><?php echo format_angka($totItemBarang); ?> </strong> </td> <td align="right"> <strong> Rp. <?php echo format_angka($totOmset); ?> </strong> </td> <td> </td> </tr> </table> </body> </html>
<tr> <td colspan="3"><strong>DETAIL BARANG </strong></td> </tr> <tr> <td width="23%"><strong>Nama </strong></td> <td width="1%">:</td> <td width="76%"> <?php echo $lihatData['nm_barang']; ?> </td> </tr> <tr> <td><strong>Harga (Rp.)</strong></td> <td>:</td> <td> <?php echo format_angka($lihatData['harga_jual']); ?> </td> </tr> <tr> <td><strong>Stok</strong></td> <td>:</td> <td> <?php echo $lihatData['stok']; ?> </td> </tr> <tr> <td><strong>Kategori </strong></td> <td>:</td> <td> <?php
echo $myData['kelas']; ?> </td> <td align="right"><?php echo format_angka($myData['uang_bayar']); ?> </td> </tr> <?php } ?> <tr> <td colspan="7" align="right" bgcolor="#F5F5F5"><strong>GRAND TOTAL : </strong></td> <td align="right" bgcolor="#F5F5F5"><b><?php echo format_angka($jumlahbarang); ?> </b></td> </tr> <tr> <td colspan="8"><strong>Jumlah Data :<?php echo $jumData; ?> </strong></td> <td colspan="2" align="right"><strong></strong></td> </tr> </table> <p> </p> </div> </div>
if ($barangData['file_gambar'] == "") { $fileGambar = "noimage.jpg"; } else { $fileGambar = $barangData['file_gambar']; } ?> <tr> <td width="24%"><a href="?open=Barang-Lihat&Kode=<?php echo $KodeBarang; ?> "><img src="img-barang/<?php echo $fileGambar; ?> " width="100" border="0"> </a> <br> <div class='harga'>Rp. <?php echo format_angka($barangData['harga_jual']); ?> </div><br> <a href="?open=Barang-Beli&Kode=<?php echo $KodeBarang; ?> " class="button orange small"> <strong>Beli</strong></a> </td> <td width="76%"> <a href="?open=Barang-Lihat&Kode=<?php echo $KodeBarang; ?> "> <div class='judul'> <?php echo $barangData['nm_barang']; ?> </div>
<tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <?php } ?> <tr> <td> </td> <td> </td> <td colspan="2"><b>GRAND TOTAL : </b></td> <td bgcolor="#CCCCCC"><strong><?php echo "Rp. " . format_angka($grandTotal); ?> </strong></td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td><input name="btnSimpan" type="submit" value=" Ubah Data"></td> <td> </td> </tr> <tr> <td colspan="6" align="center"><a href="?open=Transaksi-Proses" target="_self"><img src="images/btn_lanjutkan.jpg" alt="Lanjutkan Transaksi (Checkout)" border="0"></a></td> </tr>
</td> <td align="center" bordercolor="#000000"><?php echo $myData['nama_jenis']; echo $myData['ukuran']; ?> </td> <td align="center" bordercolor="#000000"><?php echo format_angka($myData['harga_beli']); ?> </td> <td align="right"><?php echo format_angka($myData['harga_jual']); ?> </td> <td align="right"><?php echo format_angka($myData['stok']); ?> </td> <td align="center"><a href="?open=Barang-Edit&Kode=<?php echo $myData['kd_barang']; ?> " target="_self" alt="Edit Data">Edit</a></td> <td align="center"><a href="?open=Barang-Delete&Kode=<?php echo $myData['kd_barang']; ?> " target="_self" alt="Delete Data" onclick="return confirm('ANDA YAKIN AKAN MENGHAPUS DATA BARANG INI ... ?')">Delete</a></td> </tr> <?php } ?> <tr >
$nomor = 0; while ($myData = mysql_fetch_array($myQry)) { $nomor++; $Kode = $myData['kd_provinsi']; ?> <tr> <td><?php echo $nomor; ?> </td> <td><?php echo $myData['nm_provinsi']; ?> </td> <td><?php echo format_angka($myData['biaya_kirim']); ?> </td> <td width="54"><a href="?open=Provinsi-Edit&Kode=<?php echo $Kode; ?> " target="_self">Edit</a></td> <td width="50"><a href="?open=Provinsi-Delete&Kode=<?php echo $Kode; ?> " target="_self" onClick="return confirm('ANDA YAKIN AKAN MENGHAPUS DATA PROVINSI INI ...?')">Delete</a></td> </tr> <?php } ?> </tbody>
?> </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 echo $myData['keterangan']; ?> </td> <td width="39" align="center"><a href="?open=Konfirmasi-Delete&Kode=<?php echo $Kode; ?> " target="_self" alt="Delete Data" onclick="return confirm('ANDA YAKIN AKAN MENGHAPUS DATA KONFIRMASI INI ... ?')">Delete</a></td> </tr> <?php } ?> <tr>
?> </td> </tr> <tr> <td colspan="2" align="right" bgcolor="#F5F5F5"><strong>Grand Total Uang Masuk</strong></td> <td colspan="2" align="left" bgcolor="#F5F5F5"><b>: Rp. <?php echo format_angka($jumlahbarang); ?> </b></td> </tr> <tr> <td colspan="2" align="right" bgcolor="#F5F5F5"><strong>Grand Total Uang Belum Masuk</strong></td> <td colspan="2" align="left" bgcolor="#F5F5F5"><b>: Rp. <?php echo format_angka($htg); ?> </b></td> </tr> </table> <form action="laporan_bayar_periode.php" method="post" name="form1" target="_blank" id="form1"> <table width="397" border="0" > <tr> <td width="391"><input name="txtTglAwal" type="hidden" class="tcal" value="<?php echo $tglAwal; ?> " /> <input name="txtTglAkhir" type="hidden" class="tcal" value="<?php echo $tglAkhir;
<td width="547" bgcolor="#CCCCCC"><strong>Nama Tindakan </strong></td> <td width="112" align="right" bgcolor="#CCCCCC"><strong>Harga (Rp.) </strong></td> </tr> <?php // Menampilkan daftar tindakan $mySql = "SELECT * FROM tindakan ORDER BY kd_tindakan ASC"; $myQry = mysql_query($mySql, $koneksidb) or die("Query 1 salah : " . mysql_error()); $nomor = 0; while ($myData = mysql_fetch_array($myQry)) { $nomor++; ?> <tr> <td><?php echo $nomor; ?> </td> <td><?php echo $myData['nm_tindakan']; ?> </td> <td align="right"><?php echo format_angka($myData['harga']); ?> </td> </tr> <?php } ?> </table> </div></div>
?> </td> <td> <?php echo IndonesiaTgl($myData['tgl_pemesanan']); ?> </td> <td> <?php echo $myData['nama_penerima']; ?> </td> <td> Rp. <?php echo format_angka($totalHarga); ?> </td> <td> Rp. <?php echo format_angka($biayaKirim); ?> </td> <td> <?php echo $myData['status_bayar']; ?> </td> <td><a href="transaksi_lihat.php?Kode=<?php echo $Kode; ?> " target="_blank" alt="Lihat Data">Cetak</a></td> </tr> <?php } ?> </table>
</td> <td><?php echo $tmpData['nm_tindakan']; ?> </td> <td><?php echo $tmpData['nm_dokter']; ?> </td> <td align="right"><?php echo format_angka($tmpData['harga']); ?> </td> <td><a href="?Aksi=Hapus&id=<?php echo $tmpData['id']; ?> " target="_self">Delete</a></td> </tr> <?php } ?> <tr> <td colspan="4" align="right"><b> GRAND TOTAL : </b></td> <td align="right" bgcolor="#CCCCCC"><strong>Rp. <?php echo format_angka($totalHarga); ?> </strong></td> <td> </td> </tr> </table> </form>
?> <tr> <td ><?php echo $nomor; ?> </td> <td><?php echo $data['kode_jenis']; ?> </td> <td align="left"><?php echo $data['jns_bayar']; ?> </td> <td><?php echo format_angka($data['biaya']); ?> </td> <td width="75" align="center"><a href="?page=editjenis&kode_jenis=<?php echo $data['kode_jenis']; ?> " target="_self" alt="Edit Data"></a><a href="?page=editjenis&kode_jenis=<?php echo $data['kode_jenis']; ?> "><i class="fa fa-edit"></i> Ubah</a></td> <td width="70" align="center"> <a href="?page=hapus_jenis&kode_jenis=<?php echo $data['kode_jenis']; ?> " onClick="return confirm('Apakah anda yakin ingin menghapus data ini ?')"role="button" data-toggle="modal"><i class="fa fa-trash-o"></i> Hapus</a></td> </tr>
<tr> <td colspan="3" align="right"><strong>Total Belanja (Rp) : </strong></td> <td colspan="2" align="right" bgcolor="#F5F5F5"><?php echo format_angka($totalBayar); ?> </td> </tr> <tr> <td colspan="3" align="right"><strong> Uang Bayar (Rp) : </strong></td> <td colspan="2" align="right"><?php echo format_angka($kolomData['uang_bayar']); ?> </td> </tr> <tr> <td colspan="3" align="right"><strong>Uang Kembali (Rp) : </strong></td> <td colspan="2" align="right"><?php echo format_angka($uangKembali); ?> </td> </tr> <tr> <td colspan="5"><strong>Petugas :</strong> <?php echo $kolomData['nm_petugas']; ?> </td> </tr> </table> </body> </html>
</td> <td align="right"><?php echo format_angka($subSotal); ?> </td> <td><a href="?Aksi=Delete&Kode=<?php echo $tmpData['kd_barang']; ?> " target="_self">Delete</a></td> </tr> <?php } ?> <tr> <td colspan="4" align="right" bgcolor="#F5F5F5"><strong>GRAND TOTAL : </strong></td> <td align="right" bgcolor="#F5F5F5"><b><?php echo $jumlahbarang; ?> </b></td> <td align="right" bgcolor="#F5F5F5"><b><?php echo format_angka($totalBayar); ?> </b></td> <td bgcolor="#F5F5F5"><input name="txtTotBayar" type="hidden" value="<?php echo $totalBayar; ?> " /></td> </tr> </table> </form>
echo $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 bgcolor="#F5F5F5"> </td> <td align="right" bgcolor="#00CCCC"><b><?php echo format_angka($totalBayar); ?> </b></td> <td align="right" bgcolor="#00FF33"><b><?php echo format_angka($jumlahbarang); ?> </b></td> <td bgcolor="#FFA540" align="right"><b><?php echo format_angka($totalBiaya); ?> </b></td> <td bgcolor="#F5F5F5"> </td> <td bgcolor="#F5F5F5"> </td> </tr> </table>
<tr> <td colspan="5" align="right" bgcolor="#F5F5F5"><strong>Total Belanja (Rp) : </strong></td> <td bgcolor="#F5F5F5"> Rp. <?php echo format_angka($totalHarga); ?> </td> </tr> <tr> <td colspan="5" align="right"><strong>Total Biaya Kirim (Rp) : </strong></td> <td> Rp. <?php echo format_angka($totalBiayaKirim); ?> </td> </tr> <tr> <td colspan="5" align="right" bgcolor="#F5F5F5"><strong>TOTAL (Rp) : </strong></td> <td bgcolor="#F5F5F5"> <?php echo format_angka($totalBayar); ?> </td> </tr> <tr> <td colspan="6">Nominal Pembayarannya adalah (Rp.) <b>Rp. <?php echo format_angka($unik_transfer); ?> </b> </td> </tr> </table> </body> </html>
?> </td> <td><?php echo $myData['kd_pelanggan']; ?> </td> <td><?php echo $myData['nm_pelanggan']; ?> </td> <td><?php echo $my2Data['total_barang']; ?> </td> <td><?php echo format_angka($unikTransfer); ?> </td> <td bgcolor="#FFFFCC"><?php echo $myData['status_bayar']; ?> </td> <td><a href="pemesanan_lihat.php?Kode=<?php echo $Kode; ?> " target="_blank" class='button white small'>Lihat</a></td> </tr> <?php } ?> </table>
<td width="45" align="center"><a href="penjualan/penjualan_nota.php?noNota=<?php echo $myData['kd_jual']; ?> " target="_blank">Nota</a></td> </tr> <?php } ?> <tr> <td colspan="4" align="right" bgcolor="#F5F5F5"><strong>GRAND TOTAL : </strong></td> <td align="right" bgcolor="#F5F5F5"><b><?php echo $jumlahbarang; ?> </b></td> <td align="right" bgcolor="#F5F5F5"><b><?php echo format_angka($grandTotalJual); ?> </b></td> <td colspan="2" bgcolor="#F5F5F5"> </td> </tr> <tr> <td colspan="6"><strong>Jumlah Data :<?php echo $jumData; ?> </strong></td> <td colspan="2" align="right"><strong>Halaman ke : <?php for ($h = 1; $h <= $maksData; $h++) { $list[$h] = $barisData * $h - $barisData; echo " <a href='?open=Laporan-Penjualan&hal={$list[$h]}'>{$h}</a> "; }
?> </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 echo $myData['hasil_diagnosa']; ?> </td> <td align="center"><a href="cetak/rawat_cetak.php?noRawat=<?php echo $myData['no_rawat']; ?> " target="_blank">Cetak</a></td> </tr> <?php } ?> <tr>
# JIKA TOMBOL SIMPAN TRANSAKSI DIKLIK if (isset($_POST['btnSimpan'])) { # Baca Variabel from $txtTanggal = $_POST['txtTanggal']; $txtUangBayar = $_POST['txtUangBayar']; $txtTotBayar = $_POST['txtTotBayar']; # Validasi Form $pesanError = array(); if (trim($txtTanggal) == "") { $pesanError[] = "Data <b>Tanggal Transaksi</b> belum diisi, pilih pada tanggal !"; } if (trim($txtUangBayar) == "" or !is_numeric(trim($txtUangBayar))) { $pesanError[] = "Data <b>Uang Bayar</b> belum diisi, harus berupa angka !"; } if (trim($txtUangBayar) < trim($txtTotBayar)) { $pesanError[] = "Data <b> Uang Bayar Belum Cukup</b>. \n\t\t\t\t\t\t Total belanja adalah <b> Rp. " . format_angka($txtTotBayar) . "</b>"; } # Periksa apakah sudah ada barang yang dimasukkan $tmpSql = "SELECT COUNT(*) As qty FROM tmp_penjualan"; $tmpQry = mysql_query($tmpSql, $koneksidb) or die("Gagal Query Tmp" . mysql_error()); $tmpData = mysql_fetch_array($tmpQry); if ($tmpData['qty'] < 1) { $pesanError[] = "<b>DAFTAR BARANG MASIH KOSONG</b>, belum ada barang yang dimasukan, <b>minimal 1 barang</b>."; } # JIKA ADA PESAN ERROR DARI VALIDASI if (count($pesanError) >= 1) { echo "<div class='mssgBox'>"; echo "<img src='../images/attention.png'> <br><hr>"; $noPesan = 0; foreach ($pesanError as $indeks => $pesan_tampil) { $noPesan++;