PHP app\models ToursDates::tableName Examples

Example #1

File: SiteController.php Project: andreyshade/booking-tours

 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');
 }

Example #2

File: index.php Project: andreyshade/booking-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>