public function bindChecknStore(&$data, $preload = false)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('itinerary.tsmart_itinerary_id')->from('#__tsmart_itinerary AS itinerary')->where('itinerary.tsmart_itinerary_id!=' . (int) $data['tsmart_itinerary_id'])->where('itinerary.tsmart_product_id=' . (int) $data['tsmart_product_id'])->where('itinerary.title = ' . $query->q("{$data['title']}"));
$db->setQuery($query);
$list_itinerary = $db->loadObjectList();
if (count($list_itinerary) > 0) {
vmError('itinerary title exists, please select other itinerary title');
return false;
}
return parent::bindChecknStore($data, $preload);
// TODO: Change the autogenerated stub
}
public function bindChecknStore(&$data, $preload = false)
{
$tsmart_product_id = $data['tsmart_product_id'];
$tsmart_service_class_id = $data['tsmart_service_class_id'];
$tsmart_promotion_price_id = $data['tsmart_promotion_price_id'];
$sale_period_from = JFactory::getDate($data['sale_period_from']);
$sale_period_to = JFactory::getDate($data['sale_period_to']);
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('COUNT(*)')->from('#__tsmart_tour_promotion_price AS tour_promotion_price')->where('tsmart_service_class_id=' . (int) $tsmart_service_class_id)->where('tsmart_product_id=' . (int) $tsmart_product_id)->where('tsmart_promotion_price_id<>' . (int) $tsmart_promotion_price_id)->where('((sale_period_from<=' . $query->q($sale_period_from->toSql()) . ' AND sale_period_to>= ' . $query->q($sale_period_from->toSql()) . ') OR (sale_period_from<=' . $query->q($sale_period_to->toSql()) . ' AND sale_period_to>= ' . $query->q($sale_period_to->toSql()) . '))');
$db->setQuery($query);
$total = $db->loadResult();
if ($total > 0) {
$this->setError('exists promotion');
return false;
}
return parent::bindChecknStore($data, $preload);
// TODO: Change the autogenerated stub
}
public function bindChecknStore(&$data, $preload = false)
{
return parent::bindChecknStore($data, $preload);
// TODO: Change the autogenerated stub
}
