コード例 #1
0
 public function up()
 {
     $data = (include Yii::getAlias('@common') . '/data/test-adverts.php');
     $i = 0;
     while ($i++ !== 3) {
         foreach ($data as $one) {
             $advert = new Advert();
             $advert->detachBehavior('timestamp');
             $advert->setAttributes($one);
             $advert->user_id = rand(1, 50);
             $advert->created_at = time() - 3600 * 24 * rand(1, 31) - 3600 * rand(1, 24) + rand(1, 3600);
             $advert->updated_at = $advert->created_at;
             $advert->term_at = $advert->created_at + 3600 * 24 * rand(1, 31);
             if ($advert->save()) {
                 echo "Advert for user №{$advert->user_id} created\n";
             } else {
                 print_r($advert->getErrors());
             }
         }
     }
     foreach (User::find()->all() as $user) {
         $profile = new Profile();
         $profile->user_id = $user->id;
         $profile->name = $user->username;
         if ($profile->save()) {
             echo "Profile of \"{$user->username}\" created\n";
         } else {
             print_r($profile->getErrors());
         }
     }
 }
コード例 #2
0
ファイル: AdvertController.php プロジェクト: vecherskyy/dom
 protected function findModel($id)
 {
     if (($model = Advert::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
コード例 #3
0
ファイル: MainController.php プロジェクト: scorp7mix/yii
 public function actionViewAdvert($id)
 {
     $this->layout = 'inner';
     $model = Advert::findOne($id);
     $user = $model->user;
     $images = Common::getImageAdvert($model, false);
     return $this->render('view_advert', ['model' => $model, 'user' => $user, 'images' => $images]);
 }
コード例 #4
0
 /**
  * Creating model search query.
  * @return ActiveDataProvider|\yii\data\DataProviderInterface
  */
 public function search($params = [])
 {
     $query = Advert::find()->with('owner.profile');
     $dataProvider = new \roman444uk\yii\data\ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => \roman444uk\yii\widgets\WidgetPageSize::getPageSize()]]);
     if ($params && !($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $this->buildQuery($query, $params);
     return $dataProvider;
 }
コード例 #5
0
ファイル: FilterAdvert.php プロジェクト: scorp7mix/yii
    public function beforeAction($action)
    {
        $id = \Yii::$app->request->get('id');
        $model = Advert::findOne($id);

        if (null == $model) {
            throw new HttpException(404, 'Unknown advert');
            return false;
        }

        return parent::beforeAction($action);
    }
コード例 #6
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Advert::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(['idadvert' => $this->idadvert, 'price' => $this->price, 'fk_agent_detail' => $this->fk_agent_detail, 'badroom' => $this->badroom, 'livingroom' => $this->livingroom, 'parking' => $this->parking, 'kitchen' => $this->kitchen, 'hot' => $this->hot, 'sold' => $this->sold, 'recommend' => $this->recommend, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
     $query->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'general_image', $this->general_image])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'location', $this->location])->andFilterWhere(['like', 'type', $this->type]);
     return $dataProvider;
 }
コード例 #7
0
 public function up()
 {
     $this->upModules();
     $tableOptions = null;
     if ($this->db->driverName === 'mysql') {
         $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB';
     }
     // Advert table
     $this->createTable('advert', array('id' => 'pk', 'user_id' => 'int unsigned not null', 'city_id' => 'int unsigned', 'created_at' => 'int(11)', 'updated_at' => 'int(11)', 'type' => 'varchar(16)', 'category' => 'varchar(16)', 'content' => 'text default null', 'present' => 'tinyint(1) default 0', 'min_price' => 'int(11) default null', 'max_price' => 'int(11) default null', 'currency' => 'varchar(3)', 'term_at' => 'int(11)', 'views' => 'int(11) default 0', 'status' => 'enum("' . implode('","', Advert::getStatusList()) . '") default "' . Advert::STATUS_NEW . '"', 'likes' => 'int unsigned default 0', 'dislikes' => 'int unsigned default 0', 'published' => 'tinyint(1) default 0', 'is_templet' => 'tinyint(1) default 0', 'is_foreign' => 'tinyint(1) default 0'), $tableOptions);
     // Advert templet table
     $this->createTable('advert_templet', array('id' => 'pk', 'user_id' => 'int unsigned not null', 'advert' => 'text'), $tableOptions);
     // Category table
     $this->createTable('category', array('id' => 'pk', 'name' => 'varchar(64) not null', 'description' => 'varchar(128)', 'parent_id' => 'int unsigned not null'), $tableOptions);
     // City table
     $this->createTable('city', array('id' => 'pk', 'name' => 'varchar(64) not null', 'active' => 'tinyint(1) default 1'), $tableOptions);
     // User profile table
     $this->createTable('profile', array('id' => 'pk', 'user_id' => 'int unsigned not null', 'avatar_url' => 'varchar(256)', 'name' => 'varchar(64)'), $tableOptions);
 }
