Esempio n. 1
0
<?php

$smarty->assign('d_tourstatus', getTourStatus());
$smarty->assign('d_tourdifficulty', getTripDifficulty());
$smarty->assign('d_tourcomfort', getTripComfort());
$tour = new Tours();
$smarty->assign('TourAllYears', $tour->getAllFutureYears());
$options = array();
if (is_numeric($_POST['year'])) {
    $year = (int) $_POST['year'];
    //$options['strings_OR'][]=array('field'=>'tourStartDate','eq'=>'STRONGLIKE','value'=>"$year%%");
    $options['strings_OR'][] = array('field' => 'tourStartDate', 'eq' => 'STRONGLIKE', 'value' => "{$year}%%");
    $options['strings_OR'][] = array('field' => 'tourEndDate', 'eq' => 'STRONGLIKE', 'value' => "{$year}%%");
} else {
    //$year=date("Y");
    //if (date("m")>8) $year++;
    $options[] = array('field' => 'tourStartDate', 'eq' => '>=', 'value' => date('Y-m-d H:i:s', strtotime('-1 week')));
    $options[] = array('field' => 'tourStartDate', 'eq' => '<=', 'value' => date('Y-m-d H:i:s', strtotime('+1 year')));
}
$smarty->assign('year', $year);
$t = new Tours();
$options[] = array('field' => 'tourStatus', 'eq' => '!=', 'value' => 'hidden');
$options[] = array('field' => 'tourStartDate', 'eq' => 'ORDERBY', 'value' => 'tourStartDate');
$tours = $t->searchObjectsFromDB($options);
if (is_array($tours)) {
    foreach ($tours as $t) {
        $t->loadLinkedFromDB();
        $toursv[] = $t->getValues();
    }
}
$smarty->assign('Tours', $toursv);