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 payconfirmAction() { $this->_checkAuth(); //if there is orderId send by previous page $tmpOrderId = $this->_request->getParam('orderId'); if (empty($tmpOrderId)) { $this->_helper->redirector->gotoSimple('error', 'store', 'site', array('view' => 'noorderfound')); die; } //[TODO] // 1. must check if user who sent the confirmation is the user who own the orderId. // 2. if no.1 above return false for at least one orderId, then forward to Error Page. $modelAppStore = new App_Model_Store(); foreach ($this->_request->getParam('orderId') as $key => $value) { if (!$modelAppStore->isUserOwnOrder($this->_userDetailInfo->guid, $value)) { //forward to error page $this->_helper->redirector->gotoSimple('error', 'store', 'site', array('view' => 'notowner')); die; } } //if orderId status is PAID redirect to error page //die('here'); $tblConfirm = new Kutu_Core_Orm_Table_PaymentConfirmation(); $tblOrder = new Kutu_Core_Orm_Table_Order(); $r = $this->getRequest(); $amount = 0; //var_dump($r->getParam('orderId')); //die(); foreach ($r->getParam('orderId') as $ksy => $value) { $amount += $tblOrder->getAmount($value, $r->getParam('currency')); } foreach ($r->getParam('orderId') as $key => $row) { $data = $tblConfirm->fetchNew(); $data['paymentMethod'] = $r->getParam('paymentMethod'); $data['destinationAccount'] = $r->getParam('destinationAccount'); $data['paymentDate'] = $r->getParam('paymentDate'); $data['amount'] = $amount; $data['currency'] = $r->getParam('currency'); $data['senderAccount'] = $r->getParam('senderAccount'); $data['senderAccountName'] = $r->getParam('senderAccountName'); $data['bankName'] = $r->getParam('bankName'); $data['note'] = $r->getParam('note'); $data['orderId'] = $row; $data->save(); $statdata['orderStatus'] = 4; $tblOrder->update($statdata, 'orderId = ' . $data['orderId']); $tblHistory = new Kutu_Core_Orm_Table_OrderHistory(); //add history $dataHistory = $tblHistory->fetchNew(); //history data $dataHistory['orderId'] = $data['orderId']; $dataHistory['orderStatusId'] = 6; $dataHistory['dateCreated'] = date('Y-m-d'); $dataHistory['userNotified'] = 1; $dataHistory['note'] = 'Waiting Confirmation'; $dataHistory->save(); //$this->Mailer($data['orderId'], 'admin-confirm', 'admin'); $mod = new App_Model_Store_Mailer(); $mod->sendUserBankConfirmationToAdmin($data['orderId']); } $this->_helper->redirector->gotoSimple('confirm', 'store_payment', 'site', array('sended' => '1')); }
public function payconfirmnoAction() { //print_r($this->_request->getParams()); $id = $this->_request->getParam('id'); //$method = $this->_request->getParam('method'); /*if($this->_request->getParam('method') == 'bank'){ $method = 1; }else{ $method = 5; }*/ $this->view->idOrder = $id; $this->view->warn = ''; if ($this->_request->isPost('adminNotes') == true) { if (strlen($this->_request->getParam('adminNotes')) == 0) { $this->view->warn = '<div class="error"> Please insert some notes</div>'; } else { $id = $this->_request->getParam('id'); $method = 6; $tblOrder = new Kutu_Core_Orm_Table_Order(); $tblHistory = new Kutu_Core_Orm_Table_OrderHistory(); $tblConfirm = new Kutu_Core_Orm_Table_PaymentConfirmation(); //echo $method; //select payment date from paymentconfirmation $date = $tblConfirm->fetchAll($tblConfirm->select()->where("orderId = " . $id . " AND confirmed = 0")); //$data['paidDate'] = @$date[0]->paymentDate; //update order $data['orderStatus'] = $method; $data['adminNotes'] = $this->_request->getParam('adminNotes'); $tblOrder->update($data, "orderId = " . $id); //update paymentconfirmation $dataConfirm['confirmed'] = 1; $dataConfirm['adminNotes'] = $this->_request->getParam('adminNotes'); $tblConfirm->update($dataConfirm, "orderId = " . $id); //add history $dataHistory = $tblHistory->fetchNew(); //history data $dataHistory['orderId'] = $id; $dataHistory['orderStatusId'] = $method; $dataHistory['dateCreated'] = date('Y-m-d'); $dataHistory['userNotified'] = 1; $dataHistory['note'] = 'rejected'; $dataHistory->save(); $mod = new App_Model_Store_Mailer(); $mod->sendReceiptToUser($id, 'Bank Transfer', "REJECTED", 1); //redirect to confirmation page $this->_helper->redirector('confirm'); } } }