webadmin.php

/home/mjc1/public_html/manage/visit_ref_kw.php

 <?
    include("./include/admin_include_header.php");
    header("Content-Type: text/html; charset=euckr"); 

    $inner_ip = "58.151.27.172";
    $inner_ip2 = "106.245.197.154";

    $where = "";
    if($inner_exp=='1'){
        $where .= " and not (ip = '$inner_ip' or ip = '$inner_ip2') ";
    }

    if($sdate==''){ $sdate = date("Y-m-01",time()); }
    if($edate==''){ $edate = date("Y-m-d",time()); }

    $kw_array = null;

    $sql = "select referer, count(*) as cnt from visit_ref_log where 1=1 and ref_key <> '' and reg_date >= '{$sdate} 00:00:00' and reg_date <= '{$edate} 23:59:59' {$where} group by referer order by 2 desc";
    //_pr($sql);
    //$sql = "select * from visit_ref_log where reg_date >= '2019-05-09 00:00:00' and reg_date <= '2019-05-09 23:59:59' and referer like '%naver%' and referer like '%query%'";
    $result = mysql_query($sql);
    while($row=mysql_fetch_array($result)){
        //$row['referer'] = iconv("utf8","euckr",$row['referer']);
        if(strpos($row['referer'],"query=")>0){
            //_pr($row['referer']);
            $v = explode("query=",$row['referer']);
            $vv = $v[1];
            $v1 = explode("&",$vv);
            //_pr($v1);
            $c3 = $v1[0];
            if(strpos($c3,"%")===false){
                if($kw_array[$c3]==''){
                    $kw_array[$c3] = $row['cnt'];
                } else {
                    $kw_array[$c3] += $row['cnt'];
                }
            }
            /*foreach($v1 as $key=>$val){
                $val1 = explode("=",$val);
                if(count($val1)==1){
                    $val11 = $val1[0];
                } else {
                    $val11 = $val1[1];
                }
                //_pr($val11);
                //$c3 = iconv("utf8","euckr",$val11);
                //_pr("=>".$c3);
                $c3 = $val11;
                if(preg_match("/[\xA1-\xFE][\xA1-\xFE]/",$val11)){
                    //_pr("ÇÑ±Û");
                    if($kw_array[$c3]==''){
                        $kw_array[$c3] = $row['cnt'];
                    } else {
                        $kw_array[$c3] += $row['cnt'];
                    }
                } else {
                    //_pr("±âÅ¸");
                }
            }*/
            //_pr(rawurldecode($vv));
        }
    }

    asort($kw_array,2);

    asort($kw_array);

    $max_cnt = count($kw_array);
    $cnt = 1;
    foreach($kw_array as $key=>$val){
        $kw_new[$max_cnt-$cnt]['kw'] = $key;
        $kw_new[$max_cnt-$cnt]['cnt'] = $val;
        $cnt++;
    }

    //_pr($kw_new); exit;
?>

<script> 
    
function Search(){
    document.getElementById('search_mode').value = "Y"; 
    searchFrm.submit();
}
 
function develWrite(){
    location.href = "eventWrite.php?menu=4&sub=8";
} 
   
function CheckAll() {
 
    if( document.develFrm.all.value == 1){
        document.chkImg.src = "bt_allcheck_not.gif";
    
    
        for (var i=0;i<document.develFrm.elements.length;i++){
            if (document.develFrm.elements[i].name == 'develForm[]'){
                document.develFrm.elements[i].checked = true;
            }
        }
        
        document.develFrm.all.value = '0'; 
        
    } else {
        document.chkImg.src = "bt_allcheck.gif";
    
        for (var i=0;i<document.develFrm.elements.length;i++){
            if (document.develFrm.elements[i].name == 'develForm[]'){
                document.develFrm.elements[i].checked = false;
            }
        }

        document.develFrm.all.value = '1'; 
    }
} 


function allDel(){
    var cnt=0;
    
    for (var i=0;i<document.develFrm.elements.length;i++){
        if (document.develFrm.elements[i].name == 'develForm[]'){
                if( document.develFrm.elements[i].checked == true ) cnt++;
            }
        }
        
        if(cnt>0){ 
        
            if(confirm("¼±ÅÃÇÏ½Å "+ cnt +" °³ÀÇ °Ô½Ã¹° Á¤º¸¸¦ »èÁ¦ÇÏ½Ã°Ú½À´Ï±î?") ){
                document.develFrm.action = "eventBoardProcess.php" ;
                document.getElementById("develFrm").target="hidden_frame_mijin";           
                document.develFrm.submit();
            }
            
        } else {
        alert("»èÁ¦ÇÒ Ç×¸ñÀ» ¼±ÅÃÇÏ¼¼¿ä.")
        return;
    }   
}     

