webadmin.php

/home/mjc1/public_html/manage/DemoFill.php

 <? 
include("./include/admin_include_header.php");
include("category/opcommon.php");

if(isset($_SESSION['ADMINID']) && ($_SESSION['ADMINID'] == "lys")) { 
    echo "
        <script>
            alert('Á¢±ÙÇÒ ¼ö ÀÖ´Â ±ÇÇÑÀÌ ¾ø½À´Ï´Ù.');
            history.go(-1);
        </script>";
}

if(isset($keyword) && $keyword != ""){
    if($mac_search_type=='1'){
        $Code =  " and a.mac_addr = '$keyword' ";        
    } else {
        $Code =  " and a.mac_addr like '%$keyword%' ";        
    }
}

if ($SearchMdiv == 0){
    $mCode = " ";
} else {
    $mCode = " AND a.app_code = '$SearchMdiv' ";    //ÀÚ»ê°ü¸®Pro
}

$cm_nCount          =      20;
$cm_item_nCount     =      30;          


function pageListing($cur_page, $total_page, $n, $url, $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$keyword ,$SearchMsw1 , $cm_nCount, $menu, $sub  ) {

    $retValue = "<div class='paging'>";
    if ($cur_page > 1) {

        $retValue .= "<a href='" . $url . ($cur_page-1) ."' class='page'><span class='next'>ÀÌÀü</span></a>";
    } else {
        $retValue .= "";
        $retValue .= "";
    }

    $retValue .= "";

    $start_page = ( ( (int)( ($cur_page - 1 ) / 10 ) ) * 10 ) + 1;

    $end_page = $start_page + 9;
    if ($end_page >= $total_page) $end_page = $total_page;
        if ($start_page > 1) $retValue .= "<a href='" . $url . ($start_page-1) . "' class='page'><span class='next10'>ÀÌÀü 10°³</span></a>";

            if ($total_page > 1)
                for ($k=$start_page;$k<=$end_page;$k++)
            if ($cur_page != $k) $retValue .= "<a href='$url$k'>$k</a>";
                else $retValue .= "<a href='$url$k' class='on'>$k</a>";

    if ($total_page > $end_page) $retValue .= "<a href='" . $url . ($end_page+1) . "' class='page'><span class='pro10'>´ÙÀ½ 10°³</span></a>";

    $retValue .= "";

    if ($cur_page < $total_page) {
        $retValue .= "<a href='$url" . ($cur_page+1) ."' class='page'><span class='pro'>´ÙÀ½</span></a>";

    } else {
        $retValue .= "";
        $retValue .= "";
    }

    $retValue .= "</div>";
    return $retValue;
}


/*    
  $total_sql  .=   "select
                        a.mac_addr,a.app_code,b.cde_nm,a.frst_rgst_dtm,a.bigo
                        from macs a
                        LEFT JOIN codes b ON (a.app_code = b.cde and b.cdiv='01')
                        where a.app_rgsted = 0 and b.flag4 != '' and  date_add(a.frst_rgst_dtm,interval 15 day) < now() $Code $mCode ";
                                                
*/

$total_sql  .=   "
                    select
                        a.mac_addr,
                        a.app_code,
                        b.cde_nm,
                        a.frst_rgst_dtm,
                        a.bigo
                    FROM 
                        macs a LEFT JOIN 
                        codes b ON (a.app_code = b.cde and b.cdiv='01')
                    WHERE 
                        a.app_rgsted = 0 
                        and b.flag4 != ''  $Code $mCode ";
$result      = mysql_query($total_sql) or die (mysql_error());
$nTotalCount = mysql_num_rows($result);
$nPage       = ceil($nTotalCount / $cm_nCount);
if ($pg == "") $pg = 1;
if ($_POST['search_mode'] == "Y"){ // °Ë»ö ½Ã ÆäÀÌÂ¡³Ñ¹ö ³¯¸®±â À§ÇØ ¾Æ·§ÂÊ hidden °ª Æ÷ÇÔÇÏ¿© ¼±¾ð 2013.12.02 by.jyh
  $pg = 1;      
}  
$nFrom = ($pg - 1) * $cm_nCount;
//$sql    = $total_sql . "  order by a.frst_rgst_dtm DESC limit $nFrom, $cm_nCount ";
//$sql    = $total_sql . " limit $nFrom, $cm_nCount "; // 2019-02-22 ¿À»ó¸ñÆÀÀå ¿äÃ»À¸·Î ¾Æ·¡ frst_rgst_dtm°¡ ÃÖ½ÅÀ¸·Î ³ª¿Àµµ·Ï º¹¿øµÊ
$sql    = $total_sql . "  order by a.frst_rgst_dtm DESC limit $nFrom, $cm_nCount ";
$result = mysql_query($sql) or die (mysql_error());
?>

<script>    
 function Search(){
    var strKey = document.searchFrm.keyword.value;

    if(strKey.length < 4){
        alert("MacAddress 4ÀÚÀÌ»óÀ» ÀÔ·ÂÇÏ¼¼¿ä.");
        return;
    }
    document.getElementById('search_mode').value = "Y";
    searchFrm.submit();   
}

