Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. UPDATE mySock s1
  2. LEFT JOIN mySock s2
  3. ON s1.parentId = s2.id
  4. SET
  5. s1.status = 1
  6. s1.mylevel = (s2.mylevel + 1),
  7. s1.parentString = CONCAT(s2.parentString, ':' CONCT(s1.id as char))
  8. WHERE
  9. s1.zz = 0;
  10.  
  11. public function updateParentNew($idParent)
  12. {
  13. return $this->createQueryBuilder('s1')
  14. ->update('MyBundle:Stock', 's1')
  15. ->leftJoin(''MyBundle:Stock', 's2', 'WITH', 's2.id = s1.parentId')
  16. ->set('s1.zz', 1)
  17. ->set('s1.leveltask', 's2.leveltask + 1')
  18. ->set('s1.parentString', '?par2_string')
  19. ->where('s1.zz = 0')
  20. ->andWhere('s1.parentId = ?par1')
  21. ->setParameter('par1', $idParent)
  22. ->setParameter('par2_string', s2.parentString + ':' + (string)s1.id)
  23. ->getQuery()->getSingleScalarResult();
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement