/** * This is the edit advertisement page * * @PreAuthorize("hasAnyRole('SUPER_ADMIN', 'CAN_MANAGE_ADVERTISEMENTS')") * @param Request $request * @return \Symfony\Component\HttpFoundation\Response */ public function editAction(Request $request) { $em = $this->getDoctrine()->getEntityManager(); //$this->advertisement->setInstitution($this->institution); $form = $this->createForm(new AdvertisementFormType($em), $this->advertisement); return $this->render('AdminBundle:Advertisement:form.html.twig', array('formAction' => $this->generateUrl('admin_advertisement_update', array('advertisementId' => $this->advertisement->getId())), 'form' => $form->createView(), 'ads_filesystem' => $this->get('advertisement_filesystem'), 'isEditMode' => true, 'step' => (int) $request->get('step', 2))); }
private function updateAdvertisementDenormalizedData(Advertisement $advertisement) { $data['id'] = $advertisement->getId(); $data['institution_id'] = $advertisement->getInstitution()->getId(); $data['advertisement_type_id'] = $advertisement->getAdvertisementType()->getId(); $data['title'] = $advertisement->getTitle(); $data['description'] = $advertisement->getDescription(); $data['date_created'] = $advertisement->getDateCreated() ? $advertisement->getDateCreated()->format('Y-m-d H:i:s') : 'now()'; $data['date_expiry'] = $advertisement->getDateExpiry()->format('Y-m-d H:i:s'); $data['status'] = $advertisement->getStatus(); // TODO - Enhance Saving Process. This can be done in 1 foreach. $collectionClasses = array(); foreach ($advertisement->getAdvertisementPropertyValues() as $each) { $property = $each->getAdvertisementPropertyName(); if ($property->getDataType()->getColumnType() == 'collection') { $data[$property->getName()][] = (int) $each->getValue(); $collectionClasses[$property->getName()] = $property->getDataClass(); } else { $data[$property->getName()] = $each->getValue(); } } $onDuplicatePlaceholder = $columns = $valuesPlaceholder = ''; foreach ($data as $key => $value) { if (is_array($value)) { if (empty($value)) { $data[$key] = ''; continue; } if (!$collectionClasses[$key]) { throw AdvertisementPropertyException::emptyPropertyClass($key); } $qb = $this->em->createQueryBuilder(); $query = $qb->select('a')->from($collectionClasses[$key], 'a')->where($qb->expr()->in('a.id', $value)); $data[$key] = json_encode($query->getQuery()->getResult(Query::HYDRATE_ARRAY)); } $columns .= ",{$key}"; $valuesPlaceholder .= ",:{$key}"; $onDuplicatePlaceholder .= ",{$key} = :{$key}"; } $columns = substr($columns, 1); $valuesPlaceholder = substr($valuesPlaceholder, 1); $onDuplicatePlaceholder = substr($onDuplicatePlaceholder, 1); $query = "INSERT INTO advertisement_denormalized_properties ({$columns}) VALUES({$valuesPlaceholder}) ON DUPLICATE KEY UPDATE {$onDuplicatePlaceholder}"; $result = $this->em->getConnection()->executeQuery($query, $data); }