YNU_JEUS/app_home/himed/webapps/mis/accountinginfoweb/xrw/SMRAR01500_월감가상각조회.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: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>
						<maindatalist>
							<instcd/>
							<acntcd/>
							<acntnm/>
							<fixasetcd/>
							<goodflaghngnm/>
							<goodspec/>
							<fixasetunit/>
							<qty/>
							<possnamt/>
							<possndd/>
							<mngtdeptnm/>
							<suplplcenm/>
							<cntsyearno/>
							<goodmodel/>
							<yyyymm/>
							<basejsak/>
							<bbaseksckeum/>
							<danggisangak/>
							<baseksckeum/>
							<janjonsak/>
						</maindatalist>
					</main>
					<send>
						<fixasetlist>
							<instcd_search/>
							<fixasetcd_search/>
							<fixasetnm_search/>
							<lrgcd_search/>
							<before_yyyymm/>
							<excute_yyyymm/>
							<goodflag_search/>
							<mngtdeptcd_search/>
							<mngtdeptnm_search/>
							<acntcd_search/>
							<page_search/>
							<installplcecd_search/>
							<installplcenm_search/>
						</fixasetlist>
						<sendlist>
							<instcd_search/>
							<fixasetcd_search/>
							<fixasetnm_search/>
							<lrgcd_search/>
							<before_yyyymm/>
							<excute_yyyymm/>
							<goodflag_search/>
							<mngtdeptcd_search/>
							<mngtdeptnm_search/>
						</sendlist>
					</send>
					<init>
						<goodflag>
							<cdnm/>
							<cdid/>
						</goodflag>
						<instcd>
							<cdnm/>
							<cdid/>
						</instcd>
						<be_yyyymm>
							<yyyymm/>
						</be_yyyymm>
						<acntlist>
							<acntnm>--전체--</acntnm>
							<acntcd/>
						</acntlist>
						<pagelist>
							<label/>
							<value/>
						</pagelist>
					</init>
					<temp/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
					function fInitialize()
					{
						misfComboComCdList("Z0007", cmb_instcd_search,   "N");	//기관코드
						model.setValue(cmb_instcd_search.attribute("ref"), getUserInfo("dutplceinstcd"));

					 	rszfGoodFlagListByPgmGubn(cmb_goodflag_search,"2","N");	//유형자산구분
					  	cmb_goodflag_search.select(0);					  						
						  
						rszfLMSComboList(model.getValue(cmb_goodflag_search.attribute("ref")), "", "",  "cmb_lrgcd_search", "", "L");	//대분류 코드 콤보 설정. 
						
						addComboItem("cmb_goodflag_search","--전체--","","above");
						addComboItem("cmb_lrgcd_search","--전체--","","above");
						
						fGetPageList();
															
						model.refresh();
					}
					
					//조회
					function fGetMainDataList()	{					
						if (ipt_yyyymm.value == ""){
							messageBox("작업년월을 ","C001");
							return false;
						}
						if ( (ipt_yyyymm.value).length != 6 ){
							messageBox("작업년월을 6 자리로","C001");
							return false;
						}
						return true;
					}
					
					//정렬 순서로 sort함.
					function fGetSortSeq(){
						var num = grd_main.rows- 1;
						if(rdo_seq.value == 1){
							grd_main.sort(1, 2, num, 2) = "asc";
						}else{
							grd_main.sort(1, 3, num, 3) = "asc";
						}
						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);
							
							for(i = 1; i < pGrid.rows; i++) {
								pGrid.rowStatus(i) = 1;
							}
							pGrid.refresh();
						}
					}
					
					//계정과목 조회
					function fGetAcntcdList() {
						if(ipt_yyyymm.value.length == 6){
							submit("TRRAR01502");
							addComboItem("cmb_acntcd_search","--전체--","","above");
							if(cmb_acntcd_search.label.length == 0){
								cmb_acntcd_search.select(0);
							}
						}
						cmb_acntcd_search.refresh();
					}
					
					function fGetPageList() {
						if(ipt_yyyymm.value.length == 6){
							submit("TRRAR01503");
						}
						if(ipt_yyyymm.value.length != 6 || cmb_page_search.length == 1){
							model.resetInstanceNode("/root/init/pagelist");
							model.setValue("/root/init/pagelist/label","--전체--");
						}
						cmb_page_search.refresh();
						cmb_page_search.select(0);
					}
				]]>
			</script>
			<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="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<submission id="TRRAR01501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/sendlist" resultref="/root/main/maindatalist"/>
			<submission id="TRRAR01502" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixasetlist" resultref="/root/init/acntlist"/>
			<submission id="TRRAR01503" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixasetlist" resultref="/root/init/pagelist"/>
			<bind id="bind_cpt_gaamtsum" ref="/root/hidden/apsl/sumgaamt" calculate="sum(/root/main/search/maindatalist/gaamt)"/>
		</model>
	</xhtml:head>
	<xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">월 감가상각 조회</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:40; width:1195px; height:744px; ">
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:85px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:85px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line5" class="line_4" style="x1:1122px; y1:8px; x2:1122px; y2:55px; border-color:#ffe4bb; border-left-style:solid; "/>
				<button id="button2" class="btn1_letter2" navindex="13" style="left:1133px; top:21px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							if( fGetMainDataList()  ) {	
					 			setAlertOn();
					 			model.copyNode ("/root/send/sendlist", "/root/send/fixasetlist");
					 			submit("TRRAR01501");
					 			
					 		/*	if(cmb_page_search.length == 1){
									grd_main.seqRowHeader = 1;
								}else{
									grd_main.seqRowHeader = cmb_page_search.value - 10000 + 1;
								}  */
								
								model.refresh();
							}
						]]>
					</script>
				</button>
				<select1 id="cmb_instcd_search" ref="/root/send/fixasetlist/instcd_search" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:100px; top:10px; width:150px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							fGetPageList();				
						]]>
					</script>
				</select1>
				<input id="ipt_yyyymm" ref="/root/send/fixasetlist/excute_yyyymm" class="input_s_essential" navindex="5" maxlength="6" format="9999-99" style="left:350px; top:35px; width:100px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							fGetAcntcdList();
							fGetPageList();
						]]>
					</script>
				</input>
				<input id="ipt_fixasetcd_search" ref="/root/send/fixasetlist/fixasetcd_search" class="input_search" navindex="9" visibility="visible" style="left:807px; top:33px; width:95px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_fixasetcd_search.value != "")
							{
								rszfValidationCheck("TRRSD00241", "rfcmfacdlist", "instcd,requirementcd,requirementnm,goodflag", 
												 cmb_instcd_search.value +",fixasetcd," + ipt_fixasetcd_search.value +"," + cmb_goodflag_search.value,
												  "", "fixasetcd_search,fixasetnm_search", ipt_fixasetcd_search, "SPRSD00240",
												  "instcd,goodflag","cmb_instcd_search,cmb_goodflag_search");
							}else{
								ipt_fixasetnm_search.value = '';
							}
							fGetPageList();
							grp_sea.refresh();
					]]>
					</script>
				</input>
				<input id="ipt_fixasetnm_search" ref="/root/send/fixasetlist/fixasetnm_search" class="input_search" disabled="true" navindex="10" style="left:925px; top:33px; width:185px; height:19px; "/>
				<caption id="caption2" class="search_name" style="left:461px; top:11px; width:89px; height:17px; ">대 분 류 :</caption>
				<button id="btn_fixasetcd" class="icon_search" navindex="-1" style="left:906px; top:35px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							rszfOpenPopUpListByWndName(ipt_fixasetcd_search, "", "fixasetcd_search,fixasetnm_search","SPRSD00240","instcd,goodflag","cmb_instcd_search,cmb_goodflag_search");
							grp_sea.refresh();
						]]>
					</script>
				</button>
				<caption id="caption3" class="search_name" style="left:11px; top:10px; width:89px; height:17px; ">기관코드 :</caption>
				<select1 id="cmb_lrgcd_search" ref="/root/send/fixasetlist/lrgcd_search" navindex="4" visibility="visible" appearance="minimal" style="left:550px; top:10px; width:150px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							fGetAcntcdList();
							fGetPageList();				
						]]>
					</script>
				</select1>
				<select1 id="cmb_goodflag_search" ref="/root/send/fixasetlist/goodflag_search" class="input_s_essential" navindex="2" appearance="minimal" style="left:350px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/goodflag">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							// 대분류 코드 콤보 설정.	
							rszfLMSComboList(model.getValue(cmb_goodflag_search.attribute("ref")), "", "",  "cmb_lrgcd_search", "", "L");
							addComboItem("cmb_lrgcd_search","--전체--","","above");
							cmb_lrgcd_search.dispatch("xforms-value-changed");
							
							fGetPageList();
						]]>
					</script>
				</select1>
				<caption id="cap_codeflag" class="search_name" style="left:260px; top:35px; width:90px; height:17px; ">상각년월 :</caption>
				<caption id="caption8" class="search_name" style="left:260px; top:10px; width:90px; height:17px; ">자산구분 :</caption>
				<caption id="caption9" class="search_name" style="left:715px; top:34px; width:110px; height:17px; ">자산코드 :</caption>
				<input id="ipt_mngtdeptcd_search" ref="/root/send/fixasetlist/mngtdeptcd_search" class="input_search" navindex="7" style="left:807px; top:8px; width:95px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							if(ipt_mngtdeptcd_search.value.length == 0) 
								ipt_mngtdeptnm_search.value = "";
							else 
								rszfValidationCheck("TRRPZ00201", "deptcodelist", "refcond,deptcd", 
									      "deptcd," + ipt_mngtdeptcd_search.value, "", "mngtdeptcd_search,mngtdeptnm_search",
										ipt_mngtdeptcd_search, "SPRPZ00200", "","");
							fGetPageList();
							grp_sea.refresh();
						]]>
					</script>
				</input>
				<caption id="cap_installplcecd" class="search_name" style="left:715px; top:9px; width:92px; height:17px; ">사용부서 :</caption>
				<button id="btn_mngtdeptcd_search" class="icon_search" navindex="-1" style="left:906px; top:8px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							misfOpenPopUpList("02", ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
							grp_sea.refresh();
						]]>
					</script>
				</button>
				<input id="ipt_mngtdeptnm_search" ref="/root/send/fixasetlist/mngtdeptnm_search" class="input_search" disabled="true" navindex="8" appearance="input" style="left:925px; top:8px; width:185px; height:19px; "/>
				<select1 id="cmb_acntcd_search" ref="/root/send/fixasetlist/acntcd_search" navindex="6" visibility="visible" appearance="minimal" style="left:550px; top:35px; width:150px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/acntlist">
							<label ref="acntnm"/>
							<value ref="acntcd"/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							fGetPageList();				
						]]>
					</script>
				</select1>
				<caption id="caption5" class="search_name" style="left:460px; top:35px; width:90px; height:17px; ">계정과목 :</caption>
				<caption id="caption10" class="search_name" style="left:11px; top:35px; width:89px; height:17px; ">조회범위 :</caption>
				<select1 id="cmb_page_search" ref="/root/send/fixasetlist/page_search" class="input_s_essential" navindex="3" appearance="minimal" style="left:100px; top:35px; width:150px; height:19px; ">
					<choices>
						<itemset nodeset="/root/init/pagelist">
							<label ref="label"/>
							<value ref="value"/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption11" class="search_name" style="left:715px; top:59px; width:95px; height:17px; ">설치장소 :</caption>
				<input id="ipt_installplcecd" ref="/root/send/fixasetlist/installplcecd_search" class="input_search" navindex="11" visibility="visible" appearance="input" style="left:807px; top:58px; width:95px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						if(ipt_installplcecd.value.length == 0) 
							ipt_installplcenm.value = "";
						else
							rszfValidationCheck("TRRAC90701", "custlist", "refcond,retrnm", 
									      "deptcd," + ipt_installplcecd.value, "", "installplcecd_search,installplcenm_search",
										ipt_installplcecd, "PPRAC00700", "","");
						grp_sea.refresh();
					]]>
					</script>
				</input>
				<button id="btn_installplcecd" class="icon_search" visibility="visible" style="left:906px; top:58px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						misfOpenPopUpList("19", ipt_installplcecd,"", "installplcecd_search,installplcenm_search", model.getValue(cmb_instcd_search.attribute("ref")),"instcd"); 																				
						grp_sea.refresh();
					]]>
					</script>
				</button>
				<input id="ipt_installplcenm" ref="/root/send/fixasetlist/installplcenm_search" class="input_search" disabled="true" navindex="12" visibility="visible" appearance="input" style="left:925px; top:58px; width:185px; height:19px; "/>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:125px; x2:1194px; y2:125px; "/>
			<button id="btn_excel" class="btn5_letter5" navindex="14" style="left:1115px; top:102px; width:75px; height:19px; ">
				<caption>Excel 저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							
						if( grd_main.rows - grd_main.fixedRows > 0 ) {
							var fileName ="";
							
							if(cmb_page_search.length == 1){
								fileName =  "월감가상각조회List_" + getCurrentDate();
							}else{
								fileName =  "월감가상각조회List_" + getCurrentDate() + "_" + cmb_page_search.label.replace("/","of");
							}
							
							var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
							grd_main.saveExcel(fileName, "Sheet");
						} else {
							messageBox("저장 데이터가","I004");
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_main" nodeset="/root/main/maindatalist" caption="기관코드^계정코드^계정명^자산코드^자산명^규격^단위^수량^구입금액^구입일^사용부서^설치장소^공급처^내용년수^모델명^상각년월^취득금액^전기말누계액^당기상각액^감가누계^미상각잔액^상계여부" colsep="^" colwidth="0, 0, 112, 99, 180, 100, 60, 50, 90, 80, 100, 100, 120, 70, 120, 70, 90, 100, 100, 90, 80" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" tooltip="true" navindex="15" style="left:0px; top:130px; width:1194px; height:585px; ">
				<col ref="instcd" style="text-align:right; "/>
				<col ref="acntcd" style="left:106px; top:23px; width:128px; height:23px; "/>
				<col ref="acntnm" style="text-align:left; "/>
				<col ref="fixasetcd"/>
				<col ref="goodflaghngnm" format="yyyy-mm-dd" style="left:904px; top:23px; width:100px; height:23px; text-align:left; "/>
				<col ref="goodspec" style="text-align:left; "/>
				<col ref="fixasetunit" style="text-align:center; "/>
				<col ref="qty" style="text-align:center; "/>
				<col ref="possnamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="possndd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="mngtdeptnm"/>
				<col ref="installplcenm"/>
				<col ref="suplplcenm"/>
				<col ref="cntsyearno" style="text-align:center; "/>
				<col ref="goodmodel" style="left:1045px; top:23px; width:100px; height:23px; "/>
				<col ref="yyyymm" style="text-align:center; "/>
				<col ref="basejsak" format="(-)#,###" style="text-align:right; "/>
				<col ref="bbaseksckeum" format="(-)#,###" style="text-align:right; "/>
				<col ref="danggisangak" format="(-)#,###" style="text-align:right; "/>
				<col ref="baseksckeum" format="(-)#,###" style="text-align:right; "/>
				<col ref="janjonsak" format="(-)#,###" style="left:1651px; top:23px; width:80px; height:23px; text-align:right; "/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_main.gridToInstance();
					]]>
				</script>
			</datagrid>
			<caption id="caption21" class="tit_2" style="left:5px; top:107px; width:131px; height:13px; ">출력 목록</caption>
			<caption id="caption7" style="left:85px; top:107px; width:560px; height:14px; ">(* 10,000건 이상인 경우 10,000건만 조회가 됩니다. 조회범위 조건을 입력 하신후 조회하세요.)</caption>
		</group>
		<group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
			<line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
		</group>
		<caption id="caption1" class="cell_1" visibility="hidden" style="left:134px; top:757px; width:120px; height:23px; text-align:center; vertical-align:middle; ">가수금합계</caption>
		<caption id="cpt_gaamtsum" ref="/root/hidden/apsl/sumgaamt" visibility="hidden" format="(-)#,###" style="left:255px; top:757px; width:151px; height:23px; text-align:right; vertical-align:middle; background-color:#ffcccc; "/>
	</xhtml:body>
</xhtml:html>