public function beforeDelete()
{
if (parent::beforeDelete()) {
if ($this->type == 0) {
ClassifiedGuest::deleteAll('id = ' . $this->user_id);
}
Classified::deleteAll('id = ' . $this->classified_id);
ClassifiedImage::deleteAll('classified_id = ' . $this->classified_id);
return true;
} else {
return false;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Classified::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, 'category_id' => $this->category_id, 'country_id' => $this->country_id, 'region_id' => $this->region_id, 'city_id' => $this->city_id, 'price' => $this->price, 'create_at' => $this->create_at, 'update_at' => $this->update_at, 'user_id' => $this->user_id, 'is_status' => $this->is_status, 'type' => $this->type]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
public function actionClassified($id)
{
$modelCover = new Profile();
$modelCover = $this->findModel($id);
//Sort data
$sort = new \yii\data\Sort(['attributes' => ['create_at' => ['asc' => ['create_at' => SORT_ASC], 'desc' => ['create_at' => SORT_DESC], 'default' => SORT_DESC]]]);
//pagination
$queryPage = Classified::find()->where(['user_id' => $id]);
$countQueryPage = clone $queryPage;
$pagination = new \yii\data\Pagination(['totalCount' => $countQueryPage->count(), 'pageSize' => 2]);
//Search
$mainCategory = \common\models\MainCategory::find()->all();
$searchModel = new \common\models\search\GSearch();
$dataProvider = $searchModel->search(\Yii::$app->request->queryParams);
//query model
$query = new \yii\db\Query();
$query->select(['classified.id', 'classified.title', 'classified.description', 'classified.price', 'classified.create_at', 'classified.type', 'classified.user_id', 'classified.is_status', 'main_category.main_category', 'category.category', 'country.country', 'region.region', 'city.city', 'user.username'])->from('classified')->join('JOIN', 'category', 'category.id = classified.category_id')->join('JOIN', 'main_category', 'main_category.id = classified.main_category_id')->join('JOIN', 'country', 'country.id = classified.country_id')->join('JOIN', 'region', 'region.id = classified.region_id')->join('JOIN', 'city', 'city.id = classified.city_id')->join('JOIN', 'user', 'user.id = classified.user_id')->where(['user_id' => $id])->offset($pagination->offset)->limit($pagination->limit)->orderBy($sort->orders)->all();
$command = $query->createCommand();
$data = $command->queryAll();
return $this->render('classified', ['data' => $data, 'sort' => $sort, 'pagination' => $pagination, 'maincategory' => $mainCategory, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'modelCover' => $modelCover]);
}
</span>
<span class="diadoo-botton-link"><a href="<?php
echo \yii\helpers\Url::to(['/statistic-classified/']);
?>
"><i class="fa fa-search-plus"></i> Details</a></span>
</div><!-- /.info-box-content -->
</div><!-- /.info-box -->
</div><!-- /.col -->
<!-- fix for small devices only -->
<div class="clearfix visible-sm-block"></div>
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="info-box">
<span class="info-box-icon bg-red"><i class="fa fa-remove"></i></span>
<div class="info-box-content">
<span class="info-box-text">Inactive Classified</span>
<span class="info-box-number">
<?php
echo $queryInactive = \common\models\Classified::find()->where(['is_status' => 0])->count();
?>
</span>
<span class="diadoo-botton-link"><a href="<?php
echo \yii\helpers\Url::to(['/statistic-classified/']);
?>
"><i class="fa fa-search-plus"></i> Details</a></span>
</div><!-- /.info-box-content -->
</div><!-- /.info-box -->
</div><!-- /.col -->
</div>
/**
* Finds the Classified model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Classified the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Classified::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
}
?>
</ul>
</section>
</li>
<?php
}
// }
?>
</ul>
<div style="text-align: center;">
<h3>Total data</h3>
<p style="font-size: 20px"><?php
echo $countAll = \common\models\Classified::find()->count();
?>
</p>
</div>
</div>
</div>
</div>
<div style="text-align: center; padding-bottom: 15px">
<img src="banner/image/digitalocean-banner.jpg">
</div>
</div>
<div class="col-lg-3">
<div class="panel">
<div class="panel-heading">
</div>
