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: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 

<?php
class Item_kit extends CI_Model
{
    /*
    Determines if a given item_id is an item kit
    */
    public function exists($item_kit_id)
    {
        $this->db->from('item_kits');
        $this->db->where('item_kit_id', $item_kit_id);

        return ($this->db->get()->num_rows() == 1);
    }

    /*
    Check if a given item_id is an item kit
    */
    public function is_valid_item_kit($item_kit_id)
    {
        if(!empty($item_kit_id))
        {
            //KIT #
            $pieces = explode(' ', $item_kit_id);

            if(count($pieces) == 2 && preg_match('/(KIT)/i', $pieces[0]))
            {
                return $this->exists($pieces[1]);
            }
        }

        return FALSE;
    }

    /*
    Gets total of rows
    */
    public function get_total_rows()
    {
        $this->db->from('item_kits');

        return $this->db->count_all_results();
    }
    
    /*
    Gets information about a particular item kit
    */
    public function get_info($item_kit_id)
    {
        $this->db->select('
        item_kit_id, 
        item_kits.name as name, 
        items.name as item_name, 
        item_kits.description, 
        items.description as item_description, 
        item_kits.item_id as kit_item_id, 
        kit_discount_percent, 
        price_option, 
        print_option, 
        category, 
        supplier_id, 
        item_number, 
        cost_price, 
        unit_price, 
        reorder_level, 
        receiving_quantity, 
        pic_filename, 
        allow_alt_description, 
        is_serialized, 
        deleted, 
        custom1, 
        custom2, 
        custom3, 
        custom4, 
        custom5, 
        custom6, 
        custom7, 
        custom8, 
        custom9, 
        custom10,
        item_type,
        stock_type');

        $this->db->from('item_kits');
        $this->db->join('items', 'item_kits.item_id = items.item_id', 'left');
        $this->db->where('item_kit_id', $item_kit_id);
        
        $query = $this->db->get();

        if($query->num_rows()==1)
        {
            return $query->row();
        }
        else
        {
            //Get empty base parent object, as $item_kit_id is NOT an item kit
            $item_obj = new stdClass();

            //Get all the fields from items table
            foreach($this->db->list_fields('item_kits') as $field)
            {
                $item_obj->$field = '';
            }

            return $item_obj;
        }
    }

    /*
    Gets information about multiple item kits
    */
    public function get_multiple_info($item_kit_ids)
    {
        $this->db->from('item_kits');
        $this->db->where_in('item_kit_id', $item_kit_ids);
        $this->db->order_by('name', 'asc');

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

    /*
    Inserts or updates an item kit
    */
    public function save(&$item_kit_data, $item_kit_id = FALSE)
    {
        if(!$item_kit_id || !$this->exists($item_kit_id))
        {
            if($this->db->insert('item_kits', $item_kit_data))
            {
                $item_kit_data['item_kit_id'] = $this->db->insert_id();

                return TRUE;
            }

            return FALSE;
        }

        $this->db->where('item_kit_id', $item_kit_id);

        return $this->db->update('item_kits', $item_kit_data);
    }

    /*
    Deletes one item kit
    */
    public function delete($item_kit_id)
    {
        return $this->db->delete('item_kits', array('item_kit_id' => $id));     
    }

    /*
    Deletes a list of item kits
    */
    public function delete_list($item_kit_ids)
    {
        $this->db->where_in('item_kit_id', $item_kit_ids);

        return $this->db->delete('item_kits');      
    }

    public function get_search_suggestions($search, $limit = 25)
    {
        $suggestions = array();

        $this->db->from('item_kits');

        //KIT #
        if(stripos($search, 'KIT ') !== FALSE)
        {
            $this->db->like('item_kit_id', str_ireplace('KIT ', '', $search));
            $this->db->order_by('item_kit_id', 'asc');

            foreach($this->db->get()->result() as $row)
            {
                $suggestions[] = array('value' => 'KIT '. $row->item_kit_id, 'label' => 'KIT ' . $row->item_kit_id);
            }
        }
        else
        {
            $this->db->like('name', $search);
            $this->db->order_by('name', 'asc');

            foreach($this->db->get()->result() as $row)
            {
                $suggestions[] = array('value' => 'KIT ' . $row->item_kit_id, 'label' => $row->name);
            }
        }

        //only return $limit suggestions
        if(count($suggestions > $limit))
        {
            $suggestions = array_slice($suggestions, 0, $limit);
        }

        return $suggestions;
    }

    /*
    Perform a search on items
    */
    public function search($search, $rows=0, $limit_from=0, $sort='name', $order='asc')
    {
        $this->db->from('item_kits');
        $this->db->like('name', $search);
        $this->db->or_like('description', $search);

        //KIT #
        if(stripos($search, 'KIT ') !== FALSE)
        {
            $this->db->or_like('item_kit_id', str_ireplace('KIT ', '', $search));
        }

        $this->db->order_by($sort, $order);

        if($rows > 0)
        {
            $this->db->limit($rows, $limit_from);
        }

        return $this->db->get();    
    }
    
    public function get_found_rows($search)
    {
        $this->db->from('item_kits');
        $this->db->like('name', $search);
        $this->db->or_like('description', $search);

        //KIT #
        if(stripos($search, 'KIT ') !== FALSE)
        {
            $this->db->or_like('item_kit_id', str_ireplace('KIT ', '', $search));
        }

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