project_edit.php 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135
  1. <?php
  2. $project = Project::get($id);
  3. if(!$project) throw new Exception("Project not found.");
  4. Core::addScript("public/js/app-project-form.js");
  5. $page_title = "Edit Project";
  6. $customer = $project->getCustomer();
  7. Core::addBreadcrumb("/account", "Account");
  8. Core::addBreadcrumb("/account/projects", "Projects");
  9. Core::addBreadcrumb("/account/projects?customer_id=$customer->id", "$customer->name Projects");
  10. Core::addBreadcrumb("/account/projects/$id", $project->name);
  11. Core::addBreadcrumb("/account/projects/$id/edit", $page_title);
  12. // Check templates
  13. $templates = $customer->getTemplates();
  14. $tests = $project->getTests();
  15. $location_ids = array_column($tests, "location_id");
  16. $submit = http::value("submit");
  17. if($submit) {
  18. try {
  19. Core::validateCSRFToken($submit);
  20. $new_location_ids = http::value("location_ids");
  21. $new_location_ids = explode(", ", $new_location_ids);
  22. $new_location_ids = array_filter($new_location_ids);
  23. $location_ids_to_add = array_diff($new_location_ids, $location_ids);
  24. $location_ids_to_delete = array_diff($location_ids, $new_location_ids);
  25. $project->template_id = http::value("template_id", "int");
  26. $project->name = http::value("name", "trim");
  27. $project->test_count = http::value("test_count", "int");
  28. $project->min_age = http::value("min_age", "int");
  29. $project->max_age = http::value("max_age", "int");
  30. $project->default_tester_fee = http::value("default_tester_fee", "float");
  31. $project->time_of_day = http::value("time_of_day", "trim");
  32. $project->tester_can_claim = http::value("tester_can_claim", "trim");
  33. $date_start = http::getDateFromFields("date_start");
  34. $date_deadline = http::getDateFromFields("date_deadline");
  35. $date_report = http::getDateFromFields("date_report");
  36. $form_exception = new FormException;
  37. if(empty($project->template_id)) $form_exception->addError("Template is required.");
  38. else {
  39. $template = Template::get($project->template_id);
  40. if($template->customer_id != $customer->id) $form_exception->addError("Invalid template selected.");
  41. }
  42. if(empty($project->name)) $form_exception->addError("Name is required.");
  43. if(empty($project->test_count)) $form_exception->addError("Test count is required.");
  44. if(empty($project->min_age)) $form_exception->addError("Minimum age is required.");
  45. if(empty($project->max_age)) $form_exception->addError("Maximum age is required.");
  46. if(empty($project->default_tester_fee)) $form_exception->addError("Default tester fee is required.");
  47. if(empty($project->time_of_day)) $form_exception->addError("Time of day is required.");
  48. else if(!in_array($project->time_of_day, ["A", "D", "N"])) $form_exception->addError("Invalid time of day selected.");
  49. if(empty($date_start)) $form_exception->addError("Start Date is required.");
  50. if(empty($date_deadline)) $form_exception->addError("Deadline is required.");
  51. if($project->min_age > $project->max_age) $form_exception->addError("Minimum age cannot be greater than maximum age.");
  52. $unix_start = strtotime($date_start . " 00:00:00");
  53. $unix_deadline = strtotime($date_deadline . " 23:59:59");
  54. $unix_report = null;
  55. if(!empty($date_report)) {
  56. $unix_report = strtotime($date_report . " 12:00:00");
  57. }
  58. $project->dts_start = Util::getDateTime($unix_start);
  59. $project->dts_deadline = Util::getDateTime($unix_deadline);
  60. $project->dts_report = is_null($unix_report) ? null : Util::getDateTime($unix_report);
  61. if($unix_start > $unix_deadline) $form_exception->addError("Start Date cannot be after the Deadline.");
  62. // Verify location IDs
  63. Location::load($location_ids_to_add);
  64. foreach($location_ids_to_add as $location_id) {
  65. $location = Location::get($location_id);
  66. if(!$location) $form_exception->addError("An invalid location was picked.");
  67. if($location->customer_id != $customer->id) $form_exception->addError("An invalid location was picked.");
  68. }
  69. if($form_exception->hasErrors()) throw $form_exception;
  70. $success = $project->commit();
  71. if(!$success) throw new Exception("Project could not be added at this time. Please try again later.");
  72. // Create test for new location IDs
  73. foreach($location_ids_to_add as $location_id) {
  74. $test = new Test;
  75. $test->project_id = $project->id;
  76. $test->location_id = $location_id;
  77. $test->status = Test::STATUS_UNASSIGNED;
  78. $test->dts_created = Util::getDateTime();
  79. $success = $test->commit();
  80. if(!$success) throw new Exception("Test cannot be created, please try again later.");
  81. }
  82. // Cancel tests for removed location IDs
  83. foreach($location_ids_to_delete as $location_id) {
  84. $test = Test::queryOne([
  85. "project_id" => $project->id,
  86. "location_id" => $location_id,
  87. "status" => (new Constraint("MORE_THAN"))->setValues(Test::STATUS_CANCELLED)
  88. ]);
  89. if($test) {
  90. $test->status = Test::STATUS_CANCELLED;
  91. $test->dts_updated = Util::getDateTime();
  92. $test->commit();
  93. }
  94. }
  95. Core::addAlert("success", "Project updated successfully.");
  96. HTTP::redirect("/account/projects/$project->id");
  97. }
  98. catch(FormException $e) {
  99. $e->generateAlerts();
  100. }
  101. catch(Exception $e) {
  102. Core::addAlert("danger", $e->getMessage());
  103. }
  104. }
  105. $locations = $customer->getLocations();
  106. View::includeOnce("header", compact("page_title"));
  107. View::include("project_form", compact("project", "templates", "locations", "location_ids"));
  108. View::includeOnce("footer");
  109. ?>