sales.php 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. namespace App;
  3. use App\Constraint\NotEqualsConstraint;
  4. use App\Enums\SaleStatuses;
  5. $core = Core::getInstance();
  6. $user = $core->getUser();
  7. $user->requireAdmin();
  8. $core->addBreadcrumb("/leads", __("Leads"));
  9. $nvp = ["dts_deleted" => null];
  10. $request = Request::fromRequest();
  11. $customer_id = $request->int("customer_id");
  12. if($customer_id) {
  13. $customer = Customer::get($customer_id);
  14. if($customer) {
  15. $nvp["location_id"] = array_column($customer->getLocations(), "id");
  16. }
  17. else {
  18. $nvp["location_id"] = 0;
  19. }
  20. }
  21. $location_id = $request->int("location_id");
  22. if($location_id) {
  23. $nvp["location_id"] = $location_id;
  24. }
  25. $status = $request->int("status");
  26. if($status !== null) {
  27. $nvp["status"] = $status;
  28. }
  29. $number = $request->int("number");
  30. if($number) {
  31. $nvp["id"] = $number - 999;
  32. }
  33. $custom_filter = $request->string("custom_filter");
  34. switch($custom_filter) {
  35. case "open":
  36. $nvp["status"] = new NotEqualsConstraint(SaleStatuses::COMPLETED);
  37. break;
  38. }
  39. $sort_options = [
  40. "date-asc" => __("Date (Oldest first)"),
  41. "date-desc" => __("Date (Newest first)"),
  42. "last-updated" => __("Last Updated (Most recent first)"),
  43. "predicted-sold-date" => __("Predicted Sold Date (Ascending)"),
  44. ];
  45. $sort = $request->string("sort") ?? "date-desc";
  46. switch($sort) {
  47. case "date-asc":
  48. $sort_column = "dts_created";
  49. $sort_order = "asc";
  50. break;
  51. default:
  52. case "date-desc":
  53. $sort_column = "dts_created";
  54. $sort_order = "desc";
  55. break;
  56. case "predicted-sold-date":
  57. $sort_column = "date_predicted_sold";
  58. $sort_order = "desc";
  59. break;
  60. case "last-updated":
  61. $sort_column = "dts_updated";
  62. $sort_order = "desc";
  63. break;
  64. }
  65. $sale_count = Sale::count($nvp);
  66. $pagination = new Pagination($sale_count);
  67. $pagination->setTerms(__("%s lead"), __("%s leads"));
  68. $sales = Sale::query($nvp, [
  69. "sort" => $sort_column,
  70. "order" => $sort_order,
  71. "offset" => $pagination->getOffset(),
  72. "limit" => $pagination->getPageSize()
  73. ]);
  74. $core->addScript("/js/sales.js");
  75. $core->addScript("/js/new-sale-modal.js");
  76. View::include("header");
  77. View::include("sales", compact("sales", "pagination", "customer_id", "location_id", "status", "number", "custom_filter", "sort_options", "sort"));
  78. View::include("modals/new_sale");
  79. View::include("footer");