public function createCategories() { $categories = array(array('name' => '親1', 'level' => 1, 'rank' => 1, 'child' => array(array('name' => '子1', 'level' => 2, 'rank' => 4, 'child' => array(array('name' => '孫1', 'level' => 3, 'rank' => 9))))), array('name' => '親2', 'level' => 1, 'rank' => 2, 'child' => array(array('name' => '子2-0', 'level' => 2, 'rank' => 5, 'child' => array(array('name' => '孫2', 'level' => 3, 'rank' => 10))), array('name' => '子2-1', 'level' => 2, 'rank' => 6), array('name' => '子2-2', 'level' => 2, 'rank' => 7))), array('name' => '親3', 'level' => 1, 'rank' => 3, 'child' => array(array('name' => '子3', 'level' => 2, 'rank' => 8, 'child' => array(array('name' => '孫3', 'level' => 3, 'rank' => 11)))))); foreach ($categories as $category_array) { $Category = new Category(); $Category->setPropertiesFromArray($category_array); $Category->setDelFlg(Constant::DISABLED); $Category->setCreateDate(new \DateTime()); $Category->setUpdateDate(new \DateTime()); $this->app['orm.em']->persist($Category); $this->app['orm.em']->flush(); if (!array_key_exists('child', $category_array)) { continue; } foreach ($category_array['child'] as $child_array) { $Child = new Category(); $Child->setPropertiesFromArray($child_array); $Child->setParent($Category); $Child->setDelFlg(Constant::DISABLED); $Child->setCreateDate(new \DateTime()); $Child->setUpdateDate(new \DateTime()); $Category->addChild($Child); $this->app['orm.em']->persist($Child); $this->app['orm.em']->flush(); if (!array_key_exists('child', $child_array)) { continue; } foreach ($child_array['child'] as $grandson_array) { $Grandson = new Category(); $Grandson->setPropertiesFromArray($grandson_array); $Grandson->setParent($Child); $Grandson->setDelFlg(Constant::DISABLED); $Grandson->setCreateDate(new \DateTime()); $Grandson->setUpdateDate(new \DateTime()); $Child->addChild($Grandson); $this->app['orm.em']->persist($Grandson); $this->app['orm.em']->flush(); } } } // 登録したEntityをEntityManagerからクリアする // ソート順が上記の登録順でキャッシュされているため、クリアして、DBから再取得させる $this->app['orm.em']->clear(); }
/** * カテゴリを削除する. * * @param \Eccube\Entity\Category $Category 削除対象のカテゴリ * @return boolean 成功した場合 true, 子カテゴリが存在する場合, 商品カテゴリが紐づいている場合は false */ public function delete(\Eccube\Entity\Category $Category) { $em = $this->getEntityManager(); $em->getConnection()->beginTransaction(); try { if ($Category->getChildren()->count() > 0 || $Category->getProductCategories()->count() > 0) { throw new \Exception(); } $rank = $Category->getRank(); $em->createQueryBuilder()->update('Eccube\\Entity\\Category', 'c')->set('c.rank', 'c.rank - 1')->where('c.rank > :rank')->setParameter('rank', $rank)->getQuery()->execute(); $Category->setDelFlg(1); $em->persist($Category); $em->flush(); $em->getConnection()->commit(); } catch (\Exception $e) { $em->getConnection()->rollback(); return false; } return true; }