public function actionDeleteTour($tour_id)
{
if (!($tour = Tours::findOne($tour_id))) {
Yii::$app->session->setFlash('danger', 'Tour does not exists');
return $this->redirect('manage-tours');
}
$query = new Query();
$query->select([ToursDates::FIELD_TOUR_DATE_ID])->from(ToursDates::tableName())->where([ToursDates::FIELD_TOUR_ID => $tour_id]);
$dates_id = ArrayHelper::getColumn($query->all(), ToursDates::FIELD_TOUR_DATE_ID);
if ($bookings = Bookings::findAll([Bookings::FIELD_TOUR_DATE_ID => $dates_id])) {
Yii::$app->session->setFlash('danger', 'This tour can not delete because it has a reserved places');
return $this->redirect('manage-tours');
}
ToursDates::deleteAll([ToursDates::FIELD_TOUR_ID => $tour_id]);
$tour->delete();
Yii::$app->session->setFlash('success', 'Tour successful deleted');
return $this->redirect('manage-tours');
}
use yii\db\Expression;
use yii\helpers\Html;
use app\models\ToursDates;
use app\models\Tours;
$this->title = 'Booking tours';
?>
<div class="site-index">
<div class="jumbotron">
<h1>Welcome to Booking Tours service!</h1>
<p class="lead">Chose available tour to continue</p>
</div>
<div class="body-content">
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'emptyText' => 'No available tours at this moment', 'columns' => [['class' => DataColumn::className(), 'attribute' => Tours::FIELD_TITLE], ['class' => DataColumn::className(), 'label' => 'Nearest Tour', 'value' => function ($model) {
/* @var $model Tours*/
$query = new Query();
$query->select(ToursDates::FIELD_DATE)->from(ToursDates::tableName())->where([ToursDates::FIELD_TOUR_ID => $model->tour_id])->andWhere(['>=', ToursDates::FIELD_DATE, date('Y-m-d')])->orderBy([ToursDates::FIELD_DATE => SORT_ASC]);
$result = $query->one();
return $result[ToursDates::FIELD_DATE];
}], ['class' => ActionColumn::className(), 'contentOptions' => ['class' => 'text-center'], 'template' => '{view}', 'buttons' => ['view' => function ($url, $model, $key) {
/* @var $model Tours */
return Html::a('View Details', ['booking/tour-details', Tours::FIELD_TOUR_ID => $model->tour_id], ['class' => 'btn btn-success']);
}]]]]);
?>
</div>
</div>