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

Пример #1

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    //$_POST : [value], [type]
    $memWork->createWork($_POST, false);
    //$memWork->createWork($_GET, false);
    $code = $memWork->changePwd();
    $memWork->destoryWork();
    echo "<result><code>{$code}</code></result>";
} catch (Exception $e) {
    $memWork->destoryWork();
    $code = 'n';
    $res = $e->getMessage();
    echo "<result><code>{$code}</code><data>{$res}</data></result>";
}

Пример #2

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

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class/DBMemberWork.php";
require_once "../../../class/SessionManager.php";
$mWork = new DBMemberWork(true);
$sessionManager = new SessionManager();
// 	$co_id = $sessionManager->getJoinCoid();
// 	$user_id = $sessionManager->getJoinUid();
$join_user_info_step1 = $sessionManager->getJoinUserInfoStep1();
$join_user_info_step2 = $sessionManager->getJoinUserInfoStep2();
$join_user_info_step3 = $sessionManager->getJoinUserInfoStep3();
try {
    $mWork->createWork($_POST, false);
    // 		$res = $mWork->insertCompInfoDetail($co_id, $user_id);
    $res = $mWork->insertUserJoin($join_user_info_step1, $join_user_info_step2, $join_user_info_step3);
    $mWork->destoryWork();
    if ($res != null) {
        // 			$sessionManager->destroyJoinInfo();
        header("Location:../../../route.php?contents=006");
    } else {
        throw new Exception('회원 가입 실패.');
    }
} catch (Exception $e) {
    $mWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo $err;
}

Пример #3

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    //$_POST : [value], [type]
    $memWork->createWork($_POST, false);
    // 		$memWork->createWork($_GET, false);
    $code = $memWork->findUserId();
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    $code = 'n';
    $res = $e->getMessage();
}
echo "<result><code>{$code}</code></result>";

Пример #4

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
require_once "../../class_tax/FileUtil.php";
$memWork = new DBMemberWork(true);
try {
    $imgFile = null;
    if (!empty($_FILES['user_profile_img'])) {
        if (!empty($_FILES['user_profile_img']['name'])) {
            $imgFile = FileUtil::fileSaveForImg($_FILES['user_profile_img'], 'profile');
        } else {
            $imgFile = '';
        }
    } else {
        $imgFile = '';
    }
    $memWork->createWork(-1, true);
    $res = $memWork->requestProfileModify($imgFile);
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    Util::serverLog($e);
    echo $e;
    exit;
}
if ($_POST['isPopup'] == 'y') {
    ?>
<script>
	window.opener.profileImgView('<?php 

Пример #5

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBBoardWork.php";
$memWork = new DBMemberWork();
//pageSize, pageGroupSize, maxPageIndex
$memWork->setPageInfo(30, 10, 100);
$total_count = 0;
try {
    $memWork->createWork($_POST, true);
    $total_count = $memWork->requestPointSaveLog();
    $data = array();
    //첫번째 원소로 댓글 전체 개수를 셋팅함
    array_push($data, $total_count);
    //실제 댓글 정보 셋팅
    while ($cmt = $brdWork->fetchMapRow()) {
        //htmlspecialchars 는 클라이언트 js 에서 처리한다.
        $cmt['message'] = stripslashes($cmt['message']);
        array_push($data, $cmt);
    }
    //json 객체를 json 문자열로 변환
    $data = json_encode($data);
    echo "<result><code>y</code><data><![CDATA[{$data}]]></data></result>";
} catch (Exception $e) {
    $brdWork->destoryWork();
    $errmsg = $e->getMessage();
    Util::serverLog($e);
    echo "<result><code>n</code><data>{$errmsg}</data></result>";
    exit;
}

Пример #6

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork();
try {
    $memWork->createWork($_POST, false);
    //$res = $memWork->requestRegister();
    $res = $memWork->RegisterMemberCompany();
    $memWork->destoryWork();
    if ($res) {
        header("Location:../../route.php");
    } else {
        header("Location:../../route.php");
    }
} catch (Exception $e) {
    $memWork->destoryWork();
    echo $e->getMessage();
    Util::serverLog($e);
    exit;
}

Пример #7

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    $memWork->createWork($_POST, false);
    $res = $memWork->requestComModify();
    $memWork->destoryWork();
    echo $res;
} catch (Exception $e) {
    $memWork->destoryWork();
    Util::serverLog($e);
    echo $e->getMessage();
    exit;
}

Пример #8

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    //$_POST : [value], [type]
    $memWork->createWork($_POST, false);
    //$memWork->createWork($_GET, false);
    //$code = $memWork->requestNumber();
    $code = $memWork->requestSmsNumber();
    $memWork->destoryWork();
    echo "<result><code>{$code}</code></result>";
} catch (Exception $e) {
    $memWork->destoryWork();
    $code = 'n';
    $res = $e->getMessage();
    echo "<result><code>{$code}</code><data>{$res}</data></result>";
}

