src/Entity/Product.php line 695

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. if($this->attributes) {
  622. foreach($this->getAttributes() as $attr) {
  623. if($attr->getAttribute()->getCode() == $key)
  624. return $attr;
  625. }
  626. }
  627. return null;
  628. }
  630. public function getAttributeValue($key) {
  631. $attr = $this->getAttribute($key);
  632. if (is_array($attr)) {
  633. return implode(' / ', array_map(fn($a) => $a ? $a->getDisplayedValue() : '', $attr));
  634. }
  635. return $attr ? $attr->getDisplayedValue() : null;
  636. }
  638. public function getQuantity() {
  639. return $this->quantity;
  640. }
  642. public function getModel() {
  643. return $this->model;
  644. }
  646. public function getModelSAP(): ?string {
  647. return $this->modelSAP;
  648. }
  650. public function getEan(): ?string {
  651. return $this->ean;
  652. }
  654. public function getName() {
  655. if(!empty($this->languageId)){
  656. $description = null;
  657. foreach($this->descriptions as $d){
  658. if($d->getLanguage()->getId()==$this->languageId){
  659. $description = $d;
  660. break;
  661. }
  662. }
  663. }
  664. if(empty($description) && count($this->descriptions)){
  665. $description = $this->descriptions[0];
  666. }
  667. return empty($description)?'':$description->getName();
  668. }
  670. public function getHeadingTitle() {
  671. if(!empty($this->languageId)){
  672. $description = null;
  673. foreach($this->descriptions as $d){
  674. if($d->getLanguage()->getId()==$this->languageId){
  675. $description = $d;
  676. break;
  677. }
  678. }
  679. }
  680. if(empty($description) && count($this->descriptions)){
  681. $description = $this->descriptions[0];
  682. }
  683. return empty($description)?'':$description->getHeadingTitle();
  684. }
  686. public function getDeclinaison() {
  687. $output = '';
  688. if($this->parent){
  689. $name = $this->getName();
  690. $output = substr($name, strlen($this->getParent()->getName())+2, strlen($name));
  691. }
  692. return $output;
  693. }
  695. public function getUrl() {
  696. if(!empty($this->languageId)){
  697. $description = null;
  698. foreach($this->descriptions as $d){
  699. if($d->getLanguage()->getId()==$this->languageId){
  700. $description = $d;
  701. break;
  702. }
  703. }
  704. }
  705. if(empty($description) && count($this->descriptions)){
  706. $description = $this->descriptions[0];
  707. }
  708. return empty($description)?'':$description->getUrl();
  709. }
  711. public function getDescription() {
  712. if(!empty($this->languageId)){
  713. $description = null;
  714. foreach($this->descriptions as $d){
  715. if($d->getLanguage()->getId()==$this->languageId){
  716. $description = $d;
  717. break;
  718. }
  719. }
  720. }
  721. if(empty($description) && count($this->descriptions)){
  722. $description = $this->descriptions[0];
  723. }
  724. return empty($description)?'':$description->getDescription();
  725. }
  727. public function getExtraFields() {
  728. return $this->extraFields;
  729. }
  731. public function getProductDescription($lang='fr') : ?ProductDescription {
  732. foreach($this->getDescriptions() as $desc){
  733. if($desc->getLanguage()->getCode() == $lang)
  734. return $desc;
  735. }
  736. return null;
  737. }
  739. public function getPicture() {
  740. return empty($this->pictures)?null:$this->pictures[0];
  741. }
  743. public function getPictures() {
  744. return $this->pictures;
  745. }
  747. public function getPicturesUrl() {
  748. $output = [];
  749. foreach($this->pictures as $picture){
  750. $output[] = $picture->getUrl();
  751. }
  752. return $output;
  753. }
  755. public function getImage($absolute=false) {
  756. if($absolute)
  757. return 'https://www.dogcat.com/professionnel/images/'.$this->image;
  758. return $this->image;
  759. }
  761. public function getImageMed($absolute=false) {
  762. if($absolute)
  763. return 'https://www.dogcat.com/professionnel/images/'.$this->imageMed;
  764. return $this->imageMed;
  765. }
  767. public function getImageLrg($absolute=false) {
  768. if($absolute)
  769. return 'https://www.dogcat.com/professionnel/images/'.$this->imageLrg;
  770. return $this->imageLrg;
  771. }
  773. public function getImageSm1() {
  774. return $this->imageSm1;
  775. }
  777. public function getImageXl1() {
  778. return $this->imageXl1;
  779. }
  781. public function getImageSm2() {
  782. return $this->imageSm2;
  783. }
  785. public function getImageXl2() {
  786. return $this->imageXl2;
  787. }
  789. public function getImageSm3() {
  790. return $this->imageSm3;
  791. }
  793. public function getImageXl3() {
  794. return $this->imageXl3;
  795. }
  797. public function getImageSm4() {
  798. return $this->imageSm4;
  799. }
  801. public function getImageXl4() {
  802. return $this->imageXl4;
  803. }
  805. public function getImageSm5() {
  806. return $this->imageSm5;
  807. }
  809. public function getImageXl5() {
  810. return $this->imageXl5;
  811. }
  813. public function getImageSm6() {
  814. return $this->imageSm6;
  815. }
  817. public function getImageXl6() {
  818. return $this->imageXl6;
  819. }
  821. public function getPrice($withEcotax = false, ?PriceGroup $priceGroup = null, $withVat = false) {
  822. $price = $this->price;
  823. $tax = 0;
  824. if($this->isGift()) {
  825. return 0;
  826. }
  827. if($priceGroup) {
  828. $price = $this->getPriceByGroup($priceGroup);
  829. }
  830. if($withVat) {
  831. $tax = Encoder::roundPrice($price*self::VAT_RATE);
  832. }
  833. if($withEcotax === true){
  834. return Encoder::roundPrice($price) + Encoder::roundPrice($this->getEcotax()) + $tax;
  835. }
  836. return Encoder::roundPrice($price) + $tax;
  837. }
  839. public function getPrices() {
  840. return $this->prices;
  841. }
  843. public function getPriceByGroup(PriceGroup $priceGroup) {
  845. foreach($this->prices as $price) {
  846. if($price->getGroup() == $priceGroup) {
  847. return $price->getPrice();
  848. }else{
  849. dump($price->getGroup());
  850. dump($priceGroup);
  851. }
  852. }
  853. // throw new \App\Exception\PriceGroupException();
  854. }
  856. public function hasPrice(PriceGroup $priceGroup) {
  857. if($this->hasChildren()) {
  858. foreach($this->getChildren() as $child) {
  859. if($child->hasPrice($priceGroup))
  860. return true;
  861. }
  862. }else{
  863. foreach($this->prices as $price) {
  864. if($price->getGroup() == $priceGroup)
  865. return true;
  866. }
  867. }
  868. return false;
  869. }
  871. public function getEcotax() {
  872. return $this->ecotax;
  873. }
  875. public function getFromProduct(?PriceGroup $priceGroup = null) {
  876. $tmp = null;
  877. $from = null;
  878. foreach($this->children as $product){
  879. if(!$product->isStopped() && $product->isActive()){
  880. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  881. continue;
  882. }
  883. if(is_null($tmp) || ($tmp>$product->getPrice(false, $priceGroup, false))){
  884. $tmp = $product->getPrice(false, $priceGroup, false);
  885. $from = $product;
  886. }
  887. }
  888. }
  889. return $from;
  890. }
  892. public function getFromPrice($withEcotax = true, ?PriceGroup $priceGroup = null, $withVat = false) {
  893. $tmp = null;
  894. foreach($this->children as $product){
  895. if(!$product->isStopped() && $product->isActive()){
  896. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  897. continue;
  898. }
  899. if(is_null($tmp) || ($tmp>$product->getPrice($withEcotax, $priceGroup, $withVat))){
  900. $tmp = $product->getPrice($withEcotax, $priceGroup, $withVat);
  901. }
  902. }
  903. }
  904. return is_null($tmp)?0:$tmp;
  905. }
  907. public function getSoleilPrice($withEcotax = true) {
  908. if($this->isNonSoleil()){
  909. return Encoder::roundPrice($this->price * 0.9)+($withEcotax?$this->getEcotax():0);
  910. }else if($this->isSoleil()){
  911. return Encoder::roundPrice($this->price * 0.75)+($withEcotax?$this->getEcotax():0);
  912. }
  913. return Encoder::roundPrice($this->price)+($withEcotax?$this->getEcotax():0);
  914. }
  916. public function getDateAdded() {
  917. return $this->dateAdded;
  918. }
  920. public function getLastModified() {
  921. return $this->lastModified;
  922. }
  924. public function getDateAvailable() {
  925. return $this->dateAvailable;
  926. }
  928. public function getWeight() {
  929. return $this->weight;
  930. }
  932. public function getStatus() {
  933. return $this->status;
  934. }
  936. public function getTaxClass() {
  937. return $this->taxClass;
  938. }
  940. public function getManufacturer() {
  941. return $this->manufacturer;
  942. }
  944. public function getOrdered() {
  945. return $this->ordered;
  946. }
  948. public function getPrice1() {
  949. return $this->price1;
  950. }
  952. public function getPrice2() {
  953. return $this->price2;
  954. }
  956. public function getPrice3() {
  957. return $this->price3;
  958. }
  960. public function getPrice4() {
  961. return $this->price4;
  962. }
  964. public function getPrice5() {
  965. return $this->price5;
  966. }
  968. public function getPrice6() {
  969. return $this->price6;
  970. }
  972. public function getPrice7() {
  973. return $this->price7;
  974. }
  976. public function getPrice8() {
  977. return $this->price8;
  978. }
  980. public function getPrice9() {
  981. return $this->price9;
  982. }
  984. public function getPrice10() {
  985. return $this->price10;
  986. }
  988. public function getPrice11() {
  989. return $this->price11;
  990. }
  992. public function getPrice1Qty() {
  993. return $this->price1Qty;
  994. }
  996. public function getPrice2Qty() {
  997. return $this->price2Qty;
  998. }
  1000. public function getPrice3Qty() {
  1001. return $this->price3Qty;
  1002. }
  1004. public function getPrice4Qty() {
  1005. return $this->price4Qty;
  1006. }
  1008. public function getPrice5Qty() {
  1009. return $this->price5Qty;
  1010. }
  1012. public function getPrice6Qty() {
  1013. return $this->price6Qty;
  1014. }
  1016. public function getPrice7Qty() {
  1017. return $this->price7Qty;
  1018. }
  1020. public function getPrice8Qty() {
  1021. return $this->price8Qty;
  1022. }
  1024. public function getPrice9Qty() {
  1025. return $this->price9Qty;
  1026. }
  1028. public function getPrice10Qty() {
  1029. return $this->price10Qty;
  1030. }
  1032. public function getPrice11Qty() {
  1033. return $this->price11Qty;
  1034. }
  1036. public function getProductsQtyBlocks() {
  1037. return $this->productsQtyBlocks;
  1038. }
  1040. public function getSoleil() {
  1041. return $this->soleil;
  1042. }
  1044. public function getLimitePanier() {
  1045. return $this->limitePanier;
  1046. }
  1048. public function getPage() {
  1049. return $this->page;
  1050. }
  1052. public function getGuaranty() {
  1053. return $this->guaranty;
  1054. }
  1056. public function getDefaultCategoryId() {
  1057. return $this->defaultCategoryId;
  1058. }
  1060. public function getDefaultCategory() {
  1061. return $this->defaultCategory;
  1062. }
  1064. public function getIndex() {
  1065. if(empty($this->index))
  1066. return 0;
  1067. return $this->index > 0 ? 1 : 0;
  1068. }
  1070. public function getMvente() {
  1071. return $this->mvente;
  1072. }
  1074. public function getStrategique() {
  1075. return $this->strategique;
  1076. }
  1078. public function getReapproNon() {
  1079. return $this->reapproNon;
  1080. }
  1082. public function getMultiple() {
  1083. return empty($this->multiple)?1:$this->multiple;
  1084. }
  1087. public function getOrigin() {
  1088. return $this->origin;
  1089. }
  1091. public function getReference() {
  1092. return $this->getModel();
  1093. }
  1095. public function getGift() {
  1096. return is_null($this->gift) ? 0 : $this->gift;
  1097. }
  1099. public function getType(): ?string {
  1100. return empty($this->type) ? self::TYPE_PRODUCT : $this->type;
  1101. }
  1103. public function getCountryRestrictions() {
  1104. return $this->countryRestrictions;
  1105. }
  1108. public function getRestrictedCountries() {
  1109. $output = [];
  1110. foreach($this->getCountryRestrictions() as $rc) {
  1111. $output[] = $rc->getCountry();
  1112. }
  1113. return $output;
  1114. }
  1116. public function getWelcome(): int {
  1117. return $this->welcome;
  1118. }
  1120. public function getCode(): ?string {
  1121. return $this->code;
  1122. }
  1124. public function getIsDefaultVariant() {
  1125. return $this->isDefaultVariant;
  1126. }
  1130. // public function getUrl($absolute=false) {
  1131. // if(!empty($this->parent))
  1132. // return $this->getParent()->getUrl($absolute);
  1133. // if(!empty($this->languageId)){
  1134. // $language = $this->languageId==4?'fr':'en';
  1135. // }
  1136. // if(empty($language)){
  1137. // $language = 'fr';
  1138. // }
  1139. //// $url = '/professionnel/product_info.php?products_id='.$this->getId().'&language='.$language;
  1140. //// if($absolute)
  1141. //// return 'https://www.dogcat.com'.$url;
  1142. // return $this->getUrl();
  1143. // }
  1145. public function setId($id) {
  1146. $this->id = $id;
  1147. }
  1149. public function setAttributes($attributes) {
  1150. $this->attributes = $attributes;
  1151. }
  1153. public function setChildren($children) {
  1154. $this->children = $children;
  1155. }
  1157. public function setProductModel(?ProductModel $productModel): void {
  1158. $this->productModel = $productModel;
  1159. }
  1161. public function setParent($parent) {
  1162. $this->parent = $parent;
  1163. }
  1165. public function setDescriptions($descriptions) {
  1166. $this->descriptions = $descriptions;
  1167. }
  1169. public function setExtraFields($extraFields): void {
  1170. $this->extraFields = $extraFields;
  1171. }
  1173. public function setQuantity($quantity) {
  1174. $this->quantity = $quantity;
  1175. }
  1177. public function setModel($model) {
  1178. $this->model = $model;
  1179. }
  1181. public function setModelSAP(?string $modelSAP): void {
  1182. $this->modelSAP = $modelSAP;
  1183. }
  1185. public function setEan(?string $ean): void {
  1186. $this->ean = $ean;
  1187. }
  1189. public function setImage($image) {
  1190. $this->image = $image;
  1191. }
  1193. public function setImageMed($imageMed) {
  1194. $this->imageMed = $imageMed;
  1195. }
  1197. public function setImageLrg($imageLrg) {
  1198. $this->imageLrg = $imageLrg;
  1199. }
  1201. public function setImageSm1($imageSm1) {
  1202. $this->imageSm1 = $imageSm1;
  1203. }
  1205. public function setImageXl1($imageXl1) {
  1206. $this->imageXl1 = $imageXl1;
  1207. }
  1209. public function setImageSm2($imageSm2) {
  1210. $this->imageSm2 = $imageSm2;
  1211. }
  1213. public function setImageXl2($imageXl2) {
  1214. $this->imageXl2 = $imageXl2;
  1215. }
  1217. public function setImageSm3($imageSm3) {
  1218. $this->imageSm3 = $imageSm3;
  1219. }
  1221. public function setImageXl3($imageXl3) {
  1222. $this->imageXl3 = $imageXl3;
  1223. }
  1225. public function setImageSm4($imageSm4) {
  1226. $this->imageSm4 = $imageSm4;
  1227. }
  1229. public function setImageXl4($imageXl4) {
  1230. $this->imageXl4 = $imageXl4;
  1231. }
  1233. public function setImageSm5($imageSm5) {
  1234. $this->imageSm5 = $imageSm5;
  1235. }
  1237. public function setImageXl5($imageXl5) {
  1238. $this->imageXl5 = $imageXl5;
  1239. }
  1241. public function setImageSm6($imageSm6) {
  1242. $this->imageSm6 = $imageSm6;
  1243. }
  1245. public function setImageXl6($imageXl6) {
  1246. $this->imageXl6 = $imageXl6;
  1247. }
  1249. public function setPrice($price) {
  1250. $this->price = $price;
  1251. }
  1253. public function setEcotax( $ecotax) {
  1254. $this->ecotax = $ecotax;
  1255. }
  1257. public function setDateAdded(\DateTime $dateAdded) {
  1258. $this->dateAdded = $dateAdded;
  1259. }
  1261. public function setLastModified(\DateTime $lastModified) {
  1262. $this->lastModified = $lastModified;
  1263. }
  1265. public function setDateAvailable(\DateTime $dateAvailable) {
  1266. $this->dateAvailable = $dateAvailable;
  1267. }
  1269. public function setWeight($weight) {
  1270. $this->weight = $weight;
  1271. }
  1273. public function setStatus($status) {
  1274. $this->status = $status;
  1275. }
  1277. public function setTaxClass($taxClass) {
  1278. $this->taxClass = $taxClass;
  1279. }
  1281. public function setManufacturer($manufacturer) {
  1282. $this->manufacturer = $manufacturer;
  1283. }
  1285. public function setOrdered($ordered) {
  1286. $this->ordered = $ordered;
  1287. }
  1289. public function setParentId($parentId) {
  1290. $this->parentId = $parentId;
  1291. }
  1293. public function setPrice1($price1) {
  1294. $this->price1 = $price1;
  1295. }
  1297. public function setPrice2($price2) {
  1298. $this->price2 = $price2;
  1299. }
  1301. public function setPrice3($price3) {
  1302. $this->price3 = $price3;
  1303. }
  1305. public function setPrice4($price4) {
  1306. $this->price4 = $price4;
  1307. }
  1309. public function setPrice5($price5) {
  1310. $this->price5 = $price5;
  1311. }
  1313. public function setPrice6($price6) {
  1314. $this->price6 = $price6;
  1315. }
  1317. public function setPrice7($price7) {
  1318. $this->price7 = $price7;
  1319. }
  1321. public function setPrice8($price8) {
  1322. $this->price8 = $price8;
  1323. }
  1325. public function setPrice9($price9) {
  1326. $this->price9 = $price9;
  1327. }
  1329. public function setPrice10($price10) {
  1330. $this->price10 = $price10;
  1331. }
  1333. public function setPrice11($price11) {
  1334. $this->price11 = $price11;
  1335. }
  1337. public function setPrice1Qty($price1Qty) {
  1338. $this->price1Qty = $price1Qty;
  1339. }
  1341. public function setPrice2Qty($price2Qty) {
  1342. $this->price2Qty = $price2Qty;
  1343. }
  1345. public function setPrice3Qty($price3Qty) {
  1346. $this->price3Qty = $price3Qty;
  1347. }
  1349. public function setPrice4Qty($price4Qty) {
  1350. $this->price4Qty = $price4Qty;
  1351. }
  1353. public function setPrice5Qty($price5Qty) {
  1354. $this->price5Qty = $price5Qty;
  1355. }
  1357. public function setPrice6Qty($price6Qty) {
  1358. $this->price6Qty = $price6Qty;
  1359. }
  1361. public function setPrice7Qty($price7Qty) {
  1362. $this->price7Qty = $price7Qty;
  1363. }
  1365. public function setPrice8Qty($price8Qty) {
  1366. $this->price8Qty = $price8Qty;
  1367. }
  1369. public function setPrice9Qty($price9Qty) {
  1370. $this->price9Qty = $price9Qty;
  1371. }
  1373. public function setPrice10Qty($price10Qty) {
  1374. $this->price10Qty = $price10Qty;
  1375. }
  1377. public function setPrice11Qty($price11Qty) {
  1378. $this->price11Qty = $price11Qty;
  1379. }
  1381. public function setProductsQtyBlocks($productsQtyBlocks) {
  1382. $this->productsQtyBlocks = $productsQtyBlocks;
  1383. }
  1385. public function setSoleil($soleil) {
  1386. $this->soleil = $soleil;
  1387. }
  1389. public function setLimitePanier($limitePanier) {
  1390. $this->limitePanier = $limitePanier;
  1391. }
  1393. public function setPage($page) {
  1394. $this->page = $page;
  1395. }
  1397. public function setGuaranty($guaranty) {
  1398. $this->guaranty = $guaranty;
  1399. }
  1401. public function setDefaultCategoryId($defaultCategoryId) {
  1402. $this->defaultCategoryId = $defaultCategoryId;
  1403. }
  1405. public function setIndex($index) {
  1406. $this->index = $index;
  1407. }
  1409. public function setMvente($mvente) {
  1410. $this->mvente = $mvente;
  1411. }
  1413. public function setStrategique($strategique) {
  1414. $this->strategique = $strategique;
  1415. }
  1417. public function setReapproNon($reapproNon) {
  1418. $this->reapproNon = $reapproNon;
  1419. }
  1421. public function setMultiple($multiple) {
  1422. return $this->multiple = $multiple;
  1423. }
  1425. public function setOrigin($origin) {
  1426. $this->origin = $origin;
  1427. }
  1429. public function setPrices($prices) {
  1430. $this->prices = $prices;
  1431. }
  1433. public function setGift($gift) {
  1434. $this->gift = $gift;
  1435. }
  1437. public function setType(?string $type): void {
  1438. $this->type = $type;
  1439. }
  1441. public function setCountryRestrictions($countryRestrictions): void {
  1442. $this->countryRestrictions = $countryRestrictions;
  1443. }
  1445. public function setWelcome(int $welcome): void {
  1446. $this->welcome = $welcome;
  1447. }
  1449. public function setCode(string $code): void {
  1450. $this->code = $code;
  1451. }
  1453. public function setIsDefaultVariant($isDefaultVariant): void {
  1454. $this->isDefaultVariant = $isDefaultVariant;
  1455. }
  1457. public function getCaracteristics() {
  1458. $output = [];
  1459. foreach($this->getAttributes() as $attr) {
  1460. if($attr->getAttribute()->getShowInCaracteristic())
  1461. $output[] = $attr;
  1462. }
  1463. return $output;
  1464. }
  1466. public function hasWelcomeDiscount() {
  1467. return !empty($this->welcome);
  1468. }
  1470. public function isMadeInFrance() {
  1471. if(!empty($this->origin))
  1472. return strtoupper($this->origin) == 'FR';
  1473. if($this->hasChildren()){
  1474. foreach($this->children as $child){
  1475. if(!$child->isMadeInFrance()){
  1476. return false;
  1477. }
  1478. }
  1479. return true;
  1480. }
  1481. return false;
  1482. }
  1484. public function isAvailable() {
  1485. return $this->quantity > 0;
  1486. }
  1488. public function isDefaultVariant() {
  1489. return !empty($this->isDefaultVariant);
  1490. }
  1492. public function hasRestrictionForCountry($country) {
  1493. if($country){
  1494. if($this->countryRestrictions){
  1495. foreach($this->getCountryRestrictions() as $restriction){
  1496. if($restriction->getCountry() == $country){
  1497. return true;
  1498. }
  1499. }
  1500. }
  1501. }
  1502. return false;
  1503. }
  1505. public function isAvailableForCountry($country) {
  1506. if($country && $this->countryRestrictions){
  1507. foreach($this->getCountryRestrictions() as $restriction) {
  1508. if($restriction->getCountry() == $country){
  1509. return false;
  1510. }
  1511. }
  1512. }
  1513. if($country && $this->getManufacturer()){
  1514. return $this->getManufacturer()->isAvailableForCountry($country);
  1515. }
  1516. return true;
  1517. }
  1519. public function isStopped() {
  1520. return $this->quantity == -800;
  1521. }
  1523. public function isActive() {
  1524. return $this->getStatus() == 1;
  1525. }
  1527. public function isGift() {
  1528. return $this->getGift() == 1;
  1529. }
  1531. public function isSoleil() {
  1532. return $this->soleil == 1;
  1533. }
  1535. public function isNonSoleil() {
  1536. return $this->soleil == 0;
  1537. }
  1539. public function isVivog() {
  1540. return $this->isSoleil() || $this->isNonSoleil();
  1541. }
  1543. public function isParent() {
  1544. return empty($this->parent);
  1545. }
  1547. public function isProduct() {
  1548. return $this->getType() == self::TYPE_PRODUCT;
  1549. }
  1551. public function hasChildren() {
  1552. return count($this->children)>0;
  1553. }
  1555. public function hasSoleilPrice() {
  1556. return $this->isSoleil() || $this->isNonSoleil();
  1557. }
  1559. public function hasParent() {
  1560. return !empty($this->parent);
  1561. }
  1563. public function hasSoleil() {
  1564. if($this->hasChildren()){
  1565. foreach($this->children as $child){
  1566. if($child->isSoleil()){
  1567. return true;
  1568. }
  1569. }
  1570. return false;
  1571. }
  1572. return $this->isSoleil();
  1573. }
  1575. public function hasNonSoleil() {
  1576. if($this->hasChildren()){
  1577. foreach($this->children as $child){
  1578. if($child->isNonSoleil()){
  1579. return true;
  1580. }
  1581. }
  1582. return false;
  1583. }
  1584. return $this->isNonSoleil();
  1585. }
  1587. public function addPrice(ProductPrice $productPrice): self
  1588. {
  1589. if (!$this->prices->contains($productPrice)) {
  1590. $this->prices->add($productPrice);
  1591. $productPrice->setProduct($this);
  1592. }
  1593. return $this;
  1594. }
  1596. public function removePrice(ProductPrice $productPrice): self
  1597. {
  1598. if ($this->prices->removeElement($productPrice)) {
  1599. if ($productPrice->getProduct() === $this) {
  1600. $productPrice->setProduct(null);
  1601. }
  1602. }
  1603. return $this;
  1604. }
  1606. public function toArray() : array{
  1607. $parent = $this->getParent();
  1608. $manufacturer = $this->getManufacturer();
  1609. $output = [
  1610. 'id' => $this->getId(),
  1611. 'model' => $this->getModel(),
  1612. 'name' => $this->getName(),
  1613. 'description' => $this->getDescription(),
  1614. 'quantity' => $this->getQuantity(),
  1615. 'image' => $this->getImage(),
  1616. 'price' => $this->getPrice(),
  1617. 'dateAdded' => $this->getDateAdded(),
  1618. 'lastModified' => $this->getLastModified(),
  1619. 'dateAvailable' => $this->getDateAvailable(),
  1620. 'weight' => $this->getWeight(),
  1621. 'status' => $this->getStatus()?1:0,
  1622. 'taxClass ' => $this->getTaxClass()?$this->getTaxClass()->toArray():0,
  1623. 'ordered' => $this->getOrdered(),
  1624. 'parent' => empty($parent)?null:$parent->toArray(),
  1625. 'manufacturer' => empty($manufacturer)?null:$manufacturer->toArray(),
  1626. 'productsQtyBlocks' => $this->getProductsQtyBlocks(),
  1627. 'soleil' => $this->getSoleil(),
  1628. 'nbChildren' => count($this->getChildren()),
  1629. 'limitePanier' => $this->getLimitePanier(),
  1630. 'page' => $this->getPage(),
  1631. 'garantie' => $this->getGuaranty(),
  1632. 'defaultCategoryId' => $this->getDefaultCategoryId(),
  1633. 'index' => $this->getIndex(),
  1634. 'mvente' => $this->getMvente(),
  1635. 'strategique' => $this->getStrategique(),
  1636. 'reapproNon' => $this->getReapproNon(),
  1637. 'multiple' => $this->getMultiple(),
  1638. ];
  1639. return $output;
  1640. }
  1642. public function toJson() {
  1643. return json_encode($this->toArray());
  1644. }
  1646. /**
  1647. * @todo Remove once 0 values in the table are converted to NULL.
  1648. */
  1649. public function loadDescriptions(\Doctrine\ORM\EntityManager $em)
  1650. {
  1651. $conn = $em->getConnection();
  1652. $sql = $conn->prepare('select * from products_description where products_id = '.$this->getId());
  1653. $sql->execute();
  1654. $rows = $sql->fetchAll();
  1655. $descriptions = [];
  1656. foreach($rows as $desc){
  1657. $description = new ProductDescription();
  1658. $description->setName($desc['products_name']);
  1659. $description->setDescription($desc['products_description']);
  1660. $description->setLanguage($em->getRepository('App:Language')->find($desc['language_id']==1?1:4));
  1661. $descriptions[] = $description;
  1662. }
  1663. $this->setDescriptions($descriptions);
  1664. }
  1666. public static function getSearchIndex($lang = 'fr')
  1667. {
  1668. return self::SEARCH_INDICES[$lang];
  1669. }
  1671. /**
  1672. * @ORM\PrePersist
  1673. */
  1674. public function prePersit(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  1675. $this->setDateAdded(new \DateTime);
  1676. }
  1678. /**
  1679. * @ORM\PrePersist
  1680. * @ORM\PreUpdate
  1681. */
  1682. public function preUpdate(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  1683. if(is_null($this->weight))
  1684. $this->setWeight(0);
  1685. }
  1687. }