protected function _postDelete()
{
$tblOrderDetail = new App_Model_Db_Table_OrderDetail();
$tblOrderDetail->delete("orderId=" . $this->orderId);
$tblOrderHistory = new App_Model_Db_Table_OrderHistory();
$tblOrderHistory->delete("orderId=" . $this->orderId);
$tblPaymentHistory = new App_Model_Db_Table_PaymentConfirmation();
$tblPaymentHistory->delete("orderId=" . $this->orderId);
$tblNsiapay = new App_Model_Db_Table_Nsiapay();
$tblNsiapay->delete("orderId=" . $this->orderId);
$tblNsiapayHistory = new App_Model_Db_Table_NsiapayHistory();
$tblNsiapayHistory->delete("orderId='{$this->invoiceNumber}'");
}
protected function updateInvoiceMethod($orderId, $payMethod, $status, $notify, $note)
{
$tblOrder = new App_Model_Db_Table_Order();
$rows = $tblOrder->find($orderId)->current();
$row = array();
$ivnum = $rows->invoiceNumber;
/*if(empty($ivnum)){
if($status==3 || $status==5 || (!empty($_SESSION['_method'])&&($_SESSION['_method'] =='paypal')))
$ivnum = $this->getInvoiceNumber();
//$row=array ('invoiceNumber' => $ivnum);
}*/
//if( )$ivnum = $this->getInvoiceNumber();
$row = array('orderStatus' => $status, 'paymentMethod' => $payMethod);
//$_SESSION['_method'] = '';
/*$this->_paymentMethod=$payMethod;//set payment method on table
$row->paymentMethod=$this->_paymentMethod;*/
$tblOrder->update($row, 'orderId = ' . $orderId);
$tblHistory = new App_Model_Db_Table_OrderHistory();
$rowHistory = $tblHistory->fetchNew();
$rowHistory->orderId = $orderId;
$rowHistory->orderStatusId = $status;
$rowHistory->dateCreated = date('YmdHis');
$rowHistory->userNotified = $notify;
$rowHistory->note = $note;
$rowHistory->save();
return $ivnum;
}
public function refundedAction()
{
$this->_helper->viewRenderer->setNoRender(TRUE);
$orderId = $this->_request->getParam('orderId');
//print_r($this->_request->getParams());
$tblOrder = new App_Model_Db_Table_Order();
$tblOrderDetail = new App_Model_Db_Table_OrderDetail();
$tblOrderHistory = new App_Model_Db_Table_OrderHistory();
$data['orderStatus'] = 2;
$rowOrder = $tblOrder->update($data, 'orderId = ' . $orderId);
$data2['orderId'] = $orderId;
$data2['orderStatusId'] = 2;
$data2['dateCreated'] = date('Y-m-d H:i:s');
$data2['userNotified'] = '1';
$data2['note'] = 'Refund Payment on process';
$updateHistory = $tblOrderHistory->insert($data2);
$this->_redirect(ROOT_URL . '/' . $this->view->getLanguage() . '/store/transaction');
}
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', 'hol-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->_user->kopel, $value)) {
//forward to error page
$this->_helper->redirector->gotoSimple('error', 'store', 'site', array('view' => 'notowner'));
die;
}
}
$tblConfirm = new App_Model_Db_Table_PaymentConfirmation();
$tblOrder = new App_Model_Db_Table_Order();
$r = $this->getRequest();
$amount = 0;
foreach ($r->getParam('orderId') as $ksy => $value) {
$amount += App_Model_Show_Order::show()->getAmount($value);
}
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 App_Model_Db_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();
$mod = new App_Model_Store_Mailer();
$mod->sendUserBankConfirmationToAdmin($data['orderId']);
}
$this->_helper->redirector->gotoSimple('confirm', 'store_payment', 'hol-site', array('sended' => '1'));
}
$datenow = date('YmdHis');
//if ($_SERVER['REMOTE_ADDR'] == "203.190.41.220") {
if ($rowOrder) {
if ($status_code == 00) {
$rowOrder->orderStatus = 3;
} else {
$rowOrder->orderStatus = 6;
}
$rowOrder->paymentDate = $datenow;
$tblNsiapay = new App_Model_Db_Table_Nsiapay();
$tblNsiapay->update(array('status' => 'paid', 'finishtime' => date('YmdHis')), "transidmerchant='" . $transidmerchant . "'");
$tblNhis = new App_Model_Db_Table_NsiapayHistory();
$tblNhis->insert(array('orderId' => $rowOrder->orderId, 'paymentStatus' => 'paid', 'dateAdded' => date('YmdHis')));
$redirect_url = _MERCHANTWEB . "?status_code=" . $status_code . "&order_number=" . $transidmerchant;
$rowOrder->save();
$tblHistory = new App_Model_Db_Table_OrderHistory();
$orderHistory = array('orderId' => $rowOrder->orderId, 'orderStatusId' => $rowOrder->orderStatus, 'dateCreated' => date('YmdHis'), 'userNotified' => 0, 'note' => 'paid with nsiapay method');
$tblHistory->insert($orderHistory);
} else {
$redirect_url = _MERCHANTWEB;
}
//}
//else
//{
// $rowOrder->orderStatus = 7;
// $rowOrder->datePurchased = $datenow;
//
// $rowOrder->save();
//
// $redirect_url = _MERCHANTWEB."?status_code=7&order_number=".$transidmerchant;
//}
protected function updateInvoiceMethod($orderId, $payMethod, $status, $notify, $note)
{
$tblOrder = new App_Model_Db_Table_Order();
$rows = $tblOrder->find($orderId)->current();
$row = array();
$ivnum = $rows->invoiceNumber;
$row = array('orderStatus' => $status, 'paymentMethod' => $payMethod);
$tblOrder->update($row, 'orderId = ' . $orderId);
$tblHistory = new App_Model_Db_Table_OrderHistory();
$rowHistory = $tblHistory->fetchNew();
$rowHistory->orderId = $orderId;
$rowHistory->orderStatusId = $status;
$rowHistory->dateCreated = date('YmdHis');
$rowHistory->userNotified = $notify;
$rowHistory->note = $note;
$rowHistory->save();
return $ivnum;
}