Пример #9

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    $memWork->createWork($_POST, true);
    $res = $memWork->requestRegisterCompany();
    $memWork->destoryWork();
    if ($res) {
        header("Location:../../route.php");
    } else {
        header("Location:../../route.php");
    }
} catch (Exception $e) {
    $memWork->destoryWork();
    echo $e->getMessage();
    Util::serverLog($e);
    exit;
}

Пример #10

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    $memWork->createWork(-1, false);
    $res = $memWork->requestCurComInfo();
    if ($res == null) {
        $res->CODE = '99';
    } else {
        $res->CODE = '00';
    }
    echo json_encode($res);
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    Util::serverLog($e);
    echo '{ "CODE": "99" }';
    exit;
}

Пример #11

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

<?php

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

Пример #12

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

<?php

require_once "../../../class/Utils.php";
require_once "../../../class/DBWork.php";
require_once "../../../class/DBMemberWork.php";
require_once "../../../class/SessionManager.php";
$mWork = new DBMemberWork(true);
try {
    $mWork->createWork($_POST, false);
    $ret = array();
    $res = $mWork->selectUserAsSaleCode();
    $mWork->destoryWork();
    if ($res != null) {
        $ret['CODE'] = '00';
        $ret['DATA'] = $res;
    } else {
        $ret['CODE'] = '99';
    }
    // 		var_dump($res[0]);
    //세션저장
    if ($is_sessionStart) {
        session_start();
    }
    $sessionManager = new SessionManager();
    $sessionManager->setJoinUserInfoStep1($res[0]);
    // 		var_dump($sessionManager->getJoinUserInfoStep1());
    echo json_encode($ret);
} catch (Exception $e) {
    $mWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);

Пример #13

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    //$_POST : [value], [type]
    $memWork->createWork($_POST, false);
    //$memWork->createWork($_GET, false);
    $code = $memWork->chkNumber();
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    $code = 'n';
    $res = $e->getMessage();
}
echo "<result><code>{$code}</code></result>";

Пример #14

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork();
$result = array();
$code = 'n';
$data = null;
try {
    //$_POST : [value], [type]
    $memWork->createWork($_POST, false);
    $res = $memWork->requestExistCheck();
    $memWork->destoryWork();
    $code = 'y';
} catch (Exception $e) {
    $memWork->destoryWork();
    $code = 'n';
    $res = $e->getMessage();
    Util::serverLog($e);
}
echo "<result><code>{$code}</code><data>{$res}</data></result>";

