webadmin.php

/home/mjc1/public_html/onlinecs/adminloadSpecialResult.php

<?
session_start();
?>
<?php include_once("_common.php");?>
<head>
<script type="text/javascript" src="../onlinecs/js/spcalendar.js"></script>
<link href="./css/style.css" rel="stylesheet" type="text/css">
<?
    if( $adminid == "" ){ 
?>
<SCRIPT LANGUAGE='JavaScript'> 
    alert("°ü¸®ÀÚ ·Î±×ÀÎ ÈÄ¿¡ ÀÌ¿ë°¡´ÉÇÕ´Ï´Ù.");
    location.href = "../onlinecs/adminintro.php";
</script>
<?     
     }

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


    var boxnum = document.getElementsByName("box");    //¹Ú½º¼ö·®
    var nat = document.getElementsByName("nat");    //³¹°³¼ö·®
    var ordqnt = document.getElementsByName("qnt");    //¼ö·®
    var packqnt = document.getElementsByName("packqnt");//³»Ç°¼ö

function boxcount(n)        {    //¹Ú½º¼ö·®
    var m = n-1;
    var orinat = nat[m].value;
    if(packqnt[m].value == '0'){
        alert('³»Ç°¼ö·®ÀÌ °ü¸®µÇÁö ¾Ê´Â Ç°¸ñÀÔ´Ï´Ù. \n»óÇ°°ü¸®Ã¢¿¡¼ ³»Ç°¼ö·®À» ¸ÕÀú ÀÔ·ÂÇÏ¼¼¿ä.');
        boxnum[m].value = 0;
    } else {

        if(orinat ==''){
            var orinat = 0;
        }            
        ordqnt[m].value = Number(boxnum[m].value) * Number(packqnt[m].value) + parseInt(orinat);
    }

}
function natge(n)        {    //³¹°³
    var m = n-1;
    var oriboxnum = boxnum[m].value;
    var oriordqntnum = ordqnt[m].value;


    if (packqnt[m].value == '0'){
        ordqnt[m].value = nat[m].value;
    } else {
    
            if(Number(nat[m].value) < Number(packqnt[m].value)){
                var sumordqnt = Number(ordqnt[m].value) + Number(nat[m].value);
                ordqnt[m].value = sumordqnt;
            } else {
            
                var div = Number(nat[m].value) / Number(packqnt[m].value);
                var div2 = Number(nat[m].value) % Number(packqnt[m].value);

                    if(oriboxnum == ''){
                        oriboxnum = 0;
                    } 

                    if(oriordqntnum == ''){
                        oriordqntnum = 0;
                    } 

                boxnum[m].value = parseInt(oriboxnum) + parseInt(div);
//                ordqnt[m].value = oriordqntnum + parseInt(nat[m].value);
                nat[m].value = div2;

                ordqnt[m].value = parseInt(boxnum[m].value) * parseInt(packqnt[m].value) + parseInt(nat[m].value);
                
            }
        }
//    Number(nat[m].value) / Number(packqnt[m].value)
        //boxnum[i].value
    }

function surang(n)        {    //¼ö·®
    var m = n-1;
    var div = Number(ordqnt[m].value) / Number(packqnt[m].value);
    var div2 = Number(ordqnt[m].value) % Number(packqnt[m].value);
    if(packqnt[m].value == '0'){
    nat[m].value = parseInt(ordqnt[m].value);
    boxnum[m].value = '0';
    } else {
    boxnum[m].value = parseInt(div);
    nat[m].value = parseInt(div2);
    }
}        


function convert(){    //10Áø¼ö->16Áø¼ö

        var num = document.getElementsByName("color"); 

        
        for(var i=0;i<num.length;i++)
        num[i].value = Number(num[i].value).toString(16);

        tdchg();
    }
