-- pharmanet.sp_GetTotalOrderB2C_PerformanceHA (PROCEDURE)
begin
	select 
		SUM(OrderProductQty*OrderProductPriceAfterDiscount) as TotalOrder
	FROM 
		header_transaction_customer ht 
	LEFT JOIN detail_transaction_customer dt ON ht.OrderID = dt.OrderID
	LEFT JOIN m_product p ON dt.ProductID = p.ProductID
	WHERE 
		ht.OutletID in 
		(
		SELECT 
			OutletID 
		from 
			bridging_user_outlet 
		where 
			UserID = usrID
		)
		AND 
		MONTH(OrderDate) = MONTH(CURRENT_DATE()) 
		AND 
		YEAR(OrderDate) = YEAR(CURRENT_DATE())
		and
		ht.StatusOrderID in (4);
end