PHP DBOutputWork примеры использования

Пример #1

Файл: output_item_report_proc.php Проект: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../acct_class/DBOutputWork.php";
$oWork = new DBOutputWork(true);
try {
    $oWork->createWork($_POST, true);
    $res = $oWork->requestItemCdReport();
    $result = array();
    $item_cd = -1;
    $su_sum = 0;
    $amt_sum = 0;
    $total_su_sum = 0;
    $total_amt_sum = 0;
    while ($item = $oWork->fetchMapRow()) {
        $item['io_item_cd'] = sprintf("%05d", $item['io_item_cd']);
        if ($item_cd != -1 and $item_cd != $item['io_item_cd']) {
            //일계 넣기 type -1
            $obj = null;
            $obj['io_item_cd'] = '(상품 계)';
            $obj['io_su'] = $su_sum;
            $obj['io_amt'] = $amt_sum;
            $obj['type'] = -1;
            array_push($result, $obj);
            $su_sum = 0;
            $amt_sum = 0;
            //날짜 갱신
            $item_cd = $item['io_item_cd'];
        }
        if ($item_cd == -1) {

Пример #2

Файл: output_m_list_proc.php Проект: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../acct_class/DBOutputWork.php";
$oWork = new DBOutputWork(true);
try {
    $oWork->createWork($_POST, true);
    $oWork->requestMasterList();
    $result = array();
    while ($item = $oWork->fetchMapRow()) {
        $item['io_tr_cd'] = sprintf("%05d", $item['io_tr_cd']);
        $item['io_pay_customer_id'] = sprintf("%05d", $item['io_pay_customer_id']);
        array_push($result, $item);
    }
    echo "{ CODE: '00' , DATA : " . json_encode($result) . "}";
    $oWork->destoryWork();
} catch (Exception $e) {
    $oWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Пример #3

Файл: output_print_page.php Проект: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../acct_class/DBOutputWork.php";
$oWork = new DBOutputWork(true);
try {
    $oWork->createWork(-1, true);
    $oWork->requestPrintPageInfo();
    $item = $oWork->fetchMapRow();
    echo "{ CODE: '00' , DATA : " . json_encode($item) . "}";
    $oWork->destoryWork();
} catch (Exception $e) {
    $oWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Пример #4

Файл: output_delete_proc.php Проект: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../acct_class/DBOutputWork.php";
$oWork = new DBOutputWork(true);
try {
    $oWork->createWork($_POST, true);
    $res = $oWork->requestDelArray();
    $oWork->destoryWork();
    // 리턴
    if ($res) {
        echo "{ CODE: '00', DATA:" . json_encode($res) . " }";
    } else {
        echo "{ CODE: '999' DATA: '마감된 연도 입니다.' }";
    }
    //마감 데이터
} catch (Exception $e) {
    $oWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}