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,
));
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = FilterColors::model()->findByPk($id);
if ($model === null)
throw new CHttpException(404, 'The requested page does not exist.');
return $model;
}
<?php endforeach;?>
</select>-->
</div>
<?php endif;?>
<a class="resetFilters" href="javascript:void(0);"><?php echo Yii::t('strings', 'Reset Filter'); ?></a>
<div class="colors_and_button">
<h2><?php echo Yii::t('strings', 'Colors'); ?></h2>
<?php
$allColors = FilterColors::model()->findAll(
array(
'condition' => 'status = :status',
'params' => array(':status' => 1),
//'order'=>'sort_order',
)
);
$allColors = FilterColors::model()->cf_sort_hex_colors($allColors);
?>
<ul>
<?php foreach ($allColors as $colorId => $color_data):?>
<li class="color" style="background-color: <?php echo $color_data->color_hash;?>" id="color_<?php echo $color_data->id;?>"></li>
<?php endforeach;?>
</ul>
</div>
<div id="cart">
<h2><a href="<?php echo Yii::app()->baseUrl; ?>/cart"><?php echo Yii::t('strings', 'Cart'); ?></a></h2>
</div>
