ASP / hayabusa · Files

ADM1020.php 6.81 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 
<?PHP 
//*****************************************************************************
//* プログラム名：区分編集画面
//* プログラムID：ADM1020.php
//* 機能        ：区分編集画面
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/SessionChk.inc");
include("./inc/dbcon.inc");
include('./inc/smarty.conf');
include("./inc/const.inc");
include("./inc/pagetitle.inc");
include("./inc/pagefooter.inc");

$chkNyukin = Array();
$chkShukin = Array();

//期間区分取得
$strSQL = "select * from bunrui_tbl order by disp_rank";
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
for ($intCnt = 0; $intCnt < pg_numrows($objRec); $intCnt++) {
	$objData = pg_fetch_object($objRec, $intCnt);
	$bSeq[$intCnt] = $objData->bunrui_seq;
	$bName[$intCnt] = $objData->bunrui_name;

	//期間区分に紐つく大区分の数を取得
	$bCnt[$intCnt] = get_colspanK($bSeq[$intCnt]);
	
	//大区分の取得
	$strSqlD = "select * from koumoku_tbl where koumoku_mode = 1 and koumoku_parent = ".$bSeq[$intCnt]." order by  disp_rank";
	$objRecD = pg_exec($strSqlD);
	if($objRecD==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	for ($j = 0; $j < pg_numrows($objRecD); $j++) {
		$objDataD = pg_fetch_object($objRecD, $j);
		$kSeq[$intCnt][$j] = $objDataD->koumoku_seq;
		$kMode[$intCnt][$j] = $objDataD->koumoku_mode;
		$kParent[$intCnt][$j] = $objDataD->koumoku_parent;
		$kName[$intCnt][$j] = $objDataD->koumoku_name;
		$kRank[$intCnt][$j] = $objDataD->disp_rank;
		
		//20100408 MTC)sato
		$kNyukinMode[$intCnt][$j] = $objDataD->nyukin_mode;
		if($kNyukinMode[$intCnt][$j] == 3 || $kNyukinMode[$intCnt][$j] === null){
			$chkNyukin[$intCnt][$j] = 1;
			$chkShukin[$intCnt][$j] = 1;
		}elseif($kNyukinMode[$intCnt][$j] == 2){
			$chkNyukin[$intCnt][$j] = 0;
			$chkShukin[$intCnt][$j] = 1;
		}elseif($kNyukinMode[$intCnt][$j] == 1){
			$chkNyukin[$intCnt][$j] = 1;
			$chkShukin[$intCnt][$j] = 0;
		}else{
			$chkNyukin[$intCnt][$j] = 0;
			$chkShukin[$intCnt][$j] = 0;
		}

		//大区分に紐付く小区分の数を取得
		$kCnt[$intCnt][$j] = get_colspanD($kSeq[$intCnt][$j]);
		
		//小区分の取得
		$strSqlC = "select * from koumoku_tbl where koumoku_mode = 2 and koumoku_parent = ".$kSeq[$intCnt][$j]." order by  disp_rank";
		$objRecC = pg_exec($strSqlC);
		if($objRecC==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for ($k = 0; $k < pg_numrows($objRecC); $k++) {
			$objDataC = pg_fetch_object($objRecC, $k);
			$cSeq[$intCnt][$j][$k]    = $objDataC->koumoku_seq;
			$cMode[$intCnt][$j][$k]   = $objDataC->koumoku_mode;
			$cParent[$intCnt][$j][$k] = $objDataC->koumoku_parent;
			$cName[$intCnt][$j][$k]   = $objDataC->koumoku_name;
			$cRank[$intCnt][$j][$k]   = $objDataC->disp_rank;
			$cZeiflg[$intCnt][$j][$k] = $objDataC->shouhizei_flg;
			
		}
	}
}

//区分Seqの最大値取得
	$strSql = "SELECT * FROM koumoku_tbl ORDER BY koumoku_seq DESC";
	$objRec = pg_exec($strSql);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0) {
		$objData = pg_fetch_object($objRec, 0);
		$SeqMax  = $objData->koumoku_seq;
	} else {
		$SeqMax  = 0;
	}
	
//区分rankの最大値取得
	$strSql = "SELECT * FROM koumoku_tbl ORDER BY disp_rank DESC";
	$objRec = pg_exec($strSql);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0) {
		$objData = pg_fetch_object($objRec, 0);
		$rankMax  = $objData->disp_rank;
	} else {
		$rankMax  = 0;
	}

