webadmin.php

/home/mjc1/public_html/mac_confirm/index_total.php

<?
include("./header.php");
if(!isset($_SESSION['userid'])) $_SESSION['userid'] = "";

if($_SESSION['userid'] == ""){
    header("Location: login_total.php");
}

// data ºÒ·¯¿À´Â ºÐ
/*$sql = "SELECT 
            r.user_name
        FROM 
            regist_user r LEFT JOIN codes c ON (r.app_code = c.cde)
        WHERE 
            user_id = '{$_SESSION['userid']}' group by r.user_name";*/
$sql = "select Mcompany, Mname from member where Mid = '{$_SESSION['userid']}' ";

$result = mysql_query($sql,$connect_web );

$row = mysql_fetch_assoc($result);

?>
<script>
function editPop(cdkey){
    var oldwin = window.open("userMacInformation.php?cdkey="+cdkey+"", "newpop", "status=0,toolbar=0,resizable=0,scrollbars=yes,width=800,height=800" );
}
</script>
<link href="css/macInformation.css" rel="stylesheet" />

<style>

@media(max-width:750px){
    .macContainer { width:100%; }
    .macContainer .cols1 { width:38%; }
    .macContainer .cols2 { width:57%; }
    .macWrap2 { width:90%; }
    .th_pc { display:none;}
    .th_mobile { 
        /*display:;*/
        /*display: inline-block;*/
        width: 100%;
        background: #eee;
        margin: 0px;
        padding: 0px;
        font-size: 0;
        letter-spacing: 0;
        word-spacing: 0;
        border: 0;
        border-bottom: 1px solid #dbdbdb;
    }
    .macFooter { width:98%; }
    .listContainer th {
        height: 35px;
        color: #555;
        min-width: 70px;
        width: 163px;
        font-size: 13px;
        line-height: 35px;
        text-align: center;
    }
    /*.listContainer td { display:inline-block; width:50%; }*/
}
@media(min-width:750px){
    .macContainer .cols1 { width:30%; }
    .macContainer .cols2 { width:70%; }
    .th_pc { display:;}
    .th_mobile { display:none;}
}