コード例 #8
0
 /**
  * Creating model search query.
  * @return ActiveDataProvider|\yii\data\DataProviderInterface
  */
 public function search($params = [])
 {
     $query = Advert::find()->with('owner.profile', 'files');
     // query city, bookmarks and likes
     $tableAdvert = self::tableName();
     $tableBookmark = Yii::$app->getModule('bookmarks')->tableBookmark;
     $query->select("{$tableAdvert}.*, ({$tableAdvert}.id = {$tableBookmark}.target_id) as bookmarked, city.name as cityName");
     $query->join('left join', $tableBookmark, "{$tableBookmark}.target_id = {$tableAdvert}.id");
     $query->join('left join', 'city', 'advert.city_id = city.id');
     // creating data provider
     $dataProvider = new \roman444uk\yii\data\ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => \roman444uk\yii\widgets\WidgetPageSize::getPageSize('advert-list')]]);
     if ($params && !($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $this->buildQuery($query, $params);
     if ($this->search_bookmarks) {
         $query->andWhere(["{$tableAdvert}.id" => Yii::$app->getModule('bookmarks')->manager->getIdList($this->bookmark_user_id, ['Advert'], true)]);
     }
     return $dataProvider;
 }
コード例 #9
0
ファイル: MainController.php プロジェクト: vecherskyy/dom
 public function actionFind($search = '', $price = '', $apartment = '')
 {
     $this->layout = 'sell';
     $query = Advert::find();
     $query->filterWhere(['like', 'address', $search])->orFilterWhere(['like', 'description', $search])->orFilterWhere(['type' => $apartment]);
     //$query->orFilterWhere(['type'=> $apartment]);
     if ($price) {
         $prices = explode("-", $price);
         if (isset($prices[0]) && isset($prices[1])) {
             $query->andWhere(['between', 'price', $prices[0], $prices[1]]);
         } else {
             $query->andWhere(['>=', 'price', $prices[0]]);
         }
         $countQuery = clone $query;
         $pages = new Pagination(['totalCount' => $countQuery->count()]);
         $pages->setPageSize(1);
         $model = $query->offset($pages->offset)->limit($pages->limit)->all();
         $request = Yii::$app->request;
         return $this->render('find', ['model' => $model, 'pages' => $pages, 'request' => $request]);
     }
 }
コード例 #10
0
ファイル: _form.php プロジェクト: roman444uk/moja-objava
?>

<div id="create-advert">

    <!-- Advert form -->
    <?php 
$form = ActiveForm::begin(['id' => 'advert-form', 'enableClientValidation' => true, 'enableAjaxValidation' => true, 'validateOnBlur' => true, 'validationUrl' => Url::to(['validate', 'id' => $model->id]), 'fieldConfig' => ['template' => "{label}{input}"], 'clientEvents' => ['ajaxSubmitSuccess' => "function(data) {\n    \$('a[data-update], a[data-view]').magnificPopup('close');\n    return false;\n}"]]);
?>

        <div class="left">
            <?php 
echo $form->field($model, 'city_id')->dropDownList(City::getList(), ['name' => $directPopulating ? 'city_id' : null, 'label' => 'City', 'emptyItem' => Yii::t('app', 'Empty city option')]);
?>

            <?php 
echo $form->field($model, 'type', [])->dropDownList(Advert::getTypesDropDownList(), ['name' => $directPopulating ? 'type' : null, 'emptyItem' => Yii::t('app', 'Empty type option')]);
?>

            <?php 
echo $form->field($model, 'category')->dropDownList(Category::getDropdownList(), ['name' => $directPopulating ? 'category' : null, 'emptyItem' => Yii::t('app', 'Empty category option')]);
?>

            <?php 
echo $form->field($model, 'term', ['template' => '{label}{input}'])->datepicker(['name' => $directPopulating ? 'term' : null, 'datepicker' => ['dateFormat' => Yii::$app->formatter->dateFormat, 'clientOptions' => ['maxDate' => "+1m", 'minDate' => "+1d", 'monthNamesShort' => DatepickerHelper::monthNamesShort()]]]);
?>
            
            <div class="range">
                <label class="control-label" for="min_price"><?php 
echo Yii::t('app', 'Price');
?>
</label>
コード例 #11
0
 /**
  * @return array \common\models\Advert
  */
 public function getAdverts()
 {
     return $this->hasMany(Advert::className(), ['user_id' => 'id']);
 }
コード例 #12
0
 /**
  * Test action.
  */
 public function actionVk()
 {
     $wall = file_get_contents("https://api.vk.com/method/wall.get?owner_id=-120504421&filter=others");
     $wall = json_decode($wall);
     foreach ($wall->response as $item) {
         if (is_object($item)) {
             $advert = new Advert();
             $advert->setScenario(Advert::SCENARIO_CREATE_FROM_SERVICE);
             $advert->content = $item->text;
             $advert->created_at = $item->date;
             $advert->save();
             if (isset($item->attachments)) {
                 foreach ($item->attachments as $a) {
                     $type = $a->type;
                     $f = $a->{$type};
                     $file = new \common\models\Image();
                     $file->remote_url = $f->src_big;
                     $file->created_at = $f->created;
                     $file->save();
                     $file->attachOwner($advert->id, 'Advert', 'files');
                 }
             }
         }
     }
 }
コード例 #13
0
ファイル: _form_old.php プロジェクト: roman444uk/moja-objava
        <div class="col-sm-9">
            <?php 
$form->field($model, 'content')->textarea([]);
?>
            <?php 
echo $form->field($model, 'content')->textarea(['name' => $directPopulating ? 'content' : null, 'rows' => 25]);
?>
        </div>
    
        <div class="col-sm-3">
            <?php 
echo $form->field($model, 'city_id')->dropDownList(City::getList(), ['name' => $directPopulating ? 'city_id' : null, 'class' => 'form-control input-sm']);
?>

            <?php 
echo $form->field($model, 'type')->dropDownList(Advert::getTypesDropDownList(), ['name' => $directPopulating ? 'type' : null, 'class' => 'form-control input-sm']);
?>

            <?php 
echo $form->field($model, 'category')->dropDownList(Category::getDropdownList(), ['name' => $directPopulating ? 'category' : null, 'class' => 'form-control input-sm']);
?>

            <?php 
/*echo $form->field($model, 'term')->datepicker([
      'name' => ($directPopulating) ? 'term' : null,
      'datepicker' => [
          'language' => 'ru',
          'dateFormat' => 'dd.MM.yyyy'
      ]
  ])*/
?>
コード例 #14
0
ファイル: MainController.php プロジェクト: eshaft/yii2shp
 public function actionViewAdvert($id)
 {
     $model = Advert::findOne($id);
     $data = ['name', 'email', 'text'];
     $model_feedback = new DynamicModel($data);
     $model_feedback->addRule('name', 'required');
     $model_feedback->addRule('email', 'required');
     $model_feedback->addRule('text', 'required');
     $model_feedback->addRule('email', 'email');
     if (\Yii::$app->request->isPost) {
         if ($model_feedback->load(\Yii::$app->request->post()) && $model_feedback->validate()) {
             \Yii::$app->common->sendMail('Subject Advert', $model_feedback->text);
         }
     }
     $user = $model->user;
     $images = \frontend\components\Common::getImageAdvert($model, false);
     $current_user = ['email' => '', 'username' => ''];
     if (!\Yii::$app->user->isGuest) {
         $current_user['email'] = \Yii::$app->user->identity->email;
         $current_user['username'] = \Yii::$app->user->identity->username;
     }
     $coords = str_replace(['(', ')'], '', $model->location);
     $coords = explode(',', $coords);
     $coord = new LatLng(['lat' => $coords[0], 'lng' => $coords[1]]);
     $map = new Map(['center' => $coord, 'zoom' => 20]);
     $marker = new Marker(['position' => $coord, 'title' => Common::getTitleAdvert($model)]);
     $map->addOverlay($marker);
     return $this->render('view_advert', ['model' => $model, 'model_feedback' => $model_feedback, 'user' => $user, 'images' => $images, 'current_user' => $current_user, 'map' => $map]);
 }
コード例 #15
0
    /**
     * 
     * @param type $userId
     * @return type
     */
    public static function getPublishedAdvertsCountSql()
    {
        if ($userId = Yii::$app->user->id) {
            $param = self::ADVERT_COUNT_ADDED_TODAY;
            $advertTable = Advert::tableName();
            return $sql = <<<SQL
select '{$param}' as param, count(*) as value from {$advertTable}
where {$advertTable}.user_id = {$userId}
SQL;
        }
        return null;
    }
コード例 #16
0
ファイル: Advert.php プロジェクト: roman444uk/moja-objava
 /**
  * @inheritdoc
  */
 public function extraFields()
 {
     // не обязательные поля
     return parent::extraFields();
 }
コード例 #17
0
ファイル: list.php プロジェクト: roman444uk/moja-objava
            <div class="col-sm-4 text-center">
                {summary}
            </div>
            <div class="col-sm-4 text-right">
                ' . WidgetPageSize::widget(['pjaxId' => 'advert-grid-pjax']) . '
            </div>
        </div>
        {items}
        <div class="row">
            <div class="col-sm-8">
                {pager}
            </div>
            <div class="col-sm-4 text-right" style="padding-top: 20px">
                ' . GridBulkActions::widget(['gridId' => 'user-grid']) . '
            </div>
        </div>', 'columns' => [['class' => 'yii\\grid\\CheckboxColumn', 'options' => ['style' => 'width:10px']], ['class' => 'yii\\grid\\SerialColumn', 'options' => ['style' => 'width:10px']], ['attribute' => 'id', 'header' => '№', 'filterInputOptions' => ['class' => 'form-control input-sm']], ['attribute' => 'content', 'format' => 'raw', 'contentOptions' => ['style' => 'text-align: left'], 'filterInputOptions' => ['class' => 'form-control input-sm']], ['class' => 'roman444uk\\yii\\grid\\AjaxUpdateColumn', 'attribute' => 'status', 'fieldType' => AjaxUpdateColumn::FIELD_TYPE_DROPDOWN, 'fieldOptions' => ['class' => 'form-control input-sm', 'items' => Advert::getTranslatedStatusList()], 'filter' => Advert::getTranslatedStatusList(), 'filterInputOptions' => ['class' => 'form-control input-sm'], 'updateUrl' => function ($model, $key, $index) {
    return Yii::$app->urlManager->createUrl(['advert/update', 'id' => $key]);
}, 'errorUpdate' => new JsExpression("function() {\n                alert('error updating');\n            }")], ['class' => 'roman444uk\\yii\\grid\\AjaxUpdateColumn', 'attribute' => 'category', 'fieldType' => AjaxUpdateColumn::FIELD_TYPE_DROPDOWN, 'fieldOptions' => ['class' => 'form-control input-sm', 'items' => Category::getDropdownList()], 'filter' => Category::getDropdownList(), 'filterInputOptions' => ['class' => 'form-control input-sm'], 'updateUrl' => function ($model, $key, $index) {
    return Yii::$app->urlManager->createUrl(['advert/update', 'id' => $key]);
}, 'errorUpdate' => new JsExpression("function() {\n                alert('error updating');\n            }")], ['attribute' => 'city_id', 'header' => 'Город', 'value' => function ($model, $key, $index) {
    return $model->cityName;
}, 'filter' => City::getList(), 'filterInputOptions' => ['class' => 'form-control input-sm'], 'format' => 'raw'], ['class' => 'yii\\grid\\DataColumn', 'attribute' => 'created_at', 'header' => 'Добавлено', 'format' => 'datetime', 'filter' => City::getList(), 'filterInputOptions' => ['class' => 'form-control input-sm']], ['class' => 'yii\\grid\\DataColumn', 'attribute' => 'updated_at', 'header' => 'Обновлено', 'format' => 'datetime', 'filter' => City::getList(), 'filterInputOptions' => ['class' => 'form-control input-sm']], ['class' => 'roman444uk\\yii\\grid\\StatusColumn', 'attribute' => 'published', 'filterInputOptions' => ['class' => 'form-control input-sm']], ['class' => 'roman444uk\\yii\\grid\\StatusColumn', 'attribute' => 'is_foreign', 'header' => 'Из сервиса', 'filter' => ['Да', 'Нет'], 'filterInputOptions' => ['class' => 'form-control input-sm']], ['class' => 'roman444uk\\yii\\grid\\ViewColumn', 'view' => '@backend/views/advert/_advert_grid_column', 'options' => ['style' => 'width:70px']], ['class' => 'yii\\grid\\ActionColumn', 'contentOptions' => ['style' => 'width:30px; text-align:center;'], 'buttons' => ['view' => function ($url, $model, $key) {
    return Html::a('<span class="glyphicon glyphicon-eye-open"></span><br>', $url, ['title' => Yii::t('yii', 'View'), 'data-pjax' => 0, 'data-view' => $key]);
}, 'update' => function ($url, $model, $key) {
    return Html::a('<span class="glyphicon glyphicon-pencil"></span><br>', $url, ['title' => Yii::t('yii', 'Update'), 'data-pjax' => 0, 'data-update' => $key]);
}]]]]);
?>

<?php 
Pjax::end();
?>