<?php 
//新着メッセージ
header("Content-type: text/html; charset=EUC-JP");
include("include/session_start.inc");
include("include/SessionChk.inc");

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

//表示可否 		
if($GET_FileName != "TOP"){
	$strSQL = "select memo from kojin_data_tbl where syain_cd='".$PHP_SYAIN_CD."' and seq=7";
	$objRS = pg_exec($strSQL);
	if(pg_numrows($objRS) > 0){
		$objftc = pg_fetch_object($objRS,0);
		if($objftc->memo != "1"){
			exit;
		}
	}else{
		exit;
	}
}

//*** スケジュール***
$MenuArray = array(
    "TOP000.php" => "0",
    "TDL001.php" => "1",
    "RES001.php" => "2",
    "DUT001.php" => "3",
    "RPT001.php" => "4",
    "MET001.php" => "5",
    "TEL001.php" => "6",
    "CIR001.php" => "7",
    "BBS001.php" => "8",
    "MET010.php" => "9",
    "FLO001.php" => "10",
    "MDT001.php" => "11",
    "MEM001.php" => "12",
    "MIL001.php" => "13",
    "ADR001.php" => "14",
    "LIN001.php" => "15",
    "YBO001.php" => "16",
    "PRJ000.php" => "17",
    "WML000.php" => "18",
    "TIM001.php" => "19",
    "MNP010.php" => "20",
);

$strMenuSQL = "SELECT * FROM sub_menu_TBL ORDER BY main_index,index_no";
$objMenu = pg_exec($strMenuSQL);
for($intI = 0; $intI < pg_numrows($objMenu); $intI++) {

		$MenuRec = pg_fetch_object($objMenu, $intI);
		$strMenuTitle[$MenuArray[$MenuRec->url]] = $MenuRec->name;
		$PHP_TITLE_ID[$MenuArray[$MenuRec->url]] = substr($MenuRec->url,0,3);

}

/*
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'TOP000.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[0]=pg_result($rsRecset,0,"name");
}
//*** ＴｏＤｏ***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'TDL001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[1]=pg_result($rsRecset,0,"name");
}

//*** 施設予約***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'RES001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[2]=pg_result($rsRecset,0,"name");
}

//*** 当番担当者***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'DUT001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[3]=pg_result($rsRecset,0,"name");
}

//*** 営業報告・指示***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'RPT001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[4]=pg_result($rsRecset,0,"name");
}

//*** 業務報告・指示***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MET001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[5]=pg_result($rsRecset,0,"name");
}

//*** 電話連絡***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'TEL001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[6]=pg_result($rsRecset,0,"name");
}

//*** 回覧板***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'CIR001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[7]=pg_result($rsRecset,0,"name");
}

//*** 掲示板***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'BBS001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[8]=pg_result($rsRecset,0,"name");
}

//*** 電子会議***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MET010.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[9]=pg_result($rsRecset,0,"name");
}

//*** 電子決裁***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'FLO001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[10]=pg_result($rsRecset,0,"name");
}

//*** マイ・データ***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MDT001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[11]=pg_result($rsRecset,0,"name");
}

//*** マイ･ノート***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MEM001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[12]=pg_result($rsRecset,0,"name");
}

//*** ｗｅｂメール***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MIL001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[13]=pg_result($rsRecset,0,"name");
}

//*** アドレス情報***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'ADR001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[14]=pg_result($rsRecset,0,"name");
}

//*** リンク集***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'LIN001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[15]=pg_result($rsRecset,0,"name");
}

//*** お問い合わせ・要望***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'YBO001.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[16]=pg_result($rsRecset,0,"name");
}

//*** プロジェクト管理***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'PRJ000.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[17]=pg_result($rsRecset,0,"name");
}

//*** アンケート ***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MNP010.php'";
$rsRecset = pg_exec($strMenuSQL);
if (pg_numrows($rsRecset)>0){
	$strMenuTitle[20]=pg_result($rsRecset,0,"name");
}
*/




