MET001_m.php
3.97 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
<?php
//*****************************************************************************
//*
//* プログラム名：電子会議室(携帯電話)
//* プログラムID：MET001_m.php
//* 機能 ：一覧画面
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");
//*** 広告 ***//
include("include_m/Advertisement.inc");
//*** 共通処理 ***//
include("include_m/CommonProcess.inc");
//*** 業務報告・指示***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MET001.php'";
$rsRecset = pg_exec($strMenuSQL);
$PHP_TITLE_NAME=mb_convert_encoding(pg_result($rsRecset,0,"name"), "SJIS", "EUC-JP");
//自分の所属を取得
$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 (bumon_cd =0 or bumon_cd = " .$objSyozoku->syozoku_cd ;
}else{
$strJoken=$strJoken. " or bumon_cd=".$objSyozoku->syozoku_cd ;
}
}
if (pg_numrows($objRec_s) > 0){
$strJoken=$strJoken. ") ";
}else{
$strJoken= " and (bumon_cd =0)";
}
//電子会議室情報取得
//一般用
$strSQLData="Select * From mst_metcategory,mst_mettitle,meet_tbl " .
"Where mst_metcategory.category_no=mst_mettitle.category_no " .
" and mst_metcategory.category_no=meet_tbl.category_no " .
" and mst_mettitle.title_no=meet_tbl.title_no " .$strJoken .
" Order by mst_metcategory.disp_rank,mst_mettitle.title_no DESC,meet_tbl.seq DESC";
$objRecData = pg_exec($strSQLData);
if($objRecData==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE>E-グルPro(<?php echo $PHP_TITLE_NAME; ?>)</TITLE>
</HEAD>
<BODY>
<form>
<center>
<?php echo $PHP_TITLE_NAME; ?><br>
<?php echo $strName; ?>
<HR width="100%">
<?php echo $koukokuTEL; ?>
</center>
<?php
//メニュー表示
include("include_m/CommonMenuReturn.inc");
?>
<HR width="100%">
<?php
//*** 一覧表示 ***//
for ($intCnt = 0; $intCnt < pg_numrows($objRecData); $intCnt++) {
$objData = pg_fetch_object($objRecData, $intCnt);
if($objData->bumon_cd==0){
$strBumonName="全部門";
}else{
//部門情報取得
$strSQLbumon = "SELECT bumon_name FROM mst_bumon " .
" Where syozoku_cd=$objData->bumon_cd";
//echo $strSQLbumon;
$objRec = pg_exec($strSQLbumon);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objBumon = pg_fetch_object($objRec, 0);
$strBumonName=$objBumon->bumon_name;
}
//カテゴリ名表示
if ($intCtgory_bk!=$objData->category_no){
echo "【".mb_convert_encoding($objData->category_name, "SJIS", "EUC-JP")."】<br>";
//$intCtgory_bk=$objData->category_no;
}
if ($intTitle_bk!=$objData->title_no){
$intctg=$objData->category_no;
$inttil=$objData->title_no;
//*****未読電子会議室*****//
$SQL = "SELECT seq FROM pmeet_tbl Where syain_cd = '$PHP_SYAIN_CD' and category_no=$intctg and title_no=$inttil and read_flg=0 ";
$MEET_RS = pg_exec($SQL);
$intMeet=pg_numrows($MEET_RS);
echo ' <a href="MET002_m.php?category_no='.$intctg.'&title_no='.$inttil.
'&'.$PHP_Argument.'">'.
mb_convert_encoding($objData->title_name, "SJIS", "EUC-JP").'</a>';
if (($intMeet > 0) && ($objInfo->read_flg == 0) && ($kanri_flg ==0)){
echo "(未読".$intMeet."件）";
}
echo "<br>";
$intTitle_bk=$objData->title_no;
}
$intCtgory_bk=$objData->category_no;
}
?>
<HR width="100%">
<?php
//メニュー表示
include("include_m/CommonMenuReturn.inc");
//*** 共通変数取得 ***//
include("include_m/CommonHidden.inc");
?>
</form>
</BODY>
</HTML>