webadmin.php

/home/mjc1/public_html/otms_old/base.php

<?php
$dir = ".";
include_once($dir."/_common.php");
include('./header.php'); 

if($eid==''){
    alert('로그인 후에 이용가능합니다.',"index.php"); exit;
}

if($order_key==''){ 
    if($_COOKIE['ok_product']!=''){
        $_COOKIE['ok_product'] = str_replace("%20"," ",$_COOKIE['ok_product']);
        $order_key = $_COOKIE['ok_product']; 
    } else {
        $order_key = 'a.om_site, a.base_key, a.seq'; 
    }
}

$where = " ";

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

if($stc!=''){
    $where .= " and a.c_depth = '{$stc}' ";
}

if($stpc!=''){
    $where .= " and a.c_site = '{$stpc}' ";
}

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

$list_num = 30;
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 a.* from zom_base_cont a  WHERE 1=1 $where order by $order_key limit $from_record, $list_num ";
$result      =    mysql_query($sql,$connect_om);

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

$qstr = $_SERVER['QUERY_STRING'];
?>

<!--<div id="contents" style="background:#999"><img src="http://placehold.it/960x150" alt="롤링배너"></div>-->
<div id="contents" style="height:2px;border-bottom:1px solid #eee;background:#2f6ba9">
    <span class="screen_out">header 하단 선</span>
</div>