//*****未読電話メモ*****//
if ($strMenuTitle[6]!=""){
	$SQL = "SELECT message FROM telmemo_TBL WHERE to_code='$PHP_SYAIN_CD' and read_flg=0";
	$MEMO_RS = pg_exec($SQL);
	$NW_intTelmemo=pg_numrows($MEMO_RS);
}
//*****未読掲示板*****//
if ($strMenuTitle[8]!=""){
	$SQL = "SELECT seq FROM pbbs_tbl Where syain_cd = '$PHP_SYAIN_CD' and read_flg=0 ";
	$BBS_RS = pg_exec($SQL);
	$NW_intBbs=pg_numrows($BBS_RS);
}
//*****未読回覧板*****//
if ($strMenuTitle[7]!=""){
	$SQL = "SELECT seq FROM pkairan_tbl Where syain_cd = '$PHP_SYAIN_CD' and read_flg=0 and del_flg=0 ";
	$KAI_RS = pg_exec($SQL);
	$NW_intKairan=pg_numrows($KAI_RS);
}
//*****業務報告・指示*****//
if ($strMenuTitle[5]!=""){
	$SQL = "SELECT seq FROM pmeet_tbl Where syain_cd = '$PHP_SYAIN_CD' and read_flg=0 ";
	$MEET_RS = pg_exec($SQL);
	$NW_intMeet=pg_numrows($MEET_RS);
}
//*****未読営業日報*****//
//$NW_intEigyou=0;
if ($strMenuTitle[4]!=""){
	$SQL = "SELECT seq FROM peigyou_tbl Where syain_cd = '$PHP_SYAIN_CD' and read_flg=0 ";
	$EI_RS = pg_exec($SQL);
	$NW_intEigyou=pg_numrows($EI_RS);
}
//*****電子会議室*****//
$dateNOW = date("YmdH");	//現在日時:YYYYMMDDHH
$intNoReadIN = 0;			//開催中未読件数
$intNoReadOUT = 0;			//期間外未読件数
$NW_intMeetingNUM = 0;			//開催中会議数
//開催中未読件数
if ($strMenuTitle[9]!=""){
	$strSQL = "select  count(read_flg) as cnt from pkaigi_tbl join kaigi_info_tbl ";
	$strSQL .= "on date_start <= '".$dateNOW."' and date_end > '".$dateNOW."' and (list_spk like '%/".$PHP_SYAIN_CD."/%' or list_obs like '%/".$PHP_SYAIN_CD."/%') and kaigi_info_tbl.meeting_no = pkaigi_tbl.meeting_no ";
	$strSQL .= "where syain_cd = '".$PHP_SYAIN_CD."' and read_flg = 0 group by read_flg ";
	$recData=pg_exec($strSQL);
	if($recData==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($recData)>0){
		$ftcData = pg_fetch_object($recData,0);
		$intNoReadIN = $ftcData->cnt;
	}
	//期間外未読件数
	$strSQL = "select  count(read_flg) as cnt from pkaigi_tbl join kaigi_info_tbl ";
	$strSQL .= "on date_start > '".$dateNOW."' or date_end <= '".$dateNOW."' and (list_spk like '%/".$PHP_SYAIN_CD."/%' or list_obs like '%/".$PHP_SYAIN_CD."/%') and kaigi_info_tbl.meeting_no = pkaigi_tbl.meeting_no ";
	$strSQL .= "where syain_cd = '".$PHP_SYAIN_CD."' and read_flg = 0 group by read_flg ";
	$recData=pg_exec($strSQL);
	if($recData==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($recData)>0){
		$ftcData = pg_fetch_object($recData,0);
		$intNoReadOUT = $ftcData->cnt;
	}
	//開催中会議数
	$strSQL = "select count(meeting_no) as cnt from kaigi_info_tbl ";
	$strSQL .= "where date_start <= '".$dateNOW."' and date_end > '".$dateNOW."' and (list_spk like '%/".$PHP_SYAIN_CD."/%' or list_obs like '%/".$PHP_SYAIN_CD."/%') ";
	$recData=pg_exec($strSQL);
	if($recData==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if(pg_numrows($recData)>0){
		$ftcData = pg_fetch_object($recData,0);
		$NW_intMeetingNUM = $ftcData->cnt;
	}
	
	//議事録未作成数
	$strTemp = date("Y").date("m").date("d").date("H");
	$strSQL = "select theme, measure, meeting_rule, etc,date_start, date_end, chairperson, minutes_maker, minutes, list_spk, list_obs, ";
	$strSQL .= "file_name, file_name_jp, notice_flg, opener, mst_kaigi_category.category_name, mst_kaigi_category.category_no ";
	$strSQL .= "from kaigi_info_tbl join mst_kaigi_category on mst_kaigi_category.category_no = kaigi_info_tbl.category_no ";
	$strSQL .= "where date_end < '".$strTemp."' and minutes_maker='".$PHP_SYAIN_CD."' and minutes IS NULL";
	$recData=pg_exec($strSQL);
	if($recData==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$intGiji=pg_numrows($recData);
}
//*****担当*****//
/*
$toban_date=Date("Y")."/".Date("m")."/".Date("d");
$strSQL="Select toban_no,syain_cd From touban_tbl ".
		"WHERE touban_st_date<='$toban_date' and ".
		"'$toban_date'<=touban_ed_date and ".
		" syain_cd like '%/".$PHP_SYAIN_CD."/%' ";
$objRevSet = pg_exec($strSQL);
if($objRevSet==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
*/
//*****決裁（管理者）*****//
if ($strMenuTitle[10]!=""){
	$strKessai="Select Distinct(sinsei_tbl.seq) From kessaisya_tbl,sinsei_tbl ".
				" Where kessaisya_tbl.sinsei_syubetu=sinsei_tbl.sinsei_syubetu and " .
				"((kessaisya_cd1='$PHP_SYAIN_CD'  and sinsei_flg1 = 0) or ".
				"(kessaisya_cd2='$PHP_SYAIN_CD' and sinsei_flg1 = 1 and sinsei_flg2 = 0) or ".
				"(kessaisya_cd3='$PHP_SYAIN_CD' and sinsei_flg2 = 1 and sinsei_flg3 = 0) or ".
				"(kessaisya_cd4='$PHP_SYAIN_CD' and sinsei_flg3 = 1 and sinsei_flg4 = 0) or ".
				"(kessaisya_cd5='$PHP_SYAIN_CD' and sinsei_flg4 = 1 and sinsei_flg5 = 0))";
	$objRecKessai = pg_exec($strKessai);
	if($objRecKessai==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$intKessai=pg_numrows($objRecKessai);
	
	//*****決裁（申請書）*****//
/*
	$strSin="Select sinsei_tbl.seq,sinsei_name,sinsei_tbl.sinsei_syubetu,sinsei_flg1,sinsei_flg2,".
			"sinsei_flg3,sinsei_flg4,sinsei_flg5,kessaisya_num".
			" From kessaisya_tbl,mst_sinsei,sinsei_tbl ".
			" Where kessaisya_tbl.sinsei_syubetu=sinsei_tbl.sinsei_syubetu and ".
			" mst_sinsei.sinsei_syubetu=sinsei_tbl.sinsei_syubetu and ".
			" sinsei_tbl.syain_cd='$PHP_SYAIN_CD' Order by sinsei_tbl.seq ";
*/
$strSin="Select sinsei_tbl.seq,sinsei_name,sinsei_tbl.sinsei_syubetu,sinsei_flg1,sinsei_date1,sinsei_flg2,sinsei_date2,".
				"sinsei_flg3,sinsei_date3,sinsei_flg4,sinsei_date4,sinsei_flg5,sinsei_date5,kessaisya_num".
				" From kessaisya_tbl,mst_sinsei,sinsei_tbl ".
				" Where kessaisya_tbl.sinsei_syubetu=sinsei_tbl.sinsei_syubetu and ".
				" mst_sinsei.sinsei_syubetu=sinsei_tbl.sinsei_syubetu and ".
				" sinsei_tbl.syain_cd='$PHP_SYAIN_CD' Order by sinsei_tbl.seq ";

	$objRecSin = pg_exec($strSin);
	if($objRecSin==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
}
//*****掲示板*****//
$SQL = "SELECT seq,voicedate,voicetime,title,message FROM bbs_tbl ORDER BY seq DESC";
$BBS_RS = pg_exec($SQL);
//自分の所属を取得
$strSQL_s = "SELECT syozoku_cd ".
			"FROM syozoku_tbl " .
			"WHERE syain_cd ='$PHP_SYAIN_CD'";
$objRec_s = pg_exec($strSQL_s);
if($objRec_s==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
for ($intSyozoku=0; $intSyozoku < pg_numrows($objRec_s); $intSyozoku++){
	$objSyozoku = pg_fetch_object($objRec_s, $intSyozoku);
	
	if ($intSyozoku==0){
		$strJoken= " and (send_bumon =0 or  send_bumon = " .$objSyozoku->syozoku_cd ;
	}else{
		$strJoken=$strJoken. " or send_bumon=".$objSyozoku->syozoku_cd ;
	}
}
if (pg_numrows($objRec_s) > 0){
	$strJoken=$strJoken. ") ";
}else{
	$strJoken= " and (send_bumon =0)";
}

//メモ帳情報取得
$strSQLmemo="Select memo From memo_tbl Where syain_cd = '$PHP_SYAIN_CD' ";
$objRecmemo = pg_exec($strSQLmemo);
if($objRecmemo==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}
if (pg_numrows($objRecmemo) > 0){
	$objDatamemo = pg_fetch_object($objRecmemo, 0);
	$freememo=$objDatamemo->memo;
}else{
	$freememo="";
}

if ($strMenuTitle[10]!=""){
	$intSeinseiNow=0;
	$intSeinseiOK=0;
	$intSeinseiNO=0;
	for($intSin = 0; $intSin < pg_numrows($objRecSin);$intSin++) {
		$objDateSin = pg_fetch_object($objRecSin, $intSin);
		$strComent="";
		unset($strSinsei);
		//決裁状況
		$strSinsei[$intSin][0]=$objDateSin->sinsei_name;
		$strSinsei[$intSin][1]=$objDateSin->sinsei_flg1;
		$strSinsei[$intSin][2]=$objDateSin->sinsei_flg2;
		$strSinsei[$intSin][3]=$objDateSin->sinsei_flg3;
		$strSinsei[$intSin][4]=$objDateSin->sinsei_flg4;
		$strSinsei[$intSin][5]=$objDateSin->sinsei_flg5;
		$strSinsei[$intSin][6]=$objDateSin->kessaisya_num;
		//申請日付追加
		$strSinseiDate[$intSin][0]= $objDateSin->sinsei_date1;
		$strSinseiDate[$intSin][1]= $objDateSin->sinsei_date2;
		$strSinseiDate[$intSin][2]= $objDateSin->sinsei_date3;
		$strSinseiDate[$intSin][3]= $objDateSin->sinsei_date4;
		$strSinseiDate[$intSin][4]= $objDateSin->sinsei_date5;
		for($intLestDate = 0; $intLestDate < 5; $intLestDate++) {
			if($strSinseiDate[$intSin][$intLestDate] <> ""){
					$strSinseiLestDate = $strSinseiDate[$intSin][$intLestDate];
			}
		}
		$strSinseiLestDate = str_replace ("/", "",$strSinseiLestDate);
		$Today = date("Ymd");

		for($intKessaiCnt = 1; $intKessaiCnt < 6 ;$intKessaiCnt++) {
			if ($strSinsei[$intSin][$intKessaiCnt]==0 and $intKessaiCnt <= $strSinsei[$intSin][6]){
				$intSeinseiNow++;
				break;
			}elseif(($strSinsei[$intSin][$intKessaiCnt]==1 or $strSinsei[$intSin][$intKessaiCnt]==3) and $intKessaiCnt == $strSinsei[$intSin][6]){
				if ($strSinseiLestDate + 7 > $Today ){
					$intSeinseiOK++;
					break;
				}else{
					break;
				}
			}elseif($strSinsei[$intSin][$intKessaiCnt]==2 ){
				$intSeinseiNO++;
				break;
			}
		}
		$intKessai2[$intSin]=$strComent;
	}
}

/* WEBメールチェック廃止！！
//WEB_MAIL
if ($strMenuTitle[13]!=""){
	$strSql = "SELECT send_flg7,send_flg10 FROM sendinfo_tbl WHERE syain_cd ='$PHP_SYAIN_CD'";
	$rsRecset = pg_exec($pg_con,$strSql);
	if (pg_numrows($rsRecset)>0){
		$objData = pg_fetch_object($rsRecset, 0);
		$size_flg=$objData->send_flg10;
		if ($size_flg==""){
				$size_flg=0;
		}
		$usemail_flg=$objData->send_flg7;
		if ($usemail_flg==""){
				$usemail_flg=0;
		}
	}else{
		$size_flg=0;
		$usemail_flg=0;
	}
}else{
	$size_flg=0;
	$usemail_flg=0;
}
//Webメール新着メール取得
if ($usemail_flg == 0){
	//メールサーバ登録状況確認
	$strSQLseq="Select * from mail_TBL Where syain_cd='".$PHP_SYAIN_CD."'";
	$objRecseq = pg_exec($strSQLseq);
	if($objRecseq==false){	
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}	
	if (pg_numrows($objRecseq) > 0){
		$objmail = pg_fetch_object($objRecseq, 0);
		$strMailAdd=$objmail->mail_add;
		$intSrvadd=$objmail->pop3_add;
		$strUserName=$objmail->mail_name;
		$strPASSWORD=$objmail->mail_pass;
		if ((trim($strMailAdd) !="") && (trim($intSrvadd) !="") && (trim($strUserName) !="") && (trim($strPASSWORD) !="")){
			// 登録サーバー名取得
			$strSQLseq="Select * from mailAdmin_TBL Where srv_id=".$intSrvadd." and srv_flg=2";
			$objRecseq = pg_exec($strSQLseq);
			if($objRecseq==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
			}
			if (pg_numrows($objRecseq) > 0){
				include("inc/MIL001.inc");
				include("inc/MIL002.inc");
				$use_apop    = FALSE; // use APOP for authentication
				$objmail = pg_fetch_object($objRecseq, 0);
				$strSrvName=$objmail->srv_add;
				// POPサーバー接続
				$p = new pop3($strSrvName, $strUserName, $strPASSWORD);
				$p->apop = $use_apop;
				if (!$p->open()) {
					$webmail_flg=0;
				}else{
					list($total_num, $total_size) = $p->get_stat();
					$list = $p->get_list();
					$uid  = $p->get_uidl();
					$tmpdir  = "../".$PHP_FOLDER."/temp/mail/";
					//サーバ内の全メール取得
					$init_num = $total_num;
					if (function_exists("mb_internal_encoding")) {
						mb_internal_encoding("EUC");
					}
					//メールサーバからDBにインサート
					$int_mail = 0;
					for ($num = $init_num; $num > 0; --$num) {
						//DBに既に存在するか確認
						$strSQLchk="Select mail_id,del_flg from mail_get_tbl Where mail_id ='".addslashes($uid[$num])."' and syain_cd='$PHP_SYAIN_CD'";
						$objRecchk = @pg_exec($strSQLchk);
						if($objRecchk==false){
							echo $strSQLchk."<BR>";
							echo("SQL実行に失敗しました(SELECT)");
							exit;
						}
						if (pg_numrows($objRecchk) == 0){
							$int_mail_new+=1;
						}
					}
					//未読メッセージ取得
					$strSQLmi="Select mail_id from mail_get_tbl Where syain_cd='$PHP_SYAIN_CD' and kind_flg=0 and del_flg=0";
					$objRecmi = pg_exec($strSQLmi);
					if($objRecmi==false){
						echo("SQL実行に失敗しました(SELECT)");
						exit;
					}
					$int_mail=(integer)$int_mail_new + (integer)pg_numrows($objRecmi);
				}
				
			}else{
				$webmail_flg=0;
			}
		}else{
			$webmail_flg=0;
		}
	}else{
		$webmail_flg=0;
	}
}
*/
function mime_split($data) {
	$part = split("\r\n\r\n", $data, 2);
	$part[1] = ereg_replace("\r\n[\t ]+", " ", $part[1]);
	return $part;
}
/* 文字コードコンバートJIS→SJIS */
function convert($str) {
	if (function_exists('mb_convert_encoding')) {
		return mb_convert_encoding($str, "SJIS", "JIS,SJIS");
	} elseif (function_exists('JcodeConvert')) {
		return JcodeConvert($str, 0, 2);
	}
	return true;
}

//*****プロジェクト管理*****//
if ($strMenuTitle[17]!=""){
//*****参加件数（進行中）*****//
	$SQL = "SELECT seq FROM prj_tbl WHERE sanka_list like '%/".$PHP_SYAIN_CD."/%'";
	$PRJ_RS = pg_exec($SQL);
	$intPrjNum = pg_numrows($PRJ_RS);
//*****参加件数（未完了）*****//
	$SQL = "SELECT seq FROM prj_tbl WHERE sanka_list like '%/".$PHP_SYAIN_CD."/%' and end_flg = 0 and end_date > '".date("Ymd")."'";
	$PRJ_RS = pg_exec($SQL);
	$intPrjNumEnd = pg_numrows($PRJ_RS);
//*****参加件数（完了）*****//

	$SQL = "SELECT seq FROM prj_tbl WHERE sanka_list like '%/".$PHP_SYAIN_CD."/%' and end_flg = 1";
	$PRJ_RS = pg_exec($SQL);
	$intPrjNumEnd2 = pg_numrows($PRJ_RS);

//*****監査件数*****//
	$SQL = "SELECT seq FROM prj_tbl WHERE kansa_list like '%/".$PHP_SYAIN_CD."/%' and end_flg = 0";
	$PRJ_RS = pg_exec($SQL);
	$intPrjKansa = pg_numrows($PRJ_RS);
//*****監査件数*****//
	$SQL = "SELECT seq FROM prj_comm_tbl WHERE syain_cd = '".$PHP_SYAIN_CD."' and comment = '0'";
	$PRJ_RS = pg_exec($SQL);
	$intPrjKansaNo = pg_numrows($PRJ_RS);
}

//*****アンケート*****//
if ($strMenuTitle[20]!=""){
		$SQL = "SELECT * FROM mnp_syain_info WHERE syain_cd = '".$PHP_SYAIN_CD."' AND read_flg <> 2";
		$MNP_RS = pg_exec($SQL);
		$NW_MNP=pg_numrows($MNP_RS);
}


//SQL->HTMLタグ生成
//電子会議
if($NW_intMeetingNUM!=0){
	if($intNoReadIN!=0){
		$HTML_SMET="<span class=Normalfont> <A href=MET010.php>開催中".$NW_intMeetingNUM."件(未読".$intNoReadIN."件)</a></span>";
	}else{
		$HTML_SMET="<span class=Normalfont> <A href=MET010.php>開催中".$NW_intMeetingNUM."件</a></span>";
	}
}
if($intNoReadOUT!=0){
		$HTML_EMET="<span class=Normalfont> <A href=MET010.php?selDisp=2>終了未読".$intNoReadOUT."件</a></span>";
}
if($intGiji!=0){
	$HTML_GMET="<span class=Normalfont> <A href=MET010.php?selDisp=3>未作成議事録".$intGiji."件</a></span>";
}
if($HTML_SMET!="" || $HTML_EMET!="" || $HTML_GMET!=""){
	$HTML_NMET = "<span class=Normalfont><img src=image/kaigi.gif height=19 width=20 alt=開催中の".$strMenuTitle[9]." border=0>".$strMenuTitle[9]."</SPAN>[".$HTML_SMET.$HTML_EMET.$HTML_GMET."]";
}
//プロジェクト管理
$HTML_PRJ = "";	
//20090129完了プロジェクト件数非表示対応
$intPrjNum = $intPrjNum - $intPrjNumEnd2;
if($intPrjNum != 0){
	$HTML_PRJ .= "<span class=Normalfont><A href=PRJ000.php>参加".$intPrjNum."件";
	if($intPrjNumEnd != 0){
		$HTML_PRJ .= "(未完".$intPrjNumEnd."件)";
	}
	$HTML_PRJ .= "</a></span>";
}
if($intPrjKansa != 0){
			$HTML_PRJ .= " <span class=Normalfont> <A href=PRJ000.php>確認".$intPrjKansa."件";
			if($intPrjKansaNo != 0){
				$HTML_PRJ .= "(未確認".$intPrjKansaNo."件)";
			}
			$HTML_PRJ .= "</a></span>";
}else{
			if($intPrjKansaNo != 0){
				$HTML_PRJ .= " <span class=Normalfont> <A href=PRJ000.php>";
				$HTML_PRJ .= "未確認".$intPrjKansaNo."件";
				$HTML_PRJ .= "</a></span>";
			}
}

if($HTML_PRJ != ""){
	$HTML_PRJ = "<span class=Normalfont><img src=image/prj.gif height=19 width=20 alt=".$strMenuTitle[17]." border=0>".$strMenuTitle[17]."</SPAN>[".$HTML_PRJ."]";
}
//共有スケジュール
if($intSchedule!=0){
	$HTML_SCH="<span class=Normalfont> <A href=><img src=image/new_sch.gif height=19 width=20 alt=新規共有スケジュール border=0>共有スケジュール".$intSchedule."件</a></span>";
}

/*
//メール
if($int_mail!=0){
	$HTML_MIL="<span class=Normalfont> <A href=MIL001.php><img src=image/mail.gif height=19 width=20 alt=未読".$strMenuTitle[13]." border=0>".$strMenuTitle[13]."".$int_mail."件</a></span>";
}
*/

//電話メモ
if($NW_intTelmemo!=0){
	$HTML_TEL="<span class=Normalfont> <A href=TEL001.php><img src=image/tel.gif height=19 width=20 alt=".$strMenuTitle[6]." border=0>".$strMenuTitle[6]."".$NW_intTelmemo."件</a></span>";
}
//掲示板
if($NW_intBbs!=0){
	$HTML_BBS="<span class=Normalfont> <A href=BBS001.php><img src=image/keijiban.gif height=19 width=20 alt=".$strMenuTitle[8]." border=0>".$strMenuTitle[8]."".$NW_intBbs."件</a></span>";
}
//回覧板
if($NW_intKairan!=0){
	$HTML_CIR="<span class=Normalfont> <A href=CIR001.php><img src=image/kairan.gif height=19 width=20 alt=".$strMenuTitle[7]." border=0>".$strMenuTitle[7]."".$NW_intKairan."件</a></span>";
}
//業務報告
if($NW_intMeet!=0){
	$HTML_MET="<span class=Normalfont> <A href=MET001.php><img src=image/kaigi.gif height=19 width=20 alt=".$strMenuTitle[5]." border=0>".$strMenuTitle[5]."".$NW_intMeet."件</a></span>";
}
//営業日報
if($NW_intEigyou!=0){
	$HTML_PRT="<span class=Normalfont> <A href=RPT001.php><img src=image/eigyou.gif height=19 width=20 alt=".$strMenuTitle[4]." border=0>".$strMenuTitle[4]."".$NW_intEigyou."件</a></span>";
}
//決裁
if($intKessai!=0){
	$HTML_FLO="<span class=Normalfont> <A href=FLO001.php?disp_flg=1><img src=image/kessai.gif height=19 width=20 alt=".$strMenuTitle[10]." border=0>決裁待ち".$intKessai."件</a></span>";
}
if($intSeinseiNow!=0){
	$HTML_FLO3="<span class=Normalfont> <A href=FLO001.php><img src=image/kessai.gif height=19 width=20 alt=".$strMenuTitle[10]." border=0>決裁中".$intSeinseiNow."件</a></span>";
}
if($intSeinseiOK!=0){
	$HTML_FLO4="<span class=Normalfont> <A href=FLO001.php><img src=image/kessai.gif height=19 width=20 alt=".$strMenuTitle[10]." border=0>決裁承認".$intSeinseiOK."件</a></span>";
}
if($intSeinseiNO!=0){
	$HTML_FLO5="<span class=Normalfont> <A href=FLO001.php><img src=image/kessai.gif height=19 width=20 alt=".$strMenuTitle[10]." border=0>決裁却下".$intSeinseiNO."件</a></span>";
}
for($i = 0; $i < count($intKessai2);$i++) {
	if($intKessai2[$i]!=""){
		$HTML_FLO2[$i]="<span class=Normalfont>".$intKessai2[$i]."</span>";

	}
}
if($NW_MNP!=0){
	$HTML_MNP="<span class=Normalfont> <A href=MNP010.php><img src=image/mnp_c.gif height=19 width=20 alt=".$strMenuTitle[20]." border=0>".$strMenuTitle[20].$NW_MNP."件</a></span>";
}

?>
<!--新着メッセージ-->
<table cellSpacing="0" cellPadding="0" width="100%" class="NewMessColor">
<TR><TD valign="top" width="100">

<!--
	<?php  echo $HTML_SMET; ?>
	<?php  echo $HTML_EMET; ?>
	<?php  echo $HTML_GMET; ?>
-->
<a href="javascript:loadHTMLFileNW('NewData.php?GET_FileName=<?php  echo $GET_FileName ; ?>');"><SPAN class="new_data">新着情報</SPAN></a></td>
<td>
	<?php  echo $HTML_NMET; ?>
	<?php  echo $HTML_PRJ; ?>
	<?php  echo $HTML_SCH; ?>
	<?php  echo $HTML_MIL; ?>
	<?php  echo $HTML_TEL; ?>
	<?php  echo $HTML_BBS; ?>
	<?php  echo $HTML_CIR; ?>
	<?php  echo $HTML_MET; ?>
	<?php  echo $HTML_PRT; ?>
	<?php  echo $HTML_FLO; ?>
	<?php  echo $HTML_FLO3; ?>
	<?php  echo $HTML_FLO4; ?>
	<?php  echo $HTML_FLO5; ?>
	<?php  echo $HTML_MNP; ?>
<?php 
for($i=0;$i<count($HTML_FLO2);$i++){
	echo $HTML_FLO2[$i];
}
?>
</TD></TR>
</TABLE>