Warning: pg_query(): Query failed: ERROR: invalid input syntax for type numeric: "" in /usr/local/apache24/htdocs/NGDRS_Website/components/db_connect.php on line 410
Cannot execute query: SELECT count (state_id) AS total_state, (select sum(office::NUMERIC) FROM public.ngdrs_all_state_data Where office !='NA' AND from_date = '2017-01-01' AND to_date = '2024-07-26') As total_sro , (select sum(registered::NUMERIC) FROM public.ngdrs_all_state_data Where registered !='NA' AND from_date = '2017-01-01' AND to_date = '2024-07-26') As total_registered_doc, (select sum(submitted::NUMERIC) FROM public.ngdrs_all_state_data Where submitted !='NA' AND from_date = '2017-01-01' AND to_date = '2024-07-26') As total_submitted_doc , (select round(sum(rev_collection::NUMERIC)/100000,2) FROM public.ngdrs_all_state_data Where rev_collection !='NA' AND from_date = '2017-01-01' AND to_date = '2024-07-26') As rev_collection, (select sum(appointment::NUMERIC) FROM public.ngdrs_all_state_data Where appointment !='NA' AND from_date = '2017-01-01' AND to_date = '2024-07-26') As total_appointment_doc FROM public.ngdrs_all_state_data WHERE from_date = '2017-01-01' AND to_date = '2024-07-26'