<?php 
//*****************************************************************************
//* 
//* プログラム名：電話連絡メモ
//* プログラムID：TEL001.php
//* 機能				：受信電話連絡メモ一覧画面
//* 作成者			：
//* 
//*****************************************************************************

header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/STRING.inc");
include("inc/Advertisement.inc");
include('./include/smarty.conf');
include("inc/header.inc");
include("inc/TEL001.inc");
include("inc/input_chk.inc");

//メニューセット
include("menu_opacity.php");

//**** ＤＢ接続 ****//
$strDBinc="include/dbcon.inc";
include($strDBinc);

if (empty($ichiran)){
	$ichiran=1;
}
if (empty($Sort_Mode)){
	$Sort_Mode="null";
}
if (empty($Sort_Ptn)){
	$Sort_Ptn="null";
}

$strSQL="";
$objRec="null";

//ページカウント,抽出開始位置
if (empty($intPage)||$intPage == 0){
	$intPage=0;
	$kaisiIti = 0;
}else{
	$kaisiIti = $intPage * 10;
}

//伝言一覧
if ($ichiran==1){
//全体件数のカウント(伝言一覧)
$strSQL = "SELECT COUNT(*) as cnt FROM telmemo_tbl,syain_tbl Where to_code='$PHP_SYAIN_CD' and syain_cd=from_code";
}else {
//全体件数のカウント(作成一覧)
$strSQL = "SELECT COUNT(*) as cnt FROM telmemo_tbl,syain_tbl Where from_code='$PHP_SYAIN_CD' and syain_cd=to_code";
}

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

if(pg_numrows($objRecCntSet)>0){
	$ftcData = pg_fetch_object($objRecCntSet,0);
	$intKensuCnt = $ftcData->cnt;
}else{
	$intKensuCnt = 0;
}

if ($ichiran==1) {
	//伝言一覧取得
	$strSQL  = "SELECT ";
	//$strSQL .= " seq,date,time,from_code,to_code,fromperson,msgmode,msgtype,message,tel,fax,e_mail,read_flg,name_kj_sei,name_kj_mei ";
	$strSQL .= " seq,date,time,from_code,to_code,fromperson,msgmode,msgtype,message,tel,fax,e_mail,read_flg,name_kj_sei,name_kj_mei,name_kn_sei,name_kn_mei ";
	$strSQL .= "FROM ";
	$strSQL .= " telmemo_tbl,syain_tbl ";
	$strSQL .= "WHERE ";
	$strSQL .= " to_code='$PHP_SYAIN_CD' and syain_cd=from_code ";
	$strSQL .= " ORDER BY ";
}else{

	//作成一覧取得
	$strSQL  = "SELECT ";
	//$strSQL .= " seq,date,time,from_code,to_code,fromperson,msgmode,msgtype,message,tel,fax,e_mail,read_flg,name_kj_sei,name_kj_mei ";
	$strSQL .= " seq,date,time,from_code,to_code,fromperson,msgmode,msgtype,message,tel,fax,e_mail,read_flg,name_kj_sei,name_kj_mei,name_kn_sei,name_kn_mei ";
	$strSQL .= "FROM ";
	$strSQL .= " telmemo_tbl,syain_tbl ";
	$strSQL .= "WHERE ";
	$strSQL .= " from_code='$PHP_SYAIN_CD' and syain_cd=to_code ";
	$strSQL .= " ORDER BY ";
}
// ソート情報
$Sort_Disp[1] = "";
$Sort_Disp[2] = "";
$Sort_Disp[3] = "";
$Sort_Disp[4] = "";

$Sort_Val[1] = "";
$Sort_Val[2] = "";
$Sort_Val[3] = "";
$Sort_Val[4] = "";

