function contact(Application $app, Request $request)
{
$form = $app['form.factory']->create(new ContactForm($app['currentUser']));
if ('POST' == $request->getMethod()) {
$form->bind($request);
if ($form->isValid()) {
$data = $form->getData();
$contact = new ContactSupportModel();
$contact->setSubject($data['subject']);
$contact->setMessage($data['message']);
$contact->setEmail($data['email']);
if ($app['currentUser']) {
$contact->setUserAccountId($app['currentUser']->getId());
}
$contact->setIp($_SERVER['REMOTE_ADDR']);
$contact->setBrowser($_SERVER['HTTP_USER_AGENT']);
if ($request->request->get('url')) {
$contact->setIsSpamHoneypotFieldDetected(true);
}
$contactSupportRepository = new ContactSupportRepository();
$contactSupportRepository->create($contact);
if (!$contact->getIsSpam()) {
$contact->sendEmailToSupport($app, $app['currentUser']);
}
$app['flashmessages']->addMessage('Your message has been sent');
return $app->redirect('/contact');
}
}
return $app['twig']->render('index/index/contact.html.twig', array('form' => $form->createView()));
}
public function loadById($id)
{
global $DB;
$stat = $DB->prepare("SELECT contact_support.* FROM contact_support " . " WHERE contact_support.id =:id ");
$stat->execute(array('id' => $id));
if ($stat->rowCount() > 0) {
$cs = new ContactSupportModel();
$cs->setFromDataBaseRow($stat->fetch());
return $cs;
}
}
public function fetchAll()
{
$this->buildStart();
$this->build();
$this->buildStat();
$results = array();
while ($data = $this->stat->fetch()) {
$cList = new ContactSupportModel();
$cList->setFromDataBaseRow($data);
$results[] = $cList;
}
return $results;
}
