public function updateAction() { if ($this->getRequest()->get('save_new') != null) { $curtainPriceBandRepository = $this->getDoctrine()->getRepository('ElmetSiteBundle:CurtainPriceBand'); $curtainPriceBand = $curtainPriceBandRepository->findOneById($this->getRequest()->get('curtainpriceband_current')); $curtainPrice = new CurtainPrice(); $curtainPrice->setCurtainPriceBand($curtainPriceBand); $curtainPrice->setSize($this->getRequest()->get('size_new')); $curtainPrice->setType($this->getRequest()->get('type_new')); $curtainPrice->setPrice($this->getRequest()->get('price_new')); if ($this->getRequest()->get('curtaineyeletpriceband_new') != "empty") { $curtainEyeletPriceBandRepository = $this->getDoctrine()->getRepository('ElmetSiteBundle:CurtainEyeletPriceBand'); $curtainEyeletPriceBand = $curtainEyeletPriceBandRepository->findOneById($this->getRequest()->get('curtaineyeletpriceband_new')); $curtainPrice->setCurtainEyeletPriceBand($curtainEyeletPriceBand); } $curtainSizes = $this->getCurtainSizes(); $size = $this->getRequest()->get('size_new'); $curtainPrice->setHeight($curtainSizes[$size]->getHeight()); $curtainPrice->setWidth($curtainSizes[$size]->getWidth()); $em = $this->getDoctrine()->getEntityManager(); $em->persist($curtainPrice); $em->flush(); } else { if ($this->getRequest()->get('submit_all') != null) { $em = $this->getDoctrine()->getEntityManager(); $query = $em->createQuery('SELECT cp FROM ElmetSiteBundle:CurtainPrice cp JOIN cp.curtain_price_band cpb WHERE cpb.id = :id'); $query->setParameter('id', $this->getRequest()->get('curtainpriceband_current')); $curtainPrices = $query->getResult(); foreach ($curtainPrices as $curtainPrice) { $curtainPrice->setPrice($this->getRequest()->get('all:price_' . $curtainPrice->getId())); $em->merge($curtainPrice); } $em->flush(); } else { $params = $this->getRequest()->request->all(); $keys = array_keys($params); $id = 0; foreach ($keys as $key) { $param = $params[$key]; if ($param == 'Save') { $index = stripos($key, '_'); $id = substr($key, $index + 1); } } if ($id != 0) { $repository = $this->getDoctrine()->getRepository('ElmetSiteBundle:CurtainPrice'); $curtainPrice = $repository->findOneById($id); $curtainPrice->setPrice($this->getRequest()->get('single:price_' . $id)); $em = $this->getDoctrine()->getEntityManager(); $em->merge($curtainPrice); $em->flush(); } } } return $this->viewAction($this->getRequest()->get('curtainpriceband_current')); }
public function createSecondPrice() { $curtainPriceBand = $this->cpbRepository->findOneById(2); $curtainPrice = new CurtainPrice(); $curtainPrice->setCurtainPriceBand($curtainPriceBand); $curtainPrice->setSize("3ft x 3ft"); $curtainPrice->setType("CaravanWindow"); $curtainPrice->setPrice(130.95); $curtainPrice->setWidth(3.0); $curtainPrice->setHeight(3.0); $this->em->persist($curtainPrice); $this->em->flush(); return $curtainPrice; }