<?php 
//*****************************************************************************
//* 
//* プログラム名：回覧板
//* プログラムID：CIR001.php
//* 機能        ：受信回覧一覧画面
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/STRING.inc");
include('./include/smarty.conf');
include("inc/header.inc");
include("inc/CIR001.inc");

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

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

$strSQL="";
$objRec="null";
$strSQLSyain="";
$objRecSyain="null";

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

//一覧取得
//$strSQL="SELECT pkairan_tbl.seq,kairan_tbl.date,kairan_tbl.time,kairan_tbl.title,kairan_tbl.memo,kairan_tbl.filename,kairan_tbl.filename_jp,kairan_tbl.filename2,kairan_tbl.filename_jp2,kairan_tbl.filename3,kairan_tbl.filename_jp3,pkairan_tbl.read_flg,name_kj_sei,name_kj_mei,kairan_tbl.date_kigen,kairan_tbl.time_kigen " .
$strSQL="SELECT pkairan_tbl.seq,kairan_tbl.date,kairan_tbl.time,kairan_tbl.title,kairan_tbl.memo,kairan_tbl.filename,kairan_tbl.filename_jp,kairan_tbl.filename2,kairan_tbl.filename_jp2,kairan_tbl.filename3,kairan_tbl.filename_jp3,pkairan_tbl.read_flg,name_kj_sei,name_kj_mei,kairan_tbl.date_kigen,kairan_tbl.time_kigen,name_kn_sei,name_kn_mei ".
				" FROM kairan_tbl,pkairan_tbl,syain_tbl ".
				" Where pkairan_tbl.syain_cd='$PHP_SYAIN_CD' and kairan_tbl.syain_cd=syain_tbl.syain_cd and pkairan_tbl.seq=kairan_tbl.seq".
				" and pkairan_tbl.del_flg=0 ".
//				" Order by pkairan_tbl.read_flg,seq DESC";
				" Order by ";
// ソート情報
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 .= "kairan_tbl.title ";
		$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":
		//回覧期限
		if($Sort_Ptn=="1"){
			$strSQL .= "kairan_tbl.date_kigen ASC,kairan_tbl.time_kigen ";
		}else{
			$strSQL .= "kairan_tbl.date_kigen DESC,kairan_tbl.time_kigen ";
		}
		$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"){
			$Sort_Disp[4] = "▲";
			$Sort_Val[4]  = "2";
		}else{
			$Sort_Disp[4] = "▼";
			$Sort_Val[4]  = "1";
		}
		break;
	default:
		$Sort_Mode = 1;
		//受信日付
		$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 .= " pkairan_tbl.read_flg,seq ";
}
if($Sort_Mode!="3"){
	switch ($Sort_Ptn) {
		case "1":
			$strSQL .= "ASC ";
			break;
		case "2":
			$strSQL .= "DESC ";
			break;
		default:
			//受信日付
			$Sort_Ptn  = "2";
			$strSQL .= "DESC ";
	}
}

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

//<!--一覧-->
$o_smarty->assign('PHP_SYAIN_NAME',$PHP_SYAIN_NAME);

if (($intPage > 0) && (pg_numrows($objRec) > (10 * ($intPage+1)))){
	$PageBack = " onClick=\"PageCnt(".($intPage-1).");\"";
	$PageNext = " onClick=\"PageCnt(".($intPage+1).");\"";
}elseif(($intPage > 0) && (pg_numrows($objRec) <= (10 * ($intPage+1)))){
	$PageBack = " onClick=\"PageCnt(".($intPage-1).");\"";
	$PageNext = " readonly disabled";
}elseif(($intPage == 0) && (pg_numrows($objRec) > (10 * ($intPage+1)))){
	$PageBack = " readonly disabled";
	$PageNext = " onClick=\"PageCnt(".($intPage+1).");\"";
}else{
	$PageBack = " readonly disabled";
	$PageNext = " readonly disabled";
}
$o_smarty->assign('PageBack',$PageBack);
$o_smarty->assign('PageNext',$PageNext);

