webadmin.php

/home/mjc1/public_html/emillennium/taxbill_edit_send.inc.php

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

$connect_tax    = @mysql_connect($DB_HOSTtax,$DB_USERtax,$DB_PWDtax);
@mysql_select_db( $DB_NAMEtax,$connect_tax);    


$idx = $_GET['code_idx'][0];
$appv = $_GET['appv_no_list'][$idx];        //계산서코드
$srv = $_GET['mgmt_no_list'][$idx];        //내부코드
$iDate = $_GET['isu_date_list'][$idx];        //전송일
$compsn = $_GET['comp_sn_list'][$idx];     //사업자번호
$code_dash = substr($appv,0,8)."-".substr($appv,8,8)."-".substr($appv,16,8);

    $queryTax = 
            
                    " SELECT s.ETAXBIL_APPV_NO, s.BUSN_KND_CD, decode(s.BUSNID,'12345678') AS BUSNID, s.SUB_BD_NO, s.MAIN_TX_OFFCR_NM, s.MAIN_TX_OFFCR_TELNO, s.MAIN_TX_OFFCR_EMAIL_ADDR, s.BUSNSECT_NM, s.DETAIL_NM, decode(s.CHIEF_NM,'12345678') AS CHIEF_NM, decode(s.TRADE_NM,'12345678') AS TRADE_NM, s.ADDR, 
                    d.ETAXBIL_APPV_NO, decode(d.SUP_AMT_SM,'12345678') AS SUP_AMT_SM, decode(d.TX_SM,'12345678') AS TX_SM, decode(d.TOT_AMT,'12345678') AS TOT_AMT, d.ETAXBIL_NOTE, d.RCPT_RQEST_TP_CD, d.WRITE_DT, d.EMAIL_CHECK, d.SND_STATUS_CD, d.ETAXBIL_CL_CD,d.ETAXBIL_KND_CD, d.ETAXBIL_RVS_CS_CD, d.SRVC_BUSN_MGMT_NO,
                    d.ISU_DATE,
                    f.ETAXBIL_APPV_NO, f.THNG_SEQNO, f.THNG_PURCHS_DT,  f.THNG_NM, f.THNG_STNDRD_NM, REPLACE(FORMAT(f.THNG_QTY,2),'.00','') AS THNG_QTY, REPLACE(FORMAT(f.THNG_UNTPC,2),'.00','') AS THNG_UNTPC, decode(f.THNG_SUP_AMT,'12345678') AS THNG_SUP_AMT, decode(f.THNG_TX,'12345678') AS THNG_TX, f.THNG_NOTE, d.ORG_ETAXBIL_APPV_NO
                    FROM
                    (tn_eaaa AS d LEFT JOIN tn_eaab AS s ON (s.ETAXBIL_APPV_NO = d.ETAXBIL_APPV_NO) LEFT JOIN 
                    tn_eaac AS f ON d.ETAXBIL_APPV_NO = f.ETAXBIL_APPV_NO)
                    WHERE s.ETAXBIL_APPV_NO = '$appv'";
    //echo $queryTax;
    $res = mysql_query($queryTax,$connect_tax);
    $rowcnt = 0;
    $ov_cnt = 0; $ov_qty = 0; $ov_amt = 0; $ov_vat = 0;
    while($rowTax=mysql_fetch_array($res)){
        if($rowTax[BUSN_KND_CD] == "01"){
            if($rowcnt>4){
                $ov_cnt++;
                $ov_qty += $rowTax['THNG_QTY'];
                $ov_amt += $rowTax['THNG_SUP_AMT'];
                $ov_vat += $rowTax['THNG_TX'];
                $rowcnt++;
                continue;
            }
            $rowcnt++;
        }
        $rowTax = array_utf8($rowTax);
        $idx = $rowTax[ETAXBIL_APPV_NO];
        $srvcode = $rowTax[SRVC_BUSN_MGMT_NO];
        $isudate = $rowTax[ISU_DATE];
        $emailCheck        = $rowTax[EMAIL_CHECK];

        $taxtype        = $rowTax[ETAXBIL_CL_CD];    //일반 면세 구분
        $taxtype2        = $rowTax[ETAXBIL_KND_CD];    //일반:01 영세:02 구분
        $SndCheck        = $rowTax[SND_STATUS_CD];

        $Volume         = $rowTax[ETAXBIL_APPV_NO];    //승인번호
        $SerialNum      ;    //일련번호

        if($_GET['edit_type']=='04' || $_GET['edit_type']=='06' || $_GET['edit_type']=='03' || $_GET['edit_type']=='01'){ // 04:계약의 해제, 06:이중발행 정정, 03:환입 01:기재사항 착오는 첫번째 부(-)계산서 보여주기용
            $offerPrice = $rowTax[SUP_AMT_SM]*-1;    //공급가액
            $billprice = $rowTax[TX_SM]*-1;    //세액
            $rowTax[THNG_QTY] = $rowTax[THNG_QTY]*-1;
            $rowTax[THNG_SUP_AMT] = $rowTax[THNG_SUP_AMT]*-1;
            $rowTax[THNG_TX] = $rowTax[THNG_TX]*-1;
            $totalPrice     = number_format($rowTax[TOT_AMT]*-1);    //합계금액
            
            if($_GET['edit_type']=='04'){
                $etxbil_note = "당초 작성일자 ($WRITE_DT) 당초 승인번호($code_dash) 수정사유:계약의 해제";
            } else if($_GET['edit_type']=='06'){
                $etxbil_note = "당초 승인번호($code_dash) 수정사유:이중발행 정정";
            } else if($_GET['edit_type']=='03'){
                $etxbil_note = "당초 작성일자 ($WRITE_DT) 당초 승인번호($code_dash) 수정사유:환입";
            } else if($_GET['edit_type']=='01'){
                $etxbil_note = "당초 승인번호($code_dash) 수정사유:기재사항 착오 정정용 부(-)계산서";
            }
        } else {
            $offerPrice = $rowTax[SUP_AMT_SM];    //공급가액
            $billprice = $rowTax[TX_SM];    //세액
            $totalPrice     = number_format($rowTax[TOT_AMT]);    //합계금액

            if($_GET['edit_type']=='02'){
                $etxbil_note = "당초 승인번호($code_dash) 수정사유:공급가액 변동";
            }
        }

        if($rowTax[BUSN_KND_CD] == "01"){
            $rowTaxArray[] = $rowTax;
            $sCompanyNum1    = $rowTax[BUSNID];            //사업자번호
            $sCompanyNum     = substr($sCompanyNum1 , 0, 3) ."-". substr($sCompanyNum1 , 3, 2) ."-". substr($sCompanyNum1 , 5, 5);
            $sCompanySubNum = $rowTax[SUB_BD_NO];        //종사업장번호
            
            //도장 
            $sCompanyNumimg1 = $rowTax[BUSNID]; 
            //공급자 사업자번호 변환
            $sCompanyNumimg2=substr($sCompanyNumimg1 , 0, 3) ."-". substr($sCompanyNumimg1 , 3, 2) ."-". substr($sCompanyNumimg1 , 5, 5);
            $sCompanyNumimg=$sCompanyNumimg2.".gif";    //도장이미지


            //담당자 정보
            $sOFFCR            = $rowTax[MAIN_TX_OFFCR_NM];
            $sOFFPN            = $rowTax[MAIN_TX_OFFCR_TELNO];
            $sOFFEM            = $rowTax[MAIN_TX_OFFCR_EMAIL_ADDR];

            $sCompanyNname  = $rowTax[TRADE_NM];    //상호
            $sChiefName     = $rowTax[CHIEF_NM];        //성명
            $sCompanyAddr   = $rowTax[ADDR];    //주소
            $sUptae         = $rowTax[BUSNSECT_NM];            //업태
            $sJongmok       = $rowTax[DETAIL_NM];        //종목
        } else if($rowTax[BUSN_KND_CD] == "02"){
            //담당자 정보
            $rOFFCR            = $rowTax[MAIN_TX_OFFCR_NM];
            $rOFFPN            = $rowTax[MAIN_TX_OFFCR_TELNO];
            $rOFFEM            = $rowTax[MAIN_TX_OFFCR_EMAIL_ADDR];


            $rCompanyNum1    = $rowTax[BUSNID];            //사업자번호
            $rCompanyNum     = substr($rCompanyNum1 , 0, 3) ."-". substr($rCompanyNum1 , 3, 2) ."-". substr($rCompanyNum1 , 5, 5);
            $rCompanySubNum = $rowTax[SUB_BD_NO];        //종사업장번호
            $rCompanyNname  = $rowTax[TRADE_NM];    //상호
            $rChiefName     = $rowTax[CHIEF_NM];        //성명
            $rCompanyAddr   = $rowTax[ADDR];    //주소
            $rUptae         = $rowTax[BUSNSECT_NM];            //업태
            $rJongmok       = $rowTax[DETAIL_NM];        //종목
        }

        $blankNum       = 11 - strlen($rowTax[SUP_AMT_SM]);                //공란수
        $sumNum       = strlen($rowTax[SUP_AMT_SM]);            //공급가액자리수
        $billnum      = strlen($rowTax[TX_SM]);                //세액자리수
        $bigo            = $rowTax[ETAXBIL_NOTE];    //총 비고

        $year           = substr($rowTax[WRITE_DT],0,4);    //년
        $month          = substr($rowTax[WRITE_DT],4,2);    //월
        $day            = substr($rowTax[WRITE_DT],6,2);    //일

        $cash           = number_format($rowTax[cash]);            //현금
        $checkPrice     = number_format($rowTax[checkPrice]);    //수표
        $bill           = number_format($rowTax[bill]);            //어음
        $onCredit       = number_format($rowTax[onCredit]);        //외상미수금

        $RCPT_RQEST_TP_CD = $rowTax[RCPT_RQEST_TP_CD];
        if ($rowTax[RCPT_RQEST_TP_CD] == "01") {
            $irecved = "영수";
        } else if ($rowTax[RCPT_RQEST_TP_CD] == "02"){
            $irecved = "청구";
        }

        $ORG_ETAXBIL_APPV_NO = $rowTax['ORG_ETAXBIL_APPV_NO'];
    }

    //_pr($rowTaxArray);

    if($rowcnt>5){
        $rowTaxArray[4]['THNG_NM'] = $rowTaxArray[4]['THNG_NM']."외 {$ov_cnt}건";
        $rowTaxArray[4]['THNG_STNDRD_NM'] = "";
        $rowTaxArray[4]['THNG_UNTPC'] = 0;
        if($_GET['edit_type']=='04' || $_GET['edit_type']=='06' || $_GET['edit_type']=='03' || $_GET['edit_type']=='01'){ // 04:계약의 해제, 06:이중발행 정정, 03:환입 01:기재사항 착오는 첫번째 부(-)계산서 보여주기용
            $rowTaxArray[4]['THNG_QTY'] = $rowTaxArray[4]['THNG_QTY']-$ov_qty;
            $rowTaxArray[4]['THNG_SUP_AMT'] = $rowTaxArray[4]['THNG_SUP_AMT']-$ov_amt;
            $rowTaxArray[4]['THNG_TX'] = $rowTaxArray[4]['THNG_TX']-$ov_vat;
        }
    }

    @mysql_close($connect_tax);