function tdchg(){
    var color1 = 0;
    var color1 = document.getElementsByName("color"); 
    var color2 = document.getElementsByName("tdcolor");
    for(var i=0;i<color2.length;i++){

        if (color1[i].value.length < 2) {
             var chgcolor = '00000'+color1[i].value.substr(0,1);
             color2[i].style.backgroundColor = chgcolor;
        }
        else if (color1[i].value.length < 3) {
             var chgcolor = color1[i].value.substr(0,2)+'0000';
             color2[i].style.backgroundColor = chgcolor;
        }
        else if (color1[i].value.length < 4) {
             var chgcolor = '000'+color1[i].value.substr(0,3);
             color2[i].style.backgroundColor = chgcolor;
        }
        else if( color1[i].value.length < 6)
        {
            var chgcolor = color1[i].value.substr(2,2)+color1[i].value.substr(0,2)+'00';
                 color2[i].style.backgroundColor = chgcolor;

        } else {
             var chgcolor = color1[i].value.substr(4,2)+color1[i].value.substr(2,2)+color1[i].value.substr(0,2);
             color2[i].style.backgroundColor  = chgcolor;
        }
    


    }
    
}
        function productdelete(p,n){


            if(confirm("[ "+n+" ]»óÇ°À» »èÁ¦ÇÏ½Ã°Ú½À´Ï±î?") ){
                var part = document.getElementsByName("part")[0].value;
                alert(part);
                var link = "adminproductdeleteProcess.php?code="+p+"&part="+part+"";
                window.open(link,'profrm');

                } else {
                return;
                }

        }

        function checkall()
        {
        var aaa = document.getElementsByName("selectform"); 
            if (aaa[0].checked == true){
                for(var i=0; i < aaa.length; i++) aaa[i].checked = false;
            } else {
                for(var i=0; i < aaa.length; i++) aaa[i].checked = true;
            }
        
        }

        function detailproduct(c,d){
         var win = window.open( "adminproductdetail.php?code="+c+"&class="+d+"&mode=edit", 'newWin', 'status=no,toolbar=no,scrollbars=no,resizable=no,width=860,height=620' ); 
        }

            function numbersonly(e, decimal) {    //¼ýÀÚ¸¸ÀÔ·Â
                var key; 
                var keychar; 

                if (window.event) { 
                   // IE¿¡¼ ÀÌº¥Æ®¸¦ È®ÀÎÇÏ±â À§ÇÑ ¼³Á¤ 
                    key = window.event.keyCode; 
                } else if (e) { 
                  // FireFox¿¡¼ ÀÌº¥Æ®¸¦ È®ÀÎÇÏ±â À§ÇÑ ¼³Á¤ 
                    key = e.which; 
                } else { 
                    return true; 
                } 

                keychar = String.fromCharCode(key); 
                if ((key == null) || (key == 0) || (key == 8) || (key == 9) || (key == 13) 
                        || (key == 27)) { 
                    return true; 
                } else if ((("0123456789").indexOf(keychar) > -1)) { 
                    return true; 
                } else if (decimal && (keychar == ".")) { 
                    return true; 
                } else 
                    return false; 
            }

        function formatCurrency(amount)    //¼¼ÀÚ¸® ÄÄ¸¶
            {
             amount = new String(amount);
             var amountLength = amount.length;
             var modulus = amountLength % 3;
             var currencyString = amount.substr(0,modulus);
             for(i=modulus; i<amountLength; i=i+3) {
              if(currencyString != "")
               currencyString += ",";
              currencyString += amount.substr(i, 3);
             }
             return currencyString;
            }

        function scomma(sn)
            {
                var basebuynum = document.getElementsByName("sprice")[sn].value;

                newbasebuynum = formatCurrency(basebuynum);
                document.getElementsByName("sprice")[sn].value = newbasebuynum;

                //alert(newbasebuynum);
    
            }

        function calnum(ad)
            {
            var rowid = ad.id;
//            alert(rowid);
            var rownum = rowid.replace(/[^0-9]?/g,''); 
//            alert(rownum);

                if(!confirm("Æ¯º°´Ü°¡ Á¾·áÀÏ¸¦ Ãß°¡(º¯°æ) ÇÏ½Ã°Ú½À´Ï±î? \nÈ¯°æ¼³Á¤¸Þ´ºÀÇ Æ¯º°´Ü°¡ ±â°£Àû¿ëÀÌ Çã¿ëµÇ¾î¾ß Àû¿ëµË´Ï´Ù.")){
                    document.getElementsByName("edate")[rownum].value = "";
                    return;
                } else {
                            spricesave(rownum);
                    }
            }
        function enter(e,kc){

            var code = kc.keyCode?kc.keyCode:kc.charCode;
             if(code == 13){
//ÀúÀå
                    if(!confirm("Æ¯º°´Ü°¡¸¦ Ãß°¡(º¯°æ) ÇÏ½Ã°Ú½À´Ï±î?\nÈ¯°æ¼³Á¤¸Þ´ºÀÇ Æ¯º°´Ü°¡ »ç¿ëÀÌ Çã¿ëµÇ¾î¾ß Àû¿ëµË´Ï´Ù.")){
                        return;
                    } else {
                            spricesave(e);
                    }
                }    
            }

        function spricesave(rn){

            var edate = document.getElementsByName("edate")[rn].value;
            var code = document.getElementsByName("code")[rn].value;
            var sprice = document.getElementsByName("sprice")[rn].value;
            var cuscode = document.getElementsByName("cuscode")[rn].value;
            var part = document.getElementsByName("part")[0].value;
            window.open("spricesaveProcess.php?edate="+edate+"&code="+code+"&amount="+sprice+"&cuscode="+cuscode+"&part="+part+"","profrm","width=0,height=0,scrollbars=yes");
        }

        function deldate(no){    //Æ¯º°´Ü°¡ Á¾·áÀÏ Á¦°Å

                if(!confirm("Æ¯º°´Ü°¡ ±â°£¼³Á¤À» Ãë¼Ò ÇÏ½Ã°Ú½À´Ï±î?")){
                    return;
                } else {
                    var cuscode = document.getElementsByName("cuscode")[no].value;
                    var code = document.getElementsByName("code")[no].value;
                    var sprice = document.getElementsByName("sprice")[no].value;
                    window.open("spricesaveProcess.php?edate=&code="+code+"&amount="+sprice+"&cuscode="+cuscode+"","profrm","width=0,height=0,scrollbars=yes");
                    document.getElementsByName("edate")[no].value = "";
                }
        }

        function delmoney(no){    //Æ¯º°´Ü°¡ ±Ý¾× Á¦°Å

                if(!confirm("Æ¯º°´Ü°¡ Àû¿ëÀ» Ãë¼ÒÇÏ½Ã°Ú½À´Ï±î?\nÃë¼ÒÈÄ¿¡´Â ÀÏ¹Ý ¸ÅÃâ°¡·Î °¡°ÝÀÌ ¼³Á¤µË´Ï´Ù.")){
                    return;
                } else {
                    var cuscode = document.getElementsByName("cuscode")[no].value;
                    var code = document.getElementsByName("code")[no].value;
                    var sprice = document.getElementsByName("sprice")[no].value;
                    window.open("spricesaveProcess.php?edate=&code="+code+"&amount=del&cuscode="+cuscode+"","profrm","width=0,height=0,scrollbars=yes");
                    document.getElementsByName("edate")[no].value = "";
                    document.getElementsByName("sprice")[no].value = "0";
                }
        }

