123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390 |
- <?xml version="1.0" encoding="EUC-KR"?>
- <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
- <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
- <xhtml:head>
- <xhtml:title>학생봉사자명단 및 현황조회</xhtml:title>
- <model id="model1">
- <instance id="instance1">
- <root xmlns="">
- <main>
- <cond>
- <year/>
- <vacflag/>
- </cond>
- <studvoluntr>
- <studvoluntrlist>
- <chk/>
- <servyy/>
- <vacatflag/>
- <actfromdd/>
- <acttodd/>
- <voluntrnm/>
- <brthdd/>
- <sex/>
- <actdeptcd/>
- <schnm/>
- <servtm/>
- <hometel/>
- <mpphontel/>
- <voluntrid/>
- <deptnm/>
- <year1/>
- <month1/>
- <day1/>
- <cdval/>
- </studvoluntrlist>
- </studvoluntr>
- <aaa>
- <report>
- <systeminstnm/>
- </report>
- </aaa>
- </main>
- <init>
- <sex/>
- <vacatflagcd>
- </vacatflagcd>
- <actdeptcd/>
- </init>
- <send>
- <reqdata/>
- </send>
- <hidden>
- </hidden>
- </root>
- </instance>
- <script type="javascript" ev:event="xforms-ready">
- <![CDATA[
- //grd_studvoluntrlist.fixedcellcheckbox(0,1) = "true";
- fInit();
- ]]>
- </script>
- <submission id="TRAAA02001" ref="/root/send/reqdata" method="post" mediatype="application/x-www-form-urlencoded" resultref="/root/main/studvoluntrlist"/>
- <submission id="TRZBC00101" method="post" mediatype="application/x-www-form-urlencoded"/>
- </model>
- <script type="javascript" src="../../../com/commonweb/js/common.js"/>
- <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
- <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
- <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
- <script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
- </xhtml:head>
- <script type="javascript">
- <![CDATA[
- //초기화
- function fInit() {
- model.removeNodeset("/root/main/studvoluntr/studvoluntrlist");
- var sYear = getCurrentDate().substr(0,4);
- model.setValue("/root/main/cond/year", sYear);
-
- addComboItem("cmb_vacatflagcd","전체","%","above");
- model.setValue("/root/main/cond/vacflag","%");
- grd_studvoluntrlist.fixedcellcheckbox(0,1)=true; //체크박스 위에 전체 선택 하는 콤보 셋팅
- zbcfGetCodeList(new Array("A0366","P0313","A0503"),new Array("/root/init/vacatflagcd","/root/init/sex","/root/init/actdeptcd"),true);
-
- var systeminstnm = getUserInfo("systeminstnm");
- model.setValue("/root/main/aaa/report/systeminstnm", systeminstnm);
-
-
-
- model.refresh();
- }
-
- //엑셀저장 버튼 클릭시
- function fExcel() {
- if (grd_studvoluntrlist.rows <= 1) {
- messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
- return;
- }
-
- var fileName = window.fileDialog("save", ",", false, "학생자원봉사자 명단", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
- if (fileName != ""){
- grd_studvoluntrlist.saveExcel(fileName, "SheetName", false, false, "", "", false);
- }
- }//fExcel END
-
- //조회버튼클릭시
- function fStudVoluntrlist() {
- if (model.getValue("/root/main/cond/year") == "" ) {
- messageBox("조회년도는 ","I003");
- model.setFocus("ipt_year");
- return false;
- }
- model.removeNodeset("/root/main/studvoluntr");
- //model.makeNode("/root/main/studvoluntr/studvoluntrlist");
- model.removenode("/root/send");
- model.makeNode("/root/send/reqdata");
- model.copyNode("/root/send/reqdata", "/root/main/cond");
-
- submit("TRAAA02001");
-
- var idxRow = grd_studvoluntrlist.rows-1; //전체 9
-
- for(i=1;i<=idxRow;i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
- {
- var brthdd1 =model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/brthdd");
- var year1 = brthdd1.substr(0,4);
- var month1 = brthdd1.substr(4,2);
- var day1 = brthdd1.substr(6,2);
-
- model.makeNode("/root/main/studvoluntr/studvoluntrlist["+i+"]/year1");
- model.makeNode("/root/main/studvoluntr/studvoluntrlist["+i+"]/month1");
- model.makeNode("/root/main/studvoluntr/studvoluntrlist["+i+"]/day1");
- model.setValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/year1", year1);
- model.setValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/month1", month1);
- model.setValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/day1", day1);
- }
-
- }
- ]]>
- </script>
- <xhtml:body guideline="1,1194;2,824;" 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:207px; height:14px; ">학생자원봉사자명단 및 현황조회</caption>
- </group>
- <group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:744px; ">
- <group id="grp_sea" style="left:0px; top:10px; width:1194px; height:35px; vertical-align:top; ">
- <shape id="roundrect1" class="roundrect_search" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
- <button id="button1" class="btn1_letter2" style="left:1123px; top:7px; width:56px; height:22px; ">
- <caption>조회</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fStudVoluntrlist();
- ]]>
- </script>
- </button>
- <line id="line13" class="line_4" style="x1:1107px; y1:7px; x2:1107px; y2:29px; "/>
- <caption id="caption3" class="search_name" style="left:20px; top:10px; width:94px; height:17px; ">조회년도 :</caption>
- <select1 id="cmb_vacatflagcd" ref="/root/main/cond/vacflag" class="combo_search" appearance="minimal" style="left:354px; top:9px; width:85px; height:19px; ">
- <choices>
- <itemset nodeset="/root/init/vacatflagcd/A0366">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </select1>
- <input id="ipt_year" ref="/root/main/cond/year" class="input_default" appearance="minimal" style="left:114px; top:9px; width:86px; height:19px; "/>
- <caption id="caption2" class="search_name" style="left:260px; top:10px; width:90px; height:17px; ">방학구분 :</caption>
- </group>
- <datagrid id="grd_studvoluntrlist" nodeset="/root/main/studvoluntr/studvoluntrlist" autoresize="true" caption="^년도^방학구분^시작일^종료일^성명^생년월일^성별^활동부서^학교명^활동시간누계^전화(자택)^휴대번호^voluntrid^활동부서명^year1^month1^day1^cdval" colwidth="44, 61, 70, 95, 95, 95, 95, 70, 135, 110, 80, 105, 105, 100, 100, 100, 100, 100, 100" dataheight="25" explorerbar="sort" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" colsep="^" style="left:0px; top:76px; width:1194px; height:665px; ">
- <col ref="chk" type="checkbox" checkvalue="1,0"/>
- <col ref="servyy" style="text-align:center; "/>
- <col ref="vacatflag" type="combo" disabled="true" style="text-align:center; ">
- <choices>
- <itemset nodeset="/root/init/vacatflagcd/A0366">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </col>
- <col ref="actfromdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="acttodd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="voluntrnm" style="text-align:left; "/>
- <col ref="brthdd" format="yyyy-mm-dd" style="text-align:center; "/>
- <col ref="sex" type="combo" disabled="true" style="text-align:center; ">
- <choices>
- <itemset nodeset="/root/init/sex/P0313">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </col>
- <col ref="actdeptcd" type="combo" disabled="true" style="text-align:left; ">
- <choices>
- <itemset nodeset="/root/init/actdeptcd/A0503">
- <label ref="cdnm"/>
- <value ref="cdid"/>
- </itemset>
- </choices>
- </col>
- <col ref="schnm" style="text-align:left; "/>
- <col ref="servtm" style="text-align:center; "/>
- <col ref="hometel" style="text-align:left; "/>
- <col ref="mpphontel" style="text-align:left; "/>
- <col ref="voluntrid" visibility="hidden"/>
- <col ref="deptnm" visibility="hidden"/>
- <col ref="year1" visibility="hidden"/>
- <col ref="month1" visibility="hidden"/>
- <col ref="day1" visibility="hidden"/>
- <col ref="cdval" visibility="hidden"/>
- </datagrid>
- <button id="button3" class="btn2_letter4" disable.background-image="../../../com/commonweb/images/dis_btn2_letter4.gif" style="left:1117px; top:51px; width:64px; height:19px; background-image:../../../com/commonweb/images/btn2_letter4.gif; ">
- <caption>엑셀저장</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fExcel();
- ]]>
- </script>
- </button>
- </group>
- <group id="group5" scroll="auto" style="left:0px; top:757px; width:1195px; height:27px; ">
- <button id="button95" class="btn6_letter4" style="left:0px; top:3px; width:80px; height:22px; ">
- <caption>명찰출력</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[
- fchk();
- function fchk() {
- var idxRow = grd_studvoluntrlist.rows; //data+1
- var idxRows = grd_studvoluntrlist.fixedRows; //1
- var chkCount = 0;
- var NodeCnt =0;
- for(i=1;i<=idxRow-idxRows;i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
- {
- var chkFlag=model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/chk"); //값이 있으면 1 없으면 null
- if(chkFlag=='1')
- {
- /*
- var NodeCnt=eval(getNodesetCount("/root/hidden/studvoluntr/studvoluntrlist"))+1; //선택된 자원봉사자 갯수를 셈
- //eva 사용[X] + 1 = 01, eval사용[O] + 1 = 1 (eval은 객체의 value값을 얻어올수 있다.alert(obj.value))
- // alert(NodeCnt);
- model.makeNode("/root/hidden/studvoluntr/studvoluntrlist["+NodeCnt+"]");
- model.copyNode("/root/hidden/studvoluntr/studvoluntrlist["+NodeCnt+"]","/root/main/studvoluntr/studvoluntrlist["+i+"]");
- // 체크가 된 봉사자 갯수만큼 해당 값 복사해서 넘긴다.
- */
- var NodeCnt = NodeCnt +1;
- model.makeNode("/root/hidden/studvoluntr/studvoluntrlist["+NodeCnt+"]");
- model.copyNode("/root/hidden/studvoluntr/studvoluntrlist["+NodeCnt+"]","/root/main/studvoluntr/studvoluntrlist["+i+"]");
-
- chkCount=chkCount+1;
- // 체크된 봉사자 갯수를 세서 없을 때는 메시지 처리 한다.
- }
- }
- if(chkCount=='0')
- {
- messageBox("명찰 출력할 자원봉사자를 선택하십시오.","I");
- return;
- }
- fPreview();
- }
- function fPreview(){
- /*
- var rid = "RPAAA02001"; // 레포트명
- var dataType = "XMLSTR"; // 연계방법(XMLSTR/ XMLFILE/ XML)
- var paramsXPath = "/root/hidden/studvoluntr"; // 매개변수필드 XPath [미리보기 그리드]
- var submitId = ""; // SubmitID
- var print = ""; // 출력여부(true, false)
- var printDialog = ""; // 인쇄 창 보임 여부(true, false)
- var fileType = ""; // 저장타입(xls/ pdf/ hml/rtf/ html/ bmp/ txt/ xml )
- var fileName = ""; // 파일명(c:\report\레포트명.저장타입)
- var fileDialog = ""; // 파일 저장 창 보임여부(0 : 숨김[기본]/1 : 보임)
- var closeYn = ""; // 미리보기창닫기여부(출력 후 true로 설정한 경우 미리보기 화면 닫기)
- var monNo = ""; // 모니터 번호
- var parentObjId = ""; // 부모객체명(미리 생성한 부모 객체명, 해당 부모 객체에 레포트 데이터를 생성한다.)
- var printPaperBin = ""; // 트레이번호
- var userService = ""; // 데이터 소스
- var showButton = ""; // 툴바버튼보임여부(visible, hidden)
- var printCount = ""; // 프린트장수(1, 2,..)
- var zoomRate = ""; // 미리보기뷰어 비율(0, 50,...)
- var printOption = ""; // 출력시 선택 옵션
- var dataXPath = ""; // 데이터 XPath
- var mainDataXPath = ""; // 메인리포트 반복XPath
- var subDataXPath = ""; // 서브리포트1 반복Xpath
-
- exeReportPreview(rid, dataType, paramsXPath, submitId, print, printDialog, fileType, fileName, fileDialog, closeYn, monNo, parentObjId, printPaperBin, userService, showButton, printCount, zoomRate, printOption, dataXPath, mainDataXPath, subDataXPath);
- */
-
-
- exeReportPreview("RPAAA02001", "XMLSTR","/root/hidden/studvoluntr"); //미리보기
- model.removeNodeset("/root/hidden/studvoluntr"); //그리드미리보기하려고
- model.makeNode("/root/hidden/studvoluntr");
- model.refresh();
- }//fPreview END
- ]]>
- </script>
- </button>
- <line id="line37" class="line_6" style="x1:0px; y1:0px; x2:1194px; y2:0px; "/>
- <button id="button2" class="btn6_letter4" visibility="hidden" style="left:83px; top:3px; width:80px; height:22px; ">
- <caption>활동일지</caption>
- <script type="javascript" ev:event="DOMActivate">
- <![CDATA[ //2명이상
- fchk();
- function fchk() {
- var idxRow = grd_studvoluntrlist.rows; //전체 9
- var idxRows = grd_studvoluntrlist.fixedRows; //1 실제data는 8개 [9-1]
- var chkCount = 0;
- for(i=1;i<=idxRow-idxRows;i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
- {
- var chkFlag=model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/chk"); //값이 있으면 1 없으면 null
- if(chkFlag=='1')
- {
- var NodeCnt=eval(getNodesetCount("/root/hidden/studvoluntr/studvoluntrlist"))+1; //선택된 자원봉사자 갯수를 셈
- //eva 사용[X] + 1 = 01, eval사용[O] + 1 = 1 (eval은 객체의 value값을 얻어올수 있다.alert(obj.value))
-
- model.makeNode("/root/hidden/studvoluntr/studvoluntrlist["+NodeCnt+"]");
- model.copyNode("/root/hidden/studvoluntr/studvoluntrlist["+NodeCnt+"]","/root/main/studvoluntr/studvoluntrlist["+i+"]");
- // 체크가 된 봉사자 갯수만큼 해당 값 복사해서 넘긴다.
- chkCount=chkCount+1;
- // 체크된 봉사자 갯수를 세서 없을 때는 메시지 처리 한다.
- }
- }
- if(chkCount=='0')
- {
- messageBox("활동일지를 출력할 자원봉사자를 선택하십시오.","I");
- return;
- }
- fPreview();
- }
-
- function fPreview(){
- exeReportPreview("RPAAA02002", "XMLSTR");
- model.removeNodeset("/root/hidden/studvoluntr"); //그리드미리보기하려고
- model.makeNode("/root/hidden/studvoluntr");
- }//fPreview END
- ]]>
- </script>
- </button>
- <button id="button4" class="btn3_letter4" style="left:82px; top:3px; width:80px; height:22px; ">
- <caption>SMS전송</caption>
- <script type="javascript" ev:event="onclick">
- <![CDATA[
- model.removeNodeset("/root/hidden/voluntrspec");
-
- var idxRow = grd_studvoluntrlist.rows;
- var idxRows = grd_studvoluntrlist.fixedRows;
- var chkCount=0;
-
- for(i=1;i<=idxRow-idxRows;i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
- {
-
- var chkFlag=model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/chk");
-
- if(chkFlag=='1')
- {
- var NodeCnt=eval(getNodesetCount("/root/hidden/voluntrspec/voluntrspecinfo"))+1;
- // 비어있는 hidden노드에 1을 더해 count개수 1를 만든다.
-
-
- model.makeNode("/root/hidden/voluntrspec/voluntrspecinfo["+NodeCnt+"]");
- //hidden노드에 첫번째 행을 만든뒤, 체크된 자원봉사자 정보 hidden에 넘겨준다.
-
- model.makeValue("/root/hidden/voluntrspec/voluntrspecinfo["+NodeCnt+"]/chk",model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/chk"));
- model.makeValue("/root/hidden/voluntrspec/voluntrspecinfo["+NodeCnt+"]/pid",model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/voluntrid"));
- model.makeValue("/root/hidden/voluntrspec/voluntrspecinfo["+NodeCnt+"]/recvrnm",model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/voluntrnm"));
- model.makeValue("/root/hidden/voluntrspec/voluntrspecinfo["+NodeCnt+"]/recvrtelno",model.getValue("/root/main/studvoluntr/studvoluntrlist["+i+"]/mpphontel"));
- // 체크가 된 봉사자 갯수만큼 해당 값 복사해서 넘긴다.
- chkCount=chkCount+1;
- }
- }
- if(chkCount=='0')
- {
- messageBox("SMS를 전송할 자원봉사자를 선택하십시오.","I");
- return;
- }
- modal("SPAAA03400", "1","150", "150", "SPAAA03400", "/root/hidden/voluntrspec", " /root/main/recvrlist");
- // /root/hidden/voluntrspec 경로에 담긴 정보 팝업창의 /root/main/sendmsg 노드로 보냄
- // model.removeNodeset("/root/hidden/voluntrspec");
-
- // model.makeNode("/root/hidden/voluntrspec");
- model.refresh();
-
-
- ]]>
- </script>
- </button>
- </group>
- <caption id="caption1" class="tit_2" style="left:5px; top:71px; width:209px; height:14px; ">학생자원봉사자명단</caption>
- <line id="line1" class="line_1" style="x1:0px; y1:86px; x2:1194px; y2:86px; "/>
- </xhtml:body>
- </xhtml:html>
|