SMRAC00500_재무제표출력순서관리.xrw 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <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">
  4. <xhtml:head>
  5. <xhtml:title>재무제표출력순서관리</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <acntcdprntlist>
  11. <instcd/>
  12. <seq/>
  13. <acntcd/>
  14. <prntnm/>
  15. <calform/>
  16. <prntnm1/>
  17. <prntnm2/>
  18. <prntnm3/>
  19. <prntkind/>
  20. </acntcdprntlist>
  21. <R0003/>
  22. </main>
  23. <send>
  24. <prntkind/>
  25. <prntseq/>
  26. <acntcdprntlist/>
  27. <prntseqnm/>
  28. <fromdd/>
  29. <todd/>
  30. <instcd/>
  31. </send>
  32. <hidden>
  33. <seqchk/>
  34. <seqcount/>
  35. <codeflag/>
  36. <tempcode/>
  37. <temptext/>
  38. <search>
  39. <code/>
  40. <prntnm/>
  41. </search>
  42. </hidden>
  43. <init>
  44. <R0003list>
  45. <R0003>
  46. <cdnm/>
  47. <cdid/>
  48. </R0003>
  49. </R0003list>
  50. <sheetflag>
  51. <cd>01</cd>
  52. <nm>운영계산서(수익)</nm>
  53. </sheetflag>
  54. <sheetflag>
  55. <cd>02</cd>
  56. <nm>운영계산서(비용)</nm>
  57. </sheetflag>
  58. <sheetflag>
  59. <cd>03</cd>
  60. <nm>자금계산서(수입)</nm>
  61. </sheetflag>
  62. <sheetflag>
  63. <cd>04</cd>
  64. <nm>자금계산서(지출)</nm>
  65. </sheetflag>
  66. <sheetflag>
  67. <cd>10</cd>
  68. <nm>현금흐름표</nm>
  69. </sheetflag>
  70. <sheetflag>
  71. <cd>11</cd>
  72. <nm>재고자산명세서</nm>
  73. </sheetflag>
  74. <sheetflag>
  75. <cd>12</cd>
  76. <nm>유형자산명세서</nm>
  77. </sheetflag>
  78. <sheetflag>
  79. <cd>13</cd>
  80. <nm>감가상각누계액명세서</nm>
  81. </sheetflag>
  82. <sheetflag>
  83. <cd>14</cd>
  84. <nm>차입금명세서</nm>
  85. </sheetflag>
  86. <sheetflag>
  87. <cd>15</cd>
  88. <nm>의료미수금명세서</nm>
  89. </sheetflag>
  90. <sheetflag>
  91. <cd>16</cd>
  92. <nm>외래 수익명세서</nm>
  93. </sheetflag>
  94. <sheetflag>
  95. <cd>17</cd>
  96. <nm>입원수익명세서</nm>
  97. </sheetflag>
  98. <sheetflag>
  99. <cd>18</cd>
  100. <nm>직종별 인건비명세서</nm>
  101. </sheetflag>
  102. <sheetflag>
  103. <cd>30</cd>
  104. <nm>관리항목별손익계산서</nm>
  105. </sheetflag>
  106. <sheetflag>
  107. <cd>21</cd>
  108. <nm>시산표</nm>
  109. </sheetflag>
  110. <sheetflag>
  111. <cd>22</cd>
  112. <nm>대차대조표</nm>
  113. </sheetflag>
  114. <sheetflag>
  115. <cd>23</cd>
  116. <nm>손익계산서</nm>
  117. </sheetflag>
  118. <sheetflag>
  119. <cd>24</cd>
  120. <nm>전체계정(popup 등...)</nm>
  121. </sheetflag>
  122. <sheetflag>
  123. <cd>25</cd>
  124. <nm>년이월작업</nm>
  125. </sheetflag>
  126. <sheetflag>
  127. <cd>99</cd>
  128. <nm>기타</nm>
  129. </sheetflag>
  130. </init>
  131. <temp/>
  132. <source>
  133. <instcd/>
  134. <prntkind/>
  135. </source>
  136. <target>
  137. <instcd/>
  138. <acntcd/>
  139. <acntnm/>
  140. </target>
  141. </root>
  142. </instance>
  143. <script type="javascript" ev:event="xforms-ready">
  144. <![CDATA[
  145. model.setValue("/root/send/prntseq","1");
  146. model.setValue("/root/hidden/codeflag","1");
  147. model.removenode( "/root/main/acntcdprntlist");
  148. misfComboComCdList("Z0007", cmb_instcd, "N");
  149. model.setValue("/root/send/instcd", getUserInfo("dutplceinstcd"));
  150. cmb_instcd.refresh();
  151. //콩통코드 자료
  152. // zbcfGetCodeList(new Array("R0003"), new Array("/root/init/R0003list"));
  153. //misfComboComCdList("R0003", cmb_prntkind)
  154. cmb_prntkind.select(0);
  155. ipt_fromdd.value = '19000101';
  156. ipt_todd.value = '99991231'
  157. model.refresh();
  158. misfMsterDetailSet(grd_acntcdprntlist, null, "TRRAC00501", "Y");
  159. ]]>
  160. </script>
  161. <script type="javascript">
  162. <![CDATA[
  163. //조회
  164. function fGetAactcdprtlist()
  165. {
  166. model.setValue( "/root/send/prntkind", cmb_prntkind.value);
  167. if(model.getValue("/root/send/prntseq") == "1")
  168. {
  169. model.setValue("/root/send/prntseqnm", "seq");
  170. }
  171. else
  172. {
  173. model.setValue("/root/send/prntseqnm","codeid");
  174. }
  175. misfMsterDetailRetrieve(); // submit("TRRAC00501");
  176. }
  177. //정렬 순서로 sort함.
  178. function fGetSortSeq()
  179. {
  180. var num = grd_acntcdprntlist.rows- 1;
  181. if(rdo_seq.value == 1)
  182. {
  183. grd_acntcdprntlist.sort(1, 2, num, 2) = "asc";
  184. }
  185. else
  186. {
  187. grd_acntcdprntlist.sort(1, 3, num, 3) = "asc";
  188. }
  189. model.refresh();
  190. }
  191. //출력물순서 저장
  192. function fInsAactcdprtlist()
  193. {
  194. var updtdata = getGridUpdateData(grd_acntcdprntlist);
  195. if (updtdata == "")
  196. {
  197. messageBox("변경된 데이터가","I004");
  198. return;
  199. }
  200. checkKeyColumn( "grd_acntcdprntlist" );
  201. //중복체크에 대한 부부이 빠져있음.
  202. model.setValue("/root/send/acntcdprntlist",grd_acntcdprntlist.getUpdateData());
  203. rtn = messageBox("", "Q002");
  204. if(rtn != "6" ) return false;
  205. // if(submit("TXRAC00501"))
  206. // {
  207. // grd_acntcdprntlist.clearStatus(); // submit() 성공하면 그리드의 i,u,d 상태 제거
  208. // fGetAactcdprtlist();
  209. // }
  210. misfSave("TXRAC00501");
  211. }
  212. //엑셀 입력
  213. function fInputExcel(pGrid) {
  214. var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
  215. if(fileName != "") {
  216. pGrid.loadExcel(fileName, 1, true);
  217. pGrid.deleteRow(1);
  218. for(i = 1; i < pGrid.rows; i++) {
  219. pGrid.rowStatus(i) = 1;
  220. }
  221. pGrid.refresh();
  222. }
  223. }
  224. ]]>
  225. </script>
  226. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  227. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  228. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  229. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  230. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  231. <submission id="TRZBC00101" method="urlencoded-post" replace="instance"/>
  232. <submission id="TRRAC00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/acntcdprntlist"/>
  233. <submission id="TXRAC00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
  234. </model>
  235. </xhtml:head>
  236. <xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  237. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  238. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">재무제표 출력순서 관리</caption>
  239. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  240. </group>
  241. <group id="group3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  242. <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:80px; vertical-align:top; ">
  243. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:80px; background-color:#fffbf2; border-color:#ffd799; "/>
  244. <button id="button2" class="btn1_letter2" navindex="4" style="left:1123px; top:17px; width:56px; height:22px; text-align:left; ">
  245. <caption>조회</caption>
  246. <script type="javascript" ev:event="DOMActivate">
  247. <![CDATA[
  248. fGetAactcdprtlist();
  249. ]]>
  250. </script>
  251. </button>
  252. <caption id="caption7" class="search_name" style="left:16px; top:34px; width:104px; height:17px; ">출력물 종류 :</caption>
  253. <line id="line5" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:50px; border-color:#ffe4bb; border-left-style:solid; "/>
  254. <select1 id="cmb_prntkind" ref="/root/main/R0003" class="combo_s_essential" appearance="minimal" showvalue="true" style="left:125px; top:33px; width:205px; height:19px; ">
  255. <choices>
  256. <itemset nodeset="/root/init/sheetflag">
  257. <label ref="nm"/>
  258. <value ref="cd"/>
  259. </itemset>
  260. </choices>
  261. </select1>
  262. <caption id="caption1" class="search_name" style="left:345px; top:9px; width:104px; height:17px; ">정 렬 순 서 :</caption>
  263. <select1 id="rdo_seq" ref="/root/send/prntseq" class="radio_search" overflow="visible" appearance="full" cellspacing="50" cols="2" style="left:455px; top:8px; width:190px; height:20px; vertical-align:middle; border-style:none; ">
  264. <choices>
  265. <item>
  266. <label>출력순서</label>
  267. <value>1</value>
  268. </item>
  269. <item>
  270. <label>계정코드</label>
  271. <value>2</value>
  272. </item>
  273. </choices>
  274. <script type="javascript" ev:event="xforms-value-changed">
  275. <![CDATA[
  276. //fGetSortSeq();
  277. ]]>
  278. </script>
  279. </select1>
  280. <caption id="caption2" class="search_name" style="left:780px; top:9px; width:75px; height:17px; ">기 간 :</caption>
  281. <input id="ipt_fromdd" ref="/root/send/fromdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:855px; top:8px; width:100px; height:19px; "/>
  282. <input id="ipt_todd" ref="/root/send/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:985px; top:8px; width:100px; height:19px; "/>
  283. <caption id="cap_1" style="left:958px; top:12px; width:25px; height:15px; text-align:center; vertical-align:top; ">~</caption>
  284. <select1 id="rdo_codeflag" ref="/root/hidden/codeflag" class="radio_search" overflow="visible" appearance="full" cellspacing="50" cols="3" style="left:455px; top:33px; width:320px; height:20px; vertical-align:middle; border-style:none; ">
  285. <choices>
  286. <item>
  287. <label>회계계정</label>
  288. <value>1</value>
  289. </item>
  290. <item>
  291. <label>부서코드</label>
  292. <value>2</value>
  293. </item>
  294. <item>
  295. <label>직종코드</label>
  296. <value>3</value>
  297. </item>
  298. </choices>
  299. </select1>
  300. <caption id="cap_codeflag" class="search_name" style="left:345px; top:34px; width:104px; height:17px; ">코 드 선 택 :</caption>
  301. <input id="ipt_tempcode" ref="/root/hidden/tempcode" visibility="hidden" style="left:1095px; top:35px; width:15px; height:19px; "/>
  302. <input id="ipt_temptext" ref="/root/hidden/temptext" visibility="hidden" style="left:1110px; top:35px; width:15px; height:19px; "/>
  303. <select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:125px; top:9px; width:205px; height:19px; ">
  304. <choices>
  305. <itemset>
  306. <label/>
  307. <value/>
  308. </itemset>
  309. </choices>
  310. </select1>
  311. <caption id="caption3" class="search_name" style="left:16px; top:9px; width:104px; height:17px; text-align:right; ">기 관 :</caption>
  312. <caption id="caption5" class="search_name" style="left:16px; top:58px; width:114px; height:17px; ">코 드 :</caption>
  313. <input id="ipt_code" ref="/root/hidden/search/code" class="input_s_essential" appearance="input" style="left:125px; top:57px; width:158px; height:19px; "/>
  314. <input id="ipt_prntnm" ref="/root/hidden/search/prntnm" class="input_s_essential" appearance="input" style="left:455px; top:57px; width:158px; height:19px; "/>
  315. <caption id="caption8" class="search_name" style="left:345px; top:59px; width:104px; height:17px; ">출 력 명 :</caption>
  316. <button id="button1" class="btn2_letter2" style="left:288px; top:57px; width:42px; height:19px; ">
  317. <caption>찾기</caption>
  318. <script type="javascript" ev:event="DOMActivate">
  319. <![CDATA[
  320. var vCode = model.getValue("/root/hidden/search/code");
  321. if(vCode != "")
  322. {
  323. for(var i = grd_acntcdprntlist.fixedRows ; i < grd_acntcdprntlist.rows ; i++)
  324. {
  325. if(grd_acntcdprntlist.valueMatrix(i, grd_acntcdprntlist.colRef("codeid")) == vCode)
  326. {
  327. grd_acntcdprntlist.row = i;
  328. grd_acntcdprntlist.col = grd_acntcdprntlist.colRef("codeid");
  329. return;
  330. }
  331. }
  332. }
  333. ]]>
  334. </script>
  335. </button>
  336. <button id="button4" class="btn2_letter2" style="left:618px; top:57px; width:42px; height:19px; ">
  337. <caption>찾기</caption>
  338. <script type="javascript" ev:event="DOMActivate">
  339. <![CDATA[
  340. var vPrntnm = model.getValue("/root/hidden/search/prntnm");
  341. if(vPrntnm != "")
  342. {
  343. for(var i = grd_acntcdprntlist.fixedRows ; i < grd_acntcdprntlist.rows ; i++)
  344. {
  345. if(grd_acntcdprntlist.valueMatrix(i, grd_acntcdprntlist.colRef("acntnm")) == vPrntnm)
  346. {
  347. grd_acntcdprntlist.row = i;
  348. grd_acntcdprntlist.col = grd_acntcdprntlist.colRef("acntnm");
  349. return;
  350. }
  351. }
  352. }
  353. ]]>
  354. </script>
  355. </button>
  356. </group>
  357. <line id="line3" class="line_1" style="x1:0px; y1:110px; x2:1194px; y2:110px; "/>
  358. <button id="button18" class="btn2_letter3" style="left:1139px; top:90px; width:53px; height:19px; ">
  359. <caption>행삭제</caption>
  360. <script type="javascript" ev:event="DOMActivate">
  361. <![CDATA[
  362. misfGridIUD(grd_acntcdprntlist, "D");
  363. model.refresh();
  364. ]]>
  365. </script>
  366. </button>
  367. <button id="btn_addrow" class="btn2_letter3" style="left:1085px; top:90px; width:53px; height:19px; ">
  368. <caption>행추가</caption>
  369. <script type="javascript" ev:event="DOMActivate">
  370. <![CDATA[
  371. misfGridIUD(grd_acntcdprntlist, "A");
  372. grd_acntcdprntlist.valueMatrix(grd_acntcdprntlist.rows-1, grd_acntcdprntlist.colRef("prntkind")) = cmb_prntkind.value;
  373. grd_acntcdprntlist.valueMatrix(grd_acntcdprntlist.rows-1, grd_acntcdprntlist.colRef("fromdd")) = '19000101';
  374. grd_acntcdprntlist.valueMatrix(grd_acntcdprntlist.rows-1, grd_acntcdprntlist.colRef("todd")) = '99991231';
  375. model.refresh();
  376. ]]>
  377. </script>
  378. </button>
  379. <datagrid id="grd_acntcdprntlist" nodeset="/root/main/acntcdprntlist" caption="기관코드^출력순서^계정코드^계정명^출력명^계산식^Option1^Option2^Option3^Option4^Option5^사용시작일^사용종료일^출력물 종류" colsep="^" colwidth="0, 89, 80, 150, 200, 220, 100, 100, 100, 100, 100, 100, 100, 100" ellipsis="true" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="16" rowsep="|" tooltip="true" style="left:0px; top:115px; width:1194px; height:618px; ">
  380. <col ref="instcd" visibility="hidden"/>
  381. <col ref="seq" type="input" maxlength="10" _key="false" style="text-align:center; "/>
  382. <col ref="codeid" type="inputbutton" maxlength="8" style="text-align:left; "/>
  383. <col ref="acntnm" maxlength="100"/>
  384. <col ref="prntnm" type="input" maxlength="100"/>
  385. <col ref="calform" type="input" maxlength="200"/>
  386. <col ref="prntnm1" type="input" maxlength="100"/>
  387. <col ref="prntnm2" type="input" maxlength="100"/>
  388. <col ref="prntnm3" type="input" maxlength="100"/>
  389. <col ref="prntnm4" type="input" maxlength="100"/>
  390. <col ref="prntnm5" type="input" maxlength="100"/>
  391. <col ref="fromdd" type="inputdate"/>
  392. <col ref="todd" type="inputdate"/>
  393. <col ref="prntkind"/>
  394. <script type="javascript" ev:event="onbuttonclick">
  395. <![CDATA[
  396. if(grd_acntcdprntlist.col == grd_acntcdprntlist.colRef("codeid"))
  397. {
  398. if(rdo_codeflag.value == 1)
  399. {
  400. misfOpenPopUpList("05", grd_acntcdprntlist, "", "codeid,prntnm", "cmb_instcd");
  401. }
  402. else if(rdo_codeflag.value == 2)
  403. {
  404. misfOpenPopUpList("02", grd_acntcdprntlist, "", "codeid,prntnm");
  405. }
  406. else if(rdo_codeflag.value == 3)
  407. {
  408. //misfOpenPopUpList("02", grd_acntcdprntlist, "", "codeid,prntnm");
  409. rpbfOpenComCdHelp(ipt_tempcode ,"R0061", "tempcode,temptext");
  410. model.setValue(grd_acntcdprntlist.nodeset + "[" + grd_acntcdprntlist.row + "]/codeid", ipt_tempcode.value);
  411. model.setValue(grd_acntcdprntlist.nodeset + "[" + grd_acntcdprntlist.row + "]/prntnm", ipt_temptext.value);
  412. model.removenode("/root/hidden/tempcode");
  413. model.removenode("/root/hidden/temptext");
  414. model.refresh();
  415. }
  416. }
  417. ]]>
  418. </script>
  419. <script type="javascript" ev:event="onaftersort">
  420. <![CDATA[
  421. grd_acntcdprntlist.gridToInstance();
  422. ]]>
  423. </script>
  424. </datagrid>
  425. <button id="ipt_excsave" class="btn2_letter4" style="left:1015px; top:90px; width:64px; height:19px; ">
  426. <caption>엑셀저장</caption>
  427. <script type="javascript" ev:event="DOMActivate">
  428. <![CDATA[
  429. misfSaveExcel(grd_acntcdprntlist);
  430. ]]>
  431. </script>
  432. </button>
  433. <caption id="caption21" class="tit_2" style="left:5px; top:95px; width:131px; height:13px; ">출력 목록</caption>
  434. <button id="ipt_excadd" class="btn2_letter4" style="left:944px; top:90px; width:64px; height:19px; ">
  435. <caption>엑셀입력</caption>
  436. <script type="javascript" ev:event="DOMActivate">
  437. <![CDATA[
  438. fInputExcel(grd_acntcdprntlist);
  439. grd_acntcdprntlist.gridToInstance();
  440. for(var i = 1 ; i <= model.instance1.selectNodes(grd_acntcdprntlist.nodeset).length ; i++)
  441. {
  442. model.setValue(grd_acntcdprntlist.nodeset + "[" + i + "]/fromdd", "19000101");
  443. model.setValue(grd_acntcdprntlist.nodeset + "[" + i + "]/todd", "99991231");
  444. }
  445. ]]>
  446. </script>
  447. </button>
  448. <button id="button3" class="btn2_letter4" style="left:860px; top:90px; width:64px; height:19px; ">
  449. <caption>입력목록</caption>
  450. <script type="javascript" ev:event="DOMActivate">
  451. <![CDATA[
  452. model.setValue("/root/source/instcd", model.getValue(cmb_instcd.attribute("ref")));
  453. model.setValue("/root/source/prntkind", model.getValue(cmb_prntkind.attribute("ref")));
  454. model.setValue("/root/target/instcd", "");
  455. model.setValue("/root/target/acntcd", "");
  456. model.setValue("/root/target/acntnm", "");
  457. modal("SPRAC00501","","","","","/root/source", "/root/target");
  458. ]]>
  459. </script>
  460. </button>
  461. </group>
  462. <group id="group4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  463. <button id="button39" class="btn4_letter2" style="left:1137px; top:3px; width:56px; height:22px; ">
  464. <caption>저장</caption>
  465. <script type="javascript" ev:event="DOMActivate">
  466. <![CDATA[
  467. fInsAactcdprtlist();
  468. ]]>
  469. </script>
  470. </button>
  471. <line id="line2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  472. <button id="button23" class="btn6_letter2" visibility="hidden" style="left:2px; top:3px; width:56px; height:22px; ">
  473. <caption>출력</caption>
  474. </button>
  475. </group>
  476. </xhtml:body>
  477. </xhtml:html>