<?PHP 
//*****************************************************************************
//* プログラム名：返済計画
//* プログラムID：BRR0300.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");
//エラー
$err = $_POST["err"];
$erro = $_POST["err_over"];
$errd = $_POST["err_down"];
//テキスト変更時
$chk = $_POST["chk"];
//借入金テーブルのSEQ取得
$kr_seq = $_POST["kr_seq"];
//値の受け渡し
$kariire_seq = $kr_seq;

$yyyy = $_POST["yyyy"];
$mon = $_POST["mon"];
$gseq = $_POST["gseq"];
$hseq = $_POST["hseq"];
$kseq = $_POST["kseq"];
$mode = $_POST["mode"];

$hensai_sd = $_POST["hensai_sd"];
$hensai_ed = $_POST["hensai_ed"];
$kmode = $_POST["kmode"];

$strSQL = "select * from kariire_tbl where kariire_seq=".$kariire_seq;
$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if(pg_numrows($objRec)>0){
		$objData = pg_fetch_object($objRec, 0);
		$FIRST_YEAR = $objData->first_hensai;
		$FIRST_MONTH = $objData->first_month;
		$START_MONEY_BRR = $objData->kariiregaku;
		$kr_saki = $objData->ginko_code;	//銀行コード
		$kariire_date = $objData->kariire_date;	
		$kinri = $objData->interest_cost;	//金利
		$siharai = $objData->siharai_shubetu;	//支払い方法
		$hensai_count = $objData->hensai_count;//返済回数
		//***************仮***********************/
		//if($hensai_count > 56){
		//	$hensai_count= 36;
		//}
		$kr_kubun = $objData->kariire_kubun;	//長期OR短期
		
		if ($kr_kubun = 0)
		{
			$kr_kubun = "長期";
		}
		else
		{
			$kr_kubun = "短期";
		}
	$siha="";
	switch($siharai)
	{
		case 0:
			$siha="元金返済方式";
			break;
		case 1:
			$siha="元利返済方式";
			break;
		case 2:
			$siha="アドオン返済方式";
			break;
	}
}
//借入先名
			$strSQL = "select * from mst_bank where bank_id =".$kr_saki;
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if(pg_numrows($objRec)>0){
					$objData = pg_fetch_object($objRec, 0);
					$kr_name  = $objData->bank_name;
			}





$flg_y = 0;
$flg_m = 0;
$dataYMCOLOR = "";
//年月配列
for($i=0;$i<$hensai_count;$i++){
	//返済回数
	$con[$i] = $i+1;
	if($flg_y == 0){
		$dataYM[$i][0]=$FIRST_YEAR;
		$flg_y +=1;
	}
	else{
		$dataYM[$i][0] = $dataYM[($i-1)][0];
	}
	if($flg_m == 0){
		$dataYM[$i][1] = $FIRST_MONTH;
		$flg_m += 1;
	}
	else{
		$dataYM[$i][1] = $dataYM[($i-1)][1] +1;
	}
	if($dataYM[$i][1] > 12){
		$dataYM[$i][0] = intval($dataYM[($i-1)][0]) + 1;
		$dataYM[$i][1] = intval($dataYM[$i][1])  - 12;
	}
	//色
	if($dataYM[$i][0] % 2 == 0) {
		$dataYMCOLOR[$i] = "#DAFF7F";
	}else{
		$dataYMCOLOR[$i] = "#FFE97F";
	}
	
/*******************************************************
	plan_tblから値のとりだし
*******************************************************/
	$strSQL = "select * from plan_tbl WHERE kariire_seq = ".$kariire_seq."  AND hensai_year = ".$dataYM[$i][0]." AND hensai_month = ".$dataYM[$i][1];
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($objRec)>0){
			$objData = pg_fetch_object($objRec, 0);			
			$plan_seq[$i] = $objData->plan_seq;
			$hensai_year[$i] = $objData->hensai_year;
			$hensai_month[$i] = $objData->hensai_month;
			$hensaigaku[$i] = $objData->hensaigaku;
			$kr_seq[$i] = $objData->kariire_seq;
			$auto_cal[$i] = $objData->auto_cal;
			$up_name = $objData->up_name;
			$up_time = $objData->up_time;
	}
	$nyu_text[$i] = "<input type=".'"text"'." name=".'"'."nyu_text".$i.'"'." size=".'9'." value=".'"'.$hensaigaku[$i].'"'." onChange=".'"'."chk_on('$i');".'"'." />";
	if($auto_cal[$i] == 1){
		$nyu_chk[$i] = "<input type=".'"checkbox"'." name=".'"'."nyu_chk".$i.'"'." value=".'"1'.'"'." checked>";
	}else{
		$nyu_chk[$i] = "<input type=".'"checkbox"'." name=".'"'."nyu_chk".$i.'"'." value=".'"1'.'"'.">";
	}
}
//HTMLヘッダの書き出し
//金額単位取得
$strSQL = "select start_unit 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);
	$mUnit  = $objData->start_unit;
	switch ($mUnit) {
	    case 0:
	        $mUnitName = "円";
	        break;
	    case 1:
	        $mUnitName = "千円";
	        break;
	    case 2:
	        $mUnitName = "万円";
	        break;
	}
}else{
	$mUnitName  = "円";
}
?>
<!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; charset=euc-jp">
	<meta http-equiv="content-style-type" content="text/css">
	<meta name="robots" content="noindex, nofollow">
	<script type="text/javascript" src="./js/BRR0300.js"></script>
	<script type="text/javascript" src="./js/BRR.js"></script>
	<script type="text/javascript" src="./js/input_chk.js"></script>
	<title><?PHP  echo($PHP_SYSNAME); ?></title>
	<link type="text/css" href="./templates/css/BRR.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/134361068.html#help0");
