Belajar Ngoding: Sistem Informasi Rawat Jalan Rumah Sakit Dengan PHP,Javascript,Bootstrap - Part 8 (Pembuatan Proses Pemberian Obat(Farmasi) pasien menggunakan MODAL Bootsrap

tahap ini tidak jauh berbeda dengan tutorial sebelumnya( Sistem Informasi Rawat Jalan Rumah Sakit Dengan PHP,Javascript,Bootstrap - Part 7 (Pembuatan Proses Pemberian pemeriksaan penunjang pasien menggunakan MODAL Bootsrap ) kita hanya perlu menyesuaikan data yang di butuhkan.

tabel yang akan kita gunakan nantinya adalah tdetail_obat_px, obat, pasien, dan dokter.

file yang kan kita buat adlah: list_data_pasien_rj_farmasi.php, ftambah_farmasi.php

tampilan page yang kan kita buat adalah :

syntax dari tampilan di atas adalah :

<!DOCTYPE html>
<html>

<?php
 include "koneksi.php";
 $TotBiayObat = '0'; 
 $noregistrasi = @$_GET['noregistrasi'];
 include "sqllistdataregister.php";

$carikodeobat_px = mysqli_query($conn ,"select max(id_obat_px) from tdetail_obat_px") or die (mysqli_error());
 $datakodeobat_px = mysqli_fetch_array($carikodeobat_px);
 if ($datakodeobat_px) {
  $nilaikodeobat_px = substr($datakodeobat_px[0], 2);
  $kodeobat_px = (int) $nilaikodeobat_px;
  $kodeobat_px = $kodeobat_px + 1;
  $hasilkodeobat_px = "FM".str_pad($kodeobat_px, 8, "0", STR_PAD_LEFT);
 } else {
  $hasilkodeobat_px = "FM000000001";
 }
    
    if(isset($_POST['btnsimpanobatpx'])){
        mysqli_query($conn,"INSERT INTO tdetail_obat_px VALUES( 
              '$hasilkodeobat_px',
              '".$_POST['txtnoregistrasi']."',
              '".$_POST['txtmedicalrecord']."',
              '".$_POST['txtidobat']."',
              '".$_POST['txtid_dokter']."',
              '".$_POST['txtqtybeli']."') ") or die(mysqli_error());
        echo "<script> alert ('Data Behasil di simpan');
       document.location='halamanutama.php?page=inputfarmasi&action=tambahfarmasi&noregistrasi=<php echo $noregistrasi;?>;
       </script>";

}elseif (isset($_POST['btnhapusobatpx'])) {
    $idobatpx= $_POST['btnhapusobatpx'];
    $hapusobatpx= mysqli_query($conn, "DELETE FROM tdetail_obat_px where id_obat_px='$idobatpx' ") or die(mysqli_error());
     echo "<script> alert ('Data Behasil di Hapus');
       document.location='halamanutama.php?page=inputfarmasi&action=tambahfarmasi&noregistrasi=<php echo $noregistrasi;?>;
       </script>";
 }elseif (isset($_POST['btnupdateobatpx'])) {
  $id_obat_px= $_POST['txtid_obat_px'];
  $qtyobatpx= $_POST['txtqtybeli'];
  $updateobatpx= mysqli_query($conn, "UPDATE tdetail_obat_px SET qtybeli='$qtyobatpx' where id_obat_px='$id_obat_px' ") or die(mysqli_error());
   echo "<script> alert ('Data Behasil di Update');
     document.location='halamanutama.php?page=inputfarmasi&action=tambahfarmasi&noregistrasi=<php echo $noregistrasi;?>;
     </script>";
 }
?>

<head>
 <title>Entry Farmasi Pasien</title>
 <meta charset="utf-8">
 <title> Farmasi </title>

</head>
<body>
 <?php
  include "scriptautofillnautocomplete.php";
 ?>
<div class="container">
<fieldset>
<div class="panel panel-info">
 <div class="panel-heading">
 Enry Data Farmasi Pasien
 </div>
</div>
<fieldset>
  <table class="table table-striped">
<tr>
    <td style="width: 102px">No Registrasi</td>
    <td style="width: 102px"><input type="text" name="txtnoregistrasri" value="<?php echo $datareg['noregistrasi']; ?>"></input></td>
    <td style="width: 102px">Status</td>
    <td style="width: 102px"><input type="text" name="txtstatus" value="<?php echo $datareg['statusregister']; ?>"></input></td>
    <td style="width: 102px">Tgl Register </td>
    <td style="width: 102px"><input type="text" name="datetglregister" value="<?php echo $datareg['tglregistrasi']; ?>"></input></td>
    <td style="width: 122px">Waktu Registrasi</td>
    <td><input type="text" name="timetglregister" value="<?php echo $datareg['wktregister']; ?>"></input></td>
   </tr>
<tr>
    <td>Medical Record</td>
    <td><input type="text" name="txtmedicalrecord" value="<?php echo $datareg['medicalrecord']; ?>"></input></td>
    <td>Nama Pasien </td>
    <td><input type="text" name="txtnamapasien" value="<?php echo $datareg['namapasien']; ?>"></input></td>
    <td>Tgl Lahir</td>
    <td><input type="text" name="datetgllahir" value="<?php echo $datareg['tanggallahir']; ?>"></input></td>
    <td>Umur</td>
    <td><input type="text" name="txtumur" value="<?php echo $datareg['umur']; ?>"></input></td>
   </tr>
<tr>
    <td>Jenis Kelamin</td>
    <td><input type="text" name="txtJenkel" value="<?php echo $datareg['jeniskelamin']; ?>"></input></td>
    <td>Jenis Pasien</td>
    <td><input type="select" name="slcjenispasien" value="<?php echo $datareg['jenispasien']; ?>"></input></td>
    <td>Alamat</td>
    <td colspan="3"><ttextarea name="txtalamat" cols="65" rows="1"><?php echo $datareg['alamat']; ?></ttextarea></td>
   </tr>
</table>
</fieldset>
<fieldset>

<button type="button" class="btn btn-info" data-toggle="modal" data-target="#TambahDataObat"> 
  <span class="glyphicon glyphicon-plus" aria-hidden="true"> Tambah Data Obat </span></button>
  <br />
   
  
  <div class="modal fade" id="TambahDataObat" tabindex="-1" role="dialog" aria-labelledby="TambahDataRadLabel">
    <div class="modal-dialog" role="document">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
          <h4 class="modal-title" id="TambahDataRadLabel">
Form Tambah Data Obat</h4>
</div>
<div class="modal-body">
          <form action="" method="POST" role="form">
           <div class="form-group">
            <input type="hidden" name="txtnoregistrasi" class="form-control" id="" value="<?php echo $datareg['noregistrasi']; ?>" readonly>
            <input type="hidden" name="txtmedicalrecord" class="form-control" id="" value="<?php echo $datareg['medicalrecord']; ?>" readonly>
            
            <input type="hidden" name="txtidobat" id="idobat"></input>
            <label for="">Nama Obat</label>
            <input type="text" name="txtnamaobat" class="form-control" id="namaobat" placeholder="nama obat" onkeyup="autofillobat()"></input>
            <label for="">Satuan</label>
            <input type="text" name="txtsatuan" class="form-control" id="satuan" readonly></input>
            <label for="">Stock</label>
            <input type="text" name="txtstock" class="form-control" id="stock" readonly></input>
            <label for="">Harga</label>
            <input type="text" name="txthargajual" class="form-control" id="hargajual" readonly></input>
            <label for="">Tanggal Expired</label>
            <input type="date" name="datetglexpired" class="form-control" id="tglexpired" readonly></input>
            <input type="hidden" name="txtid_dokter" id="id_dokter"></input>
            <label for="">Dokter Pemeriksa</label>
            <input type="text" name="txtnamadokter" class="form-control" id="namadokter" placeholder="nama dokter" onkeyup="autofilldokter()"></input>
            <label for="">Jumlah Beli</label>
            <input type="number" name="txtqtybeli" id="qtybeli" value="1" class="form-control"></input>
           </div>
</div>
<div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
          <button type="submit" name="btnsimpanobatpx" class="btn btn-primary">Save</button>
         </form>
</div>
</div>
</div>
</div>
<table class="table table-striped table-bordered small">
<tr>
         <th bgcolor="#4bf9f3"><center>
 Nama Dokter </center>
</th>
   <th bgcolor="#4bf9f3"><center>
 Nama Obat </center>
</th>
   <th bgcolor="#4bf9f3"><center>
 qty </center>
</th>
   <th bgcolor="#4bf9f3"><center>
 Satuan </center>
</th>
   <th bgcolor="#4bf9f3"><center>
 Harga </center>
</th>
   <th bgcolor="#4bf9f3"><center>
 Biaya </center>
</th>
   <th bgcolor="#4bf9f3"><center>
 Action </center>
</th>
  </tr>
<?php
        $sql_det_obat_px = mysqli_query($conn,"SELECT tdetail_obat_px.id_obat_px,
                   tdetail_obat_px.noregistrasi,
                   tdetail_obat_px.medicalrecord,
                   tdetail_obat_px.idobat,
                   obat.namaobat,
                   obat.stock,
                   obat.hargajual,
                   obat.satuan,
                   obat.tglexpired,
                   dokter.namadokter, 
                   tdetail_obat_px.qtybeli
                  FROM tdetail_obat_px,obat,dokter
                  WHERE tdetail_obat_px.idobat = obat.idobat
                  AND tdetail_obat_px.id_dokter = dokter.id_dokter
                  AND tdetail_obat_px.noregistrasi = '$noregistrasi' ")or die(mysqli_error());
        while ($data_obat = mysqli_fetch_array($sql_det_obat_px)) {
         
         $biaya_obat = $data_obat['hargajual']*$data_obat['qtybeli'];
   
   $Totbiaya_obat[] = $biaya_obat; 
   $TotBiayObat = array_sum($Totbiaya_obat) ;

?>
<tr>
     <td><?php echo $data_obat['namadokter']; ?></td>
     <td><?php echo $data_obat['namaobat']; ?></td>
     <td><?php echo $data_obat['qtybeli']; ?></td>
     <td><?php echo $data_obat['satuan']; ?></td>
     <td><?php echo $data_obat['hargajual']; ?></td>
     <td><?php echo $biaya_obat; ?></td>
     <td>
      <button class="btn btn-danger" data-toggle="modal" data-target="#hapusobat<?php echo $data_obat['id_obat_px']; ?>"><span class="glyphicon glyphicon-trash" aria-hidden="true"> Hapus </span> </button>
     
     <div class="modal fade" id="hapusobat<?php echo $data_obat['id_obat_px']; ?>
" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
       <div class="modal-dialog" role="document">
         <div class="modal-content">
           <div class="modal-header">
             <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
             <h4 class="modal-title" id="myModalLabel">
Form Hapus Data Obat Pasien</h4>
</div>
<div class="modal-body">
             <form action="" method="POST" role="form">
              
              <h5>
 Apakah Anda Ingin Menghapus Data ini : </h5>
<br />
               ID OBAT         : <?php echo $data_obat['id_obat_px']; ?><br />
               NAMA OBAT       : <?php echo $data_obat['namaobat']; ?><br />
               Resep Oleh DOKTER     : <?php echo $data_obat['namadokter']; ?><br />
               Biaya          : <?php echo $data_obat['hargajual']; ?><br />
                            
           </div>
<div class="modal-footer">
             <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
             <button type="submit" name="btnhapusobatpx" value="<?php echo $data_obat['id_obat_px']; ?>" class="btn btn-primary">Hapus</button>
            </form>
</div>
</div>
</div>
</div>
<button type="buton" class="btn btn-warning" data-toggle="modal" data-target="#update<?php echo $data_obat['id_obat_px']; ?>">
      <span class="glyphicon glyphicon-edit" aria-hidden="true"> edit </span>
     </button>
     
     <div class="modal fade" id="update<?php echo $data_obat['id_obat_px']; ?>
" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
       <div class="modal-dialog" role="document">
         <div class="modal-content">
           <div class="modal-header">
             <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
             <h4 class="modal-title" id="myModalLabel">
Form Update Obat Pasien</h4>
</div>
<div class="modal-body">
             <form action="" method="POST" role="form">
              
              <div class="form-group">
               <input type="text" name="txtid_obat_px" class="form-control" value="<?php echo $data_obat['id_obat_px']; ?>" id="" readonly>
              </div>
<div class="form-group">
               <label for="">Nama Obat</label>
               <input type="text" name="txtnamaobat" class="form-control" value="<?php echo $data_obat['namaobat']; ?>" id="" readonly>
              </div>
<div class="form-group">
               <label for="">Qty</label>
               <input type="number" name="txtqtybeli" class="form-control" value="<?php echo $data_obat['qtybeli']; ?>" id="">
              </div>
</div>
<div class="modal-footer">
             <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
             <button type="submit" name="btnupdateobatpx" class="btn btn-primary">Update</button>
            </form>
</div>
</div>
</div>
</div>
</td>
    </tr>
<?php
   }
  ?>
 </table>
<table class="table table-striped">
<tr>
  <td><font size="4px" color="red">Total Biaya Obat :</font></td>
  <td><font size="4px" color="red">Rp. <?php  echo $TotBiayObat;  ?></font></td>
 </tr>
</table>
</div>
</div>
</fieldset>
</fieldset>
</div>
</body>
</html>

begitulah kira2 pembuatannya... untuk list_data_pasien_rj_farmasi.php silahkan di samakan saja dengan tutorial sebelumnya and diganti link nya sesuai kebutuhan kita...

Saturday, 14 April 2018

Sistem Informasi Rawat Jalan Rumah Sakit Dengan PHP,Javascript,Bootstrap - Part 8 (Pembuatan Proses Pemberian Obat(Farmasi) pasien menggunakan MODAL Bootsrap

No comments:

Post a Comment