?>
<style>
    .tax_explain_title {font-size:15px;font-weight:bold; margin:3px 10px; }
    .tax_explain_div {margin:5px 20px;}
    .tax_explain_div p { font-size:13px; color:#00A2E8;}
</style>

<!--상세페이지-->
<div class="taxSection">
<form name='edit_next_form' id='edit_next_form' action="">
<?php if($_GET['edit_type']=='01'){?>
    <div class='tax_explain_title'>수정세금계산서 - 기재사항 착오(마이너스 발행분)</div>
    <div class='tax_explain_div'>
        <p>※ 당초 발행된 전자세금계산서에 대한 부(-)의 계산서가 아래와 같이 발급됩니다.</p>
        <p>&nbsp;&nbsp;부의 세금계산서 1장, 새로 작성된 세금계산서 1장해서 총 2장이 발행됩니다.</p>
    </div>
<?php }?>
<?php if($_GET['edit_type']=='06'){?>
    <div class='tax_explain_title'>수정세금계산서 - 이중발행 정정(마이너스 발행분)</div>
    <div class='tax_explain_div'>
        <p></p>
        <p></p>
    </div>
<?php }?>
<?php if($_GET['edit_type']=='02'){?>
    <div class='tax_explain_title'>수정세금계산서 - 공급가액 변동(수정 발행분)</div>
    <div class='tax_explain_div'>
        <p></p>
        <p></p>
    </div>
<?php }?>
<?php if($_GET['edit_type']=='04'){?>
    <div class='tax_explain_title'>수정세금계산서 - 계약의 해제(마이너스 발행분)</div>
    <div class='tax_explain_div'>
        <p></p>
        <p></p>
    </div>
<?php }?>
<?php if($_GET['edit_type']=='03'){?>
    <div class='tax_explain_title'>수정세금계산서 - 환입(마이너스 발행분)</div>
    <div class='tax_explain_div'>
        <p></p>
        <p></p>
    </div>
<?php }?>
    <div id="ly_image" class='dialog_ly_image'>
<?php 
if($_GET['edit_type']=='02'){ //공급가액 변동일때
    if($taxtype2=='01' && ($taxtype=='01' || $taxtype=='02')){ // 과세
        include("./include/new_tax_edit2.php");
        $tax_type='과세';
    } else if($taxtype == "03" or $taxtype == "04"){ // 면세
        include("./include/new_tax_free_edit2.php");
        $tax_type='면세';
    } else if($taxtype2=='02' && ($taxtype=='01' || $taxtype=='02')){ // 영세
        include("./include/new_tax_zero_edit2.php");
        $tax_type='영세';
    }
} else { // 그외의 기타 마이너스 세금계산서 표시용
    if($taxtype2=='01' && ($taxtype=='01' || $taxtype=='02')){ // 과세
        include("./include/new_tax.php");
        $tax_type='과세';
    } else if($taxtype == "03" or $taxtype == "04"){ // 면세
        include("./include/new_tax_free.php");
        $tax_type='면세';
    } else if($taxtype2=='02' && ($taxtype=='01' || $taxtype=='02')){ // 영세
        include("./include/new_tax_zero.php");
        $tax_type='영세';
    }
}
?>        
    </div>
    <div class="btnArea">
    <?php if($_GET['edit_type']=='04' || $_GET['edit_type']=='06' || $_GET['edit_type']=='03'){?>
        <a href="javascript:minus_tax_send()" class="redBtn"><span>부(-)세금계산서 발급</span></a>
        <a href="#" class="blackBtn tax_edit_close2"><span>취소</span></a>
    <?php }?>
    <?php if($_GET['edit_type']=='02'){?>
        <a href="javascript:change_tax_send()" class="redBtn"><span>변동세금계산서 발급</span></a>
        <a href="#" class="blackBtn tax_edit_close2"><span>취소</span></a>
    <?php }?>
    <?php if($_GET['edit_type']=='01'){?>
        <a href="javascript:minus_and_add_tax_view()" class="redBtn add_view_btn"><span>부(-)계산서 확인</span></a>
        <a href="javascript:minus_and_add_tax_send()" class="redBtn add_edit_btn" style='display:none;'><span>추가수정 발급</span></a>
        <a href="#" class="blackBtn tax_edit_close2"><span>취소</span></a>
    <?php }?>
    </div>
    <input type='hidden' name='ChangeBillAPPV' value='<?php echo $appv;?>'>
    <input type='hidden' name='ChangeReason' value='<?php echo $edit_type;?>'>
    <input type='hidden' name='ChangeBillDate' value='<?php echo $isudate;?>'>

    <input type='hidden' name='srvCode' value='<?php echo $srv;?>'>
    <input type='hidden' name='CompanyNum' value='<?php echo $compsn;?>'>
    <input type='hidden' name='new_email' value='<?php echo $rOFFEM;?>'>
    <input type='hidden' name='etxbil_note' value='<?php echo $etxbil_note;?>'>    

    <input type='hidden' name='totalprice' value=''>
    <input type='hidden' name='totaltax' value=''>
    <input type='hidden' name='sumPrice' value=''>
</form>
</div><!--//taxSection-->
<script>
$(function(){
    $(document).off("blur",".edit_number");
    $(document).on("blur",".edit_number",function(){
        $tr_obj = $(this).closest("tr");
        $id = $(this).attr("id");
        var v_cnt = number_ch($tr_obj.find("#id_cnt").val());
        var v_unit = number_ch($tr_obj.find("#id_unitPrice").val());
        var v_offer = number_ch($tr_obj.find("#id_offerPrice").val());
        var v_vat = number_ch($tr_obj.find("#id_billPrice").val());

        if(($id=='id_cnt' || $id=='id_unitPrice') && v_cnt!=0 && v_unit!=0){ // 수량, 단가변동일때 처리
            v = v_cnt*v_unit;
            $tr_obj.find("#id_offerPrice").val(formatCurrency(v));
            if('<?php echo $tax_type;?>'=='과세'){
                vv = Math.round(v*0.1);
                $tr_obj.find("#id_billPrice").val(formatCurrency(vv));
            }
        }
        if($id=='id_offerPrice' && v_offer!=0 && '<?php echo $tax_type;?>'=='과세'){ // 공급가액 변동일때 처리
            if(confirm('부가세 자동계산하시겠습니까?')){
                v = Math.round(v_offer*0.1);
                $tr_obj.find("#id_billPrice").val(formatCurrency(v));
            }
        }
        sum_price();        
    });
});

function sum_price(){
    form_data = $("form[name='edit_next_form']").serialize();
    $.ajax({type:"post", url:"ajax.tax_edit_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_total = $(xml).find("total").text();
            var v_sum_tot = $(xml).find("sum_tot").text();
            var v_sum_amt = $(xml).find("sum_amt").text();
            var v_sum_vat = $(xml).find("sum_vat").text();
            var v_last_OP = $(xml).find("last_OP").text();
            var v_last_BP = $(xml).find("last_BP").text();
            var v_blank_len = $(xml).find("blank_len").text();

            var v_add_key_list = $(xml).find("add_key_list").text();
            var v_add_seq_list = $(xml).find("add_seq_list").text();
            if(v_mode_ok!='Y' && v_msg!=''){
                alert(v_msg);
            } else {
                $("input[name='totalprice']").val(v_sum_amt);
                $("input[name='totaltax']").val(v_sum_vat);
                $("input[name='sumPrice']").val(v_sum_tot);
                $(".cl_blank").html(v_blank_len);
                $(".cl_total").html(v_total);
                for(i=0;i<11;i++){
                    v = v_last_OP.substring(i,i+1);
                    $("#id_sum_"+i).html(v);
                }
                for(i=0;i<10;i++){
                    v = v_last_BP.substring(i,i+1);
                    $("#id_vat_"+i).html(v);
                }
            }
        },
        error:function(rtn,status,error){    alert(error);        }
    });
}

