SMAAA01900_자원봉사자현황조회.xfdl 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAAA01900" position="absolute 0 0 1200 790" titletext="자원봉사자현황조회" oninit="SMAAA01900_oninit" onload="SMAAA01900_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 0 0 1195 25" id="group1">
  8. <Layouts>
  9. <Layout>
  10. <Static text="자원봉사자현황조회" position="absolute 0 0 159 25" id="caption6" class="tit_1"/>
  11. </Layout>
  12. </Layouts>
  13. </Div>
  14. <Div position="absolute 0 13 1195 757" id="group3" scrollbars="autoboth">
  15. <Layouts>
  16. <Layout>
  17. <Div position="absolute 575 85 865 115" id="group2" visible="false">
  18. <Layouts>
  19. <Layout>
  20. <Static text="축 일 :" position="absolute 0 0 130 17" id="caption7" class="search_name"/>
  21. <Calendar position="absolute 135 0 200 19" id="ipt_festivfromdd" class="input_search" taborder="8" mask="mm-dd" autoskip="true" autoselect="true" onchanged="group3_group2_ipt_festivfromdd_onchanged"/>
  22. <Static text="~" position="absolute 200 0 212 17" id="caption8" class="search_no_b"/>
  23. <Calendar position="absolute 215 0 280 19" id="ipt_festivtodd" class="input_search" taborder="8" mask="mm-dd"/>
  24. </Layout>
  25. </Layouts>
  26. </Div>
  27. <Div position="absolute 0 10 1194 81" align="align:center top;" id="grp_sea">
  28. <Layouts>
  29. <Layout>
  30. <Shape position="absolute 0 2 1194 71" id="roundrect1" class="roundrect_search" type="roundrectangle"/>
  31. <Button position="absolute 1123 21 1179 43" id="button1" class="btn1" text="조회" onclick="group3_grp_sea_button1_onclick"/>
  32. <Shape position="absolute 1106 5 1112 63" linetype="vertical" id="line13" class="line_4"/>
  33. <Static text="활동상태:" position="absolute 9 12 108 29" id="caption3" class="search_name"/>
  34. <Static text="~" position="absolute 240 39 252 56" id="caption5" class="search_no_b"/>
  35. <Calendar position="absolute 251 41 338 60" id="ipt_todd" class="input_search" taborder="6" onkeydown="group3_grp_sea_ipt_todd_onkeydown" autoselect="true" autoskip="true"/>
  36. <Calendar position="absolute 151 41 238 60" id="ipt_fromdd" class="input_search" taborder="5" onkeydown="group3_grp_sea_ipt_fromdd_onkeydown" autoselect="true" autoskip="true"/>
  37. <Static text="조회구분:" position="absolute 413 40 499 57" id="caption12" class="search_name"/>
  38. <Static text="소속센터:" position="absolute 414 12 504 29" id="caption14" class="search_name"/>
  39. <Combo position="absolute 816 12 925 31" id="cmb_voluntractteamcd" class="combo_search" taborder="4" innerdataset="@ds_hidden_init_comcd_A0360" datacolumn="cdnm" codecolumn="cdid" onitemchanged="group3_grp_sea_cmb_voluntractteamcd_onitemchanged"/>
  40. <Combo position="absolute 746 12 811 31" id="cmb_voluntractdwcd" class="combo_search" taborder="3" innerdataset="@ds_hidden_init_comcd_A0359" datacolumn="cdnm" codecolumn="cdid"/>
  41. <Combo position="absolute 499 12 594 31" id="cmb_actdeptcd" class="combo_search" taborder="2" innerdataset="@ds_hidden_init_comcd_A0503" datacolumn="cdnm" codecolumn="cdid"/>
  42. <Static text="활동요일/시간대:" position="absolute 617 12 749 29" id="caption2" class="search_name"/>
  43. <Combo position="absolute 499 41 594 60" id="cmb_joinflag" class="combo_search" enable="true" taborder="7" innerdataset="@ds_hidden_init_comcd_A0361" datacolumn="cdnm" codecolumn="cdid"/>
  44. <Static text="자원봉사자 등록일:" position="absolute 10 40 166 57" id="caption4" class="search_name"/>
  45. <Combo position="absolute 95 12 180 31" id="cmb_actstatflag" class="combo_search" enable="true" taborder="1" innerdataset="@ds_hidden_init_comcd_A0524" datacolumn="cdnm" codecolumn="cdid" onitemchanged="group3_grp_sea_cmb_actstatflag_onitemchanged"/>
  46. <Static text="SMS수신여부 :" position="absolute 885 40 1001 57" id="caption9" class="search_name"/>
  47. <Combo position="absolute 998 39 1073 58" id="cmb_smsrecvyn" class="combo_search" taborder="3" codecolumn="codecolumn" datacolumn="datacolumn">
  48. <Dataset id="innerdataset">
  49. <ColumnInfo>
  50. <Column id="codecolumn"/>
  51. <Column id="datacolumn"/>
  52. </ColumnInfo>
  53. <Rows>
  54. <Row>
  55. <Col id="codecolumn">%</Col>
  56. <Col id="datacolumn">- 전 체 -</Col>
  57. </Row>
  58. <Row>
  59. <Col id="codecolumn">Y</Col>
  60. <Col id="datacolumn">Y</Col>
  61. </Row>
  62. <Row>
  63. <Col id="codecolumn">N</Col>
  64. <Col id="datacolumn">N</Col>
  65. </Row>
  66. </Rows>
  67. </Dataset>
  68. </Combo>
  69. <Combo position="absolute 723 41 798 60" id="cmb_servkind" class="combo_search" taborder="3" visible="true" innerdataset="@ds_hidden_init_comcd1" codecolumn="cdid" datacolumn="cdnm"/>
  70. <Static text="봉 사 구 분:" position="absolute 617 40 728 57" id="caption10" class="search_name" visible="true"/>
  71. <Static text="소속분야:" position="absolute 205 12 303 29" id="caption11" class="search_name"/>
  72. <Combo position="absolute 290 12 390 31" id="cmb_actdivscd" class="combo_search" innerdataset="@ds_hidden_init_comcd_A0654" codecolumn="cdid" datacolumn="cdnm"/>
  73. </Layout>
  74. </Layouts>
  75. </Div>
  76. <Grid position="absolute 0 112 1194 736" id="grd_voluntrspecinfo" class="datagrid2" binddataset="ds_main_voluntrspec_voluntrspecinfo" oncelldblclick="group3_grd_voluntrspecinfo_oncelldblclick" cellsizingtype="both" extendsizetype="row" cellsizebandtype="allband">
  77. <Formats>
  78. <Format id="default">
  79. <Columns>
  80. <Column size="25" band="left"/>
  81. <Column size="32" band="left"/>
  82. <Column size="100" band="left"/>
  83. <Column size="120" band="left"/>
  84. <Column size="80" band="left"/>
  85. <Column size="57" band="left"/>
  86. <Column size="110" band="left"/>
  87. <Column size="89" band="left"/>
  88. <Column size="0"/>
  89. <Column size="0"/>
  90. <Column size="75"/>
  91. <Column size="72"/>
  92. <Column size="70"/>
  93. <Column size="56"/>
  94. <Column size="174"/>
  95. <Column size="100"/>
  96. <Column size="48"/>
  97. <Column size="364"/>
  98. <Column size="109"/>
  99. <Column size="0"/>
  100. </Columns>
  101. <Rows>
  102. <Row size="30" band="head"/>
  103. <Row size="24"/>
  104. </Rows>
  105. <Band id="head">
  106. <Cell/>
  107. <Cell col="1" displaytype="checkbox" edittype="checkbox"/>
  108. <Cell col="2" text="소속분야"/>
  109. <Cell col="3" colspan="2" text="소속센터"/>
  110. <Cell col="5" text="활동요일"/>
  111. <Cell col="6" text="활동시간대"/>
  112. <Cell col="7" text="성명"/>
  113. <Cell col="8" text="세례명"/>
  114. <Cell col="9" text="축일"/>
  115. <Cell col="10" text="지원봉사자&#10;등록일"/>
  116. <Cell col="11" text="활동&#10;정지일"/>
  117. <Cell col="12" text="재등록여부"/>
  118. <Cell col="13" text="현재상태"/>
  119. <Cell col="14" text="E-mail"/>
  120. <Cell col="15" text="휴대전화"/>
  121. <Cell col="16" text="SMS&#10;수신"/>
  122. <Cell col="17" text="주소"/>
  123. <Cell col="18" text="주민등록번호"/>
  124. <Cell col="19" text="voluntrid"/>
  125. </Band>
  126. <Band id="body">
  127. <Cell celltype="head" text="expr:currow + 1"/>
  128. <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:chk" expr="expr:(chk == &quot;true&quot; || chk == 1) ? 1 : 0"/>
  129. <Cell col="2" displaytype="combo" edittype="none" style="align:center middle;" text="bind:actdivscd" combodataset="ds_hidden_init_comcd_A0654" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  130. <Cell col="3" displaytype="combo" edittype="none" style="padding:0 0 0 2;" text="bind:actdeptcd" combodataset="ds_hidden_init_comcd1_A0503" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  131. <Cell col="4" text="bind:actdeptdetlnm" enable="false"/>
  132. <Cell col="5" displaytype="combo" edittype="none" style="padding:0 0 0 2;" text="bind:voluntractdwcd" combodataset="ds_hidden_init_comcd1_A0359" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  133. <Cell col="6" displaytype="combo" edittype="none" style="padding:0 0 0 2;" text="bind:voluntractteamcd" combodataset="ds_hidden_init_comcd1_A0360" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  134. <Cell col="7" style="align:left middle;padding:0 0 0 2;" text="bind:voluntrnm"/>
  135. <Cell col="8" text="bind:baptnm" mask="##-##"/>
  136. <Cell col="9" style="align:center middle;" text="bind:festivdd" mask="##-##"/>
  137. <Cell col="10" style="align:center middle;" text="bind:joinorgdd" mask="####-##-##"/>
  138. <Cell col="11" style="align:center middle;" text="bind:quitorgdd" mask="####-##-##"/>
  139. <Cell col="12" displaytype="combo" edittype="none" style="padding:0 0 0 2;" text="bind:joinflag" combodataset="ds_hidden_init_comcd1_A0361" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  140. <Cell col="13" displaytype="combo" edittype="none" style="padding:0 0 0 2;" text="bind:actstatflag" combodataset="ds_hidden_init_comcd1_A0524" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  141. <Cell col="14" text="bind:email"/>
  142. <Cell col="15" style="align:left middle;padding:0 0 0 2;" text="bind:mpphontel"/>
  143. <Cell col="16" style="align:center middle;" text="bind:smsrecvyn"/>
  144. <Cell col="17" style="align:left middle;padding:0 0 0 2;" text="bind:addr"/>
  145. <Cell col="18" style="padding:0 0 0 2;" text="bind:rrgstno"/>
  146. <Cell col="19" text="bind:voluntrid"/>
  147. </Band>
  148. </Format>
  149. </Formats>
  150. </Grid>
  151. <Button position="absolute 1110 84 1186 103" id="button11" class="btn7" text="엑셀저장" onclick="group3_button11_onclick"/>
  152. <Div position="absolute 25 610 195 705" id="group4" visible="false" style="background:#8cf1fbff;">
  153. <Layouts>
  154. <Layout>
  155. <Static text="명단출력 타이틀" position="absolute 10 15 110 29" id="caption13" style="font:Dotum,9,bold;"/>
  156. <Edit position="absolute 5 30 165 49" id="input1"/>
  157. <Button position="absolute 75 55 117 74" id="button5" class="btn5" text="확인" onclick="group3_group4_button5_onclick"/>
  158. <Button position="absolute 120 55 162 74" id="button6" class="btn5" text="닫기" onclick="group3_group4_button6_onclick"/>
  159. </Layout>
  160. </Layouts>
  161. </Div>
  162. </Layout>
  163. </Layouts>
  164. </Div>
  165. <Div position="absolute 0 752 1195 779" id="group5" scrollbars="autoboth">
  166. <Layouts>
  167. <Layout>
  168. <Shape position="absolute 0 0 1194 6" linetype="horizontal" id="line37" class="line_6"/>
  169. <Button position="absolute 0 4 79 26" id="button95" class="btn6" text="명단출력" onclick="group5_button95_onclick"/>
  170. <Button position="absolute 1114 3 1194 25" id="button3" class="btn4" text="초기화" onclick="group5_button3_onclick"/>
  171. <Button position="absolute 85 4 165 26" id="button2" class="btn6" text="사진출력" onclick="group5_button2_onclick"/>
  172. <Button position="absolute 1030 3 1110 25" id="button4" class="btn3" text="SMS전송" onclick="group5_button4_onclick"/>
  173. </Layout>
  174. </Layouts>
  175. </Div>
  176. <Static text="자원봉사자명단" position="absolute 0 104 139 120" id="caption1" class="tit_2"/>
  177. <Shape position="absolute 0 121 1194 127" linetype="horizontal" id="line1" class="line_10"/>
  178. </Layout>
  179. </Layouts>
  180. <Objects>
  181. <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  182. <Dataset id="ds_main_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  183. <ColumnInfo>
  184. <Column id="fromdd" type="STRING" size="256"/>
  185. <Column id="todd" type="STRING" size="256"/>
  186. <Column id="actdeptcd" type="STRING" size="256"/>
  187. <Column id="voluntractdwcd" type="STRING" size="256"/>
  188. <Column id="voluntractteamcd" type="STRING" size="256"/>
  189. <Column id="actstatflag" type="STRING" size="256"/>
  190. <Column id="joinflag" type="STRING" size="256"/>
  191. <Column id="festivfromdd" type="STRING" size="256"/>
  192. <Column id="festivtodd" type="STRING" size="256"/>
  193. <Column id="smsrecvyn" type="STRING" size="256"/>
  194. <Column id="servkind" type="STRING" size="256"/>
  195. <Column id="actdivscd" type="STRING" size="256"/>
  196. </ColumnInfo>
  197. <Rows>
  198. <Row>
  199. <Col id="fromdd"/>
  200. <Col id="todd"/>
  201. <Col id="actdeptcd"/>
  202. <Col id="voluntractdwcd">1</Col>
  203. <Col id="voluntractteamcd"/>
  204. <Col id="actstatflag"/>
  205. <Col id="joinflag"/>
  206. <Col id="festivfromdd"/>
  207. <Col id="festivtodd"/>
  208. <Col id="smsrecvyn"/>
  209. <Col id="servkind"/>
  210. <Col id="actdivscd"/>
  211. </Row>
  212. </Rows>
  213. </Dataset>
  214. <Dataset id="ds_main_voluntrspec_voluntrspecinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  215. <ColumnInfo>
  216. <Column id="chk" type="STRING" size="256"/>
  217. <Column id="actdeptcd" type="STRING" size="256"/>
  218. <Column id="actdeptdetlnm" type="STRING" size="256"/>
  219. <Column id="voluntractdwcd" type="STRING" size="256"/>
  220. <Column id="voluntractteamcd" type="STRING" size="256"/>
  221. <Column id="voluntrnm" type="STRING" size="256"/>
  222. <Column id="baptnm" type="STRING" size="256"/>
  223. <Column id="festivdd" type="STRING" size="256"/>
  224. <Column id="joinorgdd" type="STRING" size="256"/>
  225. <Column id="quitorgdd" type="STRING" size="256"/>
  226. <Column id="joinflag" type="STRING" size="256"/>
  227. <Column id="actstatflag" type="STRING" size="256"/>
  228. <Column id="email" type="STRING" size="256"/>
  229. <Column id="mpphontel" type="STRING" size="256"/>
  230. <Column id="addr" type="STRING" size="256"/>
  231. <Column id="rrgstno" type="STRING" size="256"/>
  232. <Column id="voluntrid" type="STRING" size="256"/>
  233. <Column id="photo" type="STRING" size="256"/>
  234. <Column id="smsrecvyn" type="STRING" size="256"/>
  235. </ColumnInfo>
  236. </Dataset>
  237. <Dataset id="ds_main_report" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  238. <Dataset id="ds_main_repopuplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  239. <Dataset id="ds_main_voluntrreport" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  240. <ColumnInfo>
  241. <Column id="flag" type="STRING" size="256"/>
  242. </ColumnInfo>
  243. <Rows>
  244. <Row/>
  245. </Rows>
  246. </Dataset>
  247. <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  248. <ColumnInfo>
  249. <Column id="title" type="STRING" size="256"/>
  250. </ColumnInfo>
  251. <Rows>
  252. <Row/>
  253. </Rows>
  254. </Dataset>
  255. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  256. <ColumnInfo>
  257. <Column id="comcd" type="STRING" size="256"/>
  258. </ColumnInfo>
  259. <Rows>
  260. <Row/>
  261. </Rows>
  262. </Dataset>
  263. <Dataset id="ds_hidden_init_comcd1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  264. <ColumnInfo>
  265. <Column id="cdnm" type="STRING" size="256"/>
  266. <Column id="cdid" type="STRING" size="256"/>
  267. </ColumnInfo>
  268. <Rows>
  269. <Row/>
  270. </Rows>
  271. </Dataset>
  272. <Dataset id="ds_hidden_init_comcd_A0359" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  273. <Dataset id="ds_hidden_init_comcd_A0360" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  274. <Dataset id="ds_hidden_init_comcd_A0503" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  275. <Dataset id="ds_hidden_init_comcd_A0524" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  276. <Dataset id="ds_hidden_init_comcd_A0361" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  277. <Dataset id="ds_hidden_init_comcd_A0654" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  278. <Dataset id="ds_hidden_init_comcd1_A0359" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  279. <Dataset id="ds_hidden_init_comcd1_A0360" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  280. <Dataset id="ds_hidden_init_comcd1_A0503" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  281. <Dataset id="ds_hidden_init_comcd1_A0524" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  282. <Dataset id="ds_hidden_init_comcd1_A0361" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  283. <Dataset id="ds_hidden_voluntrspec_voluntrspecinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  284. </Objects>
  285. <Bind>
  286. <BindItem id="item0" compid="group3.group2.ipt_festivfromdd" propid="value" datasetid="ds_main_search" columnid="festivfromdd"/>
  287. <BindItem id="item1" compid="group3.group2.ipt_festivtodd" propid="value" datasetid="ds_main_search" columnid="festivtodd"/>
  288. <BindItem id="item2" compid="group3.grp_sea.ipt_todd" propid="value" datasetid="ds_main_search" columnid="todd"/>
  289. <BindItem id="item3" compid="group3.grp_sea.ipt_fromdd" propid="value" datasetid="ds_main_search" columnid="fromdd"/>
  290. <BindItem id="item4" compid="group3.grp_sea.cmb_voluntractteamcd" propid="value" datasetid="ds_main_search" columnid="voluntractteamcd"/>
  291. <BindItem id="item5" compid="group3.grp_sea.cmb_voluntractdwcd" propid="value" datasetid="ds_main_search" columnid="voluntractdwcd"/>
  292. <BindItem id="item6" compid="group3.grp_sea.cmb_actdeptcd" propid="value" datasetid="ds_main_search" columnid="actdeptcd"/>
  293. <BindItem id="item7" compid="group3.grp_sea.cmb_joinflag" propid="value" datasetid="ds_main_search" columnid="joinflag"/>
  294. <BindItem id="item8" compid="group3.grp_sea.cmb_actstatflag" propid="value" datasetid="ds_main_search" columnid="actstatflag"/>
  295. <BindItem id="item9" compid="group3.grp_sea.cmb_smsrecvyn" propid="value" datasetid="ds_main_search" columnid="smsrecvyn"/>
  296. <BindItem id="item10" compid="group3.grp_sea.cmb_servkind" propid="value" datasetid="ds_main_search" columnid="servkind"/>
  297. <BindItem id="item11" compid="group3.grp_sea.cmb_actdivscd" propid="value" datasetid="ds_main_search" columnid="actdivscd"/>
  298. <BindItem id="item12" compid="group3.group4.input1" propid="value" datasetid="ds_main_cond" columnid="title"/>
  299. </Bind>
  300. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  301. * System Name :
  302. * Job Name :
  303. * Creator :
  304. * Make Date : 2015-11-13
  305. * Description :
  306. *---------------------------------------------------------------------------------------
  307. * Modify Date Modifier Modify Description
  308. *---------------------------------------------------------------------------------------
  309. * 2015-11-13 Live Converter TF->XP
  310. *
  311. *---------------------------------------------------------------------------------------
  312. ****************************************************************************************/
  313. include "com_commonxp::comm_main.xjs";
  314. function SMAAA01900_oninit(obj:Form, e:InitEventInfo)
  315. {
  316. frmf_initForm(obj);
  317. }
  318. function SMAAA01900_onload(obj:Form, e:LoadEventInfo)
  319. {
  320. grdf_initGrid(group3.grd_voluntrspecinfo);
  321. fInit();
  322. }
  323. // 초기값
  324. function fInit()
  325. {
  326. var SMAAA01900_param=frmf_getMenuParam();
  327. if(SMAAA01900_param=='2'||SMAAA01900_param=='3')
  328. {
  329. group5.button95.visible=false;
  330. group5.button2.visible=false;
  331. }
  332. appf_getCodeList([{dsNm: "ds_hidden_init_comcd_A0359", cdGrpId: "A0359"}, {dsNm: "ds_hidden_init_comcd_A0360", cdGrpId: "A0360"}
  333. , {dsNm: "ds_hidden_init_comcd_A0503", cdGrpId: "A0503"}, {dsNm: "ds_hidden_init_comcd_A0524", cdGrpId: "A0524"}
  334. , {dsNm: "ds_hidden_init_comcd_A0361", cdGrpId: "A0361"}, {dsNm: "ds_hidden_init_comcd_A0654", cdGrpId: "A0654"}], true);
  335. appf_getCodeList([{dsNm: "ds_hidden_init_comcd1_A0359", cdGrpId: "A0359"}, {dsNm: "ds_hidden_init_comcd1_A0360", cdGrpId: "A0360"}
  336. , {dsNm: "ds_hidden_init_comcd1_A0503", cdGrpId: "A0503"}, {dsNm: "ds_hidden_init_comcd1_A0524", cdGrpId: "A0524"}
  337. , {dsNm: "ds_hidden_init_comcd1_A0361", cdGrpId: "A0361"}], true);
  338. appf_getKindCodeList([{bizId:"A0018", cdGrpId:"A0507", dsNm:"ds_hidden_init_comcd1", sortField:"dispseq", sortMehotd:"asc"}]);
  339. frmf_addComboItem("group3.grp_sea.cmb_actdeptcd" ,"- 전 체 -","%","above");
  340. frmf_addComboItem("group3.grp_sea.cmb_voluntractdwcd" ,"- 전 체 -","%","above");
  341. frmf_addComboItem("group3.grp_sea.cmb_voluntractteamcd" ,"- 전 체 -","%","above");
  342. frmf_addComboItem("group3.grp_sea.cmb_actstatflag" ,"- 전 체 -","%","above");
  343. frmf_addComboItem("group3.grp_sea.cmb_joinflag" ,"- 전 체 -","%","above");
  344. frmf_addComboItem("group3.grp_sea.cmb_servkind" ,"- 전 체 -","%","above");
  345. frmf_addComboItem("group3.grp_sea.cmb_actdivscd" ,"- 전 체 -","%","above");
  346. group3.grp_sea.cmb_servkind.index = 0;
  347. group3.grp_sea.cmb_actdeptcd.index = 0;
  348. group3.grp_sea.cmb_voluntractdwcd.index = 0;
  349. group3.grp_sea.cmb_voluntractteamcd.index = 0;
  350. group3.grp_sea.cmb_actstatflag.index = 0;
  351. group3.grp_sea.cmb_joinflag.index = 0;
  352. group3.grp_sea.cmb_smsrecvyn.index = 0;
  353. group3.grp_sea.cmb_actdivscd.index = 0;
  354. var CurrentDate = utlf_getCurrentDate();
  355. var CurrentDatedd=CurrentDate.substr(0,6);
  356. dsf_makeValue(ds_main_search,"fromdd" , "string","00010101");
  357. dsf_makeValue(ds_main_search,"todd" , "string","99991231");
  358. //grd_voluntrspecinfo.fixedcellcheckbox(0,1)=true; //체크박스 위에 전체 선택 하는 콤보 셋팅
  359. }
  360. function group3_group2_ipt_festivfromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
  361. {
  362. var year=eval(utlf_getCurrentDate().substr(0,4)); //현재 년도
  363. var months=group3.group2.ipt_festivfromdd.value.substr(0,2); // 축일 선택한 월
  364. var month=(eval(group3.group2.ipt_festivfromdd.value.substr(0,2))-1);
  365. var EndDate=new Date(year,month); //현재년도와 선택한 월을 new Dat함수에 셋팅
  366. var MonthlastDay=EndDate.getMonthDay(); //현재년도와 선택한 월의 마지막 일자 구함
  367. dsf_makeValue(ds_main_search,"festivtodd", "string",months+MonthlastDay); //축일 종료 기간에 셋팅
  368. }
  369. function group3_grp_sea_button1_onclick(obj:Button, e:ClickEventInfo)
  370. {
  371. fVoluntrCondInfoReq();
  372. }
  373. function fVoluntrCondInfoReq() // 자원봉사자 명단 조회 함수
  374. {
  375. ds_send_reqdata.clearData();
  376. var fromdd =ds_main_search.getColumn(0, "festivfromdd");
  377. var todd =ds_main_search.getColumn(0, "festivtodd");
  378. var smsrecvyn =ds_main_search.getColumn(0, "smsrecvyn");
  379. if( utlf_isNull(fromdd) && utlf_isNull(todd) )
  380. {
  381. dsf_makeValue(ds_send_reqdata,"festivfromdd", "string","");
  382. dsf_makeValue(ds_send_reqdata,"festivtodd", "string","");
  383. }
  384. if(utlf_isNull(fromdd) && !utlf_isNull(todd) )
  385. {
  386. dsf_makeValue(ds_send_reqdata,"festivfromdd", "string","0101");
  387. dsf_makeValue(ds_send_reqdata,"festivtodd", "string",ds_main_search.getColumn(0, "festivtodd"));
  388. }
  389. if(!utlf_isNull(fromdd)&& utlf_isNull(todd) )
  390. {
  391. dsf_makeValue(ds_send_reqdata,"festivfromdd", "string",ds_main_search.getColumn(0, "festivfromdd"));
  392. dsf_makeValue(ds_send_reqdata,"festivtodd", "string","1231");
  393. }
  394. if( !utlf_isNull(fromdd)&& !utlf_isNull(todd) )
  395. {
  396. dsf_makeValue(ds_send_reqdata,"festivfromdd", "string",ds_main_search.getColumn(0, "festivfromdd"));
  397. dsf_makeValue(ds_send_reqdata,"festivtodd", "string",ds_main_search.getColumn(0, "festivtodd"));
  398. }
  399. dsf_makeValue(ds_send_reqdata,"servkind" , "string",ds_main_search.getColumn(0, "servkind"));
  400. dsf_makeValue(ds_send_reqdata,"smsrecvyn" , "string",ds_main_search.getColumn(0, "smsrecvyn"));
  401. dsf_makeValue(ds_send_reqdata,"fromdd" , "string",ds_main_search.getColumn(0, "fromdd"));
  402. dsf_makeValue(ds_send_reqdata,"todd" , "string",ds_main_search.getColumn(0, "todd"));
  403. dsf_makeValue(ds_send_reqdata,"actdeptcd" , "string",ds_main_search.getColumn(0, "actdeptcd"));
  404. dsf_makeValue(ds_send_reqdata,"voluntractdwcd" , "string",ds_main_search.getColumn(0, "voluntractdwcd"));
  405. dsf_makeValue(ds_send_reqdata,"voluntractteamcd", "string",ds_main_search.getColumn(0, "voluntractteamcd"));
  406. dsf_makeValue(ds_send_reqdata,"actstatflag" , "string",ds_main_search.getColumn(0, "actstatflag"));
  407. dsf_makeValue(ds_send_reqdata,"joinflag" , "string",ds_main_search.getColumn(0, "joinflag"));
  408. //grd_voluntrspecinfo.fixedcellischeck(0,1)=false;
  409. group3.grd_voluntrspecinfo.setCellProperty("head", 1, "text", "expr:0");
  410. //체크박스 전체 선택 해지
  411. var oParam = {};
  412. oParam.id = "TRAAA01901";
  413. oParam.service = "voluntractapp.VoluntrBasicMngt";
  414. oParam.method = "ReqGetVoluntrPresCondSpec";
  415. oParam.inds = "req=ds_send_reqdata";
  416. oParam.outds = "ds_main_voluntrspec_voluntrspecinfo=voluntrspecinfo";
  417. oParam.async = false;
  418. tranf_submit(oParam);
  419. ds_main_voluntrspec_voluntrspecinfo.addColumn("chk", "string");
  420. }
  421. function group3_grp_sea_ipt_todd_onkeydown(obj:Calendar, e:KeyEventInfo)
  422. {
  423. if( e.keycode == 13 ){
  424. fVoluntrCondInfoReq();
  425. }
  426. }
  427. function group3_grp_sea_ipt_fromdd_onkeydown(obj:Calendar, e:KeyEventInfo)
  428. {
  429. if( e.keycode == 13 ){
  430. fVoluntrCondInfoReq();
  431. }
  432. }
  433. function group3_grp_sea_cmb_voluntractteamcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  434. {
  435. fVoluntrCondInfoReq();
  436. }
  437. function group3_grp_sea_cmb_actstatflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  438. {
  439. if(ds_main_search.getColumn(0, "actstatflag")=="2") //탈단중이면
  440. {
  441. ds_main_search.setColumn(0, "fromdd", "");
  442. ds_main_search.setColumn(0, "todd", "");
  443. var CurrentDate = utlf_getCurrentDate();
  444. var CurrentDatedd=CurrentDate.substr(0,6);
  445. ds_main_search.setColumn(0, "fromdd" ,CurrentDatedd+"01");;
  446. ds_main_search.setColumn(0, "todd" ,CurrentDate);
  447. }
  448. else //활동중이거나 전체 일때
  449. {
  450. ds_main_search.setColumn(0, "fromdd", "");
  451. ds_main_search.setColumn(0, "todd", "");
  452. ds_main_search.setColumn(0, "fromdd" ,"00000000");
  453. ds_main_search.setColumn(0, "todd" ,"99991231");
  454. }
  455. }
  456. function group3_grd_voluntrspecinfo_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  457. {
  458. if(e.row > -1 && e.col > -1 )
  459. {
  460. var idxRow=ds_main_voluntrspec_voluntrspecinfo.rowposition; //선택한 로우 행 반환
  461. var voluntrid=ds_main_voluntrspec_voluntrspecinfo.getColumn(idxRow, "voluntrid"); // 해당 로우의 자원봉사 아이디 저장
  462. dsf_makeValue(ds_main_repopuplist,"voluntrid" , "string" , voluntrid);
  463. dsf_makeValue(ds_main_repopuplist,"reqpopupflag" , "string" ,"A"); //자원봉사자 현황 조회에서 호출했다는 팝업 플래그 의미인 A 저장
  464. //
  465. var objArg = new Object();
  466. objArg.arg_ds_main_repopuplist = ds_main_repopuplist;
  467. frmf_modal("SMAAA00100","SMAAA00100", objArg, "", 1, 150, 150, "", "", "", "", "", "M"); // prizsource 경로에 담긴 정보 팝업창의 root/main/prizsource 노드로 보냄
  468. fVoluntrCondInfoReq();
  469. }
  470. else
  471. {
  472. return;
  473. }
  474. }
  475. function group3_button11_onclick(obj:Button, e:ClickEventInfo)
  476. {
  477. fSaveExcel();
  478. }
  479. function fSaveExcel()
  480. {
  481. grdf_exportExcel(group3.grd_voluntrspecinfo, "excel", "sheetname1" , true, "" , "" , true);
  482. }
  483. function group3_group4_button5_onclick(obj:Button, e:ClickEventInfo)
  484. {
  485. var idxRow = ds_main_voluntrspec_voluntrspecinfo.rowcount;
  486. //var idxRows = grd_voluntrspecinfo.fixedRows;
  487. var chkCount = 0;
  488. for(i = 0; i < idxRow; i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
  489. {
  490. var chkFlag = ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "chk");
  491. if(chkFlag=='1')
  492. {
  493. var NodeCnt=eval(ds_hidden_voluntrspec_voluntrspecinfo.rowcount); //선택된 자원봉사자 갯수를 셈
  494. if(NodeCnt==0){
  495. dsf_copyColInfo(ds_hidden_voluntrspec_voluntrspecinfo, ds_main_voluntrspec_voluntrspecinfo);
  496. }
  497. ds_hidden_voluntrspec_voluntrspecinfo.addRow();
  498. ds_hidden_voluntrspec_voluntrspecinfo.copyRow(NodeCnt,ds_main_voluntrspec_voluntrspecinfo,i);
  499. // 체크가 된 봉사자 갯수만큼 해당 값 복사해서 넘긴다.
  500. chkCount=chkCount+1;
  501. // 체크된 봉사자 갯수를 세서 없을 때는 메시지 처리 한다.
  502. }
  503. }
  504. if(chkCount=='0')
  505. {
  506. sysf_messageBox("명찰 출력할 자원봉사자를 선택하십시오.","I");
  507. return;
  508. }
  509. //명찰리스트 출력시
  510. //미리보기출력
  511. var objDOM = rptf_createDOM();
  512. rptf_setNodeListToDOM(objDOM, "root/hidden/voluntrspec/voluntrspecinfo", ds_hidden_voluntrspec_voluntrspecinfo); // 데이터셋 1
  513. rptf_setNodeListToDOM(objDOM, "root/main/cond", ds_main_cond); // 데이터셋 2
  514. var objParam = new Object();
  515. objParam.xml_data_XML1 = objDOM.documentElement.source; // 최상의노드 XML 스트링 추출
  516. var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
  517. rptf_exeReportPreview30(["RPAAA01903"],[objParam], option);
  518. ds_hidden_voluntrspec_voluntrspecinfo.clearData();
  519. group3.group4.visible = false;
  520. }
  521. function group3_group4_button6_onclick(obj:Button, e:ClickEventInfo)
  522. {
  523. group3.group4.visible = false;
  524. }
  525. function group5_button95_onclick(obj:Button, e:ClickEventInfo)
  526. {
  527. group3.group4.visible = true;
  528. }
  529. function group5_button3_onclick(obj:Button, e:ClickEventInfo)
  530. {
  531. fVoluntrcondClear();
  532. }
  533. // 초기화 함수
  534. function fVoluntrcondClear()
  535. {
  536. var btn=sysf_messageBox("초기화를","Q004");
  537. if(btn=='6')
  538. {
  539. ds_main_voluntrspec_voluntrspecinfo.clearData();
  540. //grd_voluntrspecinfo.fixedcellischeck(0,1)=false; //전체 선택된 체크박스 해제
  541. }
  542. else
  543. {
  544. return;
  545. }
  546. }
  547. function group5_button2_onclick(obj:Button, e:ClickEventInfo)
  548. {
  549. var idxRow = ds_main_voluntrspec_voluntrspecinfo.rowcount;
  550. //var idxRows = grd_voluntrspecinfo.fixedRows;
  551. var chkCount = 0;
  552. for(i = 0; i < idxRow; i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
  553. {
  554. var chkFlag = ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "chk");
  555. if(chkFlag=='1')
  556. {
  557. var NodeCnt=eval(ds_hidden_voluntrspec_voluntrspecinfo.rowcount);
  558. // 비어있는 hidden노드에 1을 더해 count개수 1를 만든다.
  559. if(NodeCnt==0){
  560. dsf_copyColInfo(ds_hidden_voluntrspec_voluntrspecinfo, ds_main_voluntrspec_voluntrspecinfo);
  561. }
  562. ds_hidden_voluntrspec_voluntrspecinfo.addRow();
  563. ds_hidden_voluntrspec_voluntrspecinfo.copyRow(NodeCnt,ds_main_voluntrspec_voluntrspecinfo,i);
  564. chkCount=chkCount+1;
  565. }
  566. }
  567. if(chkCount=='0')
  568. {
  569. sysf_messageBox("사진 출력할 자원봉사자를 선택하십시오.","I");
  570. return;
  571. }
  572. //미리보기출력
  573. var objDOM = rptf_createDOM();
  574. rptf_setNodeListToDOM(objDOM, "root/properties/report/mainreport/params/voluntrspecinfo", ds_hidden_voluntrspec_voluntrspecinfo); // 데이터셋 1
  575. var objParam = new Object();
  576. objParam.xml_data_XML1 = objDOM.documentElement.source; // 최상의노드 XML 스트링 추출
  577. var option = "open=1;save=1;directprint=0;print=1;zoom=0;";
  578. rptf_exeReportPreview30(["RPAAA01902"],[objParam], option);
  579. ds_hidden_voluntrspec_voluntrspecinfo.clearData();
  580. }
  581. function group5_button4_onclick(obj:Button, e:ClickEventInfo)
  582. {
  583. ds_hidden_voluntrspec_voluntrspecinfo.clearData();
  584. var idxRow = ds_main_voluntrspec_voluntrspecinfo.rowcount;
  585. //var idxRows = grd_voluntrspecinfo.fixedRows;
  586. var chkCount=0;
  587. for(i = 0; i < idxRow; i++) // 그리드에 체크된 개수만큼 for문 돌려서 값을 체크한다.
  588. {
  589. var chkFlag =ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "chk");
  590. var smsrecvyn =ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "smsrecvyn");
  591. if(chkFlag=='1')
  592. {
  593. if(smsrecvyn=='Y') //수신여부가 Y인것만 sms 전송
  594. {
  595. var NodeCnt=eval(ds_hidden_voluntrspec_voluntrspecinfo.rowcount);
  596. // 비어있는 hidden노드에 1을 더해 count개수 1를 만든다.
  597. ds_hidden_voluntrspec_voluntrspecinfo.addRow();
  598. //hidden노드에 첫번째 행을 만든뒤, 체크된 자원봉사자 정보 hidden에 넘겨준다.
  599. dsf_makeValue(ds_hidden_voluntrspec_voluntrspecinfo,"chk" , "string",ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "chk"), NodeCnt );
  600. dsf_makeValue(ds_hidden_voluntrspec_voluntrspecinfo,"pid" , "string",ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "voluntrid"), NodeCnt );
  601. dsf_makeValue(ds_hidden_voluntrspec_voluntrspecinfo,"recvrnm" , "string",ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "voluntrnm"), NodeCnt );
  602. dsf_makeValue(ds_hidden_voluntrspec_voluntrspecinfo,"recvrtelno", "string",ds_main_voluntrspec_voluntrspecinfo.getColumn(i, "mpphontel"), NodeCnt );
  603. // 체크가 된 봉사자 갯수만큼 해당 값 복사해서 넘긴다.
  604. chkCount=chkCount+1;
  605. }
  606. }
  607. }
  608. if(chkCount=='0')
  609. {
  610. sysf_messageBox("SMS를 전송할 자원봉사자를 선택하십시오.","I");
  611. return;
  612. }
  613. //modal("SPAAA03400",null,null,null, "SPAAA03400", "/root/hidden/voluntrspec", " /root/main/recvrlist","width:500px;height:200px");
  614. var objArg = new Object();
  615. objArg.arg_ds_hidden_voluntrspec_voluntrspecinfo = ds_hidden_voluntrspec_voluntrspecinfo;
  616. frmf_modal("SPAAA03400","SPAAA03400", objArg, "", 1, 150, 150, "", "", "", "", "", "M");
  617. if(ds_main_voluntrreport.getColumn(0, "flag")=='S') // sms전송이 완료되었다는 의미의 플래그
  618. {
  619. fVoluntrCondInfoReq();
  620. }
  621. ds_main_voluntrreport.updatecontrol = false;
  622. ds_main_voluntrreport.deleteColumn("flag");
  623. ds_main_voluntrreport.updatecontrol = true;
  624. }
  625. ]]></Script>
  626. </Form>
  627. </FDL>