function new_pay_mail($order_id)
{
$mainframe = JFactory::getApplication();
require_once JPATH_SITE . DS . "components" . DS . "com_socialads" . DS . "helper.php";
// require when we call from backend
$socialadshelper = new socialadshelper();
$db = JFactory::getDBO();
$query = "SELECT p.payee_id,u.username, u.email,p.status FROM #__ad_payment_info as p, #__users as u\n\t\t\t\t\t\t\tWHERE p.payee_id=u.id\n\t\t\t\t\t\t\tAND p.id=" . $order_id;
$db->setQuery($query);
$result = $db->loadObject();
$body = JText::_('PAY_PAYMENT_BODY');
$find = array('[SEND_TO_NAME]', '[ORDERID]', '[SITENAME]', '[STATUS]');
if ($result->status == 'P') {
$orderstatus = JText::_('ADS_INVOICE_STATUS_PENDING');
} else {
if ($result->status == 'RF') {
$orderstatus = JText::_('SA_REFUNDED');
} else {
$orderstatus = JText::_('ADS_INVOICE_AMOUNT_CANCELLED');
}
}
$recipient = $result->email;
$siteName = $mainframe->getCfg('sitename');
$displayOrderid = sprintf("%05s", $order_id);
$replace = array($result->username, $displayOrderid, $siteName, $orderstatus);
$body = str_replace($find, $replace, $body);
$subject = JText::sprintf("SA_STATUS_CHANGED_MAIL_SUBJECT", $displayOrderid);
$status = $socialadshelper->sendmail($recipient, $subject, $body, '', 0, "");
}
function adminAdApprovalEmail($ad_id)
{
$db = JFactory::getDBO();
$query = 'SELECT a.`ad_id`,a.`ad_image`,a.`ad_title`,a.`ad_body`,a.`ad_url2` FROM `#__ad_data` as a
WHERE a.ad_id=' . $ad_id;
//. ' AND a.ad_approved=1';
$db->setQuery($query);
$oldAd = $db->loadObject();
jimport('joomla.utilities.utility');
$user = JFactory::getUser();
global $mainframe;
$mainframe = JFactory::getApplication();
$sitelink = JUri::root();
$socialadshelper = new socialadshelper();
$manageAdLink = "<a href='" . $sitelink . "administrator" . DS . "index.php?option=com_socialads&view=approveads' targe='_blank'>" . JText::_("COM_SOCIALADS_EMAIL_THIS_LINK") . "</a>";
// GET config details
$frommail = $mainframe->getCfg('mailfrom');
$fromname = $mainframe->getCfg('fromname');
$adUserName = $user->username;
$adTitle = $oldAd->ad_title;
$siteName = $mainframe->getCfg('sitename');
$today = date('Y-m-d H:i:s');
//DEFINE SEARCH
$find = array('[SEND_TO_NAME]', '[ADVERTISER_NAME]', '[SITENAME]', '[SITELINK]', '[ADTITLE]', '[CONTENT]', '[TIMESTAMP]');
// SEND ADMIN MAIL
$recipient = $frommail;
$subject = JText::_("COM_SOCIALADS_APPRVE_MAIL_TO_ADMIN_SUBJECT");
$adminEmailBody = JText::sprintf("COM_SOCIALADS_EMAIL_HELLO") . JText::sprintf('COM_SOCIALADS_APPRVE_MAIL_TO_ADMIN_CONTENT', $manageAdLink) . JText::sprintf("COM_SOCIALADS_EMAIL_SITENAME_TEAM");
// NOW REPLACE TAG
$replace = array($fromname, $adUserName, $siteName, $sitelink, $adTitle, $content, $today);
$adminEmailBody = str_replace($find, $replace, $adminEmailBody);
$status = $socialadshelper->sendmail($recipient, $subject, $adminEmailBody, $bcc_string = '', $singlemail = 0, $attachmentPath = "");
// SEND TO ADVERTISER MAIL
$advertiserEmail = $user->email;
$subject = JText::_("COM_SOCIALADS_APPRVE_MAIL_TO_ADVERTISER_SUBJECT");
$advertiserEmailBody = JText::sprintf("COM_SOCIALADS_EMAIL_HELLO") . JText::sprintf('COM_SOCIALADS_APPRVE_MAIL_TO_ADVERTISR_CONTENT') . JText::sprintf("COM_SOCIALADS_EMAIL_SITENAME_TEAM");
// NOW REPLACE TAG
$replace = array($adUserName, $adUserName, $siteName, $sitelink, $adTitle, $content, $today);
$advertiserEmailBody = str_replace($find, $replace, $advertiserEmailBody);
$status = $socialadshelper->sendmail($advertiserEmail, $subject, $advertiserEmailBody, $bcc_string = '', $singlemail = 0, $attachmentPath = "");
}