webadmin.php

/home/mjc1/public_html/adm/member_group_list.php

<?php
$sub_menu = "200130";
include_once('./_common.php');

if ($is_admin != 'super')
    alert('최고관리자만 접근 가능합니다.');

$token = get_token();

$sql_common = " from {$g5['member_group']} ";

$sql_search = " where (1) ";
if ($stx) {
    $sql_search .= " and ( ";
    switch ($sfl) {
        default :
            $sql_search .= " ({$sfl} like '%{$stx}%') ";
            break;
    }
    $sql_search .= " ) ";
}

if (!$sst) {
    $sst  = " mg_seq ";
    $sod = "";
}
$sql_order = " order by $sst $sod ";

$sql = " select count(*) as cnt
            {$sql_common}
            {$sql_search}
            {$sql_order} ";
$row = sql_fetch($sql);
$total_count = $row['cnt'];

$rows = $config['cf_page_rows'];
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if ($page < 1) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$sql = " select *
            {$sql_common}
            {$sql_search}
            {$sql_order}
            limit {$from_record}, {$rows} ";
$result = sql_query($sql);

//echo $sql;

$listall = '<a href="'.$_SERVER['PHP_SELF'].'" class="ov_listall">전체목록</a>';

$g5['title'] = "회원등급설정";
include_once('./admin.head.php');

$colspan = 6;
?>
<style>
    #add_admin .tbl_frm01 table th { font-size:12px; }
    #add_admin .tbl_frm01 table td { font-size:12px; }
    #tr_hidden { display:none; }
</style>

<span style='<?php if($add=='y'){?>display:none;<?php }?>'>

<div class="local_ov01 local_ov">
    <?php echo $listall ?>
    등급 <?php echo number_format($total_count) ?>건
</div>

<form name="fsearch" id="fsearch" class="local_sch01 local_sch" method="get">
<input type="hidden" name="sfl" value="a.mb_id" id="sfl">

<label for="stx" class="sound_only">회원아이디<strong class="sound_only"> 필수</strong></label>
<input type="text" name="stx" value="<?php echo $stx ?>" id="stx" required class="required frm_input">
<input type="submit" value="검색" id="fsearch_submit" class="btn_submit">
<input type="button" value="등급추가" id="fsearch_add" class="btn_submit">

</form>

<form name="fauthlist" id="fauthlist" method="post" action="./member_group_update.php" onsubmit="return fauthlist_submit(this);">
<input type="hidden" name="sst" value="<?php echo $sst ?>">
<input type="hidden" name="sod" value="<?php echo $sod ?>">
<input type="hidden" name="sfl" value="<?php echo $sfl ?>">
<input type="hidden" name="stx" value="<?php echo $stx ?>">
<input type="hidden" name="page" value="<?php echo $page ?>">
<input type="hidden" name="token" value="<?php echo $token ?>">

<div class="tbl_head01 tbl_wrap">
    <table>
    <caption><?php echo $g5['title']; ?> 목록</caption>
    <thead>
    <tr>
        <th scope="col">
            <label for="chkall" class="sound_only">등급 전체</label>
            <input type="checkbox" name="chkall" value="1" id="chkall" onclick="check_all(this.form)">
        </th>
        <th scope="col">등급명</th>
        <th scope="col">등급설명</th>
        <th scope="col">단가적용</th>
        <th scope="col">단가 %</th>
        <th scope="col">순번</th>
        <th scope="col">회원수</th>
        <th scope="col">관리</th>
    </tr>
    </thead>
    <tbody>
    <?php
    $count = 0;
    for ($i=0; $row=sql_fetch_array($result); $i++)
    {
        $bg = 'bg'.($i%2);
        $sql = "select count(*) as cnt from {$g5['member_table']} where mb_1 = '{$row['mg_no']}' ";
        $mg_info = sql_fetch($sql);
    ?>
    <tr class="<?php echo $bg; ?>">
        <td class="td_chk">
            <input type="hidden" name="mg_no[<?php echo $i ?>]" value="<?php echo $row['mg_no'] ?>">
            <input type="checkbox" name="chk[]" value="<?php echo $i ?>" id="chk_<?php echo $i ?>">
        </td>
        <td class="td_mbid"><?php echo $row['mg_name'] ?></td>
        <td class="td_auth_mbnick"><?php echo $row['mg_memo'] ?></td>
        <td class="td_mbid"><?php if($row['mg_danga_use']=='1'){ echo "Y"; } else { echo "N"; } ?></td>
        <td class="td_mbid"><?php echo $row['mg_danga_per'] ?> %</td>
        <td class="td_mbid"><?php echo $row['mg_seq'] ?></td>
        <td class="td_mbid"><?php echo $mg_info['cnt'] ?></td>
        <td class="td_auth"><a href='?mg_no=<?php echo $row['mg_no'] ?>&<?php echo $qstr;?>'>[수정]</a></td>
    </tr>
    <?php
        $count++;
    }

    if ($count == 0)
        echo '<tr><td colspan="'.$colspan.'" class="empty_table">자료가 없습니다.</td></tr>';
    ?>
    </tbody>
    </table>
