/**
* @return \yii\db\ActiveQuery
*/
public function getObjreservation()
{
return $this->hasOne(Objreservation::className(), ['id' => 'objreservation_id']);
}
/**
* Finds the Objreservation model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param string $id
* @return Objreservation the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Objreservation::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
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', $today->format('Y-m-d H:i:s')])->limit(3)->all();
}
public function actionGallery()
{
$model = \backend\models\Objreservation::findOne(3);
return $this->render('index', ['model' => $model]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getObjreservations()
{
return $this->hasMany(Objreservation::className(), ['location_id' => 'id']);
}
public function getObjreservation()
{
return $this->hasMany(Objreservation::className(), ['customer_id' => 'id'])->viaTable('customers', ['user_id' => 'id']);
}