?>
</div>
<div class="col-md-9"><?php
echo form_dropdown('bulan', GetOptMonth(), $s_bulan, "class='col-md-8'");
?>
</div>
</div>
</div>
<div class="col-md-3">
<div class="row">
<div class="col-md-3 search_label"><?php
echo form_label('Tahun', 'tahun');
?>
</div>
<div class="col-md-9"><?php
echo form_dropdown('tahun', GetOptYear(), $s_tahun, "class='col-md-8'");
?>
</div>
</div>
</div>
<div class="col-md-2">
<div class="row">
<div class="col-md-12">
<button type="submit" class="btn btn-info"><i class="icon-search"></i> <?php
echo lang('search_button');
?>
</button>
</div>
</div>
</div>
</div>
function detail($user = "******", $tgl = "0000-00-00", $dep = "0", $shift = "0", $status = "0")
{
$data['user'] = $user;
//$data['path_file'] = $this->filename.'_user_migrasi';
$data['path_file'] = $this->filename . '_user';
$data['main_content'] = $data['path_file'];
$data['filename'] = $this->filename;
$data['title'] = $this->title;
//if($user == 0 && $tgl == "0000-00-00" && !$this->uri->segment(5)) $tgl = date("Y-m-d");
$data['tgl'] = $tgl;
$exp = explode("~", $tgl);
$data['tgl_today'] = $exp[0];
if ($exp[0] != "0000-00-00") {
$data['start_date'] = $exp[0];
if (!isset($exp[1])) {
$data['end_date'] = $exp[0];
} else {
if (!$exp[1]) {
$data['end_date'] = $exp[0];
} else {
$data['end_date'] = $exp[1];
}
}
} else {
$data['start_date'] = $data['end_date'] = "";
}
$data['shift'] = $shift;
/* Mazhters */
if ($exp[0] == date("Y-m-d")) {
$tabel_view = "kg_view_kehadiran_rutin";
} else {
$tabel_view = "kg_view_kehadiran_mcci";
}
/* End Mazhters */
$path_paging = base_url() . $this->filename . "/main/" . $user . "/" . $tgl . "/" . $dep . "/" . $shift . "/" . $status;
$uri_segment = 8;
$pg = $this->uri->segment($uri_segment);
/*riza*/
$filter = array($tabel_view . ".tahun" => "order/asc", $tabel_view . ".bulan" => "order/asc", $tabel_view . ".tanggal" => "order/asc");
$per_page = 500;
//End Global
$filter_where_in = array();
$data['opt_pic'] = GetOptPIC();
$data['opt_pic'][''] = "";
$data['opt_dep'] = GetOptDepartment();
//$data['opt_dep'][''] = "";
$data['opt_tgl'] = GetOptDate();
$data['opt_bln'] = GetOptMonth();
$data['opt_thn'] = GetOptYear();
$exp = explode("-", $exp[0]);
if (!isset($exp[0])) {
$exp[0] = "";
}
if (!isset($exp[1])) {
$exp[1] = "";
}
if (!isset($exp[2])) {
$exp[2] = "";
}
//if($exp[2] > 0) $filter = array("tahun"=> "order/asc", "bulan"=> "order/asc", "tanggal"=> "order/asc");
//else $filter = array("id_employee"=> "order/asc", "tahun"=> "order/asc", "bulan"=> "order/asc", "tanggal"=> "order/asc");
if ($status) {
/*if($status == "alpa2")
{
$kemarin = date("Y-m-d", mktime(0, 0, 0, $exp[1], $exp[2]-1, $exp[0]));
$exp_alpa = explode("-", $kemarin);
$filter["alpa"] = "where/1";
}
else */
if ($status == "jh") {
$filter['terlambat !='] = "where/1";
}
$filter[$status] = "where/1";
}
$kondisi = "";
if ($status == "alpa2") {
$tgl_alpa = array($exp[2], $exp_alpa[2]);
$filter_where_in['tanggal'] = $tgl_alpa;
$bln_alpa = array($exp[1], $exp_alpa[1]);
$filter_where_in['bulan'] = $bln_alpa;
$thn_alpa = array($exp[0], $exp_alpa[0]);
$filter_where_in['tahun'] = $thn_alpa;
} else {
if ($data['start_date'] == $data['end_date']) {
if ($exp[0] > 0) {
$filter[$tabel_view . '.tahun'] = "where/" . $exp[0];
$data['title'] = $this->title . " ( " . $exp[0] . " )";
if ($exp[1] > 0) {
$filter[$tabel_view . '.bulan'] = "where/" . $exp[1];
$data['title'] = $this->title . " ( " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
if ($exp[2] > 0) {
$filter[$tabel_view . '.tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
}
} else {
if ($exp[1] > 0) {
$exp[0] = date("Y");
$filter['tahun'] = "where/" . $exp[0];
$filter['bulan'] = "where/" . $exp[1];
$data['title'] = $this->title . " ( " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
if ($exp[2] > 0) {
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
} else {
if ($exp[2] > 0) {
$exp[0] = date("Y");
$exp[1] = date("m");
$filter['tahun'] = "where/" . $exp[0];
$filter['bulan'] = "where/" . $exp[1];
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
}
}
}
}
if ($dep) {
/*$ex = explode("-",$dep);
$dep=array();
foreach($ex as $r)
{
$dep[] = $r;
}
$filter_where_in['id_department'] = $dep;*/
$filter['id_department'] = "where/" . $dep;
}
//else $dep=array();
if ($user) {
$temp_user = $user;
$ex = explode("-", $user);
$user = array();
foreach ($ex as $r) {
$user[] = $r;
}
$filter_where_in['id_employee'] = $user;
$user = $temp_user;
}
//else $user=array();
$data['spic'] = $user;
$data['sdep'] = $dep;
/*$data['stgl'] = $exp[2];
$data['sbln'] = $exp[1];
$data['sthn'] = $exp[0];*/
//Grup Admin
$id_grup = $this->session->userdata("webmaster_grup");
$where = "";
if ($id_grup == 4) {
$filter['nik'] = "where/-";
}
//else if($id_grup == 3) $filter['urut_position <'] = "where/40";
//else if($id_grup == 2) $filter['urut_position >='] = "where/40";
//End
//$filter['urut_position'] = "order/asc";
$filter[$tabel_view . '.id_employee'] = "order/asc";
//if(count($user) > 0 || $exp[2] > 0)
if ($exp[2] > 0 && $data['start_date'] == $data['end_date'] || $user) {
$data['emp'] = GetAll("hris_persons", array("person_id" => "where/" . $user));
$data['flag_tgl'] = 1;
$data['grid'] = array("Date", "Hadir", "OFF", "Cuti", "Ijin", "Sick", "Alpa", "Late", "In", "Out", "Shift", "Description");
$data['list'] = array("tgl", "jh", "off", "cuti", "ijin", "sakit", "alpa", "terlambat", "scan_masuk", "scan_pulang", "shift", "keterangan");
if ($data['start_date']) {
$filter['date_full >='] = "where/" . $data['start_date'];
$filter['date_full <='] = "where/" . $data['end_date'];
}
if ($shift) {
//if($shift == "p") $where_shift = " (kg_jadwal_shift.tgl_".intval($exp[2])."='".$shift."' || kg_jadwal_shift.tgl_".intval($exp[2])."='ns')";
if ($shift == "p") {
$where_shift = " (kg_jadwal_shift.tgl_" . intval($exp[2]) . "!='s' && kg_jadwal_shift.tgl_" . intval($exp[2]) . "!='m')";
} else {
$where_shift = " kg_jadwal_shift.tgl_" . intval($exp[2]) . "='" . $shift . "' ";
}
$data['query_all'] = GetJoin($tabel_view, "jadwal_shift", "kg_jadwal_shift.id_employee=" . $tabel_view . ".id_employee and kg_jadwal_shift.bulan='" . $exp[1] . "' and kg_jadwal_shift.tahun='" . $exp[0] . "' and {$where_shift}", "inner", "*", $filter, $filter_where_in);
$filter['limit'] = $pg . "/" . $per_page;
$data['query_list'] = GetJoin($tabel_view, "jadwal_shift", "kg_jadwal_shift.id_employee=" . $tabel_view . ".id_employee and kg_jadwal_shift.bulan='" . $exp[1] . "' and kg_jadwal_shift.tahun='" . $exp[0] . "' and {$where_shift}", "inner", "*," . $tabel_view . ".id as id_k", $filter, $filter_where_in);
} else {
$data['query_all'] = GetAll($tabel_view, $filter, $filter_where_in);
$filter['limit'] = $pg . "/" . $per_page;
$data['query_list'] = GetAll($tabel_view, $filter, $filter_where_in);
}
} else {
if ($data['start_date']) {
$filter['date_full >='] = "where/" . $data['start_date'];
$filter['date_full <='] = "where/" . $data['end_date'];
}
$data['flag_tgl'] = 0;
$data['grid'] = array("Nama Karyawan", "JHK", "Hadir", "OFF", "Cuti", "PHL", "Ijin", "Sakit", "Alpa", "Potong Gaji", "Pulang Cepat");
$data['list'] = array("person_nm", "jhk", "jh", "off", "cuti", "phl", "ijin", "sakit", "alpa", "potong_gaji", "pc");
/*if($exp[1] > 0) $filter['group'] = array("employee.id","bulan","tahun");
elseif($exp[0] > 0) $filter['group'] = array("employee.id","tahun");
else */
//$filter['group'] = array("employee.id","tahun");
$filter['id_employee'] = "group";
//else $filter['group'] = array("employee.id");
/*$select = "employee.id as a_id,employee.name, kg_attendance.id, SUM(kg_attendance.jhk) as jhk, SUM(kg_attendance.sakit) as sakit,
SUM(kg_attendance.cuti) as cuti,SUM(kg_attendance.ijin) as ijin,,SUM(kg_attendance.alpa) as alpa,SUM(kg_attendance.off) as off,
SUM(kg_attendance.potong_gaji) as potong_gaji, SUM(kg_attendance.pc) as pc,SUM(kg_attendance.jh) as jh";
$data['query_all'] = GetJoin("employee","attendance","attendance.id_employee=employee.id ".$kondisi, "left", $select, $filter, $filter_where_in);*/
$select = "id, person_nm, id_employee as a_id, SUM(jhk) as jhk, SUM(sakit) as sakit,\n SUM(cuti) as cuti,SUM(ijin) as ijin,SUM(phl) as phl,SUM(alpa) as alpa,SUM(off) as off,\n SUM(potong_gaji) as potong_gaji, SUM(pc) as pc, SUM(jh) as jh";
$data['query_all'] = GetAllSelect($tabel_view, $select, $filter);
//lastq();
$filter['limit'] = $pg . "/" . $per_page;
//$data['query_list'] = GetJoin("employee","attendance","attendance.id_employee=employee.id ".$kondisi, "left", $select, $filter, $filter_where_in);
$data['query_list'] = GetAllSelect($tabel_view, $select, $filter);
//die($this->db->last_query());
}
if (!$this->uri->segment(3) && !$this->uri->segment(4) && !$this->uri->segment(5)) {
$data['dis_tgl'] = "display:none;";
} else {
$data['dis_tgl'] = "display:''";
}
//Page
$pagination = Page($data['query_all']->num_rows(), $per_page, $pg, $path_paging, $uri_segment);
if (!$pagination) {
$pagination = "<strong>1</strong>";
}
$data['pagination'] = $pagination;
//End Page
$this->_render_page($this->filename . '_detail', $data);
}
function overtime($user = "******", $tgl = "0000-00-00", $dep = "0", $status = "0")
{
//Set Global
permission();
$data['filename'] = 'overtime';
$data['title'] = 'Overtime';
//if($user == 0 && $tgl == "0000-00-00" && !$this->uri->segment(5)) $tgl = date("Y-m-d");
$data['tgl'] = $tgl;
$exp = explode("~", $tgl);
if ($exp[0] != "0000-00-00") {
$data['start_date'] = $exp[0];
if (!isset($exp[1])) {
$data['end_date'] = $exp[0];
} else {
if (!$exp[1]) {
$data['end_date'] = $exp[0];
} else {
$data['end_date'] = $exp[1];
}
}
} else {
$data['start_date'] = $data['end_date'] = "";
}
$path_paging = base_url() . $this->filename . "/main/" . $user . "/" . $tgl . "/" . $dep . "/" . $status;
$uri_segment = 7;
$pg = $this->uri->segment($uri_segment);
$per_page = 15;
//End Global
$filter_where_in = array();
$data['opt_pic'] = GetOptPIC();
$data['opt_pic'][''] = "";
$data['opt_dep'] = GetOptDepartment();
//$data['opt_dep'][''] = "";
$data['opt_tgl'] = GetOptDate();
$data['opt_bln'] = GetOptMonth();
$data['opt_thn'] = GetOptYear();
$exp = explode("-", $exp[0]);
if (!isset($exp[0])) {
$exp[0] = "";
}
if (!isset($exp[1])) {
$exp[1] = "";
}
if (!isset($exp[2])) {
$exp[2] = "";
}
//if($exp[2] > 0) $filter = array("tahun"=> "order/asc", "bulan"=> "order/asc", "tanggal"=> "order/asc");
//else $filter = array("id_employee"=> "order/asc", "tahun"=> "order/asc", "bulan"=> "order/asc", "tanggal"=> "order/asc");
//Grup Admin
$id_grup = $this->session->userdata("webmaster_grup");
if ($id_grup == 3) {
$filter['urut_position <'] = "where/40";
}
if ($status) {
/*if($status == "alpa2")
{
$kemarin = date("Y-m-d", mktime(0, 0, 0, $exp[1], $exp[2]-1, $exp[0]));
$exp_alpa = explode("-", $kemarin);
$filter["alpa"] = "where/1";
}
else */
if ($status == "jh") {
$filter['terlambat !='] = "where/1";
}
$filter[$status] = "where/1";
}
$kondisi = "";
if ($status == "alpa2") {
$tgl_alpa = array($exp[2], $exp_alpa[2]);
$filter_where_in['tanggal'] = $tgl_alpa;
$bln_alpa = array($exp[1], $exp_alpa[1]);
$filter_where_in['bulan'] = $bln_alpa;
$thn_alpa = array($exp[0], $exp_alpa[0]);
$filter_where_in['tahun'] = $thn_alpa;
} else {
if ($data['start_date'] == $data['end_date']) {
if ($exp[0] > 0) {
$filter['tahun'] = "where/" . $exp[0];
$data['title'] = $this->title . " ( " . $exp[0] . " )";
if ($exp[1] > 0) {
$filter['bulan'] = "where/" . $exp[1];
$data['title'] = $this->title . " ( " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
if ($exp[2] > 0) {
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
}
} else {
if ($exp[1] > 0) {
$exp[0] = date("Y");
$filter['tahun'] = "where/" . $exp[0];
$filter['bulan'] = "where/" . $exp[1];
$data['title'] = $this->title . " ( " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
if ($exp[2] > 0) {
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
} else {
if ($exp[2] > 0) {
$exp[0] = date("Y");
$exp[1] = date("m");
$filter['tahun'] = "where/" . $exp[0];
$filter['bulan'] = "where/" . $exp[1];
$filter['tanggal'] = "where/" . $exp[2];
$data['title'] = $this->title . " ( " . $exp[2] . " " . GetMonth(intval($exp[1])) . " " . $exp[0] . " )";
}
}
}
}
}
if ($dep) {
/*$ex = explode("-",$dep);
$dep=array();
foreach($ex as $r)
{
$dep[] = $r;
}
$filter_where_in['id_department'] = $dep;*/
$filter['id_department'] = "where/" . $dep;
}
//else $dep=array();
if ($user) {
$temp_user = $user;
$ex = explode("-", $user);
$user = array();
foreach ($ex as $r) {
$user[] = $r;
}
$filter_where_in['id_employee'] = $user;
$user = $temp_user;
if ($data['start_date']) {
$filter['date_full >='] = "where/" . $data['start_date'];
$filter['date_full <='] = "where/" . $data['end_date'];
}
}
//else $user=array();
$data['spic'] = $user;
$data['sdep'] = $dep;
/*$data['stgl'] = $exp[2];
$data['sbln'] = $exp[1];
$data['sthn'] = $exp[0];*/
$filter['name'] = "order/asc";
$filter['lembur'] = "where/1";
//if(count($user) > 0 || $exp[2] > 0)
if ($exp[2] > 0 && $data['start_date'] == $data['end_date'] || $user) {
$data['flag_tgl'] = 1;
$data['grid'] = array("Nama Karyawan", "Tanggal", "OT. Incidental", "Kelebihan Jam Kerja", "Tunjangan Hari Kerja", "Alasan Lembur", "Scan Masuk", "Scan Pulang", "Keterangan");
$data['list'] = array("id_employee", "tgl", "ot_incidental", "ot_allow_shift", "ot_cont_allow", "alasan_lembur", "scan_masuk", "scan_pulang", "keterangan");
if ($status == "alpa2") {
$sql = "select * from kg_view_kehadiran where tanggal='" . $exp[2] . "' AND bulan='" . $exp[1] . "' AND tahun='" . $exp[0] . "' AND alpa='1'\n AND id_employee in (select id_employee from kg_view_kehadiran where tanggal='" . $exp_alpa[2] . "' AND bulan='" . $exp_alpa[1] . "' AND tahun='" . $exp_alpa[0] . "' AND alpa='1')";
$data['query_all'] = $this->db->query($sql);
if (!$pg) {
$pg = 0;
}
$data['query_list'] = $this->db->query($sql . " LIMIT {$pg}, {$per_page}");
} else {
$data['query_all'] = GetAll("kg_view_kehadiran", $filter, $filter_where_in);
$filter['limit'] = $pg . "/" . $per_page;
$data['query_list'] = GetAll("kg_view_kehadiran", $filter, $filter_where_in);
//lastq();
}
} else {
/*$temp = $filter['id_employee'];
unset($filter['id_employee']);
$filter['id_employee'] = $temp;
$temp = $filter['tanggal'];
unset($filter['tanggal']);
$filter['tanggal'] = $temp;
$temp = $filter['bulan'];
unset($filter['bulan']);
$filter['bulan'] = $temp;
$temp = $filter['tahun'];
unset($filter['tahun']);
if($temp == "order/asc") $temp = "where/".date("Y");
$filter['tahun'] = $temp;*/
if ($data['start_date']) {
$filter['date_full >='] = "where/" . $data['start_date'];
$filter['date_full <='] = "where/" . $data['end_date'];
}
$data['flag_tgl'] = 0;
$data['grid'] = array("Nama Karyawan", "Overtime", "OT. Incidental", "Kelebihan Jam Kerja", "Tunjangan Hari Kerja");
$data['list'] = array("name", "jhk", "ot_incidental", "ot_allow_shift", "ot_cont_allow");
/*if($exp[1] > 0) $filter['group'] = array("employee.id","bulan","tahun");
elseif($exp[0] > 0) $filter['group'] = array("employee.id","tahun");
else */
//$filter['group'] = array("employee.id","tahun");
$filter['id_employee'] = "group";
//else $filter['group'] = array("employee.id");
/*$select = "employee.id as a_id,employee.name, kg_kehadirandetil.id, SUM(kg_kehadirandetil.jhk) as jhk, SUM(kg_kehadirandetil.sakit) as sakit,
SUM(kg_kehadirandetil.cuti) as cuti,SUM(kg_kehadirandetil.ijin) as ijin,,SUM(kg_kehadirandetil.alpa) as alpa,SUM(kg_kehadirandetil.off) as off,
SUM(kg_kehadirandetil.potong_gaji) as potong_gaji, SUM(kg_kehadirandetil.pc) as pc,SUM(kg_kehadirandetil.jh) as jh";
$data['query_all'] = GetJoin("employee","kehadirandetil","kehadirandetil.id_employee=employee.id ".$kondisi, "left", $select, $filter, $filter_where_in);*/
$select = "id, name, id_employee as a_id, SUM(jhk) as jhk, SUM(ot_incidental) as ot_incidental,\n SUM(ot_allow_shift) as ot_allow_shift,SUM(ot_cont_allow) as ot_cont_allow";
$data['query_all'] = GetAllSelect("kg_view_kehadiran", $select, $filter);
//lastq();
$filter['limit'] = $pg . "/" . $per_page;
//$data['query_list'] = GetJoin("employee","kehadirandetil","kehadirandetil.id_employee=employee.id ".$kondisi, "left", $select, $filter, $filter_where_in);
$data['query_list'] = GetAllSelect("kg_view_kehadiran", $select, $filter);
//die($this->db->last_query());
}
if (!$this->uri->segment(3) && !$this->uri->segment(4) && !$this->uri->segment(5)) {
$data['dis_tgl'] = "display:none;";
} else {
$data['dis_tgl'] = "display:''";
}
//Page
$pagination = Page($data['query_all']->num_rows(), $per_page, $pg, $path_paging, $uri_segment);
if (!$pagination) {
$pagination = "<strong>1</strong>";
}
$data['pagination'] = $pagination;
//End Page
$this->load->view('overtime', $data);
}
