Bismillahirrahmanirrahim
Berikut adalah update dari source code sebelumnya, yang perlu di update hanya beberapa code saja, diantaranya
views v_antrian_depan.php (application/tray_app/antrian_depan/views)
<?php
$fav = $this->db->query("SELECT gambar FROM tbl_pengaturan WHERE id = 7")->row()->gambar;
$sistem = $this->db->query("SELECT * FROM tbl_pengaturan WHERE id = 14")->row();
$instansi = $this->db->query("SELECT * FROM tbl_pengaturan WHERE id = 11")->row();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title><?php echo $sistem->judul.' | '.$sistem->deskripsi;?></title>
<!-- Tell the browser to be responsive to screen width -->
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<!--=================================================================-->
<link rel="icon" type="image/png" href="<?php echo base_url('img/'.$fav);?>"/>
<!--=================================================================-->
<link rel="stylesheet" href="<?php echo base_url('bootstrap4/css/bootstrap.min.css');?>">
<link rel="stylesheet" href="<?php echo base_url();?>bower_components/font-awesome/css/font-awesome.min.css">
</head>
<body>
<div class="container">
<h1 align="center">SELAMAT DATANG DI PTSP<br/>
<?php echo strtoupper($instansi->keterangan);?></h1>
<hr/>
<div class="row" style="text-align: center;">
<form class="col-md alert btn-lg btn-info" action="<?php echo $link_informasi;?>" method="POST">
<input type="hidden" name="ad_jenis_id" value="1">
<button type="submit" class="col-md alert btn-lg btn-info" style="height: 300px;color:white;">
<b style="font-size:30px;">MEJA<br/>INFORMASI</b><br/><br/>
<i class="fa fa-info-circle" style="font-size:40px;"></i><br/><br/>
<div class="btn btn-lg btn-block btn-danger">AMBIL ANTRIAN</div>
</button>
</form>
<form class="col-md alert btn-lg btn-success" action="<?php echo $link_pendaftaran;?>" method="POST">
<input type="hidden" name="ad_jenis_id" value="2">
<button class="col-md alert btn-lg btn-success" style="height: 300px;color:white;">
<b style="font-size:30px;">PENDAFTARAN<br/>PERKARA</b><br/><br/>
<i class="fa fa-book" style="font-size:40px;"></i><br/><br/>
<a href="#" class="btn btn-lg btn-block btn-warning" style="color:white;">AMBIL ANTRIAN</a>
</button>
</form>
<form class="col-md alert btn-lg btn-warning" action="<?php echo $link_produk;?>" method="POST">
<input type="hidden" name="ad_jenis_id" value="3">
<button class="col-md alert btn-lg btn-warning" style="height: 300px;color:white;">
<b style="font-size:30px;">PRODUK<br/>PENGADILAN</b><br/><br/>
<i class="fa fa-file" style="font-size:40px;"></i><br/><br/>
<a href="#" class="btn btn-lg btn-block btn-success">AMBIL ANTRIAN</a>
</button>
</form>
<form class="col-md alert btn-lg btn-danger" action="<?php echo $link_pengaduan;?>" method="POST">
<input type="hidden" name="ad_jenis_id" value="4">
<button class="col-md alert btn-lg btn-danger" style="height: 300px;color:white;">
<b style="font-size:30px;">LAYANAN<br/>PENGADUAN</b><br/><br/>
<i class="fa fa-ticket" style="font-size:40px;"></i><br/><br/>
<a href="#" class="btn btn-lg btn-block btn-info">AMBIL ANTRIAN</a>
</button>
</form>
</div>
<hr/>
</div> <!-- end container -->
</body>
</html>
dan controllers Antrian_depan.php (application/tray_app/antrian_depan/controllers)
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Antrian_depan extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->model('Antrian_depan_model');
}
public function index()
{
$data = array(
'link_informasi' => site_url('antrian_depan/informasi'),
'link_pengaduan' => site_url('antrian_depan/pengaduan'),
'link_pendaftaran' => site_url('antrian_depan/pendaftaran'),
'link_produk' => site_url('antrian_depan/produk'),
);
$this->load->view('antrian_depan/v_antrian_depan',$data);
}
public function get_nomor($jenis_id){
$tahun = date("Y");
$bulan = date("m");
$hari = date("d");
$query = $this->db->query("SELECT MAX(ad_nomor) as max_id FROM tbl_antrian_depan where YEAR(ad_tgl)='$tahun' AND MONTH(ad_tgl) = '$bulan' AND DAY(ad_tgl) = $hari AND ad_jenis_id = $jenis_id ");
$row = $query->row_array();
$max_id = $row['max_id'];
$max_id1 =(int) substr($max_id,0,3);
$nomor = $max_id1 +1;
$maxkode = sprintf("%03s",$nomor);
return $maxkode;
}
public function get_sisa_antrian($jenis_id){
$tahun = date("Y");
$bulan = date("m");
$hari = date("d");
$query = $this->db->query("SELECT count(ad_id) as sisa FROM tbl_antrian_depan where YEAR(ad_tgl)='$tahun' AND MONTH(ad_tgl) = '$bulan' AND DAY(ad_tgl) = $hari AND ad_jenis_id = $jenis_id ");
$sisa = $query->row()->sisa;
return $sisa;
}
public function cetak_antrian(){
$row = $this->Antrian_depan_model->get_data_cetak();
if ($row) {
$data = array(
'row' => $row,
);
$this->load->view('antrian_depan/v_cetak_antrian',$data);
}else{
redirect(site_url('antrian_depan'));
}
}
//06-01-2019//
public function informasi()
{
$ad_jenis_id = $this->input->post('ad_jenis_id',TRUE);
$ad_jenis_nama = 'MEJA INFORMASI';
if (empty($ad_jenis_id) OR $ad_jenis_id == '') {
$this->index();
} else {
$data = array(
'ad_nomor' => $this->get_nomor(1),
'ad_nomor_panggil' => 'A'.$this->get_nomor(1),
'ad_jenis_id' => $this->input->post('ad_jenis_id',TRUE),
'ad_jenis_nama' => $ad_jenis_nama,
'ad_tgl' => date('Y-m-d H:i:s'),
'ad_status' => '1',
'ad_ke' => '',
'ad_sisa_antrian' => $this->get_sisa_antrian(1),
);
$this->Antrian_depan_model->insert($data);
redirect(site_url('antrian_depan/cetak_antrian'));
}
}
public function pendaftaran()
{
$ad_jenis_id = $this->input->post('ad_jenis_id',TRUE);
$ad_jenis_nama = 'PENDAFTARAN PERKARA';
if (empty($ad_jenis_id) OR $ad_jenis_id == '') {
$this->index();
} else {
$data = array(
'ad_nomor' => $this->get_nomor(2),
'ad_nomor_panggil' => 'B'.$this->get_nomor(2),
'ad_jenis_id' => $this->input->post('ad_jenis_id',TRUE),
'ad_jenis_nama' => $ad_jenis_nama,
'ad_tgl' => date('Y-m-d H:i:s'),
'ad_status' => '1',
'ad_ke' => '',
'ad_sisa_antrian' => $this->get_sisa_antrian(2),
);
$this->Antrian_depan_model->insert($data);
redirect(site_url('antrian_depan/cetak_antrian'));
}
}
public function produk()
{
$ad_jenis_id = $this->input->post('ad_jenis_id',TRUE);
$ad_jenis_nama = 'PRODUK PENGADILAN';
if (empty($ad_jenis_id) OR $ad_jenis_id == '') {
$this->index();
} else {
$data = array(
'ad_nomor' => $this->get_nomor(3),
'ad_nomor_panggil' => 'C'.$this->get_nomor(3),
'ad_jenis_id' => $this->input->post('ad_jenis_id',TRUE),
'ad_jenis_nama' => $ad_jenis_nama,
'ad_tgl' => date('Y-m-d H:i:s'),
'ad_status' => '1',
'ad_ke' => '',
'ad_sisa_antrian' => $this->get_sisa_antrian(3),
);
$this->Antrian_depan_model->insert($data);
redirect(site_url('antrian_depan/cetak_antrian'));
}
}
public function pengaduan()
{
$ad_jenis_id = $this->input->post('ad_jenis_id',TRUE);
$ad_jenis_nama = 'LAYANAN PENGADUAN';
if (empty($ad_jenis_id) OR $ad_jenis_id == '') {
$this->index();
} else {
$data = array(
'ad_nomor' => $this->get_nomor(4),
'ad_nomor_panggil' => 'D'.$this->get_nomor(4),
'ad_jenis_id' => $this->input->post('ad_jenis_id',TRUE),
'ad_jenis_nama' => $ad_jenis_nama,
'ad_tgl' => date('Y-m-d H:i:s'),
'ad_status' => '1',
'ad_ke' => '',
'ad_sisa_antrian' => $this->get_sisa_antrian(4),
);
$this->Antrian_depan_model->insert($data);
redirect(site_url('antrian_depan/cetak_antrian'));
}
}
}
selamat mencoba
