<?php //Error reporting ini_set('display_errors', 1); error_reporting(E_ALL); require_once 'std.table.class.inc'; require_once 'db.inc'; require_once 'error.inc'; include 'PaInvoice.class.inc'; $dbobject = new PaInvoice(); // if $where is null then all rows will be retrieved //$where = "column='value'"; $where = ""; // user may specify a particular page to be displayed /* if (isset($_GET['pageno'])) { $dbobject->setPageno($_GET['pageno']); } // if */ $data = $dbobject->getData($where); $errors = $dbobject->getErrors(); if (!empty($errors)) { // deal with error message(s) } // if foreach ($data as $row) { var_dump($row); //echo array_keys($data); foreach ($row as $field => $value) { //var_dump($value); //var_dump($field);
<?php //Error reporting ini_set('display_errors', 1); error_reporting(E_ALL); //load Mage require_once "/var/www/html/magento/app/Mage.php"; Mage::app(); $config_info = parse_ini_file('/var/www/html/magento/paGateway/paGateway.ini', true); require_once 'classes/std.table.class.inc'; require_once 'classes/db.inc'; require_once 'classes/error.inc'; include 'classes/PaInvoice.class.inc'; $dbobject = new PaInvoice(); $data = $dbobject->getData($where, $orderby); $errors = $dbobject->getErrors(); if (!empty($errors)) { // deal with error message(s) }
$day = "0" . $day; } $formatted_date = $year . "-" . $month . "-" . $day; return $formatted_date; } $pagename = $_SERVER['REQUEST_URI']; $where = ""; $groupby = "xourpo, xinv "; $orderby = "xdate, xourpo, xinv"; $oInvoiceList = new PaInvoiceByPOandInv(); $data = $oInvoiceList->getData($where, $groupby, $orderby); $errors = $oInvoiceList->getErrors(); if (!empty($errors)) { // deal with error message(s) } $oInvoiceParts = new PaInvoice(); if ($_POST) { $date_from = makeDate($_POST['date-from']); $date_to = makeDate($_POST['date-to']); $orderId = $_POST['orderId']; //TODO: make sure to is not before from - can be jquery validation $where = "xdate between '" . $date_from . "' AND '" . $date_to . "'"; //header("Location: http://localhost/var/etl/bin/categories/tool/assign1.html"); //echo "submitted."; $data = $oInvoiceList->getData($where, $groupby, $orderby); $errors = $oInvoiceList->getErrors(); if (!empty($errors)) { // deal with error message(s) } } if ($_GET) {
<?php //Error reporting ini_set('display_errors', 1); error_reporting(E_ALL); include "/var/etl/bin/includes/conn.php"; include "/var/etl/bin/includes/logging.php"; include "/var/etl/bin/includes/database_functions.php"; include "/var/etl/bin/includes/functions.php"; require_once 'std.table.class.inc'; require_once 'db.inc'; require_once 'error.inc'; include 'PaInvoice.class.inc'; $dbobject = new PaInvoice(); //load paAPI require_once '/var/www/html/magento/paGateway/reportAPI/invoiceReport.php'; //load Mage require_once "/var/www/html/magento/app/Mage.php"; Mage::app(); $config_info = parse_ini_file('/var/www/html/magento/paGateway/paGateway.ini', true); $uid = $config_info['login']['uid']; $pass = $config_info['login']['pass']; $nw = new invoiceReport(); $nw->setUser($uid, $pass); $nw->setAction('getInvoiceInRange'); //only supported function $nw->setStartDate('20120101'); //start date $nw->setEndDate('20120515'); //end date $obj = $nw->sendRequest();