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

<?php
$sub_menu = "200300";
$dir = ".";
include_once($dir."/_common.php");
include("./auth_check.php"); // 관리자 권한 체크

$mode_ok = "Y";

$all_sql = "";

$point = preg_replace("/[^-0-9]/", "", $point);

$ocode = customer_ocode($ccode);

if($sel_del=='Y' && $mode_ok=='Y'){ // 삭제
    $mode = "delete"; 
    
    if($mode_ok=='Y'){
        foreach($code_idx as $key=>$val){
            $idx = $codes[$val];
            $sql = "select * from point_edit where nidx = '{$idx}' ";
            $p_info = sql_fetch($sql,$connect_j3); $all_sql .= $sql;
            $sql = "delete from point_edit where nidx = '{$idx}' ";
            $res = mysql_query($sql,$connect_j3); $all_sql .= $sql;

            $sql = "update customers set cur_pt = cur_pt - '{$p_info['point']}' where code = '{$p_info['ccode']}'";
            $res = mysql_query($sql,$connect_j3); $all_sql .= $sql;

            cust_cur_point_cal($ccode); // 쇼핑몰 포인트 재계산
        }
    }
} else if($code!='' && $mode_ok=='Y') { // 수정
    $mode = "update";

    $sql = "update point_edit set
                    remarks = '{$remarks}', point = '{$point}', dealdate = '{$dealdate}',
                    data_updated = '".G5_TIME_YMDHIS."'
                where nidx = '{$code}'
    ";
    //_pr($sql);
    $res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
    update_del_log("point_edit", "nidx", $code,""); // 업데이트 로그 처리

    cust_cur_point_cal($ccode); // 쇼핑몰 포인트 재계산

} else if($mode_ok=='Y'){ // 신규
    $mode = "new";

    $sql = "insert into point_edit set
                    ccode = '{$ccode}', ocode = '{$ocode}',  remarks = '{$remarks}', point = '{$point}', 
                    dealdate = '{$dealdate}',
                    data_created = '".G5_TIME_YMDHIS."'
    ";
    //_pr($sql);
    $res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
    $last_idx = mysql_insert_id($connect_j3);

    update_del_log("point_edit", "nidx", $last_idx,"insert"); // 업데이트 로그 처리

    $sql = "update customers set cur_pt = cur_pt + '{$point}' where code = '{$ccode}'";
    $res = mysql_query($sql,$connect_j3); $all_sql .= $sql;

    cust_cur_point_cal($ccode); // 쇼핑몰 포인트 재계산
}

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

?>