src/Entity/Product.php line 621

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")
  15. * @ORM\Entity(repositoryClass="App\Repository\ProductRepository")
  16. * @ORM\HasLifecycleCallbacks()
  17. */
  18. class Product extends TranslatedEntity
  19. {
  21. public const VAT_RATE = 0.2;
  22. public const SEARCH_INDICES = [
  23. 'fr' => 'fr-products',
  24. 'en' => 'en-products',
  25. ];
  26. public const TYPE_PRODUCT = 'product';
  27. public const TYPE_SAV = 'sav';
  28. protected $tranlatedEntity = 'ProductDescription';
  30. /**
  31. * @var int
  32. *
  33. * @ORM\Column(name="products_id", type="integer", nullable=false)
  34. * @ORM\Id
  35. * @ORM\GeneratedValue(strategy="IDENTITY")
  36. */
  37. private $id;
  39. /**
  40. * @ORM\OneToMany(targetEntity="App\Entity\ProductAttribute", mappedBy="product")
  41. */
  42. private $attributes;
  44. /**
  45. * @ORM\OneToMany(targetEntity="App\Entity\Product", mappedBy="parent")
  46. */
  47. private $children = [];
  49. /**
  50. * @ORM\ManyToOne(targetEntity="App\Entity\Product", inversedBy="children")
  51. * @ORM\JoinColumn(name="products_parent_id", referencedColumnName="products_id", nullable=true)
  52. */
  53. private $parent;
  55. /**
  56. * @var ?ProductModel
  57. *
  58. * @ORM\ManyToOne(targetEntity="App\Entity\ProductModel", inversedBy="products")
  59. * @ORM\JoinColumn(name="products_model_id", referencedColumnName="id", nullable=true)
  60. */
  61. private $productModel;
  63. /**
  64. * @ORM\OneToMany(targetEntity="App\Entity\ProductDescription", mappedBy="product")
  65. */
  66. private $descriptions = [];
  68. /**
  69. * @ORM\OneToMany(targetEntity="App\Entity\PictureProduct", mappedBy="product")
  70. * @ORM\OrderBy({"rank" = "ASC", "id" = "ASC"})
  71. */
  72. private $pictures = [];
  74. /**
  75. * @var App\Entity\Manufacturer|null
  76. *
  77. * @ORM\ManyToOne(targetEntity="App\Entity\Manufacturer")
  78. * @ORM\JoinColumn(name="manufacturers_id", referencedColumnName="manufacturers_id", nullable=true)
  79. */
  80. private $manufacturer;
  82. /**
  83. * @ORM\OneToMany(targetEntity="App\Entity\ProductCountryRestriction", mappedBy="product")
  84. */
  85. private $countryRestrictions;
  87. /**
  88. * @ORM\OneToMany(targetEntity="App\Entity\ProductToProductExtraField", mappedBy="product")
  89. */
  90. private $extraFields = [];
  92. /**
  93. * @ORM\OneToMany(targetEntity="App\Entity\ProductPrice", mappedBy="product", cascade={"persist", "remove"}, orphanRemoval=true)
  94. */
  95. private $prices = [];
  97. /**
  98. * @var int
  99. *
  100. * @ORM\Column(name="products_quantity", type="integer", nullable=false)
  101. */
  102. private $quantity = '0';
  104. /**
  105. * @var string|null
  106. *
  107. * @ORM\Column(name="products_model", type="string", length=256, nullable=true)
  108. */
  109. private $model;
  111. /**
  112. * @var string|null
  113. *
  114. * @ORM\Column(name="products_model_sap", type="string", length=50, nullable=true)
  115. */
  116. private $modelSAP;
  118. /**
  119. * @var string|null
  120. *
  121. * @ORM\Column(name="products_ean", type="string", length=50, nullable=true)
  122. */
  123. private $ean;
  125. /**
  126. * @var string|null
  127. *
  128. * @ORM\Column(name="products_image", type="string", length=140, nullable=true)
  129. */
  130. private $image;
  132. /**
  133. * @var string|null
  134. *
  135. * @ORM\Column(name="products_image_med", type="string", length=140, nullable=true)
  136. */
  137. private $imageMed;
  139. /**
  140. * @var string|null
  141. *
  142. * @ORM\Column(name="products_image_lrg", type="string", length=140, nullable=true)
  143. */
  144. private $imageLrg;
  146. /**
  147. * @var string|null
  148. *
  149. * @ORM\Column(name="products_image_sm_1", type="string", length=140, nullable=true)
  150. */
  151. private $imageSm1;
  153. /**
  154. * @var string|null
  155. *
  156. * @ORM\Column(name="products_image_xl_1", type="string", length=140, nullable=true)
  157. */
  158. private $imageXl1;
  160. /**
  161. * @var string|null
  162. *
  163. * @ORM\Column(name="products_image_sm_2", type="string", length=140, nullable=true)
  164. */
  165. private $imageSm2;
  167. /**
  168. * @var string|null
  169. *
  170. * @ORM\Column(name="products_image_xl_2", type="string", length=140, nullable=true)
  171. */
  172. private $imageXl2;
  174. /**
  175. * @var string|null
  176. *
  177. * @ORM\Column(name="products_image_sm_3", type="string", length=140, nullable=true)
  178. */
  179. private $imageSm3;
  181. /**
  182. * @var string|null
  183. *
  184. * @ORM\Column(name="products_image_xl_3", type="string", length=140, nullable=true)
  185. */
  186. private $imageXl3;
  188. /**
  189. * @var string|null
  190. *
  191. * @ORM\Column(name="products_image_sm_4", type="string", length=140, nullable=true)
  192. */
  193. private $imageSm4;
  195. /**
  196. * @var string|null
  197. *
  198. * @ORM\Column(name="products_image_xl_4", type="string", length=140, nullable=true)
  199. */
  200. private $imageXl4;
  202. /**
  203. * @var string|null
  204. *
  205. * @ORM\Column(name="products_image_sm_5", type="string", length=140, nullable=true)
  206. */
  207. private $imageSm5;
  209. /**
  210. * @var string|null
  211. *
  212. * @ORM\Column(name="products_image_xl_5", type="string", length=140, nullable=true)
  213. */
  214. private $imageXl5;
  216. /**
  217. * @var string|null
  218. *
  219. * @ORM\Column(name="products_image_sm_6", type="string", length=140, nullable=true)
  220. */
  221. private $imageSm6;
  223. /**
  224. * @var string|null
  225. *
  226. * @ORM\Column(name="products_image_xl_6", type="string", length=140, nullable=true)
  227. */
  228. private $imageXl6;
  230. /**
  231. * @var float
  232. *
  233. * @ORM\Column(name="products_price", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  234. */
  235. private $price = '0.0000';
  237. /**
  238. * @var float
  239. * @ORM\Column(name="products_ecotax", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  240. */
  241. private $ecotax = '0.0000';
  243. /**
  244. * @var \DateTime
  245. *
  246. * @ORM\Column(name="products_date_added", type="datetime", nullable=false)
  247. */
  248. private $dateAdded;
  250. /**
  251. * @var \DateTime|null
  252. *
  253. * @ORM\Column(name="products_last_modified", type="datetime", nullable=true)
  254. */
  255. private $lastModified;
  257. /**
  258. * @var \DateTime|null
  259. *
  260. * @ORM\Column(name="products_date_available", type="datetime", nullable=true)
  261. */
  262. private $dateAvailable;
  264. /**
  265. * @var string
  266. *
  267. * @ORM\Column(name="products_weight", type="decimal", precision=5, scale=2, nullable=false, options={"default"="0.00"})
  268. */
  269. private $weight = '0.00';
  271. /**
  272. * @var bool
  273. *
  274. * @ORM\Column(name="products_status", type="boolean", nullable=false)
  275. */
  276. private $status = '0';
  278. /** *
  279. * @ORM\ManyToOne(targetEntity="App\Entity\TaxClass", inversedBy="rates")
  280. * @ORM\JoinColumn(name="products_tax_class_id", referencedColumnName="tax_class_id")
  281. */
  282. private $taxClass;
  285. /**
  286. * @var int
  287. *
  288. * @ORM\Column(name="products_ordered", type="integer", nullable=false)
  289. */
  290. private $ordered = '0';
  292. /**
  293. * @var string
  294. *
  295. * @ORM\Column(name="products_price1", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  296. */
  297. private $price1 = '0.0000';
  299. /**
  300. * @var string
  301. *
  302. * @ORM\Column(name="products_price2", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  303. */
  304. private $price2 = '0.0000';
  306. /**
  307. * @var string
  308. *
  309. * @ORM\Column(name="products_price3", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  310. */
  311. private $price3 = '0.0000';
  313. /**
  314. * @var string
  315. *
  316. * @ORM\Column(name="products_price4", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  317. */
  318. private $price4 = '0.0000';
  320. /**
  321. * @var string
  322. *
  323. * @ORM\Column(name="products_price5", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  324. */
  325. private $price5 = '0.0000';
  327. /**
  328. * @var string
  329. *
  330. * @ORM\Column(name="products_price6", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  331. */
  332. private $price6 = '0.0000';
  334. /**
  335. * @var string
  336. *
  337. * @ORM\Column(name="products_price7", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  338. */
  339. private $price7 = '0.0000';
  341. /**
  342. * @var string
  343. *
  344. * @ORM\Column(name="products_price8", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  345. */
  346. private $price8 = '0.0000';
  348. /**
  349. * @var string
  350. *
  351. * @ORM\Column(name="products_price9", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  352. */
  353. private $price9 = '0.0000';
  355. /**
  356. * @var string
  357. *
  358. * @ORM\Column(name="products_price10", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  359. */
  360. private $price10 = '0.0000';
  362. /**
  363. * @var string
  364. *
  365. * @ORM\Column(name="products_price11", type="decimal", precision=15, scale=4, nullable=false, options={"default"="0.0000"})
  366. */
  367. private $price11 = '0.0000';
  369. /**
  370. * @var int
  371. *
  372. * @ORM\Column(name="products_price1_qty", type="integer", nullable=false)
  373. */
  374. private $price1Qty = '0';
  376. /**
  377. * @var int
  378. *
  379. * @ORM\Column(name="products_price2_qty", type="integer", nullable=false)
  380. */
  381. private $price2Qty = '0';
  383. /**
  384. * @var int
  385. *
  386. * @ORM\Column(name="products_price3_qty", type="integer", nullable=false)
  387. */
  388. private $price3Qty = '0';
  390. /**
  391. * @var int
  392. *
  393. * @ORM\Column(name="products_price4_qty", type="integer", nullable=false)
  394. */
  395. private $price4Qty = '0';
  397. /**
  398. * @var int
  399. *
  400. * @ORM\Column(name="products_price5_qty", type="integer", nullable=false)
  401. */
  402. private $price5Qty = '0';
  404. /**
  405. * @var int
  406. *
  407. * @ORM\Column(name="products_price6_qty", type="integer", nullable=false)
  408. */
  409. private $price6Qty = '0';
  411. /**
  412. * @var int
  413. *
  414. * @ORM\Column(name="products_price7_qty", type="integer", nullable=false)
  415. */
  416. private $price7Qty = '0';
  418. /**
  419. * @var int
  420. *
  421. * @ORM\Column(name="products_price8_qty", type="integer", nullable=false)
  422. */
  423. private $price8Qty = '0';
  425. /**
  426. * @var int
  427. *
  428. * @ORM\Column(name="products_price9_qty", type="integer", nullable=false)
  429. */
  430. private $price9Qty = '0';
  432. /**
  433. * @var int
  434. *
  435. * @ORM\Column(name="products_price10_qty", type="integer", nullable=false)
  436. */
  437. private $price10Qty = '0';
  439. /**
  440. * @var int
  441. *
  442. * @ORM\Column(name="products_price11_qty", type="integer", nullable=false)
  443. */
  444. private $price11Qty = '0';
  446. /**
  447. * @var int
  448. *
  449. * @ORM\Column(name="products_qty_blocks", type="integer", nullable=false, options={"default"="1"})
  450. */
  451. private $productsQtyBlocks = '1';
  453. /**
  454. * @var bool
  455. *
  456. * @ORM\Column(name="products_soleil", type="integer", nullable=false)
  457. */
  458. private $soleil = '0';
  460. /**
  461. * @var int
  462. *
  463. * @ORM\Column(name="products_limite_panier", type="integer", nullable=false)
  464. */
  465. private $limitePanier = '0';
  467. /**
  468. * @var int|null
  469. *
  470. * @ORM\Column(name="products_page", type="integer", nullable=true)
  471. */
  472. private $page;
  474. /**
  475. * @var bool
  476. *
  477. * @ORM\Column(name="products_garantie", type="integer", nullable=false)
  478. */
  479. private $guaranty = '0';
  481. /**
  482. * @var int
  483. *
  484. * @ORM\Column(name="products_cat", type="integer", nullable=true)
  485. */
  486. private $defaultCategoryId = 0;
  487. private $defaultCategory;
  489. /**
  490. * @var int
  491. *
  492. * @ORM\Column(name="products_index", type="integer", nullable=false, options={"default"="1"})
  493. */
  494. private $index = '1';
  496. /**
  497. * @var int
  498. *
  499. * @ORM\Column(name="products_mvente", type="integer", nullable=false, options={"default"="1"})
  500. */
  501. private $mvente = '1';
  503. /**
  504. * @var int
  505. *
  506. * @ORM\Column(name="products_strategique", type="integer", nullable=false)
  507. */
  508. private $strategique = '0';
  510. /**
  511. * @var int
  512. *
  513. * @ORM\Column(name="products_reappro_non", type="integer", nullable=false)
  514. */
  515. private $reapproNon = '0';
  517. /**
  518. * @var int|null
  519. *
  520. * @ORM\Column(name="products_multiple", type="integer", nullable=true)
  521. */
  522. private $multiple = 1;
  524. /**
  525. * @var string|null
  526. *
  527. * @ORM\Column(name="products_origin", type="string", length=3, nullable=true)
  528. */
  529. private $origin = 1;
  531. /**
  532. * @var bool
  533. *
  534. * @ORM\Column(name="products_gift", type="boolean", nullable=true)
  535. */
  536. private $gift = '0';
  538. /**
  539. * @var ?string
  540. *
  541. * @ORM\Column(name="products_type", type="string", length=20, nullable=true)
  542. */
  543. private $type;
  545. /**
  546. * @var int
  547. *
  548. * @ORM\Column(name="products_welcome", type="boolean", nullable=false, options={"default"="1"})
  549. */
  550. private $welcome = '1';
  552. /**
  553. * @var string
  554. *
  555. * @ORM\Column(name="products_code", type="string", length=50, nullable=true)
  556. */
  557. private $code;
  559. /**
  560. * @var boolean
  561. *
  562. * @ORM\Column(name="is_default_variant", type="boolean", nullable=false, options={"default"="0"})
  563. */
  564. private $isDefaultVariant = false;
  566. public function __construct()
  567. {
  568. $this->children = new \Doctrine\Common\Collections\ArrayCollection();
  569. $this->prices = new \Doctrine\Common\Collections\ArrayCollection();
  570. $this->descriptions = new \Doctrine\Common\Collections\ArrayCollection();
  571. }
  573. public function getId() {
  574. return $this->id;
  575. }
  577. public function getChildren() {
  578. return $this->children;
  579. }
  581. public function getParent() {
  582. if(!empty($this->parent) && !empty($this->languageId)){
  583. $this->parent->setLanguageId($this->languageId);
  584. }
  585. return $this->parent;
  586. }
  588. public function getProductModel(): ?ProductModel {
  589. return $this->productModel;
  590. }
  592. public function getTopProductModel(): ?ProductModel {
  593. $tmp = $this->productModel;
  594. while(!empty($tmp)) {
  595. if($tmp->hasParent()) {
  596. $tmp = $tmp->getParent();
  597. }else{
  598. return $tmp;
  599. }
  600. }
  601. return $tmp;
  602. }
  604. public function hasProductModel() {
  605. return !empty($this->productModel);
  606. }
  608. public function getDescriptions() {
  609. return $this->descriptions;
  610. }
  612. public function getAttributes() {
  613. return $this->attributes;
  614. }
  616. public function getAttribute($key) {
  617. if (strpos($key, ',') !== false) {
  618. $codes = array_values(array_filter(array_map('trim', explode(',', $key))));
  619. return array_map(fn($code) => $this->getAttribute($code), $codes);
  620. }
  621. foreach($this->getAttributes() as $attr) {
  622. if($attr->getAttribute()->getCode() == $key)
  623. return $attr;
  624. }
  625. return null;
  626. }
  628. public function getAttributeValue($key) {
  629. $attr = $this->getAttribute($key);
  630. if (is_array($attr)) {
  631. return implode(' / ', array_map(fn($a) => $a ? $a->getDisplayedValue() : '', $attr));
  632. }
  633. return $attr ? $attr->getDisplayedValue() : null;
  634. }
  636. public function getQuantity() {
  637. return $this->quantity;
  638. }
  640. public function getModel() {
  641. return $this->model;
  642. }
  644. public function getModelSAP(): ?string {
  645. return $this->modelSAP;
  646. }
  648. public function getEan(): ?string {
  649. return $this->ean;
  650. }
  652. public function getName() {
  653. if(!empty($this->languageId)){
  654. $description = null;
  655. foreach($this->descriptions as $d){
  656. if($d->getLanguage()->getId()==$this->languageId){
  657. $description = $d;
  658. break;
  659. }
  660. }
  661. }
  662. if(empty($description) && count($this->descriptions)){
  663. $description = $this->descriptions[0];
  664. }
  665. return empty($description)?'':$description->getName();
  666. }
  668. public function getHeadingTitle() {
  669. if(!empty($this->languageId)){
  670. $description = null;
  671. foreach($this->descriptions as $d){
  672. if($d->getLanguage()->getId()==$this->languageId){
  673. $description = $d;
  674. break;
  675. }
  676. }
  677. }
  678. if(empty($description) && count($this->descriptions)){
  679. $description = $this->descriptions[0];
  680. }
  681. return empty($description)?'':$description->getHeadingTitle();
  682. }
  684. public function getDeclinaison() {
  685. $output = '';
  686. if($this->parent){
  687. $name = $this->getName();
  688. $output = substr($name, strlen($this->getParent()->getName())+2, strlen($name));
  689. }
  690. return $output;
  691. }
  693. public function getUrl() {
  694. if(!empty($this->languageId)){
  695. $description = null;
  696. foreach($this->descriptions as $d){
  697. if($d->getLanguage()->getId()==$this->languageId){
  698. $description = $d;
  699. break;
  700. }
  701. }
  702. }
  703. if(empty($description) && count($this->descriptions)){
  704. $description = $this->descriptions[0];
  705. }
  706. return empty($description)?'':$description->getUrl();
  707. }
  709. public function getDescription() {
  710. if(!empty($this->languageId)){
  711. $description = null;
  712. foreach($this->descriptions as $d){
  713. if($d->getLanguage()->getId()==$this->languageId){
  714. $description = $d;
  715. break;
  716. }
  717. }
  718. }
  719. if(empty($description) && count($this->descriptions)){
  720. $description = $this->descriptions[0];
  721. }
  722. return empty($description)?'':$description->getDescription();
  723. }
  725. public function getExtraFields() {
  726. return $this->extraFields;
  727. }
  729. public function getProductDescription($lang='fr') : ?ProductDescription {
  730. foreach($this->getDescriptions() as $desc){
  731. if($desc->getLanguage()->getCode() == $lang)
  732. return $desc;
  733. }
  734. return null;
  735. }
  737. public function getPicture() {
  738. return empty($this->pictures)?null:$this->pictures[0];
  739. }
  741. public function getPictures() {
  742. return $this->pictures;
  743. }
  745. public function getPicturesUrl() {
  746. $output = [];
  747. foreach($this->pictures as $picture){
  748. $output[] = $picture->getUrl();
  749. }
  750. return $output;
  751. }
  753. public function getImage($absolute=false) {
  754. if($absolute)
  755. return 'https://www.dogcat.com/professionnel/images/'.$this->image;
  756. return $this->image;
  757. }
  759. public function getImageMed($absolute=false) {
  760. if($absolute)
  761. return 'https://www.dogcat.com/professionnel/images/'.$this->imageMed;
  762. return $this->imageMed;
  763. }
  765. public function getImageLrg($absolute=false) {
  766. if($absolute)
  767. return 'https://www.dogcat.com/professionnel/images/'.$this->imageLrg;
  768. return $this->imageLrg;
  769. }
  771. public function getImageSm1() {
  772. return $this->imageSm1;
  773. }
  775. public function getImageXl1() {
  776. return $this->imageXl1;
  777. }
  779. public function getImageSm2() {
  780. return $this->imageSm2;
  781. }
  783. public function getImageXl2() {
  784. return $this->imageXl2;
  785. }
  787. public function getImageSm3() {
  788. return $this->imageSm3;
  789. }
  791. public function getImageXl3() {
  792. return $this->imageXl3;
  793. }
  795. public function getImageSm4() {
  796. return $this->imageSm4;
  797. }
  799. public function getImageXl4() {
  800. return $this->imageXl4;
  801. }
  803. public function getImageSm5() {
  804. return $this->imageSm5;
  805. }
  807. public function getImageXl5() {
  808. return $this->imageXl5;
  809. }
  811. public function getImageSm6() {
  812. return $this->imageSm6;
  813. }
  815. public function getImageXl6() {
  816. return $this->imageXl6;
  817. }
  819. public function getPrice($withEcotax = false, ?PriceGroup $priceGroup = null, $withVat = false) {
  820. $price = $this->price;
  821. $tax = 0;
  822. if($this->isGift()) {
  823. return 0;
  824. }
  825. if($priceGroup) {
  826. $price = $this->getPriceByGroup($priceGroup);
  827. }
  828. if($withVat) {
  829. $tax = Encoder::roundPrice($price*self::VAT_RATE);
  830. }
  831. if($withEcotax === true){
  832. return Encoder::roundPrice($price) + Encoder::roundPrice($this->getEcotax()) + $tax;
  833. }
  834. return Encoder::roundPrice($price) + $tax;
  835. }
  837. public function getPrices() {
  838. return $this->prices;
  839. }
  841. public function getPriceByGroup(PriceGroup $priceGroup) {
  843. foreach($this->prices as $price) {
  844. if($price->getGroup() == $priceGroup) {
  845. return $price->getPrice();
  846. }else{
  847. dump($price->getGroup());
  848. dump($priceGroup);
  849. }
  850. }
  851. // throw new \App\Exception\PriceGroupException();
  852. }
  854. public function hasPrice(PriceGroup $priceGroup) {
  855. if($this->hasChildren()) {
  856. foreach($this->getChildren() as $child) {
  857. if($child->hasPrice($priceGroup))
  858. return true;
  859. }
  860. }else{
  861. foreach($this->prices as $price) {
  862. if($price->getGroup() == $priceGroup)
  863. return true;
  864. }
  865. }
  866. return false;
  867. }
  869. public function getEcotax() {
  870. return $this->ecotax;
  871. }
  873. public function getFromProduct(?PriceGroup $priceGroup = null) {
  874. $tmp = null;
  875. $from = null;
  876. foreach($this->children as $product){
  877. if(!$product->isStopped() && $product->isActive()){
  878. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  879. continue;
  880. }
  881. if(is_null($tmp) || ($tmp>$product->getPrice(false, $priceGroup, false))){
  882. $tmp = $product->getPrice(false, $priceGroup, false);
  883. $from = $product;
  884. }
  885. }
  886. }
  887. return $from;
  888. }
  890. public function getFromPrice($withEcotax = true, ?PriceGroup $priceGroup = null, $withVat = false) {
  891. $tmp = null;
  892. foreach($this->children as $product){
  893. if(!$product->isStopped() && $product->isActive()){
  894. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  895. continue;
  896. }
  897. if(is_null($tmp) || ($tmp>$product->getPrice($withEcotax, $priceGroup, $withVat))){
  898. $tmp = $product->getPrice($withEcotax, $priceGroup, $withVat);
  899. }
  900. }
  901. }
  902. return is_null($tmp)?0:$tmp;
  903. }
  905. public function getSoleilPrice($withEcotax = true) {
  906. if($this->isNonSoleil()){
  907. return Encoder::roundPrice($this->price * 0.9)+($withEcotax?$this->getEcotax():0);
  908. }else if($this->isSoleil()){
  909. return Encoder::roundPrice($this->price * 0.75)+($withEcotax?$this->getEcotax():0);
  910. }
  911. return Encoder::roundPrice($this->price)+($withEcotax?$this->getEcotax():0);
  912. }
  914. public function getDateAdded() {
  915. return $this->dateAdded;
  916. }
  918. public function getLastModified() {
  919. return $this->lastModified;
  920. }
  922. public function getDateAvailable() {
  923. return $this->dateAvailable;
  924. }
  926. public function getWeight() {
  927. return $this->weight;
  928. }
  930. public function getStatus() {
  931. return $this->status;
  932. }
  934. public function getTaxClass() {
  935. return $this->taxClass;
  936. }
  938. public function getManufacturer() {
  939. return $this->manufacturer;
  940. }
  942. public function getOrdered() {
  943. return $this->ordered;
  944. }
  946. public function getPrice1() {
  947. return $this->price1;
  948. }
  950. public function getPrice2() {
  951. return $this->price2;
  952. }
  954. public function getPrice3() {
  955. return $this->price3;
  956. }
  958. public function getPrice4() {
  959. return $this->price4;
  960. }
  962. public function getPrice5() {
  963. return $this->price5;
  964. }
  966. public function getPrice6() {
  967. return $this->price6;
  968. }
  970. public function getPrice7() {
  971. return $this->price7;
  972. }
  974. public function getPrice8() {
  975. return $this->price8;
  976. }
  978. public function getPrice9() {
  979. return $this->price9;
  980. }
  982. public function getPrice10() {
  983. return $this->price10;
  984. }
  986. public function getPrice11() {
  987. return $this->price11;
  988. }
  990. public function getPrice1Qty() {
  991. return $this->price1Qty;
  992. }
  994. public function getPrice2Qty() {
  995. return $this->price2Qty;
  996. }
  998. public function getPrice3Qty() {
  999. return $this->price3Qty;
  1000. }
  1002. public function getPrice4Qty() {
  1003. return $this->price4Qty;
  1004. }
  1006. public function getPrice5Qty() {
  1007. return $this->price5Qty;
  1008. }
  1010. public function getPrice6Qty() {
  1011. return $this->price6Qty;
  1012. }
  1014. public function getPrice7Qty() {
  1015. return $this->price7Qty;
  1016. }
  1018. public function getPrice8Qty() {
  1019. return $this->price8Qty;
  1020. }
  1022. public function getPrice9Qty() {
  1023. return $this->price9Qty;
  1024. }
  1026. public function getPrice10Qty() {
  1027. return $this->price10Qty;
  1028. }
  1030. public function getPrice11Qty() {
  1031. return $this->price11Qty;
  1032. }
  1034. public function getProductsQtyBlocks() {
  1035. return $this->productsQtyBlocks;
  1036. }
  1038. public function getSoleil() {
  1039. return $this->soleil;
  1040. }
  1042. public function getLimitePanier() {
  1043. return $this->limitePanier;
  1044. }
  1046. public function getPage() {
  1047. return $this->page;
  1048. }
  1050. public function getGuaranty() {
  1051. return $this->guaranty;
  1052. }
  1054. public function getDefaultCategoryId() {
  1055. return $this->defaultCategoryId;
  1056. }
  1058. public function getDefaultCategory() {
  1059. return $this->defaultCategory;
  1060. }
  1062. public function getIndex() {
  1063. if(empty($this->index))
  1064. return 0;
  1065. return $this->index > 0 ? 1 : 0;
  1066. }
  1068. public function getMvente() {
  1069. return $this->mvente;
  1070. }
  1072. public function getStrategique() {
  1073. return $this->strategique;
  1074. }
  1076. public function getReapproNon() {
  1077. return $this->reapproNon;
  1078. }
  1080. public function getMultiple() {
  1081. return empty($this->multiple)?1:$this->multiple;
  1082. }
  1085. public function getOrigin() {
  1086. return $this->origin;
  1087. }
  1089. public function getReference() {
  1090. return $this->getModel();
  1091. }
  1093. public function getGift() {
  1094. return is_null($this->gift) ? 0 : $this->gift;
  1095. }
  1097. public function getType(): ?string {
  1098. return empty($this->type) ? self::TYPE_PRODUCT : $this->type;
  1099. }
  1101. public function getCountryRestrictions() {
  1102. return $this->countryRestrictions;
  1103. }
  1106. public function getRestrictedCountries() {
  1107. $output = [];
  1108. foreach($this->getCountryRestrictions() as $rc) {
  1109. $output[] = $rc->getCountry();
  1110. }
  1111. return $output;
  1112. }
  1114. public function getWelcome(): int {
  1115. return $this->welcome;
  1116. }
  1118. public function getCode(): ?string {
  1119. return $this->code;
  1120. }
  1122. public function getIsDefaultVariant() {
  1123. return $this->isDefaultVariant;
  1124. }
  1128. // public function getUrl($absolute=false) {
  1129. // if(!empty($this->parent))
  1130. // return $this->getParent()->getUrl($absolute);
  1131. // if(!empty($this->languageId)){
  1132. // $language = $this->languageId==4?'fr':'en';
  1133. // }
  1134. // if(empty($language)){
  1135. // $language = 'fr';
  1136. // }
  1137. //// $url = '/professionnel/product_info.php?products_id='.$this->getId().'&language='.$language;
  1138. //// if($absolute)
  1139. //// return 'https://www.dogcat.com'.$url;
  1140. // return $this->getUrl();
  1141. // }
  1143. public function setId($id) {
  1144. $this->id = $id;
  1145. }
  1147. public function setAttributes($attributes) {
  1148. $this->attributes = $attributes;
  1149. }
  1151. public function setChildren($children) {
  1152. $this->children = $children;
  1153. }
  1155. public function setProductModel(?ProductModel $productModel): void {
  1156. $this->productModel = $productModel;
  1157. }
  1159. public function setParent($parent) {
  1160. $this->parent = $parent;
  1161. }
  1163. public function setDescriptions($descriptions) {
  1164. $this->descriptions = $descriptions;
  1165. }
  1167. public function setExtraFields($extraFields): void {
  1168. $this->extraFields = $extraFields;
  1169. }
  1171. public function setQuantity($quantity) {
  1172. $this->quantity = $quantity;
  1173. }
  1175. public function setModel($model) {
  1176. $this->model = $model;
  1177. }
  1179. public function setModelSAP(?string $modelSAP): void {
  1180. $this->modelSAP = $modelSAP;
  1181. }
  1183. public function setEan(?string $ean): void {
  1184. $this->ean = $ean;
  1185. }
  1187. public function setImage($image) {
  1188. $this->image = $image;
  1189. }
  1191. public function setImageMed($imageMed) {
  1192. $this->imageMed = $imageMed;
  1193. }
  1195. public function setImageLrg($imageLrg) {
  1196. $this->imageLrg = $imageLrg;
  1197. }
  1199. public function setImageSm1($imageSm1) {
  1200. $this->imageSm1 = $imageSm1;
  1201. }
  1203. public function setImageXl1($imageXl1) {
  1204. $this->imageXl1 = $imageXl1;
  1205. }
  1207. public function setImageSm2($imageSm2) {
  1208. $this->imageSm2 = $imageSm2;
  1209. }
  1211. public function setImageXl2($imageXl2) {
  1212. $this->imageXl2 = $imageXl2;
  1213. }
  1215. public function setImageSm3($imageSm3) {
  1216. $this->imageSm3 = $imageSm3;
  1217. }
  1219. public function setImageXl3($imageXl3) {
  1220. $this->imageXl3 = $imageXl3;
  1221. }
  1223. public function setImageSm4($imageSm4) {
  1224. $this->imageSm4 = $imageSm4;
  1225. }
  1227. public function setImageXl4($imageXl4) {
  1228. $this->imageXl4 = $imageXl4;
  1229. }
  1231. public function setImageSm5($imageSm5) {
  1232. $this->imageSm5 = $imageSm5;
  1233. }
  1235. public function setImageXl5($imageXl5) {
  1236. $this->imageXl5 = $imageXl5;
  1237. }
  1239. public function setImageSm6($imageSm6) {
  1240. $this->imageSm6 = $imageSm6;
  1241. }
  1243. public function setImageXl6($imageXl6) {
  1244. $this->imageXl6 = $imageXl6;
  1245. }
  1247. public function setPrice($price) {
  1248. $this->price = $price;
  1249. }
  1251. public function setEcotax( $ecotax) {
  1252. $this->ecotax = $ecotax;
  1253. }
  1255. public function setDateAdded(\DateTime $dateAdded) {
  1256. $this->dateAdded = $dateAdded;
  1257. }
  1259. public function setLastModified(\DateTime $lastModified) {
  1260. $this->lastModified = $lastModified;
  1261. }
  1263. public function setDateAvailable(\DateTime $dateAvailable) {
  1264. $this->dateAvailable = $dateAvailable;
  1265. }
  1267. public function setWeight($weight) {
  1268. $this->weight = $weight;
  1269. }
  1271. public function setStatus($status) {
  1272. $this->status = $status;
  1273. }
  1275. public function setTaxClass($taxClass) {
  1276. $this->taxClass = $taxClass;
  1277. }
  1279. public function setManufacturer($manufacturer) {
  1280. $this->manufacturer = $manufacturer;
  1281. }
  1283. public function setOrdered($ordered) {
  1284. $this->ordered = $ordered;
  1285. }
  1287. public function setParentId($parentId) {
  1288. $this->parentId = $parentId;
  1289. }
  1291. public function setPrice1($price1) {
  1292. $this->price1 = $price1;
  1293. }
  1295. public function setPrice2($price2) {
  1296. $this->price2 = $price2;
  1297. }
  1299. public function setPrice3($price3) {
  1300. $this->price3 = $price3;
  1301. }
  1303. public function setPrice4($price4) {
  1304. $this->price4 = $price4;
  1305. }
  1307. public function setPrice5($price5) {
  1308. $this->price5 = $price5;
  1309. }
  1311. public function setPrice6($price6) {
  1312. $this->price6 = $price6;
  1313. }
  1315. public function setPrice7($price7) {
  1316. $this->price7 = $price7;
  1317. }
  1319. public function setPrice8($price8) {
  1320. $this->price8 = $price8;
  1321. }
  1323. public function setPrice9($price9) {
  1324. $this->price9 = $price9;
  1325. }
  1327. public function setPrice10($price10) {
  1328. $this->price10 = $price10;
  1329. }
  1331. public function setPrice11($price11) {
  1332. $this->price11 = $price11;
  1333. }
  1335. public function setPrice1Qty($price1Qty) {
  1336. $this->price1Qty = $price1Qty;
  1337. }
  1339. public function setPrice2Qty($price2Qty) {
  1340. $this->price2Qty = $price2Qty;
  1341. }
  1343. public function setPrice3Qty($price3Qty) {
  1344. $this->price3Qty = $price3Qty;
  1345. }
  1347. public function setPrice4Qty($price4Qty) {
  1348. $this->price4Qty = $price4Qty;
  1349. }
  1351. public function setPrice5Qty($price5Qty) {
  1352. $this->price5Qty = $price5Qty;
  1353. }
  1355. public function setPrice6Qty($price6Qty) {
  1356. $this->price6Qty = $price6Qty;
  1357. }
  1359. public function setPrice7Qty($price7Qty) {
  1360. $this->price7Qty = $price7Qty;
  1361. }
  1363. public function setPrice8Qty($price8Qty) {
  1364. $this->price8Qty = $price8Qty;
  1365. }
  1367. public function setPrice9Qty($price9Qty) {
  1368. $this->price9Qty = $price9Qty;
  1369. }
  1371. public function setPrice10Qty($price10Qty) {
  1372. $this->price10Qty = $price10Qty;
  1373. }
  1375. public function setPrice11Qty($price11Qty) {
  1376. $this->price11Qty = $price11Qty;
  1377. }
  1379. public function setProductsQtyBlocks($productsQtyBlocks) {
  1380. $this->productsQtyBlocks = $productsQtyBlocks;
  1381. }
  1383. public function setSoleil($soleil) {
  1384. $this->soleil = $soleil;
  1385. }
  1387. public function setLimitePanier($limitePanier) {
  1388. $this->limitePanier = $limitePanier;
  1389. }
  1391. public function setPage($page) {
  1392. $this->page = $page;
  1393. }
  1395. public function setGuaranty($guaranty) {
  1396. $this->guaranty = $guaranty;
  1397. }
  1399. public function setDefaultCategoryId($defaultCategoryId) {
  1400. $this->defaultCategoryId = $defaultCategoryId;
  1401. }
  1403. public function setIndex($index) {
  1404. $this->index = $index;
  1405. }
  1407. public function setMvente($mvente) {
  1408. $this->mvente = $mvente;
  1409. }
  1411. public function setStrategique($strategique) {
  1412. $this->strategique = $strategique;
  1413. }
  1415. public function setReapproNon($reapproNon) {
  1416. $this->reapproNon = $reapproNon;
  1417. }
  1419. public function setMultiple($multiple) {
  1420. return $this->multiple = $multiple;
  1421. }
  1423. public function setOrigin($origin) {
  1424. $this->origin = $origin;
  1425. }
  1427. public function setPrices($prices) {
  1428. $this->prices = $prices;
  1429. }
  1431. public function setGift($gift) {
  1432. $this->gift = $gift;
  1433. }
  1435. public function setType(?string $type): void {
  1436. $this->type = $type;
  1437. }
  1439. public function setCountryRestrictions($countryRestrictions): void {
  1440. $this->countryRestrictions = $countryRestrictions;
  1441. }
  1443. public function setWelcome(int $welcome): void {
  1444. $this->welcome = $welcome;
  1445. }
  1447. public function setCode(string $code): void {
  1448. $this->code = $code;
  1449. }
  1451. public function setIsDefaultVariant($isDefaultVariant): void {
  1452. $this->isDefaultVariant = $isDefaultVariant;
  1453. }
  1455. public function getCaracteristics() {
  1456. $output = [];
  1457. foreach($this->getAttributes() as $attr) {
  1458. if($attr->getAttribute()->getShowInCaracteristic())
  1459. $output[] = $attr;
  1460. }
  1461. return $output;
  1462. }
  1464. public function hasWelcomeDiscount() {
  1465. return !empty($this->welcome);
  1466. }
  1468. public function isMadeInFrance() {
  1469. if(!empty($this->origin))
  1470. return strtoupper($this->origin) == 'FR';
  1471. if($this->hasChildren()){
  1472. foreach($this->children as $child){
  1473. if(!$child->isMadeInFrance()){
  1474. return false;
  1475. }
  1476. }
  1477. return true;
  1478. }
  1479. return false;
  1480. }
  1482. public function isAvailable() {
  1483. return $this->quantity > 0;
  1484. }
  1486. public function isDefaultVariant() {
  1487. return !empty($this->isDefaultVariant);
  1488. }
  1490. public function hasRestrictionForCountry($country) {
  1491. if($country){
  1492. if($this->countryRestrictions){
  1493. foreach($this->getCountryRestrictions() as $restriction){
  1494. if($restriction->getCountry() == $country){
  1495. return true;
  1496. }
  1497. }
  1498. }
  1499. }
  1500. return false;
  1501. }
  1503. public function isAvailableForCountry($country) {
  1504. if($country && $this->countryRestrictions){
  1505. foreach($this->getCountryRestrictions() as $restriction) {
  1506. if($restriction->getCountry() == $country){
  1507. return false;
  1508. }
  1509. }
  1510. }
  1511. if($country && $this->getManufacturer()){
  1512. return $this->getManufacturer()->isAvailableForCountry($country);
  1513. }
  1514. return true;
  1515. }
  1517. public function isStopped() {
  1518. return $this->quantity == -800;
  1519. }
  1521. public function isActive() {
  1522. return $this->getStatus() == 1;
  1523. }
  1525. public function isGift() {
  1526. return $this->getGift() == 1;
  1527. }
  1529. public function isSoleil() {
  1530. return $this->soleil == 1;
  1531. }
  1533. public function isNonSoleil() {
  1534. return $this->soleil == 0;
  1535. }
  1537. public function isVivog() {
  1538. return $this->isSoleil() || $this->isNonSoleil();
  1539. }
  1541. public function isParent() {
  1542. return empty($this->parent);
  1543. }
  1545. public function isProduct() {
  1546. return $this->getType() == self::TYPE_PRODUCT;
  1547. }
  1549. public function hasChildren() {
  1550. return count($this->children)>0;
  1551. }
  1553. public function hasSoleilPrice() {
  1554. return $this->isSoleil() || $this->isNonSoleil();
  1555. }
  1557. public function hasParent() {
  1558. return !empty($this->parent);
  1559. }
  1561. public function hasSoleil() {
  1562. if($this->hasChildren()){
  1563. foreach($this->children as $child){
  1564. if($child->isSoleil()){
  1565. return true;
  1566. }
  1567. }
  1568. return false;
  1569. }
  1570. return $this->isSoleil();
  1571. }
  1573. public function hasNonSoleil() {
  1574. if($this->hasChildren()){
  1575. foreach($this->children as $child){
  1576. if($child->isNonSoleil()){
  1577. return true;
  1578. }
  1579. }
  1580. return false;
  1581. }
  1582. return $this->isNonSoleil();
  1583. }
  1585. public function addPrice(ProductPrice $productPrice): self
  1586. {
  1587. if (!$this->prices->contains($productPrice)) {
  1588. $this->prices->add($productPrice);
  1589. $productPrice->setProduct($this);
  1590. }
  1591. return $this;
  1592. }
  1594. public function removePrice(ProductPrice $productPrice): self
  1595. {
  1596. if ($this->prices->removeElement($productPrice)) {
  1597. if ($productPrice->getProduct() === $this) {
  1598. $productPrice->setProduct(null);
  1599. }
  1600. }
  1601. return $this;
  1602. }
  1604. public function toArray() : array{
  1605. $parent = $this->getParent();
  1606. $manufacturer = $this->getManufacturer();
  1607. $output = [
  1608. 'id' => $this->getId(),
  1609. 'model' => $this->getModel(),
  1610. 'name' => $this->getName(),
  1611. 'description' => $this->getDescription(),
  1612. 'quantity' => $this->getQuantity(),
  1613. 'image' => $this->getImage(),
  1614. 'price' => $this->getPrice(),
  1615. 'dateAdded' => $this->getDateAdded(),
  1616. 'lastModified' => $this->getLastModified(),
  1617. 'dateAvailable' => $this->getDateAvailable(),
  1618. 'weight' => $this->getWeight(),
  1619. 'status' => $this->getStatus()?1:0,
  1620. 'taxClass ' => $this->getTaxClass()?$this->getTaxClass()->toArray():0,
  1621. 'ordered' => $this->getOrdered(),
  1622. 'parent' => empty($parent)?null:$parent->toArray(),
  1623. 'manufacturer' => empty($manufacturer)?null:$manufacturer->toArray(),
  1624. 'productsQtyBlocks' => $this->getProductsQtyBlocks(),
  1625. 'soleil' => $this->getSoleil(),
  1626. 'nbChildren' => count($this->getChildren()),
  1627. 'limitePanier' => $this->getLimitePanier(),
  1628. 'page' => $this->getPage(),
  1629. 'garantie' => $this->getGuaranty(),
  1630. 'defaultCategoryId' => $this->getDefaultCategoryId(),
  1631. 'index' => $this->getIndex(),
  1632. 'mvente' => $this->getMvente(),
  1633. 'strategique' => $this->getStrategique(),
  1634. 'reapproNon' => $this->getReapproNon(),
  1635. 'multiple' => $this->getMultiple(),
  1636. ];
  1637. return $output;
  1638. }
  1640. public function toJson() {
  1641. return json_encode($this->toArray());
  1642. }
  1644. /**
  1645. * @todo Remove once 0 values in the table are converted to NULL.
  1646. */
  1647. public function loadDescriptions(\Doctrine\ORM\EntityManager $em)
  1648. {
  1649. $conn = $em->getConnection();
  1650. $sql = $conn->prepare('select * from products_description where products_id = '.$this->getId());
  1651. $sql->execute();
  1652. $rows = $sql->fetchAll();
  1653. $descriptions = [];
  1654. foreach($rows as $desc){
  1655. $description = new ProductDescription();
  1656. $description->setName($desc['products_name']);
  1657. $description->setDescription($desc['products_description']);
  1658. $description->setLanguage($em->getRepository('App:Language')->find($desc['language_id']==1?1:4));
  1659. $descriptions[] = $description;
  1660. }
  1661. $this->setDescriptions($descriptions);
  1662. }
  1664. public static function getSearchIndex($lang = 'fr')
  1665. {
  1666. return self::SEARCH_INDICES[$lang];
  1667. }
  1669. /**
  1670. * @ORM\PrePersist
  1671. */
  1672. public function prePersit(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  1673. $this->setDateAdded(new \DateTime);
  1674. }
  1676. /**
  1677. * @ORM\PrePersist
  1678. * @ORM\PreUpdate
  1679. */
  1680. public function preUpdate(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  1681. if(is_null($this->weight))
  1682. $this->setWeight(0);
  1683. }
  1685. }