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

//*** 拠点情報 ***//
$strSQL = "SELECT * FROM bumon_tbl WHERE bumon_seq = ".$area_id." ";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$objData = pg_fetch_object($objRec, 0);
$AreaData = $objData->bumon_name;

//*** 業務情報 ***//
$strSQL = "SELECT * FROM mst_gyoumu WHERE gyoumu_id = ".$gyoumu_id." ";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$objData = pg_fetch_object($objRec, 0);
$GyoumuData = $objData->gyoumu_name;
$GyoumuKikanSt = $objData->gyoumu_st_term;
$GyoumuKikanEd = $objData->gyoumu_ed_term;
if(trim($objData->gyoumu_koban)!=""){
//	$KobanData = $objData->gyoumu_koban."　";
	$KobanData = $objData->gyoumu_koban;
}else{
	$KobanData = "";
}
if(trim($objData->gyoumu_money)!=""){
	$GyoumuMoney = $objData->gyoumu_money;
}else{
	$GyoumuMoney = "0";
}

//*** 日付 ***//
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);
}

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

//*** 業者情報 ***//
$strSQL  = "SELECT";
$strSQL .= " gyousya_id, ";
$strSQL .= " gyousya_name ";
$strSQL .= "FROM ";
//$strSQL .= " rcv_tbl ,";
$strSQL .= " mst_gyousya_name AS mst_gyousya ";

//$strSQL .= " mst_gyousya ";
$strSQL .= "WHERE ";
//** 条件 **//
//$strSQL .= " rcv_tbl.rcv_gyousya_id = mst_gyousya.gyousya_id AND ";
//$strSQL .= " rcv_tbl.rcv_seikyukbn  = ".$uriageMode."        AND ";

//* 部門 *//
//$strSQL .= " rcv_tbl.rcv_area_id =".$area_id." AND ";

//* 業務 *//
//$strSQL .= " rcv_tbl.rcv_gyoumu_id = ".$gyoumu_id." AND ";
$strSQL .= " mst_gyousya.gyoumu_id = ".$gyoumu_id." ";

//* 日付範囲 *//
//switch ($cboMode) {
//case "1":
//		$strSQL .= " seikyu_kigen >='".$DateTitle[0]."/01' AND ";
//		$strSQL .= " seikyu_kigen <='".$DateTitle[11]."/99' ";
//		break;
//case "2":
//		$strSQL .= "   seikyu_kigen >='".$DateTitle[0]."/01' AND ";
//		$strSQL .= "   seikyu_kigen <='".$DateTitle[11]."/99' ";
//		$strSQL .= " (";
//		$strSQL .= "  (";
//		$strSQL .= "   nyukin_date >='".$DateTitle[0]."/01' AND ";
//		$strSQL .= "   nyukin_date <='".$DateTitle[11]."/99' ";
//		$strSQL .= "  )";
//		$strSQL .= "  OR ";
//		$strSQL .= "  (";
//		$strSQL .= "   nyukin_date = '' AND ";
//		$strSQL .= "   seikyu_kigen >='".$DateTitle[0]."/01' AND ";
//		$strSQL .= "   seikyu_kigen <='".$DateTitle[11]."/99' ";
//		$strSQL .= "  ) ";
//		$strSQL .= " )";
//		break;
//}
//$strSQL .= " GROUP BY ";
//$strSQL .= " gyousya_id,  ";
//$strSQL .= " gyousya_name ";
//echo($strSQL."<hr>");
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}

$GyousyaData = '';
//for ($intI = 0; $intI < pg_numrows($objRec); $intI++) {
//		$objData = pg_fetch_object($objRec, $intCnt);
//		if (($cboInpGyousya=="") && ($intI == 0)){
//				$cboInpGyousya = $objData->gyousya_id;
//		}
//		$GyousyaData .= '<OPTION value="'.$objData->gyousya_id.'" ';
//		if ($cboInpGyousya==$objData->gyousya_id){
//			$GyousyaData.="selected";
//		}
//		$GyousyaData .='>'.$objData->gyousya_name.'</OPTION>';
//}
if(pg_numrows($objRec) > 0){
	$objData = pg_fetch_object($objRec, 0);
	$cboInpGyousya = $objData->gyousya_id;
	$GyousyaData = $objData->gyousya_name;
}

