(pdo-mysql): INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES ('2026-08-26 06:22:41', '', 'grid_cbvcollections_chqretprevmonth', 'Scriptcase', '192.168.0.21', 'access', '')
(pdo-mysql): select count(*) from cbvvoucher v INNER JOIN cbvinvdetails i ON i.cbvvoucherid = v.cbvvoucherid where (('' IS NULL OR ''= '' OR i.SlDivCd = '')) group by v.LocCd WITH ROLLUP
(pdo-mysql): SELECT IFNULL(v.LocCd,'TOTAL') as loccd, i.SlDivCd as i_sldivcd, SUM(CASE WHEN v.VchDate = DATE_FORMAT('', '%Y-%m-%d') THEN i.InvAmt ELSE 0 END) as forthedate, SUM(CASE WHEN v.VchDate BETWEEN DATE_FORMAT('', '%Y-%m-01') AND ''
THEN i.InvAmt ELSE 0 END) as currentmonth, SUM(CASE
WHEN v.VchDate BETWEEN DATE_FORMAT('', '%Y-%m-01') AND ''
AND i.CollectionDate IS NOT NULL
AND i.CollectionDate != '0000-00-00'
THEN i.InvAmt ELSE 0
END) as pymtrecvagnstcbv, SUM(CASE
WHEN v.VchDate BETWEEN DATE_SUB(DATE_FORMAT('','%Y-%m-01'),INTERVAL 1 MONTH)
AND DATE_SUB('',INTERVAL 1 MONTH)
THEN i.InvAmt ELSE 0
END) as prevmonthsamerange, SUM(CASE
WHEN v.VchDate BETWEEN DATE_FORMAT(DATE_SUB('',INTERVAL 1 MONTH),'%Y-%m-01')
AND LAST_DAY(DATE_SUB('',INTERVAL 1 MONTH))
THEN i.InvAmt ELSE 0
END) as previousfullmonth, SUM(CASE
WHEN v.VchDate BETWEEN DATE_SUB(DATE_FORMAT('', '%Y-%m-01'),INTERVAL 2 MONTH)
AND DATE_SUB('',INTERVAL 2 MONTH)
THEN i.InvAmt ELSE 0
END) as twomonthsagosamerange, SUM(CASE
WHEN v.VchDate BETWEEN DATE_FORMAT(DATE_SUB('',INTERVAL 2 MONTH),'%Y-%m-01')
AND LAST_DAY(DATE_SUB('',INTERVAL 2 MONTH))
THEN i.InvAmt ELSE 0
END) as twomonthsagofullmonth from cbvvoucher v INNER JOIN cbvinvdetails i ON i.cbvvoucherid = v.cbvvoucherid where (('' IS NULL OR ''= '' OR i.SlDivCd = '')) group by v.LocCd WITH ROLLUP LIMIT 0,12
Cheque Bounce Comparison Based On Past Month
Processing......
