/** * Retireve a list of currencies from the database. * This function is used in the backend for the currency listing, therefore no asking if enabled or not * @author Max Milbers * @return object List of currency objects */ function getItemList($search = '') { //echo $this->getListQuery()->dump(); $items = parent::getItems(); $list_tsmart_product_id = array(); $db = $this->_db; foreach ($items as &$item) { $list_tsmart_product_id = $item->list_tsmart_product_id; $list_tsmart_product_id = explode(',', $list_tsmart_product_id); $tsmart_hotel_id = $item->tsmart_hotel_id; $tsmart_hotel_addon_id = $item->tsmart_hotel_addon_id; $list_tour_tour_class = array(); foreach ($list_tsmart_product_id as $tsmart_product_id) { $query = $db->getQuery(true); $query->select('CONCAT("<a href=index.php?option=com_tsmart&view=product&task=edit&tsmart_product_id=",products_en_gb.tsmart_product_id,">",products_en_gb.product_name," </a>","(",GROUP_CONCAT(DISTINCT(service_class.service_class_name) SEPARATOR ","),"."," ",")") AS tour_tour_class')->from('#__tsmart_hotel_id_service_class_id_accommodation_id AS hotel_id_service_class_id_accommodation_id')->leftJoin('#__tsmart_tour_id_service_class_id AS tour_id_service_class_id USING(tsmart_service_class_id)')->leftJoin('#__tsmart_service_class AS service_class ON service_class.tsmart_service_class_id=tour_id_service_class_id.tsmart_service_class_id')->where('hotel_id_service_class_id_accommodation_id.tsmart_hotel_id=' . (int) $tsmart_hotel_id)->leftJoin('#__tsmart_hotel_addon AS hotel_addon ON hotel_addon.tsmart_hotel_id=hotel_id_service_class_id_accommodation_id.tsmart_hotel_id')->where('hotel_addon.tsmart_hotel_addon_id=' . (int) $tsmart_hotel_addon_id)->leftJoin('#__tsmart_tour_id_hotel_addon_id AS tour_id_hotel_addon_id ON tour_id_hotel_addon_id.tsmart_hotel_addon_id=hotel_addon.tsmart_hotel_addon_id')->where('tour_id_hotel_addon_id.tsmart_product_id=' . (int) $tsmart_product_id)->leftJoin('#__tsmart_products AS products ON products.tsmart_product_id=tour_id_hotel_addon_id.tsmart_product_id')->innerJoin('#__tsmart_products_en_gb AS products_en_gb ON products_en_gb.tsmart_product_id=products.tsmart_product_id'); $db->setQuery($query); $list_tour_tour_class[] = $db->loadResult(); } $item->tour_tour_class = implode(' ', $list_tour_tour_class); } if ($tsmart_product_id = $this->getState('filter.tsmart_product_id')) { foreach ($items as $key => &$item) { $list_tsmart_product_id = $item->list_tsmart_product_id; $list_tsmart_product_id = explode(',', $list_tsmart_product_id); if (!in_array($tsmart_product_id, $list_tsmart_product_id)) { unset($items[$key]); } } } return $items; }
public function getItems() { require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmprice.php'; require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmpromotion.php'; $items = parent::getItems(); // TODO: Change the autogenerated stub // Create Money object that represents 1 EUR // Access the Money object's monetary value converted to its base units foreach ($items as &$item) { $item->sale_price_senior = vmprice::get_sale_price_by_mark_up_and_tax($item->price_senior, $item->mark_up_senior, $item->mark_up_price_senior, $item->tax, $item->mark_up_type); $item->sale_price_adult = vmprice::get_sale_price_by_mark_up_and_tax($item->price_adult, $item->mark_up_adult, $item->mark_up_price_adult, $item->tax, $item->mark_up_type); $item->sale_price_teen = vmprice::get_sale_price_by_mark_up_and_tax($item->price_teen, $item->mark_up_teen, $item->mark_up_price_teen, $item->tax, $item->mark_up_type); $item->sale_price_children1 = vmprice::get_sale_price_by_mark_up_and_tax($item->price_children1, $item->mark_up_children1, $item->mark_up_price_children1, $item->tax, $item->mark_up_type); $item->sale_price_children2 = vmprice::get_sale_price_by_mark_up_and_tax($item->price_children2, $item->mark_up_children2, $item->mark_up_price_children2, $item->tax, $item->mark_up_type); $item->sale_price_infant = vmprice::get_sale_price_by_mark_up_and_tax($item->price_infant, $item->mark_up_infant, $item->mark_up_price_infant, $item->tax, $item->mark_up_type); $item->sale_price_private_room = vmprice::get_sale_price_by_mark_up_and_tax($item->price_private_room, $item->mark_up_private_room, $item->mark_up_price_private_room, $item->tax, $item->mark_up_type); $item->sale_price_extra_bed = vmprice::get_sale_price_by_mark_up_and_tax($item->price_extra_bed, $item->mark_up_extra_bed, $item->mark_up_price_extra_bed, $item->tax, $item->mark_up_type); $item->sale_promotion_price_senior = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_senior, $item->mark_up_promotion_senior, $item->mark_up_promotion_price_senior, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_senior, $item->mark_up_promotion_net_senior, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_adult = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_adult, $item->mark_up_promotion_adult, $item->mark_up_promotion_price_adult, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_adult, $item->mark_up_promotion_net_adult, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_teen = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_teen, $item->mark_up_promotion_teen, $item->mark_up_promotion_price_teen, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_teen, $item->mark_up_promotion_net_teen, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_children1 = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_children1, $item->mark_up_promotion_children1, $item->mark_up_promotion_price_children1, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_children1, $item->mark_up_promotion_net_children1, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_children2 = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_children2, $item->mark_up_promotion_children2, $item->mark_up_promotion_price_children2, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_children2, $item->mark_up_promotion_net_children2, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_infant = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_infant, $item->mark_up_promotion_infant, $item->mark_up_promotion_price_infant, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_infant, $item->mark_up_promotion_net_infant, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_private_room = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_private_room, $item->mark_up_promotion_private_room, $item->mark_up_promotion_price_private_room, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_private_room, $item->mark_up_promotion_net_private_room, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->sale_promotion_price_extra_bed = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_extra_bed, $item->mark_up_promotion_extra_bed, $item->mark_up_promotion_price_extra_bed, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_extra_bed, $item->mark_up_promotion_net_extra_bed, $item->mark_up_promotion_net_type, $item->promotion_tax); $item->full_charge_children1 = $item->tsmart_promotion_price_id ? $item->tour_promotion_price_full_charge_children1 : $item->tour_price_full_charge_children1; $item->full_charge_children2 = $item->tsmart_promotion_price_id ? $item->tour_promotion_price_full_charge_children2 : $item->tour_price_full_charge_children2; } return $items; }
function getItemList($search = '') { //echo $this->getListQuery()->dump(); $items = parent::getItems(); require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmprice.php'; require_once JPATH_ROOT . '/administrator/components/com_tsmart/helpers/tsmpromotion.php'; foreach ($items as &$item) { $item->sale_price_adult = vmprice::get_sale_price_by_mark_up_and_tax($item->price_adult, $item->mark_up_adult, $item->mark_up_price_adult, $item->tax, $item->mark_up_type); $item->sale_promotion_price_adult = vmpromotion::get_sale_promotion_price_by_mark_up_and_tax($item->promotion_price_adult, $item->mark_up_promotion_adult, $item->mark_up_promotion_price_adult, $item->mark_up_promotion_type, $item->mark_up_promotion_net_price_adult, $item->mark_up_promotion_net_adult, $item->mark_up_promotion_net_type, $item->promotion_tax); } return $items; }
public function getItems() { $items = parent::getItems(); // TODO: Change the autogenerated stub foreach ($items as &$item) { $type = $item->mark_up_type; $tax = $item->tax / 100; if ($type == 'amount') { $price_senior = $item->price_senior + $item->mark_up_price_senior; $item->price_senior = round($price_senior + $price_senior . $tax); $price_adult = $item->price_adult + $item->mark_up_price_adult; $item->price_adult = round($price_adult + $price_adult . $tax); $price_teen = $item->price_teen + $item->mark_up_price_teen; $item->price_teen = round($price_teen + $price_teen . $tax); $price_infant = $item->price_infant + $item->mark_up_price_infant; $item->price_infant = round($price_infant + $price_infant . $tax); $price_children1 = $item->price_children1 + $item->mark_up_price_children1; $item->price_children1 = round($price_children1 + $price_children1 . $tax); $price_children2 = $item->price_children2 + $item->mark_up_price_children2; $item->price_children2 = round($price_children2 + $price_children2 . $tax); $price_private_room = $item->price_private_room + $item->mark_up_price_private_room; $item->price_private_room = round($price_private_room + $price_private_room . $tax); $extra_bed = $item->extra_bed + $item->mark_up_extra_bed; $item->extra_bed = round($extra_bed + $extra_bed . $tax); } else { $price_senior = $item->price_senior + $item->price_senior . $item->mark_up_senior / 100; $item->price_senior = round($price_senior + $price_senior . $tax); $price_adult = $item->price_adult + $item->price_adult * $item->mark_up_adult / 100; $item->price_adult = round($price_adult + $price_adult . $tax); $price_teen = $item->price_teen + $item->price_teen * $item->mark_up_teen / 100; $item->price_teen = round($price_teen + $price_teen . $tax); $price_infant = $item->price_infant + $item->price_infant * $item->mark_up_infant / 100; $item->price_infant = round($price_infant + $price_infant . $tax); $price_children1 = $item->price_children1 + $item->price_children1 * $item->mark_up_children1 / 100; $item->price_children1 = round($price_children1 + $price_children1 . $tax); $price_children2 = $item->price_children2 + $item->price_children2 * $item->mark_up_children2 / 100; $item->price_children2 = round($price_children2 + $price_children2 . $tax); $price_private_room = $item->price_private_room + $item->price_private_room * $item->mark_up_private_room / 100; $item->price_private_room = round($price_private_room + $price_private_room . $tax); $extra_bed = $item->extra_bed + $item->extra_bed * $item->mark_up_extra_bed / 100; $item->extra_bed = round($extra_bed + $extra_bed . $tax); } } return $items; }
/** * Retireve a list of currencies from the database. * This function is used in the backend for the currency listing, therefore no asking if enabled or not * @author Max Milbers * @return object List of currency objects */ function getItemList($search = '') { $data = parent::getItems(); return $data; }
/** * Retireve a list of currencies from the database. * This function is used in the backend for the currency listing, therefore no asking if enabled or not * @author Max Milbers * @return object List of currency objects */ function getItemList($search = '') { //echo $this->getListQuery()->dump(); $data = parent::getItems(); return $data; }