<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "DESIGN");
// 접근 권한 검사
if (!$member[mb_id]) {
    alert("로그인 하십시오.", "./?doc=bbs/mblogin.php&url=" . urlencode("./?doc=$doc"));

}
if ($member[mb_level] <= 3) { 
        alert("정식 회원만 접근가능!", "./");
  exit; }



include "./hunter/hunter.lib.php";
$ht = new Hunter_;

$html_title = "자동차보험 견적신청현황";

include "./hunter/login.php";
include "./hunter/head.php";

$hunter_qstr = "hu_area=$hu_area&hu_jikjong=$hu_jikjong&hu_jiwon=$hu_jiwon&hu_goyong=$hu_goyong&hu_sex=$hu_sex&hu_hakruk=$hu_hakruk&hu_danwi=$hu_danwi&hu_bosu_from=$hu_bosu_from&hu_bosu_to=$hu_bosu_to";

$sql_common = " from $cfg[table_hunter] where 1 ";
if ($hu_name) $sql_common .= " and hu_name = '$hu_name' ";
if ($hu_jumin_from && $hu_jumin_to) $sql_common .= " and hu_jumin between '$hu_jumin_from' and '$hu_jumin_to' ";

// 테이블의 전체 레코드수만 얻음
$sql = " select COUNT(*) " . $sql_common;
$row = sql_fetch($sql);
$total_count = $row[0];
$g_rows = $cfg[page_rows];
// 전체 페이지 계산
$total_page  = ceil($total_count / $g_rows);
// 페이지가 없으면 첫 페이지 (1 페이지)
if ($page == "") $page = 1;
// 시작 레코드 구함
$from_record = ($page - 1) * $g_rows;

$sql = " select * $sql_common order by hu_id desc limit $from_record, $cfg[page_rows] ";
$result = sql_query($sql);

?>

<table width=100%>
<form name=fhunterlist method=get action="./" autocomplete=off>
<input type=hidden name=doc value='<?=$doc?>'>
<tr>
    <td align=center>
        이름&nbsp;<input type=text name=hu_name size=10 maxlength=10 class=input
            value="<? echo $hu[hu_name]?>">&nbsp;&nbsp;
    주민번호앞자리(신청자의 생년월일을 고려 : 700101~801231)&nbsp; <input type=text name=hu_jumin_from size=6 maxlength=6 class=input
            value="<? echo $hu_jumin_from ?>">&nbsp;~&nbsp;<input type=text name=hu_jumin_to size=6 maxlength=6 class=input
            value="<? echo $hu_jumin_to ?>">
        <input type=submit value="  검 색  ">&nbsp;
        <input type=button value="전체" onclick="location='<?="./?doc=$doc"?>'">
     
    </td> 

</tr>
</form>
</table>

<TABLE width='100%' align=center cellpadding=3 cellspacing=1 class=tablebg>
<tr align=center class='ht subject subjectbg'>
    <td><b>이름</b></td>
    <td><b>연락처</b></td>
    <td><b>e-mail</b></td>
    <td><b>주민번호</b></td>
<td><b>신청일</b></td>
   
</tr>
<?
for ($i=0; $row=mysql_fetch_array($result); $i++) {
    $name = cut_str($row[hu_name], 45);
    $tel1 = cut_str($row[hu_tel1], 45);
$tel2 = cut_str($row[hu_tel2], 45);
$tel3 = cut_str($row[hu_tel3], 45);
$email = cut_str($row[hu_email], 45);
$jumin = cut_str($row[hu_jumin], 45);
$datetime = cut_str($row[hu_datetime], 45);
   

    $list = ($i%2);
    echo "
    <tr align=center class='ht list$list'>
        <td><a href='./?doc=hunter/hunterview.php&hu_id=$row[hu_id]'>$name</a> $new</td>
        <td>$tel1-$tel2-$tel3</td>
        <td>$email</td>
        <td>$jumin</td>
<td>$datetime</td>
     
    </tr>\n";
}

if (!$i) {
    echo "<tr class='content contentbg'><td colspan=20 align=center height=100>자료가 없습니다.</td></tr>\n";
}
?>
</table>

<table width=100%>
<tr>
    <td width=30%><a href="./?doc=hunter/hunterform.php">신청자 DB 새로생성</td>
    <td width=70% align=right>
        <?
        echo get_paging($default[de_write_pages], $page, $total_page, $cfg[page_rows], "./?doc=doc&$hunter_qstr&page=");
        ?>

    </td>
</tr>
</table>




<?
include "./hunter/tail.php";
?>