/** * Update an organisation * * @param \Xali\Bundle\UserBundle\Entity\User $manager the manager we want * to assign * @param \Xali\Bundle\OrganisationBundle\Entity\Organisation $organisation * the organisation to update * @return string */ public function updateOrganisation($manager, $organisation) { if (!empty($manager) && $manager instanceof User) { $result = null; $managerOrganisation = $manager->getCamp() == null ? null : $manager->getCamp()->getOrganisation(); //user belong to an other organisation if ($managerOrganisation != null && $managerOrganisation->getId() != $organisation->getId()) { return "form.error.belong_other_org"; } $sql = "UPDATE organisation\n SET manager_id = ?, name = ?, dateofcreation = ?\n WHERE organisation.id = ?\n "; try { $stmt = $this->_em->getConnection()->prepare($sql); $stmt->execute(array($manager->getId(), $organisation->getName(), $organisation->getDateOfCreation()->format('Y-m-d'), $organisation->getId())); } catch (UniqueConstraintViolationException $e) { $result = "form.error.violation_key"; } catch (\Exception $e) { $result = "form.error.other_error"; } } else { //Manager's email adress is invalid $result = "form.error.invalid_email"; } return $result; }
/** * Insert or update an organisation according to $organisation's id * * @param Xali\Bundle\OrganisationBundle\Entity\Organisation $organisation * the organisation * @param Xali\Bundle\UserBundle\Entity\User $manager * the manager user want to assign * @return string error message if there is * @author Anthony Bocci Anthony Bocci <*****@*****.**> */ public function insertOrUpdate($organisation, $manager) { $em = $this->getDoctrine()->getManager(); $orgRepo = $em->getRepository('XaliOrganisationBundle:Organisation'); //Insert if (empty($organisation->getId())) { return $orgRepo->insertOrganisation($manager, $organisation); } else { //Update return $orgRepo->updateOrganisation($manager, $organisation); } }