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

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

if($mode=='id_get'){ // 아이디별 적용단가 확인시
    $pinfo = product_info_get($code,"N"); // 상품정보 가져오기
    $cinfo = customer_info_get_by_id($search_id); // 고객 정보

    if($cinfo['code']==''){
        echo "아이디 없음";
    } else {
        $price_rtn = "";
        $id_ccode = $cinfo['code'];
        prod_multi_price_get($pinfo['saleprice'], $code, $cinfo['sale_dcrate'],$pinfo['prod_cate_code']);
        if($price_rtn==''){
            echo "적용단가 없음";
        } else {
            echo $price_rtn;
        }
    }
    exit;
}

$cinfo['code'] = $code;
$cinfo['prod_cate_code'] = $prod_cate_code;
?>

            <tr>
                <th>특별단가 적용 업체</th>
                <td>
<?php
    if($configshop['special_price_use']=='0'){
        echo "쇼핑몰 특별단가 사용안함";
    } else if($options['특별단가사용']=='0' || $options['특별단가사용']==''){
        echo "천년경영 특별단가 사용안함";
    } else {
        $sql = "select a.price, b.login_id, b.comp_name from special_price a left join customers b on a.ccode = b.code where a.biztype = '1' and a.pcode = '{$cinfo['code']}' and b.login_id <> '' ";
        $res = mysql_query($sql,$connect_j3);
        while($info=mysql_fetch_array($res)){
            echo "{$info['login_id']}({$info['comp_name']}):{$info['price']}, ";
        }
    }
?>
                </td>
            </tr>
            <tr>
                <th>다중단가 적용 업체</th>
                <td>
<?php
    if((int)$options['shop_basic_multi_price_no']>0){
        echo "비회원/기본 다중단가 : {$options['shop_basic_multi_price_no']}<br>";
    }
    if($configshop['multi_price_use']=='0'){
        echo "쇼핑몰 다중단가 사용안함";
    } else {
        $sql = "select login_id, comp_name,sale_price_no  from customers a where a.sale_price_no in (select seq from multi_price a where a.biztype = '1' and a.pcode = '{$cinfo['code']}') and a.login_id <> ''";
        $res = mysql_query($sql,$connect_j3);
        while($info=mysql_fetch_array($res)){
            echo "{$info['login_id']}({$info['comp_name']}):{$info['sale_price_no']}, ";
        }
    }
?>
                </td>
            </tr>
            <tr>
                <th>특별DC 적용 업체</th>
                <td>
<?php
    if($configshop['spdc_price_use']=='0'){
        echo "쇼핑몰 특별DC 사용안함";
    } else if($options['특별DC사용']=='0' || $options['특별DC사용']==''){
        echo "천년경영 특별DC 사용안함";
    } else {
        $sql = "select a.dc, b.login_id, b.comp_name from special_dc a left join customers b on a.ccode = b.code where a.biztype = '1' and a.pcode = '{$cinfo['code']}' and b.login_id <> ''";
        $res = mysql_query($sql,$connect_j3);
        while($info=mysql_fetch_array($res)){
            echo "{$info['login_id']}({$info['comp_name']}):{$info['dc']}, ";
        }
    }
?>
                </td>
            </tr>
            <tr>
                <th>소분류DC 적용 업체</th>
                <td>
<?php
    if($configshop['catedc_price_use']=='0'){
        echo "쇼핑몰 소분류DC 사용안함";
    } else {
        $sql = "select a.dc, b.login_id, b.comp_name from product_category_dc a left join customers b on a.ccode = b.code where a.prod_cate_code = '{$cinfo['prod_cate_code']}' and b.login_id <> ''";
        $res = mysql_query($sql,$connect_j3);
        while($info=mysql_fetch_array($res)){
            echo "{$info['login_id']}({$info['comp_name']}):{$info['dc']}%, ";
        }
    }
?>
                </td>
            </tr>