</script>
</head>
<body topmargin="0" marginwidth="0" marginheight="0" leftmargin="0" >
<iframe name="profrm" width="0" height="0" style="border:0px"></iframe>
<?

        $num = 0;
        $code2 = substr($detail,-4);

    if ( isset($mode ) && $mode == "search"){ 


        if( $count > 0){
            $limit = "limit $count";
        }  else {
            $limit = "limit 1000";    //°Ç¼ö ¹Ì¼±ÅÃ½Ã 1000°Ç ¸®¹Ô Á¦ÇÑ
        }

        if( $spname !== ""){
            $qryname = " AND name like '%$spname%'";
        }

        if( $ssize !== ""){
            $qrynorm = " AND norm like '%$ssize%'";
        }

        if( $sbigo !== ""){
            $qrybigo = " AND m.bigo like '%$sbigo%'";
        }

        if( $stotal !==""){
            $qrytotal=" and ( m.name like '%$stotal%' or m.code like '%$stotal%' or m.norm like '%$stotal%' or m.bigo like '%$stotal%' )";
        }

        if( $allcate =="on"){
        } else {
            if( $cate !==""){
                $catenumqry = "SELECT code FROM pclass where fullpath = '$cate'";
                $resultcate = mysql_query($catenumqry);
                $caterow = mysql_fetch_array($resultcate);
                $catenum = $caterow[code];
                $qrycate = "AND classcode = '$catenum'";
            }
        }

        if(!$code2 == "") $classcode = "AND classcode = '$code2'";    //¿É¼ÇÆ÷ÇÔ Á¶È¸
    

                $mqry =    "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.classcode,
                                d.ocode, d.saleprice, d.buyprice, d.baseprice,
                                s.amount, s.pcode, s.ccode, s.edate

                        FROM (product_m AS m 
                        INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1)) 
                        LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = $part)
                        
                        WHERE m.hidden = 0 $classcode $qrycate $qrytotal $qryname $qrynorm $qrybigo order by code $limit"; //±âº» °Ë»ö ÀÌ¸§,±Ô°Ý,ÄÚµå,¸Þ¸ð

                        
            

    } else {    

        if(!$code2 == "")    $classcode = "AND classcode = '$code2'"; //ÀÏ¹ÝÁ¶È¸

            
                $mqry =    "SELECT m.code, m.code2, m.bcode, m.name, m.norm, m.taxmode, m.packqnt, m.unit, m.bmanage, m.color, m.bigo, m.classcode,
                                d.ocode, d.saleprice, d.buyprice, d.baseprice,
                                s.amount, s.pcode, s.ccode, s.edate
                        FROM (product_m AS m 
                        INNER JOIN product_d AS d ON (m.code = d.pcode AND d.ocode = 1))
                        LEFT JOIN special_price AS s ON (m.code = s.pcode AND s.ccode = '$cuscode' AND s.part = '$part')

                        WHERE m.hidden = 0 $classcode";
    }

        $resultm = mysql_query($mqry);
