View GitHub Repository crm

Schedule Inspection
Subscribe

Code Duplication    Length = 5-6 lines in 2 locations

src/Oro/Bundle/SalesBundle/Entity/Repository/OpportunityRepository.php 1 location

@@ 122-126 (lines=5) @@
119 
        $qb->select('IDENTITY(opportunity.status) as name, SUM(opportunity.budgetAmountValue) as budget')
120 
            ->groupBy('opportunity.status');
121 

                                

                                                            

                                    122
                                    
                                    
        if ($dateStart && $dateEnd) {

                                

                                                            

                                    123
                                    
                                    
            $qb->where($qb->expr()->between('opportunity.createdAt', ':dateFrom', ':dateTo'))

                                

                                                            

                                    124
                                    
                                    
                ->setParameter('dateFrom', $dateStart)

                                

                                                            

                                    125
                                    
                                    
                ->setParameter('dateTo', $dateEnd);

                                

                                                            

                                    126
                                    
                                    
        }

                                

                                                            

                                    127
                                    
                                    

                                

                                                            

                                    128
                                    
                                    
        if ($owners) {

                                

                                                            

                                    129
                                    
                                    
            QueryUtils::applyOptimizedIn($qb, 'opportunity.owner', $owners);

                                

                                                                        

                

                                                            

                    
src/Oro/Bundle/SalesBundle/Entity/Repository/SalesFunnelRepository.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 161-166 (lines=6) @@
                                
                            


                                                            

                                    158
                                    
                                    
        $this->joinWorkflowStep($queryBuilder, 'workflowStep');

                                

                                                            

                                    159
                                    
                                    
        $queryBuilder->groupBy('workflowStep.name');

                                

                                                            

                                    160
                                    
                                    

                                

                                                            

                                    161
                                    
                                    
        if ($dateFrom && $dataTo) {

                                

                                                            

                                    162
                                    
                                    
            $queryBuilder

                                

                                                            

                                    163
                                    
                                    
                ->where($queryBuilder->expr()->between('funnel.createdAt', ':dateFrom', ':dateTo'))

                                

                                                            

                                    164
                                    
                                    
                ->setParameter('dateFrom', $dateFrom)

                                

                                                            

                                    165
                                    
                                    
                ->setParameter('dateTo', $dataTo);

                                

                                                            

                                    166
                                    
                                    
        }

                                

                                                            

                                    167
                                    
                                    

                                

                                                            

                                    168
                                    
                                    
        return $queryBuilder;

                                

                                                            

                                    169
                                    
                                    
    }