?> ">Company Session</a> </li> <li > <a href="<?php echo site_url('organization'); ?> ">Organization</a> </li> <li > <a href="<?php echo site_url('position'); ?> ">Position</a> </li> <!--<li > <a href="<?php echo site_url('library_table'); ?> ">Library Reference Table</a> </li>--> <?php if (is_admin_inventaris()) { ?> <li ><a href="<?php echo site_url('inventory'); ?> "><i class="icon-briefcase"></i> Inventaris</a> </li><?php } ?> <?php if (is_admin()) { ?> <li ><a href="<?php echo site_url('approval'); ?> "> Approval</a> </li><?php }
function detail_email($user_id) { $this->data['sess_nik'] = $sess_nik = get_nik($this->session->userdata('user_id')); $superior_it = getValue('user_app_lv1_it', 'users_exit', array('user_id' => 'where/' . $user_id)); $superior_hrd = getValue('user_app_lv1_hrd', 'users_exit', array('user_id' => 'where/' . $user_id)); $superior_logistik = getValue('user_app_lv1_logistik', 'users_exit', array('user_id' => 'where/' . $user_id)); $superior_koperasi = getValue('user_app_lv1_koperasi', 'users_exit', array('user_id' => 'where/' . $user_id)); $superior_perpus = getValue('user_app_lv1_perpus', 'users_exit', array('user_id' => 'where/' . $user_id)); $superior_perpus = getValue('user_app_lv1_keuangan', 'users_exit', array('user_id' => 'where/' . $user_id)); if (!$this->ion_auth->logged_in()) { redirect('auth/login', 'refresh'); } elseif (is_admin_inventaris() || $sess_nik == $superior_hrd || $sess_nik == $superior_it || $sess_nik == $superior_logistik || $sess_nik == $superior_koperasi || $sess_nik == $superior_perpus) { if (is_admin_it() || $sess_nik == $superior_it) { $group_id = 2; $type = 'it'; } elseif (is_admin_hrd() || $sess_nik == $superior_hrd) { $group_id = 1; $type = 'hrd'; } elseif (is_admin_logistik() || $sess_nik == $superior_logistik) { $group_id = 3; $type = 'logistik'; } elseif (is_admin_perpus() || $sess_nik == $superior_perpus) { $group_id = 4; $type = 'perpus'; } elseif (is_admin_koperasi() || $sess_nik == $superior_koperasi) { $group_id = 5; $type = 'koperasi'; } elseif (is_admin_keuangan() || $sess_nik == $superior_keuangan) { $group_id = 6; $type = 'keuangan'; } else { $group_id = 0; } $num_rows = getAll('users_exit', array('user_id' => 'where/' . $user_id))->num_rows(); $num_rows_exit = getAll('users_exit')->num_rows(); if ($num_rows > 0) { $exit_id = getValue('id', 'users_exit', array('user_id' => 'where/' . $user_id)); $this->data['is_submit'] = getValue('is_submit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['user_submit'] = getValue('user_submit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['date_submit'] = getValue('date_submit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['user_edit'] = getValue('user_edit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['date_edit'] = getValue('date_edit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['is_app_lv1'] = getValue('is_app_lv1_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['user_app_lv1'] = getValue('user_app_lv1_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['date_app_lv1'] = getValue('date_app_lv1_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['exit_id'] = getValue('id', 'users_exit', array('user_id' => 'where/' . $user_id)); } else { $exit_id = $this->db->select('id')->order_by('id', 'asc')->get('users_exit')->last_row(); $this->data['exit_id'] = $num_rows_exit > 0 ? $exit_id->id + 1 : 1; $this->data['is_submit'] = 0; } $this->db->insert_id(); $q = $this->db->get('users_exit'); $this->data['user_id'] = $user_id; $this->data['user_nik'] = get_nik($user_id); $this->get_user_atasan(); $this->data['type'] = $type; $this->data['inventory'] = GetAll('inventory', array('type_inventory_id' => 'where/' . $group_id)); $i = $this->db->select('users_inventory_exit.id as id, inventory.title, users_inventory_exit.is_available, users_inventory_exit.note')->from('users_inventory_exit')->join('inventory', 'users_inventory_exit.inventory_id = inventory.id', 'left')->where('inventory.type_inventory_id', $group_id)->where('users_inventory_exit.user_id', $user_id)->get(); $this->data['users_inventory'] = $i; return $this->load->view('inventory/inventory_mail', $this->data, TRUE); } }
function input_inventory($user_id) { if (!$this->ion_auth->logged_in()) { redirect('auth/login', 'refresh'); } elseif (!is_admin_inventaris()) { echo 'Anda Tidak Punya Hak Akses Ke Halaman Ini'; } else { if (is_admin_it()) { $group_id = 2; $type = 'it'; } elseif (is_admin_hrd()) { $group_id = 1; $type = 'hrd'; } elseif (is_admin_logistik()) { $group_id = 3; $type = 'logistik'; } elseif (is_admin_perpus()) { $group_id = 4; $type = 'perpus'; } elseif (is_admin_koperasi()) { $group_id = 5; $type = 'koperasi'; } elseif (is_admin_keuangan()) { $group_id = 6; $type = 'koperasi'; } else { $group_id = 0; } $num_rows = getAll('users_exit', array('user_id' => 'where/' . $user_id))->num_rows(); $num_rows_exit = getAll('users_exit')->num_rows(); if ($num_rows > 0) { $exit_id = getValue('id', 'users_exit', array('user_id' => 'where/' . $user_id)); $this->data['is_submit'] = getValue('is_submit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['user_submit'] = getValue('user_submit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['date_submit'] = getValue('date_submit_' . $type, 'users_exit', array('id' => 'where/' . $exit_id)); $this->data['exit_id'] = getValue('id', 'users_exit', array('user_id' => 'where/' . $user_id)); } else { $exit_id = $this->db->select('id')->order_by('id', 'asc')->get('users_exit')->last_row(); $this->data['exit_id'] = $num_rows_exit > 0 ? $exit_id->id + 1 : 1; $this->data['is_submit'] = 0; } $this->data['user_id'] = $user_id; $this->data['user_nik'] = get_nik($user_id); $this->data['type'] = $type; $this->data['inventory'] = GetAll('inventory', array('type_inventory_id' => 'where/' . $group_id)); $i = $this->db->select('*')->from('users_inventory')->join('inventory', 'users_inventory.inventory_id = inventory.id', 'left')->where('inventory.type_inventory_id', $group_id)->where('users_inventory.user_id', $user_id)->get(); //print_mz($i->result()); $this->data['users_inventory'] = $i; $this->_render_page('form_exit/input_inventory', $this->data); } }
/** * form_exit * * @return object form_exit * @author Deni **/ public function form_exit($id = null) { $this->trigger_events('form_exit'); 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_admin_inventaris(); $is_approver = $this->approval->approver('exit'); 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_exit'] . '.*', $this->tables['users_exit'] . '.id as id', 'exit_type.title as exit_type', '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', 'status_hrd.title as approval_status_it', 'status_hrd.title as approval_status_mgr', 'status_hrd.title as approval_status_koperasi', 'status_hrd.title as approval_status_perpus', 'status_asset.title as approval_status_asset')); $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->join('approval_status as status_lv1', 'users_exit.app_status_id_lv1 = status_lv1.id', 'left'); $this->db->join('approval_status as status_lv2', 'users_exit.app_status_id_lv2 = status_lv2.id', 'left'); $this->db->join('approval_status as status_lv3', 'users_exit.app_status_id_lv3 = status_lv3.id', 'left'); $this->db->join('approval_status as status_hrd', 'users_exit.app_status_id_hrd = status_hrd.id', 'left'); $this->db->join('approval_status as status_it', 'users_exit.app_status_id_it = status_it.id', 'left'); $this->db->join('approval_status as status_mgr', 'users_exit.app_status_id_mgr = status_mgr.id', 'left'); $this->db->join('approval_status as status_perpus', 'users_exit.app_status_id_perpus = status_perpus.id', 'left'); $this->db->join('approval_status as status_koperasi', 'users_exit.app_status_id_koperasi = status_koperasi.id', 'left'); $this->db->join('approval_status as status_asset', 'users_exit.app_status_id_asset = status_asset.id', 'left'); if ($id != null) { $this->db->where('users_exit.id', $id); } if ($is_approver !== $sess_nik && $is_admin != 1) { //$this->db->where("(users_exit.user_id= $sess_id $sub_id $subsub_id )",null, false); $this->db->where("(users_exit.user_id = {$sess_id} OR users_exit.user_app_lv1 = '{$sess_nik}' OR users_exit.user_app_lv2 = '{$sess_nik}' OR users_exit.user_app_lv3 = '{$sess_nik}' OR users_exit.user_app_asset = '{$sess_nik}' OR users_exit.created_by = '{$sess_id}')", null, false); } $this->db->where('is_purposed', 1); $this->db->order_by('users_exit.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_exit']); return $this; }