MET002_1.php
2.23 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
<?php
//*****************************************************************************
//*
//* プログラム名：業務報告・指示
//* プログラムID：MET002_1.php
//* 機能 ：指示入力画面
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//*****************************************************************************
//* インクルードファイル
//*****************************************************************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include('./include/smarty.conf');
include("./include/dbcon.inc");
$comment = "";
for($intI=1;$intI<=3;$intI++){
$File_Flg[$intI] = "0";
$File_ID[$intI] = "";
$File_NameOrg[$intI] = "";
$File_NameJp[$intI] = "";
}
if($comm_seq!=0){
//コメント抽出
$strSQL = "SELECT * FROM meet_comm_tbl WHERE seq = ".$cseq." AND comm_seq = ".$comm_seq;
$objRec = pg_exec($strSQL);
if($objRec == false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRec) > 0){
$objNo = pg_fetch_object($objRec, 0);
$comment = $objNo->comment ;
}
//添付ファイル取得
$strSQLF = "select * from meet_file_tbl where meet_seq = ".$cseq." and comm_seq = ".$comm_seq." order by file_seq";
$objRecF = pg_exec($strSQLF);
if($objRecF==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecF) > 0){
for($fcnt2=0;$fcnt2<pg_numrows($objRecF);$fcnt2++){
$objF = pg_fetch_object($objRecF, $fcnt2);
$File_Flg[$objF->file_seq] = "1";
$File_ID[$objF->file_seq] = $objF->file_seq;
$File_NameOrg[$objF->file_seq] = $objF->file_org;
$File_Name[$objF->file_seq] = $objF->file_name;
}
}
}
$o_smarty->assign('cseq',$cseq);
$o_smarty->assign('comm_seq',$comm_seq);
$o_smarty->assign('comment',$comment);
$o_smarty->assign('File_Flg' , $File_Flg);
$o_smarty->assign('File_ID' , $File_ID);
$o_smarty->assign('File_NameOrg' , $File_NameOrg);
$o_smarty->assign('File_Name' , $File_Name);
$o_smarty->assign('PHP_DISABLED',$PHP_DISABLED);
$o_smarty->assign('PHP_DISABLED_flg',$PHP_DISABLED_flg);
$o_smarty->assign('PHP_E_GRU_CAPA_OVER',$_SESSION["PHP_E_GRU_CAPA_OVER"]);
$o_smarty->display('MET002_1.tpl');
?>