function zen_update_products_price_sorter($product_id) { global $db; $products_price_sorter = zen_get_products_actual_price($product_id); $db->Execute("update " . TABLE_PRODUCTS . " set\r\n products_price_sorter='" . zen_db_prepare_input($products_price_sorter) . "'\r\n where products_id='" . $product_id . "'"); }
define('META_TAG_KEYWORDS', str_replace('"', '', $meta_product_name)); define('TOP_HEAD_H1_TITLE', str_replace('"', '', $meta_category_name)); } // CUSTOM META TAGS } // EOF break; case 'product_reviews_info_OFF': $sql = "select rd.reviews_text, r.reviews_rating, r.reviews_id, r.customers_name, p.products_id, p.products_price, p.products_tax_class_id, p.products_model, pd.products_name, p.product_is_free from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where r.reviews_id = '" . (int) $_GET['reviews_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int) $_SESSION['languages_id'] . "' and r.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'"; $review_metatags = $db->Execute($sql); if ($review_metatags->EOF) { $meta_tags_over_ride = true; } else { if (META_TAG_INCLUDE_PRICE == '1') { if ($review_metatags->fields['product_is_free'] != '1') { $meta_products_price = zen_get_products_actual_price($review_metatags->fields['products_id']); $meta_products_price = SECONDARY_SECTION . $currencies->display_price($meta_products_price, zen_get_tax_rate($review_metatags->fields['products_tax_class_id'])); } else { $meta_products_price = SECONDARY_SECTION . META_TAG_PRODUCTS_PRICE_IS_FREE_TEXT; } } else { $meta_products_price = ''; } if (zen_not_null($review_metatags->fields['products_model'])) { $meta_products_name = $review_metatags->fields['products_name'] . ' [' . $review_metatags->fields['products_model'] . ']'; } else { $meta_products_name = $review_metatags->fields['products_name']; } $meta_products_name = zen_clean_html($meta_products_name); $review_text_metatags = substr(strip_tags(stripslashes($review_metatags->fields['reviews_text'])), 0, 60); $reviews_rating_metatags = SUB_TITLE_RATING . ' ' . sprintf(TEXT_OF_5_STARS, $review_metatags->fields['reviews_rating']);
function zen_get_products_discount_price_qty($product_id, $check_qty, $check_amount = 0) { global $db; $product_id = (int) $product_id; $products_query = $db->Execute("select products_discount_type, products_discount_type_from, products_priced_by_attribute from " . TABLE_PRODUCTS . " where products_id='" . (int) $product_id . "'"); $products_discounts_query = $db->Execute("select * from " . TABLE_PRODUCTS_DISCOUNT_QUANTITY . " where products_id='" . (int) $product_id . "' and discount_qty <='" . zen_db_input($check_qty) . "' order by discount_qty desc"); $display_price = zen_get_products_base_price($product_id); $display_specials_price = zen_get_products_special_price($product_id, true); switch ($products_query->fields['products_discount_type']) { // none case $products_discounts_query->EOF: //no discount applies $discounted_price = zen_get_products_actual_price($product_id); break; case '0': $discounted_price = zen_get_products_actual_price($product_id); break; // percentage discount // percentage discount case '1': if ($products_query->fields['products_discount_type_from'] == '0') { // priced by attributes if ($check_amount != 0) { $discounted_price = $check_amount - $check_amount * ($products_discounts_query->fields['discount_price'] / 100); //echo 'ID#' . $product_id . ' Amount is: ' . $check_amount . ' discount: ' . $discounted_price . '<br />'; //echo 'I SEE 2 for ' . $products_query->fields['products_discount_type'] . ' - ' . $products_query->fields['products_discount_type_from'] . ' - '. $check_amount . ' new: ' . $discounted_price . ' qty: ' . $check_qty; } else { $discounted_price = $display_price - $display_price * ($products_discounts_query->fields['discount_price'] / 100); } } else { if (!$display_specials_price) { // priced by attributes if ($check_amount != 0) { $discounted_price = $check_amount - $check_amount * ($products_discounts_query->fields['discount_price'] / 100); } else { $discounted_price = $display_price - $display_price * ($products_discounts_query->fields['discount_price'] / 100); } } else { $discounted_price = $display_specials_price - $display_specials_price * ($products_discounts_query->fields['discount_price'] / 100); } } break; // actual price // actual price case '2': if ($products_query->fields['products_discount_type_from'] == '0') { $discounted_price = $products_discounts_query->fields['discount_price']; } else { $discounted_price = $products_discounts_query->fields['discount_price']; } break; // amount offprice // amount offprice case '3': if ($products_query->fields['products_discount_type_from'] == '0') { $discounted_price = $display_price - $products_discounts_query->fields['discount_price']; } else { if (!$display_specials_price) { $discounted_price = $display_price - $products_discounts_query->fields['discount_price']; } else { $discounted_price = $display_specials_price - $products_discounts_query->fields['discount_price']; } } break; } return $discounted_price; }
$list_box_contents = array(); //echo $listing_split->sql_query; //print_r(explode(' ',zen_products_id_in_category($current_category_id))); if (zen_count_products_in_category($current_category_id) > 0) { $listing = $db->Execute($listing_split->sql_query); $row = 0; while (!$listing->EOF) { if ($listing->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) { $list_box_contents[$row]['products_image'] = ''; } else { $list_box_contents[$row]['products_image'] = $listing->fields['products_image']; } $list_box_contents[$row]['products_name'] = $listing->fields['products_name']; $list_box_contents[$row]['products_description'] = zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), 100); $list_box_contents[$row]['products_price'] = zen_get_products_base_price($listing->fields['products_id']); $list_box_contents[$row]['actual_price'] = $currencies->display_price(zen_get_products_actual_price($listing->fields['products_id']), zen_get_tax_rate($product_check->fields['products_tax_class_id'])); $list_box_contents[$row]['products_status'] = $listing->fields['products_status']; if ($listing->fields['product_is_always_free_shipping'] == 0) { $list_box_contents[$row]['product_is_always_free_shipping'] = ''; } else { $list_box_contents[$row]['product_is_always_free_shipping'] = '<span class="free_shipping"></span>'; } if ($listing->fields['product_is_free'] == 0) { $list_box_contents[$row]['product_is_free'] = ''; } else { $list_box_contents[$row]['product_is_free'] = '<span class="free"></span>'; } $list_box_contents[$row]['products_quantity_order_min'] = $listing->fields['products_quantity_order_min']; $list_box_contents[$row]['products_id'] = $listing->fields['products_id']; $list_box_contents[$row]['products_quantity'] = $listing->fields['products_quantity']; $list_box_contents[$row]['products_price_retail'] = $currencies->display_price($listing->fields['products_price_retail'], zen_get_tax_rate($product_check->fields['products_tax_class_id']));
?> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td colspan="2" class="breadCrumb"><?php echo $breadcrumb->trail(BREAD_CRUMBS_SEPARATOR); ?> </td> </tr> <tr> <td colspan="2" class="smallText"> <?php if (false) { echo 'Looking at ' . (int) $_GET['products_id'] . '<br />'; echo 'Base Price ' . zen_get_products_base_price((int) $_GET['products_id']) . '<br />'; echo 'Actual Price ' . zen_get_products_actual_price((int) $_GET['products_id']) . '<br />'; echo 'Special Price ' . zen_get_products_special_price((int) $_GET['products_id'], true) . '<br />'; echo 'Sale Maker Discount Type ' . zen_get_products_sale_discount_type((int) $_GET['products_id']) . '<br />'; echo 'Discount Calc ' . zen_get_discount_calc((int) $_GET['products_id']) . '<br />'; echo 'Discount Calc Attr $100 $75 $50 $25 ' . zen_get_discount_calc((int) $_GET['products_id'], true, 100) . ' | ' . zen_get_discount_calc((int) $_GET['products_id'], true, 75) . ' | ' . zen_get_discount_calc((int) $_GET['products_id'], true, 50) . ' | ' . zen_get_discount_calc((int) $_GET['products_id'], true, 25) . '<br />'; } ?> </td> </tr> <?php if (PRODUCT_INFO_PREVIOUS_NEXT == '1' or PRODUCT_INFO_PREVIOUS_NEXT == '3') { ?> <tr> <td colspan="2" align="center"> <?php
function _dispatchPrice($map, $data) { $value = zen_get_products_actual_price($data->fields['products_price']); return $value; }
$price_prefix = ''; while (!$favorite_result->EOF) { $products_id = $favorite_result->fields['products_id']; if (!$products_id || key_exists($products_id, $pids)) { $favorite_result->MoveNext(); continue; } $pids[$products_id] = $products_id; $favorite_id = $favorite_result->fields['favorite_id']; $count_sql = "select count(*) as price_notice_num \n \t\t\t\tfrom 2011price_notice_content pnc inner join 2011price_notice pn on pnc.price_notice_id=pn.price_notice_id \n \t\t\t\tinner join 2011favorite_goods fg on fg.favorite_id=pn.favorite_id \n \t\t\t\twhere fg.favorite_id='" . $favorite_id . "'"; $count_result = $db->Execute($count_sql); if (!$count_result->EOF) { $message_num = $count_result->fields['price_notice_num']; } else { $message_num = 0; } $display_price = zen_get_products_display_price($favorite_result->fields['products_id']); if (empty($price_prefix)) { preg_match("/Price:(\\D+)\\d/", $display_price, $t); if ($t) { $price_prefix = $t[1]; } } $favoriteArray[] = array('favorite_id' => $favorite_result->fields['favorite_id'], 'products_id' => $favorite_result->fields['products_id'], 'products_afterbuy_model' => $favorite_result->fields['products_afterbuy_model'], 'products_price' => zen_get_products_display_price($favorite_result->fields['products_id']), 'price_num' => zen_get_products_actual_price($favorite_result->fields['products_id']), 'products_image' => $favorite_result->fields['products_image'], 'products_name' => $favorite_result->fields['products_name'], 'language_id' => $favorite_result->fields['language_id'], 'price_notice_id' => $favorite_result->fields['price_notice_id'], 'message_num' => $message_num, 'add_time' => $favorite_result->fields['add_time'], 'products_stock_status' => $favorite_result->fields['products_stock_status']); //$favoriteArray[][] = $favorite_result->fields['add_time']; $favorite_result->MoveNext(); } //echo "<pre>";print_r($favoriteArray); //eof // This should be last line of the script: $zco_notifier->notify('NOTIFY_HEADER_END_ACCOUNT');