webadmin.php

/home/mjc1/public_html/emillennium/taxbill_check_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);

$midx_list = stripslashes($midx_list);

$f_list['s_comp_sn'] = "공급자 사업자번호";
$f_list['s_sub_comp_sn'] = "공급자 종 사업자번호";
$f_list['s_comp_name'] = "공급자 상호명";
$f_list['s_ceo_name'] = "공급자 대표자";
$f_list['s_addr'] = "공급자 주소";
$f_list['s_biz_status'] = "공급자 업태";
$f_list['s_biz_item'] = "공급자 종목";
$f_list['stc_name'] = "공급자 담당자성명";
$f_list['stc_hpno'] = "공급자 담당자핸드폰";
$f_list['stc_email'] = "공급자 담당자이메일";

$f_list['r_comp_sn'] = "공급받는자 사업자번호";
$f_list['r_sub_comp_sn'] = "공급받는자 종 사업자번호";
$f_list['r_comp_name'] = "공급받는자 상호명";
$f_list['r_ceo_name'] = "공급받는자 대표자";
$f_list['r_addr'] = "공급받는자 주소";
$f_list['r_biz_status'] = "공급받는자 업태";
$f_list['r_biz_item'] = "공급받는자 종목";
$f_list['rtc_name'] = "공급받는자 담당자성명";
$f_list['rtc_hpno'] = "공급받는자 담당자핸드폰";
$f_list['rtc_email'] = "공급받는자 담당자이메일";

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

$mypoint = $PointRow[curpoint];
if(trim($mypoint)==''){ $mypoint = 0; }
$usepoint = 0;

if($smode=='comp'){ // 내부발행일건일때 
    $sql = "select * from                     
                    (select a.ccode, 
                                        c.comp_sn as s_comp_sn, c.sub_comp_sn as s_sub_comp_sn, c.comp_name as s_comp_name, c.ceo_name as s_ceo_name,
                                        concat(c.addr_m,' ',c.addr_d) as s_addr, c.biz_status as s_biz_status, c.biz_item as s_biz_item,
                                        c.tax_charge_name as stc_name, c.tax_charge_hpno as stc_hpno, c.tax_charge_email as stc_email,
                                        
                                        d.comp_sn as r_comp_sn, d.sub_comp_sn as r_sub_comp_sn, d.comp_name as r_comp_name, d.ceo_name as r_ceo_name,
                                        concat(d.addr_m,' ',d.addr_d) as r_addr, d.biz_status as r_biz_status, d.biz_item as r_biz_item,
                                        d.tax_charge_name as rtc_name, d.tax_charge_hpno as rtc_hpno, d.tax_charge_email as rtc_email, a.writedate
                    from sale_tax_m a left join sale_tax_d b on a.midx = b.midx
                    left join offices c on c.code = 1
                    left join customers d on a.ccode = d.code
                    where {$midx_list} ) aa
                where 1=1
                group by ccode";

    $res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
    while($row = mysql_fetch_object($res)){ // 항목이 비어 있는지 체크
        $row_array[] = $row;
    }
} else if($sel_mode=='detail'){ // 상세일때 내부저장
    $sql = "select * from 
                (select a.ccode, 
                        c.comp_sn as s_comp_sn, c.sub_comp_sn as s_sub_comp_sn, c.comp_name as s_comp_name, c.ceo_name as s_ceo_name,
                        concat(c.addr_m,' ',c.addr_d) as s_addr, c.biz_status as s_biz_status, c.biz_item as s_biz_item,
                        c.tax_charge_name as stc_name, c.tax_charge_hpno as stc_hpno, c.tax_charge_email as stc_email,
                        
                        d.comp_sn as r_comp_sn, d.sub_comp_sn as r_sub_comp_sn, d.comp_name as r_comp_name, d.ceo_name as r_ceo_name,
                        concat(d.addr_m,' ',d.addr_d) as r_addr, d.biz_status as r_biz_status, d.biz_item as r_biz_item,
                        d.tax_charge_name as rtc_name, d.tax_charge_hpno as rtc_hpno, d.tax_charge_email as rtc_email
                        from sale_m a left join sale_d b on a.midx = b.midx
                        left join offices c on c.code = 1
                        left join customers d on a.ccode = d.code
                        where {$midx_list} ) aa
                    where 1=1
                    group by ccode
    ";
    //echo $sql;

    $res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
    while($row = mysql_fetch_object($res)){ // 항목이 비어 있는지 체크
        $row_array[] = $row;
    }
} else if($sel_mode=='sum'){ // 집계발행일때

    $ccode_tax = explode(",",$code_list);
    $ccode_list = "";
    foreach($ccode_tax as $key=>$val){
        $v = explode("^",$val);
        $ccode = $v[1];
        $ccode_list .= "{$ccode},";
    }
    $ccode_list = substr($ccode_list,0,strlen($ccode_list)-1);

    $sql = "select * from 
                (select a.ccode, 
                        c.comp_sn as s_comp_sn, c.sub_comp_sn as s_sub_comp_sn, c.comp_name as s_comp_name, c.ceo_name as s_ceo_name,
                        concat(c.addr_m,' ',c.addr_d) as s_addr, c.biz_status as s_biz_status, c.biz_item as s_biz_item,
                        c.tax_charge_name as stc_name, c.tax_charge_hpno as stc_hpno, c.tax_charge_email as stc_email,
                        
                        d.comp_sn as r_comp_sn, d.sub_comp_sn as r_sub_comp_sn, d.comp_name as r_comp_name, d.ceo_name as r_ceo_name,
                        concat(d.addr_m,' ',d.addr_d) as r_addr, d.biz_status as r_biz_status, d.biz_item as r_biz_item,
                        d.tax_charge_name as rtc_name, d.tax_charge_hpno as rtc_hpno, d.tax_charge_email as rtc_email
                        from sale_m a left join sale_d b on a.midx = b.midx
                        left join offices c on c.code = 1
                        left join customers d on a.ccode = d.code
                        where a.ccode in ($ccode_list) ) aa
                    where 1=1
                    group by ccode
    ";
    //echo $sql;

    $res = mysql_query($sql,$connect_e1000y); $all_sql .= $sql;
    while($row = mysql_fetch_object($res)){ // 항목이 비어 있는지 체크
        $row_array[] = $row;
    }
}

