{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `civil_task_actual_id`, `civil_task_actual_task`, `civil_task_actual_date`, `civil_task_actual_vendor`, `civil_task_actual_measurement`, `civil_task_actual_measurement_type`, `civil_task_actual_resource_type`, `civil_task_actual_work_type`, `civil_task_actual_status`, `civil_task_actual_remark`, `civil_task_actual_added_by`, `civil_task_actual_added_on`, `civil_task_actual_reviewed_by`, `civil_task_actual_reviewed_on`, `civil_task_actual_approved_by`, `civil_task_actual_approved_on`, `civil_task_actual_added_user_name`, `project_process_id`, `project_process_task_status`, `project_process_task_location_id`, `project_process_task_type`, `project_plan_process_name`, `project_master_name`, `project_management_master_id`, `project_process_master_id`, `project_process_master_order`, `project_site_location_mapping_master_name`, `project_site_location_mapping_master_order`, `project_process_master_name`, `project_task_master_name`, `project_task_master_id`, `project_task_master_order`, `project_task_master_uom`, `project_uom_name`, `project_plan_id`, `project_machine_vendor_master_name`, `project_machine_vendor_master_code`, `civil_task_actual_machine`, `civil_task_actual_start`, `civil_task_actual_end`, `civil_task_actual_off_duration`, `civil_task_actual_rate_per_hour`, `civil_task_actual_bata`, `civil_task_actual_extra_charge`, `civil_task_actual_fuel_charge`, `project_machine_master_name`, `project_machine_master_id_number`, `project_machine_master_machine_type`, `project_machine_type_master_name`\r\n    FROM civil_task_actual_machine_view\r\n     WHERE Date( civil_task_actual_added_on ) > Date('2021-10-10') AND `civil_task_actual_status` != 'Invoiced'\r\n    ORDER BY civil_task_actual_date DESC, project_master_name ASC , project_process_master_order ASC, project_task_master_order ASC, project_site_location_mapping_master_order ASC\r\n    \r\n    ","aaData":[]}