break; case 'PRODUCT_LIST_MANUFACTURER': $table_inner_array[] = array('case' => 'manufacturer', 'manufacturers_name' => $listing['manufacturers_name'], 'manufacturers_link' => xos_href_link(FILENAME_DEFAULT, 'm=' . $listing['manufacturers_id'])); break; case 'PRODUCT_LIST_PRICE': $popup_content_id = xos_get_delivery_times_values($listing['products_delivery_time_id'], 'popup_content_id'); $table_inner_array[] = array('case' => 'price', 'price_breaks' => $price_breaks, 'products_id' => $listing['products_id'], 'products_delivery_time' => xos_get_delivery_times_values($listing['products_delivery_time_id']), 'link_filename_popup_content_products_delivery_time' => $popup_content_id > 0 ? xos_href_link(FILENAME_POPUP_CONTENT, 'co=' . $popup_content_id . '&p=' . $listing['products_id'], $request_type) : '', 'tax_description' => xos_get_products_tax_description($listing['products_tax_class_id'], $products_tax_rate), 'price' => $product_price, 'price_special' => $product_price_special, 'price_breaks' => $price_breaks_array); break; case 'PRODUCT_LIST_QUANTITY': $table_inner_array[] = array('case' => 'quantity', 'products_quantity' => $listing['products_quantity'] > 0 ? $listing['products_quantity'] : '<span class="red-mark">' . $listing['products_quantity'] . '</span>'); break; case 'PRODUCT_LIST_WEIGHT': $table_inner_array[] = array('case' => 'weight', 'products_weight' => $listing['products_weight']); break; case 'PRODUCT_LIST_IMAGE': $products_image_name = xos_get_product_images($listing['products_image']); if (!empty($_GET['m'])) { $table_inner_array[] = array('case' => 'image', 'products_image_small' => xos_lazy_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block lazy" style="display: none;"') . '<noscript>' . xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block"') . '</noscript>', 'products_image_medium' => xos_lazy_image(DIR_WS_IMAGES . 'products/medium/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block lazy" style="display: none;"') . '<noscript>' . xos_image(DIR_WS_IMAGES . 'products/medium/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block"') . '</noscript>', 'products_link_image' => xos_href_link(FILENAME_PRODUCT_INFO, 'm=' . $_GET['m'] . '&p=' . $listing['products_id'])); } else { $table_inner_array[] = array('case' => 'image', 'products_image_small' => xos_lazy_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block lazy" style="display: none;"') . '<noscript>' . xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block"') . '</noscript>', 'products_image_medium' => xos_lazy_image(DIR_WS_IMAGES . 'products/medium/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block lazy" style="display: none;"') . '<noscript>' . xos_image(DIR_WS_IMAGES . 'products/medium/' . rawurlencode($products_image_name['name']), $listing['products_name'], '', '', 'class="img-responsive center-block"') . '</noscript>', 'products_link_image' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $listing['products_id'])); } $smarty->assign('product_image', true); break; case 'PRODUCT_LIST_BUY_NOW': $table_inner_array[] = array('case' => 'buy_now', 'products_buy_form_begin' => xos_draw_form('cart_quantity_' . $rows, xos_href_link(basename($_SERVER['PHP_SELF']), xos_get_all_get_params(array('action')) . 'action=add_product', $request_type)), 'form_name' => 'cart_quantity_' . $rows, 'form_end' => '</form>', 'label_for_products_input_quantity' => 'products_quantity_' . $listing['products_id'], 'products_input_quantity' => xos_draw_input_field('products_quantity', '1', 'id="products_quantity_' . $listing['products_id'] . '" class="form-control input-quantity" maxlength="5"'), 'products_hidden_field' => xos_draw_hidden_field('p', $listing['products_id'])); break; } } $table_outer_array[] = array('table_inner' => $table_inner_array); unset($price_breaks_array); unset($table_inner_array);
'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } */ } else { $xsell_product_price = $currencies->display_price($products_prices[0][0]['regular'], $products_tax_rate); $products_prices[0]['special_status'] == 1 && $products_prices[0][0]['special'] > 0 ? $xsell_product_price_special = $currencies->display_price($products_prices[0][0]['special'], $products_tax_rate) : ($xsell_product_price_special = ''); $sizeof = count($products_prices[0]); /* if ($sizeof > 2) { $array_keys = array_keys($products_prices[0]); for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $xsell_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[0][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[0]['special_status'] == 1 && $products_prices[0][$qty]['special'] > 0 ? $currencies->display_price($products_prices[0][$qty]['special'], $products_tax_rate) : ''); } } */ } $xsell_products_image = xos_get_product_images($xsell['products_image']); $xsell_products_array[] = array('link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $xsell['products_id']), 'image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($xsell_products_image['name']), $xsell['products_name']), 'info' => $xsell['products_info'], 'price' => $xsell_product_price, 'price_special' => $xsell_product_price_special, 'price_breaks' => $xsell_price_breaks_array, 'tax_description' => xos_get_products_tax_description($xsell['products_tax_class_id'], $products_tax_rate), 'name' => $xsell['products_name']); } $smarty->assign('xsell_products', $xsell_products_array); $smarty->configLoad('languages/' . $_SESSION['language'] . '.conf', 'xsell_products'); $output_xsell_products = $smarty->fetch(SELECTED_TPL . '/includes/modules/xsell_products.tpl'); $smarty->clearAssign('xsell_products'); $smarty->assign('xsell_products', $output_xsell_products); } } }
$price_breaks_array[] = array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[$customer_group_id][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } } else { $product_price = $currencies->display_price($products_prices[0][0]['regular'], $products_tax_rate); $products_prices[0]['special_status'] == 1 && $products_prices[0][0]['special'] > 0 ? $product_price_special = $currencies->display_price($products_prices[0][0]['special'], $products_tax_rate) : ($product_price_special = ''); $sizeof = count($products_prices[0]); if ($sizeof > 2) { $array_keys = array_keys($products_prices[0]); for ($count = 2, $n = $sizeof; $count < $n; $count++) { $qty = $array_keys[$count]; $price_breaks_array[] = array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[0][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[0]['special_status'] == 1 && $products_prices[0][$qty]['special'] > 0 ? $currencies->display_price($products_prices[0][$qty]['special'], $products_tax_rate) : ''); } } } $product_image = xos_get_product_images($products_new['products_image']); $popup_content_id = xos_get_delivery_times_values($products_new['products_delivery_time_id'], 'popup_content_id'); $products_new_array[] = array('link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $products_new['products_id']), 'href_buy_now' => xos_href_link(FILENAME_PRODUCTS_NEW, xos_get_all_get_params(array('action')) . 'action=buy_now&p=' . $products_new['products_id']), 'date_added' => xos_date_long($products_new['products_date_added']), 'image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($product_image['name']), $products_new['products_name'], '', '', 'class="img-responsive"'), 'td_width_img' => SMALL_PRODUCT_IMAGE_MAX_WIDTH + 10, 'manufacturer' => $products_new['manufacturers_name'], 'tax_description' => xos_get_products_tax_description($products_new['products_tax_class_id'], $products_tax_rate), 'products_delivery_time' => xos_get_delivery_times_values($products_new['products_delivery_time_id']), 'link_filename_popup_content_products_delivery_time' => $popup_content_id > 0 ? xos_href_link(FILENAME_POPUP_CONTENT, 'co=' . $popup_content_id . '&p=' . $products_new['products_id'], $request_type) : '', 'price' => $product_price, 'price_special' => $product_price_special, 'price_breaks' => $price_breaks_array, 'info' => $products_new['products_info'], 'products_p_unit' => $products_new['products_p_unit'], 'products_model' => $products_new['products_model'], 'products_quantity' => $products_new['products_quantity'], 'name' => $products_new['products_name']); unset($price_breaks_array); } if (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3') { $smarty->assign('nav_bar_top', true); } if (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3') { $smarty->assign('nav_bar_bottom', true); } $smarty->assign('new_products', true); } $smarty->assign(array('nav_bar_number' => $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW), 'nav_bar_result' => '<nav><ul class="pagination">' . $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS, xos_get_all_get_params(array('page', 'info', 'lnc', 'cur', 'tpl', 'x', 'y'))) . '</ul></nav>', 'interval_days_back' => INTERVAL_DAYS_BACK, 'products_new' => $products_new_array)); $smarty->configLoad('languages/' . $_SESSION['language'] . '.conf', 'products_new'); }
if (!$is_shop) { xos_redirect(xos_href_link(FILENAME_DEFAULT), false); } elseif (!(@(include DIR_FS_SMARTY . 'catalog/templates/' . SELECTED_TPL . '/php/' . FILENAME_PRODUCT_REVIEWS_WRITE) == 'overwrite_all')) { if (PRODUCT_REVIEWS_ENABLED != 'true') { xos_redirect(xos_href_link(FILENAME_DEFAULT), false); } elseif (!isset($_SESSION['customer_id'])) { $_SESSION['navigation']->remove_current_page(); $_SESSION['navigation']->set_snapshot(); xos_redirect(xos_href_link(FILENAME_LOGIN, '', 'SSL')); } $product_info_query = xos_db_query("select p.products_id, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_p_unit from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES_OR_PAGES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_or_pages_status = '1' and p.products_id = p2c.products_id and p2c.categories_or_pages_id = c.categories_or_pages_id and p.products_id = '" . (int) $_GET['p'] . "' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'"); if (!xos_db_num_rows($product_info_query)) { xos_redirect(xos_href_link(FILENAME_PRODUCT_REVIEWS, xos_get_all_get_params(array('action'))), false); } else { $product_info = xos_db_fetch_array($product_info_query); $products_image_name = xos_get_product_images($product_info['products_image'], 'all'); } $customer_query = xos_db_query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = '" . (int) $_SESSION['customer_id'] . "'"); $customer = xos_db_fetch_array($customer_query); if (isset($_GET['action']) && $_GET['action'] == 'process' && isset($_POST['formid']) && $_POST['formid'] == $_SESSION['sessiontoken']) { $rating = xos_db_prepare_input($_POST['rating']); $review = xos_db_prepare_input(substr(strip_tags($_POST['review']), 0, 1000)); $error = false; if (strlen($review) < REVIEW_TEXT_MIN_LENGTH) { $error = true; $messageStack->add('review', JS_REVIEW_TEXT); } if ($rating < 1 || $rating > 5) { $error = true; $messageStack->add('review', JS_REVIEW_RATING); }
require DIR_WS_INCLUDES . 'html_header.php'; require DIR_WS_INCLUDES . 'boxes.php'; require DIR_WS_INCLUDES . 'header.php'; require DIR_WS_INCLUDES . 'footer.php'; if (CACHE_LEVEL > 2 && (isset($_COOKIE[session_name()]) && !isset($_GET[session_name()]) || SESSION_FORCE_COOKIE_USE == 'true')) { $smarty->caching = 1; $cache_id = 'L3|cc_reviews|' . $_SESSION['language'] . '-' . $_GET['lnc'] . '-' . $_GET[session_name()] . '-' . $session_started . '-' . SELECTED_TPL . '-' . $_SESSION['currency']; } if (!$smarty->isCached(SELECTED_TPL . '/reviews.tpl', $cache_id)) { $reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES_OR_PAGES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_or_pages_status = '1' and p.products_id = p2c.products_id and p2c.categories_or_pages_id = c.categories_or_pages_id and p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . (int) $_SESSION['languages_id'] . "' and rd.languages_id = '" . (int) $_SESSION['languages_id'] . "' order by r.reviews_id DESC"; $reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS); if ($reviews_split->number_of_rows > 0) { $reviews_query = xos_db_query($reviews_split->sql_query); $reviews_array = array(); while ($reviews = xos_db_fetch_array($reviews_query)) { $product_image = xos_get_product_images($reviews['products_image']); $reviews_array[] = array('link_filename_product_reviews_info' => xos_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'p=' . $reviews['products_id'] . '&r=' . $reviews['reviews_id']), 'date_added' => xos_date_long($reviews['date_added']), 'products_image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($product_image['name']), $reviews['products_name']), 'td_width_img' => SMALL_PRODUCT_IMAGE_MAX_WIDTH + 10, 'reviews_rating' => $reviews['reviews_rating'], 'review_text' => xos_break_string(xos_output_string_protected($reviews['reviews_text']), 60, '-<br />'), 'stars_image' => xos_image(DIR_WS_IMAGES . 'catalog/templates/' . SELECTED_TPL . '/stars_' . $reviews['reviews_rating'] . '.gif', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), 'customers_name' => xos_output_string_protected($reviews['customers_name']), 'products_name' => $reviews['products_name']); } if (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3') { $smarty->assign('nav_bar_top', true); } if (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3') { $smarty->assign('nav_bar_bottom', true); } $smarty->assign('reviews', true); } $smarty->assign(array('nav_bar_number' => $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS), 'nav_bar_result' => TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, xos_get_all_get_params(array('page', 'info', 'lnc', 'cur', 'tpl', 'x', 'y'))), 'nav_bar_result_in_pull_down_menu' => $reviews_split->display_links_in_pull_down_menu(MAX_DISPLAY_PAGE_LINKS, xos_get_all_get_params(array('page', 'info', 'lnc', 'cur', 'tpl', 'x', 'y'))), 'reviews_array' => $reviews_array)); $smarty->configLoad('languages/' . $_SESSION['language'] . '.conf', 'reviews'); } $output_reviews = $smarty->fetch(SELECTED_TPL . '/reviews.tpl', $cache_id); $smarty->assign('central_contents', $output_reviews);
$smarty->assign(array('edit' => true, 'form_begin_review' => xos_draw_form('review', FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $_GET['rID'] . '&action=preview'), 'products_name' => $rInfo->products_name, 'customers_name' => $rInfo->customers_name, 'date_added' => xos_date_short($rInfo->date_added), 'textarea_reviews_text' => xos_draw_textarea_field('reviews_text', '60', '15', $rInfo->reviews_text), 'hidden_reviews_id' => xos_draw_hidden_field('reviews_id', $rInfo->reviews_id), 'hidden_products_id' => xos_draw_hidden_field('products_id', $rInfo->products_id), 'hidden_customers_name' => xos_draw_hidden_field('customers_name', $rInfo->customers_name), 'hidden_products_name' => xos_draw_hidden_field('products_name', $rInfo->products_name), 'hidden_products_image' => xos_draw_hidden_field('products_image', $rInfo->products_image), 'hidden_date_added' => xos_draw_hidden_field('date_added', $rInfo->date_added), 'link_filename_reviews_cancel' => xos_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $_GET['rID']), 'reviews_rating' => $reviews_rating, 'form_end' => '</form>')); } elseif ($action == 'preview') { if (xos_not_null($_POST)) { $rInfo = new objectInfo($_POST); } else { $rID = xos_db_prepare_input($_GET['rID']); $reviews_query = xos_db_query("select r.reviews_id, r.products_id, r.customers_name, r.date_added, r.last_modified, r.reviews_read, rd.reviews_text, r.reviews_rating from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.reviews_id = '" . (int) $rID . "' and r.reviews_id = rd.reviews_id"); $reviews = xos_db_fetch_array($reviews_query); $products_query = xos_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . (int) $reviews['products_id'] . "'"); $products = xos_db_fetch_array($products_query); $products_name_query = xos_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $reviews['products_id'] . "' and language_id = '" . (int) $_SESSION['used_lng_id'] . "'"); $products_name = xos_db_fetch_array($products_name_query); $rInfo_array = array_merge((array) $reviews, (array) $products, (array) $products_name); $rInfo = new objectInfo($rInfo_array); } $product_image = xos_get_product_images($rInfo->products_image); if (xos_not_null($_POST)) { /* Re-Post all POST'ed variables */ reset($_POST); $hidden_post_values = ''; while (list($key, $value) = each($_POST)) { $hidden_post_values .= xos_draw_hidden_field($key, htmlspecialchars(stripslashes($value))); } $smarty->assign(array('hidden_post_values' => $hidden_post_values, 'link_filename_reviews_back_edit' => xos_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=edit'), 'link_filename_reviews_cancel' => xos_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id))); } else { if (isset($_GET['origin'])) { $back_url = $_GET['origin']; $back_url_params = ''; } else { $back_url = FILENAME_REVIEWS; $back_url_params = 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id;
for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $whats_new_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[$customer_group_id][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } */ } else { $whats_new_price = $currencies->display_price($products_prices[0][0]['regular'], $products_tax_rate); $products_prices[0]['special_status'] == 1 && $products_prices[0][0]['special'] > 0 ? $whats_new_price_special = $currencies->display_price($products_prices[0][0]['special'], $products_tax_rate) : ($whats_new_price_special = ''); $sizeof = count($products_prices[0]); /* if ($sizeof > 2) { $array_keys = array_keys($products_prices[0]); for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $whats_new_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[0][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[0]['special_status'] == 1 && $products_prices[0][$qty]['special'] > 0 ? $currencies->display_price($products_prices[0][$qty]['special'], $products_tax_rate) : ''); } } */ } $random_product['products_name'] = xos_get_products_name($random_product['products_id']); $random_new_product_image = xos_get_product_images($random_product['products_image']); $smarty->assign(array('box_whats_new_link_filename_products_new' => xos_href_link(FILENAME_PRODUCTS_NEW), 'box_whats_new_link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $random_product['products_id']), 'box_whats_new_product_image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($random_new_product_image['name']), $random_product['products_name']), 'box_whats_new_product_name' => $random_product['products_name'], 'box_whats_new_product_price' => $whats_new_price, 'box_whats_new_product_price_special' => $whats_new_price_special, 'box_whats_new_products_tax_description' => xos_get_products_tax_description($random_product['products_tax_class_id'], $products_tax_rate), 'box_whats_new_product_price_breaks' => $whats_new_price_breaks_array)); $output_whats_new = $smarty->fetch(SELECTED_TPL . '/includes/boxes/whats_new.tpl'); $smarty->assign('box_whats_new', $output_whats_new); } }
$array_keys = array_keys($products_prices[$customer_group_id]); for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $specials_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[$customer_group_id][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } */ } else { $specials_product_price = $currencies->display_price($products_prices[0][0]['regular'], $products_tax_rate); $products_prices[0]['special_status'] == 1 && $products_prices[0][0]['special'] > 0 ? $specials_product_price_special = $currencies->display_price($products_prices[0][0]['special'], $products_tax_rate) : ($specials_product_price_special = ''); $sizeof = count($products_prices[0]); /* if ($sizeof > 2) { $array_keys = array_keys($products_prices[0]); for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $specials_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[0][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[0]['special_status'] == 1 && $products_prices[0][$qty]['special'] > 0 ? $currencies->display_price($products_prices[0][$qty]['special'], $products_tax_rate) : ''); } } */ } $random_special_product_image = xos_get_product_images($random_product['products_image']); $smarty->assign(array('box_specials_link_filename_specials' => xos_href_link(FILENAME_SPECIALS), 'box_specials_link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $random_product["products_id"]), 'box_specials_product_image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($random_special_product_image['name']), $random_product['products_name']), 'box_specials_product_name' => $random_product['products_name'], 'box_specials_product_price' => $specials_product_price, 'box_specials_product_price_special' => $specials_product_price_special, 'box_specials_products_tax_description' => xos_get_products_tax_description($random_product['products_tax_class_id'], $products_tax_rate), 'box_specials_product_price_breaks' => $specials_price_breaks_array)); $output_specials = $smarty->fetch(SELECTED_TPL . '/includes/boxes/specials.tpl'); $smarty->assign('box_specials', $output_specials); } }
// Copyright (c) 2003 osCommerce // filename: categories.php // // Released under the GNU General Public License //////////////////////////////////////////////////////////////////////////////// if (!(@(include DIR_FS_SMARTY . 'admin/templates/' . ADMIN_TPL . '/php/includes/modules/new_product.php') == 'overwrite_all')) { $form_action = isset($_GET['pID']) ? 'update_product' : 'insert_product'; $parameters = array('products_name' => '', 'products_p_unit' => '', 'products_info' => '', 'products_description' => '', 'products_url' => '', 'products_id' => '', 'products_quantity' => '', 'products_delivery_time_id' => '', 'products_sort_order' => '', 'products_model' => '', 'products_image' => '', 'products_price' => '', 'products_weight' => '', 'products_date_added' => '', 'products_last_modified' => '', 'products_date_available' => '', 'products_status' => '', 'products_tax_class_id' => '', 'manufacturers_id' => '', 'attributes_quantity' => ''); if (isset($_GET['pID'])) { $product_query = xos_db_query("select products_id, products_quantity, products_delivery_time_id, products_model, products_image, products_price, products_sort_order, products_weight, products_date_added, products_last_modified, date_format(products_date_available, '" . DATE_FORMAT_SHORT . "') as products_date_available, products_status, products_tax_class_id, manufacturers_id, attributes_quantity, attributes_not_updated from " . TABLE_PRODUCTS . " where products_id = '" . (int) $_GET['pID'] . "'"); $product = xos_db_fetch_array($product_query); $pInfo = new objectInfo($product); } else { $pInfo = new objectInfo($parameters); } $products_image = xos_get_product_images($pInfo->products_image, 'all'); $has_product_attributes = xos_has_product_attributes($pInfo->products_id); $manufacturers_array = array(array('id' => '', 'text' => TEXT_NONE)); $manufacturers_query = xos_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS_INFO . " where languages_id = '" . (int) $_SESSION['used_lng_id'] . "' order by manufacturers_name"); while ($manufacturers = xos_db_fetch_array($manufacturers_query)) { $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']); } $delivery_times_array = array(array('id' => '', 'text' => TEXT_NONE)); $delivery_times_query = xos_db_query("select delivery_times_id, delivery_times_text from " . TABLE_DELIVERY_TIMES . " where language_id = '" . (int) $_SESSION['used_lng_id'] . "' order by delivery_times_id"); while ($delivery_times = xos_db_fetch_array($delivery_times_query)) { $delivery_times_array[] = array('id' => $delivery_times['delivery_times_id'], 'text' => $delivery_times['delivery_times_text']); } $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE)); $tax_class_query = xos_db_query("select distinct tc.tax_class_id, tc.tax_class_title from " . TABLE_TAX_CLASS . " tc, " . TABLE_TAX_RATES . " tr where tc.tax_class_id = tr.tax_class_id order by tc.tax_class_title"); while ($tax_class = xos_db_fetch_array($tax_class_query)) { $tax_class_array[] = array('id' => $tax_class['tax_class_id'], 'text' => $tax_class['tax_class_title']);
'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } */ } else { $orders_product_price = $currencies->display_price($products_prices[0][0]['regular'], $products_tax_rate); $products_prices[0]['special_status'] == 1 && $products_prices[0][0]['special'] > 0 ? $orders_product_price_special = $currencies->display_price($products_prices[0][0]['special'], $products_tax_rate) : ($orders_product_price_special = ''); $sizeof = count($products_prices[0]); /* if ($sizeof > 2) { $array_keys = array_keys($products_prices[0]); for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $orders_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[0][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[0]['special_status'] == 1 && $products_prices[0][$qty]['special'] > 0 ? $currencies->display_price($products_prices[0][$qty]['special'], $products_tax_rate) : ''); } } */ } $orders_products_image = xos_get_product_images($orders['products_image']); $also_purchased_products_array[] = array('link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $orders['products_id']), 'image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($orders_products_image['name']), $orders['products_name']), 'info' => $orders['products_info'], 'price' => $orders_product_price, 'price_special' => $orders_product_price_special, 'price_breaks' => $orders_price_breaks_array, 'tax_description' => xos_get_products_tax_description($orders['products_tax_class_id'], $products_tax_rate), 'name' => $orders['products_name']); } $smarty->assign('also_purchased_products', $also_purchased_products_array); $smarty->configLoad('languages/' . $_SESSION['language'] . '.conf', 'also_purchased_products'); $output_also_purchased_products = $smarty->fetch(SELECTED_TPL . '/includes/modules/also_purchased_products.tpl'); $smarty->clearAssign('also_purchased_products'); $smarty->assign('also_purchased_products', $output_also_purchased_products); } } }
if ($attributes_values['options_values_price'] != 0) { $attributes_options_values_price = true; $options_values_price = $currencies->format(xos_add_tax($currencies->currencies[$_SESSION['currency']]['value'] * $attributes_values['options_values_price'], $products_tax_rate)); } $attributes_array[] = array('products_options_name' => $attributes_values['products_options_name'], 'options_values_id' => $value, 'products_options_values_name' => $attributes_values['products_options_values_name'], 'options_values_price' => $options_values_price, 'hidden_field' => $hidden_field, 'price_prefix' => $attributes_values['price_prefix']); } } if (STOCK_CHECK == 'true') { $stock_check = xos_check_stock($products[$i]['id'], $products[$i]['quantity']); if (xos_not_null($stock_check)) { $any_out_of_stock = 1; $products_name .= $stock_check; } } $tax_rate = xos_display_tax_value($products_tax_rate); $product_image = xos_get_product_images($products[$i]['image']); $popup_content_id = xos_get_delivery_times_values($products[$i]['delivery_time_id'], 'popup_content_id'); $products_array[] = array('checkbox_cart_delete' => xos_draw_checkbox_field('cart_delete[]', $products[$i]['id'], false, 'id="cart_delete_' . ($i + 1) . '"'), 'link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . urlencode($products[$i]['id'])), 'link_remove_product' => xos_href_link(FILENAME_SHOPPING_CART, 'action=remove_product&rmp=0&p=' . urlencode($products[$i]['id'])), 'products_image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($product_image['name']), $products[$i]['name']), 'products_name' => $products[$i]['name'], 'products_packaging_unit' => $products[$i]['packaging_unit'], 'products_delivery_time' => xos_get_delivery_times_values($products[$i]['delivery_time_id']), 'link_filename_popup_content_products_delivery_time' => $popup_content_id > 0 ? xos_href_link(FILENAME_POPUP_CONTENT, 'co=' . $popup_content_id . '&p=' . $products[$i]['id'], $request_type) : '', 'products_model' => $products[$i]['model'], 'stock_check' => $stock_check, 'input_and_hidden_fields_quantity' => xos_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'id="cart_quantity_' . ($i + 1) . '" class="form-control cart-input-quantity" size="2" maxlength="5"') . xos_draw_hidden_field('p[]', $products[$i]['id']), 'products_tax' => xos_display_tax_value($products_tax_rate), 'products_price' => $currencies->format($products[$i]['price']), 'products_final_single_price' => $currencies->format($products[$i]['final_price']), 'products_final_price' => $currencies->format($products[$i]['quantity'] * $products[$i]['final_price']), 'products_attributes_option_price' => $attributes_options_values_price, 'products_attributes' => $attributes_array); if (isset($tax_rate)) { $tax_rates[$tax_rate] = '1'; } unset($attributes_array); } include DIR_WS_CLASSES . 'payment.php'; $payment_modules = new payment(); $initialize_checkout_methods = $payment_modules->checkout_initialization_method(); $alternative_checkout_methods_array = array(); if (!empty($initialize_checkout_methods)) { reset($initialize_checkout_methods); while (list(, $value) = each($initialize_checkout_methods)) { $alternative_checkout_methods_array[] = array('value' => $value);
xos_redirect(xos_href_link(FILENAME_PRODUCT_REVIEWS, xos_get_all_get_params(array('r')))); } require DIR_FS_SMARTY . 'catalog/languages/' . $_SESSION['language'] . '/' . FILENAME_PRODUCT_REVIEWS_INFO; $site_trail->add(NAVBAR_TITLE, xos_href_link(FILENAME_PRODUCT_REVIEWS_INFO, xos_get_all_get_params(array('lnc', 'cur', 'tpl', 'x', 'y')))); require DIR_WS_INCLUDES . 'html_header.php'; require DIR_WS_INCLUDES . 'boxes.php'; require DIR_WS_INCLUDES . 'header.php'; require DIR_WS_INCLUDES . 'footer.php'; xos_db_query("update " . TABLE_REVIEWS . " set reviews_read = reviews_read+1 where reviews_id = '" . (int) $_GET['r'] . "'"); if (CACHE_LEVEL > 2 && (isset($_COOKIE[session_name()]) && !isset($_GET[session_name()]) || SESSION_FORCE_COOKIE_USE == 'true')) { $smarty->caching = 1; $cache_id = 'L3|cc_product_reviews_info|' . $_SESSION['language'] . '-' . $_GET['lnc'] . '-' . $_GET[session_name()] . '-' . $session_started . '-' . SELECTED_TPL . '-' . $_SESSION['currency'] . '-' . $_SESSION['sppc_customer_group_id'] . '-' . $_SESSION['sppc_customer_group_show_tax'] . '-' . $_SESSION['sppc_customer_group_tax_exempt'] . '-' . $_GET['c'] . '-' . $_GET['m'] . '-' . $_GET['p'] . '-' . $_GET['r']; } if (!$smarty->isCached(SELECTED_TPL . '/product_reviews_info.tpl', $cache_id)) { $review = xos_db_fetch_array($review_query); $products_image_name = xos_get_product_images($review['products_image'], 'all'); $products_prices = xos_get_product_prices($review['products_price']); $products_tax_rate = xos_get_tax_rate($review['products_tax_class_id']); $price_breaks_array = array(); if (isset($products_prices[$customer_group_id][0])) { $product_price = $currencies->display_price($products_prices[$customer_group_id][0]['regular'], $products_tax_rate); $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][0]['special'] > 0 ? $product_price_special = $currencies->display_price($products_prices[$customer_group_id][0]['special'], $products_tax_rate) : ($product_price_special = ''); $sizeof = count($products_prices[$customer_group_id]); if ($sizeof > 2) { $array_keys = array_keys($products_prices[$customer_group_id]); for ($count = 2, $n = $sizeof; $count < $n; $count++) { $qty = $array_keys[$count]; $price_breaks_array[] = array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[$customer_group_id][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } } else {
function xos_remove_product($product_id) { $product_image_query = xos_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . (int) $product_id . "'"); $product_image = xos_db_fetch_array($product_image_query); $products_image_name = xos_get_product_images($product_image['products_image'], 'all'); reset($products_image_name); while ($image = each($products_image_name)) { @unlink(DIR_FS_CATALOG_IMAGES . 'products/uploads/' . $image[1]['name']); @unlink(DIR_FS_CATALOG_IMAGES . 'products/extra_small/' . $image[1]['name']); @unlink(DIR_FS_CATALOG_IMAGES . 'products/small/' . $image[1]['name']); @unlink(DIR_FS_CATALOG_IMAGES . 'products/medium/' . $image[1]['name']); @unlink(DIR_FS_CATALOG_IMAGES . 'products/large/' . $image[1]['name']); } xos_db_query("delete from " . TABLE_SPECIALS . " where products_id = '" . (int) $product_id . "'"); xos_db_query("delete from " . TABLE_PRODUCTS . " where products_id = '" . (int) $product_id . "'"); xos_db_query("delete from " . TABLE_PRODUCTS_PRICES . " where products_id = '" . (int) $product_id . "'"); xos_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int) $product_id . "'"); xos_db_query("delete from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $product_id . "'"); xos_db_query("delete from " . TABLE_PRODUCTS_XSELL . " where products_id = '" . (int) $product_id . "' or xsell_id = '" . (int) $product_id . "'"); xos_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where products_id = '" . (int) $product_id . "' or products_id like '" . (int) $product_id . "-%'"); $products_attributes_id_query = xos_db_query("select products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int) $product_id . "'"); while ($products_attributes_id = xos_db_fetch_array($products_attributes_id_query)) { xos_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . (int) $products_attributes_id['products_attributes_id'] . "'"); } xos_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int) $product_id . "'"); $product_reviews_query = xos_db_query("select reviews_id from " . TABLE_REVIEWS . " where products_id = '" . (int) $product_id . "'"); while ($product_reviews = xos_db_fetch_array($product_reviews_query)) { xos_db_query("delete from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int) $product_reviews['reviews_id'] . "'"); } xos_db_query("delete from " . TABLE_REVIEWS . " where products_id = '" . (int) $product_id . "'"); }
require 'includes/application_top.php'; if (!(@(include DIR_FS_SMARTY . 'admin/templates/' . ADMIN_TPL . '/php/' . FILENAME_IMAGE_PROCESSING) == 'overwrite_all')) { $action = isset($_GET['action']) ? $_GET['action'] : ''; if ($action == 'recreate_product_images_now') { $smarty_cache_control->clearAllCache(); require_once 'includes/classes/image_creator.php'; xos_set_time_limit(0); $files = array(); $handle = opendir(DIR_FS_CATALOG_IMAGES . 'products/uploads/'); while ($files[] = readdir($handle)) { } closedir($handle); $products_query = xos_db_query("select products_image from " . TABLE_PRODUCTS); if (xos_db_num_rows($products_query)) { while ($products = xos_db_fetch_array($products_query)) { $products_image = xos_get_product_images($products['products_image'], 'all'); foreach ($products_image as $key => $val) { if (in_array($val['name'], $files)) { new image_create(DIR_FS_CATALOG_IMAGES . 'products/uploads/' . $val['name'], DIR_FS_CATALOG_IMAGES . 'products/extra_small/' . $val['name'], EXTRA_SMALL_PRODUCT_IMAGE_MAX_WIDTH, EXTRA_SMALL_PRODUCT_IMAGE_MAX_HEIGHT, IMAGE_QUALITY, EXTRA_SMALL_PRODUCT_IMAGE_MERGE); new image_create(DIR_FS_CATALOG_IMAGES . 'products/uploads/' . $val['name'], DIR_FS_CATALOG_IMAGES . 'products/small/' . $val['name'], SMALL_PRODUCT_IMAGE_MAX_WIDTH, SMALL_PRODUCT_IMAGE_MAX_HEIGHT, IMAGE_QUALITY, SMALL_PRODUCT_IMAGE_MERGE); new image_create(DIR_FS_CATALOG_IMAGES . 'products/uploads/' . $val['name'], DIR_FS_CATALOG_IMAGES . 'products/medium/' . $val['name'], MEDIUM_PRODUCT_IMAGE_MAX_WIDTH, MEDIUM_PRODUCT_IMAGE_MAX_HEIGHT, IMAGE_QUALITY, MEDIUM_PRODUCT_IMAGE_MERGE); new image_create(DIR_FS_CATALOG_IMAGES . 'products/uploads/' . $val['name'], DIR_FS_CATALOG_IMAGES . 'products/large/' . $val['name'], $val['large_image_max_width'] == 'default' ? LARGE_PRODUCT_IMAGE_MAX_WIDTH : $val['large_image_max_width'], $val['large_image_max_height'] == 'default' ? LARGE_PRODUCT_IMAGE_MAX_HEIGHT : $val['large_image_max_height'], IMAGE_QUALITY, LARGE_PRODUCT_IMAGE_MERGE); } } } } $smarty->assign(array('recreate_product_images_now' => true, 'link_filename_image_processing_back' => xos_href_link(FILENAME_IMAGE_PROCESSING))); $smarty->configLoad('languages/' . $_SESSION['language'] . '.conf', 'image_processing'); $output_image_processing_recreate = $smarty->fetch(ADMIN_TPL . '/image_processing.tpl'); echo $output_image_processing_recreate; die;
'price_break_special' => $products_prices[$customer_group_id]['special_status'] == 1 && $products_prices[$customer_group_id][$qty]['special'] > 0 ? $currencies->display_price($products_prices[$customer_group_id][$qty]['special'], $products_tax_rate) : ''); } } */ } else { $new_product_price = $currencies->display_price($products_prices[0][0]['regular'], $products_tax_rate); $products_prices[0]['special_status'] == 1 && $products_prices[0][0]['special'] > 0 ? $new_product_price_special = $currencies->display_price($products_prices[0][0]['special'], $products_tax_rate) : ($new_product_price_special = ''); $sizeof = count($products_prices[0]); /* if ($sizeof > 2) { $array_keys = array_keys($products_prices[0]); for ($count=2, $n=$sizeof; $count<$n; $count++) { $qty = $array_keys[$count]; $new_price_breaks_array[]=array('qty' => $qty, 'price_break' => $currencies->display_price($products_prices[0][$qty]['regular'], $products_tax_rate), 'price_break_special' => $products_prices[0]['special_status'] == 1 && $products_prices[0][$qty]['special'] > 0 ? $currencies->display_price($products_prices[0][$qty]['special'], $products_tax_rate) : ''); } } */ } $new_products_image = xos_get_product_images($new_products['products_image']); $new_products_array[] = array('link_filename_product_info' => xos_href_link(FILENAME_PRODUCT_INFO, 'p=' . $new_products['products_id']), 'image' => xos_image(DIR_WS_IMAGES . 'products/small/' . rawurlencode($new_products_image['name']), $new_products['products_name']), 'info' => $new_products['products_info'], 'price' => $new_product_price, 'price_special' => $new_product_price_special, 'price_breaks' => $new_price_breaks_array, 'tax_description' => xos_get_products_tax_description($new_products['products_tax_class_id'], $products_tax_rate), 'name' => $new_products['products_name']); unset($price_breaks_array); } $smarty->assign('new_products', $new_products_array); $smarty->configLoad('languages/' . $_SESSION['language'] . '.conf', 'new_products'); $output_new_products = $smarty->fetch(SELECTED_TPL . '/includes/modules/new_products.tpl'); $smarty->clearAssign('new_products'); $smarty->assign('new_products', $output_new_products); } }