public function run() { parent::run(); // TODO: Change the autogenerated stub $nodes = Event::find()->where(['status' => 10])->limit(2)->all(); return $this->render('EventRightWidget', ['nodes' => $nodes]); }
public function search($params) { $query = Event::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['defaultOrder' => ['updatedOn' => SORT_DESC]]); $query->andWhere("not ((`state`=" . AppActiveRecord::STATUS_DRAFT . ") AND (`createdBy`!=" . \yii::$app->user->id . "))"); if (!($this->load($params) && $this->validate())) { $query->andFilterWhere(['NOT', ['state' => AppActiveRecord::STATUS_DELETE]]); return $dataProvider; } if ($this->state !== null) { if ($this->state == AppActiveRecord::STATUS_DRAFT) { $query->andFilterWhere(['state' => $this->state, 'createdBy' => \yii::$app->user->id]); } else { $query->andFilterWhere(['state' => $this->state]); } } else { $query->andFilterWhere(['NOT', ['state' => AppActiveRecord::STATUS_DELETE]]); } $query->andFilterWhere(['Id' => $this->Id, 'sourceId' => $this->sourceId, 'cityId' => $this->cityId, 'zoneId' => $this->zoneId, 'localityId' => $this->localityId, 'gpsLat' => $this->gpsLat, 'gpsLong' => $this->gpsLong, 'startDate' => $this->startDate, 'endDate' => $this->endDate, 'startTime' => $this->startTime, 'endTime' => $this->endTime, 'status' => $this->status, 'isRecursive' => $this->isRecursive, 'healthStatus' => $this->healthStatus, 'createdOn' => $this->createdOn, 'createdBy' => $this->createdBy, 'updatedOn' => $this->updatedOn, 'updatedBy' => $this->updatedBy]); $query->andFilterWhere(['like', 'categoryId', $this->categoryId])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'landmark', $this->landmark])->andFilterWhere(['like', 'pincode', $this->pincode])->andFilterWhere(['like', 'tollfree', $this->tollfree])->andFilterWhere(['like', 'contactName', $this->contactName])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'shopurl', $this->shopurl])->andFilterWhere(['like', 'price', $this->price])->andFilterWhere(['like', 'ip', $this->ip])->andFilterWhere(['like', 'recursionData', $this->recursionData])->andFilterWhere(['like', 'oldGuid', $this->oldGuid])->andFilterWhere(['like', 'guid', $this->guid])->andFilterWhere(['like', 'multipleTimings', $this->multipleTimings])->andFilterWhere(['like', 'weekdaysChecklist', $this->weekdaysChecklist]); /*$query->joinWith('eventMap')->andFilterWhere(['like', 'phone', $this->phone]) ->andFilterWhere(['like', 'mobile', $this->mobile]);//*/ return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Event::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, 'created_date' => $this->created_date, ]); $query->andFilterWhere(['like', 'title', $this->title]) ->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
public function rightMonthEvents() { $dateStart = strtotime(date('Y-m-01')); $dateEnd = strtotime(date('Y-m-t')); $events = Event::find()->andWhere('date >= :dateStart AND date <= :dateEnd', [':dateStart' => $dateStart, ':dateEnd' => $dateEnd])->limit(5)->orderBy(new Expression('rand()'))->all(); return $this->render('rightWidget/rightMonthEvents', ['events' => $events]); }
public function actionIndex() { $today = date('Y-m-d 00:00:00'); $upcomming_event = Event::find()->where(['>=', 'start_date', $today])->all(); $past_event = Event::find()->where(['<=', 'close_date', $today])->all(); return $this->render('index', ['upcomming_event' => $upcomming_event, 'past_event' => $past_event]); }
public function actionShifts($id = null) { if (!isset($id)) { $id = Yii::$app->params['currentEvent']; } $data = Participant::findUserEventDataByDay($id, Yii::$app->user->id); $events = Event::find()->where(['not', ['id' => $id]])->all(); return $this->render('shifts', ['data' => $data, 'event' => Event::findOne($id), 'events' => $events]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Event::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'object_id' => $this->object_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'event_start' => $this->event_start, 'event_end' => $this->event_end]); $query->andFilterWhere(['like', 'object_type', $this->object_type])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'event_type', $this->event_type])->andFilterWhere(['like', 'status', $this->status]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Event::find(); $query->andFilterWhere(['status' => AppActiveRecord::STATUS_DELETE]); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->setSort(['defaultOrder' => ['updatedOn' => SORT_DESC]]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['Id' => $this->Id, 'sourceId' => $this->sourceId, 'cityId' => $this->cityId, 'zoneId' => $this->zoneId, 'localityId' => $this->localityId, 'gpsLat' => $this->gpsLat, 'gpsLong' => $this->gpsLong, 'startDate' => $this->startDate, 'endDate' => $this->endDate, 'startTime' => $this->startTime, 'endTime' => $this->endTime, 'status' => $this->status, 'isRecursive' => $this->isRecursive, 'healthStatus' => $this->healthStatus, 'createdOn' => $this->createdOn, 'createdBy' => $this->createdBy, 'updatedOn' => $this->updatedOn, 'updatedBy' => $this->updatedBy, 'isfeature' => $this->isfeature, 'featurepriority' => $this->featurepriority, 'type' => $this->type, 'entityType' => $this->entityType, 'state' => $this->state]); $query->andFilterWhere(['like', 'categoryId', $this->categoryId])->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'landmark', $this->landmark])->andFilterWhere(['like', 'pincode', $this->pincode])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'tollfree', $this->tollfree])->andFilterWhere(['like', 'mobile', $this->mobile])->andFilterWhere(['like', 'contactName', $this->contactName])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'shopurl', $this->shopurl])->andFilterWhere(['like', 'price', $this->price])->andFilterWhere(['like', 'ip', $this->ip])->andFilterWhere(['like', 'recursionData', $this->recursionData])->andFilterWhere(['like', 'oldGuid', $this->oldGuid])->andFilterWhere(['like', 'guid', $this->guid])->andFilterWhere(['like', 'multipleTimings', $this->multipleTimings])->andFilterWhere(['like', 'weekdaysChecklist', $this->weekdaysChecklist])->andFilterWhere(['like', 'tag', $this->tag])->andFilterWhere(['like', 'alias', $this->alias]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Event::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['eopen_date' => SORT_ASC]]]); $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, 'organiser_id' => $this->organiser_id, 'interest_id' => $this->interest_id, 'is_active' => $this->is_active, 'eeopen_date' => $this->eeopen_date, 'eopen_date' => $this->eopen_date, 'eclose_date' => $this->eclose_date, 'start_date' => $this->start_date, 'end_date' => $this->end_date, 'created_date' => $this->created_date, 'created_by' => $this->created_by, 'updated_date' => $this->updated_date, 'updated_by' => $this->updated_by]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'location', $this->location]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Event::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, 'start_date' => $this->start_date, 'end_date' => $this->end_date, 'status' => $this->status, 'created_by' => $this->created_by, 'updated_by' => $this->updated_by, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'slug', $this->slug])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'location', $this->location])->andFilterWhere(['like', 'meta_title', $this->meta_title])->andFilterWhere(['like', 'meta_keywords', $this->meta_keywords])->andFilterWhere(['like', 'meta_description', $this->meta_description]); return $dataProvider; }
public function run() { $calendarEvents = []; // 1. Events foreach (Event::find()->orderBy('event_start')->each() as $event) { $calendarEvents[] = $event->getFullCalendarEvent(); } // 2. Matches foreach (Match::find()->each() as $match) { foreach ($match->getEvents() as $event) { $calendarEvents[] = $event->getFullCalendarEvent(); } } return $this->render('calendar', ['events' => $calendarEvents, 'months' => 3]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Event::find(); // add conditions that should always apply here $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['sportName'] = ['asc' => ['{{%sport}}.name' => SORT_ASC], 'desc' => ['{{%sport}}.name' => SORT_DESC]]; $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'); $query->joinWith('{{@sport}}'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'gender' => $this->gender, 'sport_id' => $this->sport_id, 'max_weight' => $this->max_weight, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, '{{%sport}}.url_key' => $this->url_key]); $query->andFilterWhere(['like', '{{%event}}.name', $this->name]); $query->joinWith(['sport' => function ($q) { $q->where('{{%sport}}.name LIKE "%' . $this->sportName . '%"'); }]); return $dataProvider; }
public function getAllEvents($lastIds = [], $lastDate = 0, $orderBy = self::ORDER_BY_DATE, $dateCreateType = self::DATE_CREATE_ALL, $userId = false, $limit = false) { $query = Event::find()->from(["t" => Event::tableName()])->andWhere('t.deleted = 0')->addSelect('*'); if ($lastDate != 0) { if ($dateCreateType == self::DATE_CREATE_AFTER) { $query = $query->andWhere('t.date >= :date', [':date' => $lastDate]); } else { $query = $query->andWhere('t.date <= :date', [':date' => $lastDate]); } if (!empty($lastIds)) { $query = $query->andWhere(['not in', 'id', $lastIds]); } } // Определяем сортировку if ($orderBy == self::ORDER_BY_ID) { $query = $query->orderBy('id DESC'); } elseif ($orderBy == self::ORDER_BY_DATE) { if ($dateCreateType == self::DATE_CREATE_AFTER) { $query = $query->orderBy('date ASC'); } else { $query = $query->orderBy('date DESC'); } } // Определяем за какой период будем показывать if (!empty($limit)) { $query = $query->limit((int) $limit); } elseif ($dateCreateType == self::DATE_CREATE_ALL) { $query = $query->limit(20); } elseif ($dateCreateType == self::DATE_CREATE_BEFORE) { $query = $query->andWhere('t.date <= :date', [':date' => time()])->limit(20); } elseif ($dateCreateType == self::DATE_CREATE_AFTER) { $query = $query->andWhere('t.date >= :date', [':date' => time()])->limit(20); } if (!empty($userId)) { $query = $query->andWhere('user_id = :userId', [':userId' => $userId]); } $query = $query->with(['tagEntity', 'tagEntity.tags']); return $query->all(); }
public function actionIndex() { $article = Article::find()->orderBy(['date_time' => SORT_DESC])->one(); if ($article->articlePhotos[0]->photo_path == '') { if (Yii::$app->language == 'ru') { $articleimage = Yii::getAlias('@resource/img/news_ru.jpg'); } else { $articleimage = Yii::getAlias('@resource/img/news_en.jpg'); } } else { $articleimage = $article->articlePhotos[0]->photo_path; } $event = Event::find()->orderBy(['start_timedate' => SORT_ASC])->limit(3)->all(); $section = Section::find()->limit(8)->all(); $innovation_text_on_main_page = Setting::find()->where(['key' => 'innovation_text_on_main_page'])->one(); $cooperation_with_aic = Setting::find()->where(['key' => 'cooperation_with_aic'])->one(); $fill_in_the_blank = Setting::find()->where(['key' => 'fill_in_the_blank'])->one(); $find_out_how_we_can_help_you = Setting::find()->where(['key' => 'find_out_how_we_can_help_you'])->one(); $information_for_Students = Setting::find()->where(['key' => 'information_for_Students'])->one(); $for_scientists_and_enterpreneurs = Setting::find()->where(['key' => 'for_scientists_and_enterpreneurs'])->one(); return $this->render('index', ['article' => $article, 'articleimage' => $articleimage, 'event' => $event, 'section' => $section, 'innovation_text_on_main_page' => $innovation_text_on_main_page->settingLan->index, 'cooperation_with_aic' => $cooperation_with_aic->settingLan->index, 'fill_in_the_blank' => $fill_in_the_blank->settingLan->index, 'find_out_how_we_can_help_you' => $find_out_how_we_can_help_you->settingLan->index, 'information_for_Students' => $information_for_Students->settingLan->index, 'for_scientists_and_enterpreneurs' => $for_scientists_and_enterpreneurs->settingLan->index]); }
?> <?php echo Html::hiddenInput('EventsSet[sport_id]', $model->sport_id); ?> <?php } else { ?> <?php echo $form->field($model, 'sport_id')->dropDownList(ArrayHelper::map(SportSearch::find()->all(), 'id', 'name')); ?> <?php } ?> <?php echo $form->field($model, 'events')->checkboxList(ArrayHelper::map(Event::find()->bySport($model->sport)->all(), 'id', function ($data) { return $data->name . ' (' . $data->gender . ')'; })); ?> <div class="form-actions"> <div class="row"> <div class="col-md-offset-3 col-md-9"> <?php echo Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> </div> </div> <?php
public function getEventList() { $events = Event::find()->all(); return ArrayHelper::map($events, 'id', 'dropdownName'); }
</div> </div> </li> <?php } ?> </ul> </div> <h3 class="normal-heading text-uppercase addmarginB20">Upcoming Events</h3> <div class="col-4-event-grid col-3-event-grid"> <ul class="clearfix"> <?php $startdate = date("Y-m-d 00:00:00"); $closedate = date("Y-m-d 00:00:00"); // new \yii\db\Expression('NOW()'); $event = Event::find()->where(['>', 'start_date', $startdate])->andWhere(['>=', 'close_date', $closedate])->all(); foreach ($event as $evnt) { $eventid = $evnt->id; ?> <li> <div class="box"> <div class="itemImageBlock"> <a href="<?php echo Yii::$app->urlManager->createUrl(['event/view', 'id' => $eventid]); ?> "><img src="<?php echo $evnt->banner; ?> "></a> </div> <div class="detail">
public function actionSitemap() { // проверяем есть ли закэшированная версия sitemap $urls = array(); $items = Item::find()->where(['deleted' => 0])->all(); $events = \common\models\Event::find()->where(['deleted' => 0])->all(); $schools = School::find()->where(['deleted' => 0])->all(); foreach ($items as $item) { /** @var Item $item */ $urls[] = ['url' => $item->getUrl(true), 'priority' => 0.5]; } foreach ($events as $event) { /** @var \common\models\Event $event */ $urls[] = ['url' => $event->getUrl(true), 'priority' => 0.5]; } foreach ($schools as $school) { /** @var School $school */ $urls[] = ['url' => $school->getUrl(true), 'priority' => 0.8]; } Yii::$app->response->format = \yii\web\Response::FORMAT_XML; echo '<?xml version="1.0" encoding="UTF-8"?>' . PHP_EOL; echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; foreach ($urls as $url) { echo '<url>'; echo '<loc>' . $url['url'] . '</loc>'; echo '<changefreq>weekly</changefreq>'; echo '<priority>' . $url['priority'] . '</priority>'; echo '</url>'; } echo '</urlset>'; }
/** * Updates an existing event model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { /*$model = $this->findModel($id); $photos = new ActiveDataProvider([ 'query' => event_photo::find()-> where(['event_id'=>$id]), ]); if ($model->load(Yii::$app->request->post()) && $model->save()) { $this->uploadphoto(UploadedFile::getInstances($model, 'images'), $model->id); return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('update', [ 'model' => $model, 'photos' => $photos, ]); }*/ $event = Event::find()->where(['id' => $id])->one(); $event_ru = Event_ru::find()->where(['event_id' => $id])->one(); $event_en = Event_en::find()->where(['event_id' => $id])->one(); $photos = new ActiveDataProvider(['query' => event_photo::find()->where(['event_id' => $id])]); if ($event->load(Yii::$app->request->post()) && $event_ru->load(Yii::$app->request->post()) && $event_en->load(Yii::$app->request->post())) { $event->author_id = Yii::$app->user->identity->id; if ($event->save()) { $this->uploadphoto(UploadedFile::getInstances($event, 'images'), $event->id); $event_ru->save(); $event_en->save(); } return $this->redirect(['update', 'id' => $event->id]); } else { return $this->render('update', ['event' => $event, 'event_ru' => $event_ru, 'event_en' => $event_en, 'photos' => $photos]); } }
/** * Lists all Event models. * @return mixed */ public function actionIndex() { $eventsDb = Event::find()->all(); return $this->render('index', ['eventsDb' => $eventsDb]); }
public function actionMonth($year, $month) { $dateStart = strtotime($year . '-' . $month . '-01'); $dateEnd = strtotime(date('Y-m-t', $dateStart)); $events = Event::find()->andWhere('date >= :dateStart AND date <= :dateEnd', [':dateStart' => $dateStart, ':dateEnd' => $dateEnd])->orderBy('date')->all(); return $this->render('month', ['events' => $events, 'year' => $year, 'month' => $month]); }
public function actionAdmin() { $dataProvider = new ActiveDataProvider(['query' => Event::find(), 'pagination' => false]); return $this->render('admin', ['dataProvider' => $dataProvider]); }
public function actionMap() { if (\Yii::$app->request->isAjax) { return $this->renderJson(Event::find()->where('begin > ' . time())->all()); } return $this->render('map'); }
public function beforeSave($insert) { if (parent::beforeSave($insert)) { if ($this->alias == "") { $title = $this->encodestring($this->title); $alias = $this->toAscii($title); $baseAlias = substr($alias, 0, 250); $alias = $baseAlias; $i = 1; $wheres = ['alias = :alias']; $params[':alias'] = $alias; if (!is_null($this->id)) { $wheres[] = 'id <> :id'; $params = [':id' => $this->id]; } $where = join(' AND ', $wheres); while ($findEvent = Event::find()->where($where, $params)->one()) { $alias = $baseAlias . '-' . $i; $params[':alias'] = $alias; $i++; if ($i > 30) { $alias = ''; break; } } $this->alias = $alias; } return true; } return false; }