prefix."collect_data_forms` WHERE `active` = '1' AND `display_log` = '1';";
$form_data = $wpdb->get_results($form_sql,ARRAY_A);
$col_count = 5 + count($form_data);
$i = 0;
echo "";
//exit("".print_r($date_list,true)." ");
foreach($date_list as $date_pair){
if(($date_pair['end'] >= $earliest_timestamp) && ($date_pair['start'] <= $current_timestamp)) {
$sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' ORDER BY `date` DESC";
if ($paidlog) {
$sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' AND `processed` >= '2' ORDER BY `date` DESC";
} else if($_GET['filteremail']) {
$sql = "SELECT DISTINCT `{$wpdb->prefix}purchase_logs` . * FROM `{$wpdb->prefix}submited_form_data` LEFT JOIN `{$wpdb->prefix}purchase_logs` ON `{$wpdb->prefix}submited_form_data`.`log_id` = `{$wpdb->prefix}purchase_logs`.`id` WHERE `{$wpdb->prefix}submited_form_data`.`value` IN ( '".$wpdb->escape($_GET['filteremail'])."' ) AND `{$wpdb->prefix}purchase_logs`.`date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' ORDER BY `{$wpdb->prefix}purchase_logs`.`date` DESC;";
} else if ($_GET['filter']=='affiliate') {
$sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date` BETWEEN '".$date_pair['start']."' AND '".$date_pair['end']."' AND `affiliate_id` IS NOT NULL ORDER BY `date` DESC";
}
$purchase_log = $wpdb->get_results($sql,ARRAY_A) ;
$i = 0;
$subtotal = 0;
echo "";
echo " | ";
echo "";
echo " | ";
echo " ";
if($purchase_log != null)
{
echo "";
// echo " | ";
// echo TXT_WPSC_PURCHASE_NUMBER;
// echo " | ";
echo " ";
echo TXT_WPSC_STATUS;
echo " | ";
echo " ";
echo TXT_WPSC_DATE;
echo " | ";
foreach($form_data as $form_field)
{
echo " ";
echo $form_field['name'];
echo " | ";
}
echo " ";
echo TXT_WPSC_PRICE;
echo " | ";
if(get_option('payment_method') == 2)
{
echo " ";
echo TXT_WPSC_PAYMENT_METHOD;
echo " | ";
}
echo " ";
echo TXT_WPSC_VIEWDETAILS;
echo " | ";
//echo "";
//echo TXT_WPSC_STORENAME;
//echo " | ";
echo " | ";
foreach($purchase_log as $purchase) {
$status_state = "expand";
$status_style = "";
$alternate = "";
$i++;
if(($i % 2) != 0) {
$alternate = "class='alt'";
}
echo "\n\r";
// echo " | ";
// echo $purchase['id'];
// echo " | ";
echo " ";
if($purchase['processed'] < 1) {
$purchase['processed'] = 1;
}
$stage_sql = "SELECT * FROM `".$wpdb->prefix."purchase_statuses` WHERE `id`='".$purchase['processed']."' AND `active`='1' LIMIT 1";
$stage_data = $wpdb->get_row($stage_sql,ARRAY_A);
echo "";
if($_GET['id'] == $purchase['id']) {
$status_state = "collapse";
$status_style = "style='display: block;'";
}
echo "![](".WPSC_URL."/images/icon_window_$status_state.gif) ";
if($stage_data['colour'] != '') {
$colour = "style='color: #".$stage_data['colour'].";'";
}
echo "";
switch ($purchase['processed']){
case 1:
echo "";
break;
case 2:
echo "";
break;
case 3:
echo "";
break;
case 4:
echo "";
break;
}
echo $stage_data['name'];
echo "";
echo "";
echo "";
echo " | \n\r";
echo " ";
echo date("jS M Y",$purchase['date']);
echo " | \n\r";
foreach($form_data as $form_field) {
$collected_data_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$purchase['id']."' AND `form_id` = '".$form_field['id']."' LIMIT 1";
$collected_data = $wpdb->get_results($collected_data_sql,ARRAY_A);
$collected_data = $collected_data[0];
switch($form_field['type']) {
case 'country':
echo " ";
echo get_country($purchase['billing_country']);
echo " | \n\r";
break;
case 'delivery_country':
echo " ";
echo get_country($purchase['shipping_country']);
echo " | \n\r";
break;
default:
echo " ";
echo $collected_data['value'];
echo " | \n\r";
break;
}
}
// echo " ";
//
// if($purchase['shipping_country'] != '') {
// $billing_country = $purchase['billing_country'];
// $shipping_country = $purchase['shipping_country'];
// } else {
// $country_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$purchase['id']."' AND `form_id` = '".get_option('country_form_field')."' LIMIT 1";
// $country_data = $wpdb->get_results($country_sql,ARRAY_A);
// $billing_country = $country_data[0]['value'];
// $shipping_country = $country_data[0]['value'];
// }
// //echo $country;
// echo nzshpcrt_currency_display(nzshpcrt_find_total_price($purchase['id'],$shipping_country),1);
// $subtotal += nzshpcrt_find_total_price($purchase['id'],$shipping_country);
// echo " | \n\r";
if(get_option('payment_method') == 2) {
echo " ";
$gateway_name = '';
foreach($GLOBALS['nzshpcrt_gateways'] as $gateway) {
if($purchase['gateway'] != 'testmode') {
if($gateway['internalname'] == $purchase['gateway'] ) {
$gateway_name = $gateway['name'];
}
} else {
$gateway_name = "Manual Payment";
}
}
echo $gateway_name;
echo " | \n\r";
}
echo "";
if($purchase['affiliate_id'] > 0) {
$affiliate_commision_percentage = $wpdb->get_var("SELECT commision_percentage FROM {$wpdb->prefix}wpsc_affiliates WHERE user_id='{$purchase['affiliate_id']}'");
$sale = $purchase['totalprice'] * (100-$affiliate_commision_percentage)/100;
} else {
$sale = $purchase['totalprice'];
}
echo nzshpcrt_currency_display($sale,1);
echo " | ";
echo " ";
echo "".TXT_WPSC_VIEWDETAILS."";
echo " | \n\r";
echo " \n\r";
$stage_list_sql = "SELECT * FROM `".$wpdb->prefix."purchase_statuses` ORDER BY `id` ASC";
$stage_list_data = $wpdb->get_results($stage_list_sql,ARRAY_A);
echo "\n\r";
echo " \n\r";
echo " \n\r";
echo " \n\r";
echo " ".TXT_WPSC_ORDER_STATUS."\n\r";
echo " \n\r";
echo " Tracking ID: ";
if($purchase['transactid'] != '')
{
echo " ".TXT_WPSC_TXN_ID.": ".$purchase['transactid']."";
}
echo " ".TXT_WPSC_REMOVE_LOG."";
echo " \n\r";
echo " | \n\r";
echo " \n\r";
}
echo "";
echo " ";
echo "Total: ".nzshpcrt_currency_display(admin_display_total_price($date_pair['start'], $date_pair['end']),1);
echo "
![](".WPSC_URL."/images/download.gif) ".TXT_WPSC_DOWNLOAD_CSV."";
echo " | ";
echo " ";
}
else
{
echo "";
echo " | ";
echo "No transactions for this month.";
echo " | ";
echo " ";
}
}
}
echo " ";
} else {
echo " ";
echo "";
echo " | ";
echo TXT_WPSC_NO_PURCHASES;
echo " | ";
echo " ";
echo " ";
}
} else if(is_numeric($_GET['purchaseid'])) {
$purch_sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `id`='".$_GET['purchaseid']."'";
$purch_data = $wpdb->get_results($purch_sql,ARRAY_A) ;
echo "".TXT_WPSC_DATE.":".date("jS M Y", $purch_data[0]['date'])." ";
$cartsql = "SELECT * FROM `".$wpdb->prefix."cart_contents` WHERE `purchaseid`=".$_GET['purchaseid']."";
$cart_log = $wpdb->get_results($cartsql,ARRAY_A) ;
$j = 0;
if($cart_log != null) {
echo "";
echo "";
echo " | ";
echo TXT_WPSC_NAME;
echo " | ";
echo " ";
echo TXT_WPSC_SKU;
echo " | ";
echo " ";
echo TXT_WPSC_QUANTITY;
echo " | ";
echo " ";
echo TXT_WPSC_PRICE;
echo " | ";
// echo " ";
// echo TXT_WPSC_COMMISION;
// echo " | ";
echo " ";
echo TXT_WPSC_TAX;
echo " | ";
echo " ";
echo TXT_WPSC_SHIPPING;
echo " | ";
echo " ";
echo TXT_WPSC_TOTAL;
echo " | ";
echo " ";
$endtotal = 0;
$all_donations = true;
$all_no_shipping = true;
$file_link_list = array();
foreach($cart_log as $cart_row)
{
$alternate = "";
$j++;
if(($j % 2) != 0) {
$alternate = "class='alt'";
}
$productsql= "SELECT * FROM `".$wpdb->prefix."product_list` WHERE `id`=".$cart_row['prodid']."";
$product_data = $wpdb->get_results($productsql,ARRAY_A);
$variation_sql = "SELECT * FROM `".$wpdb->prefix."cart_item_variations` WHERE `cart_id`='".$cart_row['id']."'";
$variation_data = $wpdb->get_results($variation_sql,ARRAY_A);
$variation_count = count($variation_data);
if($variation_count > 1) {
$variation_list = " (";
$i = 0;
foreach($variation_data as $variation) {
if($i > 0) {
$variation_list .= ", ";
}
$value_id = $variation['value_id'];
$value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A);
$variation_list .= $value_data[0]['name'];
$i++;
}
$variation_list .= ")";
} else if($variation_count == 1) {
$value_id = $variation_data[0]['value_id'];
$value_data = $wpdb->get_results("SELECT * FROM `".$wpdb->prefix."variation_values` WHERE `id`='".$value_id."' LIMIT 1",ARRAY_A);
$variation_list = " (".$value_data[0]['name'].")";
} else {
$variation_list = '';
}
if($purch_data[0]['shipping_country'] != '') {
$billing_country = $purch_data[0]['billing_country'];
$shipping_country = $purch_data[0]['shipping_country'];
} else {
$country_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".$_GET['purchaseid']."' AND `form_id` = '".get_option('country_form_field')."' LIMIT 1";
$country_data = $wpdb->get_results($country_sql,ARRAY_A);
$billing_country = $country_data[0]['value'];
$shipping_country = $country_data[0]['value'];
}
if($cart_row['donation'] != 1) {
$all_donations = false;
}
if($cart_row['no_shipping'] != 1) {
$shipping = $cart_row['pnp'] * $cart_row['quantity'];
$total_shipping += $shipping;
$all_no_shipping = false;
} else {
$shipping = 0;
}
if($cart_row['files'] != null) {
$file_data = unserialize($cart_row['files']);
if(is_array($file_data)) {
$file_link_list[] = "{$product_data[0]['name']}
";
}
}
echo "";
echo " | ";
echo $product_data[0]['name'];
echo $variation_list;
echo " | ";
echo " ";
$sku = get_product_meta($product_data[0]['id'], 'sku');
$sku = (string)$sku[0];
echo $sku;
echo " | ";
echo " ";
echo $cart_row['quantity'];
echo " | ";
echo " ";
$price = $cart_row['price'] * $cart_row['quantity'];
$gst = $price - ($price / (1+($cart_row['gst'] / 100)));
if($gst > 0) {
$tax_per_item = $gst / $cart_row['quantity'];
}
echo nzshpcrt_currency_display($cart_row['price'] - $tax_per_item, 1);
echo " | ";
echo " ";
echo nzshpcrt_currency_display($gst, 1);
echo " | ";
echo " ";
echo nzshpcrt_currency_display($cart_row['pnp'], 1);
echo " | ";
echo " ";
$endtotal += $price;
echo nzshpcrt_currency_display(($shipping + $price), 1);
echo " | ";
echo ' ';
}
echo "";
echo " | ";
echo " | ";
echo " ";
if($purch_data[0]['discount_value'] > 0) {
echo "".TXT_WPSC_DISCOUNT.":
";
}
if(($all_donations == false) && ($all_no_shipping == false)) {
echo "".TXT_WPSC_BASESHIPPING.":
";
echo "".TXT_WPSC_TOTALSHIPPING.":
";
}
if($purch_data[0]['affiliate_id'] != '') {
echo "".TXT_WPSC_COMMISION.":
";
}
echo "".TXT_WPSC_FINALTOTAL.":";
echo " | ";
echo " ";
if($purch_data[0]['discount_value'] > 0) {
echo nzshpcrt_currency_display($purch_data[0]['discount_value'], 1)."
";
}
if(($all_donations == false) && ($all_no_shipping == false)) {
echo nzshpcrt_currency_display($purch_data[0]['base_shipping'],1)."
";
$total_shipping += $purch_data[0]['base_shipping'];
$endtotal += $total_shipping;
echo nzshpcrt_currency_display($total_shipping, 1) . "
";
}
$endtotal -= $purch_data[0]['discount_value'];
if($purch_data[0]['affiliate_id'] > 0) {
$affiliate_commision_percentage = $wpdb->get_var("SELECT `commision_percentage` FROM `{$wpdb->prefix}wpsc_affiliates` WHERE `user_id`='{$purch_data[0]['affiliate_id']}'");
$sale = $purch_data[0]['totalprice'] * (100-$affiliate_commision_percentage)/100;
echo nzshpcrt_currency_display($sale,1). "
";
$endtotal -= $sale;
}
echo nzshpcrt_currency_display($endtotal,1);
echo " | ";
echo ' ';
echo " ";
echo "
";
if(count($file_link_list) > 0) {
echo "\n\r";
echo " ".TXT_WPSC_DOWNLOAD_ATTACHED_FILES."
\n\r";
foreach($file_link_list as $file_link) {
echo "{$file_link}\n\r";
}
echo " \n\r";
}
if (IS_WP27) {
echo "";
}
echo " ".TXT_WPSC_PURCHASE_NUMBER.":".$purch_data[0]['id']." \n\r";
echo " ".TXT_WPSC_CUSTOMERDETAILS."\n\r";
echo " \n\r";
$form_sql = "SELECT * FROM `".$wpdb->prefix."submited_form_data` WHERE `log_id` = '".(int)$_GET['purchaseid']."'";
$input_data = $wpdb->get_results($form_sql,ARRAY_A);
foreach($input_data as $input_row) {
$rekeyed_input[$input_row['form_id']] = $input_row;
}
if($input_data != null) {
$form_data = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}collect_data_forms` WHERE `active` = '1'",ARRAY_A);
foreach($form_data as $form_field) {
switch($form_field['type']) {
case 'country':
if(is_numeric($purch_data[0]['shipping_region'])) {
echo " | ".TXT_WPSC_STATE.": | ".get_region($purch_data[0]['shipping_region'])." | \n\r";
}
echo " | ".$form_field['name'].": | ".get_country($purch_data[0]['billing_country'])." | \n\r";
break;
case 'delivery_country':
echo " | ".$form_field['name'].": | ".get_country($purch_data[0]['shipping_country'])." | \n\r";
break;
case 'heading':
echo "
".$form_field['name'].": | \n\r";
break;
default:
echo " | ".$form_field['name'].": | ".$rekeyed_input[$form_field['id']]['value']." | \n\r";
break;
}
}
} else {
echo " | ".TXT_WPSC_NAME.": | ".$purch_data[0]['firstname']." ".$purch_data[0]['lastname']." | \n\r";
echo " | ".TXT_WPSC_ADDRESS.": | ".$purch_data[0]['address']." | \n\r";
echo " | ".TXT_WPSC_PHONE.": | ".$purch_data[0]['phone']." | \n\r";
echo " | ".TXT_WPSC_EMAIL.": | ".$purch_data[0]['email']." | \n\r";
}
if(get_option('payment_method') == 2) {
$gateway_name = '';
foreach($GLOBALS['nzshpcrt_gateways'] as $gateway) {
if($purch_data[0]['gateway'] != 'testmode') {
if($gateway['internalname'] == $purch_data[0]['gateway'] ) {
$gateway_name = $gateway['name'];
}
} else {
$gateway_name = "Manual Payment";
}
}
}
echo " | \n\r";
echo " | ".TXT_WPSC_PAYMENT_METHOD.": | ".$gateway_name." | \n\r";
echo " | ".TXT_WPSC_PURCHASE_NUMBER.": | ".$purch_data[0]['id']." | \n\r";
if ($purch_data[0]['find_us'])
echo " | ".TXT_WPSC_HOWCUSTOMERFINDUS.": | ".$purch_data[0]['find_us']." | \n\r";
$engrave_line = explode(",",$purch_data[0]['engravetext']);
if ($engrave_line[0]!='') {
echo " | ".TXT_WPSC_ENGRAVE." | | \n\r";
echo " | ".TXT_WPSC_ENGRAVE_LINE_ONE.": | ".$engrave_line[0]." | \n\r";
echo " | ".TXT_WPSC_ENGRAVE_LINE_TWO.": | ".$engrave_line[1]." | \n\r";
}
$comments = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}cart_contents WHERE purchaseid='".$purch_data[0]['id']."' AND meta IS NOT NULL",ARRAY_A);
if ($comments[0]['meta'] != '')
echo " | ".TXT_WPSC_COMMENTS." | | ";
foreach ((array)$comments as $comment) {
$comm = unserialize($comment['meta']);
$product_name = $wpdb->get_var("SELECT name FROM {$wpdb->prefix}product_list WHERE id='{$comment['prodid']}'");
if ($comm != '') {
echo " | ".$product_name.": | ".$comm['comment']." | \n\r";
}
}
// echo " | ".TXT_WPSC_DATE_REQUESTED." | | ";
// foreach ($comments as $comment) {
// $comm = unserialize($comment['meta']);
// $product_name = $wpdb->get_var("SELECT name FROM {$wpdb->prefix}product_list WHERE id='{$comment['prodid']}'");
// if ($comm != '') {
// echo " | ".$product_name.": | ".$comm['time_requested']." | \n\r";
// }
// }
if (is_array($comments)){
foreach ($comments as $comment) {
$comm = unserialize($comment['meta']);
if (is_array($comm['meta'])){
echo " | ".TXT_WPSC_LABEL." | | | ";
foreach($comm['meta'] as $key => $meta) {
if ($comm != '') {
echo " | ".$key.": | ".$meta." | ".$comm['time_requested'][$key]." | \n\r";
}
}
}
}
}
if($purch_data[0]['transactid'] != '') {
echo " | ".TXT_WPSC_TXN_ID.": | ".$purch_data[0]['transactid']." | \n\r";
}
echo " \n\r";
} else {
echo " ".TXT_WPSC_USERSCARTWASEMPTY;
}
if($purch_data[0]['shipping_method'] != '') {
echo " ";
echo " ".TXT_WPSC_SHIPPING_METHOD."\n\r";
echo " \n\r";
echo " | ".TXT_WPSC_SHIPPING_METHOD.": | ".$purch_data[0]['shipping_method']." | \n\r";
echo " | ".TXT_WPSC_SHIPPING_OPTION.": | ".$purch_data[0]['shipping_option']." | \n\r";
echo " \n\r";
}
echo " ".TXT_WPSC_ACTIONS."";
echo " ![](".WPSC_URL."/images/lock_open.png) ".TXT_WPSC_CLEAR_IP_LOCKS."";
echo " ![](".WPSC_URL."/images/printer.png) ".TXT_WPSC_VIEW_PACKING_SLIP."";
echo " ![](".WPSC_URL."/images/email_go.png) ".TXT_WPSC_EMAIL_BUYER."";
echo " ![](".WPSC_URL."/images/cross.png) ".TXT_WPSC_REMOVE_LOG."";
//http://www.instinct.co.nz/wordpress_2.6/wp-admin/admin.php?page=wp-shopping-cart/display-log.php&display_invoice=true&purchaseid=27
echo " ".TXT_WPSC_GOBACK."";
} elseif (is_numeric($_GET['email_buyer_id'])) {
echo $resent;
if ($resent != 0){
if (IS_WP27) {
echo " ";
}
echo "The folowing purchase recipt have has been resent:
";
echo nl2br($message_html);
} else {
echo "An Error Occured While Sending Email";
}
}
if (IS_WP27){
echo " ";
}
$sql = "SELECT * FROM `".$wpdb->prefix."purchase_logs` WHERE `date`!=''";
$purchase_log = $wpdb->get_results($sql,ARRAY_A) ;
?>
|
