src/Entity/Product.php line 653

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