Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.54 KB | None | 0 0
  1. ->SELECT('e.firstName, e.middleName, e.familyName, nd.name')
  2.                 ->FROM(\HRPresence\Entity\PersonalCalendarDay::class, 'pcd')
  3.                 ->leftJoin('pcd.nomDay', 'nd')
  4.                 ->leftJoin('pcd.personalCalendar', 'pcp')
  5.                 ->leftJoin('pcp.employee', 'e')
  6.                 ->WHERE('nd.id != 383')
  7.                 ->andWhere('pcd.day = :pcdDay')
  8.                 ->setParameter('pcdDay', $day)
  9.                 ->andWhere('pcp.period = :pcpYearMonth')
  10.                 ->setParameter('pcpYearMonth', "$year-$month-01");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement