webadmin.php

/home/mjc1/public_html/html/millennium/mac_list.php

<?php include_once("./_common2.php"); ?>
<?
    if(!isset($Oname)) $Oname = "";
    if(!isset($_REQUEST['SearchMsw1'])) $SearchMsw1 = "";
    include_once($_SERVER['DOCUMENT_ROOT']."/manage/category/opcommon.php");

    //print_r($_COOKIE);

?>

<script>
function go_check(query){ //ÇÑÅØ½º¼ÛÀå¹øÈ£Á¶È¸
    var obj = document.OrderSelect
    window.open('', 'popup','scrollbars=yes, width=900, height=490');
    
    obj.target = "popup";

    location.href = "http://ptop.e-pointerex.co.kr:8080/jsp/tr/detailSheet.jsp?iSheetNo="+query;

    return true;

}

function go_check_CJ(query){ //CJ¼ÛÀå¹øÈ£Á¶È¸
    var obj = document.OrderSelect
    window.open('', 'popup','scrollbars=yes, width=900, height=490');
    
    obj.target = "popup";

    location.href = "http://nexs.cjgls.com/web/tracking_hth_pop.jsp?slipno="+query;

    return true;

}

function go_check_hanjin(query){ //ÇÑÁøÅÃ¹è¼ÛÀå¹øÈ£Á¶È¸

    window.open("http://www.hanjin.co.kr/delivery_html/inquiry/result_waybill.jsp?wbl_num="+query,"","width=1024,height=768,scrollbars=yes");

}

function selectuser(gubun){ //°Ë»ö
    var telnum  = OrderSelect.Oname.value;

    location.href  =  "mypagepaper.php?Oname="+telnum+"&SearchMsw1="+gubun;

}

function selectuserText(telnum){

    location.href  =  "mypagepaper.php?Oname="+telnum;

}

