public function initialize()
{
global $lC_Database, $lC_Language, $lC_Currencies, $lC_Image;
if (MODULE_CONTENT_FEATURED_PRODUCTS_MAX_DISPLAY > 0) {
$limit = ' limit ' . MODULE_CONTENT_FEATURED_PRODUCTS_MAX_DISPLAY;
}
$Qfeatured = $lC_Database->query('select products_id
from :table_featured_products
where (str_to_date(expires_date, "%Y-%m-%d") >= str_to_date(now(), "%Y-%m-%d") or expires_date = "0000-00-00 00:00:00")
and status = 1
order by rand() asc' . $limit);
$Qfeatured->bindTable(':table_featured_products', TABLE_FEATURED_PRODUCTS);
$Qfeatured->bindInt(':max_display_featured_products', MODULE_CONTENT_FEATURED_PRODUCTS_MAX_DISPLAY);
$Qfeatured->execute();
if (MODULE_CONTENT_FEATURED_PRODUCTS_CACHE > 0) {
$Qfeatured->setCache('featured_products-' . $lC_Language->getCode() . '-' . $lC_Currencies->getCode(), MODULE_CONTENT_FEATURED_PRODUCTS_CACHE);
}
if ($Qfeatured->numberOfRows() > 0) {
$this->_content = '';
while ($Qfeatured->next()) {
// VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW
$lC_Product = new lC_Product($Qfeatured->valueInt('products_id'));
$this->_content .= '<div class="content-featured-products-container">' . "\n" . ' <div class="content-featured-products-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Product->getTitle()) . '</div>' . "\n";
if ($lC_Product->hasImage()) {
$this->_content .= ' <div class="content-featured-products-image">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Image->show($lC_Product->getImage(), $lC_Product->getTitle(), 'class="content-featured-products-image-src"')) . '</div>' . "\n";
}
$this->_content .= ' <div class="content-featured-products-desc">' . substr(lc_clean_html($lC_Product->getDescription()), 0, 62) . '...</div>' . "\n" . ' <div class="content-featured-products-price pricing-row">' . $lC_Product->getPriceFormated(true) . '</div>' . "\n" . ' <div class="content-featured-products-button pricing-row buy-btn-div"><button class="content-featured-products-add-button" onclick="window.location.href=\'' . lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . '&action=cart_add') . '\'" type="button">' . $lC_Language->get('new_products_button_buy_now') . '</button></div>' . "\n" . '</div>' . "\n";
}
}
$Qfeatured->freeResult();
}
public function initialize()
{
global $lC_Database, $lC_Language, $lC_Currencies, $lC_Image;
$Qupcoming = $lC_Database->query('select p.products_id, pa.value as date_expected from :table_products p, :table_templates_boxes tb, :table_product_attributes pa where tb.code = :code and tb.id = pa.id and to_days(str_to_date(pa.value, "%m/%d/%Y")) >= to_days(now()) and pa.products_id = p.products_id and p.products_status = :products_status order by pa.value limit :max_display_upcoming_products');
$Qupcoming->bindTable(':table_products', TABLE_PRODUCTS);
$Qupcoming->bindTable(':table_templates_boxes', TABLE_TEMPLATES_BOXES);
$Qupcoming->bindTable(':table_product_attributes', TABLE_PRODUCT_ATTRIBUTES);
$Qupcoming->bindValue(':code', 'date_available');
$Qupcoming->bindInt(':products_status', 1);
$Qupcoming->bindInt(':max_display_upcoming_products', MODULE_CONTENT_UPCOMING_PRODUCTS_MAX_DISPLAY);
if (MODULE_CONTENT_UPCOMING_PRODUCTS_CACHE > 0) {
$Qupcoming->setCache('upcoming_products-' . $lC_Language->getCode() . '-' . $lC_Currencies->getCode(), MODULE_CONTENT_UPCOMING_PRODUCTS_CACHE);
}
$Qupcoming->execute();
if ($Qupcoming->numberOfRows() > 0) {
$this->_content = '';
while ($Qupcoming->next()) {
// VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW
$lC_Product = new lC_Product($Qupcoming->valueInt('products_id'));
$this->_content .= '<div class="content-upcoming-products-container">' . "\n" . '<div class="content-upcoming-products-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Product->getTitle()) . '</div>' . "\n";
if ($lC_Product->hasImage()) {
$this->_content .= '<div class="content-upcoming-products-image">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Image->show($lC_Product->getImage(), $lC_Product->getTitle(), 'class="content-upcoming-products-image-src"', 'small')) . '</div>' . "\n";
}
$this->_content .= '<div class="content-upcoming-products-price pricing-row">' . $lC_Product->getPriceFormated(true) . '</div>' . "\n" . '<div class="content-upcoming-products-date">' . $Qupcoming->value('date_expected') . '</div>' . "\n" . '</div>' . "\n";
}
}
$Qupcoming->freeResult();
}
public function initialize()
{
global $lC_Services, $lC_RecentlyVisited, $lC_Language, $lC_Image, $lC_Product;
if ($lC_Services->isStarted('recently_visited') && $lC_RecentlyVisited->hasHistory()) {
$this->_content = '';
if ($lC_RecentlyVisited->hasProducts()) {
foreach ($lC_RecentlyVisited->getProducts() as $product) {
// VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW
$lC_Product = new lC_Product($product['id']);
$this->_content .= '<div class="content-recently-visited-container">' . "\n" . ' <div class="content-recently-visited-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Product->getTitle()) . '</div>' . "\n";
if ($lC_Product->hasImage()) {
$this->_content .= '<div class="content-recently-visited-image">' . (SERVICE_RECENTLY_VISITED_SHOW_PRODUCT_IMAGES == '1' ? lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Image->show($lC_Product->getImage(), $lC_Product->getTitle(), 'class="content-recently-visited-image-src"', 'small')) : NULL) . '</div>' . "\n";
}
$this->_content .= ' <div class="content-recently-visited-price pricing-row">' . $lC_Product->getPriceFormated(true) . '</div>' . "\n" . ' <div class="content-recently-visited-from">' . sprintf($lC_Language->get('recently_visited_item_in_category'), lc_link_object(lc_href_link(FILENAME_DEFAULT, 'cPath=' . $product['category_path']), $product['category_name'])) . '</div>' . "\n" . '</div>' . "\n";
}
}
if ($lC_RecentlyVisited->hasCategories()) {
foreach ($lC_RecentlyVisited->getCategories() as $category) {
// VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW
if (!empty($category['parent_id'])) {
$this->_content .= '<div class="content-recently-visited-container">' . "\n" . ' <div class="content-recently-visited-name">' . sprintf($lC_Language->get('recently_visited_item_in_category'), lc_link_object(lc_href_link(FILENAME_DEFAULT, 'cPath=' . $product['category_path']), $product['category_name'])) . '</div>' . "\n";
if (isset($category['image']) && empty($category['image']) === false) {
$this->_content .= '<div class="content-recently-visited-image">' . (SERVICE_RECENTLY_VISITED_SHOW_CATEGORY_IMAGES == '1' ? lc_link_object(lc_href_link(FILENAME_DEFAULT, 'cPath=' . $category['id']), lc_image('images/categories/' . $category['image'], $category['name'], null, null, 'class="content-recently-visited-image-src"')) : NULL) . '</div>' . "\n";
}
$this->_content .= ' <div class="content-recently-visited-price pricing-row"></div>' . "\n" . ' <div class="content-recently-visited-from">' . sprintf($lC_Language->get('recently_visited_item_in_category'), lc_link_object(lc_href_link(FILENAME_DEFAULT, 'cPath=' . $category['parent_id']), $category['parent_name'])) . '</div>' . "\n" . '</div>' . "\n";
}
}
}
if ($lC_RecentlyVisited->hasSearches()) {
foreach ($lC_RecentlyVisited->getSearches() as $searchphrase) {
// $this->_content .= '<div class="content-recently-visited-searches">' . lc_link_object(lc_href_link(FILENAME_SEARCH, 'keywords=' . $searchphrase['keywords']), lc_output_string_protected($searchphrase['keywords'])) . ' <i>(' . number_format($searchphrase['results']) . ' results)</i></div>';
}
}
}
}
public function initialize()
{
global $lC_Database, $lC_Currencies, $lC_Language, $lC_Image;
$this->_title_link = lc_href_link(FILENAME_PRODUCTS, 'featured_products');
$Qfeatured = $lC_Database->query('select products_id
from :table_featured_products
where str_to_date(expires_date, "%Y-%m-%d") >= str_to_date(now(), "%Y-%m-%d")
and status = 1
order by rand()
limit 1');
$Qfeatured->bindTable(':table_featured_products', TABLE_FEATURED_PRODUCTS);
$Qfeatured->execute();
if ($Qfeatured->numberOfRows() > 0) {
// VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW
$lC_Product = new lC_Product($Qfeatured->valueInt('products_id'));
$this->_content = '';
if ($lC_Product->hasImage()) {
$this->_content = '<li class="box-featured-products-image">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Image->show($lC_Product->getImage(), $lC_Product->getTitle(), 'class="content-featured-products-image-src"')) . '</li>';
}
$this->_content .= '<li class="box-featured-products-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword()), $lC_Product->getTitle()) . '</li>';
$this->_content .= '<li class="box-featured-products-price pricing-row">' . $lC_Product->getPriceFormated(true) . '</li>';
$this->_content .= '<li class="box-featured-products-buy-now pricing-row buy-btn-div"><button onclick="window.location.href=\'' . lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . '&action=cart_add') . '\'" type="button">' . $lC_Language->get('button_buy_now') . '</button>';
}
}
