{"iTotalDisplayRecords":"5","query":"\n    SELECT SQL_CALC_FOUND_ROWS `travel_plan_id`, `project_id`, `travel_plan_reference_number`, `travel_from_date_time`, `travel_to_date_time`, `travel_from_location`, `travel_to_location`, `vehicle_type_id`, `vehicle_id`, `remarks`, `status`, `added_by`, `added_on`, `project_name`, `vehicle_type_name`, `vehicle_number`, `added_by_user_name`, `reporting_user`\n    FROM travel_plan_view\n     Where (`reporting_user` = '' OR `added_by` = '') AND (`status` = 'Requested' OR `status` = 'Approved')\n    ORDER BY project_name ASC\n    \n    ","aaData":[{"travel_plan_id":"642","project_id":"103","travel_plan_reference_number":"KNS-TP-0642","travel_from_date_time":"2024-11-20 09:30:00","travel_to_date_time":"2024-11-20 14:00:00","travel_from_location":"MALLESHWARM","travel_to_location":"Kns AMORA KUMBALAGUD","vehicle_type_id":"2","vehicle_id":"0","remarks":"Kns AMORA Spot inspection by ELECTRICAL INSPECTOR ","status":"Requested","added_by":"165244377312120200","added_on":"2024-11-19 11:52:06","project_name":"KNS Amora","vehicle_type_name":"CAR","vehicle_number":null,"added_by_user_name":"JEEVAN.K.R","reporting_user":""},{"travel_plan_id":"575","project_id":"92","travel_plan_reference_number":"KNS-TP-0575","travel_from_date_time":"2024-09-20 08:30:00","travel_to_date_time":"2024-09-20 15:30:00","travel_from_location":"KNS OFFICE ATIGUPPE","travel_to_location":"KNS CANDRILL DODDABA","vehicle_type_id":"2","vehicle_id":"0","remarks":"SPOT INSPECTION FROM BESOM AEE","status":"Requested","added_by":"165244377312120200","added_on":"2024-09-19 12:34:15","project_name":"KNS CANDRILL","vehicle_type_name":"CAR","vehicle_number":null,"added_by_user_name":"JEEVAN.K.R","reporting_user":""},{"travel_plan_id":"649","project_id":"92","travel_plan_reference_number":"KNS-TP-0649","travel_from_date_time":"2024-11-28 11:40:00","travel_to_date_time":"2024-11-28 15:20:00","travel_from_location":"Kns office ","travel_to_location":"Kns candrill","vehicle_type_id":"2","vehicle_id":"0","remarks":"Spot inspection from AEE and AE FOR ELECTRICAL ESTIMATION ","status":"Requested","added_by":"165244377312120200","added_on":"2024-11-27 18:18:55","project_name":"KNS CANDRILL","vehicle_type_name":"CAR","vehicle_number":null,"added_by_user_name":"JEEVAN.K.R","reporting_user":""},{"travel_plan_id":"624","project_id":"114","travel_plan_reference_number":"KNS-TP-0624","travel_from_date_time":"2024-04-23 09:00:19","travel_to_date_time":"2024-04-23 20:00:19","travel_from_location":"KNS Office ","travel_to_location":"KNS Samooha ","vehicle_type_id":"2","vehicle_id":"0","remarks":"Survey","status":"Requested","added_by":"16263246927723800","added_on":"2024-11-07 12:25:51","project_name":"KNS SAMOOHA 1 and 2","vehicle_type_name":"CAR","vehicle_number":null,"added_by_user_name":"BHARATH KUMAR.K.N","reporting_user":""},{"travel_plan_id":"638","project_id":"40","travel_plan_reference_number":"KNS-TP-0638","travel_from_date_time":"2024-11-14 09:15:10","travel_to_date_time":"2024-11-14 18:00:01","travel_from_location":"KNS Office","travel_to_location":"Hosakote","vehicle_type_id":"2","vehicle_id":"0","remarks":"KNS Sir Assign Some Work (To Visit Proposed Land).","status":"Requested","added_by":"16263246927723800","added_on":"2024-11-14 09:05:11","project_name":"PROJECT-KNS","vehicle_type_name":"CAR","vehicle_number":null,"added_by_user_name":"BHARATH KUMAR.K.N","reporting_user":""}]}