Exemplo n.º 1
0
 public function load_notif_header()
 {
     $data['notification'] = GetAll('notifikasi', array('is_read' => 'where/0', 'receiver_id' => 'where/' . sessId(), 'limit' => 'limit/3', 'id' => 'order/desc'));
     $data['notifications'] = GetAll('notifikasi', array('is_read' => 'where/0', 'receiver_id' => 'where/' . sessId(), 'id' => 'order/desc'));
     $data['notification_num'] = GetAll('notifikasi', array('is_read' => 'where/0', 'receiver_id' => 'where/' . sessId()))->num_rows();
     $this->load->view('notification/head_notif_badge', $data);
 }
Exemplo n.º 2
0
 function index()
 {
     permissionUser();
     $num_rows = getAll($this->table_name, array('receiver_id' => 'where/' . sessId()))->num_rows();
     $this->data['last_id'] = $last_id = $num_rows > 0 ? $this->db->select('id')->where('receiver_id', sessId())->order_by('id', 'asc')->get($this->table_name)->last_row()->id : 0;
     $this->data['last_notif'] = getAll($this->table_name, array('receiver_id' => 'where/' . sessId(), 'id' => 'where/' . $last_id))->row();
     $this->data['all_notification'] = GetAll('notifikasi', array('receiver_id' => 'where/' . sessId(), 'id' => 'order/desc'));
     $this->_render_page('notification/index', $this->data);
 }
Exemplo n.º 3
0
 function detail($id)
 {
     $this->data['title'] = $this->title . ' - Detail';
     permissionUser();
     $this->data['id'] = $id;
     $this->data['r'] = GetAll('stok_penyesuaian', array('id' => 'where/' . $id))->row();
     $this->data['list'] = $this->main->get_list($id)->result();
     $this->_render_page($this->module . '/' . $this->file_name . '/detail', $this->data);
 }
Exemplo n.º 4
0
 function print_pdf($id)
 {
     permissionUser();
     $this->data['id'] = $id;
     $this->data['r'] = GetAll('stok_pemindahan', array('id' => 'where/' . $id))->row();
     $this->data['list'] = $this->main->get_list($id)->result_array();
     $this->load->library('pdf');
     $html = $this->load->view($this->module . '/' . $this->file_name . '/pdf', $this->data, true);
     $this->pdf->load_html($html);
     $this->pdf->render();
     $this->pdf->stream($id . '-' . $this->title . '.pdf');
 }
Exemplo n.º 5
0
 function response_cat($id = null)
 {
     //error_reporting(0);
     if ($id != '') {
         /* $qdep=$this->model_getdata->get_department();
         			$data['listdep']=$qdep->result();
         			$data['bulan']=$this->model_getdata->namabulan(); */
         $data['document'] = GetAll('report', array('id' => 'where/' . $id));
         if ($data['document']->num_rows() > 0) {
             $this->load->view('report/category/main', $data);
         } else {
             echo "Dokumen Tidak Ditemukan";
         }
     }
 }
Exemplo n.º 6
0
 function index()
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     } elseif (!$this->ion_auth->is_admin()) {
         //redirect them to the home page because they must be an administrator to view this
         //return show_error('You must be an administrator to view this page.');
         return show_error('You must be an administrator to view this page.');
     } else {
         //set the flash data error message if there is one
         $this->data['message'] = validation_errors() ? validation_errors() : $this->session->flashdata('message');
         $filter = array('is_deleted' => 0);
         $query_options = GetAll('library', $filter);
         $this->data['user_all'] = $query_options->num_rows() > 0 ? $query_options : array();
         $this->_render_page('library_table/index', $this->data);
     }
 }
Exemplo n.º 7
0
 function input($id = NULL)
 {
     $this->data['val'] = $this->data['list'] = array();
     if ($id > 0) {
         $this->data['val'] = GetAll($this->file_name, array('id' => 'where/' . $id))->row_array();
         $this->data['list'] = GetAll($this->file_name . '_list', array($this->file_name . '_id' => 'where/' . $id))->result_array();
     }
     $this->data['title'] = $this->title . ' - Input';
     permissionUser();
     $this->data['module'] = $this->module;
     $this->data['file_name'] = $this->file_name;
     $this->data['r'] = $this->main->get_detail($id);
     $this->data['opt_barang'] = GetAll('barang')->result();
     $this->data['barang'] = getAll('barang')->result_array();
     $this->data['satuan'] = getAll('satuan')->result_array();
     $this->data['opt_satuan'] = GetOptAll('satuan');
     $this->_render_page($this->module . '/' . $this->file_name . '/input', $this->data);
 }
Exemplo n.º 8
0
 private function _get_datatables_query($param = NULL)
 {
     //Parameter
     $where = "id > 0 ";
     if (isset($param['divisi']) && $param['divisi'] > 0) {
         $id_sec = "(";
         $q = GetAll("hris_orgs", array("parent_id" => "where/" . $param['divisi']));
         foreach ($q->result_array() as $r) {
             $id_sec .= "'" . $r['org_id'] . "',";
         }
         $id_sec = substr($id_sec, 0, -1) . ")";
         $where .= "AND org_id in " . $id_sec . " ";
     }
     if (isset($param['section']) && $param['section'] > 0) {
         $where .= "AND org_id='" . $param['section'] . "' ";
     }
     if (isset($param['position']) && $param['position'] > 0) {
         $where .= "AND job_class_id='" . $param['position'] . "' ";
     }
     if (isset($param['grade']) && $param['grade'] > 0) {
         $where .= "AND grade_job_class='" . $param['grade'] . "' ";
     }
     if (isset($param['regs'])) {
         if ($param['regs'] == "reguler") {
             $where .= "AND group_shift='N.A.' ";
         } else {
             if ($param['regs'] == "shift") {
                 $where .= "AND group_shift in ('A', 'B', 'C', 'D') ";
             }
         }
         //$this->db->where_in("group_shift", array("A","B","C","D"));
     }
     //Query
     $select = "*";
     $this->db->select($select);
     $this->db->from("kg_view_cuti_platfon");
     $this->db->where($where);
     $this->db->order_by("person_nm", "asc");
 }
Exemplo n.º 9
0
 function upload_excel()
 {
     $config['upload_path'] = './upload/files/excel';
     $config['allowed_types'] = 'xlsx|xls|csv';
     $config['overwrite'] = TRUE;
     $config['max_size'] = '10000';
     $val = 0;
     $this->load->library('upload', $config);
     if (!$this->upload->do_upload('excelfile')) {
         $error = array('error' => $this->upload->display_errors());
         die(print_r($error));
     } else {
         $data = array('upload_data' => $this->upload->data());
         // echo "success";
         $data_upload = $this->upload->data();
         //die(print_r($data_upload));
         $result = $this->run_import($data_upload);
         //die(print_r($result));
         foreach ($result as $row) {
             $employee_ext_id = $row['A'];
             $val = $row['C'];
             $employee_id = GetValue('employee_id', 'hris_employee', array('employee_ext_id' => 'where/' . $employee_ext_id));
             //count
             $count = GetAll('payroll_monthly_deduction_medical', array('payroll_period_id' => 'where/' . $this->input->post('periode'), 'employee_id' => 'where/' . $employee_id))->num_rows();
             if ($count > 0) {
                 $val_old = GetValue('value', 'payroll_monthly_deduction_medical', array('employee_id' => 'where/' . $employee_id, 'payroll_period_id' => 'where/' . $this->input->post('periode')));
                 $val_new = $val_old + $val;
                 $data_update = array('value' => $val_new);
                 $this->all_model->update('payroll_monthly_deduction_medical', $data_update, array('employee_id' => $employee_id, 'payroll_period_id' => $this->input->post('periode')));
                 //lastq();
             } else {
                 $data_insert = array('payroll_period_id' => $this->input->post('periode'), 'employee_id' => $employee_id, 'value' => $val, 'created_by' => sessId(), 'created_on' => date('Y-m-d H:i:s'));
                 $this->all_model->insert('payroll_monthly_deduction_medical', $data_insert);
             }
         }
     }
     redirect('payroll/medical');
 }
