webadmin.php

/home/mjc1/public_html/emillennium/taxbill_buy_nts.php

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

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

if($sdate==''){ $sdate = date("Y-m-",time())."01"; }
if($edate==''){ $edate = date("Y-m-d",time()); }

$where = "";

if($stx!=''){
    if($sti=='a.DMDER_BUSNID_ID'){
        $stx = str_replace("-","",$stx);
        $where .= " and {$sti} = FN_GET_BIZNO('$stx') ";
    } else {
        $where .= " and {$sti} = '$stx' ";
    }
}

if($st_mail!=''){
    $where .= " and a.EMAIL_CHECK = '{$st_mail}' ";
}

if($st_nts!=''){
    if(substr($st_nts,0,1) == 'E'){
        $v = explode("^",$st_nts);
        if($v[1]=='SUC001'){
            $where .= " and a.SND_STATUS_CD = '{$v[0]}' and s.RESULT_CD = 'SUC001' ";    
        } else if($v[1]=='NULL'){
            $where .= " and a.SND_STATUS_CD = '{$v[0]}' and (s.RESULT_CD is NULL or s.RESULT_CD = '') ";    
        } else {
            $where .= " and a.SND_STATUS_CD = '{$v[0]}' and not (s.RESULT_CD =  'SUC001' or s.RESULT_CD is NULL or s.RESULT_CD = '') ";    
        }
    } else {
        $where .= " and a.SND_STATUS_CD = '{$st_nts}' ";
    }
}

if($st_kind!=''){
    if(strlen($st_kind)==2){
        $where .= " and a.ETAXBIL_CL_CD = '{$st_kind}' ";    
    } else {
        $where .= " and a.ETAXBIL_CL_CD = '".substr($st_kind,0,2)."' and ETAXBIL_KND_CD = '".substr($st_kind,2,2)."' ";    
    }
}


$comp_sn = str_replace("-","",$office_info['comp_sn']);

$sql  =   "select count(*) as cnt
                from buy_tax_m a
                inner join buy_tax_d b on a.midx = b.midx
                inner join customers c on a.ccode = c.code
            where 1=1 {$where}
 ";
$result      =    mysql_query($sql,$connect_e1000y);
$row = mysql_fetch_array($result);
$total_count = $row['cnt'];

$list_num = 15;
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.midx, a.ocode, a.immd_yn, a.tax_type, a.ccode, a.writedate, a.remarks, a.recved_yn, a.card_yn, a.etax_appv_no, 
                    b.dealdate, b.pname, c.comp_name, c.code1
                from buy_tax_m a
                inner join buy_tax_d b on a.midx = b.midx
                inner join customers c on a.ccode = c.code
            where 1=1 {$where}
            order by a.data_created desc limit $from_record, $list_num 
";
$result      =    mysql_query($sql,$connect_e1000y);

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

//_pr($list_array);

$qstr = $_SERVER['QUERY_STRING'];

?>
<style>
    .order-sheet2 { font-size:0.9em; }
    .bigo_class { font-size:0.8em; line-height:20px !important; }
</style>
<!--<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">
    <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='tax_search_form' method='get'>
    <input type='hidden' name='search_form_name' id='search_form_name' value='tax_search_form'> <!-- 거래처 검색에서 리턴폼 명칭 정의-->
    <input type='hidden' name='biztype' size='' value='<?php echo $biztype;?>'>
    <input type='hidden' name='smode' size='' value='<?php echo $smode;?>'>
    <div id="sub-contents-area">
        <div class="sub-btn-area">
            <div class="sub-btn">
                <a class="lignt-blue-btn" id='btn_nts_del'>계산서삭제</a>
            </div>
        </div>
        <div class="sub-btn-area">
            <div class="sub-btn sub-btn-search" style='width:1200px;margin-left:0px;'>
                기간 : <input type='text' name='sdate' id='sdate' value='<?php echo $sdate;?>' class='width_80'> ~ <input type='text' name='edate' id='edate' value='<?php echo $edate;?>' class='width_80'>
                &nbsp;&nbsp;
                거래처검색 : 
                <input type='text' name='stc' value='<?php echo $stc;?>' class='input_readonly width_60'>
                <input type='text' name='stc_search' value='<?php echo $stc_search;?>' class='cust_search_class width_80'>&nbsp;<img src='./images/glass.png' class='customer-sel-btn glass_class'>&nbsp;
                <input type='text' id='stx' name='stx' size='' value='<?php echo $stx;?>' class="stx_class" style='display:none;'>&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' ><span>발행내역건</span></a>
            <a value='2' ><span>국세청발행내역</span></a>
            <a value='3' class="on"><span>매입 세금계산서</span></a>
        </div>
    </div>

