public function actionIndex() { $today = new DateTime(); // todo Надо переделать время $dateBegin = time(); $model = new Tour(); $model->date_begin = $today->format('Y-m-d'); $freeObj = Objreservation::find()->select('objreservation.*')->leftJoin('reservationinfo', 'objreservation.id = reservationinfo.objreservation_id')->where(['>=', 'reservationinfo.date_begin', time()])->groupBy('id')->limit(3)->all(); $data = ArrayHelper::getColumn(Tag::find()->asArray()->all(), 'name'); return $this->render('index', ['model' => $model, 'data' => $data, 'freeObj' => $freeObj, 'dateBegin' => $dateBegin]); }
public function actionIndex($sort = 'desc', $dateBegin = null) { if (Yii::$app->request->post('Tour')['date_begin']) { $dateBegin = Yii::$app->request->post('Tour')['date_begin']; } // todo Надо переделать время $dateBegin = time(); if ($sort == 'desc') { $query = Objreservation::find()->select('objreservation.*')->leftJoin('reservationinfo', 'objreservation.id = reservationinfo.objreservation_id')->where(['>=', 'reservationinfo.date_begin', $dateBegin])->groupBy('id')->addOrderBy(['price' => SORT_DESC]); } else { if ($sort == 'asc') { $query = Objreservation::find()->select('objreservation.*')->leftJoin('reservationinfo', 'objreservation.id = reservationinfo.objreservation_id')->where(['>=', 'reservationinfo.date_begin', $dateBegin])->groupBy('id')->addOrderBy(['price' => SORT_ASC]); } } $countQuery = clone $query; $pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => 4]); $models = $query->offset($pages->offset)->limit($pages->limit)->all(); return $this->render('index', ['models' => $models, 'pages' => $pages, 'dateBegin' => $dateBegin, 'sort' => $sort]); }
/** * @return \yii\db\ActiveQuery */ public function getObjreservation() { return $this->hasOne(Objreservation::className(), ['id' => 'objreservation_id']); }
public function getFreeRandomObjreservation() { $today = new DateTime(); // echo Yii::info($today->format('Y-m-d H:i:s')); // ['reservationinfo.date_begin' => $today->format('Y-m-d H:i:s')] return $query = Objreservation::find()->select('objreservation.*')->leftJoin('reservationinfo', 'objreservation.id = reservationinfo.objreservation_id')->where(['>=', 'reservationinfo.date_begin', strtotime($today->getTimestamp())])->limit(3)->all(); }