-- apps_transaction.getLacakDetailOnGoingResult (PROCEDURE)
BEGIN
	SELECT
		Order_KdProduk AS ProductID,
		Order_NmProduk AS ProductName,
		Order_Quantity AS Qty,
		ROUND((Order_ValueAfterTax/Order_Quantity),0) AS OrderPrice,
		ROUND(Order_HargaGross-Order_ValueDiscount,0) AS OrderPriceBeforePPN,
		Order_ValueAfterTax AS TotalPrice,
		(Order_HargaGross*Order_Quantity-Order_ValueDiscount) AS TotalPriceBeforePPN,
		Order_Status AS StatusOrder
	FROM apps_transaction.DataMonitoring_Ro_Owner
	WHERE 	
		Order_NomorWeb = ordernomorweb
		AND
		Order_Status = 'ON PROGRESS'
		AND
		Vs = 'Apps';
-- 	UNION ALL
-- 	SELECT
-- 		Order_KdProduk AS ProductID,
-- 		Order_NmProduk AS ProductName,
-- 		Order_Quantity AS Qty,
-- 		ROUND((Order_ValueAfterTax/Order_Quantity),0) AS OrderPrice,
-- 		Order_ValueAfterTax AS TotalPrice,
-- 		Order_Status AS StatusOrder
-- 	FROM apps_transaction.DataMonitoring_Ro_Owner
-- 	WHERE 
-- 		Order_Status = 'CANCEL'
-- 		AND
-- 		Order_NomorWeb = ordernomorweb
-- 		And
-- 		Vs = 'Apps'
-- 		AND 
-- 		DATEDIFF(CURDATE(), Order_TanggalOrder) <= 15;
END