switch ($Sort_Mode) {
	case "1":
		//日時
		$strSQL .= " seq ";
		if ($Sort_Ptn == "1"){
				$Sort_Disp[1] = "　▲";
				$Sort_Val[1]  = "2";
		}else{
				$Sort_Disp[1] = "　▼";
				$Sort_Val[1]  = "1";
		}
		$Sort_Disp[2] = "";
		$Sort_Val[2]  = "1";
		$Sort_Disp[3] = "";
		$Sort_Val[3]  = "1";
		$Sort_Disp[4] = "";
		$Sort_Val[4]  = "1";
		break;

	case "2":
		//伝言内容
		$strSQL .= " fromperson ";
		$Sort_Disp[1] = "";
		$Sort_Val[1]  = "1";

		if ($Sort_Ptn == "1"){
				$Sort_Disp[2] = "　▲";
				$Sort_Val[2]  = "2";
		}else{
				$Sort_Disp[2] = "　▼";
				$Sort_Val[2]  = "1";
		}
		$Sort_Disp[3] = "";
		$Sort_Val[3]  = "1";

		$Sort_Disp[4] = "";
		$Sort_Val[4]  = "1";
		break;

	case "3":
		//作成者
		$Sort_Disp[1] = "";
		$Sort_Val[1]  = "1";
		$Sort_Disp[2] = "";
		$Sort_Val[2]  = "1";

		if ($Sort_Ptn == "1"){
				$strSQL .= " name_kn_sei ASC,name_kn_mei ASC ";
				$Sort_Disp[3] = "　▲";
				$Sort_Val[3]  = "2";
		}else{
				$strSQL .= " name_kn_sei DESC,name_kn_mei DESC ";
				$Sort_Disp[3] = "　▼";
				$Sort_Val[3]  = "1";
		}
		$Sort_Disp[4] = "";
		$Sort_Val[4]  = "1";
		break;

	case "4":
		//伝言宛先
		$Sort_Disp[1] = "";
		$Sort_Val[1]  = "1";
		$Sort_Disp[2] = "";
		$Sort_Val[2]  = "1";
		$Sort_Disp[3] = "";
		$Sort_Val[3]  = "1";

		if ($Sort_Ptn == "1"){
				$strSQL .= " name_kn_sei ASC,name_kn_mei ASC ";
				$Sort_Disp[4] = "　▲";
				$Sort_Val[4]  = "2";
		}else{
				$strSQL .= " name_kn_sei DESC,name_kn_mei DESC ";
				$Sort_Disp[4] = "　▼";
				$Sort_Val[4]  = "1";
		}
		break;

	default:
		//受信日時(デフォルト)
		$Sort_Disp[1] = "　▼";
		$Sort_Val[1] = "1";

		$Sort_Disp[2] = "";
		$Sort_Val[2] = "1";

		$Sort_Disp[3] = "";
		$Sort_Val[3] = "1";

		$Sort_Disp[4] = "";
		$Sort_Val[4] = "1";

		$strSQL .= " read_flg,seq DESC";
		break;
}

if($Sort_Mode!="3" && $Sort_Mode !="4"){
	switch ($Sort_Ptn) {
		case "1":
			$strSQL .= "ASC ";
			break;
		case "2":
			$strSQL .= "DESC ";
			break;
	}
}

$strSQL .= " LIMIT 10 OFFSET ".$kaisiIti ;

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

//データ存在チェック
$intDelFlg=0;
if(pg_numrows($objRec)>0){
	$intDelFlg=1;
}

//チェック、削除ボタン表示セット
$DelBtn .= '<INPUT type="button" name = "btnALL" onclick="All_chk(2);" value=ﾁｪｯｸ ';
if ($intDelFlg==0){
	$DelBtn .= "disabled=true";
}
$DelBtn .= ">";
$DelBtn .= '<span class=TinnyFont><br></span>';
$DelBtn .= '<INPUT type="button" name = "btnDel" onclick="Tel_del('.$ichiran.');" value=削除 ';
if ($intDelFlg==0){
	$DelBtn .= "disabled=true";
}
$DelBtn .= ">";

