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

<?php
include("./_common.php");

$stime = time();

$mode = "update11";
$mode_ok = "N";

$site = "11";

//_pr($_POST);
$p_price = preg_replace("/[^0-9]/", "", $p_price);
$_POST['selPrc'] = preg_replace("/[^0-9]/", "", $_POST['selPrc']);
$_POST['prdSelQty'] = preg_replace("/[^0-9]/", "", $_POST['prdSelQty']);

if(1==1){

    if($sel_del=='prod_qa_get'){ // Q&A 가져오기
        $sdate = date("Ymd",time()-(60*60*24*7));
        $edate = date("Ymd",time());
        $qa_state = "00"; // 00:전체, 01:답변완료, 02:미답변

        $res = otms_11_prod_qa_get($sdate,$edate,$qa_state);
        if($res['result_code']=='500'){ // 실패시
            $msg = $res['result_message'];
        } else {
            $prd_cnt = 0;
            foreach($res['productQna'] as $key=>$info){
                $info['brdInfoCont'] = addslashes($info['brdInfoCont']);
                $info['createDt'] = substr($info['createDt'],0,19);
                if($info['brdInfoCont']!=''){
                    $info['answerDt'] = str_replace("/","-",$info['answerDt']);
                    $ans_where = " `ans_content` = '{$info['answerCont']}', `ans_date` = '{$info['answerDt']}', ";
                }

                $sql = "select count(*) as cnt from `zom_prod_qa` where om_site = '{$site}' and qa_code = '{$info['brdInfoNo']}' ";
                //echo $sql;
                $row = sql_fetch($sql,$connect_om);
                if($row['cnt']>0){
                    $sql = "update `zom_prod_qa` set
                                `p_code` = '{$info['brdInfoClfNo']}', `p_name` = '{$info['prdNm']}', `qa_subject` = '{$info['brdInfoSbjct']}', 
                                `qa_content` = '{$info['brdInfoCont']}', `mem_id` = '{$info['memID']}', `disp_yn` = '{$info['dispYn']}', `buy_yn` = '{$info['buyYn']}', `ans_yn` = '{$info['answerYn']}', 
                                {$ans_where} `qa_grp_no` = '{$info['qnaDtlsCd']}', `qa_grp_name` = '{$info['qnaDtlsCdNm']}', `reg_date` = '{$info['createDt']}'
                            where om_site = '{$site}' and qa_code = '{$info['brdInfoNo']}'
                    ";                    
                } else {
                    $sql = "INSERT INTO `zom_prod_qa` set
                                `om_site` = '{$site}', `p_code` = '{$info['brdInfoClfNo']}', `p_name` = '{$info['prdNm']}', `qa_code` = '{$info['brdInfoNo']}', `qa_subject` = '{$info['brdInfoSbjct']}', 
                                `qa_content` = '{$info['brdInfoCont']}', `mem_id` = '{$info['memID']}', `disp_yn` = '{$info['dispYn']}', `buy_yn` = '{$info['buyYn']}', `ans_yn` = '{$info['answerYn']}', 
                                {$ans_where} `qa_grp_no` = '{$info['qnaDtlsCd']}', `qa_grp_name` = '{$info['qnaDtlsCdNm']}', `reg_date` = '{$info['createDt']}'
                    ";
                }
                mysql_query($sql,$connect_om);
                $prd_cnt++;
            }
            if($prd_cnt>0){
                $mode_ok = "Y";
            }
        }
    }

    if($sel_del=='prod_qa_ans'){ // 답변 처리
        $res = otms_11_prod_qa_ans($idx,$_POST);
        if($res=='Y'){
            $mode_ok = "Y";
        } else {
            $msg = $res;
        }
    }

}

$etime = time();
$use_time = $etime-$stime;

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 "<prd_cnt>".$prd_cnt."</prd_cnt>";
echo "<prd_no>".$prd_no."</prd_no>";
echo "<use_time>".$use_time."</use_time>";
//echo "<sql>".$all_sql."</sql>";
echo "</output>";

?>