src/Entity/Product.php line 763

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use App\Entity\ProductDescription;
  6. use App\Entity\ProductModel;
  7. use Doctrine\ORM\Mapping as ORM;
  8. use Doctrine\Common\Persistence\Event\LifecycleEventArgs;
  9. use App\Helpers\Encoder;
  11. /**
  12. * Products
  13. *
  14. * @ORM\Table(name="products", indexes={
  15. * @ORM\Index(name="IDX_PRODUCTS_MODEL_SAP", columns={"products_model_sap"}),
  16. * @ORM\Index(name="IDX_PRODUCTS_MODEL", columns={"products_model"}, options={"lengths": {191}})
  17. * })
  18. * @ORM\Entity(repositoryClass="App\Repository\ProductRepository")
  19. * @ORM\HasLifecycleCallbacks()
  20. */
  21. class Product extends TranslatedEntity
  22. {
  24. public const VAT_RATE = 0.2;
  25. public const SEARCH_INDICES = [
  26. 'fr' => 'fr-products',
  27. 'en' => 'en-products',
  28. ];
  29. public const TYPE_PRODUCT = 'product';
  30. public const TYPE_SAV = 'sav';
  31. protected $tranlatedEntity = 'ProductDescription';
  33. /**
  34. * @var int
  35. *
  36. * @ORM\Column(name="products_id", type="integer", nullable=false)
  37. * @ORM\Id
  38. * @ORM\GeneratedValue(strategy="IDENTITY")
  39. */
  40. private $id;
  42. /**
  43. * @ORM\OneToMany(targetEntity="App\Entity\ProductAttribute", mappedBy="product")
  44. */
  45. private $attributes;
  47. /**
  48. * @ORM\OneToMany(targetEntity="App\Entity\Product", mappedBy="parent")
  49. */
  50. private $children = [];
  52. /**
  53. * @ORM\ManyToOne(targetEntity="App\Entity\Product", inversedBy="children")
  54. * @ORM\JoinColumn(name="products_parent_id", referencedColumnName="products_id", nullable=true)
  55. */
  56. private $parent;
  58. /**
  59. * @var ?ProductModel
  60. *
  61. * @ORM\ManyToOne(targetEntity="App\Entity\ProductModel", inversedBy="products")
  62. * @ORM\JoinColumn(name="products_model_id", referencedColumnName="id", nullable=true)
  63. */
  64. private $productModel;
  66. /**
  67. * @ORM\OneToMany(targetEntity="App\Entity\ProductDescription", mappedBy="product")
  68. */
  69. private $descriptions = [];
  71. /**
  72. * @ORM\OneToMany(targetEntity="App\Entity\PictureProduct", mappedBy="product")
  73. * @ORM\OrderBy({"rank" = "ASC", "id" = "ASC"})
  74. */
  75. private $pictures = [];
  77. /**
  78. * @var App\Entity\Manufacturer|null
  79. *
  80. * @ORM\ManyToOne(targetEntity="App\Entity\Manufacturer")
  81. * @ORM\JoinColumn(name="manufacturers_id", referencedColumnName="manufacturers_id", nullable=true)
  82. */
  83. private $manufacturer;
  85. /**
  86. * @ORM\OneToMany(targetEntity="App\Entity\ProductCountryRestriction", mappedBy="product")
  87. */
  88. private $countryRestrictions;
  90. /**
  91. * @ORM\OneToMany(targetEntity="App\Entity\ProductToProductExtraField", mappedBy="product")
  92. */
  93. private $extraFields = [];
  95. /**
  96. * @ORM\OneToMany(targetEntity="App\Entity\ProductPrice", mappedBy="product", cascade={"persist", "remove"}, orphanRemoval=true)
  97. */
  98. private $prices = [];
  100. /**
  101. * @var int
  102. *
  103. * @ORM\Column(name="products_quantity", type="integer", nullable=false)
  104. */
  105. private $quantity = '0';
  107. /**
  108. * @var string|null
  109. *
  110. * @ORM\Column(name="products_model", type="string", length=256, nullable=true)
  111. */
  112. private $model;
  114. /**
  115. * @var string|null
  116. *
  117. * @ORM\Column(name="products_model_sap", type="string", length=50, nullable=true)
  118. */
  119. private $modelSAP;
  121. /**
  122. * @var string|null
  123. *
  124. * @ORM\Column(name="products_ean", type="string", length=50, nullable=true)
  125. */
  126. private $ean;
  128. /**
  129. * @var string|null
  130. *
  131. * @ORM\Column(name="products_image", type="string", length=140, nullable=true)
  132. */
  133. private $image;
  135. /**
  136. * @var string|null
  137. *
  138. * @ORM\Column(name="products_image_med", type="string", length=140, nullable=true)
  139. */
  140. private $imageMed;
  142. /**
  143. * @var string|null
  144. *
  145. * @ORM\Column(name="products_image_lrg", type="string", length=140, nullable=true)
  146. */
  147. private $imageLrg;
  149. /**
  150. * @var string|null
  151. *
  152. * @ORM\Column(name="products_image_sm_1", type="string", length=140, nullable=true)
  153. */
  154. private $imageSm1;
  156. /**
  157. * @var string|null
  158. *
  159. * @ORM\Column(name="products_image_xl_1", type="string", length=140, nullable=true)
  160. */
  161. private $imageXl1;
  163. /**
  164. * @var string|null
  165. *
  166. * @ORM\Column(name="products_image_sm_2", type="string", length=140, nullable=true)
  167. */
  168. private $imageSm2;
  170. /**
  171. * @var string|null
  172. *
  173. * @ORM\Column(name="products_image_xl_2", type="string", length=140, nullable=true)
  174. */
  175. private $imageXl2;
  177. /**
  178. * @var string|null
  179. *
  180. * @ORM\Column(name="products_image_sm_3", type="string", length=140, nullable=true)
  181. */
  182. private $imageSm3;
  184. /**
  185. * @var string|null
  186. *
  187. * @ORM\Column(name="products_image_xl_3", type="string", length=140, nullable=true)
  188. */
  189. private $imageXl3;
  191. /**
  192. * @var string|null
  193. *
  194. * @ORM\Column(name="products_image_sm_4", type="string", length=140, nullable=true)
  195. */
  196. private $imageSm4;
  198. /**
  199. * @var string|null
  200. *
  201. * @ORM\Column(name="products_image_xl_4", type="string", length=140, nullable=true)
  202. */
  203. private $imageXl4;
  205. /**
  206. * @var string|null
  207. *
  208. * @ORM\Column(name="products_image_sm_5", type="string", length=140, nullable=true)
  209. */
  210. private $imageSm5;
  212. /**
  213. * @var string|null
  214. *
  215. * @ORM\Column(name="products_image_xl_5", type="string", length=140, nullable=true)
  216. */
  217. private $imageXl5;
  219. /**
  220. * @var string|null
  221. *
  222. * @ORM\Column(name="products_image_sm_6", type="string", length=140, nullable=true)
  223. */
  224. private $imageSm6;
  226. /**
  227. * @var string|null
  228. *
  229. * @ORM\Column(name="products_image_xl_6", type="string", length=140, nullable=true)
  230. */
  231. private $imageXl6;
  233. /**
  234. * @var float
  235. *
  236. * @ORM\Column(name="products_price", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  237. */
  238. private $price = '0.0000';
  240. /**
  241. * @var float
  242. * @ORM\Column(name="products_ecotax", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  243. */
  244. private $ecotax = '0.0000';
  246. /**
  247. * @var \DateTime
  248. *
  249. * @ORM\Column(name="products_date_added", type="datetime", nullable=false)
  250. */
  251. private $dateAdded;
  253. /**
  254. * @var \DateTime|null
  255. *
  256. * @ORM\Column(name="products_last_modified", type="datetime", nullable=true)
  257. */
  258. private $lastModified;
  260. /**
  261. * @var \DateTime|null
  262. *
  263. * @ORM\Column(name="products_date_available", type="datetime", nullable=true)
  264. */
  265. private $dateAvailable;
  267. /**
  268. * @var string
  269. *
  270. * @ORM\Column(name="products_weight", type="decimal", precision=5, scale=2, nullable=false, options={"default"="0.00"})
  271. */
  272. private $weight = '0.00';
  274. /**
  275. * @var bool
  276. *
  277. * @ORM\Column(name="products_status", type="boolean", nullable=false)
  278. */
  279. private $status = '0';
  281. /** *
  282. * @ORM\ManyToOne(targetEntity="App\Entity\TaxClass", inversedBy="rates")
  283. * @ORM\JoinColumn(name="products_tax_class_id", referencedColumnName="tax_class_id")
  284. */
  285. private $taxClass;
  288. /**
  289. * @var int
  290. *
  291. * @ORM\Column(name="products_ordered", type="integer", nullable=false)
  292. */
  293. private $ordered = '0';
  295. /**
  296. * @var string
  297. *
  298. * @ORM\Column(name="products_price1", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  299. */
  300. private $price1 = '0.0000';
  302. /**
  303. * @var string
  304. *
  305. * @ORM\Column(name="products_price2", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  306. */
  307. private $price2 = '0.0000';
  309. /**
  310. * @var string
  311. *
  312. * @ORM\Column(name="products_price3", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  313. */
  314. private $price3 = '0.0000';
  316. /**
  317. * @var string
  318. *
  319. * @ORM\Column(name="products_price4", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  320. */
  321. private $price4 = '0.0000';
  323. /**
  324. * @var string
  325. *
  326. * @ORM\Column(name="products_price5", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  327. */
  328. private $price5 = '0.0000';
  330. /**
  331. * @var string
  332. *
  333. * @ORM\Column(name="products_price6", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  334. */
  335. private $price6 = '0.0000';
  337. /**
  338. * @var string
  339. *
  340. * @ORM\Column(name="products_price7", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  341. */
  342. private $price7 = '0.0000';
  344. /**
  345. * @var string
  346. *
  347. * @ORM\Column(name="products_price8", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  348. */
  349. private $price8 = '0.0000';
  351. /**
  352. * @var string
  353. *
  354. * @ORM\Column(name="products_price9", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  355. */
  356. private $price9 = '0.0000';
  358. /**
  359. * @var string
  360. *
  361. * @ORM\Column(name="products_price10", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  362. */
  363. private $price10 = '0.0000';
  365. /**
  366. * @var string
  367. *
  368. * @ORM\Column(name="products_price11", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  369. */
  370. private $price11 = '0.0000';
  372. /**
  373. * @var int
  374. *
  375. * @ORM\Column(name="products_price1_qty", type="integer", nullable=false)
  376. */
  377. private $price1Qty = '0';
  379. /**
  380. * @var int
  381. *
  382. * @ORM\Column(name="products_price2_qty", type="integer", nullable=false)
  383. */
  384. private $price2Qty = '0';
  386. /**
  387. * @var int
  388. *
  389. * @ORM\Column(name="products_price3_qty", type="integer", nullable=false)
  390. */
  391. private $price3Qty = '0';
  393. /**
  394. * @var int
  395. *
  396. * @ORM\Column(name="products_price4_qty", type="integer", nullable=false)
  397. */
  398. private $price4Qty = '0';
  400. /**
  401. * @var int
  402. *
  403. * @ORM\Column(name="products_price5_qty", type="integer", nullable=false)
  404. */
  405. private $price5Qty = '0';
  407. /**
  408. * @var int
  409. *
  410. * @ORM\Column(name="products_price6_qty", type="integer", nullable=false)
  411. */
  412. private $price6Qty = '0';
  414. /**
  415. * @var int
  416. *
  417. * @ORM\Column(name="products_price7_qty", type="integer", nullable=false)
  418. */
  419. private $price7Qty = '0';
  421. /**
  422. * @var int
  423. *
  424. * @ORM\Column(name="products_price8_qty", type="integer", nullable=false)
  425. */
  426. private $price8Qty = '0';
  428. /**
  429. * @var int
  430. *
  431. * @ORM\Column(name="products_price9_qty", type="integer", nullable=false)
  432. */
  433. private $price9Qty = '0';
  435. /**
  436. * @var int
  437. *
  438. * @ORM\Column(name="products_price10_qty", type="integer", nullable=false)
  439. */
  440. private $price10Qty = '0';
  442. /**
  443. * @var int
  444. *
  445. * @ORM\Column(name="products_price11_qty", type="integer", nullable=false)
  446. */
  447. private $price11Qty = '0';
  449. /**
  450. * @var int
  451. *
  452. * @ORM\Column(name="products_qty_blocks", type="integer", nullable=false, options={"default"="1"})
  453. */
  454. private $productsQtyBlocks = '1';
  456. /**
  457. * @var bool
  458. *
  459. * @ORM\Column(name="products_soleil", type="integer", nullable=false)
  460. */
  461. private $soleil = '0';
  463. /**
  464. * @var int
  465. *
  466. * @ORM\Column(name="products_limite_panier", type="integer", nullable=false)
  467. */
  468. private $limitePanier = '0';
  470. /**
  471. * @var int|null
  472. *
  473. * @ORM\Column(name="products_page", type="integer", nullable=true)
  474. */
  475. private $page;
  477. /**
  478. * @var bool
  479. *
  480. * @ORM\Column(name="products_garantie", type="integer", nullable=false)
  481. */
  482. private $guaranty = '0';
  484. /**
  485. * @var int
  486. *
  487. * @ORM\Column(name="products_cat", type="integer", nullable=true)
  488. */
  489. private $defaultCategoryId = 0;
  490. private $defaultCategory;
  492. /**
  493. * @var int
  494. *
  495. * @ORM\Column(name="products_index", type="integer", nullable=false, options={"default"="1"})
  496. */
  497. private $index = '1';
  499. /**
  500. * @var int
  501. *
  502. * @ORM\Column(name="products_mvente", type="integer", nullable=false, options={"default"="1"})
  503. */
  504. private $mvente = '1';
  506. /**
  507. * @var int
  508. *
  509. * @ORM\Column(name="products_strategique", type="integer", nullable=false)
  510. */
  511. private $strategique = '0';
  513. /**
  514. * @var int
  515. *
  516. * @ORM\Column(name="products_reappro_non", type="integer", nullable=false)
  517. */
  518. private $reapproNon = '0';
  520. /**
  521. * @var int|null
  522. *
  523. * @ORM\Column(name="products_multiple", type="integer", nullable=true)
  524. */
  525. private $multiple = 1;
  527. /**
  528. * @var string|null
  529. *
  530. * @ORM\Column(name="products_origin", type="string", length=3, nullable=true)
  531. */
  532. private $origin = 1;
  534. /**
  535. * @var bool
  536. *
  537. * @ORM\Column(name="products_gift", type="boolean", nullable=true)
  538. */
  539. private $gift = '0';
  541. /**
  542. * @var ?string
  543. *
  544. * @ORM\Column(name="products_type", type="string", length=20, nullable=true)
  545. */
  546. private $type;
  548. /**
  549. * @var int
  550. *
  551. * @ORM\Column(name="products_welcome", type="boolean", nullable=false, options={"default"="1"})
  552. */
  553. private $welcome = '1';
  555. /**
  556. * @var boolean
  557. *
  558. * @ORM\Column(name="is_default_variant", type="boolean", nullable=false, options={"default"="0"})
  559. */
  560. private $isDefaultVariant = false;
  562. public function __construct()
  563. {
  564. $this->children = new \Doctrine\Common\Collections\ArrayCollection();
  565. $this->prices = new \Doctrine\Common\Collections\ArrayCollection();
  566. $this->descriptions = new \Doctrine\Common\Collections\ArrayCollection();
  567. }
  569. public function getId() {
  570. return $this->id;
  571. }
  573. public function getChildren() {
  574. return $this->children;
  575. }
  577. public function getParent() {
  578. if(!empty($this->parent) && !empty($this->languageId)){
  579. $this->parent->setLanguageId($this->languageId);
  580. }
  581. return $this->parent;
  582. }
  584. public function getProductModel(): ?ProductModel {
  585. return $this->productModel;
  586. }
  588. public function getTopProductModel(): ?ProductModel {
  589. $tmp = $this->productModel;
  590. while(!empty($tmp)) {
  591. if($tmp->hasParent()) {
  592. $tmp = $tmp->getParent();
  593. }else{
  594. return $tmp;
  595. }
  596. }
  597. return $tmp;
  598. }
  600. public function hasProductModel() {
  601. return !empty($this->productModel);
  602. }
  604. /**
  605. * Valeur(s) affichée(s) du produit sur l'axe de listing de son ProductModel racine
  606. * (ex. "Rouge", ou "XS / Rouge" pour un axe composite). Null si aucun axe n'est configuré.
  607. */
  608. public function getListingAxisLabel(): ?string {
  609. $model = $this->getTopProductModel();
  610. if (!$model) {
  611. return null;
  612. }
  613. $values = [];
  614. foreach ($model->getListingAxisCodes() as $code) {
  615. $attr = $this->getAttribute($code);
  616. if ($attr && $attr->getDisplayedValue() !== null && $attr->getDisplayedValue() !== '') {
  617. $values[] = $attr->getDisplayedValue();
  618. }
  619. }
  620. return empty($values) ? null : implode(' / ', $values);
  621. }
  623. /**
  624. * Clé du produit sur l'axe de listing de son ProductModel racine (valeurs brutes, ex. "RED"
  625. * ou "XS|RED"), identique au regroupement de CategoryProductRepository. Null si aucun axe.
  626. */
  627. public function getListingAxisKey(): ?string {
  628. $model = $this->getTopProductModel();
  629. if (!$model) {
  630. return null;
  631. }
  632. $parts = [];
  633. foreach ($model->getListingAxisCodes() as $code) {
  634. $attr = $this->getAttribute($code);
  635. $parts[] = $attr ? (string) $attr->getValue() : '';
  636. }
  637. return implode('', $parts) === '' ? null : implode('|', $parts);
  638. }
  640. public function getDescriptions() {
  641. return $this->descriptions;
  642. }
  644. public function getAttributes() {
  645. return $this->attributes;
  646. }
  648. public function getAttribute($key) {
  649. if (strpos($key, ',') !== false) {
  650. $codes = array_values(array_filter(array_map('trim', explode(',', $key))));
  651. return array_map(fn($code) => $this->getAttribute($code), $codes);
  652. }
  653. if($this->attributes) {
  654. foreach($this->getAttributes() as $attr) {
  655. if($attr->getAttribute()->getCode() == $key)
  656. return $attr;
  657. }
  658. }
  659. return null;
  660. }
  662. public function getAttributeValue($key) {
  663. $attr = $this->getAttribute($key);
  664. if (is_array($attr)) {
  665. return implode(' / ', array_map(fn($a) => $a ? $a->getDisplayedValue() : '', $attr));
  666. }
  667. return $attr ? $attr->getDisplayedValue() : null;
  668. }
  670. public function getQuantity() {
  671. return $this->quantity;
  672. }
  674. public function getModel() {
  675. return $this->model;
  676. }
  678. public function getModelSAP(): ?string {
  679. return $this->modelSAP;
  680. }
  682. public function getEan(): ?string {
  683. return $this->ean;
  684. }
  686. public function getName() {
  687. if(!empty($this->languageId)){
  688. $description = null;
  689. foreach($this->descriptions as $d){
  690. if($d->getLanguage()->getId()==$this->languageId){
  691. $description = $d;
  692. break;
  693. }
  694. }
  695. }
  696. if(empty($description) && count($this->descriptions)){
  697. $description = $this->descriptions[0];
  698. }
  699. return empty($description)?'':$description->getName();
  700. }
  702. public function getHeadingTitle() {
  703. if(!empty($this->languageId)){
  704. $description = null;
  705. foreach($this->descriptions as $d){
  706. if($d->getLanguage()->getId()==$this->languageId){
  707. $description = $d;
  708. break;
  709. }
  710. }
  711. }
  712. if(empty($description) && count($this->descriptions)){
  713. $description = $this->descriptions[0];
  714. }
  715. return empty($description)?'':$description->getHeadingTitle();
  716. }
  718. public function getDeclinaison() {
  719. $output = '';
  720. if($this->parent){
  721. $name = $this->getName();
  722. $output = substr($name, strlen($this->getParent()->getName())+2, strlen($name));
  723. }
  724. return $output;
  725. }
  727. public function getUrl() {
  728. if(!empty($this->languageId)){
  729. $description = null;
  730. foreach($this->descriptions as $d){
  731. if($d->getLanguage()->getId()==$this->languageId){
  732. $description = $d;
  733. break;
  734. }
  735. }
  736. }
  737. if(empty($description) && count($this->descriptions)){
  738. $description = $this->descriptions[0];
  739. }
  740. return empty($description)?'':$description->getUrl();
  741. }
  743. public function getDescription() {
  744. if(!empty($this->languageId)){
  745. $description = null;
  746. foreach($this->descriptions as $d){
  747. if($d->getLanguage()->getId()==$this->languageId){
  748. $description = $d;
  749. break;
  750. }
  751. }
  752. }
  753. if(empty($description) && count($this->descriptions)){
  754. $description = $this->descriptions[0];
  755. }
  756. return empty($description)?'':$description->getDescription();
  757. }
  759. public function getExtraFields() {
  760. return $this->extraFields;
  761. }
  763. public function getProductDescription($lang='fr') : ?ProductDescription {
  764. foreach($this->getDescriptions() as $desc){
  765. if($desc->getLanguage()->getCode() == $lang)
  766. return $desc;
  767. }
  768. return null;
  769. }
  771. /**
  772. * Première image (ordre rank, id), quelles que soient les clés de la collection
  773. */
  774. public function getPicture() {
  775. foreach($this->pictures ?? [] as $picture) {
  776. return $picture;
  777. }
  778. return null;
  779. }
  781. public function getPictures() {
  782. return $this->pictures;
  783. }
  785. public function getPicturesUrl() {
  786. $output = [];
  787. foreach($this->pictures as $picture){
  788. $output[] = $picture->getUrl();
  789. }
  790. return $output;
  791. }
  793. public function getImage($absolute=false) {
  794. if($absolute)
  795. return 'https://www.dogcat.com/professionnel/images/'.$this->image;
  796. return $this->image;
  797. }
  799. public function getImageMed($absolute=false) {
  800. if($absolute)
  801. return 'https://www.dogcat.com/professionnel/images/'.$this->imageMed;
  802. return $this->imageMed;
  803. }
  805. public function getImageLrg($absolute=false) {
  806. if($absolute)
  807. return 'https://www.dogcat.com/professionnel/images/'.$this->imageLrg;
  808. return $this->imageLrg;
  809. }
  811. public function getImageSm1() {
  812. return $this->imageSm1;
  813. }
  815. public function getImageXl1() {
  816. return $this->imageXl1;
  817. }
  819. public function getImageSm2() {
  820. return $this->imageSm2;
  821. }
  823. public function getImageXl2() {
  824. return $this->imageXl2;
  825. }
  827. public function getImageSm3() {
  828. return $this->imageSm3;
  829. }
  831. public function getImageXl3() {
  832. return $this->imageXl3;
  833. }
  835. public function getImageSm4() {
  836. return $this->imageSm4;
  837. }
  839. public function getImageXl4() {
  840. return $this->imageXl4;
  841. }
  843. public function getImageSm5() {
  844. return $this->imageSm5;
  845. }
  847. public function getImageXl5() {
  848. return $this->imageXl5;
  849. }
  851. public function getImageSm6() {
  852. return $this->imageSm6;
  853. }
  855. public function getImageXl6() {
  856. return $this->imageXl6;
  857. }
  859. public function getPrice($withEcotax = false, ?PriceGroup $priceGroup = null, $withVat = false) {
  860. $price = $this->price;
  861. $tax = 0;
  862. if($this->isGift()) {
  863. return 0;
  864. }
  865. if($priceGroup) {
  866. $price = $this->getPriceByGroup($priceGroup);
  867. }
  868. if($withVat) {
  869. $tax = Encoder::roundPrice($price*self::VAT_RATE);
  870. }
  871. if($withEcotax === true){
  872. return Encoder::roundPrice($price) + Encoder::roundPrice($this->getEcotax()) + $tax;
  873. }
  874. return Encoder::roundPrice($price) + $tax;
  875. }
  877. public function getPrices() {
  878. return $this->prices;
  879. }
  881. public function getPriceByGroup(PriceGroup $priceGroup) {
  883. foreach($this->prices as $price) {
  884. if($price->getGroup() == $priceGroup) {
  885. return $price->getPrice();
  886. }
  887. }
  888. // throw new \App\Exception\PriceGroupException();
  889. }
  891. public function hasPrice(PriceGroup $priceGroup) {
  892. if($this->hasChildren()) {
  893. foreach($this->getChildren() as $child) {
  894. if($child->hasPrice($priceGroup))
  895. return true;
  896. }
  897. }else{
  898. foreach($this->prices as $price) {
  899. if($price->getGroup() == $priceGroup)
  900. return true;
  901. }
  902. }
  903. return false;
  904. }
  906. public function getEcotax() {
  907. return $this->ecotax;
  908. }
  910. public function getFromProduct(?PriceGroup $priceGroup = null) {
  911. $tmp = null;
  912. $from = null;
  913. foreach($this->children as $product){
  914. if(!$product->isStopped() && $product->isActive()){
  915. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  916. continue;
  917. }
  918. if(is_null($tmp) || ($tmp>$product->getPrice(false, $priceGroup, false))){
  919. $tmp = $product->getPrice(false, $priceGroup, false);
  920. $from = $product;
  921. }
  922. }
  923. }
  924. return $from;
  925. }
  927. public function getFromPrice($withEcotax = true, ?PriceGroup $priceGroup = null, $withVat = false) {
  928. $tmp = null;
  929. foreach($this->children as $product){
  930. if(!$product->isStopped() && $product->isActive()){
  931. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  932. continue;
  933. }
  934. if(is_null($tmp) || ($tmp>$product->getPrice($withEcotax, $priceGroup, $withVat))){
  935. $tmp = $product->getPrice($withEcotax, $priceGroup, $withVat);
  936. }
  937. }
  938. }
  939. return is_null($tmp)?0:$tmp;
  940. }
  942. public function getSoleilPrice($withEcotax = true) {
  943. if($this->isNonSoleil()){
  944. return Encoder::roundPrice($this->price * 0.9)+($withEcotax?$this->getEcotax():0);
  945. }else if($this->isSoleil()){
  946. return Encoder::roundPrice($this->price * 0.75)+($withEcotax?$this->getEcotax():0);
  947. }
  948. return Encoder::roundPrice($this->price)+($withEcotax?$this->getEcotax():0);
  949. }
  951. public function getDateAdded() {
  952. return $this->dateAdded;
  953. }
  955. public function getLastModified() {
  956. return $this->lastModified;
  957. }
  959. public function getDateAvailable() {
  960. return $this->dateAvailable;
  961. }
  963. public function getWeight() {
  964. return $this->weight;
  965. }
  967. public function getStatus() {
  968. return $this->status;
  969. }
  971. public function getTaxClass() {
  972. return $this->taxClass;
  973. }
  975. public function getManufacturer() {
  976. return $this->manufacturer;
  977. }
  979. public function getOrdered() {
  980. return $this->ordered;
  981. }
  983. public function getPrice1() {
  984. return $this->price1;
  985. }
  987. public function getPrice2() {
  988. return $this->price2;
  989. }
  991. public function getPrice3() {
  992. return $this->price3;
  993. }
  995. public function getPrice4() {
  996. return $this->price4;
  997. }
  999. public function getPrice5() {
  1000. return $this->price5;
  1001. }
  1003. public function getPrice6() {
  1004. return $this->price6;
  1005. }
  1007. public function getPrice7() {
  1008. return $this->price7;
  1009. }
  1011. public function getPrice8() {
  1012. return $this->price8;
  1013. }
  1015. public function getPrice9() {
  1016. return $this->price9;
  1017. }
  1019. public function getPrice10() {
  1020. return $this->price10;
  1021. }
  1023. public function getPrice11() {
  1024. return $this->price11;
  1025. }
  1027. public function getPrice1Qty() {
  1028. return $this->price1Qty;
  1029. }
  1031. public function getPrice2Qty() {
  1032. return $this->price2Qty;
  1033. }
  1035. public function getPrice3Qty() {
  1036. return $this->price3Qty;
  1037. }
  1039. public function getPrice4Qty() {
  1040. return $this->price4Qty;
  1041. }
  1043. public function getPrice5Qty() {
  1044. return $this->price5Qty;
  1045. }
  1047. public function getPrice6Qty() {
  1048. return $this->price6Qty;
  1049. }
  1051. public function getPrice7Qty() {
  1052. return $this->price7Qty;
  1053. }
  1055. public function getPrice8Qty() {
  1056. return $this->price8Qty;
  1057. }
  1059. public function getPrice9Qty() {
  1060. return $this->price9Qty;
  1061. }
  1063. public function getPrice10Qty() {
  1064. return $this->price10Qty;
  1065. }
  1067. public function getPrice11Qty() {
  1068. return $this->price11Qty;
  1069. }
  1071. public function getProductsQtyBlocks() {
  1072. return $this->productsQtyBlocks;
  1073. }
  1075. public function getSoleil() {
  1076. return $this->soleil;
  1077. }
  1079. public function getLimitePanier() {
  1080. return $this->limitePanier;
  1081. }
  1083. public function getPage() {
  1084. return $this->page;
  1085. }
  1087. public function getGuaranty() {
  1088. return $this->guaranty;
  1089. }
  1091. public function getDefaultCategoryId() {
  1092. return $this->defaultCategoryId;
  1093. }
  1095. public function getDefaultCategory() {
  1096. return $this->defaultCategory;
  1097. }
  1099. public function getIndex() {
  1100. if(empty($this->index))
  1101. return 0;
  1102. return $this->index > 0 ? 1 : 0;
  1103. }
  1105. public function getMvente() {
  1106. return $this->mvente;
  1107. }
  1109. public function getStrategique() {
  1110. return $this->strategique;
  1111. }
  1113. public function getReapproNon() {
  1114. return $this->reapproNon;
  1115. }
  1117. public function getMultiple() {
  1118. return empty($this->multiple)?1:$this->multiple;
  1119. }
  1122. public function getOrigin() {
  1123. return $this->origin;
  1124. }
  1126. public function getReference() {
  1127. return $this->getModel();
  1128. }
  1130. public function getGift() {
  1131. return is_null($this->gift) ? 0 : $this->gift;
  1132. }
  1134. public function getType(): ?string {
  1135. return empty($this->type) ? self::TYPE_PRODUCT : $this->type;
  1136. }
  1138. public function getCountryRestrictions() {
  1139. return $this->countryRestrictions;
  1140. }
  1143. public function getRestrictedCountries() {
  1144. $output = [];
  1145. foreach($this->getCountryRestrictions() as $rc) {
  1146. $output[] = $rc->getCountry();
  1147. }
  1148. return $output;
  1149. }
  1151. public function getWelcome(): int {
  1152. return $this->welcome;
  1153. }
  1155. public function getIsDefaultVariant() {
  1156. return $this->isDefaultVariant;
  1157. }
  1161. // public function getUrl($absolute=false) {
  1162. // if(!empty($this->parent))
  1163. // return $this->getParent()->getUrl($absolute);
  1164. // if(!empty($this->languageId)){
  1165. // $language = $this->languageId==4?'fr':'en';
  1166. // }
  1167. // if(empty($language)){
  1168. // $language = 'fr';
  1169. // }
  1170. //// $url = '/professionnel/product_info.php?products_id='.$this->getId().'&language='.$language;
  1171. //// if($absolute)
  1172. //// return 'https://www.dogcat.com'.$url;
  1173. // return $this->getUrl();
  1174. // }
  1176. public function setId($id) {
  1177. $this->id = $id;
  1178. }
  1180. public function setAttributes($attributes) {
  1181. $this->attributes = $attributes;
  1182. }
  1184. public function setChildren($children) {
  1185. $this->children = $children;
  1186. }
  1188. public function setProductModel(?ProductModel $productModel): void {
  1189. $this->productModel = $productModel;
  1190. }
  1192. public function setParent($parent) {
  1193. $this->parent = $parent;
  1194. }
  1196. public function setDescriptions($descriptions) {
  1197. $this->descriptions = $descriptions;
  1198. }
  1200. public function setExtraFields($extraFields): void {
  1201. $this->extraFields = $extraFields;
  1202. }
  1204. public function setQuantity($quantity) {
  1205. $this->quantity = $quantity;
  1206. }
  1208. public function setModel($model) {
  1209. $this->model = $model;
  1210. }
  1212. public function setModelSAP(?string $modelSAP): void {
  1213. $this->modelSAP = $modelSAP;
  1214. }
  1216. public function setEan(?string $ean): void {
  1217. $this->ean = $ean;
  1218. }
  1220. public function setImage($image) {
  1221. $this->image = $image;
  1222. }
  1224. public function setImageMed($imageMed) {
  1225. $this->imageMed = $imageMed;
  1226. }
  1228. public function setImageLrg($imageLrg) {
  1229. $this->imageLrg = $imageLrg;
  1230. }
  1232. public function setImageSm1($imageSm1) {
  1233. $this->imageSm1 = $imageSm1;
  1234. }
  1236. public function setImageXl1($imageXl1) {
  1237. $this->imageXl1 = $imageXl1;
  1238. }
  1240. public function setImageSm2($imageSm2) {
  1241. $this->imageSm2 = $imageSm2;
  1242. }
  1244. public function setImageXl2($imageXl2) {
  1245. $this->imageXl2 = $imageXl2;
  1246. }
  1248. public function setImageSm3($imageSm3) {
  1249. $this->imageSm3 = $imageSm3;
  1250. }
  1252. public function setImageXl3($imageXl3) {
  1253. $this->imageXl3 = $imageXl3;
  1254. }
  1256. public function setImageSm4($imageSm4) {
  1257. $this->imageSm4 = $imageSm4;
  1258. }
  1260. public function setImageXl4($imageXl4) {
  1261. $this->imageXl4 = $imageXl4;
  1262. }
  1264. public function setImageSm5($imageSm5) {
  1265. $this->imageSm5 = $imageSm5;
  1266. }
  1268. public function setImageXl5($imageXl5) {
  1269. $this->imageXl5 = $imageXl5;
  1270. }
  1272. public function setImageSm6($imageSm6) {
  1273. $this->imageSm6 = $imageSm6;
  1274. }
  1276. public function setImageXl6($imageXl6) {
  1277. $this->imageXl6 = $imageXl6;
  1278. }
  1280. public function setPrice($price) {
  1281. $this->price = $price;
  1282. }
  1284. public function setEcotax( $ecotax) {
  1285. $this->ecotax = $ecotax;
  1286. }
  1288. public function setDateAdded(\DateTime $dateAdded) {
  1289. $this->dateAdded = $dateAdded;
  1290. }
  1292. public function setLastModified(\DateTime $lastModified) {
  1293. $this->lastModified = $lastModified;
  1294. }
  1296. public function setDateAvailable(\DateTime $dateAvailable) {
  1297. $this->dateAvailable = $dateAvailable;
  1298. }
  1300. public function setWeight($weight) {
  1301. $this->weight = $weight;
  1302. }
  1304. public function setStatus($status) {
  1305. $this->status = $status;
  1306. }
  1308. public function setTaxClass($taxClass) {
  1309. $this->taxClass = $taxClass;
  1310. }
  1312. public function setManufacturer($manufacturer) {
  1313. $this->manufacturer = $manufacturer;
  1314. }
  1316. public function setOrdered($ordered) {
  1317. $this->ordered = $ordered;
  1318. }
  1320. public function setParentId($parentId) {
  1321. $this->parentId = $parentId;
  1322. }
  1324. public function setPrice1($price1) {
  1325. $this->price1 = $price1;
  1326. }
  1328. public function setPrice2($price2) {
  1329. $this->price2 = $price2;
  1330. }
  1332. public function setPrice3($price3) {
  1333. $this->price3 = $price3;
  1334. }
  1336. public function setPrice4($price4) {
  1337. $this->price4 = $price4;
  1338. }
  1340. public function setPrice5($price5) {
  1341. $this->price5 = $price5;
  1342. }
  1344. public function setPrice6($price6) {
  1345. $this->price6 = $price6;
  1346. }
  1348. public function setPrice7($price7) {
  1349. $this->price7 = $price7;
  1350. }
  1352. public function setPrice8($price8) {
  1353. $this->price8 = $price8;
  1354. }
  1356. public function setPrice9($price9) {
  1357. $this->price9 = $price9;
  1358. }
  1360. public function setPrice10($price10) {
  1361. $this->price10 = $price10;
  1362. }
  1364. public function setPrice11($price11) {
  1365. $this->price11 = $price11;
  1366. }
  1368. public function setPrice1Qty($price1Qty) {
  1369. $this->price1Qty = $price1Qty;
  1370. }
  1372. public function setPrice2Qty($price2Qty) {
  1373. $this->price2Qty = $price2Qty;
  1374. }
  1376. public function setPrice3Qty($price3Qty) {
  1377. $this->price3Qty = $price3Qty;
  1378. }
  1380. public function setPrice4Qty($price4Qty) {
  1381. $this->price4Qty = $price4Qty;
  1382. }
  1384. public function setPrice5Qty($price5Qty) {
  1385. $this->price5Qty = $price5Qty;
  1386. }
  1388. public function setPrice6Qty($price6Qty) {
  1389. $this->price6Qty = $price6Qty;
  1390. }
  1392. public function setPrice7Qty($price7Qty) {
  1393. $this->price7Qty = $price7Qty;
  1394. }
  1396. public function setPrice8Qty($price8Qty) {
  1397. $this->price8Qty = $price8Qty;
  1398. }
  1400. public function setPrice9Qty($price9Qty) {
  1401. $this->price9Qty = $price9Qty;
  1402. }
  1404. public function setPrice10Qty($price10Qty) {
  1405. $this->price10Qty = $price10Qty;
  1406. }
  1408. public function setPrice11Qty($price11Qty) {
  1409. $this->price11Qty = $price11Qty;
  1410. }
  1412. public function setProductsQtyBlocks($productsQtyBlocks) {
  1413. $this->productsQtyBlocks = $productsQtyBlocks;
  1414. }
  1416. public function setSoleil($soleil) {
  1417. $this->soleil = $soleil;
  1418. }
  1420. public function setLimitePanier($limitePanier) {
  1421. $this->limitePanier = $limitePanier;
  1422. }
  1424. public function setPage($page) {
  1425. $this->page = $page;
  1426. }
  1428. public function setGuaranty($guaranty) {
  1429. $this->guaranty = $guaranty;
  1430. }
  1432. public function setDefaultCategoryId($defaultCategoryId) {
  1433. $this->defaultCategoryId = $defaultCategoryId;
  1434. }
  1436. public function setIndex($index) {
  1437. $this->index = $index;
  1438. }
  1440. public function setMvente($mvente) {
  1441. $this->mvente = $mvente;
  1442. }
  1444. public function setStrategique($strategique) {
  1445. $this->strategique = $strategique;
  1446. }
  1448. public function setReapproNon($reapproNon) {
  1449. $this->reapproNon = $reapproNon;
  1450. }
  1452. public function setMultiple($multiple) {
  1453. return $this->multiple = $multiple;
  1454. }
  1456. public function setOrigin($origin) {
  1457. $this->origin = $origin;
  1458. }
  1460. public function setPrices($prices) {
  1461. $this->prices = $prices;
  1462. }
  1464. public function setGift($gift) {
  1465. $this->gift = $gift;
  1466. }
  1468. public function setType(?string $type): void {
  1469. $this->type = $type;
  1470. }
  1472. public function setCountryRestrictions($countryRestrictions): void {
  1473. $this->countryRestrictions = $countryRestrictions;
  1474. }
  1476. public function setWelcome(int $welcome): void {
  1477. $this->welcome = $welcome;
  1478. }
  1480. public function setIsDefaultVariant($isDefaultVariant): void {
  1481. $this->isDefaultVariant = $isDefaultVariant;
  1482. }
  1484. public function getCaracteristics() {
  1485. $output = [];
  1486. foreach($this->getAttributes() as $attr) {
  1487. if($attr->getAttribute()->getShowInCaracteristic())
  1488. $output[] = $attr;
  1489. }
  1490. // même ordre que les filtres (attributes_order), usort est stable : l'ordre d'origine départage les égalités
  1491. usort($output, fn($a, $b) => $a->getAttribute()->getSortOrder() <=> $b->getAttribute()->getSortOrder());
  1492. return $output;
  1493. }
  1495. public function hasWelcomeDiscount() {
  1496. return !empty($this->welcome);
  1497. }
  1499. public function isMadeInFrance() {
  1500. if(!empty($this->origin))
  1501. return strtoupper($this->origin) == 'FR';
  1502. if($this->hasChildren()){
  1503. foreach($this->children as $child){
  1504. if(!$child->isMadeInFrance()){
  1505. return false;
  1506. }
  1507. }
  1508. return true;
  1509. }
  1510. return false;
  1511. }
  1513. public function isAvailable() {
  1514. return $this->quantity > 0;
  1515. }
  1517. public function isDefaultVariant() {
  1518. return !empty($this->isDefaultVariant);
  1519. }
  1521. public function hasRestrictionForCountry($country) {
  1522. if($country){
  1523. if($this->countryRestrictions){
  1524. foreach($this->getCountryRestrictions() as $restriction){
  1525. if($restriction->getCountry() == $country){
  1526. return true;
  1527. }
  1528. }
  1529. }
  1530. }
  1531. return false;
  1532. }
  1534. public function isAvailableForCountry($country) {
  1535. if($country && $this->countryRestrictions){
  1536. foreach($this->getCountryRestrictions() as $restriction) {
  1537. if($restriction->getCountry() == $country){
  1538. return false;
  1539. }
  1540. }
  1541. }
  1542. if($country && $this->getManufacturer()){
  1543. return $this->getManufacturer()->isAvailableForCountry($country);
  1544. }
  1545. return true;
  1546. }
  1548. public function isStopped() {
  1549. return $this->quantity == -800;
  1550. }
  1552. public function isActive() {
  1553. return $this->getStatus() == 1;
  1554. }
  1556. public function isGift() {
  1557. return $this->getGift() == 1;
  1558. }
  1560. public function isSoleil() {
  1561. if($this->manufacturer?->isNoSoleil())
  1562. return false;
  1563. return $this->soleil == 1;
  1564. }
  1566. public function isNonSoleil() {
  1567. if($this->manufacturer?->isNoSoleil())
  1568. return false;
  1569. return $this->soleil == 0;
  1570. }
  1572. public function isVivog() {
  1573. return $this->isSoleil() || $this->isNonSoleil();
  1574. }
  1576. public function isParent() {
  1577. return empty($this->parent);
  1578. }
  1580. public function isProduct() {
  1581. return $this->getType() == self::TYPE_PRODUCT;
  1582. }
  1584. public function hasChildren() {
  1585. return count($this->children)>0;
  1586. }
  1588. public function hasSoleilPrice() {
  1589. return $this->isSoleil() || $this->isNonSoleil();
  1590. }
  1592. public function hasParent() {
  1593. return !empty($this->parent);
  1594. }
  1596. public function hasSoleil() {
  1597. return $this->isSoleil();
  1598. }
  1600. public function hasNonSoleil() {
  1601. return $this->isNonSoleil();
  1602. }
  1604. public function addPrice(ProductPrice $productPrice): self
  1605. {
  1606. if (!$this->prices->contains($productPrice)) {
  1607. $this->prices->add($productPrice);
  1608. $productPrice->setProduct($this);
  1609. }
  1610. return $this;
  1611. }
  1613. public function removePrice(ProductPrice $productPrice): self
  1614. {
  1615. if ($this->prices->removeElement($productPrice)) {
  1616. if ($productPrice->getProduct() === $this) {
  1617. $productPrice->setProduct(null);
  1618. }
  1619. }
  1620. return $this;
  1621. }
  1623. public function toArray() : array{
  1624. $parent = $this->getParent();
  1625. $manufacturer = $this->getManufacturer();
  1626. $output = [
  1627. 'id' => $this->getId(),
  1628. 'model' => $this->getModel(),
  1629. 'name' => $this->getName(),
  1630. 'description' => $this->getDescription(),
  1631. 'quantity' => $this->getQuantity(),
  1632. 'image' => $this->getImage(),
  1633. 'price' => $this->getPrice(),
  1634. 'dateAdded' => $this->getDateAdded(),
  1635. 'lastModified' => $this->getLastModified(),
  1636. 'dateAvailable' => $this->getDateAvailable(),
  1637. 'weight' => $this->getWeight(),
  1638. 'status' => $this->getStatus()?1:0,
  1639. 'taxClass ' => $this->getTaxClass()?$this->getTaxClass()->toArray():0,
  1640. 'ordered' => $this->getOrdered(),
  1641. 'parent' => empty($parent)?null:$parent->toArray(),
  1642. 'manufacturer' => empty($manufacturer)?null:$manufacturer->toArray(),
  1643. 'productsQtyBlocks' => $this->getProductsQtyBlocks(),
  1644. 'soleil' => $this->getSoleil(),
  1645. 'nbChildren' => count($this->getChildren()),
  1646. 'limitePanier' => $this->getLimitePanier(),
  1647. 'page' => $this->getPage(),
  1648. 'garantie' => $this->getGuaranty(),
  1649. 'defaultCategoryId' => $this->getDefaultCategoryId(),
  1650. 'index' => $this->getIndex(),
  1651. 'mvente' => $this->getMvente(),
  1652. 'strategique' => $this->getStrategique(),
  1653. 'reapproNon' => $this->getReapproNon(),
  1654. 'multiple' => $this->getMultiple(),
  1655. ];
  1656. return $output;
  1657. }
  1659. public function toJson() {
  1660. return json_encode($this->toArray());
  1661. }
  1663. /**
  1664. * @todo Remove once 0 values in the table are converted to NULL.
  1665. */
  1666. public function loadDescriptions(\Doctrine\ORM\EntityManager $em)
  1667. {
  1668. $conn = $em->getConnection();
  1669. $sql = $conn->prepare('select * from products_description where products_id = '.$this->getId());
  1670. $sql->execute();
  1671. $rows = $sql->fetchAll();
  1672. $descriptions = [];
  1673. foreach($rows as $desc){
  1674. $description = new ProductDescription();
  1675. $description->setName($desc['products_name']);
  1676. $description->setDescription($desc['products_description']);
  1677. $description->setLanguage($em->getRepository('App:Language')->find($desc['language_id']==1?1:4));
  1678. $descriptions[] = $description;
  1679. }
  1680. $this->setDescriptions($descriptions);
  1681. }
  1683. public static function getSearchIndex($lang = 'fr')
  1684. {
  1685. return self::SEARCH_INDICES[$lang];
  1686. }
  1688. /**
  1689. * @ORM\PrePersist
  1690. */
  1691. public function prePersit(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  1692. $this->setDateAdded(new \DateTime);
  1693. }
  1695. /**
  1696. * @ORM\PrePersist
  1697. * @ORM\PreUpdate
  1698. */
  1699. public function preUpdate(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  1700. if(is_null($this->weight))
  1701. $this->setWeight(0);
  1702. }
  1704. }