projects.php 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. Core::addBreadcrumb("/account", "Account");
  3. Core::addBreadcrumb("/account/projects", "Projects");
  4. $customer = Customer::getForAdmin();
  5. $page_title = "$customer->name Projects";
  6. Core::addBreadcrumb("/account/projects?customer_id=$customer->id", $page_title);
  7. $nvp = ["customer_id" => $customer->id];
  8. $id = http::value("id", "int");
  9. $name = http::value("name", "trim");
  10. $year = http::value("year", "int");
  11. if($year === false) {
  12. $year = date("Y");
  13. }
  14. if($id) $nvp["id"] = $id;
  15. if($name) $nvp["name"] = (new Constraint("CONTAINS"))->setValues($name);
  16. if($year) {
  17. $min_dts = "{$year}-01-01 00:00:00";
  18. $max_dts = "{$year}-12-31 23:59:59";
  19. $nvp["dts_start"] = (new Constraint("BETWEEN"))->setValues($min_dts, $max_dts);
  20. }
  21. $projects = Project::query($nvp, ["sort" => "dts_start", "order" => "desc"]);
  22. $templates = Template::load(array_column($projects, "template_id"));
  23. $filter_count = count($nvp) - 1;
  24. View::includeOnce("header", compact("page_title"));
  25. View::include("projects", compact("customer", "filter_count", "projects", "year"));
  26. View::includeOnce("footer");
  27. ?>