TEL002.php
4.58 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
<?php
//*****************************************************************************
//*
//* プログラム名：電話連絡メモ
//* プログラムID：TEL002.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");
$strDBinc="include/dbcon.inc";
include($strDBinc);
$strSQLSyain="";
$objRecSyain="null";
//**** ＤＢ接続 ****//
$strDBinc="include/dbcon.inc";
include($strDBinc);
//社員情報取得
$strSQLSyain="SELECT syain_cd,name_kj_sei,name_kj_mei FROM syain_tbl " .
"WHERE del_flg=true " .
"Order by disp_rank" ;
$objRecSyain = pg_exec($strSQLSyain);
if($objRecSyain==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
if ($inp_seq!=""){
$strSQL = "SELECT * FROM telmemo_tbl Where seq=$inp_seq" ;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objData=pg_fetch_object($objRec, 0);
$syain_cd=$objData->from_code;
$Request="Re: ".htmlspecialchars($objData->fromperson);
$message="\n\n＞ ".str_replace("\n","\n＞ ",$objData->message);
$msg_mode ='<OPTION VALUE = "1">電話</option>';
$msg_mode.='<OPTION VALUE = "2">来客</option>';
$msg_mode.='<OPTION VALUE = "3">その他</option>';
$msg_mode.='<OPTION VALUE = "4" selected>返信</option>';
$MsgType ='<OPTION VALUE = "1">電話があったことをお伝えください</option>';
$MsgType.='<OPTION VALUE = "2">またかけ直します</option>';
$MsgType.='<OPTION VALUE = "3">折り返しの連絡をお願いします</option>';
$MsgType.='<OPTION VALUE = "4">ご伝言をお願いします</option>';
$MsgType.='<OPTION VALUE = "5">来社されました</option>';
$MsgType.='<OPTION VALUE = "6">その他</option>';
$MsgType.='<OPTION VALUE = "7" selected>メッセージ返信</option>';
}else{
$Request="";
$message="";
$msg_mode='<OPTION VALUE = "1" selected>電話</option>';
$msg_mode.='<OPTION VALUE = "2">来客</option>';
$msg_mode.='<OPTION VALUE = "3">その他</option>';
$msg_mode.='<OPTION VALUE = "4">返信</option>';
$MsgType ='<OPTION VALUE = "1" selected>電話があったことをお伝えください</option>';
$MsgType.='<OPTION VALUE = "2">またかけ直します</option>';
$MsgType.='<OPTION VALUE = "3">折り返しの連絡をお願いします</option>';
$MsgType.='<OPTION VALUE = "4">ご伝言をお願いします</option>';
$MsgType.='<OPTION VALUE = "5">来社されました</option>';
$MsgType.='<OPTION VALUE = "6">その他</option>';
$MsgType.='<OPTION VALUE = "7">メッセージ返信</option>';
}
$o_smarty->assign('Request',$Request);
$o_smarty->assign('message',$message);
$o_smarty->assign('msg_mode',$msg_mode);
$o_smarty->assign('MsgType',$MsgType);
//<!--電話連絡メモ新規作成ー-->
$Tel_y .= '<OPTION value="'.(Date("Y")-1).'">'.(Date("Y")-1).'年</OPTION>';
$Tel_y .= '<OPTION value="'.(Date("Y")).'" selected>'.(Date("Y")).'年</OPTION>';
$Tel_y .= '<OPTION value="'.((Date("Y"))+1).'">'.(Date("Y")+1).'年</OPTION>';
$o_smarty->assign('Tel_y',$Tel_y);
$a = 01;
while ($a < 13) {
if ($a==date("m")) {
$Tel_m .= "<OPTION VALUE=\"".$a."\" selected='selected'>".$a."月"."</option>";
} else {
$Tel_m .= "<OPTION VALUE=\"".$a."\">".$a."月"."</option>";
}
$a++;
}
$o_smarty->assign('Tel_m',$Tel_m);
$b = 01;
while ($b < 32) {
if ($b==date("d")) {
$Tel_d .= "<OPTION VALUE=\"".$b."\" selected='selected'>".$b."日"."</option>";
} else {
$Tel_d .= "<OPTION VALUE=\"".$b."\">".$b."日"."</option>";
}
$b++;
}
$o_smarty->assign('Tel_d',$Tel_d);
$c = 00;
while ($c < 24) {
if ($c==date("H")) {
$Tel_h .= "<OPTION VALUE=\"".$c."\" selected='selected'>".$c."時"."</option>";
} else {
$Tel_h .= "<OPTION VALUE=\"".$c."\">".$c."時"."</option>";
}
$c++;
}
$o_smarty->assign('Tel_h',$Tel_h);
$d = 00;
while ($d < 60) {
if ($d==date("i")) {
$Tel_min .= "<OPTION VALUE=\"".$d."\" selected='selected'>".$d."分"."</option>";
} else {
$Tel_min .= "<OPTION VALUE=\"".$d."\">".$d."分"."</option>";
}
$d++;
}
$o_smarty->assign('Tel_min',$Tel_min);
for ($intCnt = 0; $intCnt < pg_numrows($objRecSyain); $intCnt++) {
$objSayain = pg_fetch_object($objRecSyain, $intCnt);
if ($syain_cd==$objSayain->syain_cd){
$strChk=" selected";
}
else{
$strChk="";
}
$to_code .= "<OPTION value=".$objSayain->syain_cd.$strChk.">".
$objSayain->name_kj_sei.$objSayain->name_kj_mei."</OPTION>";
}
$o_smarty->assign('to_code',$to_code);
//カレンダー用 デフォは今日
$cal_st_y = date("Y");
$cal_st_m = date("m");
$cal_st_d = date("d");
$o_smarty->assign('calYMD',$cal_st_y."/".$cal_st_m."/".$cal_st_d);
$o_smarty->display('TEL002.tpl');
?>