-- century_emember.sp_CheckCartPriceStock (PROCEDURE)
BEGIN
	SELECT d.CartNo, d.Procod, (IFNULL(d.SalePrice,0) - IFNULL(DiscCen,0) - IFNULL(DiscMember,0) - 
	IFNULL(DiscSup,0)) as CartPrice, IFNULL(Pro_SellPrice,0)-IFNULL(Cash_Discount,0) as ProductPrice
	FROM century_emember.Cart_Detail d
	LEFT JOIN Master_centuryApp.MD_Product p ON p.Pro_Code = d.Procod
	left join (	
			SELECT * 
			FROM CenturyOutlet_887.T_CashReg_ProgramPromosi
			WHERE DATE(NOW())>= DATE(Cash_TglAwal) and DATE(NOW())<= DATE(Cash_TglAkhir)
		) as t 
	on p.Pro_Code = t.Cash_Code
	WHERE CartNo = cartid
	AND ((ifnull(d.SalePrice,0) - ifnull(DiscCen,0) - ifnull(DiscMember,0) - 
	ifnull(DiscSup,0)) != ifnull(Pro_SellPrice,0)-ifnull(Cash_Discount,0)
	-- OR productStock=0
	);
END