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;
}