$o_smarty->assign('DEFARR_BRR',$DEFARR_BRR);
$o_smarty->assign('PHP_SYSNAME',$PHP_SYSNAME);
$o_smarty->assign('lstY',$lstY);
$o_smarty->assign('kr_K',$kr_K);//借入区分
$o_smarty->assign('lstH',$lstH);//返済区分
$o_smarty->assign('err',$err);
$o_smarty->assign('erro',$erro);
$o_smarty->assign('errd',$errd);
$o_smarty->assign('lstM',$lstM);
$o_smarty->assign('lstK',$lstK);
$o_smarty->assign('DISP_CNT',$DISP_CNT);
$o_smarty->assign('chousei',$chousei);
$o_smarty->assign('shikin',$shikin);
//借入先名
$o_smarty->assign('kr_name',$kr_name);

$o_smarty->assign('dspshikin',$dspshikin);
$o_smarty->assign('sUnitName',$sUnitName);
$o_smarty->assign('dataYM',$dataYM);
$o_smarty->assign('mUnitName',$mUnitName);//借入日
$o_smarty->assign('kariire_date',date("Y年n月j日", strtotime($kariire_date)));//借入日
$o_smarty->assign('kariire_seq',$kariire_seq);//借入本数SEQ
$o_smarty->assign('FIRST_YEAR',$FIRST_YEAR);//初回返済tosi
$o_smarty->assign('FIRST_MONTH',$FIRST_MONTH);//初回返済tosi
$o_smarty->assign('START_MONEY_BRR',$START_MONEY_BRR);//当初借入額
$o_smarty->assign('START_MONEY_fm',number_format($START_MONEY_BRR));//当初借入額
$o_smarty->assign('kr_kubun',$kr_kubun);//借入区分
$o_smarty->assign('kinri',$kinri);//借入利率（金利）
$o_smarty->assign('hensai_count',$hensai_count);//返済回数
$o_smarty->assign('siha',$siha);//支払い区分
$o_smarty->assign('con',$con);//支払い回数
$o_smarty->assign('nyu_text',$nyu_text);//INPUT　TEXT
$o_smarty->assign('nyu_chk',$nyu_chk);//INPUT　checkbox

$o_smarty->assign('yyyy',$yyyy);
$o_smarty->assign('mon',$mon);
$o_smarty->assign('gseq',$gseq);
$o_smarty->assign('hseq',$hseq);
$o_smarty->assign('kseq',$kseq);
$o_smarty->assign('mode',$mode);

$o_smarty->assign('hensai_sd',$hensai_sd);
$o_smarty->assign('hensai_ed',$hensai_ed);
$o_smarty->assign('kmode',$kmode);

$o_smarty->assign('siharai',$siharai);
$o_smarty->assign('dataYMCOLOR',$dataYMCOLOR);

$o_smarty->assign('SIM_cboYaer',$_POST["SIM_cboYaer"]);
$o_smarty->assign('SIM_cboMon',$_POST["SIM_cboMon"]);
$o_smarty->assign('SIM_cboKikan',$_POST["SIM_cboKikan"]);

$o_smarty->assign('up_name',$up_name);
$o_smarty->assign('up_time',$up_time);

$o_smarty->display('BRR0300.tpl');
//フッタ部分の表示
	dspFooter($DEFARR_BRR[1], $DEFARR_BRR[3],"http://www.f-mtclab.net/article/134361068.html#help0");
?>