webadmin.php

/home/mjc1/public_html/html/m/freebies_inc.php

<?php 
    $dir = "..";
    include_once($dir."/../common.php");
    include_once("./_common2.php"); 
    
    if(isset($_GET["page"])){
        $page = $_GET["page"];
    }else{
        $page = 1;
    }

    //24.03.13기준 고객id 안나오게 변경, 남상복수정, 홍재원팀장님 요청
?>
<style>
#freebies {width:100%;padding:20px;box-sizing:border-box;margin-top: 10px;}
#freebies h1 {text-align:center;font-family:'gs',sans-serif;font-size:24px;font-weight:bold;margin-bottom:10px;padding-top:30px;border-top:1px dotted #707070;}
#freebies > ul > li {display:flex;justify-content: space-between;padding:10px;box-sizing:border-box;}
.freeb_cont {background-color:#F1F4FF;margin-bottom:2px;}
.freeb_cont:last-child {margin-bottom:0px;}
.freeb_item {font-size:12px;font-family:'맑은 고딕';text-align:center;}
.freeb_h .freeb_item {font-weight:bold;}
.fb_date {width:2.5em;}
.fb_id {width:3.5em;}
.fb_region {min-width:4em;}
.fb_name {text-align:left;width:3em;}
.freeb_h .fb_name {text-align:center;}
.fb_gift {min-width:67px;}
.fb_icon {width:24px;}
/*목록 페이징*/
#freebies nav {text-align:center;margin-top:20px;}
.pagingul {display:flex;justify-content:center;}
.pagingul li {min-width:36px;height:36px;border:1px solid #ccc;border-right:0px;text-align:center;padding:8px;box-sizing:border-box;}
.pagingul li:last-child{border-right:1px solid #ccc;}
.pagingul li a {display:block;font-size:14px;}
.pagingul li.on {background:#FD7921;}
.pagingul li.on a {color:#ffffff;}
.change_back{
    background:#FD7921;
    color:#ffffff;
}
</style>
<div id="freebies_inc">
<section id="freebies">
    <h1 style="margin-bottom: 30px;">
        사은품 발송 리스트
        <!-- <br><span style="text-align: center;font-size: 16px;line-height: 24px;display: inline-block;padding-top: 10px;font-weight: bold;font-family: 'gs',sans-serif;">(만족도, 후기, 소개)</span> -->
    </h1>
    <ul>
        <!--항목헤더-->
        <li class="freeb_h">
            <div class="freeb_item fb_date">발송월</div>
            <!-- <div class="freeb_item fb_id">ID</div> -->
            <div class="freeb_item fb_name">업체명</div>
            <div class="freeb_item fb_region">지역</div>
            <div class="freeb_item fb_gift">사은품</div>
            <div class="freeb_item fb_ship">결과</div>
            <div class="freeb_item fb_icon">방식</div>
        </li>
        <!---->

<?php

    //데이터 취득
    mysql_query("set session character_set_connection=utf8;");
    mysql_query("set session character_set_results=utf8;");
    mysql_query("set session character_set_client=utf8;");

    $sql = "select COUNT(*) as cnt from delBoard WHERE del_result = '1' order by reg_date DESC";
    $res = mysql_query($sql,$connect_web);
    $arr = mysql_fetch_array($res);
    $total_record = $arr["cnt"];
    $list = 30;
    $block_cnt = 5;
    $block_num = ceil($page/$block_cnt);
    $block_start = (($block_num - 1) * $block_cnt) + 1;
    $block_end = $block_start + $block_cnt - 1;

    $total_page = ceil($total_record/$list);

    if($block_end > $total_page){
        $block_end = $total_page;
    }

    $total_block = ceil($total_page/$block_cnt);
    $page_start = ($page - 1) * $list;

    $sql = "select * from delBoard WHERE del_result = '1' order by DATE_FORMAT(reg_date,'%y-%m') desc, gift desc limit $page_start, $list";
    $res = mysql_query($sql,$connect_web);

    if(!$res){die("error");}
    while($row=mysql_fetch_array($res)){
        $list_array[] = $row;
    }
    for($i=0;$i<count($list_array);$i++){

    $info = $list_array[$i];

    //날짜수정
    $datetime = $info['reg_date'];
    $rep = str_replace('-','/', $datetime);
    $date = ((int)iconv_substr($rep, 5, 2))."월";

    //id(최대 6글자표시)
    //$id = $info['user_id'];
    //$id_star = iconv_substr($id, 0, 3, "UTF-8").str_repeat('*',3);

    //회사이름(최대 4글자표시)
    $company = iconv("EUC-KR", "UTF-8", $info['company']);
    $company_star = iconv_substr($company, 0, 2, "UTF-8").str_repeat('*',2);

    //지역s
    $area = iconv("EUC-KR", "UTF-8", $info['user_area']);

    //사은품
    $gift = $info['gift'];
    if($gift == 0) {$gift_txt = "상품권/음료권";} 
    else if($gift == 1) {$gift_txt = "상품권/음료권";}
    else if($gift == 2) {$gift_txt = "상품권/음료권";}
    else if($gift == 3) {$gift_txt = "상품권/음료권";}

    //발송
    $result = $info['del_result'];
    if($result == 0) {$result_txt = "미발송"; } else {$result_txt = "발송";}

    //배송방식
    $method = $info['del_met'];
    if($method == 0) {$img = "./images/freebies/kpost.png"; } else {$img = "./images/freebies/kakao.png";}
?>
        <li class="freeb_cont">
            <div class="freeb_item fb_date"><?php echo $date; ?></div>
            <!-- <div class="freeb_item fb_id"><?php echo $id_star; ?></div> -->
            <div class="freeb_item fb_name"><?php echo $company_star; ?></div>
            <div class="freeb_item fb_region"><?php echo $area; ?></div>
            <div class="freeb_item fb_gift"><?php echo $gift_txt; ?></div>
            <div class="freeb_item fb_ship"><?php echo $result_txt; ?></div>
            <div class="freeb_item fb_icon"><img src="<?php echo $img; ?>" alt="발송 아이콘"></div>
        </li>
<?php } ?>
        <!--
        <li class="freeb_cont">
            <div class="freeb_item fb_date">12/30</div>
            <div class="freeb_item fb_id">abc***</div>
            <div class="freeb_item fb_name">에이**</div>
            <div class="freeb_item fb_region">대구</div>
            <div class="freeb_item fb_gift">음료2잔</div>
            <div class="freeb_item fb_ship">발송</div>
            <div class="freeb_item fb_icon"><img src="./images/freebies/kakao.png" alt="카카오톡"></div>
        </li>
        <li class="freeb_cont">
            <div class="freeb_item fb_date">1/19</div>
            <div class="freeb_item fb_id">abc***</div>
            <div class="freeb_item fb_name">에이**</div>
            <div class="freeb_item fb_region">부산</div>
            <div class="freeb_item fb_gift">상품권5만원</div>
            <div class="freeb_item fb_ship">발송</div>
            <div class="freeb_item fb_icon"><img src="./images/freebies/kpost.png" alt="우체국"></div>
        </li>
        -->
    </ul>
    <nav>
        <ul class="pagingul">
            <?php
            //customer_recommend.php 참고
            //해당 페이지에 해당변수가 존재할 경우 '소개이벤트' 페이지 안에서 이동, 아닐 경우, '만족도조사' 페이지 안에서 이동
            //포함된 각 페이지에 해당변수 있는지 확인필요
            if(isset($recommend)){
                $url = "customer_recommend.php?page=";
            } else if( isset($review) ){
                $url = "myevent.php?page=";
            } else if( isset($satis_new) ){
                $url = "customer_satisfaction_new.php?page=";
            } else if( isset($satis) ){
                $url = "satis.php?page=";
            } else {
                $url = "customer_satisfaction.php?page=";
            }

            if($page <= 1){

            }else{
                $pre = $page - 1;
                if(isset($unum)){
                    echo "<li><a href='$url$pre#freebies_inc'>이전</a></li>";
                }else{
                    echo "<li><a href='$url$pre#freebies_inc'>이전</a></li>";
                }
            }

            for($i = $block_start; $i <= $block_end; $i++){
                if($page == $i){
                    echo "<li class='change_back'><a disabled>$i</a></li>";
                }else{
                    if(isset($unum)){
                        echo "<li><a href='$url$i#freebies_inc'>$i</a></li>";
                    }else{
                        echo "<li><a href='$url$i#freebies_inc'>$i</a></li>";
                    }
                }
            }     
            
            if($page >= $block_end){

            }else{
                $next = $page + 1;
                if(isset($unum)){
                    echo "<li><a href='$url$next#freebies_inc'>다음</a></li>";
                }else{
                    echo "<li><a href='$url$next#freebies_inc'>다음</a></li>";
                }
            }
            ?>
        </ul>
    </nav>
</section>
</div>