documents.php 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165
  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. $user_id = $request->int("user_id");
  100. if($user_id) {
  101. $nvp["user_id"] = $user_id;
  102. }
  103. $status = $request->int("status");
  104. if($status !== null && $status_field) {
  105. $nvp[$status_field] = $status;
  106. }
  107. $number = $request->int("number");
  108. if($number) {
  109. $nvp["number"] = $number;
  110. }
  111. $custom_filter = $request->string("custom_filter");
  112. switch($custom_filter) {
  113. case "open":
  114. if($type === DocumentTypes::SALES_ORDER) {
  115. $nvp["invoice_status"] = new NotInConstraint(SalesOrderStatuses::PAID, SalesOrderStatuses::VOID);
  116. }
  117. if($type === DocumentTypes::ADVANCE_REPLACEMENT_UNIT) {
  118. $nvp["aru_status"] = new NotInConstraint(AruStatuses::COMPLETED, AruStatuses::CANCELLED);
  119. }
  120. break;
  121. }
  122. $count = Document::count($nvp);
  123. $pagination = new Pagination($count);
  124. $pagination->setTerms($singular, $plural);
  125. $documents = Document::query($nvp, [
  126. "sort" => "id",
  127. "order" => "desc",
  128. "offset" => $pagination->getOffset(),
  129. "limit" => $pagination->getPageSize()
  130. ]);
  131. $core->addScript("/js/new-document-modal.js");
  132. $core->addScript("/js/documents.js");
  133. View::include("header");
  134. View::include("documents", compact("title", "type_string", "type", "documents", "pagination", "type_name", "supplier_id", "customer_id", "location_id", "user_id", "status", "number", "custom_filter"));
  135. View::include("modals/new_document");
  136. View::include("footer");