src/Entity/ProductModel.php line 17

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")
  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. public function __construct()
  112. {
  113. $this->children = new \Doctrine\Common\Collections\ArrayCollection();
  114. $this->descriptions = new \Doctrine\Common\Collections\ArrayCollection();
  115. }
  117. public function getId(): int {
  118. return $this->id;
  119. }
  121. public function getAttributes() {
  122. return $this->attributes;
  123. }
  125. public function getChildren() {
  126. return $this->children;
  127. }
  129. public function getParent() {
  130. return $this->parent;
  131. }
  133. public function getDescriptions() {
  134. return $this->descriptions;
  135. }
  137. public function getPictures() {
  138. return $this->pictures;
  139. }
  141. public function getManufacturer(): ? Manufacturer {
  142. return $this->manufacturer;
  143. }
  145. public function getCountryRestrictions() {
  146. return $this->countryRestrictions;
  147. }
  149. public function getCode(): ?string {
  150. return $this->code;
  151. }
  153. public function getDateAdded(): \DateTime {
  154. return $this->dateAdded;
  155. }
  157. public function getLastModified(): ?\DateTime {
  158. return $this->lastModified;
  159. }
  161. public function getStatus(): bool {
  162. return $this->status;
  163. }
  165. public function getVariant(): ?ProductModelVariant {
  166. return $this->variant;
  167. }
  169. public function setId(int $id): void {
  170. $this->id = $id;
  171. }
  173. public function setAttributes($attributes): void {
  174. $this->attributes = $attributes;
  175. }
  177. public function setChildren($children): void {
  178. $this->children = $children;
  179. }
  181. public function setParent($parent): void {
  182. $this->parent = $parent;
  183. }
  185. public function setDescriptions($descriptions): void {
  186. $this->descriptions = $descriptions;
  187. }
  189. public function setPictures($pictures): void {
  190. $this->pictures = $pictures;
  191. }
  193. public function setManufacturer(?Manufacturer $manufacturer): void {
  194. $this->manufacturer = $manufacturer;
  195. }
  197. public function setCountryRestrictions($countryRestrictions): void {
  198. $this->countryRestrictions = $countryRestrictions;
  199. }
  201. public function setCode(?string $code): void {
  202. $this->code = $code;
  203. }
  205. public function setDateAdded(\DateTime $dateAdded): void {
  206. $this->dateAdded = $dateAdded;
  207. }
  209. public function setLastModified(?\DateTime $lastModified): void {
  210. $this->lastModified = $lastModified;
  211. }
  213. public function setStatus(bool $status): void {
  214. $this->status = $status;
  215. }
  217. public function setVariant(?ProductModelVariant $variant): void {
  218. $this->variant = $variant;
  219. }
  221. public function hasParent() {
  222. return !empty($this->parent);
  223. }
  225. public function hasChildren() {
  226. return count($this->children) > 0;
  227. }
  229. public function toArray() : array{
  230. $parent = $this->getParent();
  231. $manufacturer = $this->getManufacturer();
  232. $output = [
  233. 'id' => $this->getId(),
  234. 'code' => $this->getCode(),
  235. 'name' => $this->getName(),
  236. 'description' => $this->getDescription(),
  237. 'quantity' => $this->getQuantity(),
  238. 'image' => $this->getImage(),
  239. 'price' => $this->getPrice(),
  240. 'dateAdded' => $this->getDateAdded(),
  241. 'lastModified' => $this->getLastModified(),
  242. 'dateAvailable' => $this->getDateAvailable(),
  243. 'weight' => $this->getWeight(),
  244. 'status' => $this->getStatus()?1:0,
  245. 'taxClass ' => $this->getTaxClass()?$this->getTaxClass()->toArray():0,
  246. 'ordered' => $this->getOrdered(),
  247. 'parent' => empty($parent)?null:$parent->toArray(),
  248. 'manufacturer' => empty($manufacturer)?null:$manufacturer->toArray(),
  249. 'productsQtyBlocks' => $this->getProductsQtyBlocks(),
  250. 'soleil' => $this->getSoleil(),
  251. 'nbChildren' => count($this->getChildren()),
  252. 'limitePanier' => $this->getLimitePanier(),
  253. 'page' => $this->getPage(),
  254. 'garantie' => $this->getGuaranty(),
  255. 'defaultCategoryId' => $this->getDefaultCategoryId(),
  256. 'index' => $this->getIndex(),
  257. 'mvente' => $this->getMvente(),
  258. 'strategique' => $this->getStrategique(),
  259. 'reapproNon' => $this->getReapproNon(),
  260. 'multiple' => $this->getMultiple()
  261. ];
  262. return $output;
  263. }
  265. /**
  266. * @todo Remove once 0 values in the table are converted to NULL.
  267. */
  268. public function loadDescriptions(\Doctrine\ORM\EntityManager $em)
  269. {
  270. $conn = $em->getConnection();
  271. $sql = $conn->prepare('select * from products_description where products_id = '.$this->getId());
  272. $sql->execute();
  273. $rows = $sql->fetchAll();
  274. $descriptions = [];
  275. foreach($rows as $desc){
  276. $description = new ProductModelDescription();
  277. $description->setName($desc['products_name']);
  278. $description->setDescription($desc['products_description']);
  279. $description->setLanguage($em->getRepository('App:Language')->find($desc['language_id']==1?1:4));
  280. $descriptions[] = $description;
  281. }
  282. $this->setDescriptions($descriptions);
  283. }
  285. public function getProductModelDescription($lang='fr') : ?ProductModelDescription {
  286. foreach($this->getDescriptions() as $desc){
  287. if($desc->getLanguage()->getCode() == $lang)
  288. return $desc;
  289. }
  290. return null;
  291. }
  293. public function getProducts() {
  294. return $this->products;
  295. }
  297. public function setProducts($products): void {
  298. $this->products = $products;
  299. }
  301. public function getDefaultProduct() : ?Product {
  302. foreach($this->getProducts() as $product) {
  303. if($product->isDefaultVariant())
  304. return $product;
  305. }
  306. return $this->getProducts()->first();
  307. }
  309. public function getAllProducts() {
  310. $products = [];
  311. if($this->hasChildren()) {
  312. foreach($this->getChildren() as $child) {
  313. $cProducts = $child->getAllProducts();
  314. if(!empty($cProducts)) {
  315. $products = array_merge ($products, $cProducts);
  316. }
  317. }
  318. }else{
  319. $products = $this->getProducts()->getValues();
  320. }
  321. return $products;
  322. }
  324. public function getAssets() {
  325. $output = [];
  326. foreach($this->getAllProducts() as $p) {
  327. foreach($p->getPictures() as $picture) {
  328. if(isset($output[$p->getModel()])) {
  329. $output[$p->getModel()][] = $picture;
  330. }else{
  331. $output[$p->getModel()] = [$picture];
  332. }
  333. }
  334. }
  335. return $output;
  336. }
  338. /**
  339. * @ORM\PrePersist
  340. */
  341. public function prePersit(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  342. $this->setDateAdded(new \DateTime);
  343. }
  345. public static function getSearchIndex($lang = 'fr')
  346. {
  347. return self::SEARCH_INDICES[$lang];
  348. }
  350. }