PHP ps_product::get_price方法代码示例

 function list_attribute($product_id, $fils = true)
 {
     global $VM_LANG, $CURRENCY_DISPLAY;
     $ps_product = new ps_product();
     $db = new ps_DB();
     $db_sku = new ps_DB();
     $db_item = new ps_DB();
     // Get list of children
     if ($fils) {
         $q = "SELECT product_id,product_name FROM #__{vm}_product WHERE product_parent_id='{$product_id}' AND product_publish='Y'";
     } else {
         $q = "SELECT product_parent_id FROM #__{vm}_product WHERE product_id='{$product_id}'";
         $db->setQuery($q);
         $db->query();
         $db->next_record();
         $product_parent_id = $db->f("product_parent_id");
         $q = "SELECT product_id,product_name FROM #__{vm}_product WHERE product_parent_id='{$product_parent_id}' AND product_publish='Y'";
     }
     $db->setQuery($q);
     $db->query();
     if ($db->num_rows() > 0) {
         $display = '<select name="product_id" onChange="this.form.add_product_validate.value=0;this.form.submit();">';
         $display .= '<option value="-1">Choisissez un produit item</option>';
         while ($db->next_record()) {
             $display .= '<option value="' . $db->f("product_id") . '"';
             if ($product_id == $db->f("product_id")) {
                 $display .= ' selected="yes"';
             }
             $display .= '>' . $db->f("product_name");
             // For each child get attribute values by looping through attribute list
             $q = "SELECT product_id, attribute_name FROM #__{vm}_product_attribute_sku ";
             $q .= "WHERE product_id='{$product_id}' ORDER BY attribute_list ASC";
             $db_sku->setQuery($q);
             $db_sku->query();
             while ($db_sku->next_record()) {
                 $q = "SELECT attribute_name, attribute_value, product_id ";
                 $q .= "FROM #__{vm}_product_attribute WHERE ";
                 $q .= "product_id='" . $db->f("product_id") . "' AND ";
                 $q .= "attribute_name='" . $db_sku->f("attribute_name") . "'";
                 $db_item->setQuery($q);
                 $db_item->query();
                 while ($db_item->next_record()) {
                     $display .= ' - ' . $db_item->f("attribute_name") . " ";
                     $display .= "(" . $db_item->f("attribute_value") . ")";
                     if (!$db_sku->is_last_record()) {
                         $display .= '; ';
                     }
                 }
             }
             // Attributes for this item are done.
             // Now get item price
             $price = $ps_product->get_price($db->f("product_id"));
             if ($_SESSION["auth"]["show_price_including_tax"] == 1) {
                 $tax_rate = 1 + $ps_product->get_product_taxrate($db->f("product_id"));
                 $price['product_price'] *= $tax_rate;
             }
             $display .= ' - ' . $CURRENCY_DISPLAY->getFullValue($price["product_price"]);
             $display .= '</option>';
         }
         $display .= '</select>';
     } else {
         $display = "<input type=\"hidden\" name=\"product_id\" value=\"{$product_id}\" />\n";
     }
     return $display;
 }

 /**
  * Creates drop-down boxes from advanced attribute format.
  * @author Sean Tobin (byrdhuntr@hotmail.com)
  * @param int $product_id
  * @return string HTML code containing Drop Down Lists with Labels
  */
 function list_advanced_attribute($product_id, $prod_id = null)
 {
     global $CURRENCY_DISPLAY;
     $ps_product = new ps_product();
     $db = new ps_DB();
     $auth = $_SESSION['auth'];
     $tpl = new $GLOBALS['VM_THEMECLASS']();
     if ($product_id == 0) {
         $product_id = $prod_id;
     }
     $q = "SELECT product_id, attribute FROM #__{vm}_product WHERE product_id='{$product_id}'";
     $db->query($q);
     $db->next_record();
     $productPrice = $ps_product->get_price($product_id);
     $advanced_attribute_list = $db->f("attribute");
     if ($advanced_attribute_list) {
         $has_advanced_attributes = 1;
         $fields = explode(";", $advanced_attribute_list);
         $attributes = array();
         $i = 0;
         foreach ($fields as $field) {
             $base = explode(",", $field);
             $title = array_shift($base);
             $titlevar = str_replace(" ", "_", $title);
             $prod_index = $product_id;
             if ($prod_id) {
                 $prod_index = $prod_id;
             }
             $attributes[$i]['product_id'] = $prod_index;
             $attributes[$i]['title'] = $title;
             $attributes[$i]['titlevar'] = $titlevar;
             $options_list = array();
             foreach ($base as $base_value) {
                 $options_item = array();
                 // the Option Text
                 $attribtxt = substr($base_value, 0, strrpos($base_value, '['));
                 if ($attribtxt != "") {
                     $vorzeichen = substr($base_value, strrpos($base_value, '[') + 1, 1);
                     // negative, equal or positive?
                     if ($_SESSION["auth"]["show_price_including_tax"] == 1) {
                         $price = floatval(substr($base_value, strrpos($base_value, '[') + 2)) * (1 + @$_SESSION['product_sess'][$product_id]['tax_rate']);
                         // calculate Tax
                     } else {
                         $price = floatval(substr($base_value, strrpos($base_value, '[') + 2));
                     }
                     // Apply shopper group discount
                     $price *= 1 - $auth["shopper_group_discount"] / 100;
                     $price = $GLOBALS['CURRENCY']->convert($price, $productPrice['product_currency']);
                     if ($price == "0") {
                         $attribut_hint = "test";
                     }
                     $base_var = str_replace(" ", "_", $base_value);
                     $base_var = substr($base_var, 0, strrpos($base_var, '['));
                     $options_item['base_var'] = $base_var;
                     $options_item['base_value'] = $attribtxt;
                     if ($_SESSION['auth']['show_prices'] && _SHOW_PRICES) {
                         $options_item['sign'] = $vorzeichen;
                         $options_item['display_price'] = $CURRENCY_DISPLAY->getFullValue($price);
                     }
                 } else {
                     $base_var = str_replace(" ", "_", $base_value);
                     $options_item['base_var'] = $base_var;
                     $options_item['base_value'] = $base_value;
                 }
                 $options_list[] = $options_item;
             }
             $attributes[$i]['options_list'] = $options_list;
             $i++;
         }
     }
     if ($advanced_attribute_list) {
         $tpl->set('attributes', $attributes);
         return $tpl->fetch('product_details/includes/addtocart_advanced_attribute.tpl.php');
     }
 }

 function get_insurance_value($pid)
 {
     /* Read current Configuration */
     require_once CLASSPATH . "shipping/" . __CLASS__ . ".cfg.php";
     $db = new ps_DB();
     /* XXX map shopper group 'DUTY' to sgid (shopper group id) */
     $q = "SELECT shopper_group_id FROM #__{vm}_shopper_group ";
     $q .= "WHERE shopper_group_name='" . DHL_INSURANCE_SHOPPER_GROUP . "'";
     $db->query($q);
     if (!$db->next_record()) {
         /* no group was specific for insurnace value, use normal price */
         $ps_product = new ps_product();
         $p_array = $ps_product->get_price($pid);
         $duty_value = $p_array['product_price'];
     } else {
         $sgid = $db->f("shopper_group_id");
         $q = "SELECT product_price FROM #__{vm}_product_price ";
         $q .= "WHERE product_id='" . $pid . "' ";
         $q .= "AND shopper_group_id='" . $sgid . "'";
         $db->query($q);
         if ($db->next_record()) {
             $duty_value = $db->f("product_price");
         } else {
             /* use the default product price */
             $ps_product = new ps_product();
             $p_array = $ps_product->get_price($pid);
             $duty_value = $p_array['product_price'];
         }
     }
     return $duty_value;
 }