/**
* update slug into slug table by type
*
* @param integer $type slug type
* @param object $em entity manager object
*
* @return void
*/
public function updateSlugByType($type, $em)
{
$objects = $em->getRepository('Entity:' . $this->slugableEntity[$type])->findAll();
$query = $em->getRepository('Entity:' . $this->slugableEntity[$type])->createQueryBuilder('obj')->getQuery();
$query->setHint(\Doctrine\ORM\Query::HINT_CUSTOM_OUTPUT_WALKER, 'Gedmo\\Translatable\\Query\\TreeWalker\\TranslationWalker');
$query->setHint(\Gedmo\Translatable\TranslatableListener::HINT_TRANSLATABLE_LOCALE, 'en_GB');
$objects = $query->getResult();
foreach ($objects as $object) {
$slugObj = $em->getRepository('Entity:Slug')->findOneBy(array('type' => $type, 'objectId' => $object->getId()));
if (!$slugObj) {
$slug = new Slug();
$slug->setType($type);
$slug->setObjectId($object->getId());
$this->setSlug($slug, RmcHelpers::slugify($object->getName()), $em);
$em->persist($slug);
$em->flush();
echo 'slug inserted type ' . $type . ' For ' . $object->getName() . "\n";
} else {
echo 'slug already exists ' . $object->getName() . "\n";
}
}
}
