'.Tools::displayPrice($productPrice), 'class' => 'text-center' ), array( 'id' => 'category', 'value' => ''. Tools::htmlentitiesUTF8($roomTypeInfo['hotel_name']).'', 'class' => 'text-center' ), array( 'id' => 'total_sold', 'value' => $product['total'], 'class' => 'text-center' ), array( 'id' => 'sales', 'value' => Tools::displayPrice($product['sales']), 'class' => 'text-center' ), ); } return array('header' => $header, 'body' => $body); } public function getTableMostViewed($date_from, $date_to, $id_hotel) { $header = array( array( 'id' => 'image', 'title' => $this->l('Image'), 'class' => 'text-center', ), array( 'id' => 'product', 'title' => $this->l('Room type'), 'class' => 'text-center', ), array( 'id' => 'hotel', 'title' => $this->l('Hotel'), 'class' => 'text-center', ), array( 'id' => 'views', 'title' => $this->l('Views'), 'class' => 'text-center', ), array( 'id' => 'added_to_cart', 'title' => $this->l('Added to cart'), 'class' => 'text-center', ), array( 'id' => 'purchased', 'title' => $this->l('Booked'), 'class' => 'text-center', ), array( 'id' => 'rate', 'title' => $this->l('Conversion rate'), 'class' => 'text-center', ) ); if (Configuration::get('PS_STATSDATA_PAGESVIEWS')) { $products = $this->getTotalViewed($date_from, $date_to, (int)Configuration::get('DASHPRODUCT_NBR_SHOW_MOST_VIEWED')); $body = array(); if (is_array($products) && count($products)) { foreach ($products as $product) { $product_obj = new Product((int)$product['id_object'], true, $this->context->language->id); if (!Validate::isLoadedObject($product_obj)) { continue; } $img = ''; if (($row_image = Product::getCover($product_obj->id)) && $row_image['id_image']) { $image = new Image($row_image['id_image']); $path_to_image = _PS_PROD_IMG_DIR_.$image->getExistingImgPath().'.'.$this->context->controller->imageType; $img = ImageManager::thumbnail($path_to_image, 'product_mini_'.$product_obj->id.'.'.$this->context->controller->imageType, 45, $this->context->controller->imageType); } $objHotelRoomType = new HotelRoomType($product_obj->id); $objHotelBranch = new HotelBranchInformation($objHotelRoomType->id_hotel, $this->context->language->id); $tr = array(); $tr[] = array( 'id' => 'product', 'value' => $img, 'class' => 'text-center' ); $tr[] = array( 'id' => 'product', 'value' => ''. Tools::htmlentitiesUTF8($product_obj->name).''.'
'. Tools::displayPrice(Product::getPriceStatic((int)$product_obj->id)), 'class' => 'text-center', ); $tr[] = array( 'id' => 'hotel', 'value' => ''. Tools::htmlentitiesUTF8($objHotelBranch->hotel_name).'', 'class' => 'text-center', ); $tr[] = array( 'id' => 'views', 'value' => $product['counter'], 'class' => 'text-center', ); $added_cart = $this->getTotalProductAddedCart($date_from, $date_to, (int)$product_obj->id); $tr[] = array( 'id' => 'added_to_cart', 'value' => $added_cart, 'class' => 'text-center', ); $purchased = $this->getTotalProductPurchased($date_from, $date_to, (int)$product_obj->id); $tr[] = array( 'id' => 'purchased', 'value' => $purchased, 'class' => 'text-center', ); $tr[] = array( 'id' => 'rate', 'value' => ($product['counter'] ? round(100 * $purchased / $product['counter'], 1).'%' : '-'), 'class' => 'text-center', ); $body[] = $tr; } } } else { $link = $this->context->link->getAdminLink('AdminModules').'&configure=statsdata'; $body = '
'.$this->l('You must enable the "Save global page views" option from ').'Data mining for statistics'.$this->l(' module in order to display the most viewed room types, or use the QloApps Google Analytics module.').'
';
}
return array('header' => $header, 'body' => $body);
}
public function getTableTop10MostSearch($date_from, $date_to)
{
$header = array(
array(
'id' => 'reference',
'title' => $this->l('Hotel'),
'class' => 'text-center'
),
array(
'id' => 'image',
'title' => $this->l('Cover image'),
'class' => 'text-center'
),
array(
'id' => 'location',
'title' => $this->l('Location'),
'class' => 'text-center'
),
array(
'id' => 'count',
'title' => $this->l('Count'),
'class' => 'text-center'
),
// array(
// 'id' => 'totalQuantitySold',
// 'title' => $this->l('Results'),
// 'class' => 'text-center'
// )
);
if (Configuration::get('PS_STATSDATA_PAGESVIEWS')) {
$hotels = $this->getMostSearchedHotels(
$date_from,
$date_to,
(int)Configuration::get('DASHPRODUCT_NBR_SHOW_TOP_SEARCH')
);
$body = array();
if (is_array($hotels) && count($hotels))
foreach ($hotels as $hotel) {
$objHotelBranch = new HotelBranchInformation($hotel['id_hotel'], $this->context->language->id);
$addressInfo = $objHotelBranch->getAddress($hotel['id_hotel']);
$tr = array();
$tr[] = array(
'id' => 'reference',
'value' => ''.
Tools::htmlentitiesUTF8($hotel['hotel_name']).'',
'class' => 'text-center',
);
$tr[] = array(
'id' => 'image',
'value' => $this->getHotelImage($objHotelBranch->id),
'class' => 'text-center',
);
$tr[] = array(
'id' => 'location',
'value' => $addressInfo['address1'],
'class' => 'text-center',
);
$tr[] = array(
'id' => 'views',
'value' => $hotel['views'],
'class' => 'text-center',
);
$body[] = $tr;
}
} else {
$link = $this->context->link->getAdminLink('AdminModules').'&configure=statsdata';
$body = ''.$this->l('You must enable the "Save global page views" option from ').'Data mining for statistics'.$this->l(' module in order to display the most viewed room types, or use the QloApps Google Analytics module.').'
';
}
return array('header' => $header, 'body' => $body);
}
public function getHotelImage($idHotel)
{
$noPictureImagePath = _PS_IMG_.'p/en.jpg';
$hotelImage = HotelImage::getCover($idHotel);
if (is_array($hotelImage) && count($hotelImage)) {
$objHotelImage = new HotelImage();
$imgLink = $this->context->link->getMediaLink($objHotelImage->getImageLink($hotelImage['id'], ImageType::getFormatedName('small')));
} else {
$imgLink = $this->context->link->getMediaLink($noPictureImagePath);
}
return '