Exemplo n.º 10
0
 function update_master_component_value($component_id)
 {
     $today = date('Y-m-d');
     $master_id = GetAllSelect('payroll_master_component', 'payroll_component_id, payroll_master_id', array('payroll_component_id' => 'where/' . $component_id))->result();
     $emp_id = getValue('employee_id', 'payroll_master', array('id' => 'where/' . $master_id));
     $filter = array('payroll_component_id' => 'where/' . $component_id, 'session_id' => 'where/' . $this->session_id);
     $component_session_id = getValue('id', 'payroll_component_session', $filter);
     //lastq();
     $com_val = $this->db->select('*')->where('payroll_component_session_id', $component_session_id)->get('payroll_component_value')->result();
     $formula = '';
     if (!empty($com_val)) {
         //print_ag($com_val);
         foreach ($com_val as $c) {
             $from = date('Y-m-d', strtotime($c->from));
             $to = date('Y-m-d', strtotime($c->to));
             //print_ag("$today lebih besar dari $from , $today kurang dari $to");
             //print_mz($from);
             //if($today > $from && $today < $to)die('s');
             if ($today >= $from && $today <= $to) {
                 $formula = $c->formula;
                 //echo $formula;
                 $is_condition = $c->is_condition;
                 $min = $c->min;
                 $max = $c->max;
             }
         }
     }
     $tx = explode(' ', $formula);
     $r = '';
     foreach ($master_id as $value) {
         if ($formula != null && $component_id != 60) {
             if (!in_array('IF', $tx)) {
                 for ($i = 0; $i < sizeof($tx); $i++) {
                     //print_mz($tx);
                     if (preg_match("/[a-z]/i", $tx[$i])) {
                         $session_id = '2015';
                         $g = getValue('id', 'payroll_component', array('code' => 'where/' . $tx[$i]));
                         $detail = $this->payroll->get_employee_detail($emp_id);
                         $det = $detail->row();
                         $employee_job_id = getValue('job_id', 'hris_employee_job', array('employee_id' => 'where/' . $emp_id));
                         $job_value_id = getValue('job_value_id', 'hris_jobs', array('job_id' => 'where/' . $employee_job_id));
                         $filter = array('session_id' => 'where/' . $session_id, 'job_value_id' => 'where/' . $job_value_id, 'job_class_id' => 'where/' . $det->job_class_id);
                         $job_value_matrix = GetAll('payroll_job_value_matrix', $filter);
                         //lastq();
                         $job_value_matrix_num = GetAll('payroll_job_value_matrix', $filter)->num_rows();
                         //lastq();
                         if ($tx[$i] == 'JVM') {
                             $g = $jvm = $job_value_matrix_num > 0 ? $job_value_matrix->row()->value : 0;
                             //print_r('jvm='.$g.'-');
                         } elseif ($tx[$i] == 'VAR') {
                             $cm_param = GetAll('payroll_compensation_mix', array('session_id' => 'where/' . $session_id, 'job_class_id' => 'where/' . $det->job_class_id));
                             $cm_param_num = GetAll('payroll_compensation_mix', array('session_id' => 'where/' . $session_id, 'job_class_id' => 'where/' . $det->job_class_id))->num_rows();
                             //lastq();
                             $row = $cm_param->row();
                             $g = $var = $cm_param_num > 0 ? $row->var / 100 : 0 / 100;
                             //print_mz('var='.$var.'-');
                         } elseif ($tx[$i] == 'CONV') {
                             $g = getValue('value', 'payroll_exchange_rate', array('session_id' => 'where/' . $session_id));
                         } else {
                             $g = getValue('value', 'payroll_master_component', array('payroll_master_id' => 'where/' . $value->payroll_master_id, 'payroll_component_id' => 'where/' . $g));
                             //print_r($g.'-');
                         }
                         //print_r($value->component.'='.$g.'<br/>');
                         $tx[$i] = $g;
                     }
                     if (strpos($tx[$i], '%') !== false) {
                         $tx[$i] = substr_replace($tx[$i], '/100', -1);
                     } else {
                         false;
                     }
                     $r .= $tx[$i];
                 }
             } else {
                 $com = explode(PHP_EOL, $formula);
                 //print_ag($com);
                 for ($j = 0; $j < sizeof($com); $j++) {
                     $ntx = '';
                     $bwgs = getValue('value', 'payroll_master_component', array('payroll_master_id' => 'where/' . $value->payroll_master_id, 'payroll_component_id' => 'where/60'));
                     $hous = getValue('value', 'payroll_master_component', array('payroll_master_id' => 'where/' . $value->payroll_master_id, 'payroll_component_id' => 'where/66'));
                     //print_mz($xj[$i]);
                     $bwgshous = $bwgs + $hous;
                     //print_mz($bwgshous);
                     $xj = explode(' ', $com[$j]);
                     //print_ag($xj);
                     $n = '';
                     for ($i = 7; $i < sizeof($xj); $i++) {
                         if (preg_match("/[a-z]/i", $xj[$i])) {
                             //echo $j.'-'.$xj[$i].'<br/>';
                             switch ($xj[$i]) {
                                 case 'TK0':
                                     $xj[$i] = getValue('value', 'payroll_ptkp', array('title' => 'where/' . 'TK0'));
                                     break;
                                 case 'K0':
                                     $xj[$i] = getValue('value', 'payroll_ptkp', array('title' => 'where/' . 'K0'));
                                     break;
                                 case 'K1':
                                     $xj[$i] = getValue('value', 'payroll_ptkp', array('title' => 'where/' . 'K1'));
                                     //print_mz($xj[$i]);
                                     break;
                                 case 'K2':
                                     $xj[$i] = getValue('value', 'payroll_ptkp', array('title' => 'where/' . 'K2'));
                                     break;
                                 case 'K3':
                                     $xj[$i] = getValue('value', 'payroll_ptkp', array('title' => 'where/' . 'K3'));
                                     break;
                                 case 'UMK':
                                     //$xj[$i]=getValue('value', 'UMK', array('session'=>'where/'.$session_id));
                                     $xj[$i] = 3000000;
                                     break;
                                 default:
                                     //print_ag($xj[$i]);
                                     $code = getValue('id', 'payroll_component', array('code' => 'where/' . $xj[$i]));
                                     $xj[$i] = getValue('value', 'payroll_master_component', array('payroll_master_id' => 'where/' . $value->payroll_master_id, 'payroll_component_id' => 'where/' . $code));
                                     //print_ag($xj[$i]);
                                     break;
                             }
                             //print_ag('awa'.$j.'-'.$xj[$i]);
                         }
                         //print_ag($value->component);
                         //print_ag($xj[$i]);
                         if ($xj[$i] == '%') {
                             $xj[$i] = '/100';
                             //print_ag('ke_replace '.$xj[$i]);
                         }
                         $ntx .= $xj[$i];
                     }
                     //print_ag($value->code);
                     //print_ag($xj);
                     if ($xj[6] == '>') {
                         $f = current(explode(";", $ntx));
                         //print_mz($ntx);
                         $f = $this->evalmath($f);
                         $f = @eval("return " . $f . ";");
                         //print_mz($f);
                         $l = substr($ntx, strpos($ntx, ";") + 1);
                         //print_ag($j.'-'.$l);
                         $l = $this->evalmath($l);
                         $l = @eval("return " . $l . ";");
                         //print_ag('>'.$bwgshous.$xj[6].$f.'='.$r);
                         //print_mz($bwgshous.' > '.$f);
                         if ($bwgshous > $f) {
                             $r = $l;
                         }
                     } elseif ($xj[6] == '<') {
                         $f = current(explode(";", $ntx));
                         //print_mz($ntx);
                         $f = $this->evalmath($f);
                         $f = @eval("return " . $f . ";");
                         //print_mz($f);
                         $l = substr($ntx, strpos($ntx, ";") + 1);
                         //print_ag($j.'-'.$l);
                         $l = $this->evalmath($l);
                         $l = @eval("return " . $l . ";");
                         //print_ag('>'.$bwgshous.$xj[6].$f.'='.$r);
                         //print_mz($bwgshous.' > '.$f);
                         if ($bwgshous < $f) {
                             $r = $l;
                         }
                     } elseif ($xj[6] == '<=') {
                         $f = current(explode(";", $ntx));
                         //print_mz($ntx);
                         $f = $this->evalmath($f);
                         $f = @eval("return " . $f . ";");
                         //print_mz($f);
                         $l = substr($ntx, strpos($ntx, ";") + 1);
                         //print_ag($j.'-'.$l);
                         $l = $this->evalmath($l);
                         $l = @eval("return " . $l . ";");
                         //print_ag('>'.$bwgshous.$xj[6].$f.'='.$r);
                         //print_mz($bwgshous.' > '.$f);
                         if ($bwgshous <= $f) {
                             $r = $l;
                         }
                     } elseif ($xj[6] == '>=') {
                         $f = current(explode(";", $ntx));
                         //print_mz($ntx);
                         $f = $this->evalmath($f);
                         $f = @eval("return " . $f . ";");
                         //print_mz($f);
                         $l = substr($ntx, strpos($ntx, ";") + 1);
                         //print_ag($j.'-'.$l);
                         $l = $this->evalmath($l);
                         $l = @eval("return " . $l . ";");
                         //print_ag('>'.$bwgshous.$xj[6].$f.'='.$r);
                         //print_mz($bwgshous.' > '.$f);
                         if ($bwgshous >= $f) {
                             $r = $l;
                         }
                     }
                     //print_ag($bwgshous.$xj[6].$f.'='.$r);
                 }
                 //print_ag($bwgshous.$xj[6].$f.$r);
                 //print_ag($bwgshous.$xj[6].$f.$r);
                 //print_mz($com);
                 //print_ag($ntx);
                 //print_ag($f);
             }
             $f = $this->evalmath($r);
             $tz = @eval("return " . $f . ";");
             //print_ag($tz);
             //$is_condition = getValue('is_condition', 'payroll_component_value', array('payroll_component_id'=>'where/'.$value->component_id));
             //$is_condition = 0;
             if ($is_condition == 1) {
                 //$min = 1000;
                 //$max = 70000000;
                 //$min = getValue('min', 'payroll_component_value', array('payroll_component_id'=>'where/'.$value->component_id));
                 //$max = getValue('max', 'payroll_component_value', array('payroll_component_id'=>'where/'.$value->component_id));
                 if ($tz > $max) {
                     $tz = $max;
                 } elseif ($tz < $min) {
                     $tz = $min;
                 } else {
                     $tz = $tz;
                 }
             }
             $this->db->where('payroll_master_id', $value->payroll_master_id)->where('payroll_component_id', $component_id)->update('payroll_master_component', array('value' => $tz));
             //echo '<pre>';print_r($this->db->last_query());echo "</pre><br/>";
         }
     }
 }
