YNU_JEUS/app_home/himed/webapps/mis/purcbaseweb/xrw/SMRSC08400_세금계산서내역비교.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<!--
	* 제    목   : SMRSC08400_세금계산서내역비교
	* 설    명   : 국세청 전자세금계산서와 계약내역 비교
	* 설 계 자  : 김금련	
	* 작 성 자  : 김금련
	* 작 성 일  : 2017.04.04
	* 기    타   :  
-->
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:ms="urn:schemas-microsoft-com:xslt" xmlns:my="http://www.comsquare.co.kr/example" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>국세청 세금계산서와 계약건 내역 비교</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<upperlimitlst>
							<upperlimitinfo/>
						</upperlimitlst>
						<cmprlst>
							<cmprinfo/>
						</cmprlst>
					</main>
					<send>
						<srchbasedd/>
						<srchgoodcd/>
						<srchchkfrdd/>
						<srchchktodd/>
						<srchwinacnt/>
						<srchwinacntnm/>
						<suppcustcd/>
						<suppcustnm/>
						<ugoodcd/>
						<uwinacnt/>
						<uwinacntnm/>
						<ubasedd/>
						<ucustnm/>
						<uentrregno/>
						<umaincustlastsuplplce/>
						<umaincustlastsuplplcenm/>
						<sdata/>
						<refcond/>
						<retrnm/>
						<custstat/>
						<list/>
						<instcd/>
						<ufromdd/>
						<utodd/>
						<srchfromdd/>
						<srchtodd/>
						<selectyn/>
						<save>
							<upperlimitinfo/>
							<keumcomparelst/>
							<exelist/>
							<cmprinfo/>
						</save>
						<purccnsttndd/>
						<purccnsttnno/>
						<purccondd/>
						<purcconno/>
						<acptdd/>
						<entrregno/>
						<totamt/>
						<conflagnm/>
					</send>
					<init>
						<combobscdlst/>
					</init>
					<hidden/>
					<temp>
						<item/>
					</temp>
					<rexprnt>
						<benflist>
							<srchfromdd/>
							<srchtodd/>
						</benflist>
					</rexprnt>
				</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/basiccodeweb/js/ZBC001.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="../../../mis/miscommonweb/js/RSZ001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fGetScreenInit();	
					var gDutplceinstcd  =  getUserInfo("dutplceinstcd");   // 사용자 기관코드
					       model.setValue("/root/send/instcd", gDutplceinstcd); 
				]]>
			</script>
			<submission id="TXRSC08401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/sdata" replace="instance" resultref="/root/temp"/>
			<submission id="TRRSC08401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/upperlimitlst"/>
			<submission id="TRRAC90601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/list"/>
			<submission id="TXRSC08402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" replace="instance" resultref="/root/temp"/>
			<submission id="TRRSC08403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/upperlimitlst"/>
			<submission id="TRRSC08404" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/cmprlst"/>
			<submission id="TXRSC08403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" replace="instance" resultref="/root/temp"/>
			<submission id="TRRSC08405" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/prtinfo/cmprlst"/>
			<submission id="TXRSC08404" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" replace="instance" resultref="/root/temp"/>
		</model>
		<script type="javascript">
			<![CDATA[			
			// 화면 초기화
			function fGetScreenInit(){

				misfGridInit(grd_upperlimitupload);
				misfGridInit(grd_keumcomparelst);				
				
				model.setValue("/root/send/instcd",getUserInfo("dutplceinstcd"));
				var curdate = getCurrentDate();
				var cvtdate = curdate.toDate("YYYYMMDD");
				model.setValue("/root/send/srchbasedd" ,  getCurrentDate().substr(0,6));	
				var basedd = model.getValue("/root/send/srchbasedd");

                model.setValue(ipt_srchchkfrdd.attribute("ref") ,basedd + "01");
//				var tobasedd = cvtdate.getAddDate(1,"M").getDateFormat("YYYYMMDD");
				var dt = new Date(getCurrentDate().substr(0, 4), getCurrentDate().substr(4, 2), 0);

			    model.setValue(ipt_srchchktodd.attribute("ref") , getCurrentDate().substr(0,6) + dt.getDate());				
				var srchbasedd = model.getValue("/root/send/srchbasedd");
		
				model.setValue("/root/send/ubasedd" ,  getCurrentDate().substr(0,6));
				btn_tabcompare.selected = true;
				cmb_conflagnm.select(1);

				model.refresh();
			}			
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1194;2,783;1,1193;2,-3;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="grp_tle" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:280px; height:15px; ">
				<![CDATA[국세청 세금계산서 & 계약건 내역 비교]]>
			</caption>
		</group>
		<group id="grp_biz" scroll="auto" style="left:0px; top:13px; width:1195px; height:762px; ">
			<switch id="switch1" style="left:0px; top:31px; width:1194px; height:729px; ">
				<case id="case_compare" selected="true">
					<group id="grp_sea" style="left:0px; top:5px; width:1192px; height:60px; vertical-align:top; ">
						<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
						<caption id="caption2" class="search_name" style="left:628px; top:6px; width:86px; height:17px; ">계정과목 :</caption>
						<line id="line13" class="line_4" style="x1:1042px; y1:7px; x2:1042px; y2:29px; "/>
						<input id="ipt_srchbasedd" ref="/root/send/srchbasedd" class="input_default" navindex="3" inputtype="date" format="yyyy-mm" style="left:94px; top:7px; width:71px; height:19px; text-align:center; ">
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[
										var basedd = model.getValue("/root/send/srchbasedd");
										var cvtdate = basedd.toDate("YYYYMM");
                                        model.setValue(ipt_srchchkfrdd.attribute("ref") ,basedd + "01");

				                        var tobasedd = cvtdate.getAddDate(1,"M").getDateFormat("YYYYMM");
			                        	var dt = new Date(basedd.substr(0, 4), basedd.substr(4, 2), 0);

			                            model.setValue(ipt_srchchktodd.attribute("ref") , basedd.substr(0,6) + dt.getDate());				

										model.refresh();
								]]>
							</script>
						</input>
						<caption id="caption1" class="search_name" style="left:9px; top:7px; width:90px; height:17px; ">기준일자 :</caption>
						<button id="btn_regnohelp" class="icon_search" navindex="5" style="left:407px; top:37px; width:16px; height:16px; text-align:center; ">
							<caption/>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[
									var sinstcd = model.getValue("/root/send/instcd");
									rszfOpenPopUpListByWndName(ipt_suppcustcd,"","suppcustcd,suppcustnm","SPRSD00220","instcd",sinstcd);

                                   model.refresh();		                                              				
								]]>
							</script>
						</button>
						<input id="ipt_suppcustnm" ref="/root/send/suppcustnm" class="output_fix" navindex="-1" editable="false" style="left:425px; top:35px; width:135px; height:19px; "/>
						<input id="ipt_suppcustcd" ref="/root/send/suppcustcd" class="input" navindex="4" style="left:350px; top:35px; width:54px; height:19px; text-align:center; ">
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[
									setInputNodeCurText();
									misfSearchCust(ipt_suppcustnm,cmb_instcd);
								]]>
							</script>
						</input>
						<caption id="caption5" class="search_name" style="left:253px; top:34px; width:90px; height:17px; ">거  래  처 :</caption>
						<input id="ipt_srchwinacnt" ref="/root/send/srchwinacnt" class="input" navindex="2" style="left:717px; top:7px; width:103px; height:19px; ">
							<script type="javascript" ev:event="xforms-value-changed">
								<![CDATA[
                            if(ipt_srchwinacnt.value == null || ipt_srchwinacnt.value == "") {
								opt_srchwinacntnm.value = "";
							} else {								
								rszfValidationCheck("TRRAC00111", "acntlist", "acntflag,useyn,jobgb,srhtxt","1,,," + model.getValue(ipt_srchwinacnt.attribute("ref")) ,"","winacnt,winacntnm" ,ipt_srchwinacnt,"PPRAC00100","","");
							}
							ipt_srchwinacnt.refresh();
							opt_srchwinacntnm.refresh();
								]]>
							</script>
						</input>
						<output id="opt_srchwinacntnm" ref="/root/send/srchwinacntnm" class="output_fix" appearance="output" style="left:845px; top:7px; width:140px; height:19px; "/>
						<button id="btn_srchwinacnt" class="icon_search" style="left:825px; top:13px; width:16px; height:16px; ">
							<caption/>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[
					rszfOpenPopUpListByWndName(ipt_srchwinacnt,"","srchwinacnt,srchwinacntnm","PPRAC00100","","");
					model.refresh();
					]]>
							</script>
						</button>
						<button id="button6" class="btn1_letter1" navindex="6" visibility="hidden" style="left:1078px; top:7px; width:17px; height:22px; ">
							<caption>초기화</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[	                             
									model.setValue("/root/send/srchwinacnt", "");
									model.setValue("/root/send/srchwinacntnm", "");
									model.setValue("/root/send/srchmaincustlastsuplplce", "");
									model.setValue("/root/send/srchmaincustlastsuplplcenm", "");									
									
									model.refresh();						
								]]>
							</script>
						</button>
						<button id="btn_save" class="btn4_letter2" navindex="8" style="left:1128px; top:7px; width:56px; height:22px; ">
							<caption>저장</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[
									updtdata = getGridUpdateData(grd_keumcomparelst);
					
									if(updtdata == ""){
										messageBox("저장할 데이터가 ","E014");
										return false;
									}else{									
										model.setValue("/root/send/save/keumcomparelst", updtdata);
										if( submit("TXRSC08403") ) {
											messageBox("저장이","I002");  
											btn_sea.dispatch("DOMActivate");
										} else {
											messageBox("저장","E009");
										   return;           
										}
									}						
					     ]]>
							</script>
						</button>
						<button id="btn_sea" class="btn1_letter2" navindex="6" style="left:1060px; top:7px; width:56px; height:22px; ">
							<caption>조회</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[
	             						
									if( submit("TRRSC08404") ){
										var lstCnt = getNodesetCount("/root/main/cmprlst/cmprinfo");
										caption3.value = "(건수:" + lstCnt + "건)";	
									}
									caption3.refresh();									
									//그리드 색깔표시
									for(var i=grd_keumcomparelst.fixedRows;i<grd_keumcomparelst.rows;i++){		
										var n1 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("n1"));
										var n2 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("n2"));
										var n3 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("n3"));	
										var ttaxamt = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("ttaxamt"));
										var ttaxamt2 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("ttaxamt2"));
										var sumamt3 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("sumamt3"));										

										if(n1 == "" && n2 == "" && n3 == ""){
											grd_keumcomparelst.rowStyle(i,"data","background-color") = "#FFFFCC";
										}else{
                                           if((n1 == "Y" && ttaxamt != "") &&(n2 == "" && ttaxamt2 == "0" ) &&(n3 == "" && sumamt3 == "0" )){  //세금계산서만
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											   model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");
										   }else if((n1 == "" && ttaxamt == "0") &&(n2 == "Y"  && ttaxamt2 != "" ) &&(n3 == "" && sumamt3 == "0" )){   //미용만
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											    model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");	
										   }else if((n1 == "" && ttaxamt == "0") &&(n2 == "" && ttaxamt2 == "0" ) &&(n3 == "Y"&& sumamt3 != "" )){   //계산서만   
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											    model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");											   
										   }else if((n1 == "Y" && ttaxamt != "") &&(n2 == "Y" && ttaxamt2 != "") &&(n3 == "" && sumamt3 == "0" )){   //세금계산서,미용   
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											    model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");											   
										   }else if((n1 == "Y" && ttaxamt != "") &&(n2 == "" && ttaxamt2 == "0" ) &&(n3 == "Y" && sumamt3 != "" )){   //세금계산서,계산서   
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											    model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");											   
										   }else if((n1 == "" && ttaxamt == "0") &&(n2 == "Y" && ttaxamt2 != "" ) &&(n3 == "Y" && sumamt3 != ""  )){   //미용,계산서   									
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											    model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");											
										   }else if((n1 == "Y" && ttaxamt != "") &&(n2 == "Y" && ttaxamt2 != "") &&(n3 == "Y" && sumamt3 != "" )){   //세금계산서,미용 ,계산서  
										       grd_keumcomparelst.rowStyle(i,"data","background-color") = "white";
											    model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/issueyn" , "★");											   
										   }else{
											   	grd_keumcomparelst.rowStyle(i,"data","background-color") = "#FFFFCC";
										   }   
										}
									}
								// 직전달 세금계산서 색인 리스트 저장 - 2017.08.14 김금련   
								var curdate = getCurrentDate();
				                var cvtdate = curdate.toDate("YYYYMM");
			                	var tobasedd = cvtdate.getAddDate(-1,"M").getDateFormat("YYYYMM");	
								var basedd = model.getValue("/root/send/srchbasedd");
								
					    	if((grd_keumcomparelst.rows > 1) && (tobasedd == basedd)){  
								    for(i = 1 ; i<grd_keumcomparelst.rows ; i++){
							             grd_keumcomparelst.rowStatus(i) = 1;
						            }
									updtdata = getGridUpdateData(grd_keumcomparelst);
									model.setValue("/root/send/save/cmprinfo", updtdata);
									submit("TXRSC08404"); 
								    for(i = 1 ; i<grd_keumcomparelst.rows ; i++){
							             grd_keumcomparelst.rowStatus(i) = 0;
						            }									
							    }
									
									grd_keumcomparelst.refresh();                          
								]]>
							</script>
						</button>
						<input id="ipt_srchchktodd" ref="/root/send/srchchktodd" class="combo_default" navindex="3" inputtype="date" style="left:470px; top:7px; width:95px; height:19px; "/>
						<caption id="caption42" style="left:452px; top:8px; width:15px; height:20px; font-weight:bold; ">~</caption>
						<caption id="caption14" class="search_name" style="left:255px; top:7px; width:117px; height:17px; ">검수일자 :</caption>
						<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_default" navindex="1" visibility="hidden" appearance="minimal" style="left:165px; top:5px; width:20px; height:19px; ">
							<choices>
								<itemset nodeset="/root/init/instcd">
									<label ref="cdnm"/>
									<value ref="cdid"/>
								</itemset>
							</choices>
						</select1>
						<caption id="caption12" class="search_name" style="left:10px; top:35px; width:90px; height:17px; ">구    분 :</caption>
						<select1 id="cmb_conflagnm" ref="/root/send/conflagnm" appearance="minimal" style="left:94px; top:35px; width:85px; height:19px; ">
							<choices>
								<item>
									<label>전체</label>
									<value/>
								</item>
								<item>
									<label>단가</label>
									<value>단가</value>
								</item>
								<item>
									<label>수의</label>
									<value>수의</value>
								</item>
							</choices>
						</select1>
						<input id="ipt_srchchkfrdd" ref="/root/send/srchchkfrdd" class="combo_default" navindex="2" inputtype="date" style="left:350px; top:7px; width:95px; height:19px; "/>
					</group>
					<caption id="caption35" class="tit_2" style="left:5px; top:80px; width:315px; height:13px; ">검수내역과 세금계산서 비교 리스트</caption>
					<line id="line2" class="line_1" style="x1:0px; y1:95px; x2:1190px; y2:95px; "/>
					<datagrid id="grd_keumcomparelst" nodeset="/root/main/cmprlst/cmprinfo" caption="^기준일자^유형^구분^계약일자/SEQ^계약일자/SEQ^거래처^거래처^계약건명^계약금액^사업자등록번호^발행^세금계산서^미용^계산서^계정과목^계정과목^검수일자/SEQ^검수일자/SEQ^(국)세금^(국)미용^(국)계산^FAX^HP^TEL^금액^참고사항^품의일자^품의seq" colsep="^" colwidth="20, 10, 39, 39, 75, 35, 33,90, 200, 70, 90, 30, 80, 50, 70, 55, 90, 75, 35, 60, 60, 60,100,100,100,0,100,10,10" explorerbar="sort" frozencols="7" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" tooltip="true" navindex="7" style="left:0px; top:100px; width:1190px; height:620px; ">
						<col checkvalue="Y,N" ref="select" type="checkbox"/>
						<col ref="basedd" visibility="hidden"/>
						<col ref="cont_type" style="text-align:center; "/>
						<col ref="conflagnm" style="text-align:center; "/>
						<col ref="purccondd" format="yyyy-mm-dd" style="text-align:center; "/>
						<col ref="purcconno" style="text-align:center; "/>
						<col ref="suplplcecd" style="text-align:center; "/>
						<col ref="suppcustnm" style="padding-left:5; "/>
						<col ref="goodcntnm" style="text-align:left; padding-left:5; "/>
						<col ref="totconamt" format="#,###" style="text-align:right; "/>
						<col ref="entrregno" format="999-99-99999" style="text-align:center; "/>
						<col ref="issueyn" style="text-align:center; "/>
						<col ref="ttaxamt" format="#,##0" style="text-align:right; "/>
						<col ref="ttaxamt2" format="#,##0" style="text-align:right; "/>
						<col ref="sumamt3" format="#,##0" style="text-align:right; "/>
						<col ref="acntcd" style="text-align:center; "/>
						<col ref="acntnm" style="left:124px; top:32px; width:100px; height:23px; text-align:center; padding-left:5; "/>
						<col ref="purcchkdd" format="yyyy-mm-dd" style="text-align:center; "/>
						<col ref="purcchkno" style="text-align:center; "/>
						<col ref="n1" style="text-align:center; "/>
						<col ref="n2" style="text-align:center; "/>
						<col ref="n3" style="text-align:center; "/>
						<col ref="faxno" style="text-align:center; "/>
						<col ref="taxhp" type="input" style="text-align:center; "/>
						<col ref="cntctel" style="text-align:center; "/>
						<col ref="tamt" visibility="hidden"/>
						<col ref="cmt" type="input" style="text-align:center; "/>
						<col ref="purccnsttndd" visibility="hidden"/>
						<col ref="purccnsttnno" visibility="hidden"/>
						<script type="javascript" ev:event="onmouseup">
							<![CDATA[
								if (isDataCell()) {
								    for ( var i = 1; i <= grd_keumcomparelst.rows-1; i++) {
                                    	model.setValue("/root/main/cmprlst/cmprinfo["+   i +"]/select" , "N");
										grd_keumcomparelst.rowStatus(i)= "0";		
//										alert(model.getValue("/root/main/cmprlst/cmprinfo["+   i +"]/goodcntnm"));
					            	}
									
									for ( var j = 0; j< grd_keumcomparelst.selectedRows;j++) {
										var k=grd_keumcomparelst.selectedRow(j);
										var temp = model.getValue("/root/main/cmprlst/cmprinfo["+ k +"]/select");

										model.setValue("/root/main/cmprlst/cmprinfo["+ k +"]/select" , "Y");
										grd_keumcomparelst.rowStatus(k) = "2";		
									}
								}
								model.refresh();
					]]>
						</script>
						<script type="javascript" ev:event="ondblclick">
							<![CDATA[
//							var instcd = getUserInfo("dutplceinstcd");
//							var clickcol = grd_keumcomparelst.colAttribute(grd_keumcomparelst.col,"ref");
//                            var flag       = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("flag"));							
//							var aspurccon = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("aspurccon"));
//							var purccondd = aspurccon.substr(0,8);
//							var purcconno = aspurccon.substr(11,4);	
//
//								model.makeValue("/root/popbattret/send/instcd", instcd);
//								model.makeValue("/root/popbattret/send/purccondd", purccondd);
//								model.makeValue("/root/popbattret/send/purcconno", purcconno);	
//							
//							if(clickcol == "aspurccon"){ // 계약일자 / 번호
//									if(flag == "PH") {
//										window.load("SMRSP00800.xrw", "modal","", "left:100; top:100;", "/root/popbattret/send","/root/temp/callopen");	
//									} else {
//										window.load("SMRSP00100.xrw", "modal","", "left:100; top:100;", "/root/popbattret/send","/root/temp/callopen");	
//									}	 
//							 }else  if(clickcol == "purcconseq"){ // 총액품목 변경단가계약 조회 분기
//							 	window.load("SMRSP00300.xrw", "modal","", "left:100; top:100;", "/root/popbattret/send","/root/temp/callopen");	
//							 } 
							]]>
						</script>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
								var clickcol = grd_keumcomparelst.colAttribute(grd_keumcomparelst.col,"ref");
						     	if(clickcol == "taxhp" ){
 								  var taxhp = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("taxhp"));
							      var entrregno = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("entrregno"));	
								         grd_keumcomparelst.addStatus(grd_keumcomparelst.selectedRow(0) , "update")
							    }
