Simple single page PHP Script to show data with filters.

Hi,

I have the following tables.

orders table

Column :

id
user_id
shipping_type
payment_status
order_status
order_date
update_date

order_histories table

Column :

order_id
history
created_at
updated_at

consignments table

Column :

order_id
bill_code
shipping_type
shipped_out
created_at
updated_at



I need a single page admin without login. so that i can do multiple combination query.

Eg:

1. Find order_histories.order_id that have orders.order_id = 9 AND order_histories.history having last history as "Order fulfill" as latest entry for this order_id between date created_at and updated_at .

2. Find orders.order_id where consignment tables having orders.order_id = consignments.order_id, orders.order_status = 3 and consignments.shipped_out = 1 between created_at and updated_at

3. Find orders.order_id where consignment tables having orders.order_id = consignments.order_id, orders.order_status = 2 , consignments.shipping_type = DHL and consignments.shipped_out = 0 between created_at and updated_at

4. Find consignments.order_id where consignments_shipped_out=1 and orders.order_status !=3 , between created_at and updated_at

5. Using Input Box to put Order ID, Find orders.order_id where consignment tables having orders.order_id = consignments.order_id


// Order status
// 0 => Order placed
// 1 => Unfulfilled
// 2 => Fulfilled
// 3 => Shipped/Collected
// 4 => Canceled
// 5 => Aborted
// 6 => On Hold
// 7 => Failed Consignment
// 8 => Failed PDF
//9 => Consignment Created

// Payment status
// 0 => Unpaid/Payment Pending
// 1 => Paid
// 2 => Payment Waiting for approval
// 3 => Aborted
// 4 => Canceled
// 5 => Refunded

//Shipping Status
//0 => Not ship
//1 => Shipped


When display, i need full name for "order_status" , "payment_status" and "shipping_status"

In the listing page, i need information like :

No., Orders Id, Payment Status, Order Status, Last Order History Status, Consignment Ship Status, Consignment Shipping Type, Orders Shipping Type


Fully sortable, by every column.


Thank you.