Membuat Aplikasi Klinik #07 - Update dan Delete
Pada tahap ini kita akan menambahkan fungsi edit, update dan delete pada fungsi Pasiencreate.php untuk melengkapi proses CRUD (Create,Read, Update dan Delete) dari module pada file Pasiencreate.php.
Buka kembali file Pasiencreate.php lalu tambahkan bari fungsi baru seperti berikut ini
public function pasien_edit($data)
{
?>
<?php
if($_SERVER['REQUEST_METHOD']=='POST')
{
$nik = $this->app->post('nik');
$nama = $this->app->post('nama_lengkap');
$alamat = $this->app->post('alamat');
$kontak = $this->app->post('kontak');
if($this->obj->updateTable('pasien',
'pasien_nik=:pasien_nik,
pasien_nama=:pasien_nama,
pasien_alamat=:pasien_alamat,
pasien_kontak=:pasien_kontak
','pasien_id=:pasien_id',
array(
":pasien_nik"=>$nik,
":pasien_nama"=>$nama,
":pasien_alamat"=>$alamat,
":pasien_kontak"=>$kontak,
":pasien_id"=>$data['pasien_id']
)
))
{
$this->success = $this->app->alert('success','Data berhasil disimpan');
$this->app->reload(3,'?page=semua_pasien');
}
else
{
$this->success = $this->app->alert('danger','Data gagal disimpan');
$this->app->reload(3,'?page=semua_pasien');
}
}
?>
<!-- general form elements -->
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Edit pasien</h3>
</div>
<!-- /.card-header -->
<!-- form start -->
<form action="<?php htmlentities($_SERVER['REQUEST_URI'])?>" method="post">
<div class="card-body">
<?php
if(count($this->err)>0)
{
$this->app->getError($this->err);
}
?>
<?=$this->success?>
<div class="form-group">
<label>NIK</label>
<input type="text" name="nik" class="form-control" value="<?=$data['pasien_nik']?>" placeholder="Masukan nomor induk kependudukan">
</div>
<div class="form-group">
<label>Nama lengkap</label>
<input type="text" name="nama_lengkap" class="form-control" value="<?=$data['pasien_nama']?>" placeholder="Masukan nama lengkap">
</div>
<div class="form-group">
<label>Alamat lengkap</label>
<textarea class="form-control" name="alamat" rows="5"><?=$data['pasien_alamat']?></textarea>
</div>
<div class="form-group">
<label>Kontak</label>
<input type="text" name="kontak" class="form-control" value="<?=$data['pasien_kontak']?>" placeholder="Masukan nomor kontak / whatsapp">
</div>
<div class="card-footer">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</form>
</div>
<!-- /.card -->
<?php
}
public function pasien_edit_index($get)
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Edit Pasien','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<?php
if(!$this->obj->getTable('pasien','pasien_id=:pasien_id',$get,'pasien_id'))
{
echo "<div class='col-md-12'>".$this->app->alert('danger','Data tidak ditemukan')."</dic>";
}
else
{
Pasiencreate::pasien_edit($this->obj->row);
}
?>
</div>
</div>
</section>
</div>
<?php
}
public function delete_pasien($get)
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Delete Pasien','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<?php
if(!$this->obj->getTable('pasien','pasien_id=:pasien_id',$get,'pasien_id'))
{
echo "<div class='col-md-12'>".$this->app->alert('danger','Data tidak ditemukan')."</dic>";
}
else
{
if($this->obj->delete('paseien','pasien_id=:pasien_id','pasien_id', $this->obj->row['pasien_id']))
{
echo $this->app->alert('success col-md-12','Data berhasil dihapus');
$this->app->reload(3,'?page=semua_pasien');
}
else
{
echo $this->app->alert('danger col-md-12','Data gagal dihapus');
$this->app->reload(3,'?page=semua_pasien');
}
}
?>
</div>
</div>
</section>
</div>
<?php
}
Sehingga nanti keseluruhan kode yang terdapat pada fungsi Pasiencreate.php akan terlihat seperti berikut :
<?php
class Pasiencreate
{
public $success;
public $err;
public function pasien_tambah()
{
?>
<!-- general form elements -->
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Tambah pasien</h3>
</div>
<!-- /.card-header -->
<!-- form start -->
<form action="<?php htmlentities($_SERVER['REQUEST_URI'])?>" method="post">
<div class="card-body">
<?php
if(count($this->err)>0)
{
$this->app->getError($this->err);
}
?>
<?=$this->success?>
<div class="form-group">
<label>NIK</label>
<input type="text" name="nik" class="form-control" value="<?=rand(3000000000000000,4000000000000000)?>" placeholder="Masukan nomor induk kependudukan">
</div>
<div class="form-group">
<label>Nama lengkap</label>
<input type="text" name="nama_lengkap" class="form-control" placeholder="Masukan nama lengkap">
</div>
<div class="form-group">
<label>Alamat lengkap</label>
<textarea class="form-control" name="alamat" rows="5"></textarea>
</div>
<div class="form-group">
<label>Kontak</label>
<input type="text" name="kontak" class="form-control" placeholder="Masukan nomor kontak / whatsapp">
</div>
<div class="card-footer">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</form>
</div>
<!-- /.card -->
<?php
}
public function pasien_proses()
{
$this->err = array();
if($_SERVER['REQUEST_METHOD']=='POST')
{
if(empty($this->app->post('nik')))
{
array_push($this->err,"NIK Wajib diisi");
}
else
{
$nik = $this->app->post('nik');
}
if(empty($this->app->post('nama_lengkap')))
{
array_push($this->err,"Nama lengkap Wajib diisi");
}
else
{
$nama = $this->app->post('nama_lengkap');
}
if(empty($this->app->post('alamat')))
{
array_push($this->err,"Alamat wajib disisi");
}
else
{
$alamat = $this->app->post('alamat');
}
if(empty($this->app->post('kontak')))
{
array_push($this->err,"Kontak Wajib diisi");
}
else
{
$kontak = $this->app->post('kontak');
}
if(count($this->err)==0)
{
if($this->obj->insertTable('pasien','pasien_nik, pasien_nama, pasien_alamat, pasien_kontak',
':pasien_nik,:pasien_nama,:pasien_alamat, :pasien_kontak',
array(
":pasien_nik"=>$nik,
":pasien_nama"=>$nama,
":pasien_alamat"=>$alamat,
":pasien_kontak"=>$kontak
)
))
{
$this->success = $this->app->alert('success','Data berhasil disimpan');
$this->app->reload(3);
}
else
{
$this->success = $this->app->alert('danger','Data gagal disimpan');
$this->app->reload(3);
}
}
}
}
public function pasien_index()
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Tambah Pasien','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<?=Pasiencreate::pasien_proses()?>
<?=Pasiencreate::pasien_tambah()?>
</div>
</div>
</div>
</section>
</div>
<?php
}
public function pasien_table()
{
?>
<div class="card">
<div class="card-header">
<h3 class="card-title">DataTable with default features</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example2" class="table table-bordered table-striped">
<thead>
<tr>
<th>NO</th>
<th>NIK</th>
<th>Nama Lengkap</th>
<th>Alamat</th>
<th>Kontak</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$data = $this->obj->pagination('halaman','pasien',10,NULL,'ORDER by pasien_id DESC');
$data->execute();
while($row=$data->fetch(PDO::FETCH_BOTH))
{
?>
<tr>
<td><?=$no?></td>
<td><?=$row['pasien_nik']?></td>
<td><?=$row['pasien_nama']?></td>
<td><?=$row['pasien_alamat']?></td>
<td><?=$row['pasien_kontak']?></td>
<td>
<a href="?page=pasien_edit&pasien_id=<?=$row['pasien_id']?>"><i class="fas fa-pen"></i></a>
<a href="?page=pasien_delete&pasien_id=<?=$row['pasien_id']?>"><i class="fas fa-trash"></i></a>
</tr>
<?php $no+=1; } ?>
</tbody>
</table>
</div>
<!-- /.card-body -->
<?php
$this->obj->paginationNumberBootstrap('pasien',10,'page=semua_pasien','halaman');
?>
</div>
<?php
}
public function pasien_table_index()
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Semua Pasien','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<?=Pasiencreate::pasien_table()?>
</div>
</section>
</div>
<?php
}
public function pasien_edit($data)
{
?>
<?php
if($_SERVER['REQUEST_METHOD']=='POST')
{
$nik = $this->app->post('nik');
$nama = $this->app->post('nama_lengkap');
$alamat = $this->app->post('alamat');
$kontak = $this->app->post('kontak');
if($this->obj->updateTable('pasien',
'pasien_nik=:pasien_nik,
pasien_nama=:pasien_nama,
pasien_alamat=:pasien_alamat,
pasien_kontak=:pasien_kontak
','pasien_id=:pasien_id',
array(
":pasien_nik"=>$nik,
":pasien_nama"=>$nama,
":pasien_alamat"=>$alamat,
":pasien_kontak"=>$kontak,
":pasien_id"=>$data['pasien_id']
)
))
{
$this->success = $this->app->alert('success','Data berhasil disimpan');
$this->app->reload(3,'?page=semua_pasien');
}
else
{
$this->success = $this->app->alert('danger','Data gagal disimpan');
$this->app->reload(3,'?page=semua_pasien');
}
}
?>
<!-- general form elements -->
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Edit pasien</h3>
</div>
<!-- /.card-header -->
<!-- form start -->
<form action="<?php htmlentities($_SERVER['REQUEST_URI'])?>" method="post">
<div class="card-body">
<?php
if(count($this->err)>0)
{
$this->app->getError($this->err);
}
?>
<?=$this->success?>
<div class="form-group">
<label>NIK</label>
<input type="text" name="nik" class="form-control" value="<?=$data['pasien_nik']?>" placeholder="Masukan nomor induk kependudukan">
</div>
<div class="form-group">
<label>Nama lengkap</label>
<input type="text" name="nama_lengkap" class="form-control" value="<?=$data['pasien_nama']?>" placeholder="Masukan nama lengkap">
</div>
<div class="form-group">
<label>Alamat lengkap</label>
<textarea class="form-control" name="alamat" rows="5"><?=$data['pasien_alamat']?></textarea>
</div>
<div class="form-group">
<label>Kontak</label>
<input type="text" name="kontak" class="form-control" value="<?=$data['pasien_kontak']?>" placeholder="Masukan nomor kontak / whatsapp">
</div>
<div class="card-footer">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</form>
</div>
<!-- /.card -->
<?php
}
public function pasien_edit_index($get)
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Edit Pasien','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<?php
if(!$this->obj->getTable('pasien','pasien_id=:pasien_id',$get,'pasien_id'))
{
echo "<div class='col-md-12'>".$this->app->alert('danger','Data tidak ditemukan')."</dic>";
}
else
{
Pasiencreate::pasien_edit($this->obj->row);
}
?>
</div>
</div>
</section>
</div>
<?php
}
public function delete_pasien($get)
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Delete Pasien','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<?php
if(!$this->obj->getTable('pasien','pasien_id=:pasien_id',$get,'pasien_id'))
{
echo "<div class='col-md-12'>".$this->app->alert('danger','Data tidak ditemukan')."</dic>";
}
else
{
if($this->obj->delete('paseien','pasien_id=:pasien_id','pasien_id', $this->obj->row['pasien_id']))
{
echo $this->app->alert('success col-md-12','Data berhasil dihapus');
$this->app->reload(3,'?page=semua_pasien');
}
else
{
echo $this->app->alert('danger col-md-12','Data gagal dihapus');
$this->app->reload(3,'?page=semua_pasien');
}
}
?>
</div>
</div>
</section>
</div>
<?php
}
}
Seorang laki - laki biasa yang senang duduk sendirian di pinggir pantai, pengagum embun pagi dan lembayung senja, suka blogging, coding dan jogging. Moto hidupnya adalah hidup santai dan simple
0 Response to "Membuat Aplikasi Klinik #07 - Update dan Delete"
Post a Comment
Komentar yang Anda kirim akan terlebih dahulu di moderasi oleh Admin