public function addcommentajaxAction()
{
$request = $this->getRequest();
if ($request->isPost()) {
$form = new BlogCommentForm();
//trigger data controls
$form->setInputFilter(new BlogCommentInputFilter());
$form->setData($request->getPost());
if ($form->isValid()) {
//$message = new Message();
$utils = new Utils();
$to = EmailCommentConfig::$emailAdressForContact;
$name = $utils->stripTags_replaceHtmlChar_trim($request->getPost('contactnom'), true, true, true);
$company = $utils->stripTags_replaceHtmlChar_trim($request->getPost('contactentreprise'), true, true, true);
$subject = "Contact site web de la part de " . $utils->stripTags_replaceHtmlChar_trim($request->getPost('contactnom'), true, true, true);
$from = $utils->stripTags_replaceHtmlChar_trim($request->getPost('contactemail'), true, true, true);
$contenuid = (int) $utils->stripTags_replaceHtmlChar_trim($request->getPost('contactcontenuid'), true, true, true);
$txt = wordwrap($utils->stripTags_replaceHtmlChar_trim($request->getPost('contacttext'), true, true, true), 70);
$message = new EmailSent();
$message->setRow1($name);
$message->setRow2($company);
$message->setRow3($from);
$message->setMessage($txt);
$message->setDate(date("Y-m-d H:i:s", time()));
$message->setType(TypeMessage::$blog);
$message->setContenuId($contenuid);
$message->setCommentaireStatut(0);
$messageDao = new CommentaireDao();
$messageDao->saveCommentaire($message);
//zend message sendmail
/*$emailMessage = new Message();
$emailMessage->addFrom($from, $name)
->addTo($to)
->setSubject($subject)
->setBody($txt);
$transport = new SendmailTransport();
$transport->send($emailMessage);
*/
//zend message smtp
$messageToSend = new Message();
$messageToSend->addFrom($from, $name)->addTo($to)->setSubject($subject);
$messageToSend->setBody($txt);
$messageToSend->setEncoding("UTF-8");
$transport = new SmtpTransport();
$options = new SmtpOptions(array('name' => EmailCommentConfig::$smtpServerNameForContact, 'host' => EmailCommentConfig::$smtpHostServerForContact, 'port' => EmailCommentConfig::$smtpHostPortForContact, 'connection_class' => EmailCommentConfig::$connectionClassForContact, 'connection_config' => array('username' => EmailCommentConfig::$connectionConfigUsernameForContact, 'password' => EmailCommentConfig::$connectionConfigPwdForContact, 'ssl' => EmailCommentConfig::$connectionConfigSSLForContact)));
$transport->setOptions($options);
$transport->send($messageToSend);
return new JsonModel(array('result' => 'ok'));
} else {
return new JsonModel(array('result' => 'failure', 'error' => $form->getMessages()));
}
}
}
public function saveCommentaire(Commentaire $commentaire)
{
$id = (int) $commentaire->getId();
if (!(bool) $commentaire->getRow1()) {
$commentaire->setRow1("");
}
if (!(bool) $commentaire->getRow2()) {
$commentaire->setRow2("");
}
if (!(bool) $commentaire->getRow3()) {
$commentaire->setRow3("");
}
if (!(bool) $commentaire->getRow4()) {
$commentaire->setRow4("");
}
if (!(bool) $commentaire->getMessage()) {
$commentaire->setMessage("");
}
if (!(bool) $commentaire->getType()) {
$commentaire->setType("blog");
}
if (!(bool) $commentaire->getRang()) {
$commentaire->setRang(0);
}
if (!(bool) $commentaire->getDate()) {
$commentaire->setDate(time());
}
if (!(bool) $commentaire->getCommentaireStatut()) {
$commentaire->setCommentaireStatut(0);
}
if (!(bool) $commentaire->getType()) {
$commentaire->setType("");
}
if (!(bool) $commentaire->getContenuId()) {
$commentaire->setContenuId(0);
}
if (!(bool) $commentaire->getCommentaireId()) {
$commentaire->setCommentaireId(0);
}
if ($id > 0) {
$requete = $this->dbGateway->prepare("\r\n\t\t\t\tUPDATE commentaire \r\n\t\t\t\tSET commentaire_row1 = :row1, \r\n\t\t\t\tcommentaire_row2 = :row2,\r\n\t\t\t\tcommentaire_row3 = :row3,\r\n\t\t\t\tcommentaire_row4 = :row4,\r\n commentaire_msg = :msg,\r\n commentaire_status = :status,\r\n commentaire_contenuid = :contenuid,\r\n commentaire_type = :type,\r\n commentaire_date = :datemsg\r\n\t\t\t\tWHERE commentaire_id = :id\r\n\t\t\t") or die(print_r($this->dbGateway->errors_info()));
$requete->execute(array('id' => $id, 'row1' => $commentaire->getRow1(), 'row2' => $commentaire->getRow2(), 'row3' => $commentaire->getRow3(), 'row4' => $commentaire->getRow4(), 'msg' => $commentaire->getMessage(), 'type' => $commentaire->getType(), 'status' => $commentaire->getCommentaireStatut(), 'contenuid' => $commentaire->getContenuId(), 'datemsg' => $commentaire->getDate()));
} else {
$requete = $this->dbGateway->prepare("INSERT into commentaire(" . "commentaire_row1, " . "commentaire_row2, " . "commentaire_row3, " . "commentaire_row4, " . "commentaire_msg, " . "commentaire_type, " . "commentaire_date, " . "commentaire_status, " . "commentaire_contenuid) " . "values(" . ":rowa, " . ":rowb, " . ":rowc, " . ":rowd, " . ":msg, " . ":type, " . ":datemsg, " . ":status, " . ":contenuid)") or die(print_r($this->dbGateway->error_info()));
$info = $requete->execute(array('rowa' => $commentaire->getRow1(), 'rowb' => $commentaire->getRow2(), 'rowc' => $commentaire->getRow3(), 'rowd' => $commentaire->getRow4(), 'msg' => $commentaire->getMessage(), 'type' => $commentaire->getType(), 'status' => $commentaire->getCommentaireStatut(), 'contenuid' => $commentaire->getContenuId(), 'datemsg' => $commentaire->getDate()));
//var_dump($info);
//exit;
}
}
