public function getMyBookmarks()
{
$book = Bookmark::find()->where(['user_id' => 1])->asArray()->all();
$n = count($book);
$arr = [];
for ($i = 0; $i < $n; $i++) {
$arr[$i] = $book[$i]['advert_id'];
}
$query = Advert::find()->andFilterWhere(['IN', 'id', $arr]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Bookmark::find();
$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;
}
$query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'advert_id' => $this->advert_id]);
return $dataProvider;
}
/**
* Displays a single Advert model.
* @param integer $id
* @return mixed
*/
public function actionView($id)
{
if (Currency::find()->where(['>', 'date', time()])->orderBy(['date' => SORT_DESC])->asArray()->one() == null) {
$currency = new Currency();
if ($currency->exchangeRates()) {
Yii::$app->session->setFlash('warning', 'Exchange rates might differ from actual ones');
}
}
$model = $this->findModel($id);
$pic = new Pictures();
$imgModel = new UploadForm();
$n = Bookmark::find()->where(['user_id' => Yii::$app->user->identity->getId(), 'advert_id' => $id])->all();
if ($model->user_id == Yii::$app->user->identity->getId()) {
if (isset($_POST['delete'])) {
$model->deletePic();
}
if (!empty($n)) {
$value = 'Delete ' . 'from bookmarks';
} else {
$value = 'Add to bookmarks';
}
if (Yii::$app->request->isPost) {
$imgModel->imageFiles = UploadedFile::getInstances($imgModel, 'imageFiles');
if ($imgModel->upload($id)) {
return $this->render('view-my-advert', ['model' => $this->findModel($id), 'imgModel' => $imgModel, 'pic' => $pic]);
}
}
return $this->render('view-my-advert', ['model' => $this->findModel($id), 'imgModel' => $imgModel, 'pic' => $pic, 'value' => $value]);
} else {
$views = new Views();
$n = Bookmark::find()->where(['user_id' => Yii::$app->user->identity->getId(), 'advert_id' => $id])->all();
if (!empty($n)) {
$value = 'Delete ' . 'from bookmarks';
} else {
$value = 'Add to bookmarks';
}
if (!$views->countViews($id)) {
if ($model->user_id !== Yii::$app->user->identity->getId()) {
$advert = new Advert();
$advert->countViews($id);
$views->advert_id = $id;
$views->user_id = Yii::$app->user->identity->getId();
$views->save();
}
}
return $this->render('view-adv', ['model' => $this->findModel($id), 'pic' => $pic, 'imgModel' => $imgModel, 'value' => $value]);
}
}
public function actionAddToBookmarks($id)
{
$bookmark = new Bookmark();
$n = Bookmark::find()->where(['user_id' => Yii::$app->user->identity->getId(), 'advert_id' => $id])->one();
if (!empty($n)) {
$n->delete();
echo 'Add to bookmarks';
} else {
$bookmark->user_id = Yii::$app->user->identity->getId();
$bookmark->advert_id = $id;
$bookmark->save();
echo 'Delete ' . 'from bookmarks';
}
}
use app\models\AdvertSearch;
use app\models\Bookmark;
use app\models\Currency;
use yii\data\ActiveDataProvider;
use yii\helpers\Html;
use yii\helpers\Url;
$columns = [['attribute' => 'price', 'format' => 'html', 'value' => function ($searchModel) {
$currency = Currency::find()->where(['>', 'date', time()])->asArray()->one();
$dropDownItems = ['uan' => 'грн.', 'rur' => 'руб.', 'usd' => 'USD', 'eur' => 'EURO'];
if (isset($_GET['currency']) && $_GET['currency'] !== 'default') {
$cur = $_GET['currency'];
} else {
$cur = $searchModel->currency;
}
$price = round($searchModel->price * ($currency[$searchModel->currency] / $currency[$cur]), 2);
return '<h4><strong>' . $price . ' ' . $dropDownItems[$cur] . '</strong></h4>';
}, 'options' => ['style' => 'width: 130px; max-width: 130px;']], ['attribute' => 'price', 'format' => 'html', 'value' => function ($searchModel) {
$span = '<span class="glyphicon glyphicon-trash"></span>';
$url = Url::toRoute(['bookmark/delete-bm', 'advert_id' => $searchModel->id]);
return Html::a($span, [$url]);
}]];
$searchModel = new AdvertSearch();
$book = Bookmark::find()->where(['user_id' => Yii::$app->user->identity->getId()])->asArray()->all();
$n = count($book);
$arr = [0];
for ($i = 0; $i < $n; $i++) {
$arr[$i] = $book[$i]['advert_id'];
}
$query = Advert::find()->andFilterWhere(['IN', 'id', $arr]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
echo $this->render('_try', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'columns' => $columns]);
public function getMyBookmarks()
{
$query = Bookmark::find()->andFilterWhere(['user_id' => Yii::$app->user->identity->getId()]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
return $dataProvider;
}
public function actionAddToBookmarks($id)
{
$bookmark = new Bookmark();
$n = Bookmark::find()->where(['user_id' => Yii::$app->user->identity->getId(), 'advert_id' => $id])->all();
// var_dump(!empty($n)); die;
if (!empty($n)) {
echo Json::encode([]);
} else {
$bookmark->user_id = Yii::$app->user->identity->getId();
$bookmark->advert_id = $id;
$bookmark->save();
echo Json::encode([]);
}
}
