public function mailerAdmin($idOrder, $key, $userTo)
{
$mail = new PaymentGateway_HtmlMail();
$tblSetting = new Kutu_Core_Orm_Table_PaymentSetting();
$template = $tblSetting->fetchAll($tblSetting->select()->where("settingKey = '{$key}'"));
$tblOrder = new Kutu_Core_Orm_Table_Order();
$tbluser = new Kutu_Core_Orm_Table_User();
$tblOrderDetail = new Kutu_Core_Orm_Table_OrderDetail();
$tblSetting = new Kutu_Core_Orm_Table_PaymentSetting();
$lgsMail = $tblSetting->fetchAll($tblSetting->select()->where("settingKey = 'paypalBusiness'"));
$userDetailInfo = $tbluser->userInfoOrder($idOrder);
$rowset = $tblOrder->getOrderAndStatus($idOrder);
$rowsetDetail = $tblOrderDetail->fetchAll($tblOrderDetail->select()->where("orderId = " . $idOrder));
$tblConfirm = new Kutu_Core_Orm_Table_PaymentConfirmation();
if ($rowset[0]->orderStatus == 6) {
$status = 'rejected';
} else {
$status = 'confirmed';
}
$unConfirmed = $tblConfirm->fetchAll($tblConfirm->select()->where("confirmed =0 AND orderId = " . $idOrder));
echo '<pre>';
//print_r($userDetailInfo);
echo '</pre>';
$detail = "ORDER ID : " . $idOrder . '<br/>' . 'Detail : <br/><blockquote><ol>';
foreach ($rowsetDetail as $row) {
$detail .= '<li><ul>
<li>Document Name: ' . $row->documentName . '</li>
<li>Quantity : ' . $row->qty . '</li>
<li>Price : USD ' . number_format($row->price, 2) . ' </li>
<li>Tax : ' . number_format($row->tax, 2) . ' %</li>
<li>Final Price : ' . number_format($row->finalPrice, 2) . '</li>
</ul></li>';
}
$detail .= '</ol><blockquote><br />';
//print_r($detail);
$sMailSource = $template[0]->note;
if ($userTo == 'admin') {
$sMailEmailTo = $lgsMail[0]->settingValue;
$sMailEmailFrom = $userDetailInfo[0]->email;
$link = '<a href="' . KUTU_ROOT_URL . '/admin/store/detailOrder/id/' . $idOrder . '">here</a>';
} else {
$sMailEmailTo = $userDetailInfo[0]->email;
$sMailEmailFrom = $lgsMail[0]->settingValue;
$link = '<a href="' . KUTU_ROOT_URL . '/site/store_payment/detail/id/' . $idOrder . '">here</a>';
}
$sMailSubject = "Confirmation for user payment";
$sMailHeader = '';
$aMailDataSet = array('PAYMENTDATE' => $unConfirmed[0]->paymentDate, 'PAIDTIME' => $unConfirmed[0]->paymentDate, 'PAYMENT' => $rowset[0]->paymentMethod, 'DESCRIPTION' => $detail, 'TOTALORDER' => $rowset[0]->orderTotal, 'ORDERTIME' => $rowset[0]->datePurchased, 'INVOICE' => $rowset[0]->invoiceNumber, 'METHOD' => $rowset[0]->paymentMethod, 'LINK' => $link, 'STATUS' => $status);
$mail->SendFileMail($sMailSource, $sMailEmailTo, $sMailSubject, $sMailEmailFrom, $sMailHeader, $aMailDataSet);
}