function extensionDate(mac,code,productName){    
    if(confirm("[[ "+mac+" ]]"+productName+"Á¦Ç° \n\nµ¥¸ð±â°£À» ¿¬ÀåÇÏ½Ã°Ú½À´Ï±î?")){
        location.href = "extensionDateProcess.php?mac="+mac+"&code="+code+"";
    } else {
        return;
    }
}
</script>
<link rel='stylesheet' type='text/css' href='./css/new.css'>
<div class="container">
    <div class="border_contents">
        <div class="admin_table">
            <h3 class="list_ttl">
                µ¥¸ð±â°£¿¬Àå
                <span class="list_sub_ttl bgygr">µ¥¸ð±â°£ ¿¬Àå ÆäÀÌÁöÀÔ´Ï´Ù.</span>
            </h3>
            
            <!-- °Ë»ö¹Ú½º -->
            <form name='searchFrm' method=get>
                <input type="hidden" name="search_mode" id="search_mode">
                <div class="searchArea searchAreaPlus">
                    <span class="searchAreaL"></span>
                    <span class="searchAreaR"></span>
                    <dl class="search_tender requestSearchArea" style="width:545px;">
                        <dd class="relative">
                            <p class="arrow"></p>
                            <select name='SearchMdiv' id="program" class="nonearrow">
                                <option value=0  <? if($SearchMdiv == '0'){ echo "selected"; } ?>>ÀüÃ¼ »óÇ°¸í</option>
                                <? 
                                    $osql = "SELECT cde, cde_alias, flag4 FROM codes WHERE flag4 != '' ORDER BY flag4";
                                    $oresult = mysql_query($osql);
                                    
                                    while($orow = mysql_fetch_array($oresult)){
                                ?>
                                <option value="<?=$orow['cde']?>" <? if($SearchMdiv == $orow['cde']){ echo "selected"; } ?> ><?=$orow['cde_alias']?></option>
                                <? } ?>
                            </select>
                        </dd>
                        <dd>
                            <input type='checkbox' class="nobuy_mem" name='mac_search_type' value='1' <?php if($mac_search_type=='1'){ echo "checked"; }?>>ÀÏÄ¡ °Ë»ö&nbsp;
                            <em class="title bgygr" style="margin-right:10px;">MacAddress</em>
                        </dd>
                        <dd>
                            <input type='text' name='keyword' size='10' value='<?=$keyword;?>' onKeyDown="javascript:if(event.keyCode == 13) Search();"  style="width:143px;height:29px;" placeholder="4ÀÚ¸®ÀÌ»ó ÀÔ·ÂÇÏ¼¼¿ä." class="keyword">
                        </dd>
                        <dd class="searchbtnarea">
                            <a href='javascript:Search();' class="searchBtn bgygr">°Ë»ö</a>
                            <input type='hidden' name='mode' value='search'>
                        </dd>
                    </dl><!--search_tender-->
                </div><!-- //searchArea1-->
            </form>

            <form name='pro_storeFrm'>
                <div class="borderWarp" style="border-bottom:0 none;width:1200px;margin-left:-100px;">
                    <table class="borderTable requestarea">
                        <tr class="bgygr">
                            <th>MacAddress</th>
                            <th>Á¦Ç°¸í</th>
                            <th>µ¥¸ð¹öÁ¯½ÃÀÛ(º¯°æ)ÀÏÀÚ</th>
                            <th>ºñ°í</th>
                            <th class="last">°ü¸®</th>       
                        </tr>
                        <?
                            if($num = mysql_num_rows($result)){
                                while($row  = mysql_fetch_array($result)) {
                        ?>
                        <tr>
                            <td class="family"><?=$row['mac_addr'];?></td>
                            <td>
                                <input type=hidden name='mode' value='<?=$row['app_code']?>'>
                                <?=$row['cde_nm']?>
                            </td>
                            <td class="family"><?=$row['frst_rgst_dtm'];?> </td>
                            <td>
                                <? if($row['bigo']){ ?>
                                    <span class="red"><?=$row['bigo'];?></span>
                                <? } else { ?>
                                    <span class="blue">¿¬ÀåÀÌ·Â¾øÀ½</span>
                                <? } ?>
                            </td>
                            <td class="last">
                                <input type = "button" value = "¿¬Àå" onClick = "javascript:extensionDate('<?=$row['mac_addr'];?>','<?=$row['app_code'];?>','<?=$row['cde_nm'];?>')">
                            </td>
                        </tr>
                        <? 
                                } 
                            } else {  
                        ?>
                        <tr>
                            <td colspan="11" class="last">µ¥ÀÌÅÍ°¡ ¾ø½À´Ï´Ù.</td>
                        </tr>
                        <? }  ?>

                    </table><!-- //borderTable -->
                </div><!-- //borderWarp -->
            </form>

            <? echo pageListing($pg, $nPage, $cm_nCount, "DemoFill.php?menu=3&sub=3&search_mode=$search_mode&SearchMdiv=$SearchMdiv&keyword=$keyword&mode=$mode&pg=" , $mode, $SearchMdiv ,$SearchMup,$SearchMper ,$keyword ,$SearchMsw1 , $cm_nCount, $menu, $sub)?>
            <?//print_r($_REQUEST)?>

             <iframe name="ifrm" width="0" height="0"></iframe>
        </div><!-- //admin_table -->

        <p class="navi">°ü¸®ÀÚ¸ðµå > Á¤Ç°°ü¸® > µ¥¸ð±â°£¿¬Àå</p>

        <div class="footer">
            <?    include("./include/admin_include_footer.php"); ?>
        </div><!-- //footer -->

    </div><!-- //border_contents -->
</div><!-- //container -->
</div><!-- //wrap -->

</body>
</html>