IN `tanggal` VARCHAR(50)

BEGIN
TRUNCATE tbl_wt0_tmp;

INSERT INTO tbl_wt0_tmp
SELECT DISTINCT * FROM tbl_wt0 WHERE TGL1=tanggal;

DELETE FROM tbl_wt0 WHERE TGL1 = tanggal;

INSERT INTO tbl_wt0
SELECT DISTINCT * FROM tbl_wt0_tmp;
END

	IN `shop` VARCHAR(4),
	IN `tgl` VARCHAR(50)

BEGIN
DECLARE result INT;
SELECT
dt.SHOP,
SUM(dt.GROSS) AS SALES_GROSS_DRY
-- dt.TANGGAL,
-- CONCAT("%-",tgl) AS tt
FROM
(
	SELECT DISTINCT
	a.SHOP,
	a.GROSS,
	a.TANGGAL,
	a.PRDCD,
	a.CAT_COD,
	a.`DIV`
	FROM tbl_dt a IGNORE INDEX(idx_cat,idx_div,idx_shop)
	
	WHERE
	(
		MATCH(a.SHOP) AGAINST(shop IN BOOLEAN MODE)
	)
	AND
	(
		a.TANGGAL LIKE CONCAT("%-",tgl)
	)
) AS dt
WHERE 
(
	dt.CAT_COD NOT IN ("34202","45002")
	AND
	dt.CAT_COD NOT LIKE "5%"
)
AND
(
	dt.PRDCD IS NOT NULL 
	OR
	dt.PRDCD NOT LIKE "0000%%"
	OR
	dt.PRDCD NOT IN (SELECT PLU FROM tbl_prodsus WHERE MODUL RLIKE "point")
)
AND
(
	dt.`DIV` NOT IN (54,31,32)
);
-- RETURN result;
END

	IN `MENU` VARCHAR(50),
	IN `T_AWAL` DATE,
	IN `T_AKHIR` DATE

BEGIN
	SELECT
		a.PRDCD,
		a.`DESC`,
		SUM(a.GROSS) AS gross,
		SUM(a.gross-(a.QTY * a.HPP)) AS mrgn,
		a.MENU_RET
	FROM tbl_tmp_sls_mrgn a
	WHERE a.MENU_RET = MENU AND a.TANGGAL BETWEEN T_AWAL AND T_AKHIR
	GROUP BY a.PRDCD;
END

BEGIN
	INSERT INTO idm_b.tbl_mas_toko
	SELECT 
	"",
	a.SHOP AS KdToko,
	a.`DESC` AS NAMATOKO,
	a.BUKA,
	(
		CASE
			WHEN a.WIL = "TTE" THEN "7"
			WHEN a.WIL = "ABN" THEN "9"
			WHEN a.WIL = "MDO" THEN "1"
		END
	) BASE,
	(
		CASE
			WHEN a.WIL = "TTE" THEN "IDM TAFURE"
			WHEN a.WIL = "ABN" THEN "Office ABN"
			WHEN a.WIL = "MDO" THEN "Office"
		END
	) BASE,
	0,
	0,
	"Y",
	CURRENT_TIMESTAMP()
	FROM tbl_direk a
	WHERE a.SHOP NOT IN (SELECT gg.kdtoko FROM idm_b.tbl_mas_toko gg);
	UPDATE idm_b.tbl_mas_toko SET FlagAktif = "N" WHERE kdtoko NOT IN (SELECT SHOP FROM tbl_direk);
	UPDATE idm_b.tbl_mas_toko SET FlagAktif = "Y" WHERE kdtoko IN (SELECT SHOP FROM tbl_direk);
END