$transidmerchant = $_GET['TRANSIDMERCHANT']; $totalamount = $_GET['AMOUNT']; $status_code = $_GET['STATUSCODE']; $tblOrder = new App_Model_Db_Table_Order(); $rowOrder = $tblOrder->fetchRow("invoiceNumber='" . $transidmerchant . "' AND orderStatus=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;
$bank = $_GET['BANK']; $approvalCode = $_GET['APPROVALCODE']; $result = strtoupper($_GET['RESULT']); require_once ROOT_DIR . '/app/models/Db/Table/Order.php'; require_once ROOT_DIR . '/app/models/Db/Table/Row/Order.php'; $tblOrder = new App_Model_Db_Table_Order(); $rowOrder = $tblOrder->fetchRow("invoiceNumber='" . $transidmerchant . "' AND orderStatus=1"); $datenow = date('YmdHis'); if ($_SERVER['REMOTE_ADDR'] == "203.190.41.220") { if ($rowOrder > 0) { if ($result == "SUCCESS") { //$rowOrder->orderStatus = 14; $rowOrder->paymentDate = $datenow; $data = array('status' => 'notify', 'responseCode' => $responseCode, 'creditcard' => $cardNumber, 'bank' => $bank, 'approvalCode' => $approvalCode); $tblNsiapay = new App_Model_Db_Table_Nsiapay(); $tblNsiapay->update($data, "transidmerchant='" . $transidmerchant . "'"); $tblNhis = new App_Model_Db_Table_NsiapayHistory(); $tblNhis->insert(array('orderId' => $rowOrder->orderId, 'paymentStatus' => 'notify', 'dateAdded' => date('YmdHis'))); $response = "Continue"; } else { //$rowOrder->orderStatus = 15; $rowOrder->paymentDate = $datenow; $response = "Stop"; } $rowOrder->save(); } else { $response = "Stop"; } echo $response; } else { $rowOrder->orderStatus = 7;
Pandamp_Application::getResource('multidb')->getDb('db1'); $transidmerchant = $_GET['TRANSIDMERCHANT']; $currency = $_GET['CURRENCY']; require_once ROOT_DIR . '/app/models/Db/Table/Order.php'; require_once ROOT_DIR . '/app/models/Db/Table/Nsiapay.php'; require_once ROOT_DIR . '/app/models/Db/Table/NsiapayHistory.php'; $tblOrder = new App_Model_Db_Table_Order(); $rowOrder = $tblOrder->fetchRow("invoiceNumber='" . $transidmerchant . "'"); $datenow = date('YmdHis'); //if ($_SERVER['REMOTE_ADDR'] == '202.182.62.118') { if ($rowOrder) { //$rowOrder->orderStatus = 9; $rowOrder->datePurchased = $datenow; $rowOrder->save(); $tblNsiapay = new App_Model_Db_Table_Nsiapay(); $tblNsiapay->update(array('status' => 'verify', 'bin' => $currency), "transidmerchant='" . $transidmerchant . "'"); $tblNhis = new App_Model_Db_Table_NsiapayHistory(); $tblNhis->insert(array('nsiaId' => $rowOrder->orderId, 'paymentStatus' => 'verify', 'dateAdded' => date('YmdHis'))); $response = "continue"; } else { $response = "stop"; } echo $response; //} //else //{ // $rowOrder->orderStatus = 7; // $rowOrder->datePurchased = $datenow; // // $rowOrder->save(); //