</div>

<div class="btn_list01 btn_list">
    <input type="submit" name="act_button" value="선택삭제" onclick="document.pressed=this.value">
</div>

<?php
//if (isset($stx))
//    echo '<script>document.fsearch.sfl.value = "'.$sfl.'";</script>'."\n";

if (strstr($sfl, 'mb_id'))
    $mb_id = $stx;
else
    $mb_id = '';
?>
</form>

</span>
<?php
$pagelist = get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, $_SERVER['PHP_SELF'].'?'.$qstr.'&amp;page=');
echo $pagelist;

$mg_danga_per = 100;

if($mg_no!=''){
    $sql = "select * from {$g5['member_group']} where mg_no = '{$mg_no}'";
    $mg_info = sql_fetch($sql);
    $mg_name = $mg_info['mg_name'];
    $mg_memo = $mg_info['mg_memo'];
    $mg_seq = $mg_info['mg_seq'];
    $mg_payment = $mg_info['mg_payment'];
    $mg_point = $mg_info['mg_point'];
    $mg_point_price = $mg_info['mg_point_price'];
    $mg_point_price_get = $mg_info['mg_point_price_get'];
    $mg_save = $mg_info['mg_save'];
    $mg_save_price = $mg_info['mg_save_price'];
    $mg_save_price_get = $mg_info['mg_save_price_get'];
    $mg_img = $mg_info['mg_img'];
    $mg_danga_use = $mg_info['mg_danga_use'];
    $mg_danga_per = $mg_info['mg_danga_per'];
}

?>

<form name="fauthlist2" id="fauthlist2" action="./member_group_update.php" method="post" autocomplete="off" onsubmit='return false;' enctype="multipart/form-data">
<input type="hidden" name="sfl" value="<?php echo $sfl ?>">
<input type="hidden" name="stx" value="<?php echo $stx ?>">
<input type="hidden" name="sst" value="<?php echo $sst ?>">
<input type="hidden" name="sod" value="<?php echo $sod ?>">
<input type="hidden" name="page" value="<?php echo $page ?>">
<input type="hidden" name="token" value="<?php echo $token ?>">
<input type="hidden" name="mg_no" value="<?php echo $mg_no ?>">

