src/Admin/FluxoCaixaAdmin.php line 16

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace App\Admin;
  7. use Sonata\AdminBundle\Admin\AbstractAdmin;
  8. use Sonata\AdminBundle\Datagrid\DatagridMapper;
  9. use Sonata\AdminBundle\Datagrid\ListMapper;
  10. use Sonata\AdminBundle\Form\FormMapper;
  11. use Sonata\AdminBundle\Route\RouteCollection;
  12. use Sonata\AdminBundle\Show\ShowMapper;
  13. use Sonata\Form\Type\DatePickerType;
  14. use Sonata\Form\Type\DateRangePickerType;
  16. final class FluxoCaixaAdmin extends BaseAdmin
  17. {
  18.     protected $perPageOptions = [64, 128, 256, 2000];
  20.     protected $datagridValues = [
  21.         '_page'         => 1,
  22.         '_sort_order'   => 'ASC',
  23.         '_sort_by'      => 'dataExtrato',
  24.         '_per_page'     => 2000
  25.     ];
  27.     protected $maxPerPage = 2000;
  29.     public function getExportFields()
  30.     {
  31.         return array(
  32.             'Data' =>'dataExtrato',
  33.             'Descrição'=>'descricao',
  34.             'NF/Comprovante' => 'tipoDocumento',
  35.             'Conta' => 'classificacao',
  36.             'Valor' => 'valor',
  37.         );
  38.     }
  40.     public function getDataSourceIterator()
  41.     {
  42.         $datasourceit = parent::getDataSourceIterator();
  43.         $datasourceit->setDateTimeFormat('d/m/Y'); //change this to suit your needs
  44.         return $datasourceit;
  45.     }
  47. //    public function getExportFormats()
  48. //    {
  49. //        return ['html'];
  50. //    }
  53.     public function createQuery($context = 'list')
  54.     {
  55.         $query = parent::createQuery($context);
  57.         if(!isset($_GET['filter'])){
  59.             $today = new \DateTime('now');
  60.             $fromTime = new \DateTime( $today->format('Y') . '-' . $today->format('m') . '-01');
  61.             $toTime = new \DateTime($fromTime->format('Y-m-d') . ' first day of next month');
  62.             $fromTime->setTime(0,0,0);
  63.             $toTime->setTime(0,0,0);
  65.             $query->andWhere($query->getRootAliases()[0] . '.dataExtrato >= :fromTime');
  66.             $query->andWhere($query->getRootAliases()[0] . '.dataExtrato <= :toTime');
  67.             // $query->andWhere($query->expr()->notIn($query->getRootAliases()[0] . '.classificacao', '175,174,173,167,160,159,158'));
  68.             $query->setParameter('fromTime', $fromTime->format('Y-m-d'));
  69.             $query->setParameter('toTime', $toTime->format('Y-m-d'));
  70.         }
  72.         return $query;
  73.     }
  75. //    protected function configureDefaultFilterValues(array &$filterValues)
  76. //    {
  77. //        parent::configureDefaultFilterValues($filterValues); // TODO: Change the autogenerated stub
  78. //
  79. //        // display the first page (default = 1)
  80. //        $filterValues['_page'] = 1;
  81. //
  82. //        // reverse order (default = 'ASC')
  83. //        $filterValues['_sort_order'] = 'ASC';
  84. //
  85. //        // name of the ordered field (default = the model's id field, if any)
  86. //        $filterValues['_sort_by'] = 'ordem';
  87. //
  88. //        $filterValues['_per_page'] = 'All';
  89. //
  90. //    }
  92. //    public function getFilterParameters()
  93. //    {
  94. //        $this->datagridValues = array_merge([
  95. //            'ordem' => ['value' => 1],
  96. //        ], $this->datagridValues);
  97. //
  98. //        return parent::getFilterParameters();
  99. //    }
  101.     protected function configureRoutes(RouteCollection $collection)
  102.     {
  103.         parent::configureRoutes($collection); // TODO: Change the autogenerated stub
  105.         $collection->remove("create");
  106.         $collection->remove("delete");
  108.         $collection->add('relatorioContabilidade');
  109.         $collection->add('ordenarFluxo');
  111.     }
  113.     protected function configureBatchActions($actions)
  114.     {
  115.         return parent::configureBatchActions($actions); // TODO: Change the autogenerated stub
  116.         unset($actions['edit']);
  117.         unset($actions['delete']);
  118.     }
  120.     protected function configureDatagridFilters(DatagridMapper $datagridMapper): void
  121.     {
  122.         $datagridMapper
  123.             //->add('tipo')
  124.             ->add('dataExtrato', 'doctrine_orm_datetime_range', ['field_type'=> DateRangePickerType::class])
  125.             ->add('ordem')
  126.             ;
  127.     }
  129.     protected function configureListFields(ListMapper $listMapper): void
  130.     {
  131.         $this->setTemplate('list', 'FluxoCaixa/list.html.twig');
  133.         $listMapper
  134.             
  135.             ->add('ordem', null, ['label'=>'Ordem', 'template'=>'FluxoCaixa/input_ordem_list.html.twig'])
  136.             ->add('dataExtrato', null, ['label'=>'Data'])
  137.             ->add('descricao', null, ['label'=>'Descrição','template'=>'FluxoCaixa/descricao_list.html.twig'])
  138.             ->add('tipoDocumento', null, ['label'=>'N.F/Comprovante'])
  139.             ->add('classificacao', null, ['label'=>'Conta'])
  140.             ->add('valorFormatado', null, ['label'=>'Valor','template'=>'FluxoCaixa/valor_list.html.twig'])
  141.             ->add('id', null, ['label'=>'ID'])
  142.             ->add('link', null, ['label'=>'Link','template'=>'FluxoCaixa/link_financeiro.html.twig'])
  143.             ->add('_action', null, [
  144.                 'actions' => [
  145.                     'show' => [],
  146.                     'edit' => [],
  147.                     //'delete' => [],
  148.                 ],
  149.             ]);
  150.     }
  152.     protected function configureFormFields(FormMapper $formMapper): void
  153.     {
  154.         $formMapper
  155.             ->add('ordem')
  156.             ->add('dataExtrato', DatePickerType::class,['label'=>'Data do extrato', 'required'=>true])
  157.             ;
  158.     }
  160.     protected function configureShowFields(ShowMapper $showMapper): void
  161.     {
  162.         $showMapper
  163.             ->add('id')
  164.             ->add('tipo')
  165.             ->add('createdAt')
  166.             ->add('dataExtrato')
  167.             ;
  168.     }
  170.     public function preUpdate($object)
  171.     {
  172.         $object->setUserUltimaAlteracao($this->getUserLogado());
  173.         parent::preUpdate($object); // TODO: Change the autogenerated stub
  174.     }
  176. }