1
0

document.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499
  1. <?php
  2. namespace App;
  3. use App\Enums\DocumentTypes;
  4. use RuntimeException;
  5. /**
  6. * @var string $document_type_string
  7. * @var int $document_number
  8. * @var string $action
  9. */
  10. $action = $action ?? null;
  11. $document_number = $document_number ?? null;
  12. switch($document_type_string) {
  13. case "invoices":
  14. $document_type = DocumentTypes::INVOICE;
  15. break;
  16. case "delivery-notes":
  17. $document_type = DocumentTypes::DELIVERY_NOTE;
  18. break;
  19. case "goods-in":
  20. $document_type = DocumentTypes::GOODS_IN;
  21. break;
  22. case "arus":
  23. $document_type = DocumentTypes::ADVANCE_REPLACEMENT_UNIT;
  24. break;
  25. default:
  26. throw new RuntimeException(__("Invalid document type."));
  27. }
  28. $request = Request::fromRequest();
  29. $controller = new class($document_type, $document_number) {
  30. private ?User $user;
  31. private int $documentType;
  32. private ?int $documentNumber;
  33. private Request $request;
  34. public function __construct(int $document_type, ?int $document_number) {
  35. $core = Core::getInstance();
  36. $this->user = $core->getUser();
  37. $this->documentType = $document_type;
  38. $this->documentNumber = $document_number;
  39. $this->request = Request::fromRequest();
  40. }
  41. private function requireDocument(): Document {
  42. $document = Document::queryOne([
  43. "type" => $this->documentType,
  44. "number" => $this->documentNumber
  45. ]);
  46. if(!$document) {
  47. throw new RuntimeException(__("Document not found."));
  48. }
  49. return $document;
  50. }
  51. private function requireItem(int $item_id): DocumentItem {
  52. $document = $this->requireDocument();
  53. $items = $document->getItems(["id" => $item_id]);
  54. if(!$items) {
  55. throw new RuntimeException(__("Item not found."));
  56. }
  57. return $items[0];
  58. }
  59. private function requireCompany(int $id): Company {
  60. $company = Company::get($id);
  61. if(!$company) {
  62. throw new RuntimeException(__("Company not found."));
  63. }
  64. return $company;
  65. }
  66. private function requireLocation(int $id): Location {
  67. $location = Location::get($id);
  68. if(!$location) {
  69. throw new RuntimeException(__("Location not found."));
  70. }
  71. return $location;
  72. }
  73. private function requireTicket(int $id): Ticket {
  74. $ticket = Ticket::get($id);
  75. if(!$ticket) {
  76. throw new RuntimeException(__("Ticket not found."));
  77. }
  78. return $ticket;
  79. }
  80. private function requireSupplier(int $id): Supplier {
  81. $supplier = Supplier::get($id);
  82. if(!$supplier) {
  83. throw new RuntimeException(__("Supplier not found."));
  84. }
  85. return $supplier;
  86. }
  87. public function view(): void {
  88. $document = $this->requireDocument();
  89. $core = Core::getInstance();
  90. $this->user->requireAdmin();
  91. if($document->isInvoice() || $document->isDeliveryNote()) {
  92. /** @var Sale $sale */
  93. $sale = $document->getSale();
  94. if($sale) {
  95. $core->addBreadcrumb("/leads", __("Leads"));
  96. $core->addBreadcrumb($sale->getUrl(), __("Lead %d", $sale->getNumber()));
  97. }
  98. if($document->isPartOfAru()) {
  99. /** @var Document $aru */
  100. $aru = $document->getRelatedDocument();
  101. $core->addBreadcrumb("/arus", __("ARUs"));
  102. $core->addBreadcrumb($aru->getUrl(), $aru->getTitle());
  103. }
  104. }
  105. else if($document->isGoodsIn()) {
  106. $core->addBreadcrumb("/goods-in", __("Goods-In"));
  107. }
  108. else if($document->isAru()) {
  109. $core->addBreadcrumb("/arus", __("ARUs"));
  110. }
  111. $core->addBreadcrumb($document->getUrl(), $document->getTitle());
  112. $core->addScript("/js/document-item-modal.js");
  113. $core->addScript("/js/document-page.js");
  114. View::include("header");
  115. View::include("document", compact("document"));
  116. View::include("modals/document_item");
  117. View::include("footer");
  118. }
  119. public function create(): void {
  120. $type = $this->documentType;
  121. if(!DocumentTypes::validate($type)) {
  122. throw new RuntimeException(__("Invalid document type."));
  123. }
  124. $supplier_id = $this->request->int("supplier_id");
  125. $supplier = $supplier_id ? $this->requireSupplier($supplier_id) : null;
  126. $company_id = $this->request->int("company_id");
  127. $company = $company_id ? $this->requireCompany($company_id) : null;
  128. $location_id = $this->request->int("location_id");
  129. $location = $location_id ? $this->requireLocation($location_id) : null;
  130. $ticket_id = $this->request->int("ticket_id");
  131. $ticket = $ticket_id ? $this->requireTicket($ticket_id) : null;
  132. $document = new Document();
  133. $document->company_id = $company->id ?? null;
  134. $document->user_id = $this->user->id;
  135. $document->supplier_id = $supplier->id ?? null;
  136. $document->location_id = $location->id ?? null;
  137. if($location) {
  138. $address = $location->getAddress();
  139. $lines = array_merge([$location->name], $address->getLines());
  140. $address_string = implode("\n", $lines);
  141. $document->billing_address = $address_string;
  142. $document->delivery_address = $address_string;
  143. }
  144. $document->type = $type;
  145. $document->number = Document::getNextNumber($type);
  146. $document->date = date("Y-m-d");
  147. $document->dts_created = Database::dts();
  148. if($document->isGoodsIn() && !$document->supplier_id && !$document->location_id) {
  149. throw new RuntimeException(__("Supplier or location must be selected for a Goods-In document."));
  150. }
  151. if($document->isAru() && !$document->location_id) {
  152. throw new RuntimeException(__("Location must be selected for an ARU document."));
  153. }
  154. $document->commit();
  155. if($document->isAru() && $ticket) {
  156. $ticket->aru_document_id = $document->id;
  157. $ticket->commit();
  158. }
  159. $item_description = $this->request->string("item_description");
  160. $item_serial_number = $this->request->string("item_serial_number");
  161. if($item_description) {
  162. $item = new DocumentItem();
  163. $item->document_id = $document->id;
  164. $item->description = $item_description;
  165. $item->serial_number = $item_serial_number;
  166. $item->quantity = 1;
  167. $item->unit_price = "0.00";
  168. $item->dts_created = Database::dts();
  169. $item->commit();
  170. }
  171. if($document->hasCosts() && $location) {
  172. $address = $location->getAddress();
  173. $document->currency = "GBP";
  174. $document->tax_rate = "20.00";
  175. $document->billing_address = (string) $address;
  176. $document->delivery_address = (string) $address;
  177. $document->commit();
  178. }
  179. Json::success([
  180. "url" => $document->getUrl()
  181. ]);
  182. }
  183. public function update(): void {
  184. $document = $this->requireDocument();
  185. $company_id = $this->request->int("company_id");
  186. $company = $this->requireCompany($company_id);
  187. $document->company_id = $company->id;
  188. if($document->isInvoice()) {
  189. $document->invoice_status = $this->request->int("invoice_status");
  190. $document->terms = $this->request->string("terms");
  191. $document->currency = $this->request->string("currency");
  192. $document->tax_rate = $this->request->decimal("tax_rate", 2);
  193. $document->dts_finalised = $this->request->dateTime("dts_finalised", "Y-m-d\TH:i", $this->user->getTimezone());
  194. $document->dts_paid = $this->request->dateTime("dts_paid", "Y-m-d\TH:i", $this->user->getTimezone());
  195. }
  196. if($document->isAru()) {
  197. $document->aru_status = $this->request->int("aru_status");
  198. }
  199. $document->date = $this->request->string("date");
  200. if($document->isInvoice() || $document->isDeliveryNote()) {
  201. $document->billing_address = $this->request->string("billing_address");
  202. $document->delivery_address = $this->request->string("delivery_address");
  203. $document->po_number = $this->request->string("po_number");
  204. }
  205. $document->notes = $this->request->string("notes");
  206. $document->delivery_company = $this->request->string("delivery_company");
  207. $document->tracking_number = $this->request->string("tracking_number");
  208. $document->delivery_cost = $this->request->decimal("delivery_cost", 2);
  209. $document->contact_name = $this->request->string("contact_name");
  210. $document->contact_phone = $this->request->string("contact_phone");
  211. $document->contact_email = $this->request->email("contact_email");
  212. $document->commit();
  213. if(Http::isAjax()) {
  214. Json::success();
  215. }
  216. else {
  217. Session::addAlert("success", __("%s document updated successfully.", $document->getDisplayType()));
  218. Http::redirect($document->getUrl());
  219. }
  220. }
  221. public function submitItem(): void {
  222. $document = $this->requireDocument();
  223. $document_item_id = $this->request->int("document_item_id");
  224. if($document_item_id) {
  225. $item = $this->requireItem($document_item_id);
  226. $item->dts_updated = Database::dts();
  227. }
  228. else {
  229. $item = new DocumentItem();
  230. $item->document_id = $document->id;
  231. $item->dts_created = Database::dts();
  232. }
  233. $item->description = $this->request->string("description");
  234. $item->serial_number = $this->request->string("serial_number");
  235. $item->quantity = $this->request->int("quantity");
  236. $item->unit_price = $this->request->decimal("unit_price", 2);
  237. $item->insurance_value = $this->request->decimal("insurance_value", 2);
  238. $item->commit();
  239. Json::success([
  240. "html" => View::getHtml("document_items_section", ["document" => $document])
  241. ]);
  242. }
  243. public function deleteItem(): void {
  244. $document = $this->requireDocument();
  245. $document_item_id = $this->request->int("document_item_id");
  246. $item = $this->requireItem($document_item_id);
  247. $item->softDelete();
  248. Json::success([
  249. "html" => View::getHtml("document_items_section", ["document" => $document])
  250. ]);
  251. }
  252. public function deleteItems(): void {
  253. $document_item_ids = $this->request->int("document_item_ids");
  254. if(!$document_item_ids || !is_array($document_item_ids)) {
  255. throw new RuntimeException(__("No items selected."));
  256. }
  257. $items = $this->validateItemIds($document_item_ids);
  258. foreach($items as $item) {
  259. $item->softDelete();
  260. }
  261. $document = $this->requireDocument();
  262. Session::addAlert("success", __("Items deleted successfully."));
  263. Http::redirect($document->getUrl());
  264. }
  265. public function createDocumentWithItems(int $document_type): void {
  266. $document_item_ids = $this->request->int("document_item_ids");
  267. if(!$document_item_ids || !is_array($document_item_ids)) {
  268. throw new RuntimeException(__("No items selected."));
  269. }
  270. $source_document = $this->requireDocument();
  271. $items = $this->validateItemIds($document_item_ids);
  272. $document = new Document();
  273. $document->company_id = $source_document->company_id;
  274. $document->user_id = $this->user->id;
  275. $document->sale_id = $source_document->sale_id;
  276. $document->location_id = $source_document->location_id;
  277. $document->related_document_id = $source_document->id;
  278. $document->type = $document_type;
  279. $document->currency = $source_document->currency;
  280. $document->tax_rate = $source_document->tax_rate;
  281. $document->billing_address = $source_document->billing_address;
  282. $document->delivery_address = $source_document->delivery_address;
  283. $document->number = Document::getNextNumber($document_type);
  284. $document->date = date("Y-m-d");
  285. $document->delivery_company = $source_document->delivery_company;
  286. $document->tracking_number = $source_document->tracking_number;
  287. $document->notes = $source_document->notes;
  288. $document->contact_name = $source_document->contact_name;
  289. $document->contact_phone = $source_document->contact_phone;
  290. $document->contact_email = $source_document->contact_email;
  291. $document->dts_created = Database::dts();
  292. $document->commit();
  293. foreach($items as $item) {
  294. $document_item = new DocumentItem();
  295. $document_item->document_id = $document->id;
  296. $document_item->description = $item->description;
  297. $document_item->serial_number = $item->serial_number;
  298. $document_item->quantity = $item->quantity;
  299. $document_item->unit_price = $item->unit_price;
  300. $document_item->dts_created = Database::dts();
  301. $document_item->commit();
  302. }
  303. Session::addAlert("success", __("%s created successfully.", $document->getDisplayType()));
  304. Http::redirect($document->getUrl());
  305. }
  306. /**
  307. * @param int[] $document_item_ids
  308. * @return DocumentItem[]
  309. */
  310. private function validateItemIds(array $document_item_ids): array {
  311. $items = [];
  312. foreach($document_item_ids as $document_item_id) {
  313. $items[] = $this->requireItem($document_item_id);
  314. }
  315. return $items;
  316. }
  317. public function renderPdf(): void {
  318. $document = $this->requireDocument();
  319. $variant = $this->request->string("variant");
  320. $access_token = $this->request->string("access_token");
  321. if($access_token !== $document->getAccessToken()) {
  322. throw new RuntimeException(__("Invalid access token."));
  323. }
  324. $view = "document_pdf";
  325. if($document->isPartOfAru() && $document->isDeliveryNote()) {
  326. $view = "aru_dn_pdf";
  327. }
  328. View::include($view, compact("document", "variant"));
  329. }
  330. public function downloadPdf(): void {
  331. $document = $this->requireDocument();
  332. $variant = $this->request->string("variant");
  333. $host = $_SERVER["HTTP_HOST"];
  334. $render_url = "https://" . $host . $document->getUrl() . "/render-pdf?" . http_build_query([
  335. "access_token" => $document->getAccessToken(),
  336. "variant" => $variant
  337. ]);
  338. chdir($_ENV["DIR_ROOT"]);
  339. $output_filename = $document->id . ".pdf";
  340. $output_path = "pdf-output/" . $output_filename;
  341. $command = sprintf('node pdf.js "%s" "%s"',
  342. $render_url,
  343. $output_filename
  344. );
  345. shell_exec($command);
  346. if(file_exists($output_path)) {
  347. Http::downloadFile($output_path, $document->getPdfFilename(), "application/pdf");
  348. }
  349. else {
  350. header("Content-Type: text/plain");
  351. http_response_code(500);
  352. echo "Failed to generate PDF.\n";
  353. }
  354. exit();
  355. }
  356. };
  357. switch($action) {
  358. case "create":
  359. $controller->create();
  360. break;
  361. case "submit":
  362. $controller->update();
  363. break;
  364. case "submit-item":
  365. $controller->submitItem();
  366. break;
  367. case "delete-item":
  368. $controller->deleteItem();
  369. break;
  370. case "items-batch-action":
  371. $batch_action = $request->string("batch_action");
  372. switch($batch_action) {
  373. case "delete":
  374. $controller->deleteItems();
  375. break;
  376. case "create-invoice":
  377. $controller->createDocumentWithItems(DocumentTypes::INVOICE);
  378. break;
  379. case "create-delivery-note":
  380. $controller->createDocumentWithItems(DocumentTypes::DELIVERY_NOTE);
  381. break;
  382. case "create-goods-in":
  383. $controller->createDocumentWithItems(DocumentTypes::GOODS_IN);
  384. break;
  385. default:
  386. throw new RuntimeException(__("Invalid batch action."));
  387. }
  388. break;
  389. case "render-pdf":
  390. $controller->renderPdf();
  391. break;
  392. case "download-pdf":
  393. $controller->downloadPdf();
  394. break;
  395. default:
  396. $controller->view();
  397. }