Ejemplos de App_Model_Db_Table_Order::fetchRow en PHP

Ejemplo n.º 1

Archivo: nsiapay_notify.php Proyecto: hukumonline/pmg

<?php

error_reporting(E_ALL | E_STRICT);
require_once "../baseinit.php";
Pandamp_Application::getResource('session');
Pandamp_Application::getResource('multidb')->getDb('db1');
$transidmerchant = $_GET['OrderNumber'];
$responseCode = $_GET['RESPONSECODE'];
$cardNumber = $_GET['CARDNUMBER'];
$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;

Ejemplo n.º 2

Archivo: nsiapay_verify.php Proyecto: hukumonline/store

<?php

error_reporting(E_ALL | E_STRICT);
require_once "../baseinit.php";
Pandamp_Application::getResource('session');
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
//{