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;
}