<?php namespace App\Admin; use App\Entity\Flux; use App\Entity\Groupe; use App\Entity\Prestataire; use App\Entity\User; use App\Enum\MoyenEnum; use App\Exception\BalanceInsufficientException; use App\Utils\OperationUtils; use Sonata\AdminBundle\Admin\AbstractAdmin; use Sonata\AdminBundle\Datagrid\DatagridMapper; use Sonata\AdminBundle\Datagrid\ListMapper; use Sonata\AdminBundle\Form\FormMapper; use Sonata\AdminBundle\Route\RouteCollection; use Symfony\Component\Form\Extension\Core\Type\CheckboxType; use Symfony\Component\Form\Extension\Core\Type\ChoiceType; use Symfony\Component\Form\Extension\Core\Type\DateType; use Symfony\Component\Form\Extension\Core\Type\HiddenType; use Symfony\Component\Form\Extension\Core\Type\MoneyType; use Symfony\Component\Security\Core\Security; use Symfony\Component\Validator\Constraints\Regex; use Symfony\Component\HttpFoundation\RedirectResponse; /** * Administration des cotisations. * * KOHINOS : Outil de gestion de Monnaie Locale Complémentaire * * @author Julien Jorry <julien.jorry@gmail.com> */ class CotisationAdmin extends AbstractAdmin { protected $baseRouteName = 'cotisation'; protected $baseRoutePattern = 'cotisation'; protected $security; protected $operationUtils; protected $translator; protected $datagridValues = [ '_sort_order' => 'DESC', '_sort_by' => 'createdAt', '_per_page' => 250, ]; protected $maxPerPage = 250; protected $perPageOptions = [50, 100, 250, 500, 1000]; public function setOperationUtils(OperationUtils $operationUtils) { $this->operationUtils = $operationUtils; } public function setSecurity(Security $security) { $this->security = $security; } /** * {@inheritdoc} */ protected function configureDatagridFilters(DatagridMapper $datagridMapper): void { $em = $this->getConfigurationPool()->getContainer()->get('doctrine')->getManager(); $datagridMapper ->add('cotisationInfos.annee', null, ['label' => 'Année']) ->add('montant', null, ['label' => 'Montant']) ->add('groupe', 'doctrine_orm_callback', [ 'label' => 'Groupe local', 'callback' => function ($queryBuilder, $alias, $field, $value) { if (!$value['value']) { return; } $queryBuilder ->leftJoin('App\Entity\CotisationPrestataire', 'c', 'WITH', $alias . '.id = c.id') ->leftJoin('App\Entity\CotisationAdherent', 'ca', 'WITH', $alias . '.id = ca.id') ->leftJoin('c.expediteur', 'e') ->leftJoin('ca.expediteur', 'f') ->andWhere('e.groupe = :groupe OR f.groupe = :groupe') ->setParameter('groupe', $value['value']); return true; }, 'advanced_filter' => false, 'show_filter' => true, 'field_type' => ChoiceType::class, 'field_options' => [ 'choices' => $em->getRepository(Groupe::class)->findBy(['enabled' => true], ['name' => 'ASC']), 'choice_label' => 'name', 'placeholder' => 'Indifférent', 'expanded' => false, 'multiple' => false, ], ]) ->add('cotisationInfos.recu', null, [ 'label' => 'Recu ?', 'show_filter' => true, 'advanced_filter' => false, ]) ; } /** * {@inheritdoc} */ protected function configureFormFields(FormMapper $formMapper) { $cotisation = $this->getSubject(); $now = new \DateTime(); $em = $this->getConfigurationPool()->getContainer()->get('doctrine')->getManager(); $formMapper ->with('Cotisation', ['class' => 'col-md-8']) ->add('parenttype', HiddenType::class, [ 'data' => Flux::TYPE_COTISATION, ]) ->add('operateur', HiddenType::class, [ 'data' => $this->security->getUser(), 'data_class' => null, 'entity_class' => User::class, 'em' => $em, ]) ->add('montant', MoneyType::class, [ 'label' => 'Montant en euro(s)', 'scale' => 2, 'required' => true, 'constraints' => [ new Regex(['pattern' => '/[0-9]{1,}(\.[0-9]{1,2})?/']), ], 'empty_data' => (float) 0.0, ]) ->add('role', HiddenType::class, [ 'data' => $this->security->getUser() ? $this->security->getUser()->getGroups()[0]->__toString() : '', ]) ->add('destinataire', HiddenType::class, [ 'data' => $em->getRepository(Prestataire::class)->findOneBy(['mlc' => true]), 'data_class' => null, 'entity_class' => Prestataire::class, 'em' => $em, ]) ->add('moyen', ChoiceType::class, [ 'required' => true, 'choices' => MoyenEnum::getAvailableTypes(), 'choice_label' => function ($choice) { return MoyenEnum::getTypeName($choice); }, ]) ; if (null != $this->security->getUser() && ($this->security->isGranted('ROLE_SUPER_ADMIN') || $this->security->isGranted('ROLE_TRESORIER'))) { $formMapper ->add('cotisationInfos.recu', CheckboxType::class, [ 'label' => 'Paiement bien reçu', 'required' => false, ]); } $formMapper->end() ->with('Date', ['class' => 'col-md-4']) ->add('cotisationInfos.annee', null, [ 'label' => 'Année', 'required' => false, ]) ->add('cotisationInfos.debut', DateType::class, [ 'label' => 'Date de début', 'widget' => 'single_text', 'required' => true, // 'html5' => false, 'format' => 'yyyy-MM-dd', 'attr' => ['class' => 'js-datepicker'], ]) ->add('cotisationInfos.fin', DateType::class, [ 'label' => 'Date de fin', 'widget' => 'single_text', // 'html5' => false, 'format' => 'yyyy-MM-dd', 'attr' => ['class' => 'js-datepicker'], ]) ->end() ; } protected function configureRoutes(RouteCollection $collection) { $collection->remove('delete'); if (null != $this->security->getUser() && !($this->security->isGranted('ROLE_TRESORIER') || $this->security->isGranted('ROLE_SUPER_ADMIN') || $this->security->isGranted('ROLE_COMPTOIR'))) { $collection->clearExcept(['list', 'export']); } } /** * {@inheritdoc} */ protected function configureListFields(ListMapper $listMapper) { // In TAV env, block access to standard cotisations admin. if ($this->getConfigurationPool()->getContainer()->getParameter('tav_env')) { $url = $this->getConfigurationPool()->getContainer()->get( 'router' )->generate( 'sonata_admin_dashboard' ); $redirection = new RedirectResponse( $url ); $redirection->send(); } unset($this->listModes['mosaic']); $listMapper ->add('id', 'text', [ 'template' => '@kohinos/bundles/SonataAdminBundle/Block/cotisation_obj.html.twig', ]) ->add('expediteur.groupe.name', null, [ 'label' => 'Groupe', ]) ->add('cotisationInfos.annee', null, [ 'label' => 'Année', ]) ->add('montant', 'decimal', [ 'label' => 'Montant', 'attributes' => ['fraction_digits' => 2], ]) ->add('moyen', null, [ 'label' => 'Moyen', ]) ->add('cotisationInfos.debut', null, [ 'label' => 'Crée le', ]) ->add('cotisationInfos.fin', null, [ 'label' => 'Expire le', ]) ->add('cotisationInfos.recu', null, [ 'label' => 'Paiement bien reçu ?', 'editable' => true, ]) ->add('operateurAndRole', null, [ 'label' => 'Opérateur', ]) ->add('_action', null, [ 'actions' => [ 'edit' => [], ], ]) ; } public function getDataSourceIterator() { $iterator = parent::getDataSourceIterator(); $iterator->setDateTimeFormat('d/m/Y H:i:s'); //change this to suit your needs return $iterator; } public function prePersist($cotisation) { try { if ($cotisation->getCotisationInfos()->isRecu()) { $this->operationUtils->executeOperations($cotisation); } } catch (\Exception $e) { throw new BalanceInsufficientException($e->getMessage()); } } /** Overwrite create methode to catch custom error */ public function create($object) { $em = $this->getConfigurationPool()->getContainer()->get('doctrine')->getManager(); try { $em->beginTransaction(); $res = parent::create($object); $em->getConnection()->commit(); return $res; } catch (BalanceInsufficientException $e) { $em->getConnection()->rollBack(); $this->getConfigurationPool()->getContainer()->get('session')->getFlashBag()->add('error', $e->getMessage()); return null; } } public function getExportFields() { return [ 'Id' => 'expediteur', 'Groupe' => 'expediteur.groupe.name', 'Annee' => 'cotisationInfos.annee', 'Type' => 'type', 'Montant' => 'montant', 'Moyen' => 'moyen', 'Crée le' => 'cotisationInfos.debut', 'Expire le' => 'cotisationInfos.fin', 'Reçu ?' => 'cotisationInfos.recu', 'Operateur' => 'operateurAndRole', 'Reference' => 'reference', 'Date' => 'created_at', ]; } }