function initialize()
{
global $osC_Database, $osC_Language;
$Qmanufacturers = $osC_Database->query('select m.manufacturers_id as id, m.manufacturers_name as text, m.manufacturers_image as image from :table_manufacturers m, :table_manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id order by manufacturers_name');
$Qmanufacturers->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
$Qmanufacturers->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qmanufacturers->bindInt(':languages_id', $osC_Language->getID());
$Qmanufacturers->setCache('box-manufacturers-' . $osC_Language->getCode(), 100);
$Qmanufacturers->execute();
if (BOX_MANUFACTURERS_LIST_TYPE == 'ComboBox') {
$manufacturers_array = array(array('id' => '', 'text' => $osC_Language->get('pull_down_default')));
while ($Qmanufacturers->next()) {
$manufacturers_array[] = $Qmanufacturers->toArray();
}
$this->_content = '<form name="manufacturers" action="' . osc_href_link(FILENAME_DEFAULT, null, 'NONSSL', false) . '" method="get">' . osc_draw_pull_down_menu('manufacturers', $manufacturers_array, null, 'onchange="this.form.submit();" size="' . BOX_MANUFACTURERS_LIST_SIZE . '" style="width: 99%"') . osc_draw_hidden_session_id_field() . '</form>';
} else {
$this->_content = '<ul>';
while ($Qmanufacturers->next()) {
$manufacturers_image = $Qmanufacturers->value('image');
if (!empty($manufacturers_image) && file_exists(DIR_WS_IMAGES . 'manufacturers/' . $Qmanufacturers->value('image'))) {
$this->_content .= '<li>' . osc_link_object(osc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $Qmanufacturers->valueInt('id')), osc_image("images/manufacturers/" . $Qmanufacturers->value('image'), $Qmanufacturers->value('text'))) . '</li>';
}
}
$this->_content .= '</ul>';
}
$Qmanufacturers->freeResult();
}
public function initialize()
{
$OSCOM_Database = Registry::get('Database');
$Qmanufacturers = $OSCOM_Database->query('select manufacturers_id as id, manufacturers_name as text from :table_manufacturers order by manufacturers_name');
$Qmanufacturers->setCache('manufacturers');
$Qmanufacturers->execute();
$manufacturers_array = array(array('id' => '', 'text' => OSCOM::getDef('pull_down_default')));
while ($Qmanufacturers->next()) {
$manufacturers_array[] = $Qmanufacturers->toArray();
}
$Qmanufacturers->freeResult();
$this->_content = '<form name="manufacturers" action="' . OSCOM::getLink() . '" method="get">' . osc_draw_hidden_field('Index', null) . osc_draw_pull_down_menu('Manufacturers', $manufacturers_array, null, 'onchange="this.form.submit();" size="' . BOX_MANUFACTURERS_LIST_SIZE . '" style="width: 100%"') . osc_draw_hidden_session_id_field() . '</form>';
}
function initialize()
{
global $osC_Database, $osC_Language;
$Qmanufacturers = $osC_Database->query('select manufacturers_id as id, manufacturers_name as text from :table_manufacturers order by manufacturers_name');
$Qmanufacturers->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
$Qmanufacturers->setCache('manufacturers');
$Qmanufacturers->execute();
$manufacturers_array = array(array('id' => '', 'text' => $osC_Language->get('pull_down_default')));
while ($Qmanufacturers->next()) {
$manufacturers_array[] = $Qmanufacturers->toArray();
}
$Qmanufacturers->freeResult();
$this->_content = '<form name="manufacturers" action="' . osc_href_link(FILENAME_DEFAULT, null, 'NONSSL', false) . '" method="get">' . osc_draw_pull_down_menu('manufacturers', $manufacturers_array, null, 'onchange="this.form.submit();" size="' . BOX_MANUFACTURERS_LIST_SIZE . '" style="width: 100%"') . osc_draw_hidden_session_id_field() . '</form>';
}
function initialize()
{
global $osC_Session;
$data = array();
foreach (osC_Template::getTemplates() as $template) {
$data[] = array('id' => $template['code'], 'text' => $template['title']);
}
if (sizeof($data) > 1) {
$hidden_get_variables = '';
foreach ($_GET as $key => $value) {
if ($key != 'template' && $key != $osC_Session->getName() && $key != 'x' && $key != 'y') {
$hidden_get_variables .= osc_draw_hidden_field($key, $value);
}
}
$this->_content = '<form name="templates" action="' . osc_href_link(basename($_SERVER['SCRIPT_FILENAME']), null, 'AUTO', false) . '" method="get">' . $hidden_get_variables . osc_draw_pull_down_menu('template', $data, $_SESSION['template']['code'], 'onchange="this.form.submit();" style="width: 100%"') . osc_draw_hidden_session_id_field() . '</form>';
}
}
public function initialize()
{
$OSCOM_Currencies = Registry::get('Currencies');
$data = array();
foreach ($OSCOM_Currencies->getData() as $key => $value) {
$data[] = array('id' => $key, 'text' => $value['title']);
}
if (sizeof($data) > 1) {
$hidden_get_variables = '';
foreach ($_GET as $key => $value) {
if ($key != 'currency' && $key != Registry::get('Session')->getName() && $key != 'x' && $key != 'y') {
$hidden_get_variables .= osc_draw_hidden_field($key, $value);
}
}
$this->_content = '<form name="currencies" action="' . OSCOM::getLink(null, null, null, 'AUTO', false) . '" method="get">' . $hidden_get_variables . osc_draw_pull_down_menu('currency', $data, $_SESSION['currency'], 'onchange="this.form.submit();" style="width: 100%"') . osc_draw_hidden_session_id_field() . '</form>';
}
}
function initialize()
{
global $osC_Session, $osC_Currencies;
$data = array();
foreach ($osC_Currencies->currencies as $key => $value) {
$data[] = array('id' => $key, 'text' => $value['title']);
}
if (sizeof($data) > 1) {
$hidden_get_variables = '';
foreach ($_GET as $key => $value) {
if ($key != 'currency' && $key != $osC_Session->getName() && $key != 'x' && $key != 'y') {
if (is_array($value)) {
foreach ($value as $hidden_value) {
$hidden_get_variables .= osc_draw_hidden_field($key, $hidden_value);
}
} else {
$hidden_get_variables .= osc_draw_hidden_field($key, $value);
}
}
}
$this->_content = '<form name="currencies" action="' . osc_href_link(basename($_SERVER['SCRIPT_FILENAME']), null, 'AUTO', false) . '" method="get">' . $hidden_get_variables . osc_draw_pull_down_menu('currency', $data, $_SESSION['currency'], 'onchange="this.form.submit();" style="width: 99%"') . osc_draw_hidden_session_id_field() . '</form>';
}
}
function getBatchPagesPullDownMenu($batch_keyword = 'page', $parameters = '')
{
global $osC_Language;
$number_of_pages = ceil($this->batch_size / $this->batch_rows);
if ($number_of_pages > 1) {
$pages_array = array();
for ($i = 1; $i <= $number_of_pages; $i++) {
$pages_array[] = array('id' => $i, 'text' => $i);
}
$hidden_parameter = '';
if (!empty($parameters)) {
$parameters = explode('&', $parameters);
foreach ($parameters as $parameter) {
$keys = explode('=', $parameter, 2);
if ($keys[0] != $batch_keyword) {
$hidden_parameter .= osc_draw_hidden_field($keys[0], isset($keys[1]) ? $keys[1] : '');
}
}
}
$string = '<form action="' . osc_href_link(basename($_SERVER['SCRIPT_FILENAME'])) . '" action="get">' . $hidden_parameter . sprintf($osC_Language->get('result_set_current_page'), osc_draw_pull_down_menu($batch_keyword, $pages_array, $this->batch_number, 'onchange="this.form.submit();"'), $number_of_pages) . osc_draw_hidden_session_id_field() . '</form>';
} else {
$string = sprintf($osC_Language->get('result_set_current_page'), 1, 1);
}
return $string;
}
/**
* Generate the filters params for the product listing page
*
* @access public
*
* @return mixed
*/
function get_filters_params()
{
global $cPath, $osC_Services, $osC_Template;
$params = '';
//pass the manufacturers or cPath param as seo is disabled
if (!$osC_Services->isStarted('sefu') || $osC_Template->getGroup() == 'search') {
if (isset($_GET['manufacturers']) && !empty($_GET['manufacturers'])) {
$params .= osc_draw_hidden_field('manufacturers', $_GET['manufacturers']);
} else {
if (isset($_GET['cPath']) && !empty($_GET['cPath'])) {
$params .= osc_draw_hidden_field('cPath', $cPath);
}
}
}
//pass the cpath or manufacturer filter for the search result page
if ($osC_Template->getGroup() == 'search') {
if (isset($_GET['filter']) && !empty($_GET['filter'])) {
$params .= osc_draw_hidden_field('filter', $_GET['filter']);
}
}
$params .= osc_draw_hidden_session_id_field();
//whether the products attributes filter and the category/manufacturer filter is linked
if (defined('PRODUCT_LINK_FILTER') && PRODUCT_LINK_FILTER == '1') {
if (isset($_GET['products_attributes']) && is_array($_GET['products_attributes'])) {
foreach ($_GET['products_attributes'] as $att_value_id => $att_value) {
$params .= osc_draw_hidden_field('products_attributes[' . $att_value_id . ']', $att_value);
}
}
}
//pass search params
$keys = array('keywords', 'pfrom', 'pto', 'datefrom_days', 'datefrom_months', 'datefrom_years', 'dateto_days', 'dateto_months', 'dateto_years');
foreach ($keys as $key) {
if (isset($_GET[$key])) {
$params .= osc_draw_hidden_field($key, $_GET[$key]);
}
}
return $params;
}
}
$options = array(array('id' => '', 'text' => $osC_Language->get('filter_all_categories')));
} else {
if (isset($_GET['cPath']) && !empty($_GET['cPath'])) {
//pass the cPath param as seo is disabled
if (!$osC_Services->isStarted('sefu')) {
echo osc_draw_hidden_field('cPath', $_GET['cPath']);
}
$options = array(array('id' => '', 'text' => $osC_Language->get('filter_all_manufacturers')));
}
}
//whether the products attributes filter and the category/manufacturer filter is linked
if (defined('PRODUCT_LINK_FILTER') && PRODUCT_LINK_FILTER == '1') {
if (isset($_GET['products_attributes']) && is_array($_GET['products_attributes'])) {
foreach ($_GET['products_attributes'] as $att_value_id => $att_value) {
echo osc_draw_hidden_field('products_attributes[' . $att_value_id . ']', $att_value);
}
}
}
if (isset($_GET['sort'])) {
echo osc_draw_hidden_field('sort', $_GET['sort']);
}
while ($Qfilterlist->next()) {
$options[] = array('id' => $Qfilterlist->valueInt('id'), 'text' => $Qfilterlist->value('name'));
}
echo osc_draw_pull_down_menu('filter', $options, isset($_GET['filter']) ? $_GET['filter'] : null, 'onchange="this.form.submit()"');
echo osc_draw_hidden_session_id_field() . '</form>' . "\n";
}
}
$Qlisting = $osC_Products->execute();
require 'includes/modules/product_listing.php';
function initialize()
{
global $osC_Database, $osC_Language, $osC_Template, $osC_Services;
$Qmanufacturers = $osC_Database->query('select m.manufacturers_id as id, m.manufacturers_name as text, m.manufacturers_image as image from :table_manufacturers m, :table_manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id order by manufacturers_name');
$Qmanufacturers->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
$Qmanufacturers->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qmanufacturers->bindInt(':languages_id', $osC_Language->getID());
$Qmanufacturers->setCache('box-manufacturers-' . $osC_Language->getCode(), 100);
$Qmanufacturers->execute();
if (BOX_MANUFACTURERS_LIST_TYPE == 'ComboBox') {
//verify whether the seo friendly url is enabled
if (isset($osC_Services) && $osC_Services->isStarted('sefu')) {
$this->_content .= '<select class="boxSelect">';
$this->_content .= '<option value="">' . $osC_Language->get('pull_down_default') . '</option>';
while ($Qmanufacturers->next()) {
//verify whether it is the current selected manufacturer
$selected = false;
if (isset($_GET['manufacturers'])) {
if ($_GET['manufacturers'] == $Qmanufacturers->valueInt('id')) {
$selected = true;
} elseif (strpos($_SERVER['REQUEST_URI'], '_') != false) {
$url = trim($_SERVER['REQUEST_URI'], '/');
$parts = explode('_', $url);
$manufactures_id = $parts[0];
if ($manufactures_id == $Qmanufacturers->valueInt('id')) {
$selected = true;
}
}
}
if ($selected == true) {
$this->_content .= '<option value="' . osc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $Qmanufacturers->valueInt('id')) . '" selected="selected">' . $Qmanufacturers->value('text') . '</option>';
} else {
$this->_content .= '<option value="' . osc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $Qmanufacturers->valueInt('id')) . '">' . $Qmanufacturers->value('text') . '</option>';
}
}
$this->_content .= '</select>';
//add the javascript block so that make the seo friendly url work normally
$osC_Template->addJavascriptBlock('<script type="text/javascript">
window.addEvent("domready", function() {
$$("select.boxSelect").each(function(boxSelect) {
boxSelect.addEvent("change", function() {
var link = boxSelect.get("value");
window.location = link;
return false;
});
});
});
</script>');
//add the css declaration
$osC_Template->addStyleDeclaration('select.boxSelect {width: 193px;}');
} else {
$manufacturers_array = array(array('id' => '', 'text' => $osC_Language->get('pull_down_default')));
while ($Qmanufacturers->next()) {
$manufacturers_array[] = $Qmanufacturers->toArray();
}
$this->_content = '<form name="manufacturers" action="' . osc_href_link(FILENAME_DEFAULT, null, 'NONSSL', false) . '" method="get">' . osc_draw_pull_down_menu('manufacturers', $manufacturers_array, null, 'onchange="this.form.submit();" size="' . BOX_MANUFACTURERS_LIST_SIZE . '" style="width: 99%"') . osc_draw_hidden_session_id_field() . '</form>';
}
} else {
$this->_content = '<ul>';
while ($Qmanufacturers->next()) {
$manufacturers_image = $Qmanufacturers->value('image');
if (!empty($manufacturers_image) && file_exists(DIR_WS_IMAGES . 'manufacturers/' . $Qmanufacturers->value('image'))) {
$this->_content .= '<li>' . osc_link_object(osc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $Qmanufacturers->valueInt('id')), osc_image("images/manufacturers/" . $Qmanufacturers->value('image'), $Qmanufacturers->value('text'))) . '</li>';
}
}
$this->_content .= '</ul>';
}
$Qmanufacturers->freeResult();
}
}
echo osc_draw_pull_down_menu('manufacturers', $manufacturers_array);
?>
</li>
<li><?php
echo osc_draw_label($osC_Language->get('field_search_price_from'), 'pfrom') . osc_draw_input_field('pfrom');
?>
</li>
<li><?php
echo osc_draw_label($osC_Language->get('field_search_price_to'), 'pto') . osc_draw_input_field('pto');
?>
</li>
<li><?php
echo osc_draw_label($osC_Language->get('field_search_date_from'), 'datefrom') . osc_draw_date_pull_down_menu('datefrom', null, false, null, null, date('Y') - $osC_Search->getMinYear(), 0);
?>
</li>
<li><?php
echo osc_draw_label($osC_Language->get('field_search_date_to'), 'dateto') . osc_draw_date_pull_down_menu('dateto', null, null, null, null, date('Y') - $osC_Search->getMaxYear(), 0);
?>
</li>
</ol>
</div>
</div>
<?php
echo osc_draw_hidden_session_id_field();
?>
</form>
<?php
echo '<li>' . osc_link_object(osc_href_link(FILENAME_DEFAULT, 'index'), $osC_Language->get('home')) . '</li>' . '<li>' . osc_link_object(osc_href_link(FILENAME_PRODUCTS, 'specials'), $osC_Language->get('specials')) . '</li>' . '<li>' . osc_link_object(osc_href_link(FILENAME_PRODUCTS, 'new'), $osC_Language->get('new_products')) . '</li>';
if ($osC_Customer->isLoggedOn()) {
echo '<li>' . osc_link_object(osc_href_link(FILENAME_ACCOUNT, 'logoff', 'SSL'), $osC_Language->get('sign_out')) . '</li>';
}
echo '<li>' . osc_link_object(osc_href_link(FILENAME_ACCOUNT, null, 'SSL'), $osC_Language->get('my_account')) . '</li>' . '<li>' . osc_link_object(osc_href_link(FILENAME_ACCOUNT, 'wishlist', 'SSL'), $osC_Language->get('my_wishlist')) . '</li>' . '<li>' . osc_link_object(osc_href_link(FILENAME_CHECKOUT, null, 'SSL'), $osC_Language->get('cart_contents')) . '</li>' . '<li>' . osc_link_object(osc_href_link(FILENAME_CHECKOUT, 'checkout', 'SSL'), $osC_Language->get('checkout')) . '</li>' . '<li class="last">' . osc_link_object(osc_href_link(FILENAME_INFO, 'contact'), $osC_Language->get('contact_us')) . '</li>';
?>
</ul>
<form name="search" action="<?php
echo osc_href_link(FILENAME_SEARCH, null, 'NONSSL', false);
?>
" method="get">
<?php
echo osc_draw_input_field('keywords', null, 'maxlength="20"') . ' ' . osc_draw_hidden_session_id_field() . osc_draw_image_submit_button('button_quick_find.gif', $osC_Language->get('box_search_heading'));
?>
</form>
</div>
</div>
</div>
<?php
if ($osC_Services->isStarted('breadcrumb')) {
?>
<div id="breadcrumbPath">
<?php
echo $breadcrumb->trail(' » ');
?>
</div>
if (PRODUCT_LIST_FILTER > 0) {
if (isset($_GET['Manufacturers']) && !empty($_GET['Manufacturers'])) {
$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from :table_products p, :table_products_to_categories p2c, :table_categories c, :table_categories_description cd, :table_templates_boxes tb, :table_product_attributes pa where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int) $OSCOM_Language->getID() . "' and tb.code = 'Manufacturers' and tb.id = pa.id and pa.products_id = p.products_id and pa.value = '" . (int) $_GET['Manufacturers'] . "' order by cd.categories_name";
} else {
$filterlist_sql = "select distinct m.manufacturers_id as id, m.manufacturers_name as name from :table_products p, :table_products_to_categories p2c, :table_manufacturers m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . $OSCOM_Category->getID() . "' order by m.manufacturers_name";
}
$Qfilterlist = $OSCOM_Database->query($filterlist_sql);
$Qfilterlist->execute();
if ($Qfilterlist->numberOfRows() > 1) {
echo '<p><form name="filter" action="' . OSCOM::getLink() . '" method="get">' . $OSCOM_Language->get('filter_show') . ' ';
if (isset($_GET['Manufacturers']) && !empty($_GET['Manufacturers'])) {
echo osc_draw_hidden_field('Manufacturers', $_GET['Manufacturers']);
$options = array(array('id' => '', 'text' => OSCOM::getDef('filter_all_categories')));
} else {
echo osc_draw_hidden_field('cPath', $OSCOM_Category->getPath());
$options = array(array('id' => '', 'text' => OSCOM::getDef('filter_all_manufacturers')));
}
if (isset($_GET['sort'])) {
echo osc_draw_hidden_field('sort', $_GET['sort']);
}
while ($Qfilterlist->next()) {
$options[] = array('id' => $Qfilterlist->valueInt('id'), 'text' => $Qfilterlist->value('name'));
}
echo osc_draw_pull_down_menu('filter', $options, isset($_GET['filter']) ? $_GET['filter'] : null, 'onchange="this.form.submit()"') . osc_draw_hidden_session_id_field() . '</form></p>' . "\n";
}
}
if (isset($_GET['Manufacturers']) && !empty($_GET['Manufacturers'])) {
$OSCOM_Products->setManufacturer($_GET['Manufacturers']);
}
$Qlisting = $OSCOM_Products->execute();
require 'includes/modules/product_listing.php';
Copyright (c) 2009 Wuxi Elootec Technology Co., Ltd
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License v2 (1991)
as published by the Free Software Foundation.
*/
if (isset($current_category_id) && !empty($current_category_id)) {
$Qgroups = $osC_Database->query('select distinct(p.products_attributes_groups_id) from :table_products p, :table_products_to_categories ptc where p.products_id = ptc.products_id and p.products_attributes_groups_id is not null and ptc.categories_id = :categories_id ');
$Qgroups->bindTable(':table_products', TABLE_PRODUCTS);
$Qgroups->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES);
$Qgroups->bindInt(':categories_id', $current_category_id);
$Qgroups->execute();
if ($Qgroups->numberOfRows() > 0) {
echo '<div class="moduleBox"><h6>' . $osC_Language->get('products_attributes_filter') . '</h6>' . "\n";
echo ' <div id="productAttributes" class="content">' . "\n";
echo ' <form name="filter" action="' . osc_href_link(FILENAME_DEFAULT) . '" method="get">' . osc_draw_hidden_field('cPath', isset($_GET['cPath']) ? $_GET['cPath'] : '') . osc_draw_hidden_session_id_field();
while ($Qgroups->next()) {
$Qentries = $osC_Database->query('select * from :table_products_attributes_values where products_attributes_groups_id = :products_attributes_groups_id and language_id = :language_id order by sort_order');
$Qentries->bindTable(':table_products_attributes_values', TABLE_PRODUCTS_ATTRIBUTES_VALUES);
$Qentries->bindInt(':products_attributes_groups_id', $Qgroups->valueInt('products_attributes_groups_id'));
$Qentries->bindInt(':language_id', $osC_Language->getID());
$Qentries->execute();
while ($Qentries->next()) {
$data = array();
$data[] = array('id' => '', 'text' => $osC_Language->get('pull_down_default'));
if ($Qentries->value('module') == 'text_field') {
$Qvalues = $osC_Database->query('select distinct value from :table_products_attributes where products_attributes_values_id = :products_attributes_values_id and language_id = :language_id ');
$Qvalues->bindTable(':table_products_attributes', TABLE_PRODUCTS_ATTRIBUTES);
$Qvalues->bindInt(':products_attributes_values_id', $Qentries->value('products_attributes_values_id'));
$Qvalues->bindInt(':language_id', $osC_Language->getID());
$Qvalues->execute();
function initialize()
{
$this->_title_link = OSCOM::getLink(null, 'Search');
$this->_content = '<form name="search" action="' . OSCOM::getLink() . '" method="get">' . osc_draw_hidden_field('Search', null) . osc_draw_input_field('Q', null, 'style="width: 80%;" maxlength="30"') . ' ' . osc_draw_hidden_session_id_field() . osc_draw_image_submit_button('button_quick_find.gif', OSCOM::getDef('box_search_heading')) . '<br />' . sprintf(OSCOM::getDef('box_search_text'), OSCOM::getLink(null, 'Search')) . '</form>';
}
function initialize()
{
global $osC_Language;
$this->_title_link = osc_href_link(FILENAME_SEARCH);
$this->_content = '<form name="search" action="' . osc_href_link(FILENAME_SEARCH, null, 'NONSSL', false) . '" method="get">' . osc_draw_input_field('keywords', null, 'style="width: 80%;" maxlength="30"') . ' ' . osc_draw_hidden_session_id_field() . osc_draw_image_submit_button('button_quick_find.gif', $osC_Language->get('box_search_heading')) . '<br />' . sprintf($osC_Language->get('box_search_text'), osc_href_link(FILENAME_SEARCH)) . '</form>';
}
