1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
|
<?php header("Content-type:text/html;charset=euckr"); ?>
<?php include("./_common.php"); ?>
<?php
$sql = "select * from office where code = 1";
$result = mysql_query($sql,$connect_ezbill);
$comp_row = mysql_fetch_array($result);
$ChangeReason = $_POST['ChangeReason'];
$ChangeBillAPPV = $_POST['ChangeBillAPPV'];
$ChangeBillDate = $_POST['ChangeBillDate'];
$code = $ChangeBillAPPV;
$code_dash = substr($code,0,8)."-".substr($code,8,8)."-".substr($code,16,8);
$connect_tax = @mysql_connect($DB_HOSTtax,$DB_USERtax,$DB_PWDtax);
@mysql_select_db( $DB_NAMEtax,$connect_tax);
if($code!=''){
$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 = '$code'";
//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) 수정사유:기재사항 착오 정정용 부(-)계산서";
$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;
$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;
}
//_pr($rowTaxArray);
} // end if($code)
@mysql_close($connect_tax);
//echo $taxtype;
?>
<?php if($_POST['ChangeReason']=='01'){ // 기재사항 착오 수정용?>
<? if($taxtype2=='01' && ($taxtype=='01' || $taxtype=='02')){ $tax_simple_type = "1"; //일반 ?>
<? include("./include/new_tax_edit1.php"); ?>
<? } if($taxtype == "03" or $taxtype == "04"){ $tax_simple_type = "2"; //면세 ?>
<? include("./include/new_tax_free_edit1.php"); ?>
<? } if($taxtype2=='02' && ($taxtype=='01' || $taxtype=='02')){ $tax_simple_type = "3"; //영세 ?>
<? include("./include/new_tax_zero_edit1.php"); ?>
<? } ?>
<?php } ?>
<input type='hidden' name='vat_type' id='vat_type' value='<?php echo $vat_type?>'> <!-- 0:VAT별도, 1:VAT포함 -->
<input type='hidden' name='tax_simple_type' id='tax_simple_type' value='<?php echo $tax_simple_type?>'> <!-- 0:VAT별도, 1:VAT포함 -->
|