Doctrs\SonataImportBundle\Repository\DefaultRepository::pagerfanta()

Complexity

Conditions	5
Paths	5

Size

Total Lines	18
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function pagerfanta(Request $request) {
        $sql = $this->createQueryBuilder('data');
        $sql->select('data');
        switch ($request->get('type', 'all')) {
            case 'success':
                $sql->where('data.status = 1 or data.status = 2');
                break;
            case 'new':
                $sql->where('data.status = 1');
                break;
            case 'update':
                $sql->where('data.status = 2');
                break;
            case 'error':
                $sql->where('data.status = 3');
                break;
        }
        return $sql->getQuery();
    }