function dibspayment_paywin_order_params($cart)
{
global $wpdb;
$order_data = array();
$purchase_log = $wpdb->get_results("SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `sessionid`= " . $cart->sessionid . " LIMIT 1", ARRAY_A);
$currency_code = $wpdb->get_results("SELECT `code` FROM `" . WPSC_TABLE_CURRENCY_LIST . "` WHERE `id`='" . get_option('currency_type') . "' LIMIT 1", ARRAY_A);
// Set status on new order
$wpdb->query("UPDATE `" . WPSC_TABLE_PURCHASE_LOGS . "` SET `processed` = '" . get_option('dibspw_statusp') . "' WHERE `sessionid` = '" . $cart->sessionid . "' LIMIT 1;");
// collect data for request
$order_data['orderid'] = $purchase_log[0]['id'];
$order_data['merchant'] = get_option('dibspw_mid');
$order_data['amount'] = dibspayment_paywin_round($cart->total_price);
$order_data['currency'] = $currency_code[0]['code'];
$order_data['language'] = get_option('dibspw_lang');
$order_data['oitypes'] = 'QUANTITY;UNITCODE;DESCRIPTION;AMOUNT;ITEMID;VATAMOUNT';
$order_data['oinames'] = 'Qty;UnitCode;Description;Amount;ItemId;VatAmount';
$order_data['oinames'] = 'Qty;UnitCode;Description;Amount;ItemId;VatAmount';
$wpec_taxes_c = new wpec_taxes_controller();
//$tax_total = $wpec_taxes_c->wpec_taxes_calculate_total();
//get the rate for the country and region if set
$tax_total = $wpec_taxes_c->wpec_taxes->wpec_taxes_get_rate($wpec_taxes_c->wpec_taxes_retrieve_selected_country(), $wpec_taxes_c->wpec_taxes_retrieve_region());
// cart items
$i = 1;
foreach ($cart->cart_items as $oitem) {
$tmp_price = dibspayment_paywin_round($oitem->unit_price);
if (!empty($tmp_price)) {
$unit_price = $oitem->unit_price;
$tax['tax'] = 0;
if ($wpec_taxes_c->wpec_taxes->wpec_taxes_get_enabled() && $tax_total['rate']) {
if ($wpec_taxes_c->wpec_taxes_isincluded()) {
$tax = $wpec_taxes_c->wpec_taxes_calculate_included_tax($oitem);
$tax['tax'] = $tax['tax'] / $oitem->quantity;
$unit_price = $oitem->unit_price - $tax['tax'];
} else {
$tax['tax'] = $unit_price * ($tax_total['rate'] / 100);
}
}
$tmp_name = !empty($oitem->product_name) ? $oitem->product_name : $oitem->sku;
if (empty($tmp_name)) {
$tmp_name = $oitem->product_id;
}
$order_data['oiRow' . $i++] = dibspayment_paywin_oirow_str($oitem->quantity, dibspayment_paywin_utf8Fix(str_replace(";", "\\;", $tmp_name)), dibspayment_paywin_round($unit_price), dibspayment_paywin_utf8Fix(str_replace(";", "\\;", $oitem->product_id)), dibspayment_paywin_round($tax['tax']));
}
unset($tmp_price, $tmp_name);
}
// Shipping calculation
if ($cart->calculate_total_shipping()) {
$shipping_tax = 0;
$fRate = $cart->calculate_total_shipping();
if ($tax_total['shipping'] && $wpec_taxes_c->wpec_taxes->wpec_taxes_get_enabled()) {
if ($wpec_taxes_c->wpec_taxes_isincluded()) {
$shipping_tax = $wpec_taxes_c->wpec_taxes_calculate_tax($cart->calculate_total_shipping(), $tax_total['rate'], false);
$fRate = $fRate - $shipping_tax;
} else {
$shipping_tax = $wpec_taxes_c->wpec_taxes_calculate_tax($cart->calculate_total_shipping(), $tax_total['rate']);
}
}
$order_data['oiRow' . $i++] = dibspayment_paywin_oirow_str(1, "Shipping", dibspayment_paywin_round($fRate), "shipping_0", dibspayment_paywin_round($shipping_tax));
}
// Cupone if it is avaliable
if ($cart->coupons_amount > 0) {
$order_data['oiRow' . $i++] = dibspayment_paywin_oirow_str(1, "Coupon", -dibspayment_paywin_round($cart->coupons_amount), "coupon_0", 0);
}
// Address fields here..
$aAddr = $_POST['collected_data'];
$order_data['shippingfirstname'] = $aAddr[get_option('dibspw_form_first_name_d')];
$order_data['shippinglastname'] = $aAddr[get_option('dibspw_form_last_name_d')];
$order_data['shippingpostalcode'] = $aAddr[get_option('dibspw_form_post_code_d')];
$order_data['shippingpostalplace'] = $aAddr[get_option('dibspw_form_city_d')];
//$order_data['shippingaddress2'] = $aAddr[get_option('dibspw_form_address_d')];
$order_data['shippingaddress'] = $aAddr[get_option('dibspw_form_country_d')] . " " . $aAddr[get_option('dibspw_form_state_d')];
$order_data['billingfirstname'] = $aAddr[get_option('dibspw_form_first_name_b')];
$order_data['billinglastname'] = $aAddr[get_option('dibspw_form_last_name_b')];
$order_data['billingpostalcode'] = $aAddr[get_option('dibspw_form_post_code_b')];
$order_data['billingpostalplace'] = $aAddr[get_option('dibspw_form_city_b')];
$order_data['billingaddress'] = $aAddr[get_option('dibspw_form_address_b')];
//$order_data['billingaddress'] = $aAddr[get_option('dibspw_form_country_b')]. " " .
// $aAddr[get_option('dibspw_form_state_b')];
$order_data['billingmobile'] = $aAddr[get_option('dibspw_form_phone_b')];
$order_data['billingemail'] = $aAddr[get_option('dibspw_form_email_b')];
$order_data['acceptreturnurl'] = get_option('siteurl') . "/?dibspw_result=success";
$order_data['cancelreturnurl'] = site_url() . "/?dibspw_result=cancel";
$order_data['callbackurl'] = get_option('siteurl') . "/?dibspw_result=callback";
$order_data['s_callbackfix'] = get_option('siteurl') . "/?dibspw_result=callback";
$order_data['s_sysmod'] = DIBS_SYSMOD;
if (get_option('dibspw_testmode')) {
$order_data['test'] = 1;
}
if (get_option('dibspw_capturenow')) {
$order_data['capturenow'] = 1;
}
if (get_option('dibspw_fee')) {
$order_data['addfee'] = 1;
}
$order_data['s_pid'] = $cart->sessionid;
if (get_option('dibspw_account')) {
$order_data['account'] = get_option('dibspw_account');
}
if (get_option('dibspw_paytype')) {
$order_data['paytype'] = get_option('dibspw_paytype');
}
if (get_option('dibspw_pid')) {
$order_data['s_partnerid'] = get_option('dibspw_pid');
}
if ($hmac = get_option('dibspw_hmac')) {
$order_data['MAC'] = dibspayment_paywin_calc_mac($order_data, $hmac, $bUrlDecode = FALSE);
}
return $order_data;
}
/**
* save to database method
* @access public
*
* @param integer purchase log id
*/
function save_to_db($purchase_log_id)
{
global $wpdb, $wpsc_shipping_modules;
$method = $this->cart->selected_shipping_method;
$shipping = 0;
if (!empty($method) && method_exists($wpsc_shipping_modules[$method], "get_item_shipping")) {
$shipping = $wpsc_shipping_modules[$this->cart->selected_shipping_method]->get_item_shipping($this);
}
if ($this->cart->has_total_shipping_discount()) {
$shipping = 0;
}
$shipping = apply_filters('wpsc_item_shipping_amount_db', $shipping, $this);
//initialize tax variables
$tax = 0;
$tax_rate = 0;
//wpec_taxes - calculate product tax and add to total price
$wpec_taxes_controller = new wpec_taxes_controller();
if ($wpec_taxes_controller->wpec_taxes_isincluded() && $wpec_taxes_controller->wpec_taxes_isenabled()) {
$taxes = $wpec_taxes_controller->wpec_taxes_calculate_included_tax($this);
$tax_rate = $taxes['rate'];
$tax = $taxes['tax'];
}
$wpdb->insert(WPSC_TABLE_CART_CONTENTS, array('prodid' => $this->product_id, 'name' => $this->get_title(), 'purchaseid' => $purchase_log_id, 'price' => $this->unit_price, 'pnp' => $shipping, 'tax_charged' => $tax, 'gst' => $tax_rate, 'quantity' => $this->quantity, 'donation' => $this->is_donation, 'no_shipping' => 0, 'custom_message' => $this->custom_message, 'files' => serialize($this->custom_file), 'meta' => NULL), array('%d', '%s', '%d', '%f', '%f', '%f', '%f', '%s', '%d', '%d', '%s', '%s', '%s'));
$cart_id = $wpdb->get_var("SELECT " . $wpdb->insert_id . " AS `id` FROM `" . WPSC_TABLE_CART_CONTENTS . "` LIMIT 1");
wpsc_update_cartmeta($cart_id, 'sku', $this->sku);
$downloads = get_option('max_downloads');
if ($this->is_downloadable == true) {
$product_files = (array) get_posts(array('post_type' => 'wpsc-product-file', 'post_parent' => $this->product_id, 'numberposts' => -1, 'post_status' => 'inherit'));
foreach ($product_files as $file) {
// if the file is downloadable, check that the file is real
$unique_id = sha1(uniqid(mt_rand(), true));
$wpdb->insert(WPSC_TABLE_DOWNLOAD_STATUS, array('product_id' => $this->product_id, 'fileid' => $file->ID, 'purchid' => $purchase_log_id, 'cartid' => $cart_id, 'uniqueid' => $unique_id, 'downloads' => $downloads, 'active' => 0, 'datetime' => date('Y-m-d H:i:s')), array('%d', '%d', '%d', '%d', '%s', '%s', '%d', '%s'));
$download_id = $wpdb->get_var("SELECT " . $wpdb->insert_id . " AS `id` FROM `" . WPSC_TABLE_DOWNLOAD_STATUS . "` LIMIT 1");
wpsc_update_meta($download_id, '_is_legacy', 'false', 'wpsc_downloads');
}
}
do_action('wpsc_save_cart_item', $cart_id, $this->product_id);
}
/**
* save to database method
* @access public
*
* @param integer purchase log id
*/
function save_to_db($purchase_log_id)
{
global $wpdb, $wpsc_shipping_modules;
$method = $this->cart->selected_shipping_method;
$shipping = 0;
if (!empty($method) && method_exists($wpsc_shipping_modules[$method], "get_item_shipping")) {
$shipping = $wpsc_shipping_modules[$this->cart->selected_shipping_method]->get_item_shipping($this);
}
if ($this->cart->has_total_shipping_discount()) {
$shipping = 0;
}
//initialize tax variables
$tax = 0;
$tax_rate = 0;
//wpec_taxes - calculate product tax and add to total price
$wpec_taxes_controller = new wpec_taxes_controller();
if ($wpec_taxes_controller->wpec_taxes_isincluded() && $wpec_taxes_controller->wpec_taxes_isenabled()) {
$taxes = $wpec_taxes_controller->wpec_taxes_calculate_included_tax($this);
$tax_rate = $taxes['rate'];
$tax = $taxes['tax'];
}
$wpdb->query($wpdb->prepare("INSERT INTO `" . WPSC_TABLE_CART_CONTENTS . "` (\n `prodid`, `name`, `purchaseid`, `price`, `pnp`,\n `tax_charged`, `gst`, `quantity`, `donation`,\n `no_shipping`, `custom_message`, `files`, `meta`\n ) VALUES ('%d', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%d', '0', '%s', '%s', NULL)", $this->product_id, $this->product_name, $purchase_log_id, $this->unit_price, (double) $shipping, (double) $tax, (double) $tax_rate, $this->quantity, $this->is_donation, $this->custom_message, serialize($this->custom_file)));
$cart_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `" . WPSC_TABLE_CART_CONTENTS . "` LIMIT 1");
wpsc_update_cartmeta($cart_id, 'sku', $this->sku);
$downloads = get_option('max_downloads');
if ($this->is_downloadable == true) {
$product_files = (array) get_posts(array('post_type' => 'wpsc-product-file', 'post_parent' => $this->product_id, 'numberposts' => -1, 'post_status' => 'inherit'));
foreach ($product_files as $file) {
// if the file is downloadable, check that the file is real
$unique_id = sha1(uniqid(mt_rand(), true));
$wpdb->query("INSERT INTO `" . WPSC_TABLE_DOWNLOAD_STATUS . "` (\n `product_id` , `fileid` ,\n `purchid` , `cartid`,\n `uniqueid`, `downloads`,\n `active` , `datetime`\n ) VALUES (\n '{$this->product_id}', '{$file->ID}',\n '{$purchase_log_id}', '{$cart_id}',\n '{$unique_id}', '{$downloads}',\n '0', NOW()\n );");
$download_id = $wpdb->get_var("SELECT LAST_INSERT_ID() AS `id` FROM `" . WPSC_TABLE_DOWNLOAD_STATUS . "` LIMIT 1");
wpsc_update_meta($download_id, '_is_legacy', 'false', 'wpsc_downloads');
}
}
do_action('wpsc_save_cart_item', $cart_id, $this->product_id);
}
