/**
* 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;
}
