public function findByRelated(Context $context, Field $field, Module $module, Container $container)
{
$qb = $this->createQueryBuilder();
$qb->addSelect('*');
$qb->from($this->buildEavQuery($module), EavTables::CONTAINER_PREFIX)->join('BigfishEavBundle:Related', 'Related', 'ON', EavTables::CONTAINER_PREFIX . '.container_id = Related.to_container')->where($qb->expr()->eq(EavTables::CONTAINER_PREFIX . '.culture', ':culture'))->setParameter('culture', 'nl')->andwhere($qb->expr()->eq(EavTables::CONTAINER_PREFIX . '.module_id', ':module_id'))->setParameter('module_id', $module->getId())->andWhere($qb->expr()->eq('Related.from_container', ':container_id'))->setParameter('container_id', $container->getId())->andWhere($qb->expr()->isNull(EavTables::CONTAINER_PREFIX . '.deleted'))->andWhere($qb->expr()->eq('Related.field_id', ':field_id'))->setParameter('field_id', $field->getId())->orderBy(EavTables::CONTAINER_PREFIX . '.sequence', 'ASC');
$qb->orderBy(EavTables::CONTAINER_PREFIX . '.sequence', 'ASC');
$result = $qb->getQuery()->getResult();
return $result;
}
/**
* @Route("/module/grid/item/delete/{module}/{container}/{fromField}/{fromContainer}", name="module_grid_item_delete")
*/
public function deleteAction(Request $request, Module $module, Container $container, Field $fromField, Container $fromContainer)
{
$form = $this->createForm(new DeleteContainerType($container, $module));
if ($this->formHandler->handleDelete($form, $request, $container)) {
$url = $this->generateUrl('module_grid_item_index', array('container' => $container->getId(), 'module' => $module->getId(), 'fromField' => $fromField->getId(), 'fromContainer' => $fromContainer->getId()));
return new JsonResponse(array('success' => true, 'url' => $url));
}
return $this->render('BigfishEavBundle:Default:delete.html.twig', array('form' => $form->createView(), 'actionUrl' => $this->generateUrl('module_grid_item_delete', array('container' => $container->getId(), 'module' => $module->getId(), 'fromField' => $fromField->getId(), 'fromContainer' => $fromContainer->getId()))));
}
