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>'; }