<form name='tax_list_form' method='post'>
<input type='hidden' name='sel_mode' value='sum'>
<input type='hidden' name='sdate' value='<?php echo $sdate?>'>
<input type='hidden' name='edate' value='<?php echo $edate?>'>
<input type='hidden' name='RequestCode' value=''>
<input type='hidden' name='new_email' value=''>
<input type="hidden" name="edit_type" id="edit_type" 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:80px;"><col style="width:120px;"><col style="width:80px;">
                <col style="width:150px;"><col style="width:80px;"><col style="width:80px;">
                <col style="width:150px;"><col style="width:150px;">
                </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>
                    </tr>
                </thead>
                <tbody>
<?php 
    for($i=0;$i<count($list_array);$i++){ 
        $info = $list_array[$i];

        if($info['card_yn']=='2'){ $tax_gubun = "현금영수증"; }
        else if($info['card_yn']=='1'){ $tax_gubun = "신용카드계산서"; }
        else if($info['card_yn']=='0' && $info['etax_appv_no']==''){ $tax_gubun = "종이계산서"; }
        else if($info['card_yn']=='0' && $info['etax_appv_no']=='0000000000'){ $tax_gubun = "전자계산서"; }
        
?>
                    <tr style='height:40px;' id='xxx_<?php echo $i?>'>
                        <td class="tcenter ">
                            <input type='checkbox' name='code_idx[]' value='<?php echo $info['midx'];?>'>
                        </td>
                        <td class="tcenter "><?php echo $info['midx'];?></td>
                        <td class="tcenter "><?php echo $tax_gubun;?></td>
                        <td class="tcenter "><?php echo $info['code1'];?></td>
                        <td class="linetxt"><?php echo $info['comp_name'];?></td>
                        <td class="tcenter"><?php echo $info['writedate'];?></td>
                        <td class="tcenter"><?php echo $info['dealdate'];?></td>
                        <td class="linetxt"><?php echo $info['pname'];?></td>
                        <td class="tcenter "><?php echo $info['remarks'];?></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");
        if(v==0){
            document.location.href="./taxbill.php";
        } else if(v==1){
            document.location.href="./taxbill_detail.php?smode=comp";
        } else if(v==2){
            document.location.href="./taxbill_nts.php";
        } else if(v==3){
            document.location.href="./taxbill_buy_nts.php";
        }
    });

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

    $("#xls_down").click(function(){ // 엑셀다운로드
        document.tax_search_form.action='taxbill_nts_xls_down.php';
        document.tax_search_form.target = '_blank';
        document.tax_search_form.submit();
        document.tax_search_form.action='?';
        document.tax_search_form.target = '';
    });

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

    $(".customer-sel-btn").click(function(){ // 거래처 ? 검색일경우
        customer_search('',1);
    });

    $(".cust_search_class").keypress(function(){ // 거래처명란에서 엔터로 검색일경우
        if(event.keyCode==13){
            var v_cn = $(".cust_search_class").val()
            customer_search(encodeURI(v_cn),1);
        }
    }).change(function(){
        $("input[name='stc']").val("");
    });

    $("#btn_nts_del").click(function(){
        var ck_cnt = 0; ck_midx_list = "";
        $("input[name='code_idx[]']").each(function(){
            if($(this).is(":checked")==true){    ck_cnt++;    ck_midx_list = ck_midx_list+$(this).val()+","; }
        });
        if(ck_cnt==0){ alert('삭제하실 상품을 선택하시기 바랍니다.'); return; }
        if(confirm('정말로 삭제하시겠습니까?')){
            $.get("ajax.tax_buy_process.php?smode=del&midx_list="+ck_midx_list,function(rtn){
                //alert(rtn);
                $("#modal_member_box2").html(rtn);
            });
        }
    });

});

function customer_search(v_cn,v_page){
    var sti_val = $("form[name='tax_search_form'] select[name='sti'] option:selected").val();
    if(sti_val==undefined){ sti_val = "comp_name"; }
    $.get("customer_list.inc.php?biztype=0&modetype=list&sti="+sti_val+"&stx="+v_cn+"&page="+v_page,function(rtn){
        $("#modal_member_box").html(rtn).dialog({
            resizable: true, height:780, width:1100, modal: true, title: "거래처 [검색]",
            buttons: {
                닫기: function() {
                    $( this ).dialog( "close" );
                }
            }
        });
    });    
}

</script>
<?php include('./include/footer.php'); ?>
<div id="modal_member_box" title="1차모달" style="display:;width:100%; height:100%; padding-top:3px;padding-left:3px;background-color:#FFFFFF;position:relative;"></div>
<div id="modal_member_box2" title="2차모달" style="display:none;width:100%; height:100%; padding-top:3px;padding-left:3px;background-color:#FFFFFF;position:relative;"></div>