/** * Displays a single Friends model. * @param string $userOne * @param string $userTwo * @return mixed */ public function actionView($user) { $model = User::find()->where('username = :username', [':username' => $user])->one(); $owner_id = $model["id"]; $dataProvider = new ActiveDataProvider(['query' => Album::find()->where(['owner_id' => '' . $owner_id, 'shareable' => '1'])]); $query = new Query(); $dataProviderOne = new ActiveDataProvider(['query' => $query->select("*")->from('album')->innerJoin('yetki', 'yetki.id' . '=' . 'album.id')->where('owner_id = ' . $owner_id)]); return $this->render('view', ['dataProvider' => $dataProvider, 'dataProviderOne' => $dataProviderOne]); }
public function actionSharable($albumId, $username, $name, $surname) { $sql = (new \yii\db\Query())->createCommand()->insert('yetki', ['id' => $albumId, 'username' => $username, 'name' => $name, 'surname' => $surname])->execute(); $dataProvider = new ActiveDataProvider(['query' => Album::find()->where(['owner_id' => '' . Yii::$app->user->getId()])]); return $this->render('index', ['dataProvider' => $dataProvider]); }