Exemplo n.º 11
0
 private function _get_datatables_query($param = NULL)
 {
     //Parameter
     $exp = explode("~", $param['tgl']);
     $where = "date_full >= '" . $exp[0] . "' AND date_full <= '" . $exp[1] . "' ";
     if (isset($param['divisi']) && $param['divisi'] > 0) {
         $id_sec = "(";
         $q = GetAll("hris_orgs", array("parent_id" => "where/" . $param['divisi']));
         foreach ($q->result_array() as $r) {
             $id_sec .= "'" . $r['org_id'] . "',";
         }
         $id_sec = substr($id_sec, 0, -1) . ")";
         $where .= "AND org_id in " . $id_sec . " ";
     }
     if (isset($param['section']) && $param['section'] > 0) {
         $where .= "AND org_id='" . $param['section'] . "' ";
     }
     if (isset($param['position']) && $param['position'] > 0) {
         $where .= "AND job_class_id='" . $param['position'] . "' ";
     }
     if (isset($param['grade']) && $param['grade'] > 0) {
         $where .= "AND grade_job_class='" . $param['grade'] . "' ";
     }
     if (isset($param['regs'])) {
         if ($param['regs'] == "reguler") {
             $where .= "AND group_shift='N.A.' ";
         } else {
             if ($param['regs'] == "shift") {
                 $where .= "AND group_shift in ('A', 'B', 'C', 'D') ";
             }
         }
         //$this->db->where_in("group_shift", array("A","B","C","D"));
     }
     $person_id = permission();
     if ($person_id != 1) {
         $bawahan = CekBawahan($person_id);
         $id_bawahan = "('" . $person_id . "',";
         foreach ($bawahan as $r) {
             $id_bawahan .= "'" . $r . "',";
         }
         $id_bawahan = substr($id_bawahan, 0, -1) . ")";
         $where .= "AND person_id in " . $id_bawahan . " ";
     }
     //Query
     $select = "id, ext_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(late) as late, SUM(alpa) as alpa,SUM(off) as off, SUM(jh) as jh";
     $this->db->select($select);
     $this->db->from($this->table);
     $i = 0;
     $like = "";
     foreach ($this->column as $item) {
         if (isset($_POST['search']['value'])) {
             //($i===0) ? $this->db->like($item, $_POST['search']['value']) : $this->db->or_like($item, $_POST['search']['value']);
             $like .= $i === 0 ? " AND (" . $item . " LIKE '%" . $_POST['search']['value'] . "%' " : " OR " . $item . " LIKE '%" . $_POST['search']['value'] . "%' ";
         }
         $column[$i] = $item;
         $i++;
     }
     if ($like != "") {
         $like .= ")";
         $this->db->where($where . $like);
     } else {
         $this->db->where($where);
     }
     $this->db->group_by(array("id_employee", "person_nm"));
     if (isset($_POST['order'])) {
         $this->db->order_by($column[$_POST['order']['0']['column']], $_POST['order']['0']['dir']);
     } else {
         if (isset($this->order)) {
             $order = $this->order;
             $this->db->order_by(key($order), $order[key($order)]);
         }
     }
     $this->db->order_by("person_nm", "asc");
 }
