@@ -73,17 +73,17 @@ discard block |
||
| 73 | 73 | |
| 74 | 74 | $qb = $this->createQueryBuilder('e'); |
| 75 | 75 | $qb->andWhere("e.priority >= $range_end ") |
| 76 | - ->andWhere("e.priority <= $range_start ") |
|
| 77 | - ->andWhere('e.event = :event') |
|
| 78 | - ->setParameter('event',$event) |
|
| 79 | - ->setMaxResults(1) |
|
| 80 | - ->orderBy('e.priority','ASC'); |
|
| 76 | + ->andWhere("e.priority <= $range_start ") |
|
| 77 | + ->andWhere('e.event = :event') |
|
| 78 | + ->setParameter('event',$event) |
|
| 79 | + ->setMaxResults(1) |
|
| 80 | + ->orderBy('e.priority','ASC'); |
|
| 81 | 81 | |
| 82 | 82 | $result=$qb->getQuery()->getResult(); |
| 83 | 83 | if(count($result)){ |
| 84 | - return $result[0]->getPriority() -1; |
|
| 84 | + return $result[0]->getPriority() -1; |
|
| 85 | 85 | }else{ |
| 86 | - return $range_start; |
|
| 86 | + return $range_start; |
|
| 87 | 87 | } |
| 88 | 88 | |
| 89 | 89 | } |
@@ -96,13 +96,13 @@ discard block |
||
| 96 | 96 | $qb = $this->createQueryBuilder('e'); |
| 97 | 97 | |
| 98 | 98 | $qb->andWhere("e.priority >= $range_end ") |
| 99 | - ->andWhere("e.priority <= $range_start ") |
|
| 100 | - ->andWhere('e.priority '.($up ? '>' : '<' ).' :pri') |
|
| 101 | - ->andWhere('e.event = :event') |
|
| 102 | - ->setParameter('event',$pluginEventHandler->getEvent()) |
|
| 103 | - ->setParameter('pri', $pluginEventHandler->getPriority() ) |
|
| 104 | - ->setMaxResults(1) |
|
| 105 | - ->orderBy('e.priority', ($up ? 'ASC':'DESC' ) ); |
|
| 99 | + ->andWhere("e.priority <= $range_start ") |
|
| 100 | + ->andWhere('e.priority '.($up ? '>' : '<' ).' :pri') |
|
| 101 | + ->andWhere('e.event = :event') |
|
| 102 | + ->setParameter('event',$pluginEventHandler->getEvent()) |
|
| 103 | + ->setParameter('pri', $pluginEventHandler->getPriority() ) |
|
| 104 | + ->setMaxResults(1) |
|
| 105 | + ->orderBy('e.priority', ($up ? 'ASC':'DESC' ) ); |
|
| 106 | 106 | |
| 107 | 107 | $result=$qb->getQuery()->getResult(); |
| 108 | 108 | |
@@ -60,7 +60,7 @@ |
||
| 60 | 60 | */ |
| 61 | 61 | protected $appConfig; |
| 62 | 62 | |
| 63 | - /** |
|
| 63 | + /** |
|
| 64 | 64 | * get query builder. |
| 65 | 65 | * |
| 66 | 66 | * @param array $searchData |
@@ -114,7 +114,7 @@ |
||
| 114 | 114 | */ |
| 115 | 115 | public function delete($News) |
| 116 | 116 | { |
| 117 | - $this->createQueryBuilder('n') |
|
| 117 | + $this->createQueryBuilder('n') |
|
| 118 | 118 | ->update() |
| 119 | 119 | ->set('n.rank', 'n.rank - 1') |
| 120 | 120 | ->where('n.rank > :rank') |