public function actionSave()
{
if (Yii::$app->request->isPost) {
$post = Yii::$app->request->post();
if ($post['payload'] && $post['entityModel']) {
$payload = Json::decode($post['payload']);
if (!isset($payload['fields'])) {
return;
}
$categoryId = isset($post['categoryId']) ? $post['categoryId'] : 0;
$entityId = EavEntity::find()->select(['id'])->where(['entityModel' => $post['entityModel'], 'categoryId' => $categoryId])->scalar();
if (!$entityId) {
$entity = new EavEntity();
$entity->entityName = isset($post['entityName']) ? $post['entityName'] : 'Untitled';
$entity->entityModel = $post['entityModel'];
$entity->categoryId = $categoryId;
$entity->save(false);
$entityId = $entity->id;
}
foreach ($payload['fields'] as $order => $field) {
$attribute = EavAttribute::findOne(['name' => $field['cid'], 'entityId' => $entityId]);
if (!$attribute) {
$attribute = new EavAttribute();
$lastId = EavAttribute::find()->select(['id'])->orderBy(['id' => SORT_DESC])->limit(1)->scalar() + 1;
$attribute->name = 'c' . $lastId;
}
//$attribute->name = $field['cid'];
$attribute->type = $field['type'];
$attribute->entityId = $entityId;
$attribute->typeId = EavAttributeType::find()->select(['id'])->where(['name' => $field['field_type']])->scalar();
$attribute->label = $field['label'];
//$attribute->defaultValue = '';
//$attribute->defaultOptionId = 0;
$attribute->required = $field['required'];
$attribute->order = $order;
$attribute->description = isset($field['field_options']['description']) ? $field['field_options']['description'] : '';
$attribute->save(false);
if (!isset($field['field_options']['options'])) {
continue;
}
EavAttributeOption::deleteAll(['attributeId' => $attribute->id]);
foreach ($field['field_options']['options'] as $o) {
$option = new EavAttributeOption();
$option->attributeId = $attribute->id;
$option->value = $o['label'];
$option->defaultOptionId = (int) $o['checked'];
$option->save();
}
}
}
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = EavEntity::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'categoryId' => $this->categoryId]);
$query->andFilterWhere(['like', 'entityName', $this->entityName])->andFilterWhere(['like', 'entityModel', $this->entityModel]);
return $dataProvider;
}
public function getListEntities()
{
$models = EavEntity::find()->select(['id', 'entityName'])->asArray()->all();
return ArrayHelper::map($models, 'id', 'entityName');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEntity()
{
return $this->hasOne(EavEntity::className(), ['id' => 'entityId']);
}
/**
* Finds the EavEntity model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return EavEntity the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = EavEntity::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionSave()
{
if (Yii::$app->request->isPost) {
$post = Yii::$app->request->post();
if ($post['payload'] && $post['entityModel']) {
$payload = Json::decode($post['payload']);
if (!isset($payload['fields'])) {
return;
}
$transaction = \Yii::$app->db->beginTransaction();
try {
$categoryId = isset($post['categoryId']) ? $post['categoryId'] : 0;
$entityId = EavEntity::find()->select(['id'])->where(['entityModel' => $post['entityModel'], 'categoryId' => $categoryId])->scalar();
if (!$entityId) {
$entity = new EavEntity();
$entity->entityName = isset($post['entityName']) ? $post['entityName'] : 'Untitled';
$entity->entityModel = $post['entityModel'];
$entity->categoryId = $categoryId;
$entity->save(false);
$entityId = $entity->id;
}
$attributes = [];
foreach ($payload['fields'] as $order => $field) {
if (!isset($field['cid'])) {
continue;
}
// Attribute
if (isset($field['cid'])) {
$attribute = EavAttribute::findOne(['name' => $field['cid'], 'entityId' => $entityId]);
}
if (empty($attribute)) {
$attribute = new EavAttribute();
$lastId = EavAttribute::find()->select(['id'])->orderBy(['id' => SORT_DESC])->limit(1)->scalar() + 1;
$attribute->name = 'c' . $lastId;
}
$attribute->type = $field['group_name'];
$attribute->entityId = $entityId;
$attribute->typeId = EavAttributeType::find()->select(['id'])->where(['name' => $field['field_type']])->scalar();
$attribute->label = $field['label'];
$attribute->order = $order;
if (isset($field['field_options']['description'])) {
$attribute->description = $field['field_options']['description'];
unset($field['field_options']['description']);
} else {
$attribute->description = '';
}
$attribute->save(false);
$attributes[] = $attribute->id;
if (isset($field['field_options']['options'])) {
$options = [];
foreach ($field['field_options']['options'] as $k => $o) {
$option = EavAttributeOption::find()->where(['attributeId' => $attribute->id, 'value' => $o['label']])->one();
if (!$option) {
$option = new EavAttributeOption();
}
$option->attributeId = $attribute->id;
$option->value = $o['label'];
$option->defaultOptionId = (int) $o['checked'];
$option->order = $k;
$option->save();
$options[] = $option->value;
}
EavAttributeOption::deleteAll(['and', ['attributeId' => $attribute->id], ['NOT', ['IN', 'value', $options]]]);
unset($field['field_options']['options']);
}
// Rule
$rule = EavAttributeRule::find()->where(['attributeId' => $attribute->id])->one();
if (!$rule) {
$rule = new EavAttributeRule();
}
$rule->attributeId = $attribute->id;
if (!empty($field['field_options'])) {
foreach ($field['field_options'] as $key => $param) {
$rule->{$key} = $param;
}
}
$rule->required = isset($field['field_options']['required']) ? (int) $field['field_options']['required'] : 0;
$rule->visible = isset($field['field_options']['visible']) ? (int) $field['field_options']['visible'] : 0;
$rule->locked = isset($field['field_options']['locked']) ? (int) $field['field_options']['locked'] : 0;
$rule->save();
}
$attrArray = EavAttribute::find()->select('id')->where(['AND', ['NOT IN', 'id', $attributes], ['IN', 'entityId', $entityId]])->asArray()->all();
if (!is_null($attrArray)) {
EavAttribute::deleteAll(['IN', 'id', $attrArray]);
EavAttributeValue::deleteAll(['IN', 'attributeId', $attrArray]);
EavAttributeOption::deleteAll(['IN', 'attributeId', $attrArray]);
EavAttributeRule::deleteAll(['IN', 'attributeId', $attrArray]);
}
$transaction->commit();
} catch (\Exception $e) {
$transaction->rollBack();
throw $e;
}
}
}
}