function GetPeriodFull($param)
{
$exp = explode("~", $param);
return FormatTanggalShort($exp[0]) . " s/d " . FormatTanggalShort($exp[1]);
}
/**
* Load view
*
* @access public
* @param string $view
* @param mixed $data
* @param boolean $return
* @return void
*/
public function load_view($view, $data = array(), $return = FALSE)
{
// Not include master view on ajax request
if ($this->_ci->input->is_ajax_request()) {
$this->_ci->load->view($view, $data);
return;
}
// Title
if (empty($this->title)) {
$title = $this->brand_name;
} else {
$title = $this->title . $this->title_separator . $this->brand_name;
}
// Description
$description = $this->description;
// Metadata
$metadata = array();
foreach ($this->metadata as $name => $content) {
if (strpos($name, 'og:') === 0) {
$metadata[] = '<meta property="' . $name . '" content="' . $content . '">';
} else {
$metadata[] = '<meta name="' . $name . '" content="' . $content . '">';
}
}
$metadata = implode('', $metadata);
// Javascript
$js = array();
foreach ($this->js as $js_file) {
$js[] = '<script src="' . assets_url($js_file) . '"></script>';
}
$js = implode('', $js);
// CSS
$css = array();
foreach ($this->css as $css_file) {
$css[] = '<link rel="stylesheet" href="' . assets_url($css_file) . '">';
}
$person_id = $this->_ci->session->userdata('person_id');
$data['person_id'] = $person_id;
$data['person_nm'] = getValue('person_nm', 'hris_persons', array('person_id' => 'where/' . $person_id));
if (!$data['person_nm']) {
$data['person_nm'] = "Administrator";
}
$data['person_img'] = file_exists('assets/assets/img/profiles/PICTURE_' . $person_id . '.JPG') ? assets_url('assets/img/profiles/PICTURE_' . $person_id . '.JPG') : assets_url('assets/img/profiles/photo-default.png');
//Inbox
$inbox = 0;
$list_notif = "";
$bawahan = CekBawahan($person_id);
if (count($bawahan) > 0) {
$q = GetAll("kg_view_attendance", array("no_slide" => "where/1", "date_full " => "order/asc", "date_full" => "group"), array("id_employee" => $bawahan));
if ($q->num_rows() > 0) {
foreach ($q->result_array() as $r) {
$inbox++;
$list_notif .= "<a href='" . site_url('dashboard/index_slide/' . $r['date_full']) . "'>\n <div class='notification-messages notification-messages-full info'>\n <div class='message-wrapper'>\n <div class='heading'>Alert - No Slide Attend</div>\n <div class='description'>" . FormatTanggalShort($r['date_full']) . "</div>\n </div>\n <div class='clearfix'></div>\n </div></a>";
}
}
//Overtime///////////////////////////////////////////////////////////
$q = GetAll("kg_view_overtime", array("ovt_status" => "where/Waiting"), array("id_employee" => $bawahan));
foreach ($q->result_array() as $r) {
$inbox++;
$img = GetPP($r['id_employee']);
$list_notif .= "<a href='" . site_url('attendance_form/overtime/' . $r['id']) . "'><div class='notification-messages info'>\n <div class='user-profile'>\n <img src='" . $img . "' width='35' height='35'>\n </div>\n <div class='message-wrapper'>\n <div class='heading'>" . $r['person_nm'] . " - Overtime</div>\n <div class='description'>" . FormatTanggalShort($r['date_full']) . "</div>\n <!--<div class='date pull-left'>A min ago</div>-->\n </div>\n <div class='clearfix'></div>\n </div></a>";
}
//Cuti///////////////////////////////////////////////////////////
$q = GetAll("kg_view_cuti", array("cuti_status" => "where/Waiting"), array("id_employee" => $bawahan));
foreach ($q->result_array() as $r) {
$inbox++;
$img = GetPP($r['id_employee']);
$list_notif .= "<a href='" . site_url('attendance_form/cuti/' . $r['id']) . "'><div class='notification-messages info'>\n <div class='user-profile'>\n <img src='" . $img . "' width='35' height='35'>\n </div>\n <div class='message-wrapper'>\n <div class='heading'>" . $r['person_nm'] . " - Leave</div>\n <div class='description'>" . FormatTanggalShort($r['tgl_start']) . "</div>\n <!--<div class='date pull-left'>A min ago</div>-->\n </div>\n <div class='clearfix'></div>\n </div></a>";
}
}
//die($list_notif);
//OT Notif User Pribadi
$q = GetAll("kg_view_overtime", array("ovt_status" => "where/Approve", "is_read" => "where/0", "create_user_id" => "where/" . $person_id));
foreach ($q->result_array() as $r) {
$inbox++;
$img = GetPP($r['modify_user_id']);
$list_notif .= "<a href='" . site_url('attendance_form/overtime/' . $r['id']) . "'><div class='notification-messages info'>\n <div class='user-profile'>\n <img src='" . $img . "' width='35' height='35'>\n </div>\n <div class='message-wrapper'>\n <div class='heading'>" . strtok(GetValue("person_nm", "hris_persons", array("person_id" => "where/" . $r['modify_user_id'])), " ") . " - Approval Overtime</div>\n <div class='description'>" . FormatTanggalShort($r['date_full']) . "</div>\n <!--<div class='date pull-left'>A min ago</div>-->\n </div>\n <div class='clearfix'></div>\n </div></a>";
}
//Cuti Notif User Pribadi
$q = GetAll("kg_view_cuti", array("cuti_status" => "where/Approve", "is_read" => "where/0", "create_user_id" => "where/" . $person_id));
foreach ($q->result_array() as $r) {
$inbox++;
$img = GetPP($r['modify_user_id']);
$list_notif .= "<a href='" . site_url('attendance_form/cuti/' . $r['id']) . "'><div class='notification-messages info'>\n <div class='user-profile'>\n <img src='" . $img . "' width='35' height='35'>\n </div>\n <div class='message-wrapper'>\n <div class='heading'>" . strtok(GetValue("person_nm", "hris_persons", array("person_id" => "where/" . $r['modify_user_id'])), " ") . " - Approval Leave</div>\n <div class='description'>" . FormatTanggalShort($r['tgl_start']) . "</div>\n <!--<div class='date pull-left'>A min ago</div>-->\n </div>\n <div class='clearfix'></div>\n </div></a>";
}
$data['inbox'] = $inbox;
$data['list_notif'] = $list_notif;
$menu = $this->_ci->uri->segment(1, 0);
$data['active'] = $data['active1'] = $data['active2'] = $data['active3'] = $data['active4'] = "";
switch ($menu) {
case 'dashboard':
$data['active'] = "class='active'";
break;
case 'employee':
$data['active1'] = "class='active'";
break;
case 'attendance':
$data['active2'] = "class='active'";
break;
case 'attendance_form':
$data['active2'] = "class='active'";
break;
case 'config':
$data['active3'] = "class='active'";
break;
case 'report':
$data['active4'] = "class='active'";
break;
default:
${$data}['active1'] = "class='active'";
break;
}
//Sub Menu
$submenu = $this->_ci->uri->segment(2);
$param = $menu . "/" . $submenu;
$data['active_1'] = $data['active_2'] = $data['active_3'] = "";
$data['active2_1'] = $data['active2_2'] = $data['active2_3'] = "";
$data['active3_1'] = $data['active3_2'] = $data['active3_3'] = "";
$data['active4_1'] = $data['active4_2'] = $data['active4_3'] = "";
switch ($param) {
case 'dashboard/index':
$data['active_1'] = "class='active'";
break;
case 'dashboard/index_slide':
$data['active_2'] = "class='active'";
break;
case 'dashboard/overtime':
$data['active_3'] = "class='active'";
break;
case 'attendance/':
$data['active2_1'] = "class='active'";
break;
case 'attendance_form/overtime':
$data['active2_2'] = "class='active'";
break;
case 'config/':
$data['active3_1'] = "class='active'";
break;
case 'config/holiday':
$data['active3_2'] = "class='active'";
break;
case 'config/overtime':
$data['active3_3'] = "class='active'";
break;
default:
${$data}['active3_1'] = "class='active'";
break;
}
$css = implode('', $css);
$header = $this->_ci->load->view('header', $data, TRUE);
$footer = $this->_ci->load->view('footer', array(), TRUE);
$sidebar = $this->_ci->load->view('sidebar', $data, TRUE);
$main_content = $this->_ci->load->view($view, $data, TRUE);
$body = $this->_ci->load->view('layout/' . $this->layout, array('header' => $header, 'footer' => $footer, 'sidebar' => $sidebar, 'main_content' => $main_content), TRUE);
return $this->_ci->load->view('base_view', array('title' => $title, 'description' => $description, 'metadata' => $metadata, 'js' => $js, 'css' => $css, 'body' => $body, 'ga_id' => $this->ga_id), $return);
}
<div class="col-md-6 no-padding">
<label class="form-label"><b>Employee</b></label>
<div class="row">
<div class="col-md-12">
<?php
echo $employee_nm;
?>
</div>
</div>
</div>
<div class="col-md-6 no-padding">
<label class="form-label"><b>Date</b></label>
<div class="row">
<div class="col-md-12">
<?php
echo FormatTanggalShort($tgl);
?>
<input type="hidden" name="date_full" value="<?php
echo $tgl;
?>
">
</div>
</div>
</div>
</div>
</div>
</div>
<?php
} else {
?>
function ajax_list_detail_att($tgl = NULL, $id_emp = NULL)
{
permission();
$this->load->model('attendance_model', 'att');
$param = array("tgl" => $tgl, "id_emp" => $id_emp, "detailz_grafik" => 1);
$list = $this->att->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$shift = GetValue("tgl_" . intval($r->tanggal), "kg_jadwal_shift", array("id_employee" => "where/" . $id_emp, "bulan" => "where/" . $r->bulan, "tahun" => "where/" . $r->tahun));
$edit = '<a class="btn btn-sm btn-primary" href="javascript:void(0);" onclick="editAtt(' . "'" . $r->id . "'" . ', ' . "'" . $tgl . "'" . ')"><i class="glyphicon glyphicon-pencil"></i> Edit</a>';
$data[] = array($no, GetDayName($r->date_full) . ", " . FormatTanggalShort($r->date_full), $r->jh, $r->off, $r->alpa, $r->scan_masuk, $r->scan_pulang, strtoupper($shift));
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->att->count_all($param), "recordsFiltered" => $this->att->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function ajax_list_employee()
{
permission();
$this->load->model('employee_model', 'emp');
$param = array();
$list = $this->emp->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$gender = $r->adm_gender_cd == "m" ? "Male" : "Female";
if (!$r->adm_gender_cd) {
$gender = "-";
}
$edit = '<a class="btn btn-sm btn-primary" href="javascript:void(0);" onclick="detailEmp(' . "'" . $r->person_id . "'" . ')"><i class="glyphicon glyphicon-pencil"></i> Edit</a>';
$data[] = array($no, $r->ext_id, $r->person_nm, $r->group_shift, intval($r->grade), $gender, FormatTanggalShort($r->birth_dttm), $edit);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->emp->count_all($param), "recordsFiltered" => $this->emp->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function ajax_list_cuti_app($tgl = NULL)
{
$webmaster_id = permission();
$this->load->model('cuti_model', 'cuti');
if ($this->session->userdata('person_id') > 1) {
$person_id = $this->session->userdata('person_id');
} else {
$person_id = 0;
}
$param = array("tgl" => $tgl, "approve" => 1, "person_id" => $person_id);
$list = $this->cuti->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
if ($r->cuti_status == "Waiting") {
$cls = "blue";
if ($r->id_employee != $webmaster_id) {
$r->cuti_status = "Waiting Your Approval";
}
} else {
if ($r->cuti_status == "Approve") {
$cls = "green";
} else {
if ($r->cuti_status == "Reject") {
$cls = "red";
}
}
}
$status = '<a class="' . $cls . '" href="javascript:void(0);" onclick="detailCuti(' . "'" . $r->id . "'" . ')">' . $r->cuti_status . '</a>';
$data[] = array($no, FormatTanggalShort($r->tgl_start) . " - " . FormatTanggalShort($r->tgl_end), FormatTanggalShort($r->tgl_start_ref) . " - " . FormatTanggalShort($r->tgl_end_ref), $r->hari, $r->reason, $r->feedback, $status);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->cuti->count_all($param), "recordsFiltered" => $this->cuti->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function ajax_list_detail_ovt($tgl = NULL, $id_emp = NULL)
{
$person_id = permission();
$this->load->model('overtime_model', 'ovt');
$param = array("tgl" => $tgl, "id_emp" => $id_emp, "detailz" => 1);
$list = $this->ovt->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$data[] = array($no, GetDayName($r->date_full) . ", " . FormatTanggalShort($r->date_full), $r->ovt_hour_sum, $r->ovt_flag, $r->ovt_reason, $r->ovt_detail_reason);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->ovt->count_all($param), "recordsFiltered" => $this->ovt->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function ajax_list_holiday($year = NULL)
{
permission();
$this->load->model('config_holiday_model', 'holiday');
$param = array("tahun" => $year);
$list = $this->holiday->get_datatables($param);
$data = array();
$no = $_POST['start'];
foreach ($list->result() as $r) {
$no++;
$edit = '<a class="btn btn-sm btn-primary" href="javascript:void(0);" onclick="editHoliday(' . "'" . $r->id . "'" . ')"><i class="glyphicon glyphicon-pencil"></i> Edit</a>';
$data[] = array($no, GetDayName($r->tanggal) . ", " . FormatTanggalShort($r->tanggal), $r->ket, $edit);
}
$output = array("draw" => $_POST['draw'], "recordsTotal" => $this->holiday->count_all($param), "recordsFiltered" => $this->holiday->count_all($param), "data" => $data);
//output to json format
echo json_encode($output);
}
function export_ovt_full($tgl = NULL, $regs = NULL, $div = NULL, $sec = NULL, $pos = NULL, $grade = NULL)
{
$this->load->model('overtime_model', 'ovt');
$param = array("tgl" => $tgl, "rekap" => "full", "regs" => $regs, "divisi" => $div, "section" => $sec, "position" => $pos, "grade" => $grade);
$exp = explode("~", $tgl);
$list = $this->ovt->get_datatables($param);
$dataz = array();
$no = 0;
//$_POST['start'];
foreach ($list->result() as $r) {
$no++;
$dataz[] = array($no, $r->ext_id, $r->person_nm, GetDayName($r->date_full) . ", " . FormatTanggalShort($r->date_full), Decimal($r->ovt_hour_sum, 1), Decimal($r->ovt_hour_cal), $r->ovt_reason, $r->ovt_detail_reason);
}
$data['list'] = $dataz;
//print_mz($data['list']);
$html = $this->load->view('export_overtime_full', $data);
to_excel($html, 'ReportOvertimeFull');
}
