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
|
<?php
$dir = ".";
include_once($dir."/_common.php");
$mode_ok = "Y";
$all_sql = "";
if($sel_del=='Y' && $mode_ok=='Y'){ // 삭제
$mode = "delete";
$code_list = "";
foreach($code_idx as $key=>$val){
$code_list .= "{$codes[$val]},";
}
if($mode_ok=='Y'){
$code_list = substr($code_list,0,strlen($code_list)-1);
update_del_log("shop_qa", "idx", $code_list,"del"); // 삭제 로그 처리
$sql = "delete from shop_qa where idx in ({$code_list}) ";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
}
} else if($code!='' && $mode_ok=='Y'){ // 수정
$mode = "update";
$sql = "select a.*, ifnull(rep_date,'0000-00-00 00:00:00') as rep_date_c from shop_qa a where 1=1 and idx = '{$code}'";
$res = mysql_query($sql,$connect_j3);
$cinfo = mysql_fetch_array($res);
if($qa_reply!=''){
$rep_date = " , rep_date = now() ";
}
$sql = "update shop_qa set
ecode = '{$ecode}', qa_name = '{$qa_name}',
qa_subject = '{$qa_subject}', qa_content = '{$qa_content}', qa_email = '{$qa_email}', qa_reply = '{$qa_reply}' {$rep_date}
where idx = '$code'
";
//_pr($sql); exit;
mysql_query($sql,$connect_j3); $all_sql .= $sql;
update_del_log("shop_qa", "idx", $code,""); // 업데이트 로그 처리
if($config['mail_1n1_mem']=='1' && $cinfo['rep_date_c']=='0000-00-00 00:00:00' && $qa_reply!=''){ // 답변이면서 기본환경설정 1:1문의 답변시 회원에게 통보
ob_start();
include_once ("{$j3_shop_path}/mail/1n1_mail.php");
$ma_content = ob_get_contents();
ob_end_clean();
$ma_subject = "고객님 1:1문의 게시판에 답변이 달렸습니다.";
$snd_email = $config['admin_email'];
$rcv_email = $qa_email;
$mail = new PHPMailer;
$rtn = email_send($mail, $ma_subject, $ma_content, $snd_email, $rcv_email);
}
} else if($mode_ok=='Y'){ // 신규
$mode = "new";
if($qa_reply!=''){
$rep_date = " , rep_date = now() ";
}
$sql = "insert into shop_qa set
mb_id = '{$id}', ccode = '{$ccode}', ecode = '{$id_code}', qa_name = '{$qa_name}',
qa_subject = '{$qa_subject}', qa_content = '{$qa_content}', qa_reply = '{$qa_reply}', qa_email = '{$qa_email}',
reg_date = now() {$rep_date}
";
//_pr($sql); exit;
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$code = mysql_insert_id($connect_j3);
}
//_pr($_POST); exit;
echo "<?php xml version='1.0' encoding='utf-8'?><output>";
echo "<mode>".$mode."</mode>";
echo "<mode_ok>".$mode_ok."</mode_ok>";
echo "<rtn_url>".$rtn_url."</rtn_url>";
echo "<msg>".$msg."</msg>";
echo "<after_add>".$after_add."</after_add>";
//echo "<sql>".$all_sql."</sql>";
echo "</output>";
?>
|