PHP DBInputWork Examples

Example #1

File: input_delete_proc.php Project: akswosn/Smartax

<?php

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

Example #2

File: input_day_report_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../acct_class/DBInputWork.php";
$iWork = new DBInputWork(true);
try {
    $iWork->createWork($_POST, true);
    $res = $iWork->requestDayReport();
    $result = array();
    $yyyymmdd = -1;
    $su_sum = 0;
    $amt_sum = 0;
    $total_su_sum = 0;
    $total_amt_sum = 0;
    while ($item = $iWork->fetchMapRow()) {
        if ($yyyymmdd != -1 and $yyyymmdd != $item['io_dt']) {
            //일계 넣기 type -1
            $obj = null;
            $obj['io_dt'] = '(일계)';
            $obj['io_su'] = $su_sum;
            $obj['io_amt'] = $amt_sum;
            $obj['type'] = -1;
            array_push($result, $obj);
            $su_sum = 0;
            $amt_sum = 0;
            //날짜 갱신
            $yyyymmdd = $item['io_dt'];
        }
        if ($yyyymmdd == -1) {
            $yyyymmdd = $item['io_dt'];

Example #3

File: input_d_list_proc.php Project: akswosn/Smartax

<?php

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