public function actionGetProducts() { if ($_GET['category_id']) { $aCategories = Category::model()->getRecursiveChildren((int) $_GET['category_id']); $aCategories[] = $_GET['category_id']; } if ($_GET['categories_ids']) { $aCategories = $_GET['categories_ids']; } $c = new CDbCriteria(); if ($_GET['category_id'] || $_GET['categories_ids']) { $c->with = array('category2product' => array('on' => 'category2product.category_id = category2product_category2product.category_id'), 'category' => array('on' => 'category.category_id = category2product.category_id'), 'product_description' => array('with' => array('product')), 'variations' => array('with' => array('variation_description'))); $c->together = true; $c->compare('category2product.category_id', $aCategories); if ($_GET['filter_color_id']) { $c->compare('variations.filter_color_id', $_GET['filter_color_id']); } $c->compare('t.status', 1); $c->compare('product.status', 1); if (!empty($_GET['deliveryTime'])) { $temp_d_time = DeliveryTime::model()->findByPk($_GET['deliveryTime']); $amount_of_days = $temp_d_time->amount_of_days; $aAllDeliveryTimes = CHtml::listData(DeliveryTime::model()->findAll(array('select' => 'id', 'condition' => 'amount_of_days<=:ad', 'params' => array(':ad' => $amount_of_days))), 'id', 'id'); $c->addInCondition('product.delivery_time_id', array_keys($aAllDeliveryTimes)); } $c->order = 'category.sort_order ASC'; } $model = Product::model()->findAll($c); $dataProvider = new CArrayDataProvider($model, array('keyField' => 'product_id', 'pagination' => false, 'sort' => array('attributes' => array('sort_order')))); $this->renderPartial('products_list', array('dataProvider' => $dataProvider, 'model' => $model)); }
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 = DeliveryTime::model()->findByPk($id); if ($model === null) throw new CHttpException(404, 'The requested page does not exist.'); return $model; }
<div class="filtersContainer"> <div id="categories"> <div class="cat_sub cats"> <h2><?php echo Yii::t('strings', 'Categories'); ?></h2> <?php echo Category::model()->generateHTMLList(); ?> </div> <div class="cat_sub cats_children"> <div class="cats_children_holder"> <h2><?php echo Yii::t('strings', 'Types'); ?></h2> </div> </div> </div> <?php $allDeliveryTimes = DeliveryTime::model()->findAll( array( 'condition' => 'status = :status', 'params' => array(':status' => 1), 'order'=>'sort_order', ) ); ?> <?php if (count($allDeliveryTimes) > 0): ?> <div class="deliveryTimeSliderNew"> <h2 class="availabilityHeader"><?php echo Yii::t('strings', 'Availability'); ?> (<?php echo Yii::t('strings', 'Days'); ?>)</h2> <ul class="deliveryTimeUl"> <?php foreach ($allDeliveryTimes as $delivery_time):?> <li><span class="deliveryCoolCheckboxes" id="deliveryCoolCheckboxes_<?php echo $delivery_time->id;?>"><img src="/images/empty_checkbox.png" alt="<?php echo $delivery_time->amount_of_days;?>"/></span><?php echo $delivery_time->amount_of_days;?></li>