Advertisement
Guest User

Untitled

a guest
Dec 15th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. bookpermit
  2.  
  3. id | userfk | bookfk |
  4. 1 | 6 | 6 |
  5. 2 | 6 | 7 |
  6. 3 | 7 | 7 |
  7. 4 | 8 | 8 |
  8. books
  9.  
  10. id | name | uerfk |
  11. 1 | xyz1 | 6 |
  12. 2 | xyz2 | 7 |
  13. 3 | xyz3 | 8 |
  14.  
  15. display_book_by_permission:
  16. pattern: /displaybookbypermission/{user}
  17. defaults: { _controller: xxxBundle:Books:display, _format: ~ }
  18. requirements:
  19. _method: GET
  20.  
  21. /**
  22. * @Route("/displaybookbypermission/{user}/{bookpermit}")
  23. * @ParamConverter("user", class="xxxxBundle:Users")
  24. * @ParamConverter("bookpermit", class="xxxxBundle:BookPermit")
  25. * @Template()
  26. */
  27. public function displayAction(Request $request, $user, $bookpermit)
  28. {
  29. $em = $this->getDoctrine()->getManager();
  30. $bookLists= $em->getRepository("xxxBundle:Books")->findBy(
  31. array(
  32. "usersfk" => $user,
  33. "usersfk" => $bookpermit
  34. )
  35. );
  36.  
  37. $data = array();
  38.  
  39. foreach ($bookLists as $bookList)
  40. {
  41.  
  42. array_push($data, $this->serialize($bookLists));
  43. }
  44.  
  45.  
  46. $response = new Response(json_encode($data), 200);
  47. $response->headers->set('Content-Type', 'application/json');
  48.  
  49. return $response;
  50. }
  51.  
  52. http://localhost:88/books/web/app_dev.php/displaybookbypermission/6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement