DELIMITER $$

USE `kutamimba`$$

DROP PROCEDURE IF EXISTS `spUpdateSaldoTabByNorek`$$

CREATE DEFINER=`root`@`%` PROCEDURE `spUpdateSaldoTabByNorek`(vNoRek VARCHAR(50),vDate DATE)
BEGIN

DECLARE done INT DEFAULT FALSE;
DECLARE vTRANS_TAB_ID_NEXT INT;
DECLARE vTRX_DATE_NEXT DATE;
DECLARE vSaldo DECIMAL(19,4);
DECLARE cursor_tab CURSOR FOR
-- START TRANSACTION;

SELECT
trans_tab_id,trx_date
FROM t_trans_tab WHERE no_rek=vNoRek AND trx_date>=vDate
ORDER BY `trx_date`,`trans_tab_id`;
-- COMMIT;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cursor_tab;
read_loop: LOOP
FETCH cursor_tab INTO vTRANS_TAB_ID_NEXT,vTRX_DATE_NEXT;
IF done THEN
LEAVE read_loop;
END IF;
START TRANSACTION;
SELECT
IFNULL((
SELECT SUM(`kredit`-`debet`)
FROM t_trans_tab
WHERE no_rek=vNoRek AND trx_date<vTRX_DATE_NEXT
),0)
+
IFNULL((
SELECT SUM(`kredit`-`debet`)
FROM t_trans_tab
WHERE no_rek=vNoRek AND trx_date=vTRX_DATE_NEXT AND TRANS_TAB_ID<=vTRANS_TAB_ID_NEXT
),0)
INTO vSaldo;

UPDATE t_trans_tab SET saldo=vSaldo WHERE trans_tab_id=vTRANS_TAB_ID_NEXT;
COMMIT;
END LOOP;
CLOSE cursor_tab;
END$$

DELIMITER ;