LIST1730.php
2.93 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
<?PHP
//*****************************************************************************
//*
//* プログラム名:アラーム設定、回答文言新規登録
//* プログラムID:alarm_ansreg3.php
//* 機能 :アラーム設定、回答文言を登録する
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/smarty.conf");
include("./include/session_start.inc");
include("./include/SessionChk2.inc");
include("./include/dbcon.inc");
include("./include/jcode.phps");
//********** ヘッダー処理 **********//
include("./include/headr_data.inc");
//********** メイン処理 **********//
include("./include/dbcon.inc");
$o_smarty->assign('mail_id' , $_POST["mail_id"]);
//配信情報を取得
$strSQL = "SELECT * FROM mail_data WHERE mail_id = ".(int)$_POST["mail_id"];
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objData = pg_fetch_object($objRec, 0);
$Reserva_Year = substr($objData->reserva_date, 0, 4);
$ReservaMonth = substr($objData->reserva_date, 4, 2);
$ReservaDay = substr($objData->reserva_date, 6, 2);
$ReservaHour = substr($objData->reserva_time, 0, 2);
$ReservaMinute = substr($objData->reserva_time, 2, 2);
$Month_Data = '<OPTION value="">--</OPTION>';
for($intI = 1; $intI < 13 ; $intI++){
$Month_Data .= '<OPTION value="'.sprintf('%02d', $intI).'" ';
if ($ReservaMonth==sprintf('%02d', $intI)){
$Month_Data .= 'selected';
}
$Month_Data .= '>'.sprintf('%02d', $intI).'</OPTION>';
}
$Day_Data = '<OPTION value="">--</OPTION>';
for($intI = 1; $intI < 32 ; $intI++){
$Day_Data .= '<OPTION value="'.sprintf('%02d', $intI).'" ';
if ($ReservaDay==sprintf('%02d', $intI)){
$Day_Data .= 'selected';
}
$Day_Data .= '>'.sprintf('%02d', $intI).'</OPTION>';
}
$Hour_List=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");
for ($intI=0; $intI < count($Hour_List); $intI++){
if ($intI==0){
$Hour_Data.='<option value="" ';
}else{
$Hour_Data.='<option value="'.$Hour_List[$intI].'" ';
}
if ($ReservaHour==$Hour_List[$intI]){
$Hour_Data.="selected";
}
$Hour_Data.='>'.$Hour_List[$intI].'</option>';
}
$Minute_List=array("--","00","30");
for ($intI=0; $intI < count($Minute_List); $intI++){
if ($intI==0){
$Minute_Data.='<option value="" ';
}else{
$Minute_Data.='<option value="'.$Minute_List[$intI].'" ';
}
if ($ReservaMinute==$Minute_List[$intI]){
$Minute_Data.="selected";
}
$Minute_Data.='>'.$Minute_List[$intI].'</option>';
}
$o_smarty->assign('Reserva_Year' , $Reserva_Year);
$o_smarty->assign('Month_Data' , $Month_Data);
$o_smarty->assign('Day_Data' , $Day_Data);
$o_smarty->assign('Hour_Data' , $Hour_Data);
$o_smarty->assign('Minute_Data' , $Minute_Data);
$o_smarty->display('LIST1730.tpl');
?>