Controller Home.php
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Home extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->model('M_home');
$this->auth->cek_auth(); //ngambil auth dari library
}
function index(){
$username = $this->session->userdata('user_data');
$tgl = date('Y-m-d');
$antrian = $this->M_home->antrian($tgl)->result();
$data = array(
'username' => $username,
'antrian' => $antrian,
);
$this->load->view('home/v_home',$data);
}
function data_antrian(){
$tgl = date('Y-m-d');
$antrian = $this->M_home->antrian($tgl)->result();
$data = array(
'antrian' => $antrian,
);
$this->load->view('home/v_data',$data);
}
function data_antrians(){
$tgl = date('Y-m-d');
$antrian = $this->M_home->antrian($tgl)->result();
echo "1";
}
}
models M_home.php
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class M_home extends CI_Model
{
function __construct()
{
parent::__construct();
}
function antrian($tgl){
$this->db->from('ambil_antrian');
$this->db->where('a_tgl',$tgl);
$this->db->where('a_status <>','2');
return $this->db->get();
}
}
views (buat sebuah folder dengan nama home didalam folder views) buat nama file dengan nama v_home.php
<html>
<head>
<title>Sistem Antrian | Login</title>
<link rel="stylesheet" href="<?php echo base_url();?>bootstrap/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-md-12">
<h1>Selamat Datang <?php echo $username;?><span style="float:right;"><a href="<?php echo base_url('login/logout');?>" class="btn btn-danger">Logout</a></span></h1>
<div id="data_antrian"></div>
</div>
</div>
</div>
</body>
<script src="<?php echo base_url();?>bootstrap/js/jquery.min.js"></script>
</html>
<script>
setInterval(function(){
$("#data_antrian").load('<?php echo base_url("home/data_antrian")?>')
}, 1000);
</script>
dan v_data.php didalam folder home (views/home)
<table class="table table-bordered table-hover">
<tr>
<th>No.</th>
<th>Nomor Panggil</th>
<th>Panggil</th>
<th>Selesai</th>
</tr>
<?php if(!empty($antrian)){
$no = 1;
foreach($antrian as $antri){
if($antri->a_status == '0'){
$panggil = 'Panggil';
$warna = 'btn btn-success';
}else{
$panggil = 'Panggil Ulang';
$warna = 'btn btn-warning';
}
?>
<tr>
<td><?php echo $no++;?></td>
<td><?php echo $antri->a_nomor;?></td>
<td><a href="<?php echo base_url('home/proses/'.$antri->a_nomor.'/'.$antri->a_tgl);?>" class="<?php echo $warna;?>"><?php echo $panggil;?></a>
</td>
<td><a href="<?php echo base_url('home/delete/'.$antri->a_nomor.'/'.$antri->a_tgl);?>" class="btn btn-danger">Hapus</a></td>
</tr>
<?php } ?>
<?php } ?>
</table>
