echo '
';
if ( 'POST' == $_SERVER['REQUEST_METHOD'] )
{
if ( $_POST['confirmation_number'] != '0' && is_numeric($_POST['confirmation_number']) )
{
global $wpdb;
$purchase_log = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `google_order_number`= %s LIMIT 1", $_POST['confirmation_number']), ARRAY_A );
if ( $purchase_log != '' )
{
$race_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_CART_CONTENTS . "` WHERE `purchaseid`= %s LIMIT 1", $purchase_log['id']), ARRAY_A );
$first_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `log_id`= %s AND `form_id` = '2' LIMIT 1", $purchase_log['id']), ARRAY_A );
$last_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `log_id`= %s AND `form_id` = '3' LIMIT 1", $purchase_log['id']), ARRAY_A );
switch ( $purchase_log['processed'] )
{
case '1':
$order_status = 'Incomplete.';
break;
case '2':
$order_status = 'Order Received. Payment Pending.';
break;
case '3':
$order_status = 'Accepted Payment.';
break;
case '4':
$order_status = 'Job Dispatched.';
break;
case '5':
$order_status = 'Order Cancelled.';
break;
case '6':
$order_status = 'Payment Declined.';
break;
default:
}
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
| Purchase Date |
" . date( "M jS Y", $purchase_log['date'] ) . " |
| Name |
" . $first_name['value'] . " " . $last_name['value'] . " |
| Race |
" . $race_name['name'] . " |
| Order Status |
" . $order_status . " |
";
}
else
echo "
"."Confirmation #: ". $_POST['confirmation_number'] ." NOT found!
";
}
else if ( $_POST['first_name'] != "" && $_POST['last_name'] != "" )
{
$found = false;
global $wpdb;
$first_name_log_id = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `value`= %s AND `form_id` = '2' ", $_POST['first_name']), ARRAY_A);
$last_name_log_id = $wpdb->get_results( $wpdb->prepare("SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `value`= %s AND `form_id` = '3' ", $_POST['last_name']), ARRAY_A);
if ( $first_name_log_id != NULL && $last_name_log_id != NULL )
{
foreach($last_name_log_id as $lnameid)
{
foreach($first_name_log_id as $fnameid)
{
if($lnameid['log_id'] == $fnameid['log_id'])
{
$purchase_log = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_PURCHASE_LOGS . "` WHERE `id`= %s LIMIT 1", $lnameid['log_id']), ARRAY_A );
$race_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_CART_CONTENTS . "` WHERE `purchaseid`= %s LIMIT 1", $lnameid['log_id']), ARRAY_A );
$first_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `log_id`= %s AND `form_id` = '2' LIMIT 1", $lnameid['log_id']), ARRAY_A );
$last_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM `" . WPSC_TABLE_SUBMITED_FORM_DATA . "` WHERE `log_id`= %s AND `form_id` = '3' LIMIT 1", $lnameid['log_id']), ARRAY_A );
switch ( $purchase_log['processed'] )
{
case '1':
$order_status = 'Incomplete.';
break;
case '2':
$order_status = 'Order Received. Payment Pending.';
break;
case '3':
$order_status = 'Accepted Payment.';
break;
case '4':
$order_status = 'Job Dispatched.';
break;
case '5':
$order_status = 'Order Cancelled.';
break;
case '6':
$order_status = 'Payment Declined.';
break;
default:
}
if ( $purchase_log['processed'] != '1') {
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
| Purchase Date |
" . date( "M jS Y", $purchase_log['date'] ) . " |
| Name |
" . $fnameid['value'] . " " . $lnameid['value'] . " |
| Race |
" . $race_name['name'] . " |
| Order Status |
" . $order_status . " |
";
$found = true;
}
}
}
}
}
if ($found == false)
echo "No record found for ". $_POST['first_name'] ." ". $_POST['last_name'].".";
}
}
?> 
