public function imagesAction(Request $request, $id) { //$images = $this->getImagesAction(); $em = $this->getDoctrine()->getEntityManager(); $images = $em->createQueryBuilder()->select('b')->from('RARWebBundle:PropertyImages', 'b')->where('b.property_id = :userId')->setParameter('userId', $id)->getQuery()->getResult(); /*---- start - update images of properties -----*/ $em = $this->getDoctrine()->getEntityManager(); $property = $em->getRepository('RARWebBundle:Property')->find($id); if (!$property) { throw $this->createNotFoundException('Unable to find Blog post.'); } if (is_null($id)) { $postData = $request->get('$id'); $property = $postData['id']; } $em = $this->getDoctrine()->getEntityManager(); $property = $em->getRepository('RARWebBundle:Property')->find($id); if (!$property) { $property = new Property(); throw $this->createNotFoundException('No product found for idss ' . $id); } if ($request->getMethod() == 'POST') { $file = $_FILES['file']['name']; $file1 = $_FILES['file']['tmp_name']; move_uploaded_file($_FILES["file"]["tmp_name"], "Property/" . $_FILES["file"]["name"]); $propertyName = $this->get('request')->request->get('propertyName'); $realtor = new PropertyImages(); $realtor->setPropertyId($id); $realtor->setImageUrl($file); $em = $this->getDoctrine()->getEntityManager(); $em->persist($realtor); $em->flush(); } /*---- end - Update images of properties -----*/ return $this->render('RARAdminBundle:Property:images.html.twig', array('property' => $property, 'images' => $images)); }
public function showPropertyImagesAction(Request $request, $id) { if ($request->getMethod() == 'POST') { $file = $_FILES['file']['name']; $file1 = $_FILES['file']['tmp_name']; move_uploaded_file($_FILES["file"]["tmp_name"], "Property/" . $_FILES["file"]["name"]); $realtor = new PropertyImages(); $realtor->setPropertyId($id); $realtor->setImageUrl($file); $realtor->setIsMain(0); $em = $this->getDoctrine()->getEntityManager(); $em->persist($realtor); $em->flush(); } $em = $this->getDoctrine()->getEntityManager(); $images = $em->createQueryBuilder()->select('PropertyImages')->from('RARWebBundle:PropertyImages', 'PropertyImages')->leftJoin('RARWebBundle:Property', 'property', "WITH", "property.id=PropertyImages.property_id")->where('property.id = :userId')->setParameter('userId', $id)->getQuery()->getResult(); $property = $em->getRepository('RARWebBundle:Property')->find($id); return $this->render('RARWebBundle:Page:realtorPropertyImages.html.twig', array('images' => $images, 'property' => $property)); }