Exemplo n.º 12
0
 function detail_email($id)
 {
     $sess_id = $this->data['sess_id'] = $this->session->userdata('user_id');
     $this->data['sess_nik'] = $sess_nik = get_nik($sess_id);
     $this->data['recruitment'] = $this->recruitment_model->recruitment($id)->result();
     $this->data['_num_rows'] = $this->recruitment_model->recruitment($id)->num_rows();
     $this->data['status'] = getAll('recruitment_status', array('is_deleted' => 'where/0'));
     $this->data['urgensi'] = getAll('recruitment_urgensi', array('is_deleted' => 'where/0'));
     $jk = explode(',', getAll('users_recruitment_kualifikasi', array('id' => 'where/' . $id))->row('jenis_kelamin_id'));
     $pendidikan = explode(',', getAll('users_recruitment_kualifikasi', array('id' => 'where/' . $id))->row('pendidikan_id'));
     $komputer = explode(',', getAll('users_recruitment_kemampuan', array('id' => 'where/' . $id))->row('komputer'));
     $this->data['jenis_kelamin'] = $this->recruitment_model->get_jk($jk);
     $this->data['pendidikan'] = $this->recruitment_model->get_pendidikan($pendidikan);
     $this->data['komputer'] = $this->recruitment_model->get_komputer($komputer);
     $this->data['position_pengaju'] = $this->get_user_position($this->recruitment_model->recruitment($id)->row_array()['user_id']);
     $this->data['approval_status'] = GetAll('approval_status', array('is_deleted' => 'where/0'));
     return $this->load->view('form_recruitment/recruitment_mail', $this->data, TRUE);
 }
Exemplo n.º 13
0
 function add()
 {
     error_reporting(0);
     permissionUser();
     //print_mz($this->input->post());
     $laporan = $this->input->post('laporan');
     $m_v = $this->input->post('m_v');
     $user = $this->input->post('user_id');
     foreach ($laporan as $m) {
         $cek = GetAll('report_permission', array('user_id' => 'where/' . $user, 'menu_id' => 'where/' . $m))->num_rows();
         $data['menu_id'] = $m;
         $data['create'] = $m_c[$m] ? '1' : '0';
         $data['view'] = $m_v[$m] ? '1' : '0';
         $data['update'] = $m_u[$m] ? '1' : '0';
         $data['delete'] = $m_d[$m] ? '1' : '0';
         $data['user_id'] = $user;
         $data['user_group'] = GetValue('group_id', 'users_groups', array('user_id' => 'where/' . $user));
         if ($cek == 0) {
             $this->db->insert('report_permission', $data);
         } else {
             $this->db->where(array('user_id' => $user, 'menu_id' => $m));
             $this->db->update('report_permission', $data);
         }
     }
     redirect($this->module . '/' . $this->file_name, 'refresh');
 }
Exemplo n.º 14
0
 function edit($id)
 {
     permission();
     $q = GetAll("kg_kehadirandetil", array("id" => "where/" . $id));
     $r = $q->result_array();
     $data['val'] = $r[0];
     $data['tgl'] = $r[0]['tahun'] . "-" . $r[0]['bulan'] . "-" . $r[0]['tanggal'];
     $data['absensi'] = array(array("jh", "Hadir"), array("off", "Off"), array("cuti", "Cuti"), array("ijin", "Ijin"), array("sakit", "Sakit"), array("alpa", "Alpa"));
     //print_mz($data['absensi']);
     for ($i = 0; $i <= 20; $i++) {
         $opt[$i] = $i;
     }
     $data['opt_lembur'] = $opt;
     $this->load->view('attendance_edit', $data);
     //$this->_render_page($this->filename.'_edit',$data);
 }
Exemplo n.º 15
0
 function INV($id)
 {
     permissionUser();
     $this->data['id'] = $id;
     $this->data[$this->file_name] = GetAll('cash_ledger', array('id' => 'where/' . $id));
     $this->data[$this->file_name . '_list'] = GetAll('cash_ledger_list', array('id' => 'where/' . $id));
     $this->load->library('mpdf60/mpdf');
     $html = $this->load->view($this->module . '/' . $this->file_name . '/invoice', $this->data, true);
     $mpdf = new mPDF();
     $mpdf = new mPDF('A4');
     $mpdf->WriteHTML($html);
     $mpdf->Output($id . '-' . $title . '.pdf', 'I');
 }
Exemplo n.º 16
0
 function GetOTCal($id_emp, $date)
 {
     $exp = explode("-", $date);
     $att_start_period = GetConfigDirect('att_start_period');
     if ($exp[2] < $att_start_period) {
         $awal = date("Y-m", mktime(0, 0, 0, $exp[1] - 1, $exp[2], $exp[0])) . "-" . $att_start_period;
     } else {
         $awal = $exp[0] . "-" . $exp[1] . "-" . $att_start_period;
     }
     $acc = 0;
     $sum_hour = 0;
     $qq = GetAll("kg_view_overtime", array("id_employee" => "where/" . $id_emp, "ovt_status" => "where/Approve", "date_full >=" => "where/" . $awal, "date_full <=" => "where/" . $date, "date_temp" => "where/0000-00-00"));
     if ($qq->num_rows() > 0) {
         foreach ($qq->result_array() as $ss) {
             if ($ss['job_level'] != "nonmanagement") {
                 if ($ss['ovt_hour_sum'] >= 2) {
                     $acc += $ss['ovt_hour_sum'];
                     $sum_hour += $ss['ovt_hour_sum'];
                 }
             } else {
                 $acc += $ss['ovt_hour_cal'];
                 $sum_hour += $ss['ovt_hour_sum'];
             }
         }
     }
     $qq = GetAll("kg_view_overtime", array("id_employee" => "where/" . $id_emp, "ovt_status" => "where/Approve", "date_temp >=" => "where/" . $awal, "date_temp <=" => "where/" . $date));
     if ($qq->num_rows() > 0) {
         foreach ($qq->result_array() as $ss) {
             if ($ss['job_level'] != "nonmanagement") {
                 if ($ss['ovt_hour_sum'] >= 2) {
                     $acc += $ss['ovt_hour_sum'];
                     $sum_hour += $ss['ovt_hour_sum'];
                 }
             } else {
                 $acc += $ss['ovt_hour_cal'];
                 $sum_hour += $ss['ovt_hour_sum'];
             }
         }
     }
     return $sum_hour . "~" . $acc;
 }
Exemplo n.º 17
0
 public function loadsatuanexist($id)
 {
     $data['ex'] = GetAll('barang_satuan', array('barang_id' => 'where/' . $id))->result_array();
     $data['options_satuan'] = options_row('barang', 'get_satuan', 'id', 'title', '-- Pilih Satuan --');
     $this->load->view('barang/satuan_exist', $data);
 }
Exemplo n.º 18
0
 function exe_shift($person_id, $tgl)
 {
     $webmaster_id = permission();
     $exp = explode("-", $tgl);
     $thn = $exp[0];
     $grup = array("N.A.", "A", "B", "C", "D");
     $bln = array("01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12");
     if ($thn == "2016") {
         $jadwal_grup['N.A.'] = array("reg", "off", "off", "reg", "reg", "reg", "reg", "reg", "off", "off", "reg", "reg", "reg", "reg", "reg", "off", "off", "reg", "reg", "reg", "reg", "reg", "off", "off", "reg", "reg", "reg", "reg");
         $jadwal_grup['A'] = array(1, 2, 2, 2, "off", 3, 3, "off", 1, 1, 1, 2, 2, "off", 3, 3, "off", "off", 1, 1, 2, 2, "off", 3, 3, 3, "off", 1);
         $jadwal_grup['B'] = array("off", 1, 1, 1, 2, 2, "off", 3, 3, "off", "off", 1, 1, 2, 2, "off", 3, 3, 3, "off", 1, 1, 2, 2, 2, "off", 3, 3);
         $jadwal_grup['C'] = array(3, 3, "off", "off", 1, 1, 2, 2, "off", 3, 3, 3, "off", 1, 1, 2, 2, 2, "off", 3, 3, "off", 1, 1, 1, 2, 2, "off");
         $jadwal_grup['D'] = array(2, "off", 3, 3, 3, "off", 1, 1, 2, 2, 2, "off", 3, 3, "off", 1, 1, 1, 2, 2, "off", 3, 3, "off", "off", 1, 1, 2);
     } else {
         if ($thn == "2015") {
             $jadwal_grup['N.A.'] = array("reg", "reg", "off", "off", "reg", "reg", "reg", "reg", "reg", "off", "off", "reg", "reg", "reg", "reg", "reg", "off", "off", "reg", "reg", "reg", "reg", "reg", "off", "off", "reg", "reg", "reg");
             $jadwal_grup['A'] = array(1, 1, 2, 2, 2, "off", 3, 3, "off", 1, 1, 1, 2, 2, "off", 3, 3, "off", "off", 1, 1, 2, 2, "off", 3, 3, 3, "off");
             $jadwal_grup['B'] = array(3, "off", 1, 1, 1, 2, 2, "off", 3, 3, "off", "off", 1, 1, 2, 2, "off", 3, 3, 3, "off", 1, 1, 2, 2, 2, "off", 3);
             $jadwal_grup['C'] = array("off", 3, 3, "off", "off", 1, 1, 2, 2, "off", 3, 3, 3, "off", 1, 1, 2, 2, 2, "off", 3, 3, "off", 1, 1, 1, 2, 2);
             $jadwal_grup['D'] = array(2, 2, "off", 3, 3, 3, "off", 1, 1, 2, 2, 2, "off", 3, 3, "off", 1, 1, 1, 2, 2, "off", 3, 3, "off", "off", 1, 1);
         }
     }
     //echo $thn."<br>";
     //print_mz($jadwal_grup);
     //foreach($grup as $g) {
     $emp = GetAll("kg_view_employee", array("person_id" => "where/" . $person_id));
     foreach ($emp->result_array() as $r) {
         $g = $r['group_shift'];
         if (isset($jadwal_grup[$g])) {
             $id_employee = $person_id;
             $loop = 0;
             foreach ($bln as $b) {
                 if ($b >= $exp[1]) {
                     $datanginput = array('id_employee' => $id_employee, 'bulan' => $b, 'tahun' => $thn);
                     $jml_hari = date("t", mktime(0, 0, 0, $b, 1, $thn));
                     $awal = $b == $exp[1] ? intval($exp[2]) : 1;
                     for ($i = $awal; $i <= $jml_hari; $i++) {
                         if ($loop == 28) {
                             $loop = 0;
                         }
                         $datanginput['tgl_' . $i] = $jadwal_grup[$g][$loop];
                         $loop++;
                     }
                     $temp_datahitung = $datanginput;
                     unset($temp_datahitung['bulan']);
                     unset($temp_datahitung['tahun']);
                     unset($temp_datahitung['id_employee']);
                     $hitung = array_count_values($temp_datahitung);
                     //print_mz($datanginput);
                     if (!isset($hitung['1'])) {
                         $hitung['1'] = 0;
                     }
                     if (!isset($hitung['2'])) {
                         $hitung['2'] = 0;
                     }
                     if (!isset($hitung['3'])) {
                         $hitung['3'] = 0;
                     }
                     if (!isset($hitung['reg'])) {
                         $hitung['reg'] = 0;
                     }
                     if (!isset($hitung['off'])) {
                         $hitung['off'] = 0;
                     }
                     $datanginput['jum_p'] = $hitung['1'];
                     $datanginput['jum_s'] = $hitung['2'];
                     $datanginput['jum_m'] = $hitung['3'];
                     $datanginput['jum_ns'] = $hitung['reg'];
                     $datanginput['jum_off'] = $hitung['off'];
                     $cekdata = GetValue("id", "kg_jadwal_shift", array("id_employee" => "where/" . $id_employee, "bulan" => "where/" . $b, "tahun" => "where/" . $thn));
                     if (!$cekdata) {
                         $datanginput['create_user_id'] = $webmaster_id;
                         $datanginput['create_date'] = date("Y-m-d H:i:s");
                         //print_mz($datanginput);
                         $this->db->insert('kg_jadwal_shift', $datanginput);
                         //$log[]=date("d-m-Y H:i:s").'; BERHASIL! Karyawan dengan nama '.GetValue('name','kg_employee',array('nik'=>'where/'.$nik)).' dari departemen '.GetValue('title','kg_department',array('id'=>'where/'.GetValue('id_department','kg_employee',array('nik'=>'where/'.$nik)))).'. untuk periode '.$bln.' - '.$thn.' telah diinput';
                     } else {
                         $datanginput['modify_user_id'] = $webmaster_id;
                         $datanginput['modify_date'] = date("Y-m-d H:i:s");
                         $this->db->where("id_employee", $id_employee);
                         $this->db->where("bulan", $b);
                         $this->db->where("tahun", $thn);
                         $this->db->update('kg_jadwal_shift', $datanginput);
                         //lastq();
                     }
                 } else {
                     $datanginput = array('id_employee' => $id_employee, 'bulan' => $b, 'tahun' => $thn);
                     $jml_hari = date("t", mktime(0, 0, 0, $b, 1, $thn));
                     //$awal = $b==$exp[1] ? intval($exp[2]) : 1;
                     for ($i = 1; $i <= $jml_hari; $i++) {
                         if ($loop == 28) {
                             $loop = 0;
                         }
                         //$datanginput['tgl_'.$i]=$jadwal_grup[$g][$loop];
                         $loop++;
                     }
                 }
             }
         }
     }
     //}
 }
Exemplo n.º 19
0
 function form_cuti_pdf($id)
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     }
     $sess_id = $this->data['sess_id'] = $this->session->userdata('user_id');
     $user_id = getValue('user_id', 'users_cuti', array('id' => 'where/' . $id));
     $user_nik = get_nik($user_id);
     $cuti_details = $this->data['form_cuti'] = $this->form_cuti_model->form_cuti_supervisor($id)->result();
     $this->data['_num_rows'] = $this->form_cuti_model->form_cuti_supervisor($id)->num_rows();
     $this->data['approval_status'] = GetAll('approval_status', array('is_deleted' => 'where/0'));
     $this->data['sisa_cuti'] = !empty($this->get_sisa_cuti($user_nik)[0]['ENTITLEMENT']) ? $this->get_sisa_cuti($user_nik)[0]['ENTITLEMENT'] : '-';
     $this->data['id'] = $id;
     $title = $this->data['title'] = 'Form Cuti-' . get_name($user_id);
     $this->load->library('mpdf60/mpdf');
     $html = $this->load->view('cuti_pdf', $this->data, true);
     $mpdf = new mPDF();
     $mpdf = new mPDF('A4');
     $mpdf->WriteHTML($html);
     $mpdf->Output($id . '-' . $title . '.pdf', 'I');
 }
