webadmin.php

/home/mjc1/public_html/ryunen/adm/coupon.php

<?php
$sub_menu = "800300";
include("./_common.php");
include("./auth_check.php"); // 관리자 권한 체크
include($j3_adm_path."/shop_header.php");

$config['popup_reg_type'] = "page"; // jqueryui로 ckeditor를 불러올경우(모달) link박스등이 일부 입력이 안되는 문제(해외에서도 이슈가 있음)가 있어서 모달방식대신 구 page방식으로 변경함

$order_key = 'idx desc'; 

$where = "  ";

if($stx!=''){
    $where .= " and {$sti} like '%{$stx}%' ";
}

$sql  =   "select count(*) as cnt from shop_coupon a WHERE 1=1 $where ";
$result      =    mysql_query($sql,$connect_j3);
$row = mysql_fetch_array($result);
$total_count = $row['cnt'];

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

$sql = "select * from shop_coupon a WHERE 1=1 $where order by $order_key limit $from_record, $list_num";
$result      =    mysql_query($sql,$connect_j3);

//_pr($sql);
while($cus_info=mysql_fetch_array($result)){
    $list_array[] = $cus_info;
}

$qstr = $_SERVER['QUERY_STRING'];

?>
<?php
if($shop_du_size>$limit_mbyte){ 
?>
<script src="<?php echo $j3_lib_url?>/ckeditor-nf/ckeditor.js"></script>
<?php } else { ?>
<script src="<?php echo $j3_lib_url?>/ckeditor/ckeditor.js"></script>
<?php }?>
<div id="wrap" class='container_wrap'>
    <div id="sub-title">
        <h2>쿠폰관리</h2>
        <div class="sub-location">
            <a href="./index.php" class="home"><span class="screen_out">홈</span></a>
            <span class="location-gt"></span>
            <a>통계/마케팅</a>
            <span class="location-gt"></span>
            <a>쿠폰관리</a>
        </div>
    </div>
<!-- 검색영역 -->
    <form name='popup_search_form' method='get'>
    <input type='hidden' name='faq_idx' size='' value='<?php echo $faq_idx;?>'>
    <input type='hidden' name='page' size='' value='<?php echo $page;?>'>
    <div id="sub-contents-area">
        <div class="sub-btn-area">
            <div class="sub-btn">
                <a class="lignt-blue-btn" id='btn_order_new'>신규등록</a><!--<a class="blue-btn">주문복사</a><?php if($Orow['ordstate']==0){ ?><a class="black-btn">전체삭제</a><?php }?><a class="gray-btn" id='buy_print'>인쇄</a><a class="gray-btn" id='xls_down'>엑셀</a>--><a class="black-btn" id='sel_delete'>선택삭제</a>
            </div>
        </div>
        <div class="sub-btn-area">
            <div class="sub-btn sub-btn-search">
                <select name='sti'>
                    <option value='a.cp_id' <?php if($sti=='a.cp_id'){?>selected<?php }?>>쿠폰번호</option>
                    <option value='a.cp_name' <?php if($sti=='a.cp_name'){?>selected<?php }?>>쿠폰명칭</option>
                    <option value='a.cp_desc' <?php if($sti=='a.cp_desc'){?>selected<?php }?>>쿠폰내용</option>
                </select>
                <input type='text' id='stx' name='stx' size='' value='<?php echo $stx;?>' class="stx_class">&nbsp;<a href="#" class="black-btn" id='search_btn_press'>검색</a>
            </div>
        </div>
    </div>
    </form>
<!-- 검색 영영 끝 -->
<!-- 탭 구분 영역 끝 -->
    <div class="item_tab screen_out">
        <div class="item_tab_navi">
<?php 
    foreach($cate_array as $key=>$cate){
        if($cate['idx']==$faq_idx){ $class = "on"; } else { $class = ""; }
?>
            <a value='<?php echo $cate['idx'];?>' class="<?php echo $class;?>"><span><?php echo $cate['faq_cate'];?></span></a>
<?php 
    }
?>
            <!--<a value='2'><span>매입.매출처 관리</span></a>-->
        </div>
    </div><!--//item_tab-->
<!-- 탭 구분 영역 끝 -->

    <form name='popup_list_form' method='post'>
    <input type='hidden' name='sel_del' value=''>
    <input type='hidden' name='b_table' value='<?php echo $b_table;?>'>
    <div class="div-list-area">
        <div class="cust-list-area">
            <table class="order-sheet2">
                <caption class="screen_out">1:1문의 리스트 조회<caption>
                <colgroup>
                <col style="width:30px;">
                <col style="width:50px;"><col style="width:80px;"><col style="width:200px;">
                <col style="width:80px;"><col style="width:80px;">
                <col style="width:80px;"><col style="width:80px;"><col style="width:80px;">
                <col style="width:80px;">
                </colgroup>

                <thead>
                    <tr>
                        <th scope="col"><input type='checkbox' name='ck_all' class='check_all_class'></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><th scope="col">사용여부</th>
                        <th scope="col">발행쿠폰수</th>
                    </tr>
                </thead>
                <tbody>