for ($intCnt = 0; $intCnt < pg_numrows($objRec); $intCnt++) {
	$objData = pg_fetch_object($objRec, $intCnt);

	//<!--日時-->
	$day[$intCnt] = $objData->date . "　". $objData->time;

	//<!--伝言者-->
	$dengon[$intCnt] = $objData->name_kj_sei . $objData->name_kj_mei;

	//<!--伝言内容-->
	switch ($objData->msgmode) {
		case 1:
			$msg_mode[$intCnt] = "電話";
			break;
		case 2:
			$msg_mode[$intCnt] = "来客";
			break;
		case 3:
			$msg_mode[$intCnt] = "その他";
			break;
		case 4:
			$msg_mode[$intCnt] = "返信";
			break;
	} 
	
	//<!--依頼主-->
	$irainusi1[$intCnt] =$objData->fromperson;

	if (($objData->read_flg==0) && (($ichiran==1 || empty($ichiran)))){
		$kakunin[$intCnt] = "<font color='#FF0000'>未確認</font>";
		$BgColor[$intCnt]  = "tblUn";
	}elseif (($objData->read_flg==0) && ($ichiran==2)){
		$kakunin[$intCnt] = "<font color='#FF0000'>未確認</font>";
		$BgColor[$intCnt]  = "tblUn";
	}else{
		$kakunin[$intCnt] = "確認済";
		$BgColor[$intCnt]  = "tblAl";
	}
	$sql[$intCnt] = $objData->seq;
}

//ページ、ボタンセット
if (($intPage > 0) && ($intKensuCnt > (10 * ($intPage+1)))){
	$PageBackPrm = $intPage-1;
	$PageNextPrm = $intPage+1;
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt($ichiran,1,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt($ichiran,0,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt($ichiran,2,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
}elseif(($intPage > 0) && ($intKensuCnt <= (10 * ($intPage+1)))){
	$PageBackPrm = $intPage-1;
	$PageNextPrm = "";
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt($ichiran,1,$intPage,$Sort_Mode,$Sort_Ptn)'  > ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt($ichiran,0,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt($ichiran,2,$intPage,$Sort_Mode,$Sort_Ptn)' disabled> ";
}elseif(($intPage == 0) && ($intKensuCnt > (10 * ($intPage+1)))){
	$PageBackPrm = "";
	$PageNextPrm = $intPage+1;
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt($ichiran,1,$intPage,$Sort_Mode,$Sort_Ptn)' disabled> ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt($ichiran,0,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt($ichiran,2,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
}else{
	$PageBackPrm = "";
	$PageNextPrm = "";
	$botan1 = "<input type='button' name='PageB' value='<<前の10件' onClick='PageCnt($ichiran,1,$intPage,$Sort_Mode,$Sort_Ptn)' disabled > ";
	$botan2 = "<input type='button' name='PageF' value='最近の10件' onClick='PageCnt($ichiran,0,$intPage,$Sort_Mode,$Sort_Ptn)' > ";
	$botan3 = "<input type='button' name='PageN' value='次の10件>>' onClick='PageCnt($ichiran,2,$intPage,$Sort_Mode,$Sort_Ptn)' disabled > ";
}

$o_smarty->assign('day',$day);
$o_smarty->assign('dengon',$dengon);
$o_smarty->assign('msg_mode',$msg_mode);
$o_smarty->assign('irainusi1',$irainusi1);
$o_smarty->assign('syain_cd',$syain_cd);
$o_smarty->assign('kakunin',$kakunin);
$o_smarty->assign('BgColor',$BgColor);
$o_smarty->assign('sql',$sql);

$o_smarty->assign('pg_numrows',pg_numrows($objRec));
$o_smarty->assign('DelBtn',$DelBtn);
$o_smarty->assign('ichiran',$ichiran);

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

$o_smarty->assign('botan1',$botan1);
$o_smarty->assign('botan2',$botan2);
$o_smarty->assign('botan3',$botan3);

$o_smarty->assign('Sort_Disp',$Sort_Disp);
$o_smarty->assign('Sort_Val',$Sort_Val);
$o_smarty->assign('Sort_Mode',$Sort_Mode);
$o_smarty->assign('Sort_Ptn',$Sort_Ptn);
$o_smarty->assign('title',$title);


$o_smarty->assign('PHP_TITLE_NAME',$PHP_TITLE_NAME[6]);

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