YNU_JEUS/app_home/himed/webapps/mis/addtaxweb/xrw/SMRAT00310_국세청자료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>
						<excel>
							<excellist/>
						</excel>
					</main>
					<send>
						<condition1>
							<instcd/>
							<fromdd/>
							<todd/>
							<taxbillkind>4</taxbillkind>
							<taxbillflag>1</taxbillflag>
							<entrregno/>
							<custnm/>
						</condition1>
						<condition2>
							<instcd/>
							<fromdd/>
							<todd/>
							<taxbillkind>4</taxbillkind>
							<taxbillflag>1</taxbillflag>
							<entrregno/>
							<custnm/>
							<suplamt/>
							<valaddtax/>
							<amt/>
						</condition2>
						<excel>
							<excellist/>
						</excel>
						<connectable>
							<connectablelist/>
						</connectable>
						<disconnected>
							<disconnectedlist/>
						</disconnected>
					</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_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>
					<temp/>
					<hidden>
						<condition>
							<yyyy/>
							<reptkind/>
							<reptkind_1/>
							<autodate>Y</autodate>
						</condition>
					</hidden>
				</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;
						
						model.setValue("/root/hidden/condition/yyyy", getCurrentDate().substr(0, 4));
						fSetReptKind();
						fSetDate(ipt_fromdd.attribute("ref"), ipt_todd.attribute("ref"),rdo_reptkind.attribute("ref"));
						fSetDate(ipt_fromdd_1.attribute("ref"), ipt_todd_1.attribute("ref"),rdo_reptkind_1.attribute("ref"));
						
						model.refresh();						
					}
					
					function fSetReptKind()
					{
						var sMonth = getCurrentDate().substr(4, 2);

						if(sMonth == "01" || sMonth == "02" || sMonth == "03")
						{
							model.setValue("/root/hidden/condition/reptkind", "1");
							model.setValue("/root/hidden/condition/reptkind_1", "1");
						}
						else if(sMonth == "04" || sMonth == "05" || sMonth == "06")
						{
							model.setValue("/root/hidden/condition/reptkind", "2");
							model.setValue("/root/hidden/condition/reptkind_1", "2");
						}
						else if(sMonth == "07" || sMonth == "08" || sMonth == "09")
						{
							model.setValue("/root/hidden/condition/reptkind", "3");
							model.setValue("/root/hidden/condition/reptkind_1", "3");
						}
						else if(sMonth == "10" || sMonth == "11" || sMonth == "12")
						{
							model.setValue("/root/hidden/condition/reptkind", "4");
							model.setValue("/root/hidden/condition/reptkind_1", "4");
						}

						model.refresh();
					}
					
					function fInputExcel(pGrid) 
					{
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						
						if(fileName != "") {
							pGrid.loadExcel(fileName, 1, true);
						
							pGrid.deleteRow(1);
							pGrid.deleteRow(1);
							pGrid.deleteRow(1);
							pGrid.deleteRow(1);
							pGrid.deleteRow(1);
							pGrid.deleteRow(1);
							pGrid.rebuild();
							return true;
						}
						return false;
					}
					
					function fAutoSearch(vRow, SearchFlag)
					{
						if(SearchFlag == "Y")
						{
							if(model.getValue("/root/hidden/condition/autodate") == "Y")
							{
								model.setValue(ipt_fromdd_1.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("makedd")));
								model.setValue(ipt_todd_1.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("makedd")));							
							}						
							model.setValue(ipt_entrregno.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("custcd")));	
							model.setValue(ipt_custnm.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("custnm")));
							model.setValue(rdo_taxbillflag.attribute("ref"), grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("etaxbillflag")));	
							model.refresh();
							btn_search_1.dispatch("DOMActivate");
						}
						
						for(var i = grd_connectablelist.fixedRows ; i < grd_connectablelist.rows ; i++)
						{//alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("suplamt")));
						//alert(grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("suplamt")));
							if(	grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("custcd")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("entrregno"))	
							&&	grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("suplamt")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("suplamt"))
							&&	grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("valaddtax")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("valaddtax"))
							&&	grd_disconnectedlist.valueMatrix(vRow, grd_disconnectedlist.colRef("amt")) == grd_connectablelist.valueMatrix(i, grd_connectablelist.colRef("amt")))
							{	//alert();								
								grd_connectablelist.rowstyle(i, "data", "background-color") = "#ffff00";
								grd_disconnectedlist.rowstyle(vRow, "data", "background-color") = "#ffff00";
							}							
						}
						model.refresh();
					}
					
					function fSetDate(vFromdd, vTodd, vReptKind)
					{
						if(model.getValue("/root/hidden/condition/yyyy").length != 4)
						{
							messageBox("년도가 잘못되었습니다.", "I999");
							return;
						}

						var sReptKind = model.getValue(vReptKind);
						var vYYYY = model.getValue("/root/hidden/condition/yyyy");

						if(sReptKind == "1")
						{
							model.setValue(vFromdd, vYYYY + "0101");
							model.setValue(vTodd, vYYYY + "0331");
						}
						else if(sReptKind == "2")
						{
							model.setValue(vFromdd, vYYYY + "0401");
							model.setValue(vTodd, vYYYY + "0630");
						}
						else if(sReptKind == "3")
						{
							model.setValue(vFromdd, vYYYY + "0701");
							model.setValue(vTodd, vYYYY + "0930");
						}
						else if(sReptKind == "4")
						{
							model.setValue(vFromdd, vYYYY + "1001");
							model.setValue(vTodd, vYYYY + "1231");
						}

						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="TRRAT00311" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition1" resultref="/root/main/disconnected"/>
			<submission id="TXRAT00311" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/excel/excellist" resultref="/root/temp"/>
			<submission id="TRRAT00312" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition2" resultref="/root/main/connectable"/>
			<submission id="TXRAT00312" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/connectable/connectablelist" resultref="/root/temp"/>
			<submission id="TXRAT00313" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition1" resultref="/root/temp"/>
			<submission id="TXRAT00314" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/disconnected/disconnectedlist" resultref="/root/temp"/>
		</model>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" guideline="1,1193;" 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:595px; height:85px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:595px; height:85px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line5" class="line_4" style="x1:509px; y1:34px; x2:509px; y2:57px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:5px; top:35px; width:105px; height:17px; ">조 회 일 자 :</caption>
				<input id="ipt_fromdd" ref="/root/send/condition1/fromdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:110px; top:34px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							model.setValue(rdo_reptkind.attribute("ref"), "");
//							model.setValue(ipt_fromdd_1.attribute("ref"), model.getValue(ipt_fromdd.attribute("ref")));
//							ipt_fromdd_1.refresh();
							
						]]>
					</script>
				</input>
				<caption id="caption2" style="left:212px; top:36px; width:15px; height:20px; ">~</caption>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:525px; top:35px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							model.removeNodeset(grd_disconnectedlist.nodeset);
							grd_disconnectedlist.refresh();
							submit("TRRAT00311");
							
							for(var i = grd_disconnectedlist.fixedRows ; i < grd_disconnectedlist.rows ; i++)
							{
								grd_disconnectedlist.isReadOnly(i, grd_disconnectedlist.colRef("instaxknd")) = true;
								if(grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("custregflag")) == "N")
								{
									grd_disconnectedlist.cellStyle("background-color", i, grd_disconnectedlist.colRef("custcd")) = "#ff6600";
								}
							}
							model.refresh();

						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/condition1/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:225px; top:34px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							model.setValue(rdo_reptkind.attribute("ref"), "");
