Пример #1
0
 /**
  * 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]);
 }
Пример #2
0
 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]);
 }