public function run()
{
$model = new Categories();
if ($model->load(Yii::$app->request->post())) {
if ($model->save()) {
Yii::$app->session->setFlash('success', Yii::t('app', 'New category successfully saved.'));
$model = new Categories();
} else {
Yii::$app->session->setFlash('error', Yii::t('app', 'Error on saving category.'));
}
}
return Yii::$app->request->isAjax ? $this->controller->renderAjax('manage', ['model' => $model]) : $this->controller->render('manage', ['model' => $model]);
}
public function run($cat = 0)
{
$cat = (int) $cat;
Yii::$app->response->format = \yii\web\Response::FORMAT_RAW;
$headers = Yii::$app->response->headers;
$headers->add('Content-Type', 'application/xml');
$content = '<?xml version="1.0" encoding="UTF-8"?>';
if ($cat <= 0) {
$categories = Categories::find()->where(['status' => Categories::STATUS_ACTIVE])->select(['id'])->asArray()->all();
$content .= '<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
foreach ($categories as $category) {
$content .= '<sitemap>';
$content .= '<loc>' . Url::to(['/feed/sitemap', 'cat' => $category['id']], true) . '</loc>';
$content .= '</sitemap>';
}
$content .= '</sitemapindex>';
} else {
$advers = $this->controller->getModel(null, $cat);
$content .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1">';
foreach ($advers as $adver) {
$url = urldecode(Adver::generateLink($adver['id'], $adver['title'], $adver['category']['name'], $adver['country']['name'], $adver['province']['name'], $adver['city']['name'], $adver['address'], $adver['lang'], true));
$content .= '<url>';
$content .= "<loc>{$url}</loc>";
$content .= "<changefreq>daily</changefreq>";
$content .= '<priority>0.5</priority>';
$content .= '<lastmod>' . date(DATE_W3C, $adver['updated_at']) . '</lastmod>';
foreach ($adver['gallery'] as $gallery) {
$content .= '<image:image><image:loc>' . Gallery::getImageUrlFromOutside($gallery['name'], $gallery['adver_id'], 0, 0, 70, true) . '</image:loc></image:image>';
}
$content .= '</url>';
}
$content .= '</urlset>';
}
return $content;
}
public function findModel($id)
{
if (($model = Categories::findOne($id)) !== null) {
return $model;
} else {
throw new \yii\web\NotFoundHttpException(Yii::t('app', 'The requested page does not exist.'));
}
}
public function run($id)
{
$id = (int) $id;
$output = [];
if (($model = \common\models\categories\Categories::findOne($id)) !== null) {
if ($model->delete()) {
$output = ['error' => false, 'message' => Yii::t('app', 'Successfully deleted!')];
}
}
if (empty($output)) {
$output = ['error' => true, 'message' => Yii::t('app', 'The requested page does not exist.')];
}
return \yii\helpers\Json::encode($output);
}
public function run($search = null, $id = null)
{
$out = ['more' => false];
if (!is_null($search)) {
$query = new Query();
$query->select('[[id]], [[name]] AS [[text]]')->from('{{%categories}}')->filterWhere(['like', '[[name]]', $search])->andWhere(['[[status]]' => Categories::STATUS_ACTIVE])->limit(20);
$command = $query->createCommand();
$data = $command->queryAll();
$out['results'] = array_values($data);
} elseif ($id > 0) {
$cat = Categories::findOne(['id' => $id, 'status' => Categories::STATUS_ACTIVE]);
$out['results'] = ['id' => $id, 'text' => $cat->name];
} else {
$out['results'] = ['id' => 0, 'text' => Yii::t('app', 'No matching records found')];
}
return Json::encode($out);
}
public function run($id)
{
$id = (int) $id;
$output = [];
if (($model = Categories::findOne($id)) !== null) {
if ($model->status == Categories::STATUS_ACTIVE) {
$model->status = Categories::STATUS_DISABLE;
} else {
$model->status = Categories::STATUS_ACTIVE;
}
if ($model->save()) {
$output = ['error' => false, 'message' => Yii::t('app', 'Successfully status changed!')];
}
}
if (empty($output)) {
$output = ['error' => true, 'message' => Yii::t('app', 'The requested page does not exist.')];
}
return \yii\helpers\Json::encode($output);
}
public function search($params)
{
$query = Categories::find();
// join with relation `author` that is a relation to the table `users`
// and set the table alias to be `author`
$query->joinWith(['user' => function ($query) {
$query->from(['u' => 'user']);
}]);
$query->from(['c' => $this->tableName()]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->sort->attributes['user.username'] = ['asc' => ['u.username' => SORT_ASC], 'desc' => ['u.username' => SORT_DESC]];
//$dataProvider->sort->defaultOrder = ['updated_at' => SORT_DESC];
// load the seach form data and validate
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
// adjust the query by adding the filters
$query->andFilterWhere(['c.id' => $this->id]);
$query->andFilterWhere(['like', 'c.name', $this->name])->andFilterWhere(['c.status' => $this->status]);
$query->andFilterWhere(['LIKE', 'u.username', $this->getAttribute('user.username')]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getCategories()
{
return $this->hasMany(Categories::className(), ['user_id' => 'id']);
}
</h3>
</div>
<div class="panel-body">
<?php
$form = ActiveForm::begin(['id' => $model->formName(), 'enableClientValidation' => true]);
?>
<?php
echo Html::activeHiddenInput($model, 'id');
?>
<?php
echo $form->field($model, 'name')->textInput();
?>
<?php
if (Yii::$app->getUser()->can('CategoryDisable')) {
echo $form->field($model, 'status')->dropDownList(Categories::getStatusList());
}
?>
<?php
if (!$model->isNewRecord) {
echo $form->field($model, 'user_id')->widget(Select2::classname(), ['language' => Yii::$app->helper->getTwoCharLanguage(), 'pluginOptions' => ['allowClear' => true, 'minimumInputLength' => 2, 'ajax' => ['url' => $userListUrl, 'dataType' => 'json', 'data' => new JsExpression('function(params) { return {search:params.term}; }'), 'results' => new JsExpression('function(data,page) { return {results:data.results}; }')], 'initSelection' => new JsExpression($initScript)]]);
}
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? Yii::t('app', 'Add') : Yii::t('app', 'Update'), ['class' => 'btn btn-primary btn-block']);
?>
</div>
<?php
ActiveForm::end();
?>
/**
* @return \yii\db\ActiveQuery
*/
public function getCategory()
{
return $this->hasOne(Categories::className(), ['id' => 'category_id']);
}