<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='menu_search_form' method='get'>
    <input type='hidden' name='biztype' size='' value='<?php echo $biztype;?>'>
    <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" id='sel_edit'>선택수정</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.base_key' <?php if($sti=='a.base_key'){?>selected<?php }?>>항목키</option>
                    <option value='a.base_key_name' <?php if($sti=='a.base_key_name'){?>selected<?php }?>>항목키 명</option>
                    <option value='a.base_cont_no' <?php if($sti=='a.base_cont_no'){?>selected<?php }?>>항목 no</option>
                    <option value='a.base_cont_name' <?php if($sti=='a.base_cont_name'){?>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">
        <div class="item_tab_navi">
            <a value='0' ><span>오픈마켓 설정관리</span></a>
            <a value='1' class="on"><span>기초항목 관리</span></a>
        </div>
    </div>

<form name='menu_list_form' method='post'>
<input type='hidden' name='sel_del' value=''>
    <div class="div-list-area">
        <div class="cust-list-area">
            <table class="order-sheet2">
                <caption class="screen_out">매입처 원장 조회<caption>
                <colgroup>
                <col style="width:30px;">
                <col style="width:60px;"><col style="width:150px;"><col style="width:150px;">
                <col style="width:80px;"><col style="width:260px;"><col style="width:70px;">
                </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">항목 no</th><th scope="col">항목 내용</th><th scope="col">순번</th>
                    </tr>
                </thead>
                <tbody class='menu_tbody change_check_class'>
<?php 
    for($i=0;$i<count($list_array);$i++){ 
        $info = $list_array[$i];
        $p_type = explode("^",$info['p_type']);
?>
                    <tr>
                        <td class="tcenter ">
                            <input type='checkbox' name='code_idx[<?php echo $i;?>]' value='<?php echo $i;?>' class='code_idx_calss'>
                            <input type='hidden' name='codes[<?php echo $i;?>]' value='<?php echo $info['idx'];?>'>
                        </td>
                        <td class="tcenter ">
                            <?php echo $site_name[$info['om_site']];?>
                        </td>
                        <td class="tcenter ">
                            <input type='text' name='base_key[<?php echo $i;?>]' value='<?php echo $info['base_key'];?>' tabindex='<?php echo 100+$i?>'>
                        </td>
                        <td class="tcenter ">
                            <input type='text' name='base_key_name[<?php echo $i;?>]' value='<?php echo $info['base_key_name'];?>' tabindex='<?php echo 200+$i?>'>
                        </td>
                        <td class="tcenter ">
                            <input type='text' name='base_cont_no[<?php echo $i;?>]' value='<?php echo $info['base_cont_no'];?>' class='width_60' tabindex='<?php echo 300+$i?>'>
                        </td>
                        <td class="tcenter ">
                            <input type='text' name='base_cont_name[<?php echo $i;?>]' value='<?php echo $info['base_cont_name'];?>' class='width_300'  tabindex='<?php echo 400+$i?>'>
                        </td>
                        <td class="tcenter ">
                            <input type='text' name='seq[<?php echo $i;?>]' value='<?php echo $info['seq'];?>' class='width_60' tabindex='<?php echo 500+$i?>'>
                        </td>
                    </tr>
<?php 
        $idx++;
    } 
?>
                </tbody>
            </table>
        </div>
    </div>
</form>

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

</div><!--//wrap-->

<script>
var qstr = '<?php echo $qstr;?>';
$(function(){
    $(".check_all_class").click(function(){ // 전체선택 전체선택 해제
        if($(this).is(":checked")){
            $(".code_idx_calss").prop("checked",true);
        } else {
            $(".code_idx_calss").prop("checked",false);            
        }
    });

    $(".item_tab_navi a").click(function(){ //네비게이션 탭 처리
        v = $(this).attr("value");
        if(v==0){
            document.location.href="./base_config.php";
        } else if(v==1){
            document.location.href="./base.php";
        }
    });

    $(".sub-btn #btn_order_new").click(function(){ // 상품 신규 버튼
        add_menu("");
    });

    $(".order_key_class").change(function(){ // 순서변경시
        document.menu_search_form.action='?';
        document.menu_search_form.target = '';
        document.menu_search_form.submit();
    });

    $("#search_btn_press").click(function(){
        document.menu_search_form.action='?';
        document.menu_search_form.target = '';
        document.menu_search_form.submit();
    });

    $(document).on("change",".change_check_class input, .change_check_class select",function(){ // input이나 select값이 변경되면 해당 라인을 체크해줌
        $tr_obj = $(this).closest("tr");
        $tr_obj.find(".code_idx_calss").prop("checked",true);
    });

    $("#sel_edit").click(function(){ // 선택 수정
        var ck_cnt = 0;
        var v = $(".code_idx_calss").each(function(){
            if($(this).is(":checked")){ ck_cnt++; }
        });
        if(ck_cnt==0){ alert('수정하실 항목을 선택하세요.'); return; }    
        if(confirm('정말로 선택하신 '+ck_cnt+'개의 항목을 수정하시겠습니까?')){
            $("input[name='sel_del']").val("EDIT");
            var form_data = $("form[name='menu_list_form']").serialize();

            $.ajax({type:"post", url:"ajax.base_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();
                    if(v_mode_ok!='Y'){
                        alert(v_msg);
                    } else {
                        alert('수정되었습니다.');
                        $(".code_idx_calss").each(function(){ $(this).prop("checked",false); });
                        $(".check_all_class").prop("checked",false);
                    }
                },
                error:function(rtn,status,error){    alert(error);        }
            });
        }    
    });

    $("#sel_delete").click(function(){ // 선택삭제
        var ck_cnt = 0;
        var v = $(".code_idx_calss").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='menu_list_form']").serialize();

            $.ajax({type:"post", url:"ajax.base_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();
                    if(v_mode_ok!='Y'){
                        alert(v_msg);
                    } else {
                        document.location.href='?<?php echo $qstr."&time=".time();?>';
                    }
                },
                error:function(rtn,status,error){    alert(error);        }
            });
        }
    });

});

function add_menu(){
    $.get("base_reg.inc.php",function(rtn){
        $("#modal_member_box").html(rtn).dialog({
            resizable: true, height:340, width:740, modal: true, title:"항목 [신규]",
            buttons: {
                저장: function() {
                    form_save();
                },
                닫기: function() {
                    $( this ).dialog( "close" );
                }
            }
        });
        setTimeout(function(){
            $(".ui-button-text").eq(1).click();
        },100);
    });
}

function form_save(){ // 상품분류 저장/수정
    var form_obj = $("form[name='menu_reg_form']");
    if($(form_obj).find("input[name='me_name']").val()==''){
        alert('메뉴명을 입력하세요.'); return;
    }
    $(form_obj).find("input[name='qstr']").val('<?php echo $qstr;?>');
    //if(confirm('저장하시겠습니까?')){
        var form_data = $(form_obj).serialize();

        $.ajax({type:"post", url:"ajax.base_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_after_add = $(xml).find("after_add").text();
                if(v_mode_ok!='Y'){
                    alert(v_msg);
                } else {
                    document.location.reload();
                }
            },
            error:function(rtn,status,error){    alert(error);        }
        });
    //}
    //$(form_obj).submit();
}

</script>

<?php include('./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>