-- century_emember.sp_SelectCartHeader (PROCEDURE)
begin
	SELECT 	h.CartNo, CartDate, MemberID, 
		OutCode, Out_Name, Out_DateOpen, Out_DateClose, Out_Address,
		IFNULL(Out_Phone, Out_Fax) AS Out_Phone,
		Out_GPS_Lintang, Out_GPS_Bujur,
		SUM(d.Qty * d.SalePrice) AS TotalPrice,
		COUNT(Procod) AS TotalProduct,
		ifnull(SUM(DiscSup), 0) as DiscSup,
		(SUM(d.Qty * DiscCen) + SUM(d.Qty * DiscMember) + SUM(d.Qty * DiscSup)) AS TotalDiscount,
		SUM(d.Qty * (d.SalePrice - DiscCen - DiscMember - DiscSup)) AS GrandTotalPrice
	FROM century_emember.Cart_Header h 
	LEFT JOIN Master_centuryApp.M_Outlet o ON h.Outcode = o.Out_Code
	LEFT JOIN century_emember.Cart_Detail d ON h.CartNo = d.CartNo
	WHERE MemberID = cardNum
	GROUP BY h.CartNo;
end