The following requirement is to integrate WordPress + multi-purpose WooCommerce plug-in with our self-developed online dispatch and delivery system back end.

what I need is the SQL statement that gives
the list of client orders that has been prepared by a vendor and ready
for delivery: something similar to the following SQL specifications

“SELECT Order_Details (Order_reference, Order_Amount, Date, time,
order_Package_spec(weight/Volume),
Payment_Status, Delivery_Status,
Is_Order_Ready_for_Delivery,
Optional[Delivery_Area/District] ) ,
Client_Details (Client_ID, Mobile_no, Delivery_Address),
Vendor_Details (Vendor_ID, Mobile/Contact_No, PickUp_Address,
Optional[PickUp_Area/District] ),
Delivery_Payment_Status_if_there_is,

FROM (Group of Joint Tables)
WHERE (Order_Date & Time Condition) AND
((Vendor Condition) AND/OR
(PickUp_Address/ Optional[Area/District] Condition) AND/OR
(Delivery_Address/ Optional[Area/District] Condition))”

• This topic was modified 4 years, 1 month ago by Steven Stern (sterndata).