<?php 
//*****************************************************************************
//* 
//* プログラム名：営業日報
//* プログラムID：RPT006.php
//* 機能        ：営業日報修正画面
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//***************************
//*　インクルードファイル
//***************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');
include("include/STRING.inc");
include("inc/mtc_comfunc.inc");

include("./include/dbcon.inc");				//ＤＢ接続

$strSQLtori="";
$objRectori="null";
$strSQLsyain="";
$objRecsyain="null";
$strSQLRPT="";
$objRecRPT="null";
$strSQLchk="";
$objRecchk="null";

//部門情報取得
$strSQLmst = "SELECT syozoku_cd,bumon_name FROM mst_bumon Order by disp_rank";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

//if (empty($intwk_flg)){
//営業日報情報取得
$strSQLRPT="SELECT seq,date,time,time_e,tori_code,tori_name,charge,syain_cd,syain_list,visit_purpose,memo,subject,bikou,bumon_cd " .
					 "FROM eigyo_memo_tbl ".
					 "Where seq=$re_seq ";
$objRecRPT = pg_exec($strSQLRPT);
if($objRecRPT==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$objEdit = pg_fetch_object($objRecRPT, 0);
	
//報告日編集
$visit_y=substr($objEdit->date,0,4);
$visit_m=substr($objEdit->date,5,2);
$visit_d=substr($objEdit->date,8,2);
	
if ($objEdit->time ==""){
	$visit_h="";
	$visit_min="";
}else{
	$visit_h=substr($objEdit->time,0,2);
	$visit_min=substr($objEdit->time,3,2);
}
if ($objEdit->time_e ==""){
	$visit_e_h="";
	$visit_e_min="";
}else{
	$visit_e_h=substr($objEdit->time_e,0,2);
	$visit_e_min=substr($objEdit->time_e,3,2);
}

$charge = htmlspecialchars(mtc_rtrim($objEdit->charge));
$Purpose = mtc_rtrim($objEdit->visit_purpose);
$Note = mtc_rtrim($objEdit->bikou);
$memo=mtc_rtrim($objEdit->memo);
$bumon_cd=$objEdit->bumon_cd;
$Subject=mtc_rtrim($objEdit->subject);

//取引先編集
$tori_code=$objEdit->tori_code;
if ($tori_code==0){
	$Visit=1;
	$Visit_input=htmlspecialchars(mtc_rtrim($objEdit->tori_name));
}else{
	$strSQLchk="SELECT del_flg FROM torihiki_TBL Where seq=$tori_code Order by tori_name_kn ";
	$objRecchk = pg_exec($strSQLchk);
	if($objRectori==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$objCheck = pg_fetch_object($objRecchk, 0);
	
	if ($objCheck->del_flg==false){
		$Visit=1;
		$Visit_input=mtc_rtrim($objCheck->tori_name);	
	}else{
		$Visit=0;
		$Sel_Visit=$objEdit->tori_code;
	}
}

$intwk_flg=1;
//取引先情報取得
$strSQLtori="SELECT seq,tori_name FROM torihiki_TBL Where del_flg=true Order by tori_name_kn";
$objRectori = pg_exec($strSQLtori);
if($objRectori==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

//社員情報取得
$strSQLsyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where del_flg=true Order by disp_rank";
$objRecsyain = pg_exec($strSQLsyain);
if($objRecsyain==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
	
if (($intaddsts == 1) || ($intaddsts == 2)){
	//社員情報取得
	$strJyoken=str_replace("/","' or syain_cd='",$strsel);
}else{
	$strJyoken=str_replace("/","' or syain_cd='",$objEdit->syain_list);
}
$strSQLSyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl Where syain_cd=" . "'" .$strJyoken ."' Order by disp_rank";
$objRecData = pg_exec($strSQLSyain);
if($objRecData==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

//訪問年
for ($i=Date("Y")-1;$i<=Date("Y")+1;$i++) {
	$sel_visit_y .= "<OPTION value='".$i."' "; 
	if ($visit_y == $i){
		$sel_visit_y .= "selected";
	}
	$sel_visit_y .= ">".$i."年</OPTION>";		
}
//訪問月
for ($i=1;$i<=12;$i++) {
	$sel_visit_m .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($visit_m == sprintf('%02d', $i)){
		$sel_visit_m .= "selected";
	}
	$sel_visit_m .= ">".$i."月</OPTION>";
}
//訪問日
for ($i=1;$i<=31;$i++) {
	$sel_visit_d .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($visit_d == sprintf('%02d', $i)){
		$sel_visit_d .= "selected";
	}
	$sel_visit_d .= ">".$i."日</OPTION>";
}
//訪問時
$sel_visit_h = "<OPTION value='' ";
if ($visit_h == ""){
	$sel_visit_h .= "selected";
}
$sel_visit_h .= ">--時</OPTION>";
for ($i=8;$i<=23;$i++) {
	$sel_visit_h .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($visit_h == sprintf('%02d', $i)){
		$sel_visit_h .= "selected";
	}
	$sel_visit_h .= ">".$i."時</OPTION>";
}
for ($i=0;$i<=7;$i++) {
	$sel_visit_h .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($visit_h == sprintf('%02d', $i)){
		$sel_visit_h .= "selected";
	}
	$sel_visit_h .= ">".$i."時</OPTION>";
}
//訪問分
$sel_visit_min = "<OPTION value='' ";
if ($visit_min == ""){
	$sel_visit_min .= "selected";
}
$sel_visit_min .= ">--分</OPTION>";
for ($i=0;$i<=5;$i++) {
	$sel_visit_min .= "<OPTION value='".sprintf('%02d', $i*10)."' ";
	if ($visit_min == sprintf('%02d', $i*10)){
		$sel_visit_min .= "selected";
	}
	$sel_visit_min .= ">".($i*10)."分</OPTION>";
}
//訪問時 終了
$sel_visit_e_h = "<OPTION value='' ";
if ($visit_e_h == ""){
	$sel_visit_e_h .= "selected";
}
$sel_visit_e_h .= ">--時</OPTION>";
for ($i=8;$i<=23;$i++) {
	$sel_visit_e_h .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($visit_e_h == sprintf('%02d', $i)){
		$sel_visit_e_h .= "selected";
	}
	$sel_visit_e_h .= ">".$i."時</OPTION>";
}
for ($i=0;$i<=7;$i++) {
	$sel_visit_e_h .= "<OPTION value='".sprintf('%02d', $i)."' ";
	if ($visit_e_h == sprintf('%02d', $i)){
		$sel_visit_e_h .= "selected";
	}
	$sel_visit_e_h .= ">".$i."時</OPTION>";
}
//訪問分 終了
$sel_visit_e_min = "<OPTION value='' ";
if ($visit_e_min == ""){
	$sel_visit_e_min .= "selected";
}
$sel_visit_e_min .= ">--分</OPTION>";
for ($i=0;$i<=5;$i++) {
	$sel_visit_e_min .= "<OPTION value='".sprintf('%02d', $i*10)."' ";
	if ($visit_e_min == sprintf('%02d', $i*10)){
		$sel_visit_e_min .= "selected";
	}
	$sel_visit_e_min .= ">".($i*10)."分</OPTION>";
}

if ($Visit == 0){
	$strRadio[0] = "checked";
}elseif ($Visit == 1){
	$strRadio[1] = "checked";
}
	
for ($intCnt = 0; $intCnt < pg_numrows($objRectori); $intCnt++) {
	$objtorihiki = pg_fetch_object($objRectori, $intCnt);
	$strToriNm=LINE_DEL($objtorihiki->tori_name,40);
	$sel_strToriNm .= "<OPTION value='".($objtorihiki->seq)."' ";
	if($Sel_Visit == $objtorihiki->seq){
		$sel_strToriNm .= "selected";
	}
	$sel_strToriNm .= "><span class='Normalfont'>".$strToriNm."</span></OPTION>";
}

if (pg_numrows($objRecData) != 0){
	for ($intlist = 0; $intlist < pg_numrows($objRecData); $intlist++) {
		$objlist = pg_fetch_object($objRecData, $intlist);
		$sel_intlist .= "<OPTION value='".($objlist->syain_cd)."'>".($objlist->name_kj_sei.$objlist->name_kj_mei)."</OPTION>";
	}
	$sel_intlist .= '<OPTION value="" >　　　　　　　</OPTION>';
}
else{
	$sel_intlist = '<OPTION value="" >　　　　　　　</OPTION>';
}

for ($intlist = 0; $intlist < pg_numrows($objRecsyain); $intlist++) {
		$objlist = pg_fetch_object($objRecsyain, $intlist);
		$sel_intlist2 .= "<OPTION value= '".$objlist->syain_cd."' selected>".($objlist->name_kj_sei.$objlist->name_kj_mei)."</OPTION>";
}

for ($intBumon = 0; $intBumon < pg_numrows($objRecmst); $intBumon++) {
	$objDatamst = pg_fetch_object($objRecmst, $intBumon);
	$sel_bumon_name .= "部門コード".$bumon_cd;
	$sel_bumon_name .= "<OPTION value='".($objDatamst->syozoku_cd)."' ";
	if ($bumon_cd==$objDatamst->syozoku_cd){
		$sel_bumon_name .= "selected";
	}
	$sel_bumon_name .= ">".($objDatamst->bumon_name)."</OPTION>";
}

//添付ファイル取得
//ファイルアップ配列初期化
for($fCnt=0;$fCnt<5;$fCnt++){
	$strFileP[$fCnt] = "";
	$strFileN[$fCnt] = "";
	$strFileC[$fCnt] = $fCnt + 1;
	$strFileD[$fCnt] = "";
}

$strSQL = "SELECT";
$strSQL .= " * ";
$strSQL .= "FROM";
$strSQL .= " common_file_tbl ";
$strSQL .= "WHERE ";
$strSQL .= " type = 'RPT' AND ";
$strSQL .= " seq1 = ".$re_seq." AND ";
$strSQL .= " seq2 = 0 ";
$strSQL .= "ORDER BY ";
$strSQL .= " file_seq ASC ";
$objFileRec = pg_exec($strSQL);
if($objFileRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
if(pg_numrows($objFileRec) > 0){
	for($intI=0;$intI<pg_numrows($objFileRec);$intI++){
		$objFileData = pg_fetch_object($objFileRec, $intI);
		$strFileP[($objFileData->file_seq) - 1] = "temp/".$PHP_FOLDER_NAME."/RPT/".($objFileData->file_name);
		$strFileN[($objFileData->file_seq) - 1] = htmlspecialchars($objFileData->file_name_org);
		$strFileD[($objFileData->file_seq) - 1] = "disabled";
	}
}

$o_smarty->assign('strFileP',$strFileP);
$o_smarty->assign('strFileN',$strFileN);
$o_smarty->assign('strFileC',$strFileC);
$o_smarty->assign('strFileD',$strFileD);

$o_smarty->assign('sel_visit_y',$sel_visit_y);
$o_smarty->assign('sel_visit_m',$sel_visit_m);
$o_smarty->assign('sel_visit_d',$sel_visit_d);
$o_smarty->assign('sel_visit_h',$sel_visit_h);
$o_smarty->assign('sel_visit_min',$sel_visit_min);
$o_smarty->assign('sel_visit_e_h',$sel_visit_e_h);
$o_smarty->assign('sel_visit_e_min',$sel_visit_e_min);
$o_smarty->assign('strRadio',$strRadio);
$o_smarty->assign('Visit_input',$Visit_input);
$o_smarty->assign('sel_strToriNm',$sel_strToriNm);
$o_smarty->assign('sel_intlist',$sel_intlist);
$o_smarty->assign('sel_intlist2',$sel_intlist2);
$o_smarty->assign('charge',$charge);
$o_smarty->assign('sel_bumon_name',$sel_bumon_name);
$o_smarty->assign('Purpose',$Purpose);
$o_smarty->assign('memo',$memo);
$o_smarty->assign('Subject',$Subject);
$o_smarty->assign('Note',$Note);
$o_smarty->assign('intsts',$intsts);

$o_smarty->assign('re_seq',$re_seq);
$o_smarty->assign('chk_tori',$chk_tori);
$o_smarty->assign('Customer',$Customer);
$o_smarty->assign('Customer_group',$Customer_group);
$o_smarty->assign('Caller',$Caller);
$o_smarty->assign('start_y',$start_y);
$o_smarty->assign('start_m',$start_m);
$o_smarty->assign('end_d',$end_d);
$o_smarty->assign('intwk_flg',$intwk_flg);

$o_smarty->assign('calYMD',$visit_y."/".$visit_m."/".$visit_d);

$o_smarty->display('RPT006.tpl');
?>