SEND0002.php
5.37 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
158
159
160
161
162
163
164
<?PHP
//*****************************************************************************
//*
//* プログラム名：め〜るNiポン！V2
//* プログラムID：SEND0002.php
//* 機能 ：送信先選択（配信）
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include('./include/smarty.conf');
include("./include/session_start.inc");
include("./include/SessionChk.inc");
//********** ヘッダー処理 **********//
include("./include/headr_data.inc");
//***************************
//* 初期処理
//***************************
include("./include/dbcon.inc");
//*** 送信元選択 ***//
$strSQL = "SELECT ";
$strSQL .= " * ";
$strSQL .= "FROM ";
$strSQL .= " syain_tbl ";
if ($_POST["Send_User"]!=""){
$User_List = split ("," , $_POST["Send_User"]);
for($intI = 0; $intI < count($User_List)-1; $intI++){
if ($intI==0){
$strSQL .= " WHERE syain_cd<>".$User_List[$intI];
}else{
$strSQL .= " AND syain_cd<>".$User_List[$intI];
}
}
}
$strSQL .= " ORDER BY ";
$strSQL .= " name_kn_sei ASC,";
$strSQL .= " name_kn_mei ASC,";
$strSQL .= " syain_cd ASC";
//echo $strSQL;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for($intI = 0; $intI < pg_numrows($objRec) ; $intI++) {
$objData = pg_fetch_object($objRec, $intI);
$Select_List[$intI][0] = $objData->syain_cd;
$Select_List[$intI][1] = $objData->name_kj_sei." ".$objData->name_kj_mei;
$Select_List[$intI][2] = $objData->mail_addr;
$Select_List[$intI][3] = $objData->pc_mail_addr;
}
$o_smarty->assign('Select_List' , $Select_List);
//*** 選択済みユーザー ***//
if ($_POST["Send_User"]!=""){
$strSQL = "SELECT ";
$strSQL .= " * ";
$strSQL .= "FROM ";
$strSQL .= " syain_tbl ";
$User_List = split ("," , $_POST["Send_User"]);
for($intI = 0; $intI < count($User_List)-1; $intI++){
if ($intI==0){
$strSQL .= " WHERE syain_cd=".$User_List[$intI];
}else{
$strSQL .= " OR syain_cd=".$User_List[$intI];
}
}
$strSQL .= " ORDER BY ";
$strSQL .= " name_kn_sei ASC,";
$strSQL .= " name_kn_mei ASC,";
$strSQL .= " syain_cd ASC";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for($intI = 0; $intI < pg_numrows($objRec) ; $intI++) {
$objData = pg_fetch_object($objRec, $intI);
$Send_List[$intI][0] = $objData->syain_cd;
$Send_List[$intI][1] = $objData->name_kj_sei." ".$objData->name_kj_mei;
$Send_List[$intI][2] = $objData->mail_addr;
$Send_List[$intI][3] = $objData->pc_mail_addr;
}
}else{
}
$o_smarty->assign('Send_List' , $Send_List);
$o_smarty->assign('Send_User' , $_POST["Send_User"]);
$o_smarty->assign('alarm_flg', $_REQUEST["alarm_flg"]);
$o_smarty->assign('alarm_id', $_REQUEST["alarm_id"]);
$o_smarty->assign('alarm_yyyy', $_REQUEST["alarm_yyyy"]);
$o_smarty->assign('alarm_mm', $_REQUEST["alarm_mm"]);
$o_smarty->assign('alarm_dd', $_REQUEST["alarm_dd"]);
$o_smarty->assign('alarm_hh', $_REQUEST["alarm_hh"]);
$o_smarty->assign('alarm_time_mm', $_REQUEST["alarm_time_mm"]);
$o_smarty->assign('SendType', $_REQUEST["SendType"]);
$o_smarty->assign('radSendPtn', $_REQUEST["radSendPtn"]);
$o_smarty->assign('group_id', $_REQUEST["group_id"]);
$o_smarty->assign('date_yyyy', $_REQUEST["date_yyyy"]);
$o_smarty->assign('date_mm', $_REQUEST["date_mm"]);
$o_smarty->assign('date_dd', $_REQUEST["date_dd"]);
$o_smarty->assign('time_hh', $_REQUEST["time_hh"]);
$o_smarty->assign('time_mm', $_REQUEST["time_mm"]);
$o_smarty->assign('kidok_yyyy', $_REQUEST["kidok_yyyy"]);
$o_smarty->assign('kidok_mm', $_REQUEST["kidok_mm"]);
$o_smarty->assign('kidok_dd', $_REQUEST["kidok_dd"]);
$o_smarty->assign('kidok_hh', $_REQUEST["kidok_hh"]);
$o_smarty->assign('kidok_time_mm', $_REQUEST["kidok_time_mm"]);
$o_smarty->assign('kidok', $_REQUEST["kidok"]);
$o_smarty->assign('midok', $_REQUEST["midok"]);
$o_smarty->assign('send_yyyy', $_REQUEST["send_yyyy"]);
$o_smarty->assign('send_mm', $_REQUEST["send_mm"]);
$o_smarty->assign('send_dd', $_REQUEST["send_dd"]);
$o_smarty->assign('send_hh', $_REQUEST["send_hh"]);
$o_smarty->assign('send_time_mm', $_REQUEST["send_time_mm"]);
$o_smarty->assign('NowSend', $_REQUEST["NowSend"]);
$o_smarty->assign('pattern_id', $_REQUEST["pattern_id"]);
$o_smarty->assign('limit_yyyy', $_REQUEST["limit_yyyy"]);
$o_smarty->assign('limit_mm', $_REQUEST["limit_mm"]);
$o_smarty->assign('limit_dd', $_REQUEST["limit_dd"]);
$o_smarty->assign('limit_time_hh', $_REQUEST["limit_time_hh"]);
$o_smarty->assign('limit_time_mm', $_REQUEST["limit_time_mm"]);
$o_smarty->assign('view_flg', $_REQUEST["view_flg"]);
if($_REQUEST["SendType"] != ""){
$o_smarty->assign('radSend', $_REQUEST["SendType"]);
}else{
$o_smarty->assign('radSend', $_REQUEST["radSend"]);
}
if($_REQUEST["kenmei"] != ""){
$o_smarty->assign('TITLE', $_REQUEST["kenmei"]);
}else{
$o_smarty->assign('TITLE', $_REQUEST["TITLE"]);
}
if($_REQUEST["tei"] != ""){
$o_smarty->assign('rad_tei', $_REQUEST["tei"]);
}else{
$o_smarty->assign('rad_tei', $_REQUEST["rad_tei"]);
}
if($_REQUEST["text"] != ""){
$o_smarty->assign('MAIL_TEXT', $_REQUEST["text"]);
}else{
$o_smarty->assign('MAIL_TEXT', $_REQUEST["MAIL_TEXT"]);
}
$o_smarty->display('SEND0002.tpl');
?>