Exemplo n.º 1
0
    ?>
">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 
    }
Exemplo n.º 2
0
 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);
     }
 }
Exemplo n.º 3
0
 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);
     }
 }
Exemplo n.º 4
0
 /**
  * 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;
 }