<?PHP 
//*****************************************************************************
//* プログラム名：実績一括更新
//* プログラムID：ZIS0121.php
//* 機能        ：
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./inc/session_start.inc");
include("./inc/SessionChk.inc");
include("./inc/dbcon.inc");


$years_lst = Array();
$months_lst = Array();

//年月
for($i=0; $i<12; $i++){
	$months_lst[$i] = intval($_POST["months_lst"]) + $i;
	$years_lst[$i] = intval($_POST["years_lst"]);

	if($months_lst[$i] > 12){
		$months_lst[$i] = $months_lst[$i] - 12;
		$years_lst[$i] = $years_lst[$i] + 1;
	}
}
// POST受信
$numUnit = $_POST["numUnit"];
$daikbn  = $_POST["daikbn"];
$chukbn  = $_POST["chukbn"];
$shokbn  = $_POST["shokbn"];
$kamoku  = $_POST["kamoku"];
$daikbnseq  = $_POST["daikbnseq"];
$chukbnseq  = $_POST["chukbnseq"];
$shokbnseq  = $_POST["shokbnseq"];
$kamokuseq  = $_POST["kamokuseq"];
$zandaka = $_POST["zandaka"];
$money01 = $_POST["money01"];
$money02 = $_POST["money02"];
$money03 = $_POST["money03"];
$money04 = $_POST["money04"];
$money05 = $_POST["money05"];
$money06 = $_POST["money06"];
$money07 = $_POST["money07"];
$money08 = $_POST["money08"];
$money09 = $_POST["money09"];
$money10 = $_POST["money10"];
$money11 = $_POST["money11"];
$money12 = $_POST["money12"];

if(count($kamoku) !== count($money01) ){
		echo("区分・または科目に不正な項目が含まれています。<br />");
		echo("最新のＣＳＶファイルをダウンロードし、編集してください。");
		echo("<a href='ZIS0100.php'>戻る</a>");
}

//年月
//$dataY = $ZIS_cboY;
//$dataM = $ZIS_cboM;
//$numUnit = get_unitNum($zis_unit);

for($i=0;$i<count($months_lst);$i++){

	//該当月のデータ削除
	$strSQL = "DELETE FROM z_monthly_data WHERE data_year = ".$years_lst[$i]." AND data_month = ".$months_lst[$i]." ";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(DELETE)");
		exit;
	}
	
	//SEQ取得
	$newSEQ = 0;
	$strSQL = "SELECT data_seq FROM z_monthly_data ORDER BY data_seq DESC";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($objRec) > 0){
		$objData = pg_fetch_object($objRec, 0);
		$newSEQ = ($objData->data_seq) + 1;
	}else{
		$newSEQ = 0;
	}
	
	$inputmoney = Array();
	switch($i){
	case 0:
		$inputmoney = $money01;
		break;
	case 1:
		$inputmoney = $money02;
		break;
	case 2:
		$inputmoney = $money03;
		break;
	case 3:
		$inputmoney = $money04;
		break;
	case 4:
		$inputmoney = $money05;
		break;
	case 5:
		$inputmoney = $money06;
		break;
	case 6:
		$inputmoney = $money07;
		break;
	case 7:
		$inputmoney = $money08;
		break;
	case 8:
		$inputmoney = $money09;
		break;
	case 9:
		$inputmoney = $money10;
		break;
	case 10:
		$inputmoney = $money11;
		break;
	case 11:
		$inputmoney = $money12;
		break;
	default:
		$inputmoney = Array();
		break;
	}

	
	for($j=0; $j<count($kamoku); $j++ ){
		$dataseq = $newSEQ + $j;
		if(!$zandaka[$j]){
			$zandaka[$j] = "NULL";
		}
		
		if($inputmoney[$j]){
			//INSERT
			$strSQL  = "";
			$strSQL .= "INSERT INTO z_monthly_data (";
			$strSQL .= " data_seq, ";
			$strSQL .= " data_year, ";
			$strSQL .= " data_month, ";
			$strSQL .= " cseq1, ";
			$strSQL .= " cseq2, ";
			$strSQL .= " cseq3, ";
			$strSQL .= " cseq4, ";
			$strSQL .= " cseq5, ";
			$strSQL .= " data_money, ";
			$strSQL .= " base_money ";
			$strSQL .= ") VALUES(";
			$strSQL .= " ".$dataseq.", ";
			$strSQL .= " ".$years_lst[$i].", ";
			$strSQL .= " ".$months_lst[$i].", ";
			$strSQL .= " ".$daikbnseq[$j].", ";
			$strSQL .= " ".$chukbnseq[$j].", ";
			$strSQL .= " ".$shokbnseq[$j].", ";
			$strSQL .= " ".$kamokuseq[$j].", ";
			$strSQL .= " 0, ";
			$strSQL .= " ".($inputmoney[$j] * $numUnit).", ";
			$strSQL .= " ".$zandaka[$j]." ";
			$strSQL .= ")";
//echo($strSQL);
			$objRec = pg_exec($strSQL);
			if($objRec==false){
				echo("SQL実行に失敗しました(INSERT)");
				exit;
			}
		}
	}

}

//*** 単位計算値 ***//
function get_unitNum($ptn_flg) { 
		$strReturn = "";
		switch ($ptn_flg) {
		case "1": $strReturn = 1000; break;
		case "2": $strReturn = 10000; break;
		default : $strReturn = 1; break;
		}
		return $strReturn;
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE></TITLE>
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
	function chk(){
		document.frm.action="ZIS0100.php";
		document.frm.method="POST";
		document.frm.submit();
		return false;
	}
-->
</SCRIPT></HEAD>
<BODY onLoad="return chk();">
<form name="frm">
<input type="hidden" name="ZIS_cboY" value="<?PHP  echo $dataY; ?>">
<input type="hidden" name="ZIS_cboM" value="<?PHP  echo $dataM; ?>">
</form>
</BODY>
</HTML>