<?php 
//*****************************************************************************
//* 
//* プログラム名：回覧板
//* プログラムID：CIR007.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/CIR007.inc");
//メニューセット
include("menu_opacity.php");
$strDBinc="include/dbcon.inc";
include($strDBinc);

$strTempPath="temp/".$PHP_FOLDER_NAME."/kairan/";

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

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

//作成一覧取得
//管理者用
if($PHP_BIT[2]==1){
	//$strSQL="SELECT syain_cd,seq,date,time,syain_list,title,memo,filename,filename_jp,filename2,filename_jp2,filename3,filename_jp3 FROM kairan_tbl Order by seq DESC";
	$strSQL="SELECT syain_cd,seq,date,time,syain_list,title,memo,filename,filename_jp,filename2,filename_jp2,filename3,filename_jp3 FROM kairan_tbl Order by seq ";
}else{
//一般用
	$strSQL="SELECT syain_cd,seq,date,time,syain_list,title,memo,filename,filename_jp,filename2,filename_jp2,filename3,filename_jp3 FROM kairan_tbl ".
				"Where syain_cd='$PHP_SYAIN_CD' ".
				//" Order by seq DESC";
				" Order by seq ";
}
switch ($Sort_Ptn_S) {
	case "1":
		$Sort_Ptn_S=2;
		$strSQL .= "ASC ";
		$disp_Ptn = "▲";
		break;
	case "2":
		$Sort_Ptn_S=1;
		$strSQL .= "DESC ";
		$disp_Ptn = "▼";

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

//<!--作成回覧一覧-->
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;
	//社員名取得
	$strJyoken=$objData->syain_list;
	if (substr($strJyoken,strlen($strJyoken)-1,1)=="/"){
		$strJyoken=substr($strJyoken,0,strlen($strJyoken)-1);
	}
	$strJyoken=str_replace("/","') or (syain_tbl.syain_cd='",$strJyoken);
	

	$intseq=$objData->seq;

	$strSyain="SELECT name_kj_sei,name_kj_mei,disp_rank FROM syain_tbl,pkairan_tbl ".
						"Where ((syain_tbl.syain_cd=" . "'" .$strJyoken ."')) and syain_tbl.syain_cd = pkairan_tbl.syain_cd and read_flg=0" .
						" and seq=$intseq" .
						" Order by disp_rank";

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

	$PhpDate[$intCntP] = $objData->date;
	$PhpTime[$intCntP] = $objData->time;
	$PhpSeq[$intCntP] = $objData->seq;
	if ($objData->title !=""){
		$PhpTitle[$intCntP] = $objData->title;
	}else{
		$PhpTitle[$intCntP] = "タイトルなし";
	}


	for ($intSyainCnt = 0; $intSyainCnt < pg_numrows($objRecSyain); $intSyainCnt++) {
		$objSyain = pg_fetch_object($objRecSyain, $intSyainCnt);
		$Syain_name[$intCntP] .= $objSyain->name_kj_sei . $objSyain->name_kj_mei ."<BR>";
	}

	//長文ファイルチェック
	$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($PHP_BIT[2]==1){
		$strSyain="SELECT name_kj_sei,name_kj_mei FROM syain_tbl where syain_cd = '".$objData->syain_cd."'";
		$objRecSyain = pg_exec($strSyain);
		$objSyain = pg_fetch_object($objRecSyain, 0);
		if($objRecSyain==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
		$maker[$intCntP]="（".$objSyain->name_kj_sei.$objSyain->name_kj_mei."）";			
	}else{
		$maker[$intCntP]="";
	}
}

$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('Syain_name',$Syain_name);

$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('pg_numrows',pg_numrows($objRec));

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

$o_smarty->assign('PHP_BIT',$PHP_BIT[2]);
$o_smarty->assign('maker',$maker);

$o_smarty->assign('Sort_Ptn_S',$Sort_Ptn_S);
$o_smarty->assign('disp_Ptn',$disp_Ptn);


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


?>