PHP - Troubling Orders

Hi,

how can I track my order with DHL API? I want to implement SOAP request in PHP. Can you help me?

I've been staring at this for a few hours and know there is a solution...I will post my code...sorry about it's length...I think that is one of the problems when I am trying to think through the logic of what I am trying to do.

//fetch production data
if( isset ( $action ) && $action == 'fetch_production_data' ) {
	
	$query = "
			SELECT p1.order_id, p1.dept_code, p1.status_id, p1.expected_complete_time
			FROM production_status p1
			LEFT JOIN production_status p2 ON -- find similar records
			  p1.order_id = p2.order_id AND   -- ...for the same order
			  p1.dept_code = p2.dept_code AND -- ...and the same department
			  p2.submit_time > p1.submit_time -- ...and that come after the row that p1 found
			WHERE
			  p1.dept_code IN (5, 6, 7, 8, 10, 11, 12) AND -- limit to department we care about
			  p2.id IS NULL                        -- filter to keep only the p1 rows that didn't have later p2 rows
		 ";

	$stmt = $pdo->query( $query );

	//array to store order statuses
	$statuses = [];

	//build array to store order statuses for each order that has a manufacturing status
	while ( $row = $stmt->fetch() ) {
		$statuses[ $row[ "order_id" ] ][ $row[ "dept_code" ] ] = array(
			'status_id' => $row[ "status_id" ],
			'expected_complete_time' => $row[ "expected_complete_time" ]
		);
	}
	
	//filters are set
	if(isset($_GET['filters'])){
		
		//check field for manipulation
		$field = $_GET['filters'][0]['field'];
		if ( $field == 'Job Number' )
			$field = 'job_number';
		else if ( $field == 'Enterprise' )
			$field = 'enterprise';
		else 
			exit();
		
		//check type for manipulation
		$type = $_GET['filters'][0]['type'];
		if ( $type == '=' )
			$type = '=';
		else if ( $type == 'like' )
			$type = 'LIKE';
		else 
			exit();
		
		//check value for job_number as numeric
		$value = $_GET['filters'][0]['value'];
		if ( $field == 'job_number' && trim( !is_numeric ( $value ) ) )
			exit();
		else if ( $type == 'LIKE' )
			$value = "'%" . $value . "%'";
		
		$filter_data = TRUE;
	}
	
	//pagination
	if( isset( $field ) && isset( $type ) && isset( $value ) )
		$total_pages_sql = "SELECT COUNT(*) FROM production_data WHERE ". $field ." ". $type ." ". $value;
	else
		$total_pages_sql = "SELECT COUNT(*) FROM production_data";
	
	$stmt = $pdo->query($total_pages_sql);
	$stmt->execute();
	
	$records_per_page = 14;
	$page = $_GET['page'];
	$offset = ($page-1) * $records_per_page; 
	$total_rows = $stmt->fetchColumn();
	$total_pages = ceil($total_rows / $records_per_page);
	
	/*fetch production data*/
	if( isset( $field ) && isset( $type ) && isset( $value ) ) {
		
		$sql = 'SELECT id, job_number, enterprise, description, line_item, as400_ship_date, insert_time
				FROM production_data
				WHERE '. $field .' '. $type .' '. $value .' 
				ORDER BY enterprise, job_number, line_item LIMIT '. $offset . ', '. $records_per_page;

	} else {

		$sql = 'SELECT id, job_number, enterprise, description, line_item, as400_ship_date, insert_time 
				FROM production_data
				ORDER BY enterprise, job_number, line_item LIMIT '. $offset . ', '. $records_per_page;

	}

	//prepare SQL statement & execute
	$stmt = $pdo->query($sql);

	// define departments
	$dept_codes = [5,6,7,8,10,11,12];

	//output data into spreadsheet view
	while(list($id, $job_number, $enterprise, $description, $line_item, $as400_ship_date, $insert_time) = $stmt->fetch(PDO::FETCH_NUM))
	{

		// get/produce status values
		$status = [];
		foreach($dept_codes as $key)
		{
			$status[$key] = $statuses[$id][$key] ?? 0;
		}
		
		//set format for dates
		$date_format = 'm/d/Y';
		
		//get crating shipping expected ship date and assign to expected ship date
		$expected_ship_date = ( $status[8]['expected_complete_time'] != '' ) ? $status[8]['expected_complete_time'] : 'N/A';
		
		//format expected dates
		$expected_ship_date = ( $expected_ship_date != 'N/A' ) ? date( $date_format, strtotime( $expected_ship_date ) ) : $expected_ship_date;
		$as400_ship_date = date( $date_format, strtotime( $as400_ship_date ) );
		
		// build the buttons, once
		$btns = build_change_order_status_btns($id, $user_dept_code, $job_number, $enterprise, $status);
		
		//determine if order is new or revised
		$latestRevisedsql = $pdo->query('SELECT insert_time FROM production_data_archive WHERE order_id = "'.$id.'" ORDER BY insert_time desc LIMIT 1');
		$latestRevised = $latestRevisedsql->fetch();
		$latestRevisedcnt = $latestRevisedsql->rowCount();
		
		//setup dates for comparison
		$currentDate = strtotime(date('Y-m-d H:i:s'));
		$revisedDate = strtotime($latestRevised['insert_time']);
		$insertDate = strtotime($insert_time);
		
		//add 24hrs to revised date
		$revisedDate = $revisedDate + 86400;
		$insertDate = $insertDate + 86400;
		
		//see if the order is new or was revised in the last 24 hours
		$is_revised = ( $revisedDate > $currentDate ) ? TRUE : FALSE;
		$is_new = ( $insertDate > $currentDate && $latestRevisedcnt == 0 ) ? TRUE : FALSE;

		//build JSON response
		$json['data'][] = array(
			'Enterprise' => $enterprise,
			'Job Number' => $job_number,
			'LN #' => '<a href="order_details.php?order=' . $id . '">' . $line_item . '</a>',
			'Description' => $description,
			'AS400 Ship Date' => $as400_ship_date,
			'Est Ship' => $expected_ship_date,
			'QC' => $btns[10],
			'Pole Barn' => $btns[12],
			'Thermoforming' => $btns[6],
			'Vinyl/Paint' => $btns[5],
			'Fnl Asmb 1' => $btns[7],
			'Fnl Asmb 2' => $btns[11],
			'Crating/Shipping' => $btns[8],
			'New' => $is_new,
			'Revised' => $is_revised,
		);
		
		$json['new_orders'][] = [ $id => $latestRevised, 'cdate' => $currentDate, 'revised_date' => $revisedDate, 'is revised' => $is_revised ];
		
	}
	
	$json['last_page'] = $total_pages;
	
	$json['current_page'] = $page;
	
	header('Content-type: text/javascript');
	print(json_encode($json, JSON_PRETTY_PRINT));
}

If a $_GET var is set (say $_GET['new'] or $_GET['revised']) I'd like to pull all of the orders in the system which were created or revised in the last 24hours. Between all of the other features of Tabulator I am using (pagination, filtering, and I need to setup AJAX sorting) my head is just spinning...the criteria that I am using to figure out if an order was revised or is new is as so:

Maybe I need to clean up my code a bit...maybe I'm doing too much there. I don't like the way I am handling the pagination and when it comes to the AJAX sorting I'll likely have to handle it in a very similar way. Everything works...I just know I could probably be doing several things better.