<?PHP 
//*****************************************************************************
//* プログラム名：請求・入金管理
//* プログラムID：RCV3030.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');

//*** 請求･入金初期情報 ***//
$strSQL = "SELECT * FROM rcv_kanri WHERE kanri_id=1";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
if(pg_numrows($objRec)>0){
		$objData  = pg_fetch_object($objRec, 0);
		$RCV_MODE = $objData->kanri_data;
}else{
		$RCV_MODE = "0";
}

//*** 基本情報 ***//
$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);
	$start_unit = $objData->start_unit;
}else{
	$start_unit = "0";
}

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

if ($Reload==1){
		$cboInpArea      = $cboInpArea;
		$cboInpGyousya   = $cboInpGyousya;
		$cboInpGyoumu    = $cboInpGyoumu;

		$chkDay = split("#", $Days);
		$chkMoney = split("#", $Moneys);

}else if ($rcv_id !=""){
		//修正

}else{
		$cboInpArea      = "";
		$cboInpGyousya   = "";
		$cboInpGyoumu    = "";

		$optSeikyukbn[1] = "checked";
		$optSeikyukbn[2] = "";

		$txtInpMoney     = "";
		$txtInpKigen     = "";

		$txtInpNDate     = "";
		$txtInpNMoney    = "";
		$txtInpMemo      = "";

		$txtCalKigen     = date("Y/m/d");
		$txtCalNDate     = date("Y/m/d");

		for ($intCnt = 0; $intCnt < 12; $intCnt++) {
				$chkDay[$intCnt]   = "";
				$chkMoney[$intCnt] = "";
		}

		if ($chkDisp==""){
				$chkDisp=1;
		}
}

if ($chkDisp==1){
		$chkSel = "checked";
}else{
		$chkSel = "";
}

//*** 拠点情報 ***//
$strSQL = "SELECT * FROM user_area WHERE user_seq = ".$PHP_USER_SEQ." ";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$User_Area[0] = "";
for ($intCnt = 0; $intCnt < pg_numrows($objRec); $intCnt++) {
		$objData = pg_fetch_object($objRec, $intCnt);
		$User_Area[$intCnt] = $objData->area_id;
}

$AreaData = '';
if ($User_Area[0]!=""){
		$strSQL  = "SELECT * FROM bumon_tbl WHERE ";
		for ($intI = 0; $intI < count($User_Area); $intI++) {
				if ($intI!="0"){
						$strSQL  .= " OR ";
				}
				$strSQL .= " bumon_seq = ".$User_Area[$intI];
		}
		$strSQL .= " 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);

				if (($intCnt==0) && ($cboInpArea=="")){
						$cboInpArea = $objData->bumon_seq;
				}

				$AreaData .= '<OPTION value="'.$objData->bumon_seq.'" ';
				if ($cboInpArea==$objData->bumon_seq){
					$AreaData.="selected";
				}
				$AreaData .='>'.$objData->bumon_name.'</OPTION>';
		}
}


//*** 業者情報 ***//
//echo "uriageMode=".$uriageMode;
$GyousyaData = '';
$strSQL  = "SELECT * FROM mst_gyousya ";
switch ($uriageMode) {
case "1":
		$strSQL .= "WHERE disp_mode1=1 ";
		break;
case "2":
		$strSQL .= "WHERE disp_mode2=1 ";
		break;
}
$strSQL .= "ORDER BY gyousya_name";
$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);
		$GyousyaData .= '<OPTION value="'.$objData->gyousya_id.'" ';
		if ($cboInpGyousya==$objData->gyousya_id){
			$GyousyaData.="selected";
		}
		$GyousyaData .='>'.$objData->gyousya_name.'</OPTION>';
}

//*** 業務情報 ***//
$GyoumuData = '';
$strSQL = "SELECT * FROM mst_gyoumu WHERE gyoumu_area=".$cboInpArea;
if ($chkDisp==1){
		$strSQL .= " AND gyoumu_ed_term>='".$Kijyun_Year."/".$Kijyun_Month."/01' ";
}

$strSQL .= " ORDER BY gyoumu_name";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
for ($intI = 0; $intI < pg_numrows($objRec); $intI++) {
		$objData = pg_fetch_object($objRec, $intI);
		$GyoumuData .= '<OPTION value="'.$objData->gyoumu_id.'" ';
		if ($cboInpGyoumu==$objData->gyoumu_id){
			$GyoumuData.="selected";
		}
		$GyoumuData .='>'.$objData->gyoumu_name.'</OPTION>';
}

for ($intI = 0; $intI < 12; $intI++) {
		$DateTitle[$intI]   = date("Y/m", mktime(0,0,0,$Kijyun_Month+$intI,"01",$Kijyun_Year));
		$DateTitleDp[$intI] = substr(date("Y/m", mktime(0,0,0,$Kijyun_Month+$intI,"01",$Kijyun_Year)),2);

		$Chk_Y = date("Y", mktime (0,0,0,intval($Kijyun_Month)+1+$intI,"1",$Kijyun_Year));
		$Chk_M = date("m", mktime (0,0,0,intval($Kijyun_Month)+1+$intI,"1",$Kijyun_Year));
		$Chk_D = date("d", mktime (0,0,0,intval($Kijyun_Month)+1+$intI,"1",$Kijyun_Year));
		$DayMax = date("j", mktime (0,0,0,intval($Chk_M),intval($Chk_D)-1,$Chk_Y));

		$cboYoteiDay[$intI] = '<OPTION value="" >----</OPTION>';
		for ($intJ = 1; $intJ <= $DayMax; $intJ++) {
				$cboYoteiDay[$intI] .= '<OPTION value="'.sprintf('%02d', $intJ).'" ';
				if ($chkDay[$intI] == sprintf('%02d', $intJ)){
						$cboYoteiDay[$intI] .= "selected";
				}
				$cboYoteiDay[$intI] .= '>'.sprintf('%02d', $intJ).'</OPTION>';
		}
}

$cboDay = '';
for ($intI = 1; $intI <= 31; $intI++) {
		$cboDay .= '<OPTION value="'.sprintf('%02d', $intI).'" >'.sprintf('%02d', $intI).'</OPTION>';
}
$cboDay .= '<OPTION value="99" >月末</OPTION>';

$o_smarty->assign('Money_Tani' , $Money_Tani);				//金額単位
$o_smarty->assign('RCV_MODE'   , $RCV_MODE);					//請求管理モード
$o_smarty->assign('div_id'     ,  $div_id);						// DIVの場所
$o_smarty->assign('cboDay'     , $cboDay);

$o_smarty->assign('DateTitle'  , $DateTitle);
$o_smarty->assign('DateTitleDp', $DateTitleDp);

$o_smarty->assign('AreaData'    ,  $AreaData);				// 拠点情報
$o_smarty->assign('GyousyaData' ,  $GyousyaData);			// 業者情報
$o_smarty->assign('GyoumuData'  ,    $GyoumuData);		// 業務情報
$o_smarty->assign('chkSel'    ,    $chkSel);					// 業務情報

$o_smarty->assign('optSeikyukbn',  $optSeikyukbn);		// 業務情報

$o_smarty->assign('cboYoteiDay' ,  $cboYoteiDay);		  // 予定日
$o_smarty->assign('chkMoney'    ,  $chkMoney);			  // 予定金額


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

?>