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
|
<?php
$dir = ".";
include_once($dir."/_common.php");
$connect_tax = @mysql_connect($DB_HOSTtax,$DB_USERtax,$DB_PWDtax);
@mysql_select_db( $DB_NAMEtax,$connect_tax);
$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($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]); //공급가액자리수
$offerPrice = $rowTax[SUP_AMT_SM]; //공급가액
$billnum = strlen($rowTax[TX_SM]); //세액자리수
$billprice = $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); //일
$totalPrice = number_format($rowTax[TOT_AMT]); //합계금액
$cash = number_format($rowTax[cash]); //현금
$checkPrice = number_format($rowTax[checkPrice]); //수표
$bill = number_format($rowTax[bill]); //어음
$onCredit = number_format($rowTax[onCredit]); //외상미수금
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_QTY'] = $rowTaxArray[4]['THNG_QTY']+$ov_qty;
$rowTaxArray[4]['THNG_UNTPC'] = 0;
$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);
?>
<!--상세페이지-->
<div class="taxSection">
<div id="ly_image">
<?php
if($taxtype2=='01' && ($taxtype=='01' || $taxtype=='02')){ // 과세
include("./include/new_tax.php");
} else if($taxtype == "03" or $taxtype == "04"){ // 면세
include("./include/new_tax_free.php");
} else if($taxtype2=='02' && ($taxtype=='01' || $taxtype=='02')){ // 영세
include("./include/new_tax_zero.php");
}
?>
</div>
</div><!--//taxSection-->
|