project.php 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. <?php
  2. /**
  3. * @property int $id
  4. * @property int $customer_id
  5. * @property int $template_id
  6. * @property string $name
  7. * @property int $test_count
  8. * @property int $min_age
  9. * @property int $max_age
  10. * @property float $default_customer_fee
  11. * @property float $default_tester_fee
  12. * @property int $time_of_day
  13. * @property bool $tester_can_claim
  14. * @property string $template_overrides_json
  15. * @property string $dts_start
  16. * @property string $dts_deadline
  17. * @property string $dts_created
  18. * @property string $dts_updated
  19. * @property string $dts_report
  20. * @property string $dts_finished
  21. * @property int $user_id_finished
  22. *
  23. * @method Project get(int $id)
  24. */
  25. class Project extends Model {
  26. const TOD_ANYTIME = "A";
  27. const TOD_DAYTIME = "D";
  28. const TOD_NIGHTTIME = "N";
  29. protected static $table = "project";
  30. protected static $id_field = "id";
  31. protected static $fillable_fields = ["customer_id", "template_id", "name", "test_count", "min_age", "max_age", "default_customer_fee", "default_tester_fee", "time_of_day", "tester_can_claim", "template_overrides_json", "dts_start", "dts_deadline", "dts_created", "dts_updated", "dts_report", "dts_finished", "user_id_finished"];
  32. /**
  33. * @var Test[] $tests
  34. */
  35. protected $tests = null;
  36. // Object methods
  37. /**
  38. * @return Customer
  39. */
  40. public function getCustomer() {
  41. return Customer::get($this->customer_id);
  42. }
  43. /**
  44. * @return Test[]
  45. */
  46. public function getTests() {
  47. if(!is_null($this->tests)) return $this->tests;
  48. $nvp = [];
  49. $nvp["project_id"] = $this->id;
  50. $nvp["status"] = (new Constraint("MORE_THAN"))->setValues(Test::STATUS_CANCELLED);
  51. $this->tests = Test::query($nvp);
  52. return $this->tests;
  53. }
  54. public function getTestCount() {
  55. if(is_null($this->tests)) $this->getTests();
  56. return count($this->tests);
  57. }
  58. public function getPassCount() {
  59. $count = 0;
  60. $tests = $this->getTests();
  61. foreach($tests as $test) {
  62. if(!$test->isPass()) continue;
  63. ++$count;
  64. }
  65. return $count;
  66. }
  67. public function getFailCount() {
  68. $count = 0;
  69. $tests = $this->getTests();
  70. foreach($tests as $test) {
  71. if(!$test->isFail()) continue;
  72. ++$count;
  73. }
  74. return $count;
  75. }
  76. public function getPendingCount() {
  77. $count = 0;
  78. $tests = $this->getTests();
  79. foreach($tests as $test) {
  80. if(!$test->isPending()) continue;
  81. ++$count;
  82. }
  83. return $count;
  84. }
  85. public function getPassRate(): string {
  86. $pass_count = $this->getPassCount();
  87. $fail_count = $this->getFailCount();
  88. $pass_fail_count = $pass_count + $fail_count;
  89. if($pass_fail_count == 0) return "0%";
  90. return (number_format($pass_count / $pass_fail_count, 4) * 100) . "%";
  91. }
  92. public function getLocations() {
  93. $tests = $this->getTests();
  94. return Location::query(["id" => array_column($tests, "location_id")]);
  95. }
  96. public function getDisplayAgeRange() {
  97. if($this->min_age && $this->max_age) {
  98. return $this->min_age . " to " . $this->max_age;
  99. }
  100. else if($this->min_age) {
  101. return "At least " . $this->min_age;
  102. }
  103. else if($this->max_age) {
  104. return "Up to " . $this->max_age;
  105. }
  106. return "No age restriction";
  107. }
  108. public function getNameHtml(): string {
  109. if($this->isAnytime()) {
  110. return htmlspecialchars($this->name);
  111. }
  112. $icon = $this->getTimeOfDayIcon();
  113. $time_of_day = $this->getTimeOfDayText();
  114. return htmlspecialchars($this->name) . " <i class=\"fa fa-fw fa-{$icon}\" data-toggle=\"tooltip\" title=\"{$time_of_day}\"></i>";
  115. }
  116. public function getCompletedPercentage() {
  117. $test_count = $this->test_count;
  118. $tests = $this->getTests();
  119. $completed_tests = array_filter($tests, function($test) {
  120. return $test->status == Test::STATUS_COMPLETED;
  121. });
  122. $completed_test_count = count($completed_tests);
  123. return floor(($completed_test_count / $test_count) * 100);
  124. }
  125. /**
  126. * @return Template
  127. */
  128. public function getTemplate() {
  129. return Template::get($this->template_id);
  130. }
  131. public function getTemplateOverrides() {
  132. $overrides = json_decode($this->template_overrides_json) ?: [];
  133. return $overrides;
  134. }
  135. public function getTimeOfDayText() {
  136. switch($this->time_of_day) {
  137. case self::TOD_ANYTIME: return "Any";
  138. case self::TOD_DAYTIME: return "Day";
  139. case self::TOD_NIGHTTIME: return "Night";
  140. }
  141. }
  142. public function getTimeOfDayIcon() {
  143. switch($this->time_of_day) {
  144. case self::TOD_ANYTIME: return "adjust";
  145. case self::TOD_DAYTIME: return "sun";
  146. case self::TOD_NIGHTTIME: return "moon";
  147. }
  148. }
  149. public function getURL() {
  150. return "/account/projects/{$this->id}";
  151. }
  152. public function getDirectory() {
  153. $directory = ROOT_DIR . "/files/projects/" . $this->id;
  154. if(!file_exists($directory)) mkdir($directory, 0777, true);
  155. return $directory;
  156. }
  157. public function hasInvoicePDF() {
  158. $directory = $this->getDirectory();
  159. return file_exists($directory . "/invoice.pdf");
  160. }
  161. public function isAnytime() {
  162. return $this->time_of_day == self::TOD_ANYTIME;
  163. }
  164. public function isDaytime() {
  165. return $this->time_of_day == self::TOD_DAYTIME;
  166. }
  167. public function isNighttime() {
  168. return $this->time_of_day == self::TOD_NIGHTTIME;
  169. }
  170. public function isPastDeadline() {
  171. $deadline_unix = Util::getUnixTimeFromUTC($this->dts_deadline);
  172. return time() > $deadline_unix;
  173. }
  174. public function isFinished() {
  175. return $this->dts_finished === null;
  176. }
  177. public function markFinished() {
  178. if(!Core::$user) throw new Exception("Trying to mark project as finished while not logged in.");
  179. if(!Core::$user->isAdmin()) throw new Exception("Trying to mark project as finished with non-admin account.");
  180. $this->dts_finished = Util::getUTCDateTime();
  181. $this->user_id_finished = Core::$user->id;
  182. return $this->commit();
  183. }
  184. public function markUnfinished() {
  185. $this->dts_finished = null;
  186. $this->user_id_finished = null;
  187. return $this->commit();
  188. }
  189. public function getDisplayReportMonth() {
  190. $report_month = "-";
  191. if($this->dts_report) {
  192. $dt_report = new DateTime($this->dts_report . " UTC");
  193. $report_month = $dt_report->format("M Y");
  194. }
  195. return $report_month;
  196. }
  197. public function getDataTableRow() {
  198. $tests = $this->getTests();
  199. return [
  200. "id" => (int) $this->id,
  201. "rowId" => "project-row-{$this->id}",
  202. "name" => $this->name,
  203. "testCount" => count($tests),
  204. "timeOfDay" => $this->getTimeOfDayText(),
  205. "unixStart" => Util::getUnixTimeFromUTC($this->dts_start),
  206. "unixEnd" => Util::getUnixTimeFromUTC($this->dts_end),
  207. "reportMonth" => $this->getDisplayReportMonth(),
  208. "unixReport" => $this->dts_report ? Util::getUnixTimeFromUTC($this->dts_report) : 0,
  209. ];
  210. }
  211. public function getTestResultsUrl(): string {
  212. $customer = $this->getCustomer();
  213. $customer_slug = Util::slugWithId($customer->name, $customer->id);
  214. $project_slug = Util::slugWithId($this->name, $this->id);
  215. return "/account/test-results/{$customer_slug}/{$project_slug}";
  216. }
  217. }