PHP fetch_current_system_codes Examples

Example #1

File: product_catalog_model.php Project: ohjack/mallerp_standard

 public function fetch_child_catalogs($parent_id)
 {
     if ($this->CI->is_super_user()) {
         return $this->get_result('product_catalog', '*', array('parent' => $parent_id));
     }
     $user_id = get_current_user_id();
     $codes = fetch_current_system_codes();
     if (in_array('sale', $codes)) {
         $sale_cat_ids = $this->CI->product_model->fetch_all_sale_catalog_ids($user_id);
     }
     $lower_priority_users = $this->CI->user_model->fetch_lower_priority_users_by_system_code('purchase');
     $lower_priority_user_ids = array();
     foreach ($lower_priority_users as $user) {
         $lower_priority_user_ids[] = $user->u_id;
     }
     $lower_priority_user_ids[] = get_current_user_id();
     if (is_array($codes) && in_array('finance', $codes)) {
         return $this->get_result('product_catalog', '*', array('parent' => $parent_id));
     }
     if (in_array('purchase', $codes)) {
         $this->db->from('product_catalog');
         $this->db->where(array('parent' => $parent_id));
         $this->db->where_in('(product_catalog.purchaser_id', $lower_priority_user_ids);
         $this->db->or_where('product_catalog.purchaser_id = -1)');
         $query = $this->db->get();
         return $query->result();
     }
     if (in_array('sale', $codes)) {
         if (empty($sale_cat_ids)) {
             return array();
         }
         $this->db->from('product_catalog');
         $this->db->where('parent', $parent_id);
         $this->db->where_in('id', $sale_cat_ids);
         $query = $this->db->get();
         return $query->result();
     }
     return $this->get_result('product_catalog', '*', array('parent' => $parent_id));
 }

Example #2

File: product_model.php Project: ohjack/mallerp_standard

 public function fetch_to_be_edit_products()
 {
     $lower_priority_users = $this->CI->user_model->fetch_lower_priority_users_by_system_code('purchase');
     $lower_priority_user_ids = array();
     foreach ($lower_priority_users as $user) {
         $lower_priority_user_ids[] = $user->u_id;
     }
     $lower_priority_user_ids[] = get_current_user_id();
     $codes = fetch_current_system_codes();
     $status = fetch_status_id('sale_status', 'in_stock');
     $cat_ids = array();
     $cat_id = $this->CI->session->userdata('current_catalog_id');
     if (!isset($this->CI->product_catalog_model)) {
         $this->CI->load->model('product_catalog_model');
     }
     if ($cat_id != -1 && $cat_id != FALSE) {
         $cat_ids = array($cat_id);
     }
     $cat_ids = array_merge($cat_ids, $this->CI->product_catalog_model->fetch_all_child_catalog_ids($cat_id));
     $this->db->select('product_basic.sku, product_basic.id as pid, product_basic.name_cn, product_basic.name_en, product_basic.updated_date,product_basic.*,user.name');
     $this->db->from('product_basic');
     $this->db->join('user', 'user.id = product_basic.purchaser_id', 'LEFT');
     if (!$this->CI->is_super_user() && in_array('purchase', $codes)) {
         $this->db->where("(product_basic.market_model = '' ");
         $this->db->or_where('product_basic.box_contain_number = 0 ');
         $this->db->or_where('product_basic.box_total_weight = 0 ');
         $this->db->or_where('product_basic.box_length = 0 ');
         $this->db->or_where('product_basic.box_width = 0 ');
         $this->db->or_where('product_basic.box_height = 0 ');
         $this->db->or_where("product_basic.min_stock_number = '' )");
     }
     if (!$this->CI->is_super_user() && in_array('shipping', $codes)) {
         $this->db->where("product_basic.packing_material  = 0 ");
     }
     if (!empty($cat_ids)) {
         $this->db->where_in('catalog_id', $cat_ids);
         if (!$this->CI->is_super_user() && in_array('purchase', $codes)) {
             //$this->db->where_in('product_basic.purchaser_id', $lower_priority_user_ids);
         }
     } else {
         if (!$this->CI->is_super_user() && in_array('purchase', $codes)) {
             //$this->db->where_in('product_basic.purchaser_id', $lower_priority_user_ids);
         }
         if (!$this->CI->is_super_user() && in_array('sale', $codes)) {
             return array();
         }
     }
     $this->db->distinct();
     $this->db->order_by('product_basic.updated_date', 'DESC');
     $this->db->limit(5);
     $query = $this->db->get();
     return $query->result();
 }