webadmin.php

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

<? include("./include/header.php"); ?>

<?php

// 몇명이 이 페이지에 들어왔는지 카운팅
if($_SERVER['REMOTE_ADDR']!='58.151.27.172' && $_SERVER['REMOTE_ADDR']!='115.138.35.2'){ // 사내의 대구, 서울 아이피가 아닐 경우에만

    $today = date("Y-m-d"); // 오늘날짜
    $time = date("H");
    $page = basename($_SERVER['PHP_SELF']);
    $page_kr = iconv("utf-8","euckr","동영상강의");
    $sql = "SELECT * FROM mBoard_page_count WHERE inflow_date = '{$today}' AND page = '{$page}' AND page_kr = '{$page_kr}' ORDER BY inflow_time DESC";
    $res = mysql_query($sql,$connect_web);
    $row = mysql_fetch_array($res);

    if(!$row || $row['inflow_time'] != $time){ // 데이터가 없을 때
        $insertsql = "INSERT INTO mBoard_page_count(inflow_date, inflow_time, count, page, page_kr) VALUES ('{$today}', '{$time}', 1, '{$page}', '{$page_kr}')";
        mysql_query($insertsql,$connect_web);
    } else { // 데이터가 있을 때
        $updatesql = "UPDATE mBoard_page_count SET count = count+1 WHERE inflow_date = '{$today}' AND inflow_time = '{$time}' AND page = '{$page}'";
        mysql_query($updatesql,$connect_web);
    }
}

