function __construct($filename)
{
if (is_file($filename)) {
$this->filename = $filename;
$xml = new \XMLReader();
if (false !== $xml->open($filename)) {
$this->xml = $xml;
$rootCategory = Category::findOne(['parent_id' => 0]);
if (empty($rootCategory)) {
if (null === ($rootCategory = Category::createEmptyCategory(0, null, 'Каталог'))) {
$this->xml->close();
$this->xml = null;
}
$this->rootCategoryCache = $rootCategory->id;
} else {
$this->rootCategoryCache = $rootCategory->id;
}
if (empty(static::$propertiesCache)) {
static::$propertiesCache = array_reduce(CommercemlGuid::find([['>', 'model_id', 0], ['type' => 'PROPERTY']])->all(), function ($result, $item) {
$result[$item['guid']] = $item->property;
return $result;
}, []);
}
$this->objectProduct = Object::getForClass(Product::className());
}
}
}
/**
* @return string
*/
public function actionPrint()
{
$this->layout = 'print';
$products = ProductCompareHelper::getProductsList(true);
$object = Object::getForClass(Product::className());
return $this->render('print', ['error' => empty($products) || null === $object, 'message' => Yii::t('app', 'No products for comparing'), 'object' => $object, 'products' => $products]);
}
/**
* Delete relations
* @return bool
*/
public function cleanUpRelations()
{
if (!is_subclass_of($this->owner, '\\yii\\db\\ActiveRecord')) {
return false;
}
if (isset($this->owner->is_deleted) && 0 === intval($this->owner->is_deleted)) {
return false;
}
if (null === ($object = Object::getForClass($this->owner->className()))) {
return false;
}
$whereDelete = ['object_id' => $object->id, 'object_model_id' => $this->owner->id];
ObjectPropertyGroup::deleteAll($whereDelete);
ObjectStaticValues::deleteAll($whereDelete);
Image::deleteAll($whereDelete);
ViewObject::deleteAll($whereDelete);
try {
Yii::$app->db->createCommand()->delete($object->categories_table_name, ['object_model_id' => $this->owner->id])->execute();
Yii::$app->db->createCommand()->delete($object->column_properties_table_name, ['object_model_id' => $this->owner->id])->execute();
Yii::$app->db->createCommand()->delete($object->eav_table_name, ['object_model_id' => $this->owner->id])->execute();
} catch (Exception $e) {
// do nothing
}
return true;
}
public function run()
{
$this->genButton = Html::a(Icon::show('edit') . Yii::t('app', 'Generate'), '#', ['class' => 'btn btn-success', 'id' => 'btn-generate']);
$parent_id = $this->model->main_category_id;
$owner_id = $this->model->id;
$this->addButton = Html::a(Icon::show('plus') . Yii::t('app', 'Add'), Url::toRoute(['/shop/backend-product/edit', 'parent_id' => $parent_id, 'owner_id' => $owner_id, 'returnUrl' => \app\backend\components\Helper::getReturnUrl()]), ['class' => 'btn btn-success', 'id' => 'btn-add']);
if (!empty($this->footer)) {
$this->footer = Html::tag('div', $this->addButton . ' ' . $this->genButton, ['class' => 'widget-footer']);
}
$this->object = Object::getForClass(get_class($this->model));
$rest_pg = (new Query())->select('id, name')->from(PropertyGroup::tableName())->where(['object_id' => $this->object->id])->orderBy('sort_order')->all();
$this->property_groups_to_add = [];
foreach ($rest_pg as $row) {
$this->property_groups_to_add[$row['id']] = $row['name'];
}
$optionGenerate = Json::decode($this->model->option_generate);
if (null === PropertyGroup::findOne($optionGenerate['group'])) {
$this->model->option_generate = $optionGenerate = null;
}
$groupModel = null;
if (isset($optionGenerate['group'])) {
$groupModel = PropertyGroup::findOne($optionGenerate['group']);
$properties = Property::getForGroupId($optionGenerate['group']);
} else {
$group_ids = array_keys($this->property_groups_to_add);
$group_id = array_shift($group_ids);
$groupModel = PropertyGroup::findOne($group_id);
$properties = Property::getForGroupId($group_id);
}
if (is_null($groupModel)) {
$groupModel = new PropertyGroup();
}
return $this->render($this->viewFile, ['model' => $this->model, 'form' => $this->form, 'groups' => $this->property_groups_to_add, 'groupModel' => $groupModel, 'properties' => $properties, 'optionGenerate' => $optionGenerate, 'footer' => $this->footer]);
}
public function actionEdit($id = null)
{
$model = new PrefilteredPages();
$model->loadDefaultValues();
if ($id !== null) {
$model = PrefilteredPages::findOne($id);
}
$static_values_properties = [];
$property_groups_ids_for_object = (new Query())->select('id')->from(PropertyGroup::tableName())->where(['object_id' => Object::getForClass(Product::className())->id])->column();
$properties = Property::find()->andWhere(['in', 'property_group_id', $property_groups_ids_for_object])->all();
foreach ($properties as $prop) {
/** @var Property $prop */
$static_values_properties[$prop->id] = ['property' => $prop, 'static_values_select' => PropertyStaticValues::getSelectForPropertyId($prop->id), 'has_static_values' => $prop->has_static_values === 1];
}
$post = \Yii::$app->request->post();
if ($model->load($post) && $model->validate()) {
$save_result = $model->save();
if ($save_result) {
Yii::$app->session->setFlash('info', Yii::t('app', 'Object saved'));
$returnUrl = Yii::$app->request->get('returnUrl', ['index', 'id' => $model->id]);
switch (Yii::$app->request->post('action', 'save')) {
case 'next':
return $this->redirect(['edit', 'returnUrl' => $returnUrl]);
case 'back':
return $this->redirect($returnUrl);
default:
return $this->redirect(Url::toRoute(['edit', 'id' => $model->id, 'returnUrl' => $returnUrl]));
}
//return $this->redirect(['/backend/prefiltered-pages/edit', 'id' => $model->id]);
} else {
\Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot update data'));
}
}
return $this->render('prefiltered-page-form', ['model' => $model, 'static_values_properties' => $static_values_properties]);
}
public function actionIndex($category_id = null)
{
$searchModel = new Category();
$searchModel->active = 1;
$params = Yii::$app->request->get();
$dataProvider = $searchModel->search($params);
$selectedCategory = null;
if ($category_id !== null) {
$selectedCategory = Category::findById($category_id);
}
if ($selectedCategory !== null) {
if (Yii::$app->request->isPost === true) {
$newProperty = isset($_GET['add_property_id']) ? Property::findById($_GET['add_property_id']) : null;
if ($newProperty !== null) {
$filterSet = new FilterSets();
$filterSet->category_id = $selectedCategory->id;
$filterSet->property_id = $newProperty->id;
$filterSet->sort_order = 65535;
$filterSet->save();
}
}
}
$groups = PropertyGroup::getForObjectId(Object::getForClass(Product::className())->id, false);
$propertiesDropdownItems = [];
foreach ($groups as $group) {
$item = ['label' => $group->name, 'url' => '#', 'items' => []];
$properties = Property::getForGroupId($group->id);
foreach ($properties as $prop) {
$item['items'][] = ['label' => $prop->name, 'url' => '?category_id=' . $category_id . '&add_property_id=' . $prop->id, 'linkOptions' => ['class' => 'add-property-to-filter-set', 'data-property-id' => $prop->id, 'data-action' => 'post']];
}
$propertiesDropdownItems[] = $item;
}
return $this->render('index', ['dataProvider' => $dataProvider, 'searchModel' => $searchModel, 'selectedCategory' => $selectedCategory, 'propertiesDropdownItems' => $propertiesDropdownItems]);
}
public function run()
{
$query = Category::find();
$query->andWhere([Category::tableName() . '.active' => 1]);
if ($this->root_category_id !== null) {
$query->andWhere([Category::tableName() . '.parent_id' => $this->root_category_id]);
}
if ($this->category_group_id !== null) {
$query->andWhere([Category::tableName() . '.category_group_id' => $this->category_group_id]);
}
$query->groupBy(Category::tableName() . ".id");
$query->orderBy($this->sort);
if ($this->limit !== null) {
$query->limit($this->limit);
}
$object = Object::getForClass(Category::className());
\app\properties\PropertiesHelper::appendPropertiesFilters($object, $query, $this->values_by_property_id, []);
$sql = $query->createCommand()->getRawSql();
$cacheKey = "FilteredCategoriesWidget:" . md5($sql);
$result = Yii::$app->cache->get($cacheKey);
if ($result === false) {
$categories = Category::findBySql($sql)->all();
$result = $this->render($this->viewFile, ['categories' => $categories]);
Yii::$app->cache->set($cacheKey, $result, 86400, new \yii\caching\TagDependency(['tags' => ActiveRecordHelper::getCommonTag(Category::tableName())]));
}
return $result;
}
public function down()
{
$this->dropTable('{{%special_price_list_type}}');
$this->dropTable('{{%special_price_object}}');
$this->dropColumn('{{%special_price_list}}', 'type_id');
$this->addColumn('{{%special_price_list}}', 'type', "ENUM('core', 'discount', 'delivery', 'project') DEFAULT 'project'");
$this->update('{{%special_price_list}}', ['type' => 'core'], ['class' => 'app\\modules\\shop\\models\\Currency', 'object_id' => Object::getForClass(Product::className())->id]);
$this->update('{{%special_price_list}}', ['type' => 'discount'], ['class' => 'app\\modules\\shop\\models\\Discount', 'object_id' => Object::getForClass(Product::className())->id]);
$this->delete('{{%special_price_list}}', ['class' => 'app\\modules\\shop\\models\\Discount', 'object_id' => Object::getForClass(Order::className())->id]);
}
public function getObject()
{
if ($this->object === null) {
$this->object = Object::getForClass(get_class($this->owner));
if ($this->object === null) {
throw new \Exception("Can't find Object row for " . get_class($this->owner));
}
}
return $this->object;
}
public function run()
{
$object = app\models\Object::getForClass($this->model->className());
/** @var \app\modules\shop\models\AddonCategory $addonCategories */
$addonCategories = app\components\Helper::getModelMap(AddonCategory::className(), 'id', 'name');
/** @var app\modules\shop\models\Addon $bindedAddons */
$bindedAddons = $this->model->bindedAddons;
$addAddonModel = new AddAddonModel();
return $this->render('addons-widget', ['object' => $object, 'addonCategories' => $addonCategories, 'bindedAddons' => $bindedAddons, 'model' => $this->model, 'form' => $this->form, 'addAddonModel' => $addAddonModel]);
}
public function getBindedAddons()
{
$object_id = Object::getForClass($this->className())->id;
return $this->hasMany(Addon::className(), ['id' => 'addon_id'])->viaTable('{{%addon_bindings}}', ['object_model_id' => 'id'], function ($query) use($object_id) {
/** @var \yii\db\Query $query */
$query->andWhere(['appliance_object_id' => $object_id]);
$query->orderBy(['sort_order' => SORT_ASC]);
return $query;
})->innerJoin('{{%addon_bindings}}', 'addon_id=addon.id AND appliance_object_id=:aoid AND object_model_id=:oid', [':aoid' => $object_id, ':oid' => $this->id])->orderBy(['addon_bindings.sort_order' => SORT_ASC]);
}
public function up()
{
$submissionObject = Object::getForClass(\app\models\Submission::className());
/** @var PropertyHandler $propertyHandler */
$propertyHandler = PropertyHandler::findOne(['name' => 'Text']);
$this->addColumn(Review::tableName(), 'submission_id', 'INT UNSIGNED NOT NULL');
$form = new \app\models\Form();
$form->name = 'Review form';
$form->email_notification_addresses = '';
$form->email_notification_view = '@app/modules/review/views/review-email-template.php';
$form->save(false, ['name', 'email_notification_addresses', 'email_notification_view']);
$propertyGroup = new PropertyGroup();
$propertyGroup->attributes = ['object_id' => $form->object->id, 'name' => 'Review form additional properties', 'hidden_group_title' => 1];
$propertyGroup->save(true, ['object_id', 'name', 'hidden_group_title']);
$nameProperty = new Property();
$nameProperty->attributes = ['property_group_id' => $propertyGroup->id, 'name' => 'Name', 'key' => 'name', 'property_handler_id' => $propertyHandler->id, 'handler_additional_params' => '{}', 'is_eav' => 1];
$nameProperty->save(true, ['property_group_id', 'name', 'key', 'property_handler_id', 'is_eav', 'handler_additional_params']);
$phoneProperty = new Property();
$phoneProperty->attributes = ['property_group_id' => $propertyGroup->id, 'name' => 'Phone', 'key' => 'phone', 'property_handler_id' => $propertyHandler->id, 'handler_additional_params' => '{}', 'is_eav' => 1];
$phoneProperty->save(true, ['property_group_id', 'name', 'key', 'property_handler_id', 'is_eav', 'handler_additional_params']);
$objectPropertyGroup = new ObjectPropertyGroup();
$objectPropertyGroup->attributes = ['object_id' => $form->object->id, 'object_model_id' => $form->id, 'property_group_id' => $propertyGroup->id];
$objectPropertyGroup->save(true, ['object_id', 'object_model_id', 'property_group_id']);
$reviews = Review::find()->all();
foreach ($reviews as $review) {
$submission = new \app\models\Submission();
$submission->form_id = $form->id;
$submission->processed_by_user_id = $review->author_user_id;
$submission->date_received = $review->date_submitted;
$submission->save(false, ['form_id', 'processed_by_user_id', 'date_received']);
$review->submission_id = $this->db->lastInsertID;
$review->save(true, ['submission_id']);
$this->insert(ObjectPropertyGroup::tableName(), ['object_id' => $submissionObject->id, 'object_model_id' => $submission->id, 'property_group_id' => $propertyGroup->id]);
$this->insert($submissionObject->eav_table_name, ['object_model_id' => $submission->id, 'property_group_id' => $propertyGroup->id, 'key' => $nameProperty->key, 'value' => $review->author_name]);
$this->insert($submissionObject->eav_table_name, ['object_model_id' => $submission->id, 'property_group_id' => $propertyGroup->id, 'key' => $phoneProperty->key, 'value' => $review->author_phone]);
}
$this->dropColumn(Review::tableName(), 'date_submitted');
$this->dropColumn(Review::tableName(), 'author_user_id');
$this->dropColumn(Review::tableName(), 'author_name');
$this->dropColumn(Review::tableName(), 'author_phone');
$this->dropColumn(Review::tableName(), 'rate');
$this->renameColumn(Review::tableName(), 'text', 'review_text');
$this->alterColumn(Review::tableName(), 'rating_id', 'CHAR(32)');
$this->update(BackendMenu::tableName(), ['route' => 'review/backend-rating/index'], ['route' => 'backend/rating/index']);
$this->update(BackendMenu::tableName(), ['route' => 'review/backend-review/index'], ['name' => 'Reviews']);
$this->delete(BackendMenu::tableName(), ['route' => ['review/backend/products', 'review/backend/pages']]);
$this->alterColumn(RatingValues::tableName(), 'rating_id', 'CHAR(32) NOT NULL');
$this->alterColumn(RatingValues::tableName(), 'object_id', 'INT UNSIGNED NOT NULL');
$this->alterColumn(RatingValues::tableName(), 'object_model_id', 'INT UNSIGNED NOT NULL');
$this->alterColumn(RatingValues::tableName(), 'rating_item_id', 'INT UNSIGNED NOT NULL');
$this->alterColumn(RatingValues::tableName(), 'user_id', 'INT UNSIGNED NOT NULL');
$this->createIndex('ix-rating_values-rating_id', RatingValues::tableName(), 'rating_id');
$this->createIndex('ix-rating_values-object_id-object_model_id', RatingValues::tableName(), ['object_id', 'object_model_id']);
$this->createIndex('ix-rating_item-rating_group', RatingItem::tableName(), 'rating_group');
}
/**
* @inheritdoc
* @param int $id
* @return int|mixed
* @throws NotFoundHttpException
*/
public function run($id)
{
/** @var Form|HasProperties $form */
if (null === ($form = Form::findById($id))) {
throw new NotFoundHttpException();
}
$post = Yii::$app->request->post();
$form->abstractModel->setAttrubutesValues($post);
/** @var AbstractModel|SpamCheckerBehavior $model */
$model = $form->getAbstractModel();
if (Yii::$app->request->isAjax && isset($post['ajax'])) {
Yii::$app->response->format = Response::FORMAT_JSON;
return ActiveForm::validate($model);
}
/** @var \app\models\Object $object */
$object = Object::getForClass(Form::className());
$propGroups = ObjectPropertyGroup::find()->where(['and', 'object_id = :object', 'object_model_id = :id'], [':object' => $object->id, ':id' => $id])->asArray()->all();
$propIds = ArrayHelper::getColumn($propGroups, 'property_group_id');
// Spam checking
$activeSpamChecker = SpamChecker::getActive();
$data = [];
$haveSpam = false;
if ($activeSpamChecker !== null && !empty($activeSpamChecker->api_key)) {
$data[$activeSpamChecker->name]['class'] = $activeSpamChecker->behavior;
$data[$activeSpamChecker->name]['value']['key'] = $activeSpamChecker->api_key;
$properties = Property::getForGroupId($propIds[0]);
foreach ($properties as $prop) {
if (!isset($activeSpamChecker->{$prop->interpret_as}) || empty($activeSpamChecker->{$prop->interpret_as})) {
continue;
}
$data[$activeSpamChecker->name]['value'][$activeSpamChecker->{$prop->interpret_as}] = is_array($post[$form->abstractModel->formName()][$prop->key]) ? implode(' ', $post[$form->abstractModel->formName()][$prop->key]) : $post[$form->abstractModel->formName()][$prop->key];
}
$model->attachBehavior('spamChecker', ['class' => SpamCheckerBehavior::className(), 'data' => $data]);
$haveSpam = $model->isSpam();
}
$date = new \DateTime();
/** @var Submission|HasProperties $submission */
$submission = new Submission(['form_id' => $form->id, 'date_received' => $date->format('Y-m-d H:i:s'), 'ip' => Yii::$app->request->userIP, 'user_agent' => Yii::$app->request->userAgent, 'spam' => (int) $haveSpam]);
if (false === Yii::$app->user->isGuest) {
$submission->processed_by_user_id = Yii::$app->user->identity->getId();
}
if (!($form->abstractModel->validate() && $submission->save())) {
return "0";
}
if (isset($post[$form->abstractModel->formName()])) {
$data = ['AddPropetryGroup' => [$submission->formName() => array_keys($form->getPropertyGroups())], $submission->abstractModel->formName() => $post[$form->abstractModel->formName()]];
if (isset($_FILES[$form->abstractModel->formName()])) {
$_FILES[$submission->abstractModel->formName()] = $_FILES[$form->abstractModel->formName()];
}
$submission->saveProperties($data);
}
return $submission->id;
}
public function search($params)
{
/* @var $query \yii\db\ActiveQuery */
$query = $this->baseModel->find();
$table_inheritance_joined = false;
$dataProvider = new ActiveDataProvider(['query' => &$query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
if (!$this->load($params)) {
return $dataProvider;
}
$object = Object::getForClass($this->baseModel->className());
$baseModelTableName = $this->baseModel->tableName();
$eavJoinsCount = 0;
$osvJoinsCount = 0;
foreach ($this->propertyGroups as $groupId => $properties) {
foreach ($properties as $key => $propertyValue) {
/** @var \app\properties\PropertyValue $propertyValue */
$prop = Property::findById($propertyValue->property_id);
if (empty($this->{$prop->key}) === true && $this->{$prop->key} !== '0') {
continue;
}
// determine property storage type and join needed table if needed
if ($prop->is_column_type_stored) {
if ($table_inheritance_joined === false) {
$table_inheritance_joined = true;
$query->join('INNER JOIN', $object->column_properties_table_name . ' ti', 'ti.object_model_id = ' . $baseModelTableName . '.id');
}
if ($prop->value_type === 'STRING' && $prop->property_handler_id !== 3) {
$query->andFilterWhere(['like', 'ti.' . $prop->key, $this->{$prop->key}]);
} else {
$query->andFilterWhere(['ti.' . $prop->key => $this->{$prop->key}]);
}
} elseif ($prop->is_eav) {
$eavJoinsCount++;
$eavTableName = 'eav' . $eavJoinsCount;
$key = 'key' . $eavJoinsCount;
$query->join('INNER JOIN', "{$object->eav_table_name} {$eavTableName}", $eavTableName . '.object_model_id = ' . $baseModelTableName . ".id AND {$eavTableName}.key=:{$key}", [$key => $prop->key]);
if ($prop->value_type === 'STRING' && $prop->property_handler_id !== 3) {
$query->andFilterWhere(['like', $eavTableName . '.value', $this->{$prop->key}]);
} else {
// numeric - direct match
$query->andFilterWhere([$eavTableName . '.value' => $this->{$prop->key}]);
}
} elseif ($prop->has_static_values) {
$osvJoinsCount++;
$osvTableName = 'osv' . $osvJoinsCount;
$query->join('INNER JOIN', "object_static_values {$osvTableName}", "{$osvTableName}.object_id={$object->id} AND {$osvTableName}.object_model_id={$baseModelTableName}.id");
// numeric - direct match
$query->andFilterWhere(["{$osvTableName}.property_static_value_id", $this->{$prop->key}]);
}
}
}
return $dataProvider;
}
public function up()
{
// return false;
$this->addColumn('{{%special_price_list}}', 'handler', Schema::TYPE_STRING);
$this->update('{{%special_price_list}}', ['class' => 'app\\modules\\shop\\helpers\\PriceHandlers', 'handler' => 'getCurrencyPriceProduct'], ['class' => 'app\\modules\\shop\\models\\Currency', 'object_id' => \app\models\Object::getForClass(\app\modules\shop\models\Product::className())->id]);
$this->update('{{%special_price_list}}', ['class' => 'app\\modules\\shop\\helpers\\PriceHandlers', 'handler' => 'getDiscountPriceProduct'], ['class' => 'app\\modules\\shop\\models\\Discount', 'object_id' => \app\models\Object::getForClass(\app\modules\shop\models\Product::className())->id]);
$this->update('{{%special_price_list}}', ['class' => 'app\\modules\\shop\\helpers\\PriceHandlers', 'handler' => 'getDiscountPriceOrder'], ['class' => 'app\\modules\\shop\\models\\Discount', 'object_id' => \app\models\Object::getForClass(\app\modules\shop\models\Order::className())->id]);
$this->insert('{{%special_price_list}}', ['object_id' => \app\models\Object::getForClass(\app\modules\shop\models\Order::className())->id, 'class' => 'app\\modules\\shop\\helpers\\PriceHandlers', 'active' => 1, 'sort_order' => 12, 'handler' => 'getDeliveryPriceOrder', 'type_id' => (new \yii\db\Query())->select('id')->from('{{%special_price_list_type}}')->where(['key' => 'delivery'])->scalar()]);
$this->insert('{{%events}}', ['owner_class_name' => 'app\\modules\\shop\\ShopModule', 'event_name' => 'order_calculate', 'event_class_name' => 'app\\modules\\shop\\events\\OrderCalculateEvent', 'selector_prefix' => '', 'event_description' => '', 'documentation_link' => '']);
$eventId = $this->db->lastInsertID;
$this->insert('{{%event_handlers}}', ['event_id' => $eventId, 'sort_order' => 0, 'handler_class_name' => 'app\\modules\\shop\\helpers\\PriceHandlers', 'handler_function_name' => 'handleSaveDiscounts', 'is_active' => 1, 'non_deletable' => 0, 'triggering_type' => 'application_trigger']);
}
public function actionEdit($parent_id, $id = null)
{
$object = Object::getForClass(Page::className());
/** @var null|Page|HasProperties $model */
$model = new Page();
$model->published = 1;
if ($id !== null) {
$model = Page::findOne($id);
if ($model === null) {
throw new NotFoundHttpException();
}
}
$model->parent_id = $parent_id;
$event = new BackendEntityEditEvent($model);
$this->trigger(self::BACKEND_PAGE_EDIT, $event);
$post = \Yii::$app->request->post();
if ($event->isValid && $model->load($post)) {
$saveStateEvent = new BackendEntityEditEvent($model);
$this->trigger(self::BACKEND_PAGE_EDIT_SAVE, $saveStateEvent);
if ($saveStateEvent->isValid && $model->validate()) {
$save_result = $model->save();
$model->saveProperties($post);
if (null !== ($view_object = ViewObject::getByModel($model, true))) {
if ($view_object->load($post, 'ViewObject')) {
if ($view_object->view_id <= 0) {
$view_object->delete();
} else {
$view_object->save();
}
}
}
if ($save_result) {
$this->runAction('save-info', ['model_id' => $model->id]);
Yii::$app->session->setFlash('info', Yii::t('app', 'Object saved'));
$returnUrl = Yii::$app->request->get('returnUrl', ['/page/backend/index']);
switch (Yii::$app->request->post('action', 'save')) {
case 'next':
return $this->redirect(['/page/backend/edit', 'returnUrl' => $returnUrl, 'parent_id' => Yii::$app->request->get('parent_id', null)]);
case 'back':
return $this->redirect($returnUrl);
default:
return $this->redirect(Url::toRoute(['/page/backend/edit', 'id' => $model->id, 'returnUrl' => $returnUrl, 'parent_id' => $model->parent_id]));
}
} else {
\Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot update data'));
}
}
}
return $this->render('page-form', ['model' => $model, 'object' => $object]);
}
/**
* @throws yii\web\ServerErrorHttpException
*/
public function init()
{
parent::init();
if (null === $this->modelName) {
throw new yii\web\ServerErrorHttpException('Model name should be set in controller actions');
}
if (!is_subclass_of($this->modelName, '\\yii\\db\\ActiveRecord')) {
throw new yii\web\ServerErrorHttpException('Model class does not exists');
}
$this->objectId = Object::getForClass($this->modelName);
if (null === $this->objectId) {
throw new yii\web\ServerErrorHttpException('Object does not exists for model.');
}
}
public function run()
{
app\backend\assets\FrontendEditingAsset::register($this->view);
$items = [['label' => Icon::show('dashboard') . ' ' . Yii::t('app', 'Backend'), 'url' => ['/backend/']]];
switch (Yii::$app->requestedRoute) {
case 'shop/product/list':
if (isset($_GET['properties'])) {
$apply_if_params = [];
foreach ($_GET['properties'] as $property_id => $values) {
if (isset($values[0])) {
$apply_if_params[$property_id] = $values[0];
}
}
if (Yii::$app->response->dynamic_content_trait === true) {
$items[] = ['label' => Icon::show('puzzle') . ' ' . Yii::t('app', 'Edit Dynamic Content'), 'url' => ['/backend/dynamic-content/edit', 'id' => Yii::$app->response->matched_dynamic_content_trait_model->id]];
} else {
if (isset($_GET['properties'], $_GET['last_category_id'])) {
$items[] = ['label' => Icon::show('puzzle') . ' ' . Yii::t('app', 'Add Dynamic Content'), 'url' => ['/backend/dynamic-content/edit', 'DynamicContent' => ['apply_if_params' => Json::encode($apply_if_params), 'apply_if_last_category_id' => $_GET['last_category_id'], 'object_id' => Object::getForClass(app\modules\shop\models\Product::className())->id, 'route' => 'shop/product/list']]];
}
}
} else {
// no properties selected - go to category edit page
if (isset($_GET['last_category_id'])) {
$reviewsLink = $this->getReviewEditParams("Category", intval($_GET['last_category_id']));
$cat = app\modules\shop\models\Category::findById($_GET['last_category_id']);
$items[] = ['label' => Icon::show('pencil') . ' ' . Yii::t('app', 'Edit category'), 'url' => ['/shop/backend-category/edit', 'id' => $cat->id, 'parent_id' => $cat->parent_id]];
}
}
break;
case 'shop/product/show':
if (isset($_GET['model_id'])) {
$reviewsLink = $this->getReviewEditParams("Product", intval($_GET['model_id']));
$items[] = ['label' => Icon::show('pencil') . ' ' . Yii::t('app', 'Edit product'), 'url' => ['/shop/backend-product/edit', 'id' => intval($_GET['model_id'])]];
}
break;
case '/page/page/show':
case '/page/page/list':
if (isset($_GET['id'])) {
$page = app\modules\page\models\Page::findById($_GET['id']);
$reviewsLink = $this->getReviewEditParams("Page", $_GET['id']);
$items[] = ['label' => Icon::show('pencil') . ' ' . Yii::t('app', 'Edit page'), 'url' => ['/page/backend/edit', 'id' => $page->id, 'parent_id' => $page->parent_id]];
}
break;
}
if (!empty($reviewsLink)) {
$items[] = $reviewsLink;
}
return $this->render('floating-panel', ['items' => $items, 'bottom' => $this->bottom]);
}
public static function editQuery(SearchEvent $event)
{
/** @var \app\modules\shop\ShopModule $module */
$module = \Yii::$app->modules['shop'];
/** @var \app\modules\shop\ShopModule $module */
$properties = (new Query())->select('`id`')->from(PropertyStaticValues::tableName())->where('`name` LIKE :q')->addParams([':q' => '%' . $event->q . '%'])->all();
$event->activeQuery->select('{{%object_static_values}}.object_model_id')->distinct(true)->from(ObjectStaticValues::tableName())->where('{{%object_static_values}}.object_id = :objectId')->addParams([':objectId' => Object::getForClass(Product::className())->id])->andWhere(['in', '{{%object_static_values}}.property_static_value_id', ArrayHelper::getColumn($properties, 'id')]);
if ($module->allowSearchGeneratedProducts != 1) {
$event->activeQuery->innerJoin('{{%product}}', '{{%product}}.id = {{%object_static_values}}.object_model_id');
$event->activeQuery->andWhere(['{{%product}}.parent_id' => 0, '{{%product}}.active' => 1]);
}
$event->setFunctionSearch(function ($activeQuery) {
return ArrayHelper::getColumn($activeQuery->all(), 'object_model_id');
});
}
public function actionEdit($id = null)
{
$model = new Form();
if ($id > 0) {
$model = Form::findOne($id);
}
/** @var \app\models\Object $object */
$object = Object::getForClass(Form::className());
$propIds = (new Query())->select('property_group_id')->from([ObjectPropertyGroup::tableName()])->where(['and', 'object_id = :object', 'object_model_id = :id'], [':object' => $object->id, ':id' => $id])->column();
$post = \Yii::$app->request->post();
$properties = isset($post['Form']['properties']) ? $post['Form']['properties'] : [];
if ($model->load($post) && $model->validate()) {
if ($model->save()) {
$id = $model->id;
$remove = [];
$add = [];
foreach ($propIds as $value) {
$key = array_search($value, $properties);
if ($key === false) {
$remove[] = $value;
} else {
unset($properties[$key]);
}
}
foreach ($properties as $value) {
$add[] = [$value, $object->id, $id];
}
Yii::$app->db->createCommand()->delete(ObjectPropertyGroup::tableName(), ['and', 'object_id = :object', 'object_model_id = :id', ['in', 'property_group_id', $remove]], [':object' => $object->id, ':id' => $id])->execute();
if (!empty($add)) {
Yii::$app->db->createCommand()->batchInsert(ObjectPropertyGroup::tableName(), ['property_group_id', 'object_id', 'object_model_id'], $add)->execute();
}
\Yii::$app->session->setFlash('info', Yii::t('app', 'Object saved'));
$returnUrl = Yii::$app->request->get('returnUrl', ['/backend/form/index', 'id' => $model->id]);
switch (Yii::$app->request->post('action', 'save')) {
case 'next':
return $this->redirect(['/backend/form/edit', 'returnUrl' => $returnUrl]);
case 'back':
return $this->redirect($returnUrl);
default:
return $this->redirect(Url::toRoute(['/backend/form/edit', 'id' => $model->id, 'returnUrl' => $returnUrl]));
}
} else {
\Yii::$app->session->setFlash('error', Yii::t('app', 'Cannot update data'));
}
}
$items = ArrayHelper::map(PropertyGroup::find()->where('object_id = :object', [':object' => $object->id])->all(), 'id', 'name');
return $this->render('edit', ['model' => $model, 'items' => $items, 'selected' => $propIds]);
}
public function actionClearDeleted()
{
$time = new \DateTime();
$days = Yii::$app->getModule('core')->daysToStoreSubmissions;
$time->sub(new \DateInterval("P{$days}D"));
/** @var Object $object */
$object = Object::getForClass(Submission::className());
if ($object !== null) {
$submissionIds = Submission::find()->select(['id'])->where('UNIX_TIMESTAMP(`date_received`) < ' . $time->getTimestamp() . ' AND `is_deleted` = \'1\'')->column();
Review::deleteAll(['submission_id' => $submissionIds]);
Yii::$app->db->createCommand()->delete($object->column_properties_table_name, ['object_model_id' => $submissionIds]);
Yii::$app->db->createCommand()->delete($object->eav_table_name, ['object_model_id' => $submissionIds]);
Yii::$app->db->createCommand()->delete($object->categories_table_name, ['object_model_id' => $submissionIds]);
ObjectStaticValues::deleteAll(['object_id' => $object->id, 'object_model_id' => $submissionIds]);
Submission::deleteAll(['id' => $submissionIds]);
}
}
/**
* @throws NotFoundHttpException
* @throws ServerErrorHttpException
*/
public function init()
{
if (false === Yii::$app->request->isAjax) {
throw new NotFoundHttpException('Page not found');
}
$catId = Yii::$app->request->post('cat-id');
if (null !== Category::findOne(['id' => $catId])) {
$this->categoryId = $catId;
} else {
throw new ServerErrorHttpException("Can't find Category with id {$catId}");
}
if (true === empty(static::$object)) {
static::$object = Object::getForClass(Product::className());
}
$this->action = Yii::$app->request->post('action', '');
$this->items = Yii::$app->request->post('mc-items', []);
parent::init();
}
/**
* Поиск связи по модели
*
* @param \yii\db\ActiveRecord $model
* @param boolean $forceDefault Флаг для принудительного возврата модели
* @return \yii\db\ActiveRecord|null Возвращает модель или null, если ничего не найдено
*/
public static function getByModel($model = null, $forceDefault = false)
{
if (null === $model || !is_object($model)) {
return null;
}
if (null === ($object = Object::getForClass($model::className()))) {
return null;
}
if (null === ($result = static::find()->where(['object_id' => $object->id, 'object_model_id' => $model->id])->one())) {
if ($forceDefault) {
$result = new static();
$result->object_id = $object->id;
$result->object_model_id = $model->id;
$result->view_id = 1;
}
}
return $result;
}
public function run()
{
$object = Object::getForClass(\app\models\Form::className());
$groups = PropertyGroup::getForModel($object->id, $this->formId);
$view = !empty($this->model->form_view) ? $this->model->form_view : 'form';
$successView = !empty($this->model->form_success_view) ? $this->model->form_success_view : 'success';
if (!$this->isModal) {
echo Html::beginTag('div', ['id' => 'form-info-' . $this->id, 'style' => 'display: none;']);
echo $this->render($successView);
echo '</div>';
}
echo $this->render($view, ['id' => $this->id, 'model' => $this->model, 'groups' => $groups, 'options' => $this->options]);
if ($this->isModal) {
Modal::end();
Modal::begin(['id' => 'modal-form-info-' . $this->id, 'size' => Modal::SIZE_SMALL, 'header' => $this->statusHeaderName ? $this->statusHeaderName : $this->model->name . ' ' . \Yii::t('app', 'status')]);
echo $this->render($successView);
Modal::end();
}
}
/**
* @inheritdoc
*/
public function run()
{
$this->object = Object::getForClass(get_class($this->model));
$cacheKey = 'PropertiesWidget: ' . get_class($this->model) . ':' . $this->model->id;
$data = Yii::$app->cache->get($cacheKey);
if ($data === false) {
$this->objectPropertyGroups = ObjectPropertyGroup::getForModel($this->model);
$addedPropertyGroupsIds = [];
foreach ($this->objectPropertyGroups as $opg) {
$addedPropertyGroupsIds[] = $opg->property_group_id;
}
$restPg = (new Query())->select('id, name')->from(PropertyGroup::tableName())->where(['object_id' => $this->object->id])->andWhere(['not in', 'id', $addedPropertyGroupsIds])->orderBy('sort_order')->all();
$this->propertyGroupsToAdd = ArrayHelper::map($restPg, 'id', 'name');
Yii::$app->cache->set($cacheKey, ['objectPropertyGroups' => $this->objectPropertyGroups, 'propertyGroupsToAdd' => $this->propertyGroupsToAdd], 86400, new TagDependency(['tags' => [ActiveRecordHelper::getCommonTag(get_class($this->model)), ActiveRecordHelper::getCommonTag(PropertyGroup::className()), ActiveRecordHelper::getCommonTag(Property::className())]]));
} else {
$this->objectPropertyGroups = $data['objectPropertyGroups'];
$this->propertyGroupsToAdd = $data['propertyGroupsToAdd'];
}
return $this->render($this->viewFile, ['model' => $this->model, 'object' => $this->object, 'object_property_groups' => $this->objectPropertyGroups, 'property_groups_to_add' => $this->propertyGroupsToAdd, 'form' => $this->form, 'widget_id' => $this->getId()]);
}
public function getPossibleSelections()
{
$allowed_category_ids = [];
if ($this->onlyAvailableProducts) {
$object = Object::getForClass(Product::className());
if (!is_null($object) && isset($this->current_selections['last_category_id'])) {
$cacheKey = 'CategoriesFilterWidget: ' . $object->id . ':' . $this->current_selections['last_category_id'] . ':' . Json::encode($this->current_selections['properties']);
$allowed_category_ids = Yii::$app->cache->get($cacheKey);
if ($allowed_category_ids === false) {
$query = new Query();
$query = $query->select($object->categories_table_name . '.category_id')->distinct()->from($object->categories_table_name);
if (count($this->current_selections['properties']) > 0) {
foreach ($this->current_selections['properties'] as $property_id => $values) {
$joinTableName = 'OSVJoinTable' . $property_id;
$query->join('JOIN', ObjectStaticValues::tableName() . ' ' . $joinTableName, $joinTableName . '.object_id = :objectId AND ' . $joinTableName . '.object_model_id = ' . $object->categories_table_name . '.object_model_id ', [':objectId' => $object->id]);
$imploded_values = implode(', ', array_map('intval', $values));
$query->andWhere(new Expression('`' . $joinTableName . '`.`property_static_value_id`' . ' in (' . $imploded_values . ')'));
}
}
$allowed_category_ids = $query->column();
Yii::$app->cache->set($cacheKey, $allowed_category_ids, 86400, new \yii\caching\TagDependency(['tags' => [\devgroup\TagDependencyHelper\ActiveRecordHelper::getCommonTag($object->object_class), \devgroup\TagDependencyHelper\ActiveRecordHelper::getCommonTag(Category::className())]]));
$object = null;
}
}
}
$this->possible_selections = [];
$models = Category::getByLevel($this->category_group_id);
if (isset($models[0]) && $this->omit_root == true) {
$models = Category::getByParentId($models[0]->id);
}
$this->possible_selections = [];
foreach ($models as $model) {
if ($this->onlyAvailableProducts === true && !in_array($model->id, $allowed_category_ids)) {
continue;
}
$this->possible_selections[] = $this->recursiveGetTree($model, $allowed_category_ids);
}
return $this->possible_selections;
}
/**
* @inheritdoc
*/
public function run()
{
if (null === ($form = Form::findById($this->formId)) || null === $this->model || null === $this->model->object) {
throw new InvalidParamException();
}
if ($this->registerCanonical === true) {
$this->getView()->registerLinkTag(['rel' => 'canonical', 'href' => ObjectRule::canonical($this->additionalParams)], 'canonical');
}
$formObject = Object::getForClass(Form::className());
$groups = PropertyGroup::getForModel($formObject->id, $form->id);
$models = Review::getForObjectModel($this->model->id, $this->model->object->id, $form->id);
$review = new Review(['scenario' => 'check']);
$review->useCaptcha = $this->useCaptcha;
/** @var $module \app\modules\review\ReviewModule */
$module = Yii::$app->getModule('review');
$maxPerPage = $module->maxPerPage;
$pageSize = $module->pageSize;
if ($pageSize > $maxPerPage) {
$pageSize = $maxPerPage;
}
$this->additionalParams['review-page'] = Yii::$app->request->get('review-page');
$this->additionalParams['review-per-page'] = Yii::$app->request->get('review-per-page');
return $this->render($this->viewFile, ['reviews' => new ArrayDataProvider(['id' => 'review', 'allModels' => $models, 'pagination' => ['pageSize' => $pageSize, 'params' => $this->additionalParams], 'sort' => ['attributes' => ['submission_id'], 'defaultOrder' => ['submission_id' => $this->sort]]]), 'objectModel' => $this->model, 'model' => $form, 'review' => $review, 'groups' => $groups, 'ratingGroupName' => $this->ratingGroupName, 'useCaptcha' => $this->useCaptcha, 'additionalParams' => $this->additionalParams]);
}
/**
* Preparation to delete category.
* Deleting related products and inserted categories.
* @return bool
*/
public function beforeDelete()
{
if (!parent::beforeDelete()) {
return false;
}
$productObject = Object::getForClass(Product::className());
switch ($this->deleteMode) {
case self::DELETE_MODE_ALL:
$products = !is_null($productObject) ? Product::find()->join('INNER JOIN', $productObject->categories_table_name . ' pc', 'pc.object_model_id = product.id')->where('pc.category_id = :id', [':id' => $this->id])->all() : [];
break;
case self::DELETE_MODE_MAIN_CATEGORY:
$products = Product::findAll(['main_category_id' => $this->id]);
break;
default:
$products = !is_null($productObject) ? Product::find()->join('INNER JOIN', $productObject->categories_table_name . ' pc', 'pc.object_model_id = product.id')->join('INNER JOIN', $productObject->categories_table_name . ' pc2', 'pc2.object_model_id = product.id')->where('pc.category_id = :id', [':id' => $this->id])->groupBy('pc2.object_model_id')->having('COUNT(*) = 1')->all() : [];
break;
}
foreach ($products as $product) {
$product->delete();
}
foreach ($this->children as $child) {
$child->deleteMode = $this->deleteMode;
$child->delete();
}
if (!is_null($productObject)) {
Yii::$app->db->createCommand()->delete($productObject->categories_table_name, ['category_id' => $this->id])->execute();
}
return true;
}
/**
* Product page view
*
* @param null $model_id
* @return string
* @throws NotFoundHttpException
* @throws ServerErrorHttpException
*/
public function actionShow($model_id = null)
{
if (null === ($object = Object::getForClass(Product::className()))) {
throw new ServerErrorHttpException('Object not found.');
}
$cacheKey = 'Product:' . $model_id;
if (false === ($product = Yii::$app->cache->get($cacheKey))) {
if (null === ($product = Product::findById($model_id))) {
throw new NotFoundHttpException();
}
Yii::$app->cache->set($cacheKey, $product, 86400, new TagDependency(['tags' => [ActiveRecordHelper::getObjectTag(Product::className(), $model_id)]]));
}
$request = Yii::$app->request;
$values_by_property_id = $request->get('properties', []);
if (!is_array($values_by_property_id)) {
$values_by_property_id = [$values_by_property_id];
}
$selected_category_id = $request->get('last_category_id');
$selected_category_ids = $request->get('categories', []);
if (!is_array($selected_category_ids)) {
$selected_category_ids = [$selected_category_ids];
}
$category_group_id = intval($request->get('category_group_id', 0));
// trigger that we are to show product to user!
// wow! such product! very events!
$specialEvent = new ProductPageShowed(['product_id' => $product->id]);
EventTriggeringHelper::triggerSpecialEvent($specialEvent);
if (!empty($product->meta_description)) {
$this->view->registerMetaTag(['name' => 'description', 'content' => ContentBlockHelper::compileContentString($product->meta_description, Product::className() . ":{$product->id}:meta_description", new TagDependency(['tags' => [ActiveRecordHelper::getCommonTag(ContentBlock::className()), ActiveRecordHelper::getCommonTag(Product::className())]]))], 'meta_description');
}
$selected_category = $selected_category_id > 0 ? Category::findById($selected_category_id) : null;
$this->view->title = $product->title;
$this->view->blocks['h1'] = $product->h1;
$this->view->blocks['announce'] = $product->announce;
$this->view->blocks['content'] = $product->content;
$this->view->blocks['title'] = $product->title;
return $this->render($this->computeViewFile($product, 'show'), ['model' => $product, 'category_group_id' => $category_group_id, 'values_by_property_id' => $values_by_property_id, 'selected_category_id' => $selected_category_id, 'selected_category' => $selected_category, 'selected_category_ids' => $selected_category_ids, 'object' => $object, 'breadcrumbs' => $this->buildBreadcrumbsArray($selected_category, $product)]);
}
/**
* Replaces images for specified model
* $images array format:
* [
* 0 => [
* 'filename' => 'something.png',
* 'image_title' => 'title',
* 'image_alt' => 'alt',
* ],
* 1 => [
* 'image_title' => 'title',
* 'image_alt' => 'alt',
* ],
* ]
* @param \yii\db\ActiveRecord $model
* @param array $images array of data
* @throws \Exception
*/
public static function replaceForModel(\yii\db\ActiveRecord $model, array $images)
{
$object = Object::getForClass($model->className());
if ($object) {
$current_images = static::getForModel($object->id, $model->id);
// first find existing images in input array
foreach ($current_images as $current) {
$found = false;
foreach ($images as $key => $new) {
if ($new['filename'] === $current->filename && !empty($new['filename'])) {
$found = true;
$current->setAttributes($new);
$current->sort_order = $key;
$current->save();
// delete processed image from input array
unset($images[$key]);
}
}
if (!$found) {
$current->delete();
}
}
unset($current_images);
// insert new images
foreach ($images as $key => $new) {
if (isset($new['filename'])) {
if (!empty($new['filename'])) {
$new['filename'] = urldecode(preg_replace("~[\\?#].*\$~Usi", "", $new['filename']));
$image_model = new Image();
$image_model->object_id = $object->id;
$image_model->object_model_id = $model->id;
$image_model->filename = basename($new['filename']);
if (preg_match("#^https?://#Us", $new['filename'])) {
$image_model->filename = basename(preg_replace("#^https?://[^/]#Us", "", $new['filename']));
try {
$stream = fopen($new['filename'], 'r');
Yii::$app->getModule('image')->fsComponent->putStream($image_model->filename, $stream);
} catch (\Exception $e) {
// whoops :-(
}
} else {
$image_model->filename = $new['filename'];
}
$image_model->image_title = isset($new['image_title']) ? $new['image_title'] : '';
$image_model->image_alt = isset($new['image_alt']) ? $new['image_alt'] : '';
$image_model->sort_order = $key;
$image_model->save();
unset($image_model);
}
}
}
}
}
