/**
* transaction_results function main function for creating the purchase reports, transaction results page, and email receipts
* @access public
*
* @since 3.7
* @param $sessionid (string) unique session id
* @param echo_to_screen (boolean) whether to output the results or return them (potentially redundant)
* @param $transaction_id (int) the transaction id
*/
function transaction_results($sessionid, $display_to_screen = true, $transaction_id = null)
{
global $message_html, $echo_to_screen, $purchase_log;
// pre-3.8.9 variable
$echo_to_screen = $display_to_screen;
$purchase_log_object = new WPSC_Purchase_Log($sessionid, 'sessionid');
// compatibility with pre-3.8.9 templates where they use a global
// $purchase_log object which is simply just a database row
$purchase_log = $purchase_log_object->get_data();
// pre-3.8.9 templates also use this global variable
$message_html = wpsc_get_transaction_html_output($purchase_log_object);
do_action('wpsc_transaction_results_shutdown', $purchase_log_object, $sessionid, $display_to_screen);
return $message_html;
}
function wpsc_purchlog_edit_status($purchlog_id = '', $purchlog_status = '')
{
global $wpdb;
if (empty($purchlog_id) && empty($purchlog_status)) {
$purchlog_id = absint($_POST['id']);
$purchlog_status = absint($_POST['new_status']);
}
$purchase_log = new WPSC_Purchase_Log($purchlog_id);
//in the future when everyone is using the 2.0 merchant api, we should use the merchant class to update the staus,
// then you can get rid of this hook and have each person overwrite the method that updates the status.
do_action('wpsc_edit_order_status', array('purchlog_id' => $purchlog_id, 'purchlog_data' => $purchase_log->get_data(), 'new_status' => $purchlog_status));
$result = wpsc_update_purchase_log_status($purchlog_id, $purchlog_status);
wpsc_clear_stock_claims();
return $result;
}
/**
* Pushes sales data back to Baikonur
*
* Only pushes once. Accounts for annoying potential edge case of status-switching admins
*
* @param WPSC_Purchase_Log object $purchase_log Purchase Log object
* @return void
*/
public static function push_sales_data($purchase_log_id, $current_status, $old_status, $purchase_log)
{
$purchase_log = new WPSC_Purchase_Log($purchase_log_id);
$id = absint($purchase_log->get('id'));
//Also checking is_order_received, as that's what Manual Payments do.
if ($purchase_log->is_transaction_completed() || $purchase_log->is_order_received()) {
$pushed_to_sass = wpsc_get_meta($id, '_pushed_to_wpeconomy', 'purchase_log');
if (empty($pushed_to_saas)) {
$data = $purchase_log->get_data();
$cart_contents = $purchase_log->get_cart_contents();
//We want to push sales data - but naturally, IDs will differ, even names could potentially.
//So we add the slug to the object we POST
foreach ($cart_contents as $key => $cart_item) {
$slug = get_post_field('post_name', $cart_item->prodid);
$cart_contents[$key]->slug = $slug;
}
$args = array('body' => array('data' => json_encode($data), 'cart_contents' => json_encode($cart_contents)));
$request = wp_remote_post('http://www.wpeconomy.org/?sales_data=true', $args);
$response = wp_remote_retrieve_response_code($request);
//For some reason, if the site is down, we want the ability to ensure we can grab the sale later.
$success = 200 === $response;
wpsc_update_meta($id, '_pushed_to_wpeconomy', $success, 'purchase_log');
}
}
}
function do_export_file()
{
global $wpdb;
$trnsid = 1;
$gateway_accounts = get_option('pbci_gateway_accounts', array());
$export_accounts = get_option('pbci_export_accounts', array('sales_revenue' => 'Product Revenue', 'shipping' => 'Shipping', 'sales_tax_account' => 'Sales Tax Payable', 'sales_tax_payee' => 'Sales Tax'));
$cust = array('NAME' => '', 'FIRSTNAME' => '', 'LASTNAME' => '', 'EMAIL' => '', 'PHONE1' => '', 'BADDR1' => '', 'BADDR2' => '', 'BADDR3' => '', 'BADDR4' => '', 'SADDR1' => '', 'SADDR2' => '', 'SADDR3' => '', 'SADDR4' => '');
$trans = array('TRNSID' => '', 'TRNSTYPE' => '', 'DATE' => '', 'ACCNT' => '', 'AMOUNT' => '', 'NAME' => '', 'MEMO' => '', 'PAYMETH' => '');
$spl = array('SPLID' => '', 'TRNSTYPE' => '', 'DATE' => '', 'ACCNT' => '', 'AMOUNT' => '', 'NAME' => '', 'MEMO' => '', 'INVITEM' => '', 'PRICE' => '', 'EXTRA' => '');
$content = "";
$cust_content = "";
$headers = "";
$headers .= "!CUST\tNAME\t\n";
$headers .= "!ACCNT\tNAME\tACCNTTYPE\tEXTRA\tACCNUM\n";
$content .= "ACCNT\t" . $export_accounts['sales_revenue'] . "\tINC\t\n";
$content .= "ACCNT\t" . $export_accounts['shipping'] . "\tINC\t\n";
$content .= "ACCNT\t" . $export_accounts['sales_tax_account'] . "\tOCLIAB\tSALESTAX\t2201\n";
foreach ($gateway_accounts as $gateway => $account_name) {
if (!empty($account_name)) {
$content .= "ACCNT\t" . $account_name . "\tBANK\t\n";
}
}
// !TRNS line
$headers .= '!TRNS';
foreach ($trans as $key => $value) {
$headers .= "\t" . $key;
}
$headers .= "\n";
// !SPL line
$headers .= '!SPL';
foreach ($spl as $key => $value) {
$headers .= "\t" . $key;
}
$headers .= "\n";
// !CUST line
$headers .= '!CUST';
foreach ($cust as $key => $value) {
$headers .= "\t" . $key;
}
$headers .= "\n";
// !ENDTRNS line
//$content .= '!ENDTRNS' . "\n";
$export_dates = array_keys($_POST['period']);
foreach ($export_dates as $export_date) {
$a = explode('-', $export_date);
$year = $a[0];
$month = $a[1];
$sql = "SELECT ID FROM " . WPSC_TABLE_PURCHASE_LOGS . ' WHERE MONTH( FROM_UNIXTIME( date ) ) = ' . $month . ' AND YEAR( FROM_UNIXTIME( DATE ) ) = ' . $year . ' ORDER by date DESC';
$result = $wpdb->get_col($sql, 0);
$purchase_log_ids = array_map('intval', $result);
$max_rows = 1;
foreach ($purchase_log_ids as $purchase_log_id) {
$purchase_log = new WPSC_Purchase_Log($purchase_log_id);
$gateway_id = $purchase_log->get('gateway');
$data = $purchase_log->get_data();
if (empty($gateway_accounts[$gateway_id])) {
continue;
}
// reset the transaction array back to empty
foreach ($trans as $key => $value) {
$trans[$key] = '';
}
// reset the customer array back to empty
foreach ($cust as $key => $value) {
$cust[$key] = '';
}
if ($purchase_log->get('processed') != WPSC_Purchase_Log::ACCEPTED_PAYMENT && $purchase_log->get('processed') != WPSC_Purchase_Log::CLOSED_ORDER) {
continue;
}
$checkout_form_data = new WPSC_Checkout_Form_Data($purchase_log_id);
$checkout = $checkout_form_data->get_data();
if (!isset($checkout['billingstate'])) {
$checkout['billingstate'] = '';
}
if (!isset($checkout['shippingstate'])) {
$checkout['shippingstate'] = '';
}
$timestamp = $purchase_log->get('date');
$thedate = date('m/d/Y', $timestamp);
foreach ($trans as $key => $value) {
switch ($key) {
case 'TRNSID':
$trans[$key] = $trnsid++;
break;
case 'TIMESTAMP':
$trans[$key] = $purchase_log->get('date');
break;
case 'TRNSTYPE':
$trans[$key] = 'CASH SALE';
break;
case 'DATE':
$trans[$key] = $thedate;
break;
case 'ACCNT':
$trans[$key] = $gateway_accounts[$gateway_id];
break;
case 'NAME':
$trans[$key] = $checkout['billingfirstname'] . ' ' . $checkout['billinglastname'];
break;
case 'AMOUNT':
$trans[$key] = $purchase_log->get('totalprice');
break;
case 'CLEAR':
$trans[$key] = 'N';
break;
case 'SHIPDATE':
$trans[$key] = $thedate;
break;
case 'PAYMETH':
$trans[$key] = $purchase_log->get('gateway_name');
break;
case 'DOCNUM':
$trans[$key] = $purchase_log_id;
break;
case 'MEMO':
$trans[$key] = 'sparkle-gear.com purchase #' . $purchase_log_id;
break;
case 'ADDR1':
$trans[$key] = $checkout['billingfirstname'] . ' ' . $checkout['billinglastname'];
break;
case 'ADDR2':
$trans[$key] = $checkout['billingaddress'];
break;
case 'ADDR3':
$trans[$key] = $checkout['billingcity'] . ', ' . $checkout['billingstate'] . ' ' . $checkout['billingpostcode'];
break;
case 'ADDR4':
$trans[$key] = $checkout['billingcountry'];
break;
case 'SHIPVIA':
$trans[$key] = $purchase_log->get('shipping_method_name');
break;
case 'INVTITLE':
$trans[$key] = 'Sparkle Gear Web Store';
break;
case 'SADDR1':
$trans[$key] = $checkout['shippingfirstname'] . ' ' . $checkout['shippinglastname'];
break;
case 'SADDR2':
$trans[$key] = $checkout['shippingaddress'];
break;
case 'SADDR3':
$trans[$key] = $checkout['shippingcity'] . ', ' . $checkout['shippingstate'] . ' ' . $checkout['shippingpostcode'];
break;
case 'SADDR4':
$trans[$key] = $checkout['billingcountry'];
break;
}
}
foreach ($cust as $key => $value) {
switch ($key) {
case 'NAME':
$cust[$key] = $checkout['billingfirstname'] . ' ' . $checkout['billinglastname'];
break;
case 'FIRSTNAME':
$cust[$key] = $checkout['billingfirstname'];
break;
case 'LASTNAME':
$cust[$key] = $checkout['billinglastname'];
break;
case 'EMAIL':
$cust[$key] = $checkout['billingemail'];
break;
case 'PHONE1':
$cust[$key] = $checkout['billingphone'];
break;
case 'BADDR1':
$cust[$key] = $checkout['billingfirstname'] . ' ' . $checkout['billinglastname'];
break;
case 'BADDR2':
$cust[$key] = $checkout['billingaddress'];
break;
case 'BADDR3':
$cust[$key] = $checkout['billingcity'] . ', ' . $checkout['billingstate'] . ' ' . $checkout['billingpostcode'];
break;
case 'BADDR4':
$cust[$key] = $checkout['billingcountry'];
break;
case 'SADDR1':
$cust[$key] = $checkout['shippingfirstname'] . ' ' . $checkout['shippinglastname'];
break;
case 'SADDR2':
$cust[$key] = $checkout['shippingaddress'];
break;
case 'SADDR3':
$cust[$key] = $checkout['shippingcity'] . ', ' . $checkout['shippingstate'] . ' ' . $checkout['shippingpostcode'];
break;
case 'SADDR4':
$cust[$key] = $checkout['billingcountry'];
break;
}
}
foreach ($trans as $key => $value) {
$trans[$key] = trim(preg_replace('/\\s+/', ' ', $value));
}
foreach ($cust as $key => $value) {
$cust[$key] = trim(preg_replace('/\\s+/', ' ', $value));
}
$splid = 1;
// TRNS line
$content .= 'TRNS';
foreach ($trans as $key => $value) {
$content .= "\t" . $value;
}
$content .= "\n";
$cart_contents = $purchase_log->get_cart_contents();
foreach ($cart_contents as $cart_item) {
$product_id = $cart_item->prodid;
if ($parent_product = get_post_field('post_parent', $product_id)) {
$product_id = $parent_product;
}
$terms = wp_get_post_terms($product_id, 'wpsc_product_category');
if (!empty($terms)) {
foreach ($terms as $term) {
$invitem = $term->name;
if ($term->parent != 0) {
break;
}
}
} else {
$invitem = '';
}
/*
$item_name = '';
$article = new Bling_Article( $cart_item->prodid );
if ( $article->check() ) {
$item_name = $article->name();
}
*/
$spl_product = array('SPLID' => $trnsid++, 'TRNSTYPE' => 'PAYMENT', 'DATE' => $trans['DATE'], 'ACCNT' => $export_accounts['sales_revenue'], 'AMOUNT' => -($cart_item->price * $cart_item->quantity), 'QNTY' => -$cart_item->quantity, 'PRICE' => $cart_item->price, 'NAME' => '', 'DOCNUM' => $purchase_log_id, 'MEMO' => $cart_item->name);
// SPL line
$content .= 'SPL';
foreach ($spl as $key => $value) {
$content .= "\t";
if (!empty($spl_product[$key])) {
$content .= $spl_product[$key];
}
}
$content .= "\n";
}
$spl_shipping = array('SPLID' => $trnsid++, 'TRNSTYPE' => 'PAYMENT', 'DATE' => $trans['DATE'], 'ACCNT' => $export_accounts['shipping'], 'AMOUNT' => -$purchase_log->get('total_shipping'), 'PRICE' => $purchase_log->get('total_shipping'), 'NAME' => '', 'DOCNUM' => $purchase_log_id, 'MEMO' => 'customer paid shipping', 'EXTRA' => '', 'QNTY' => '');
$splid = 2;
$spl_discount = array('SPLID' => $trnsid++, 'TRNSTYPE' => 'PAYMENT', 'DATE' => $trans['DATE'], 'ACCNT' => $export_accounts['sales_revenue'], 'AMOUNT' => $purchase_log->get('discount_value'), 'PRICE' => -$purchase_log->get('discount_value'), 'NAME' => '', 'DOCNUM' => $purchase_log_id, 'MEMO' => 'discount', 'EXTRA' => '', 'QNTY' => '');
$spl_tax = array('SPLID' => $trnsid++, 'TRNSTYPE' => 'PAYMENT', 'DATE' => $trans['DATE'], 'ACCNT' => $export_accounts['sales_tax_account'], 'AMOUNT' => -$purchase_log->get('wpec_taxes_total'), 'PRICE' => "6.25%", 'NAME' => $export_accounts['sales_tax_payee'], 'DOCNUM' => $purchase_log_id, 'MEMO' => 'sales tax', 'EXTRA' => 'AUTOSTAX', 'QNTY' => '', 'INVITEM' => 'MA Sales/Use Tax');
$spl_end = array('SPLID' => $trnsid++, 'EXTRA' => 'ENDGRP');
// SPL line
$content .= 'SPL';
foreach ($spl as $key => $value) {
$content .= "\t";
if (!empty($spl_shipping[$key])) {
$content .= $spl_shipping[$key];
}
}
$content .= "\n";
// SPL line
$content .= 'SPL';
foreach ($spl as $key => $value) {
$content .= "\t";
if (!empty($spl_tax[$key])) {
$content .= $spl_tax[$key];
}
}
$content .= "\n";
// SPL line
$content .= 'SPL';
foreach ($spl as $key => $value) {
$content .= "\t";
if (!empty($spl_discount[$key])) {
$content .= $spl_discount[$key];
}
}
$content .= "\n";
$content .= 'SPL';
foreach ($spl as $key => $value) {
$content .= "\t";
if (!empty($spl_end[$key])) {
$content .= $spl_end[$key];
}
}
$content .= "\n";
$splid = 3;
$content .= 'ENDTRNS';
$content .= "\n";
//if ( --$max_rows == 0 )
// break;
$cust_content .= 'CUST';
foreach ($cust as $key => $value) {
$cust_content .= "\t" . $value;
}
$cust_content .= "\n";
}
}
$file_name = 'download.iif';
header('Content-Type: text/csv');
header('Content-Disposition: inline; filename="' . $file_name . '"');
echo $headers;
echo $cust_content;
echo $content;
exit;
}
