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 Name", "Test Status", "Test Result", "Location Name", "Address", "Region", "Internal ID", "Area Manager", "Date", ]; 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[] = $project->name; $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->getDisplayAddress(); $output[] = $location->region; $output[] = $location->internal_id; $output[] = $location->area_manager; $output[] = $test_date; 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); ?>