function sendThankyouMail(Contribution $contribution)
{
$name = $contribution->getName();
$pName = $contribution->getPoiName();
$add = $contribution->getPoiAddress();
$cat = $contribution->getPoiCategory();
$mes = $contribution->getPoiMessage();
$subject = "Thank you for your Contribution ({$pName})";
$message = "\n <html>\n <head>\n <title>Feedback Received</title>\n </head>\n <body>\n <img src='http://mymap.com.np/img/banner.jpg'><br>\n <p>Dear {$name},</p>\n <p>Your following contributionhas been received and acknowledged.</p>\n <p><b>POI Name : </b>{$pName}</p>\n <p><b>POI Address : </b>{$add}</p>\n <p><b>POI Category : </b>{$cat}</p>\n <p><b>Message : </b>{$mes}</p>\n <p>Your contribution will be processed and will be available in the next update. Thank you for your contribution!</p>\n <p>Regards, </p>\n <p><a href='http://mymap.com.np'>MyMap - Offline map for Nepal </a> developers.</p>\n </body>\n </html>\n ";
$message = str_replace("\n.", "\n..", $message);
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <*****@*****.**>' . "\r\n";
mail($contribution->getEmail(), $subject, $message, $headers);
}
public function add(Contribution $contribution)
{
$name = $contribution->getName();
$email = $contribution->getEmail();
$poiName = $contribution->getPoiName();
$poiAddress = $contribution->getPoiAddress();
$poiCategory = $contribution->getPoiCategory();
$poiMessage = $contribution->getPoiMessage();
$poiRequest = $contribution->getPoiRequest();
date_default_timezone_set('Asia/Kathmandu');
$date = date('Y-m-d H:i:s');
$SQL = "INSERT INTO " . $this->TABLE_NAME . " (name,email,poiName,poiAddress,poiCategory,poiMessage,poiRequest,date)\n VALUES ('{$name}','{$email}','{$poiName}','{$poiAddress}','{$poiCategory}','{$poiMessage}','{$poiRequest}','{$date}')";
if ($result = mysql_query($SQL, $this->connection)) {
return mysql_insert_id($this->connection);
} else {
return false;
}
}
