1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 

<?php
class Stock_location extends CI_Model
{
    public function exists($location_name = '')
    {
        $this->db->from('stock_locations');  
        $this->db->where('location_name', $location_name);
        
        return ($this->db->get()->num_rows() >= 1);
    }
    
    public function get_all($limit = 10000, $offset = 0)
    {
        $this->db->from('stock_locations');
        $this->db->limit($limit);
        $this->db->offset($offset);
    
        return $this->db->get();
    }
    
    public function get_undeleted_all($module_id = 'items')
    {
        $this->db->from('stock_locations');
        $this->db->join('permissions', 'permissions.location_id = stock_locations.location_id');
        $this->db->join('grants', 'grants.permission_id = permissions.permission_id');
        $this->db->where('person_id', $this->session->userdata('person_id'));
        $this->db->like('permissions.permission_id', $module_id, 'after');
        $this->db->where('deleted', 0);

        return $this->db->get();
    }

    public function show_locations($module_id = 'items')
    {
        $stock_locations = $this->get_allowed_locations($module_id);

        return count($stock_locations) > 1;
    }

    public function multiple_locations()
    {
        return $this->get_all()->num_rows() > 1;
    }

    public function get_allowed_locations($module_id = 'items')
    {
        $stock = $this->get_undeleted_all($module_id)->result_array();
        $stock_locations = array();
        foreach($stock as $location_data)
        {
            $stock_locations[$location_data['location_id']] = $location_data['location_name'];
        }

        return $stock_locations;
    }

    public function is_allowed_location($location_id, $module_id = 'items')
    {
        $this->db->from('stock_locations');
        $this->db->join('permissions', 'permissions.location_id = stock_locations.location_id');
        $this->db->join('grants', 'grants.permission_id = permissions.permission_id');
        $this->db->where('person_id', $this->session->userdata('person_id'));
        $this->db->like('permissions.permission_id', $module_id, 'after');
        $this->db->where('deleted', 0);
        $this->db->where('stock_locations.location_id', $location_id);

        return ($this->db->get()->num_rows() == 1);
    }
    
    public function get_default_location_id()
    {
        $this->db->from('stock_locations');
        $this->db->join('permissions', 'permissions.location_id = stock_locations.location_id');
        $this->db->join('grants', 'grants.permission_id = permissions.permission_id');
        $this->db->where('person_id', $this->session->userdata('person_id'));
        $this->db->where('deleted', 0);
        $this->db->limit(1);

        return $this->db->get()->row()->location_id;
    }
    
    public function get_location_name($location_id) 
    {
        $this->db->from('stock_locations');
        $this->db->where('location_id', $location_id);

        return $this->db->get()->row()->location_name;
    }
    
    public function save(&$location_data, $location_id) 
    {
        $location_name = $location_data['location_name'];

        if(!$this->exists($location_name))
        {
            $this->db->trans_start();

            $location_data = array('location_name'=>$location_name, 'deleted'=>0);
            $this->db->insert('stock_locations', $location_data);
            $location_id = $this->db->insert_id();
             
            $this->_insert_new_permission('items', $location_id, $location_name);
            $this->_insert_new_permission('sales', $location_id, $location_name);
            $this->_insert_new_permission('receivings', $location_id, $location_name);
            
            // insert quantities for existing items
            $items = $this->Item->get_all();
            foreach($items->result_array() as $item)
            {
                $quantity_data = array('item_id' => $item['item_id'], 'location_id' => $location_id, 'quantity' => 0);
                $this->db->insert('item_quantities', $quantity_data);
            }

            $this->db->trans_complete();
            
            return $this->db->trans_status();
        }
        else 
        {
            $this->db->where('location_id', $location_id);

            return $this->db->update('stock_locations', $location_data);
        }
    }
        
    private function _insert_new_permission($module, $location_id, $location_name)
    {
        // insert new permission for stock location
        $permission_id = $module . '_' . $location_name;
        $permission_data = array('permission_id' => $permission_id, 'module_id' => $module, 'location_id' => $location_id);
        $this->db->insert('permissions', $permission_data);
        
        // insert grants for new permission
        $employees = $this->Employee->get_all();
        foreach($employees->result_array() as $employee)
        {
            $grants_data = array('permission_id' => $permission_id, 'person_id' => $employee['person_id']);
            $this->db->insert('grants', $grants_data);
        }
    }
    
    /*
     Deletes one item
    */
    public function delete($location_id)
    {
        $this->db->trans_start();

        $this->db->where('location_id', $location_id);
        $this->db->update('stock_locations', array('deleted' => 1));
        
        $this->db->where('location_id', $location_id);
        $this->db->delete('permissions');

        $this->db->trans_complete();
        
        return $this->db->trans_status();
    }
}
?>