public function initialize() { global $lC_Cache, $lC_Database, $lC_Services, $lC_Currencies, $lC_Specials, $lC_Language, $lC_Image; $this->_title_link = lc_href_link(FILENAME_PRODUCTS, 'new'); $data = array(); if ($lC_Cache->isEnabled() && BOX_WHATS_NEW_CACHE > 0 && $lC_Cache->read('box-whats_new-' . $lC_Language->getCode() . '-' . $lC_Currencies->getCode(), BOX_WHATS_NEW_CACHE)) { $data = $lC_Cache->getCache(); } else { $Qnew = $lC_Database->query('select products_id from :table_products where products_status = :products_status order by products_date_added desc limit :max_random_select_new'); $Qnew->bindTable(':table_products', TABLE_PRODUCTS); $Qnew->bindInt(':products_status', 1); $Qnew->bindInt(':max_random_select_new', BOX_WHATS_NEW_RANDOM_SELECT); $Qnew->executeRandomMulti(); if ($Qnew->numberOfRows()) { // VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW $lC_Product = new lC_Product($Qnew->valueInt('products_id')); $data = $lC_Product->getData(); $data['display_price'] = $lC_Product->getPriceFormated(true); $data['display_image'] = $lC_Product->getImage(); } if ($lC_Cache->isEnabled()) { $lC_Cache->write($data); } } if (!empty($data)) { $this->_content = ''; if (empty($data['display_image']) === false) { $this->_content = '<li class="box-whats-new-image"><div class="thumbnail">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $data['keyword']), $lC_Image->show($data['display_image'], $data['name'], 'class="box-whats-new-image-src"')) . '</div></li>'; } $this->_content .= '<li class="box-whats-new-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $data['keyword']), $data['name']) . '</li>'; $this->_content .= '<li class="box-whats-new-price pricing-row">' . $data['display_price'] . '</li>'; $this->_content .= '<li class="box-whats-new-buy-now pricing-row buy-btn-div"><button onclick="window.location.href=\'' . lc_href_link(FILENAME_PRODUCTS, $data['keyword'] . '&action=cart_add') . '\'" title="" type="button">' . $lC_Language->get('button_buy_now') . '</button>'; } }
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_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_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_Database, $lC_Cache, $lC_Language, $lC_Currencies, $lC_Image, $current_category_id; $data = array(); if ($lC_Cache->isEnabled() && MODULE_CONTENT_NEW_PRODUCTS_CACHE > 0 && $lC_Cache->read('new_products-' . $lC_Language->getCode() . '-' . $lC_Currencies->getCode() . '-' . $current_category_id, MODULE_CONTENT_NEW_PRODUCTS_CACHE)) { $data = $lC_Cache->getCache(); } else { if ($current_category_id < 1) { $Qproducts = $lC_Database->query('select products_id from :table_products where products_status = :products_status and parent_id = :parent_id order by products_date_added desc limit :max_display_new_products'); } else { $Qproducts = $lC_Database->query('select distinct p2c.products_id from :table_products p, :table_products_to_categories p2c, :table_categories c where c.parent_id = :category_parent_id and c.categories_id = p2c.categories_id and p2c.products_id = p.products_id and p.products_status = :products_status and p.parent_id = :parent_id order by p.products_date_added desc limit :max_display_new_products'); $Qproducts->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES); $Qproducts->bindTable(':table_categories', TABLE_CATEGORIES); $Qproducts->bindInt(':category_parent_id', $current_category_id); } $Qproducts->bindTable(':table_products', TABLE_PRODUCTS); $Qproducts->bindInt(':products_status', 1); $Qproducts->bindInt(':parent_id', 0); $Qproducts->bindInt(':max_display_new_products', MAX_DISPLAY_PRODUCTS_NEW); $Qproducts->execute(); while ($Qproducts->next()) { // VQMOD-hookpoint; DO NOT MODIFY OR REMOVE THE LINE BELOW $lC_Product = new lC_Product($Qproducts->valueInt('products_id')); $data[$lC_Product->getID()] = $lC_Product->getData(); $data[$lC_Product->getID()]['display_price'] = $lC_Product->getPriceFormated(true); $data[$lC_Product->getID()]['display_image'] = $lC_Product->getImage(); } if ($lC_Cache->isEnabled()) { $lC_Cache->write($data); } } if (!empty($data)) { $this->_content = ''; foreach ($data as $product) { $this->_content .= '<div class="content-new-products-container">' . "\n"; $this->_content .= ' <div class="content-new-products-image">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $product['keyword']), $lC_Image->show($product['display_image'], $product['name'], 'class="content-new-products-image-src"')) . '</div>' . "\n" . ' <div class="content-new-products-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $product['keyword']), $product['name']) . '</div>' . "\n" . ' <div class="content-new-products-desc">' . (strlen(lc_clean_html($product['description'])) > 65 ? substr(lc_clean_html($product['description']), 0, 62) . '...' : lc_clean_html($product['description'])) . '</div>' . "\n" . ' <div class="content-new-products-price pricing-row">' . $product['display_price'] . '</div>' . "\n" . ' <div class="content-new-products-button pricing-row buy-btn-div"><button class="content-new-products-add-button" onclick="window.location.href=\'' . lc_href_link(FILENAME_PRODUCTS, $product['keyword'] . '&action=cart_add') . '\'" type="button">' . $lC_Language->get('new_products_button_buy_now') . '</button></div>' . "\n"; $this->_content .= '</div>' . "\n"; } } }
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>'; } }
case 'PRODUCT_LIST_NAME': if (isset($_GET['manufacturers'])) { $output .= '<div class="product-listing-module-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . '&manufacturers=' . $_GET['manufacturers']), $lC_Product->getTitle()) . '</div>' . "\n" . '<div class="product-listing-module-description">' . lc_clean_html($lC_Product->getBlurb()) . '</div>' . "\n"; } else { $output .= '<div class="product-listing-module-name">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . ($cPath ? '&cPath=' . $cPath : '')), $lC_Product->getTitle()) . '</div>' . "\n" . '<div class="product-listing-module-description">' . lc_clean_html($lC_Product->getBlurb()) . '</div>' . "\n"; } break; case 'PRODUCT_LIST_MANUFACTURER': if ($lC_Product->hasManufacturer()) { $output .= '<div class="product-listing-module-manufacturer">' . lc_link_object(lc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $lC_Product->getManufacturerID()), $lC_Product->getManufacturer()) . '</div>' . "\n"; } else { $output .= '<div class="product-listing-module-manufacturer"></div>' . "\n"; } break; case 'PRODUCT_LIST_PRICE': $output .= '<div class="product-listing-module-price pricing-row">' . ($show_price ? $lC_Product->getPriceFormated(true) : null) . '</div>' . "\n"; break; case 'PRODUCT_LIST_QUANTITY': $output .= '<div class="product-listing-module-quantity">' . $lC_Product->getQuantity() . '</div>' . "\n"; break; case 'PRODUCT_LIST_WEIGHT': $output .= '<div class="product-listing-module-weight">' . $lC_Product->getWeight() . '</div>' . "\n"; break; case 'PRODUCT_LIST_IMAGE': if (isset($_GET['manufacturers'])) { $output .= '<div class="product-listing-module-image">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . '&manufacturers=' . $_GET['manufacturers']), $lC_Image->show($lC_Product->getImage(), $lC_Product->getTitle(), 'class="product-listing-module-image-src"')) . '</div>' . "\n"; } else { $output .= '<div class="product-listing-module-image">' . lc_link_object(lc_href_link(FILENAME_PRODUCTS, $lC_Product->getKeyword() . ($cPath ? '&cPath=' . $cPath : '')), $lC_Image->show($lC_Product->getImage(), $lC_Product->getTitle(), 'class="product-listing-module-image-src"')) . '</div>' . "\n"; } break; case 'PRODUCT_LIST_BUY_NOW':
public function getProducts() { $history = array(); if (isset($this->visits['products']) && empty($this->visits['products']) === false) { $counter = 0; foreach ($this->visits['products'] as $k => $v) { $counter++; $lC_Product = new lC_Product($v['id']); $lC_Category = new lC_Category($lC_Product->getCategoryID()); $history[] = array('name' => $lC_Product->getTitle(), 'id' => $lC_Product->getID(), 'keyword' => $lC_Product->getKeyword(), 'price' => SERVICE_RECENTLY_VISITED_SHOW_PRODUCT_PRICES == '1' ? $lC_Product->getPriceFormated(true) : '', 'image' => $lC_Product->getImage(), 'category_name' => $lC_Category->getTitle(), 'category_path' => $lC_Category->getPath()); if ($counter == SERVICE_RECENTLY_VISITED_MAX_PRODUCTS) { break; } } } return $history; }