{"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_manpower_agency_name`, `project_manpower_agency_code`, `civil_work_order_number`, `civil_task_actual_contract_rate`\r\n    FROM civil_task_actual_contract_view\r\n     WHERE Date(civil_task_actual_added_on) > Date('2021-10-12') 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":[]}