document.php 16 KB

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