<section id="add_admin">
    <h2 class="h2_frm">회원 등급 추가</h2>

    <div class="local_desc01 local_desc">
        <p>
            다음 양식에서 회원등급을 추가하실 수 있습니다.
        </p>
    </div>

    <div class="tbl_frm01 tbl_wrap">
        <table>
        <colgroup>
            <col class="grid_4">
            <col>
        </colgroup>
        <tbody>
        <tr>
            <th scope="row"><label for="mb_id">등급명<strong class="sound_only">필수</strong></label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="text" name="mg_name" value="<?php echo $mg_name ?>" id="mg_name" required class="required frm_input">
            </td>
        </tr>
        <tr>
            <th scope="row"><label for="mb_id">등급설명</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="text" name="mg_memo" value="<?php echo $mg_memo ?>" id="mg_memo" required class="frm_input" size=80%>
            </td>
        </tr>
        <tr>
            <th scope="row"><label for="mb_id">등급 단가 적용</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="radio" name="mg_danga_use" value="0" id="mg_danga_use" <?php echo ($mg_danga_use=='0' || $mg_danga_use=='')?"checked":"";?>>  단가변동 미 사용 &nbsp;
                <input type="radio" name="mg_danga_use" value="1" id="mg_danga_use" <?php echo ($mg_danga_use=='1')?"checked":"";?>>  단가변동 사용 &nbsp;
            </td>
        </tr>
        <tr>
            <th scope="row"><label for="mb_id">등급 단가 %</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="text" name="mg_danga_per" value="<?php echo $mg_danga_per ?>" id="mg_danga_per" required class="frm_input" size=5> %
                <br><br> 실수나 오류로 인해서 0%를 적용했을때는 단가오류를 방지하기 위해서 100%으로 적용됩니다.
            </td>
        </tr>
        <tr>
            <th scope="row"><label for="mb_id">순번</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="text" name="mg_seq" value="<?php echo $mg_seq ?>" id="mg_seq" required class="frm_input" >
                &nbsp; 낮을수록 상위 표시
            </td>
        </tr>
        <tr id='tr_hidden'>
            <th scope="row"><label for="mb_id">결제조건</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="radio" name="mg_payment" value="A" id="mg_payment" <?php echo ($mg_payment=='A' || $mg_payment=='')?"checked":"";?>>  현금/카드 &nbsp;
                <input type="radio" name="mg_payment" value="B" id="mg_payment" <?php echo ($mg_payment=='B')?"checked":"";?>>  현금만 &nbsp;
                <input type="radio" name="mg_payment" value="C" id="mg_payment" <?php echo ($mg_payment=='C')?"checked":"";?>>  카드 및 기타결제만
            </td>
        </tr>
        <tr id='tr_hidden'>
            <th scope="row"><label for="mb_id">추가적립</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="checkbox" name="mg_point" value="Y" id="mg_point" <?php echo ($mg_point=='Y')?"checked":"";?>> &nbsp;
                회원이 <input type="text" name="mg_point_price" value="<?php echo $mg_point_price ?>" id="mg_point_price" required class="frm_input" size=7>원 이상 구매시,
                <input type="text" name="mg_point_price_get" value="<?php echo $mg_point_price_get ?>" id="mg_point_price_get" required class="frm_input" size=3>% 를 추가 적립함. (장바구니 금액 기준)
            </td>
        </tr>
        <tr id='tr_hidden'>
            <th scope="row"><label for="mb_id">추가할인</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                <input type="checkbox" name="mg_save" value="Y" id="mg_save" <?php echo ($mg_save=='Y')?"checked":"";?>> &nbsp;
                회원이 <input type="text" name="mg_save_price" value="<?php echo $mg_save_price ?>" id="mg_save_price" required class="frm_input" size=7>원 이상 구매시,
                <input type="text" name="mg_save_price_get" value="<?php echo $mg_save_price_get ?>" id="mg_save_price_get" required class="frm_input" size=3>% 를 추가 할인함. (장바구니 금액 기준)
            </td>
        </tr>
        <tr id='tr_hidden'    >
            <th scope="row"><label for="mb_id">등급이미지</label></th>
            <td>
                <strong id="msg_mb_id" class="msg_sound_only"></strong>
                이미지 크기는 넓이 80픽셀 높이 22픽셀로 해주세요. gif 이미지만 가능.<br>
                <input type="file" name="mg_img" value="" id="mg_img" required class="frm_input"><br>
                <?php if($mg_img!=''){ ?>
                    <img src='/data/member/<?php echo "mg_".$mg_no;?>/<?php echo $mg_img;?>';
                <?php }?>
            </td>
        </tr>
        </tbody>
        </table>
    </div>

    <div class="btn_confirm01 btn_confirm">
        <input type="button" value="<?php if($mg_no!=''){?>수정<?php } else {?>저장<?php }?>" class="btn_submit" onclick="add_group()">
    </div>
</section>

</form>

<script>
function add_group(){
    f = document.fauthlist2;
    if(f.mg_name.value==''){
        alert('등급명을 입력하시기 바랍니다.'); return;
    }
    f.submit();
}

$(function(){ // 추가버튼 동작
    $("#fsearch_add").click(function(){
        location.href='member_group_list.php?add=y';
    });
});
</script>

<?php
include_once ('./admin.tail.php');
?>