//							model.setValue(ipt_todd_1.attribute("ref"), model.getValue(ipt_todd.attribute("ref")));			
//							ipt_todd_1.refresh();	
						]]>
					</script>
				</input>
				<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:110px; top:9px; 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>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							model.setValue(rdo_taxbillflag.attribute("ref"), model.getValue(rdo_billflag.attribute("ref")));
							rdo_taxbillflag.refresh();
						]]>
					</script>
				</select1>
				<caption id="caption8" class="search_name" style="left:5px; top:10px; width:109px; height:17px; ">계산서구분 :</caption>
				<caption id="caption3" class="search_name" style="left:5px; top:60px; width:104px; height:17px; ">사업자번호 :</caption>
				<input id="ipt_regnm" ref="/root/send/condition1/custnm" navindex="6" imemode="hangul" style="left:227px; top:59px; width:148px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
							if(event.keyCode == 13)
							{
								racfCustValidCheck("entrregno,custnm", "name");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							racfCustValidCheck("entrregno,custnm", "name");
						]]>
					</script>
				</input>
				<button id="btn_entregnohelp" class="icon_search" style="left:209px; top:59px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
							misfOpenPopUpList("14", ipt_regno, "", 	"entrregno,custnm");
							model.refresh();
						
						]]>
					</script>
				</button>
				<input id="ipt_regno" ref="/root/send/condition1/entrregno" navindex="5" format="999-99-99999" style="left:110px; top:59px; width:95px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
							if(event.keyCode == 13)
							{
								racfCustValidCheck("entrregno,custnm", "code");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							racfCustValidCheck("entrregno,custnm", "code");
						]]>
					</script>
				</input>
				<button id="button4" class="btn2_letter2" style="left:380px; top:59px; width:42px; height:19px; text-align:left; ">
					<caption>제거</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							model.setValue(ipt_regno.attribute("ref"), "");
							model.setValue(ipt_regnm.attribute("ref"), "");
							ipt_regno.refresh();
							ipt_regnm.refresh();
						]]>
					</script>
				</button>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:165px; x2:595px; y2:165px; "/>
			<datagrid id="grd_disconnectedlist" nodeset="/root/main/disconnected/disconnectedlist" backcoloralternate="#ffffff" caption="선택^기관코드^사업자번호^종사업자코드^거래처명^공급가액^부가세액^합계^과세구분^작성일^발행일^발신일^과세종류^대표자명^수정계산서구분^발행구분^승인번호^승인여부^상태^일련번호^계산서종류^계산서구분^거래처등록여부^비고^기타" colsep="^" colwidth="35, 0, 75, 0, 120, 95, 95, 95, 80, 80, 80, 80, 0, 70, 100, 100, 100, 0, 0, 0, 0, 0, 0, 120, 120" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:0px; top:170px; width:595px; height:585px; ">
				<col checkvalue="Y,N" ref="chk" type="checkbox"/>
				<col ref="instcd"/>
				<col ref="custcd"/>
				<col ref="subcustcd"/>
				<col ref="custnm"/>
				<col ref="suplamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="valaddtax" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col ref="amt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
				<col disabled="false" ref="instaxknd" 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="makedd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="issuedd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="senddd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="taxknd"/>
				<col ref="prsdnm"/>
				<col ref="modifyflag"/>
				<col ref="issueflag"/>
				<col ref="approvalno"/>
				<col ref="approvalyn"/>
				<col ref="proc_flag"/>
				<col ref="seqno"/>
				<col ref="etaxbillkind"/>
				<col ref="etaxbillflag"/>
				<col ref="custregflag"/>
				<col ref="cmt"/>
				<col ref="etc"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
					
						if(grd_disconnectedlist.col == grd_disconnectedlist.colRef("custcd"))
						{
							model.setValue(ipt_regno.attribute("ref"), grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custcd")));
							model.setValue(ipt_regnm.attribute("ref"), grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custnm")));
							ipt_regno.refresh();
							ipt_regnm.refresh();
						}
						else
						{
							fAutoSearch(grd_disconnectedlist.row, "Y");
						}
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custregflag")) == "N")
						{
							messageBox("거래처가 등록되어 있지 않습니다.", "I000");
							grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")) = "";
							grd_disconnectedlist.rowStatus(grd_disconnectedlist.row) = 0;
							return false;
						}
						//alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")));
						if(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")) == "Y")
						{
							//alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")));
							grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = "01";
							grd_disconnectedlist.isReadOnly(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = false;
						}
						else
						{
							//alert(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("chk")));							
							grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = "";
							grd_disconnectedlist.isReadOnly(grd_disconnectedlist.row, grd_disconnectedlist.colRef("instaxknd")) = true;
							grd_disconnectedlist.removeStatus(grd_disconnectedlist.row, "update");
						}
						grd_disconnectedlist.refresh();
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_disconnectedlist.gridToInstance();		
					]]>
				</script>
			</datagrid>
			<caption id="caption21" class="tit_2" style="left:5px; top:122px; width:310px; height:13px; ">mapping 되지 않은 국세청 자료 목록</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>
				<button id="button5" class="icon_next" navindex="-1" style="left:270px; top:7px; width:13px; height:15px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var vYYYY = model.getValue(ipt_yyyy.attribute("ref"));
							var vNum = parseInt(vYYYY, 10);
							
							if (vNum != 1) 
							{
								vNum++;
							} 
							else 
							{
								return;
							}
							model.setValue(ipt_yyyy.attribute("ref"), vNum);
							ipt_yyyy.refresh();	
							rdo_reptkind.dispatch("xforms-value-changed");
						]]>
					</script>
				</button>
				<caption id="caption11" class="search_name" style="left:80px; top:6px; width:101px; height:17px; ">년        도 :</caption>
				<input id="ipt_yyyy" ref="/root/hidden/condition/yyyy" class="input_s_essential" navindex="1" maxlength="4" style="left:200px; top:6px; width:68px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							rdo_reptkind.dispatch("xforms-value-changed");				
						]]>
					</script>
				</input>
				<button id="btn_pre" class="icon_pre" navindex="-1" style="left:185px; top:7px; width:13px; height:15px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							var vYYYY = model.getValue(ipt_yyyy.attribute("ref"));
							var vNum = parseInt(vYYYY, 10);
							
							if (vNum != 1) 
							{
								vNum--;
							} 
							else 
							{
								return;
							}
							model.setValue(ipt_yyyy.attribute("ref"), vNum);
							ipt_yyyy.refresh();		
							rdo_reptkind.dispatch("xforms-value-changed");		 			
						]]>
					</script>
				</button>
				<select id="chk_autodate" ref="/root/hidden/condition/autodate" visibility="visible" overflow="visible" appearance="full" style="left:310px; top:5px; width:190px; height:20px; border-style:none; ">
					<choices>
						<item>
							<label>자동조회 시 자동 일자 사용</label>
							<value>Y</value>
						</item>
					</choices>
				</select>
			</group>
			<button id="btn_excel" class="btn2_letter4" style="left:526px; top:142px; 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="기관코드^일련번호^계산서종류^계산서구분^사업자번호^거래처명^상태^공급가액^부가세액^합계^계산서일^미결전표정보^미결전표일자^미결전표번호^미결전표일련번호^발행구분^DIT계산서번호^담당자메일^거래처메일^전자세금계산서구분^승인번호" colsep="^" colwidth="0, 0, 0, 0, 75, 120, 0, 95, 95, 95, 80, 120, 0, 0, 0, 100, 100, 100, 100, 100, 0" explorerbar="sort" frozencols="21" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:599px; top:170px; width:595px; height:585px; ">
				<col ref="instcd"/>
				<col ref="seqno"/>
				<col ref="taxbillkind"/>
				<col ref="taxbillflag"/>
				<col ref="entrregno"/>
				<col ref="custnm"/>
				<col ref="proc_flag"/>
				<col ref="suplamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="valaddtax" format="(-)#,###" style="text-align:right; "/>
				<col ref="amt" format="(-)#,###" style="text-align:right; "/>
				<col ref="genrdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="unslinfo"/>
				<col ref="unsldd"/>
				<col ref="unslno"/>
				<col ref="undeciseqno"/>
				<col ref="isscust"/>
				<col ref="inv_no"/>
				<col ref="dtiemail"/>
				<col ref="custdtiemailaddr"/>
				<col ref="ebillflag"/>
				<col ref="approvalno"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
						if(grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("custnm")) == "")
						{
							messageBox("거래처가 등록되어 있지 않습니다.\n거래처를 확인 후 등록하세요", "I000");
							return false;							
						}
					
						if(grd_connectablelist.col == grd_connectablelist.colRef("entrregno"))
						{
							model.setValue(ipt_entrregno.attribute("ref"), grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("entrregno")));
							model.setValue(ipt_custnm.attribute("ref"), grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("custnm")));
							ipt_entrregno.refresh();
							ipt_custnm.refresh();
						}
						else
						{						
							if(	grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("etaxbillflag")) 	== grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("taxbillflag"))				                 
					                 &&	grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("custcd")) 		== grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("entrregno"))
					                 &&	grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("suplamt")) 		== grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("suplamt"))
					                 &&	grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("valaddtax")) 	== grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("valaddtax"))
					                 &&	grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("amt")) 		== grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("amt")))
					                 {
					                 	if(grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("makedd")) != grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("genrdd")))
					                 	{
					                 		dlgRslt = messageBox("계산서 일자가 다릅니다. 수정하시겠습니까?\n\nYes(수정 후 Mapping) / No(Mapping 취소)", "Q000");
					                 		if(dlgRslt == 6)
					                 		{
					                 			grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("genrdd")) = grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("makedd"));
					                 		}
					                 		else
					                 		{
					                 			return false;
					                 		}
					                 	}
	
					                 	grd_connectablelist.rowStatus(grd_connectablelist.row) = 2;
					                 	grd_connectablelist.valueMatrix(grd_connectablelist.row, grd_connectablelist.colRef("approvalno")) = grd_disconnectedlist.valueMatrix(grd_disconnectedlist.row, grd_disconnectedlist.colRef("approvalno"));				                 	
					                 	model.setValue("/root/send/connectable/connectablelist", grd_connectablelist.getUpdateData());
								submit("TXRAT00312");
								messageBox("Mapping 되었습니다.", "I000");
								btn_search.dispatch("DOMActivate");
								btn_search_1.dispatch("DOMActivate");
		
					                 }		
					                 else
					                 {
					                 	messageBox("데이터가 일치하지 않습니다.", "I000");
					                 }
						}	
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_connectablelist.gridToInstance();			
					]]>
				</script>
			</datagrid>
			<caption id="caption5" class="tit_2" style="left:600px; top:125px; width:250px; height:13px; ">mapping 가능한 nU 부가세 List</caption>
			<line id="line2" class="line_1" style="x1:599px; y1:165px; x2:1194px; y2:165px; "/>
			<button id="button1" class="btn2_letter4" style="left:1127px; top:142px; 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_letter7" visibility="visible" style="left:340px; top:141px; width:116px; height:22px; ">
				<caption>일괄 Mapping</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var total = 0;
						for(var i = grd_disconnectedlist.fixedRows ; i < grd_disconnectedlist.rows ; i++)
						{
							for(var j = grd_connectablelist.fixedRows ; j < grd_connectablelist.rows ; j++)
							{
								if(	grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("etaxbillflag")) 	== grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("taxbillflag"))
						                 &&	grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("makedd")) 	== grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("genrdd")) 
						                 &&	grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("custcd")) 	== grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("entrregno"))
						                 &&	grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("suplamt")) 	== grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("suplamt"))
						                 &&	grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("valaddtax")) 	== grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("valaddtax"))
						                 &&	grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("amt")) 		== grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("amt"))
						                 &&	grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("approvalno"))      == "")
						                 {
						                 	++total;
						                 	grd_connectablelist.rowStatus(j) = 2;
						                 	grd_connectablelist.valueMatrix(j, grd_connectablelist.colRef("approvalno")) = grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("approvalno"));
						                 	break;
						                 }
							}
							
						}
						var updtdata = getGridUpdateData(grd_connectablelist);
						if (updtdata != "")
						{
							model.setValue("/root/send/connectable/connectablelist", grd_connectablelist.getUpdateData());
							submit("TXRAT00312");
							messageBox("총" + total + "건이 Mapping 되었습니다.", "I000");
							btn_search.dispatch("DOMActivate");
							btn_search_1.dispatch("DOMActivate");
						}
						else
						{
							messageBox("일치하는 데이터가 없습니다.", "I000");
						}
						
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					
					/*
						for(var i = grd_disconnectedlist.fixedRows ; i < grd_disconnectedlist.rows ; i++)
						{
							fAutoSearch(i);
							if(grd_connectablelist.rows == grd_connectablelist.fixedRows+ 1 )
							{
								grd_connectablelist.rowStatus(grd_connectablelist.fixedRows) = 2;
								grd_connectablelist.valueMatrix(grd_connectablelist.fixedRows, grd_connectablelist.colRef("approvalno")) = grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("approvalno"));
								model.setValue("/root/send/connectable/connectablelist", grd_connectablelist.getUpdateData());
								submit("TXRAT00312");
							}							
						}
					*/
					
					
					]]>
				</script>
			</button>
			<group id="group4" style="left:598px; top:30px; width:595px; height:85px; vertical-align:top; ">
				<shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:595px; height:85px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line4" class="line_4" style="x1:514px; y1:29px; x2:514px; y2:52px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption9" class="search_name" style="left:10px; top:35px; width:105px; 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:115px; top:34px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							model.setValue(rdo_reptkind_1.attribute("ref"), "");						
						]]>
					</script>
				</input>
				<caption id="caption10" style="left:217px; top:34px; width:15px; height:20px; ">~</caption>
				<button id="btn_search_1" class="btn1_letter2" navindex="4" style="left:530px; top:30px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							model.removeNodeset(grd_connectablelist.nodeset);
							grd_connectablelist.refresh();
							submit("TRRAT00312");

						]]>
					</script>
				</button>
				<input id="ipt_todd_1" ref="/root/send/condition2/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:230px; top:34px; width:100px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							model.setValue(rdo_reptkind_1.attribute("ref"), "");
						]]>
					</script>
				</input>
				<select1 id="rdo_taxbillflag" ref="/root/send/condition2/taxbillflag" class="radio_search" disabled="false" navindex="4" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:115px; top:9px; 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:10px; top:10px; width:109px; height:17px; ">계산서구분 :</caption>
				<caption id="caption7" class="search_name" style="left:10px; top:60px; width:104px; height:17px; ">사업자번호 :</caption>
				<input id="ipt_custnm" ref="/root/send/condition2/custnm" navindex="6" imemode="hangul" style="left:232px; top:59px; width:148px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
							if(event.keyCode == 13)
							{
								racfCustValidCheck("entrregno,custnm", "name");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							racfCustValidCheck("entrregno,custnm", "name");
						]]>
					</script>
				</input>
				<button id="button2" class="icon_search" style="left:214px; top:59px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
							misfOpenPopUpList("14", ipt_entrregno, "", 	"entrregno,custnm");
							model.refresh();
						
						]]>
					</script>
				</button>
				<input id="ipt_entrregno" ref="/root/send/condition2/entrregno" navindex="5" format="999-99-99999" style="left:115px; top:59px; width:95px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[
							if(event.keyCode == 13)
							{
								racfCustValidCheck("entrregno,custnm", "code");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							racfCustValidCheck("entrregno,custnm", "code");
						]]>
					</script>
				</input>
				<button id="button3" class="btn2_letter2" style="left:385px; top:59px; width:42px; height:19px; text-align:left; ">
					<caption>제거</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							model.setValue(ipt_entrregno.attribute("ref"), "");
							model.setValue(ipt_custnm.attribute("ref"), "");
							ipt_entrregno.refresh();
							ipt_custnm.refresh();
						]]>
					</script>
				</button>
			</group>
			<datagrid id="grd_exceluploadlist" nodeset="/root/main/excel/excellist" visibility="hidden" backcoloralternate="#ffffff" caption="번호^작성일자^승인번호^발행일자^전송일자^공급자사업자등록번호^종사업장번호^상호^대표자명^공급받는자사업자등록번호^종사업장번호^상호^대표자명^합계금액^공급가액^세액^전자세금계산서분류^전자세금계산서종류^발행유형^비고^기타^계산서구분^계산서종류^기관코드" colsep="^" colwidth="100,100,100, 100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" style="left:15px; top:300px; width:75px; height:20px; ">
				<col ref="no"/>
				<col ref="makedd"/>
				<col ref="approvalno"/>
				<col ref="issuedd"/>
				<col ref="senddd"/>
				<col ref="supcustcd"/>
				<col ref="supsubcustcd"/>
				<col ref="supcustnm"/>
				<col ref="supprsdnm"/>
				<col ref="demcustcd"/>
				<col ref="demsubcustcd"/>
				<col ref="demcustnm"/>
				<col ref="demprsdnm"/>
				<col ref="amt"/>
				<col ref="suplamt"/>
				<col ref="valaddtax"/>
				<col ref="modifyflag"/>
				<col ref="taxknd"/>
				<col ref="issueflag"/>
				<col ref="cmt"/>
				<col ref="etc"/>
				<col ref="etaxbillflag"/>
				<col ref="etaxbillkind"/>
				<col ref="instcd"/>
			</datagrid>
			<button id="btn_excelupload" class="btn2_letter4" style="left:457px; top:142px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						model.removeNodeset(grd_exceluploadlist.nodeset);
						grd_exceluploadlist.refresh();
											
						if(fInputExcel(grd_exceluploadlist))
						{														
							if(grd_exceluploadlist.rows > grd_exceluploadlist.fixedRows)
							{
								for(var i = grd_exceluploadlist.fixedRows ; i < grd_exceluploadlist.rows ; i++)
								{
									grd_exceluploadlist.rowStatus(i) = 1;		
									grd_exceluploadlist.valueMatrix(i, grd_exceluploadlist.colRef("etaxbillflag")) = model.getValue(rdo_billflag.attribute("ref"));		
									grd_exceluploadlist.valueMatrix(i, grd_exceluploadlist.colRef("etaxbillkind")) = "4";
									grd_exceluploadlist.valueMatrix(i, grd_exceluploadlist.colRef("instcd")) = model.getValue("/root/send/condition2/instcd");		
								}
								model.setValue("/root/send/excel/excellist", grd_exceluploadlist.getUpdateData());		
								submit("TXRAT00311");						
							}
						}
					]]>
				</script>
			</button>
			<button id="btn_DTIapplicationNTS" class="btn4_letter10" visibility="visible" style="left:185px; top:141px; width:152px; height:22px; ">
				<caption>다큐빌 승인번호 적용</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						submit("TXRAT00313");										
					
					]]>
				</script>
			</button>
			<select1 id="rdo_reptkind" ref="/root/hidden/condition/reptkind" class="radio_search" navindex="2" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:277px; top:120px; width:320px; height:20px; vertical-align:middle; border-style:none; ">
				<choices>
					<itemset nodeset="/root/init/init_reptkind/item">
						<label ref="label"/>
						<value ref="value"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[	
						fSetDate(ipt_fromdd.attribute("ref"), ipt_todd.attribute("ref"),rdo_reptkind.attribute("ref"));						
					]]>
				</script>
			</select1>
			<select1 id="rdo_reptkind_1" ref="/root/hidden/condition/reptkind_1" class="radio_search" navindex="2" overflow="visible" appearance="full" cellspacing="20" cols="4" style="left:867px; top:119px; width:320px; height:20px; vertical-align:middle; border-style:none; ">
				<choices>
					<itemset nodeset="/root/init/init_reptkind/item">
						<label ref="label"/>
						<value ref="value"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[	
						fSetDate(ipt_fromdd_1.attribute("ref"), ipt_todd_1.attribute("ref"),rdo_reptkind_1.attribute("ref"));
					]]>
				</script>
			</select1>
			<button id="button6" class="btn4_letter10" visibility="visible" style="left:5px; top:141px; width:152px; height:22px; ">
				<caption>nU 부가세 일괄 생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						/*
						for(var i = grd_disconnectedlist.fixedRows ; i < grd_disconnectedlist.rows ; i++)
						{
							if(grd_disconnectedlist.valueMatrix(i, grd_disconnectedlist.colRef("chk")) != "Y")
							{
								grd_disconnectedlist.removeStatus(i, "update");
							}
						}
						model.refresh();
						*/
						var updtdata = getGridUpdateData(grd_disconnectedlist);
						if (updtdata != "")
						{
							dlgRslt = messageBox("nU 부가세 데이터를 생성하시겠습니까?", "Q000");
			                 		if(dlgRslt == 6)
			                 		{
			                 			model.setValue("/root/send/disconnected/disconnectedlist", grd_disconnectedlist.getUpdateData());
								submit("TXRAT00314");
								btn_search.dispatch("DOMActivate");
								btn_search_1.dispatch("DOMActivate");
			                 		}
						}
					
					
					
					
					
					]]>
				</script>
			</button>
			<button id="button7" class="btn4_letter7" visibility="visible" style="left:600px; top:141px; width:152px; height:22px; ">
				<caption>일괄 matching</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if(grd_disconnectedlist.rows > grd_disconnectedlist.fixedRows && grd_connectablelist.rows > grd_connectablelist.fixedRows)
						{
							for(var i = grd_disconnectedlist.fixedRows ; i < grd_disconnectedlist.rows ; i++)
							{
								fAutoSearch(i, "N");
							}
							model.refresh();
						}					
					
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>