MNP020.php
4.75 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
<?php
//*****************************************************************************
//*
//* プログラム名：アンケート機能
//* プログラムID：MNP020.php
//* 機能 ：アンケート作成一覧
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/session_start.inc");
include("./include/SessionChk.inc");
//***************************
//* 画面制御
//***************************
include('./include/smarty.conf');
include("./inc/header.inc");
include("./inc/input_chk.inc");
include("./menu_opacity.php"); //メニュー
include("./inc/MNP000.inc");
include("./include/dbcon.inc");
if (empty($_POST["intPage"])){
$intPage=0;
}
//一覧取得
$strSQL = "SELECT ";
$strSQL .= " mnp_kihon_tbl.mail_id ,";
$strSQL .= " mnp_kihon_tbl.mail_subject ,";
$strSQL .= " mnp_kihon_tbl.mail_body ,";
$strSQL .= " mnp_kihon_tbl.send_syain_cd,";
$strSQL .= " mnp_kihon_tbl.send_mode ,";
$strSQL .= " mnp_kihon_tbl.send_date ,";
$strSQL .= " mnp_kihon_tbl.send_time ,";
$strSQL .= " mnp_kihon_tbl.ans_type ,";
$strSQL .= " mnp_kihon_tbl.ans_limit ,";
$strSQL .= " mnp_kihon_tbl.disp_mode ,";
$strSQL .= " syain_tbl.name_kj_sei ,";
$strSQL .= " syain_tbl.name_kj_mei ";
$strSQL .= "FROM";
$strSQL .= " syain_tbl , ";
$strSQL .= " mnp_kihon_tbl ";
$strSQL .= "WHERE";
$strSQL .= " syain_tbl.syain_cd = mnp_kihon_tbl.send_syain_cd AND ";
$strSQL .= " send_syain_cd='".$_SESSION["PHP_SYAIN_CD"]."'";
$strSQL .= "ORDER BY ";
$strSQL .= " send_date DESC,";
$strSQL .= " send_time DESC ";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if (($intPage > 0) && (pg_numrows($objRec) > (10 * ($intPage+1)))){
$PageBack = " onClick=\"Make_PageCnt(".($intPage-1).");\"";
$PageNext = " onClick=\"Make_PageCnt(".($intPage+1).");\"";
}elseif(($intPage > 0) && (pg_numrows($objRec) <= (10 * ($intPage+1)))){
$PageBack = " onClick=\"Make_PageCnt(".($intPage-1).");\"";
$PageNext = " readonly disabled";
}elseif(($intPage == 0) && (pg_numrows($objRec) > (10 * ($intPage+1)))){
$PageBack = " readonly disabled";
$PageNext = " onClick=\"Make_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;
$List_Data[$intCntP][0] = $objData->mail_id;
$List_Data[$intCntP][1] = $objData->mail_subject;
$List_Data[$intCntP][2] = $objData->mail_body;
$List_Data[$intCntP][3] = $objData->send_syain_cd;
$List_Data[$intCntP][4] = $objData->send_mode;
$List_Data[$intCntP][5] = $objData->send_date;
$List_Data[$intCntP][6] = $objData->send_time;
$List_Data[$intCntP][7] = $objData->ans_type;
$List_Data[$intCntP][8] = $objData->ans_limit;
$List_Data[$intCntP][9] = $objData->disp_mode;
$List_Data[$intCntP][10] = $objData->name_kj_sei;
$List_Data[$intCntP][11] = $objData->name_kj_mei;
$strSQL = "SELECT ";
$strSQL .= " (SELECT COUNT(*) FROM mnp_syain_info AS chk1 WHERE chk1.mail_id=M.mail_id) AS send_cnt ,";
$strSQL .= " (SELECT COUNT(*) FROM mnp_syain_info AS chk1 WHERE chk1.mail_id=M.mail_id AND chk1.read_flg = 0) AS n_read_cnt,";
$strSQL .= " (SELECT COUNT(*) FROM mnp_syain_info AS chk2 WHERE chk2.mail_id=M.mail_id AND chk2.read_flg = 1) AS read_cnt ,";
$strSQL .= " (SELECT COUNT(*) FROM mnp_syain_info AS chk3 WHERE chk3.mail_id=M.mail_id AND chk3.read_flg = 2) AS ans_cnt ";
$strSQL .= "FROM ";
$strSQL .= " mnp_syain_info AS M ";
$strSQL .= "WHERE";
$strSQL .= " M.mail_id=".$objData->mail_id." ";
$strSQL .= "GROUP BY ";
$strSQL .= " M.mail_id";
//echo $strSQL."<hr>";
$objCntRec = pg_exec($strSQL);
if($objCntRec==false){
echo("SQL実行に失敗しました(SELECT)b");
exit;
}
$objCntData = pg_fetch_object($objCntRec, 0);
$List_Data[$intCntP][12] = $objCntData->send_cnt;
$List_Data[$intCntP][13] = $objCntData->n_read_cnt;
$List_Data[$intCntP][14] = $objCntData->read_cnt;
$List_Data[$intCntP][15] = $objCntData->ans_cnt;
}
$o_smarty->assign('List_Data',$List_Data);
$o_smarty->assign('PHP_TITLE_NAME',$PHP_TITLE_NAME[20]);
$o_smarty->display('MNP020.tpl');
?>