Exemplo n.º 20
0
 function carilist()
 {
     $v = $_POST['v'];
     $cariref = $this->db->query("SELECT * FROM sales_order WHERE (id='{$v}' OR so='{$v}') ");
     if ($cariref->num_rows() > 0) {
         $data['refid'] = $cariref->row_array();
         //if($data['refid']['is_app_lv1']==1){
         if ($data['refid']['is_closed'] == 0) {
             $data['reftype'] = 'sales_order';
             $cekparsial = $this->db->query("SELECT * FROM stok_pengeluaran_list WHERE ref_type='" . $data['reftype'] . "' AND order_id='" . $data['refid']['id'] . "' GROUP BY pengeluaran_id ORDER BY id DESC ");
             $so = getValue('so', 'sales_order', array('id' => 'where/' . $v));
             $pengiriman_ke = getAll('stok_pengeluaran', array('ref_id' => 'where/' . $v));
             // lastq();
             if ($cekparsial->num_rows() > 0) {
                 $data['part'] = TRUE;
                 $data['partno'] = $pengiriman_ke->num_rows() + 1;
                 $data['partdata'] = $cekparsial->row_array();
             }
             $data['list'] = GetAll('sales_order_list', array('order_id' => 'where/' . $data['refid']['id']))->result_array();
             $this->load->view('stok/pengeluaran/input_list', $data);
         }
         //}
     }
 }
Exemplo n.º 21
0
 public function get_modal()
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     } elseif (!$this->ion_auth->is_admin()) {
         //redirect them to the home page because they must be an administrator to view this
         //return show_error('You must be an administrator to view this page.');
         return show_error('You must be an administrator to view this page.');
     } else {
         //list of filterize limit comp_session for pagination
         $this->data['comp_session'] = $this->comp_session_model->comp_session()->result();
         $f_payroll_type = array("is_deleted" => 0);
         $q_payroll_type = GetAll('payroll_type', $f_payroll_type);
         $this->data['payroll_type'] = $q_payroll_type->num_rows() > 0 ? $q_payroll_type : array();
         $this->_render_page('comp_session/modal/index', $this->data);
     }
 }