if (pg_numrows($objRec)==0) {
	$PageCheak = " disabled=true";
}
$o_smarty->assign('PageCheak',$PageCheak);

if (pg_numrows($objRec)==0) { 
	$PageDel = " disabled=true"; 
}
$o_smarty->assign('PageDel',$PageDel);

//終了ページの取得
$intEndCnt=10 * ($intPage+1);
if ($intEndCnt>pg_numrows($objRec)){
	$intEndCnt=pg_numrows($objRec);
}

for ($intCnt = 10 * $intPage; $intCnt < $intEndCnt ; $intCnt++) {
	$objData = pg_fetch_object($objRec, $intCnt);
	
	$intCntP = $intCnt - 10 * $intPage;
	$PhpDate[$intCntP] = $objData->date;
	$PhpTime[$intCntP] = $objData->time;
	$PhpSeq[$intCntP] = $objData->seq;
	if ($objData->title !=""){
		$PhpTitle[$intCntP] = $objData->title;
	}else{
		$PhpTitle[$intCntP] = "タイトルなし";
	}
	$PhpName_kj_sei[$intCntP] = $objData->name_kj_sei;
	$PhpName_kj_mei[$intCntP] = $objData->name_kj_mei;
	$PhpDate_kigen[$intCntP] = $objData->date_kigen;
	$PhpTime_kigen[$intCntP] = $objData->time_kigen;

	//長文ファイルチェック
	$strFileNm[$intCntP]="";
	$strFileNm2[$intCntP]="";
	$strFileNm3[$intCntP]="";
	//ファイル1
	if ($objData->filename_jp!=""){
		$strFileNm[$intCntP]=LINE_DEL($objData->filename_jp,16);
	}

	//ファイル2
	if ($objData->filename_jp2!=""){
		$strFileNm2[$intCntP]=LINE_DEL($objData->filename_jp2,16);
		if ($strFileNm[$intCntP]!=""){
			$strFileNm2[$intCntP] = "<br>".$strFileNm2[$intCntP];
		}
	}

	//ファイル3
	if ($objData->filename_jp3!=""){
		$strFileNm3[$intCntP]=LINE_DEL($objData->filename_jp3,16);
		if (($strFileNm[$intCntP]!="") || ($strFileNm2[$intCntP]!="")){
			$strFileNm3[$intCntP] = "<br>".$strFileNm3[$intCntP];
		}
	}

	//既読状態
	if ($objData->read_flg==0){
		$read_flg[$intCntP] = "<span class=\"Chufont\">未読</span>";
		$BgColor[$intCntP]  = "tblUn";
	}else{
		$read_flg[$intCntP] = "<span class=\"Normalfont\">既読</span>";
		$BgColor[$intCntP]  = "tblAl";
	}
}

$o_smarty->assign('intPage',$intPage);
$o_smarty->assign('PhpDate',$PhpDate);
$o_smarty->assign('PhpTime',$PhpTime);
$o_smarty->assign('PhpSeq',$PhpSeq);
$o_smarty->assign('PhpTitle',$PhpTitle);
$o_smarty->assign('PhpName_kj_sei',$PhpName_kj_sei);
$o_smarty->assign('PhpName_kj_mei',$PhpName_kj_mei);
$o_smarty->assign('PhpDate_kigen',$PhpDate_kigen);
$o_smarty->assign('PhpTime_kigen',$PhpTime_kigen);

$o_smarty->assign('strFileNm',$strFileNm);
$o_smarty->assign('strFileNm2',$strFileNm2);
$o_smarty->assign('strFileNm3',$strFileNm3);

$o_smarty->assign('read_flg',$read_flg);
$o_smarty->assign('BgColor',$BgColor);

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

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

//無料版ダウンロードボタン制御
$o_smarty->assign('PHP_MODE_FLG',$PHP_MODE_FLG);

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

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

?>