<?php 
    for($i=0;$i<count($list_array);$i++){ // 게시물 처리
        $info = $list_array[$i];
        if($info['pu_edate']<date("Y-m-d H:i:s",time())){
            $red_font = "style='color:red;'";
        } else {
            $red_font = "";
        }

        $sql = "select count(*) as cnt from shop_coupon_list where cp_id = '{$info['cp_id']}' ";
        $cp_info = sql_fetch($sql,$connect_j3);
?>
                    <tr>
                        <td class="tcenter ">
                            <input type='checkbox' name='code_idx[]' value='<?php echo $i;?>' class='code_idx_class'>
                            <input type='hidden' name='codes[]' value='<?php echo $info['idx'];?>'>
                        </td>
                        <td class="tcenter "><?php echo $info['idx'];?></td>
                        <td class="tcenter click_edit"><?php echo $info['cp_id'];?></td>
                        <td class="linetxt click_edit"><?php echo $info['cp_name'];?></td>
                        <td class="tcenter "><?php echo $info['cp_sdate'];?></td>
                        <td class="tcenter "><?php echo $info['cp_edate'];?></td>
                        <td class="tcenter "><?php echo number_format($info['cp_price']);?></td>
                        <td class="tcenter "><?php echo number_format($info['cp_min']);?></td>
                        <td class="tcenter "><?php echo $info['cp_use'];?></td>
                        <td class="tcenter "><a href='coupon_list.php?biztype=&sti=a.cp_id&stx=<?php echo $info['cp_id'];?>'><?php echo $cp_info['cnt'];?></a></td>
                    </tr>
<?php 
    } 
?>
                </tbody>
            </table>
        </div>
    </div>
    </form>

    <div class='pg_wrap' style='padding-top:0px;'>
        <?php echo get_paging($list_num, $page, $total_page, "?$qstr");?>
    </div>

</div><!--//wrap-->
<script>
var qstr = '<?php echo $qstr;?>';
$(function(){
    $(".item_tab_navi a").click(function(){ //네비게이션 탭 처리
        v = $(this).attr("value");
        $("form[name='popup_search_form'] input[name='popup_idx']").val(v);
        $("form[name='popup_search_form']").submit();
    });

    $(".click_edit").css("cursor","pointer").click(function(){ // 수정
        var code = $(this).closest("tr").find("input[name='codes[]']").val();
        if('<?php echo $config['popup_reg_type']?>'=='page'){
            document.location.href='coupon_reg.php?code='+code+qstr;
        } else {
            popup_add(code);
        }
    });

    $(".sub-btn #btn_order_new").click(function(){ // 신규 버튼
        setsave("qstr",qstr,1);
        if('<?php echo $config['popup_reg_type']?>'=='page'){
            document.location.href='coupon_reg.php';
        } else {
            popup_add('');
        }
    });

    $(".check_all_class").click(function(){ // 전체선택 전체선택 해제
        if($(this).is(":checked")){
            $("input[name='code_idx[]']").prop("checked",true);
        } else {
            $("input[name='code_idx[]']").prop("checked",false);            
        }
    });

    $("#sel_delete").click(function(){ // 선택삭제
        var ck_cnt = 0;
        var v = $("input[name='code_idx[]']").each(function(){
            if($(this).is(":checked")){ ck_cnt++; }
        });
        if(ck_cnt==0){ alert('삭제하실 쿠폰을 선택하세요.'); return; }

        if(confirm('정말로 '+ck_cnt+'개의 쿠폰을 삭제하시겠습니까?')){
            $("input[name='sel_del']").val("Y");
            var form_data = $("form[name='popup_list_form']").serialize();

            $.ajax({type:"post", url:"ajax.coupon_reg_process.php?", data:form_data, async:false, dataType : "xml", 
                success:function(xml){    
                    var v_mode = $(xml).find("mode").text();
                    var v_mode_ok = $(xml).find("mode_ok").text();
                    var v_msg = $(xml).find("msg").text();
                    var v_popup_cnt = $(xml).find("popup_cnt").text();
                    if(v_mode_ok=='Y'){
                        document.location.reload();
                    } else {
                        alert(v_msg);
                    }
                },
                error:function(rtn,status,error){    alert(error);        }
            });
        }
    });

    $(".bbs_write_view").css("cursor","pointer").click(function(){
        $tr_obj = $(this).closest("tr");
        $b_table = $tr_obj.find("input[name='b_tables[]']").val();
        document.location.href='popup.php?b_table='+$b_table;
    });


    $("#search_btn_press").click(function(){ // 검색버튼 누를때
        document.popup_search_form.action='?';
        document.popup_search_form.target = '';
        document.popup_search_form.submit();
    });

});
</script>

<?php
include($j3_adm_path."/shop_footer.php");
?>
<div id="modal_member_box" title="거래처수정" style="display:none;width:100%; height:100%; padding-top:3px;padding-left:3px;background-color:#FFFFFF;position:relative;"></div>