<?php 
//*****************************************************************************
//* 
//* プログラム名：営業日報
//* プログラムID：RPT001.php
//* 機能        ：営業日報作成一覧画面
//* 作成者      ：K.Yoshimura
//* 
//*****************************************************************************

header("Content-type: text/html; charset=EUC-JP");

include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');
$strDBinc="include/dbcon.inc";

include($strDBinc);

$strSQL="";
$objRec="null";
$strSyain="";
$objRecSyain="null";
$strChek="";
$objRecChek="null";

?>
<?php 

if (empty($intPage)){
	$intPage=0;
}

//管理者権限がある場合は全て表示
if($admin_session=="administrator"){
	$strSQL="SELECT seq,date,time,time_e,tori_name,charge,syain_cd,syain_list,visit_purpose,memo,subject,bikou ".
				" FROM eigyo_memo_tbl ".
				" Order by date DESC,time DESC,eigyo_memo_tbl.seq DESC ";
}else{
	//作成済みの営業日報情報取得
	$strSQL="SELECT seq,date,time,time_e,tori_name,charge,syain_cd,syain_list,visit_purpose,memo,subject,bikou ".
				" FROM eigyo_memo_tbl Where syain_cd='$PHP_SYAIN_CD'" .
				" Order by date DESC,time DESC,seq DESC ";
}


$objRec = pg_exec($strSQL);
if($objRec==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

$numrow = pg_numrows($objRec);
$intPage10times1plus = 	10 * ($intPage +1 );

//チェックボックス表示確認
$intEndCnt=10 * ($intPage+1);
if ($intEndCnt>pg_numrows($objRec)){
	$intEndCnt=pg_numrows($objRec);
}
$intDispFlg=0;
for ($intCnt = 10 * $intPage; $intCnt < $intEndCnt; $intCnt++) {
	$objData = pg_fetch_object($objRec, $intCnt);
	if ($objData->read_flg==0){
		$intDispFlg=1;
		break;
	}
}
if ($intDispFlg!=1){
	$strDisp = " disabled";
}
?>
		<?php 
//終了ページの取得
$intEndCnt=10 * ($intPage+1);

if ($intEndCnt>pg_numrows($objRec)){
	$intEndCnt=pg_numrows($objRec);
}

if (($intPage > 0) && (pg_numrows($objRec) > (10 * ($intPage+1)))){
	$PageBackPrm = $intPage-1;
	$PageNextPrm = $intPage+1;
}elseif(($intPage > 0) && (pg_numrows($objRec) <= (10 * ($intPage+1)))){
	$PageBackPrm = $intPage-1;
	$PageNextPrm = "";
}elseif(($intPage == 0) && (pg_numrows($objRec) > (10 * ($intPage+1)))){
	$PageBackPrm = "";
	$PageNextPrm = $intPage+1;
}else{
	$PageBackPrm = "";
	$PageNextPrm = "";
}

$i = 0;
for ($intCnt = 10 * $intPage; $intCnt < $intEndCnt; $intCnt++) {
	$objData = pg_fetch_object($objRec, $intCnt);
	
	//社員名取得
	$strJyoken=str_replace("/","' or syain_cd='",$objData->syain_list);
	
	$strSyain="SELECT name_kj_sei,name_kj_mei FROM syain_tbl ".
						"Where syain_cd=" . "'" .$strJyoken ."'" .
						" Order by disp_rank";

	$objRecSyain = pg_exec($strSyain);
	if($objRecSyain==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	
	if (($objData->time =="") && ($objData->time_e =="")){
		$strTime[$i]="";
	}elseif (($objData->time !="") && ($objData->time_e !="")){
		$strTime[$i]=$objData->time ."〜" .$objData->time_e;
	}elseif (($objData->time !="") && ($objData->time_e =="")){
		$strTime[$i]=$objData->time ."〜";
	}
	
	$date[$i] = $objData->date;
	$tori_name[$i] = $objData->tori_name			;
	$charge[$i] = $objData->charge;
	
?>
			<?php 
			for ($intSyainCnt = 0; $intSyainCnt < pg_numrows($objRecSyain); $intSyainCnt++) {
				$objSyain = pg_fetch_object($objRecSyain, $intSyainCnt);
				$name_kj[$i] .= $objSyain->name_kj_sei.$objSyain->name_kj_mei."<span class='TinnyFont'><br></span><br>";
			}
			
			$visit_purpose[$i] = str_replace ("\n", "<BR>", $objData->visit_purpose);
			$visit_purpose[$i] = str_replace ("\t", "　　", $visit_purpose[$i]);
			$visit_purpose[$i] = str_replace ("\s", "&nbsp;", $visit_purpose[$i]);
			$visit_purpose[$i] = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$visit_purpose[$i]);

			$memo[$i] = str_replace ("\n", "<BR>", $objData->memo);
			$memo[$i] = str_replace ("\t", "　　", $memo[$i]);
			$memo[$i] = str_replace ("\s", "&nbsp;", $memo[$i]);
			$memo[$i] = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$memo[$i]);

			$Subject[$i] = str_replace ("\n", "<BR>", $objData->subject);
			$Subject[$i] = str_replace ("\t", "　　", $Subject[$i]);
			$Subject[$i] = str_replace ("\s", "&nbsp;", $Subject[$i]);
			$Subject[$i] = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$Subject[$i]);

			$Note[$i] = str_replace ("\n", "<BR>", $objData->bikou);
			$Note[$i] = str_replace ("\t", "　　", $Note[$i]);
			$Note[$i] = str_replace ("\s", "&nbsp;", $Note[$i]);
			$Note[$i] = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$Note[$i]);

			$seq[$i] = $objData->seq;
			$i++;
}

$o_smarty->assign('intPage',$intPage);
$o_smarty->assign('numrow',$numrow);
$o_smarty->assign('intPage10times1plus',$intPage10times1plus);
$o_smarty->assign('intDispFlg',$intDispFlg);
$o_smarty->assign('strDisp',$strDisp);
$o_smarty->assign('date',$date);
$o_smarty->assign('strTime',$strTime);
$o_smarty->assign('tori_name',$tori_name);
$o_smarty->assign('charge',$charge);
$o_smarty->assign('name_kj',$name_kj);
$o_smarty->assign('visit_purpose',$visit_purpose);
$o_smarty->assign('memo',$memo);
$o_smarty->assign('Subject',$Subject);
$o_smarty->assign('Note',$Note);
$o_smarty->assign('seq',$seq);

$o_smarty->assign('PageBackPrm',$PageBackPrm);
$o_smarty->assign('PageNextPrm',$PageNextPrm);


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