LIST1720.php
3.28 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
<?PHP
//*****************************************************************************
//*
//* プログラム名：め〜るNiポン！V2
//* プログラムID：LIST1720.php
//* 機能 ：自動配信設定
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/smarty.conf");
include("./include/jcode.phps");
include("./include/session_start.inc");
include("./include/SessionChk.inc");
//********** ヘッダー処理 **********//
include("./include/headr_data.inc");
//********** カレンダー処理 **********//
include("./include/dbcon.inc");
//メール開催日
$strSysDate = date("YmdHi");
if (strlen($strSysDate) == 10) {
$strSysDate = "20" . $strSysDate;
}
$calYMD1 = $strSysDate;
$strYear = substr($strSysDate, 0, 4);
$strMonth = substr($strSysDate, 4, 2);
$strSQL = "SELECT * FROM kidok_data WHERE kidok_data.mail_id = " . $_POST["mail_id"] .
" ORDER BY kidok_data.check_id";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$Kidoku_Flg=0;
$Midoku_Flg=0;
if(pg_numrows($objRecSet) > O){
$objData = pg_fetch_object($objRecSet,0);
if($objData->check_id == 0){
$Midoku_Flg = 1;
}else{
$Kidoku_Flg = 1;
}
$Kidok_YEAR = substr($objData->message_date, 0, 4);
$Kidok_MONTH = substr($objData->message_date, 4, 2);
$Kidok_DAY = substr($objData->message_date, 6, 2);
$Kidok_HOUR = substr($objData->message_time, 0, 2);
$Kidok_Minute = substr($objData->message_time, 2, 2);
}else{
$Kidok_YEAR = $strYear;
$Kidok_MONTH = 0;
$Kidok_DAY = 0;
$Kidok_HOUR = "";
$Kidok_Minute = "";
}
$opt_date_mm = make_option_md(12, $Kidok_MONTH);
$opt_date_dd = make_option_md(date(t,mktime(0,0,0,(int)$date_mm,1)), $Kidok_DAY);
$tempTimeArr = array("","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","00","01","02","03","04","05","06","07");
$opt_time_hh = make_option_time($tempTimeArr, $Kidok_HOUR);
$tempTimeArr = array("","00","30");
$opt_time_mm = make_option_time($tempTimeArr, $Kidok_Minute);
$o_smarty->assign('Kidok_YEAR' , $Kidok_YEAR);
$o_smarty->assign('opt_date_mm' , $opt_date_mm);
$o_smarty->assign('opt_date_dd' , $opt_date_dd);
$o_smarty->assign('opt_time_hh' , $opt_time_hh);
$o_smarty->assign('opt_time_mm' , $opt_time_mm);
$o_smarty->assign('Kidoku_Flg' , $Kidoku_Flg);
$o_smarty->assign('Midoku_Flg' , $Midoku_Flg);
$o_smarty->assign('calYMD1' , $calYMD1);
$o_smarty->assign('mail_id' , $_POST["mail_id"]);
$o_smarty->display('LIST1720.tpl');
function make_option_time($arr,$strCmp){
$retString = "<OPTION value=''>--</OPTION>";
for($i=1;$i<count($arr);$i++){
if($arr[$i] == $strCmp){
$retString .= "<OPTION value='".$arr[$i]."' selected>".$arr[$i]."</OPTION>";
}else{
$retString .= "<OPTION value='".$arr[$i]."'>".$arr[$i]."</OPTION>";
}
}
return $retString;
}
function make_option_md($pMax, $strCmp){
$retString = "<OPTION value=''>--</OPTION>";
for($i = 1; $i <= $pMax ; $i++){
if($i==$strCmp){
$retString .= "<OPTION value='".sprintf("%02d",$i)."' selected>".sprintf("%02d",$i)."</OPTION>";
}else{
$retString .= "<OPTION value='".sprintf("%02d",$i)."'>".sprintf("%02d",$i)."</OPTION>";
}
}
return $retString;
}
?>