//        echo $mqry;

?>
        <table width="780" height="25" border="0" cellpadding="0" cellspacing="0" >
        <form name="result">
<? 
    $i = 1;
    if($numrow = mysql_num_rows($resultm)){

    while($row = mysql_fetch_array($resultm)){

                
        if ($row[taxmode] == "1"){
            $taxmode = "°ú¼¼";
        }
        if ($row[taxmode] == "0"){
            $taxmode = "¸é¼¼";
        }

        if ($idx > 0){
            $numidx  = $idx-1;
        } else if ($nidx > 0){
            $numidx  = $nidx-1;
        }
        
?>


                <tr>
                    <td width="1">
                    <!-- 10Áø¼ö¸¦ 16Áø¼ö·Î ¹Ù²Ù±â À§ÇÑ ÀÔ·Â°ª -->
<!--                    <input type="text"  name="color3" value="<?=$row[color]?>"> -->
                    <input type="hidden" name="color" value="<?=$row[color]?>">
                    <input type="hidden" name="oldidx" value="<?=$numidx?>">
                    <input type="hidden" name="part" value="<?=$part?>">
                    </td>
                    <td width="780" class="txt07" valign="middle" align="left">
                        <table border="0" cellpadding="0" cellspacing="0" width="780" class="txt07">
                            <tr class="txt03" height="25">
                                <td width="5%" align="center" valign="middle">
                                    <?=$i?><input type="hidden" name="cuscode" value="<?=$cuscode?>">
                                </td>
                                <td width="15%" align="center" valign="middle">
                                    <input name="edate" id="edate[<?=$i-1?>]" value="<?=$row[edate]?>" style="width:75px;text-align:center;" readonly> <img src="../onlinecs/img/common/calendar.gif" style="cursor:pointer;" align="absmiddle" border="0" onClick="calendar(event, 'edate[<?=$i-1;?>]')" > <img src="../onlinecs/img/admin/caldelete.gif" style="cursor:pointer" border="0" align="absmiddle" onClick="deldate(<?=$i-1;?>)">
                                </td>
                                <td width="10%" align="center" valign="middle">
                                    <?=$row[code]?><input type="hidden" name="code" value="<?=$row[code]?>" >
                                </td>
                                <td width="18%" align="left" valign="middle">
                                    <?=$row[name]?>
                                </td>
                                <td width="18%" align="left" valign="middle">
                                    <?=$row[norm]?>
                                </td>
                                <td width="10%" align="right" valign="middle" style="padding:0 5px 0 0;">
                                    <?=number_format($row[buyprice])?>
                                </td>
                                <td width="10%" align="right" valign="middle" style="padding:0 5px 0 0;">
                                    <?=number_format($row[saleprice])?>
                                </td>
                                <td width="12%" align="right" valign="middle" style="padding:0 5px 0 0;">
                                    <input name="sprice" value="<?=number_format($row[amount])?>"  style="width:70px;text-align:right;ime-mode:disabled;" onKeyPress="return numbersonly(event,false)" onchange="scomma(<?=$i-1?>);" onkeydown='enter(<?=$i-1?>,event);'> <img src="../onlinecs/img/admin/caldelete.gif" style="cursor:pointer" border="0" align="absmiddle" onClick="delmoney(<?=$i-1;?>)">
                                </td>
                            </tr>
                            <tr>
                                <td colspan="14" height="1" bgcolor="#efefef">
                                </td>
                            <tr>
                                    
                        </table>
                    </td>
                    <td width="2">
                    </td>


<? 
    $i++;
}
    } else {
?>
                        <table border="0" cellpadding="0" cellspacing="0" width="800" class="txt03">
                            <tr>
                                <td width="100%" align="center" valign="middle" height="50">
                                °Ë»ö°á°ú°¡ ¾ø½À´Ï´Ù.
                                </td>
                            </tr>
                        </table>
<? } ?>


                </tr>
            </table>



</body>
</html>
<script>
    convert();
</script>