Esempi in PHP per DBWork

Esempio n. 1

File: DBFaqWork.php Progetto: akswosn/Smartax

 public static function isWriteTable($tblKind)
 {
     //로그인 여부 확인
     if (!DBWork::isValidUser()) {
         return false;
     }
     switch ($tblKind) {
         //공지사항
         case 1:
             //회계 FAQ
         //회계 FAQ
         case 2:
             //재고 FAQ
             if (self::isAdminUser()) {
                 return true;
             } else {
                 return false;
             }
         default:
             //건의/질문하기
             return true;
     }
 }

Esempio n. 2

File: body_header_middle.php Progetto: akswosn/Smartax

<div class="header-middle">
	<div class="header-middle-inner">
		<img class="header-middle-product-img" src="./img/common/img_product_02x648.png" alt="태극회계 프로그램 이미지">
		<img class="header-middle-product-txt" src="./img/common/txt_product_01.png" alt="세계 최초 현금출납장 복식회계 프로그램은 역시 태극회계!! 차변, 대변없이 입금, 출금에 계정만 입력하면 OK!!">
	<?php 
if (!DBWork::isValidUser()) {
    ?>
				<a id="btn-sample" href="#"><img src="./img/common/btn_sample_03.png" alt="태극회계 체험하기"></a>
			<?php 
}
?>
	
	</div>
	<?php 
if (DBWork::isValidUser()) {
    ?>
				<div class="header-middle-start">
					<a id="btn-start" href="#"><img src="./img/common/btn_start_01.png" alt="태극회계 시작하기"></a>
				</div>
			<?php 
}
?>
</div>
<script>
(function() {
	// 회사코드 체크
	$("#btn-start").click(function() {
        var v = $("#co_select").val();
        
        if (v) {
            if (v == -1) {

Esempio n. 3

File: junpyo_fix_proc.php Progetto: akswosn/Smartax

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
$listWork = new DBWork();
$updateWork = new DBWork();
//localhost/FarmSaver/proc/DataConvert/junpyo_fix_proc.php
try {
    $co_id = $_GET['co_id'];
    $listWork->createWork(-1, $login_id);
    $updateWork->createWork(-1, $login_id);
    $listWork->querySql("SELECT * FROM junpyo where co_id={$co_id} AND jp_view_gubun>4 AND jp_view='y';");
    $idx = 0;
    while ($row = $listWork->fetchMapRow()) {
        $jp_rem = $row['jp_rem'];
        if ($jp_rem == '') {
            continue;
        }
        $jp_id = $row['jp_match_id'];
        $updateWork->updateSql("UPDATE junpyo SET `jp_rem` = '{$jp_rem}' WHERE co_id={$co_id} AND jp_id={$jp_id};");
        $idx++;
    }
    $listWork->destoryWork();
    $updateWork->destoryWork();
    echo $idx;
} catch (Exception $e) {
    $listWork->destoryWork();
    $updateWork->destoryWork();
    echo $e->getMessage();
    Util::serverLog($e);
    exit;

Esempio n. 4

File: Utils.php Progetto: akswosn/Smartax

 public static function isWriteTable($tblKind)
 {
     //로그인 여부 확인
     if (!DBWork::isValidUser()) {
         return false;
     }
     switch ($tblKind) {
         case '11':
         case '21':
             if (self::isAdminUser()) {
                 return true;
             } else {
                 return false;
             }
         default:
             return true;
     }
 }

Esempio n. 5

File: gycode_fix_proc.php Progetto: akswosn/Smartax

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
$iWork = new DBWork();
$toWork = new DBWork();
//kimgj1212
//choice4410
//localhost/FarmSaver/proc/DataConvert/gycode_fix_proc.php?id=kimgj1212
//http://localhost/FarmSaver/proc/DataConvert/data_convert_proc.php?id=choice4410
//localhost/proc/DataConvert/gycode_fix_proc.php?id=choice4410
try {
    $login_id = $_GET['id'];
    $fromWork->createWork($_GET, $login_id);
    $toWork->createWork($_GET, false);
    $toWork->querySql("SELECT co_id FROM farmsaver.company_member A , user_info B WHERE B.user_id='{$login_id}' AND A.uid=B.uid;");
    $uid = 0;
    while ($row = $toWork->fetchMixedRow()) {
        $uid = (int) $row['uid'];
        $co_list['001'] = (int) $row['co_id'];
    }
    //계정 ->덮어쓰는 것 가능
    echo "--> convertGycode<br>";
    $result['gycode'] = ConvertUtils::convertGycode($fromWork, $toWork, $co_list, $uid);
    $fromWork->destoryWork();
    $toWork->destoryWork();
} catch (Exception $e) {
    $toWork->rollback();
    $fromWork->destoryWork();
    $toWork->destoryWork();
    echo $e->getMessage();

Esempio n. 6

File: junpyo_fix_customer_proc.php Progetto: akswosn/Smartax

<?php

require_once "../../class/Utils.php";
require_once "../../class/DBWork.php";
$listWork = new DBWork();
$updateWork = new DBWork();
//localhost/FarmSaver/proc/DataConvert/junpyo_fix_customer_proc.php
//localhost/proc/DataConvert/junpyo_fix_customer_proc.php
try {
    $co_id = $_GET['co_id'];
    $listWork->createWork(-1, $login_id);
    $updateWork->createWork(-1, $login_id);
    $listWork->querySql("SELECT * FROM junpyo WHERE jp_view = 'y' and jp_view_gubun>4;");
    $idx = 0;
    $updateWork->startTransaction();
    while ($row = $listWork->fetchMapRow()) {
        $customer_id = $row['customer_id'];
        if ($customer_id == 0) {
            continue;
        }
        $jp_id = $row['jp_match_id'];
        if ($jp_id == 0) {
            throw new Exception($row['jp_id']);
        }
        $updateWork->updateSql("UPDATE junpyo SET `customer_id` = {$customer_id} WHERE jp_id={$jp_id};");
        $idx++;
    }
    $updateWork->commit();
    $listWork->destoryWork();
    $updateWork->destoryWork();
    echo $idx;