OLDBOY/adm/sms_admin/num_book.php



<title>OLDBOY/adm/sms_admin/num_book.php</title>


<div class="header">OLDBOY/adm/sms_admin/num_book.php</div>
<pre>&lt;?php
$sub_menu = &quot;900800&quot;;
include_once(&quot;./_common.php&quot;);

$page_size = 20;
$colspan = 9;

auth_check_menu($auth, $sub_menu, &quot;r&quot;);

$token = get_token();

$g5[&#039;title&#039;] = &quot;휴대폰번호 관리&quot;;

if ($page &lt; 1) $page = 1;

$bg_no = isset($_REQUEST[&#039;bg_no&#039;]) ? preg_replace(&#039;/[^0-9]/i&#039;, &#039;&#039;, $_REQUEST[&#039;bg_no&#039;]) : &#039;&#039;;
$st = isset($_REQUEST[&#039;st&#039;]) ? preg_replace(&#039;/[^a-z0-9]/i&#039;, &#039;&#039;, $_REQUEST[&#039;st&#039;]) : &#039;&#039;;

$sql_korean = $sql_group = $sql_search = $sql_no_hp = &#039;&#039;;

if (is_numeric($bg_no) &amp;&amp; $bg_no)
    $sql_group = &quot; and bg_no=&#039;$bg_no&#039; &quot;;
else
    $sql_group = &quot;&quot;;

if ($st == &#039;all&#039;) {
    $sql_search = &quot;and (bk_name like &#039;%{$sv}%&#039; or bk_hp like &#039;%{$sv}%&#039;)&quot;;
} else if ($st == &#039;name&#039;) {
    $sql_search = &quot;and bk_name like &#039;%{$sv}%&#039;&quot;;
} else if ($st == &#039;hp&#039;) {
    $sql_search = &quot;and bk_hp like &#039;%{$sv}%&#039;&quot;;
} else {
    $sql_search = &#039;&#039;;
}

$ap = isset($_GET[&#039;ap&#039;]) ? (int) $_GET[&#039;ap&#039;] : 0;
$no_hp = isset($_GET[&#039;no_hp&#039;]) ? preg_replace(&#039;/[^0-9a-z_]/i&#039;, &#039;&#039;, $_GET[&#039;no_hp&#039;]) : 0;

if ($ap &gt; 0)
    $sql_korean = korean_index(&#039;bk_name&#039;, $ap-1);
else {
    $sql_korean = &#039;&#039;;
    $ap = 0;
}

if ($no_hp == &#039;yes&#039;) {
    set_cookie(&#039;cookie_no_hp&#039;, &#039;yes&#039;, 60*60*24*365);
    $no_hp_checked = &#039;checked&#039;;
} else if ($no_hp == &#039;no&#039;) {
    set_cookie(&#039;cookie_no_hp&#039;, &#039;&#039;, 0);
    $no_hp_checked = &#039;&#039;;
} else {
    if (get_cookie(&#039;cookie_no_hp&#039;) == &#039;yes&#039;)
        $no_hp_checked = &#039;checked&#039;;
    else
        $no_hp_checked = &#039;&#039;;
}

if ($no_hp_checked == &#039;checked&#039;)
    $sql_no_hp = &quot;and bk_hp &lt;&gt; &#039;&#039;&quot;;

$total_res = sql_fetch(&quot;select count(*) as cnt from {$g5[&#039;sms5_book_table&#039;]} where 1 $sql_group $sql_search $sql_korean $sql_no_hp&quot;);
$total_count = $total_res[&#039;cnt&#039;];

$total_page = (int)($total_count/$page_size) + ($total_count%$page_size==0 ? 0 : 1);
$page_start = $page_size * ( $page - 1 );

$vnum = $total_count - (($page-1) * $page_size);

$res = sql_fetch(&quot;select count(*) as cnt from {$g5[&#039;sms5_book_table&#039;]} where bk_receipt=1 $sql_group $sql_search $sql_korean $sql_no_hp&quot;);
$receipt_count = $res[&#039;cnt&#039;];
$reject_count = $total_count - $receipt_count;

$res = sql_fetch(&quot;select count(*) as cnt from {$g5[&#039;sms5_book_table&#039;]} where mb_id=&#039;&#039; $sql_group $sql_search $sql_korean $sql_no_hp&quot;);
$no_member_count = $res[&#039;cnt&#039;];
$member_count = $total_count - $no_member_count;

$no_group = sql_fetch(&quot;select * from {$g5[&#039;sms5_book_group_table&#039;]} where bg_no = 1&quot;);

$group = array();
$qry = sql_query(&quot;select * from {$g5[&#039;sms5_book_group_table&#039;]} where bg_no&gt;1 order by bg_name&quot;);
while ($res = sql_fetch_array($qry)) array_push($group, $res);

include_once(G5_ADMIN_PATH.&#039;/admin.head.php&#039;);
?&gt;

&lt;script&gt;

function book_all_checked(chk)
{
    if (chk) {
        jQuery(&#039;[name=&quot;bk_no[]&quot;]&#039;).attr(&#039;checked&#039;, true);
    } else {
        jQuery(&#039;[name=&quot;bk_no[]&quot;]&#039;).attr(&#039;checked&#039;, false);
    }
}

function no_hp_click(val)
{
    var url = &#039;./num_book.php?bg_no=&lt;?php echo $bg_no?&gt;&amp;st=&lt;?php echo $st?&gt;&amp;sv=&lt;?php echo $sv?&gt;&#039;;

    if (val == true)
        location.href = url + &#039;&amp;no_hp=yes&#039;;
    else
        location.href = url + &#039;&amp;no_hp=no&#039;;
}
&lt;/script&gt;

&lt;div class=&quot;local_ov01 local_ov&quot;&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt;업데이트 &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt;&lt;?php echo isset($sms5[&#039;cf_datetime&#039;]) ? $sms5[&#039;cf_datetime&#039;] : &#039;&#039;; ?&gt;&lt;/span&gt;&lt;/span&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt; 건수  &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt;&lt;?php echo number_format($total_count)?&gt;명&lt;/span&gt;&lt;/span&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt; 회원  &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt; &lt;?php echo number_format($member_count)?&gt;명&lt;/span&gt;&lt;/span&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt; 비회원  &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt; &lt;?php echo number_format($no_member_count)?&gt;명&lt;/span&gt;&lt;/span&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt; 수신  &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt; &lt;?php echo number_format($receipt_count)?&gt;명&lt;/span&gt;&lt;/span&gt;
    &lt;span class=&quot;btn_ov01&quot;&gt;&lt;span class=&quot;ov_txt&quot;&gt; 거부  &lt;/span&gt;&lt;span class=&quot;ov_num&quot;&gt; &lt;?php echo number_format($reject_count)?&gt;명&lt;/span&gt;&lt;/span&gt;
&lt;/div&gt;

&lt;form name=&quot;search_form&quot; method=&quot;get&quot; action=&quot;&lt;?php echo $_SERVER[&#039;SCRIPT_NAME&#039;]?&gt;&quot; class=&quot;local_sch01 local_sch&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;bg_no&quot; value=&quot;&lt;?php echo $bg_no?&gt;&quot; &gt;
&lt;label for=&quot;st&quot; class=&quot;sound_only&quot;&gt;검색대상&lt;/label&gt;
&lt;select name=&quot;st&quot; id=&quot;st&quot;&gt;
    &lt;option value=&quot;all&quot;&lt;?php echo get_selected(&#039;all&#039;, $st); ?&gt;&gt;이름 + 휴대폰번호&lt;/option&gt;
    &lt;option value=&quot;name&quot;&lt;?php echo get_selected(&#039;name&#039;, $st); ?&gt;&gt;이름&lt;/option&gt;
    &lt;option value=&quot;hp&quot; &lt;?php echo get_selected(&#039;hp&#039;, $st); ?&gt;&gt;휴대폰번호&lt;/option&gt;
&lt;/select&gt;
&lt;label for=&quot;sv&quot; class=&quot;sound_only&quot;&gt;검색어&lt;strong class=&quot;sound_only&quot;&gt; 필수&lt;/strong&gt;&lt;/label&gt;
&lt;input type=&quot;text&quot; name=&quot;sv&quot; value=&quot;&lt;?php echo $sv?&gt;&quot; id=&quot;sv&quot; required class=&quot;frm_input required&quot;&gt;
&lt;input type=&quot;submit&quot; value=&quot;검색&quot; class=&quot;btn_submit&quot;&gt;
&lt;/form&gt;

&lt;form name=&quot;search_form&quot; class=&quot;local_sch01 local_sch&quot;&gt;
&lt;label for=&quot;bg_no&quot; class=&quot;sound_only&quot;&gt;그룹명&lt;/label&gt;
&lt;select name=&quot;bg_no&quot; id=&quot;bg_no&quot; onchange=&quot;location.href=&#039;&lt;?php echo $_SERVER[&#039;SCRIPT_NAME&#039;]?&gt;?bg_no=&#039;+this.value;&quot;&gt;
    &lt;option value=&quot;&quot;&lt;?php echo get_selected(&#039;&#039;, $bg_no); ?&gt;&gt; 전체 &lt;/option&gt;
    &lt;option value=&quot;&lt;?php echo $no_group[&#039;bg_no&#039;]?&gt;&quot;&lt;?php echo get_selected($no_group[&#039;bg_no&#039;], $bg_no); ?&gt;&gt; &lt;?php echo $no_group[&#039;bg_name&#039;]?&gt; (&lt;?php echo number_format($no_group[&#039;bg_count&#039;])?&gt; 명) &lt;/option&gt;
    &lt;?php for($i=0; $i&lt;count($group); $i++) {?&gt;
    &lt;option value=&quot;&lt;?php echo $group[$i][&#039;bg_no&#039;]?&gt;&quot;&lt;?php echo get_selected($group[$i][&#039;bg_no&#039;], $bg_no);?&gt;&gt; &lt;?php echo $group[$i][&#039;bg_name&#039;]?&gt; (&lt;?php echo number_format($group[$i][&#039;bg_count&#039;])?&gt; 명) &lt;/option&gt;
    &lt;?php } ?&gt;
&lt;/select&gt;
&lt;input type=&quot;checkbox&quot; name=&quot;no_hp&quot; id=&quot;no_hp&quot; &lt;?php echo $no_hp_checked?&gt; onclick=&quot;no_hp_click(this.checked)&quot;&gt;
&lt;label for=&quot;no_hp&quot;&gt;휴대폰 소유자만 보기&lt;/label&gt;
&lt;/form&gt;


&lt;form name=&quot;hp_manage_list&quot; id=&quot;hp_manage_list&quot; method=&quot;post&quot; action=&quot;./num_book_multi_update.php&quot; onsubmit=&quot;return hplist_submit(this);&quot; &gt;
&lt;input type=&quot;hidden&quot; name=&quot;page&quot; value=&quot;&lt;?php echo $page; ?&gt;&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;token&quot; value=&quot;&lt;?php echo $token; ?&gt;&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;sw&quot; value=&quot;&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;atype&quot; value=&quot;del&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;str_query&quot; value=&quot;&lt;?php echo clean_query_string($_SERVER[&#039;QUERY_STRING&#039;]); ?&gt;&quot; &gt;

&lt;div class=&quot;tbl_head01 tbl_wrap&quot;&gt;
    &lt;table&gt;
    &lt;caption&gt;&lt;?php echo $g5[&#039;title&#039;]; ?&gt; 목록&lt;/caption&gt;
    &lt;thead&gt;
    &lt;tr&gt;
        &lt;th scope=&quot;col&quot;&gt;
            &lt;label for=&quot;chk_all&quot; class=&quot;sound_only&quot;&gt;현재 페이지 전체&lt;/label&gt;
            &lt;input type=&quot;checkbox&quot; id=&quot;chk_all&quot; onclick=&quot;book_all_checked(this.checked)&quot;&gt;
        &lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;번호&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;그룹&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;이름&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;휴대폰&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;수신&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;아이디&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;업데이트&lt;/th&gt;
        &lt;th scope=&quot;col&quot;&gt;관리&lt;/th&gt;
    &lt;/tr&gt;
    &lt;/thead&gt;
    &lt;tbody&gt;
    &lt;?php if (!$total_count) { ?&gt;
    &lt;tr&gt;
        &lt;td colspan=&quot;&lt;?php echo $colspan?&gt;&quot; class=&quot;empty_table&quot;&gt;데이터가 없습니다.&lt;/td&gt;
    &lt;/tr&gt;
    &lt;?php
    }
    $line = 0;
    $qry = sql_query(&quot;select * from {$g5[&#039;sms5_book_table&#039;]} where 1 $sql_group $sql_search $sql_korean $sql_no_hp order by bk_no desc limit $page_start, $page_size&quot;);
    // while($res = sql_fetch_array($qry))
    for ($i=0; $res = sql_fetch_array($qry); $i++) 
    {
        $bg = &#039;bg&#039;.($line++%2);

        $tmp = sql_fetch(&quot;select bg_name from {$g5[&#039;sms5_book_group_table&#039;]} where bg_no=&#039;{$res[&#039;bg_no&#039;]}&#039;&quot;);
        $group_name = $tmp[&#039;bg_name&#039;];
    ?&gt;
    &lt;tr class=&quot;&lt;?php echo $bg; ?&gt;&quot;&gt;
        &lt;td class=&quot;td_chk&quot;&gt;
            &lt;label for=&quot;bk_no_&lt;?php echo $i; ?&gt;&quot; class=&quot;sound_only&quot;&gt;&lt;?php echo $group_name?&gt;의 &lt;?php echo get_text($res[&#039;bk_name&#039;]) ?&gt;&lt;/label&gt;
            &lt;input type=&quot;checkbox&quot; name=&quot;bk_no[]&quot; value=&quot;&lt;?php echo $res[&#039;bk_no&#039;]?&gt;&quot; id=&quot;bk_no_&lt;?php echo $i; ?&gt;&quot;&gt;
        &lt;/td&gt;
        &lt;td class=&quot;td_num&quot;&gt;&lt;?php echo number_format($vnum--)?&gt;&lt;/td&gt;
        &lt;td&gt;&lt;?php echo $group_name?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_mbname&quot;&gt;&lt;?php echo get_text($res[&#039;bk_name&#039;]) ?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_numbig&quot;&gt;&lt;?php echo $res[&#039;bk_hp&#039;]?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_boolean&quot;&gt;&lt;?php echo $res[&#039;bk_receipt&#039;] ? &#039;&lt;font color=blue&gt;수신&lt;/font&gt;&#039; : &#039;&lt;font color=red&gt;거부&lt;/font&gt;&#039;?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_mbid&quot;&gt;&lt;?php echo $res[&#039;mb_id&#039;] ? $res[&#039;mb_id&#039;] : &#039;비회원&#039;?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_datetime&quot;&gt;&lt;?php echo $res[&#039;bk_datetime&#039;]?&gt;&lt;/td&gt;
        &lt;td class=&quot;td_mng td_mng_l&quot;&gt;
            &lt;a href=&quot;./num_book_write.php?w=u&amp;amp;bk_no=&lt;?php echo $res[&#039;bk_no&#039;]?&gt;&amp;amp;page=&lt;?php echo $page?&gt;&amp;amp;bg_no=&lt;?php echo $bg_no?&gt;&amp;amp;st=&lt;?php echo $st?&gt;&amp;amp;sv=&lt;?php echo $sv?&gt;&amp;amp;ap=&lt;?php echo $ap?&gt;&quot; class=&quot;btn btn_03&quot;&gt;수정&lt;/a&gt;
            &lt;a href=&quot;./sms_write.php?bk_no=&lt;?php echo $res[&#039;bk_no&#039;]?&gt;&quot; class=&quot;btn btn_02&quot;&gt;보내기&lt;/a&gt;
            &lt;a href=&quot;./history_num.php?st=hs_hp&amp;amp;sv=&lt;?php echo $res[&#039;bk_hp&#039;]?&gt;&quot; class=&quot;btn btn_02&quot;&gt;내역&lt;/a&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;?php } ?&gt;
    &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;
&lt;div class=&quot;btn_fixed_top&quot;&gt;
    &lt;input type=&quot;submit&quot; name=&quot;act_button&quot; value=&quot;선택삭제&quot; onclick=&quot;document.pressed=this.value&quot; class=&quot;btn btn_02&quot;&gt;
    &lt;input type=&quot;submit&quot; name=&quot;act_button&quot; value=&quot;수신허용&quot; onclick=&quot;document.pressed=this.value&quot; class=&quot;btn btn_02&quot;&gt;
    &lt;input type=&quot;submit&quot; name=&quot;act_button&quot; value=&quot;수신거부&quot; onclick=&quot;document.pressed=this.value&quot; class=&quot;btn btn_02&quot;&gt;
    &lt;input type=&quot;submit&quot; name=&quot;act_button&quot; value=&quot;선택이동&quot; onclick=&quot;document.pressed=this.value&quot; class=&quot;btn btn_02&quot;&gt;
    &lt;input type=&quot;submit&quot; name=&quot;act_button&quot; value=&quot;선택복사&quot; onclick=&quot;document.pressed=this.value&quot; class=&quot;btn btn_02&quot;&gt;
    &lt;a href=&quot;./num_book_write.php?page=&lt;?php echo $page?&gt;&amp;amp;bg_no=&lt;?php echo $bg_no?&gt;&quot; class=&quot;btn btn_01&quot;&gt;번호추가&lt;/a&gt;
&lt;/div&gt;
&lt;/form&gt;
&lt;script&gt;
function hplist_submit(f){
    if (!is_checked(&quot;bk_no[]&quot;)) {
        alert(document.pressed+&quot; 하실 항목을 하나 이상 선택하세요.&quot;);
        return false;
    }
    if(document.pressed == &quot;선택이동&quot;) {
        select_copy(&quot;move&quot;, f);
        return;
    }
    if(document.pressed == &quot;선택복사&quot;) {
        select_copy(&quot;copy&quot;, f);
        return;
    }
    if(document.pressed == &quot;선택삭제&quot;) {
        if(!confirm(&quot;선택한 자료를 정말 삭제하시겠습니까?&quot;)) {
            return false;
        }
    }
    if(document.pressed == &quot;수신허용&quot;) {
        f.atype.value=&quot;receipt&quot;;
    }
    if(document.pressed == &quot;수신거부&quot;) {
        f.atype.value=&quot;reject&quot;;
    }
    return true;
}
// 선택한 이모티콘 그룹 이동
function select_copy(sw, f) {
    if( !f ){
        var f = document.emoticonlist;
    }
    if (sw == &quot;copy&quot;)
        str = &quot;복사&quot;;
    else
        str = &quot;이동&quot;;

    var sub_win = window.open(&quot;&quot;, &quot;move&quot;, &quot;left=50, top=50, width=500, height=550, scrollbars=1&quot;);

    f.sw.value = sw;
    f.target = &quot;move&quot;;
    f.action = &quot;./num_book_move.php&quot;;
    f.submit();
}
&lt;/script&gt;

&lt;?php echo get_paging(G5_IS_MOBILE ? $config[&#039;cf_mobile_pages&#039;] : $config[&#039;cf_write_pages&#039;], $page, $total_page, $_SERVER[&#039;SCRIPT_NAME&#039;].&quot;?bg_no=$bg_no&amp;amp;st=$st&amp;amp;sv=$sv&amp;amp;ap=$ap&amp;amp;page=&quot;); ?&gt;

&lt;?php
include_once(G5_ADMIN_PATH.&#039;/admin.tail.php&#039;);</pre>