-- apps_master.getListDataOrderOutlet (PROCEDURE)
begin
SELECT	OrderID, CartID, hto1.OutletID, OutletName, EntryID, 
	(SELECT UserFullName FROM apps_master.m_user1 u1 
	JOIN apps_transaction.header_transaction_owner1 hto1 ON u1.UserID = hto1.EntryID
	WHERE hto1.OrderID = orderID1) AS EntryName, o1.OutletAddress, OutletLatitude, OutletLongitude,
	OutletPhone,
	hto1.StatusOrderID, StatusOrderName, DATE_FORMAT(OrderDate, '%d-%m-%Y') AS OrderDate,
	DATE_FORMAT(OrderDate, '%H:%i') AS OrderTime, ApprovedID, ApprovedDate
FROM	apps_transaction.header_transaction_owner1 hto1
	LEFT JOIN apps_master.m_outlet1 o1 ON hto1.OutletID = o1.OutletID
	LEFT JOIN apps_master.m_status_order so ON hto1.StatusOrderID = so.StatusOrderID
	LEFT JOIN apps_master.outlet_location ol ON hto1.OutletID = ol.OutletID AND ol.OutletID = o1.OutletID
WHERE hto1.OrderID = orderID1;
end