PHP ps_product::get_field方法代码示例

 function getProductBySku($sku)
 {
     global $database, $logger;
     $logger->debug(get_class($this) . "::getProductBySku({$sku})");
     $prod = new Product();
     $ps_prod = new ps_product();
     $ps_cat = new ps_product_category();
     $query = "select product_id from #__vm_product where product_sku=" . $sku;
     $database->loadQuery($query);
     $id = $db->loadResult();
     $prod->setOid($id);
     $prod->setName($ps_prod->get_field('product_name'));
     $prod->setFlypage($ps_prod->get_flypage($id));
     $prod->setCategoryId($ps_cat->get_cid($id));
     return $prod;
 }

 /**
  * Calculates the taxable order subtotal for the order.
  * If an item has no weight, it is non taxable.
  * @author Chris Coleman
  * @param array $d
  * @return float Subtotal
  */
 function calc_order_taxable($d)
 {
     $auth = $_SESSION['auth'];
     $cart = $_SESSION['cart'];
     $subtotal = 0.0;
     require_once CLASSPATH . 'ps_product.php';
     $ps_product = new ps_product();
     require_once CLASSPATH . 'ps_shipping_method.php';
     $db = new ps_DB();
     for ($i = 0; $i < $cart["idx"]; $i++) {
         $skip_tax = false;
         // do we skip this product due to zero percent tax rate?
         $tax_rate_id = $ps_product->get_field($cart[$i]["product_id"], 'product_tax_id');
         if ($tax_rate_id != '0') {
             // look up the tax rate
             $q = "SELECT tax_rate FROM #__{vm}_tax_rate WHERE tax_rate_id='{$tax_rate_id}'";
             $db->query($q);
             if ($db->num_rows() > 0) {
                 $tax_rate = $db->f('tax_rate');
                 if ($tax_rate == 0) {
                     $skip_tax = true;
                 }
             }
         }
         $price = $ps_product->get_adjusted_attribute_price($cart[$i]["product_id"], $cart[$i]["description"]);
         $product_price = $GLOBALS['CURRENCY']->convert($price["product_price"], $price['product_currency']);
         $item_weight = ps_shipping_method::get_weight($cart[$i]["product_id"]) * $cart[$i]['quantity'];
         if (($item_weight != 0 or TAX_VIRTUAL == '1') && !$skip_tax) {
             $subtotal += $product_price * $cart[$i]["quantity"];
         }
     }
     return $subtotal;
 }

 /**
  * Retrieves the maximum and minimum quantity for the product specified by $product_id
  *
  * @param int $product_id
  * @return array
  */
 function product_order_levels($product_id)
 {
     $min_order = 0;
     $max_order = 0;
     $product_order_levels = ps_product::get_field($product_id, 'product_order_levels');
     $product_parent_id = ps_product::get_field($product_id, 'product_parent_id');
     if ($product_order_levels != ',') {
         $order_levels = $product_order_levels;
         $levels = explode(",", $order_levels);
         $min_order = array_shift($levels);
         $max_order = array_shift($levels);
     } else {
         if ($product_parent_id > 0) {
             //check parent if product_parent_id != 0
             $product_order_levels = ps_product::get_field($product_parent_id, 'product_order_levels');
             $product_parent_id = ps_product::get_field($product_parent_id, 'product_parent_id');
             if ($product_order_levels != ",") {
                 $order_levels = $product_order_levels;
                 $levels = explode(",", $order_levels);
                 $min_order = array_shift($levels);
                 $max_order = array_shift($levels);
             }
         }
     }
     return array($min_order, $max_order);
 }

 $tax_total = 0;
 $shipping_total = $shipping_tax = 0;
 $order_total = 0;
 $coupon_discount = vmGet($_SESSION, 'coupon_discount', 0);
 $coupon_discount_before = $coupon_discount_after = $payment_discount_before = $payment_discount_after = $tax = $shipping = false;
 $product_rows = array();
 for ($i = 0; $i < $cart["idx"]; $i++) {
     // Added for the zone shipping module
     $vars["zone_qty"] += $cart[$i]["quantity"];
     if ($i % 2) {
         $product_rows[$i]['row_color'] = "sectiontableentry2";
     } else {
         $product_rows[$i]['row_color'] = "sectiontableentry1";
     }
     // Get product parent id if exists
     $product_parent_id = $ps_product->get_field($cart[$i]["product_id"], "product_parent_id");
     // Get flypage for this product
     $flypage = $ps_product->get_flypage($cart[$i]["product_id"]);
     // Build URL based on whether item or product
     if ($product_parent_id) {
         $url = $sess->url(URL . basename($_SERVER['PHP_SELF']) . "?page=shop.product_details&flypage={$flypage}&product_id={$product_parent_id}");
     } else {
         $url = $sess->url(URL . basename($_SERVER['PHP_SELF']) . "?page=shop.product_details&flypage={$flypage}&product_id=" . $_SESSION['cart'][$i]["product_id"]);
     }
     $product_rows[$i]['product_name'] = "<a href=\"{$url}\"><strong>" . shopMakeHtmlSafe($ps_product->get_field($_SESSION['cart'][$i]["product_id"], "product_name")) . "</strong></a><br />" . $ps_product->getDescriptionWithTax($_SESSION['cart'][$i]["description"], $_SESSION['cart'][$i]["product_id"]);
     // Display attribute values if this an item
     $product_rows[$i]['product_attributes'] = "";
     if ($product_parent_id) {
         $db_detail = $ps_product->attribute_sql($cart[$i]["product_id"], $product_parent_id);
         while ($db_detail->next_record()) {
             $product_rows[$i]['product_attributes'] .= "<br />" . $db_detail->f("attribute_name") . "&nbsp;";

    /**
     * Called to validate the form values before the order is stored
     * 
     * @author gday
     * @author soeren
     * 
     * @param array $d
     * @return boolean
     */
    function validate_form(&$d)
    {
        global $VM_LANG, $PSHOP_SHIPPING_MODULES, $vmLogger;
        $db = new ps_DB();
        $auth = $_SESSION['auth'];
        $cart = $_SESSION['cart'];
        if (!$cart["idx"]) {
            $q = "SELECT order_id FROM #__{vm}_orders WHERE user_id='" . $auth["user_id"] . "' ";
            $q .= "ORDER BY cdate DESC";
            $db->query($q);
            $db->next_record();
            $d["order_id"] = $db->f("order_id");
            return False;
        }
        if (PSHOP_AGREE_TO_TOS_ONORDER == '1') {
            if (empty($d["agreed"])) {
                $vmLogger->warning($VM_LANG->_('PHPSHOP_AGREE_TO_TOS', false));
                return false;
            }
        }
        if (!ps_checkout::noShippingMethodNecessary()) {
            if (!$this->validate_shipping_method($d)) {
                return False;
            }
        }
        if (!$this->validate_payment_method($d, false)) {
            return false;
        }
        if (CHECK_STOCK == '1') {
            for ($i = 0; $i < $cart["idx"]; $i++) {
                $quantity_in_stock = ps_product::get_field($cart[$i]["product_id"], 'product_in_stock');
                $product_name = ps_product::get_field($cart[$i]["product_id"], 'product_name');
                if ($cart[$i]["quantity"] > $quantity_in_stock) {
                    $vmLogger->err('The Quantity for the Product "' . $product_name . '" in your Cart (' . $cart[$i]["quantity"] . ') exceeds the Quantity in Stock (' . $quantity_in_stock . '). 
												We are very sorry for this Inconvenience, but you you need to lower the Quantity in Cart for this Product.');
                    return false;
                }
            }
        }
        // calculate the unix timestamp for the specified expiration date
        // default the day to the 1st
        $expire_timestamp = @mktime(0, 0, 0, $_SESSION["ccdata"]["order_payment_expire_month"], 15, $_SESSION["ccdata"]["order_payment_expire_year"]);
        $_SESSION["ccdata"]["order_payment_expire"] = $expire_timestamp;
        return True;
    }

 /**
  * Creates the Quantity Input Boxes/Radio Buttons/Lists for Products
  *
  * @param int $product_id The Parent Product ID
  * @param int $prod_id The actual Product ID
  * @param string $child
  * @param string $use_parent
  * @return string
  */
 function show_quantity_box($product_id, $prod_id, $child = false, $use_parent = 'N')
 {
     global $VM_LANG;
     $tpl = vmTemplate::getInstance();
     if ($child == 'Y') {
         //We have a child list so get the current quantity;
         $quantity = 0;
         for ($i = 0; $i < $_SESSION["cart"]["idx"]; $i++) {
             if ($_SESSION['cart'][$i]["product_id"] == $prod_id) {
                 $quantity = $_SESSION['cart'][$i]["quantity"];
             }
         }
     } else {
         $quantity = vmrequest::getInt('quantity', 1);
     }
     // Detremine which style to use
     if ($use_parent == 'Y' && !empty($product_id)) {
         $id = $product_id;
     } else {
         $id = $prod_id;
     }
     //Get style to use
     $product_in_stock = ps_product::get_field($id, 'product_in_stock');
     $quantity_options = ps_product::get_quantity_options($id);
     extract($quantity_options);
     //Start output of quantity
     //Check for incompatabilities and reset to normal
     if (CHECK_STOCK == '1' && !$product_in_stock) {
         $display_type = 'hide';
     }
     if (empty($display_type) || @$display_type == "hide" && $child == 'Y' || @$display_type == "radio" && $child == 'YM' || @$display_type == "radio" && !$child) {
         $display_type = "none";
     }
     unset($quantity_options['display_type']);
     $tpl->set('prod_id', $prod_id);
     $tpl->set('quantity', $quantity);
     $tpl->set('display_type', $display_type);
     $tpl->set('child', $child);
     $tpl->set('quantity_options', $quantity_options);
     //Determine if label to be used
     $html = $tpl->fetch('product_details/includes/quantity_box_general.tpl.php');
     return $html;
 }

 function getCartnvpstr(&$order_totals = array())
 {
     global $auth, $VM_LANG;
     $cart = $_SESSION['cart'];
     require_once CLASSPATH . 'ps_product.php';
     $ps_product = new ps_product();
     $ret_str = "";
     $item_total = 0;
     for ($i = 0; $i < $cart["idx"]; $i++) {
         // Product PRICE
         $price = $ps_product->get_adjusted_attribute_price($cart[$i]["product_id"], $cart[$i]["description"]);
         // Convert to product currency if necessary
         $product_price = $GLOBALS['CURRENCY']->convert($price["product_price"], $price["product_currency"]);
         // SUBTOTAL CALCULATION
         $ret_str .= "&L_AMT" . $i . "=" . round($product_price, 2);
         $ret_str .= "&L_QTY" . $i . "=" . $cart[$i]["quantity"];
         $ret_str .= "&L_NAME" . $i . "=" . urlencode($ps_product->get_field($_SESSION['cart'][$i]["product_id"], "product_name"));
         $item_total += round($product_price, 2) * $cart[$i]["quantity"];
     }
     if (!empty($order_totals['coupon_discount'])) {
         // Discount is the difference left after order total has been reduced by subtotal, tax, shipping and shipping tax
         $discount = round($order_totals['order_total'], 2) - $item_total - round($order_totals['order_tax'], 2) - $order_totals['order_shipping'] - $order_totals['order_shipping_tax'];
         // add discount as line item
         $ret_str .= "&L_AMT" . $i . "=" . round($discount, 2);
         $ret_str .= "&L_QTY" . $i . "=1";
         $ret_str .= "&L_NAME" . $i . "=" . urlencode($VM_LANG->_('PHPSHOP_COUPON_DISCOUNT'));
         $item_total += $discount;
     }
     $order_totals['item_total'] = round($item_total, 2);
     $ret_str .= "&ITEMAMT=" . round($item_total, 2);
     //die( $ret_str );
     return $ret_str;
 }

 function notify_list($product_id)
 {
     global $sess, $mosConfig_fromname, $VM_LANG;
     $option = vmGet($_REQUEST, 'option');
     $product_id = intval($product_id);
     if ($product_id == 0) {
         return False;
     }
     $dbv = new ps_DB();
     $qt = "SELECT contact_email from #__{vm}_vendor ";
     $qt .= "WHERE vendor_id='1'";
     $dbv->query($qt);
     $dbv->next_record();
     $from_email = $dbv->f("contact_email");
     $db = new ps_DB();
     $q = 'SELECT notify_email FROM #__{vm}_waiting_list WHERE ';
     $q .= 'notified="0" AND product_id=' . $product_id;
     $db->query($q);
     require_once CLASSPATH . 'ps_product.php';
     $ps_product = new ps_product();
     while ($db->next_record()) {
         // get the product name for the e-mail
         $product_name = $ps_product->get_field($product_id, "product_name");
         // lets make the e-mail up from the info we have
         $notice_subject = sprintf($VM_LANG->_('PRODUCT_WAITING_LIST_EMAIL_SUBJECT'), $product_name);
         $flypage = $ps_product->get_flypage($product_id);
         // now get the url information
         $url = URL . "index.php?page=shop.product_details&flypage={$flypage}&product_id={$product_id}&option={$option}&Itemid=" . $sess->getShopItemid();
         $notice_body = sprintf($VM_LANG->_('PRODUCT_WAITING_LIST_EMAIL_TEXT'), $product_name, $url);
         // send the e-mail
         $shopper_email = $db->f("notify_email");
         vmMail($from_email, $mosConfig_fromname, $shopper_email, $notice_subject, $notice_body, "");
         $this->update($shopper_email, $product_id);
     }
     return True;
 }

 /**
  * updates the quantity of a product_id in the cart
  * @author pablo
  * @param array $d
  * @return boolean result of the update
  */
 function update(&$d)
 {
     global $VM_LANG, $vmLogger, $func, $page;
     include_class("product");
     $product_id = (int) $d["prod_id"];
     $quantity = isset($d["quantity"]) ? (int) $d["quantity"] : 1;
     $_SESSION['last_page'] = "shop.cart";
     // Check for negative quantity
     if ($quantity < 0) {
         $vmLogger->warning($VM_LANG->_('PHPSHOP_CART_ERROR_NO_NEGATIVE', false));
         return False;
     }
     if (!is_numeric($quantity)) {
         $vmLogger->warning($VM_LANG->_('PHPSHOP_CART_ERROR_NO_VALID_QUANTITY', false));
         return False;
     }
     if (!$product_id) {
         return false;
     }
     $deleted_prod = 0;
     $updated_prod = 0;
     if ($quantity == 0 && strtolower($func) == "cartupdate") {
         $deleted_prod = $this->delete($d);
     } else {
         for ($i = 0; $i < $_SESSION['cart']["idx"]; $i++) {
             // modified for the advanced attribute modification
             if ($_SESSION['cart'][$i]["product_id"] == $product_id && $_SESSION['cart'][$i]["description"] == $d["description"]) {
                 if (strtolower($func) == 'cartadd') {
                     $quantity += $_SESSION['cart'][$i]["quantity"];
                 }
                 // Get min and max order levels
                 list($min, $max) = ps_product::product_order_levels($product_id);
                 if ($min != 0 && $quantity < $min) {
                     eval("\$msg = \"" . $VM_LANG->_('VM_CART_MIN_ORDER', false) . "\";");
                     $vmLogger->warning($msg);
                     return false;
                 }
                 if ($max != 0 && $quantity > $max) {
                     eval("\$msg = \"" . $VM_LANG->_('VM_CART_MAX_ORDER', false) . "\";");
                     $vmLogger->warning($msg);
                     return false;
                 }
                 $quantity_options = ps_product::get_quantity_options($product_id);
                 if (!empty($quantity_options) && !empty($quantity_options['quantity_step'])) {
                     if ($quantity % $quantity_options['quantity_step'] > 0) {
                         continue;
                     }
                 }
                 // Remove deleted or unpublished products from the cart
                 if (!ps_product::product_exists($product_id)) {
                     $this->delete(array('product_id', $product_id));
                     continue;
                 }
                 // Check to see if checking stock quantity
                 if (CHECK_STOCK) {
                     $product_in_stock = ps_product::get_field($product_id, 'product_in_stock');
                     if (empty($product_in_stock)) {
                         $product_in_stock = 0;
                     }
                     if ($quantity > $product_in_stock) {
                         global $notify;
                         $_SESSION['notify'] = array();
                         $_SESSION['notify']['idx'] = 0;
                         $k = 0;
                         $notify = $_SESSION['notify'];
                         $_SESSION['notify'][$k]["prod_id"] = $product_id;
                         $_SESSION['notify'][$k]["quantity"] = $quantity;
                         $_SESSION['notify']['idx']++;
                         $page = 'shop.waiting_list';
                         return true;
                     }
                 }
                 $_SESSION['cart'][$i]["quantity"] = $quantity;
                 $updated_prod++;
             }
         }
     }
     if (!empty($_SESSION['coupon_discount'])) {
         // Update the Coupon Discount !!
         require_once CLASSPATH . 'ps_coupon.php';
         ps_coupon::process_coupon_code($d);
     }
     ps_cart::saveCart();
     return array($updated_prod, $deleted_prod);
 }

 // Determiine the cart direction and set vars
 if (@$_SESSION['vmCartDirection']) {
     $i = 0;
     $up_limit = $cart["idx"];
 } else {
     $i = $cart["idx"] - 1;
     $up_limit = -1;
 }
 $ci = 0;
 //Start loop through cart
 do {
     //If we are not showing the minicart start the styling of the individual products
     $price = $ps_product->get_adjusted_attribute_price($cart[$i]["product_id"], $cart[$i]["description"]);
     $price["product_price"] = $GLOBALS['CURRENCY']->convert($price["product_price"], $price["product_currency"]);
     $amount += $cart[$i]["quantity"];
     $product_parent_id = $ps_product->get_field($cart[$i]["product_id"], "product_parent_id");
     if (@$auth["show_price_including_tax"] == 1) {
         $my_taxrate = $ps_product->get_product_taxrate($cart[$i]["product_id"]);
         $price["product_price"] *= $my_taxrate + 1;
     }
     $subtotal = round($price["product_price"], 2) * $cart[$i]["quantity"];
     $total += $subtotal;
     $flypage_id = $product_parent_id;
     if ($flypage_id == 0) {
         $flypage_id = $cart[$i]["product_id"];
     }
     $flypage = $ps_product->get_flypage($flypage_id);
     $category_id = vmGet($cart[$i], 'category_id', 0);
     if ($product_parent_id) {
         $url = $sess->url(URL . "index.php?page=shop.product_details&flypage={$flypage}&product_id={$product_parent_id}&category_id={$category_id}");
     } else {