public function insertAttributeOption($attribute_id, $attribute_options = array()) { if (is_numeric($this->product_id) && $this->product_id > 0) { if (is_array($attribute_options)) { foreach ($attribute_options as $option) { //Get Attribute option id $attr_options = ProductAttributeOptions::Select('id')->whereRaw('option_label = ?', array($option))->first(); if (count($attr_options) > 0) { $attr_options_id = $attr_options->id; $data_arr = array('product_id' => $this->product_id, 'attribute_id' => $attribute_id, 'attribute_options_id' => $attr_options_id); ProductAttributesOptionValues::insertGetId($data_arr); } } } } }
public function deleteAllAttributeOptions($attribute_id) { # Get all attribute option ids related to the deleted attribute $attr_option_details = ProductAttributeOptions::Select('id')->whereRaw('attribute_id = ?', array($attribute_id))->get(); if (count($attr_option_details) > 0) { foreach ($attr_option_details as $attr_option) { # Delete attribute options $this->deleteAttributeOption($attribute_id, $attr_option['id']); } } return true; }