//    	                        if(clickcol == "remark" ){
// 								  var remark = grd_keumcomparelst.valueMatrix(grd_keumcomparelst.row, grd_keumcomparelst.colRef("remark"));
//								
//								   grd_keumcomparelst.valueMatrix(grd_keumcomparelst.selectedRow(0) , grd_keumcomparelst.colRef("select")) = "Y";
//								   grd_keumcomparelst.addStatus(grd_keumcomparelst.selectedRow(0) , "update");
//							    }								
    			                model.refresh();
							]]>
						</script>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
						     	grd_keumcomparelst.gridToInstance();
							]]>
						</script>
					</datagrid>
					<button id="btn_excel" class="btn2_letter4" style="left:1126px; top:-141px; width:64px; height:186px; ">
						<caption>엑셀저장</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								misfSaveExcel(grd_keumcomparelst); 
							]]>
						</script>
					</button>
					<button id="button2" class="btn2_letter2" style="left:1082px; top:-141px; width:42px; height:186px; ">
						<caption>출력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								var flag = "본";
								fPrint(flag);
							]]>
						</script>
					</button>
					<caption id="caption3" style="left:847px; top:73px; width:200px; height:20px; font-family:돋움체; font-size:10pt; font-weight:bold; color:#0000ff; text-align:right; "/>
					<button id="button5" class="btn5_letter5" navindex="21" style="left:1110px; top:75px; width:75px; height:19px; ">
						<caption>Excel 저장</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						if( grd_keumcomparelst.rows - grd_keumcomparelst.fixedRows > 0 ) {
							var fileName = "세금계산서 비교 리스트_" + getCurrentDate();
							var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
							grd_keumcomparelst.saveExcel(fileName, "Sheet");
						} else {
							messageBox("저장 데이터가","I004");
						}
					]]>
						</script>
					</button>
					<bool id="bol_selectall" visibility="hidden" overflow="visible" appearance="full" ref="/root/send/selectyn" style="left:21px; top:103px; width:20px; height:18px; font-weight:bold; border-style:none; ">
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
						var row = grd_keumcomparelst.rows;
	
						if( row > 1 ) {
							if(bol_selectall.value == "true") {
								for( var i = 1; i <= row-1 ; i++ ) {
									model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/select" , "Y");
								}
							} else {
								for( var i = 1; i <= row-1 ; i++ ) {
									model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/select" , "N");
								}
							}
							model.refresh();
						}
					]]>
						</script>
					</bool>
					<button id="btn_prta" class="btn6_letter2" style="left:1052px; top:73px; width:56px; height:22px; ">
						<caption>출력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
				         	model.removeNodeset("/root/prtinfo/cmprlst");		
				         	model.makeNode("/root/prtinfo/cmprlst");
							var totamtlist = "";
							for(var i=grd_keumcomparelst.fixedRows;i<grd_keumcomparelst.rows;i++){		

								if(grd_keumcomparelst.valueMatrix(i, grd_keumcomparelst.colRef("select")) == "Y") {
									var ttaxamt = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("ttaxamt"));
									var ttaxamt2 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("ttaxamt2"));
									var sumamt3 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("sumamt3"));
									var entrregno = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("entrregno"));	
									var entrregno = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("entrregno"));	
									var purcchkdd = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("purcchkdd"));
									var n1 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("n1"));
									var n2 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("n2"));
									var n3 = grd_keumcomparelst.valueMatrix(i,grd_keumcomparelst.colRef("n3"));
									var temp = "";
									var tamt = "";
									
									if(n1 != "" && n2 != "" && n3 != ""){
										temp = "7";
									}else if(n1 != "" && n2 != "" && n3 == ""){
										temp="6";
									}else if(n1 != "" && n2 == "" && n3 != ""){
										temp="5";
									}else if(n1 == "" && n2 != "" && n3 != ""){		
										temp="4";
									}else if(n1 != "" && n2 == "" && n3 == ""){		
										temp="3";		
									}else if(n1 == "" && n2 != "" && n3 == ""){		
										temp="2";			
									}else if(n1 == "" && n2 == "" && n3 != ""){		
										temp="1";	
									}else{
										temp ="0";
									}
									
									if(temp == "7"){
										tamt =  "'" + ttaxamt+ "','" + ttaxamt2+ "','" +sumamt3  + "'" ;
									}else if(temp == "6"){
										tamt = "'" + ttaxamt+ "','" + ttaxamt2 + "'";
									}else if(temp == "5"){
										tamt =  "'" + ttaxamt+ "','" + sumamt3 + "'";						
									}else if(temp == "4"){
										tamt =  "'" + ttaxamt2+ "','" + sumamt3 + "'";	
									}else if(temp == "3"){
										tamt =  "'" + ttaxamt + "'";	
									}else if(temp == "2"){
										tamt =  "'" + ttaxamt2 + "'";		
									}else if(temp == "1"){
										tamt =  "'" + sumamt3 + "'" ;	
									}
				//						alert(tamt);
									model.setValue("/root/main/cmprlst/cmprinfo["+ i +"]/tamt" , tamt);	
									model.setValue("/root/send/totamt",tamt);
									model.setValue("/root/send/entrregno",entrregno);	
									model.setValue("/root/send/acptdd",purcchkdd);										
									
									submit("TRRSC08405") ;

									exeReportPreview("RPRSD08401","XMLSTR","/root/prtinfo/cmprlst");
								} 				
							}
			
				//			totamtlist = totamtlist + tamt ;

					]]>
						</script>
					</button>
					<button id="button7" class="btn2_letter5" visibility="hidden" style="left:755px; top:70px; width:75px; height:19px; ">
						<caption>거래처저장</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
									updtdata = getGridUpdateData(grd_keumcomparelst);
					
									if(updtdata == ""){
										messageBox("저장할 데이터가 ","E014");
										return false;
									}else{									
										model.setValue("/root/send/save/keumcomparelst", updtdata);
										if( submit("TXRSC08403") ) {
											messageBox("저장이","I002");  
											btn_sea.dispatch("DOMActivate");
										} else {
											messageBox("저장","E009");
										   return;           
										}
									}
					]]>
						</script>
					</button>
				</case>
				<case id="case_upload">
					<caption id="caption7" class="tit_2" style="left:5px; top:50px; width:215px; height:15px; ">국세청 세금계산서 내역 업로드</caption>
					<line id="line3" class="line_1" style="x1:0px; y1:65px; x2:1192px; y2:65px; "/>
					<caption id="caption4" style="left:802px; top:45px; width:140px; height:18px; font-family:돋움체; font-size:10pt; font-weight:bold; color:#0000ff; "/>
					<datagrid id="grd_upperlimitupload" nodeset="/root/main/upperlimitlst/upperlimitinfo" caption="구분^기준일자^(A)작성일자^(B)승인번호^(C)발급일자^(D)전송일자^(E)사업자등록번호^(G)상호^(H)대표자^(I)주소^(K)종사업자^(O)합계금액^(P)공급가액^(Q)세액^(R)분류^(S)종류^(T)발급유형^(U)비고^(W)공급자이메일^(X)공급받는자이메일^(AA)품목명^(AB)규격^(AC)수량^(AD)단가" colsep="^" colwidth="50, 60, 80, 180, 80, 80, 110, 150, 60, 150, 80, 80, 80, 80, 100, 80, 100, 150, 150, 150, 150, 100, 60, 80" ellipsis="true" explorerbar="sort" rowheader="update" rowheight="23" rowsep="|" selectionmode="listbox" tooltip="true" style="left:0px; top:70px; width:1192px; height:645px; ">
						<col ref="flag" style="text-align:center; "/>
						<col ref="basedd" format="yyyy-mm" style="text-align:center; "/>
						<col ref="acptdd" format="yyyy-mm-dd" style="text-align:center; "/>
						<col ref="appno" 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="entrregno" format="999-99-99999" style="text-align:center; "/>
						<col ref="cmpynm" style="text-align:center; "/>
						<col ref="prsdnm" style="text-align:center; "/>
						<col ref="addr" style="text-align:center; "/>
						<col ref="mnrplcno" style="text-align:center; "/>
						<col ref="totamt" format="(-)#,##0" style="text-align:center; "/>
						<col ref="samt" format="(-)#,##0" style="text-align:center; "/>
						<col ref="amount" format="(-)#,##0" style="text-align:center; "/>
						<col ref="taxgubun" style="text-align:center; "/>
						<col ref="taxkind" style="text-align:center; "/>
						<col ref="issuetype" style="text-align:center; "/>
						<col ref="remark" style="text-align:center; "/>
						<col ref="semail" style="text-align:center; "/>
						<col ref="demail" style="text-align:center; "/>
						<col ref="goodcntnm" style="text-align:center; "/>
						<col ref="goodspec" style="text-align:center; "/>
						<col ref="qty" format="(-)#,##0" style="text-align:center; "/>
						<col ref="unitcost" format="(-)#,##0" style="text-align:center; "/>
						<script type="javascript" ev:event="onmouseup">
							<![CDATA[
							if (isDataCell()) {
								for ( var i = 1; i < grd_upperlimitupload.rows; i++) {
									grd_upperlimitupload.rowStatus(i) = 0;
								}
								
								for ( var j = 0 ; j< grd_upperlimitupload.selectedRows;j++) {
//								alert("선택:"+grd_upperlimitupload.selectedRow(j));
                                    var flag = model.getValue("/root/copynode/para_flag");
									if(flag == "F"){
								        grd_upperlimitupload.rowStatus(grd_upperlimitupload.selectedRow(j)) = 2;										
									}else{
								        grd_upperlimitupload.rowStatus(grd_upperlimitupload.selectedRow(j)) = 4;
									}
								}
							}
							]]>
						</script>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
						     	grd_upperlimitupload.gridToInstance();
							]]>
						</script>
					</datagrid>
					<button id="button1" class="btn5_letter3" style="left:1136px; top:44px; width:53px; height:19px; ">
						<caption>업로드</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								model.removenode("/root/main/upperlimitlst/upperlimitinfo");

								var menu_cnt = grd_upperlimitupload.rows;
								var fileName = window.fileDialog("open", "", false);
								grd_upperlimitupload.loadExcel(fileName);
								
								for (i=grd_upperlimitupload.fixedRows; i<grd_upperlimitupload.rows; i++)
								{
									grd_upperlimitupload.rowStatus(i) = 1; //insert
								}								
								
								model.setValue("/root/send/sdata", grd_upperlimitupload.getUpdateData());

								var lstCnt = getNodesetCount("/root/main/upperlimitlst/upperlimitinfo");
								if( lstCnt > 0 ){	
									if( submit("TXRSC08401")){
										btn_search.dispatch("DOMActivate");	
										messageBox("업로드되었습니다.", "I000");
										caption4.value = "(건수:" + lstCnt + "건)";
									}
								}
								model.refresh();
							]]>
						</script>
					</button>
					<group id="group1" style="left:0px; top:5px; width:1192px; height:35px; vertical-align:top; ">
						<shape id="roundrect2" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
						<line id="line1" class="line_4" style="x1:1052px; y1:7px; x2:1052px; y2:29px; "/>
						<button id="btn_search" class="btn1_letter2" style="left:1061px; top:6px; width:56px; height:22px; ">
							<caption>조회</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[
                                    caption4.value = "";
									var ubasedd = model.getValue("/root/send/ubasedd");
									model.setValue("/root/send/ufromdd", ubasedd +"01");
									model.setValue("/root/send/utodd", ubasedd +"31");
									
									if( submit("TRRSC08401") ) {
										var lstCnt = getNodesetCount("/root/main/upperlimitlst/upperlimitinfo");
										if( lstCnt > 0 ){
											caption4.value = "(건수:" + lstCnt + "건)";
										}
									}
									model.removenode("/root/copynode");
									model.removenode(gvParamPath +"/SMRSD00400_/SMRSD00400_value");
									model.makeNode("/root/copynode");									
									model.refresh();	
									
									for(var i=grd_upperlimitupload.fixedRows;i<grd_upperlimitupload.rows;i++){		
										var flag = grd_upperlimitupload.valueMatrix(i,grd_upperlimitupload.colRef("flag"));

										if(flag == "제외"){
											grd_upperlimitupload.rowStyle(i,"data","background-color") = "#fec3c3";
										}else{
											grd_upperlimitupload.rowStyle(i,"data","background-color") = "white";
										}
									}
									grd_upperlimitupload.refresh();
								]]>
							</script>
						</button>
						<button id="button3" class="btn4_letter2" style="left:1125px; top:6px; width:56px; height:22px; ">
							<caption>저장</caption>
							<script type="javascript" ev:event="DOMActivate">
								<![CDATA[
							if(grd_upperlimitupload.rows != "1") model.setValue("/root/send/save/upperlimitinfo" ,grd_upperlimitupload.getUpdateData());	
						
							if( submit("TXRSC08402") ) {
								btn_search.dispatch("DOMActivate");	
								messageBox(" ", "I001", "");
							}
							model.removenode("/root/copynode");
							model.removenode(gvParamPath +"/SMRSD00400_/SMRSD00400_value");
							model.makeNode("/root/copynode");  
					    ]]>
							</script>
						</button>
						<caption id="caption8" class="search_name" style="left:19px; top:8px; width:90px; height:17px; ">기준일자 :</caption>
						<input id="ipt_ubasedd" ref="/root/send/ubasedd" class="input_default" navindex="3" inputtype="date" format="yyyy-mm" style="left:104px; top:7px; width:100px; height:19px; text-align:center; "/>
						<caption id="caption9" class="search_name" style="left:235px; top:7px; width:90px; height:17px; ">거래처명 :</caption>
						<input id="ipt_custnm" ref="/root/send/ucustnm" class="input" navindex="4" style="left:322px; top:8px; width:178px; height:19px; text-align:center; "/>
						<input id="ipt_uentrregno" ref="/root/send/uentrregno" class="input" navindex="4" format="999-99-99999" style="left:660px; top:9px; width:178px; height:19px; text-align:center; "/>
						<caption id="caption10" class="search_name" style="left:533px; top:8px; width:124px; height:17px; ">사업자 등록번호 :</caption>
					</group>
					<button id="button4" class="btn5_letter4" style="left:1067px; top:44px; width:64px; height:19px; ">
						<caption>전체삭제</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
									for ( var i = 1; i < grd_upperlimitupload.rows; i++) {
									grd_upperlimitupload.rowStatus(i) = 4;
								}
							]]>
						</script>
					</button>
					<button id="btn_upchk" class="btn2_letter2" navindex="13" style="left:942px; top:44px; width:42px; height:19px; ">
						<caption>검증</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[                                   

						model.removenode("/root/copynode");
						model.removenode(gvParamPath +"/SMRSD00400_/SMRSD00400_value");
						model.makeNode("/root/copynode");

						setParameter("para_ubasedd"       , model.getValue(ipt_ubasedd.attribute("ref")));					     					     

//						modal("SPRSD08401");				
	                     window.load("SPRSD08401_세금계산서중복조회.xrw", "modal","", "", "/root/send","/root/init");						
	                     
						 var acptdd = model.getValue("/root/copynode/para_acptdd"); 
						 var entrregno = model.getValue("/root/copynode/para_entrregno")
						 var totamt = model.getValue("/root/copynode/para_totamt")	
						
						model.setValue("/root/send/acptdd", acptdd);
						model.setValue("/root/send/entrregno", entrregno);	
						model.setValue("/root/send/totamt", totamt);		
						
						submit("TRRSC08403");
//						var CSV = model.getValue(gvParamPath +"/SMRSD00400_/SMRSD00400_value");
//						setCSVToNode("/root/copynode", CSV, "purccnsttnsublist");						
							
						model.refresh();
					]]>
						</script>
					</button>
					<caption id="caption11" style="left:215px; top:49px; width:130px; height:15px; background-color:#ffcc66; ">※ 기준일자(YYYYMM)</caption>
					<button id="button8" class="btn5_letter5" navindex="21" style="left:988px; top:44px; width:75px; height:19px; ">
						<caption>Excel 저장</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						if( grd_upperlimitupload.rows - grd_upperlimitupload.fixedRows > 0 ) {
							var fileName = "세금계산서 내역 업로드_" + getCurrentDate();
							var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
							grd_upperlimitupload.saveExcel(fileName, "Sheet");
						} else {
							messageBox("저장 데이터가","I004");
						}
					]]>
						</script>
					</button>
				</case>
			</switch>
			<button id="btn_tabcompare" class="btn_sw" group="tab" selected="true" style="left:0px; top:10px; width:95px; height:22px; ">
				<caption>색인</caption>
				<toggle case="case_compare" ev:event="onclick"/>
			</button>
			<button id="btn_tabupload" class="btn_sw" group="tab" style="left:95px; top:10px; width:75px; height:22px; ">
				<caption>업 로 드</caption>
				<toggle case="case_upload" ev:event="onclick"/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>