//*** 金額情報 ***//
for ($intI = 0; $intI < count($DateTitle); $intI++) {
		$strSQL  = "SELECT";
		$strSQL .= " * ";
		$strSQL .= "FROM ";
//		$strSQL .= " receive_tbl AS rcv_tbl ";
		$strSQL .= " rcv_tbl ";
		$strSQL .= "WHERE ";
		//** 条件 **//
		$strSQL .= " rcv_seikyukbn    = ".$uriageMode." AND ";

		//* 部門 *//
		$strSQL .= " rcv_area_id =".$area_id." AND ";

		//* 業務 *//
		$strSQL .= " rcv_gyoumu_id = ".$gyoumu_id." AND ";

		//* 業者 *//
//		if($cboInpGyousya){
//			$strSQL .= " rcv_gyousya_id = ".$cboInpGyousya." AND ";
//		}

		//* 日付範囲 *//
		$strSQL .= " seikyu_kigen >='".$DateTitle[$intI]."/01' AND ";
		$strSQL .= " seikyu_kigen <='".$DateTitle[$intI]."/99' ";

//echo("<hr>".$strSQL);
		$objRec = pg_exec($strSQL);
		if($objRec==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
		if(pg_numrows($objRec)>0){
				$Chk_Flg = "0";
				for ($intJ = 0; $intJ < pg_numrows($objRec); $intJ++) {
						$objData = pg_fetch_object($objRec, $intJ);
						//echo $objData->seikyu_money."<hr>";
						$InpMoney[$intI] = (float)$InpMoney[$intI]+$objData->seikyu_money;
						//echo $InpMoney[$intI]."<hr>";
						if ($intJ==0){
								$Sel_Date = split("/", $objData->seikyu_kigen);
								$Sel_Day         = $Sel_Date[2];
								$rcv_key[$intI] = $objData->rcv_id;
						}else{
								$rcv_key[$intI]  = "err";
								$Sel_Day         = "";
						}
					$up_name[$intI]  =  $objData->up_name;
					$up_time[$intI]  =  $objData->up_time;
				}
		}else{
				$InpMoney[$intI] = "";
				$rcv_key[$intI]  = "";
				$Sel_Day         = "";
				$up_name[$intI]  = "";
				$up_time[$intI]  = "";
		}

		//echo $InpMoney[$intI]."<hr>";

		$chkDate = split("/", $DateTitle[$intI]);
		$Chk_Y = date("Y", mktime (0,0,0,intval($chkDate[1])+1,"1",$chkDate[0]));
		$Chk_M = date("m", mktime (0,0,0,intval($chkDate[1])+1,"1",$chkDate[0]));
		$Chk_D = date("d", mktime (0,0,0,intval($chkDate[1])+1,"1",$chkDate[0]));
		$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 ($Sel_Day==sprintf('%02d', $intJ)){
					$cboYoteiDay[$intI].="selected";
				}
				$cboYoteiDay[$intI] .= ' >'.sprintf('%02d', $intJ).'</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('area_id'    ,  $area_id);				//部門
$o_smarty->assign('gyoumu_id'  ,  $gyoumu_id);			//業務
$o_smarty->assign('uriageMode' ,  $uriageMode);			//売り上げモード


$o_smarty->assign('AreaData'    ,  $AreaData);				// 拠点情報
$o_smarty->assign('GyoumuData'  ,  $GyoumuData);		// 業務情報
$o_smarty->assign('KobanData'   ,  $KobanData);		
$o_smarty->assign('GyoumuKikanSt'   ,  $GyoumuKikanSt);		
$o_smarty->assign('GyoumuKikanEd'   ,  $GyoumuKikanEd);		
$o_smarty->assign('GyoumuMoney'   ,  $GyoumuMoney);		

$o_smarty->assign('cboInpGyousya' ,  $cboInpGyousya);			// 業者情報
$o_smarty->assign('GyousyaData' ,  $GyousyaData);			// 業者情報

$o_smarty->assign('optSeikyukbn',  $optSeikyukbn);		// 請求区分

$o_smarty->assign('cboYoteiDay' ,  $cboYoteiDay);			// 予定日
$o_smarty->assign('InpMoney'    ,  $InpMoney);				// 予定金額
$o_smarty->assign('rcv_key'     ,  $rcv_key);					// キー

$o_smarty->assign('newGyousya'  ,  $newGyousya);					// 新業者名

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

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

?>