.mc_logo { width:117px; height:100px; float:left; }
.mc_copyright { color:#6f6f6f !important; margin:5px 5px 5px 20px; font-size:11px; }
.macFooter { clear:both; }
.logo { width:300px; }
</style>
<script>
$(function(){
    /*$(window).resize(function(){
        if(document.body.clientWidth<636){
            $(".th_pc").hide();
            $(".th_mobile").show();
        } else {
            $(".th_pc").show();
            $(".th_mobile").hide();
        }
    });*/
});
</script>
<body>
    <input type='hidden' id='th_split' value='0'>
    <form name="" id="" action="" method="post">
    <div class="macWrap1">
        <div class="logo"><img src="images/logo.png" alt="¿¥Á¦ÀÌ¼ÒÇÁÆ®"></div>
        <div class="macWrap2">
            <div class="header">
                <h1><img src="images/mac_title.png" alt="MacAddredd Á¤Ç°ÀÎÁõ"></h1>
                <p>°í°´´ÔÀÇ Mac Address Á¤º¸¸¦ °ü¸® ÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.</p>
            </div>


             <table class="macContainer" >
                <caption>
                    ÀÎÁõÁ¤º¸
                    <span class="logout"><a href="./logout_total.php"><img src="images/btn_logout.png" alt="·Î±×¾Æ¿ô"></a></span>-
                </caption>
                <colgroup>
                    <col class='cols1'><col class='cols2'>
                </colgroup>
                <tr>
                    <th>È¸¿ø ¾ÆÀÌµð</th>
                    <td><?=$_SESSION['userid']?></td>
                </tr>
                <tr>
                    <th>»óÈ£¸í [¼º¸í]</th>
                    <td><?=$row['Mcompany']."[".$row['Mname']."]"?></td>
                </tr>
            </table>

              &nbsp
<?php 
if($_SESSION['userid']=='sgdream'){

    $where = "";
    if($s_txt!=''){
        $where .= " and {$s_key} like '%{$s_txt}%' ";
    }

    $sql = "SELECT a.user_id, b.user_name
            FROM app_priv AS a
            INNER JOIN app_user AS b ON a.user_id = b.user_id
            WHERE
            a.groupwareid = 'sgdream'
           {$where}
            GROUP BY a.user_id, b.user_name order by b.user_name";
    //print_r($sql);
    $res = mysql_query($sql,$connect_app);
    while($info=mysql_fetch_array($res)){
        $id_array[] = $info;
    }
    //print_r($id_array);
?>
<div style='margin:0 0 15px 0;'>
´ë¸®Á¡ ¼±ÅÃ : <select name='sk_sub_id' id='sk_sub_id'>
    <option value=''>--¼±ÅÃ--</option>
<?php
foreach($id_array as $key=>$val){
    if($sub_id==$val['user_id']){ $std = "selected"; } else { $std = ""; }
    echo "<option value='{$val['user_id']}' {$std}>{$val['user_name']}</option>";
}
?>
</select>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <select name='s_key'>
        <option value='user_id' <?php if($s_key=='user_id'){ echo "selected"; }?>>È¸¿øID</option>
        <option value='user_name' <?php if($s_key=='user_name'){ echo "selected"; }?>>»óÈ£¸í</option>
    </select>
    <input type='text' name='s_txt' value='<?php echo $s_txt;?>' size=13>
    <input type='button' value='°Ë»öÇÏ±â' onclick="key_search()">
</div>
<?php
}    
?>

            <table class="listContainer">
                <!--<colgroup>
                    <col width="25%"><col width="25%"><col width="25%"><col width="25%">
                </colgroup>-->
                <tr class='th_pc'>
                    <th>ÇÁ·Î±×·¥</th>
                    <th>CD-Key</th>
                    <th>¸¸·áÀÏÀÚ</th>
                    <th>¶óÀÌ¼¾½º</th>
                </tr>
                <!-- ¸ð¹ÙÀÏ¿ë -->
                <thead class="th_mobile">
                    <th>ÇÁ·Î±×·¥</th>
                    <th>CD-Key</th>
                    <th>¸¸·áÀÏÀÚ</th>
                    <th>¶óÀÌ¼¾½º</th>
                </thead>
                <!-- ¸ð¹ÙÀÏ¿ë ³¡ -->

            <?

            $sess_id = $_SESSION['userid'];
            if($sub_id!=''){
                $sess_id = $sub_id;
            }

            // data ºÒ·¯¿À´Â ºÐ
            $sql = "SELECT 
                        r.idx, 
                        r.user_id, 
                        r.cdkey, 
                        r.user_name, 
                        r.app_code, 
                        r.enddate, 
                        r.license_pc, 
                        r.license_pda, 
                        r.sale_amount, 
                        r.bigo, 
                        r.rgst_dtm, 
                        c.cde_nm, 
                        c.flag3,
                        COUNT(d.cdkey) AS use_cdkey
                    FROM regist_user r 
                    LEFT JOIN codes c ON (r.app_code = c.cde)
                    LEFT JOIN mac_detail d ON (d.cdkey = r.cdkey)
                    WHERE r.user_id = '{$sess_id}'
                    GROUP BY r.idx, r.user_id, r.cdkey, r.user_name, r.enddate, r.license_pc, r.license_pda, r.sale_amount, r.bigo, r.rgst_dtm, r.rgster, c.cde_nm 
                    ORDER BY r.idx DESC";
            //print_r($sql);
            $result = mysql_query($sql);


            if($num = mysql_num_rows($result)){

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

                    // Notice Error ¹æÁö
                    if(!isset($row['idx'])) $row['idx'] = "";    
                    if(!isset($row['user_id'])) $row['user_id'] = "";    
                    if(!isset($row['cdkey'])) $row['cdkey'] = "";    
                    if(!isset($row['user_name'])) $row['user_name'] = "";    
                    if(!isset($row['user_id'])) $row['user_id'] = "";    
                    if(!isset($row['enddate'])) $row['enddate'] = "";

            ?>
                <tr class='th_pc'>
                    <td><?=$row['cde_nm'];?></td>
                    <td class='tab_class'><? echo substr($row['cdkey'],0,4)."-".substr($row['cdkey'],4,4)."-".substr($row['cdkey'],8,4); ?></td>
                    <td class='tab_f_class'><?=$row['enddate'];?></td>
                    <td>
                        <?=$row['license_pc']."(".$row['use_cdkey'].")"?> °³ <img src="images/btn_mac.png" alt="Mac°ü¸®" onclick="editPop('<?=$row['cdkey']?>');">
                    </td>
                </tr>

                <!-- ¸ð¹ÙÀÏ¿ë -->
                <tr class='th_mobile'>
                    <td><?=$row['cde_nm'];?></td>
                    <td class='tab_class'><? echo substr($row['cdkey'],0,4)."-".substr($row['cdkey'],4,4)."-".substr($row['cdkey'],8,4); ?></td>
                    <td class='tab_f_class'><?=$row['enddate'];?></td>
                    <td>
                        <?=$row['license_pc']?> °³ <img src="images/btn_mac.png" alt="Mac°ü¸®" onclick="editPop('<?=$row['cdkey']?>');">
                    </td>
                </tr>
                <!-- ¸ð¹ÙÀÏ¿ë ³¡-->

            <?
                }
            } else {
            ?>
                <tr>
                    <td height="100" colspan="4" >µ¥ÀÌÅ¸°¡ ¾ø½À´Ï´Ù.</td>
                </tr>
            <?
                }
            ?>


            </table>


        </div><!-- //macWrap2-->

        <div class="macFooter">
            <!--<img src="images/copyright.png" alt="Ä«ÇÇ¶óÀÌÆ®">-->
            <div class='mc_logo'><img src='images/mc_copy_logo.png'></div>
            <div class='mc_copyright'><strong>¿¥Á¦ÀÌ¼ÒÇÁÆ®</strong> | ´ëÇ¥ <strong>Á¤ÀÏ¿µ</strong> | »ç¾÷ÀÚ¹øÈ£ 502-18-94746 | Åë½ÅÆÇ¸Å¾÷½Å°í 2011-¼¿ï¼ÛÆÄ-0758 | ¼¿ïÆ¯º°½Ã ¼ÛÆÄ±¸ Áß´ë·Î 105(°¡¶ôµ¿, ¾ÆÀÌµðÅ¸¿ö 1004È£) | Tel (02)<strong>401-5121</strong> | Fax (02)<strong>832-3555</strong> | ´ë±¸±¤¿ª½Ã ¼ö¼º±¸ µ¿´ë±¸·Î 331(¹ü¾î3µ¿, Ã»È¿Á¤ºôµù 7F) | Tel (053)894-1194 | Fax (053)744-1120 | ºÎ»ê±¤¿ª½Ã µ¿´ë±¸ »çÁ÷ºÏ·Î 34(»çÁ÷µ¿ 48-20) | Tel (051)894-1194 | Fax (051)797-8797 | ¾÷¹«½Ã°£ ÆòÀÏ <strong>09:00-18:00</strong>, Á¡½É : <strong>12:00-13:00 ±¹/°øÈÞÀÏ, Åä¿äÀÏ ÈÞ¹«</strong>
            <br>COPYRIGHT (C)<?php echo date("Y");?> MJSOFT ALL RIGHT RESERVED. </div>
        </div>
    </div><!-- smsWrap1-->
    </form>
</body>
<script>
$(function(){
    $("#sk_sub_id").change(function(){
        $v = $(this).val();
        document.location.href='?sub_id='+$v+'&s_key=<?php echo $s_key;?>&s_txt=<?php echo $s_txt;?>';
    });

    $("input[name='s_txt']").keypress(function(){
        if(event.keyCode==13){
            key_search();
        }
    });
});

function key_search(){
    $s_key = $("select[name='s_key'] option:selected").val();
    $s_txt = $("input[name='s_txt']").val();
    document.location.href='?s_key='+$s_key+'&s_txt='+$s_txt;
}
</script>
<? include("./footer.php"); ?>