Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ->SELECT('e.firstName, e.middleName, e.familyName, nd.name')
- ->FROM(\HRPresence\Entity\PersonalCalendarDay::class, 'pcd')
- ->leftJoin('pcd.nomDay', 'nd')
- ->leftJoin('pcd.personalCalendar', 'pcp')
- ->leftJoin('pcp.employee', 'e')
- ->WHERE('nd.id != 383')
- ->andWhere('pcd.day = :pcdDay')
- ->setParameter('pcdDay', $day)
- ->andWhere('pcp.period = :pcpYearMonth')
- ->setParameter('pcpYearMonth', "$year-$month-01");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement