<?PHP 
//*****************************************************************************
//* プログラム名：入金画面
//* プログラムID：SIM0200.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");

$SIM_cboYaer = $_POST["SIM_cboYaer"];         //年
$SIM_cboMon = $_POST["SIM_cboMon"];           //月
$SIM_cboKikan = $_POST["SIM_cboKikan"];       //期間
$bSeq = $_POST["bSeq"];         //期間区分シーケンスNo.
$dSeq = $_POST["dSeq"];         //項目シーケンスNo.
$chgmode = $_GET["chgmode"];    //絞込みモード
$bFlg = $_REQUEST["back"];        //入力画面から遷移フラグ
$sMode = $_REQUEST["sMode"];       //収支モード
$bumon = $PHP_BUMON_SEQ;

//メニューボックスの年取得
if($SIM_cboYaer == False){
	$SIM_cboYaer = date("Y");
}
$lstY = year_lst($SIM_cboYaer);

//月取得
if($SIM_cboMon == False){
	$SIM_cboMon = date("n");
}
if($SIM_cboYaer.sprintf('%02d', $SIM_cboMon) < $START_YEAR.sprintf('%02d', $START_MONTH)){
	$SIM_cboYaer = $START_YEAR;
	$SIM_cboMon = $START_MONTH;
}

//何ヶ月表示？
$DISP_CNT = 12;

//年月配列
for($i=0;$i<$DISP_CNT;$i++){
	$dataYM[$i][0]=$SIM_cboYaer;
	$dataYM[$i][1]=intval($SIM_cboMon) + $i;
	if($dataYM[$i][1] > 12){
		$dataYM[$i][0] = intval($dataYM[$i][0]) + 1;
		$dataYM[$i][1] = intval($SIM_cboMon) + $i - 12;
	}
}
//前の年月
$prevYM[0] = $SIM_cboYaer;
$prevYM[1] = intval($SIM_cboMon) -1;
if($prevYM[1] < 1){
	$prevYM[0] = intval($prevYM[0]) - 1;
	$prevYM[1] = intval($SIM_cboMon) + 11;
}
//当月
$nowYM[0] = date("Y");
$nowYM[1] = date("n");

//基準年月
$strSQL = "SELECT * FROM rcv_kanri WHERE kanri_id=2";
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_numrows($objRec)>0){
		$objData = pg_fetch_object($objRec, 0);
		$Kijyun_Month   = $objData->kanri_data;
}else{
		$Kijyun_Month   = "4";
}
if($SIM_cboMon < $Kijyun_Month){
	$baseYM[0] = $SIM_cboYaer - 1;
	$baseYM[1] = $Kijyun_Month;
}else if($Kijyun_Month + 12 - $SIM_cboMon > 12){
	$baseYM[0] = $SIM_cboYaer - 1;
	$baseYM[1] = $Kijyun_Month;
}else{
	$baseYM[0] = $SIM_cboYaer;
	$baseYM[1] = $Kijyun_Month;
}

//メニューボックスの分類名取得
if ($bFlg ==="1") {
	$bunrui = edit_bunrui("999");
}else{
	$bunrui = edit_bunrui($bSeq);
}

//メニューボックスの大項目取得
if ($chgmode === "b") {
	$dkoumoku = edit_dai($bumon, $bSeq, "999");
}elseif($bFlg ==="1") {
	$dkoumoku = edit_dai($bumon, "999", "999");
}else{
	$dkoumoku = edit_dai($bumon, $bSeq, $dSeq);
}

//初回表示時全件表示
if ($bSeq == False || $bFlg == 1){
	$bSeq = "999";
}
if ($dSeq == False || $bFlg == 1){
	$dSeq = "999";
}

$strSQL = "";

//期間区分ごとに各金額集計
$strSQL = "SELECT bunrui_seq, bunrui_start, bunrui_end FROM bunrui_tbl ";
	//入力画面からの遷移時、全件表示
	if ($bFlg == False){
		//分類の絞込み
		if ($bSeq !== "999") {
			$strSQL .= "WHERE bunrui_seq = ". $bSeq ." ";
		}
	}
	$strSQL .= "ORDER BY disp_rank";
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_numrows($objRec) > 0){
	for ($i = 0; $i < pg_numrows($objRec); $i++) {
		$objData = pg_fetch_object($objRec, $i);
		$kikanNo[$i] = sprintf("%02d", $i);
		$kikanSt[$i] = sprintf("%02d", $objData->bunrui_start);
		$kikanEd[$i] = sprintf("%02d", $objData->bunrui_end );
	}
}

//期間区分のループ
for ($i = 0; $i < count($kikanNo); $i++) {
	//月ループ
	for($j = 0; $j < 12; $j++){
		$monthNo[$j] = sprintf("%02d", $dataYM[$j][1]);
		
		if ($sMode == 1 || $sMode == False){
			//収支モード 収入
			//売上金・入金情報の取得
			$strSQL  = "SELECT * FROM rcv_tbl ";
			$strSQL .= " WHERE rcv_seikyukbn = 1 AND ( ";
			$strSQL .= "  (seikyu_kigen >= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanSt[$i]."' ";
			$strSQL .= "  AND seikyu_kigen <= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanEd[$i]."' ";
			$strSQL .= "  AND (nyukin_date is null OR nyukin_date = '') ";
			$strSQL .= "  ) OR ( ";
			$strSQL .= "  nyukin_date >= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanSt[$i]."' ";
			$strSQL .= "  AND nyukin_date <= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanEd[$i]."' ";
			$strSQL .= "  )";
			$strSQL .= " )";
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if(pg_numrows($objRec) > 0){
				//項目ループ
				for ($k = 0; $k < pg_numrows($objRec); $k++) {
					$objData = pg_fetch_object($objRec, $k) ;
					if ( mb_strlen($objData->nyukin_date) > 0) {
						$nyuNyukin[$i][$j] = intval($nyuNyukin[$i][$j]) + intval($objData->nyukin_money) ;
					}else{
						$nyuNyukin[$i][$j] = intval($nyuNyukin[$i][$j]) + intval($objData->seikyu_money) ;
					}
				}
			}
			
			//借入金・入金情報の取得
			$strSQL  = "SELECT kt.kariire_seq, kt.kariiregaku FROM kariire_tbl AS kt ";
			$strSQL .= " WHERE kt.kariire_date >= ".sprintf('%04d', $dataYM[$j][0]).$monthNo[$j].$kikanSt[$i];
			$strSQL .= " AND kt.kariire_date <= ".sprintf('%04d', $dataYM[$j][0]).$monthNo[$j].$kikanEd[$i];
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if(pg_numrows($objRec) > 0){
				//項目ループ
				for ($k = 0; $k < pg_numrows($objRec); $k++) {
					$objData = pg_fetch_object($objRec, $k) ;
					$kariirekin[$i][$j] = intval($kariirekin[$i][$j]) + intval($objData->kariiregaku) ;
				}
			}
			
		}elseif ($sMode == 2){
			//収支モード 支出
			
			//売上金・出金情報の取得
			$strSQL  = "SELECT * FROM rcv_tbl ";
			$strSQL .= " WHERE rcv_seikyukbn = 2 AND ( ";
			$strSQL .= "  (seikyu_kigen >= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanSt[$i]."' ";
			$strSQL .= "  AND seikyu_kigen <= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanEd[$i]."' ";
			$strSQL .= "  AND (nyukin_date is null OR nyukin_date = '') ";
			$strSQL .= "  ) OR ( ";
			$strSQL .= "  nyukin_date >= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanSt[$i]."' ";
			$strSQL .= "  AND nyukin_date <= '".sprintf('%04d', $dataYM[$j][0])."/".$monthNo[$j]."/".$kikanEd[$i]."' ";
			$strSQL .= "  )";
			$strSQL .= " )";
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if(pg_numrows($objRec) > 0){
				//項目ループ
				for ($k = 0; $k < pg_numrows($objRec); $k++) {
					$objData = pg_fetch_object($objRec, $k) ;
					if ( mb_strlen($objData->nyukin_date) > 0) {
						$nyuShukin[$i][$j] = intval($nyuShukin[$i][$j]) + intval($objData->nyukin_money) ;
					}else{
						$nyuShukin[$i][$j] = intval($nyuShukin[$i][$j]) + intval($objData->seikyu_money) ;
					}
				}
			}

			//借入金・返済情報の取得
			$strSQL  = "SELECT pt.plan_seq, pt.total FROM plan_tbl AS pt ";
			$strSQL .= " INNER JOIN kariire_tbl AS kt ON (pt.kariire_seq = kt.kariire_seq) ";
			$strSQL .= " WHERE pt.hensai_year = ".$dataYM[$j][0]." AND pt.hensai_month = ".$monthNo[$j]." ";
			$strSQL .= " AND kt.hensai_date >= ".$kikanSt[$i]." AND kt.hensai_date <= ".$kikanEd[$i]." ";

			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if(pg_numrows($objRec) > 0){
				//項目ループ
				for ($k = 0; $k < pg_numrows($objRec); $k++) {
					$objData = pg_fetch_object($objRec, $k) ;
					$kariirekin[$i][$j] = intval($kariirekin[$i][$j]) + intval($objData->total) ;
				}
			}
			
		}
		//表示条件を取得
		$dspcol_kar[$i] = intval($dspcol_kar[$i]) + intval($kariirekin[$i][$j]);
		$dspcol_nyu[$i] = intval($dspcol_nyu[$i]) + intval($nyuNyukin[$i][$j]);
		$dspcol_shu[$i] = intval($dspcol_shu[$i]) + intval($nyuShukin[$i][$j]);
	}
}

//収支切替・更新
if ($bSeq == True && $dSeq == True) {

	$strSQL = "SELECT bt.bunrui_seq, bt.bunrui_name, bt.bunrui_start, bt.bunrui_end, kt.koumoku_seq AS kt_seq, kt.koumoku_name AS kt_name, ";
	$strSQL .= "kt.nyukin_mode, kt2.koumoku_seq AS kt2_seq, kt2.koumoku_name AS kt2_name ";
	$strSQL .= "FROM bunrui_tbl AS bt INNER JOIN koumoku_tbl AS kt ON (bt.bunrui_seq = kt.koumoku_parent) ";
	$strSQL .= "INNER JOIN koumoku_tbl AS kt2 ON (kt.koumoku_seq = kt2.koumoku_parent) ";
	$strSQL .= "INNER JOIN kengen_tbl AS ken ON (ken.koumoku_seq = kt2.koumoku_seq) ";
	$strSQL .= "WHERE kt.koumoku_mode = 1 AND kt2.koumoku_mode = 2 AND ken.bumon_seq = ".$bumon." " ;

	//入力画面からの遷移時、全件表示
	if ($bFlg == False){
		//分類の絞込み
		if ($bSeq !== "999") {
			$strSQL .= "AND bt.bunrui_seq = ". $bSeq ." ";
			//大項目の絞込み
			if ($chgmode !== "b") {
				if ($dSeq !== "999") {
					$strSQL .= "AND kt.koumoku_seq = ". $dSeq ." ";
				}
			}
		}
	}
	$strSQL .= "ORDER BY bt.disp_rank, kt.disp_rank, kt2.disp_rank";
}

$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$bSeq = 0;
$dSeq = 0;

if(pg_num_rows($objRec) > 0){
	//レコード取得
	for ($i = 0; $i < pg_numrows($objRec); $i++) {
	
		$objData = pg_fetch_object($objRec, $i);
		$objTabDat[$i] = $objData;
		$cSeqDisp[$i] = intval($objData->kt2_seq);
		$cNameDisp[$i] = $objData->kt2_name;

		if ($sMode == 1 || $sMode == False){
			//収入 金額の取得
			for ($j=0;$j<count($dataYM);$j++) {
				$strSQL2 = "select * from nyukin_tbl where koumoku_seq = ".$cSeqDisp[$i]." and nyukin_year = ".$dataYM[$j][0]." and nyukin_month = ".$dataYM[$j][1]." and nyukin_mode = 1 ";
				$objRec2 = pg_exec($strSQL2);
				if($objRec2==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
				}
				if(pg_numrows($objRec2) > 0){
					$objData2 = pg_fetch_object($objRec2, 0);
					$dataIn[$i][$j] = number_format($objData2->nyukin_data);
				}
				//コメントの取得
				$jbuff = intval($j)+1;
				$strSQL3 = "SELECT * FROM comment_tbl WHERE koumoku_seq = ".$cSeqDisp[$i]." and nyukin_year = ".$dataYM[$j][0]." and nyukin_month = ".$dataYM[$j][1]." AND nyukin_mode = 1 ";
				$objRec3 = pg_exec($strSQL3);
				if(pg_numrows($objRec3) > 0){
					$objData3 = pg_fetch_object($objRec3, 0);
					$CommentIn[$i][$j] = $objData3->comment_text;
				}
			}
			
		}elseif ($sMode == 2){
			//支出
			for ($j=0;$j<count($dataYM);$j++) {
				$strSQL2 = "select * from nyukin_tbl where koumoku_seq = ".$cSeqDisp[$i]." and nyukin_year = ".$dataYM[$j][0]." and nyukin_month = ".$dataYM[$j][1]." and nyukin_mode = 2 ";
				$objRec2 = pg_exec($strSQL2);
				if($objRec2==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
				}
				if(pg_numrows($objRec2) > 0){
					$objData2 = pg_fetch_object($objRec2, 0);
					$dataOut[$i][$j] = number_format($objData2->nyukin_data);
				}
				
				//コメントの取得
				$ibuff = intval($j)+1;
				$strSQL3 = "SELECT * FROM comment_tbl WHERE koumoku_seq = ".$cSeqDisp[$i]." and nyukin_year = ".$dataYM[$j][0]." and nyukin_month = ".$dataYM[$j][1]." AND nyukin_mode = 2 ";
				$objRec3 = pg_exec($strSQL3);
				if(pg_numrows($objRec3) > 0){
					$objData3 = pg_fetch_object($objRec3, 0);
					$CommentOut[$i][$j] = $objData3->comment_text;
				
				}
			}
		}
	}
	//表の縦の行数取得
	$cCnt = pg_num_rows($objRec);
}

//金額単位取得
$strSQL = "select * from start_tbl";
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_numrows($objRec)>0){
	$objData = pg_fetch_object($objRec, 0);
	$sUnit  = $objData->start_unit;

	switch ($sUnit) {
	    case 0:
	        $sUnitName = "円";
	        break;
	    case 1:
	        $sUnitName = "千円";
	        break;
	    case 2:
	        $sUnitName = "万円";
	        break;
	}

}else{
	$sUnitName  = "";
}

//借入・入金管理のアクセス権取得
$strSQL = "SELECT * FROM user_sikaku WHERE user_seq = ".$PHP_USER_SEQ." AND sikaku_kbn = '20'" ;
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_num_rows($objRec) > 0){
	//レコード取得
	for ($i = 0; $i < pg_numrows($objRec); $i++) {
		$objData = pg_fetch_object($objRec, $i);
		$nyuAuth = $objData->sikaku_mode ;
	}
}

$strSQL = "SELECT * FROM user_sikaku WHERE user_seq = ".$PHP_USER_SEQ." AND sikaku_kbn = '30'" ;
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_num_rows($objRec) > 0){
	//レコード取得
	for ($i = 0; $i < pg_numrows($objRec); $i++) {
		$objData = pg_fetch_object($objRec, $i);
		$karAuth = $objData->sikaku_mode ;
	}
}

//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/jquery-ui-1.7.1.custom.min.js"></script>
	<script type="text/javascript" src="./js/jquery.tipsy.js"></script>
	<script type="text/javascript" src="./js/SIM0200.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 rel="stylesheet" href="./templates/SIMmain.css" type="text/css" />
