외부 유입 검색어 분석기 채택완료

<?
$sub_menu = "200816";
include_once("./_common.php");
$g5['title'] ="검색어 분석기";
require_once './admin.head.php';
include_once(G5_PLUGIN_PATH.'/jquery-ui/datepicker.php');

// 날짜 설정
if(!$datefrom) $datefrom = date("Y-m-d", strtotime("1 days ago"));
if(!$dateto) $dateto = G5_TIME_YMD;

// 주사 지랄 방지
$datefrom = substr($datefrom, 0, 10);
$dateto = substr($dateto, 0, 10);
$site = substr($site, 0, 10);
$site_ori = $site;

// 검색사이트들
$site_arr = array("Google", "NAVER", "DAUM", "NATE", "Bing");
$surl_arr = array("Google" => "http://www.google.%", "NAVER" => "%search.naver.com%",  "DAUM" => "%search.daum.net%", "NATE" => "%nate.com%",  "Bing" => "http://www.bing.com%");
$svar_arr = array("Google" => "q", "NAVER" => "query", "DAUM" => "q", "NATE" => "q", "Bing" => "q");
?>
<style type="text/css">
#m3tbl { border:solid 1px #CCC; border-collapse:collapse;}
#m3tbl th { border:solid 1px #CCC; text-align:center;}
#m3tbl td { border:solid 1px #CCC; text-align:center; padding:2px 8px;}
#div_m3sq ul { display:inline; padding:0; margin:0; }
#div_m3sq ul li { display:inline; padding:10px 30px; border:solid 1px #3ad1d6; background: #3cd4d9; }
#div_m3sq ul li a {color:#fff; text-decoration: none; font-weight: bold;} 
#div_m3sq ul li a:hover {color:#007b81; text-decoration: none; font-weight: bold;} 
</style>


<div id="div_m3sq">

외부 유입 검색어 분석기<br />
<br />
<ul>
<li><a href="<?php echo $PHP_SELF?>?dateto=<?php echo $dateto?>&datefrom=<?php echo $datefrom?>">All</a></li>
<? foreach($site_arr as $site) { ?>
<li><a href="<?php echo $PHP_SELF?>?site=<?php echo $site?>&dateto=<?php echo $dateto?>&datefrom=<?php echo $datefrom?>"><?php echo $site?></a></li>
<? } ?>
</ul>

<br />
<br />

<form action="<?php echo $_SERVER['PHP_SELF']?>" class="local_sch01 local_sch" method="get" style="overflow: hidden;">
    <input type="hidden" name="site" value="<?php echo $site_ori?>" />
    <div class="sch_last">
        <strong>기간별검색</strong>
        <input type="text" name="datefrom" id="datefrom" value="<?php echo $datefrom?>" class="frm_input" size="10" />
        <label for="datefrom" class="sound_only">시작일</label>
        ~
        <input type="text" name="dateto" id="dateto" value="<?php echo $dateto?>" class="frm_input" size="10" />
        <label for="dateto" class="sound_only">종료일</label>
        <input type="submit" value="검색" class="btn_submit" style=" background:#f8d034; font-weight:700; font-size:14px;width:80px; padding:10px;">
    </div>
</form>

<script>
$(function(){
    $("#datefrom, #dateto").datepicker({ changeMonth: true, changeYear: true, dateFormat: "yy-mm-dd", showButtonPanel: true, yearRange: "c-99:c+99", maxDate: "+0d" });
});
</script>

<form action="javascript:;" onsubmit="findsq(getElementById('sq').value)" class="local_sch03 local_sch"  style="overflow: hidden"/>
    결과내 검색 : <input type="text" id="sq" name="sq" value="<?php echo $sq?>" class="frm_input" />
    <input type="submit" value="검색"  class="btn_submit" style=" background:#a2de14; font-weight:700; width:80px; padding:10px; border-radius:4px; font-size:14px;"/>
    <input type="button" value="재설정" onclick="resetsq()"  class="btn_submit" style=" background:#a2de14; font-weight:700; width:80px; padding:10px; border-radius:4px; font-size:14px;" />
    <span id="search_cnt"></span><br />
</form>
<br />

<?
function get_os($agent)
{
    $agent = strtolower($agent);

    //echo $agent; echo "<br/>";

    if (preg_match("/windows 98/", $agent))                 { $s = "98"; }
    else if(preg_match("/windows 95/", $agent))             { $s = "95"; }
    else if(preg_match("/windows nt 4\.[0-9]*/", $agent))   { $s = "NT"; }
    else if(preg_match("/windows nt 5\.0/", $agent))        { $s = "2000"; }
    else if(preg_match("/windows nt 5\.1/", $agent))        { $s = "XP"; }
    else if(preg_match("/windows nt 5\.2/", $agent))        { $s = "2003"; }
    else if(preg_match("/windows nt 6\.0/", $agent))        { $s = "Vista"; }
    else if(preg_match("/windows nt 6\.1/", $agent))        { $s = "윈도우"; }
    else if(preg_match("/windows 9x/", $agent))             { $s = "ME"; }
    else if(preg_match("/windows ce/", $agent))             { $s = "CE"; }
    else if(preg_match("/mac/", $agent) && 
            preg_match("/iphone/", $agent))                 { $s = "아이폰"; }
    else if(preg_match("/mac/", $agent))                    { $s = "맥"; }
    else if(preg_match("/linux/", $agent) &&
            preg_match("/android/", $agent))                { $s = "안드로이드"; }
    else if(preg_match("/linux/", $agent))                  { $s = "Linux"; }
    else if(preg_match("/sunos/", $agent))                  { $s = "sunOS"; }
    else if(preg_match("/irix/", $agent))                   { $s = "IRIX"; }
    else if(preg_match("/phone/", $agent))                  { $s = "Phone"; }
    else if(preg_match("/bot|slurp/", $agent))              { $s = "Robot"; }
    else if(preg_match("/internet explorer/", $agent))      { $s = "IE"; }
    else if(preg_match("/mozilla/", $agent))                { $s = "크롬"; }
    else { $s = "기타"; }

    return $s;
}
    
// vi_referer에서 사이트 찾고, vi_date로 범위 정하기, 정렬은 vi_id 역순 (속도 개선 필요)
if(in_array($site_ori, $site_arr)) {
    $where1 = "vi_referer LIKE '{$surl_arr[$site_ori]}' ";
}
else { // 5개 사이트 모두 포함
    $where1 = " ( ";
    foreach($surl_arr as $site => $surl) {
        $where1 .= " vi_referer LIKE '$surl' OR ";
    }
    $where1 .= " 0 )";
}

// $query = sql_query("select * from `$g5[visit_table]` where $where1 AND vi_date>='$datefrom' AND vi_date<='$dateto' order by vi_id desc");

$sql  = " select * from {$g5['visit_table']} where $where1 AND vi_date>='$datefrom' AND vi_date<='$dateto' ";
$sql .= " order by vi_id desc ";
// $sql .= " limit 0,101 ";
$query= sql_query($sql);

?>
<div class="tbl_head01 tbl_wrap" style="display: inline-block; width:100%;">
<table>
    <caption><?php echo $g5['title']; ?> 목록</caption>
<thead>
<tr>
    <th scope="col">날짜</th>
    <th scope="col">사이트</th>
    <th scope="col">검색어</th>
    <th scope="col">IP</th>
    <th scope="col">AGENT</th>
</tr>
</thead>
<tbody>

<?
$cnt = 0;
$cnt2 = array();

