webadmin.php

/home/mjc1/public_html/emillennium/taxbill.reg.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);    


//_pr($_POST);

$code_list = "";
$midx_list = "";

if($sel_mode=='detail'){
    foreach($code_idx as $key=>$val){
        if(substr($codes[$val],0,1)=='g'){
            $code_list .= "{$codes[$val]},";
            $v = explode("^",$codes[$val]);
            if($v[0]=='g'){
                $midx = trim($v[2]); $seq = trim($v[3]);
                if($midx!='' && $seq!=''){
                    $midx_list .= "(b.midx = '$midx' and b.seq = '$seq') or ";
                }
            }
        }
    }
    $code_list = substr($code_list,0,strlen($code_list)-1);
    $midx_list = substr($midx_list,0,strlen($midx_list)-3);
} else if($sel_mode=='sum'){
    foreach($code_idx as $key=>$val){
        if(substr($codes[$val],0,1)=='g'){
            $code_list .= "{$codes[$val]},";
        }
    }
    $code_list = substr($code_list,0,strlen($code_list)-1);
}
//_pr($code_list);

$sql = "select * from offices where code = 1 ";
$res = mysql_query($sql,$connect_e1000y);
while($minfo = mysql_fetch_array($res)){
    $code = $minfo['code'];
    $comp_sn = $minfo['comp_sn'];
    $telno1 = $minfo['telno1'];
    $hpno = $minfo['hpno'];
    $faxno = $minfo['faxno'];
    $sub_comp_sn = $minfo['sub_comp_sn'];
    $biz_status = $minfo['biz_status'];
    $biz_item = $minfo['biz_item'];
    $comp_name = $minfo['comp_name'];
    $ceo_name = $minfo['ceo_name'];
    $zipcode = $minfo['zipcode'];
    $addr_m = $minfo['addr_m'];
    $addr_d = $minfo['addr_d'];

    $tax_charge_name = $minfo['tax_charge_name'];
    $tax_charge_hpno = $minfo['tax_charge_hpno'];
    $tax_charge_email = $minfo['tax_charge_email'];

    $buy_array[] = $minfo;
}

$PointSQL = "SELECT curpoint FROM cust_cash WHERE id = '$eid'";
$PointResult = MYSQL_QUERY($PointSQL,$connect_cash);
$PointRow = MYSQL_FETCH_ARRAY($PointResult);

$mypoint = $PointRow[curpoint];

$office_comp_sn = str_replace("-","",$comp_sn);
$sql = "SELECT * FROM tn_caaa WHERE BUSNID = '{$office_comp_sn}' ";
$res = mysql_query($sql,$connect_tax);
$tax_cert_info = mysql_fetch_array($res);
$tax_cert_info['END_DT2'] = substr($tax_cert_info['END_DT'],0,4)."-".substr($tax_cert_info['END_DT'],4,2)."-".substr($tax_cert_info['END_DT'],6,2);

$cur_month = date("m",time());
if($cur_month==12){ $nxt_month = 1;} 
else { $nxt_month = $cur_month+1; }

@mysql_close($connect_tax);

?>

