{"iTotalDisplayRecords":"4","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `id`, `site_id`, `khatha_document`, `applied_date`, `received_date`, `requested_amount`, `paid_amount`, `payment_requested_on`, `payment_paid_on`, `added_by`, `added_on`, `project_name`, `project_id`, `site_no`, `crm_site_status`, `site_area`, `site_premium_type`, `dimension_name`, `site_type_name`, `status_name`, `status_num_days`, `release_status_name`, `site_bank_name`, `dimension_length`, `dimension_breadth`, `site_featured`, `site_cost`, `site_type_id`, `site_status_id`, `site_remarks`, `site_release_status_id`, `site_bank_id`, `site_mortgaged_on`, `site_released_on`\r\n    FROM khatha_payment_first\r\n     Where `paid_amount` = '0' \r\n    ORDER BY payment_requested_on asc\r\n    \r\n    ","aaData":[{"sl_number":1,"id":"3545","site_id":"2567","khatha_document":"documents\/registration_doc\/202201281643365122.pdf","applied_date":"2022-01-28","received_date":"2022-01-28","requested_amount":"0","paid_amount":"0","payment_requested_on":"2022-01-28","payment_paid_on":"2022-01-28","added_by":"158434344063237500","added_on":"2022-01-28 15:48:42","project_name":"KNS OJAS PHASE-B","project_id":"12","site_no":"91","crm_site_status":"6","site_area":"1500.00","site_premium_type":"2","dimension_name":"30 x 50","site_type_name":"West & Park","status_name":"Katha Transfer","status_num_days":"60","release_status_name":"DR","site_bank_name":"Not Mortgage","dimension_length":"30","dimension_breadth":"50","site_featured":"1","site_cost":"","site_type_id":"41","site_status_id":"6","site_remarks":"","site_release_status_id":"9","site_bank_id":"5","site_mortgaged_on":"0000-00-00","site_released_on":"0000-00-00"},{"sl_number":2,"id":"4965","site_id":"5818","khatha_document":"","applied_date":"2023-11-01","received_date":"2023-11-01","requested_amount":"0","paid_amount":"0","payment_requested_on":"2023-11-01","payment_paid_on":"2023-11-01","added_by":"161362538893167300","added_on":"2024-05-23 12:40:58","project_name":"KNS ALORA","project_id":"33","site_no":"25","crm_site_status":"8","site_area":"2400.00","site_premium_type":"2","dimension_name":"40 x 60","site_type_name":"Facing 60 feet Main Road \/North Facing","status_name":"Management Blocked","status_num_days":"-1","release_status_name":"RR","site_bank_name":"HDFC","dimension_length":"40","dimension_breadth":"60","site_featured":"1","site_cost":"","site_type_id":"12","site_status_id":"8","site_remarks":"OK","site_release_status_id":"1","site_bank_id":"3","site_mortgaged_on":"2023-06-16","site_released_on":"2024-05-23"},{"sl_number":3,"id":"4980","site_id":"5848","khatha_document":"","applied_date":"2023-11-01","received_date":"2023-11-01","requested_amount":"0","paid_amount":"0","payment_requested_on":"2023-11-01","payment_paid_on":"2023-11-01","added_by":"161362538893167300","added_on":"2024-05-23 14:25:41","project_name":"KNS ALORA","project_id":"33","site_no":"164","crm_site_status":"1","site_area":"2884.75","site_premium_type":"1","dimension_name":"ODD","site_type_name":"East Facing","status_name":"Available","status_num_days":"-1","release_status_name":"RR","site_bank_name":"HDFC","dimension_length":"0","dimension_breadth":"0","site_featured":"1","site_cost":"","site_type_id":"1","site_status_id":"1","site_remarks":"ok","site_release_status_id":"1","site_bank_id":"3","site_mortgaged_on":"2023-06-17","site_released_on":"2024-05-23"},{"sl_number":4,"id":"5443","site_id":"5205","khatha_document":"","applied_date":"2024-11-01","received_date":"2024-11-01","requested_amount":"3000","paid_amount":"0","payment_requested_on":"2026-01-16","payment_paid_on":"2024-11-01","added_by":"15579842866620500","added_on":"2026-01-16 11:27:41","project_name":"KNS FRESCO","project_id":"30","site_no":"159","crm_site_status":"5","site_area":"1200.00","site_premium_type":"2","dimension_name":"30 x 40","site_type_name":"South West Corner","status_name":"Registration","status_num_days":"30","release_status_name":"RR","site_bank_name":"Walton 2","dimension_length":"30","dimension_breadth":"40","site_featured":"1","site_cost":"","site_type_id":"8","site_status_id":"5","site_remarks":"OK","site_release_status_id":"1","site_bank_id":"36","site_mortgaged_on":"2024-08-14","site_released_on":"2023-04-27"}]}