Пример #15

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
require_once "../../class/SessionManager.php";
$memWork = new DBMemberWork(true);
try {
    //$_POST : [login_id], [login_pw]
    //$memWork->createWork($_GET, false);
    $memWork->createWork($_POST, false);
    $res = $memWork->requestLogin();
    //세션 정보 저장
    $manager = new SessionManager();
    $manager->setUserNm($res['user_name']);
    $manager->setCoNm($res['co_nm']);
    $manager->setUserType($res['auth_id']);
    $headContent = "Location:../../route.php";
    $manager->destory();
    $memWork->destoryWork();
    if ($res) {
        if (isset($_POST["contents"])) {
            $headContent = $headContent . '?contents=' . $_POST["contents"];
            header($headContent);
        } else {
            header($headContent);
        }
    } else {
        $_SESSION['isLoginFail'] = 'y';
        header($headContent);
    }

Пример #16

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

<?php

require_once "../class/Utils.php";
require_once "../class/DBWork.php";
require_once "../class/DBMemberWork.php";
$memWork = new DBMemberWork();
try {
    $memWork->createWork(-1, false);
    $memWork->requestGetConfig();
    if ($item = $memWork->fetchMixedRow()) {
        echo "{ CODE: '00' , DATA : '{$item['config']}' }";
    } else {
        echo "{ CODE: '00' }";
    }
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Пример #17

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

<?php

require_once "./class/Utils.php";
require_once "./class/DBWork.php";
require_once "./class/DBMemberWork.php";
?>

<div class="header-top">
	<div class="header-top-inner">
		<h1 class="header-top-logo">
			<a href="./route.php?contents=100"><img src="./img/common/img_logo_01.png" alt="세계 최초 비차대 복식부기 시스템 산천경제연구소"></a>
		</h1>
		<span class="header-top-menu">
			<?php 
if (DBWork::isValidUser()) {
    $memWork = new DBMemberWork();
    try {
        $memWork->createWork(-1, false);
        $memWork->requestUserInfo();
        $memWork->destoryWork();
    } catch (Exception $e) {
        $memWork->destoryWork();
        echo $e->getMessage();
        Util::serverLog($e);
        exit;
    }
    $userInfo = $_SESSION;
    ?>
					<select id="co_select" value="<?php 
    echo $co['co_id'];
    ?>

Пример #18

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    $memWork->createWork($_GET, false);
    $res = $memWork->requestComInfo();
    $result = array();
    if ($res == null) {
        $result['CODE'] = '99';
    } else {
        $result['DATA'] = $res;
        $result['CODE'] = '00';
    }
    echo json_encode($result);
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    Util::serverLog($e);
    echo '{ "CODE": "99" }';
    exit;
}

Пример #19

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    $memWork->createWork($_POST, false);
    $res = $memWork->requestChangeCoId();
    $memWork->destoryWork();
    echo $res;
} catch (Exception $e) {
    $memWork->destoryWork();
    Util::serverLog($e);
    echo $e->getMessage();
    exit;
}

Пример #20

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

<?php

require_once "./class/Utils.php";
require_once "./class/DBWork.php";
require_once "./class/DBMemberWork.php";
require_once "./class/Display.php";
$memWork = new DBMemberWork();
$memWork->setPageInfo(20, 10, 100);
$total_count = 0;
$contents = $_GET['contents'];
try {
    $memWork->createWork($_GET, FALSE);
    $total_count = $memWork->requestPointUseLog();
} catch (Exception $e) {
    $memWork->destoryWork();
    echo $e->getMessage();
    Util::serverLog($e);
    exit;
}
function displayPointList($memWork)
{
    while ($post = $memWork->fetchMixedRow()) {
        ?>
				<tr>
					<td><?php 
        echo $post['pu_id'];
        ?>
</td>
					<td><?php 
        echo $post['pu_co_nm'];
        ?>

Пример #21

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
try {
    $memWork->createWork(-1, false);
    $res = $memWork->requestUserList();
    if ($res == null) {
        $res->CODE = '99';
    } else {
        $res->CODE = '00';
    }
    echo json_encode($res);
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Пример #22

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

<?php

require_once "../class/Utils.php";
require_once "../class/DBWork.php";
require_once "../class/DBMemberWork.php";
$memWork = new DBMemberWork();
try {
    $memWork->createWork($_POST, false);
    $memWork->requestSetConfig();
    $memWork->destoryWork();
    echo '{CODE: "00"}';
} catch (Exception $e) {
    $memWork->destoryWork();
    $err = $e->getMessage();
    Util::serverLog($e);
    echo "{ CODE: '99' , DATA : '{$err}'}";
    exit;
}

Пример #23

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

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
require_once "../../class/SessionManager.php";
require_once "../../class/DBMemberWork.php";
$memWork = new DBMemberWork(true);
$index = (int) $_POST["index"];
$ret = array();
if ($index > -1) {
    $ret["CODE"] = '00';
    $companyArray = $_SESSION[DBWork::companyArray];
    $comp = $companyArray[$index];
    if (!empty($comp)) {
        //세션 설정
        $_SESSION[DBWork::companyKey] = $comp["co_id"];
        $manager = new SessionManager();
        $manager->setCoNm($comp["co_nm"]);
    } else {
        $ret["CODE"] = '99';
        $ret['MSG'] = "회사정보를 불러오는데 문제가 발생하였습니다.";
    }
    $ret['DATA'] = $comp;
} else {
    $ret["CODE"] = '99';
    $ret['DATA'] = $index;
    $ret['MSG'] = "회사정보를 불러오는데 문제가 발생하였습니다.";
}
echo json_encode($ret);
$memWork->destoryWork();
exit;

Пример #24

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

<?php

require_once "./class/Utils.php";
require_once "./class/DBWork.php";
require_once "./class/DBMemberWork.php";
require_once "./class/SessionManager.php";
$memWork = new DBMemberWork(true);
try {
    //$_POST : [value], [type]
    //user정보
    $memWork->createWork(-1, false);
    $user_info = $memWork->selectUserInfo();
    $memWork->destoryWork();
} catch (Exception $e) {
    $memWork->destoryWork();
    echo $e;
}
//생년 월일 구하기
$birth = '';
if (strLen($user_info[0]['user_jumin']) < 8) {
    $birth = $user_info[0]['user_jumin'];
} else {
    if (substr($user_info[0]['user_jumin'], 7, 1) == '1' || substr($user_info[0]['user_jumin'], 7, 1) == '2') {
        $birth = '19' . substr($user_info[0]['user_jumin'], 0, 2) . '년 ';
    } else {
        $birth = '20' . substr($user_info[0]['user_jumin'], 0, 2) . '년 ';
    }
    $birth = $birth . substr($user_info[0]['user_jumin'], 2, 2) . '월 ' . substr($user_info[0]['user_jumin'], 4, 2) . '일';
}
//회사 정보
$companyArray = $_SESSION[DBWork::companyArray];