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
$gubun = $_POST["gubun"];
$sendPhone = $_POST["sendPhone"];
$msgBody = $_POST["msgBody"];
$destPhone = $_POST["destPhone"];
if ($gubun == "1") {
$host = "114.108.136.196";
$uid = "sms_bbd";
$pwd = "mjsmsbbd86";
$dbName = "sms_sk";
$conn = mysql_connect($host,$uid,$pwd);
if (!$conn) {
echo ("not connect.<br>");
exit;
}
mysql_select_db("sms_sk");
mysql_query('set names utf8');
$cnt = 0;
$sms_no;
$num = 1;
$rs1 = mysql_query("SELECT SP_SMS_NO()");
while ($row = mysql_fetch_assoc($rs1)) {
$sms_no = $row['SP_SMS_NO()'];
}
$destPhoneArray = explode("|", $destPhone);
foreach ($destPhoneArray as $value) {
// 고유키 생성(yymmddhhmmss + 프로시저6자리 + 순번매긴것)
$num = $num == 100 ? 1 : $num;
$num = sprintf("%02d", $num);
$sMsgId = date('ymdHis', time());
$sMsgId = $sMsgId.$sms_no.$num;
$sql = "INSERT INTO telink_sms (CMP_MSG_ID,WRT_DTTM,SND_DTTM,SND_PHN_ID,RCV_PHN_ID,CALLBACK,SND_MSG ) VALUES ('".$sMsgId."',DATE_FORMAT(NOW(),'%Y%m%d%H%i%s'),DATE_FORMAT(NOW(),'%Y%m%d%H%i%s'),'gjmcs1313','".$value."','".$sendPhone."','".$msgBody."')";
$rs = mysql_query($sql);
if ($rs) {
$cnt = $cnt + 1;
}
$num++;
}
mysql_close($conn);
echo ($cnt." insert OK.<br>");
exit;
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title>
<script language="javascript">
function send() {
var sendPhone = document.getElementById('sendPhone').value;
var msgBody = document.getElementById('msgBody').value;
var destPhoneTemp = document.getElementById('destPhone').value;
var destPhone = '';
var destPhoneCnt = 0;
var destPhoneArray = destPhoneTemp.split(/[\n]/);
if (destPhoneArray) {
for (var i = 0; i < destPhoneArray.length; i++) {
if (i == 0) {
destPhone = destPhone + '' + destPhoneArray[i];
} else {
destPhone = destPhone + '|' + destPhoneArray[i];
}
destPhoneCnt++;
}
}
if (confirm('총 ' + destPhoneCnt + '건 발송하시겟습니까?')) {
document.getElementById('gubun').value = '1';
document.getElementById('destPhone').value = destPhone;
var frm = document.getElementById('frm');
frm.action = "telink_sms.php";
frm.submit();
}
}
</script>
</head>
<body>
<form id="frm" name="frm" method="post" action=''>
<input type="hidden" id="gubun" name="gubun" value=""/>
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="100%">
<tr>
<td>발신번호</td>
<td><input type="text" id="sendPhone" name="sendPhone" size="30" maxlength="20"/></td>
</tr>
<tr>
<td>내용</td>
<td><textarea id="msgBody" name="msgBody" style="width:590px;height:200px;"></textarea></td>
</tr>
<tr>
<td>수신번호</td>
<td><textarea id="destPhone" name="destPhone" style="width:590px;height:600px;"></textarea></td>
</tr>
<tr>
<td align="center"><input type="button" onclick="send();" value="보내기"></td>
<td></td>
</tr>
</table>
</form>
</body>
</html>
|