/** * @return \yii\db\ActiveQuery */ public function getTitleImage() { return $this->hasOne(EntityToFile::className(), ['entity_model_id' => 'id'])->andOnCondition(['t2.entity_model_name' => static::formName(), 't2.attribute' => EntityToFile::TYPE_ARTICLE_TITLE_IMAGE])->from(['t2' => EntityToFile::tableName()])->orderBy('t2.position DESC'); }
public function actionSortImages() { $sortOrder = \Yii::$app->request->post('sort'); if ($sortOrder) { $sortOrder = explode(',', $sortOrder); $i = count($sortOrder); foreach ($sortOrder as $fileId) { \Yii::$app->db->createCommand()->update(EntityToFile::tableName(), ['position' => $i], 'id = :id', [':id' => (int) $fileId])->execute(); $i--; } } echo Json::encode([]); }