//_pr($row_array);

$office_comp_sn = str_replace("-","",$row_array[0]->s_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_DT'] = "20170730";

$sql = "SELECT * FROM members WHERE userid = '$eid' ";
$res = mysql_query($sql,$connect_tax);
$tax_mem_info = mysql_fetch_array($res);

@mysql_close($connect_tax);

?>
<script>
$(function(){
    if('<?php echo $tax_mem_info['userid'];?>'==''){ // 계산서 서버의 member에 해당 아이디 있는지 확인
        alert('이지텍스 국세청발급 중지상태입니다. \n\n고객센터에 연락하셔서 승인 받으시기 바랍니다.(1566-8680)');
        return;
    }
    if('<?php echo $tax_cert_info['END_DT']?>'==''){ // 공인인증서 정보가 있는지 확인
        alert('등록된 공인인증서가 없습니다. 공인인증서 등록화면으로 이동합니다.');
        url = "http://114.108.136.204:7000/applet.jsp";
        window.open(url,"cert","width=1024, height=768, scrollbars=yes");
        return;
    } else if('<?php echo $tax_cert_info['END_DT']?>'<'<?php echo date("Ymd",time())?>'){ // 공인인증서 유효기간 오버된지 확인
        alert('공인인증서가 만료 되었습니다. <?php echo $tax_cert_info['END_DT']?> 공인인증서 갱신 화면으로 이동합니다.');
        url = "http://114.108.136.204:7000/applet.jsp";
        window.open(url,"cert","width=1024, height=768, scrollbars=yes");
        return;
    }

    if(<?php echo $usepoint;?>><?php echo $mypoint;?>){ // 포인트 부족 확인
        alert('포인트가 부족합니다. 잔여포인트:<?php echo $mypoint;?>, 사용할포인트:<?php echo $usepoint;?>'); process_do='N';
    }

    var process_do = 'Y';

<?php
    foreach($row_array as $keys=>$row){ // 항목이 비어 있는지 체크
        $cnt = 0;
        $r_comp_name = $row->r_comp_name;
        $s_comp_name = $row->s_comp_name;
        foreach($row as $key=>$val){
            if($key=='writedate'){ // 작성일자 체크
?>
                var month_6m_date = '<?php echo date("Ymd",time()-60*60*24*182)?>';
                //현재일자
                var nowyear = '<?php echo date("Y",time());?>';
                var nowmonth = '<?php echo date("m",time());?>'
                var nowday = '<?php echo date("d",time());?>';

                //작성일자
                var year = '<?php echo substr($val,0,4);?>';
                var month = '<?php echo substr($val,5,2);?>';
                var day = '<?php echo substr($val,8,2);?>';

                var nowdate = String(nowyear)+String(nowmonth)+String(nowday);
                var writedate = String(year)+String(month)+String(day);            

                if(nowdate < writedate){
                    alert("작성일자는 미래일자로 할 수 없습니다.");
                    return;
                }            

                //기한체크
                var write = String(year)+String(month)+String(day);

                if(String(nowyear)+String(nowmonth)>String(year)+String(month)){
                    if(String(month)=="12"){
                        wl_year = String(number_ch(year)+1);
                        wl_month = "01";
                    } else {
                        wl_year = String((year));
                        wl_month = String(number_ch(month)+1);
                        if(wl_month.length==1){ wl_month = "0"+wl_month; }
                    }
                    
                    var write_limit = String(wl_year)+String(wl_month)+"10";
                    if(write_limit<nowdate){
                        alert("작성일자가 발급기한 이전입니다.\n가산세가 부과 될 수 있습니다.");
                    }
                }

                if(write<month_6m_date){
                    if(!confirm('작성일자가 6개월이상 지났습니다. 정말 발행하시겠습니까?')){
                        var process_do = 'N';
                    }
                }
<?php
                continue;
            }
            if($cnt>1){
                if(trim($val)==''){
                    if($cnt>11){
                        $comp_name = $r_comp_name;
                    } else {
                        $comp_name = $s_comp_name;
                    }
?>
    if(process_do=='Y'){
        if(!confirm('<?php echo $comp_name."의 ".$f_list[$key]."의 항목이 없습니다.그대로 적용하시겠습니까?";?>')){
            var process_do = 'N';
        }
    }
<?php
                }
            }
            $cnt++;
        }
        if($sms_send=='1'){
            $usepoint += 170;
        } else {
            $usepoint += 150;
        }
    }
?>
    if(process_do=='Y'){
        if(confirm('정말로 국세청 발행하시겠습니까?')){
            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);        }
            });
        }
    }
});
</script>