while($row = sql_fetch_array($query)) {
    // 어느 사이트인지 찾기
    foreach($surl_arr as $site => $surl) {
        if(strstr($row['vi_referer'], str_replace("%", "", $surl))) {
            $engine = $site;
            break;
        }
    }
    // 검색문자열 찾기
    $regex = "/(\?|&){$svar_arr[$engine]}\=([^&]*)/i";
    preg_match($regex, $row['vi_referer'], $matches);
    $querystr = $matches[2];
    // 보통 검색어 사이를 +로 넘긴다
    $querystr = str_replace("+", " ", $querystr);
    // %ab 이런 식으로 된 걸 바꿔주기
    $querystr = urldecode($querystr);
    // 네이버는 unicode로 된 경우도 있어서
    if($engine=="Naver") $querystr = utf8_urldecode($querystr);
    // 캐릭터셋이 EUC-KR인 경우는 UTF-8로 고치기 (EUC-KR 유저는 UTF-8과 EUC-KR를 서로 바꿔주면 될 듯)
    $charset = mb_detect_encoding($querystr, "ASCII, UTF-8, EUC-KR");
    if($charset=="EUC-KR") $querystr = iconv("EUC-KR", "UTF-8", $querystr);
    // 자잘한 처리들
    $querystr = trim($querystr);
    $querystr = htmlspecialchars($querystr);
    // 가끔 빈 것들도 있다 -_-
    if(!strlen($querystr)) continue;
    
if($row['vi_ip'] == "124.111.187.193") { $row['vi_ip'] = "내부아이피"; }
    // 에코
    echo "<tr><td style='width:320px;'>".$row['vi_date']." ".$row['vi_time']."</td>";
    echo "<td style='width:80px;'><a href=\"$PHP_SELF?site=$engine\"><img src=\"/adm/img/".strtolower($engine).".jpg\" /></a></td>";
    echo "<td style=\"text-align:left\" id=\"m3sqtd[$cnt]\"><a href=\"$row[vi_referer]\" target=\"_blank\">$querystr</a></td>";
    echo "<td style=\"text-align:left; width:120px;\">".$row['vi_ip']."</td>";
    echo "<td style=\"text-align:left; width:120px;\">".get_os($row['vi_agent'])."</td></tr>\n";
    // 카운트용 변수
    $cnt++;
    $cnt2[$engine]++;
}
ksort($cnt2);

// 베짱이님 제공 함수
function utf8_urldecode($str, $chr_set='CP949') {
    $callback_function = create_function('$matches, $chr_set="'.$chr_set.'"', 'return iconv("UTF-16BE", $chr_set, pack("n*", hexdec($matches[1])));');
    return rawurldecode(preg_replace_callback('/%u([[:alnum:]]{4})/', $callback_function, $str));
} 

?>
    </tbody>
</table>
</div>
<br />
Total : <?php echo $days=(strtotime($dateto)-strtotime($datefrom))/(24*60*60)+1?> days, <?php echo $cnt?> results (<?=sprintf("%.1f",$cnt/$days)?>/day)<br />
<? if(!$site_ori) { // 모든 사이트의 경우 비율 분석
    foreach($cnt2 as $engine => $count) {
        echo "$engine : $count (".sprintf("%.1f",$count/$cnt*100)."%)<br />";
    }
}?>

</div>

<script type="text/javascript">
function findsq(sq) {
    if(sq=="") return;
    var i = 0;
    var search_cnt = 0; // 결과내 검색 개수
    while(a = document.getElementById("m3sqtd["+i+"]")) {
        if(a.innerText.toLowerCase().match(sq.toLowerCase())) { // 찾는 값이 있으면 보이기
            a.parentNode.style.display="";
            search_cnt++;
        } else { // 찾는 값이 없으면 숨기기
            a.parentNode.style.display="none";
        }
        i++;
    }
    document.getElementById("search_cnt").innerText = "결과내 검색 : " + search_cnt + "건";
}
function resetsq() {
    var i = 0;
    while(a = document.getElementById("m3sqtd["+i+"]")) {
        a.parentNode.style.display=""; // 모든 행의 display 속성 reset
        i++;
    }
    document.getElementById("search_cnt").innerText = "";
    document.getElementById("sq").value = "";
}
</script>
<?php
include_once('./admin.tail.php');
?>