123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
- <grid>
- <degolist/>
- </grid>
- </main>
- <send>
- <instcd/>
- <yyyy/>
- <mngtdeptcd_search/>
- <mngtdeptnm_search/>
- <dfromdd/>
- <dtodd/>
- <basedd/>
- <useyn/>
- <deptaprvnm/>
- <senddd/>
- <passnmin/>
- <passnmax/>
- </send>
- <init>
- </init>
- <hidden/>
- <temp>
- <userinfo/>
- </temp>
- <popacnt>
- <instcd/>
- <yyyy/>
- <selectyn/>
- </popacnt>
- <popacntlist>
- <acntlist/>
- </popacntlist>
- </root>
- </instance>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
- <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- fInitialize();
- ]]>
- </script>
- <submission id="TRRFC00403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/grid/degolist"/>
- <submission id="TRRFC00404" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp/userinfo"/>
- <submission id="TXRFC00405" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/grid/degolist" resultref="/root/temp"/>
- <submission id="TXRFC00406" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
- <submission id="TXRFC00408" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
- </model>
- <script type="javascript">
- <![CDATA[
- // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
- function fInitialize() {
- misfGridInit(grd_degolist);
-
- misfComboComCdList("C0048",cmb_instcd,"Y"); //기관코드
-
- model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd")); // 기관 설정
- model.setValue(ipt_yyyy.attribute("ref"),getCurrentDate().substring(0, 4));
-
- misfMsterDetailSet(grd_degolist, null, "TRRFC00403","Y"); //마스터 설정
-
- model.setValue(ipt_mngtdeptcd_search.attribute("ref") , getUserInfo("dutplcecd"));
- model.setValue(ipt_mngtdeptnm_search.attribute("ref") , getUserInfo("dutplcenm"));
-
- if(getUserInfo("dutplceinstcd") == "031"){
- cap_dept031.visible = true;
- cap_dept032.visible = false;
- }else{
- cap_dept031.visible = false;
- cap_dept032.visible = true;
- }
-
- var dutplcecd = getUserInfo("dutplcecd");
- if(dutplcecd == "4020334000" || getUserInfo("userid") == "MIS" || getUserInfo("userid") == "99207" ){
- btn_search.dispatch("DOMActivate");
- }else{
- messageBox("물류팀외 조회할 수","I004");
- btn_search.disabled = true;
- btn_save.disabled = true;
- btn_proc.disabled = true;
- ipt_yyyy.disabled = true;
- btn_mngtdeptcd_search.disabled = true;
- ipt_mngtdeptcd_search.disabled = true;
- }
-
- model.refresh();
- }
- ]]>
- </script>
- </xhtml:head>
- <xhtml:body pagewidth="1200" pageheight="800" 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:186px; height:15px; ">재물조사 실사 관리</caption>
- </group>
- <group id="grp_biz" scroll="auto" style="left:0px; top:38px; width:1195px; height:722px; ">
- <group id="grp_sea" style="left:0px; top:10px; width:1185px; height:35px; vertical-align:top; ">
- <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1185px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
- <line id="line13" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
- </group>
- </group>
- <group id="group2" style="left:0px; top:12px; width:1195px; height:27px; ">
- <line id="line16" class="line_2" style="x1:0px; y1:25px; x2:1185px; y2:25px; "/>
- <button id="btn_clear" class="btn4_letter3" navindex="13" visibility="hidden" style="left:555px; top:0px; width:68px; height:22px; ">
- <caption>초기화</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fInitialize();
- ]]>
- </script>
- </button>
- <button id="btn_save" class="btn4_letter2" navindex="12" style="left:1130px; top:3px; width:56px; height:22px; ">
- <caption>저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var updtdata = getGridUpdateData(grd_degolist);
-
- if (updtdata == "") {
- messageBox("변경된 데이터가","I004");
- return;
- }
- misfSave("TXRFC00405");
- btn_search.dispatch("DOMActivate");
- messageBox("저장", "I002");
- ]]>
- </script>
- </button>
- <button id="btn_proc" class="btn1_letter4" navindex="12" visibility="visible" style="left:1048px; top:3px; width:80px; height:22px; ">
- <caption>일괄처리</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var deptcd = model.getValue("/root/send/mngtdeptcd_search");
- if(deptcd == ""){
- messageBox("부서코드가", "I004");
- return;
- }else{
- if ( messageBox("일괄 실사결과입력을", "Q004") == 6 ) {
- if(misfSave("TXRFC00408")){
- btn_search.dispatch("DOMActivate");
- messageBox("저장", "I002");
- }
- model.refresh();
- }
- }
- ]]>
- </script>
- </button>
- </group>
- <group id="group1" scroll="auto" style="left:0px; top:38px; width:1195px; height:722px; ">
- <group id="group3" style="left:0px; top:10px; width:1185px; height:35px; vertical-align:top; ">
- <shape id="roundrect2" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1185px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
- <caption id="cap_instcd" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">기관코드 :</caption>
- <line id="line1" class="line_4" style="x1:1110px; y1:5px; x2:1110px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
- <button id="btn_search" class="btn1_letter2" navindex="6" style="left:1125px; top:6px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- submit("TRRFC00403");
-
- var yyyy = model.getValue("/root/main/grid/degolist[1]/yyyy");
- var basedd = model.getValue("/root/main/grid/degolist[1]/basedd");
- var tbasedd = yyyy + "-" + basedd.substr(0,2) + "-" + basedd.substr(2,2);
- var dfromdd = model.getValue("/root/main/grid/degolist[1]/dfromdd"); //부서확인기간(fromdd)
- var dtodd = model.getValue("/root/main/grid/degolist[1]/dtodd"); //부서확인기간(todd)
- var useyn = model.getValue("/root/main/grid/degolist[1]/useyn"); //사용여부
- var passnmin = model.getValue("/root/main/grid/degolist[1]/passnmin"); //기준금액(min)
- var passnmax = model.getValue("/root/main/grid/degolist[1]/passnmax"); //기준금액(max)
- var deptaprvnm = model.getValue("/root/main/grid/degolist[1]/deptaprvnm"); //부서장 승인자명
- var senddd = model.getValue("/root/main/grid/degolist[1]/senddd"); //최종제출일자
- var dd = getCurrentDate();
- model.setValue("/root/send/basedd",tbasedd);
- model.setValue("/root/send/dfromdd",dfromdd);
- model.setValue("/root/send/dtodd",dtodd);
- model.setValue("/root/send/useyn",useyn);
- model.setValue("/root/send/deptaprvnm",deptaprvnm);
- model.setValue("/root/send/senddd",senddd);
- model.setValue("/root/send/passnmin",passnmin);
- model.setValue("/root/send/passnmax",passnmax);
-
- model.refresh();
- ]]>
- </script>
- </button>
- <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:108px; top:8px; width:177px; height:19px; text-align:center; ">
- <choices>
- <itemset>
- <label/>
- <value/>
- </itemset>
- </choices>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- btn_search.dispatch("DOMActivate");
- ]]>
- </script>
- </select1>
- <input id="ipt_mngtdeptcd_search" ref="/root/send/mngtdeptcd_search" class="input_search" disabled="false" navindex="4" style="left:790px; top:5px; width:95px; height:19px; ">
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- misfSearchDept(ipt_mngtdeptnm_search);
- ]]>
- </script>
- </input>
- <button id="btn_mngtdeptcd_search" class="icon_search" disabled="false" navindex="-1" style="left:888px; top:5px; width:16px; height:16px; ">
- <caption/>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- misfOpenPopUpList("02", ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
- ipt_mngtdeptcd_search.refresh();
- ipt_mngtdeptnm_search.refresh();
- ]]>
- </script>
- </button>
- <caption id="cap_dept031" class="search_name" visibility="hidden" style="left:690px; top:5px; width:92px; height:17px; ">사용부서 :</caption>
- <input id="ipt_mngtdeptnm_search" ref="/root/send/mngtdeptnm_search" class="output_fix" navindex="-1" editable="false" appearance="input" style="left:907px; top:5px; width:150px; height:19px; "/>
- <caption id="cap_dept032" class="search_name" visibility="hidden" style="left:690px; top:5px; width:92px; height:17px; ">설치장소 :</caption>
- </group>
- <line id="line3" class="line_1" style="x1:0px; y1:149px; x2:1195px; y2:149px; "/>
- <caption id="caption10" class="tit_2" style="left:5px; top:134px; width:205px; height:13px; ">부서별 대상품목 리스트</caption>
- <datagrid id="grd_degolist" nodeset="/root/main/grid/degolist" caption="계정과목^계정과목^자산코드^자산명^규격^수량^취득금액^취득일^잔존가^보유상태^실사결과^실사비고^부서비고^사용부서^설치부서^년도^기준일자^부서확인(fromdd)^부서확인(todd)^사용여부^기준금액(min)^기준금액(max)^사용부서코드^부서장승인자명^최종제출일자" colsep="^" colwidth="55,100, 100, 216, 131, 35, 75, 70, 75,60,60,115,115,90,90,0,0,0,0,0,0,0,0,0,0" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" navindex="7" style="left:0px; top:155px; width:1195px; height:563px; ">
- <col ref="acntcd" visibility="hidden" style="text-align:center; "/>
- <col ref="acntnm" style="padding-left:5; "/>
- <col ref="fixasetcd" style="text-align:center; "/>
- <col ref="goodflaghngnm" style="padding-left:5; "/>
- <col ref="goodspec" style="padding-left:5; "/>
- <col ref="goodqty" style="text-align:center; "/>
- <col ref="possnamt" format="#,##0" style="text-align:right; "/>
- <col ref="possndd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="janjonsak" format="#,##0" style="text-align:right; "/>
- <col disabled="true" ref="status" type="combo" style="text-align:center; ">
- <choices>
- <item>
- <label>보유</label>
- <value>1</value>
- </item>
- <item>
- <label>미보유</label>
- <value>2</value>
- </item>
- <item>
- <label>불용</label>
- <value>3</value>
- </item>
- </choices>
- </col>
- <col ref="silstatus" type="combo" style="text-align:center; background-color:#C4E693; ">
- <choices>
- <item>
- <label>보유</label>
- <value>1</value>
- </item>
- <item>
- <label>미보유</label>
- <value>2</value>
- </item>
- <item>
- <label>불용</label>
- <value>3</value>
- </item>
- </choices>
- </col>
- <col ref="silcmt" type="input" style="text-align:center; background-color:#C4E693; "/>
- <col ref="remark" style="text-align:center; "/>
- <col ref="mngtdeptnm" style="text-align:center; "/>
- <col ref="installplcenm" style="text-align:center; "/>
- <col ref="yyyy" visibility="hidden"/>
- <col ref="basedd" visibility="hidden"/>
- <col ref="dfromdd" visibility="hidden"/>
- <col ref="dtodd" visibility="hidden"/>
- <col ref="useyn" visibility="hidden"/>
- <col ref="passnmin" visibility="hidden"/>
- <col ref="passnmax" visibility="hidden"/>
- <col ref="mngtdeptcd" visibility="hidden"/>
- <col ref="deptaprvnm" visibility="hidden"/>
- <col ref="senddd" visibility="hidden"/>
- <col ref="instcd" visibility="hidden"/>
- <script type="javascript" ev:event="xforms-value-changed">
- <![CDATA[
- // if(grd_propllist.col == grd_propllist.colRef("deptcd")) {
- // misfValidationCheck("02", "grd_propllist", "deptcd,deptnm", model.getValue(cmb_instcd.attribute("ref")),"instcd");
- // }
- ]]>
- </script>
- <script type="javascript" ev:event="onaftersort">
- <![CDATA[
- grd_degolist.gridToInstance();
- ]]>
- </script>
- </datagrid>
- <button id="button4" class="btn2_letter4" navindex="8" style="left:1122px; top:129px; width:64px; height:19px; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- var deptnm = model.getValue("/root/send/mngtdeptnm_search");
-
- if( grd_degolist.rows - grd_degolist.fixedRows > 0 ) {
- var fileName ="("+ deptnm +")"+"재물대상품목_" + getCurrentDate();
- var fileName = window.fileDialog("save", ",", false, fileName, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
- grd_degolist.saveExcel(fileName, "Sheet");
- } else {
- messageBox("저장 데이터가","I004");
- }
- ]]>
- </script>
- </button>
- <input id="ipt_yyyy" ref="/root/send/yyyy" class="input_search" navindex="2" visibility="hidden" style="left:450px; top:15px; width:105px; height:19px; text-align:center; "/>
- <caption id="caption11" class="tit_2" style="left:5px; top:50px; width:205px; height:15px; ">재물조사 정보</caption>
- <shape id="rectangle2" appearance="rectangle" style="left:1px; top:66px; width:1185px; height:62px; background-color:#ffffcc; border-color:#99ccff; "/>
- <caption id="caption12" class="cell_1" style="left:225px; top:72px; width:105px; height:23px; text-align:center; vertical-align:middle; ">부서 확인기간 :</caption>
- <input id="input8" ref="/root/send/dfromdd" disabled="true" navindex="2" format="yyyy-mm-dd" style="left:333px; top:73px; width:105px; height:19px; text-align:center; "/>
- <input id="input9" ref="/root/send/dtodd" disabled="true" navindex="2" format="yyyy-mm-dd" style="left:457px; top:73px; width:105px; height:19px; text-align:center; "/>
- <caption id="caption13" class="cell_1" style="left:10px; top:72px; width:90px; height:23px; text-align:center; vertical-align:middle; ">기준일자 :</caption>
- <input id="input10" ref="/root/send/basedd" disabled="true" navindex="2" style="left:103px; top:73px; width:92px; height:19px; text-align:center; "/>
- <caption id="caption14" class="cell_1" style="left:590px; top:72px; width:80px; height:23px; text-align:center; vertical-align:middle; ">사용여부 :</caption>
- <input id="input11" ref="/root/send/useyn" disabled="true" navindex="2" style="left:673px; top:73px; width:45px; height:19px; text-align:center; "/>
- <caption id="caption16" style="left:442px; top:74px; width:20px; height:20px; ">~</caption>
- <caption id="caption1" class="cell_1" style="left:745px; top:72px; width:105px; height:23px; text-align:center; vertical-align:middle; ">부서장 승인자명 :</caption>
- <caption id="caption2" class="cell_1" style="left:970px; top:72px; width:105px; height:23px; text-align:center; vertical-align:middle; ">최종제출일자 :</caption>
- <input id="input1" ref="/root/send/deptaprvnm" disabled="true" navindex="2" style="left:853px; top:73px; width:90px; height:19px; text-align:center; "/>
- <input id="input2" ref="/root/send/senddd" disabled="true" navindex="2" format="yyyy-mm-dd" style="left:1078px; top:73px; width:85px; height:19px; text-align:center; "/>
- <caption id="caption3" class="cell_1" style="left:10px; top:101px; width:90px; height:23px; text-align:center; vertical-align:middle; ">기준금액 :</caption>
- <input id="input3" ref="/root/send/passnmin" disabled="true" navindex="2" format="#,##0" style="left:104px; top:102px; width:105px; height:19px; text-align:center; "/>
- <input id="input4" ref="/root/send/passnmax" disabled="true" navindex="2" format="#,##0" style="left:228px; top:102px; width:105px; height:19px; text-align:center; "/>
- <caption id="caption4" style="left:213px; top:103px; width:20px; height:20px; ">~</caption>
- </group>
- </xhtml:body>
- </xhtml:html>
|