function convert_product_attributes_result($attributes_values, $load_option_name = true, $can_operate = false) { if ($load_option_name) { $attributes_values->fields['products_options_name'] = zen_options_name($attributes_values->fields['options_id']); $attributes_values->fields['products_options_values_name'] = zen_values_name($attributes_values->fields['options_values_id']); } $attributes_values->fields['products_display_price'] = $attributes_values->fields['price_prefix'] . $attributes_values->fields['options_values_price']; $attributes_values->fields['products_attributes_display_weight'] = $attributes_values->fields['products_attributes_weight_prefix'] . $attributes_values->fields['products_attributes_weight']; require_once DIR_WS_CLASSES . 'currencies.php'; $currencies = new currencies(); $attributes_price_final = zen_get_attributes_price_final($attributes_values->fields["products_attributes_id"], 1, $attributes_values, 'false'); $attributes_price_final_value = $attributes_price_final; $attributes_price_final = $currencies->display_price($attributes_price_final, zen_get_tax_rate(1), 1); $attributes_price_final_onetime = zen_get_attributes_price_final_onetime($attributes_values->fields["products_attributes_id"], 1, $attributes_values); $attributes_price_final_onetime = $currencies->display_price($attributes_price_final_onetime, zen_get_tax_rate(1), 1); $new_attributes_price = ''; if ($attributes_values->fields["attributes_discounted"]) { $new_attributes_price = zen_get_attributes_price_final($attributes_values->fields["products_attributes_id"], 1, '', 'false'); $new_attributes_price = zen_get_discount_calc($attributes_values->fields['products_id'], true, $new_attributes_price); if ($new_attributes_price != $attributes_price_final_value) { $new_attributes_price = '|' . $currencies->display_price($new_attributes_price, zen_get_tax_rate(1), 1); } else { $new_attributes_price = ''; } } $attributes_values->fields['attributes_display_price_final'] = $attributes_price_final . $new_attributes_price . ' ' . $attributes_price_final_onetime; // status $attributes_values->fields['products_status'] = ""; foreach ($this->statuses as $type => $icon_info) { $attributes_values->fields['products_status'] .= self::make_status_link($attributes_values->fields, $type, $icon_info['color'], $icon_info['alt'], $can_operate); } return $attributes_values->fields; }
?> </td> <td class="main"><?php echo zen_draw_input_field('discount_price[' . $discount_name[$i]['id'] . ']', $discount_name[$i]['discount_price']); ?> </td> // Dual Pricing start <td class="main"><?php echo zen_draw_input_field('discount_price_w[' . $discount_name[$i]['id'] . ']', $discount_name[$i]['discount_price_w']); ?> </td> <?php if (DISPLAY_PRICE_WITH_TAX_ADMIN == 'true') { ?> <td class="main" align="right"><?php echo $currencies->display_price($discounted_price, '', 1) . ' ' . $currencies->display_price($discounted_price, zen_get_tax_rate(1), 1); ?> </td> <td class="main" align="right"><?php echo $currencies->display_price_w($discounted_price_w, '', 1) . ' ' . $currencies->display_price_w($discounted_price_w, zen_get_tax_rate(1), 1); ?> </td> <td class="main" align="right"><?php echo ' x ' . number_format($discount_name[$i]['discount_qty']) . ' = ' . $currencies->display_price($discounted_price, '', $discount_name[$i]['discount_qty']) . ' ' . $currencies->display_price($discounted_price, zen_get_tax_rate(1), $discount_name[$i]['discount_qty']); ?> </td> <td class="main" align="right"><?php echo ' x ' . number_format($discount_name[$i]['discount_qty']) . ' = ' . $currencies->display_price_w($discounted_price_w, '', $discount_name[$i]['discount_qty']) . ' ' . $currencies->display_price_w($discounted_price_w, zen_get_tax_rate(1), $discount_name[$i]['discount_qty']); ?> </td> <?php
$limit = @mysql_result($groups_query, 0, "customers_status_accumulated_limit"); $current_discount = @mysql_result($groups_query, 0, "customers_status_discount"); if ($customer['customers_status'] != $customers_groups_id) { if ($changed) { // send emails // assign language to template for caching $vamTemplate->assign('language', $_SESSION['language']); $vamTemplate->caching = false; // set dirs manual $vamTemplate->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/'); $vamTemplate->assign('logo_path', HTTP_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/'); $vamTemplate->assign('CUSTOMERNAME', $check_status['customers_name']); $vamTemplate->assign('EMAIL', $check_status['customers_email_address']); $vamTemplate->assign('GROUPNAME', $customers_groups_name); $vamTemplate->assign('GROUPDISCOUNT', $current_discount); $vamTemplate->assign('ACCUMULATED_LIMIT', $currencies->display_price($limit, 0)); //email to admin $html_mail_admin = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/accumulated_discount_admin.html'); $txt_mail_admin = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/accumulated_discount_admin.txt'); vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, STORE_OWNER_EMAIL_ADDRESS, STORE_OWNER, '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', EMAIL_ACC_SUBJECT, $html_mail_admin, $txt_mail_admin); //email to customer $html_mail_customer = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/accumulated_discount_customer.html'); $txt_mail_customer = $vamTemplate->fetch(CURRENT_TEMPLATE . '/admin/mail/' . $_SESSION['language'] . '/accumulated_discount_customer.txt'); vam_php_mail(EMAIL_BILLING_ADDRESS, EMAIL_BILLING_NAME, $check_status['customers_email_address'], $check_status['customers_name'], '', EMAIL_BILLING_REPLY_ADDRESS, EMAIL_BILLING_REPLY_ADDRESS_NAME, '', '', EMAIL_ACC_SUBJECT, $html_mail_customer, $txt_mail_customer); } } } // eof denuz added accumulated discount } if ($order_updated == true) { $messageStack->add_session(BUS_ORDER . $this_orderID . ' ' . BUS_SUCCESS, 'success');
$link_to = '<a href="orders.php?action=edit&oID=' . $affiliate_sales['affiliate_orders_id'] . '">' . $affiliate_sales['affiliate_orders_id'] . '</a>'; ?> <td class="dataTableContent"><?php echo $affiliate_sales['affiliate_firstname'] . " " . $affiliate_sales['affiliate_lastname']; ?> </td> <td class="dataTableContent" align="center"><?php echo vam_date_short($affiliate_sales['affiliate_date']); ?> </td> <td class="dataTableContent" align="right"><?php echo $link_to; ?> </td> <td class="dataTableContent" align="right"> <?php echo $currencies->display_price($affiliate_sales['affiliate_value'], ''); ?> </td> <td class="dataTableContent" align="right"><?php echo $affiliate_sales['affiliate_percent'] . "%"; ?> </td> <td class="dataTableContent" align="right"> <?php echo $currencies->display_price($affiliate_sales['affiliate_payment'], ''); ?> </td> <td class="dataTableContent" align="center"><?php if ($affiliate_sales['orders_status']) { echo $affiliate_sales['orders_status']; } else { echo TEXT_DELETED_ORDER_BY_ADMIN;
for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') { echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; } echo '</i></small></nobr>'; } } // BOF: Attributes Product Codes - If product code exists, use it, else default to product model. echo ' </td>' . "\n"; if (tep_not_null($order->products[$i]['code'])) { echo ' <td class="dataTableContent" valign="top">' . $order->products[$i]['code'] . '</td>' . "\n"; } else { echo ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n"; } echo ' <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->display_price($order->products[$i]['final_price'], 0, 1, $order->info['currency']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], 1, $order->info['currency']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->display_price($order->products[$i]['final_price'], 0, $order->products[$i]['qty'], $order->info['currency']) . '</b></td>' . "\n" . ' <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty'], $order->info['currency']) . '</b></td>' . "\n"; echo ' </tr>' . "\n"; } ?> <tr> <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { echo ' <tr>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" . ' <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" . ' </tr>' . "\n"; } ?> </table></td> </tr> </table></td> </tr> <tr>
echo '<tr class="dataTableRow">' . "\n"; echo '<td class="dataTableContent" align="right"><b>' . ADDPRODUCT_TEXT_STEP . ' 3: </b></td>' . "\n"; echo '<td class="dataTableContent" valign="top" colspan="2"><i>' . ADDPRODUCT_TEXT_OPTIONS_NOTEXIST . '</i></td>' . "\n"; echo '</tr>' . "\n"; $_POST['step'] = 4; } else { echo '<tr class="dataTableRow">' . tep_draw_form('addProduct', FILENAME_ORDERS_EDIT, 'oID=' . $_GET['oID'] . '&action=' . $_GET['action']) . "\n"; echo '<td class="dataTableContent" align="right"><b>' . ADDPRODUCT_TEXT_STEP . ' 3: </b></td><td class="dataTableContent" valign="top">'; $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $_POST['add_product_products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int) $languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $_POST['add_product_products_id'] . "' and pa.options_id = '" . (int) $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int) $languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array) - 1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . ') '; } } if (isset($_POST['add_product_options'])) { $selected_attribute = $_POST['add_product_options'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } echo $products_options_name['products_options_name'] . ':' . "\n"; echo tep_draw_pull_down_menu('add_product_options[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute) . '<br />' . "\n"; } echo '</td>'; echo '<td class="dataTableContent" align="center"><input type="submit" value="' . ADDPRODUCT_TEXT_OPTIONS_CONFIRM . '">'; echo '<input type="hidden" name="add_product_categories_id" value=' . $_POST['add_product_categories_id'] . '>'; echo '<input type="hidden" name="add_product_products_id" value=' . $_POST['add_product_products_id'] . '>'; echo '<input type="hidden" name="step" value="4">';
</tr> <tr> <td colspan="10"><?php echo zen_black_line(); ?> </td> </tr> <tr> <?php } else { // attributes display listing // calculate current total attribute price // $attributes_values $attributes_price_final = zen_get_attributes_price_final($attributes_values->fields["products_attributes_id"], 1, $attributes_values, 'false'); $attributes_price_final_value = $attributes_price_final; $attributes_price_final = $currencies->display_price($attributes_price_final, zen_get_tax_rate($product_check->fields['products_tax_class_id']), 1); $attributes_price_final_onetime = zen_get_attributes_price_final_onetime($attributes_values->fields["products_attributes_id"], 1, $attributes_values); $attributes_price_final_onetime = $currencies->display_price($attributes_price_final_onetime, zen_get_tax_rate($product_check->fields['products_tax_class_id']), 1); ?> <td class="smallText"> <?php echo $attributes_values->fields["products_attributes_id"]; ?> </td> <td class="smallText"> <?php // echo $products_name_only; ?> </td> <td class="smallText"> <?php echo $options_name; ?> </td>
</tr> <tr> <td colspan="10"><?php echo zen_black_line(); ?> </td> </tr> <tr> <?php } else { // attributes display listing // calculate current total attribute price // $attributes_values $attributes_price_final = zen_get_attributes_price_final($attributes_values->fields["products_attributes_id"], 1, $attributes_values, 'false'); $attributes_price_final_value = $attributes_price_final; $attributes_price_final = $currencies->display_price($attributes_price_final, zen_get_tax_rate(1), 1); $attributes_price_final_onetime = zen_get_attributes_price_final_onetime($attributes_values->fields["products_attributes_id"], 1, $attributes_values); $attributes_price_final_onetime = $currencies->display_price($attributes_price_final_onetime, zen_get_tax_rate(1), 1); ?> <td class="smallText"> <?php echo $attributes_values->fields["products_attributes_id"]; ?> </td> <td class="smallText"> <?php // echo $products_name_only; ?> </td> <td class="smallText"> <?php echo $options_name; ?> </td>
//loop all the products in the order $products_ordered_attributes = ''; // Raymond Burns not sure about code below. THIS SEEMS TO BE DEPRECATED CODE TO BE REMOVED if (isset($order->products[$i]['attributes']) && sizeof($order->products[$i]['attributes']) > 0) { for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) { $products_ordered_attributes .= "\n\t" . $order->products[$i]['attributes'][$j]['option'] . ' ' . $order->products[$i]['attributes'][$j]['value']; } } /* ** Altered for CCGV ** */ $total_weight += $order->products[$i]['qty'] * $order->products[$i]['weight']; $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; /* ** EOF alterations for CCGV ** */ if ($order->products[$i]['model']) { /* ** Altered for Mail Manager **/ $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n" . '<br />'; } else { $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n" . '<br />'; } /* ** EOF alteration for Mail Manager **/ } $Text_Billing_Adress = "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . $order->billing['name'] . "\n"; if ($order->billing['company']) { $Text_Billing_Adress .= $order->billing['company'] . "\n"; } $Text_Billing_Adress .= $order->billing['street_address'] . "\n"; if ($order->billing['suburb']) { $Text_Billing_Adress .= $order->billing['suburb'] . "\n"; } $Text_Billing_Adress .= $order->billing['city'] . "\n"; if ($order->billing['state']) {
} $affiliate_amount = $affiliate_sales['total']; if ($affiliate_transactions > 0) { $affiliate_average = tep_round($affiliate_amount / $affiliate_transactions, 2); } else { $affiliate_average = "n/a"; } $affiliate_commission = $affiliate_sales['payment']; $affiliates_raw = "select count(*) as count from " . TABLE_AFFILIATE . ""; $affiliates_raw_query = tep_db_query($affiliates_raw); $affiliates_raw = tep_db_fetch_array($affiliates_raw_query); $affiliate_number = $affiliates_raw['count']; $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_AFFILIATES); $contents[] = array('params' => 'class="infoBox"', 'text' => BOX_ENTRY_AFFILIATES . ' ' . $affiliate_number . '<br>' . BOX_ENTRY_CONVERSION . ' ' . $affiliate_conversions . '<br>' . BOX_ENTRY_COMMISSION . ' ' . $currencies->display_price($affiliate_commission, '')); $box = new box(); echo $box->menuBox($heading, $contents); echo '<br>'; // $contents = array(); if (getenv('HTTPS') == 'on') { $size = getenv('SSL_CIPHER_ALGKEYSIZE') ? getenv('SSL_CIPHER_ALGKEYSIZE') . '-bit' : '<i>' . BOX_CONNECTION_UNKNOWN . '</i>'; $contents[] = array('params' => 'class="infoBox"', 'text' => tep_image(DIR_WS_ICONS . 'locked.gif', ICON_LOCKED, '', '', 'align="right"') . sprintf(BOX_CONNECTION_PROTECTED, $size)); } else { $contents[] = array('params' => 'class="infoBox"', 'text' => tep_image(DIR_WS_ICONS . 'unlocked.gif', ICON_UNLOCKED, '', '', 'align="right"') . BOX_CONNECTION_UNPROTECTED); } $box = new box(); echo $box->tableBlock($contents); ?> </td>
break; default: if (is_object($aInfo)) { $heading[] = array('text' => HTML_B_START . $aInfo->affiliate_firstname . BLANK . $aInfo->affiliate_lastname . HTML_B_END); $contents[] = array('align' => 'center', 'text' => HTML_A_START . olc_href_link(FILENAME_AFFILIATE, olc_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id . '&action=edit') . '">' . olc_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . olc_href_link(FILENAME_AFFILIATE, olc_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id . '&action=confirm') . '">' . olc_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . olc_href_link(FILENAME_AFFILIATE_CONTACT, 'selected_box=affiliate&affiliate=' . $aInfo->affiliate_email_address) . '">' . olc_image_button('button_email.gif', IMAGE_EMAIL) . HTML_A_END); $affiliate_sales_raw = "select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from " . TABLE_AFFILIATE_SALES . " a left join " . TABLE_ORDERS . " o on (a.affiliate_orders_id=o.orders_id)\n where o.orders_status >= " . AFFILIATE_PAYMENT_ORDER_MIN_STATUS . " and affiliate_id = '" . $aInfo->affiliate_id . APOS; $affiliate_sales_values = olc_db_query($affiliate_sales_raw); $affiliate_sales = olc_db_fetch_array($affiliate_sales_values); $contents[] = array('text' => HTML_BR . TEXT_DATE_ACCOUNT_CREATED . BLANK . olc_date_short($aInfo->date_account_created)); $contents[] = array('text' => EMPTY_STRING . TEXT_DATE_ACCOUNT_LAST_MODIFIED . BLANK . olc_date_short($aInfo->date_account_last_modified)); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_DATE_LAST_LOGON . BLANK . olc_date_short($aInfo->date_last_logon)); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_NUMBER_OF_LOGONS . BLANK . $aInfo->number_of_logons); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_COMMISSION . BLANK . $aInfo->affiliate_commission_percent . ' %'); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_COUNTRY . BLANK . $aInfo->countries_name); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_NUMBER_OF_SALES . BLANK . $affiliate_sales['count'], EMPTY_STRING); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_SALES_TOTAL . BLANK . $currencies->display_price($affiliate_sales['total'], EMPTY_STRING)); $contents[] = array('text' => EMPTY_STRING . TEXT_INFO_AFFILIATE_TOTAL . BLANK . $currencies->display_price($affiliate_sales['payment'], EMPTY_STRING)); } break; } if (olc_not_null($heading) && olc_not_null($contents)) { echo ' <td width="25%" valign="top">' . NEW_LINE; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . NEW_LINE; } ?> </tr> </table></td> </tr> <?php
function b_specials() { global $currency, $currencies, $languages_id, $xoopsDB, $xoopsConfig, $customer_group, $customer_id, $_GET; /* if(!defined("XOSC_BLOCK") && !defined("XOSC_CONFIG")) { define("XOSC_BLOCK",1); require_once(XOOPS_ROOT_PATH."/modules/osC/includes/application_top.php"); } */ // Config Part require_once XOOPS_ROOT_PATH . "/modules/osC/includes/configure.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/database_tables.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/filenames.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/functions/database.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/functions/general.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/functions/html_output.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/classes/boxes.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/classes/currencies.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/classes/product.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/classes/customer_group.php"; require_once XOOPS_ROOT_PATH . "/modules/osC/includes/languages/" . $xoopsConfig['language'] . ".php"; //$currencies = new currencies(); if (!isset($customer_group)) { if (!isset($_SESSION['customer_id'])) { $customer_group = new customer_group(0); } else { $customer_group = new customer_group($_SESSION['customer_id']); } } if (!defined('XBLOCK_CONFIG')) { $configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION); while ($configuration = tep_db_fetch_array($configuration_query)) { define($configuration['cfgKey'], $configuration['cfgValue']); } define('XBLOCK_CONFIG', "1"); } if (!isset($_SESSION['languages_id'])) { $lang_query = "select languages_id from " . TABLE_LANGUAGES . " where directory ='" . $xoopsConfig['language'] . "'"; $lang = tep_db_query($lang_query); $lang_id = tep_db_fetch_array($lang); $languages_id = $lang_id['languages_id']; } else { $languages_id = $_SESSION['languages_id']; } // currency if (isset($_GET['currency'])) { $currency = $_GET['currency']; } if (!session_is_registered('currency') || isset($HTTP_GET_VARS['currency']) || USE_DEFAULT_LANGUAGE_CURRENCY == 'true' && LANGUAGE_CURRENCY != $currency) { if (!session_is_registered('currency')) { session_register('currency'); } if (isset($HTTP_GET_VARS['currency'])) { if (!($currency = tep_currency_exists($HTTP_GET_VARS['currency']))) { $currency = USE_DEFAULT_LANGUAGE_CURRENCY == 'true' ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } } else { $currency = USE_DEFAULT_LANGUAGE_CURRENCY == 'true' ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } } if ($currency == '') { if (!($currency = tep_currency_exists($HTTP_GET_VARS['currency']))) { $currency = USE_DEFAULT_LANGUAGE_CURRENCY == 'true' ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } } //$currencies = new currencies(); if (!isset($currencies) || !is_object($currencies)) { $currencies = new currencies(); } //echo "CUR:".$currencies.":".$currency; //print_r($currencies); // Box Part if ($random_product = tep_random_select("select p.products_distributor_id,p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int) $languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) { $sproduct = new product($random_product["products_id"]); $add_text = ''; if ($customer_group->getdisplaytax() == '1') { $add_text = '<br>' . TEXT_VAT_INFO . ' ' . $sproduct->get_tax() . ' % ' . $sproduct->get_tax_title(); } if ($customer_group->getdisplayshipment() == '1') { $add_text .= '<br>' . TEXT_SHIPPING_HANDLING_INFO; } $image_path = DIR_WS_IMAGES; switch ($random_product['products_distributor_id']) { case 1: $image_path = 'http://ec.ingrammicro.de/jpg/'; break; case 2: $image_path = ''; break; } $info_box_contents = array(); $info_box_contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product["products_id"]) . '">' . tep_image($image_path . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br><s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span>' . $add_text); $block = new infoBox($info_box_contents); } return $block->content; }
$total_tax = 0; // eof order editor 5 0 9 for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { //loop all the products in the order $products_ordered_attributes = ''; if (isset($order->products[$i]['attributes']) && sizeof($order->products[$i]['attributes']) > 0) { for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) { $products_ordered_attributes .= "\n\t" . $order->products[$i]['attributes'][$j]['option'] . ' ' . $order->products[$i]['attributes'][$j]['value']; } } $total_weight += $order->products[$i]['qty'] * $order->products[$i]['weight']; $total_tax += tep_calculate_tax($total_products_price, $products_tax) * $order->products[$i]['qty']; $total_cost += $total_products_price; if (EMAIL_USE_HTML == 'true') { if ($order->products[$i]['model']) { $products_ordered .= $order_totals_zelle_beginn . $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $order_totals_zelle_mitte . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . $order_totals_zelle_end; } else { $products_ordered .= $order_totals_zelle_beginn . $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' = ' . $order_totals_zelle_mitte . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . $order_totals_zelle_end; } } else { if ($order->products[$i]['model']) { $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' (' . $order->products[$i]['model'] . ') = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n"; } else { $products_ordered .= $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n"; } } } $Text_Billing_Adress = "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . $order->billing['name'] . "\n"; if ($order->billing['company']) { $Text_Billing_Adress .= $order->billing['company'] . "\n"; }
<td class="dataTableContent"></td> <td class="dataTableContent"></td> <td class="dataTableContent" align="center"><b><?php echo $totalquantity; ?> </b> </td> <?php if ($show_breakdown == 'on') { ?> <td class="dataTableContent"></td> <?php } ?> <td class="dataTableContent" align="right"><b><?php echo TEXT_TOTAL . ' '; echo $currencies->display_price($totalgross, '', 1); ?> </b> </td> </tr> <?php } ?> </table> </td> </tr> </table> </td> </tr> </table> </form> </td>
<td align="right" class="dataTableContent"><?php echo TEXT_CONVERSION; ?> </td> <td align="left" class="dataTableContent"><?php echo $affiliate_conversions; ?> </td> </tr> <tr> <td align="right" class="dataTableContent"><?php echo TEXT_AMOUNT; ?> </td> <td align="left" class="dataTableContent"><?php echo $currencies->display_price($affiliate_amount, ''); ?> </td> <td align="right" class="dataTableContent"><?php echo TEXT_AVERAGE; ?> </td> <td align="left" class="dataTableContent"><?php echo $currencies->display_price($affiliate_average, ''); ?> </td> </tr> <tr> <td align="right" class="dataTableContent"><?php echo TEXT_COMMISSION_RATE; ?>
function replace_status_email($oID, $comments, $email_template_id) { require_once 'includes/classes/currencies.php'; $currencies = new currencies(); //オーダー情報の取得 require_once 'includes/classes/order.php'; $order = new order($oID); //============ 以下、予約語を置換 ============ $comments = str_replace('[CUSTOMER_NAME]', stripslashes($order->customer['name']), $comments); $comments = str_replace('[ORDER_ID]', stripslashes($oID), $comments); if ($email_template_id != MODULE_EMAIL_TEMPLATE_CHECKOUT_SUCCESS_VISITOR_MAIL_ID) { if (function_exists('zen_visitors_purchase_is_visitors_order') && zen_visitors_purchase_is_visitors_order($oID)) { $invoice_url = ''; } elseif (function_exists('zen_catalog_href_link')) { $invoice_url = zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL'); $invoice_url = MODULE_EMAIL_TEMPLATE_INVOICE_TEXT . "\n" . $invoice_url; } else { $invoice_url = zen_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL', false); } $comments = str_replace('[INVOICE_URL]', $invoice_url, $comments); } // insert comments if status changed if ($email_template_id != MODULE_EMAIL_TEMPLATE_CHECKOUT_SUCCESS_MAIL_ID && $email_template_id != MODULE_EMAIL_TEMPLATE_CHECKOUT_SUCCESS_VISITOR_MAIL_ID) { if ($_POST['notify_comments'] == 'on') { $notify_comments = stripslashes($_POST['comments']); } else { $notify_comments = ''; } $comments = str_replace('[COMMENTS]', $notify_comments, $comments); } // products $products_ordered = ""; for ($i = 0, $n = count($order->products); $i < $n; $i++) { $products_ordered_attributes = ''; for ($j = 0; $j < count($order->products[$i]['attributes']); $j++) { $products_ordered_attributes .= "\n\t" . $order->products[$i]['attributes'][$j]['option'] . ' ' . $order->products[$i]['attributes'][$j]['value']; } $products_ordered .= $order->products[$i]['name'] . ($order->products[$i]['model'] != '' ? ' (' . $order->products[$i]['model'] . ') ' : '') . $order->products[$i]['qty'] . '点 ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . ($order->products[$i]['onetime_charges'] != 0 ? "\n" . TEXT_ONETIME_CHARGES_EMAIL . $currencies->display_price($order->products[$i]['onetime_charges'], $order->products[$i]['tax'], 1) : '') . $products_ordered_attributes . "\n"; } $comments = str_replace('[PRODUCTS_ORDERED]', stripslashes($products_ordered), $comments); // totals $totals = ''; for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { $totals .= strip_tags($order->totals[$i]['title']) . ' ' . strip_tags($order->totals[$i]['text']) . "\n"; } $comments = str_replace('[TOTALS]', stripslashes($totals), $comments); $billing_address = zen_address_format($order->billing['format_id'], $order->billing, 0, '', "\n"); $comments = str_replace('[BILLING_ADDRESS]', stripslashes($billing_address), $comments); if (isset($GLOBALS['phpmailer']['content_type']) && $GLOBALS['phpmailer']['content_type'] != 'virtual') { $delivery_address = stripslashes(zen_address_format($order->delivery['format_id'], $order->delivery, 0, '', "\n")); } else { $delivery_address = MODULE_EMAIL_TEMPLATE_NOT_DELIVERY; } $comments = str_replace('[DELIVERY_ADDRESS]', $delivery_address, $comments); $comments = str_replace('[PAYMENT_METHOD]', stripslashes($order->info['payment_method']), $comments); $date_ordered = strftime(MODULE_EMAIL_TEMPLATE_DATE_FORMAT_LONG, strtotime($order->info['date_purchased'])); $weekday = array(MODULE_EMAIL_TEMPLATE_SUN, MODULE_EMAIL_TEMPLATE_MON, MODULE_EMAIL_TEMPLATE_TUE, MODULE_EMAIL_TEMPLATE_WED, MODULE_EMAIL_TEMPLATE_THU, MODULE_EMAIL_TEMPLATE_FRI, MODULE_EMAIL_TEMPLATE_SAT); $date_ordered .= $weekday[strftime('%w', strtotime($order->info['date_purchased']))]; $comments = str_replace('[DATE_ORDERED]', $date_ordered, $comments); // insert orderd comment if ($email_template_id == MODULE_EMAIL_TEMPLATE_CHECKOUT_SUCCESS_MAIL_ID || $email_template_id == MODULE_EMAIL_TEMPLATE_CHECKOUT_SUCCESS_VISITOR_MAIL_ID) { if (!empty($GLOBALS['phpmailer']['comments'])) { $order_comments = stripslashes($GLOBALS['phpmailer']['comments']); } else { $order_comments = ''; } $comments = str_replace('[COMMENT]', $order_comments, $comments); } return $comments; }
// # Send Confirmation if (isset($_POST['send_confirmation'])) { $order = new order($oID); $products_ordered = ''; $products_ordered_html = ''; $attributes_exist = '0'; $products_ordered_attributes = ''; foreach ($order->products as $product) { //$products_ordered.=sprintf("%2d x %s\n",$product['qty'],$product['name']); if (isset($product['attributes'])) { $attributes_exist = '1'; for ($j = 0, $n2 = sizeof($product['attributes']); $j < $n2; $j++) { $products_ordered_attributes .= "\n\t" . $product['attributes'][$j]['option'] . ' ' . $product['attributes'][$j]['value']; } } $products_ordered .= $product['qty'] . ' x ' . $product['name'] . ' (' . $product['model'] . ') = ' . $currencies->display_price($product['final_price'], $product['tax'], $product['qty']) . $products_ordered_attributes . "\n"; $products_ordered_html .= '<table width="100%"><tr><td align="center" style="width:40px; font:normal 12px arial; text-align:center;">x' . $product['qty'] . '</td><td align="left" style="width:235px; padding-left:10px; font:normal 12px arial;">' . $product['name'] . '</td><td style="width:68px; font:normal 12px arial;">' . $product['model'] . '</td><td align="left" style="width:63px; font:normal 12px arial;">' . $products_ordered_attributes . '</td><td align="left" style="width:69px; font:normal 12px arial;">' . $currencies->display_price($product['final_price'], $product['tax'], $product['qty']) . '</td></tr></table><br>' . "\n"; } // # Order Total label $ot_title_wd = 0; $ot_text_wd = 0; $ot_label_text = array(); $ot_label_html = array(); $order_totals = array(); $ot_query = tep_db_query("SELECT * FROM " . TABLE_ORDERS_TOTAL . " WHERE orders_id='{$oID}' ORDER BY sort_order"); while ($order_totals_row = tep_db_fetch_array($ot_query)) { $order_totals[] = $order_totals_row; } foreach ($order_totals as $idx => $ot) { $ot_txt = array(); $ot_title_wd = max($ot_title_wd, strlen($order_totals[$idx]['strip_title'] = preg_replace('/<.*?>/', '', $ot['title'])));
?> "> <img src="<?php echo DIR_WS_IMAGES . $data[$i]['products_image']; ?> " class="img-responsive img-thumbnail" alt="<?php echo $data[$i]['products_name']; ?> "> </a> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $data[$i]['products_id']); ?> "> <h4><?php echo $data[$i]['products_name']; ?> </h4> </a> <span class="text-center"> <?php echo $currencies->display_price($data[$i]['products_price'], tep_get_tax_rate($data[$i]['products_tax_class_id'])); ?> </span> </div> <?php } ?> </div> </div> </div>
?> </td> <td class="dataTableContent" align="center" valign="middle"> <label onmouseover="this.style.cursor='pointer'; this.style.cursor='hand'"> <input onmouseover="this.style.cursor='pointer'; this.style.cursor='hand'" checked="checked" size="20" name="xsell_id[]" type="checkbox" value="<?php echo $PRODUCTS_id[0]; ?> ">Cross-sell</label> </td> <td class="dataTableContent"><?php echo $PRODUCTS_name[0]; ?> </td> <td class="dataTableContent"><?php echo $currencies->display_price($PRODUCTS_price[0], olc_get_tax_rate($product_info_values['products_tax_class_id'])); ?> </td> </tr> <?php } } $query = 'select distinct b.language_id, a.products_id, b.products_name, b.products_description, a.products_quantity, a.products_model, a.products_image, b.products_url, a.products_price FROM ' . TABLE_PRODUCTS . ' a, ' . TABLE_PRODUCTS_DESCRIPTION . ' b, products_to_categories p2c WHERE b.products_id=a.products_id and b.language_id = "' . $languages_id . '" AND a.products_id=p2c.products_id ' . ($CATEGORIES_id ? ' and p2c.categories_id="' . $CATEGORIES_id . '" ' : '') . ($MANUFACTURES_id ? ' and a.manufacturers_id="' . $MANUFACTURES_id . '" ' : '') . ' and a.products_id != "' . $add_related_product_ID . '" ORDER BY b.products_name'; list($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description, $PRODUCTS_quantity, $PRODUCTS_model, $PRODUCTS_image, $PRODUCTS_url, $PRODUCTS_price) = general_db_conct($query); if ($PRODUCTS_id) { ?> <tr bgcolor='#FFFFFF'><td colspan=6>List of products for adding in Cross-Sell (X-Sell). Please check it...</td></tr> <?php $num_of_products = sizeof($PRODUCTS_id); for ($i = 0; $i < $num_of_products; $i++) {
break; default: if (is_object($aInfo)) { $heading[] = array('text' => '<b>' . $aInfo->affiliate_firstname . ' ' . $aInfo->affiliate_lastname . '</b>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_AFFILIATE, tep_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_AFFILIATE, tep_get_all_get_params(array('acID', 'action')) . 'acID=' . $aInfo->affiliate_id . '&action=confirm') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_AFFILIATE_CONTACT, 'selected_box=affiliate&affiliate=' . $aInfo->affiliate_email_address) . '">' . tep_image_button('button_email.gif', IMAGE_EMAIL) . '</a>'); $affiliate_sales_raw = "select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from " . TABLE_AFFILIATE_SALES . " a left join " . TABLE_ORDERS . " o on (a.affiliate_orders_id=o.orders_id) where o.orders_status >= " . AFFILIATE_PAYMENT_ORDER_MIN_STATUS . " and affiliate_id = '" . $aInfo->affiliate_id . "'"; $affiliate_sales_values = tep_db_query($affiliate_sales_raw); $affiliate_sales = tep_db_fetch_array($affiliate_sales_values); $contents[] = array('text' => '<br>' . TEXT_DATE_ACCOUNT_CREATED . ' ' . tep_date_short($aInfo->date_account_created)); $contents[] = array('text' => '' . TEXT_DATE_ACCOUNT_LAST_MODIFIED . ' ' . tep_date_short($aInfo->date_account_last_modified)); $contents[] = array('text' => '' . TEXT_INFO_DATE_LAST_LOGON . ' ' . tep_date_short($aInfo->date_last_logon)); $contents[] = array('text' => '' . TEXT_INFO_NUMBER_OF_LOGONS . ' ' . $aInfo->number_of_logons); $contents[] = array('text' => '' . TEXT_INFO_COMMISSION . ' ' . $aInfo->affiliate_commission_percent . ' %'); $contents[] = array('text' => '' . TEXT_INFO_COUNTRY . ' ' . $aInfo->countries_name); $contents[] = array('text' => '' . TEXT_INFO_NUMBER_OF_SALES . ' ' . $affiliate_sales['count'], ''); $contents[] = array('text' => '' . TEXT_INFO_SALES_TOTAL . ' ' . $currencies->display_price($affiliate_sales['total'], '')); $contents[] = array('text' => '' . TEXT_INFO_AFFILIATE_TOTAL . ' ' . $currencies->display_price($affiliate_sales['payment'], '')); } break; } if (tep_not_null($heading) && tep_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> <?php
echo '<a href="javascript:popupWindow(\'' . (HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_HELP_4) . '\')">' . TEXT_SUMMARY_HELP . '</a>'; ?> </td> <td width="15%" class="dataTableContent"><?php echo $affiliate_conversions . ' %'; ?> </td> </tr> <tr> <td width="35%" align="right" class="dataTableContent"><?php echo TEXT_AMOUNT; echo '<a href="javascript:popupWindow(\'' . (HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_HELP_5) . '\')">' . TEXT_SUMMARY_HELP . '</a>'; ?> </td> <td width="15%" class="dataTableContent"><?php echo $currencies->display_price($affiliate_sales['total'], ''); ?> </td> <td width="35%" align="right" class="dataTableContent"><?php echo TEXT_AVERAGE; echo '<a href="javascript:popupWindow(\'' . (HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_HELP_6) . '\')">' . TEXT_SUMMARY_HELP . '</a>'; ?> </td> <td width="15%" class="dataTableContent"><?php echo $currencies->display_price($affiliate_average, ''); ?> </td> </tr> <tr> <td width="35%" align="right" class="dataTableContent"><?php echo TEXT_COMMISSION_RATE;
<?php $lang = getSiteLanguage(); $currencies = new currencies(); $query = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . $lang['id'] . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS; if ($random_product = tep_random_select($query)) { if (USE_PRICES_TO_QTY == 'false' && PRICE_BOOK == 'true') { //added here so this can be used add the whole page $discount_price = tep_get_discountprice($random_product['products_price'], $customer_id, $customer_group, $random_product['products_id'], $cPath, $random_product['manufacturers_id']); } $oldPrice = 0; $newPrice = 0; if ($discount_price['lowest']['discount'] > 0 && PRICE_BOOK == 'true') { if ($new_price = tep_get_products_special_price($random_product['products_id'])) { if ($new_price < $discount_price['lowest']['price']) { $oldPrice = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])); $newPrice = $currencies->display_price($new_price, tep_get_tax_rate($random_product['products_tax_class_id'])); } else { $oldPrice = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])); $newPrice = $currencies->display_price($discount_price['lowest']['price'], tep_get_tax_rate($random_product['products_tax_class_id'])); } } else { $oldPrice = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])); $newPrice = $currencies->display_price($discount_price['lowest']['price'], tep_get_tax_rate($random_product['products_tax_class_id'])); } } else { if ($new_price = tep_get_products_special_price($random_product['products_id'])) { $oldPrice = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])); $newPrice = $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])); } else { $newPrice = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id']));