app/proxy/entity/src/Eccube/Entity/Category.php line 29

Open in your IDE?
  1. <?php
  3. /*
  4. * This file is part of EC-CUBE
  5. *
  6. * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  7. *
  8. * http://www.ec-cube.co.jp/
  9. *
  10. * For the full copyright and license information, please view the LICENSE
  11. * file that was distributed with this source code.
  12. */
  14. namespace Eccube\Entity;
  16. use Doctrine\Common\Collections\Criteria;
  17. use Doctrine\ORM\Mapping as ORM;
  20. /**
  21. * Category
  22. *
  23. * @ORM\Table(name="dtb_category")
  24. * @ORM\InheritanceType("SINGLE_TABLE")
  25. * @ORM\DiscriminatorColumn(name="discriminator_type", type="string", length=255)
  26. * @ORM\HasLifecycleCallbacks()
  27. * @ORM\Entity(repositoryClass="Eccube\Repository\CategoryRepository")
  28. */
  29. class Category extends \Eccube\Entity\AbstractEntity
  30. {
  31. use \Customize\Entity\CategoryTrait;
  33. /**
  34. * @return string
  35. */
  36. public function __toString()
  37. {
  38. return (string) $this->getName();
  39. }
  41. /**
  42. * @return integer
  43. */
  44. public function countBranches()
  45. {
  46. $count = 1;
  48. foreach ($this->getChildren() as $Child) {
  49. $count += $Child->countBranches();
  50. }
  52. return $count;
  53. }
  55. /**
  56. * @param \Doctrine\ORM\EntityManager $em
  57. * @param integer $sortNo
  58. *
  59. * @return \Eccube\Entity\Category
  60. */
  61. public function calcChildrenSortNo(\Doctrine\ORM\EntityManager $em, $sortNo)
  62. {
  63. $this->setSortNo($this->getSortNo() + $sortNo);
  64. $em->persist($this);
  66. foreach ($this->getChildren() as $Child) {
  67. $Child->calcChildrenSortNo($em, $sortNo);
  68. }
  70. return $this;
  71. }
  73. public function getParents()
  74. {
  75. $path = $this->getPath();
  76. array_pop($path);
  78. return $path;
  79. }
  81. public function getPath()
  82. {
  83. $path = [];
  84. $Category = $this;
  86. $max = 10;
  87. while ($max--) {
  88. $path[] = $Category;
  90. $Category = $Category->getParent();
  91. if (!$Category || !$Category->getId()) {
  92. break;
  93. }
  94. }
  96. return array_reverse($path);
  97. }
  99. public function getNameWithLevel()
  100. {
  101. return str_repeat('　', $this->getHierarchy() - 1).$this->getName();
  102. }
  104. public function getDescendants()
  105. {
  106. $DescendantCategories = [];
  108. $ChildCategories = $this->getChildren();
  109. foreach ($ChildCategories as $ChildCategory) {
  110. $DescendantCategories[$ChildCategory->getId()] = $ChildCategory;
  111. $DescendantCategories2 = $ChildCategory->getDescendants();
  112. foreach ($DescendantCategories2 as $DescendantCategory) {
  113. $DescendantCategories[$DescendantCategory->getId()] = $DescendantCategory;
  114. }
  115. }
  117. return $DescendantCategories;
  118. }
  120. public function getSelfAndDescendants()
  121. {
  122. return array_merge([$this], $this->getDescendants());
  123. }
  125. /**
  126. * カテゴリに紐づく商品があるかどうかを調べる.
  127. *
  128. * ProductCategoriesはExtra Lazyのため, lengthやcountで評価した際にはCOUNTのSQLが発行されるが,
  129. * COUNT自体が重いので, LIMIT 1で取得し存在チェックを行う.
  130. *
  131. * @see http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/working-with-associations.html#filtering-collections
  132. *
  133. * @return bool
  134. */
  135. public function hasProductCategories()
  136. {
  137. $criteria = Criteria::create()
  138. ->orderBy(['category_id' => Criteria::ASC])
  139. ->setFirstResult(0)
  140. ->setMaxResults(1);
  142. return $this->ProductCategories->matching($criteria)->count() > 0;
  143. }
  145. /**
  146. * @var int
  147. *
  148. * @ORM\Column(name="id", type="integer", options={"unsigned":true})
  149. * @ORM\Id
  150. * @ORM\GeneratedValue(strategy="IDENTITY")
  151. */
  152. private $id;
  154. /**
  155. * @var string
  156. *
  157. * @ORM\Column(name="category_name", type="string", length=255)
  158. */
  159. private $name;
  161. /**
  162. * @var int
  163. *
  164. * @ORM\Column(name="hierarchy", type="integer", options={"unsigned":true})
  165. */
  166. private $hierarchy;
  168. /**
  169. * @var int
  170. *
  171. * @ORM\Column(name="sort_no", type="integer")
  172. */
  173. private $sort_no;
  175. /**
  176. * @var \DateTime
  177. *
  178. * @ORM\Column(name="create_date", type="datetimetz")
  179. */
  180. private $create_date;
  182. /**
  183. * @var \DateTime
  184. *
  185. * @ORM\Column(name="update_date", type="datetimetz")
  186. */
  187. private $update_date;
  189. /**
  190. * @var \Doctrine\Common\Collections\Collection
  191. *
  192. * @ORM\OneToMany(targetEntity="Eccube\Entity\ProductCategory", mappedBy="Category", fetch="EXTRA_LAZY")
  193. */
  194. private $ProductCategories;
  196. /**
  197. * @var \Doctrine\Common\Collections\Collection
  198. *
  199. * @ORM\OneToMany(targetEntity="Eccube\Entity\Category", mappedBy="Parent")
  200. * @ORM\OrderBy({
  201. * "sort_no"="DESC"
  202. * })
  203. */
  204. private $Children;
  206. /**
  207. * @var \Eccube\Entity\Category
  208. *
  209. * @ORM\ManyToOne(targetEntity="Eccube\Entity\Category", inversedBy="Children")
  210. * @ORM\JoinColumns({
  211. * @ORM\JoinColumn(name="parent_category_id", referencedColumnName="id")
  212. * })
  213. */
  214. private $Parent;
  216. /**
  217. * @var \Eccube\Entity\Member
  218. *
  219. * @ORM\ManyToOne(targetEntity="Eccube\Entity\Member")
  220. * @ORM\JoinColumns({
  221. * @ORM\JoinColumn(name="creator_id", referencedColumnName="id")
  222. * })
  223. */
  224. private $Creator;
  226. /**
  227. * Constructor
  228. */
  229. public function __construct()
  230. {
  231. $this->ProductCategories = new \Doctrine\Common\Collections\ArrayCollection();
  232. $this->Children = new \Doctrine\Common\Collections\ArrayCollection();
  233. }
  235. /**
  236. * Get id.
  237. *
  238. * @return int
  239. */
  240. public function getId()
  241. {
  242. return $this->id;
  243. }
  245. /**
  246. * Set name.
  247. *
  248. * @param string $name
  249. *
  250. * @return Category
  251. */
  252. public function setName($name)
  253. {
  254. $this->name = $name;
  256. return $this;
  257. }
  259. /**
  260. * Get name.
  261. *
  262. * @return string
  263. */
  264. public function getName()
  265. {
  266. return $this->name;
  267. }
  269. /**
  270. * Set hierarchy.
  271. *
  272. * @param int $hierarchy
  273. *
  274. * @return Category
  275. */
  276. public function setHierarchy($hierarchy)
  277. {
  278. $this->hierarchy = $hierarchy;
  280. return $this;
  281. }
  283. /**
  284. * Get hierarchy.
  285. *
  286. * @return int
  287. */
  288. public function getHierarchy()
  289. {
  290. return $this->hierarchy;
  291. }
  293. /**
  294. * Set sortNo.
  295. *
  296. * @param int $sortNo
  297. *
  298. * @return Category
  299. */
  300. public function setSortNo($sortNo)
  301. {
  302. $this->sort_no = $sortNo;
  304. return $this;
  305. }
  307. /**
  308. * Get sortNo.
  309. *
  310. * @return int
  311. */
  312. public function getSortNo()
  313. {
  314. return $this->sort_no;
  315. }
  317. /**
  318. * Set createDate.
  319. *
  320. * @param \DateTime $createDate
  321. *
  322. * @return Category
  323. */
  324. public function setCreateDate($createDate)
  325. {
  326. $this->create_date = $createDate;
  328. return $this;
  329. }
  331. /**
  332. * Get createDate.
  333. *
  334. * @return \DateTime
  335. */
  336. public function getCreateDate()
  337. {
  338. return $this->create_date;
  339. }
  341. /**
  342. * Set updateDate.
  343. *
  344. * @param \DateTime $updateDate
  345. *
  346. * @return Category
  347. */
  348. public function setUpdateDate($updateDate)
  349. {
  350. $this->update_date = $updateDate;
  352. return $this;
  353. }
  355. /**
  356. * Get updateDate.
  357. *
  358. * @return \DateTime
  359. */
  360. public function getUpdateDate()
  361. {
  362. return $this->update_date;
  363. }
  365. /**
  366. * Add productCategory.
  367. *
  368. * @param \Eccube\Entity\ProductCategory $productCategory
  369. *
  370. * @return Category
  371. */
  372. public function addProductCategory(ProductCategory $productCategory)
  373. {
  374. $this->ProductCategories[] = $productCategory;
  376. return $this;
  377. }
  379. /**
  380. * Remove productCategory.
  381. *
  382. * @param \Eccube\Entity\ProductCategory $productCategory
  383. *
  384. * @return boolean TRUE if this collection contained the specified element, FALSE otherwise.
  385. */
  386. public function removeProductCategory(ProductCategory $productCategory)
  387. {
  388. return $this->ProductCategories->removeElement($productCategory);
  389. }
  391. /**
  392. * Get productCategories.
  393. *
  394. * @return \Doctrine\Common\Collections\Collection
  395. */
  396. public function getProductCategories()
  397. {
  398. return $this->ProductCategories;
  399. }
  401. /**
  402. * Add child.
  403. *
  404. * @param \Eccube\Entity\Category $child
  405. *
  406. * @return Category
  407. */
  408. public function addChild(Category $child)
  409. {
  410. $this->Children[] = $child;
  412. return $this;
  413. }
  415. /**
  416. * Remove child.
  417. *
  418. * @param \Eccube\Entity\Category $child
  419. *
  420. * @return boolean TRUE if this collection contained the specified element, FALSE otherwise.
  421. */
  422. public function removeChild(Category $child)
  423. {
  424. return $this->Children->removeElement($child);
  425. }
  427. /**
  428. * Get children.
  429. *
  430. * @return \Doctrine\Common\Collections\Collection
  431. */
  432. public function getChildren()
  433. {
  434. return $this->Children;
  435. }
  437. /**
  438. * Set parent.
  439. *
  440. * @param \Eccube\Entity\Category|null $parent
  441. *
  442. * @return Category
  443. */
  444. public function setParent(Category $parent = null)
  445. {
  446. $this->Parent = $parent;
  448. return $this;
  449. }
  451. /**
  452. * Get parent.
  453. *
  454. * @return \Eccube\Entity\Category|null
  455. */
  456. public function getParent()
  457. {
  458. return $this->Parent;
  459. }
  461. /**
  462. * Set creator.
  463. *
  464. * @param \Eccube\Entity\Member|null $creator
  465. *
  466. * @return Category
  467. */
  468. public function setCreator(Member $creator = null)
  469. {
  470. $this->Creator = $creator;
  472. return $this;
  473. }
  475. /**
  476. * Get creator.
  477. *
  478. * @return \Eccube\Entity\Member|null
  479. */
  480. public function getCreator()
  481. {
  482. return $this->Creator;
  483. }
  484. }