YNU_JEUS/app_home/himed/webapps/pam/pamendstatsweb/xrw/SMPAE00301_원무마감집계계정관리.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?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:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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>
						<sscdlist>
							<sscdinfo>
								<earncls/>
								<dispseq/>
								<ordflag/>
								<lrgnm/>
								<mdlnm/>
								<smlnm/>
								<crpammod/>
								<crpamnm/>
								<drpammod/>
								<drpamnm/>
								<setqueryflag/>
								<setquery/>
								<prgdescflag/>
								<prgdesc/>
								<bizdescflag/>
								<bizdesc/>
								<flagnm/>
								<craccountcd/>
								<crmisflag/>
								<draccountcd/>
								<drmisflag/>
								<fromdd/>
								<todd/>
							</sscdinfo>
						</sscdlist>
					</main>
					<send>
						<sscd/>
						<aggkind>0</aggkind>
					</send>
					<temp>
						<grupstr/>
						<pammod/>
						<agginfo>
							<setquery/>
							<prgdesc/>
							<bizdesc/>
						</agginfo>
					</temp>
				</root>
			</instance>
			<submission id="TRPAE00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/sscdlist/sscdinfo"/>
			<submission id="TXPAE00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/sscdlist/sscdinfo"/>
		</model>
		<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/dateHelper.js"/>
		<script type="javascript">
			<![CDATA[
				
				var SELROW = -1;
				
			]]>
		</script>
		<script type="javascript" ev:event="xforms-ready">
			<![CDATA[
				btn_search.dispatch("DOMActivate");
			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:20px; width:1195px; height:41px; background-color:#fffbf2; border-color:#ffd799; "/>
		<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1045px; top:30px; width:56px; height:22px; background-image:../../../com/commonweb/images/btn1_letter2.gif; ">
			<caption>조회</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					submit("TRPAE00301");
					grd_sscd.rebuildStyle();
				]]>
			</script>
		</button>
		<button id="btn_excel1" class="btn2_letter2" disable.background-image="../../../com/commonweb/images/dis_btn2_letter3.gif" style="left:1153px; top:65px; width:42px; height:19px; background-image:../../../com/commonweb/images/btn2_letter3.gif; ">
			<caption>엑셀</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					var filename = window.fileDialog("save", ",", false, "원무수익 재무 자동분개 계정", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
					grd_sscd.saveExcel(filename, "sheetname:계정목록;colhiddenextend:false;rowhiddenextend:false");
					
					messageBox("엑셀 저장이 완료되었습니다.", "I999");
				]]>
			</script>
		</button>
		<caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:191px; height:14px; font-family:돋움; vertical-align:middle; ">원무 수익 재무 자동분개 관리</caption>
		<caption id="cap_grid" class="tit_2" style="left:0px; top:70px; width:85px; height:14px; ">계정 목록</caption>
		<line id="line2" class="line_1" style="x1:0px; y1:85px; x2:1195px; y2:85px; "/>
		<datagrid id="grd_sscd" nodeset="/root/main/sscdlist/sscdinfo" allowselection="false" backcoloralternate="transparent" caption="집계계정^순서^구분^대분류명^중분류명^소분류명^원 무^원 무^원 무^원 무^집 계^집 계^집 계^집 계^집 계^집 계^재 무^재 무^재 무^재 무^재 무^적용시작일^적용종료일|집계계정^순서^구분^대분류명^중분류명^소분류명^차변증감^차변명칭^대변증감^대변명칭^쿼리^쿼리^전산^전산^원무^원무^전표 적요^차변코드^차변분개^대변코드^대변분개^적용시작일^적용종료일" colsep="^" colwidth="60, 35, 50, 60, 150, 150, 60, 0, 60, 0, 30, 0, 30, 0, 30, 0, 195, 60, 0, 0, 0, 95, 95" extendlastcol="scroll" frozencols="6" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:90px; width:1195px; height:490px; ">
			<col ref="earncls" style="text-align:center; "/>
			<col ref="dispseq" format="#" style="text-align:center; "/>
			<col disabled="true" ref="ordflag" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>입원</label>
						<value>I</value>
					</item>
					<item>
						<label>외래</label>
						<value>O</value>
					</item>
					<item>
						<label>건진</label>
						<value>S</value>
					</item>
				</choices>
			</col>
			<col ref="lrgnm" type="input" maxbyte="50" style="padding-left:1; "/>
			<col ref="mdlnm" type="input" maxbyte="50" style="padding-left:1; "/>
			<col ref="smlnm" type="input" maxbyte="50" style="padding-left:1; "/>
			<col ref="crpammod" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>증가</label>
						<value>1</value>
					</item>
					<item>
						<label>감소</label>
						<value>-1</value>
					</item>
				</choices>
			</col>
			<col ref="crpamnm" type="input" visibility="hidden" style="text-align:center; "/>
			<col ref="drpammod" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>증가</label>
						<value>1</value>
					</item>
					<item>
						<label>감소</label>
						<value>-1</value>
					</item>
				</choices>
			</col>
			<col ref="drpamnm" type="input" visibility="hidden" style="text-align:center; "/>
			<col disabled="true" ref="setqueryflag" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>○</label>
						<value>Y</value>
					</item>
				</choices>
			</col>
			<col ref="setquery"/>
			<col disabled="true" ref="prgdescflag" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>○</label>
						<value>Y</value>
					</item>
				</choices>
			</col>
			<col ref="prgdesc"/>
			<col disabled="true" ref="bizdescflag" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>○</label>
						<value>Y</value>
					</item>
				</choices>
			</col>
			<col ref="bizdesc"/>
			<col ref="flagnm" type="input" maxbyte="100" style="padding-left:1; "/>
			<col ref="craccountcd" style="text-align:center; "/>
			<col ref="crmisflag" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>차변</label>
						<value>D</value>
					</item>
					<item>
						<label>대변</label>
						<value>C</value>
					</item>
				</choices>
			</col>
			<col ref="draccountcd" style="text-align:center; "/>
			<col ref="drmisflag" type="combo" style="text-align:center; ">
				<choices>
					<item>
						<label>차변</label>
						<value>D</value>
					</item>
					<item>
						<label>대변</label>
						<value>C</value>
					</item>
				</choices>
			</col>
			<col ref="fromdd" type="inputdate" format="yyyy-mm-dd" style="text-align:center; "/>
			<col ref="enddd" type="inputdate" format="yyyy-mm-dd" style="text-align:center; "/>
			<script type="javascript" ev:event="xforms-value-changed">
				<![CDATA[
					
					var row = grd_sscd.row;
					var col = grd_sscd.col;
					
					grd_sscd.cellStyle("font-weight", row, col) = "bold";
					grd_sscd.rowStyle(row, "all", "background-color") = "#ffffa0";
					
					if (col == grd_sscd.colRef("crpammod") || col == grd_sscd.colRef("drpammod")) {
						
						var setCol = (col == grd_sscd.colRef("crpammod")) ? grd_sscd.colRef("drpammod") : grd_sscd.colRef("crpammod");
						grd_sscd.valueMatrix(row, setCol) = Number(grd_sscd.valueMatrix(row, col)) * -1;
						grd_sscd.cellStyle("font-weight", row, setCol) = "bold";
						grd_sscd.refresh();
					}
				]]>
			</script>
			<script type="javascript" ev:event="onclick">
				<![CDATA[
				
					var row = SELROW = grd_sscd.row + grd_sscd.frozenRows - 1;
					
					if (row < 1) {
						return;
					}
					
					model.setValue("/root/temp/agginfo/setquery", model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/setquery"));
					model.setValue("/root/temp/agginfo/prgdesc",  model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/prgdesc"));
					model.setValue("/root/temp/agginfo/bizdesc",  model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/bizdesc"));
					
					tar_setquery.refresh();
					tar_prgdesc.refresh();
					tar_bizdesc.refresh();
					
					var ordflag = model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/ordflag");
					if (ordflag == "I") {
						ordflag = "입원";
					} else if (ordflag == "O") { 
						ordflag = "외래";
					} else if (ordflag == "S") {
						ordflag = "건진";
					}
					
					var str = "[ " + model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/earncls") + " ]  "
					        + "[ " + ordflag + " ]  "
							+ model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/lrgnm") + " - "
							+ model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/mdlnm") + " - "
							+ model.getValue("/root/main/sscdlist/sscdinfo[" + row + "]/smlnm");
					
				]]>
			</script>
		</datagrid>
		<button id="btn_save" class="btn4_letter2" style="left:1130px; top:30px; width:56px; height:22px; ">
			<caption>저장</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					if (grd_sscd.getUpdateDataXml("update") == "") {
						messageBox("변경사항이 없습니다", "E999");
						return;
					}
					
					var nodeset = grd_sscd.nodeset;
					var cnt = instance1.selectNodes(nodeset).length;
					
					for (var i = 1; i < cnt; i++) {
						
						if (grd_sscd.rowStatus(i) == 2) {
							
							if (model.getValue(nodeset + "[" + i + "]/dispseq") == "") {
								messageBox("순서를 입력하십시오", "E999");
								return;
							}
							
							if (model.getValue(nodeset + "[" + i + "]/lrgnm") == "") {
								messageBox("대분류명을 입력하십시오", "E999");
								return;
							}
							
							if (model.getValue(nodeset + "[" + i + "]/mdlnm") == "") {
								messageBox("중분류명을 입력하십시오", "E999");
								return;
							}
							
							if (model.getValue(nodeset + "[" + i + "]/smlnm") == "") {
								messageBox("소분류명을 입력하십시오", "E999");
								return;
							}
							
							if (model.getValue(nodeset + "[" + i + "]/flagnm") == "") {
								messageBox("재무계정명을 입력하십시오", "E999");
								return;
							}
						}
					}
					
					model.setValue("/root/send/sscd", grd_sscd.getUpdateData());
					if (submit("TXPAE00301")) {
						grd_sscd.rebuildStyle();
					}
				]]>
			</script>
		</button>
		<line id="line13" style="x1:1115px; y1:28px; x2:1115px; y2:55px; border-color:#FFD799; border-left-style:solid; "/>
		<caption id="caption21" class="search_name" style="left:10px; top:32px; width:70px; height:17px; ">구분 :</caption>
		<line id="line1" style="x1:1030px; y1:28px; x2:1030px; y2:55px; border-color:#FFD799; border-left-style:solid; "/>
		<select1 id="radio1" ref="/root/send/aggkind" appearance="full" cellspacing="5" cols="7" overflow="visible" style="left:75px; top:33px; width:345px; height:15px; border-style:none; ">
			<choices>
				<item>
					<label>전체</label>
					<value>0</value>
				</item>
				<item>
					<label>수익</label>
					<value>1</value>
				</item>
				<item>
					<label>수입</label>
					<value>2</value>
				</item>
				<item>
					<label>미수</label>
					<value>3</value>
				</item>
				<item>
					<label>선수</label>
					<value>4</value>
				</item>
				<item>
					<label>기타</label>
					<value>5</value>
				</item>
				<item>
					<label>건진</label>
					<value>6</value>
				</item>
			</choices>
		</select1>
		<caption id="cap_setquery" class="tit_2" style="left:0px; top:595px; width:87px; height:13px; ">집계 Query</caption>
		<line id="ln_setquery" class="line_1" style="x1:0px; y1:610px; x2:395px; y2:610px; "/>
		<textarea id="tar_setquery" ref="/root/temp/agginfo/setquery" scroll="autovscroll" maxbyte="4000" style="left:0px; top:615px; width:395px; height:150px; padding:5; "/>
		<caption id="cap_prgdesc" class="tit_2" style="left:400px; top:595px; width:148px; height:13px; ">집계 내역 설명 (전산)</caption>
		<line id="ln_prgdesc" class="line_1" style="x1:400px; y1:610px; x2:795px; y2:610px; "/>
		<textarea id="tar_prgdesc" ref="/root/temp/agginfo/prgdesc" scroll="autovscroll" maxbyte="4000" style="left:400px; top:615px; width:395px; height:150px; padding:5; "/>
		<caption id="cap_bizdesc" class="tit_2" style="left:800px; top:595px; width:148px; height:13px; ">집계 내역 설명 (원무)</caption>
		<line id="ln_bizdesc" class="line_1" style="x1:800px; y1:610px; x2:1195px; y2:610px; "/>
		<button id="btn_setdesc" class="btn2_letter2" style="left:1153px; top:590px; width:42px; height:19px; ">
			<caption>입력</caption>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					if (SELROW < 1) {
						return;
					}
					
					var setquery = model.getValue("/root/temp/agginfo/setquery").trim();
					var prgdesc  = model.getValue("/root/temp/agginfo/prgdesc").trim();
					var bizdesc  = model.getValue("/root/temp/agginfo/bizdesc").trim();
					
					var row = SELROW - grd_sscd.frozenRows + 1;
					
					model.setValue("/root/main/sscdlist/sscdinfo[" + SELROW + "]/setqueryflag", ( setquery != "" ? "Y" : "N" ));
					model.setValue("/root/main/sscdlist/sscdinfo[" + SELROW + "]/setquery",     setquery);
					model.setValue("/root/main/sscdlist/sscdinfo[" + SELROW + "]/prgdescflag",  ( prgdesc != "" ? "Y" : "N" ));
					model.setValue("/root/main/sscdlist/sscdinfo[" + SELROW + "]/prgdesc",      prgdesc);
					model.setValue("/root/main/sscdlist/sscdinfo[" + SELROW + "]/bizdescflag",  ( bizdesc != "" ? "Y" : "N" ));
					model.setValue("/root/main/sscdlist/sscdinfo[" + SELROW + "]/bizdesc",      bizdesc);
					
					grd_sscd.refresh();
					
					grd_sscd.rowStyle(row, "all", "background-color") = "#ffffa0";
					
					grd_sscd.addStatus(row, "update");
					
				]]>
			</script>
		</button>
		<textarea id="tar_bizdesc" ref="/root/temp/agginfo/bizdesc" scroll="autovscroll" maxbyte="4000" style="left:800px; top:615px; width:395px; height:150px; padding:5; "/>
		<button id="btn_collapse" style="left:1099px; top:590px; width:26px; height:19px; background-image:../../../com/commonweb/images/btn_send_bottom.gif; ">
			<caption/>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					grd_sscd.attribute("height") = "490px";
					
					cap_setquery.attribute("top") = "595px";
					cap_prgdesc.attribute("top")  = "595px";
					cap_bizdesc.attribute("top")  = "595px";
					
					ln_setquery.attribute("y1") = ln_setquery.attribute("y2") = "610px";
					ln_prgdesc.attribute("y1")  = ln_prgdesc.attribute("y2")  = "610px";
					ln_bizdesc.attribute("y1")  = ln_bizdesc.attribute("y2")  = "610px";
					
					tar_setquery.attribute("top") = "615px";
					tar_prgdesc.attribute("top")  = "615px";
					tar_bizdesc.attribute("top")  = "616px";
					
					tar_setquery.attribute("height") = "150px";
					tar_prgdesc.attribute("height")  = "150px";
					tar_bizdesc.attribute("height")  = "150px";
					
					btn_expand.attribute("top")   = "590px";
					btn_collapse.attribute("top") = "590px";
					btn_setdesc.attribute("top")  = "590px";
					
				]]>
			</script>
		</button>
		<button id="btn_expand" style="left:1126px; top:590px; width:26px; height:19px; background-image:../../../com/commonweb/images/btn_send_top.gif; ">
			<caption/>
			<script type="javascript" ev:event="DOMActivate">
				<![CDATA[
					grd_sscd.attribute("height") = "200px";
					
					cap_setquery.attribute("top") = "305px";
					cap_prgdesc.attribute("top")  = "305px";
					cap_bizdesc.attribute("top")  = "305px";
					
					ln_setquery.attribute("y1") = ln_setquery.attribute("y2") = "320px";
					ln_prgdesc.attribute("y1")  = ln_prgdesc.attribute("y2")  = "320px";
					ln_bizdesc.attribute("y1")  = ln_bizdesc.attribute("y2")  = "320px";
					
					tar_setquery.attribute("top") = "325px";
					tar_prgdesc.attribute("top")  = "325px";
					tar_bizdesc.attribute("top")  = "326px";
					
					tar_setquery.attribute("height") = "440px";
					tar_prgdesc.attribute("height")  = "440px";
					tar_bizdesc.attribute("height")  = "440px";
					
					btn_expand.attribute("top")   = "300px";
					btn_collapse.attribute("top") = "300px";
					btn_setdesc.attribute("top")  = "300px";
				]]>
			</script>
		</button>
	</xhtml:body>
</xhtml:html>