Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- defined('BASEPATH') or exit('No direct script access allowed');
- class Dashboard extends CI_Controller
- {
- public function __construct()
- {
- parent::__construct();
- $this->load->library('form_validation');
- $this->load->library('datatables');
- $this->load->library('src/Toastr');
- $this->load->model('Dashboard_model','Dashboard', TRUE);
- set_zone();
- if ($this->session->userdata('role_id') !== '1') {
- $this->toastr->error('Please Login to Continue !!!');
- redirect('login');
- }
- }
- public function index()
- {
- $join = array(
- ['tbl_status', 'tbl_pegawai.id_status=tbl_status.id', 'LEFT']
- );
- $data = [
- 'titles' => "Dashboard Administrator || Dashboard Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'ShowData' => $this->Dashboard->viewGlobalJoinGroupOrder(
- '
- count(tbl_pegawai.nama_pegawai) AS tot,
- tbl_status.status
- ',
- 'tbl_pegawai',
- $join,
- 'status',
- 'status')->result_array(),
- 'dashboard' => true,
- 'breadcumb' => "Dashboard",
- 'view' => "v_Dashboard"
- ];
- $this->load->view("index", $data);
- }
- // View Profile User
- public function profuser($id = 0)
- {
- if ($id !== '0') {
- $data = [
- 'titles' => "Dashboard Administrator",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', decrypt_url($id))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'profile' => true,
- 'breadcumb' => "Profile",
- 'view' => "v_Profuser"
- ];
- $this->load->view("index", $data);
- }else{
- redirect('Dashboard.html','refresh');
- }
- }
- // Edit Profile User
- public function Profedit()
- {
- $id = $this->session->userdata('id');
- $this->form_validation->set_rules("name", "Administrator Name", "trim|min_length[5]|required");
- if ($this->form_validation->run() == false) {
- $this->profuser($id);
- } else {
- $input = [
- 'users_name' => htmlspecialchars($this->input->post('nama_admin')),
- 'password' => password_hash($this->input->post('password'),PASSWORD_BCRYPT)
- ];
- if ($this->Dashboard->update('tbl_users', 'id_users', $id, $input)) {
- helper_log('edit', $this->session->userdata('username').' Successfully Updated Profile !!!');
- $this->toastr->success('Username : ' . $input['name'] . ' Successfully Updated Profile !!!');
- redirect('Dashboard.html');
- }
- }
- }
- // Start Pengaturan Aplikasi //
- // View Settings Website Page
- public function Settings()
- {
- $data = [
- 'titles' => "Dashboard Administrator || Dashboard Settings Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'dashboard' => true,
- 'breadcumb' => "Dashboard",
- 'view' => "v_Setting"
- ];
- $this->load->view("index", $data);
- }
- // Action Update Web Setting
- public function ActionEditWebSetting($id=0)
- {
- if($id!=0){
- $this->form_validation->set_rules("name", "Name", "trim|min_length[5]|required");
- if ($this->form_validation->run() == false) {
- $this->Settings(1);
- } else {
- $update = [
- 'aplication_name' => htmlentities($this->input->post('name'))
- ];
- // Update Into Database
- if ($this->Dashboard->update('tbl_setting', 'id_setting', 1, $update)) {
- $this->toastr->success('Success Update Setting Website Success !!');
- helper_log('edit', $this->session->userdata('username').' Successfully Updated Setting Website !!!');
- redirect('Dashboard.html','refresh');
- }
- }
- }
- }
- // View Pengaturan No Absensi ASN
- public function AbsensiASN()
- {
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View No Absensi ASN Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'absensiasn' => true,
- 'breadcumb' => "View No Absensi ASN",
- 'view' => "v_AbsensiASN"
- ];
- $this->load->view("index", $data);
- }
- // Json View Datatable No ASN Absen
- public function jsonASN()
- {
- $join = array(
- ['tbl_pegawai', 'tbl_pegawai.userid_machines=tbl_no_absen.userid', 'LEFT'],
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- header('Content-Type: application/json');
- echo $this->Dashboard->jsonGlobalJoin(
- '
- tbl_no_absen.id_no_absen,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.id_jabatan,
- tbl_jabatan.nama_jabatan,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_no_absen',
- $join
- );
- }
- // Action No Absen ASN
- public function ActionNoAbsenASN()
- {
- $data = [
- 'userid' => htmlentities($this->input->post('id_pegawai'))
- ];
- if($this->Dashboard->insert('tbl_no_absen', $data)){
- helper_log('add', $this->session->userdata('username').' Successfully Inserted Data No ASN Absen !!!','Inserted No Absen ASN');
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Inserted Data No ASN Absen !!!','Inserted Data No Absen ASN !!!');
- redirect('No-Asn-Absen.html', 'refresh');
- }
- }
- // View Edit No Absensi ASN
- public function EditAbsensiASN($id=0)
- {
- if($id!=0){
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Edit No Absensi ASN Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'EditData' => $this->Dashboard->viewWhere('tbl_no_absen','id_no_absen',$id)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'apel' => true,
- 'breadcumb' => "View Edit No Absensi ASN",
- 'view' => "v_EditNoAbsen"
- ];
- $this->load->view("index", $data);
- }
- }
- // Action Edit No Absensi ASN
- public function ActionEditAbsensiASN()
- {
- $id = htmlentities($this->input->post('idEdit'));
- if($id!=0){
- $update = [
- 'userid' => htmlentities($this->input->post('id_pegawai'))
- ];
- if($this->Dashboard->update('tbl_no_absen', 'id_no_absen', $id, $update)){
- helper_log('edit', $this->session->userdata('username').' Successfully Edit Data No Absen ASN ID = '.$id.' !!!','Edit Data No Absen ASN ID = '.$id);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Edit Data No Absen ASN!!!','Updated Data No Absen ASN !!!');
- redirect('No-Asn-Absen.html', 'refresh');
- }
- }
- }
- // Action Delete No Absensi ASN
- public function DeleteAbsensiASN($id=0)
- {
- if($id!=0){
- if($this->Dashboard->delete('id_no_absen', 'tbl_no_absen', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete No Absen ASN ID = '.$id.' !!!','Delete No Absen ASN ID = '.$id);
- $this->toastr->error('Username = ' . $this->session->userdata('username') . ' Successfully Delete No Absen ASN ID = '.$id.' !!!','Delete NO Absen ASN ID = '.$id. ' !!!');
- redirect('No-Asn-Absen.html', 'refresh');
- }
- }
- }
- // Website Setting
- public function Setting()
- {
- $setting = $this->Dashboard->viewAll('*', 'tbl_setting')->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Website Setting Pages",
- 'title' => 'Update Setting',
- 'settings' => $this->Dashboard->viewWhere('tbl_setting','id_setting', 1)->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users', 'id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'breadcumb' => 'Website Setting',
- 'view' => "v_Setting"
- ];
- $this->load->view("index", $data);
- }
- // Action Edit Setting
- public function ActionSetting()
- {
- $update = [
- 'application_name' => htmlentities($this->input->post('application_name'))
- // 'address' => htmlentities($this->input->post('address')),
- // 'phone_number' => htmlentities($this->input->post('phone_number')),
- // 'host' => htmlentities($this->input->post('host')),
- // 'email' => htmlentities($this->input->post('email')),
- // 'password' => htmlentities($this->input->post('password_email')),
- // 'facebook' => htmlentities($this->input->post('facebook')),
- // 'website' => htmlentities($this->input->post('website')),
- ];
- if($this->Dashboard->update('tbl_setting', 'id_setting', 1, $update)){
- // Active Auth Acces
- // $active = htmlentities($this->input->post('switch'));
- // if($active === 'on'){
- // $data = [
- // 'status_auth' => '1'
- // ];
- // }else{
- // $data = [
- // 'status_auth' => '0'
- // ];
- // }
- // // Update Status
- // if($this->Dashboard->update('tbl_auth', 'id_auth', 1, $data)){
- $this->toastr->success('Username = '.$this->session->userdata('username').' Update Setting Application Successfuly !!!');
- helper_log('edit', $this->session->userdata('username').' Update Setting Applications ', 'Account Username = '.$this->session->userdata('username').' Successfuly Update Seettings Applications');
- redirect('Setting.html','refresh');
- // }
- }
- }
- // End Pengaturan Aplikasi //
- public function Synchronize()
- {
- // At start of script
- $time_start = microtime(true);
- $join = array(
- ['template', 'userinfo.userid=template.userid', 'LEFT']
- );
- $cek = $this->Dashboard->viewAll2('*','userinfo')->result_array();
- $cekLocal = $this->Dashboard->viewAll('*','tbl_pegawai')->result_array();
- // $cek = $this->Dashboard->viewGlobalJoin2(
- // '
- // userinfo.badgenumber AS badgenumber,
- // userinfo.name AS name,
- // userinfo.userid AS userid,
- // template.Template AS fingerprint
- // ',
- // 'userinfo',
- // $join)->result_array();
- if(empty($cekLocal)){
- // If Empty
- foreach ($cek as $row) {
- $this->db->trans_start();
- $data = [
- 'nama_pegawai' => $row['name'],
- // 'template' => $row['fingerprint'],
- 'badge_number' => $row['badgenumber'],
- 'userid_machines' => $row['userid']
- ];
- $this->Dashboard->insert('tbl_pegawai', $data);
- if ($this->db->trans_status() === FALSE){
- $this->db->trans_rollback();
- }else{
- $this->db->trans_commit();
- }
- $this->db->trans_complete();
- }
- }else{
- $cekLastData = $this->Dashboard->lastData('*','tbl_pegawai', 'id_pegawai')->result_array();
- // Get Data From userinfo
- $getUserInfo = $this->Dashboard->viewWhereAssosiative2('*','tbl_pegawai',['badge_number >' => $cekLastData[0]['badge_number']])->result_array();
- foreach ($getUserInfo as $row) {
- $this->db->trans_start();
- $data = [
- 'nama_pegawai' => $row['name'],
- 'badge_number' => $row['badgenumber'],
- 'userid_machines' => $row['userid']
- ];
- $this->Dashboard->insert('tbl_pegawai', $data);
- if ($this->db->trans_status() === FALSE){
- $this->db->trans_rollback();
- }else{
- $this->db->trans_commit();
- }
- $this->db->trans_complete();
- }
- }
- $time_end = microtime(true);
- echo 'Total execution time in seconds: ' . (microtime(true) - $time_start);
- }
- public function getLogAttandences()
- {
- // At start of script
- $time_start = microtime(true);
- $cek = $this->Dashboard->viewAll2('*','checkinout')->result_array();
- $cekLocal = $this->Dashboard->viewAll('*','tbl_absensi')->result_array();
- if(empty($cekLocal)){
- // If Empty
- foreach ($cek as $row) {
- $this->db->trans_start();
- $data = [
- 'id_machines' => $row['SN'],
- 'userid_machines' => $row['userid'],
- 'checktime' => $row['checktime'],
- 'checktype' => $row['checktype'],
- 'verifycode' => $row['verifycode'],
- 'sensorid' => $row['sensorid']
- ];
- $this->Dashboard->insert('tbl_absensi', $data);
- if ($this->db->trans_status() === FALSE){
- $this->db->trans_rollback();
- }else{
- $this->db->trans_commit();
- }
- $this->db->trans_complete();
- }
- }else{
- $cekLastData = $this->Dashboard->lastData('*','tbl_absensi', 'id_absensi')->result_array();
- // Get Data From userinfo
- $getUserInfo = $this->Dashboard->viewWhereAssosiative2('*','tbl_absensi',['userid_machines >' => $cekLastData[0]['userid_machines']])->result_array();
- foreach ($getUserInfo as $row) {
- $this->db->trans_start();
- $data = [
- 'id_machines' => $row['SN'],
- 'userid_machines' => $row['userid'],
- 'checktime' => $row['checktime'],
- 'checktype' => $row['checktype'],
- 'verifycode' => $row['verifycode'],
- 'sensorid' => $row['sensorid']
- ];
- $this->Dashboard->insert('tbl_absensi', $data);
- if ($this->db->trans_status() === FALSE){
- $this->db->trans_rollback();
- }else{
- $this->db->trans_commit();
- }
- $this->db->trans_complete();
- }
- }
- $time_end = microtime(true);
- echo 'Total execution time in seconds: ' . (microtime(true) - $time_start);
- }
- // View Admin Unit
- public function AdminUnit()
- {
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $data = [
- 'titles' => "Dashboard Administrator || View Admin Unit Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewAll('*','tbl_pegawai')->result_array(),
- 'adminUnit' => $this->Dashboard->viewAll(
- '
- *
- ',
- 'tbl_jabatan'
- )->result_array(),
- 'adminunit' => true,
- 'breadcumb' => "View Admin Unit",
- 'view' => "v_AdminUnit"
- ];
- $this->load->view("index", $data);
- }
- // Json View Datatable Admin Unit
- public function jsonAdminUnit()
- {
- header('Content-Type: application/json');
- echo $this->Dashboard->jsonWhereAsso(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.id_jabatan
- ',
- 'tbl_pegawai',
- );
- }
- // View Add Admin Unit
- public function AddAdminUnit()
- {
- $data = [
- 'titles' => "Dashboard Administrator || View Add Admin Unit Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'addadminunit' => true,
- 'breadcumb' => "View Add Admin Unit",
- 'view' => "v_AddAdminUnit"
- ];
- $this->load->view("index", $data);
- }
- // Action Add Admin Unit
- public function ActionAddAdminUnit()
- {
- $id_pegawai = htmlentities($this->input->post('id_pegawai'));
- $update = [
- // 'id_jabatan' => htmlentities($this->input->post('id_jabatan'))
- // 'id_jabatan' => 6
- ];
- if($this->Dashboard->update('tbl_pegawai', 'id_pegawai', $id_pegawai, $update)){
- helper_log('edit', $this->session->userdata('username').' Successfully Add Admin Unit ID '.$id_pegawai.' Successfully !!!');
- $this->toastr->success('Username : ' . $this->session->userdata('username') . ' Add Admin Unit ID '.$id_pegawai.' Successfully !!!');
- redirect('AdminUnit.html', 'refresh');
- }
- }
- // Action Delete Admin Unit
- public function ActionDeleteAdminUnit($id=0)
- {
- if($id!=0){
- $update = [
- 'id_jabatan' => 0
- ];
- if($this->Dashboard->update('tbl_pegawai', 'id_pegawai', $id, $update)){
- helper_log('edit', $this->session->userdata('username').' Successfully Add Admin Unit ID '.$id.' Successfully !!!');
- $this->toastr->success('Username : ' . $this->session->userdata('username') . ' Add Admin Unit ID '.$id.' Successfully !!!');
- redirect('AdminUnit.html', 'refresh');
- }
- }
- }
- // Make Account Admin Unit
- public function ActionMakeAccountAdminUnit($id=0)
- {
- if($id!=0){
- // Check id_pegawai sudah ada di tbl_users belum
- $check = $this->Dashboard->viewWhere('tbl_pegawai','id_pegawai',$id)->result_array();
- // Check Account
- $checkAccount = $this->Dashboard->viewWhereAssosiative('*','tbl_users', ['userid' => $check[0]['userid_machines']]);
- if($checkAccount->num_rows !== 0){
- $username = $check[0]['nip'];
- }else{
- $username = '';
- }
- if($checkAccount->num_rows() === 0){
- $jdArray = $checkAccount->result_array();
- // Make Account
- $data = [
- 'userid' => $check[0]['userid_machines'],
- 'users_name' => $check[0]['nama_pegawai'],
- 'username' => $username,
- 'password' => password_hash('123456', PASSWORD_BCRYPT),
- 'role_id' => 2
- ];
- if($this->Dashboard->insert('tbl_users', $data)){
- helper_log('add', $this->session->userdata('username').' Successfully Add Account Admin Unit For '.$data['users_name'].' Successfully!!!');
- $this->toastr->success('Username : ' . $this->session->userdata('username') . ' Successfully Add Account Admin Unit For '.$data['user_name'].' Successfully!!!');
- }
- redirect('AdminUnit.html', 'refresh');
- }else{
- $this->toastr->error('Account Alraedy Exist !!!');
- redirect('AdminUnit.html', 'refresh');
- }
- }
- }
- // View Izin
- public function ViewIzin()
- {
- $cekPerangkat = $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array();
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoinWhere(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- ['tbl_pegawai.userid_machines' => $cekPerangkat[0]['userid']],
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Izin Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'izin' => true,
- 'breadcumb' => "View Izin List",
- 'view' => "v_IzinList"
- ];
- $this->load->view("index", $data);
- }
- // Json View Datatable Izin
- public function jsonIzin()
- {
- $join = array(
- ['tbl_pegawai', 'tbl_pegawai.userid_machines=tbl_cuti.userid', 'LEFT'],
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- header('Content-Type: application/json');
- echo $this->Dashboard->jsonGlobalJoin(
- '
- tbl_cuti.id_cuti,
- tbl_cuti.tgl_pengajuan_cuti,
- tbl_cuti.tanggal_cuti,
- tbl_cuti.keterangan,
- tbl_cuti.dokumen,
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.id_jabatan,
- tbl_jabatan.nama_jabatan,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_cuti',
- $join
- );
- }
- // View Add Izin
- public function AddIzin()
- {
- $cekPerangkat = $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array();
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoinWhere(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- ['tbl_pegawai.userid_machines' => $cekPerangkat[0]['userid']],
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Add Izin Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'izin' => true,
- 'breadcumb' => "View Add Izin",
- 'view' => "v_AddIzin"
- ];
- $this->load->view("index", $data);
- }
- // Action Delete Izin
- public function DeleteIzin($id=0)
- {
- if($id!=0){
- // Get Images
- $checkCuti = $this->Dashboard->viewWhere('tbl_cuti','id_cuti',$id)->result_array(); // $checkCuti[0]['dokumen']
- $getImages = $checkCuti[0]['dokumen'];
- $path = 'document/izin/'.$getImages;
- if(file_exists($path)){
- unlink($path);
- if($this->Dashboard->delete('id_cuti', 'tbl_cuti', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete Izin Cuti = '.$id.' !!!','Delete Izin Cuti ID = '.$id);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Delete Izin Cuti ID = '.$id.' !!!','Delete Izin Cuti ID = '.$id. ' !!!');
- redirect('ViewIzinAdm.html', 'refresh');
- }
- }else{
- if($this->Dashboard->delete('id_cuti', 'tbl_cuti', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete Izin Cuti = '.$id.' !!!','Delete Izin Cuti ID = '.$id);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Delete Izin Cuti ID = '.$id.' !!!','Delete Izin Cuti ID = '.$id. ' !!!');
- redirect('ViewIzinAdm.html', 'refresh');
- }
- }
- }
- }
- // Action Add Izin
- public function ActionAddIzin()
- {
- $dokumen = $_FILES['dokumen'];
- $begin = new DateTime($this->input->post('dari'));
- $end = new DateTime($this->input->post('sampai'));
- $end = $end->modify('+1 day');
- $interval = new DateInterval('P1D'); //referensi : https://en.wikipedia.org/wiki/ISO_8601#Durations
- $daterange = new DatePeriod($begin, $interval ,$end);
- if($dokumen['name'] !== ''){
- $config['upload_path'] = './document/izin';
- $config['allowed_types'] = 'jpg|png|jpeg';
- $config['max_size'] = 5048;
- $config['file_name'] = 'Izin-' . date('Y-m-d');
- $this->load->library('upload', $config);
- $this->upload->initialize($config);
- if (!$this->upload->do_upload('dokumen')) {
- $this->toastr->warning('Failed to Upload Document, Make Sure the format is PNG or JPEG or JPG and Size 2 mb !!');
- redirect('ViewIzinAdm.html','refresh');
- } else {
- foreach ($daterange as $date) {
- $data = [
- 'tgl_pengajuan_cuti' => date('Y-m-d'),
- 'tanggal_cuti' => $date->format("Y-m-d"),
- 'userid' => htmlentities($this->input->post('id_pegawai')),
- 'keterangan' => htmlentities($this->input->post('keterangan')),
- 'dokumen' => $this->upload->data('file_name')
- ];
- $this->Dashboard->insert('tbl_cuti', $data);
- }
- helper_log('add', $this->session->userdata('username').' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']. ' !!!');
- redirect('ViewIzinAdm.html', 'refresh');
- }
- }else{
- foreach ($daterange as $date) {
- $data = [
- 'tgl_pengajuan_cuti' => date('Y-m-d'),
- 'tanggal_cuti' => $date->format("Y-m-d"),
- 'userid' => htmlentities($this->input->post('id_pegawai')),
- 'keterangan' => htmlentities($this->input->post('keterangan'))
- ];
- $this->Dashboard->insert('tbl_cuti', $data);
- }
- helper_log('add', $this->session->userdata('username').' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']. ' !!!');
- redirect('ViewIzinAdm.html', 'refresh');
- }
- }
- // View SPT
- public function ViewSPT()
- {
- $cekPerangkat = $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array();
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoinWhere(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- ['tbl_pegawai.userid_machines' => $cekPerangkat[0]['userid']],
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View SPT List Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'spt' => true,
- 'breadcumb' => "View SPT List",
- 'view' => "v_SPTList"
- ];
- $this->load->view("index", $data);
- }
- // Json View Datatable SPT
- public function jsonSPT()
- {
- $join = array(
- ['tbl_pegawai', 'tbl_pegawai.userid_machines=tbl_spt.userid', 'LEFT'],
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- header('Content-Type: application/json');
- echo $this->Dashboard->jsonGlobalJoin(
- '
- tbl_spt.id_spt,
- tbl_spt.tanggal_pengajuan,
- tbl_spt.tanggal,
- tbl_spt.kota_tujuan,
- tbl_spt.keterangan,
- tbl_spt.dokumen,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.id_jabatan,
- tbl_jabatan.nama_jabatan,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_spt',
- $join
- );
- }
- // View Add SPT
- public function AddSPT()
- {
- $cekPerangkat = $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array();
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoinWhere(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- ['tbl_pegawai.userid_machines' => $cekPerangkat[0]['userid']],
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Add SPT Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'spt' => true,
- 'breadcumb' => "View Add SPT",
- 'view' => "v_AddSPT"
- ];
- $this->load->view("index", $data);
- }
- // Action Add SPT
- public function ActionAddSPT()
- {
- $dokumen = $_FILES['dokumen'];
- $begin = new DateTime($this->input->post('dari'));
- $end = new DateTime($this->input->post('sampai'));
- $end = $end->modify('+1 day');
- $interval = new DateInterval('P1D'); //referensi : https://en.wikipedia.org/wiki/ISO_8601#Durations
- $daterange = new DatePeriod($begin, $interval ,$end);
- if($dokumen['name'] !== ''){
- $config['upload_path'] = './document/spt';
- $config['allowed_types'] = 'jpg|png';
- $config['max_size'] = 2048;
- $config['file_name'] = 'SPT-' . date('Y-m-d');
- $this->load->library('upload', $config);
- $this->upload->initialize($config);
- if (!$this->upload->do_upload('dokumen')) {
- $this->toastr->warning('Failed to Upload Document, Make Sure the format is PNG or JPEG or JPG and Size 2 mb !!');
- redirect('ViewSPTAdm.html','refresh');
- } else {
- foreach ($daterange as $date) {
- $data = [
- 'tanggal_pengajuan' => date('Y-m-d'),
- 'tanggal' => $date->format("Y-m-d"),
- 'userid' => htmlentities($this->input->post('id_pegawai')),
- 'kota_tujuan' => htmlentities($this->input->post('kota')),
- 'keterangan' => htmlentities($this->input->post('keterangan')),
- 'dokumen' => $this->upload->data('file_name')
- ];
- $this->Dashboard->insert('tbl_spt', $data);
- }
- helper_log('add', $this->session->userdata('username').' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']. ' !!!');
- redirect('ViewSPTAdm.html', 'refresh');
- }
- }else{
- foreach ($daterange as $date) {
- $data = [
- 'tanggal_pengajuan' => date('Y-m-d'),
- 'tanggal' => $date->format("Y-m-d"),
- 'userid' => htmlentities($this->input->post('id_pegawai')),
- 'kota_tujuan' => htmlentities($this->input->post('kota')),
- 'keterangan' => htmlentities($this->input->post('keterangan'))
- ];
- $this->Dashboard->insert('tbl_spt', $data);
- }
- helper_log('add', $this->session->userdata('username').' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Add Izin Cuti = '.$data['userid'].' !!!','Add Izin USERID '.$data['userid']. ' !!!');
- redirect('ViewSPTAdm.html', 'refresh');
- }
- }
- // Action Delete SPT
- public function DeleteSPT($id=0)
- {
- if($id!=0){
- // Get Images
- $checkSpt = $this->Dashboard->viewWhere('tbl_spt','id_spt',$id)->result_array(); // $checkSpt[0]['dokumen']
- $getImages = $checkSpt[0]['dokumen'];
- $path = 'document\spt/'.$getImages;
- if(file_exists($path)){
- unlink($path);
- if($this->Dashboard->delete('id_spt', 'tbl_spt', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete SPT ID = '.$id.' !!!','Delete SPT ID = '.$id);
- $this->toastr->error('Username = ' . $this->session->userdata('username') . ' Successfully Delete SPT ID = '.$id.' !!!','Delete SPT ID = '.$id. ' !!!');
- redirect('ViewSPTAdm.html', 'refresh');
- }
- }else{
- if($this->Dashboard->delete('id_spt', 'tbl_spt', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete SPT = '.$id.' !!!','Delete SPT ID = '.$id);
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Delete Izin SPT ID = '.$id.' !!!','Delete SPT ID = '.$id. ' !!!');
- redirect('ViewSPTAdm.html', 'refresh');
- }
- }
- }
- }
- public function ViewApel()
- {
- $cekPerangkat = $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array();
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoinWhere(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- ['tbl_pegawai.userid_machines' => $cekPerangkat[0]['userid']],
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Apel List Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'apel' => true,
- 'breadcumb' => "View Apel List",
- 'view' => "v_ApelList"
- ];
- $this->load->view("index", $data);
- }
- // Json View Datatable Apel
- public function jsonApel()
- {
- $join = array(
- ['tbl_pegawai', 'tbl_pegawai.userid_machines=tbl_apel_pagi.userid', 'LEFT'],
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- header('Content-Type: application/json');
- echo $this->Dashboard->jsonGlobalJoin(
- '
- tbl_apel_pagi.id_apel_pagi,
- tbl_apel_pagi.tanggal,
- tbl_apel_pagi.keterangan,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.id_jabatan,
- tbl_jabatan.nama_jabatan,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_apel_pagi',
- $join
- );
- }
- // View Add Apel
- public function AddApel()
- {
- $cekPerangkat = $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array();
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $cekPegawai = $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array();
- $data = [
- 'titles' => "Dashboard Administrator || View Add Apel Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'apel' => true,
- 'breadcumb' => "View Add Apel",
- 'view' => "v_AddApel"
- ];
- $this->load->view("index", $data);
- }
- // Action Add Apel
- public function ActionAddApel()
- {
- $data = [
- 'tanggal' => date('Y-m-d'),
- 'userid' => htmlentities($this->input->post('id_pegawai')),
- 'keterangan' => htmlentities($this->input->post('keterangan'))
- ];
- if($this->Dashboard->insert('tbl_apel_pagi', $data)){
- helper_log('add', $this->session->userdata('username').' Successfully Inserted Data Apel Pagi '.json_encode($data, true).' !!!','Inserted Add Apel pagi data = '.json_encode($data, true));
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Inserted Data Apel Pagi !!!','Inserted Data Apel Pagi !!!');
- redirect('ViewApel.html', 'refresh');
- }
- }
- // View Edit Apel
- public function EditApel($id=0)
- {
- if($id!=0){
- $join = array(
- ['tbl_jabatan', 'tbl_pegawai.id_jabatan=tbl_jabatan.id_jabatan', 'LEFT'],
- ['tbl_perangkat', 'tbl_jabatan.id_perangkat=tbl_perangkat.id_perangkat', 'LEFT']
- );
- $data = [
- 'titles' => "Dashboard Administrator || View Edit Apel Pages",
- 'settings' => $this->Dashboard->viewAll('*','tbl_setting')->result_array(),
- 'user' => $this->Dashboard->viewWhere('tbl_users','id_users', $this->session->userdata('id'))->result_array(),
- 'version' => $this->Dashboard->viewWhere('tbl_version','id_version', 1)->result_array(),
- 'EditData' => $this->Dashboard->viewWhere('tbl_apel_pagi','id_apel_pagi',$id)->result_array(),
- 'pegawai' => $this->Dashboard->viewGlobalJoin(
- '
- tbl_pegawai.id_pegawai,
- tbl_pegawai.nama_pegawai,
- tbl_pegawai.userid_machines,
- tbl_perangkat.id_perangkat,
- tbl_perangkat.nama_perangkat
- ',
- 'tbl_pegawai',
- $join)->result_array(),
- 'apel' => true,
- 'breadcumb' => "View Edit Apel",
- 'view' => "v_EditApel"
- ];
- $this->load->view("index", $data);
- }
- }
- // Action Edit Apel Pagi
- public function ActionEditApel()
- {
- $id = htmlentities($this->input->post('idEdit'));
- if($id!=0){
- $update = [
- 'tanggal' => htmlentities($this->input->post('tanggal')),
- 'userid' => htmlentities($this->input->post('id_pegawai')),
- 'keterangan' => htmlentities($this->input->post('keterangan'))
- ];
- if($this->Dashboard->update('tbl_apel_pagi', 'id_apel_pagi', $id, $update)){
- helper_log('edit', $this->session->userdata('username').' Successfully Edit Data Apel ID = '.$id.' With Data = '.json_encode($update, true).' !!!','Edit Data Apel Pagi ID = '.$id.' with data = '.json_encode($update, true));
- $this->toastr->success('Username = ' . $this->session->userdata('username') . ' Successfully Edit Data Apel Pagi!!!','Inserted Data Apel Pagi!!!');
- redirect('ViewApel.html', 'refresh');
- }
- }
- }
- // Action Delete Apel
- public function DeleteApel($id=0)
- {
- if($id!=0){
- if($this->Dashboard->delete('id_apel_pagi', 'tbl_apel_pagi', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete Apel ID = '.$id.' !!!','Delete Apel ID = '.$id);
- $this->toastr->error('Username = ' . $this->session->userdata('username') . ' Successfully Delete Apel ID = '.$id.' !!!','Delete SPT ID = '.$id. ' !!!');
- redirect('ViewApel.html', 'refresh');
- }
- }else{
- if($this->Dashboard->delete('id_apel_pagi', 'tbl_apel_pagi', $id)){
- helper_log('delete', $this->session->userdata('username').' Successfully Delete Apel ID = '.$id.' !!!','Delete Apel ID = '.$id);
- $this->toastr->error('Username = ' . $this->session->userdata('username') . ' Successfully Delete Apel ID = '.$id.' !!!','Delete SPT ID = '.$id. ' !!!');
- redirect('ViewApel.html', 'refresh');
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement