示例#1
0
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 . "'");
}
示例#2
0
             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;
}
示例#4
0
$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');