sale.php 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356
  1. <?php
  2. namespace App;
  3. use App\Enums\DocumentTypes;
  4. use App\Enums\SalesOrderStatuses;
  5. use App\Enums\SaleStatuses;
  6. use RuntimeException;
  7. /**
  8. * @var int $number
  9. * @var string $action
  10. */
  11. $number = $number ?? null;
  12. $action = $action ?? null;
  13. $request = Request::fromRequest();
  14. $controller = new class($number) {
  15. private ?int $number;
  16. private Request $request;
  17. private User $user;
  18. public function __construct(?int $number) {
  19. $core = Core::getInstance();
  20. $this->user = $core->getUser();
  21. $this->number = $number;
  22. $this->request = Request::fromRequest();
  23. }
  24. private function getSale(): ?Sale {
  25. if(!$this->number) {
  26. return null;
  27. }
  28. return Sale::getByNumber($this->number);
  29. }
  30. private function requireSale(): Sale {
  31. $sale = $this->getSale();
  32. if(!$sale) {
  33. throw new RuntimeException(__("Lead not found."));
  34. }
  35. return $sale;
  36. }
  37. private function requireNote(?int $note_id): SaleNote {
  38. $notes = $this->requireSale()->getNotes(["id" => $note_id]);
  39. if(!$notes) {
  40. throw new RuntimeException(__("Note not found."));
  41. }
  42. return $notes[0];
  43. }
  44. private function requireItem(?int $item_id): SaleItem {
  45. $items = $this->requireSale()->getItems(["id" => $item_id]);
  46. if(!$items) {
  47. throw new RuntimeException(__("Item not found."));
  48. }
  49. return $items[0];
  50. }
  51. private function requireCompany(?int $company_id): Company {
  52. return Company::require($company_id);
  53. }
  54. public function view(): void {
  55. $sale = $this->requireSale();
  56. $core = Core::getInstance();
  57. $this->user->requireAdmin();
  58. $core->addBreadcrumb("/leads", __("Leads"));
  59. $core->addBreadcrumb($sale->getUrl(), $sale->getTitle());
  60. $core->addScript("/js/sale-item-modal.js");
  61. $core->addScript("/js/sale-note-modal.js");
  62. $core->addScript("/js/sale-page.js");
  63. $core->addScript("/js/ticket-modal.js");
  64. View::include("header");
  65. View::include("sale", compact("sale"));
  66. View::include("modals/sale_item");
  67. View::include("modals/sale_note");
  68. View::include("modals/ticket");
  69. View::include("footer");
  70. }
  71. public function createOrUpdate(): void {
  72. $company_id = $this->request->int("company_id");
  73. $company = $this->requireCompany($company_id);
  74. $location_id = $this->request->int("location_id");
  75. $location = Location::require($location_id);
  76. $sale = $this->getSale();
  77. if(!$sale) {
  78. $sale = new Sale();
  79. $sale->location_id = $location->id;
  80. $sale->user_id = $this->user->id;
  81. $sale->status = SaleStatuses::NEW;
  82. $sale->currency = "GBP";
  83. $sale->dts_created = Database::dts();
  84. $success_message = __("Lead created successfully.");
  85. }
  86. else {
  87. $sale->location_id = $location->id;
  88. $sale->status = $this->request->int("status");
  89. $sale->currency = $this->request->string("currency");
  90. $sale->tax_rate = $this->request->decimal("tax_rate", 2);
  91. if(!SaleStatuses::validate($sale->status)) {
  92. throw new RuntimeException(__("Status is invalid."));
  93. }
  94. $sale->dts_updated = Database::dts();
  95. $success_message = __("Lead updated successfully.");
  96. }
  97. $sale->company_id = $company->id;
  98. $sale->date_predicted_sold = $this->request->date("date_predicted_sold");
  99. $sale->commit();
  100. if(Http::isAjax()) {
  101. Json::success();
  102. }
  103. else {
  104. Session::addAlert("success", $success_message);
  105. Http::redirect($sale->getUrl());
  106. }
  107. }
  108. public function delete(): void {
  109. $sale = $this->requireSale();
  110. $sale->softDelete();
  111. Json::success();
  112. }
  113. public function submitNote(): void {
  114. $sale = $this->requireSale();
  115. $note_id = $this->request->int("sale_note_id");
  116. if($note_id) {
  117. $note = $this->requireNote($note_id);
  118. }
  119. else {
  120. $note = new SaleNote();
  121. $note->sale_id = $sale->id;
  122. $note->user_id = $this->user->id;
  123. $note->dts_created = Database::dts();
  124. }
  125. $note->content = $this->request->string("content");
  126. if(empty($note->content)) {
  127. throw new RuntimeException(__("Content cannot be empty."));
  128. }
  129. $note->commit();
  130. Json::success([
  131. "html" => View::getHtml("sale_notes_section", compact("sale"))
  132. ]);
  133. }
  134. public function deleteNote(): void {
  135. $note_id = $this->request->int("note_id");
  136. $note = $this->requireNote($note_id);
  137. $note->softDelete();
  138. Json::success();
  139. }
  140. public function submitItem(): void {
  141. $sale = $this->requireSale();
  142. $sale_item_id = $this->request->int("sale_item_id");
  143. if($sale_item_id) {
  144. $item = $this->requireItem($sale_item_id);
  145. }
  146. else {
  147. $item = new SaleItem();
  148. $item->sale_id = $sale->id;
  149. }
  150. $product_id = $this->request->int("product_id");
  151. $product = Product::require($product_id);
  152. $item->product_id = $product->id;
  153. $item->quantity = $this->request->int("quantity");
  154. $item->unit_price = $this->request->decimal("unit_price", 2);
  155. $item->commit();
  156. Json::success([
  157. "html" => View::getHtml("sale_items_section", compact("sale"))
  158. ]);
  159. }
  160. public function deleteItem(): void {
  161. $item_id = $this->request->int("sale_item_id");
  162. $item = $this->requireItem($item_id);
  163. $sale = $item->getSale();
  164. $item->delete();
  165. Json::success([
  166. "html" => View::getHtml("sale_items_section", compact("sale"))
  167. ]);
  168. }
  169. /**
  170. * @param int[] $item_ids
  171. * @return SaleItem[]
  172. */
  173. private function validateItemIds(array $item_ids): array {
  174. $items = [];
  175. foreach($item_ids as $item_id) {
  176. $items[] = $this->requireItem($item_id);
  177. }
  178. return $items;
  179. }
  180. public function deleteItems(): void {
  181. $sale = $this->requireSale();
  182. $item_ids = $this->request->int("sale_item_ids");
  183. if(empty($item_ids) || !is_array($item_ids)) {
  184. throw new RuntimeException(__("No items selected."));
  185. }
  186. $items = $this->validateItemIds($item_ids);
  187. foreach($items as $item) {
  188. $item->delete();
  189. }
  190. Session::addAlert("success", __("Items deleted successfully."));
  191. Http::redirect($sale->getUrl());
  192. }
  193. public function createSalesOrderFromItems(): void {
  194. $sale = $this->requireSale();
  195. $location = $sale->getLocation();
  196. $customer = $location->getCustomer();
  197. $billing_entity = $location->getBillingEntity();
  198. $delivery_address = $location->getAddress();
  199. if($billing_entity) {
  200. $billing_address = $billing_entity->getAddress();
  201. $billing_name = $billing_entity->name;
  202. }
  203. else {
  204. $billing_address = $delivery_address;
  205. $billing_name = $location->name;
  206. }
  207. $item_ids = $this->request->int("sale_item_ids");
  208. if(empty($item_ids) || !is_array($item_ids)) {
  209. throw new RuntimeException(__("No items selected."));
  210. }
  211. $sale_items = $this->validateItemIds($item_ids);
  212. $billing_address_string = $billing_name . "\n" . $billing_address;
  213. $delivery_address_string = $location->name . "\n" . $delivery_address;
  214. // OK
  215. $document = new Document();
  216. $document->company_id = $sale->company_id;
  217. $document->user_id = $this->user->id;
  218. $document->sale_id = $sale->id;
  219. $document->location_id = $location->id;
  220. $document->type = DocumentTypes::SALES_ORDER;
  221. $document->invoice_status = SalesOrderStatuses::DRAFT;
  222. $document->currency = $sale->currency;
  223. $document->tax_rate = $sale->tax_rate;
  224. $document->billing_address = $billing_address_string;
  225. $document->delivery_address = $delivery_address_string;
  226. $document->number = Document::getNextNumber(DocumentTypes::SALES_ORDER);
  227. $document->date = date("Y-m-d");
  228. $document->vat_number = $customer->vat_number;
  229. $document->contact_name = $location->contact_name;
  230. $document->contact_phone = $location->contact_phone;
  231. $document->contact_email = $location->contact_email;
  232. $document->dts_created = Database::dts();
  233. $document->commit();
  234. foreach($sale_items as $sale_item) {
  235. $product = $sale_item->getProduct();
  236. $supplier = $product->getSupplier();
  237. $item = new DocumentItem();
  238. $item->document_id = $document->id;
  239. $item->product_id = $product->id;
  240. $item->description = $product->name . " ($supplier->name)";
  241. $item->quantity = $sale_item->quantity;
  242. $item->unit_price = $sale_item->unit_price;
  243. $item->dts_created = Database::dts();
  244. $item->commit();
  245. }
  246. Session::addAlert("success", __("Sales Order created successfully."));
  247. Http::redirect($document->getUrl());
  248. }
  249. };
  250. switch($action) {
  251. case "submit-note":
  252. $controller->submitNote();
  253. break;
  254. case "delete-note":
  255. $controller->deleteNote();
  256. break;
  257. case "submit-item":
  258. $controller->submitItem();
  259. break;
  260. case "delete-item":
  261. $controller->deleteItem();
  262. break;
  263. case "submit":
  264. $controller->createOrUpdate();
  265. break;
  266. case "items-batch-action":
  267. $batch_action = $request->string("batch_action");
  268. switch($batch_action) {
  269. case "create-sales-order":
  270. $controller->createSalesOrderFromItems();
  271. break;
  272. case "delete":
  273. $controller->deleteItems();
  274. break;
  275. default:
  276. throw new RuntimeException(__("Invalid batch action."));
  277. }
  278. break;
  279. default:
  280. $controller->view();
  281. break;
  282. }