?>

    </div>
    <style>
    .container{margin:20px 0;padding:0 15px;}
    .container section,
    .container table {width:100%;border:2px solid #383a7d;border-top:0px none;background-color:#fff;font-size:12px;}
    </style>

<style>
    .movie_container{width: 100%;}

    .movie_container ul{width: 90%;margin: 0 auto;border-bottom: 1px dashed #d6d6d6;display: flex;justify-content: space-between;margin-bottom: 20px;}
    .movie_container ul:last-child{border-bottom: 0px;}
    .video_li{width: 48.5%;margin-bottom: 20px;}
    .video_li p{font-size: 14px;line-height: 20px;font-weight: 600;margin-top: 10px;letter-spacing: -0.4px;text-align: center;}
    .video_li a{width: 100%;display: block;border-radius: 10px;overflow: hidden;}
    .video_li a img{width: 100%;}

    .float_div_class{display: none;}

    /*동영상개선점 등록하기*/
    .impromovie {
        width: 25%;
        padding: 8px 10px;
        background: #999;
        /* width: 126px; */
        color: #fff;
        /* font-weight: 900; */
        font-weight: 600;
        border-radius: 4px;
        display: block;
        cursor: pointer;
        font-size: 14px;
        text-align: center;
    }
    /* .impromovie:hover{background: #333;} */
    [aria-describedby="customermovie_improvement"]{padding: 0px;border-radius: 10px;border: 1px solid #333;}
    [aria-describedby="customermovie_improvement"] .ui-widget-header{background: #333;border: 0px;border-radius: 0px;padding: 0.7em 1em;}
    [aria-describedby="customermovie_improvement"] .ui-dialog-title{color: #fff;font-size: 16px;}
    [aria-describedby="customermovie_improvement"] .ui-dialog-titlebar-close{right: 1em;}
    #customermovie_improvement{padding: 10px 0px 5px !important;}
    #impromovietext{width: 100%;box-sizing: border-box;}
    [aria-describedby="customermovie_improvement"] .ui-dialog-buttonpane{border: 0px;margin-top: 0px;padding: 0 1em 0.5em;}
    [aria-describedby="customermovie_improvement"] .ui-dialog-buttonpane button{background: #fff;border: 1px solid #999;font-size: 14px;font-weight: bold;}
    /* [aria-describedby="customermovie_improvement"] .ui-dialog-buttonpane button:hover{background: #333;color: #fff;} */
    
    #m3_search_form{width: 70%;}
    #m3_search_form > div::after{content: '';display: block;clear: both;}
    #m3_search{width: 70%;height: 52px;box-sizing: border-box;border: 2px solid #4d4d4d;border-right: 0px;border-radius: 6px 0px 0px 6px;cursor: text;float: left;padding-left: 10px;font-size: 14px;outline: none;}
    #m3_search_btn{display: inline-block;width: 50px;height: 52px;line-height: 52px;background: #4d4d4d;color: #fff;text-align: center;font-size: 14px;float: left;border-radius: 0px 6px 6px 0px;font-weight: bold;cursor: pointer;}
</style>

        <div class="movie_container" style="margin-top: 50px;">
            <div class="movie_top" style="width: 100%;height: 290px;padding: 0px;overflow: hidden;background: #59BDDD;position: relative;">
                <img src="./images/customermovie/customermovie_top2-6.png" alt="천년경영3 쉬운 사용법 영상" style=" position: absolute;left: 50%;top: 0px;transform: translateX(-50%);z-index: 2; height:290px">
                <!-- <div style="position: absolute;left: 50%;bottom: 0px;transform: translateX(-50%);width: 100%;height: 20px;background: #1B7E9D;z-index: 0;"></div> -->
            </div>
        </div>

        <div style="width: 90%;margin: 0 auto;margin-top: 20px;display: flex;justify-content: space-between;">
            <?php if($_SERVER['REMOTE_ADDR']=='58.151.27.172'){ ?>
            <form name="m3_search_form" id="m3_search_form" method="post">
                <div style="width: 100%">
                    <input type="text" name="stc" value="<?php echo $stc;?>" id="m3_search" placeholder="강의명을 입력해주세요.">
                    <a id="m3_search_btn">검색</a>
                </div>
            </form>

            <p class="impromovie">동영상개선점 등록하기</p>
            <?php } ?>
        </div>

        <div class="movie_container" style="margin-top: 20px;">
            <!-- <h3 style="width: 90%;margin: 0 auto;font-weight: 600;margin-bottom: 20px;">천년경영Ⅲ 영상보기</h3> -->

            <?php
                $where = "";
                if($stc != "") { // 검색명이 있으면 추가
                    $stc = iconv("utf-8","euc-kr",$stc);
                    $where .= " AND a.title LIKE '%{$stc}%'";
                }

                $sql = "SELECT a.idx, a.title, a.link, a.thumb from mBoard_movie AS a WHERE 1=1 {$where} AND a.hidden <> '1' ORDER BY idx ASC";
                $res = mysql_query($sql,$connect_web);
                $cnt = 0; // ul 태그용 카운트
                $cnt2 = 1; // 맨마지막에 추가영상 li를 추가하기 위한 카운트
                $allcnt = mysql_num_rows($res); // 위 sql의 전체 결과 카운트
                while($info = mysql_fetch_array($res)) {
                    $info['title'] = iconv("euc-kr","utf-8",$info['title']);

                    if($cnt > 1) { $cnt = 0; } // ul 태그용 카운트가 1이상이 되면 0으로 초기화

                    if($cnt == 0) { echo "<ul>"; } // ul 태그용 카운트가 0일 때 ul태그 추가

                    $moviename = preg_replace("/[0-9.]/","",$info['title']); // hidden 값용으로 타이틀에서 숫자와 .만 제거
            ?>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="<?php echo $moviename; ?>">
                    <a href="<?php echo $info['link']; ?>" target="_blank"><img src="<?php echo "../../save_dir/m_movie/".$info['thumb']; ?>" alt="<?php echo $info['title']; ?>"></a>
                    <p><?php echo $info['title']; ?></p>
                </li>

            <?php
                    if($cnt2 == $allcnt) { // 맨마지막 카운트와 전체결과 카운트가 동일하면 맨 마지막이라 판단하고 추가영상 li 추가
                    if($cnt == 1) { echo "</ul><ul>"; } // ul 태그용 카운트가 3이면 ul태그 닫고 추가영상용으로 다시염
            ?>
                <li class="video_li">
                    <a><img src="../millennium/img/customer/m3_video_update.png" alt="추가영상 업데이트 중"></a>
                </li>
            <?php
                    }

                    if($cnt == 1) { echo "</ul>"; } // ul 태그용 카운트가 1이면 ul태그 닫음
                    $cnt ++; // 카운트올림
                    $cnt2 ++; // 카운트올림

                }
            ?>

            <!--
            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="사업자등록관리">
                    <a href="https://youtu.be/2lm-0woSEDE?si=bZSX1zv0So_6DNie" target="_blank"><img src="../millennium/img/customer/m3_video01.png" alt="1.사업장 등록관리"></a>
                    <p>1.사업장 등록관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="거래처등록관리">
                    <a href="https://youtu.be/LqBnC-80JDE?si=9hnBED054zMXupPr" target="_blank"><img src="../millennium/img/customer/m3_video02.png" alt="2.거래처 등록관리"></a>
                    <p>2.거래처 등록관리</p>
                </li>
            </ul>

            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="상품등록관리">
                    <a href="https://youtu.be/BjZuELjcZx8?si=XoQmpLyrkyRGR2PK" target="_blank"><img src="../millennium/img/customer/m3_video03.png" alt="3.상품 등록관리"></a>
                    <p>3.상품 등록관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="특별단가관리">
                    <a href="https://youtu.be/sOWUVmYkuZo?si=XQj6zLtu1dGRmep5" target="_blank"><img src="../millennium/img/customer/m3_video04.png" alt="4.특별 단가관리"></a>
                    <p>4.특별 단가관리</p>
                </li>
            </ul>

            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="매입전표등록관리">
                    <a href="https://youtu.be/cuTUr6kzu2A?si=27LxWiAOjCCVoBVO" target="_blank"><img src="../millennium/img/customer/m3_video05.png" alt="5.매입전표 등록관리"></a>
                    <p>5.매입전표 등록관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="매출전표등록관리">
                    <a href="https://youtu.be/W-Mw61gCcIg?si=gDK_S2o60A49lSn-" target="_blank"><img src="../millennium/img/customer/m3_video06.png" alt="6.매출전표 등록관리"></a>
                    <p>6.매출전표 등록관리</p>
                </li>
            </ul>

            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="입금출금등록관리">
                    <a href="https://youtu.be/KDvezECmZrs?si=81PsXmAV66yVy4N8" target="_blank"><img src="../millennium/img/customer/m3_video07.png" alt="7.입금 출금 등록관리"></a>
                    <p>7.입금 출금 등록관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="거래명세표발행">
                    <a href="https://youtu.be/JLVP0jvqNtg?si=Xsnv1D_o-GvZCA18" target="_blank"><img src="../millennium/img/customer/m3_video08.png" alt="8.거래명세표 발행"></a>
                    <p>8.거래명세표 발행</p>
                </li>
            </ul>

            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="전자세금계산서발행">
                    <a href="https://youtu.be/Jobbrh-nxqE?si=mYB9zktN3FE355i3" target="_blank"><img src="../millennium/img/customer/m3_video09.png" alt="9.전자세금계산서 발행"></a>
                    <p>9.전자세금계산서 발행</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="상품재고관리">
                    <a href="https://youtu.be/XmiNDUnU_Xk?si=5fL-Hnb5vB90rAGi" target="_blank"><img src="../millennium/img/customer/m3_video10.png" alt="10.상품재고관리"></a>
                    <p>10.상품재고관리</p>
                </li>
            </ul>

            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="사용자직원 관리">
                    <a href="https://youtu.be/OumtnrkXvUQ?si=VVMrBH5dwh_kIdLW" target="_blank"><img src="../millennium/img/customer/m3_video11.png" alt="11.사용자직원 관리"></a>
                    <p>11.사용자직원 관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="수발주 등록 관리">
                    <a href="https://youtu.be/6a7IjU83PkQ?si=JZwXYa5HZH38-D_9" target="_blank"><img src="../millennium/img/customer/m3_video12.png" alt="12.수발주 등록 관리"></a>
                    <p>12.수발주 등록 관리</p>
                </li>
            </ul>
            
            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="수주 관련 보고서">
                    <a href="https://youtu.be/xOfa0lN8XVc?si=JRAzQEWlQFZhxQcJ" target="_blank"><img src="../millennium/img/customer/m3_video13.png" alt="13.수주 관련 보고서"></a>
                    <p>13.수주 관련 보고서</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="상품 다중 단가 관리">
                    <a href="https://youtu.be/k4aPjoI086o?si=MG0gMFQpxAvCFIq0" target="_blank"><img src="../millennium/img/customer/m3_video14.png" alt="14.상품 다중 단가 관리"></a>
                    <p>14.상품 다중 단가 관리</p>
                </li>
            </ul>

            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="견적서 등록관리">
                    <a href="https://youtu.be/Kp3zOflURcE?si=2OYerkGRn3OzUoS9" target="_blank"><img src="../millennium/img/customer/m3_video15.png" alt="15.견적서 등록관리"></a>
                    <p>15.견적서 등록관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="상품 할인 판매관리">
                    <a href="https://youtu.be/oRM2j-FNJ-4?si=WqcpNDWOipgDcFuV" target="_blank"><img src="../millennium/img/customer/m3_video16.png" alt="16.상품 할인 판매관리"></a>
                    <p>16.상품 할인 판매관리</p>
                </li>
            </ul>
            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="상품 행사단가 관리">
                    <a href="https://youtu.be/HNMwiUgP-Dg?si=ZobKhtyk5fgs5OT2" target="_blank"><img src="../millennium/img/customer/m3_video17.png" alt="17.상품 행사단가 관리"></a>
                    <p>17.상품 행사단가 관리</p>
                </li>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="창고(차량) 재고관리">
                    <a href="https://youtu.be/ca06go6iqto?si=XW83X_hCYJbWMkC2" target="_blank"><img src="../millennium/img/customer/m3_video18.png" alt="18.창고(차량) 재고관리<"></a>
                    <p>18.창고(차량) 재고관리</p>
                </li>
            </ul>
            <ul>
                <li class="video_li">
                    <input type="hidden" name="moviename" value="도소매 포스 판매관리">
                    <a href="https://youtu.be/F1b-7YURnB0?si=xm22Pwy0D8cPLY8q" target="_blank"><img src="../millennium/img/customer/m3_video19.png" alt="19.도소매 포스 판매관리"></a>
                    <p>19.도소매 포스 판매관리</p>
                </li>
                <li class="video_li">
                    <a><img src="../millennium/img/customer/m3_video_update.png" alt="추가영상 업데이트 중"></a>
                </li>
            </ul>
            -->
        </div>

<?php if($_SERVER['REMOTE_ADDR']!='58.151.27.172' && $_SERVER['REMOTE_ADDR']!='115.138.35.2'){ // 사내의 대구, 서울 아이피가 아닐 경우에만 ?>
<script>
$(function(){
    $(".video_li a").click(function(){
        var hid = $(this).closest("li").find("input[name='moviename']").val();
        $.ajax({type:"post", url:"ajax.customermovie.php", data:{"page":"youtube","page_kr":hid}, 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();
                if(v_mode_ok=='Y'){
                    //document.location.reload();
                } else {
                    alert(v_msg);
                }
            },
            error:function(rtn,status,error){    alert(error);        }
        });
    });
});
</script>
<?php } ?>

<script>
    $("#m3_search_btn").click(function(){
        $(this).closest("form").submit();
    });

    $(".impromovie").click(function(){
        $.get("customermovie_improvement.php",function(rtn){
            $("#customermovie_improvement").html(rtn).dialog({
                resizable: false, height: 'auto', width: '90%', modal: true, title:"개선점 등록하기",
                buttons: {
                "개선점 등록하기": function() { 
                    if($("form[name='impromovieform']").find("#impromovietext").val() == "") { alert("내용을 입력해주시기 바랍니다."); return; }

                    var form_data = $("form[name='impromovieform']").serialize();
                    
                    $.ajax({type:"post", url:"../millennium/ajax.customermovie.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();
                            if(v_mode_ok!='Y'){
                                alert(v_msg);
                            } else {
                                alert("등록되었습니다.");
                            }
                        },
                        error:function(rtn,status,error){    alert("Error : "+error);    }
                    });
                    $(this).dialog('close'); 
                },
                "닫기": function() { 
                    $(this).dialog('close'); 
                }
            }
            });
        });
    });
</script>


<?include("./include/footer.php");?> 

<div id="customermovie_improvement" title="개선점 등록하기" style="display:none;width:100%; height:100%; padding-top:3px;padding-left:3px;background-color:#FFFFFF;position:relative;"></div>