</head>
<?PHP 

//タイトル部分の表示
dspTitle($PHP_SYSNAME, $PHP_GROUP_NAME, $PHP_BUMON_NAME, $PHP_USER_NAME,"http://www.f-mtclab.net/article/134351395.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_SYSNAME',$PHP_SYSNAME);
$o_smarty->assign('PHP_GROUP_NAME',$PHP_GROUP_NAME);
$o_smarty->assign('PHP_BUMON_NAME',$PHP_BUMON_NAME);
$o_smarty->assign('PHP_USER_NAME',$PHP_USER_NAME);
$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('START_YEAR',$START_YEAR);
$o_smarty->assign('START_MONTH',$START_MONTH);

$o_smarty->assign('lstY',$lstY);

$o_smarty->assign('SIM_cboYaer',$SIM_cboYaer);
$o_smarty->assign('SIM_cboMon',$SIM_cboMon);
$o_smarty->assign('SIM_cboKikan',$SIM_cboKikan);

$o_smarty->assign('nyuAuth',$nyuAuth);
$o_smarty->assign('karAuth',$karAuth);

//$nyuNyukin[期間数][月数]
$o_smarty->assign('monthNo',$monthNo);
$o_smarty->assign('nyuNyukin',$nyuNyukin);
$o_smarty->assign('nyuShukin',$nyuShukin);
$o_smarty->assign('kariirekin',$kariirekin);
$o_smarty->assign('dspcol_nyu',$dspcol_nyu);
$o_smarty->assign('dspcol_shu',$dspcol_shu);
$o_smarty->assign('dspcol_kar',$dspcol_kar);

$o_smarty->assign('karNo',$karNo);
$o_smarty->assign('karKei',$karKei);
$o_smarty->assign('henNo',$henNo);
$o_smarty->assign('henKei',$henKei);

$o_smarty->assign('sUnitName',$sUnitName);
$o_smarty->assign('bSeq',$bSeq);
$o_smarty->assign('bunrui',$bunrui);

$o_smarty->assign('dSeq',$dSeq);
$o_smarty->assign('dkoumoku',$dkoumoku);

$o_smarty->assign('cCnt',$cCnt);
$o_smarty->assign('cSeq',$cSeqDisp);
$o_smarty->assign('cName',$cNameDisp);

$o_smarty->assign('nowYM',$nowYM);
$o_smarty->assign('prevYM',$prevYM);
$o_smarty->assign('baseYM',$baseYM);
$o_smarty->assign('dataYM',$dataYM);
$o_smarty->assign('sMode',$sMode);
$o_smarty->assign('objTabDat',$objTabDat);
$o_smarty->assign('dataIn',$dataIn);
$o_smarty->assign('dataOut',$dataOut);
$o_smarty->assign('CommentIn',$CommentIn);
$o_smarty->assign('CommentOut',$CommentOut);

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

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


//関数
function year_lst($prm){
	$ret = "";
	for($i=($prm-2);$i<=($prm+2);$i++){
		if($i==$prm){
			$ret .= "<option value='".$i."' selected>".$i."</option>";
		}else{
			$ret .= "<option value='".$i."'>".$i."</option>";
		}
	}
	return $ret;
}

function edit_bunrui($prm){
	$strSQL = "select * from bunrui_tbl order by disp_rank";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	for ($j = 0; $j < pg_numrows($objRec); $j++) {
		$objData = pg_fetch_object($objRec, $j);
		$bSeq[$j] = $objData->bunrui_seq;
		$bName[$j] = $objData->bunrui_name;
	}
	//引数が空のとき、全件取得
	if ($prm == false){
		$prm = 999;
	}
	
	$ret = "";
	for($i=0;$i<count($bSeq);$i++){
		if($bSeq[$i] == $prm){
			$ret .= "<option value='".$bSeq[$i]."' selected>".$bName[$i]."</option>";
		}else{
			$ret .= "<option value='".$bSeq[$i]."'>".$bName[$i]."</option>";
		}
	}
	if (999 == $prm) {
		$ret .= "<option value="."\"999\""." selected>全て</option>";
	}else{
		$ret .= "<option value="."\"999\"".">全て</option>";
	}
	
	return $ret;
}

//大区分セレクトメニュー作成
function edit_dai($bumon, $prm, $prm2){
	
	$ret = "";

	//親シーケンスNo.が無いとき、全件取得
	if ($prm==FALSE) {
		$prm = 999;
	}

	if ($prm!="999") {
		
		$strSQL  = "SELECT DISTINCT kou1.koumoku_seq, kou1.koumoku_name, kou1.disp_rank ";
		$strSQL .= "FROM koumoku_tbl AS kou2 ";
		$strSQL .= "INNER JOIN koumoku_tbl AS kou1 ON (kou1.koumoku_seq = kou2.koumoku_parent) ";
		$strSQL .= "INNER JOIN kengen_tbl AS ken ON (ken.koumoku_seq = kou2.koumoku_seq) ";
		$strSQL .= "WHERE ";
		$strSQL .= "kou1.koumoku_parent = ".$prm." AND ";
		$strSQL .= "kou2.koumoku_mode = 2 AND ";
		$strSQL .= "kou1.koumoku_mode = 1 AND ";
		$strSQL .= "ken.bumon_seq = ".$bumon." " ;
		$strSQL .= "ORDER BY kou1.disp_rank ";

		$objRec = pg_exec($strSQL);
		if($objRec==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		for ($j = 0; $j < pg_numrows($objRec); $j++) {
			$objData = pg_fetch_object($objRec, $j);
			$kSeq[$j] = $objData->koumoku_seq;
			$kName[$j] = $objData->koumoku_name;
		}

		for($i=0;$i<count($kSeq);$i++){
			if($kSeq[$i] == $prm2){
				$ret .= "<option value='".$kSeq[$i]."' selected>".$kName[$i]."</option>";
			}else{
				$ret .= "<option value='".$kSeq[$i]."'>".$kName[$i]."</option>";
			}
		}
	}
	
	if($prm2 === "999" || $prm === "999"){
		$ret .= "<option value=\"999\" selected>全て</option>";
	}else{
		$ret .= "<option value=\"999\">全て</option>";
	}
	
	return $ret;
}
	
//先頭の分類シーケンスNo.を取得
function get_bunrui_head($prm){
	
	$strSQL = "select * from bunrui_tbl order by disp_rank";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0) {
		$objData = pg_fetch_object($objRec, 0);
		$ret = $objData->bunrui_seq;
	}
	
	return $ret;
}
	
//期間中で先頭となる大項目シーケンスNo.を取得(引数：部門seq,分類Seq、返り値：大項目Seq)
function get_dai_head($bumon, $prm){

	$strSQL = "SELECT * FROM koumoku_tbl WHERE koumoku_mode = 1 AND koumoku_parent = ".$prm." ORDER BY disp_rank";

		$strSQL  = "SELECT kou1.koumoku_seq, kou1.koumoku_name, kou2.koumoku_seq, kou2.koumoku_name ";
		$strSQL .= "FROM koumoku_tbl AS kou1 ";
		$strSQL .= "INNER JOIN koumoku_tbl AS kou2 ON (kou2.koumoku_parent = kou1.koumoku_seq) ";
		$strSQL .= "INNER JOIN kengen_tbl AS ken ON (kou2.koumoku_seq = ken.koumoku_seq) ";
		$strSQL .= "WHERE ";
		$strSQL .= "kou1.koumoku_mode = 1 AND kou1.koumoku_parent = ".$prm." AND ";
		$strSQL .= "kou2.koumoku_mode = 2 AND ken.bumon_seq = ".$bumon." ";
		$strSQL .= "ORDER BY disp_rank ";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0) {
		$objData = pg_fetch_object($objRec, 0);
		$ret = $objData->koumoku_seq;
	}

	return $ret;
}

?>