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

<? session_start(); ?>
<?
     $admin = str_replace("admin+","",$adminid);
    include("../onlinecs/commonSTADMIN.php");


$cust_base_sale = str_replace(",","",$cust_base_sale);
$cust_base_buy = str_replace(",","",$cust_base_buy);
$limitbaln = str_replace(",","",$limitbaln);

$sql = "SELECT MAX(code) AS code from customer";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if($row[code] == ""){
    $code = 0;
}
$code = $row[code] + 1;
$newmaxcode = str_pad($code,6,"0",STR_PAD_LEFT); //¾ÕÀÚ¸® 0ä¿ì±â 6ÀÚ¸®·Î ±¸¼º


?>


<?
    $usql = "INSERT INTO customer 
    ( code, part, code2, compname, status, item, compalias, loginid, cust_base_buy, ceoname, loginpwd, cust_base_sale, telno1, fax, hpno, taxmode, compsn, email, limitbaln, salestop, zipcode, addr1, addr2, bigo)
    value 
    ( '$newmaxcode','$part','$code2','$compname','$status','$item','$compalias','$loginid','$cust_base_buy','$ceoname','$loginpwd','$cust_base_sale','$telno1','$fax','$hpno','$taxmode','$compsn','$email', '$limitbaln','$salestopvalue','$zipcode','$addr1','$addr2','$bigo')
    ";
//DB¾÷µ¥ÀÌÆ®ÈÄ »ç¿ë
/*    $usql = "INSERT INTO customer 
    ( code, part, code2, compname, status, item, compalias, loginid, cust_base_buy, ceoname, loginpwd, cust_base_sale, telno1, fax, hpno, taxmode, compsn, email, limitbaln, salestop, zipcode, addr1, addr2, bigo, stopsalebigo)
    value 
    ( '$newmaxcode','$part','$code2','$compname','$status','$item','$compalias','$loginid','$cust_base_buy','$ceoname','$loginpwd','$cust_base_sale','$telno1','$fax','$hpno','$taxmode','$compsn','$email', '$limitbaln','$salestopvalue','$zipcode','$addr1','$addr2','$bigo', '$stopsalebigo')
    ";
*/
//»óÈ£¸í Áߺ¹
        $cnsql = "SELECT * FROM customer WHERE (compname = '$compname' AND compname != '$oldcompname')";
        $cnresult = mysql_query($cnsql);
        if(mysql_num_rows($cnresult) == ""){

    

//¾àĪ Áߺ¹
            $casql = "SELECT * FROM customer WHERE (compalias = '$compalias' AND compalias !='$oldcompalias') ";
            $caresult = mysql_query($casql);
            if(mysql_num_rows($caresult) ==""){

//°ü¸®ÄÚµå Áߺ¹            

                $codesql = "SELECT * FROM customer WHERE (code2 = '$code2' AND code2 != '$oldcode2')";
                $coderesult = mysql_query($codesql);
                if(mysql_num_rows($coderesult) ==""){

//ÁÖ¹®ID Áߺ¹
                    $idsql = "SELECT * FROM customer WHERE (loginid = '$loginid' AND loginid != '$oldloginid')";
                    $idresult = mysql_query($idsql);
                    if(mysql_num_rows($idresult) == ""){

        ?>



<?    echo $usql;
    mysql_query($usql);
?>
<SCRIPT LANGUAGE="JavaScript">
    parent.alert("ÀúÀåµÇ¾ú½À´Ï´Ù");
//    parent.location="admincustomer.php?part=<?=$part?>&detail=<?=$newmaxcode?>";
</SCRIPT>


        <? } else { ?>
                <SCRIPT LANGUAGE="JavaScript">
                    parent.alert("À̹̠Àִ ÁÖ¹®IDÀÔ´Ï´Ù.");    //¾ÆÀ̵ð Áߺ¹
                    parent.customerdetail.loginid.focus();
                </SCRIPT>


        <?    }
            } else { ?>

            <SCRIPT LANGUAGE="JavaScript">
                parent.alert("À̹̠Àִ °ü¸®ÄÚµåÀÔ´Ï´Ù.");    //°ü¸®ÄÚµå Áߺ¹
                parent.customerdetail.loginid.focus();
            </SCRIPT>



        <?    }
        } else { ?>

        <SCRIPT LANGUAGE="JavaScript">
            parent.alert("À̹̠Àִ ¾àĪÀÔ´Ï´Ù.");    //¾àĪ Áߺ¹
            parent.customerdetail.compalias.focus();
        </SCRIPT>
        
<? }
    } else { ?>
<SCRIPT LANGUAGE="JavaScript">
        parent.alert("À̹̠Àִ »óÈ£¸í ÀÔ´Ï´Ù.");    
        parent.customerdetail.compname.focus();
</SCRIPT>
<? } ?>