sales.php 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  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. default:
  36. $custom_filter = "open";
  37. $nvp["status"] = new NotEqualsConstraint(SaleStatuses::COMPLETED);
  38. break;
  39. case "open":
  40. $nvp["status"] = new NotEqualsConstraint(SaleStatuses::COMPLETED);
  41. break;
  42. case "all":
  43. break;
  44. }
  45. $sort_options = [
  46. "date-asc" => __("Date (Oldest first)"),
  47. "date-desc" => __("Date (Newest first)"),
  48. "last-updated" => __("Last Updated (Most recent first)"),
  49. "predicted-sold-date" => __("Predicted Sold Date (Ascending)"),
  50. ];
  51. $sort = $request->string("sort") ?? "date-desc";
  52. switch($sort) {
  53. case "date-asc":
  54. $sort_column = "dts_created";
  55. $sort_order = "asc";
  56. break;
  57. default:
  58. case "date-desc":
  59. $sort_column = "dts_created";
  60. $sort_order = "desc";
  61. break;
  62. case "predicted-sold-date":
  63. $sort_column = "date_predicted_sold";
  64. $sort_order = "desc";
  65. break;
  66. case "last-updated":
  67. $sort_column = "dts_updated";
  68. $sort_order = "desc";
  69. break;
  70. }
  71. $sale_count = Sale::count($nvp);
  72. $pagination = new Pagination($sale_count);
  73. $pagination->setTerms(__("%s lead"), __("%s leads"));
  74. $sales = Sale::query($nvp, [
  75. "sort" => $sort_column,
  76. "order" => $sort_order,
  77. "offset" => $pagination->getOffset(),
  78. "limit" => $pagination->getPageSize()
  79. ]);
  80. $core->addScript("/js/sales.js");
  81. $core->addScript("/js/new-sale-modal.js");
  82. View::include("header");
  83. View::include("sales", compact("sales", "pagination", "customer_id", "location_id", "status", "number", "custom_filter", "sort_options", "sort"));
  84. View::include("modals/new_sale");
  85. View::include("footer");