function minus_tax_send(){ // 마이너스 세금계산서 발급 이중발행정정, 계약의 해제, 환입일 경우
    if(confirm('이대로 수정세금계산서를 발행하시겠습니까?')){
        form_data = $("form[name='edit_next_form']").serialize();
        $.post("curl_send_soap_edit_process.php",form_data,function(rtn){
            v = rtn.split(":");
            if(v[0]=='ok'){
                alert('수정세금계산서가 정상적으로 발행되었습니다.');
                document.location.reload();
            } else {
                alert(rtn);
            }
        });
    }
}

function change_tax_send(){ // 수정발행분 처리일경우
    if(confirm('이대로 수정세금계산서를 발행하시겠습니까?')){
        form_data = $("form[name='edit_next_form']").serialize();
        $.post("curl_send_soap_edit2_process.php",form_data,function(rtn){
            v = rtn.split(":");
            if(v[0]=='ok'){
                alert('수정세금계산서가 정상적으로 발행되었습니다.');
                document.location.reload();
            } else {
                alert(rtn);
            }
        });
    }
}

function minus_and_add_tax_view(){ // 기재사항 착오정정의 마이너스분 화면으로 이동 처리
    if(confirm('추가세금계산서 발급화면으로 이동합니다.')){
        form_data = $("form[name='edit_next_form']").serialize();
        $.post("ajax_edit1_send.php",form_data,function(rtn){
            $(".dialog_ly_image").html(rtn);
            $(".add_edit_btn").show();
            $(".add_view_btn").hide();
            $(".tax_explain_title").html("수정세금계산서 - 기재사항 착오(수정 발행분)");
            $(".tax_explain_div").html("<p>※ 여기서 수정한 내용은 매출전표에 자동반영되지 않기 때문에 금액변동시 매출전표는 직접수정하셔야 합니다.</p><p>※ 당초 세금계산서 작성일을 기재하는 것이 원칙이며, 정정 사유 중 작성일자를 잘못 기재한 경우만 올바른 작성일자로 수정 가능합니다.</p>");
            $("#modal_member_box2").height("700px");
            //alert(rtn);
        });
    }
}

function minus_and_add_tax_send(){ // 기재사항 착오정저의 최종 처리
    if(confirm('이대로 수정세금계산서를 발행하시겠습니까?')){
        form_data = $("form[name='edit_next_form']").serialize();
        $.post("curl_send_soap_edit1_process.php",form_data,function(rtn){
            v = rtn.split(":");
            if(v[0]=='ok'){
                alert('수정세금계산서가 정상적으로 발행되었습니다.');
                document.location.reload();
            } else {
                alert(rtn);
            }
        });
    }
}
</script>