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 }