</script>
<style>
    .deliveryTable tr td {padding-left:10px; padding-right:10px; line-height:25px;}
    .deliveryTable2 {margin-top:5px; margin-bottom:5px; border-left:1px solid #e0e0e0; border-top:1px solid #e0e0e0; }
    .deliveryTable2 td, th { border-right:1px solid #e0e0e0; border-bottom:1px solid #e0e0e0;}
    .deliveryTable2 th { background:#f0f0f0; }
</style>
<form name="OrderSelect" action="" method="post">

<div class="deliverySearch" style='display:none;'>
    <form name="searchFrm" method="post">
    <div class="deliverySection">
        <p><img src="./img/mypage/division.jpg" alt="±¸ºÐ"></p>
        <select name='SearchMsw1'>
            <option value=all <? if($SearchMsw1 == 'all' ){ echo "selected"; } ?> >ÀüÃ¼</option>
            <option value=1 <? if($SearchMsw1 == '1' ){ echo "selected"; } ?> >¹è¼Û</option>
            <option value=2 <? if($SearchMsw1 == '2' ){ echo "selected"; } ?> >ÁÖ¹®</option>
        </select>
        <p><img src="./img/mypage/number.jpg" alt="ÀüÈ¹øÈ£"> <input type="text" name="Oname" value="<?=$Oname;?>" onKeyDown="if(event.keyCode==13)selectuserText(this.value);" size="15"></p>
        <p><input type="image" name="submit" src="./img/mypage/search.jpg"> <font color="#3333CC">Áö¿ª¹øÈ£Æ÷ÇÔ ÀÔ·Â ÈÄ [°Ë»ö]´©¸£¼¼¿ä.</font></p>
    </div>
    </form>
</div><!-- //faqSearch -->

<table class="deliveryTable" style='width:100%;'>
     <tr>
        <th>ÇÁ·Î±×·¡¸í</th>
        <th>CD-KEY</th>
        <th>¶óÀÌ¼¾½º</th>
        <th>µî·Ï/¸¸·áÀÏ</th>
        <th>ºñ°í</th>
        <th>¼¼ºÎ³»¿ªº¸±â</th>
    </tr>

<?

    if (1==1) {

        if( $SearchMsw1 == 'all')  $SearchMswQry =  "";
        if( $SearchMsw1 == '1')    $SearchMswQry =  " AND Deliver <> '' ";
        if( $SearchMsw1 == '2')    $SearchMswQry =  " AND Deliver = '' ";

    $box_qry      =  " select r.*, c.cde_nm from regist_user r left join codes c on r.app_code = c.cde where user_id = '{$_COOKIE['USERID']}' " ;

    $box_result   =  MYSQL_QUERY($box_qry);
    $num          =  MYSQL_NUM_ROWS($box_result);

        if ($num > 0 ) {

            $i = 1;

        while ($Row   =  MYSQL_FETCH_ARRAY($box_result)) {
            //_pr($Row);
            $sql = "SELECT A.*, B.bigo FROM mac_detail A LEFT JOIN macs B ON A.mac_idx = B.idx WHERE A.cdkey = '{$Row['cdkey']}'";
            $res = mysql_query($sql);
            //$info = mysql_fetch_array($res);
            $mac_cnt = mysql_num_rows($res)

    ?>

    <tr onclick="if(document.all('tr_<?=$i;?>').style.display==''){document.all('tr_<?=$i;?>').style.display='none';}else{document.all('tr_<?=$i;?>').style.display=''}" onmouseover="this.style.background='#ecf0f9'" onmouseout="this.style.background='#ffffff'" style="cursor:pointer;">
        <td height="30">
            <?php echo $Row['cde_nm']?>
        </td>
        <td height="30">
            <?php echo $Row['cdkey']?>
        </td>
        <td height="30">
            <?php echo $Row['license_pc']."({$mac_cnt})"?>
        </td>
        <td height="30">
            <?php echo substr($Row['rgst_dtm'],0,10);?><br><font color=red><?php echo $Row['enddate'];?></font>
        </td>
        <td height="30">
            <?php echo $Row['bigo']?>
        </td>


        <td width="120">
            <p><img src="./img/mypage/detail_bt.jpg" alt="»ó¼¼³»¿ªº¸±â"></p>
        </td>
    </tr>

    <tr id='tr_<?=$i;?>' style='display:none;'>
        <td colspan="6" style='<?php if($mac_cnt==0){?>display:none;<?php }?>'>
            <table class='deliveryTable2' style='width:100%;' >
                <tr>
                    <th>È¸¿øID</th>
                    <th>MACÁÖ¼Ò</th>
                    <th>±ÇÇÑ</th>
                </tr>
<?php
    while($info = mysql_fetch_array($res)){
?>
                <tr>
                    <td><?php echo $info['pc_name']?><br><?php echo $info['last_edit_dtm']?></td>
                    <td><?php echo $info['mac_addr']?><br><?php echo $info['bigo']?></td>
                    <td>
                        <? if($info['opt1'] == 0){    ?>
                            <p><span style="font-size:9pt;"><font face="Verdana">ÀüÃ¼±â´É</font></span></p>
                        <? }else{    ?>
                            <p><span style="font-size:9pt;"><font face="Verdana">Á¶È¸±â´É</font></span></p>
                        <? }    ?>
                    </td>
                </tr>
<?php
    }
?>
            </table>
        </td>
    </tr>

<?
    
    $i++;

        } 
    } else {


?>

    <tr>
        <td colspan="7">
            <p class="noneData">°Ë»öµÈ ³»¿ªÀÌ ¾ø½À´Ï´Ù.</p>
        </td>
    </tr>


<?
        }

    } else {

?>

    <tr>
        <td colspan="7">
            <p class="noneData">°Ë»öµÈ ³»¿ªÀÌ ¾ø½À´Ï´Ù.</p>
        </td>
    </tr>

<? } ?>

</table>
</form>