YNU_JEUS/app_home/himed/webapps/mis/addtaxweb/xrw/SMRAT00300_DTI세금계산서일괄생성Mapping.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>DTI-NU 중복 Mapping 검증</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<disconnected>
							<disconnectedlist/>
						</disconnected>
						<connectable>
							<connectablelist/>
						</connectable>
					</main>
					<send>
						<condition1>
							<instcd/>
							<fromdd/>
							<todd/>
							<taxbillkind>4</taxbillkind>
							<taxbillflag>1</taxbillflag>
						</condition1>
						<condition2>
							<instcd/>
							<fromdd/>
							<todd/>
							<taxbillkind>4</taxbillkind>
							<taxbillflag>1</taxbillflag>
						</condition2>
					</send>
					<init>
						<init_taxbillkind>
							<item>
								<label>세금계산서</label>
								<value>4</value>
							</item>
							<item>
								<label>계산서</label>
								<value>5</value>
							</item>
						</init_taxbillkind>
						<init_taxbillflag>
							<item>
								<label>매입</label>
								<value>1</value>
							</item>
							<item>
								<label>매출</label>
								<value>2</value>
							</item>
						</init_taxbillflag>
						<grd_disconnectedlist/>
					</init>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
			<script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[

					fInitialize();

				]]>
			</script>
			<script type="javascript">
				<![CDATA[

					function fInitialize()
					{
						model.removeNodeset(grd_disconnectedlist.nodeset);
						model.removeNodeset(grd_connectablelist.nodeset);					
						
						model.setValue("/root/send/condition1/instcd",   	getUserInfo("dutplceinstcd"));
						model.setValue(ipt_fromdd.attribute("ref"),			getCurrentDate());
						model.setValue(ipt_todd.attribute("ref"),			getCurrentDate());
						model.setValue("/root/send/condition2/instcd",   	getUserInfo("dutplceinstcd"));
						model.setValue(ipt_fromdd_1.attribute("ref"),		getCurrentDate());
						model.setValue(ipt_todd_1.attribute("ref"),			getCurrentDate());
						grd_disconnectedlist.rowHeight(0) = 35;
						grd_connectablelist.rowHeight(0) = 35;
						
						misfGridComboComCdList("R0364", grd_disconnectedlist, "proc_flag", "");
						
						model.refresh();						
					}
					
				]]>
			</script>
			<bind id="bindSecPageCnt" ref="/root/send/printparams/secPageCnt" calculate="count(/root/main/printlist/secpage)"/>
			<bind id="bindAllEtcProf" ref="/root/send/printparams/allEtcProf" calculate="count(/root/main/list/etcproflist)"/>
			<bind id="bindAllCount" ref="/root/send/printparams/allCount" calculate="sum(/root/main/list/etcproflist/cnt)"/>
			<bind id="bindPayTotAmt" ref="/root/send/printparams/payTotAmt" calculate="sum(/root/main/list/etcproflist/paytotamt)"/>
			<bind id="bindProfTax" ref="/root/send/printparams/profTax" calculate="sum(/root/main/list/etcproflist/proftax)"/>
			<bind id="bindIncmTax" ref="/root/send/printparams/incmTax" calculate="sum(/root/main/list/etcproflist/incmtax)"/>
			<bind id="bindResdnTax" ref="/root/send/printparams/resdnTax" calculate="sum(/root/main/list/etcproflist/resdntax)"/>
			<bind id="bindSumAmt" ref="/root/send/printparams/sumAmt" calculate="sum(/root/main/list/etcproflist/sumamt)"/>
			<bind id="bindPayAmt" ref="/root/send/printparams/payAmt" calculate="sum(/root/main/list/etcproflist/payamt)"/>
			<bind id="bindChkCnt" ref="/root/hidden/checkedcnt" calculate="count(/root/main/list/etcproflist[chk='Y']/chk)"/>
			<submission id="TRRAT00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition1" resultref="/root/main/overlap"/>
			<submission id="TRRAT00302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition2" resultref="/root/main/tax"/>
		</model>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">전자세금계산서 일괄 mapping</caption>
			<caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:762px; ">
			<group id="grp_sea" style="left:0px; top:30px; width:1195px; height:60px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line5" class="line_4" style="x1:1107px; y1:16px; x2:1107px; y2:39px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:575px; top:9px; width:90px; height:17px; ">조회일자 :</caption>
				<input id="ipt_fromdd" ref="/root/send/condition1/fromdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:665px; top:8px; width:100px; height:19px; text-align:center; "/>
				<caption id="caption2" style="left:767px; top:10px; width:15px; height:20px; ">~</caption>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:17px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							model.removeNodeset(grd_disconnectedlist.nodeset);
							submit("TRRAT00301");

						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/condition1/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:780px; top:8px; width:100px; height:19px; text-align:center; "/>
				<caption id="caption7" class="search_name" style="left:285px; top:9px; width:99px; height:17px; ">계산서종류 :</caption>
				<select1 id="rdo_billkind" ref="/root/send/condition1/taxbillkind" class="radio_search" disabled="false" navindex="3" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:390px; top:8px; width:165px; height:20px; vertical-align:middle; border-style:none; ">
					<choices>
						<itemset nodeset="/root/init/init_taxbillkind/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="rdo_billflag" ref="/root/send/condition1/taxbillflag" class="radio_search" disabled="false" navindex="4" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:390px; top:35px; width:165px; height:20px; vertical-align:middle; border-style:none; ">
					<choices>
						<itemset nodeset="/root/init/init_taxbillflag/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption8" class="search_name" style="left:285px; top:35px; width:109px; height:17px; ">계산서구분 :</caption>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:115px; x2:1195px; y2:115px; "/>
			<datagrid id="grd_disconnectedlist" nodeset="/root/main/disconnected/disconnectedlist" backcoloralternate="#ffffff" caption="기관코드^일련번호^계산서종류^계산서구분^발행구분^사업자번호^거래처명^거래처&#xA;등록여부^상태^공급가액^부가세액^합계^계산서일자^과세종류^거래처담당자^거래처이메일^DTI세금계산서&#xA;번호^당당자이메일^비고" colsep="^" colwidth="0, 0, 0, 0, 100, 80, 120, 80, 80, 100, 100, 100, 80, 80, 80, 100, 100, 100, 0" explorerbar="sort" frozencols="21" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:0px; top:120px; width:1195px; height:250px; ">
				<col ref="instcd" visibility="hidden"/>
				<col ref="seqno" visibility="hidden"/>
				<col ref="taxbillkind" visibility="hidden"/>
				<col ref="taxbillflag" visibility="hidden"/>
				<col ref="isscust"/>
				<col ref="entrregno"/>
				<col ref="custnm"/>
				<col ref="reg_cust" style="text-align:center; "/>
				<col disabled="true" ref="proc_flag" type="combo">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="suplamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="valaddtax" type="combo" format="(-)#,###" style="text-align:right; padding-right:1; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="amt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="genrdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="taxkind" type="combo">
					<choices>
						<item>
							<label>과세</label>
							<value>01</value>
						</item>
						<item>
							<label>영세율</label>
							<value>02</value>
						</item>
						<item>
							<label>대손세액가감</label>
							<value>03</value>
						</item>
						<item>
							<label>비과세</label>
							<value>04</value>
						</item>
						<item>
							<label>면세</label>
							<value>05</value>
						</item>
					</choices>
				</col>
				<col ref="custdtieacntchrgnm"/>
				<col ref="custdtiemailaddr"/>
				<col ref="inv_no"/>
				<col ref="dtiemail"/>
				<col ref="cmt"/>
			</datagrid>
			<caption id="caption21" class="tit_2" style="left:5px; top:97px; width:310px; height:13px; ">mapping 되지 않은 DTI 전자세금계산서 목록</caption>
			<group id="group2" scroll="auto" style="left:0px; top:0px; width:1195px; height:27px; ">
				<line id="line1" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
				<button id="btn_print" class="btn4_letter2" visibility="hidden" style="left:5px; top:3px; width:56px; height:22px; ">
					<caption>출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
					

						]]>
					</script>
				</button>
			</group>
			<button id="btn_excel" class="btn2_letter4" style="left:1126px; top:94px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							
						var sFromdd 	= model.getValue(ipt_fromdd.attribute("ref")).substr(2, 2) + "-" + model.getValue(ipt_fromdd.attribute("ref")).substr(4, 2) + "-" + model.getValue(ipt_fromdd.attribute("ref")).substr(6, 2);
						var sTodd		= model.getValue(ipt_todd.attribute("ref")).substr(2, 2) + "-" + model.getValue(ipt_todd.attribute("ref")).substr(4, 2) + "-" + model.getValue(ipt_todd.attribute("ref")).substr(6, 2);
						
						var sTitle = "mapping 되지 않은 DTI 전자세금계산서 목록 " + sFromdd + " ~ " + sTodd;
						grd_disconnectedlist.rebuild();
						misfSaveExcel(grd_disconnectedlist, sTitle);
					]]>
				</script>
			</button>
			<datagrid id="grd_connectablelist" nodeset="/root/main/connectable/connectablelist" backcoloralternate="#ffffff" caption="기관코드_DTI^기관코드^기관코드일치여부^계산서종류_DTI^계산서종류^계산서종류일치여부^계산서구분_DTI^계산서구분^계산서구분일치여부^발행구분_DTI^발행구분^발행구분일치여부^공급가액_DTI^공급가액^공급가액일치여부^부가세액_DTI^부가세액^부가세액일치여부^합계_DTI^합계^합계일치여부^계산서일자_DTI^계산서일자^계산서일자일치여부^사업자등록번호_DTI^사업자등록번호^사업자등록번호일치여부^담당자이메일_DTI^담당자이메일^담당자이메일일치여부^거래처이메일_DTI^거래처이메일^거래처이메일일치여부^DTI연동여부^세금계산서구분^일련번호^미결전표일자^미결전표번호^미결전표일련번호^DTI세금계산서번호" colsep="^" colwidth="0,80,0,0,100,0,0,100,0,0,100,0,0,100,0,0,100,0,0,100,0,0,80,0,0,100,0,0,100,0,0,100,0,80,100,0,80,80,80,80" explorerbar="sort" frozencols="21" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:0px; top:460px; width:1195px; height:302px; ">
				<col ref="instcd_dti"/>
				<col ref="instcd_tax"/>
				<col ref="eq_instcd"/>
				<col ref="taxbillkind_dti"/>
				<col ref="taxbillkind_tax"/>
				<col ref="eq_taxbillkind"/>
				<col ref="taxbillflag_dti"/>
				<col ref="taxbillflag_tax"/>
				<col ref="eq_taxbillflag"/>
				<col ref="isscust_dti"/>
				<col ref="isscust_tax"/>
				<col ref="eq_isscust"/>
				<col ref="suplamt_dti" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="suplamt_tax" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="eq_suplamt"/>
				<col ref="valaddtax_dti" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="valaddtax_tax" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="eq_valaddtax"/>
				<col ref="amt_dti" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="amt_tax" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="eq_amt"/>
				<col ref="genrdd_dti" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="genrdd_tax" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="eq_genrdd"/>
				<col ref="entrregno_dti"/>
				<col ref="entrregno_tax"/>
				<col ref="eq_entrregno"/>
				<col ref="dtiemail_dti"/>
				<col ref="dtiemail_tax"/>
				<col ref="eq_dtiemail"/>
				<col ref="emailaddr_dti"/>
				<col ref="emailaddr_tax"/>
				<col ref="eq_emailaddr"/>
				<col ref="dtibillyn"/>
				<col ref="ebillflag"/>
				<col ref="seqno"/>
				<col ref="unsldd"/>
				<col ref="unslno"/>
				<col ref="undeciseqno"/>
				<col ref="inv_no"/>
			</datagrid>
			<caption id="caption5" class="tit_2" style="left:5px; top:441px; width:485px; height:13px; ">mapping 가능한 nU 부가세 List</caption>
			<line id="line2" class="line_1" style="x1:0px; y1:455px; x2:1195px; y2:455px; "/>
			<button id="button1" class="btn2_letter4" style="left:1127px; top:434px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var sFromdd 	= model.getValue(ipt_fromdd.attribute("ref")).substr(2, 2) + "-" + model.getValue(ipt_fromdd.attribute("ref")).substr(4, 2) + "-" + model.getValue(ipt_fromdd.attribute("ref")).substr(6, 2);
						var sTodd		= model.getValue(ipt_todd.attribute("ref")).substr(2, 2) + "-" + model.getValue(ipt_todd.attribute("ref")).substr(4, 2) + "-" + model.getValue(ipt_todd.attribute("ref")).substr(6, 2);
						
						var sTitle = "mapping 가능한 nU 부가세 List " + sFromdd + " ~ " + sTodd;
						grd_connectablelist.rebuild();
						misfSaveExcel(grd_connectablelist, sTitle);
					]]>
				</script>
			</button>
			<button id="btn_disconnect" class="btn4_letter6" visibility="visible" style="left:295px; top:92px; width:104px; height:22px; ">
				<caption>계산서 생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

					]]>
				</script>
			</button>
			<group id="group4" style="left:0px; top:372px; width:1195px; height:60px; vertical-align:top; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line4" class="line_4" style="x1:1107px; y1:16px; x2:1107px; y2:39px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption9" class="search_name" style="left:575px; top:9px; width:90px; height:17px; ">조회일자 :</caption>
				<input id="ipt_fromdd_1" ref="/root/send/condition2/fromdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:665px; top:8px; width:100px; height:19px; text-align:center; "/>
				<caption id="caption10" style="left:767px; top:10px; width:15px; height:20px; ">~</caption>
				<button id="btn_search_1" class="btn1_letter2" navindex="4" style="left:1123px; top:17px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							model.removeNodeset(grd_taxlist.nodeset);
							submit("TRRAT00302");

						]]>
					</script>
				</button>
				<input id="ipt_todd_1" ref="/root/send/condition2/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:780px; top:8px; width:100px; height:19px; text-align:center; "/>
				<caption id="caption12" class="search_name" style="left:285px; top:9px; width:99px; height:17px; ">계산서종류 :</caption>
				<select1 id="radio1" ref="/root/send/condition2/taxbillkind" class="radio_search" disabled="true" navindex="3" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:390px; top:8px; width:165px; height:20px; vertical-align:middle; border-style:none; ">
					<choices>
						<itemset nodeset="/root/init/init_taxbillkind/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<select1 id="radio2" ref="/root/send/condition2/taxbillflag" class="radio_search" disabled="true" navindex="4" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:390px; top:35px; width:165px; height:20px; vertical-align:middle; border-style:none; ">
					<choices>
						<itemset nodeset="/root/init/init_taxbillflag/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption13" class="search_name" style="left:285px; top:35px; width:109px; height:17px; ">계산서구분 :</caption>
			</group>
		</group>
	</xhtml:body>
</xhtml:html>