Membuat Aplikasi Klinik #11 - Membuat Module Manajemen Role
Selanjutnya disini kita akan membuat module untuk manajemen role yang mana role ini nantinya diperlukan atau nanti akan digunakan module user untuk ditambahkan kedalam tabel user. Sehingga sebelum membuat module untuk menajamen user, kita terlebih dahulu perlu menyiapakan module manajemen role
Pertama tambahkan terlebih dahulu tabel role dan user pada database aplikasi klinik Anda seperti berikut
users_role.sql
CREATE TABLE `users_role` (
`role_id` smallint(5) UNSIGNED NOT NULL,
`role_name` varchar(65) DEFAULT NULL,
`role_alias` varchar(65) DEFAULT NULL,
`role_module` enum('admin','dokter','perawat') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `users_role`
--
ALTER TABLE `users_role`
ADD PRIMARY KEY (`role_id`),
ADD UNIQUE KEY `role_name` (`role_name`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `users_role`
--
ALTER TABLE `users_role`
MODIFY `role_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
users.sql
CREATE TABLE `users` (
`user_id` int(10) UNSIGNED NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`role_id` smallint(6) NOT NULL,
`nama_lengkap` varchar(65) DEFAULT NULL,
`photo` blob DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`),
ADD KEY `email` (`email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
Selanjutnya buka file Pasiendetail.php tambahkan extends module role seperti berikut
<?php
class Pasiendetail extends Role
{
Selanjutnya buat file dengan nama Role.php pada folder admin, tambahkan seperti berikut
<?php
class Role
{
public function role_tambah()
{
?>
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Tambah role</h3>
</div>
<form action="<?php htmlentities($_SERVER['REQUEST_URI'])?>" method="post">
<div class="card-body">
<?=$this->success?>
<div class="form-group">
<label>Role name</label>
<input type="text" name="role_name" class="form-control" placeholder="Masukan role name" required="">
</div>
<div class="form-group">
<label>Role alias</label>
<input type="text" name="role_alias" class="form-control" placeholder="Masukan role alias" required="">
</div>
<div class="form-group">
<label>Role Module</label>
<select class="form-control" name="role_module" required="">
<option value="admin">admin</option>
<option valu="dokter">dokter</option>
<option value="perawat">perawat</option>
</select>
</div>
<div class="form-group">
<button type="submit" class="btn btn-md btn-primary">Submit</button>
</div>
</div>
</form>
</div>
<?php
}
public function role_proses()
{
if($_SERVER['REQUEST_METHOD']=='POST')
{
$role_name = $this->app->post('role_name');
$role_alias = $this->app->post('role_alias');
$role_module = $this->app->post('role_module');
if($this->obj->insertTable('users_role','role_name, role_alias, role_module',
':role_name, :role_alias, :role_module',
array(
":role_name"=>$role_name,
":role_alias"=>$role_alias,
":role_module"=>$role_module
)
))
{
$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 role_index()
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Tambah role','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<?=$this->role_proses()?>
<?=$this->role_tambah()?>
</div>
</div>
</div>
</section>
</div>
<?php
}
public function role_table()
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Semua Role','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="card">
<div class="card-header">
<h3 class="card-title">Data semua role</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example2" class="table table-bordered table-striped">
<thead>
<tr>
<th>NO</th>
<th>Role name</th>
<th>Role Alias</th>
<th>Role Module</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$data = $this->obj->pagination('halaman','users_role',10,NULL,'ORDER by role_id DESC');
$data->execute();
while($row=$data->fetch(PDO::FETCH_BOTH))
{
?>
<tr>
<td><?=$no?></td>
<td><?=$row['role_name']?></td>
<td><?=$row['role_alias']?></td>
<td><?=$row['role_module']?></td>
<td>
<a href="?page=role_edit&role_id=<?=$row['role_id']?>"><i class="fas fa-pen"></i></a>
<a href="?page=role_delete&role_id=<?=$row['role_id']?>"><i class="fas fa-trash"></i></a>
</td>
</tr>
<?php $no+=1; } ?>
</tbody>
</table>
</div>
<!-- /.card-body -->
<?php
$this->obj->paginationNumberBootstrap('users_role',10,'page=semua_role','halaman');
?>
</div>
</div>
</section>
</div>
<?php
}
public function role_edit($data)
{
?>
<?php
if($_SERVER['REQUEST_METHOD']=='POST')
{
$role_name = $this->app->post('role_name');
$role_alias = $this->app->post('role_alias');
$role_module = $this->app->post('role_module');
if($this->obj->updateTable('users_role',
'role_name=:role_name,
role_alias=:role_alias,
role_module=:role_module
','role_id=:role_id',
array(
":role_name"=>$role_name,
":role_alias"=>$role_alias,
":role_module"=>$role_module,
":role_id"=>$data['role_id']
)
))
{
$this->success = $this->app->alert('success','Data berhasil disimpan');
$this->app->reload(3,'?page=semua_role');
}
else
{
$this->success = $this->app->alert('danger','Data gagal disimpan');
$this->app->reload(3,'?page=semua_role');
}
}
?>
<div class="col-md-12">
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">Tambah role</h3>
</div>
<form action="<?php htmlentities($_SERVER['REQUEST_URI'])?>" method="post">
<div class="card-body">
<?=$this->success?>
<div class="form-group">
<label>Role name</label>
<input type="text" name="role_name" value="<?=$data['role_name']?>" class="form-control" placeholder="Masukan role name" required="">
</div>
<div class="form-group">
<label>Role alias</label>
<input type="text" name="role_alias" value="<?=$data['role_alias']?>" class="form-control" placeholder="Masukan role alias" required="">
</div>
<div class="form-group">
<label>Role Module</label>
<select class="form-control" name="role_module" required="">
<option value="<?=$data['role_module']?>"><?=$data['role_module']?></option>
<option value="admin">admin</option>
<option value="dokter">dokter</option>
<option value="perawat">perawat</option>
</select>
</div>
<div class="form-group">
<button type="submit" class="btn btn-md btn-primary">Submit</button>
</div>
</div>
</form>
</div>
</div>
<?php
}
public function role_edit_index($get)
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Edit Role','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<?php
if(!$this->obj->getTable('users_role','role_id=:role_id',$get,'role_id'))
{
echo "<div class='col-md-12'>".$this->app->alert('danger','Data tidak ditemukan')."</dic>";
}
else
{
Role::role_edit($this->obj->row);
}
?>
</div>
</div>
</section>
</div>
<?php
}
public function role_delete($get)
{
?>
<div class="content-wrapper">
<?=$this->app->bread('Delete Role','Home','?page=home')?>
<section class="content">
<div class="container-fluid">
<div class="row">
<?php
if(!$this->obj->getTable('users_role','role_id=:role_id',$get,'role_id'))
{
echo "<div class='col-md-12'>".$this->app->alert('danger','Data tidak ditemukan')."</dic>";
}
else
{
if($this->obj->delete('users_role','role_id=:role_id','role_id', $this->obj->row['role_id']))
{
echo $this->app->alert('success col-md-12','Data berhasil dihapus');
$this->app->reload(3,'?page=semua_role');
}
else
{
echo $this->app->alert('danger col-md-12','Data gagal dihapus');
$this->app->reload(3,'?page=semua_role');
}
}
?>
</div>
</div>
</section>
</div>
<?php
}
}
Terakhir tambahkan role module tersebut pada file Runadmin.php, sehingga secara keseluruhan akan terlihat seperti berikut
<?php
class Runadmin
{
public function Moduleadmin($path='')
{
$this->app->getEmpty('page');
$this->themes->head($path);
$this->themes->css($path);
$this->themes->admin_nav_header($path);
$this->themes->admin_sidebar($path);
switch ($this->app->get('page'))
{
case 'home':
$this->crud->dashboard_test();
break;
case 'semua_pasien':
$this->crud->pasien_table_index();
break;
case 'pasien_tambah':
$this->crud->pasien_index();
break;
case 'pasien_edit':
$this->crud->pasien_edit_index($this->app->get('pasien_id'));
break;
case 'pasien_delete':
$this->crud->pasien_delete($this->app->get('pasien_id'));
break;
case 'pasien_riwayat':
$this->crud->pasien_riwayat_table_index($this->app->get('pasien_id'));
$this->crud->pasien_riwayat_modal();
break;
case 'pasien_riwayat_tambah':
$this->crud->pasien_riwayat_index($this->app->get('pasien_id'));
break;
case 'pasien_riwayat_delete':
$this->crud->pasien_riwayat_delete($this->app->get('riwayat_id'));
break;
//role
case 'role_tambah':
$this->crud->role_index();
break;
case 'semua_role':
$this->crud->role_table();
break;
case 'role_edit':
$this->crud->role_edit_index($this->app->get('role_id'));
break;
case 'role_delete':
$this->crud->role_delete($this->app->get('role_id'));
break;
default:
$this->crud->dashboard_test();
break;
}
$this->themes->footer($path);
$this->crud->pasien_riwayat_ajax('app/load/ajax/Detailriwayat.php');
}
}
ada
Selanjutnya : Membuat Aplikasi Klinik #12 - Module Manajemen User
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 #11 - Membuat Module Manajemen Role"
Post a Comment
Komentar yang Anda kirim akan terlebih dahulu di moderasi oleh Admin