src/Entity/ProductModel.php line 415

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use App\Entity\ProductModelDescription;
  6. use Doctrine\ORM\Mapping as ORM;
  7. use Doctrine\Common\Persistence\Event\LifecycleEventArgs;
  8. use App\Helpers\Encoder;
  10. /**
  11. * Products
  12. *
  13. * @ORM\Table(name="products_models", indexes={@ORM\Index(name="IDX_PRODUCTS_MODELS_CODE", columns={"code"})})
  14. * @ORM\Entity(repositoryClass="App\Repository\ProductRepository")
  15. * @ORM\HasLifecycleCallbacks()
  16. */
  17. class ProductModel extends TranslatedEntity
  18. {
  20. public const VAT_RATE = 0.2;
  21. public const SEARCH_INDICES = [
  22. 'fr' => 'fr-models',
  23. 'en' => 'en-models',
  24. ];
  25. protected $tranlatedEntity = 'ProductModelDescription';
  27. /**
  28. * @var int
  29. *
  30. * @ORM\Column(name="id", type="integer", nullable=false)
  31. * @ORM\Id
  32. * @ORM\GeneratedValue(strategy="IDENTITY")
  33. */
  34. private $id;
  36. /**
  37. * @var string
  38. *
  39. * @ORM\Column(name="code", type="string", length=50, nullable=true)
  40. */
  41. private $code;
  43. /**
  44. * @ORM\OneToMany(targetEntity="App\Entity\ProductModelAttribute", mappedBy="productModel")
  45. */
  46. private $attributes;
  48. /**
  49. * @ORM\OneToMany(targetEntity="App\Entity\ProductModel", mappedBy="parent")
  50. */
  51. private $children = [];
  53. /**
  54. * @ORM\ManyToOne(targetEntity="App\Entity\ProductModel", inversedBy="children")
  55. * @ORM\JoinColumn(name="parent_id", referencedColumnName="id", nullable=true)
  56. */
  57. private $parent;
  59. /**
  60. * @ORM\OneToMany(targetEntity="App\Entity\ProductModelDescription", mappedBy="model")
  61. */
  62. private $descriptions = [];
  64. /**
  65. * @var App\Entity\Manufacturer|null
  66. *
  67. * @ORM\ManyToOne(targetEntity="App\Entity\Manufacturer")
  68. * @ORM\JoinColumn(name="manufacturers_id", referencedColumnName="manufacturers_id", nullable=true)
  69. */
  70. private $manufacturer;
  72. /**
  73. * @ORM\OneToMany(targetEntity="App\Entity\ProductModelCountryRestriction", mappedBy="model")
  74. */
  75. private $countryRestrictions;
  77. /**
  78. * @var \DateTime
  79. *
  80. * @ORM\Column(name="date_added", type="datetime", nullable=false)
  81. */
  82. private $dateAdded;
  84. /**
  85. * @var \DateTime|null
  86. *
  87. * @ORM\Column(name="last_modified", type="datetime", nullable=true)
  88. */
  89. private $lastModified;
  91. /**
  92. * @var bool
  93. *
  94. * @ORM\Column(name="status", type="boolean", nullable=false)
  95. */
  96. private $status = '0';
  98. /**
  99. * @ORM\OneToMany(targetEntity="App\Entity\Product", mappedBy="productModel")
  100. */
  101. private $products = [];
  103. /**
  104. * @var App\Entity\ProductModelVariant|null
  105. *
  106. * @ORM\ManyToOne(targetEntity="App\Entity\ProductModelVariant")
  107. * @ORM\JoinColumn(name="variant_id", referencedColumnName="id", nullable=true)
  108. */
  109. private $variant;
  111. /**
  112. * Axe de déclinaison (1 = axis1, 2 = axis2 du ProductModelVariant) sur lequel le modèle est
  113. * éclaté dans les listings catégorie : une vignette par valeur de cet axe.
  114. * Null = une seule vignette pour tout le modèle.
  115. *
  116. * @var int|null
  117. *
  118. * @ORM\Column(name="listing_axis", type="smallint", nullable=true)
  119. */
  120. private $listingAxis;
  122. /**
  123. * Déclinaison affichée à l'arrivée sur la fiche modèle (route product_model).
  124. * Null = repli sur le produit marqué is_default_variant, sinon le premier produit.
  125. *
  126. * @var Product|null
  127. *
  128. * @ORM\ManyToOne(targetEntity="App\Entity\Product")
  129. * @ORM\JoinColumn(name="default_product_id", referencedColumnName="products_id", nullable=true, onDelete="SET NULL")
  130. */
  131. private $defaultProduct;
  133. /**
  134. * Catégorie par défaut (première catégorie transmise par Akeneo)
  135. *
  136. * @var int|null
  137. *
  138. * @ORM\Column(name="products_cat", type="integer", nullable=true)
  139. */
  140. private $defaultCategoryId;
  142. public function __construct()
  143. {
  144. $this->children = new \Doctrine\Common\Collections\ArrayCollection();
  145. $this->descriptions = new \Doctrine\Common\Collections\ArrayCollection();
  146. }
  148. public function getId(): int {
  149. return $this->id;
  150. }
  152. public function getAttributes() {
  153. return $this->attributes;
  154. }
  156. public function getChildren() {
  157. return $this->children;
  158. }
  160. public function getParent() {
  161. return $this->parent;
  162. }
  164. public function getDescriptions() {
  165. return $this->descriptions;
  166. }
  168. public function getPictures() {
  169. return $this->pictures;
  170. }
  172. public function getManufacturer(): ? Manufacturer {
  173. return $this->manufacturer;
  174. }
  176. public function getCountryRestrictions() {
  177. return $this->countryRestrictions;
  178. }
  180. public function getCode(): ?string {
  181. return $this->code;
  182. }
  184. public function getDateAdded(): \DateTime {
  185. return $this->dateAdded;
  186. }
  188. public function getLastModified(): ?\DateTime {
  189. return $this->lastModified;
  190. }
  192. public function getStatus(): bool {
  193. return $this->status;
  194. }
  196. public function getVariant(): ?ProductModelVariant {
  197. return $this->variant;
  198. }
  200. public function setId(int $id): void {
  201. $this->id = $id;
  202. }
  204. public function setAttributes($attributes): void {
  205. $this->attributes = $attributes;
  206. }
  208. public function setChildren($children): void {
  209. $this->children = $children;
  210. }
  212. public function setParent($parent): void {
  213. $this->parent = $parent;
  214. }
  216. public function setDescriptions($descriptions): void {
  217. $this->descriptions = $descriptions;
  218. }
  220. public function setPictures($pictures): void {
  221. $this->pictures = $pictures;
  222. }
  224. public function setManufacturer(?Manufacturer $manufacturer): void {
  225. $this->manufacturer = $manufacturer;
  226. }
  228. public function setCountryRestrictions($countryRestrictions): void {
  229. $this->countryRestrictions = $countryRestrictions;
  230. }
  232. public function setCode(?string $code): void {
  233. $this->code = $code;
  234. }
  236. public function setDateAdded(\DateTime $dateAdded): void {
  237. $this->dateAdded = $dateAdded;
  238. }
  240. public function setLastModified(?\DateTime $lastModified): void {
  241. $this->lastModified = $lastModified;
  242. }
  244. public function setStatus(bool $status): void {
  245. $this->status = $status;
  246. }
  248. public function setVariant(?ProductModelVariant $variant): void {
  249. $this->variant = $variant;
  250. }
  252. public function getListingAxis(): ?int {
  253. return $this->listingAxis;
  254. }
  256. public function setListingAxis(?int $listingAxis): void {
  257. $this->listingAxis = $listingAxis;
  258. }
  260. public function getDefaultCategoryId(): ?int {
  261. return $this->defaultCategoryId;
  262. }
  264. public function setDefaultCategoryId(?int $defaultCategoryId): void {
  265. $this->defaultCategoryId = $defaultCategoryId;
  266. }
  268. /**
  269. * Codes des attributs de l'axe utilisé pour l'affichage en listing (plusieurs pour un axe
  270. * composite, ex. "taille,couleur"). Vide si aucun axe n'est configuré.
  271. */
  272. public function getListingAxisCodes(): array {
  273. if (!$this->listingAxis || !$this->variant) {
  274. return [];
  275. }
  276. $axis = $this->listingAxis === 2 ? $this->variant->getAxis2() : $this->variant->getAxis1();
  277. return array_values(array_filter(array_map('trim', explode(',', (string) $axis))));
  278. }
  280. public function hasParent() {
  281. return !empty($this->parent);
  282. }
  284. public function hasChildren() {
  285. return count($this->children) > 0;
  286. }
  288. public function toArray() : array{
  289. $parent = $this->getParent();
  290. $manufacturer = $this->getManufacturer();
  291. $output = [
  292. 'id' => $this->getId(),
  293. 'code' => $this->getCode(),
  294. 'name' => $this->getName(),
  295. 'description' => $this->getDescription(),
  296. 'quantity' => $this->getQuantity(),
  297. 'image' => $this->getImage(),
  298. 'price' => $this->getPrice(),
  299. 'dateAdded' => $this->getDateAdded(),
  300. 'lastModified' => $this->getLastModified(),
  301. 'dateAvailable' => $this->getDateAvailable(),
  302. 'weight' => $this->getWeight(),
  303. 'status' => $this->getStatus()?1:0,
  304. 'taxClass ' => $this->getTaxClass()?$this->getTaxClass()->toArray():0,
  305. 'ordered' => $this->getOrdered(),
  306. 'parent' => empty($parent)?null:$parent->toArray(),
  307. 'manufacturer' => empty($manufacturer)?null:$manufacturer->toArray(),
  308. 'productsQtyBlocks' => $this->getProductsQtyBlocks(),
  309. 'soleil' => $this->getSoleil(),
  310. 'nbChildren' => count($this->getChildren()),
  311. 'limitePanier' => $this->getLimitePanier(),
  312. 'page' => $this->getPage(),
  313. 'garantie' => $this->getGuaranty(),
  314. 'defaultCategoryId' => $this->getDefaultCategoryId(),
  315. 'index' => $this->getIndex(),
  316. 'mvente' => $this->getMvente(),
  317. 'strategique' => $this->getStrategique(),
  318. 'reapproNon' => $this->getReapproNon(),
  319. 'multiple' => $this->getMultiple()
  320. ];
  321. return $output;
  322. }
  324. /**
  325. * @todo Remove once 0 values in the table are converted to NULL.
  326. */
  327. public function loadDescriptions(\Doctrine\ORM\EntityManager $em)
  328. {
  329. $conn = $em->getConnection();
  330. $sql = $conn->prepare('select * from products_description where products_id = '.$this->getId());
  331. $sql->execute();
  332. $rows = $sql->fetchAll();
  333. $descriptions = [];
  334. foreach($rows as $desc){
  335. $description = new ProductModelDescription();
  336. $description->setName($desc['products_name']);
  337. $description->setDescription($desc['products_description']);
  338. $description->setLanguage($em->getRepository('App:Language')->find($desc['language_id']==1?1:4));
  339. $descriptions[] = $description;
  340. }
  341. $this->setDescriptions($descriptions);
  342. }
  344. public function getProductModelDescription($lang='fr') : ?ProductModelDescription {
  345. foreach($this->getDescriptions() as $desc){
  346. if($desc->getLanguage()->getCode() == $lang)
  347. return $desc;
  348. }
  349. return null;
  350. }
  352. public function getProducts() {
  353. return $this->products;
  354. }
  356. public function setProducts($products): void {
  357. $this->products = $products;
  358. }
  360. public function setDefaultProduct(?Product $defaultProduct): void {
  361. $this->defaultProduct = $defaultProduct;
  362. }
  364. /**
  365. * Produit par défaut saisi au backoffice, tel quel (sans repli)
  366. */
  367. public function getConfiguredDefaultProduct(): ?Product {
  368. return $this->defaultProduct;
  369. }
  371. public function getDefaultProduct() : ?Product {
  372. // le produit saisi n'est retenu que s'il fait toujours partie du modèle et reste actif
  373. if($this->defaultProduct && $this->defaultProduct->isActive() && in_array($this->defaultProduct, $this->getAllProducts(), true)) {
  374. return $this->defaultProduct;
  375. }
  376. foreach($this->getAllProducts() as $product) {
  377. if($product->isDefaultVariant())
  378. return $product;
  379. }
  380. return count($this->getAllProducts()) > 0 ? $this->getAllProducts()[0] : null;
  381. }
  383. public function getAllProducts() {
  384. $products = [];
  385. if($this->hasChildren()) {
  386. foreach($this->getChildren() as $child) {
  387. $cProducts = $child->getAllProducts();
  388. if(!empty($cProducts)) {
  389. $products = array_merge ($products, $cProducts);
  390. }
  391. }
  392. }else{
  393. $products = $this->getProducts()->getValues();
  394. }
  395. return $products;
  396. }
  398. /**
  399. * Première image du premier produit du modèle qui en possède une (sous-modèles compris)
  400. */
  401. public function getPicture(): ?PictureProduct {
  402. foreach($this->getAllProducts() as $product) {
  403. foreach($product->getPictures() as $picture) {
  404. return $picture;
  405. }
  406. }
  407. return null;
  408. }
  410. /**
  411. * Image d'une entrée de listing : celle du produit affiché, sinon celle du produit par défaut
  412. * s'il appartient à la même entrée (ex. même couleur), sinon celle d'un autre produit de
  413. * l'entrée, et en dernier recours celle du modèle.
  414. */
  415. public function getListingPicture(?Product $displayed = null): ?PictureProduct {
  416. if($displayed && $displayed->getPicture()) {
  417. return $displayed->getPicture();
  418. }
  419. $listingProducts = $this->getListingProducts($displayed);
  420. $default = $this->getDefaultProduct();
  421. if($default && in_array($default, $listingProducts, true) && $default->getPicture()) {
  422. return $default->getPicture();
  423. }
  424. foreach($listingProducts as $product) {
  425. if($product->getPicture()) {
  426. return $product->getPicture();
  427. }
  428. }
  429. return $this->getPicture();
  430. }
  432. public function getAssets() {
  433. $output = [];
  434. foreach($this->getAllProducts() as $p) {
  435. foreach($p->getPictures() as $picture) {
  436. if(isset($output[$p->getModel()])) {
  437. $output[$p->getModel()][] = $picture;
  438. }else{
  439. $output[$p->getModel()] = [$picture];
  440. }
  441. }
  442. }
  443. return $output;
  444. }
  446. /**
  447. * Description de la langue courante (cf. translate()), à défaut la première disponible
  448. */
  449. private function getCurrentDescription(): ?ProductModelDescription {
  450. if(!empty($this->languageId)){
  451. foreach($this->descriptions as $d){
  452. if($d->getLanguage()->getId()==$this->languageId){
  453. return $d;
  454. }
  455. }
  456. }
  457. return count($this->descriptions) ? $this->descriptions[0] : null;
  458. }
  460. public function getName() {
  461. $description = $this->getCurrentDescription();
  462. return empty($description)?'':$description->getName();
  463. }
  465. public function getUrl() {
  466. $description = $this->getCurrentDescription();
  467. return empty($description)?'':$description->getUrl();
  468. }
  470. /**
  471. * Produits du modèle listés avec $displayed : ceux qui partagent sa valeur sur l'axe de
  472. * listing (ex. même couleur). Tous les produits si aucun axe n'est configuré.
  473. */
  474. public function getListingProducts(?Product $displayed = null): array {
  475. $products = $this->getAllProducts();
  476. $key = $displayed ? $displayed->getListingAxisKey() : null;
  477. if(is_null($key)) {
  478. return $products;
  479. }
  480. return array_values(array_filter($products, fn(Product $p) => $p->getListingAxisKey() === $key));
  481. }
  483. /**
  484. * Prix le plus bas du modèle ; avec $displayed, limité aux produits de la même entrée de
  485. * listing (cf. getListingProducts()).
  486. */
  487. public function getFromPrice($withEcotax = true, ?PriceGroup $priceGroup = null, $withVat = false, ?Product $displayed = null) {
  488. $tmp = null;
  489. foreach($this->getListingProducts($displayed) as $product) {
  490. if(!$product->isStopped() && $product->isActive()){
  491. if(!empty($priceGroup) && !$product->hasPrice($priceGroup)) {
  492. continue;
  493. }
  494. if(is_null($tmp) || ($tmp>$product->getPrice($withEcotax, $priceGroup, $withVat))){
  495. $tmp = $product->getPrice($withEcotax, $priceGroup, $withVat);
  496. }
  497. }
  498. }
  499. return $tmp;
  500. }
  502. /**
  503. * @ORM\PrePersist
  504. */
  505. public function prePersit(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  506. $this->setDateAdded(new \DateTime);
  507. }
  509. public static function getSearchIndex($lang = 'fr')
  510. {
  511. return self::SEARCH_INDICES[$lang];
  512. }
  514. }