Exemplo n.º 22
0
 function detail($id, $first_login = FALSE)
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     } elseif ($id != $this->session->userdata('user_id') && !$this->ion_auth->is_admin()) {
         //redirect them to the home page because they must be an administrator to view this
         //return show_error('You must be an administrator to view this page.');
         return show_error('You can not view this page.');
     } else {
         $this->data['message'] = validation_errors() ? validation_errors() : $this->session->flashdata('message');
         $this->data['csrf'] = $this->_get_csrf_nonce();
         $user = $this->person_model->getUsers($id)->row();
         $user_emp = $this->person_model->getUserEmp($id)->row();
         $user_course = $this->person_model->getUserCourse($id);
         $user_certificate = $this->person_model->getUserCertificate($id);
         $user_education = $this->person_model->getUserEducation($id);
         $user_exp = $this->person_model->getUserexperience($id);
         $user_sk = $this->person_model->getUserSk($id);
         $user_sti = $this->person_model->getUserSti($id);
         $user_jabatan = $this->person_model->getUserJabatan($id);
         $user_award = $this->person_model->getUserAward($id);
         $user_ikatan = $this->person_model->getUserIkatanDinas($id);
         $jsondata = file_get_contents(get_api_key() . 'users/lists/format/json');
         $data = json_decode($jsondata, true);
         if ($this->cekNik($data, 'EMPLID', $user->nik) == TRUE) {
             $getdata = file_get_contents(get_api_key() . 'users/list/EMPLID/' . $user->nik . '/format/json');
             $data = json_decode($getdata, true);
             $url = get_api_key() . 'users/employement/EMPLID/' . $user->nik . '/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);
                 $this->data['user_info'] = $user_info;
             } else {
                 //$this->data['user_info'] = $this->form_cuti_model->where('users.id',$user_id)->form_cuti_input()->result();
             }
             //employee identity
             $this->data['id'] = $user->id;
             $this->data['nik'] = !empty($user->nik) ? $user->nik : '-';
             $this->data['bod'] = !empty($user->bod) ? $user->bod : '-';
             $this->data['is_birthday_reminder'] = $user->is_birthday_reminder;
             $this->data['first_login'] = $first_login;
             $this->data['first_name'] = !empty($user->first_name) ? $user->first_name : '';
             $this->data['last_name'] = !empty($user->last_name) ? $user->last_name : '';
             $this->data['business_unit'] = !empty($user->organization_title) ? $user->organization_title : '';
             $this->data['marital'] = !empty($user->marital_title) ? $user->marital_title : '';
             $this->data['phone'] = !empty($user->phone) ? $user->phone : '';
             $this->data['email'] = !empty($user->email) ? $user->email : '';
             $this->data['previous_email'] = !empty($user_info['PREVIOUSEMAIL']) ? $user_info['PREVIOUSEMAIL'] : '-';
             $this->data['bb_pin'] = !empty($user_info['PINBB']) ? $user_info['PINBB'] : '-';
             $this->data['photo'] = !empty($user->photo) ? $user->photo : '';
             $this->data['s_kk'] = $this->form_validation->set_value('kk', $user->scan_kk);
             $this->data['s_akta'] = $this->form_validation->set_value('akta', $user->scan_akta);
             $user_folder = $user->id . $user->first_name;
             $this->data['u_folder'] = $user_folder;
             $url = get_api_key() . 'users/course/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getcourse = file_get_contents($url);
                 $course = json_decode($getcourse, true);
                 $this->data['course'] = $course;
             } else {
                 $this->data['course'] = $user_course->result_array();
             }
             $url = get_api_key() . 'users/certificate/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getcertificate = file_get_contents(get_api_key() . 'users/certificate/EMPLID/' . $user->nik . '/format/json');
                 $certificate = json_decode($getcertificate, true);
                 $this->data['certificate'] = $certificate;
             } else {
                 $this->data['certificate'] = $user_certificate->result_array();
             }
             $url = get_api_key() . 'users/award/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getaward = file_get_contents(get_api_key() . 'users/award/EMPLID/' . $user->nik . '/format/json');
                 $award = json_decode($getaward, true);
                 $this->data['award'] = $award;
             } else {
                 $this->data['award'] = $user_award->result_array();
             }
             //Education Tab API
             $url = get_api_key() . 'users/education/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $geteducation = file_get_contents(get_api_key() . 'users/education/EMPLID/' . $user->nik . '/format/json');
                 $education = json_decode($geteducation, true);
                 $this->data['education'] = $education;
             } else {
                 $this->data['education'] = $user_education->result_array();
             }
             //Experience Tab API
             $url = get_api_key() . 'users/experience/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getexperience = file_get_contents(get_api_key() . 'users/experience/EMPLID/' . $user->nik . '/format/json');
                 $experience = json_decode($getexperience, true);
                 $this->data['experience'] = $experience;
             } else {
                 $this->data['experience'] = $user_exp->result_array();
             }
             //SK Tab API
             $url = get_api_key() . 'users/sk/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getsk = file_get_contents(get_api_key() . 'users/sk/EMPLID/' . $user->nik . '/format/json');
                 $sk = json_decode($getsk, true);
                 $this->data['sk'] = $sk;
             } else {
                 $this->data['sk'] = $user_sk->result_array();
             }
             //STI Tab API
             $url = get_api_key() . 'users/sti/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getsti = file_get_contents(get_api_key() . 'users/sti/EMPLID/' . $user->nik . '/format/json');
                 $sti = json_decode($getsti, true);
                 $this->data['sti'] = $sti;
             } else {
                 $this->data['sti'] = $user_sti->result_array();
             }
             //Riwayat_jabatan Tab API
             $url = get_api_key() . 'users/jabatan/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getjabatan = file_get_contents(get_api_key() . 'users/jabatan/EMPLID/' . $user->nik . '/format/json');
                 $jabatan = json_decode($getjabatan, true);
                 $this->data['jabatan'] = $jabatan;
             } else {
                 $this->data['jabatan'] = $user_exp->result_array();
             }
             //Ikatan_Dinas Tab API
             $url = get_api_key() . 'users/ikatan_dinas/EMPLID/' . $user->nik . '/format/json';
             $headers = get_headers($url);
             $response = substr($headers[0], 9, 3);
             if ($response != "404") {
                 $getikatan_dinas = file_get_contents(get_api_key() . 'users/ikatan_dinas/EMPLID/' . $user->nik . '/format/json');
                 $ikatan_dinas = json_decode($getikatan_dinas, true);
                 $this->data['ikatan_dinas'] = $ikatan_dinas;
             } else {
                 $this->data['ikatan_dinas'] = $user_exp->result_array();
             }
             $this->data['aviva'] = !empty($user_emp->aviva) ? $user_emp->aviva : !empty($user_info['AVIVA']) ? $user_info['AVIVA'] : '-';
             $this->data['bpjs_kerja'] = !empty($user_emp->aviva) ? $user_emp->aviva : !empty($user_info['JAMSOSTEK']) ? $user_info['JAMSOSTEK'] : '-';
             $this->data['ktp'] = !empty($user_emp->aviva) ? $user_emp->aviva : !empty($user_info['KTP']) ? $user_info['KTP'] : '-';
             $this->data['ktp_valid_date'] = !empty($user_emp->aviva) ? $user_emp->aviva : !empty($user_info['KTPVALIDDATE']) ? $user_info['KTPVALIDDATE'] : '-';
             $this->data['npwp'] = !empty($user_emp->aviva) ? $user_emp->aviva : !empty($user_info['NPWP']) ? $user_info['NPWP'] : '-';
             $this->data['tax'] = !empty($user_emp->aviva) ? $user_emp->aviva : !empty($user_info['TAX']) ? $user_info['TAX'] : '-';
             $this->data['bpjs_kesehatan'] = !empty($user_info['BPJS']) ? $user_info['BPJS'] : '-';
             $this->data['bpjs_date'] = !empty($user_info['BPJS']) ? $user_info['BPJSDATE'] : '-';
             $this->data['bumida'] = !empty($user_info['BUMIDA']) ? $user_info['BUMIDA'] : '-';
             $this->data['bumida_date'] = !empty($user_info['BPJS']) ? $user_info['BUMIDADATE'] : '-';
             $this->data['seniority_date'] = !empty($user_emp->seniority_date) ? $user_emp->seniority_date : !empty($user_info['SENIORITYDATE']) ? $user_info['SENIORITYDATE'] : '-';
             $this->data['position'] = !empty($user_emp->position) ? $user_emp->position : !empty($user_info['POSITION']) ? $user_info['POSITION'] : '-';
             $this->data['organization'] = !empty($user_info['ORGANIZATION']) ? $user_info['ORGANIZATION'] : '-';
             $this->data['bu'] = !empty($user_info['BU']) ? $user_info['BU'] : '-';
             $this->data['empl_status'] = !empty($user_emp->empl_status) ? $user_emp->empl_status : !empty($user_info['EMPLOYEESTATUS']) ? $user_info['EMPLOYEESTATUS'] : '-';
             $this->data['employee_status'] = !empty($user_emp->employee_status) ? $user_emp->employee_status : !empty($user_info['STATUS']) ? $user_info['STATUS'] : '-';
             $this->data['cost_center'] = !empty($user_emp->cost_center) ? $user_emp->cost_center : !empty($user_info['COSTCENTER']) ? $user_info['COSTCENTER'] : '-';
             $this->data['position_group'] = !empty($user_emp->position_group) ? $user_emp->position_group : !empty($user_info['POSITIONGROUP']) ? $user_info['POSITIONGROUP'] : '-';
             $this->data['grade'] = !empty($user_emp->grade) ? $user_emp->grade : !empty($user_info['GRADE']) ? $user_info['GRADE'] : '-';
             $this->data['resign_reason'] = !empty($user_emp->resign_reason) ? $user_emp->resign_reason : !empty($user_info['RESIGNREASONCODEID']) ? $user_info['RESIGNREASONCODEID'] : '-';
             $this->data['active_inactive'] = !empty($user_emp->active_inactive) ? $user_emp->active_inactive : !empty($user_info['ACTIVEINACTIVE']) ? $user_info['ACTIVEINACTIVE'] : '-';
         } else {
             //employement
             $this->data['seniority_date'] = !empty($user_emp->seniority_date) ? $user_emp->seniority_date : '-';
             $this->data['position'] = !empty($user_emp->position) ? $user_emp->position : '-';
             $this->data['empl_status'] = !empty($user_emp->empl_status) ? $user_emp->empl_status : '-';
             $this->data['employee_status'] = !empty($user_emp->employee_status) ? $user_emp->employee_status : '-';
             $this->data['cost_center'] = !empty($user_emp->cost_center) ? $user_emp->cost_center : '-';
             $this->data['position_group'] = !empty($user_emp->position_group) ? $user_emp->position_group : '-';
             $this->data['grade'] = !empty($user_emp->grade) ? $user_emp->grade : '-';
             $this->data['resign_reason'] = !empty($user_emp->resign_reason) ? $user_emp->resign_reason : '-';
             $this->data['active_inactive'] = !empty($user_emp->active_inactive) ? $user_emp->active_inactive : '-';
         }
         $this->data['s_photo'] = $this->form_validation->set_value('photo', $user->photo);
         $user_folder = $user->id . $user->first_name;
         $this->data['u_folder'] = $user_folder;
         //Company Sponsor Course Tab
         $this->data['user_course'] = $user_course;
         //Certificate Tab
         $this->data['user_certificate'] = $user_certificate;
         //Education Tab
         $this->data['user_education'] = $user_education;
         //Experience Tab
         $this->data['user_exp'] = $user_exp;
         //SuraKeputusan Tab
         $this->data['user_sk'] = $user_sk;
         $this->data['user_sti'] = $user_sti;
         $this->data['user_jabatan'] = $user_jabatan;
         $this->data['user_award'] = $user_award;
         $this->data['user_ikatan'] = $user_ikatan;
         //Mazhters
         $dt_temp = date("d");
         //$dt_temp = date("d", mktime(1, 1, 1, date("m"), date("d")-1, date("Y")));
         $this->baca_cron($dt_temp, date("m"), date("Y"));
         $mchID = GetValue("mchID", "users", array("id" => "where/" . $id));
         $q = GetAll("view_att", array("mchID" => "where/" . $mchID));
         $this->data['rekap_hadir'] = array("total" => 0, "hadir" => 0, "terlambat" => 0, "cuti" => 0, "ijin" => 0, "sakit" => 0, "alpa" => 0, "off" => 0);
         foreach ($q->result_array() as $r) {
             if ($r['jh'] || $r['terlambat']) {
                 $this->data['rekap_hadir']['hadir']++;
             }
             if ($r['terlambat']) {
                 $this->data['rekap_hadir']['terlambat']++;
             }
             if ($r['ijin']) {
                 $this->data['rekap_hadir']['ijin']++;
             }
             if ($r['sakit']) {
                 $this->data['rekap_hadir']['sakit']++;
             }
             if ($r['cuti']) {
                 $this->data['rekap_hadir']['cuti']++;
             }
             if ($r['alpa']) {
                 $this->data['rekap_hadir']['alpa']++;
             }
             if ($r['off']) {
                 $this->data['rekap_hadir']['off']++;
             }
             $this->data['rekap_hadir']['total']++;
         }
         if ($this->data['rekap_hadir']['hadir'] != 0) {
             $this->data['persen_hadir'] = number_format($this->data['rekap_hadir']['hadir'] / $this->data['rekap_hadir']['total'] * 100, 1) != 0 ? number_format($this->data['rekap_hadir']['hadir'] / $this->data['rekap_hadir']['total'] * 100, 1) : $this->data['rekap_hadir']['hadir'];
             $this->data['persen_terlambat'] = number_format($this->data['rekap_hadir']['terlambat'] / $this->data['rekap_hadir']['total'] * 100, 1);
         } else {
             $this->data['persen_hadir'] = 0;
             $this->data['persen_terlambat'] = 0;
         }
         //End Mazhters
         if (date("m-d") !== date('m-d', strtotime($user->bod)) && $user->is_birthday_reminder == 1) {
             $this->db->query("update users set is_birthday_reminder = 0 where id = {$id}");
         }
         $this->_render_page('person/detail', $this->data);
     }
 }
