public static function GetByName($attributeName) { return Attribute::find(array('name' => $attributeName)); }
public function actionUpdate($id) { //CVarDumper::dump($_POST, 10, true); //die; $model = $this->loadModel($id); if (isset($_POST['deleteVariationID'])) { Variation::model()->deleteAll('variation_id=' . $_POST['deleteVariationID']); VariationDescription::model()->deleteAll('variation_id=' . $_POST['deleteVariationID']); Variation2attribute::model()->deleteAll('variation_id=' . $_POST['deleteVariationID']); Variation2value::model()->deleteAll('variation_id=' . $_POST['deleteVariationID']); Product2variation::model()->deleteAll('variation_id=' . $_POST['deleteVariationID']); echo 'success'; exit; } $lang_model = new LanguageModel; $ProdDescModel = new ProductDescription; $Category2product = $this->loadCatToProdModel('product_id=' . $id); $assignedToCategory = $Category2product['category_id']; $CadDescModel = new CategoryDescription; $Product2variation = new Product2variation; $Variation = new Variation; $VariationDescription = new VariationDescription; $Variation2attribute = new Variation2attribute; $AttributeModel = new Attribute; $AttributeDescModel = new AttributeDescription; $Attribute2value = new Attribute2value; $ValueModel = new Value; $ValueDescription = new ValueDescription; $aCategories = Category::model()->generateTreeList(); $aLangNames = array(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); $allLangs = $lang_model->findAll('1', array('order' => 'id ASC')); // Filter colors $allFilterColors = FilterColors::model()->findAll( array( 'condition' => 'status = :status', 'params' => array(':status' => 1), 'order'=>'sort_order', ) ); // Delivery Time $allDeliveryTimes = DeliveryTime::model()->findAll( array( 'condition' => 'status = :status', 'params' => array(':status' => 1), 'order'=>'sort_order', ) ); //Existing Variations $aExistingVariations = array(); $aProd2Var = $Product2variation->findAll('product_id=' . $id); foreach ($aProd2Var as $prod_to_var) { $aVar = $Variation->find('variation_id=' . $prod_to_var['variation_id']); $aExistingVariations[$prod_to_var['variation_id']]['image'] = $aVar['variation_image']; $aExistingVariations[$prod_to_var['variation_id']]['filter_color_id'] = $aVar['filter_color_id']; $aVarDescrs = $VariationDescription->findAll('variation_id=' . $prod_to_var['variation_id']); foreach ($aVarDescrs as $var_descr) { $aExistingVariations[$prod_to_var['variation_id']]['lang_var_names'][$var_descr['language_id']] = $var_descr['variation_name']; $aExistingVariations[$prod_to_var['variation_id']]['description'][$var_descr['language_id']] = $var_descr['variation_description']; } $Variation2value = new Variation2value; $aVar2Val = $Variation2value->findAll('variation_id=' . $prod_to_var['variation_id']); foreach ($aVar2Val as $var_to_val) { $aExistingVariations[$prod_to_var['variation_id']]['set_values'][] = $var_to_val['value_id']; } $aVars2Attrs = $Variation2attribute->findAll('variation_id=' . $prod_to_var['variation_id']); //attributes foreach ($aVars2Attrs as $var_to_attr) { $aAttr = $AttributeModel->find('attribute_id=' . $var_to_attr['attribute_id']); $aAttrDescrs = $AttributeDescModel->find('attribute_id=\'' . $aAttr['attribute_id'] . '\' AND language_id=' . $this->language_id); $aExistingVariations[$prod_to_var['variation_id']]['attributes'][$aAttr['attribute_id']]['attribute_name'] = $aAttrDescrs['attribute_name']; //values $aAttr2Vals = $Attribute2value->findAll('attribute_id=' . (int)$aAttr['attribute_id']); foreach ($aAttr2Vals as $attr_to_val) { $aValDescrs = $ValueDescription->find('value_id=' . $attr_to_val['value_id'] . ' AND language_id=' . $this->language_id); $aExistingVariations[$prod_to_var['variation_id']]['attributes'][$aAttr['attribute_id']]['values'][$aValDescrs['value_id']] = $aValDescrs['value_name']; } } } $allLangsJS = array(); foreach ($allLangs as $language) { $allLangsJS[$language['id']] = $language['code']; } $aAttributes = $AttributeModel->findAll(); $aReadyAttrsValues = array(); foreach ($aAttributes as $attribute) { //descriptions $aAttrDescr = $AttributeDescModel->find("language_id='" . $this->language_id . "' AND attribute_id='" . $attribute['attribute_id'] . "'"); $aReadyAttrsValues[$attribute['attribute_id']]['attribute_name'] = $aAttrDescr['attribute_name']; //values $aValues = $Attribute2value->findAll('attribute_id=' . $attribute['attribute_id']); foreach ($aValues as $value) { $aValDescrs = $ValueDescription->findAll("value_id='" . $value['value_id'] . "' AND language_id='" . $this->language_id . "'"); foreach ($aValDescrs as $value_description) { $aReadyAttrsValues[$attribute['attribute_id']]['values'][$value['value_id']] = $value_description['value_name']; } } } $aPordNames = $ProdDescModel->findAll("product_id = '" . $id . "'"); foreach ($aPordNames as $lng_product) { $aLangNames[$lng_product['language_id']] = $lng_product['product_name']; } if (isset($_POST['Product'])) { $Category2product->updateAll(array('category_id' => $_POST['Category2product']['category_id']), 'product_id=' . $id); if (!empty($_POST['deliveryTime'])) { $_POST['Product']['delivery_time_id'] = $_POST['deliveryTime']; } $model->attributes = $_POST['Product']; if ($model->save()) { foreach ($_POST['ProductDescription']['product_name'] as $langId => $prodName) { $prod_desc_model = new ProductDescription; $prod_desc_model->updateByPk(array('product_id' => $id, 'language_id' => $langId), array('product_name' => $prodName)); } } //old variations if (isset($_POST['ExistingVariation'])) { foreach ($_POST['ExistingVariation'] as $varId => $variationData) { foreach ($variationData as $lang_id => $variation_name) { $VariationDescription = new VariationDescription; if (VariationDescription::model()->count("variation_id=:field", array("field" => $varId))) { $VariationDescription->setIsNewRecord(false); } $VariationDescription->variation_id = $varId; $VariationDescription->language_id = $lang_id; $VariationDescription->variation_name = $variation_name; $VariationDescription->variation_description = $_POST['ExistingVariationDesc'][$varId][$lang_id]; $VariationDescription->save(); } if (isset($_POST['ExistingAttributeValue'][$varId])) { $Variation2value = new Variation2value; $Variation2value->deleteAll('variation_id=' . $varId); foreach ($_POST['ExistingAttributeValue'][$varId] as $attr_id => $value_id) { if (isset($_POST['ExistingAttribute'][$varId][$attr_id])) { if ($_POST['ExistingAttribute'][$varId][$attr_id] == 'removed') { $Variation2attribute = new Variation2attribute; $Variation2attribute->deleteAll('attribute_id=' . $attr_id . ' AND variation_id=' . $varId); } $Variation2value = new Variation2value; if ($value_id > 0) { $Variation2value->attributes = array( 'variation_id' => $varId, 'value_id' => $value_id, ); $Variation2value->save(); } } } } if (isset($_POST['RegularAttribute'][$varId])) { foreach ($_POST['RegularAttribute'][$varId] as $attr_id => $value) { if (isset($_POST['RegularAttributeValue'][$varId][$attr_id]) && $_POST['RegularAttributeValue'][$varId][$attr_id] > 0) { $Variation2attribute = new Variation2attribute; $Variation2attribute->attributes = array( 'variation_id' => $varId, 'attribute_id' => $attr_id, ); $Variation2attribute->save(); $Variation2value = new Variation2value; $Variation2value->attributes = array( 'variation_id' => $varId, 'value_id' => $_POST['RegularAttributeValue'][$varId][$attr_id], ); $Variation2value->save(); } } } if (isset($_POST['ExistingFilterColor'][$varId])) { $Variation = new Variation; $Variation->variation_id = $varId; $Variation->setIsNewRecord(false); $Variation->filter_color_id = $_POST['ExistingFilterColor'][$varId]; $Variation->save(); } } } //variations if (isset($_POST['NewVariation'])) { foreach ($_POST['NewVariation'] as $specId => $variationData) { $Variation = new Variation; $Variation->attributes = array( 'variation_image' => 'some_image.jpg', 'status' => 1, ); $Variation->save(); $variation_id = $Variation->getPrimaryKey(); $Product2variation = new Product2variation; $Product2variation->attributes = array( 'product_id' => $id, 'variation_id' => $variation_id, ); $Product2variation->save(); foreach ($variationData as $lang_id => $variation_name) { $VariationDescription = new VariationDescription; $VariationDescription->attributes = array( 'variation_name' => $variation_name, 'variation_id' => $variation_id, 'language_id' => $lang_id, ); $VariationDescription->save(); } if (isset($_POST['NewAttribute'][$specId])) { foreach ($_POST['NewAttribute'][$specId] as $attr_id => $value) { if (isset($_POST['NewAttributeValue'][$specId][$attr_id]) && $_POST['NewAttributeValue'][$specId][$attr_id] > 0) { $Variation2attribute = new Variation2attribute; $Variation2attribute->attributes = array( 'variation_id' => $variation_id, 'attribute_id' => $attr_id, ); $Variation2attribute->save(); $Variation2value = new Variation2value; $Variation2value->attributes = array( 'variation_id' => $variation_id, 'value_id' => $_POST['NewAttributeValue'][$specId][$attr_id], ); $Variation2value->save(); } } } } } $this->redirect(array('index')); } $this->render('update', array( 'model' => $model, 'allLangs' => $allLangs, 'allLangsJS' => json_encode($allLangsJS), 'aReadyAttrsValues' => $aReadyAttrsValues, 'ProdDescModel' => $ProdDescModel, 'aLangNames' => $aLangNames, 'Category2product' => $Category2product, 'aExistingVariations' => $aExistingVariations, 'aCategories' => $aCategories, 'assignedToCategory' => $assignedToCategory, 'allFilterColors' => $allFilterColors, 'allDeliveryTimes' => $allDeliveryTimes, )); }