public function actionGetAttributes()
{
Yii::$app->response->format = Response::FORMAT_JSON;
if (!($modelId = Yii::$app->getRequest()->post('model_id'))) {
return null;
}
$params['model_id'] = (int) $modelId;
$category_id = Yii::$app->getRequest()->post('category_id');
$params['category_id'] = $category_id ? $category_id : null;
$entity = EavEntity::findOne($params);
if (!$entity) {
try {
$entity = new EavEntity($params);
$entity->save();
} catch (Exception $exc) {
return false;
}
}
$querySelected = $entity->getEavAttributes()->orderBy('label')->limit(null);
$queryAvailable = clone $querySelected;
$selectedDataProvider = new ActiveDataProvider(['query' => $querySelected]);
$ids = $queryAvailable->select('id')->all();
$ids = array_map(function ($item) {
return $item->id;
}, $ids);
$ids = !empty($ids) ? implode(', ', $ids) : '0';
$availableDataProvider = new ActiveDataProvider(['query' => EavAttribute::find()->where("id NOT IN ({$ids})")->limit(null)]);
$selected = $this->renderIsAjax('attributes', ['dataProvider' => $selectedDataProvider]);
$available = $this->renderIsAjax('attributes', ['dataProvider' => $availableDataProvider]);
return ['available' => $available, 'selected' => $selected];
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = EavEntity::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => Yii::$app->request->cookies->getValue('_grid_page_size', 20)], 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'category_id' => $this->category_id, 'model_id' => $this->model_id]);
return $dataProvider;
}
protected function loadEavAttributes()
{
if (!$this->isAttributesLoaded) {
$modelTable = EavEntityModel::tableName();
$entityTable = EavEntity::tableName();
$attributeTable = EavAttribute::tableName();
$entityToAttributeTable = '{{%eav_entity_attribute}}';
$attributes = EavAttribute::find()->innerJoin($entityToAttributeTable, "{$attributeTable}.id = {$entityToAttributeTable}.attribute_id")->innerJoin($entityTable, "{$entityToAttributeTable}.entity_id = {$entityTable}.id")->innerJoin($modelTable, "{$entityTable}.model_id = {$modelTable}.id")->andWhere(["{$modelTable}.entity_model" => $this->ownerClassName])->andWhere(["{$entityTable}.category_id" => $this->getEavCatgoryId()])->orderBy(['order' => SORT_DESC])->all();
$validators = $this->owner->getValidators();
foreach ($attributes as $attribute) {
$this->eavAttributes->{$attribute['name']} = $attribute;
$validators[] = \yii\validators\Validator::createValidator('safe', $this->owner, [$attribute['name']], []);
}
$this->isAttributesLoaded = true;
}
}
public function setValue($entityModel, $catgoryId, $itemId, $value)
{
if (!isset($this->_value) || !$this->_value) {
$this->_value = $this->loadValue($entityModel, $catgoryId, $itemId);
}
if (!$this->_value) {
if (!($eavModel = EavEntityModel::findOne(['entity_model' => $entityModel]))) {
throw new InvalidParamException(Yii::t('yee/eav', 'Model was not found.'));
}
if (!($eavEntity = EavEntity::findOne(['model_id' => $eavModel->id, 'category_id' => $catgoryId]))) {
throw new InvalidParamException(Yii::t('yee/eav', 'Entity was not found.'));
}
$eavValue = new EavValue(['entity_id' => $eavEntity->id, 'attribute_id' => $this->getPrimaryKey(), 'item_id' => $itemId, 'value' => $value]);
if (!$eavValue->save()) {
throw new \yii\db\Exception(Yii::t('yee/eav', 'An error occurred during creation of EavValue record.'));
}
$this->_value = $eavValue;
}
$this->_value->value = $value;
}