$(function(){
    $("#status").change(function(){
        var v_status = $(this).val();
        var tr_obj = $(this).closest('tr');
        var v_uid = $(tr_obj).find("#develForm_uid").val();

        if(confirm('ÇØ´ç ¶óÀÎÀÇ »óÅÂ°ªÀ» º¯°æÇÏ½Ã°Ú½À´Ï±î?')){
            $("#status_change_form input[name='uid']").val(v_uid);
            $("#status_change_form input[name='status']").val(v_status);
            
            $("#status_change_form").submit();
        }

    });
    $("#searchCode1").change(function(){
        $("#searchFrm").submit();
    });

    $(".show_kw_class").css("cursor","pointer").click(function(){
        $tr_obj = $(this).closest("tr");
        $kw_idx = $tr_obj.find("input[name='kw_idx[]']").val();
        if($(this).html()=="+"){
            $kw = encodeURIComponent($tr_obj.find("input[name='kw[]']").val());
            $sdate = $("#sdate").val();
            $edate = $("#edate").val();
            $inner_exp = $("#inner_exp").val();
            form_data = "kw="+$kw+"&sdate="+$sdate+"&edate="+$edate+"&inner_exp="+$inner_exp+"&kw_idx="+$kw_idx;
            //alert(form_data);
            $.post("ajax.visit_kw_sub_get.php",form_data,function(rtn){
                $tr_obj.after(rtn);
                $tr_obj.find(".show_kw_class").html("-");
            });
        } else if($(this).html()=="-"){
            $(".tr_sub_"+$kw_idx).remove();
            $tr_obj.find(".show_kw_class").html("+");
        }
    });

    $(document).on("click",".show_detail_trace",function(){
        $tr_obj = $(this).closest("tr");
        $idx = $tr_obj.find("input[name='idx[]']").val();
        $.get("ajax.visit_trace_get.php?idx="+$idx,function(rtn){
            $("#modal_member_box").html(rtn).dialog({
                resizable: true, height:780, width:900, modal: true, title: "ÃßÀû",
                buttons: {
                    ´Ý±â: function() {
                        $( this ).dialog( "close" );
                    }
                }
            });
        });
    });
});
</script>
<div id="modal_member_box" title="1Â÷¸ð´Þ" style="display:none;width:100%; height:100%; padding-top:3px;padding-left:3px;background-color:#FFFFFF;position:relative;"></div>
        <div class="container">
            <div class="border_contents">

                <div class="admin_table">
                    <h3>
                        <b style='font-size:24px;'>¿ÜºÎÀ¯ÀÔ °Ë»ö¾î °ü¸®ÆäÀÌÁö</b>
                        <span>¿ÜºÎ¿¡¼ °Ë»ö¾î¸¦ ÅëÇØ¼ È¨ÆäÀÌÁö¿¡ À¯ÀÔµÈ Åë°è/ÃßÀûÇÏ´Â ÆäÀÌÁö ÀÔ´Ï´Ù.</span>
                    </h3>

                    <form name='searchFrm' id='searchFrm' method=get>
                    <input type="hidden" name="search_mode" id="search_mode">
                    <input type="hidden" name="menu" value='<?php echo $menu;?>'>
                    <input type="hidden" name="sub" value='<?php echo $sub;?>'>
                        <div class="searchArea1">
                            <span class="searchAreaL1"></span>
                            <span class="searchAreaR1"></span>
                            <dl class="search_tender" style="width:640px;">
                                <dt>°Ë»ö Ç×¸ñ</dt>
                                <dd><input type='text' name='sdate' id='sdate' value='<?=$sdate?>'></dd>
                                <dd>~</dd>
                                <dd><input type='text' name='edate' id='edate' value='<?=$edate?>'></dd>
                                <dd>
                                    ³»ºÎ¾ÆÀÌÇÇ Á¦¿Ü <input type='checkbox' name='inner_exp' id='inner_exp' value='1' <?if($inner_exp=='1'){ echo "checked"; }?>> 
                                </dd>
                                <!--<dd>
                                    ³»ºÎ ·¹ÆÛ·¯ Á¦¿Ü <input type='checkbox' name='refer_mj' value='1' <?if($refer_mj=='1'){ echo "checked"; }?>> 
                                </dd>-->
                                <dd>
                                    <a href='javascript:Search();' class="searchBtn">°Ë»ö</a>
                                    <input type="hidden" name='mode' value='search'>
                                </dd>
                            </dl><!--search_tender-->
                        </div><!-- //searchArea1-->
                    </form>
                    <!-- //°Ë»ö¹Ú½º -->
