| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101 |
- <?php /** @noinspection PhpUnhandledExceptionInspection */
- namespace App;
- use App\Constraint\NotEqualsConstraint;
- use App\Enums\SaleStatuses;
- $core = Core::getInstance();
- $user = $core->getUser();
- $user->requireAdmin();
- $core->addBreadcrumb("/leads", __("Leads"));
- $nvp = ["dts_deleted" => null];
- $request = Request::fromRequest();
- $customer_id = $request->int("customer_id");
- if($customer_id) {
- $customer = Customer::get($customer_id);
- if($customer) {
- $nvp["location_id"] = array_column($customer->getLocations(), "id");
- }
- else {
- $nvp["location_id"] = 0;
- }
- }
- $location_id = $request->int("location_id");
- if($location_id) {
- $nvp["location_id"] = $location_id;
- }
- $status = $request->int("status");
- if($status !== null) {
- $nvp["status"] = $status;
- }
- $number = $request->int("number");
- if($number) {
- $nvp["id"] = $number - 999;
- }
- $custom_filter = $request->string("custom_filter");
- switch($custom_filter) {
- case "open":
- $nvp["status"] = new NotEqualsConstraint(SaleStatuses::COMPLETED);
- break;
- }
- $sort_options = [
- "date-asc" => __("Date (Oldest first)"),
- "date-desc" => __("Date (Newest first)"),
- "last-updated" => __("Last Updated (Most recent first)"),
- "predicted-sold-date" => __("Predicted Sold Date (Ascending)"),
- ];
- $sort = $request->string("sort") ?? "date-desc";
- switch($sort) {
- case "date-asc":
- $sort_column = "dts_created";
- $sort_order = "asc";
- break;
- default:
- case "date-desc":
- $sort_column = "dts_created";
- $sort_order = "desc";
- break;
- case "predicted-sold-date":
- $sort_column = "date_predicted_sold";
- $sort_order = "desc";
- break;
- case "last-updated":
- $sort_column = "dts_updated";
- $sort_order = "desc";
- break;
- }
- $sale_count = Sale::count($nvp);
- $pagination = new Pagination($sale_count);
- $pagination->setTerms(__("%s lead"), __("%s leads"));
- $sales = Sale::query($nvp, [
- "sort" => $sort_column,
- "order" => $sort_order,
- "offset" => $pagination->getOffset(),
- "limit" => $pagination->getPageSize()
- ]);
- $core->addScript("/js/sales.js");
- $core->addScript("/js/new-sale-modal.js");
- View::include("header");
- View::include("sales", compact("sales", "pagination", "customer_id", "location_id", "status", "number", "custom_filter", "sort_options", "sort"));
- View::include("modals/new_sale");
- View::include("footer");
|