-- pharmanet.sp_GetAccomplishedSales_HA (PROCEDURE)
begin
	SELECT 	ifnull(concat('Rp ', format(SUM(OrderProductQty*OrderProductPriceAfterDiscount), 0)),'-') AS Total
	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 = outID
		AND 
		MONTH(OrderDate) = MONTH(CURRENT_DATE()) 
		AND 
		YEAR(OrderDate) = YEAR(CURRENT_DATE());
end