SMRNB01100_칠곡직원식수현황.xfdl 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRNB01100" inheritanceid="" position="absolute 0 0 1024 768" titletext="칠곡직원식수현황" onload="SMRNB00800_onload" ontimer="SMRNB00800_ontimer">
  5. <Layouts>
  6. <Layout>
  7. <Static id="cap_title" text="칠곡직원식수현황" class="tit_1" position="absolute 0 0 140 25"/>
  8. <Static id="cap_time" position="absolute 758 1 1023 24" style="background:darkseagreen;padding:0 0 0 4;align:center middle;font:Dotum,10,bold;" anchor="top right"/>
  9. <Button id="btn_print" taborder="27" text="출력" class="btn6" position="absolute 908 26 964 48" anchor="top right" onclick="btn_print_onclick" visible="true"/>
  10. <Button id="btn_close" taborder="30" text="종료" class="btn4" position="absolute 967 26 1023 48" anchor="top right" onclick="btn_close_onclick"/>
  11. <Static id="cap_messege_title" position="absolute 116 741 233 764" anchor="left bottom" style="background:lightblue;padding:0 0 0 4;"/>
  12. <Static id="cap_messege" position="absolute 235 741 908 764" anchor="left bottom" style="background:lightblue;padding:0 0 0 4;font:Dotum,9,bold;"/>
  13. <Shape id="line7" class="line_6" position="absolute 0 47 1023 53" anchor="left top right"/>
  14. <Static id="caption1" text="칠곡직원식수현황" class="tit_2" position="absolute 0 119 165 135"/>
  15. <Shape id="line1" class="line_10" position="absolute 0 135 1023 141" anchor="left top right"/>
  16. <Div id="grp_search" taborder="34" class="div_SA2" position="absolute 0 51 1023 111" anchor="left top right">
  17. <Layouts>
  18. <Layout>
  19. <Static id="cap_searchdd" text="조회기간" class="search_name" position="absolute 10 12 84 29" anchor="default"/>
  20. <Button id="btn_search" taborder="4" text="조회" onclick="grp_search_btn_search_onclick" class="btn1" position="absolute 953 18 1009 40" style="align:center;" anchor="top right"/>
  21. <Shape id="line7" linetype="vertical" class="line_4" position="absolute 938 12 941 47" anchor="top right"/>
  22. <Calendar id="ipt_fromdd" taborder="5" autoselect="true" class="input_essential" position="absolute 87 9 205 30" anchor="default" value="null" dateformat="yyyy-MM-dd ddd"/>
  23. <Static id="cap_01" text="~" position="absolute 209 12 221 28" anchor="default"/>
  24. <Calendar id="ipt_todd" taborder="6" autoselect="true" class="input_essential" position="absolute 223 9 341 30" anchor="default" dateformat="yyyy-MM-dd ddd"/>
  25. <Radio id="rdo_gubun" taborder="7" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 486 10 818 30" style="textpadding:0 10 0 3;" columncount="-1" rowcount="-1" index="-1">
  26. <Dataset id="innerdataset">
  27. <ColumnInfo>
  28. <Column id="codecolumn" size="256"/>
  29. <Column id="datacolumn" size="256"/>
  30. </ColumnInfo>
  31. <Rows>
  32. <Row>
  33. <Col id="codecolumn">0</Col>
  34. <Col id="datacolumn">직원</Col>
  35. </Row>
  36. <Row>
  37. <Col id="codecolumn">1</Col>
  38. <Col id="datacolumn">지역암센터</Col>
  39. </Row>
  40. <Row>
  41. <Col id="codecolumn">2</Col>
  42. <Col id="datacolumn">근로학생</Col>
  43. </Row>
  44. <Row>
  45. <Col id="codecolumn">3</Col>
  46. <Col id="datacolumn">연구원</Col>
  47. </Row>
  48. </Rows>
  49. </Dataset>
  50. </Radio>
  51. <Static id="cap_gubun" text="직원업체구분" class="search_name" position="absolute 386 12 484 29"/>
  52. <Static id="cap_place" text="장소" class="search_name" position="absolute 10 36 84 53"/>
  53. <Radio id="rdo_place" taborder="8" columncount="-1" codecolumn="cdid" datacolumn="cdnm" position="absolute 87 34 467 54" style="textpadding:0 10 0 3;" index="-1" innerdataset="@ds_init_placelist" rowcount="-1"/>
  54. </Layout>
  55. </Layouts>
  56. </Div>
  57. <Grid id="grd_sicksulist" taborder="35" useinputpanel="false" position="absolute 0 140 1023 736" autofittype="col" binddataset="ds_main_sicksulist">
  58. <Formats>
  59. <Format id="default">
  60. <Columns>
  61. <Column size="25" band="left"/>
  62. <Column size="120"/>
  63. <Column size="120"/>
  64. <Column size="140"/>
  65. <Column size="120"/>
  66. <Column size="120"/>
  67. <Column size="120"/>
  68. <Column size="80"/>
  69. </Columns>
  70. <Rows>
  71. <Row size="24" band="head"/>
  72. <Row size="24"/>
  73. </Rows>
  74. <Band id="head">
  75. <Cell/>
  76. <Cell col="1" text="ID"/>
  77. <Cell col="2" text="성명"/>
  78. <Cell col="3" text="날짜"/>
  79. <Cell col="4" text="식사구분"/>
  80. <Cell col="5" text="OCS_ID"/>
  81. <Cell col="6" text="구분"/>
  82. <Cell col="7" text="Take Out"/>
  83. </Band>
  84. <Band id="body">
  85. <Cell celltype="head" text="expr:currow+1"/>
  86. <Cell col="1" text="bind:id"/>
  87. <Cell col="2" text="bind:name"/>
  88. <Cell col="3" displaytype="date" text="bind:dietdate"/>
  89. <Cell col="4" text="bind:flag"/>
  90. <Cell col="5" displaytype="text" style="align:center middle;" text="bind:ocs_id"/>
  91. <Cell col="6" text="bind:gubun"/>
  92. <Cell col="7" text="bind:takeout"/>
  93. </Band>
  94. </Format>
  95. </Formats>
  96. </Grid>
  97. <Button id="btn_excel" taborder="36" text="Excel" class="btn7" position="absolute 841 26 905 48" anchor="top right" onclick="btn_excel_onclick"/>
  98. </Layout>
  99. </Layouts>
  100. <Bind>
  101. <BindItem id="item0" compid="grp_search.rdo_gubun" propid="value" datasetid="ds_send" columnid="gubun"/>
  102. <BindItem id="item19" compid="cap_messege" propid="text" datasetid="ds_messege" columnid="cmt"/>
  103. <BindItem id="item15" compid="grp_search.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
  104. <BindItem id="item20" compid="grp_search.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
  105. <BindItem id="item1" compid="grp_search.rdo_place" propid="value" datasetid="ds_send" columnid="ocs_id"/>
  106. </Bind>
  107. <Objects>
  108. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  109. <ColumnInfo>
  110. <Column id="instcd" type="STRING" size="256"/>
  111. <Column id="fromdd" type="STRING" size="256"/>
  112. <Column id="todd" type="STRING" size="256"/>
  113. <Column id="gubun" type="STRING" size="256"/>
  114. <Column id="ocs_id" type="STRING" size="256"/>
  115. </ColumnInfo>
  116. <Rows>
  117. <Row>
  118. <Col id="instcd"/>
  119. <Col id="fromdd"/>
  120. <Col id="todd"/>
  121. <Col id="gubun"/>
  122. <Col id="ocs_id"/>
  123. </Row>
  124. </Rows>
  125. </Dataset>
  126. <Dataset id="ds_main_sicksulist" firefirstcount="0" firenextcount="0" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  127. <Dataset id="ds_init_placelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  128. </Objects>
  129. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  130. * System Name :
  131. * Job Name :
  132. * Creator :
  133. * Make Date : 2017-12-04
  134. * Description :
  135. *---------------------------------------------------------------------------------------
  136. * Modify Date Modifier Modify Description
  137. *---------------------------------------------------------------------------------------
  138. * 2017-06-19 Live Converter TF->XP
  139. *
  140. *---------------------------------------------------------------------------------------
  141. ****************************************************************************************/
  142. //=======================================================================================
  143. // Lib Include
  144. //---------------------------------------------------------------------------------------
  145. include "com_commonxp::comm_main.xjs";
  146. include "mis_miscommonxp::MIS.xjs";
  147. //=======================================================================================
  148. // Global Form Variable
  149. //---------------------------------------------------------------------------------------
  150. var arErrorCode = new HashArray();
  151. //=======================================================================================
  152. // Function
  153. //---------------------------------------------------------------------------------------
  154. /****************************************************************************************
  155. * Argument : N/A
  156. * Description : 초기화
  157. ****************************************************************************************/
  158. function lf_init() {
  159. var sInstcd = sysf_getUserInfo("dutplceinstcd");
  160. var sScrid = frmf_getMenuParam();
  161. ds_send.setColumn(0, "instcd", sInstcd);
  162. ds_send.setColumn(0, "fromdd", utlf_getCurrentDate());
  163. ds_send.setColumn(0, "todd", utlf_getCurrentDate());
  164. ds_send.setColumn(0, "gubun", "0");
  165. ds_send.setColumn(0, "ocs_id", "50000");
  166. cap_messege_title.style.background = "lightblue";
  167. cap_messege.text = "";
  168. }
  169. /****************************************************************************************
  170. * Argument : N/A
  171. * Description : 시간설정
  172. ****************************************************************************************/
  173. function lf_setTime() {
  174. var cTime = utlf_getCurrentDateTime();
  175. cap_time.text = cTime.substr(0,4)+"/"+cTime.substr(4,2)+"/"+cTime.substr(6,2)+" "+cTime.substr(9,2)+":"+cTime.substr(11,2)+":"+cTime.substr(13,2);
  176. }
  177. /****************************************************************************************
  178. * Argument : N/A
  179. * Description : 출력후 메시지
  180. ****************************************************************************************/
  181. function lf_complete() {
  182. cap_messege_title.style.background = "lightblue";
  183. cap_messege.text = "출력이 완료되었습니다.";
  184. }
  185. //=======================================================================================
  186. // Event
  187. //---------------------------------------------------------------------------------------
  188. /****************************************************************************************
  189. * Components : Form
  190. * Description : 화면 처음 초기화시 폼초기화
  191. ****************************************************************************************/
  192. function SMRNB00800_onload(obj:Form, e:LoadEventInfo)
  193. {
  194. frmf_initForm(obj);
  195. dsf_createDsRow("ds_req", [
  196. {col:"lrgcd", type:"STRING", size:256, val:"ES"}
  197. ]);
  198. var oParam = {};
  199. oParam.id = "TRRNB00015";
  200. oParam.service = "sicksuapp.SicksuMngt";
  201. oParam.method = "reqGetPlaceList";
  202. oParam.inds = "req=ds_req";
  203. oParam.outds = "ds_init_placelist=placelist";
  204. oParam.async = false;
  205. //oParam.callback = "cf_TRRNB00015";
  206. tranf_submit(oParam);
  207. lf_init();
  208. lf_setTime();
  209. this.setTimer(0, 1000);
  210. }
  211. /****************************************************************************************
  212. * Components : Form
  213. * Description : 화면 타이머 설정 시계표시
  214. ****************************************************************************************/
  215. function SMRNB00800_ontimer(obj:Form, e:TimerEventInfo)
  216. {
  217. if(e.timerid == 0) {
  218. lf_setTime();
  219. }
  220. }
  221. /****************************************************************************************
  222. * Components : Button
  223. * Description : 종료
  224. ****************************************************************************************/
  225. function btn_close_onclick(obj:Button, e:ClickEventInfo)
  226. {
  227. this.close();
  228. }
  229. /****************************************************************************************
  230. * Components : Button
  231. * Description : 조회
  232. ****************************************************************************************/
  233. function grp_search_btn_search_onclick(obj:Button, e:ClickEventInfo)
  234. {
  235. if(ds_send.getColumn(0, "gubun") == "0") {
  236. var oParam = {};
  237. oParam.id = "TRRNB00013";
  238. oParam.service = "sicksuapp.SicksuMngt";
  239. oParam.method = "reqGetSicksuList032";
  240. oParam.inds = "req=ds_send";
  241. oParam.outds = "ds_main_sicksulist=foodprintlist";
  242. oParam.async = false;
  243. oParam.callback = "cf_TRRNB00013";
  244. tranf_submit(oParam);
  245. if(arErrorCode.pop("TRRNB00013") > -1) {
  246. cap_messege_title.style.background = "lightblue";
  247. cap_messege.text = "조회되었습니다.";
  248. } else {
  249. cap_messege_title.style.background = "red";
  250. cap_messege.text = "조회를 실패하였습니다.";
  251. }
  252. } else {
  253. var oParam = {};
  254. oParam.id = "TRRNB00012";
  255. oParam.service = "sicksuapp.SicksuMngt";
  256. oParam.method = "reqGetIrregularList";
  257. oParam.inds = "req=ds_send";
  258. oParam.outds = "ds_main_sicksulist=foodprintlist";
  259. oParam.async = false;
  260. oParam.callback = "cf_TRRNB00012";
  261. tranf_submit(oParam);
  262. if(arErrorCode.pop("TRRNB00012") > -1) {
  263. cap_messege_title.style.background = "lightblue";
  264. cap_messege.text = "조회되었습니다.";
  265. } else {
  266. cap_messege_title.style.background = "red";
  267. cap_messege.text = "조회를 실패하였습니다.";
  268. }
  269. }
  270. }
  271. function cf_TRRNB00012(sSvcId, nErrorCode, sErrorMsg) {
  272. arErrorCode.push(sSvcId, nErrorCode);
  273. }
  274. function cf_TRRNB00013(sSvcId, nErrorCode, sErrorMsg) {
  275. arErrorCode.push(sSvcId, nErrorCode);
  276. }
  277. /****************************************************************************************
  278. * Components : Button
  279. * Description : 출력
  280. ****************************************************************************************/
  281. function btn_print_onclick(obj:Button, e:ClickEventInfo)
  282. {
  283. var objDOM = rptf_createDOM(); // DOM 객체 설정
  284. rptf_setNodeListToDOM(objDOM, "/root/main/sicksulist" , ds_main_sicksulist);
  285. var objParam = new Object();
  286. objParam.xml_data_XML1 = objDOM.documentElement.source;
  287. objParam.fromdd = ds_send.getColumn(0,"fromdd");
  288. objParam.todd = ds_send.getColumn(0,"todd");
  289. var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=1;callback=lf_complete";
  290. rptf_exeReportPreview30(["RPRNB01100"],[objParam], option);
  291. }
  292. /****************************************************************************************
  293. * Components : Button
  294. * Description : 엑셀저장
  295. ****************************************************************************************/
  296. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  297. {
  298. if( ds_main_sicksulist.rowcount > 0 ){
  299. grdf_exportExcel(grd_sicksulist, "비정규직업체별현황", "SheetName", false, "", "user", false);
  300. } else {
  301. sysf_messageBox("조회된 데이터가 ", "I004");
  302. }
  303. }
  304. ]]></Script>
  305. </Form>
  306. </FDL>