Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1.         $testVehicle = $vehicleRepository->createQueryBuilder('v')
  2.                 ->select('v.id', 'v.length', 'v.width', 'v.height', 'v.volume')
  3.                 ->join('v.company', 'company')
  4.                 ->join('company.carnets', 'cr')
  5.                 ->where('v.length >= :cargoLength', 'v.width >= :cargoWidth',
  6.                         'v.height >= :cargoHeight', 'v.volume >= :cargoVolume',
  7.                         'cr.code = 1'
  8.                         )
  9.                 ->setParameter('cargoLength', $cargo->getLength())
  10.                 ->setParameter('cargoWidth', $cargo->getWidth())
  11.                 ->setParameter('cargoHeight', $cargo->getHeight())
  12.                 ->setParameter('cargoVolume', $cargo->getVolume())
  13.                 ->getQuery()
  14.                 ->getResult()
  15.         ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement