| 1234567891011121314151617181920212223242526272829303132333435363738394041 |
- <?php
- Core::addBreadcrumb("/account", "Account");
- Core::addBreadcrumb("/account/projects", "Projects");
- Core::addScript("public/js/app-projects.js");
- $customer = Customer::getForAdmin();
- $page_title = "$customer->name Projects";
- Core::addBreadcrumb("/account/projects?customer_id=$customer->id", $page_title);
- $nvp = ["customer_id" => $customer->id];
- $id = http::value("id", "int");
- $name = http::value("name", "trim");
- $year = http::value("year", "int");
- if($year === false) {
- $year = date("Y");
- }
- if($id) $nvp["id"] = $id;
- if($name) $nvp["name"] = (new Constraint("CONTAINS"))->setValues($name);
- if($year) {
- $min_dts = "{$year}-01-01 00:00:00";
- $max_dts = "{$year}-12-31 23:59:59";
- $nvp["dts_start"] = (new Constraint("BETWEEN"))->setValues($min_dts, $max_dts);
- }
- $projects = Project::query($nvp, ["sort" => "dts_start", "order" => "desc"]);
- $templates = Template::load(array_column($projects, "template_id"));
- $filter_count = count($nvp) - 1;
- View::includeOnce("header", compact("page_title"));
- View::include("projects", compact("customer", "filter_count", "projects", "year"));
- View::includeOnce("footer");
- ?>
|