|
@@ 17-25 (lines=9) @@
|
| 14 |
|
->getSingleScalarResult(); |
| 15 |
|
} |
| 16 |
|
|
| 17 |
|
public function getRealFromDate(Agreement $agreement) |
| 18 |
|
{ |
| 19 |
|
$date = $this->getEntityManager() |
| 20 |
|
->createQuery('SELECT MIN(w.date) FROM AppBundle:Workday w INNER JOIN w.agreement a WHERE w.agreement = :agreement') |
| 21 |
|
->setParameter('agreement', $agreement) |
| 22 |
|
->getSingleScalarResult(); |
| 23 |
|
|
| 24 |
|
return null === $date ?: new \DateTime($date); |
| 25 |
|
} |
| 26 |
|
|
| 27 |
|
public function getRealToDate(Agreement $agreement) |
| 28 |
|
{ |
|
@@ 27-35 (lines=9) @@
|
| 24 |
|
return null === $date ?: new \DateTime($date); |
| 25 |
|
} |
| 26 |
|
|
| 27 |
|
public function getRealToDate(Agreement $agreement) |
| 28 |
|
{ |
| 29 |
|
$date = $this->getEntityManager() |
| 30 |
|
->createQuery('SELECT MAX(w.date) FROM AppBundle:Workday w INNER JOIN w.agreement a WHERE w.agreement = :agreement') |
| 31 |
|
->setParameter('agreement', $agreement) |
| 32 |
|
->getSingleScalarResult(); |
| 33 |
|
|
| 34 |
|
return null === $date ?: new \DateTime($date); |
| 35 |
|
} |
| 36 |
|
|
| 37 |
|
public function getActivitiesStats(Agreement $agreement) |
| 38 |
|
{ |