SMCRC00100_연동정보관리.xrw 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <!--
  3. * Name : SMCRC00100_연동정보관리
  4. * Summary : 데이터연동 설정정보
  5. * Programmer : 엄윤호
  6. * Date Written : 2007.08.01
  7. * History : 2007.08.01
  8. * Remark :
  9. -->
  10. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
  11. <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">
  12. <xhtml:head>
  13. <xhtml:title>데이터 연동설정 관리</xhtml:title>
  14. <model id="model1">
  15. <instance id="instance1">
  16. <root xmlns="">
  17. <main>
  18. <list>
  19. <synclist/>
  20. </list>
  21. </main>
  22. <send>
  23. <srch>
  24. <prgmid/>
  25. <tablenm/>
  26. <useyn/>
  27. </srch>
  28. <synclist/>
  29. </send>
  30. <init>
  31. <comncdlist>
  32. <C0022list/>
  33. <C0025list/>
  34. <C0035list/>
  35. </comncdlist>
  36. </init>
  37. <temp>
  38. <result/>
  39. </temp>
  40. </root>
  41. </instance>
  42. <script type="javascript" ev:event="xforms-ready">
  43. <![CDATA[
  44. // C0022: 연동사용여부, C0025: 연동속성구분, C0035: 연동간격
  45. zbcfGetCodeList(new Array("C0022", "C0025", "C0035"),
  46. new Array("/root/init/comncdlist/C0022list", "/root/init/comncdlist/C0025list", "/root/init/comncdlist/C0035list"));
  47. addComboItemAll( "cmb_useyn");
  48. fCheckAuth();
  49. fInitSyncList();
  50. //model.refresh();
  51. submit("TRCRC00101");
  52. fGetSyncdtSet();
  53. ]]>
  54. </script>
  55. <submission id="TRZBC00101" mediatype="application/x-www-form-urlencoded" method="post" replace="instance"/>
  56. <!--submission id="TRZBC00102" mediatype="application/x-www-form-urlencoded" method="post" replace="instance"/-->
  57. <submission id="TRCRC00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/srch" resultref="/root/main/list/synclist"/>
  58. <submission id="TXCRC00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/synclist" resultref="/root/temp/result"/>
  59. </model>
  60. <script type="javascript" src="../../../crm/ruleweb/js/CRZ001.js"/>
  61. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  62. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  63. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  64. <script type="javascript">
  65. <![CDATA[
  66. function fCheckAuth() {
  67. // 권한체크
  68. if (!checkAuth("r")) {
  69. btn_search.disabled=true;
  70. }
  71. if (!checkAuth("x")) {
  72. btn_syncadd.disabled=true;
  73. btn_syncdel.disabled=true;
  74. btn_save.disabled=true;
  75. }
  76. if (!checkAuth("p")) {
  77. btn_saveexcel.disabled = true;
  78. }
  79. }
  80. function fInitSyncList() {
  81. // 그리드 초기화
  82. model.removeNodeset("/root/main/list/synclist");
  83. grd_synclist.clearStatus();
  84. //model.refresh();
  85. }
  86. function fSaveSyncList() {
  87. var grid = grd_synclist;
  88. var updt_list = getGridUpdateData(grid);
  89. if (updt_list != "") {
  90. model.setValue("/root/send/synclist", grid.getUpdateData());
  91. }
  92. setAlertOn();
  93. if (submit("TXCRC00101")) {
  94. grid.clearStatus(); // submit() 성공하면 그리드의 i,u,d 상태 제거
  95. model.setValue("/root/send/synclist","");
  96. submit("TRCRC00101");
  97. fGetSyncdtSet();
  98. }
  99. }
  100. //================================================================//
  101. //예약관련 프로세스만 실행시간을 수정할 수 있도록 한다. //
  102. //==============================================================//
  103. function fGetSyncdtSet(){
  104. if(grd_synclist.rows > 1){
  105. for(i=1;grd_synclist.rows>i;i++){
  106. if(grd_synclist.valueMatrix(i,grd_synclist.colRef("prgmid"))=="SCHEDULE_MNG" || grd_synclist.valueMatrix(i,grd_synclist.colRef("prgmid"))=="SCHEDULE_MNG_MAPPING")
  107. {
  108. grd_synclist.isReadOnly(i,grd_synclist.colRef("fromdt"))= false;
  109. grd_synclist.isReadOnly(i,grd_synclist.colRef("fcsttodt"))= false;
  110. }else{
  111. grd_synclist.isReadOnly(i,grd_synclist.colRef("fromdt"))= true;
  112. grd_synclist.isReadOnly(i,grd_synclist.colRef("fcsttodt"))= true;
  113. }
  114. }
  115. }
  116. model.refresh();
  117. }
  118. ]]>
  119. </script>
  120. </xhtml:head>
  121. <xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  122. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  123. <caption id="caption1" class="tit_1" style="left:0px; top:0px; width:189px; height:14px; ">데이터 연동정보 관리</caption>
  124. </group>
  125. <group id="group2" style="left:0px; top:23px; width:1194px; height:35px; vertical-align:top; ">
  126. <shape id="roundrect1" appearance="roundrect" style="left:0px; top:0px; width:1194px; height:35px; "/>
  127. <caption id="caption3" class="search_name" style="left:16px; top:9px; width:104px; height:17px; ">프로그램 ID :</caption>
  128. <input id="ipt_prgmid" ref="/root/send/srch/prgmid" class="input_search" maxlength="30" style="left:125px; top:8px; width:145px; height:19px; "/>
  129. <button id="btn_prgmsrch" class="icon_search" style="left:275px; top:9px; width:16px; height:16px; ">
  130. <caption/>
  131. <script type="javascript" ev:event="DOMActivate">
  132. <![CDATA[
  133. var srch_condition = "P";
  134. var srch_term = model.getValue("/root/send/srch/prgmid");
  135. var recv_prgmid_path = "/root/send/srch/prgmid";
  136. var recv_tablenm_path = "";
  137. crzfOpenSelectPrgm(srch_condition, srch_term, recv_prgmid_path, recv_tablenm_path);
  138. ]]>
  139. </script>
  140. </button>
  141. <caption id="caption4" class="search_name" style="left:331px; top:9px; width:119px; height:17px; ">연동테이블명 :</caption>
  142. <input id="ipt_tablenm" ref="/root/send/srch/tablenm" class="input_search" maxlength="16" style="left:450px; top:8px; width:145px; height:19px; "/>
  143. <button id="btn_tablesrch" class="icon_search" style="left:600px; top:9px; width:16px; height:16px; ">
  144. <caption/>
  145. <script type="javascript" ev:event="DOMActivate">
  146. <![CDATA[
  147. var srch_condition = "T";
  148. var srch_term = model.getValue("/root/send/srch/tablenm");
  149. var recv_prgmid_path = "";
  150. var recv_tablenm_path = "/root/send/srch/tablenm";
  151. crzfOpenSelectPrgm(srch_condition, srch_term, recv_prgmid_path, recv_tablenm_path);
  152. ]]>
  153. </script>
  154. </button>
  155. <caption id="caption5" class="search_name" style="left:910px; top:10px; width:86px; height:17px; ">사용여부 :</caption>
  156. <select1 id="cmb_useyn" ref="/root/send/srch/useyn" class="combo_search" appearance="minimal" style="left:1005px; top:8px; width:85px; height:19px; ">
  157. <choices>
  158. <itemset nodeset="/root/init/comncdlist/C0022list/C0022">
  159. <label ref="cdnm"/>
  160. <value ref="cdid"/>
  161. </itemset>
  162. </choices>
  163. </select1>
  164. <line id="line1" class="line_4" style="x1:1106px; y1:7px; x2:1106px; y2:29px; "/>
  165. <button id="btn_search" class="btn1_letter2" style="left:1122px; top:7px; width:56px; height:22px; ">
  166. <caption>조회</caption>
  167. <script type="javascript" ev:event="DOMActivate">
  168. <![CDATA[
  169. submit("TRCRC00101");
  170. fGetSyncdtSet();
  171. ]]>
  172. </script>
  173. </button>
  174. </group>
  175. <group id="group3" scroll="auto" style="left:0px; top:58px; width:1195px; height:693px; ">
  176. <caption id="caption2" class="tit_2" style="left:5px; top:10px; width:144px; height:14px; ">데이터 연동정보 설정</caption>
  177. <button id="btn_syncadd" class="btn2_letter4" style="left:996px; top:5px; width:64px; height:19px; ">
  178. <caption>항목추가</caption>
  179. <script type="javascript" ev:event="DOMActivate">
  180. <![CDATA[
  181. model.setFocus("grd_synclist");
  182. grd_synclist.addRow();
  183. grd_synclist.editCell();
  184. ]]>
  185. </script>
  186. </button>
  187. <button id="btn_syncdel" class="btn2_letter4" style="left:1063px; top:5px; width:64px; height:19px; ">
  188. <caption>항목삭제</caption>
  189. <script type="javascript" ev:event="DOMActivate">
  190. <![CDATA[
  191. deleteSelectedRows(grd_synclist, true);
  192. ]]>
  193. </script>
  194. </button>
  195. <button id="btn_saveexcel" class="btn2_letter4" style="left:1130px; top:5px; width:64px; height:19px; ">
  196. <caption>엑셀저장</caption>
  197. <script type="javascript" ev:event="DOMActivate">
  198. <![CDATA[
  199. var file_nm = window.fileDialog("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  200. if (file_nm != "") {
  201. grd_synclist.saveExcel(file_nm, "SheetName", true, true, "", "", false);
  202. }
  203. ]]>
  204. </script>
  205. </button>
  206. <line id="line2" class="line_1" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  207. <datagrid id="grd_synclist" nodeset="/root/main/list/synclist" caption="프로그램 ID^연동 테이블명^연동 테이블정보^연동간격^연동단위^실행시작^실행종료^접속 IP^접속 DB^접속 ID^접속 PW^접속 Port^사용여부^속성구분" colwidth="150, 150, 150, 60, 60, 70, 60, 90, 80, 80, 80, 70, 60, 70" ellipsis="true" explorerbar="sortshowmove" extendlastcol="scroll" rowheader="update" style="left:0px; top:30px; width:1194px; height:658px; ">
  208. <col imemode="disabled" ref="prgmid" type="input" maxlength="30" _key="true"/>
  209. <col imemode="disabled" ref="synctablenm" type="input" maxlength="16"/>
  210. <col ref="tableinfo" type="input" maxlength="100"/>
  211. <col class="text_center" ref="syncintvl" type="combo">
  212. <choices>
  213. <itemset nodeset="/root/init/comncdlist/C0035list/C0035">
  214. <label ref="cdnm"/>
  215. <value ref="cdid"/>
  216. </itemset>
  217. </choices>
  218. </col>
  219. <col class="text_center" ref="syncunit" type="input" format="99999"/>
  220. <col class="text_center" ref="fromdt" type="input" format="hh:nn"/>
  221. <col class="text_center" ref="fcsttodt" type="input" format="hh:nn"/>
  222. <!--<col class="text_center" ref="attrflag" type="combo">
  223. <choices>
  224. <itemset nodeset="/root/init/comncdlist/C0025list/C0025">
  225. <label ref="cdnm"/>
  226. <value ref="cdid"/>
  227. </itemset>
  228. </choices>
  229. </col>-->
  230. <col class="text_center" imemode="disabled" ref="connip" type="input" maxlength="20"/>
  231. <col class="text_center" imemode="disabled" ref="conndb" type="input" maxlength="30"/>
  232. <col class="text_center" imemode="disabled" ref="connacnt" type="input" maxlength="30"/>
  233. <col class="text_center" imemode="disabled" ref="connpwd" secretendposition="30" secretmark="*" secretstartposition="0" type="input" maxlength="30"/>
  234. <col class="text_center" ref="connport" type="input" format="99999"/>
  235. <col class="text_center" ref="useyn" type="combo">
  236. <choices>
  237. <itemset nodeset="/root/init/comncdlist/C0022list/C0022">
  238. <label ref="cdnm"/>
  239. <value ref="cdid"/>
  240. </itemset>
  241. </choices>
  242. </col>
  243. <col class="text_center" ref="attrflag" type="combo">
  244. <choices>
  245. <itemset nodeset="/root/init/comncdlist/C0025list/C0025">
  246. <label ref="cdnm"/>
  247. <value ref="cdid"/>
  248. </itemset>
  249. </choices>
  250. </col>
  251. </datagrid>
  252. </group>
  253. <group id="group4" style="left:0px; top:751px; width:1195px; height:29px; vertical-align:top; ">
  254. <button id="btn_navi" class="btn3_letter6" style="left:0px; top:0px; width:104px; height:22px; ">
  255. <caption>연동내역정보</caption>
  256. <script type="javascript" ev:event="DOMActivate">
  257. <![CDATA[
  258. open("SMCRC00200");
  259. ]]>
  260. </script>
  261. </button>
  262. <button id="btn_save" class="btn4_letter2" _auth="X" style="left:1068px; top:0px; width:56px; height:22px; ">
  263. <caption>저장</caption>
  264. <script type="javascript" ev:event="DOMActivate">
  265. <![CDATA[
  266. fSaveSyncList();
  267. ]]>
  268. </script>
  269. </button>
  270. <button id="btn_init" class="btn4_letter3" style="left:1127px; top:0px; width:68px; height:22px; ">
  271. <caption>초기화</caption>
  272. <script type="javascript" ev:event="DOMActivate">
  273. <![CDATA[
  274. fInitSyncList();
  275. model.refresh();
  276. ]]>
  277. </script>
  278. </button>
  279. <button id="btn_hospinfo" class="btn3_letter6" style="left:108px; top:0px; width:104px; height:22px; ">
  280. <caption>병원정보설정</caption>
  281. <script type="javascript" ev:event="DOMActivate">
  282. <![CDATA[
  283. window.load("SPCRC00400_병원정보설정.xrw", "modal", "hosp_pop", "align:center;", "", "");
  284. ]]>
  285. </script>
  286. </button>
  287. <!--<button id="button1" class="btn3_letter4" style="left:216px; top:0px; width:104px; height:22px; ">
  288. <caption>휴일관리</caption>
  289. <script type="javascript" ev:event="DOMActivate">
  290. <![CDATA[
  291. window.load("SPCRC00500_휴일관리.xrw", "modal", "hosp_pop", "align:center;", "", "");
  292. ]]>
  293. </script>
  294. </button>-->
  295. </group>
  296. </xhtml:body>
  297. </xhtml:html>