YNU_JEUS/app_home/himed/webapps/mis/addtaxweb/xrw/SMRAT00360_국세청-nU Mapping Data 검증.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>국세청-NU Mapping Data 일치여부 검증</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<different>
							<differentlist/>
						</different>
					</main>
					<send>
						<condition>
							<instcd/>
							<fromdd/>
							<todd/>
							<searchflag>error</searchflag>
						</condition>
						<different>
							<differentlist/>
						</different>
					</send>
					<temp/>
					<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>
						<init_reptkind>
							<item>
								<label>1기예정</label>
								<value>1</value>
							</item>
							<item>
								<label>1기확정</label>
								<value>2</value>
							</item>
							<item>
								<label>2기예정</label>
								<value>3</value>
							</item>
							<item>
								<label>2기확정</label>
								<value>4</value>
							</item>
						</init_reptkind>
						<init_flagcd>
							<item>
								<label>정규</label>
								<value>1</value>
							</item>
							<item>
								<label>예정신고누락분</label>
								<value>2</value>
							</item>
						</init_flagcd>
						<init_fixasetflag>
							<item>
								<label>일반 매입·출</label>
								<value>00</value>
							</item>
							<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>
						</init_fixasetflag>
						<R0364list>
							<R0364/>
						</R0364list>
						<Z0007list>
							<Z0007/>
						</Z0007list>
					</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" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[

					fInitialize();

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

					function fInitialize()
					{
						model.removeNodeset(grd_differentlist.nodeset);

						misfComboComCdListMulti("Z0007", "cmb_instcd");
						zbcfGetCodeList(new Array("R0364"), new Array("/root/init/R0364list"));
						zbcfGetCodeList(new Array("Z0007"), new Array("/root/init/Z0007list"));

						model.setValue(cmb_instcd.attribute("ref"),   	getUserInfo("dutplceinstcd"));
						model.setValue(ipt_fromdd.attribute("ref"),		getCurrentDate());
						model.setValue(ipt_todd.attribute("ref"),		getCurrentDate());
						grd_differentlist.rowHeight(0) = 35;

						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="TRZBC00101" method="post" replace="instance"/>
			<submission id="TRRAT00361" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/different"/>
			<submission id="TXRAT00351" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/different/differentlist" resultref="/root/temp"/>
		</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; ">국세청-NU Mapping Data 일치여부 검증</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:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line5" class="line_4" style="x1:1107px; y1:6px; x2:1107px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:310px; top:9px; width:90px; height:17px; ">조회일자 :</caption>
				<input id="ipt_fromdd" ref="/root/send/condition/fromdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:400px; top:8px; width:100px; height:19px; text-align:center; "/>
				<caption id="caption2" style="left:502px; top:11px; width:15px; height:20px; ">~</caption>
				<select1 id="cmb_instcd" ref="/root/send/condition/instcd" class="combo_s_essential" disabled="true" navindex="-1" appearance="minimal" style="left:99px; top:8px; width:176px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption3" class="search_name" style="left:9px; top:9px; width:90px; height:17px; ">기관구분 :</caption>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:7px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							model.removeNodeset(grd_differentlist.nodeset);
							grd_differentlist.refresh();
							submit("TRRAT00361");
							for(var i = grd_differentlist.fixedRows ; i < grd_differentlist.rows ; i++)
							{
								
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_taxbillkind")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("taxbillkind_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("taxbillkind_nts")) = "#ffff00";
								}
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_taxbillflag")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("taxbillflag_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("taxbillflag_nts")) = "#ffff00";
								}								
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_suplamt")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("suplamt_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("suplamt_nts")) = "#ffff00";
								}
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_valaddtax")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("valaddtax_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("valaddtax_nts")) = "#ffff00";
								}
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_amt")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("amt_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("amt_nts")) = "#ffff00";
								}
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_genrdd")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("genrdd_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("genrdd_nts")) = "#ffff00";
								}
								if(grd_differentlist.valueMatrix(i, grd_differentlist.colRef("eq_entrregno")) == "N")
								{
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("entrregno_tax")) = "#ffff00";
									grd_differentlist.cellStyle("background-color", i, grd_differentlist.colRef("entrregno_nts")) = "#ffff00";
								}															
							}

						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/condition/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:515px; top:8px; width:100px; height:19px; text-align:center; "/>
				<select1 id="rdo_retrkind" ref="/root/send/condition/searchflag" overflow="visible" appearance="full" cellspacing="15" cols="3" style="left:750px; top:10px; width:260px; height:16px; border-style:none; ">
					<choices>
						<item>
							<label>전체</label>
							<value>all</value>
						</item>
						<item>
							<label>오류</label>
							<value>error</value>
						</item>
					</choices>
				</select1>
				<caption id="caption9" class="search_name" style="left:660px; top:10px; width:97px; height:17px; ">조회구분 :</caption>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:88px; x2:1195px; y2:88px; "/>
			<datagrid id="grd_differentlist" nodeset="/root/main/different/differentlist" backcoloralternate="#ffffff" caption="선택^기관코드^일련번호^계산서종류&#xA;TAX^계산서종류&#xA;NTS^계산서종류일치여부^계산서구분&#xA;TAX^계산서구분&#xA;NTS^계산서구분일치여부^공급가액&#xA;TAX^공급가액&#xA;NTS^공급가액일치여부^부가세액&#xA;TAX^부가세액&#xA;NTS^부가세액일치여부^합계&#xA;TAX^합계&#xA;NTS^합계일치여부^계산서일자&#xA;TAX^계산서일자&#xA;NTS^계산서일자일치여부^사업자번호&#xA;TAX^사업자번호&#xA;NTS^사업자번호일치여부^미결전표일자^미결전표번호^미결전표일련번호^전표구분^전송구분^DTI세금계산서번호" colsep="^" colwidth="50,0,0,90,90,0,80,80,0,100,100,0,100,100,0,100,100,0,80,80,0,80,80,0,80,80,80,100,80,80" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:0px; top:93px; width:1195px; height:662px; ">
				<col checkvalue="Y,N" ref="chk" type="checkbox"/>
				<col ref="instcd"/>
				<col ref="seqno"/>
				<col disabled="true" ref="taxbillkind_tax" type="combo">
					<choices>
						<itemset nodeset="/root/init/init_taxbillkind/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</col>
				<col disabled="true" ref="taxbillkind_nts" type="combo">
					<choices>
						<itemset nodeset="/root/init/init_taxbillkind/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</col>
				<col ref="eq_taxbillkind"/>
				<col disabled="true" ref="taxbillflag_tax" type="combo">
					<choices>
						<itemset nodeset="/root/init/init_taxbillflag/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</col>
				<col disabled="true" ref="taxbillflag_nts" type="combo">
					<choices>
						<itemset nodeset="/root/init/init_taxbillflag/item">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</col>
				<col ref="eq_taxbillflag"/>
				<col ref="suplamt_tax"/>
				<col ref="suplamt_nts"/>
				<col ref="eq_suplamt"/>
				<col ref="valaddtax_tax"/>
				<col ref="valaddtax_nts"/>
				<col ref="eq_valaddtax"/>
				<col ref="amt_tax"/>
				<col ref="amt_nts"/>
				<col ref="eq_amt"/>
				<col ref="genrdd_tax"/>
				<col ref="genrdd_nts"/>
				<col ref="eq_genrdd"/>
				<col ref="entrregno_tax"/>
				<col ref="entrregno_nts"/>
				<col ref="eq_entrregno"/>
				<col ref="unsldd"/>
				<col ref="unslno"/>
				<col ref="unslseqno"/>
				<col ref="slipflag"/>
				<col ref="sanctyn"/>
				<col ref="inv_no"/>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if(grd_differentlist.valueMatrix(grd_differentlist.row, grd_differentlist.colRef("chk")) != "Y")
						{
							grd_differentlist.removeStatus(grd_differentlist.row, "update");
						}
						grd_differentlist.refresh();				
					]]>
				</script>
			</datagrid>
			<caption id="caption21" class="tit_2" style="left:5px; top:73px; width:310px; height:13px; ">국세청-NU Mapping Data 불일치 List</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:67px; 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 = "국세청-NU 데이터 불일치 " + sFromdd + " ~ " + sTodd;
							grd_differentlist.rebuild();
							misfSaveExcel(grd_differentlist, sTitle);
					]]>
				</script>
			</button>
			<button id="btn_disconnect" class="btn4_letter4" visibility="visible" style="left:265px; top:65px; width:80px; height:22px; ">
				<caption>연결해제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_differentlist);
						if (updtdata != "")
						{
							dlgRslt = messageBox("연결을 해제 하시겠습니까?", "Q000");
			                 		if(dlgRslt == 6)
			                 		{
			                 			model.setValue("/root/send/different/differentlist", grd_differentlist.getUpdateData());
								submit("TXRAT00351");
								btn_search.dispatch("DOMActivate");								
			                 		}
						}
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>