Exemplo n.º 23
0
 function get_modal()
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     } elseif (!$this->ion_auth->is_admin()) {
         //redirect them to the home page because they must be an administrator to view this
         //return show_error('You must be an administrator to view this page.');
         return show_error('You must be an administrator to view this page.');
     } else {
         $organization = $this->organization_model->getOrganization();
         $this->data['organization'] = $organization;
         $f_organization_class = array("is_deleted" => 0);
         $q_organization_class = GetAll('organization_class', $f_organization_class);
         $this->data['q_organization_class'] = $q_organization_class;
         $this->data['organization_class'] = $q_organization_class->num_rows() > 0 ? $q_organization_class : array();
         $f_organization = array("is_deleted" => 0);
         $q_organization = GetAll('organization', $f_organization);
         $this->data['q_organization'] = $q_organization;
         $this->data['parent'] = $q_organization->num_rows() > 0 ? $q_organization : array();
         $this->_render_page('organization/modal/index', $this->data);
     }
 }
Exemplo n.º 24
0
 function bast($id = NULL)
 {
     permissionUser();
     $this->data['id'] = $id;
     $this->data[$this->file_name] = GetAll($this->module . '_' . $this->file_name, array('id' => 'where/' . $id))->row_array();
     $this->data[$this->file_name . '_list'] = GetAll($this->module . '_' . $this->file_name . '_list', array('id' => 'where/' . $id));
     $this->load->library('mpdf60/mpdf');
     $html = $this->load->view($this->module . '/' . $this->file_name . '/bast', $this->data, true);
     to_doc($html, 'BAST');
     //        $mpdf = new mPDF();
     //        $mpdf = new mPDF('A4');
     //        $mpdf->WriteHTML($html);
     //        $mpdf->Output($id.'_BAST-'.$title.'.pdf', 'I');
 }
Exemplo n.º 25
0
 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');
 }
Exemplo n.º 26
0
 public function get_modal()
 {
     if (!$this->ion_auth->logged_in()) {
         //redirect them to the login page
         redirect('auth/login', 'refresh');
     } elseif (!$this->ion_auth->is_admin()) {
         //redirect them to the home page because they must be an administrator to view this
         //return show_error('You must be an administrator to view this page.');
         return show_error('You must be an administrator to view this page.');
     } else {
         //list of filterize limit library for pagination
         $this->data['library'] = $this->library_model->library()->result();
         $f_parent_status = array("is_deleted" => 0);
         $q_parent_status = GetAll('library', $f_parent_status);
         $this->data['parent_group'] = $q_parent_status->num_rows() > 0 ? $q_parent_status : array();
         $this->_render_page('library/modal/index', $this->data);
     }
 }
Exemplo n.º 27
0
 /**
  * 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);
 }
Exemplo n.º 28
0
 function list_data($id_emp = NULL, $period = NULL)
 {
     $period = "2015-11-16~2015-12-15";
     permission();
     $data['emp'] = GetAll("kg_view_employee", array("person_id" => "where/" . $id_emp));
     $data['id_emp'] = $id_emp;
     $data['period'] = $period;
     $data['date'] = substr($period, 11, 10);
     $exp = explode("-", $data['date']);
     $data['last_date'] = date("Y-m-d", mktime(0, 0, 0, $exp[1], $exp[0], $exp[2]));
     $data['ot_rasio'] = GetOTRasio($id_emp, $data['date']);
     $data['ot_rasio_last'] = GetOTRasio($id_emp, $data['last_date']);
     $data['ot_rasio_selisih'] = str_replace("%", "", $data['ot_rasio']) - str_replace("%", "", $data['ot_rasio_last']);
     if (str_replace("%", "", $data['ot_rasio']) > str_replace("%", "", $data['ot_rasio_last'])) {
         $data['high_low'] = "higher";
     } else {
         $data['high_low'] = "lower";
     }
     //$data['detail'] = $this->att->get_by_id($id_emp, $param)->result_array();
     $this->load->view('list_data', $data);
 }
Exemplo n.º 29
0
 function flickr_api_setup()
 {
     $CI =& get_instance();
     //$CI->load->library('flickr_api','flickr_api');
     $q = GetAll('kg_flickr_api', array("id" => "where/1"));
     $val = $q->row_array();
     $flickr_api_params = array('request_format' => $val['request_format'], 'response_format' => $val['response_format'], 'api_key' => $val['api_key'], 'secret' => $val['secret_key'], 'cache_use_db' => FALSE, 'cache_expiration' => $val['cache_expiration'], 'cache_max_rows' => $val['cache_max_rows']);
     //$CI->flickr_api->initialize($flickr_api_params);
     $CI->phpflickr->phpflickr($val['api_key'], $val['secret_key'], true);
     return $val;
 }
Exemplo n.º 30
0
 public function load_badge()
 {
     $data['notification_num'] = GetAll('chat', array('is_read' => 'where/0', 'receiver_id' => 'where/' . sessId()))->num_rows();
     $this->load->view('message/badges', $data);
 }