PHP DBAdminWork Examples

Example #1

File: admin_linkuser_select_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork($_POST, true);
    $ret = array();
    if ($_POST['type'] == 'T') {
        $res = $aWork->selectLinkUserListForTax();
    } else {
        $res = $aWork->selectLinkUserList();
    }
    $aWork->destoryWork();
    $ret['DATA'] = $res;
    $ret['CODE'] = '00';
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' }";
    exit;
}

Example #2

File: member_change_flag.php Project: akswosn/Smartax

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../class/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->AdminCreateWork($_POST, true);
    $res = $aWork->requestUpdateValid();
    echo '{ CODE: "00", ';
    echo 'DATA: ' . json_encode($res) . ' }';
    $aWork->destoryWork();
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Example #3

File: member_invalid_list_proc.php Project: akswosn/Smartax

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../class/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->AdminCreateWork(-1, true);
    $res = $aWork->requestInvalidMemberList();
    $result = array();
    while ($item = $aWork->fetchMapRow()) {
        array_push($result, $item);
    }
    echo '{ CODE: "00", ';
    echo 'DATA: ' . json_encode($result) . ' }';
    $aWork->destoryWork();
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Example #4

File: admin_comp_user_modify_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork($_POST, true);
    $type = $_POST['type'];
    $mem_level = $_POST['mem_level'];
    if ($mem_level == '3') {
        //세무(등록 삭제 동일)
        $res = $aWork->registUserAsCompForSales();
    } else {
        if ($type == 'R') {
            $res = $aWork->registUserAsComp();
        } else {
            if ($type == 'D') {
                $res = $aWork->deleteUserAsComp();
            } else {
                echo "{ CODE: '99' , DATA : '타입오류입니다.'}";
                exit;
            }
        }
    }
    $aWork->destoryWork();
    if ($res > 0) {
        $ret['CODE'] = '00';
    } else {
        $ret['CODE'] = '99';
        $ret['DATA'] = '변경실패';

Example #5

File: admin_user_modify_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork($_POST, true);
    $type = $_POST['type'];
    if ($type == 'R') {
        $res = $aWork->registSalesMember();
    } else {
        if ($type == 'D') {
            $res = $aWork->deleteSalesMember();
        } else {
            echo "{ CODE: '99' , DATA : '타입오류입니다.'}";
            exit;
        }
    }
    $aWork->destoryWork();
    if ($res > 0) {
        $ret['CODE'] = '00';
    } else {
        $ret['CODE'] = '99';
        $ret['DATA'] = '변경실패';
    }
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);

Example #6

File: admin_comp_select_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork(-1, true);
    $ret = array();
    $res = $aWork->selectCompList();
    $aWork->destoryWork();
    $ret['DATA'] = $res;
    $ret['CODE'] = '00';
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' }";
    exit;
}

Example #7

File: admin_linkuser_user_select_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork($_POST, true);
    $ret = array();
    $res = $aWork->selectLinkUserListAsMember();
    $aWork->destoryWork();
    $ret['DATA'] = $res;
    $ret['CODE'] = '00';
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' }";
    exit;
}

Example #8

File: admin_alluser_select_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork(-1, true);
    $ret = array();
    $res = $aWork->selectAllUserList();
    $aWork->destoryWork();
    $ret['DATA'] = $res;
    $ret['CODE'] = '00';
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' }";
    exit;
}

Example #9

File: admin_main_user_modify_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork($_POST, true);
    $res = $aWork->updateUserInfo();
    $aWork->destoryWork();
    if ($res > 0) {
        $ret['CODE'] = '00';
    } else {
        $ret['CODE'] = '99';
        $ret['DATA'] = '변경실패';
    }
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' }";
    exit;
}

Example #10

File: admin_comp_modify_proc.php Project: akswosn/Smartax

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class_tax/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    $aWork->createWork($_POST, true);
    $res = $aWork->updateComp();
    $aWork->destoryWork();
    if ($res > 0) {
        $ret['CODE'] = '00';
    } else {
        $ret['CODE'] = '99';
        $ret['DATA'] = '변경실패';
    }
    echo json_encode($ret);
} catch (Exception $e) {
    $aWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$e}'}";
    exit;
}

Example #11

File: login_proc.php Project: akswosn/Smartax

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../class/DBAdminWork.php";
$aWork = new DBAdminWork(true);
try {
    //$_POST : [login_id], [login_pw]
    $aWork->AdminCreateWork($_POST, false);
    $res = $aWork->requestLogin();
    $aWork->destoryWork();
    if ($res) {
        //성공
        echo " { 'CODE' : '00' }";
    } else {
        //실패
        echo " { 'CODE' : '99' }";
    }
} catch (Exception $e) {
    $aWork->destoryWork();
    echo " { 'CODE' : '99' }";
    Util::serverLog($e);
    exit;
}