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


//*** 基本情報 ***//
$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;
}

//部門選択
$cboArea = $_REQUEST["cboArea"];
$sWhere = "";

$AreaData = '<option value="" ';
if ($cboArea==""){
	$AreaData .= "selected";
}
$AreaData .= '>全部門</option>';

$strSQL = "SELECT * FROM bumon_tbl ";
$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);

		$AreaData .= '<option value="'.$objData->bumon_seq.'" ';
		if ($cboArea==$objData->bumon_seq){
			$AreaData.="selected";
			if(!$sWhere){
				$sWhere .= " WHERE ";
			}else{
				$sWhere .= " AND ";
			}
			$sWhere .= " bumon_seq = ".$cboArea." ";
		}
		$AreaData .='>'.$objData->bumon_name.'</option>';
}


//期間選択
$cboKikan = $_REQUEST["cboKikan"];

//*** 請求･入金初期情報 ***//
$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);
		$start_month = $objData->kanri_data;
}else{
		$start_month = "4";
}

if ($start_month > date("n")){
		$To_NYear = (int)date("Y")-1;
}else{
		$To_NYear = date("Y");
}
$To_NMonth  = sprintf("%02d", $start_month);

$Bf_Year   =(int)$To_NYear-1;
$Bf_Month  = $To_NMonth;
$To_Year   = $To_NYear;
$To_Month  = $To_NMonth;
$Af_Year   = (int)$To_NYear+1;
$Af_Month  = $To_NMonth;

$KikanData = '<option value="" ';
if ($cboKikan == ""){
	$KikanData .= 'selected';
}
$KikanData .= '>全期間</option>';
$KikanData .= '<option value="1" ';
if ($cboKikan=="1"){
	$KikanData.="selected";
	if(!$sWhere){
		$sWhere .= " WHERE ";
	}else{
		$sWhere .= " AND ";
	}
	$sWhere .= " (gyoumu_st_term < '".$To_Year."/".$To_Month."/01' ";
	$sWhere .= " OR gyoumu_ed_term < '".$To_Year."/".$To_Month."/01') ";
	$sWhere .= " AND gyoumu_ed_term <> '' ";
}
$KikanData .= '>前期以前</option>';

$KikanData .= '<option value="2" ';
if ($cboKikan=="2"){
	$KikanData.="selected";
	if(!$sWhere){
		$sWhere .= " WHERE ";
	}else{
		$sWhere .= " AND ";
	}
	$sWhere .= " ( (gyoumu_ed_term >= '".$To_Year."/".$To_Month."/01' ";
	$sWhere .= " AND gyoumu_ed_term < '".$Af_Year."/".$Af_Year."/01') ";
	$sWhere .= " OR (gyoumu_st_term >= '".$To_Year."/".$To_Month."/01' ";
	$sWhere .= " AND gyoumu_st_term < '".$Af_Year."/".$Af_Month."/01') ) ";
}
$KikanData .= '>今期</option>';

$KikanData .= '<option value="3" ';
if ($cboKikan=="3"){
	$KikanData.="selected";

	if(!$sWhere){
		$sWhere .= " WHERE ";
	}else{
		$sWhere .= " AND ";
	}
	$sWhere .= " (gyoumu_st_term >= '".$Af_Year."/".$Af_Month."/01' ";
	$sWhere .= " OR gyoumu_ed_term >= '".$Af_Year."/".$Af_Month."/01') ";
}
$KikanData .= '>次期以降</option>';



// 業務一覧取得
$strSQL  = "SELECT ";
$strSQL .= " bumon_name,          ";
$strSQL .= " gyoumu_id,           ";
$strSQL .= " gyoumu_name,         ";
$strSQL .= " gyoumu_money,        ";
$strSQL .= " gyoumu_st_term,      ";
$strSQL .= " gyoumu_ed_term,      ";
$strSQL .= " mst_gyoumu.disp_rank, ";
$strSQL .= " gyoumu_koban         ";
$strSQL .= " FROM ";
$strSQL .= " mst_gyoumu left join bumon_tbl on mst_gyoumu.gyoumu_area=bumon_tbl.bumon_seq ";
$strSQL .= $sWhere." ";
$strSQL .= " ORDER BY ";
$strSQL .= " mst_gyoumu.gyoumu_koban, mst_gyoumu.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);
		$bumon_name[$intI]     = $objData->bumon_name;
		$gyoumu_id[$intI]      = $objData->gyoumu_id;
		$gyoumu_name[$intI]    = $objData->gyoumu_name;
		$gyoumu_money[$intI]   = $objData->gyoumu_money;
		$gyoumu_st_term[$intI] = $objData->gyoumu_st_term;
		$gyoumu_ed_term[$intI] = $objData->gyoumu_ed_term;
		$disp_rank[$intI]      = $objData->disp_rank;
		$gyoumu_koban[$intI]    = $objData->gyoumu_koban;

//		$strSQL2  = "SELECT mst_gyousya_set.gyoumu_id, mst_gyousya.gyousya_id, mst_gyousya.gyousya_name FROM mst_gyousya_set " ;
//		$strSQL2 .= " INNER JOIN mst_gyousya ON (mst_gyousya_set.gyousya_id = mst_gyousya.gyousya_id) ";
//		$strSQL2 .= " WHERE mst_gyousya_set.gyoumu_id = ".$gyoumu_id[$intI];
		$strSQL2  = "SELECT mst_gyousya_name.gyousya_id, mst_gyousya_name.gyousya_name ";
		$strSQL2 .= "FROM mst_gyousya_name " ;
		$strSQL2 .= " WHERE mst_gyousya_name.gyoumu_id = ".$gyoumu_id[$intI];
		$objRec2 = pg_exec($strSQL2);
		if($objRec2==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
		for($intJ = 0; $intJ < pg_numrows($objRec2); $intJ++){
			$objData2 = pg_fetch_object($objRec2, $intJ);
			$gyousya_id[$intI][$intJ] = $objData2->gyousya_id;
			$gyousya_name[$intI][$intJ] = $objData2->gyousya_name;
		}
}
if(is_array($gyoumu_money)){
	$sum_gyoumu_money = array_sum($gyoumu_money);
}



//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/ADM2040.js"></script>
	<title><?PHP  echo($PHP_SYSNAME); ?></title>
	<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/134448344.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('Money_Tani' , $Money_Tani);		//金額単位
$o_smarty->assign('AreaData' , $AreaData);
$o_smarty->assign('KikanData' , $KikanData);

$o_smarty->assign('bumon_name'    , $bumon_name);
$o_smarty->assign('gyoumu_id'     , $gyoumu_id);
$o_smarty->assign('gyoumu_name'   , $gyoumu_name);
$o_smarty->assign('gyoumu_koban'  , $gyoumu_koban);
$o_smarty->assign('gyoumu_money'  , $gyoumu_money);
$o_smarty->assign('gyoumu_st_term', $gyoumu_st_term);
$o_smarty->assign('gyoumu_ed_term', $gyoumu_ed_term);
$o_smarty->assign('gyousya_id', $gyousya_id);
$o_smarty->assign('gyousya_name', $gyousya_name);
$o_smarty->assign('disp_rank'  , $disp_rank);
$o_smarty->assign('sum_gyoumu_money'  , $sum_gyoumu_money);

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

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

?>