YEAR() and beberlei/DoctrineExtensions

Question

I have to make requests with YEAR and I installed beberlei/DoctrineExtensions with doctrine command. I added the requested annotations

doctrine:
   orm:
        auto_generate_proxy_classes: '%kernel.debug%'
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true
        dql:
            datetime_functions:
                year: DoctrineExtensions\Query\Mysql\Year

, but it does not work, I have this error:

Attempted to load class "Year" from namespace "DoctrineExtensions\Query\Mysql". Did you forget a "use" statement for another namespace?

The request:

public function groupTypeInterArray(){
    $qb = $this->createQueryBuilder('i')
            ->select('YEAR(i.interventionDate)');
    return $qb->getQuery()->execute();
}

Config Doctrine

# Doctrine Configuration
doctrine:
    dbal:
        driver: pdo_mysql
        host: '%database_host%'
        port: '%database_port%'
        dbname: '%database_name%'
        user: '%database_user%'
        password: '%database_password%'
        charset: UTF8
        # if using pdo_sqlite as your database driver:
        #   1. add the path in parameters.yml
        #     e.g. database_path: '%kernel.project_dir%/var/data/data.sqlite'
        #   2. Uncomment database_path in parameters.yml.dist
        #   3. Uncomment next line:
        #path: '%database_path%'

    orm:
        auto_generate_proxy_classes: '%kernel.debug%'
        naming_strategy: doctrine.orm.naming_strategy.underscore
        auto_mapping: true
        dql:
            datetime_functions:
                Year: DoctrineExtensions\Query\Mysql\Year

I searched all the afternoon, but I didn't find the solution.

Thank you in advance.

enter image description here

Have you install ```beberlei/DoctrineExtensions``` using ```composer require beberlei/DoctrineExtensions``` command — Maulik Savaliya, Oct 11 '18 at 04:42
Can you please check with change "datetime_functions" with "string_functions" — Maulik Savaliya, Oct 11 '18 at 06:27
Can you please share your configuration of doctrine from config.yml? — Maulik Savaliya, Oct 11 '18 at 09:05
Strange, because I have replaced your configuration in my local project and still it's working fine, if you are using linux can you please fire command in terminal: ```la -la vendor/beberlei/DoctrineExtensions/src/Query/Mysql/Year.php``` in your project directory and paste the output over here? — Maulik Savaliya, Oct 11 '18 at 09:20
Okay then can you please check the above file is available in your vendor or not? — Maulik Savaliya, Oct 11 '18 at 09:33
vendor/beberlei/DoctrineExtensions/src/Query/Mysql/Year.php it's ok. And the permission? where should I look? — delph49, Oct 11 '18 at 09:45
okay then open your cmd and then follow the steps: 1. go to your dir 2. execute the command: "dir vendor/beberlei/DoctrineExtensions/src/Query/Mysql/Year.php" (Please check upper case and lower case as window is case insensitive ) 3. Open file in your folder and check permission with right click on it — Maulik Savaliya, Oct 11 '18 at 09:51
I edit my first message with a fot of the permission and The result to the command: Répertoire: D:\Users\delph\Desktop\NetBeansProjects\ProjetMairie6\vendor\beberlei\DoctrineExtensions\src\Query\Mysql Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 10/10/2018 15:55 678 Year.php — delph49, Oct 11 '18 at 09:59
Can you please check if a file is executable or not? Google that how to check file is executable or not in windows.The file should have permission 644. — Maulik Savaliya, Oct 11 '18 at 10:03

score 0 · Answer 1 · answered Jul 08 '19 at 13:35

1.dql: datetime_functions: year: DoctrineExtensions\Query\Mysql\Year ???

2.dql: datetime_functions: Year: DoctrineExtensions\Query\Mysql\Year ???

Maybe dql: datetime_functions: YEAR: DoctrineExtensions\Query\Mysql\Year MONTH: DoctrineExtensions\Query\Mysql\Month DAY: DoctrineExtensions\Query\Mysql\Day

score 0 · Answer 2 · answered Jan 15 '20 at 08:52

0

For me removing the vendor dir and do a fresh composer install solved the problem.

answered Jan 15 '20 at 08:52

24HOURSMEDIA

11
2

score 0 · Answer 3 · answered Apr 02 '20 at 01:06

in the query replace "Year" with "year"

so use the following code instead:

public function groupTypeInterArray(){
    $qb = $this->createQueryBuilder('i')
            ->select('year(i.interventionDate)');
    return $qb->getQuery()->execute();
}

and you also need to change the corresponding line in the doctrine config :

replaces this code

Year: DoctrineExtensions\Query\Mysql\Year

By this code

year: DoctrineExtensions\Query\Mysql\Year

PS : to know which link you have to use to add a function correctly in doctrine config you have to go on this link

YEAR() and beberlei/DoctrineExtensions

3 Answers3