sonata admin daterange

gistfile1.aw

            ->add('orderdatefrom', 'doctrine_orm_callback',
                array
                (
                    'callback' => function(\Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery $queryBuilder, $alias, $field, $options)
                    {
                        if(!isset($options['value']) || !$options['value'])
                        {
                            return;
                        }
                        $value = $options['value'];

                        // set defaults
                        if(empty($value['year']))
                        {
                            return;
                        }
                        if(empty($value['month']))
                        {
                            $value['month'] = 1;
                        }
                        if(empty($value['day']))
                        {
                            $value['day'] = 1;
                        }
                        // new datetime
                        $datetime = new \DateTime();

                        // update date
                        $datetime->setDate($value['year'], $value['month'], $value['day']);

                        $queryBuilder->andWhere(sprintf('%s.orderdate', $alias) . ' >= :orderdatefrom');
                        $queryBuilder->setParameter(":orderdatefrom", $datetime);
                    },
                    'field_type' => 'date',
                    'label' => 'statistic.orderdatefrom'
                )
            )
            ->add('orderdateto', 'doctrine_orm_callback',
                array
                (
                    'callback' => function(\Sonata\DoctrineORMAdminBundle\Datagrid\ProxyQuery $queryBuilder, $alias, $field, $options)
                    {
                        if(!isset($options['value']) || !$options['value'])
                        {
                            return;
                        }
                        $value = $options['value'];

                        // set defaults
                        if(empty($value['year']))
                        {
                            return;
                        }
                        if(empty($value['month']))
                        {
                            $value['month'] = 1;
                        }
                        if(empty($value['day']))
                        {
                            $value['day'] = 1;
                        }
                        // new datetime
                        $datetime = new \DateTime();

                        // update date
                        $datetime->setDate($value['year'], $value['month'], $value['day']);

                        $queryBuilder->andWhere(sprintf('%s.orderdate', $alias) . ' <= :orderdateto');
                        $queryBuilder->setParameter(":orderdateto", $datetime);
                    },
                    'field_type' => 'date',
                    'label' => 'statistic.orderdateto'
                )
            )