<style>
    .send_date_em em { color:#9dcc34; font-weight:bold; }
</style>
<form name='taxbill_reg_form' method='post' action=''>
<input type='hidden' name='qstr' value=''>
<input type="hidden" name="code_list" value="<?php echo $code_list;?>">
<input type="hidden" name="midx_list" value="<?php echo $midx_list;?>">
<input type='hidden' name='sdate' value='<?php echo $sdate;?>'>
<input type='hidden' name='edate' value='<?php echo $edate;?>'>
<input type='hidden' name='sel_mode' value='<?php echo $sel_mode;?>'>
<input type='hidden' name='sendmode' value=''>
<input type='hidden' name='smode' size='' value='<?php echo $smode;?>'>
    <div id="sub-contents-area">
        <div class="sub-btn-area">
            <div class="sub-btn pop-btn">
                <?php if($smode==''){?><a class="lignt-blue-btn" id='btn_tax_comp'>내부발행</a><?php }?><a class="gray-btn" id='btn_tax_nts'>국세청발행</a><a class="black-btn" id='sel_cancel'>취소</a>
            </div>
        </div>
    </div>

<div class='cust_modal1'>
    <h4>발행 설정</h4>
    <table class="order-sheet table-top-border">
        <caption class="screen_out">발행 설정</caption>
        <colgroup>
            <col style="width:100px;"><col style="width:230px;">
            <col style="width:100px;"><col style="width:230px;">
        </colgroup>

        <tbody>
        <tr>
            <th>청구/영수 구분</th>
            <td colspan=3>
                <input type='radio' name='recved_yn' value='0' checked> 청구&nbsp;&nbsp; <input type='radio' name='recved_yn' value='1'> 영수
            </td>
        </tr>
        <tr>
            <th>SMS전송</th>
            <td colspan=3><input type='checkbox' name='sms_send' value='on'> (국세청발송만 해당)
                
            </td>
        </tr>
        <tr>
            <th>[도장] 인쇄</th>
            <td colspan=3>
                <input type='checkbox' name='seal_print' value='1'> 도장 : <img src='http://mjsoft.co/seal/<?php echo $comp_sn;?>.gif' onerror="this.style.display='none';" width=28>
            </td>
        </tr>
<?php if($smode==''){?>
        <tr>
            <th>작성일자</th>
            <td colspan=3>
                <input type='radio' name='c_date_type' value='0' checked> 그대로설정 &nbsp;&nbsp;<input type='radio' name='c_date_type' value='1'> 임의설정 <input type='text' name='c_date' id='c_date' value='<?php echo date("Y-m-d",time())?>' class='width_80'>
            </td>
        </tr>
        <tr>
            <th>거래일자</th>
            <td colspan=3>
                <input type='radio' name='d_date_type' value='0' checked> 그대로설정 &nbsp;&nbsp;<input type='radio' name='d_date_type' value='1'> 임의설정 <input type='text' name='d_date' id='d_date' value='<?php echo date("Y-m-d",time())?>' class='width_80'>
            </td>
        </tr>
<?php }?>
        <tr>
            <th>보유포인트</th>
            <td colspan=3>
                <?php echo number_format($mypoint); ?> (P) -> 전자세금계산서 1건당 150p차감, sms전송시 170p차감
            </td>
        </tr>
        <tr>
            <th>공인인증서 만료일</th>
            <td colspan=3>
                <?php if($tax_cert_info['END_DT']<date("Ymd",time())){ echo $tax_cert_info['END_DT2']." <font color='red'>[인증서 만료]</font>"; } else { echo $tax_cert_info['END_DT2']; }?>
            </td>
        </tr>
        <tr>
            <th>국세청 전송기한</th>
            <td colspan=3 class='send_date_em'>
                <em><?php echo $cur_month;?>월분</em> 전송기한 : <em><?php echo $nxt_month;?>월 10일</em>까지
            </td>
        </tr>
    </table>
</div>

</form>
<script>
$(function(){
    setTimeout(function(){ // 레이어 사이즈 재 조정
        var v = $(".cust_modal1").height();
        v = v+80;
        $("#modal_member_box").height(v);
    },1000);

    $(".pop-btn a").css("color","#fff");

    $("#sel_cancel").click(function(){ // 닫기
        $("#modal_member_box").dialog("close");
    });

    $("#btn_state_printer2").click(function(){ // 인쇄 발행
        window.open("","state_print", "width=800, height=800, scrollbars=yes");
        $("input[name='sendmode']").val("print");
        taxbill_reg_form.action='statement_print.php';
        taxbill_reg_form.target='state_print';
        taxbill_reg_form.submit();
    });

    $("#btn_state_email2").click(function(){ // 메일전송 발행
        window.open("","state_print", "width=800, height=800, scrollbars=yes");
        $("input[name='sendmode']").val("email");
        $("select[name='print_type']").val('3')
        taxbill_reg_form.action='statement_print.php';
        taxbill_reg_form.target='state_print';
        taxbill_reg_form.submit();
    });

    $("#btn_tax_comp").click(function(){ // 내부발행
        $("input[name='sendmode']").val("direct");
        var form_data = $("form[name='taxbill_reg_form']").serialize();

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

    $("#btn_tax_nts").click(function(){ // 국세청 발행
        $("input[name='sendmode']").val("nts");
        var form_data = $("form[name='taxbill_reg_form']").serialize();

        $.post("taxbill_check_reg.inc.php",form_data,function(rtn){
            //alert(rtn);
            $("#modal_member_box2").html(rtn);
        });

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

    $("#c_date").datepicker({
        showOn: "button",
        buttonImage: "./images/common/calendar.png",
        buttonImageOnly: true,
        buttonText: "Select date",
        dateFormat: "yy-mm-dd",
        changeMonth: true,
        changeYear: true,
            monthNames: ['1월','2월','3월','4월','5월','6월','7월','8월','9월','10월','11월','12월'],
            monthNamesShort: ['1월','2월','3월','4월','5월','6월','7월','8월','9월','10월','11월','12월'],
            dayNames: ['일','월','화','수','목','금','토'],
            dayNamesShort: ['일','월','화','수','목','금','토'],
            dayNamesMin: ['일','월','화','수','목','금','토'],
            showMonthAfterYear: true,
            yearSuffix: '년'
    }).change(function(){
        $("input[name='c_date_type']").eq(1).prop("checked",true);
    });

    $("#d_date").datepicker({
        showOn: "button",
        buttonImage: "./images/common/calendar.png",
        buttonImageOnly: true,
        buttonText: "Select date",
        dateFormat: "yy-mm-dd",
        changeMonth: true,
        changeYear: true,
            monthNames: ['1월','2월','3월','4월','5월','6월','7월','8월','9월','10월','11월','12월'],
            monthNamesShort: ['1월','2월','3월','4월','5월','6월','7월','8월','9월','10월','11월','12월'],
            dayNames: ['일','월','화','수','목','금','토'],
            dayNamesShort: ['일','월','화','수','목','금','토'],
            dayNamesMin: ['일','월','화','수','목','금','토'],
            showMonthAfterYear: true,
            yearSuffix: '년'
    }).change(function(){
        $("input[name='d_date_type']").eq(1).prop("checked",true);
    });
});

</script>