function form_absen($id = null)
{
$sess_id = $this->session->userdata('user_id');
if (!empty(is_have_subordinate(get_nik($sess_id)))) {
$sub_id = get_subordinate($sess_id);
} else {
$sub_id = '';
}
if (!empty(is_have_subsubordinate($sess_id))) {
$subsub_id = 'OR ' . get_subsubordinate($sess_id);
} else {
$subsub_id = '';
}
$this->db->select('absen.*, absen.id as id, absen.date_tidak_hadir as date, users.username as name,keterangan_absen.id as keterangan_id, keterangan_absen.title as keterangan_absen');
$this->db->from('users_keterangan_absen as absen');
$this->db->join('users', 'users.id = absen.user_id', 'LEFT');
$this->db->join('comp_session', 'absen.id_comp_session = comp_session.id', 'LEFT');
$this->db->join('keterangan_absen', 'absen.keterangan_id = keterangan_absen.id', 'LEFT');
if ($id != null) {
$this->db->where('absen.id', $id);
}
$this->db->where("(absen.user_id= {$sess_id} {$sub_id} {$subsub_id} )", null, false);
$this->db->where('absen.is_deleted', 0);
$q = $this->db->get();
return $q;
}
function form_training($id = null)
{
$sess_id = $this->session->userdata('user_id');
if (!empty(is_have_subordinate(get_nik($sess_id)))) {
$sub_id = get_subordinate($sess_id);
} else {
$sub_id = '';
}
$this->db->select('training.*, training.id as id,users.nik as nik, users.username as name,penyelenggara.title as penyelenggara, pembiayaan.title as pembiayaan,
status_lv1.title as approval_status_lv1,
status_lv2.title as approval_status_lv2');
$this->db->from('users_training as training');
$this->db->join('users', 'users.id = training.user_id', 'LEFT');
$this->db->join('penyelenggara', 'training.penyelenggara_id = penyelenggara.id', 'LEFT');
$this->db->join('pembiayaan', 'training.pembiayaan_id = pembiayaan.id', 'LEFT');
$this->db->join('approval_status as status_lv1', 'training.approval_status_id_lv1 = status_lv1.id', 'left');
$this->db->join('approval_status as status_lv2', 'training.approval_status_id_lv2 = status_lv2.id', 'left');
if ($id != null) {
$this->db->where('training.id', $id);
}
$this->db->where('training.is_deleted', 0);
$this->db->where("(training.user_id= {$sess_id} {$sub_id})", null, false);
$q = $this->db->get();
return $q;
}
function form_exit($id = null)
{
$sess_id = $this->session->userdata('user_id');
if (!empty(is_have_subordinate(get_nik($sess_id)))) {
$sub_id = get_subordinate($sess_id);
} else {
$sub_id = '';
}
$admin = $this->ion_auth->is_admin() || $this->ion_auth->is_admin_bagian();
//$this->db->select('users_exit.id as id, users_exit.user_id, exit_type.title as exit_type, users_exit.date_exit, users_exit.created_on as date_created, users_exit.is_app,users_exit.user_app, users_exit.date_app,users_exit.note_app, users_exit.is_app_mgr, users_exit.user_app_mgr, users_exit.date_app_mgr, users_exit.is_app_koperasi, users_exit.user_app_koperasi, users_exit.date_app_koperasi,users_exit.is_app_perpus, users_exit.user_app_perpus, users_exit.date_app_perpus,users_exit.is_app_hrd, users_exit.user_app_hrd, users_exit.date_app_hrd, users_exit_inventaris.*, users_exit_rekomendasi.*');
$this->db->select('users_exit.*, exit_type.title as exit_type');
$this->db->from('users_exit');
$this->db->join('users', 'users.id = users_exit.user_id', 'LEFT');
$this->db->join('exit_type', 'users_exit.exit_type_id = exit_type.id', 'LEFT');
$this->db->where('users_exit.is_deleted', 0);
if ($admin != 1) {
$this->db->where("(users_exit.user_id= {$sess_id} {$sub_id})", null, false);
}
if ($id != null) {
$this->db->where('users_exit.id', $id);
}
$this->db->where('is_purposed', 1);
//$this->db->where('users_exit.user_id', $sess_id);
$this->db->order_by('users_exit.id', 'desc');
$q = $this->db->get();
return $q;
}
function index($bulan = 'bln', $tahun = "thn", $sort_by = "id", $sort_order = "asc", $offset = 0)
{
if (!$this->ion_auth->logged_in()) {
//redirect them to the login page
redirect('auth/login', 'refresh');
} else {
$sess_id = $this->session->userdata('user_id');
$sess_nik = get_nik($sess_id);
$s_bulan = substr($bulan, 3);
if ($s_bulan) {
$filter['bulan'] = "where/" . $s_bulan;
}
$this->data['s_bulan'] = $s_bulan;
$filter = array();
$s_tahun = substr($tahun, 3);
if ($s_tahun) {
$filter['tahun'] = "where/" . $s_tahun;
}
$this->data['s_tahun'] = $s_tahun;
$month = $bulan !== 'bln' ? '/MONTH/' . substr($bulan, 3) : 'bln';
$year = $tahun !== 'thn' ? '/YEAR/' . substr($tahun, 3) : 'thn';
if ($bulan === 'bln' && $tahun === 'thn') {
$url = get_api_key() . 'attendance/user/EMPLID/' . $sess_nik . '/format/json';
//print_mz($url);
} elseif ($tahun === 'thn') {
$url = get_api_key() . 'attendance/user/EMPLID/' . $sess_nik . $month . '/format/json';
//print_mz($url);
} elseif ($bulan === 'bln') {
$url = get_api_key() . 'attendance/user/EMPLID/' . $sess_nik . $year . '/format/json';
//print_mz($url);
} else {
$url = get_api_key() . 'attendance/user/EMPLID/' . $sess_nik . $month . $year . '/format/json';
}
$headers = get_headers($url);
$response = substr($headers[0], 9, 3);
if ($response != "404") {
$get_user_attendance = file_get_contents($url);
$this->data['user_att'] = $user_attendance = json_decode($get_user_attendance, true);
} else {
$this->data['user_att'] = '';
}
$this->_render_page('attendance_axapta/index', $this->data);
}
}
function get_user_atasan()
{
$id = $this->session->userdata('user_id');
$pos_group = get_pos_group(get_nik($id));
$url = get_api_key() . 'users/superior/EMPLID/' . get_nik($id) . '/format/json';
$url_atasan_satu_bu = get_api_key() . 'users/atasan_by_posgroup/EMPLID/' . get_nik($id) . '/format/json';
$headers = get_headers($url);
$headers2 = get_headers($url_atasan_satu_bu);
$response = substr($headers[0], 9, 3);
$response2 = substr($headers2[0], 9, 3);
//$url_atasan_satu_bu = get_api_key().'users/atasan_satu_bu/EMPLID/'.get_nik($id).'/format/json';
if ($pos_group == 'AMD' || $pos_group == 'DIR' || $pos_group == 'KACAB' || $pos_group == 'MGR' || $pos_group == 'ASM') {
if ($response != "404") {
$get_atasan = file_get_contents($url);
$atasan = json_decode($get_atasan, true);
$get_atasan2 = file_get_contents($url_atasan_satu_bu);
$atasan2 = json_decode($get_atasan2, true);
$atasan3 = array_merge($atasan, $atasan2);
return $this->data['user_atasan'] = $atasan3;
} elseif ($response == "404" && $response2 != "404") {
$get_atasan = file_get_contents($url_atasan_satu_bu);
$atasan = json_decode($get_atasan, true);
return $this->data['user_atasan'] = $atasan;
} else {
return $this->data['user_atasan'] = '- Karyawan Tidak Memiliki Atasan -';
}
} else {
if ($response != "404") {
$get_atasan = file_get_contents($url);
$atasan = json_decode($get_atasan, true);
return $this->data['user_atasan'] = $atasan;
} elseif ($response == "404" && $response2 != "404") {
$get_atasan = file_get_contents($url_atasan_satu_bu);
$atasan = json_decode($get_atasan, true);
return $this->data['user_atasan'] = $atasan;
} else {
return $this->data['user_atasan'] = '- Karyawan Tidak Memiliki Atasan -';
}
}
}
function user($action = NULL, $id = NULL)
{
$this->load->model('users_model');
$this->load->model('institusi_model');
$action = xss_clean($action);
$id = xss_clean(intval($id));
$page = isset($_POST['page']) ? $_POST['page'] : 1;
$rp = isset($_POST['rp']) ? $_POST['rp'] : 10;
$sortname = isset($_POST['sortname']) ? $_POST['sortname'] : '';
$sortorder = isset($_POST['sortorder']) ? $_POST['sortorder'] : '';
$query = isset($_POST['query']) ? $_POST['query'] : false;
$qtype = isset($_POST['qtype']) ? $_POST['qtype'] : false;
if ($sortname != "") {
$sort = "ORDER BY {$sortname} {$sortorder}";
}
$start = ($page - 1) * $rp;
$limit = "LIMIT {$start}, {$rp}";
$query = $this->db->query("select * from users {$sort} {$limit}");
//$getData = $this->users_model->get_data();
$getData = $query->result();
$totalData = $query->num_rows();
$result = array('page' => $page, 'total' => $totalData, 'rows' => array());
if ($totalData > 0) {
$i = 1;
foreach ($getData as $r) {
$kode = $r->ID_USER;
$dataCell = array('id' => $kode, 'cell' => array('seq' => $i + $start, 'id_user' => $kode, 'nik' => get_nik($kode), 'name_first' => $r->NAME_FIRST, 'name_mid' => $r->NAME_MID, 'name_last' => $r->NAME_LAST, 'name' => set_display_nama($r->NAME_FIRST, $r->NAME_MID, $r->NAME_LAST), 'email_user' => $r->EMAIL_USER, 'id_institusi' => $r->ID_INSTITUSI, 'institusi' => NamaInstitusi($r->ID_INSTITUSI), 'pekerjaan' => $r->PEKERJAAN, 'bidang_keahlian' => $r->BIDANG_KEAHLIAN, 'nohp_user' => $r->NOHP_USER, 'web_user' => $r->WEB_USER, 'blokir' => $r->BLOKIR, 'date_created' => $r->DATE_CREATED));
$result['rows'][] = $dataCell;
$i++;
}
}
header("Content-type: application/json");
echo json_encode($result);
//$data['list'] = $this->users_model->get_data();
//$content['CONTENT'] = $this->parser->parse('admin/institusi_admin_form',$data,true);
//$this->parser->parse('admin',$content);
}
</a></span></h4>
</div>
<div class="grid-body no-border">
<?php
$att = array('class' => 'form-no-horizontal-spacing', 'id' => '');
echo form_open('form_cuti/add', $att);
?>
<div class="row column-seperation">
<div class="col-md-5">
<h4><?php
echo lang('emp_info');
?>
</h4>
<?php
$sess_id = $this->session->userdata('user_id');
$sess_nik = get_nik($sess_id);
//$cur_sess = date('Y');
//$sisa_cuti = $user->hak_cuti;
?>
<div class="row form-row">
<div class="col-md-3">
<label class="form-label text-right"><?php
echo lang('name');
?>
</label>
</div>
<div class="col-md-9">
<?php
if (is_admin()) {
$style_up = 'class="select2" style="width:100%" id="emp"';
echo form_dropdown('emp', $users, '', $style_up);
/**
* form_resignment
*
* @return object form_resignment
* @author Deni
**/
public function form_resignment($id = null)
{
$this->trigger_events('form_resignment');
if (isset($this->_ion_select) && !empty($this->_ion_select)) {
foreach ($this->_ion_select as $select) {
$this->db->select($select);
}
$this->_ion_select = array();
} else {
$sess_id = $this->session->userdata('user_id');
$sess_nik = get_nik($sess_id);
$is_approver = $this->approval->approver('resignment');
$is_admin = is_admin();
$is_admin_payroll = is_admin_payroll();
if (!empty(is_have_subordinate(get_nik($sess_id)))) {
$sub_id = get_subordinate($sess_id);
} else {
$sub_id = '';
}
if (!empty(is_have_subsubordinate($sess_id))) {
$subsub_id = 'OR ' . get_subsubordinate($sess_id);
} else {
$subsub_id = '';
}
//default selects
$this->db->select(array($this->tables['users_resignment'] . '.*', $this->tables['users_resignment'] . '.id as id', 'status_lv1.title as approval_status_lv1', 'status_lv2.title as approval_status_lv2', 'status_lv3.title as approval_status_lv3', 'status_hrd.title as approval_status_hrd', 'users_resignment_wawancara.alasan_resign_id', 'users_resignment_wawancara.desc_resign', 'users_resignment_wawancara.procedure_resign', 'users_resignment_wawancara.kepuasan_resign', 'users_resignment_wawancara.saran_resign', 'users_resignment_wawancara.rework_resign'));
$this->db->join('users', 'users.id = users_resignment.user_id', 'LEFT');
//$this->db->join('alasan_resign', 'users_resignment.alasan_resign_id = alasan_resign.id', 'LEFT');
$this->db->join('approval_status as status_lv1', 'users_resignment.app_status_id_lv1 = status_lv1.id', 'left');
$this->db->join('approval_status as status_lv2', 'users_resignment.app_status_id_lv2 = status_lv2.id', 'left');
$this->db->join('approval_status as status_lv3', 'users_resignment.app_status_id_lv3 = status_lv3.id', 'left');
$this->db->join('approval_status as status_hrd', 'users_resignment.app_status_id_hrd = status_hrd.id', 'left');
$this->db->join('users_resignment_wawancara', 'users_resignment.id = users_resignment_wawancara.user_resignment_id', 'left');
if ($id != null) {
$this->db->where('users_resignment.id', $id);
}
if ($is_approver !== $sess_nik && $is_admin != 1 && $is_admin_payroll != 1) {
//$this->db->where("(users_resignment.user_id= $sess_id $sub_id $subsub_id )",null, false);
$this->db->where("(users_resignment.user_id = {$sess_id} OR users_resignment.user_app_lv1 = '{$sess_nik}' OR users_resignment.user_app_lv2 = '{$sess_nik}' OR users_resignment.user_app_lv3 = '{$sess_nik}' OR users_resignment.created_by = '{$sess_id}')", null, false);
}
$this->db->order_by('users_resignment.id', 'desc');
}
$this->trigger_events('extra_where');
//run each where that was passed
if (isset($this->_ion_like) && !empty($this->_ion_like)) {
foreach ($this->_ion_like as $like) {
$this->db->or_like($like);
}
$this->_ion_like = array();
}
if (isset($this->_ion_limit) && isset($this->_ion_offset)) {
$this->db->limit($this->_ion_limit, $this->_ion_offset);
$this->_ion_limit = NULL;
$this->_ion_offset = NULL;
} else {
if (isset($this->_ion_limit)) {
$this->db->limit($this->_ion_limit);
$this->_ion_limit = NULL;
}
}
//set the order
if (isset($this->_ion_order_by) && isset($this->_ion_order)) {
$this->db->order_by($this->_ion_order_by, $this->_ion_order);
$this->_ion_order = NULL;
$this->_ion_order_by = NULL;
}
$this->response = $this->db->get($this->tables['users_resignment']);
return $this;
}
<div class="col-md-6 pull-right">
<p>Yang bersangkutan</p>
<?php
if ($this->session->userdata('user_id') == $td->task_receiver && $n_report == 0 || get_nik($this->session->userdata('user_id')) == $td->task_receiver && $n_report == 0) {
?>
<button class="btn btn-danger btn-cons" type="submit"><i class="icon-ok"></i> Save</button>
<a href="<?php
echo site_url('form_spd_dalam_group');
?>
"><button class="btn btn-white btn-cons" type="button">Cancel</button></a>
<?php
} elseif ($this->session->userdata('user_id') != $td->task_receiver && $n_report == 0) {
?>
<p class="">...............................</p>
<?php
} elseif ($this->session->userdata('user_id') == $td->task_receiver && $n_report == 1 || get_nik($this->session->userdata('user_id')) == $td->task_receiver && $n_report == 1) {
?>
<p class="wf-submit">
<span class="semi-bold"><?php
echo get_name($report_creator);
?>
</span><br/>
<span class="small"><?php
echo dateIndo($created_on);
?>
</span><br/>
</p>
<?php
} else {
?>
<p class="wf-submit">
function form_resignment_pdf($id)
{
if (!$this->ion_auth->logged_in()) {
redirect('auth/login', 'refresh');
}
$sess_id = $this->data['sess_id'] = $this->session->userdata('user_id');
$user_id = getValue('user_id', 'users_resignment', array('id' => 'where/' . $id));
$this->data['user_nik'] = get_nik($user_id);
$form_resignment = $this->data['form_resignment'] = $this->form_resignment_model->form_resignment($id)->result();
$this->data['_num_rows'] = $this->form_resignment_model->form_resignment($id)->num_rows();
$this->data['approval_status'] = GetAll('approval_status', array('is_deleted' => 'where/0'));
$this->data['id'] = $id;
$title = $this->data['title'] = 'Form Karyawan Keluar-' . get_name($user_id);
$this->load->library('mpdf60/mpdf');
$html = $this->load->view('resignment_pdf', $this->data, true);
$mpdf = new mPDF();
$mpdf = new mPDF('A4');
$mpdf->WriteHTML($html);
$mpdf->Output($id . '-' . $title . '.pdf', 'I');
}
/**
* form_training_group
*
* @return object form_training_group
* @author Deni
**/
public function form_training_group($id = null)
{
$this->trigger_events('form_training_group');
if (isset($this->_ion_select) && !empty($this->_ion_select)) {
foreach ($this->_ion_select as $select) {
$this->db->select($select);
}
$this->_ion_select = array();
} else {
$sess_id = $this->session->userdata('user_id');
$sess_nik = get_nik($sess_id);
$is_approver = $this->approval->approver('training');
$is_admin = is_admin();
$is_admin_legal = is_admin_legal();
if (!empty(is_have_subordinate(get_nik($sess_id)))) {
$sub_id = get_subordinate($sess_id);
} else {
$sub_id = '';
}
if (!empty(is_have_subsubordinate($sess_id))) {
$subsub_id = 'OR ' . get_subsubordinate($sess_id);
} else {
$subsub_id = '';
}
//default selects
$this->db->select(array($this->tables['users_training_group'] . '.*', $this->tables['users_training_group'] . '.id as id', $this->tables['penyelenggara'] . '.title as penyelenggara', $this->tables['pembiayaan'] . '.title as pembiayaan', $this->tables['training_type'] . '.title as training_type', 'training_ikatan_dinas.title as ikatan', 'training_waktu.title as waktu', 'status_lv1.title as approval_status_lv1', 'status_lv2.title as approval_status_lv2', 'status_lv3.title as approval_status_lv3', 'status_hrd.title as approval_status_hrd'));
$this->db->join('users', 'users_training_group.user_pengaju_id = users.id', 'left');
$this->db->join('penyelenggara', 'users_training_group.penyelenggara_id = penyelenggara.id', 'LEFT');
$this->db->join('pembiayaan', 'users_training_group.pembiayaan_id = pembiayaan.id', 'LEFT');
$this->db->join('training_type', 'users_training_group.training_type_id = training_type.id', 'LEFT');
$this->db->join('training_ikatan_dinas', 'users_training_group.ikatan_dinas_id = training_ikatan_dinas.id', 'LEFT');
$this->db->join('training_waktu', 'users_training_group.waktu_id = training_waktu.id', 'LEFT');
$this->db->join('approval_status as status_lv1', 'users_training_group.approval_status_id_lv1 = status_lv1.id', 'left');
$this->db->join('approval_status as status_lv2', 'users_training_group.approval_status_id_lv2 = status_lv2.id', 'left');
$this->db->join('approval_status as status_lv3', 'users_training_group.approval_status_id_lv3 = status_lv3.id', 'left');
$this->db->join('approval_status as status_hrd', 'users_training_group.approval_status_id_hrd = status_hrd.id', 'left');
if ($id != null) {
$this->db->where('users_training_group.id', $id);
}
if ($is_approver !== $sess_nik && $is_admin != 1 && $is_admin_legal != 1) {
//$this->db->where("(users_training_group.user_id= $sess_id $sub_id $subsub_id )",null, false);
$this->db->where("(users_training_group.user_pengaju_id = {$sess_id} OR users_training_group.user_peserta_id like '%{$sess_nik}%' OR users_training_group.user_app_lv1 = '{$sess_nik}' OR users_training_group.user_app_lv2 = '{$sess_nik}' OR users_training_group.user_app_lv3 = '{$sess_nik}' OR users_training_group.created_by = '{$sess_id}')", null, false);
}
$this->db->order_by('users_training_group.id', 'desc');
}
$this->trigger_events('extra_where');
//run each where that was passed
if (isset($this->_ion_like) && !empty($this->_ion_like)) {
foreach ($this->_ion_like as $like) {
$this->db->or_like($like);
}
$this->_ion_like = array();
}
if (isset($this->_ion_limit) && isset($this->_ion_offset)) {
$this->db->limit($this->_ion_limit, $this->_ion_offset);
$this->_ion_limit = NULL;
$this->_ion_offset = NULL;
} else {
if (isset($this->_ion_limit)) {
$this->db->limit($this->_ion_limit);
$this->_ion_limit = NULL;
}
}
//set the order
if (isset($this->_ion_order_by) && isset($this->_ion_order)) {
$this->db->order_by($this->_ion_order_by, $this->_ion_order);
$this->_ion_order = NULL;
$this->_ion_order_by = NULL;
}
$this->response = $this->db->get($this->tables['users_training_group']);
return $this;
}
<form class="form-no-horizontal-spacing" id="formAppLv3">
<div class="row column-seperation">
<div class="col-md-5">
<h4>Informasi karyawan</h4>
<?php
if ($_num_rows > 0) {
foreach ($form_cuti as $user) {
$cur_sess = date('Y');
// convert date time
$user_nik = get_nik($user->user_id);
$submission_date = dateIndo($user->created_on);
$date_start_cuti = dateIndo($user->date_mulai_cuti);
$date_end_cuti = dateIndo($user->date_selesai_cuti);
?>
<div class="row form-row">
<div class="col-md-4">
<label class="form-label text-right">No</label>
</div>
<div class="col-md-8">
<input name="no" id="no" type="text" class="form-control" placeholder="No" value="<?php
echo $user->id;
?>
" disabled="disabled">
</div>
</div>
<div class="row form-row">
<div class="col-md-4">
<label class="form-label text-right"><?php
echo lang('start_working');
?>
public function form_spd_luar_report_group($id = null, $user_id = null)
{
$this->trigger_events('form_spd_luar_report_group');
if (isset($this->_ion_select) && !empty($this->_ion_select)) {
foreach ($this->_ion_select as $select) {
$this->db->select($select);
}
$this->_ion_select = array();
} else {
//default selects
$sess_nik = !empty(get_nik($this->session->userdata('user_id'))) ? get_nik($this->session->userdata('user_id')) : $this->session->userdata('user_id');
$this->db->select(array($this->tables['users_spd_luar_report_group'] . '.*', $this->tables['users_spd_luar_report_group'] . '.id as id', $this->tables['users_spd_luar_group'] . '.id as spd_id'));
$this->db->join('users_spd_luar_report_group', 'users_spd_luar_group.id = users_spd_luar_report_group.user_spd_luar_group_id', 'left');
if ($id != null && $user_id != null) {
//$this->db->where('users_spd_luar_report_group.user_spd_luar_group_id', $id);
$this->db->where('users_spd_luar_report_group.created_by', $user_id);
}
$this->db->where('users_spd_luar_group.is_deleted', 0);
}
$this->trigger_events('extra_where');
//run each where that was passed
if (isset($this->_ion_where) && !empty($this->_ion_where)) {
foreach ($this->_ion_where as $where) {
$this->db->where($where);
}
$this->_ion_where = array();
}
if (isset($this->_ion_like) && !empty($this->_ion_like)) {
foreach ($this->_ion_like as $like) {
$this->db->or_like($like);
}
$this->_ion_like = array();
}
if (isset($this->_ion_limit) && isset($this->_ion_offset)) {
$this->db->limit($this->_ion_limit, $this->_ion_offset);
$this->_ion_limit = NULL;
$this->_ion_offset = NULL;
} else {
if (isset($this->_ion_limit)) {
$this->db->limit($this->_ion_limit);
$this->_ion_limit = NULL;
}
}
//set the order
if (isset($this->_ion_order_by) && isset($this->_ion_order)) {
$this->db->order_by($this->_ion_order_by, $this->_ion_order);
$this->_ion_order = NULL;
$this->_ion_order_by = NULL;
}
$this->response = $this->db->get($this->tables['users_spd_luar_group']);
return $this;
}
<h4>Yang Memberi Tugas</h4>
<div class="row form-row">
<div class="col-md-3">
<label class="form-label text-right">Nama</label>
</div>
<div class="col-md-9">
<?php
if (is_admin() || is_admin_bagian()) {
?>
<select id="emp" class="select2" style="width:100%" name="emp_tc">
<?php
foreach ($all_users->result() as $u) {
$selected = $u->id == $sess_id ? 'selected = selected' : '';
?>
<option value="<?php
echo get_nik($u->id);
?>
" <?php
echo $selected;
?>
><?php
echo $u->username;
?>
</option>
<?php
}
?>
</select>
<?php
} else {
?>
$att = array('class' => 'form-no-horizontal-spacing', 'id' => '');
echo form_open('form_promosi/add', $att);
if ($_num_rows > 0) {
foreach ($form_promosi as $row) {
?>
<div class="row column-seperation">
<div class="col-md-5">
<h4>Informasi karyawan</h4>
<div class="row form-row">
<div class="col-md-3">
<label class="form-label text-right">NIK</label>
</div>
<div class="col-md-9">
<input name="nik" id="form3LastName" type="text" class="form-control " placeholder="Nama" value="<?php
echo get_nik($row->user_id);
?>
" disabled="disabled">
</div>
</div>
<div class="row form-row">
<div class="col-md-3">
<label class="form-label text-right">Nama</label>
</div>
<div class="col-md-9">
<input name="name" id="form3LastName" type="text" class="form-control " placeholder="Nama" value="<?php
echo get_name($row->user_id);
?>
" disabled="disabled">
</div>
</div>
function get_sisa_absen($user_id = null)
{
//$id = $this->session->userdata('user_id');
if ($user_id != null) {
$url = get_api_key() . 'users/sisa_cuti/EMPLID/' . get_nik($user_id) . '/format/json';
$headers = get_headers($url);
$response = substr($headers[0], 9, 3);
if ($response != "404") {
$getsisa_absen = file_get_contents($url);
$sisa_absen = json_decode($getsisa_absen, true);
return $sisa_absen;
} else {
return '-';
}
}
}
<table class="table table-striped table-flip-scroll cf">
<thead>
<tr>
<th width="20%">Nama Karyawan</th>
<th width="20%">Nama pelatihan</th>
<th width="40%">Tujuan</th>
<th width="10%" style="text-align:center;">APPR SPV</th>
<th width="10%" style="text-align:center;">APPR HRD</th>
</tr>
</thead>
<tbody>
<?php
if ($form_training->num_rows() > 0) {
foreach ($form_training->result() as $user) {
$id_training = $user->id;
$session_id = get_nik($this->session->userdata('user_id'));
$id_user = $this->session->userdata('user_id');
$txt_app_lv1 = $txt_app_lv2 = $txt_app_lv3 = "-";
// approval training
//Approval Level 1
if (!empty(is_have_subordinate($session_id))) {
if (cek_subordinate(is_have_subordinate($session_id), 'id', $user->user_id)) {
if ($user->is_app_lv1 == 0) {
$txt_app_lv1 = "<a href='" . site_url('form_training/approval_spv/' . $user->id) . "''>\n <button type='button' class='btn btn-info btn-small' title='Make Approval'><i class='icon-paste'></i></button>\n </a>";
} else {
$txt_app_lv1 = "<a href='" . site_url('form_training/approval_spv/' . $user->id) . "''>Ya</a>";
}
} elseif ($user->is_app_lv1 == 1) {
$txt_app_lv1 = "<a href='" . site_url('form_training/approval_spv/' . $user->id) . "''>Ya</a>";
} elseif ($user->is_app_lv1 == 0) {
$txt_app_lv1 = '-';
function pdf($id)
{
if (!$this->ion_auth->logged_in()) {
//redirect them to the login page
redirect('auth/login', 'refresh');
}
$this->data['title'] = $title = 'SPD - Luar Kota (Group)';
$sess_id = $this->data['sess_id'] = $this->session->userdata('user_id');
$sess_nik = get_nik($sess_id);
$data_result = $this->data['task_detail'] = $this->form_spd_luar_group_model->where('users_spd_luar_group.id', $id)->form_spd_luar_group($id)->result();
$this->data['td_num_rows'] = $this->form_spd_luar_group_model->where('users_spd_luar_group.id', $id)->form_spd_luar_group($id)->num_rows();
$receiver = getAll('users_spd_luar_group', array('id' => 'where/' . $id))->row('task_receiver');
$creator = getAll('users_spd_luar_group', array('id' => 'where/' . $id))->row('task_creator');
$user_submit = getAll('users_spd_luar_group', array('id' => 'where/' . $id))->row('user_submit');
$this->data['biaya_pjd_group'] = getAll('users_spd_luar_group_biaya', array('user_spd_luar_group_id' => 'where/' . $id));
$this->data['biaya_tambahan'] = getAll('pjd_biaya', array('type_grade' => 'where/0'));
$this->data['receiver'] = $p = explode(",", $receiver);
$this->data['receiver_submit'] = explode(",", $user_submit);
$this->data['id'] = $id;
$b = $this->data['biaya_pjd'] = $this->db->distinct()->select('users_spd_luar_group_biaya.pjd_biaya_id as biaya_id, pjd_biaya.title as jenis_biaya')->from('users_spd_luar_group_biaya')->join('pjd_biaya', 'pjd_biaya.id = users_spd_luar_group_biaya.pjd_biaya_id', 'left')->where('user_spd_luar_group_id', $id)->where('pjd_biaya.type_grade', 0)->get();
//print_mz($this->data['biaya_pjd']->result());
$this->data['detail'] = $this->db->distinct()->select('user_id')->where('user_spd_luar_group_id', $id)->get('users_spd_luar_group_biaya');
$this->data['ci'] = $this;
$this->load->library('mpdf60/mpdf');
$html = $this->load->view('spd_luar_group_pdf', $this->data, true);
$this->mpdf = new mPDF();
$this->mpdf->AddPage('L', '', '', '', '', 30, 30, 10, 10, 10, 10);
// margin footer
$this->mpdf->WriteHTML($html);
$this->mpdf->Output($id . '-' . $title . '-' . $creator . 'pdf', 'I');
}
function get_penerima_tugas_satu_bu()
{
$user_id = $this->session->userdata('user_id');
$url_org = get_api_key() . 'users/emp_satu_bu/EMPLID/' . get_nik($user_id) . '/format/json';
$headers_org = get_headers($url_org);
$response = substr($headers_org[0], 9, 3);
if ($response != "404") {
$get_penerima_tugas = file_get_contents($url_org);
$penerima_tugas = json_decode($get_penerima_tugas, true);
return $this->data['penerima_tugas_satu_bu'] = $penerima_tugas;
} else {
return $this->data['penerima_tugas_satu_bu'] = 'Tidak ada karyawan dengan Bussiness Unit yang sama';
}
}
function insert_leave_request($user_id, $data = array(), $leave_request_id)
{
$user_id = get_nik($user_id);
$leaveid = substr($leave_request_id[0]['IDLEAVEREQUEST'], 2) + 1;
$leaveid = sprintf('%06d', $leaveid);
$IDLEAVEREQUEST = 'CT' . $leaveid;
$RECVERSION = $leave_request_id[0]['RECVERSION'] + 1;
$RECID = $leave_request_id[0]['RECID'] + 1;
$remarks = str_replace(' ', '-', $data['remarks']);
$alamat_cuti = str_replace(' ', '-', $data['alamat_cuti']);
$phone = str_replace(' ', '-', $data['contact']);
$method = 'post';
$params = array();
$uri = get_api_key() . 'users/leave_request/' . 'EMPLID/' . $user_id . '/HRSLEAVETYPEID/' . $data['alasan_cuti_id'] . '/REMARKS/' . $remarks . '/CONTACTPHONE/' . $phone . '/TOTALLEAVEDAYS/' . $data['jumlah_hari'] . '/LEAVEDATETO/' . $data['date_selesai_cuti'] . '/LEAVEDATEFROM/' . $data['date_mulai_cuti'] . '/REQUESTDATE/' . $data['created_on'] . '/IDLEAVEREQUEST/' . $IDLEAVEREQUEST . '/STATUSFLAG/' . '3' . '/IDPERSONSUBSTITUTE/' . $data['user_pengganti'] . '/TRAVELLINGLOCATION/' . $alamat_cuti . '/MODIFIEDDATETIME/' . $data['created_on'] . '/MODIFIEDBY/' . $data['created_by'] . '/CREATEDDATETIME/' . $data['created_on'] . '/CREATEDBY/' . $data['created_by'] . '/DATAAREAID/' . get_user_dataareaid($user_id) . '/RECVERSION/' . $RECVERSION . '/RECID/' . $RECID . '/BRANCHID/' . get_user_branchid($user_id) . '/DIMENSION/' . get_user_buid($user_id) . '/DIMENSION2_/' . get_user_dimension2_($user_id) . '/HRSLOCATIONID/' . get_user_locationid($user_id) . '/HRSEMPLGROUPID/' . get_user_emplgroupid($user_id);
$this->rest->format('application/json');
$result = $this->rest->{$method}($uri, $params);
if (isset($result->status) && $result->status == 'success') {
return true;
} else {
return false;
}
}
?>
<p>Yang bersangkutan</p>
<p> </p>
<p> </p>
<p class="wf-submit">
<span class="semi-bold">
<?php
echo get_name($td->created_by);
?>
</span><br/>
<span class="small"><?php
echo dateIndo($td->created_on);
?>
</span><br/>
<span class="small"><?php
echo get_user_position(get_nik($td->created_by));
?>
</span><br/>
</p>
<?php
}
?>
</div>
<div style="float: right;text-align: center; width: 45%;" class="style5">
<p>Yang memberi tugas / ijin</p>
<p> </p>
<p> </p>
<span class="semi-bold"><?php
echo get_name($td->task_creator);
/**
* form_spd_luar
*
* @return object form_spd_luar
* @author Deni
**/
public function form_spd_luar($id = null)
{
$this->trigger_events('form_spd_luar');
if (isset($this->_ion_select) && !empty($this->_ion_select)) {
foreach ($this->_ion_select as $select) {
$this->db->select($select);
}
$this->_ion_select = array();
} else {
$sess_id = $this->session->userdata('user_id');
$sess_nik = get_nik($sess_id);
$is_admin = is_admin();
$is_approver = $this->approval->approver('dinas');
if (!empty(is_have_subordinate(get_nik($sess_id)))) {
$sub_id = get_subordinate($sess_id);
} else {
$sub_id = '';
}
if (!empty(is_have_subsubordinate($sess_id))) {
$subsub_id = 'OR ' . get_subsubordinate($sess_id);
} else {
$subsub_id = '';
}
//default selects
$this->db->select(array($this->tables['users_spd_luar'] . '.*', $this->tables['users_spd_luar'] . '.id as id', $this->tables['users_spd_luar'] . '.id as form_spd_luar_id', $this->tables['transportation'] . '.title as transportation_nm', 'city_to.title as city_to', 'city_from.title as city_from'));
$this->db->join('users', 'users.nik = users_spd_luar.task_receiver', 'LEFT');
$this->db->join('users as creator', 'creator.nik = users_spd_luar.task_creator', 'LEFT');
$this->db->join('transportation', 'users_spd_luar.transportation_id = transportation.id');
$this->db->join('city as city_to', 'users_spd_luar.to_city_id = city_to.id');
$this->db->join('city as city_from', 'users_spd_luar.from_city_id = city_from.id');
if ($id != null) {
$this->db->where('users_spd_luar.id', $id);
}
if ($is_approver !== $sess_nik && $is_admin != 1) {
$this->db->where("(users_spd_luar.task_receiver = '{$sess_nik}' OR users_spd_luar.task_creator = '{$sess_nik}' OR users_spd_luar.created_by = '{$sess_id}'\n OR users_spd_luar.user_app_lv1 = '{$sess_nik}' OR users_spd_luar.user_app_lv2 = '{$sess_nik}' OR users_spd_luar.user_app_lv3 = '{$sess_nik}' \n )", null, false);
}
$this->db->where('users_spd_luar.is_deleted', 0);
$this->db->order_by('users_spd_luar.id', 'desc');
}
$this->trigger_events('extra_where');
//run each where that was passed
if (isset($this->_ion_where) && !empty($this->_ion_where)) {
foreach ($this->_ion_where as $where) {
$this->db->where($where);
}
$this->_ion_where = array();
}
if (isset($this->_ion_like) && !empty($this->_ion_like)) {
foreach ($this->_ion_like as $like) {
$this->db->or_like($like);
}
$this->_ion_like = array();
}
if (isset($this->_ion_limit) && isset($this->_ion_offset)) {
$this->db->limit($this->_ion_limit, $this->_ion_offset);
$this->_ion_limit = NULL;
$this->_ion_offset = NULL;
} else {
if (isset($this->_ion_limit)) {
$this->db->limit($this->_ion_limit);
$this->_ion_limit = NULL;
}
}
//set the order
if (isset($this->_ion_order_by) && isset($this->_ion_order)) {
$this->db->order_by($this->_ion_order_by, $this->_ion_order);
$this->_ion_order = NULL;
$this->_ion_order_by = NULL;
}
$this->response = $this->db->get($this->tables['users_spd_luar']);
return $this;
}
<th width="15%">Hubungan</th>
<th width="13%">Jenis Pemeriksaan</th>
<th width="12%">Rupiah</th>
<th width="12%">Disetujui</th>
</tr>
</thead>
<tbody>
<?php
if (!empty($detail_hrd)) {
$total = $detail_hrd[0]['rupiah'];
for ($i = 0; $i < sizeof($detail_hrd); $i++) {
$is_approve = $detail_hrd[$i]['is_approve'] == 1 ? 'Ya' : 'Tidak';
?>
<tr>
<td><?php
echo get_nik($detail_hrd[$i]['karyawan_id']);
?>
</td>
<td><?php
echo get_name($detail_hrd[$i]['karyawan_id']);
?>
</td>
<td><?php
echo $detail_hrd[$i]['pasien'];
?>
</td>
<td><?php
echo $detail_hrd[$i]['hubungan'];
?>
</td>
<td><?php
function send_spd_report_mail($spd_id, $receiver_id)
{
$url = base_url() . 'form_spd_dalam/report/' . $spd_id;
$sender = !empty(get_nik($this->session->userdata('user_id'))) ? get_nik($this->session->userdata('user_id')) : $this->session->userdata('user_id');
$data = array('sender_id' => $sender, 'receiver_id' => get_nik($receiver_id), 'sent_on' => date('Y-m-d-H-i-s', strtotime('now')), 'subject' => 'Laporan Tugas Perjalanan Dinas Dalam Kota', 'email_body' => get_name($sender) . ' telah membuat laporan perjalanan dinas dalam kota, untuk melihat detail silakan <a href=' . $url . '>Klik Disini</a>', 'is_read' => 0);
$this->db->insert('email', $data);
}
?>
<td align="center" class="style3"><?php
echo get_name($row->user_app_lv2);
?>
</td>
<?php
}
?>
<td align="center" class="style3"><?php
echo get_name($row->user_app_hrd);
?>
</td>
</tr>
<tr>
<td align="center"><?php
$pengaju_nik = get_nik($row->user_id);
echo dateIndo($row->created_on);
?>
<br/><?php
echo get_user_position($pengaju_nik);
?>
</td>
<?php
if (!empty($row->user_app_lv1)) {
?>
<td align="center"><?php
echo dateIndo($row->date_app_lv1);
?>
<br/>(Supervisor)</td>
<?php
}
function get_user_position($user_id)
{
$url = get_api_key() . 'users/employement/EMPLID/' . get_nik($user_id) . '/format/json';
$headers = get_headers($url);
$response = substr($headers[0], 9, 3);
if ($response != "404") {
$getuser_info = file_get_contents($url);
$user_info = json_decode($getuser_info, true);
return $user_info['POSITION'];
} else {
return '-';
}
}
function get_subordinate()
{
$id = get_nik($this->input->post('id'));
$subordinate = getAll('users', array('superior_id' => 'where/' . $id));
foreach ($subordinate->result_array() as $row) {
$result['0'] = '-- Pilih User --';
$result[$row['id']] = ucwords(strtolower($row['username']));
}
$data['result'] = $result;
$this->load->view('dropdown_atasan', $data);
}
function get_sisa_cuti($user_id)
{
if ($user_id != null) {
$url = get_api_key() . 'users/sisa_cuti/EMPLID/' . get_nik($user_id) . '/format/json';
$headers = get_headers($url);
$response = substr($headers[0], 9, 3);
if ($response != "404") {
$getsisa_cuti = file_get_contents($url);
$sisa_cuti = json_decode($getsisa_cuti, true);
return $sisa_cuti;
} else {
return '-';
}
}
}
</div>
<!--PST242, PST263, PST2, PST129-->
</div>
</div>
<?php
if (!empty($row->user_app_lv3)) {
?>
<div class="col-md-12 text-xenter">
<div class="col-md-12 text-center">
<p class="wf-approve-sp">
<div class="col-md-12"><span class="semi-bold">Mengetahui / Menyetujui,</span><br/><br/></div>
<?php
$approved = assets_url('img/approved_stamp.png');
$rejected = assets_url('img/rejected_stamp.png');
if (!empty($row->user_app_lv3) && $row->is_app_lv3 == 0 && get_nik($sess_id) == $row->user_app_lv3) {
?>
<div class="btn btn-success btn-cons" id="" type="" data-toggle="modal" data-target="#submitpromosiModalLv3"><i class="icon-ok"></i>Submit</div>
<span class="small"></span>
<span class="semi-bold"></span><br/>
<span class="small"></span><br/>
<span class="semi-bold"></span><br/>
<span class="semi-bold">(<?php
echo get_user_position($row->user_app_lv3);
?>
)</span>
<?php
} elseif (!empty($row->user_app_lv3) && $row->is_app_lv3 == 1) {
echo $row->app_status_id_lv3 == 1 ? "<img class=approval-img-al src={$approved}>" : ($row->app_status_id_lv3 == 2 ? "<img class=approval-img-al src={$rejected}>" : '<span class="small"></span><br/>');
?>
<span class="small"></span><br/>
/**
* users
*
* @return object Users
* @author Ben Edmunds
**/
public function users($groups = NULL)
{
$sess_id = $this->session->userdata('user_id');
$is_inventory = $this->uri->segment(1);
$this->trigger_events('users');
$is_admin_bagian = $this->ion_auth->is_admin_bagian();
$user = $is_inventory == 'inventory' ? get_user_same_bu(get_nik($sess_id)) : get_user_same_org(get_nik($sess_id));
if (isset($this->_ion_select) && !empty($this->_ion_select)) {
foreach ($this->_ion_select as $select) {
$this->db->select($select);
}
$this->_ion_select = array();
} else {
//default selects
$this->db->select(array($this->tables['users'] . '.*', $this->tables['users'] . '.id as id', $this->tables['users'] . '.id as user_id'));
if ($is_admin_bagian == 1) {
$this->db->where('id != ', 1);
for ($i = 0; $i < sizeof($user) - 1; $i++) {
$this->db->or_like('nik', $user[$i]);
}
}
}
//filter by group id(s) if passed
if (isset($groups)) {
//build an array if only one group was passed
if (is_numeric($groups)) {
$groups = array($groups);
}
//join and then run a where_in against the group ids
if (isset($groups) && !empty($groups)) {
$this->db->distinct();
$this->db->join($this->tables['users_groups'], $this->tables['users_groups'] . '.' . $this->join['users'] . '=' . $this->tables['users'] . '.id', 'inner');
$this->db->where_in($this->tables['users_groups'] . '.' . $this->join['groups'], $groups);
}
}
$this->trigger_events('extra_where');
//run each where that was passed
if (isset($this->_ion_where) && !empty($this->_ion_where)) {
foreach ($this->_ion_where as $where) {
$this->db->where($where);
}
$this->_ion_where = array();
}
if (isset($this->_ion_like) && !empty($this->_ion_like)) {
foreach ($this->_ion_like as $like) {
$this->db->or_like($like);
}
$this->_ion_like = array();
}
if (isset($this->_ion_limit) && isset($this->_ion_offset)) {
$this->db->limit($this->_ion_limit, $this->_ion_offset);
$this->_ion_limit = NULL;
$this->_ion_offset = NULL;
} else {
if (isset($this->_ion_limit)) {
$this->db->limit($this->_ion_limit);
$this->_ion_limit = NULL;
}
}
//set the order
if (isset($this->_ion_order_by) && isset($this->_ion_order)) {
$this->db->order_by($this->_ion_order_by, $this->_ion_order);
$this->_ion_order = NULL;
$this->_ion_order_by = NULL;
}
$this->response = $this->db->get($this->tables['users']);
return $this;
}
