hasPermission($project)) throw new Exception("You do not have permission to access this resource."); header("Content-Type: text/csv"); header("Content-Disposition: attachment; filename=\"export.csv\""); header("Cache-Control: private, max-age=0, must-revalidate"); header("Pragma: public"); $template = $project->getTemplate(); $object = json_decode($template->json); $fields_1 = $object->beforeTest; $fields_2 = $object->duringTest; $fields = array_merge($fields_1, $fields_2); $fields = array_filter($fields, function($field) { if(!isset($field->name)) return false; if($field->type == "file") return false; return true; }); $tests = Test::query([ "project_id" => $id, "status" => (new Constraint("NOT_EQUALS"))->setValues(Test::STATUS_CANCELLED), ]); $locations = Location::load(array_column($tests, "location_id")); $testers = User::load(array_column($tests, "tester_id")); $handle = fopen("php://output", "w"); $field_names = [ "Project ID", "Project Name", "Template Name", "Test ID", "Test Status", "Test Result", "Location Name", "Legal Entity", "Address", "Email", "Phone", "Region", "Internal ID", "Area Manager", "Tester Age", "Tester Gender", "Travel Costs", "Date", "Start Time", "End Time", "Duration", ]; foreach($fields as $field) { $field_names[] = $field->label; } fputcsv($handle, $field_names); foreach($tests as $test) { $location = $test->getLocation(); $tester = $test->getTester(); $values = $test->getValues(true); $test_date = ""; $test_start = ""; $test_end = ""; $test_duration = ""; $result = "Pending"; $age = ""; $gender = ""; $travel_costs = ""; $output = []; $output[] = $id; $output[] = $project->name; $output[] = $template->name; $output[] = $test->id; $output[] = $test->getStatusText(); if(!is_null($test->pass)) { $result = $test->pass ? "Pass" : "Fail"; $test_start_dt = new DateTime($test->dts_start); $test_end_dt = new DateTime($test->dts_end); $test_duration_diff = $test_start_dt->diff($test_end_dt, true); $test_date = $test_start_dt->format("d/m/Y"); $test_start = $test_start_dt->format("H:i:s"); $test_end = $test_end_dt->format("H:i:s"); $test_duration = $test_duration_diff->h . ":" . $test_duration_diff->i . ":" . $test_duration_diff->s; if($tester) { $tester_dob_dt = new DateTime($tester->date_of_birth); $dob_diff = $test_start_dt->diff($tester_dob_dt, true); $age = $dob_diff->y; $gender = $tester->gender; $travel_costs = $test->test_travel_costs; } } $output[] = $result; $output[] = $location->name; $output[] = $location->legal_entity_name; $output[] = $location->getDisplayAddress(); $output[] = $location->email; $output[] = $location->phone; $output[] = $location->region; $output[] = $location->internal_id; $output[] = $location->area_manager; $output[] = $age; $output[] = $gender; $output[] = $travel_costs; $output[] = $test_date; $output[] = $test_start; $output[] = $test_end; $output[] = $test_duration; foreach($fields as $field) { $field_name = $field->name; $value = isset($test->$field_name) ? $test->$field_name : ($values[$field->name] ?? ""); if(!empty($field->displayStrings)) { $index = array_search($value, $field->values); $value = $field->displayStrings[$index]; } $output[] = $value; } fputcsv($handle, $output); } fclose($handle); ?>