src/Crud/Controller/crudPlainController.php line 2347

Open in your IDE?
  1. <?php
  2. namespace App\Crud\Controller;
  4. use App\Crud\Crud;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Pagerfanta\Pagerfanta;
  7. use Pagerfanta\Adapter\DoctrineORMAdapter;
  8. use App\Crud\FormFilter\crudFilterType;
  9. use Symfony\Component\Form\Extension\Core\DataTransformer\DateTimeToStringTransformer;
  10. use Symfony\Component\Form\Extension\Core\Type\DateType;
  11. use Symfony\Component\Form\Extension\Core\Type\TimeType;
  12. use Symfony\Component\Form\Extension\Core\Type\CollectionType;
  13. //use Symfony\Component\Form\Extension\Core\Type\ChoiceType
  14. use App\Crud\ParseConfig\ParseConfig;
  15. use Symfony\Contracts\Translation\TranslatorInterface;
  16. use Psr\Log\LoggerInterface;
  17. use Symfony\Component\Mailer\MailerInterface;
  18. use Symfony\Component\HttpFoundation\RequestStack;
  19. use Doctrine\ORM\EntityManagerInterface;
  20. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  21. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  22. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  23. use Symfony\Component\HttpFoundation\StreamedResponse;
  25. /**
  26.  * crudController controller.
  27.  */
  28. class crudPlainController extends AbstractController
  29. {
  30.     //CONSTANTES RELACIONADAS CON LAS PLANTILLAS POR DEFECTO EN CASO DE QUE NO SE
  31.     //ESPECIFIQUE NINGUNA
  32.     const defaultTwigIndexName       = '@crud\crud\index.html.twig';
  33.     const defaultTwigInlineIndexName = '@crud\crud\index_inline.html.twig';
  34.     const defaultTwigNewName         = '@crud\crud\new.html.twig';
  35.     const defaultModalTwigNewName    = '@crud\crud\formulario_new_modal.html.twig';
  36.     const defaultTwigEditName        = '@crud\crud\edit.html.twig';
  37.     const defaultTwigShowName        = '@crud\crud\show.html.twig';
  38.     const defaultModalTwigEditName   = '@crud\crud\formulario_edit_modal.html.twig';
  39.     const defaultModalTwigShowName   = '@crud\crud\show_data.html.twig';
  40.     const defaultTwigExcelName       = '@crud\crud\excel.html.twig';
  41.     
  42.     //COSNTANTE QUE INDICA LA CANTIDAD DE COLUMNAS QUE TENDRÁ EL FORMULARIO DE
  43.     //FILTRADO EN CASO DE QUE NO SE ESPECIFIQUE NINGÚN OTRO
  44.     const defaultFilterColumns = 2;
  46.     //REQUEST OBJECT
  47.     protected $request;
  48.     protected $inline = false;
  49.     protected $ajax = false;
  51.     //PROPIEDADES RELACIONADAS CON LA IDENTIFICACION DE LA ENTIDAD A LA QUE SE 
  52.     //LE HACE CRUD
  53.     protected $rol;             //rol pasado en la ruta
  54.     protected $routeClassName;  //Identificador de la clase en el mapa
  55.     protected $className;       //Nombre real de la clase
  56.     protected $fabricante;      //Fabricante de la clase
  57.     protected $bundle;          //Bundle donde reside la clase
  58.     protected $entityFolder;    //Folder donde reside el fichero que define la clase
  59.     protected $classFullName;   //Calculado. Nombre completo de la clase: <Fabricante/Bundle/Folder/Clase>
  60.     protected $bundleName;      //Calculado. Nombre del bundle: <FabricanteBundle>
  61.     
  62.     //PROPIEDADES RELACIONADAS CON LAS PLANTILLAS QUE SE USARÁN PARA MOSTRAR LAS
  63.     //DISTINTAS OPERACIONES
  64.     protected $twigIndexName;   
  65.     protected $twigNewName;
  66.     protected $twigShowName;
  67.     protected $twigEditName;
  68.     protected $heightModalForm;
  69.     protected $widthModalForm;
  70.     protected $heightModalShow;
  71.     protected $widthModalShow;
  72.     protected $indexInnerView;
  73.     protected $twigExcelName;
  74.     
  75.     //PROPIEDADES RELACIONADAS CON LA OPERACION INDEX.
  76.     //
  77.     //Layout de la tabla
  78.     protected $columnAction;
  79.     protected $search;
  80.     protected $tableInfo;
  81.     protected $scrollY;
  82.     
  83.     //BOTONES QUE SE MOSTRARÁN O NO. 
  84.     protected $showInIndex;
  85.     protected $newInIndex;
  86.     protected $editInIndex;
  87.     protected $deleteInIndex;
  88.     protected $buttons;         //Imágenes que se usarán para cada botón.
  89.     //
  90.     //FILTRADO
  91.     protected $showFilter;
  92.     protected $filterColumns;
  93.     protected $showColumns;
  94.     protected $filterData;
  95.     protected $formularioFiltro;
  96.     //
  97.     //PAGINADO
  98.     protected $paginator; 
  99.     protected $showPaginator;
  100.     protected $maxPerPage = 10;
  102.     //PROPIEDADES RELACIONADAS CON LAS OPERACIONES NEW Y EDIT.
  103.     protected $showIdInForm;
  104.     protected $formulario;
  105.     protected $formColumns;
  107.     //OTRAS PROPIEDADES ÚTILES Y COMUNES A TODAS LAS OPERACIONES
  108.     protected $em;
  109.     protected $translator;
  110.     protected $translatorBase;
  111.     protected $booleans;
  112.     protected $paramsRequest;
  113.     protected $entities;
  114.     protected $oldEntity;
  115.     protected $logger;
  116.     protected $widthLabel;
  117.     protected $modal;
  118.     protected $mailer;
  119.     protected $session;
  121.     protected $dateFields = [];
  122.     
  123.     protected $allowedRol = null;
  124.     protected $allowedINDEX = null;
  125.     protected $allowedCREATE = null;
  126.     protected $allowedUPDATE = null;
  127.     protected $allowedDELETE = null;
  128.     protected $allowedSHOW = null;
  129.     
  130.     protected $accion;
  131.     
  132.     protected function setDateToBeginMonth($fecha)
  133.     {
  134.         $year = $fecha->format('Y');
  135.         $month = $fecha->format('m');
  136.         $fecha->setDate($year, $month, 1);
  137.         $fecha->setTime(0,0,0);
  138.         return $fecha;
  139.     }
  141.     /* 
  142.      * MÉTODOS DE LA CLASE
  143.      */
  144.     public function __construct(TranslatorInterface $translator, LoggerInterface $logger, MailerInterface $mailer, RequestStack $requestStack, EntityManagerInterface $entityManager)
  145.     {
  146.         $this->translator = $translator;
  147.         $this->logger = $logger;
  148.         $this->mailer = $mailer;
  149.         $this->session = $requestStack->getSession();
  150.         $this->request = $requestStack->getCurrentRequest();
  151.         $this->em = $entityManager;
  152.     }
  154.     /* 
  155.      * MÉTODOS COMUNES A UNA O VARIAS ACCIONES
  156.      */
  157.     protected function comunCheckConstrains($entity)
  158.     {
  159.         $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  160.         $paramsForFunctionInEntity['accion'] = $this->accion;
  161.         $paramsForFunctionInEntity['bundle_class'] = $this->bundleName . ':' . $this->className;
  162.         $paramsForFunctionInEntity['entity'] = $entity;
  163.         return $this->comunCheckNullableConstrains($entity) 
  164.                &&
  165.                $this->comunCheckUniqueConstrains($entity) 
  166.                &&
  167.                $this->checkNonUniqueConstrains($entity);
  168.     }
  169.     
  170.     protected function comunCheckUniqueConstrains($entity)
  171.     {
  172.        $className = $this->classFullName;
  173.        $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  174.        $constraints = $className::getUniqueConstraints($paramsForFunctionInEntity);
  176.        $existe = false;
  177.        if (isset($constraints['singles']))
  178.          foreach ($constraints['singles'] as $campo)
  179.          {    
  180.             $search = array(); 
  181.             $value=$entity->getFieldValue($campo['nombre']);
  182.             if ($campo['association'])
  183.               if ($value)  
  184.                   $value=$value->getId();
  185.               else
  186.                   continue;
  187.             $search[$campo['nombre']]=$value;
  188.             $otraEntidad = $this->em->getRepository($this->bundleName . '\\Entity\\' . $this->className)->findOneBy($search);
  189.             $existe = ($this->accion=='CREATE' && $otraEntidad) 
  190.                       ||
  191.                       ( $otraEntidad && $entity->getId() != $otraEntidad->getId() );
  192.             if ($existe)
  193.             {
  194.               $this->session->getFlashBag()->set('danger', 
  195.                                                $this->translator->trans(
  196.                                                     'error.unique.single',
  197.                                                     array('%className%' => strtoupper($this->translator->trans($this->routeClassName.'.singular',array(),'crud')),
  198.                                                           '%fieldname%' => strtoupper($this->translator->trans($this->routeClassName.'.fields.'.$campo['nombre'],array(),'crud'))),
  199.                                                     'crud'));
  200.               return false;
  201.             }   
  202.          } 
  203.        if (isset($constraints['composite']))
  204.          foreach ($constraints['composite'] as $nombre=>$columns)
  205.          {    
  206.            $search = array(); 
  207.            $camposStr = '';
  208.            foreach ($columns as $campo)  
  209.            {    
  210.              if ($camposStr == '')
  211.                $camposStr .= $this->translator->trans($this->routeClassName.'.fields.'.$campo['nombre'],array(),'crud');
  212.              else
  213.                $camposStr .= ', '.$this->translator->trans($this->routeClassName.'.fields.'.$campo['nombre'],array(),'crud');
  214.              $value=$entity->getFieldValue($campo['nombre']);
  215.              if ($campo['association'] and $value)
  216.                $value=$value->getId();  
  217.              if ($value) 
  218.                  $search[$campo['nombre']]=$value;
  219.            } 
  220.            if (count($search)>1)
  221.            {
  222.                $otraEntidad = $this->em->getRepository($this->bundleName . '\\Entity\\' . $this->className)->findOneBy($search);
  223.                $existe = ($this->accion=='CREATE' && $otraEntidad)
  224.                          ||
  225.                          ( $otraEntidad && $entity->getId() != $otraEntidad->getId() );
  226.                if ($existe)
  227.                {
  228.                  $this->session->getFlashBag()->set('danger', 
  229.                                                    $this->translator->trans(
  230.                                                         'error.unique.composite',
  231.                                                         array('%className%' => strtoupper($this->translator->trans($this->routeClassName.'.singular',array(),'crud')),
  232.                                                               '%fieldname%' => strtoupper($camposStr)),
  233.                                                         'crud'));
  234.                  return false;
  235.                } 
  236.            }
  237.        }
  238.        return true;
  239.     }
  241.     protected function getNullableConstraints($entity)
  242.     {
  243.         //Singles Unique Constraints
  244.         $nullableFields = array();
  245.         $properties = $this->em->getClassMetadata($this->classFullName)->fieldMappings;
  246.         $association = $this->em->getClassMetadata($this->classFullName)->associationMappings;
  247.         $formulario = $this->getFormulario($entity);
  248.         foreach ($formulario as $field=>$prop)
  249.         {
  250.             if ( isset($properties[$field]) && isset($properties[$field]['nullable']) && !$properties[$field]['nullable'])
  251.             {
  252.                 $nullableFields[$field]=$field;
  253.             }
  254.             if ( isset($association[$field]) &&
  255.                  ( (isset($association[$field]['joinColumns'][0]['nullable']) && !$association[$field]['joinColumns'][0]['nullable']) || (isset($association[$field]['joinTable']['joinColumns'][0]['nullable']) && !$association[$field]['joinTable']['joinColumns'][0]['nullable'])))
  256.             {
  257.                 $nullableFields[$field]=$field;
  258.             }
  259.         }    
  260.         return $nullableFields;
  261.     }
  262.     
  263.     protected function comunCheckNullableConstrains($entity)
  264.     {
  265.         $constraints = $this->getNullableConstraints($entity);
  267.         if (count($constraints)>0)
  268.         foreach ($constraints as $key=>$campo)
  269.         {    
  270.             $valor = $entity->getFieldValue($campo);
  271.             if ($valor===null || $valor==='' || ($valor instanceof  \Doctrine\Common\Collections\ArrayCollection && $valor->count()== 0))
  272.              {
  273.                   $this->session->getFlashBag()->set('danger', 
  274.                                                    $this->translator->trans(
  275.                                                         'error.nullable',
  276.                                                         array('%fieldname%' => strtoupper($this->translator->trans($this->routeClassName.'.fields.'.$campo,array(),'crud'))),
  277.                                                         'crud'));
  278.                   return false;
  279.              }
  280.          } 
  281.        return true;
  282.     }
  284.     protected function checkNonUniqueConstrains($entity)
  285.     {
  286.         $formulario=  $this->getFormulario($entity);
  287.         foreach ($formulario as $campo)
  288.         {
  289.             if ($valor = $entity->getFieldValue($campo['nombre']))
  290.             {    
  291.                 if ($campo['type']=='integer' || $campo['type']=='smallint')
  292.                 {
  293.                     if (!is_numeric($valor) || !is_integer($valor*1))
  294.                     {    
  295.                         $this->session->getFlashBag()->set('danger', 
  296.                                                        $this->translator->trans(
  297.                                                             'error.integer',
  298.                                                             array('%fieldname%' => strtoupper($this->translator->trans($this->translatorBase.'.fields.'.$campo['nombre'],array(),'crud'))),
  299.                                                             'crud'));
  300.                         return false;
  301.                     }
  302.                 }
  303.                 else
  304.                 if ($campo['type']=='float')
  305.                 {
  306.                     if (!is_numeric($valor) || !is_float($valor*1))
  307.                     {    
  308.                         $this->session->getFlashBag()->set('danger', 
  309.                                                        $this->translator->trans(
  310.                                                             'error.float',
  311.                                                             array('%fieldname%' => strtoupper($this->translator->trans($this->translatorBase.'.fields.'.$campo['nombre'],array(),'crud'))),
  312.                                                             'crud'));
  313.                         return false;
  314.                     }
  315.                 }
  316.             }
  317.         }    
  318.        return true;
  319.     }
  320.         
  321.     protected function comunParamsForForm($entity=null)
  322.     {
  323.         $params = $this->comunParamsForFunctionsInEntity();
  324.         $params['accion'] = $this->accion;
  325.         $params['showIdInForm'] = $this->showIdInForm;
  326.         $params['entity'] = $entity;
  327.         return $params;
  328.     }
  330.     private function buildForm(&$params)
  331.     {
  332.         
  333.         $builder = $this->createFormBuilder($params['entity'], array('allow_extra_fields'=>true));
  334.         
  335.         $formulario = $this->getFormulario($params['entity']);
  337.         foreach ($formulario as $item)
  338.         {
  339.             $tipo = null;
  340.             $atributos = null;
  341.             if (isset($item['atributos']))
  342.             {
  343.                 if (isset($item['atributos']['attr']['data-url']))
  344.                 {
  345.                     $item['atributos']['attr']['data-url'] = $params['url'];
  346.                 }
  348.                 //en caso de que la entidad tenga una relacion ManyToOne con otra y este atributo se llene a partir de haber seleccionado
  349.                 //el valor del parent previamente, por lo que el valor de dicho padre no debe ser modificable y no se muestra
  350.                 if (isset($item['atributos']['attr']['isparent']) and isset($params['paramsRequest']['idParent']))
  351.                 {
  352.                     $idParent = $params['paramsRequest']['idParent'];
  353.                     //creando una query que devuelve una lista con solo la entity que tenga el valor del parent seleccionado
  354.                     $item['atributos']['query_builder'] = function (EntityRepository $er) use ($idParent) {
  355.                         return $er->createQueryBuilder('e')
  356.                             ->where('e.id = :id')
  357.                             ->setParameter('id', $idParent);
  358.                     };
  359.                     //eliminando que ponga el placeholder para que seleccione automaticamente el unico valor que hay en la lista devuelta por la query anterior
  360.                     $item['atributos']['empty_value'] = false;
  361.                 }
  363.                 //para el caso de que exista una query_builder como atributo y ademas sea necesario reemplazar algun valor de esa query
  364.                 //y dicho valor debe venir dentro del array de $params
  365.                 if(isset($item['atributos']['attr']['query_builder']))
  366.                 {
  367.                     foreach ($item['atributos']['attr']['query_builder']['replace'] as $key){
  368.                         $item['atributos']['attr']['query_builder']['params'] = str_replace($key, $params[$key], $item['atributos']['attr']['query_builder']['params']);
  369.                     }
  370.                     $item['atributos']['query_builder'] = $params['em']->getRepository($item['atributos']['attr']['query_builder']['entity'])->{$item['atributos']['attr']['query_builder']['funcion']}($item['atributos']['attr']['query_builder']['params']);
  371.                     unset($item['atributos']['attr']['query_builder']);
  372.                 }
  374.                 $atributos = $item['atributos'];
  376.             }
  377.             if (isset($item['tipo']))
  378.                 $tipo = $item['tipo'];
  379.             $nombre = $item['nombre'];
  381.             switch ($tipo)
  382.             {
  383. /*                case 'time':
  384.                 $tipo = TimeType::class;
  385.                     break;*/
  386.                 case 'collection':
  387.                     $tipo = CollectionType::class;
  388.                     break;
  389.                 case 'date':
  390.                 $tipo = DateType::class;
  391.                     $atributos['html5'] = false;
  392. //                $builder->add($nombre, $tipo, $atributos);
  393. //                $builder->get($nombre)->addViewTransformer(new DateTimeToStringTransformer(null, null, 'd-m-Y'));
  394. //                $builder->add($builder->create($nombre,$tipo,$atributos)->addViewTransformer(new DateTimeToStringTransformer()));
  395.                     break;
  396.                 case 'geometria':
  397.                 $tipo = "Symfony\Component\Form\Extension\Core\Type\HiddenType";
  398.   //              $builder->add($nombre, $tipo, $atributos);
  399.                     break;
  400.                 case 'biplane_enum':
  401.                     if (isset($atributos['attr']['class']))
  402.                     {
  403.                     $class = str_replace('spinbox-input', '', $atributos['attr']['class']);
  404.                     if ($class)
  405.                         {
  406.                         $atributos['attr']['class'] = $class;
  407.                         }
  408.                     else
  409.                         {
  410.                         unset($atributos['attr']['class']);
  411.                 }
  412.             }
  413.                     break;
  414.                 case 'subcriber':
  415.                     $builder->addEventSubscriber(new $item['atributos']['class_subcriber']($params['em'], $params['translator']));
  416.                     break;
  417.                 case 'Symfony\Component\Form\Extension\Core\Type\FileType':
  418.                     $params['file'][$nombre] = $atributos['attr']['class'];
  419.                     break;
  420.             }
  422.             if ($tipo != 'subcriber')
  423.             {
  424.                 if ($atributos && isset($atributos['attr']['class']))
  425.                     $atributos['attr']['class'].=' form-control';
  426.                 else
  427.                     $atributos['attr']['class']='form-control';
  428.                 if (strpos($atributos['attr']['class'],'chosen-select')!==false)
  429.                 {
  430.                     $atributos['attr']['class'].=' chosen-pending';
  431.                 }
  432.                 $builder->add($nombre, $tipo, $atributos);
  433.             }
  435.             }
  436.         return $builder->getForm();
  437.     }
  438.      
  439.     protected function comunParamsForFunctionsInEntity()
  440.     {
  441.         $params = array(
  442.             'em'              => $this->em,
  443.             'rol'             => $this->rol,
  444.             'routeClassName'  => $this->routeClassName,
  445.             'user'            => $this->getUser(),
  446.             'className'       => $this->classFullName,
  447.             'session'         => $this->session,
  448.             'translator'      => $this->translator,
  449.             'translatorBase'  => $this->translatorBase,
  450.             'filterData'      => $this->filterData,
  451.             'paramsRequest'   => $this->paramsRequest,
  452.             'viewWidth'       => $this->session->get('view_width'),
  453.             'logger'          => $this->logger,
  454.         );
  455.         unset($params['paramsRequest']['filterData']);
  456.         return $params;
  457.     }   
  458.     
  459.     protected function comunPersist($entity, $flush=true)
  460.     {
  461.         if (!$this->em)
  462.           $this->em = $this->getDoctrine()->getManager();
  463.         try 
  464.         {
  465.             $isNew = $entity->getId()==null;
  466.             $this->em->persist($entity);
  467.             if($flush)
  468.             {
  469.                 $this->em->flush();
  470.                 if (!$this->ajax)
  471.                 {
  472.                 $texto = $isNew ? 'persist.success.create' : 'persist.success.update';
  473.                     $this->session->getFlashBag()->set(
  474.                         'info', 
  475.                         $this->translator->trans($texto, array(), 'crud')
  476.                     );
  477.                 }
  478.             }
  479.             return true;
  480.         }
  481.         catch (\Exception $exc)
  482.         {
  483.             if (!$this->ajax)
  484.             {
  485.            $texto = $isNew ? 'persist.fail.create' : 'persist.fail.update';
  486.                 $this->session->getFlashBag()->set(
  487.                     'danger',
  488.                     $this->translator->trans($texto, array(), 'crud').' ( '.$exc->getMessage().' )'
  489.                 );
  490.             }
  491.            $this->logger->error($exc->getTraceAsString());
  492.            return false;
  493.         }
  494.     }
  495.   
  496.     protected function comunRemove($entity, $flush=true)
  497.     {
  498.         if (!$this->em)
  499.           $this->em = $this->getDoctrine()->getManager();
  500.         try {
  501.             $this->em->remove($entity);
  502.             if($flush){
  503.                 $this->em->flush();
  504.                 if (!$this->ajax)
  505.                 {
  506.                     $this->session->getFlashBag()->set('info', $this->translator
  507.                                                                        ->trans('persist.success.delete', array(), 'crud'));           
  508.                 }
  509.             }
  510.             return true;
  511.         } catch (\Exception $exc) {
  512.             if (!$this->ajax)
  513.             {
  514.             $msg = $exc->getMessage();
  515.             if (strpos($msg,'Foreign')===false)
  516.                 {
  517.                     $this->session->getFlashBag()->set(
  518.                         'danger', 
  519.                         $this->translator->trans('persist.fail.delete', array(), 'crud')
  520.                     );
  521.                 }
  522.             else
  523.                 {
  524.                     $this->session->getFlashBag()->set(
  525.                         'danger', 
  526.                         $this->translator->trans('persist.fail.delete_foreign', array(), 'crud')
  527.                     );
  528.                 }
  529.                 
  530.             }
  531.             $this->logger->error($msg);
  532.             return false;
  533.         }
  534.     }
  535.     
  536.     protected function setClassMap($routeClassName)
  537.     {
  538.         $parseConfig = new ParseConfig();
  539.         $config = $parseConfig->parse($this->container);
  540.         $this->booleans = $config['crudBooleans'];
  541.         $this->buttons = $config['crudButtons'];
  542.         $config = $config['crudMapping'];
  544.         $this->inline = false;
  545.         $inline = strrpos($routeClassName, '_inline');
  546.         if ($inline !== false)
  547.         {
  548.             $routeClassName = substr($routeClassName, 0, $inline);
  549.             $this->inline = true;
  550.         }
  551. //        $config = $this->container->getParameter('crudmapping');
  552.         if (isset($config[$routeClassName]))
  553.         {
  554.             $this->routeClassName = $routeClassName;
  555.             $properties = $config[$routeClassName];
  557.             if (isset($properties['allowedRol']))
  558.             {
  559.                 $this->allowedRol = $properties['allowedRol'];
  560.             }
  561.             if (isset($properties['allowedINDEX']))
  562.             {
  563.                 $this->allowedINDEX = $properties['allowedINDEX'];
  564.             }
  565.             if (isset($properties['allowedCREATE']))
  566.             {
  567.                 $this->allowedCREATE = $properties['allowedCREATE'];
  568.             }
  569.             if (isset($properties['allowedUPDATE']))
  570.             {
  571.                 $this->allowedUPDATE = $properties['allowedUPDATE'];
  572.             }
  573.             if (isset($properties['allowedDELETE']))
  574.             {
  575.                 $this->allowedDELETE = $properties['allowedDELETE'];
  576.             }
  577.             if (isset($properties['allowedSHOW']))
  578.             {
  579.                 $this->allowedSHOW = $properties['allowedSHOW'];
  580.             }
  581.             
  582.             if (!$this->inline)
  583.             {
  584.                 $this->translatorBase = $properties['translatorBase'];
  586.                 if (isset($properties['className']))
  587.                 {
  588.                     $this->className     = $properties['className'];
  589.                 }
  590.                 if (isset($properties['fabricante']))
  591.                 {
  592.                     $this->fabricante    = $properties['fabricante'];
  593.                 }
  594.                 if (isset($properties['bundle']))
  595.                 {
  596.                     $this->bundle        = $properties['bundle'];
  597.                 }
  598.                 if (isset($properties['bundlename']))
  599.                 {
  600.                     $this->bundleName    = $properties['bundlename'];
  601.                 }
  602.                 if (isset($properties['entityfolder']))
  603.                 {
  604.                     $this->entityFolder  = $properties['entityfolder'];
  605.                 }
  606.                 if (isset($properties['classfullname']))
  607.                 {
  608.                     $this->classFullName = $properties['classfullname'];
  609.                 }
  611.                 $this->modal = $properties['modal'];
  612.                 $this->widthModalForm = $properties['widthModalForm'];
  613.                 $this->heightModalForm = $properties['heightModalForm'];
  614.                 $this->widthModalShow = $properties['widthModalShow'];
  615.                 $this->heightModalShow = $properties['heightModalShow'];
  617.                 if (isset($properties['indexInnerView']))
  618.                     $this->indexInnerView = $properties['indexInnerView'];
  620.                 if (isset($properties['twigIndexName']))
  621.                     $this->twigIndexName = $properties['twigIndexName'];
  622.                 else
  623.                     if (!$this->twigIndexName)
  624.                     $this->twigIndexName = self::defaultTwigIndexName;
  626.                 if (isset($properties['twigNewName']))
  627.                 { 
  628.                     $this->twigNewName = $properties['twigNewName'];
  629.                 }
  630.                 else
  631.                     if (!$this->twigNewName || $this->twigNewName==self::defaultTwigNewName)
  632.                     {
  633.                         if ($this->modal)
  634.                         {
  635.                             $this->twigNewName = self::defaultModalTwigNewName;
  636.                         }
  637.                         else
  638.                         {
  639.                             $this->twigNewName = self::defaultTwigNewName;
  640.                         }
  641.                     }
  643.                 if (isset($properties['twigEditName']))
  644.                     $this->twigEditName = $properties['twigEditName'];
  645.                 else
  646.                     if (!$this->twigEditName || $this->twigEditName==self::defaultTwigEditName)
  647.                     {
  648.                         if ($this->modal)
  649.                             $this->twigEditName = self::defaultModalTwigEditName;
  650.                         else
  651.                             $this->twigEditName = self::defaultTwigEditName;
  652.                     }
  654.                 if (isset($properties['twigShowName']))
  655.                     $this->twigShowName = $properties['twigShowName'];
  656.                 else
  657.                     if (!$this->twigShowName || $this->twigShowName==self::defaultTwigShowName)
  658.                     {
  659.                         if ($this->modal)
  660.                             $this->twigShowName = self::defaultModalTwigShowName;
  661.                         else
  662.                             $this->twigShowName = self::defaultTwigShowName;
  663.                     }
  665.                 if (isset($properties['twigexcelname']))
  666.                     $this->twigExcelName = $properties['twigexcelname'];
  667.                 else
  668.                     if (!$this->twigExcelName || $this->twigExcelName==self::defaultTwigExcelName)
  669.                     {
  670.                         if ($this->modal)
  671.                             $this->twigExcelName = self::defaultTwigExcelName;
  672.                         else
  673.                             $this->twigExcelName = self::defaultTwigExcelName;
  674.                     }
  676.                 $this->filterColumns = $properties['filterColumns'];
  678.                 if (!isset($this->showColumns))
  679.                 $this->showColumns = $properties['showColumns'];
  681.                 if (!isset($this->formColumns))
  682.                 $this->formColumns = $properties['formColumns'];
  684.                 if (isset($properties['showIdInForm']))
  685.                     $this->showIdInForm = $properties['showIdInForm'];
  686.                 else
  687.                     if (!isset($this->showIdInForm))
  688.                         $this->showIdInForm = false;
  690.                 if (isset($properties['showInIndex']))
  691.                 $this->showInIndex = $properties['showInIndex'];
  692.                 else
  693.                     if (!isset($this->showInIndex))
  694.                         $this->showInIndex = false;
  696.                 if (isset($properties['newInIndex']))
  697.                 $this->newInIndex = $properties['newInIndex'];
  698.                 else
  699.                     if (!isset($this->newInIndex))
  700.                         $this->newInIndex = true;
  702.                 if (isset($properties['deleteInIndex']))
  703.                 $this->deleteInIndex = $properties['deleteInIndex'];
  704.                 else
  705.                     if (!isset($this->deleteInIndex))
  706.                         $this->deleteInIndex = true;
  708.                 if (isset($properties['editInIndex']))
  709.                 $this->editInIndex = $properties['editInIndex'];
  710.                 else
  711.                     if (!isset($this->editInIndex))
  712.                         $this->editInIndex = true;
  714.                 if (isset($properties['showFilter']))
  715.                 $this->showFilter = $properties['showFilter'];
  716.                 else
  717.                     if (!isset($this->showFilter))
  718.                         $this->showFilter = true;
  720.                 if (isset($properties['showPaginator']))
  721.                     $this->showPaginator = $properties['showPaginator'];
  722.                 else
  723.                     if (!isset($this->showPaginator))
  724.                         $this->showPaginator = true;
  726.                 if (isset($properties['columnAction']))
  727.                     $this->columnAction = $properties['columnAction'];
  728.                 else
  729.                     if (!isset($this->columnAction))
  730.                         $this->columnAction = true;
  732.                 if (isset($properties['search']))
  733.                     $this->search = $properties['search'];
  734.                 else
  735.                     if (!isset($this->search))
  736.                         $this->search = true;
  738.                 if (isset($properties['tableInfo']))
  739.                     $this->tableInfo = $properties['tableInfo'];
  740.                 else
  741.                     if (!isset($this->tableInfo))
  742.                         $this->tableInfo = true;
  744.                 if (isset($properties['scrollY']))
  745.                     $this->scrollY = $properties['scrollY'];
  746.                 else
  747.                     if (!isset($this->scrollY))
  748.                         $this->scrollY = null;
  750.                 if (isset($properties['widthLabel']))
  751.                     $this->widthLabel = $properties['widthLabel'];
  752.                 else
  753.                     if (!isset($this->widthLabel))
  754.                         $this->widthLabel = '20%';
  755.             }
  756.             else
  757.             {
  758.                 $this->twigIndexName = self::defaultTwigInlineIndexName;
  759.             }
  760.         }
  761.         else
  762.         {
  763.             throw new \RuntimeException(
  764.                 $this->translator->trans(
  765.                     'error.class_not_defined', array('%className%' => $this->routeClassName), 'crud'
  766.                 )
  767.             );
  768.         }
  769.         return $config;
  770.     }        
  772.     protected function comunSetFileFields($params, $form, $entity, $uploadDir = "uploads", $hashKey = '')
  773.     {        
  774.         $deleteFiles = array();
  775.         if (isset($params['file']))
  776.         {
  777.             $oldfile=$this->request->get('oldfile');
  778.             foreach ($params['file'] as $fieldName=>$class) 
  779.             {
  780.                 if ($oldfile && isset($oldfile[$fieldName]) && $oldfile[$fieldName]=='deleted')
  781.                 {
  782.                     $deleteFiles[] = $fieldName;
  783.                 }
  784.                 $file = $form->get($fieldName);
  785.                 $viewData = $file->getViewData();
  786.                 if ($viewData instanceof \Symfony\Component\HttpFoundation\File\UploadedFile)
  787.                 {
  788.                     $fileName = $this->comunUpload($viewData, $uploadDir, $hashKey);
  789.                     if ($fileName)
  790.                     {
  791.                         $adjunto = new $class();
  792.                         $adjunto->setArchivo($viewData->getClientOriginalName());
  793.                         $adjunto->setRuta($uploadDir);
  794.                         $adjunto->setArchivoHash($fileName);
  795.                         $adjunto->setSize(filesize($uploadDir.'/'.$fileName));
  796.                         $this->em->persist($adjunto);
  797.                         $this->em->flush();
  798.                         $setMethod = 'set'.ucfirst($fieldName);
  799.                         $entity->$setMethod($adjunto);
  800.                     }
  801.                 }
  802.                 else
  803.                 {
  804.                     if ($oldfile && isset($oldfile[$fieldName]) && $oldfile[$fieldName]=='deleted')
  805.                     {
  806.                         $setMethod = 'set'.ucfirst($fieldName);
  807.                         $entity->$setMethod(null);
  808.                     }
  809.                 }
  810.             }
  811.         }
  812.         return $deleteFiles;
  813.     }        
  815.     protected function setParamsRequest()
  816.     {
  817.         $this->paramsRequest = array();
  819.         $keys = $this->request->query->keys();
  820.         foreach ($keys as $index=>$key)
  821.         {
  822.            $this->paramsRequest[$key]=$this->request->get($key); 
  823.         }
  824.         $keys = $this->request->attributes->keys();
  825.         foreach ($keys as $index=>$key)
  826.         {
  827.             if (strpos($key,'_')!==0 && $key!='id' && $key!='routeClassName' && $key!='filterdata')
  828.             {
  829.                 $this->paramsRequest[$key]=$this->request->get($key); 
  830.             }
  831.         }
  833.         $keys = $this->request->request->keys();
  834.         foreach ($keys as $index=>$key)
  835.         {
  836.             if ($key!='crud_type')
  837.             {
  838.                 $this->paramsRequest[$key]=$this->request->get($key); 
  839.             }
  840.         }
  841.     }
  842.         
  843.     protected function setFilterData($routeClassName)
  844.     {
  845.         $this->filterData = $this->request->get('filterData');
  846.         if (!$this->filterData)
  847.           $this->filterData=$this->session->get($routeClassName);
  848.         if (!$this->filterData)
  849.           $this->filterData=array();
  850.     }
  851.     
  852.     protected function setInitialValues($rol, $routeClassName)
  853.     {
  854.         $this->rol = $rol;
  855.         $this->ajax = $this->request->get('_xml_http_request')==='true';
  856.         $this->setUtilProperties();
  857.         $this->setFilterData($routeClassName);
  858.         $this->setParamsRequest();
  859.         $this->setClassMap($routeClassName);
  860.     }   
  862.     protected function setUtilProperties()
  863.     {
  864.     }   
  865.     
  866.     protected function comunUpload($file, $uploadDir, $hashKey)
  867.     {
  868.         if ($file){
  869.             $extension = pathinfo($file->getClientOriginalName(), PATHINFO_EXTENSION);
  870.             if (!$extension) {
  871.                 // no se puede deducir la extensión
  872.                 $extension = 'bin';
  873.             }
  874.             $fileName = $hashKey . rand(1, 99999999) . '.' . $extension;
  875.             rtrim($uploadDir,"/");
  876.             $file->move($uploadDir,$fileName);
  877.             return $fileName;
  878.         }else{
  879.             return null;
  880.         }        
  881.     }
  882.     
  883.     /* 
  884.      * MÉTODOS ASOCIADOS A LA ACCIÓN INDEX
  885.      */
  886.     public function indexAction($rol, $routeClassName)
  887.     {     
  888.         $this->setInitialValues($rol, $routeClassName);
  889.         $this->accion = 'INDEX';
  890.         if (!$this->allowActionExecution())
  891.         {
  892.             return $this->render('@crud\\accesDenied.html.twig');
  893.         }
  894.         if (!$this->inline)
  895.         {
  896.             $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  897.             $paramsForFunctionInEntity['showIdInForm'] = $this->showIdInForm;
  899.             $this->indexPrepareFilterForm($paramsForFunctionInEntity);
  900.             $paramsForFunctionInEntity['filterForm']= $this->formularioFiltro;
  901.             $this->entities = $this->indexLoadEntities($paramsForFunctionInEntity);
  903.             $this->session->set($routeClassName,$this->filterData);
  905.             //$this->paginator = $this->indexCreatePaginator($this->entities);
  906.             $this->paginator = null;
  909.         }
  910.         $params = $this->indexParamsForTwig($this->em);
  911.         if (isset($this->paramsRequest['view']))
  912.             return $this->render($this->paramsRequest['view'], $params);
  913.         else
  914.             return $this->render($this->twigIndexName, $params);
  915.         
  916.     }
  917.     
  918.     protected function getFormFilter()
  919.     {
  920.         $formulario = array();
  921.         $R = new \ReflectionClass($this->classFullName);
  922.         $fields = $R->getProperties(\ReflectionProperty::IS_PRIVATE);
  923.         $properties = $this->em->getClassMetadata($this->classFullName)->fieldMappings;
  924.         $association = $this->em->getClassMetadata($this->classFullName)->associationMappings;
  925.         foreach ($fields as $field)
  926.         {
  927.             $fieldname = $field->name;
  928.             $label = $this->translator->trans($this->routeClassName.'.fields.'.$fieldname, array(), 'crud');
  929.             if ($label == $this->routeClassName.'.fields.'.$fieldname)
  930.             {
  931.                 $label = $this->translator->trans($this->translatorBase.'.fields.'.$fieldname, array(), 'crud');
  932.             }
  933.             
  934.             if (isset($properties[$field->name]))
  935.             {
  936.                 $prop = $properties[$fieldname];
  937.                 if (isset($prop['id']) && $prop['id'] && (!isset($this->showIdInForm) || !$this->showIdInForm))
  938.                 {
  939.                     continue;
  940.                 }
  941.                 $formulario[$fieldname]=array('nombre'   =>$fieldname,
  942.                                               'tipo'     => null,
  943.                                               'type'     => $prop['type'],
  944.                                               'atributos'=> array('label' => $label,
  945.                                                                   'required' => false,
  946.                                                                   'attr'=>array('style'=>'width: 100%')));
  947.                 if ($prop['type']=='integer' || $prop['type']=='smallint')
  948.                 {
  949.                     $this->getFormFilterInteger($fieldname, $prop, $formulario);
  950.                 }
  951.                 if ($prop['type']=='boolean')
  952.                 {    
  953.                     $this->getFormFilterBoolean($fieldname, $prop, $formulario);
  954.                 }   
  955.                 if ($prop['type']=='datetime')
  956.                 {
  957.                     $this->getFormFilterDateTime($fieldname, $prop, $formulario);
  958.                 }
  959.             }
  960.             if (isset($association[$field->name]))
  961.             {    
  962.                 $prop = $association[$fieldname];
  963.                 if ((isset($prop['id']) && $prop['id'] && !$this->showIdInForm) 
  964.                     ||
  965.                     $this->isAdjunto($prop['targetEntity']))
  966.                     continue;
  967.                 $this->getFormFilterAssociation($fieldname, $prop, $formulario);
  968.             }  
  969.         }    
  970.         return $formulario;
  971.     }   
  972.     
  973.     protected function getFormFilterInteger($fieldname, $prop, &$formulario)
  974.     {
  975.         $formulario[$fieldname]['atributos']['attr']['class'] = 'spinbox-input';                
  976.         $formulario[$fieldname]['atributos']['attr']['full_width'] = true;                
  977.     }   
  978.    
  979.     protected function getFormFilterBoolean($fieldname, $prop, &$formulario)
  980.     {
  981.         $formulario[$fieldname]['tipo'] = 'Symfony\Component\Form\Extension\Core\Type\ChoiceType';
  982.         $formulario[$fieldname]['atributos']['choices']=array_flip(array('true'=>$this->translator->trans('choice_value.yes', array(), 'crud'),
  983.                                                               'false'=>$this->translator->trans('choice_value.no', array(), 'crud')));
  984.         $formulario[$fieldname]['atributos']['placeholder'] = $this->translator->trans('choice_value.empty_value',array(),'crud');
  985.         $formulario[$fieldname]['atributos']['empty_data'] = null;
  986.     }   
  987.    
  988.     protected function getFormFilterDateTime($fieldname, $prop, &$formulario)
  989.     {
  990.         $label = $formulario[$fieldname]['atributos']['label'];
  991.         $formulario[$fieldname.'_WWdesdeWW']=array(
  992.             'nombre'    => $fieldname.'_WWdesdeWW',
  993.             'tipo'      => null,//'text',
  994.             'type'      => $prop['type'],
  995.             'atributos' => array(
  996.                 'label' => $label.
  997.                            ' '.
  998.                            $this->translator->trans('range_values.since', array(), 'crud').':',
  999.                 'required' => false,
  1000.                 'attr'     => array(
  1001.                     'style'=>'width: 100%'
  1002.                 )
  1003.             )
  1004.         );
  1005.         $formulario[$fieldname.'_WWhastaWW']=array(
  1006.             'nombre'    =>$fieldname.'_WWhastaWW',
  1007.             'tipo'      => null,//'text',
  1008.             'type'      => $prop['type'],
  1009.             'atributos' => array(
  1010.                 'label' => $label.
  1011.                            ' '.
  1012.                            $this->translator->trans('range_values.to', array(), 'crud').':',
  1013.                 'required' => false,
  1014.                 'attr'     => array(
  1015.                     'style'=>'width: 100%'
  1016.                 )
  1017.             )
  1018.         );
  1019.         if (isset($prop['columnDefinition']) && $prop['columnDefinition']=='fecha')
  1020.         {    
  1021.             $formulario[$fieldname.'_WWdesdeWW']['tipo'] = 'date';
  1022.             $formulario[$fieldname.'_WWdesdeWW']['atributos']['attr']['class']='campo_fecha date-picker';
  1023.             $formulario[$fieldname.'_WWdesdeWW']['atributos']['attr']['data-date-format']="dd-mm-yyyy";                  
  1025.             $formulario[$fieldname.'_WWhastaWW']['tipo'] = 'date';
  1026.             $formulario[$fieldname.'_WWhastaWW']['atributos']['attr']['class']='campo_fecha date-picker';
  1027.             $formulario[$fieldname.'_WWhastaWW']['atributos']['attr']['data-date-format']="dd-mm-yyyy";                  
  1028.         }
  1029.         unset($formulario[$fieldname]);
  1030.     }   
  1031.    
  1032.     protected function getFormFilterAssociation($fieldname, $prop, &$formulario)
  1033.     {
  1034.         $label = $this->translator->trans($this->routeClassName.'.fields.'.$fieldname, array(), 'crud');
  1035.         if ($label == $this->routeClassName.'.fields.'.$fieldname)
  1036.         {
  1037.             $label = $this->translator->trans($this->translatorBase.'.fields.'.$fieldname, array(), 'crud');
  1038.         }
  1039.         
  1040.         $formulario[$fieldname]=array(
  1041.             'nombre'          => $fieldname,
  1042.             'tipo'            => EntityType::class,
  1043.             'type'            => 'association',
  1044.             'association'     => $prop['type'],
  1045.             'atributos'       => array(
  1046.                 'label'       => $label,
  1047.                 'required'    => false,
  1048.                 'class'       => $prop['targetEntity'],
  1049.                 'placeholder' => $this->translator->trans('choice_value.empty_value', array(), 'crud'),
  1050.                 'empty_data'  => null,
  1051.                 'multiple'    => true,
  1052.                 'attr'        => array(
  1053.                     'class'   =>'chosen-select',
  1054.                     'style'   =>'width: 100%',
  1055.                     'data-placeholder' => $this->translator->trans('choice_value.empty_value', array(), 'crud')
  1056.                 )
  1057.             )
  1058.         );
  1059.     }   
  1060.    
  1061.     protected function isAdjunto($aClassName)
  1062.     {
  1063.        $r = new \ReflectionClass($aClassName);
  1064.        return $r->isSubclassOf('App\Crud\Entity\crudAdjunto');
  1065.     }   
  1066.     
  1067.     private function indexShowFields()
  1068.     {
  1069.         $showFields = array();
  1070.         $translator = $this->translator;
  1071.         $className = $this->classFullName;
  1073.         $R = new \ReflectionClass($className);
  1074.         $fields = $R->getProperties(\ReflectionProperty::IS_PRIVATE);
  1076.         $properties = $this->em->getClassMetadata($className)->fieldMappings;
  1077.         $association = $this->em->getClassMetadata($className)->associationMappings;
  1078.         foreach ($fields as $field)
  1079.         {
  1080.             $fieldname = $field->name;
  1081.             $label = $translator->trans($this->routeClassName.'.fields.'.$fieldname, array(), 'crud');
  1082.             if ($label == $this->routeClassName.'.fields.'.$fieldname)
  1083.             {
  1084.                 $label = $translator->trans($this->translatorBase.'.fields.'.$fieldname, array(), 'crud');
  1085.             }
  1086.             if (isset($properties[$field->name]))
  1087.             {
  1088.                 $prop = $properties[$fieldname];
  1089.                 if (isset($prop['id']) && $prop['id'] && !$this->showIdInForm)
  1090.                     continue;
  1091.                 $showFields[$fieldname]=array('nombre' => $fieldname,
  1092.                                                 'type' => $prop['type'],
  1093.                                               'label'  => $label);
  1094.                 if (isset($prop['columnDefinition']))
  1095.                 {
  1096.                     $showFields[$fieldname]['type'] = $prop['columnDefinition'];
  1097.                 }        
  1098.                    
  1099.             }
  1100.             if (isset($association[$field->name]))
  1101.             {    
  1102.                 $prop = $association[$fieldname];
  1103.                 if ((isset($prop['id']) && $prop['id'] && !$params['showIdInForm']) 
  1104.                     ||
  1105.                     (isset($prop['type']) && ($prop['type']==8 || $prop['type']==4)))
  1106.                     continue;
  1107.                 $showFields[$fieldname]=array(
  1108.                     'nombre' => $fieldname,
  1109.                     'label'  => $label
  1110.                 );
  1111.                 if($this->isAdjunto($prop['targetEntity']))
  1112.                 {
  1113.                     $showFields[$fieldname]['type'] = 'attach';
  1114.                 }
  1115.             }    
  1116.         }    
  1117.         return $showFields;
  1118.     }
  1119.     
  1120.     protected function showGetFields($entity=null)
  1121.     {
  1122.         $showFields = $this->indexShowFields();
  1123.         return $showFields;
  1124.     }   
  1125.     
  1126.     protected function indexGetFields()
  1127.     {
  1128.         $indexFields = $this->indexShowFields();
  1129.         return $indexFields;
  1130.     }   
  1131.     
  1132.     protected function excelGetFields()
  1133.     {
  1134.         $excelFields = $this->indexGetFields();
  1135.         
  1136.         return $excelFields;
  1137.     }   
  1138.     
  1139.     protected function indexParamsForTwig()
  1140.     {
  1141.         $params = array();
  1142.         $params['routeClassName'] = $this->routeClassName;
  1143.         $params['contenedor'] = $this->routeClassName;
  1144.         $params['imageWidth'] = '70px';
  1145.         foreach ($this->paramsRequest as $key=>$value)
  1146.         {
  1147.             if ($key!='filterData')
  1148.             {
  1149.                 $params[$key]=$value;
  1150.             }
  1151.         }
  1152.         $params['now']  = new \DateTime();
  1153.         if ($this->indexInnerView)
  1154.             $params['index_view'] = $this->indexInnerView;
  1155.         else
  1156.             if (!$this->modal)
  1157.                 $params['index_view'] = '@crud\crud\index_inner.html.twig';
  1158.             else
  1159.                 $params['index_view'] = '@crud\crud\index_inner_modal.html.twig';
  1160.         $params['inline'] = $this->inline;
  1161.         if (!$this->inline)
  1162.         {
  1163.            $className = $this->classFullName;
  1165.            $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  1166.            $paramsForFunctionInEntity['showIdInForm'] = $this->showIdInForm;
  1167.            $params['indexFields']    = $this->indexGetFields();
  1168.            $params['rol']            = $this->rol;
  1169.            $params['className']      = $this->classFullName;
  1170.            $params['formFilter']     = $this->formFilter->createView();
  1171.            $params['filterActive']   = $this->filterActive;
  1172.            $params['filterColumns']  = $this->filterColumns;
  1173.            $params['showInIndex']    = $this->showInIndex;
  1174.            $params['newInIndex']     = $this->newInIndex;
  1175.            $params['editInIndex']    = $this->editInIndex;
  1176.            $params['deleteInIndex']  = $this->deleteInIndex;
  1178.            $params['filterData']     = $this->filterData;
  1179.            $params['showFilter']     = $this->showFilter;
  1180.            $params['showPaginator']  = $this->showPaginator;
  1181.            $params['columnAction']   = $this->columnAction;
  1182.            $params['search']         = $this->search;
  1183.            $params['tableInfo']      = $this->tableInfo;
  1184.            $params['scrollY']        = $this->scrollY;
  1185.            $params['booleans']       = $this->booleans;
  1186.            $params['buttons']        = $this->buttons;
  1187.            $params['entities']       = $this->paginator ? $this->paginator->getCurrentPageResults() : ($this->entities instanceof \Doctrine\ORM\QueryBuilder ? $this->entities->getQuery()->getResult() : $this->entities);
  1188.            $params['paginator']      = $this->paginator;
  1189.            $params['paramsRequest']  = $this->paramsRequest;
  1190.            $params['heightModalForm']  = $this->heightModalForm;
  1191.            $params['widthModalForm']  = $this->widthModalForm;
  1192.            $params['heightModalShow']  = $this->heightModalShow;
  1193.            $params['widthModalShow']  = $this->widthModalShow;
  1194.            $params['widthLabel']    = $this->widthLabel;
  1196.            $paramsForFunctionInEntity['entities'] = $params['entities'];
  1197.            $paramsEntity = $className::getParamsForIndexTwig($paramsForFunctionInEntity);
  1198.            $params = array_merge($params, $paramsEntity);
  1199.         }
  1201.        return $params;
  1202.     }
  1204.     protected function indexCreatePaginator($entities)
  1205.     {
  1206.         if ($this->showPaginator)
  1207.         {    
  1208.             $adapter = new DoctrineORMAdapter($entities);
  1209.             $pagerfanta = new Pagerfanta($adapter);
  1210.             $pagerfanta->setMaxPerPage($this->maxPerPage);
  1211.             if (!$page = $this->request->get('page'))
  1212.             {
  1213.                 $page = 1;
  1214.             }
  1215.             try
  1216.             {
  1217.                 $pagerfanta->setCurrentPage($page);
  1218.             } 
  1219.             catch (NotValidCurrentPageException $e)
  1220.             {
  1221.                 throw new NotFoundHttpException();
  1222.             }
  1223.             return $pagerfanta;
  1224.         }
  1225.         else
  1226.             return null;
  1227.     }
  1228.     
  1229.     protected function indexLoadEntities($params)
  1230.     {
  1231.         $params['logger'] = $this->logger;
  1232.         $query = $this->em->getRepository($this->bundleName.'\\Entity\\'.$this->className)->loadResults($params, $this->filterData);
  1233.         return $query->getQuery()->getResult();
  1234.     }
  1236.     protected function indexCleanFilterData()
  1237.     {
  1238.         foreach ($this->filterData as $key=>$valor)
  1239.         {
  1240.             if ((is_array($valor) && empty($valor)) || 
  1241.                 (($valor instanceof \Doctrine\Common\Collections\ArrayCollection) && $valor->count()==0) || 
  1242.                 $valor=='')
  1243.             {
  1244.                 unset($this->filterData[$key]);
  1245.             }
  1246.         }
  1247.     }
  1248.     
  1249.     public function indexPrepareFilterForm($params)
  1250.     {
  1251.         $this->indexCleanFilterData();
  1253.         if ($this->request->getMethod()=="POST")
  1254.         {
  1255.             $this->filterData=array();
  1256.             //Tomar los datos del request
  1257.             if ($this->request->get('form'))
  1258.             {
  1259.                 $this->filterData = $this->request->get('form');
  1260.             }
  1261.             $this->indexCleanFilterData();
  1262.         }
  1263.         
  1264. //        $classFullName = $this->classFullName;
  1265. //        $classFullName::setFiltros($params, $this->filterData);
  1266.         $this->setFiltros();
  1267.         $this->formFilter = $this->indexBuildFilterForm($this->filterData, $params);
  1268.         
  1269.         $this->filterActive = false; //Para poner abierto o cerrado el panel de filtros
  1270.         foreach ($this->filterData as $value) 
  1271.         {
  1272.             if (!empty($value)) 
  1273.             {
  1274.                 $this->filterActive = true;
  1275.                 break;
  1276.             }
  1277.         }    
  1278.     }   
  1280.     protected function allowActionExecution($entity=null)
  1281.     {
  1282.         if ($this->allowedRol)
  1283.         {
  1284.             return $this->isAllowed($this->allowedRol);
  1285.         }
  1286.         else
  1287.         {
  1288.             $var = 'allowed'.$this->accion;
  1289.             if ($this->$var)
  1290.             {
  1291.                 return $this->isAllowed($this->$var);
  1292.             }
  1293.             else
  1294.             {
  1295.                 return false;
  1296.             }
  1297.         }
  1298.     }
  1299.     
  1300.     private function isAllowed($rule)
  1301.     {
  1302.         if (is_array($rule))
  1303.         {
  1304.             return in_array($this->rol, $rule);
  1305.         }
  1306.         else
  1307.         {
  1308.             return $rule=='all' || $rule == $this->rol; 
  1309.         }
  1310.     }
  1311.     
  1312.     protected function setFiltros()
  1313.     {
  1314.         
  1315.     }
  1316.     
  1317.     private function indexBuildFilterForm($data, $params)
  1318.     {
  1319.         $builder = $this->createFormBuilder($data, array(
  1320.             'csrf_protection' => false,
  1321.             'validation_groups' => array('filtering'),
  1322.         ));
  1323.         $this->formularioFiltro = $this->getFormFilter();
  1324.         foreach ($this->formularioFiltro as $item)
  1325.         {
  1326.             $tipo = null;
  1327.             $atributos = array('mapped'=>false);
  1328.             if (isset($item['tipo']))
  1329.               $tipo = $item['tipo'];
  1330.             if (isset($item['atributos']))
  1331.               $atributos = array_merge ($atributos, $item['atributos']);
  1332.             $nombre = $item['nombre'];
  1333.             if ($data && isset($data[$nombre]) && $data[$nombre]!='null' && $data[$nombre]!='not null')
  1334.             {
  1335.                 if (isset($item['type']) && $item['type']=='association' && $data[$nombre] != '')
  1336.                 {
  1337.                     if (isset($atributos['multiple']) && $atributos['multiple']==true)
  1338.                     {
  1339.                         if ($data[$nombre] instanceof \Doctrine\Common\Collections\ArrayCollection)
  1340.                         {
  1341.                             $data[$nombre] = $data[$nombre]->toArray();
  1342.                         }
  1343.                         if (!is_array($data[$nombre]))
  1344.                             $data[$nombre]=array($data[$nombre]);
  1346.                         $atributos['data'] = new \Doctrine\Common\Collections\ArrayCollection();
  1347.                         foreach ($data[$nombre] as $key=>$option)
  1348.                         {
  1349.                             if ($option instanceof \Crud\Entity\crudEntity)
  1350.                                 $entidad = $option;
  1351.                             else
  1352.                                 $entidad = $this->em->getRepository($atributos['class'])->find($option);
  1353.                             $entidad = $this->em->merge($entidad);
  1354.                             $atributos['data'][]=$entidad;
  1355.                         }    
  1356.                     }
  1357.                     else
  1358.                     {
  1359.                         $entidad = $this->em->getRepository($atributos['class'])->find($data[$nombre]); 
  1360.                         $atributos['data']=$entidad;
  1361.                     }
  1362.                 }
  1363.                 else
  1364.                     if ($tipo=='Biplane\EnumBundle\Form\Type\EnumType' && isset($atributos['enum_class']) && $data[$nombre] != '' )
  1365.                     {
  1366.                         if (is_array($data[$nombre]))
  1367.                         {
  1368.                             foreach ($data[$nombre] as $valor)
  1369.                         {
  1370.                                 $enum = $this->getEnumFilterData($atributos['enum_class'], $valor);
  1371.                                 $atributos['data'][] = $enum;
  1372.                         }
  1373.                         }
  1374.                         else
  1375.                         {
  1376.                             $enum = $this->getEnumFilterData($atributos['enum_class'], $data[$nombre]);
  1377.                         $atributos['data']=$enum;
  1378.                         }    
  1379.                     }    
  1380.                     else
  1381.                         if (($tipo=='entity' || $tipo==EntityType::class) && isset($atributos['class']) && $data[$nombre] != '' )
  1382.                         {
  1383.                             if (isset($atributos['multiple']) && $atributos['multiple']==true)
  1384.                             {
  1385.                                 $collecion = new \Doctrine\Common\Collections\ArrayCollection();
  1386.                                 if (!is_array($data[$nombre]))
  1387.                                     $data[$nombre]=array($data[$nombre]);
  1388.                                 foreach ($data[$nombre] as $option)
  1389.                                 {
  1390.                                     $entidad = $this->em->getRepository($atributos['class'])->find($option);
  1391.                                     $collecion[]=$entidad;
  1392.                                 }  
  1393.                                 $atributos['data']=$collecion;
  1394.                             }
  1395.                             else
  1396.                             {
  1397.                                 $entidad = $this->em->getRepository($atributos['class'])->find($data[$nombre]); 
  1398.                                 $atributos['data']=$entidad;
  1399.                             }
  1400.                         }    
  1401.                         else
  1402.                         {    
  1403.                             $atributos['data']=$data[$nombre];
  1404.                         }
  1405.             }    
  1406.             if ($tipo=="date")
  1407.             {
  1408.                 $tipo=null;//"text";
  1409.                 $builder->add($nombre,$tipo,$atributos);
  1410.                 if (isset($data[$nombre]))
  1411.                 {
  1412.                     $atributos['data']=$data[$nombre];
  1413.                 }
  1414.                 //$builder->get($nombre)->addViewTransformer(new DateTimeToStringTransformer(null,null,'d-m-Y'));
  1415.             }
  1416.             else    
  1417.             if ($tipo=="Biplane\EnumBundle\Form\Type\EnumType")
  1418.             {
  1419.                 if (isset($atributos['attr']['class']))
  1420.                 {
  1421.                     $class = str_replace('spinbox-input', '', $atributos['attr']['class']);
  1422.                     if ($class)
  1423.                         $atributos['attr']['class']=$class;
  1424.                     else
  1425.                         unset($atributos['attr']['class']);
  1426.                 }    
  1427. /*                if (isset($atributos['enum_class']))
  1428.                 {
  1429.                     $atributos['choices'] = $atributos['enum_class']::getReadables();
  1430.                     unset($atributos['enum_class']);
  1431.                 }*/
  1432.                 $builder->add($nombre,'Biplane\EnumBundle\Form\Type\EnumType',$atributos);
  1433.             }
  1434.             else    
  1435.             {    
  1436.                 $builder->add($nombre,$tipo,$atributos);        
  1437.             }    
  1438.         }    
  1439.         return $builder->getForm();
  1440.     }
  1441.     
  1442.     private function getEnumFilterData($enumClass, $valor)
  1443.     {
  1444.         try
  1445.         {
  1446.                 $enum = $enumClass::create($valor);
  1447.         }
  1448.         catch (\Exception $exc)
  1449.         {
  1450.             if (is_numeric($valor))
  1451.                 $enum = $enumClass::create((int)$valor);
  1452.         }
  1453.         return $enum;
  1454.     }
  1455.     /* 
  1456.      * MÉTODOS ASOCIADOS A LA ACCIÓN NEW
  1457.      */
  1458.     public function newAction($rol, $routeClassName)
  1459.     {
  1460.         $this->setInitialValues($rol, $routeClassName);
  1461.         $this->accion = 'CREATE';
  1463.         if (!$this->allowActionExecution())
  1464.         {
  1465.             return $this->render('@crud\\accesDenied.html.twig');
  1466.         }
  1467.         
  1468.         
  1469.         $entity = $this->createEntity();
  1470.             
  1471.         $this->setValuesBeforeForm($entity);
  1473.         $params = $this->comunParamsForForm($entity);
  1474.         $this->formulario = $this->buildForm($params);
  1476.         $paramsForTwigNew = $this->newParamsForTwig($entity); 
  1477.         return $this->render($this->twigNewName, $paramsForTwigNew);        
  1478.     }
  1480.     protected function newParamsForTwig($entity)
  1481.     {
  1482.         $params= array(
  1483.             'rol'            => $this->rol,
  1484.             'routeClassName' => $this->routeClassName,
  1485.             'contenedor'     => $this->routeClassName,
  1486.             'entity'         => $entity,
  1487.             'form'           => $this->formulario->createView(),
  1488.             'filterData'     => $this->filterData,
  1489.             'paramsRequest'  => $this->paramsRequest,
  1490.             'widthLabel'     => $this->widthLabel,
  1491.             'formColumns'    => $this->formColumns,
  1492.             'accion'         => $this->accion,
  1493.             'notShow'        => array('_token'=>'1'),
  1494.            );
  1495.        foreach ($this->paramsRequest as $key=>$value)
  1496.        {
  1497.            if ($key!='filterData' && $key!='form')
  1498.            {
  1499.                $params[$key]=$value;
  1500.            }
  1501.        }
  1502.        
  1503.        $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  1504.        $paramsEntity = $entity->newParamsForTwig($paramsForFunctionInEntity);
  1506.        return array_merge($params, $paramsEntity);
  1507.     }
  1509.     /* 
  1510.      * MÉTODOS ASOCIADOS A LA ACCIÓN CREATE
  1511.      */
  1512.     public function backToListAction($rol, $routeClassName, $id)
  1513.     {
  1514.        $this->setInitialValues($rol, $routeClassName);
  1515.        $aClassName = $this->classFullName;
  1516.        if ($id == -1) $id=null;
  1517.        $ruta = $aClassName::backToList($routeClassName, $this->em, $id, $this->filterData );
  1518.        $ruta['params']['rol'] = $rol;
  1519.        return $this->redirect($this->generateUrl($ruta['ruta'], $ruta['params']));
  1520.     }
  1521.     
  1522.     /* 
  1523.      * MÉTODOS ASOCIADOS A LA ACCIÓN CREATE
  1524.      */
  1525.     public function createAction($rol, $routeClassName)
  1526.     {
  1527.         $this->setInitialValues($rol, $routeClassName);
  1528.         $this->accion = 'CREATE';
  1529.         
  1530.         if (!$this->allowActionExecution())
  1531.         {
  1532.             return $this->render('@crud\\accesDenied.html.twig');
  1533.         }
  1535.         $entity = $this->createEntity();
  1537. //        $this->setValuesBeforeForm('CREATE', $entity);
  1539.         $params = $this->comunParamsForForm($entity);
  1540.         $this->formulario = $this->buildForm($params);
  1541.         
  1542.         $this->formulario->handleRequest($this->request);
  1544.         if ($this->formulario->isSubmitted() && $this->formulario->isValid())
  1545.         {
  1546.             $this->setValuesAfterForm($entity);
  1547.             
  1548.             $this->comunSetFileFields($params, $this->formulario, $entity);
  1549.             
  1550.             if ($this->comunCheckConstrains($entity))
  1551.             {        
  1552.                 $this->beforeSave($entity);
  1553.                 if($this->comunPersist($entity))
  1554.                 {
  1555.                     $this->afterSave($entity);
  1556.                     return $this->createRedirectOnSuccess($entity);
  1557.                 }
  1558.             }
  1559.         }
  1560.         else
  1561.             $this->comunSetFormularioErrors();
  1563.         return $this->createRedirectOnFail($entity);
  1564.     }
  1566.     protected function createRedirectOnFail($entity)
  1567.     {
  1568.         if ($this->ajax)
  1569.         {
  1570.             $error = $this->session->getFlashBag()->get('danger');
  1571.             if (count($error)>0)
  1572.               $error = $error[0];
  1573.             else
  1574.               $error="Error";  
  1575.             $data= array('ok'=>false,'error'=>$error);
  1576.             $data = new \Symfony\Component\HttpFoundation\Response(json_encode($data));
  1577.             $data->headers->set('Content-Type', 'application/json');
  1578.             return $data;        
  1579.         }
  1580.         else
  1581.         {
  1582.             $paramsForTwigNew = $this->newParamsForTwig($entity); 
  1583.             return $this->render($this->twigNewName, $paramsForTwigNew);   
  1584.         }
  1585.     }   
  1586.     
  1587.     protected function afterSave($entity)
  1588.     {
  1589.         $params = $this->comunParamsForFunctionsInEntity(); 
  1590.         $params['request'] = $this->request;
  1591.         $params['entity'] = $entity;
  1592.         $params['accion'] = $this->accion;
  1593.         if ($this->accion=='UPDATE')
  1594.             $params['oldEntity'] = $this->oldEntity;
  1595.         
  1596.         $entity->afterSave($params);
  1597.     }
  1598.     
  1599.     protected function beforeSave($entity)
  1600.     {
  1601.         $params = $this->comunParamsForFunctionsInEntity(); 
  1602.         $params['request'] = $this->request;
  1603.         $params['entity'] = $entity;
  1604.         $params['accion'] = $this->accion;
  1605.         if ($this->accion=='UPDATE')
  1606.             $params['oldEntity'] = $this->oldEntity;
  1607.         
  1608.         $entity->beforeSave($params);
  1609.     }
  1610.     
  1611.     protected function createEntity()
  1612.     {
  1613.         $entityFullName = $this->classFullName;
  1614.         
  1615.         return new $entityFullName();
  1616.     }   
  1617.     
  1618.     protected function createRedirectOnSuccess($entity)
  1619.     {
  1620.         if ($this->ajax)
  1621.         {
  1622.             $data= array('ok'=>true,'id'=>$entity->getId(),'txt'=>$entity->__toString());
  1623.             $data = new \Symfony\Component\HttpFoundation\Response(json_encode($data));
  1624.             $data->headers->set('Content-Type', 'application/json');
  1625.             return $data;        
  1626.         }
  1627.         else
  1628.         {
  1629.             $ruta = $entity->createRedirectOnSuccess($this->em, $this->request, $this->routeClassName, $this->rol );
  1630.             return $this->redirect($this->generateUrl($ruta['ruta'], $ruta['params']));
  1631.         }
  1632.     } 
  1633.     
  1634.     protected function setValuesAfterForm($entity)
  1635.     {
  1636.     }
  1637.     
  1638.     protected function setValuesBeforeForm($entity)
  1639.     {
  1640.     }
  1641.     
  1642.     /* 
  1643.      * MÉTODOS ASOCIADOS A LA ACCIÓN SHOW
  1644.      */
  1645.     public function showAction($rol, $id, $routeClassName, $tab=-1)
  1646.     {
  1647.         $this->setInitialValues($rol, $routeClassName);
  1648.         $this->accion = 'SHOW';
  1649.         $entity = $this->em->getRepository($this->bundleName.'\\Entity\\'.$this->className)->find($id);
  1650.         if (!$entity) 
  1651.           throw new \RuntimeException($this->translator->trans(
  1652.                                                      'error.instance_not_found',
  1653.                                                      array('%className%' => $this->routeClassName.'/'.$this->className,
  1654.                                                            '%id%'        => $id),
  1655.                                                      'crud'));
  1657.         if (!$this->allowActionExecution('SHOW', $entity))
  1658.         {
  1659.             return $this->render('@crud\\accesDenied.html.twig');
  1660.         }
  1661.         
  1662.         $paramsForTwigShow = $this->showCreateParamsForTwig($entity);
  1663.         $paramsForTwigShow['tab']=$tab;
  1665.         return $this->render($this->twigShowName, $paramsForTwigShow);        
  1666.     }
  1667.     
  1668.     protected function showCreateParamsForTwig($entity)
  1669.     {
  1670.        $className = $this->classFullName; 
  1671.        $page = $this->request->get('page');
  1673.        $params= array(
  1674.            'routeClassName'            => $this->routeClassName,
  1675.            'rol' => $this->rol,
  1676.            //'readableSingularClassName' => $this->readableSingularClassName,
  1677.            'entity'                    => $entity,
  1678.            'booleans' => $this->booleans,
  1679.            'paramsRequest'  => $this->paramsRequest, 
  1680.            'widthLabel' => $this->widthLabel,
  1681.            'showColumns' => $this->showColumns,
  1682.            'editInIndex' => $this->editInIndex,
  1683.            'deleteInIndex' => $this->deleteInIndex,
  1684.         );
  1685.        foreach ($this->paramsRequest as $key=>$value)
  1686.            if ($key!='filterData')
  1687.                $params[$key]=$value;
  1689.        $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  1690.        $paramsForFunctionInEntity['entity'] = $entity;
  1691.        $paramsForFunctionInEntity['showIdInForm'] = $this->showIdInForm;
  1693.        $params['showFields'] = $this->showGetFields($entity);
  1695.        $paramsEntity = $entity->getParamsForShowTwig($this->comunParamsForFunctionsInEntity());
  1697.        return array_merge($params, $paramsEntity);
  1698.     }
  1699.     
  1700.     /* 
  1701.      * MÉTODOS ASOCIADOS A LA ACCIÓN EDIT
  1702.      */
  1703.     public function editAction($rol, $id, $routeClassName)
  1704.     {
  1705.         $this->setInitialValues($rol, $routeClassName);
  1706.         $this->accion = 'UPDATE';
  1707.         
  1708.         $entity = $this->em->getRepository($this->bundleName.'\\Entity\\'.$this->className)->find($id);
  1709.         if (!$entity) 
  1710.           throw new \RuntimeException($this->translator->trans(
  1711.                                                      'error.instance_not_found',
  1712.                                                      array('%className%' => $this->routeClassName.'/'.$this->className,
  1713.                                                            '%id%'        => $id),
  1714.                                                      'crud'));
  1715.         
  1716.         if (!$this->allowActionExecution($entity))
  1717.         {
  1718.             return $this->render('@crud\\accesDenied.html.twig');
  1719.         }
  1720.         
  1721.         $this->setValuesBeforeForm($entity);        
  1723.         $params = $this->comunParamsForForm($entity);
  1724.         $this->formulario = $this->buildForm($params);
  1725.         
  1726.         $paramsForTwigEdit = $this->editParamsForTwig($entity); 
  1727.         return $this->render($this->twigEditName, $paramsForTwigEdit);        
  1728.     }
  1730.     protected function editParamsForTwig($entity)
  1731.     {
  1732.         $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  1733.  
  1734.         $paramsEntity = $entity->editParamsForTwig($paramsForFunctionInEntity);
  1736.         $params= array(
  1737.             'rol'           => $this->rol,
  1738.             'routeClassName' => $this->routeClassName,
  1739.             'contenedor'     => $this->routeClassName,
  1740.             'entity'         => $entity,
  1741.             'form'           => $this->formulario->createView(),
  1742.             'filterData'     => $this->filterData,
  1743.             'paramsRequest'  => $this->paramsRequest,
  1744.             'widthLabel'     => $this->widthLabel,
  1745.             'formColumns'    => $this->formColumns,
  1746.             'accion'         => $this->accion,
  1747.             'editInIndex'    => $this->editInIndex,
  1748.             'deleteInIndex'    => $this->deleteInIndex,
  1749.             'notShow'        => array('_token'=>'1'),
  1750.         );
  1751.         foreach ($this->paramsRequest as $key=>$value)
  1752.             if ($key!='filterData')
  1753.                 $params[$key]=$value;
  1755.         return array_merge($params, $paramsEntity);
  1756.     }
  1758.     /* 
  1759.      * MÉTODOS ASOCIADOS A LA ACCIÓN UPDATE
  1760.      */
  1761.     public function updateAction($rol, $id, $routeClassName)
  1762.     {
  1763.         $this->setInitialValues($rol, $routeClassName);
  1764.         $this->accion = 'UPDATE';
  1766.         $entity = $this->em->getRepository($this->bundleName.'\\Entity\\'.$this->className)->find($id);
  1767.         if (!$entity) 
  1768.           throw new \RuntimeException($this->translator->trans(
  1769.                                                      'error.instance_not_found',
  1770.                                                      array('%className%' => $this->routeClassName.'/'.$this->className,
  1771.                                                            '%id%'        => $id),
  1772.                                                      'crud'));
  1774.         if (!$this->allowActionExecution($entity))
  1775.         {
  1776.             return $this->render('@crud\\accesDenied.html.twig');
  1777.         }
  1778.         
  1779.         $this->oldEntity = clone $entity;
  1781.         $params = $this->comunParamsForForm($entity);
  1782.         $this->formulario = $this->buildForm($params);
  1784.         $this->formulario->handleRequest($this->request);
  1786.         if ($this->formulario->isSubmitted() && $this->formulario->isValid())
  1787.         {
  1788.             $this->setValuesAfterForm($entity);
  1790.             $deleteFiles = $this->comunSetFileFields($params, $this->formulario, $entity);
  1792.             if ($this->comunCheckConstrains($entity))
  1793.             {        
  1794.                 $this->beforeSave($entity);
  1795.                 if($this->comunPersist($entity))
  1796.                 {
  1797.                     $this->deleteFiles($entity, $deleteFiles);
  1798.                     $this->afterSave($entity);
  1799.                     return $this->updateRedirectOnSuccess($entity);
  1800.                 }
  1801.             }  
  1802.         }
  1803.         else
  1804.         {
  1805.           $this->comunSetFormularioErrors();
  1806.         }
  1807.         
  1808.         return $this->updateRedirectOnFail($entity);        
  1809.     }
  1811.     protected function updateRedirectOnFail($entity)
  1812.     {
  1813.         if ($this->ajax)
  1814.         {
  1815.             $error = $this->session->getFlashBag()->get('danger');
  1816.             if (count($error)>0)
  1817.               $error = $error[0];
  1818.             else
  1819.               $error="Error";  
  1820.             $data= array('ok'=>false,'error'=>$error);
  1821.             $data = new \Symfony\Component\HttpFoundation\Response(json_encode($data));
  1822.             $data->headers->set('Content-Type', 'application/json');
  1823.             return $data;        
  1824.         }
  1825.         else
  1826.         {
  1827.             $paramsForTwigEdit = $this->editParamsForTwig($entity); 
  1828.             return $this->render($this->twigEditName, $paramsForTwigEdit);        
  1829.         }
  1830.     }   
  1831.     
  1832.     protected function comunSetFormularioErrors()
  1833.     {
  1834.         $childs = $this->formulario->getIterator();
  1835.         $childs = $childs->getIterator();
  1836.         $error = '';
  1837.         $childs->next();
  1838.         while ($error=='' && $child = $childs->current())
  1839.         {
  1840.             $errors = $child->getErrors();
  1841.             if (count($errors)>0)
  1842.             {    
  1843.                 $fieldName = $this->translator
  1844.                                ->trans($this->routeClassName.'.fields.'.$child->getName(), array(), 'crud');
  1845.                 $errorMessage = $errors[0]->getMessage();
  1846.                 $fieldValue = $errors[0]->getMessageParameters();
  1847.                 $fieldValue = $fieldValue['{{ value }}'];
  1848.                 $this->session->getFlashBag()
  1849.                                      ->set('danger', $fieldName.': '.$errorMessage.' "'.$fieldValue.'"');
  1850.                 $error = 'error';
  1851.             }    
  1852.             $childs->next();
  1853.         } 
  1854.     }
  1855.     
  1856.     protected function deleteFiles($entity, $deleteFiles)
  1857.     {
  1858.         foreach ($deleteFiles as $fieldName)
  1859.         {
  1860.             //borrar aqui el adjunto anterior
  1861.             $getMethod = 'get'.ucfirst($fieldName);
  1862.             $adjunto = $this->oldEntity->$getMethod();
  1863.             $filename = $adjunto->getRuta().'/'.$adjunto->getArchivoHash();
  1864.             try
  1865.     {
  1866.                 $this->em->remove($adjunto);
  1867.                 $this->em->flush();
  1868.                 unlink($filename);
  1869.             }
  1870.             catch (\Exception $exc) {}
  1871.         }
  1872.     }
  1873.     
  1874.     protected function updateRedirectOnSuccess($entity)
  1875.     {
  1876.         if ($this->ajax)
  1877.         {
  1878.             $data= array('ok'=>true,'id'=>$entity->getId());
  1879.             $data = new \Symfony\Component\HttpFoundation\Response(json_encode($data));
  1880.             $data->headers->set('Content-Type', 'application/json');
  1881.             return $data;        
  1882.         }
  1883.         else
  1884.         {
  1885.             $ruta = $entity->updateRedirectOnSuccess($this->em, $this->request, $this->routeClassName, $this->rol );
  1886.             return $this->redirect($this->generateUrl($ruta['ruta'], $ruta['params']));
  1887.         }
  1888.     } 
  1889.     
  1890.     /* 
  1891.      * MÉTODOS ASOCIADOS A LA ACCIÓN DELETE
  1892.      */
  1893.     public function deleteAction($rol, $id, $routeClassName)
  1894.     {
  1895.         $this->setInitialValues($rol, $routeClassName);
  1896.         $this->accion='DELETE';
  1897.         
  1898.         
  1900.         $entity = $this->em->getRepository($this->bundleName.'\\Entity\\'.$this->className)->find($id);
  1901.         if (!$entity) 
  1902.           throw new \RuntimeException($this->translator->trans(
  1903.                                                      'error.instance_not_found',
  1904.                                                      array('%className%' => $this->routeClassName.'/'.$this->className,
  1905.                                                            '%id%'        => $id),
  1906.                                                      'crud'));
  1908.         if (!$this->allowActionExecution($entity))
  1909.         {
  1910.             return $this->render('@crud\\accesDenied.html.twig');
  1911.         }
  1912.         
  1913.         $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  1915.         if($entity->checkNonReferentialIntegrityConstrains($paramsForFunctionInEntity))
  1916.         {
  1917.            $this->beforeDelete($entity, $paramsForFunctionInEntity);
  1918.         
  1919.            if($this->comunRemove($entity))
  1920.            {
  1921.                $this->afterDelete($entity, $paramsForFunctionInEntity);
  1922.                return $this->deleteRedirectOnSuccess($entity);
  1923.            }
  1924.            else{
  1925.                return $this->deleteRedirectOnFail($entity);
  1926.         }
  1927.         }
  1928.         else {
  1929.            return $this->deleteRedirectOnFail($entity);
  1930.         }
  1931.     }
  1932.     
  1933.     protected function afterDelete($entity, $params = null)
  1934.     {
  1935.         
  1936.     }
  1937.     
  1938.     protected function beforeDelete($entity, $params)
  1939.     {
  1940.        $entity->beforeDelete($params);
  1941.     }   
  1942.    
  1943.     protected function deleteRedirectOnSuccess($entity)
  1944.     {
  1945.         if ($this->ajax)
  1946.         {    
  1947.             $data= array('ok'=>true,'id'=>$entity->getId(),'txt'=>$entity->__toString());
  1948.             $data = new \Symfony\Component\HttpFoundation\Response(json_encode($data));
  1949.             $data->headers->set('Content-Type', 'application/json');
  1950.             return $data;        
  1951.         }
  1952.         else
  1953.         {
  1954.             $ruta = $entity->deleteRedirectOnSuccess($this->em, $this->request, $this->routeClassName, $this->rol );
  1955.             return $this->redirect($this->generateUrl($ruta['ruta'], $ruta['params']));
  1956.         }
  1957.     }   
  1958.     
  1959.     protected function deleteRedirectOnFail($entity)
  1960.     {
  1961.         if ($this->ajax)
  1962.         {
  1963.             $error = $this->session->getFlashBag()->get('danger');
  1964.             if (count($error)>0)
  1965.               $error = $error[0];
  1966.             else
  1967.               $error="Error";  
  1968.             $data= array('ok'=>false,'error'=>$error);
  1969.             $data = new \Symfony\Component\HttpFoundation\Response(json_encode($data));
  1970.             $data->headers->set('Content-Type', 'application/json');
  1971.             return $data;            
  1972.         }
  1973.         else
  1974.         {
  1975.            $ruta = $entity->deleteRedirectOnFail($this->em, $this->request, $this->routeClassName, $this->rol );
  1976.            return $this->redirect($this->generateUrl($ruta['ruta'], $ruta['params']));
  1977.         }
  1978.     }   
  1979.     
  1980.     public function paginatorAction($rol, $routeClassName, $page)
  1981.     {
  1982.        $this->setInitialValues($rol, $routeClassName);
  1983.        $aClassName = $this->classFullName;
  1984.        $ruta = $aClassName::paginator($routeClassName, $page, $this->filterData );
  1985.        return $this->redirect($this->generateUrl($ruta['ruta'], $ruta['params']));
  1986.     }
  1987.     
  1988.     public function getNestedAction($bundleName, $className, $fieldName, $value, $sel=-1)
  1989.     {
  1990.         $em = $this ->em;
  1991.         if ($value==-1)
  1992.             $childs = $em->getRepository($bundleName.'\\Entity\\'.$className)->findAll();
  1993.         else
  1994.         {
  1995.             $childs = $em->getRepository($bundleName.'\\Entity\\'.$className)->createQueryBuilder('p')
  1996.                            ->leftJoin('p.'.$fieldName,$fieldName)
  1997.                            ->where($fieldName.'.id='.$value)
  1998.                            ->getQuery()->getResult();
  1999.         }    
  2000.         return $this->render('@crud\Common\comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  2001.     }
  2002.     
  2003.     public function getDependientesAction($className, $fieldName, $value, $sel=-1)
  2004.     {
  2005.         $className = str_replace('()','\\',$className);
  2007.         $em = $this ->em;
  2008.         if ($value==-1)
  2009.             $childs = $em->getRepository($className)->findAll();
  2010.         else
  2011.         {
  2012.             $childs = $em->getRepository($className)->createQueryBuilder('p')
  2013.                            ->leftJoin('p.'.$fieldName,$fieldName)
  2014.                            ->where($fieldName.'.id='.$value)
  2015.                            ->getQuery()->getResult();
  2016.         }    
  2017.         return $this->render('@crud\Common\comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  2018.     }
  2019.     
  2020.     public function getAllItemsAction($routeClassName, $sel=-1)
  2021.     {
  2022.         $this->setInitialValues($routeClassName);
  2023.         $items = $this->em->getRepository($this->bundleName.'\\Entity\\'.$this->className)->findAll();
  2024.         return $this->render('@crud\Common\comboreloaded.html.twig', array("entities"=>$items, 'value'=>$sel));
  2025.     }
  2026.     
  2027.     protected function excelCreateParamsForTwig()
  2028.     {
  2029.         $params = $this->indexParamsForTwig();
  2030.         
  2031.         $params['indexFields'] = $this->excelGetFields(); 
  2032.  
  2033.         return $params;
  2034.     }
  2036.     public function excelAction($rol, $routeClassName)
  2037.     {
  2038.         $this->setInitialValues($rol, $routeClassName);
  2039.         $this->accion='INDEX';
  2040.         if (!$this->allowActionExecution())
  2041.         {
  2042.             return $this->render('@crud\\accesDenied.html.twig');
  2043.         }
  2045.         $paramsForFunctionInEntity = $this->comunParamsForFunctionsInEntity();
  2046.         $paramsForFunctionInEntity['showIdInForm'] = $this->showIdInForm;
  2048.         $this->indexPrepareFilterForm($paramsForFunctionInEntity);
  2049.         $paramsForFunctionInEntity['filterForm']= $this->formularioFiltro;
  2050.         $this->entities = $this->indexLoadEntities($paramsForFunctionInEntity);
  2052.         $spreadSheet = $this->generateSpreadSheet();
  2053.         $contentType = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
  2054.         $xlsxWriter = new Xlsx($spreadSheet);            
  2056.         $fileName = str_replace(' ','',$this->translator->trans($this->translatorBase.'.plural', [], 'crud')).'.xlsx';
  2057.         $response = new StreamedResponse();
  2058.         $response->headers->set('Content-Type', $contentType);
  2059.         $response->headers->set('Content-Disposition', 'attachment;filename="'.$fileName.'"');
  2060.         $response->setPrivate();
  2061.         $response->headers->addCacheControlDirective('no-cache', true);
  2062.         $response->headers->addCacheControlDirective('must-revalidate', true);
  2063.         $response->setCallback(function() use ($xlsxWriter) {
  2064.             $xlsxWriter->save('php://output');
  2065.         });
  2067.         return $response;            
  2068.     }
  2069.     
  2070.     protected function getExcelValue($entity, $field)
  2071.     {
  2072.         if (is_object($entity))
  2073.         {
  2074.             return $entity->getFieldValue($field['nombre']);
  2075.         }
  2076.         else
  2077.         {
  2078.             return $entity[$field['nombre']];
  2079.         }
  2080.     }
  2081.     
  2082.     protected function generateSpreadSheet()
  2083.     {
  2084. //        $fields = $this->excelGetFields();
  2085.         $params = $this->excelCreateParamsForTwig();
  2086.         $fields = $params['indexFields'];
  2087.         
  2088.         $spreadSheet = new Spreadsheet();
  2089.         $sheet = $spreadSheet->getActiveSheet();
  2090.         $sheet->setCellValue('A1', $this->translator->trans($this->translatorBase.'.plural', [], 'crud'))->mergeCells('A1:D1');
  2091.         $sheet->getStyle('A1')->getFont()->setBold(true);
  2092.         $sheet->getStyle('A1')->getFont()->setSize(16);
  2094.         $col = 'A';
  2095.         foreach ($fields as $field)
  2096.         {
  2097.             $sheet->setCellValue($col.'3', $field['label']);
  2098.             $sheet->getStyle($col.'3')->getFont()->setBold(true);
  2099.             $sheet->getStyle($col.'3')->getFont()->setSize(12);
  2100.             $col++;
  2101.         }
  2102.         $row = 4;
  2103.         foreach ($this->entities as $entity)
  2104.         {
  2105.             $col = 'A';
  2106.             foreach ($fields as $field)
  2107.             {
  2108.                 $value = $this->getExcelValue($entity, $field);
  2109.                 if (is_object($value))
  2110.                 {
  2111.                     if ($value instanceof \DateTime)
  2112.                     {
  2113.                         $value = $value->format('Y/m/d');
  2114.                     }
  2115.                     else
  2116.                     {
  2117.                         $value = $value->__toString();
  2118.                     }
  2119.                 }
  2120.                 $sheet->setCellValue($col.$row, $value);
  2121.                 $col++;
  2122.             }
  2123.             $row++;
  2124.         }
  2125.         return $spreadSheet;
  2126.     }
  2127.     
  2128.     protected function getParameter(string $name): array|bool|string|int|float|\UnitEnum|null
  2129.     {
  2130.         if (isset($_ENV[$name]))
  2131.         {
  2132.             $value = $_ENV[$name];
  2133.         }
  2134.         else
  2135.         {
  2136.             $value = parent::getParameter($name);
  2137.             if (!$value)
  2138.             {
  2139.                 throw new \Exception('Parameter '.$name.' is not defined');
  2140.             }
  2141.         }
  2142.         return $value;
  2143.     }
  2144.     
  2145.     protected function getFormulario($entity)
  2146.     {
  2147.         $formulario = array();
  2148.         $R = new \ReflectionClass($this->classFullName);
  2149.         $fields = $R->getProperties(\ReflectionProperty::IS_PRIVATE);
  2150.         $properties = $this->em->getClassMetadata($this->classFullName)->fieldMappings;
  2151.         $association = $this->em->getClassMetadata($this->classFullName)->associationMappings;
  2152.         foreach ($fields as $field)
  2153.         {
  2154.             $fieldname = $field->name;
  2155.             $label = $this->translator->trans($this->routeClassName.'.fields.'.$fieldname, array(), 'crud');
  2156.             if ($label == $this->routeClassName.'.fields.'.$fieldname)
  2157.             {
  2158.                 $label = $this->translator->trans($this->translatorBase.'.fields.'.$fieldname, array(), 'crud');
  2159.             }
  2160.             if (isset($properties[$field->name]))
  2161.             {
  2162.                 $prop = $properties[$fieldname];
  2163.                 if (isset($prop['id']) && $prop['id'] && (!isset($this->showIdInForm) || !$this->showIdInForm))
  2164.                 {
  2165.                     continue;
  2166.                 }
  2167.                 $formulario[$fieldname]=array(
  2168.                     'nombre'   =>$fieldname,
  2169.                     'tipo'     =>null,
  2170.                     'type'     =>$prop['type'], 
  2171.                     'atributos'=>array(
  2172.                         'label' => $label,
  2173.                         'required' => !$prop['nullable'],
  2174.                         'attr'=>array(
  2175.                             'style'=>'width: 100%'
  2176.                         )
  2177.                     )
  2178.                 );
  2179.                 $tip = $this->translator->trans($this->translatorBase.'.tips.'.$fieldname, array(), 'crud');
  2180.                 if ($tip != $this->translatorBase.'.tips.'.$fieldname)
  2181.                 {
  2182.                     $formulario[$fieldname]['atributos']['attr']['tip']=$tip;
  2183.                 }
  2184.                 if ($prop['type']=='boolean')
  2185.                 {
  2186.                     $formulario[$fieldname]['atributos']['attr']['class'] = 'ace ace-switch ace-switch-5';                
  2187.                 }
  2188.                 if ($prop['type']=='text')
  2189.                 {
  2190.                     $formulario[$fieldname]['atributos']['attr']['rows'] = '2';                
  2191.                 }
  2192.                 if ($prop['type']=='integer' || $prop['type']=='smallint')
  2193.                 {
  2194.                     $formulario[$fieldname]['atributos']['attr']['class'] = 'spinbox-input';                
  2195.                     $formulario[$fieldname]['atributos']['attr']['full_width'] = true;                
  2196.                     $formulario[$fieldname]['tipo'] = 'Symfony\Component\Form\Extension\Core\Type\IntegerType';                
  2197.                 }
  2198.                 if ($prop['type']=='float')
  2199.                 {
  2200.                     if (isset($prop['columnDefinition']) && $prop['columnDefinition']=='dolar')
  2201.                     {    
  2202.                         $formulario[$fieldname]['tipo'] = 'number';
  2203.                         $formulario[$fieldname]['atributos']['attr']['class']='dolar form-control-currency';
  2204.                         $formulario[$fieldname]['atributos']['attr']['min']="0"; 
  2205.                         $formulario[$fieldname]['atributos']['attr']['step']="0.01"; 
  2206.                         $formulario[$fieldname]['atributos']['attr']['data-number-to-fixed']="2"; 
  2207.                         $formulario[$fieldname]['atributos']['attr']['data-number-step-factor']="100"; 
  2208.                         $formulario[$fieldname]['atributos']['attr']['style'].="; text-align: right"; 
  2209.                     }
  2210.                 }
  2211.              /*   if ($prop['type']=='time')
  2212.                 {
  2213.                     $formulario[$fieldname]['tipo'] = 'time';
  2214.                 }*/
  2215.                 if ($prop['type']=='datetime')
  2216.                 {
  2217.                     if (isset($prop['columnDefinition']) && $prop['columnDefinition']=='fecha')
  2218.                     {    
  2219.                         $formulario[$fieldname]['tipo'] = 'date';
  2220.                         $formulario[$fieldname]['atributos']['widget'] = 'single_text';
  2221.                         $formulario[$fieldname]['atributos']['format'] = 'dd-MM-yyyy';
  2222.                         $formulario[$fieldname]['atributos']['attr']['class']='campo_fecha date-picker';
  2223.                         $formulario[$fieldname]['atributos']['attr']['data-date-format']="dd-mm-yyyy"; 
  2224.                         //$formulario[$fieldname]['atributos']['attr']['data-uk-datepicker']="{format:'DD-MM-YYYY', pos: 'bottom'}";
  2225.                     }
  2226.                     
  2227.                     if (isset($prop['columnDefinition']) && $prop['columnDefinition']=='fechaHora')
  2228.                     {    
  2229.                         $formulario[$fieldname]['tipo'] = 'date';
  2230.                         $formulario[$fieldname]['atributos']['attr']['class']='campo_hora_fecha date-picker';
  2231.                         $formulario[$fieldname]['atributos']['attr']['data-date-format']="dd-mm-yyyy"; 
  2232.                         //$formulario[$fieldname]['atributos']['attr']['data-uk-datepicker']="{format:'DD-MM-YYYY', pos: 'bottom'}";
  2233.                     }
  2234.                 }
  2236.                 if (isset($prop['columnDefinition']))
  2237.                 {                    
  2238.                     switch ($prop['columnDefinition'])
  2239.                     {
  2240.                         case 'geometria_punto':
  2241.                             $formulario[$fieldname]['tipo'] = 'geometria';
  2242.                             $formulario[$fieldname]['atributos']['attr']['class']='geometria_punto';                                     
  2243.                         break;    
  2244.                         case 'geometria_poligono':
  2245.                             $formulario[$fieldname]['tipo'] = 'geometria';
  2246.                             $formulario[$fieldname]['atributos']['attr']['class']='geometria_poligono';                                     
  2247.                         break;    
  2248.                         case 'email':
  2249.                             $formulario[$fieldname]['tipo'] = 'Symfony\Component\Form\Extension\Core\Type\EmailType';
  2250.                         break;    
  2251.                     }
  2252.                 }   
  2253.             }
  2254.             if (isset($association[$field->name]))
  2255.             {    
  2256.                 $prop = $association[$fieldname];
  2257.                 if ((isset($prop['id']) && $prop['id'] && !$this->showIdInForm) 
  2258.                     || (!$prop['isOwningSide'] && !$entity->getNotOwningSideInForm($field->name)))
  2259.                 {
  2260.                     continue;
  2261.                 }
  2262.                 $formulario[$fieldname]=array(
  2263.                     'nombre'   =>$fieldname,
  2264.                     'tipo'     =>null,
  2265.                     'type'     =>'association',
  2266.                     'atributos'=>array(
  2267.                         'label' => $label,
  2268.                         'required' => (isset($prop['joinColumns'][0]['nullable']) && !$prop['joinColumns'][0]['nullable']) || (isset($prop['joinTable']['joinColumns'][0]['nullable']) && !$prop['joinTable']['joinColumns'][0]['nullable']),
  2269.                         'placeholder' => $this->translator->trans('choice_value.empty_value', array(), 'crud'),
  2270.                         'empty_data' => null,
  2271.                         'attr' => array(
  2272.                             'class'=>'chosen-select',
  2273.                             'style'=>'width: 100%',
  2274.                             'data-placeholder'=>$this->translator->trans('choice_value.empty_value',array(),'crud')
  2275.                         )
  2276.                     )
  2277.                 );
  2278.                 if (isset($prop['joinColumns'][0]['columnDefinition']))
  2279.                 {
  2280.                     if (strpos($prop['joinColumns'][0]['columnDefinition'],'relation/')===0)
  2281.                     {
  2282.                         $formulario[$fieldname]['atributos']['attr']['relation']=str_replace('relation/','',$prop['joinColumns'][0]['columnDefinition']);
  2283.                     }
  2284.                     if (strpos($prop['joinColumns'][0]['columnDefinition'],'dependiente{')===0)
  2285.                     {
  2286.                         $dependiente = str_replace('dependiente{','',$prop['joinColumns'][0]['columnDefinition']);
  2287.                         $dependiente = str_replace('}','',$dependiente);
  2288.                         $dependiente = explode(',', $dependiente);
  2289.                         if (count($dependiente)==3)
  2290.                         {
  2291.                             $dependiente[1] = str_replace('\\','()',$dependiente[1]);
  2292.                             $formulario[$fieldname]['atributos']['attr']['dependiente_parent']=$dependiente[0];
  2293.                             $formulario[$fieldname]['atributos']['attr']['dependiente_class']=$dependiente[1];
  2294.                             $formulario[$fieldname]['atributos']['attr']['dependiente_field']=$dependiente[2];
  2295.                         }
  2296.                         else
  2297.                         {
  2298.                             throw new \RuntimeException('Crud - The column definition for property "'.$fieldname.'" is not correct.');
  2299.                         }
  2300.                     }
  2301.                 }
  2302.                 $tip = $this->translator->trans($this->translatorBase.'.tips.'.$fieldname, array(), 'crud');
  2303.                 if ($tip != $this->translatorBase.'.tips.'.$fieldname)
  2304.                 {
  2305.                     $formulario[$fieldname]['atributos']['attr']['tip']=$tip;
  2306.                 }
  2307.                 if($prop['type']==8) //Many to many association
  2308.                 {
  2309.                     $formulario[$fieldname]['atributos']['attr']['class'] = 'chosen-select form-control';
  2310.                 }
  2311.                 else
  2312.                 if($prop['type']==4) //One to Many (not owning side)
  2313.                 {
  2314.                     $formulario[$fieldname]['tipo'] = 'collection';
  2315.                     $formulario[$fieldname]['atributos']['entry_type'] = $prop['targetEntity'];
  2316.                     $formulario[$fieldname]['atributos']['entry_options'] = ['label' => false];
  2317.                     $formulario[$fieldname]['atributos']['allow_add'] = true;
  2318.                     $formulario[$fieldname]['atributos']['attr']['containerclass'] = 'full-row';
  2319.                     unset($formulario[$fieldname]['atributos']['placeholder']);
  2320.                 }
  2321.                 else
  2322.                 {
  2323.                     if(isset($prop['joinColumns'][0]['columnDefinition']) && $prop['joinColumns'][0]['columnDefinition']=='chosen')
  2324.                     {
  2325.                         $formulario[$fieldname]['atributos']['attr']['class'] = 'chosen-select form-control';
  2326.                     }
  2327.                 }
  2328.                 if($this->isAdjunto($prop['targetEntity']))
  2329.                 {
  2330.                     $formulario[$fieldname]['tipo'] = 'Symfony\Component\Form\Extension\Core\Type\FileType';
  2331.                     unset($formulario[$fieldname]['atributos']['placeholder']);
  2332.                     unset($formulario[$fieldname]['atributos']['empty_data']);
  2333.                     $formulario[$fieldname]['atributos']['mapped'] = false;
  2334.                     $formulario[$fieldname]['atributos']['attr']['class'] = $prop['targetEntity'];
  2335.                     unset($formulario[$fieldname]['atributos']['attr']['style']);
  2336.                     unset($formulario[$fieldname]['atributos']['attr']['data-placeholder']);
  2337.                     if (isset($prop['joinColumns'][0]['columnDefinition']))
  2338.                     {
  2339.                         $formulario[$fieldname]['atributos']['attr']['accept'] = $prop['joinColumns'][0]['columnDefinition'];
  2340.                     }
  2341.                 }   
  2342.             }  
  2343.         }  
  2344.         return $formulario;
  2345.     }   
  2347.     public function quickUpdateAction()
  2348.     {
  2349.         $ret= array('ok'=>true);
  2350.         try
  2351.         {
  2352.             $data = $this->request->get('quick');
  2353.             $entity = $this->em->getRepository('App\\Entity\\'.$data['class'])->find($data['id']);
  2354.             if ($entity)
  2355.             {
  2356.                 if ($data['association'])
  2357.                 {
  2358.                     $valor = $this->em->getRepository('App\\Entity\\'.$data['association'])->find($data['valor']);
  2359.                 }
  2360.                 else
  2361.                 {
  2362.                     $valor = $data['valor'];
  2363.                 }
  2364.                 $setFunction = 'set'.ucfirst($data['field']); 
  2365.                 $entity->$setFunction($valor);
  2366.                 $this->em->persist($entity);
  2367.                 $this->em->flush();
  2368.             }
  2369.             else
  2370.             {
  2371.                 $ret['ok'] = false;
  2372.                 $ret['msg'] = 'No se encontro a un '.$data['class'].' con el identificador envíado'; 
  2373.             }
  2374.         }
  2375.         catch(\Exception $exc)
  2376.         {
  2377.             $ret['ok'] = false;
  2378.             $ret['msg'] = $exc->getMessage(); 
  2379.         }
  2380.         $data = new \Symfony\Component\HttpFoundation\Response(json_encode($ret));
  2381.         $data->headers->set('Content-Type', 'application/json');
  2382.         return $data;        
  2383.     }
  2384.     
  2385.     public function quickDeleteAction($className, $id)
  2386.     {
  2387.         try
  2388.         {
  2389.             $habilidad = $this->em->getRepository('App\\Entity\\'.$className)->find($id);
  2390.             $this->em->remove($habilidad);
  2391.             $this->em->flush();
  2392.             $ret = ['ok'=>true];
  2393.         }
  2394.         catch (\Exception $exc)
  2395.         {
  2396.             $ret = ['ok'=>false, 'msg'=>$exc->getMessage()];
  2397.         }
  2398.         $data = new \Symfony\Component\HttpFoundation\Response(json_encode($ret));
  2399.         $data->headers->set('Content-Type', 'application/json');
  2400.         return $data;        
  2401.     }
  2402.         
  2403. }