SELECT tlm_regionid AS id,
tg_region_desc,SUM(PDEMAND) AS DEMAND, SUM(OUTSTANDING) AS OUTSTANDING,TPSD_CREATE_DATE FROM
(SELECT LOCATION,SUM(PDEMAND) AS PDEMAND,SUM(OUTSTANDING) AS OUTSTANDING,TPSD_CREATE_DATE FROM (
SELECT S.`TPSD_LOC_ID` AS LOCATION,SUM(S.tpsd_oustanding_amt) AS PDEMAND,( SUM(tpsd_oustanding_amt) - SUM(tpsd_collection_amt) ) AS OUTSTANDING,TPSD_CREATE_DATE FROM tp_proposal_detail P
INNER JOIN tp_location_master on TLM_LOC_ID = TPD_LOC_ID
INNER join tp_applicationform1_detail ON tpd_propid = TAFI_APPL_ID
INNER JOIN tp_payment_status_details S ON S.tpsd_application_id = P.tpd_propid
WHERE ((TPD_STATUS = 'A' and TPSD_PAY_TYPE IN ('O','P')) or (TPD_STATUS != 'R' and TPSD_PAY_TYPE = 'P' and TPSD_STATUS IN ('A','P')) or (TPD_STATUS = 'R' and TPSD_PAY_TYPE = 'P' and TPSD_STATUS = 'A')) AND S.`TPSD_MOD_ID` IN (2,8) and TPD_RISK_FLAG IN('LR','MR') GROUP BY P.tpd_propid
UNION ALL
SELECT S.`TPSD_LOC_ID` AS LOCATION, SUM(S.tpsd_oustanding_amt) AS PDEMAND,( SUM(tpsd_oustanding_amt) - SUM(tpsd_collection_amt) ) AS OUTSTANDING,TPSD_CREATE_DATE FROM tp_application_detail P
JOIN tp_proposal_detail ON tp_proposal_detail.TPD_PROPID = P.TPAD_PROPID
INNER JOIN tp_location_master on TLM_LOC_ID = TPD_LOC_ID
INNER join tp_applicationform1_detail ON tpd_propid = TAFI_APPL_ID
INNER JOIN tp_payment_status_details S ON S.tpsd_application_id = P.tpad_propid
WHERE ((tpad_status = 'A' and TPSD_PAY_TYPE IN ('O','P')) or (tpad_status != 'R' and TPSD_PAY_TYPE = 'P' and TPSD_STATUS IN ('A','P')) or (tpad_status = 'R' and TPSD_PAY_TYPE = 'P' and TPSD_STATUS = 'A')) AND P.TPAD_MOD_ID = S.`TPSD_MOD_ID`
AND P.TPAD_APPID = S.`TPSD_APPID` and TPD_RISK_FLAG IN('LR','MR')
GROUP BY P.tpad_propid
)AS A GROUP BY LOCATION) AS B
INNER JOIN tp_location_master
ON tlm_loc_id = B.LOCATION
INNER JOIN tp_region_master
ON tg_regionid = tlm_regionid
WHERE ( B.LOCATION != ''
OR B.LOCATION != '0' ) GROUP BY tlm_regionid
Fatal error: Uncaught ArgumentCountError: Too few arguments to function rgDistULBDashboard::getRegion(), 0 passed in /var/www/html/uat/general/risk_base_dashboard.php on line 536 and exactly 1 expected in /var/www/html/uat/Classes/risk_base_dashboard.class.php:101
Stack trace:
#0 /var/www/html/uat/general/risk_base_dashboard.php(536): rgDistULBDashboard->getRegion()
#1 /var/www/html/uat/index.php(375): include('/var/www/html/u...')
#2 {main}
thrown in
/var/www/html/uat/Classes/risk_base_dashboard.class.php on line
101