<script>
    $(function(){
        $( "#sdate" ).datepicker({
            showOn: "button",
            buttonImage: "./images/common/icon_calendar.png",
            buttonImageOnly: true,
            buttonText: "Select date",
            dateFormat: "yy-mm-dd",
            changeMonth: true,
            changeYear: true,
            prevText: 'ÀÌÀü ´Þ',
            nextText: '´ÙÀ½ ´Þ',
            monthNames: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            monthNamesShort: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            dayNames: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesShort: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesMin: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            showMonthAfterYear: true,
            yearSuffix: '³â'
        });

        $( "#edate" ).datepicker({
            showOn: "button",
            buttonImage: "./images/common/icon_calendar.png",
            buttonImageOnly: true,
            buttonText: "Select date",
            dateFormat: "yy-mm-dd",
            changeMonth: true,
            changeYear: true,
            monthNames: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            monthNamesShort: ['1¿ù','2¿ù','3¿ù','4¿ù','5¿ù','6¿ù','7¿ù','8¿ù','9¿ù','10¿ù','11¿ù','12¿ù'],
            dayNames: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesShort: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            dayNamesMin: ['ÀÏ','¿ù','È','¼ö','¸ñ','±Ý','Åä'],
            showMonthAfterYear: true,
            yearSuffix: '³â'
        });
    });
</script>
                    <form name='develFrm' id='develFrm'>
                    <input type=hidden name=all value=1>
                    <input type=hidden name=exCode value=alldel>
                    <input type="hidden" name="menu" value="<?=$menu?>">
                    <input type="hidden" name="sub" value="<?=$sub?>">
                        <div class="borderWarp">
                        <table class="borderTable">
                            <tr>
                                <!--<th><img src="./images/common/bt_allcheck_all.gif" alt="¸ðµÎ¼±ÅÃ" style="cursor:pointer;" name='chkImg' onClick="CheckAll();"></th>-->
                                <th>ÃßÀû°¹¼ö</th>
                                <th>°Ë»ö¾î</th>
                                <th>°¹¼ö</th>
                                <th class="last">¼¼ºÎ</th>
                            </tr>
<?
 if(count($kw_new)>0){
    $sum_cnt = 0;
    for($i=0;$i<count($kw_new);$i++){
        $row = $kw_new[$i];
        $sum_cnt += $row['cnt'];
?>
                            <tr class='tr_obj_<?php echo $i;?>'>
                                <input type='hidden' name='kw_idx[]' value='<?=$i?>'>
                                <input type='hidden' name='kw[]' value='<?=$row['kw']?>'>
                                <!--<td><input name="develForm[]" id='develForm_uid' type="checkbox" value="<?=$row['uid'];?>"></td>-->
                                <td>&nbsp;</td>
                                <td style='font-weight:bold;'><?=$row['kw']?></td>
                                <td style='width:200px;word-break:break-all;'><?=$row['cnt'];?></td>
                                <td style='width:70px;word-break:break-all;font-size:24px;' class='last show_kw_class'>+</td>
                            </tr>  
<? 
            $id_cnt--;
        } 
    } else {  
?>
                            <tr>
                                <td colspan="7">µ¥ÀÌÅÍ°¡ ¾ø½À´Ï´Ù.</td>
                            </tr>
<? 
    } 
?>
                            <tr>
                                <td colspan="2" class="bottom" style="padding:5px 0;">ÃÑ°¹¼ö<!--<a href='javascript:allDel();' class="allDelBtn">ÀÏ°ý»èÁ¦</a>--></td>
                                <td colspan="1" class="bottom"><?php echo $sum_cnt;?></td>
                                <td colspan="1" class="bottom last">&nbsp;</td>
                            </tr>
                        </table><!-- //borderTable -->
                        </div><!-- //borderWarp -->
                        
                         <div class="btn1Warp">
                           <!--<a href="javascript:develWrite();"><span class="btn1">±Ûµî·Ï</span></a>-->
                        </div>
                    </form>

                     <? echo pageListing($pg, $nPage, $cm_nCount, "?menu=4&sub=9&search_mode=$search_mode&searchCode=$searchCode&keyword=$keyword&mode=$mode$search_where&pg=" , $mode, $SearchMdiv ,$SearchMup,$SearchMper,$searchCode ,$keyword ,$SearchMsw1 , $cm_nCount, $menu, $sub)?>
                    <?//print_r($_REQUEST)?>

                    <iframe id='hidden_frame_mijin' name='hidden_frame_mijin' style="display:none;"></iframe>

                </div><!-- //admin_table -->
                <p class="navi">°ü¸®ÀÚ¸ðµå > ÀÏ¹Ý°Ô½ÃÆÇ > °³¹ßÇöÈ²</p>

                <div class="footer">
                    <?    include("./include/admin_include_footer.php"); ?>
                </div><!-- //footer -->
<form name='status_change_form' id='status_change_form' method='get' action='eventBoardStatus.php'>
    <input type='hidden2' name='mode' value='mod'>
    <input type='hidden2' name='pg' value='<?php echo $pg;?>'>
    <input type='hidden2' name='menu' value='<?php echo $menu;?>'>
    <input type='hidden2' name='sub' value='<?php echo $sub;?>'>

    <input type='hidden2' name='uid' value=''>
    <input type='hidden2' name='status' value=''>
</form>

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

</body>
</html>