SIM0930.php 6.39 KB

Raw Blame History Permalink

<?PHP
//*****************************************************************************
//* プログラム名：区分編集画面
//* プログラムID：SIM0930.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");

//期間区分取得
$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;

		//大区分に紐付く小区分の数を取得
		$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/SIM0930.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

/*
<!--
	<script type="text/javascript" src="./js/jquery.tablednd_0_5.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>
-->
*/

//タイトル部分の表示
dspTitle($PHP_SYSNAME, $PHP_GROUP_NAME, $PHP_BUMON_NAME, $PHP_USER_NAME, "0930");


//メイン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('SeqMax',$SeqMax);
$o_smarty->assign('rankMax',$rankMax);

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

//フッタ部分の表示
dspFooter($DEFARR[1], $DEFARR[3]);


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;
}

?>