src/Entity/Category.php line 17

Open in your IDE?
  1. <?php
  3. namespace App\Entity;
  5. use Doctrine\ORM\Mapping as ORM;
  6. use Doctrine\Common\Persistence\Event\LifecycleEventArgs;
  7. use App\Entity\CategoryDescription;
  10. /**
  11. * Categories
  12. *
  13. * @ORM\Table(name="categories")
  14. * @ORM\Entity(repositoryClass="App\Repository\CategoryRepository")
  15. * @ORM\HasLifecycleCallbacks
  16. */
  17. class Category extends TranslatedEntity
  18. {
  20. protected $tranlatedEntity = 'CategoryDescription';
  21. public const SEARCH_INDICES = [
  22. 'fr' => 'fr-categories',
  23. 'en' => 'en-categories',
  24. ];
  25. public const DISCOUNT_UNIVERSE = 242;
  27. /**
  28. * @var int
  29. *
  30. * @ORM\Column(name="categories_id", type="integer", nullable=false)
  31. * @ORM\Id
  32. * @ORM\GeneratedValue(strategy="IDENTITY")
  33. */
  34. private $id;
  36. /**
  37. * @var string|null
  38. *
  39. * @ORM\Column(name="categories_image", type="string", length=64, nullable=true)
  40. */
  41. private $image;
  43. /**
  44. * @var \App\Entity\Category
  45. *
  46. * @ORM\ManyToOne(targetEntity="App\Entity\Category", inversedBy="children")
  47. * @ORM\JoinColumn(name="parent_id", referencedColumnName="categories_id", nullable=true)
  48. */
  49. private $parent;
  51. /**
  52. * @var array
  53. *
  54. * @ORM\OneToMany(targetEntity="App\Entity\Category", mappedBy="parent")
  55. * @ORM\OrderBy({"sortOrder" = "ASC"})
  56. */
  57. private $children;
  59. /**
  60. * @ORM\OneToMany(targetEntity="App\Entity\CategoryDescription", mappedBy="category", cascade={"persist"})
  61. */
  62. private $descriptions = [];
  64. /**
  65. * @ORM\OneToMany(targetEntity="App\Entity\CategoryToExtraField", mappedBy="category")
  66. */
  67. private $extraFields = [];
  69. /**
  70. * @ORM\OneToMany(targetEntity="App\Entity\PictureCategory", mappedBy="category")
  71. */
  72. private $pictures = [];
  74. /**
  75. * @var int
  76. *
  77. * @ORM\Column(name="sort_order", type="integer", nullable=false)
  78. */
  79. private $sortOrder = '0';
  81. /**
  82. * @var \DateTime|null
  83. *
  84. * @ORM\Column(name="date_added", type="datetime", nullable=true)
  85. */
  86. private $dateAdded;
  88. /**
  89. * @var \DateTime|null
  90. *
  91. * @ORM\Column(name="last_modified", type="datetime", nullable=true)
  92. */
  93. private $lastModified;
  95. /**
  96. * @var int|null
  97. *
  98. * @ORM\Column(name="categories_best", type="integer", nullable=true)
  99. */
  100. private $categoriesBest;
  102. /**
  103. * @var int
  104. *
  105. * @ORM\Column(name="categories_affichage", type="integer", nullable=false, options={"default"="1"})
  106. */
  107. private $affichage = '1';
  109. /**
  110. * @var int
  111. *
  112. * @ORM\Column(name="categories_sousmenu", type="integer", nullable=false, options={"default"="1"})
  113. */
  114. private $sousmenu = '1';
  116. /**
  117. * @var int
  118. *
  119. * @ORM\Column(name="categories_index", type="integer", nullable=false, options={"default"="1"})
  120. */
  121. private $index = '1';
  123. /**
  124. * @var int
  125. *
  126. * @ORM\Column(name="categories_hide_children", type="integer", nullable=false)
  127. */
  128. private $hideChildren = '0';
  130. /**
  131. * @var string
  132. *
  133. * @ORM\Column(name="categories_position", type="string", length=64, nullable=true)
  134. */
  135. private $position = '0';
  137. /**
  138. * @var ?boolean
  139. *
  140. * @ORM\Column(name="categories_menu_spacer", type="boolean", nullable=true)
  141. */
  142. private $menuSpacer = '0';
  144. /**
  145. * @var string
  146. *
  147. * @ORM\Column(name="categories_code", type="string", length=50, nullable=true)
  148. */
  149. private $code = '0';
  151. private $file;
  152. private $temp;
  153. private $currentPath;
  155. public function __construct() {
  156. $this->pictures = new \Doctrine\Common\Collections\ArrayCollection();
  157. }
  159. public function getId() {
  160. return $this->id;
  161. }
  163. public function getName() {
  164. if(!empty($this->languageId)){
  165. $description = null;
  166. foreach($this->descriptions as $d){
  167. if($d->getLanguage()->getId()==$this->languageId){
  168. $description = $d;
  169. break;
  170. }
  171. }
  172. }
  173. if(empty($description) && count($this->descriptions)){
  174. $description = $this->descriptions[0];
  175. }
  176. return empty($description)?'':$description->getName();
  177. }
  179. public function getUrl() {
  180. if(!empty($this->languageId)){
  181. $description = null;
  182. foreach($this->descriptions as $d){
  183. if($d->getLanguage()->getId()==$this->languageId){
  184. $description = $d;
  185. break;
  186. }
  187. }
  188. }
  189. if(empty($description) && count($this->descriptions)){
  190. $description = $this->descriptions[0];
  191. }
  192. return empty($description)?'':$description->getUrl();
  193. }
  195. public function getDescription() {
  196. if(!empty($this->languageId)){
  197. $description = null;
  198. foreach($this->descriptions as $d){
  199. if($d->getLanguage()->getId()==$this->languageId){
  200. $description = $d;
  201. break;
  202. }
  203. }
  204. }
  205. if(empty($description) && count($this->descriptions)){
  206. $description = $this->descriptions[0];
  207. }
  208. return empty($description)?'':$description->getDescription();
  209. }
  211. public function getDescriptions() {
  212. return $this->descriptions;
  213. }
  215. public function getExtraFields() {
  216. return $this->extraFields;
  217. }
  219. public function getImage() {
  220. return $this->image;
  221. }
  223. public function getParent(): ?\App\Entity\Category {
  224. return $this->parent;
  225. }
  227. public function getChildren() {
  228. return $this->children;
  229. }
  231. public function getSortOrder() {
  232. return $this->sortOrder;
  233. }
  235. public function getDateAdded(): ?\DateTime {
  236. return $this->dateAdded;
  237. }
  239. public function getLastModified(): ?\DateTime {
  240. return $this->lastModified;
  241. }
  243. public function getCategoriesBest() {
  244. return $this->categoriesBest;
  245. }
  247. public function getAffichage() {
  248. return $this->affichage;
  249. }
  251. public function getSousmenu() {
  252. return $this->sousmenu;
  253. }
  255. public function getIndex() {
  256. return $this->index;
  257. }
  259. public function getHideChildren() {
  260. return $this->hideChildren;
  261. }
  263. public function getCategoryDescription($lang='fr') : ?CategoryDescription {
  264. foreach($this->getDescriptions() as $desc){
  265. if($desc->getLanguage()->getCode() == $lang)
  266. return $desc;
  267. }
  268. return null;
  269. }
  271. public function getPictures() {
  272. return $this->pictures;
  273. }
  275. public function getPosition(): ?string {
  276. return $this->position;
  277. }
  279. public function getMenuSpacer() {
  280. return $this->menuSpacer;
  281. }
  283. public function getCurrentPath() {
  284. return $this->currentPath;
  285. }
  287. public function getCode(): string {
  288. return $this->code;
  289. }
  291. public function setPictures($pictures): void {
  292. $this->pictures = $pictures;
  293. }
  295. public function setDescriptions($descriptions) {
  296. $this->descriptions = $descriptions;
  297. }
  299. public function setExtraFields($extraFields): void {
  300. $this->extraFields = $extraFields;
  301. }
  303. public function setImage($image) {
  304. $this->image = $image;
  305. }
  307. public function setParent(?\App\Entity\Category $parent) {
  308. $this->parent = $parent;
  309. }
  311. public function setChildren($children) {
  312. $this->children = $children;
  313. }
  315. public function setSortOrder($sortOrder) {
  316. $this->sortOrder = $sortOrder;
  317. }
  319. public function setDateAdded(\DateTime $dateAdded) {
  320. $this->dateAdded = $dateAdded;
  321. }
  323. public function setLastModified(\DateTime $lastModified) {
  324. $this->lastModified = $lastModified;
  325. }
  327. public function setCategoriesBest($categoriesBest) {
  328. $this->categoriesBest = $categoriesBest;
  329. }
  331. public function setAffichage($affichage) {
  332. $this->affichage = $affichage;
  333. }
  335. public function setSousmenu($sousmenu) {
  336. $this->sousmenu = $sousmenu;
  337. }
  339. public function setIndex($index) {
  340. $this->index = $index;
  341. }
  343. public function setHideChildren($hideChildren) {
  344. $this->hideChildren = $hideChildren;
  345. }
  347. public function setPosition(?string $position): void {
  348. $this->position = $position;
  349. }
  351. public function setMenuSpacer($menuSpacer): void {
  352. $this->menuSpacer = $menuSpacer;
  353. }
  355. public function setCurrentPath($currentPath): void {
  356. $this->currentPath = $currentPath;
  357. }
  359. public function setCode(string $code): void {
  360. $this->code = $code;
  361. }
  363. public function isRoot() {
  364. return empty($this->parent);
  365. }
  367. public function isActive() {
  368. return $this->getAffichage() == 1;
  369. }
  371. public function isVisibleInMenu() {
  372. return $this->isActive() && ($this->getSousmenu() == 1);
  373. }
  375. public function hasChildren() {
  376. return !empty($this->children) && (count($this->children)>0);
  377. }
  379. public function toArray() : array{
  380. $output = [
  381. 'id' => $this->getId(),
  382. 'leaf' => count($this->children)?false:true,
  383. 'children' => [],
  384. 'name' => $this->getName(),
  385. 'languageId' => $this->getLanguageId()
  386. ];
  387. foreach($this->children as $child){
  388. $output['children'][] = $child->toArray();
  389. }
  390. return $output;
  391. }
  393. /**
  394. * @todo Remove once 0 values in the table are converted to NULL.
  395. */
  396. public function loadDescriptions(\Doctrine\ORM\EntityManager $em)
  397. {
  398. $conn = $em->getConnection();
  399. $sql = $conn->prepare('select * from categories_description where categories_id = '.$this->getId());
  400. $sql->execute();
  401. $rows = $sql->fetchAll();
  402. $descriptions = [];
  403. foreach($rows as $desc){
  404. $description = new CategoryDescription();
  405. $description->setName($desc['categories_name']);
  406. $description->setDescription($desc['categories_description']);
  407. $description->setLanguage($em->getRepository('App:Language')->find($desc['language_id']));
  408. $descriptions[] = $description;
  409. }
  410. $this->setDescriptions($descriptions);
  411. }
  413. /**
  414. * @ORM\PostLoad
  415. *
  416. * @todo Remove once 0 values in the table are converted to NULL.
  417. */
  418. public function postLoad(\Doctrine\ORM\Event\LifecycleEventArgs $args) {
  419. if ($this->parent && $this->parent->getId() == 0) {
  420. $this->parent = null;
  421. }
  422. // $this->loadDescriptions($args->getObjectManager());
  423. // $this->translate();
  424. }
  426. public static function getSearchIndex($lang = 'fr')
  427. {
  428. return self::SEARCH_INDICES[$lang];
  429. }
  431. }