(pdo-mysql): INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES ('2026-08-26 06:18:44', '', 'new', 'Scriptcase', '192.168.0.21', 'access', '')
(pdo-mysql): select count(*) from cbvvoucher v INNER JOIN cbvinvdetails i ON i.cbvvoucherid = v.cbvvoucherid INNER JOIN cbvcollections c ON c.cbvvoucherid = v.cbvvoucherid where ((i.SlDivCd='' OR ''='')) 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 = '2025-06-13' THEN v.VchAmt ELSE 0 END) as fromdatetodate, SUM(CASE WHEN v.VchDate >=DATE_FORMAT('2025-06-13','%Y-%m-01') AND v.VchDate <='2025-06-13' THEN v.VchAmt ELSE 0 END) as currentmonth, SUM(CASE WHEN v.VchDate>= DATE_FORMAT('2025-06-13','%Y-%m-01') AND v.VchDate<='2025-06-13' THEN c.CollectionAmt ELSE 0 END) as pymtrecvagnstcbv, SUM(CASE WHEN v.VchDate>= DATE_SUB(DATE_FORMAT('2025-06-13','%Y-%m-01'),INTERVAL 1 MONTH) AND v.VchDate<= DATE_SUB('2025-06-13',INTERVAL 1 MONTH) THEN v.VchAmt ELSE 0 END) as prevmonthsamerange, SUM(CASE WHEN v.VchDate>= DATE_FORMAT(DATE_SUB(DATE_FORMAT('2025-06-13','%Y-%m-01'),INTERVAL 1 MONTH),'%Y-%m-01') AND v.VchDate<= LAST_DAY(DATE_SUB('2025-06-13',INTERVAL 1 MONTH)) THEN v.VchAmt ELSE 0 END) as previousfullmonth, SUM(CASE WHEN v.VchDate BETWEEN DATE_SUB(DATE_FORMAT('2025-06-13','%Y-%m-01'),INTERVAL 2 MONTH) AND DATE_SUB('2025-06-13',INTERVAL 2 MONTH) THEN v.VchAmt ELSE 0 END) as twomonthsagosamerange, SUM(CASE WHEN v.VchDate >=DATE_FORMAT(DATE_SUB('2025-06-13',INTERVAL 2 MONTH),'%Y-%m-01') AND v.VchDate<=LAST_DAY(DATE_SUB('2025-06-13',INTERVAL 2 MONTH)) THEN v.VchAmt ELSE 0 END) as twomonthsagofullmonth from cbvvoucher v INNER JOIN cbvinvdetails i ON i.cbvvoucherid = v.cbvvoucherid INNER JOIN cbvcollections c ON c.cbvvoucherid = v.cbvvoucherid where ((i.SlDivCd='' OR ''='')) group by v.LocCd WITH ROLLUP; LIMIT 0,12
Report of
Processing......