//HTMLヘッダの書き出し
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> 
<html>
<head>
	<meta http-equiv="content-type" content="text/html; cahrset=euc-jp">
	<meta http-equiv="content-style-type" content="text/css">
	<meta name="robots" content="noindex, nofollow">
	
	<script type="text/javascript" src="./js/jquery1.3.2.js"></script>
	<script type="text/javascript" src="./js/ui.core.js"></script>
	<script type="text/javascript" src="./js/ui.draggable.js"></script>
	<script type="text/javascript" src="./js/ui.droppable.js"></script>
	<script type="text/javascript" src="./js/ui.sortable.js"></script>
	<script type="text/javascript" src="./js/jquery.tipsy.js"></script>
	<script type="text/javascript" src="./js/ADM1020.js"></script>
	<title><?PHP  echo($PHP_SYSNAME); ?></title>
	<link type="text/css" href="./templates/jquery-ui-1.7.1.css" rel="stylesheet" />
	<link type="text/css" href="./templates/tipsy.css" rel="stylesheet" />
	<link type="text/css" href="./templates/SIMmain.css" rel="stylesheet" />

</head>

<?PHP 

//タイトル部分の表示
dspTitle($PHP_SYSNAME, $PHP_GROUP_NAME, $PHP_BUMON_NAME, $PHP_USER_NAME,"http://www.f-mtclab.net/article/134532314.html#help0");


//メインHTML部分の表示
//[0]システムURL、[1]HP URL、[2]マニュアルURL、[3]MTC HP URL、[4]マスタメールアドレス、
//[5]期間区分名、[6]大区分名、[7]小区分名、[8]支出名、[9]収入名、[10]消費税率（文字型）
$o_smarty->assign('DEFARR',$DEFARR);

$o_smarty->assign('PHP_USER_ADMIN',$PHP_USER_ADMIN);
$o_smarty->assign('PHP_USER_NYUKIN',$PHP_USER_NYUKIN);
$o_smarty->assign('PHP_USER_SHIKIN',$PHP_USER_SHIKIN);
$o_smarty->assign('bName',$bName);
$o_smarty->assign('bSeq',$bSeq);
$o_smarty->assign('bCnt',$bCnt);

$o_smarty->assign('kSeq',$kSeq);
$o_smarty->assign('kMode',$kMode);
$o_smarty->assign('kParent',$kParent);
$o_smarty->assign('kName',$kName);
$o_smarty->assign('kRank',$kRank);
$o_smarty->assign('kCnt',$kCnt);

$o_smarty->assign('cSeq',$cSeq);
$o_smarty->assign('cMode',$cMode);
$o_smarty->assign('cParent',$cParent);
$o_smarty->assign('cName',$cName);
$o_smarty->assign('cRank',$cRank);
$o_smarty->assign('cZeiflg',$cZeiflg);
$o_smarty->assign('kNyukinMode',$kNyukinMode);
$o_smarty->assign('chkNyukin',$chkNyukin);
$o_smarty->assign('chkShukin',$chkShukin);

$o_smarty->assign('SeqMax',$SeqMax);
$o_smarty->assign('rankMax',$rankMax);

$o_smarty->display('ADM1020.tpl');

//フッタ部分の表示
dspFooter($DEFARR[1], $DEFARR[3],"http://www.f-mtclab.net/article/134532314.html#help0");


function get_colspanK($kSeq){
	//期間区分に紐付く大区分の数を取得
	$strSQL  = "SELECT count(*) AS cnt FROM koumoku_tbl AS kt WHERE kt.koumoku_parent = ".$kSeq." ";
	$strSQL .= "AND kt.koumoku_mode = 1 ";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_num_rows($objRec) > 0){
		$objData = pg_fetch_object($objRec, 0);
		$kcnt = $objData->cnt;
	}
	$ret = $kcnt;
	return $ret;
}

function get_colspanD($dSeq){
	//大区分に紐付く小区分の数を取得
	$strSQL  = "SELECT count(*) AS cnt FROM koumoku_tbl AS kt2 WHERE kt2.koumoku_parent = ".$dSeq." ";
	$strSQL .= "AND kt2.koumoku_mode = 2 ";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_num_rows($objRec) > 0){
		$objData = pg_fetch_object($objRec, 0);
		$dcnt = $objData->cnt;
	}
	$ret = $dcnt;
	return $ret;
}

?>