{"iTotalDisplayRecords":"6","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `sales_plan_id`, `planning_from_date`, `planning_to_date`, `sales_plan_status`, `added_by`, `added_on`, `approved_by`, `approved_on`, `added_user_name`\r\n    FROM sales_plan_view\r\n     WHERE (`sales_plan_status` = 'Draft' OR `sales_plan_status` = 'Pending') \r\n    ORDER BY planning_from_date ASC\r\n    \r\n    ","aaData":[{"sales_plan_id":"40","planning_from_date":"2024-05-01","planning_to_date":"2024-05-31","sales_plan_status":"Pending","added_by":"171316664041011700","added_on":"2024-05-23 17:57:36","approved_by":"","approved_on":"1970-01-01 10:10:10","added_user_name":"NAVEEN GIRISH","total_planned_area":"75000","total_site_visits":"480","total_leads":"4800"},{"sales_plan_id":"44","planning_from_date":"2024-08-01","planning_to_date":"2024-08-31","sales_plan_status":"Draft","added_by":"171316664041011700","added_on":"2024-08-10 12:02:27","approved_by":"","approved_on":"1970-01-01 10:10:10","added_user_name":"NAVEEN GIRISH","total_planned_area":"49882","total_site_visits":"229","total_leads":"2038"},{"sales_plan_id":"59","planning_from_date":"2025-11-01","planning_to_date":"2025-11-30","sales_plan_status":"Draft","added_by":"171464700312440400","added_on":"2025-11-13 21:57:36","approved_by":"","approved_on":"1970-01-01 10:10:10","added_user_name":"Admin","total_planned_area":"120000","total_site_visits":null,"total_leads":null},{"sales_plan_id":"63","planning_from_date":"2026-08-01","planning_to_date":"2026-08-31","sales_plan_status":"Draft","added_by":"171464700312440400","added_on":"2026-08-07 09:58:56","approved_by":"","approved_on":"1970-01-01 10:10:10","added_user_name":"Admin","total_planned_area":"8000","total_site_visits":null,"total_leads":null},{"sales_plan_id":"65","planning_from_date":"2026-08-01","planning_to_date":"2026-08-31","sales_plan_status":"Draft","added_by":"17754780297216000","added_on":"2026-08-07 13:01:24","approved_by":"","approved_on":"1970-01-01 10:10:10","added_user_name":"Girish C M","total_planned_area":"256500","total_site_visits":null,"total_leads":null},{"sales_plan_id":"64","planning_from_date":"2026-08-01","planning_to_date":"2026-08-31","sales_plan_status":"Draft","added_by":"17754780297216000","added_on":"2026-08-07 12:55:11","approved_by":"","approved_on":"1970-01-01 10:10:10","added_user_name":"Girish C M","total_planned_area":"162000","total_site_visits":null,"total_leads":null}]}