ORDER HISTORY
OPEN ORDERS
query($querystr); if($db->num_rows()>0) { $counter = 0; while ($db->next_record()) { $stored_order_id = $db->record[order_id]; $querystr1 = "SELECT * FROM aqua_order_master WHERE order_id = '$stored_order_id' AND order_status != '4' AND order_status != '5' AND order_status != '0'"; $db2->query($querystr1); if($db2->num_rows()>0) { $db2->next_record(); $stored_order_no = $db2->record[order_no]; $stored_order_day = $db2->record[order_day]; $stored_order_month = $db2->record[order_month]; $stored_order_year = $db2->record[order_year]; $stored_order_status = $db2->record[order_status]; $stored_order_date = $stored_order_day.' / '.$stored_order_month.' / '.$stored_order_year; $counter = $counter + 1; $edit_name = 'Edit_'.$stored_order_id; $view_name = 'View_'.$stored_order_id; if($stored_order_status==1) { $status_type = "You -> ABI"; } else if($stored_order_status==2) { $status_type = "ABI -> You"; } else if($stored_order_status==3) { $status_type = "Confirm"; } else if($stored_order_status==4) { $status_type = "Closed"; } ?>
No
Order Number
Order Date
Status
 

 

ORDERS ALREADY SENT
query($querystr); if($db->num_rows()>0) { $counter = 0; while ($db->next_record()) { $stored_order_id = $db->record[order_id]; $querystr1 = "SELECT * FROM aqua_order_master WHERE order_id = '$stored_order_id' AND order_status = '4'"; $db2->query($querystr1); if($db2->num_rows()>0) { $db2->next_record(); $stored_order_no = $db2->record[order_no]; $stored_order_day = $db2->record[order_day]; $stored_order_month = $db2->record[order_month]; $stored_order_year = $db2->record[order_year]; $stored_order_date = $stored_order_day.' / '.$stored_order_month.' / '.$stored_order_year; $counter = $counter + 1; $view_name = 'View_'.$stored_order_id; ?>
No
Order Number
Order Date
Status
 
Closed

ABI - AquaBridge International