MET993.php
4.7 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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
<?php
//*****************************************************************************
//*
//* プログラム名：業務報告ＣＳＶファイル吐き出し
//* プログラムID：MET993.php
//* 機能 ：ＣＳＶファイルにデータを吐き出す
//* 作成者 ：
//*
//* Copyright (C) 2004 Media Tech Inc. All rights reserved.
//*****************************************************************************
//***************************
//* インクルードファイル
//***************************
include("include/session_start.inc");
include("include/SessionChk.inc");
include("include/jcode.phps");
$strDBinc="include/dbcon.inc";
include($strDBinc);
//カテゴリマスタ情報取得
$strSQLmst = "SELECT category_name FROM mst_metcategory WHERE category_no=$category_no ";
$objRecmst = pg_exec($strSQLmst);
if($objRecmst==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objmst = pg_fetch_object($objRecmst, 0);
$category_name = $objmst->category_name;
//タイトルマスタ情報取得
$strSQLtitle = "SELECT title_name FROM mst_mettitle WHERE title_no=$title_no ";
$objRectitle = pg_exec($strSQLtitle);
if($objRectitle==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objTitle = pg_fetch_object($objRectitle, 0);
$title_name = $objTitle->title_name;
$strSQL="SELECT seq, meet_date,meet_time,memo,name_kj_sei,name_kj_mei,meet_tbl.seq,meet_tbl.syain_cd ".
"FROM syain_tbl,meet_tbl " .
"WHERE syain_tbl.syain_cd=meet_tbl.syain_cd and " .
"meet_tbl.title_no=$title_no " .
"Order by meet_date DESC";
$objRec = pg_exec($pg_con, $strSQL);
if ($objRec == false){
echo "SQLの実行に失敗しました。";
exit;
}
$intCount = pg_numrows($objRec);
$filename = "業務報告".date("Y").date("m").date("d").".csv";
//20090930 ファイル名の文字コード
//$filename = JcodeConvert($filename, 1, 2);
$Agent = getenv( "HTTP_USER_AGENT" );
/*201310対応
if( ereg( "MSIE", $Agent ) ){
$filename = JcodeConvert($filename, 1, 2);
} elseif( ereg( "Firefox", $Agent ) ) {
} elseif( ereg( "Safari", $Agent ) ) {
} else {
$filename = JcodeConvert($filename, 1, 2);
}
*/
if( preg_match( "/MSIE/", $Agent ) ){
$filename = JcodeConvert($filename, 1, 2);
} elseif( preg_match( "/Chrome/", $Agent ) ) {
$filename = JcodeConvert($filename, 1, 2);
} elseif( preg_match( "/Firefox/", $Agent ) ) {
} elseif( preg_match( "/Safari/", $Agent ) ) {
} else {
$filename = JcodeConvert($filename, 1, 2);
}
Header("Content-Disposition: attachment; filename=\"$filename\"");
Header("Content-Type: text/csv");
//ヘッダー行出力
$strWk=$category_name."(".$title_name.")\n";
echo JcodeConvert($strWk, 1, 2);
//明細データ出力
for ($i = 0; $i < $intCount; $i++){
$objData = pg_fetch_object($objRec, $i);
//部門名の取得
$strSQLbumon = "SELECT bumon_name FROM mst_bumon,syozoku_tbl " .
"WHERE syozoku_tbl.syain_cd = '$objData->syain_cd' and ".
" mst_bumon.syozoku_cd = syozoku_tbl.syozoku_cd " .
" Order by mst_bumon.disp_rank ";
$objRecbumon = pg_exec($strSQLbumon);
if($objRecbumon==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if(pg_numrows($objRecbumon)>0){
$objbumon = pg_fetch_object($objRecbumon, 0);
}
$strWk=$objData->name_kj_sei.$objData->name_kj_mei."（".$objbumon->bumon_name."）";
$strWk=JcodeConvert($strWk, 1, 2);
echo $strWk;
//発言日時編集
$strWk=$objData->meet_date;
echo ",".JcodeConvert($strWk, 1, 2);
$strWk=$objData->meet_time;
echo ",".JcodeConvert($strWk, 1, 2);
$strWk = str_replace("\r\n"," ",$objData->memo);
$strWk = str_replace(",","，",$strWk);
echo ",".JcodeConvert($strWk, 1, 2);
echo "\n";
//コメント
$strSqlC = "select comm_seq, meet_comm_tbl.syain_cd,comment, comm_date, syain_tbl.name_kj_sei, syain_tbl.name_kj_mei ";
$strSqlC .= "from meet_comm_tbl join syain_tbl on syain_tbl.syain_cd = meet_comm_tbl.syain_cd ";
$strSqlC .= "where seq = ".$objData->seq." order by comm_seq desc";
$objRecC = pg_exec($strSqlC);
if($objRecC==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (pg_numrows($objRecC) > 0){
for($ic=0;$ic<pg_numrows($objRecC);$ic++){
$objInfoC = pg_fetch_object($objRecC, $ic);
//指示者
$strWk = " 指示：".$objInfoC->name_kj_sei.$objInfoC->name_kj_mei;
$strWk=JcodeConvert($strWk, 1, 2);
echo $strWk;
//日付
$strWk = substr($objInfoC->comm_date,0,4)."/".substr($objInfoC->comm_date,4,2)."/".substr($objInfoC->comm_date,6,2);
$strWk=JcodeConvert($strWk, 1, 2);
echo ",".$strWk;
//時間
$strWk = substr($objInfoC->comm_date,8,2).":".substr($objInfoC->comm_date,10,2).":00";
$strWk=JcodeConvert($strWk, 1, 2);
echo ",".$strWk;
//指示内容
$strWk = str_replace("\r\n"," ",$objInfoC->comment);
$strWk = str_replace(",","，",$strWk);
echo ",".JcodeConvert($strWk, 1, 2);
echo "\n";
}
}
}
?>