SparePartTest.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421
  1. <?php
  2. namespace Tests\Unit\Models;
  3. use App\Models\Reservation;
  4. use App\Models\Shortage;
  5. use App\Models\SparePart;
  6. use App\Models\SparePartOrder;
  7. use Illuminate\Foundation\Testing\RefreshDatabase;
  8. use Tests\TestCase;
  9. class SparePartTest extends TestCase
  10. {
  11. use RefreshDatabase;
  12. protected $seed = true;
  13. public function test_price_accessors_convert_from_kopeks_to_rubles(): void
  14. {
  15. $sparePart = SparePart::factory()->create([
  16. 'purchase_price' => 150.50, // Will be stored as 15050 kopeks
  17. 'customer_price' => 200.00,
  18. 'expertise_price' => 180.25,
  19. ]);
  20. $sparePart->refresh();
  21. $this->assertSame(15050, $sparePart->getRawOriginal('purchase_price'));
  22. $this->assertSame(20000, $sparePart->getRawOriginal('customer_price'));
  23. $this->assertSame(18025, $sparePart->getRawOriginal('expertise_price'));
  24. $this->assertEquals(150.50, $sparePart->purchase_price);
  25. $this->assertEquals(200.00, $sparePart->customer_price);
  26. $this->assertEquals(180.25, $sparePart->expertise_price);
  27. }
  28. public function test_zero_prices_are_stored_and_displayed_as_zero(): void
  29. {
  30. $sparePart = SparePart::factory()->create([
  31. 'purchase_price' => 0,
  32. 'customer_price' => 0,
  33. 'expertise_price' => 0,
  34. ]);
  35. $sparePart->refresh();
  36. $this->assertSame(0, $sparePart->getRawOriginal('purchase_price'));
  37. $this->assertSame(0, $sparePart->getRawOriginal('customer_price'));
  38. $this->assertSame(0, $sparePart->getRawOriginal('expertise_price'));
  39. $this->assertEquals(0.0, $sparePart->purchase_price);
  40. $this->assertEquals(0.0, $sparePart->customer_price);
  41. $this->assertEquals(0.0, $sparePart->expertise_price);
  42. $this->assertSame('0.00₽', $sparePart->purchase_price_txt);
  43. }
  44. public function test_price_txt_accessors_format_prices(): void
  45. {
  46. $sparePart = SparePart::factory()->create([
  47. 'purchase_price' => 1500.50,
  48. ]);
  49. $sparePart->refresh();
  50. $this->assertStringContainsString('₽', $sparePart->purchase_price_txt);
  51. $this->assertStringContainsString('1', $sparePart->purchase_price_txt);
  52. $this->assertStringContainsString('500', $sparePart->purchase_price_txt);
  53. }
  54. public function test_price_txt_returns_dash_for_null_prices(): void
  55. {
  56. $sparePart = SparePart::factory()->create([
  57. 'purchase_price' => null,
  58. ]);
  59. $sparePart->refresh();
  60. $this->assertEquals('-', $sparePart->purchase_price_txt);
  61. }
  62. public function test_physical_stock_without_docs_calculates_correctly(): void
  63. {
  64. $sparePart = SparePart::factory()->create();
  65. // Create orders WITHOUT documents
  66. SparePartOrder::factory()
  67. ->inStock()
  68. ->withDocuments(false)
  69. ->withQuantity(10)
  70. ->forSparePart($sparePart)
  71. ->create();
  72. SparePartOrder::factory()
  73. ->inStock()
  74. ->withDocuments(false)
  75. ->withQuantity(5)
  76. ->forSparePart($sparePart)
  77. ->create();
  78. // Create order WITH documents (should not count)
  79. SparePartOrder::factory()
  80. ->inStock()
  81. ->withDocuments(true)
  82. ->withQuantity(20)
  83. ->forSparePart($sparePart)
  84. ->create();
  85. // Create shipped order (should not count)
  86. SparePartOrder::factory()
  87. ->shipped()
  88. ->withDocuments(false)
  89. ->forSparePart($sparePart)
  90. ->create();
  91. $this->assertEquals(15, $sparePart->physical_stock_without_docs);
  92. }
  93. public function test_physical_stock_with_docs_calculates_correctly(): void
  94. {
  95. $sparePart = SparePart::factory()->create();
  96. SparePartOrder::factory()
  97. ->inStock()
  98. ->withDocuments(true)
  99. ->withQuantity(7)
  100. ->forSparePart($sparePart)
  101. ->create();
  102. SparePartOrder::factory()
  103. ->inStock()
  104. ->withDocuments(false)
  105. ->withQuantity(10)
  106. ->forSparePart($sparePart)
  107. ->create();
  108. $this->assertEquals(7, $sparePart->physical_stock_with_docs);
  109. }
  110. public function test_reserved_without_docs_calculates_correctly(): void
  111. {
  112. $sparePart = SparePart::factory()->create();
  113. $order = SparePartOrder::factory()
  114. ->inStock()
  115. ->withDocuments(false)
  116. ->forSparePart($sparePart)
  117. ->create();
  118. // Active reservations WITHOUT documents
  119. Reservation::factory()
  120. ->active()
  121. ->withQuantity(3)
  122. ->withDocuments(false)
  123. ->fromOrder($order)
  124. ->forSparePart($sparePart)
  125. ->create();
  126. Reservation::factory()
  127. ->active()
  128. ->withQuantity(2)
  129. ->withDocuments(false)
  130. ->fromOrder($order)
  131. ->forSparePart($sparePart)
  132. ->create();
  133. // Cancelled reservation (should not count)
  134. Reservation::factory()
  135. ->cancelled()
  136. ->withQuantity(10)
  137. ->withDocuments(false)
  138. ->fromOrder($order)
  139. ->forSparePart($sparePart)
  140. ->create();
  141. // Reservation WITH documents (should not count)
  142. // Need to create separate order with documents for this
  143. $orderWithDocs = SparePartOrder::factory()
  144. ->inStock()
  145. ->withDocuments(true)
  146. ->forSparePart($sparePart)
  147. ->create();
  148. Reservation::factory()
  149. ->active()
  150. ->withQuantity(5)
  151. ->fromOrder($orderWithDocs)
  152. ->forSparePart($sparePart)
  153. ->create();
  154. $this->assertEquals(5, $sparePart->reserved_without_docs);
  155. }
  156. public function test_free_stock_without_docs_calculates_correctly(): void
  157. {
  158. $sparePart = SparePart::factory()->create();
  159. $order = SparePartOrder::factory()
  160. ->inStock()
  161. ->withDocuments(false)
  162. ->withQuantity(10)
  163. ->forSparePart($sparePart)
  164. ->create();
  165. Reservation::factory()
  166. ->active()
  167. ->withQuantity(3)
  168. ->withDocuments(false)
  169. ->fromOrder($order)
  170. ->forSparePart($sparePart)
  171. ->create();
  172. // Physical: 10, Reserved: 3, Free: 7
  173. $this->assertEquals(7, $sparePart->free_stock_without_docs);
  174. }
  175. public function test_total_physical_stock_sums_both_types(): void
  176. {
  177. $sparePart = SparePart::factory()->create();
  178. SparePartOrder::factory()
  179. ->inStock()
  180. ->withDocuments(false)
  181. ->withQuantity(10)
  182. ->forSparePart($sparePart)
  183. ->create();
  184. SparePartOrder::factory()
  185. ->inStock()
  186. ->withDocuments(true)
  187. ->withQuantity(5)
  188. ->forSparePart($sparePart)
  189. ->create();
  190. $this->assertEquals(15, $sparePart->total_physical_stock);
  191. }
  192. public function test_total_free_stock_calculates_correctly(): void
  193. {
  194. $sparePart = SparePart::factory()->create();
  195. $orderNoDocs = SparePartOrder::factory()
  196. ->inStock()
  197. ->withDocuments(false)
  198. ->withQuantity(10)
  199. ->forSparePart($sparePart)
  200. ->create();
  201. $orderWithDocs = SparePartOrder::factory()
  202. ->inStock()
  203. ->withDocuments(true)
  204. ->withQuantity(8)
  205. ->forSparePart($sparePart)
  206. ->create();
  207. Reservation::factory()
  208. ->active()
  209. ->withQuantity(3)
  210. ->withDocuments(false)
  211. ->fromOrder($orderNoDocs)
  212. ->forSparePart($sparePart)
  213. ->create();
  214. Reservation::factory()
  215. ->active()
  216. ->withQuantity(2)
  217. ->withDocuments(true)
  218. ->fromOrder($orderWithDocs)
  219. ->forSparePart($sparePart)
  220. ->create();
  221. // Total physical: 18, Total reserved: 5, Total free: 13
  222. $this->assertEquals(13, $sparePart->total_free_stock);
  223. }
  224. public function test_quantity_backward_compatibility_attributes(): void
  225. {
  226. $sparePart = SparePart::factory()->create();
  227. $order = SparePartOrder::factory()
  228. ->inStock()
  229. ->withDocuments(false)
  230. ->withQuantity(10)
  231. ->forSparePart($sparePart)
  232. ->create();
  233. Reservation::factory()
  234. ->active()
  235. ->withQuantity(3)
  236. ->withDocuments(false)
  237. ->fromOrder($order)
  238. ->forSparePart($sparePart)
  239. ->create();
  240. // Old attributes should return free stock
  241. $this->assertEquals($sparePart->free_stock_without_docs, $sparePart->quantity_without_docs);
  242. $this->assertEquals($sparePart->free_stock_with_docs, $sparePart->quantity_with_docs);
  243. $this->assertEquals($sparePart->total_free_stock, $sparePart->total_quantity);
  244. }
  245. public function test_has_open_shortages_returns_true_when_shortages_exist(): void
  246. {
  247. $sparePart = SparePart::factory()->create();
  248. Shortage::factory()
  249. ->open()
  250. ->forSparePart($sparePart)
  251. ->create();
  252. $this->assertTrue($sparePart->hasOpenShortages());
  253. }
  254. public function test_has_open_shortages_returns_false_when_no_shortages(): void
  255. {
  256. $sparePart = SparePart::factory()->create();
  257. $this->assertFalse($sparePart->hasOpenShortages());
  258. }
  259. public function test_has_open_shortages_ignores_closed_shortages(): void
  260. {
  261. $sparePart = SparePart::factory()->create();
  262. Shortage::factory()
  263. ->closed()
  264. ->forSparePart($sparePart)
  265. ->create();
  266. $this->assertFalse($sparePart->hasOpenShortages());
  267. }
  268. public function test_open_shortages_qty_calculates_correctly(): void
  269. {
  270. $sparePart = SparePart::factory()->create();
  271. Shortage::factory()
  272. ->open()
  273. ->withQuantities(10, 3) // missing 7
  274. ->forSparePart($sparePart)
  275. ->create();
  276. Shortage::factory()
  277. ->open()
  278. ->withQuantities(5, 2) // missing 3
  279. ->forSparePart($sparePart)
  280. ->create();
  281. Shortage::factory()
  282. ->withQuantities(20, 20) // fully reserved = closed
  283. ->forSparePart($sparePart)
  284. ->create();
  285. $this->assertEquals(10, $sparePart->open_shortages_qty);
  286. }
  287. public function test_is_below_min_stock_returns_true_when_below(): void
  288. {
  289. $sparePart = SparePart::factory()
  290. ->withMinStock(10)
  291. ->create();
  292. SparePartOrder::factory()
  293. ->inStock()
  294. ->withDocuments(false)
  295. ->withQuantity(5)
  296. ->forSparePart($sparePart)
  297. ->create();
  298. $this->assertTrue($sparePart->isBelowMinStock());
  299. }
  300. public function test_is_below_min_stock_returns_false_when_at_or_above(): void
  301. {
  302. $sparePart = SparePart::factory()
  303. ->withMinStock(10)
  304. ->create();
  305. SparePartOrder::factory()
  306. ->inStock()
  307. ->withDocuments(false)
  308. ->withQuantity(15)
  309. ->forSparePart($sparePart)
  310. ->create();
  311. $this->assertFalse($sparePart->isBelowMinStock());
  312. }
  313. public function test_get_free_stock_helper_method(): void
  314. {
  315. $sparePart = SparePart::factory()->create();
  316. SparePartOrder::factory()
  317. ->inStock()
  318. ->withDocuments(false)
  319. ->withQuantity(10)
  320. ->forSparePart($sparePart)
  321. ->create();
  322. SparePartOrder::factory()
  323. ->inStock()
  324. ->withDocuments(true)
  325. ->withQuantity(5)
  326. ->forSparePart($sparePart)
  327. ->create();
  328. $this->assertEquals(10, $sparePart->getFreeStock(false));
  329. $this->assertEquals(5, $sparePart->getFreeStock(true));
  330. }
  331. public function test_pricing_codes_list_attribute(): void
  332. {
  333. $sparePart = SparePart::factory()->create();
  334. // Assuming pricing codes relationship works
  335. $this->assertIsString($sparePart->pricing_codes_list);
  336. }
  337. public function test_relations_exist(): void
  338. {
  339. $sparePart = SparePart::factory()->create();
  340. $this->assertInstanceOf(\Illuminate\Database\Eloquent\Relations\HasMany::class, $sparePart->orders());
  341. $this->assertInstanceOf(\Illuminate\Database\Eloquent\Relations\HasMany::class, $sparePart->reservations());
  342. $this->assertInstanceOf(\Illuminate\Database\Eloquent\Relations\HasMany::class, $sparePart->shortages());
  343. $this->assertInstanceOf(\Illuminate\Database\Eloquent\Relations\HasMany::class, $sparePart->movements());
  344. }
  345. }