/**
* Displays a form to create a new Message entity.
*
* @Route("", name="contact_index")
* @Method("GET")
*/
public function newAction()
{
$message = new Message();
if (null !== ($clientId = $this->get('session')->get('client-id'))) {
if (null !== ($client = $this->getDoctrine()->getRepository('AppBundle:Client')->find($clientId))) {
$message->setClient($client);
}
}
$form = $this->createCreateForm($message);
return $this->render(':Contact:index.html.twig', array('message' => $message, 'form' => $form->createView()));
}
/**
* @param ObjectManager $manager
* @throws \Doctrine\DBAL\DBALException
*/
protected function loadMessages(ObjectManager $manager)
{
echo "\nMessages ... ";
$stmt = $this->connection->executeQuery('SELECT * FROM message');
foreach ($stmt->fetchAll() as $record) {
$message = new Message();
if ($record['client_id']) {
$message->setClient($this->getReference('client-' . $record['client_id']));
}
$message->setEmailAddress($record['client_id'] ? $record['client_id'] : '');
$message->setMessage($record['message']);
$message->setCreated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['created_at'])));
$message->setUpdated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['updated_at'])));
$manager->persist($message);
}
}
