order_id = $order_id;
}
/**************************************************************************
* name: html_change_bill_to
* created by: kaltokri
* description: Prints formular to change bill to
* parameters: none
* returns: none
**************************************************************************/
function html_change_bill_to($user_id) {
global $VM_LANG;
?>
_PHPSHOP_ORDER_CHANGE_UPD_BILL ?>:
_PHPSHOP_ORDER_CHANGE_UPD_SHIP ?>:
order_id."'";
$db->query($q);
$db->next_record();
?>
order_id."'";
$db->query($q);
$db->next_record();
$rate_details = explode( "|", $db->f("ship_method_id") );
?>
f('ship_method_id') == "" OR preg_match('/^standard_shipping/', $db->f('ship_method_id'))) {
?>
_PHPSHOP_ORDER_PRINT_SHIPPING ?>:
_PHPSHOP_ORDER_PRINT_SHIPPING_TAX ?>:
order_id."'";
$db->query($q);
$db->next_record();
?>
_PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT ?>:
order_id."'";
$db->query($q);
$db->next_record();
?>
_PHPSHOP_COUPON_DISCOUNT ?>:
order_id."'";
$db->query($q);
$db->next_record();
?>
0) {
$product_id = $product_id_bysku;
}
// Output to generate a "return to parant"-button
$html_return_parent = '';
// Page reseted = -1 or called first time = ""
if ($product_id < 0 || $product_id == "") {
// Generate product list
?>
query($q);
// Are there childs?
if ( $db->num_rows()) {
// Yes! Drop down list to select the child
?>
_PHPSHOP_ORDER_EDIT_CHOOSE_PRODUCT_BY_SKU;
}
// List all products by name
else {
$sortby = 'product_name';
$select_name = 'product_id';
$reset_other_list = 'this.form.product_id_bysku.value=-1';
$first_item = $VM_LANG->_PHPSHOP_ORDER_EDIT_CHOOSE_PRODUCT;
}
$query_list_products = "SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`";
$query_list_products .= ",`#__{sc}_product`.`product_id`,`#__{sc}_category`.`category_id`,`product_full_image`,`product_thumb_image`";
$query_list_products .= ",`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`";
$query_list_products .= " FROM (`#__{sc}_product`, `#__{sc}_category`, `#__{sc}_product_category_xref`";
$query_list_products .= ",`#__{sc}_shopper_group`) LEFT JOIN `#__{sc}_product_price` ON";
$query_list_products .= " `#__{sc}_product`.`product_id` = `#__{sc}_product_price`.`product_id`";
$query_list_products .= " WHERE `#__{sc}_product_category_xref`.`category_id`=`#__{sc}_category`.`category_id`";
$query_list_products .= " AND `#__{sc}_product`.`product_id`=`#__{sc}_product_category_xref`.`product_id`";
$query_list_products .= " AND `#__{sc}_product`.`product_parent_id`='0'";
$query_list_products .= " AND (( `#__{sc}_shopper_group`.`shopper_group_id`=`#__{sc}_product_price`.`shopper_group_id` )";
$query_list_products .= " OR (`#__{sc}_product_price`.`product_id` IS NULL))";
$query_list_products .= " GROUP BY `#__{sc}_product`.`product_sku` ORDER BY `#__{sc}_product`.`" . $sortby . "`";
$db->query($query_list_products);
$display = '';
$display .= '' . $first_item . ' ';
while ($db->next_record()) {
$display .= 'f("product_id")) {
$display .= ' selected="yes"';
}
if ($skumode) {
$display .= '>' . $db->f("product_sku") . ' ';
}
else {
$display .= '>' . $db->f("product_name") . '';
}
}
$display .= ' ';
return $display;
}
/**************************************************************************
* name: list_attribute
* created by: nfischer
* description: Lists all child/sister products of the given product
* parameters: $product_id, $fils
* returns: string HTML code with Items, attributes & 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;
if ($fils) {
// Generate childlist
$q = "SELECT product_id,product_name FROM #__{sc}_product WHERE product_parent_id='$product_id'";
}
else {
// Child is selected, list siblings
$q = "SELECT product_parent_id FROM #__{sc}_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 #__{sc}_product WHERE product_parent_id='$product_parent_id'";
}
$db->setQuery($q);
$db->query();
if( $db->num_rows() > 0 ) {
$display = '';
$display .= '' . $VM_LANG->_PHPSHOP_SELECT . ' ';
while ($db->next_record()) {
$display .= 'f("product_id")) {
$display .= ' selected="yes"';
}
$display .= '>' . $db->f("product_name");
if ($fils) {
$searched_id = $product_id;
}
else {
$searched_id = $product_parent_id;
}
// For each child get attribute values by looping through attribute list
$q = "SELECT product_id, attribute_name FROM #__{sc}_product_attribute_sku ";
$q .= "WHERE product_id='$searched_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 #__{sc}_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 .= ' ';
}
$display .= ' ';
}
else {
$display= "