Exemplos de App_Model_Db_Table_Nsiapay::update em PHP

Exemplo n.º 1

Arquivo: nsiapay_process.php Projeto: hukumonline/pmg

$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;

Exemplo n.º 2

Arquivo: nsiapay_notify.php Projeto: hukumonline/pmg

$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;

Exemplo n.º 3

Arquivo: nsiapay_verify.php Projeto: hukumonline/store

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();
//