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);
}
public function trdetailAction()
{
$this->_checkAuth();
$orderId = $this->_request->getParam('id');
$userId = $this->_userInfo->userId;
$tblOrder = new Kutu_Core_Orm_Table_Order();
$tblOrderDetail = new Kutu_Core_Orm_Table_OrderDetail();
$tblOrderHistory = new Kutu_Core_Orm_Table_OrderHistory();
$tblOrderPaypalHistory = new Kutu_Core_Orm_Table_PaypalPaymentHistory();
$rowset = $tblOrder->getOrderAndStatus($orderId);
$rowsetDetail = $tblOrderDetail->fetchAll($tblOrderDetail->select()->where("orderId='" . $orderId . "'"));
$rowsetHistory = $tblOrderHistory->getUserHistory($orderId);
$rowsetPaypalHistory = $tblOrderPaypalHistory->fetchAll($tblOrderPaypalHistory->select()->where("orderId='" . $orderId . "'"));
//print_r($rowsetHistory);
$this->view->listOrder = $rowset;
$this->view->listOrderDetail = $rowsetDetail;
$this->view->rowsetHistory = $rowsetHistory;
$this->view->rowsetPaypalHistory = $rowsetPaypalHistory;
}
public function payconfirmAction()
{
$idOrder = $this->_request->getParam('id');
$tblOrder = new Kutu_Core_Orm_Table_Order();
$tblOrderDetail = new Kutu_Core_Orm_Table_OrderDetail();
$tblConfirm = new Kutu_Core_Orm_Table_PaymentConfirmation();
$rowset = $tblOrder->getOrderAndStatus($idOrder);
$rowsetDetail = $tblOrderDetail->fetchAll($tblOrderDetail->select()->where("orderId = " . $idOrder));
$rowsetConfirm = $tblConfirm->fetchAll($tblConfirm->select()->where("orderId = " . $idOrder));
$Paid = $tblConfirm->fetchAll($tblConfirm->select()->where("orderId = " . $idOrder)->order('paymentId DESC')->limit(0, 1));
$this->view->Paid = $Paid[0]->paymentDate;
$this->view->idOrder = $idOrder;
$this->view->rowset = $rowset;
$this->view->rowsetDetail = $rowsetDetail;
$this->view->rowsetConfirm = $rowsetConfirm;
echo '<pre>';
//print_r($rowset);
//print_r($rowsetDetail);
//print_r($rowsetConfirm);
echo '</pre>';
}
