documents.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. <?php /** @noinspection PhpUnhandledExceptionInspection */
  2. namespace App;
  3. /**
  4. * @var string $type_string
  5. */
  6. use App\Constraint\NotInConstraint;
  7. use App\Enums\AruStatuses;
  8. use App\Enums\DocumentTypes;
  9. use App\Enums\SalesOrderStatuses;
  10. use RuntimeException;
  11. $core = Core::getInstance();
  12. $user = $core->getUser();
  13. $user->requireAdmin();
  14. switch($type_string) {
  15. case "sales-orders":
  16. $title = __("Sales Orders");
  17. $type = DocumentTypes::SALES_ORDER;
  18. $singular = __("%s sales order");
  19. $plural = __("%s sales orders");
  20. $status_field = "invoice_status";
  21. break;
  22. case "goods-in":
  23. $title = __("Goods-In");
  24. $type = DocumentTypes::GOODS_IN;
  25. $singular = __("%s goods-in documents");
  26. $plural = __("%s goods-in documents");
  27. $status_field = null;
  28. break;
  29. case "arus":
  30. $title = __("ARUs");
  31. $type = DocumentTypes::ADVANCE_REPLACEMENT_UNIT;
  32. $singular = __("%s ARU");
  33. $plural = __("%s ARUs");
  34. $status_field = "aru_status";
  35. break;
  36. case "delivery-notes":
  37. $title = __("Delivery Notes");
  38. $type = DocumentTypes::DELIVERY_NOTE;
  39. $singular = __("%s delivery note");
  40. $plural = __("%s delivery notes");
  41. $status_field = null;
  42. break;
  43. default:
  44. throw new RuntimeException(__("Invalid type string."));
  45. }
  46. $core->addBreadcrumb("/$type_string", $title);
  47. $type_name = DocumentTypes::enumToText($type);
  48. $nvp = [
  49. "type" => $type,
  50. "dts_deleted" => null
  51. ];
  52. $request = Request::fromRequest();
  53. $document_ids = $request->int("document_ids");
  54. $batch_action = $request->string("batch_action");
  55. if($type === DocumentTypes::SALES_ORDER && is_array($document_ids)) {
  56. $batch_documents = Document::query([
  57. "id" => $document_ids,
  58. "type" => DocumentTypes::SALES_ORDER,
  59. ]);
  60. foreach($batch_documents as $batch_document) {
  61. switch($batch_action) {
  62. case "mark-draft":
  63. $batch_document->invoice_status = SalesOrderStatuses::DRAFT;
  64. break;
  65. case "mark-shipped":
  66. $batch_document->invoice_status = SalesOrderStatuses::SHIPPED;
  67. break;
  68. case "mark-paid":
  69. $batch_document->invoice_status = SalesOrderStatuses::PAID;
  70. break;
  71. case "mark-void":
  72. $batch_document->invoice_status = SalesOrderStatuses::VOID;
  73. break;
  74. case "mark-uncollectible":
  75. $batch_document->invoice_status = SalesOrderStatuses::UNCOLLECTIBLE;
  76. break;
  77. }
  78. $batch_document->commit();
  79. }
  80. }
  81. $supplier_id = $request->int("supplier_id");
  82. if($supplier_id) {
  83. $nvp["supplier_id"] = $supplier_id;
  84. }
  85. $customer_id = $request->int("customer_id");
  86. if($customer_id) {
  87. $customer = Customer::get($customer_id);
  88. if($customer) {
  89. $nvp["location_id"] = array_column($customer->getLocations(), "id");
  90. }
  91. else {
  92. $nvp["location_id"] = 0;
  93. }
  94. }
  95. $location_id = $request->int("location_id");
  96. if($location_id) {
  97. $nvp["location_id"] = $location_id;
  98. }
  99. $status = $request->int("status");
  100. if($status !== null && $status_field) {
  101. $nvp[$status_field] = $status;
  102. }
  103. $number = $request->int("number");
  104. if($number) {
  105. $nvp["number"] = $number;
  106. }
  107. $custom_filter = $request->string("custom_filter");
  108. switch($custom_filter) {
  109. case "open":
  110. if($type === DocumentTypes::SALES_ORDER) {
  111. $nvp["invoice_status"] = new NotInConstraint(SalesOrderStatuses::PAID, SalesOrderStatuses::VOID);
  112. }
  113. if($type === DocumentTypes::ADVANCE_REPLACEMENT_UNIT) {
  114. $nvp["aru_status"] = new NotInConstraint(AruStatuses::COMPLETED, AruStatuses::CANCELLED);
  115. }
  116. break;
  117. }
  118. $count = Document::count($nvp);
  119. $pagination = new Pagination($count);
  120. $pagination->setTerms($singular, $plural);
  121. $documents = Document::query($nvp, [
  122. "sort" => "id",
  123. "order" => "desc",
  124. "offset" => $pagination->getOffset(),
  125. "limit" => $pagination->getPageSize()
  126. ]);
  127. $core->addScript("/js/new-document-modal.js");
  128. $core->addScript("/js/documents.js");
  129. View::include("header");
  130. View::include("documents", compact("title", "type_string", "type", "documents", "pagination", "type_name", "supplier_id", "customer_id", "location_id", "status", "number", "custom_filter"));
  131. View::include("modals/new_document");
  132. View::include("footer");