PPRAC00100_계정코드HELP.xfdl 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="PPRAC00100" position="absolute 0 0 686 541" titletext="계정코드 Help" oninit="PPRAC00100_oninit" onload="PPRAC00100_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption1" text="계정코드 리스트" class="tit_2" position="absolute 0 70 118 91"/>
  8. <Shape id="line1" class="line_10" position="absolute 0 86 680 92" anchor="left top right"/>
  9. <Div id="group6" taborder="1" class="div_SA" position="absolute 0 0 680 61" anchor="left top right">
  10. <Layouts>
  11. <Layout>
  12. <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 609 20 665 42" onclick="group6_btn_search_onclick"/>
  13. <Shape id="line8" linetype="vertical" class="line_4" position="absolute 591 9 597 52"/>
  14. <Combo id="cmb_useyns" taborder="6" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_s_essential" visible="false" position="absolute 407 34 527 53" onitemchanged="group6_cmb_useyns_onitemchanged">
  15. <Dataset id="innerdataset">
  16. <ColumnInfo>
  17. <Column id="codecolumn"/>
  18. <Column id="datacolumn"/>
  19. </ColumnInfo>
  20. <Rows>
  21. <Row>
  22. <Col id="codecolumn">%</Col>
  23. <Col id="datacolumn">전체</Col>
  24. </Row>
  25. <Row>
  26. <Col id="codecolumn">Y</Col>
  27. <Col id="datacolumn">사용</Col>
  28. </Row>
  29. <Row>
  30. <Col id="codecolumn">N</Col>
  31. <Col id="datacolumn">사용안함</Col>
  32. </Row>
  33. </Rows>
  34. </Dataset>
  35. </Combo>
  36. <Static id="caption3" text="사용여부 :" class="search_name" visible="false" position="absolute 321 36 407 53"/>
  37. <Static id="caption5" text="계정구분 :" class="search_name" position="absolute 16 36 102 53"/>
  38. <Static id="caption7" text="조회조건 :" class="search_name" position="absolute 16 9 105 26"/>
  39. <Edit id="ipt_acntnms" taborder="7" class="input_s_essential" position="absolute 219 8 527 27" autoselect="true" autoskip="true" onkeydown="group6_ipt_acntnms_onkeydown"/>
  40. <Combo id="cmb_acntflag" taborder="8" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_s_essential" position="absolute 100 34 245 53" onitemchanged="group6_cmb_acntflag_onitemchanged">
  41. <Dataset id="innerdataset">
  42. <ColumnInfo>
  43. <Column id="codecolumn"/>
  44. <Column id="datacolumn"/>
  45. </ColumnInfo>
  46. <Rows>
  47. <Row>
  48. <Col id="codecolumn"/>
  49. <Col id="datacolumn"/>
  50. </Row>
  51. <Row>
  52. <Col id="codecolumn">1</Col>
  53. <Col id="datacolumn">자산</Col>
  54. </Row>
  55. <Row>
  56. <Col id="codecolumn">2</Col>
  57. <Col id="datacolumn">부채</Col>
  58. </Row>
  59. <Row>
  60. <Col id="codecolumn">3</Col>
  61. <Col id="datacolumn">자본</Col>
  62. </Row>
  63. <Row>
  64. <Col id="codecolumn">4</Col>
  65. <Col id="datacolumn">수익</Col>
  66. </Row>
  67. <Row>
  68. <Col id="codecolumn">5</Col>
  69. <Col id="datacolumn">비용</Col>
  70. </Row>
  71. </Rows>
  72. </Dataset>
  73. </Combo>
  74. <Radio id="rdo_jobgb" taborder="9" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" class="radio_search" position="absolute 100 8 218 27">
  75. <Dataset id="innerdataset">
  76. <ColumnInfo>
  77. <Column id="codecolumn"/>
  78. <Column id="datacolumn"/>
  79. </ColumnInfo>
  80. <Rows>
  81. <Row>
  82. <Col id="codecolumn">1</Col>
  83. <Col id="datacolumn">코드명</Col>
  84. </Row>
  85. <Row>
  86. <Col id="codecolumn">2</Col>
  87. <Col id="datacolumn">코드</Col>
  88. </Row>
  89. </Rows>
  90. </Dataset>
  91. </Radio>
  92. </Layout>
  93. </Layouts>
  94. </Div>
  95. <Grid id="grd_acntlist" taborder="2" binddataset="ds_main_acntlist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 91 680 511" anchor="all" oncelldblclick="grd_acntlist_oncelldblclick">
  96. <Formats>
  97. <Format id="default">
  98. <Columns>
  99. <Column size="23"/>
  100. <Column size="67"/>
  101. <Column size="274"/>
  102. <Column size="145"/>
  103. <Column size="58"/>
  104. <Column size="58"/>
  105. <Column size="37"/>
  106. <Column size="0"/>
  107. <Column size="37"/>
  108. </Columns>
  109. <Rows>
  110. <Row size="24" band="head"/>
  111. <Row size="24"/>
  112. </Rows>
  113. <Band id="head">
  114. <Cell/>
  115. <Cell col="1" text="계정코드"/>
  116. <Cell col="2" text="계정명"/>
  117. <Cell col="3" text="상위계정명"/>
  118. <Cell col="4" text="계정구분"/>
  119. <Cell col="5" text="잔액구분"/>
  120. <Cell col="6" text="기표"/>
  121. <Cell col="7" text="사용"/>
  122. <Cell col="8" text="사용"/>
  123. </Band>
  124. <Band id="body">
  125. <Cell celltype="head" expr="currow+1"/>
  126. <Cell col="1" text="bind:acntcd"/>
  127. <Cell col="2" text="bind:acntnm"/>
  128. <Cell col="3" style="align:left middle;padding:2 2 2 2;" text="bind:supacntnm"/>
  129. <Cell col="4" displaytype="combo" style="align:left middle;padding:2 2 2 2;" text="bind:acntflag" combodataset="ds_cmb_acntflag" combocodecol="value" combodatacol="label" enable="false"/>
  130. <Cell col="5" displaytype="combo" style="align:left middle;padding:2 2 2 2;" text="bind:balflag" combodataset="ds_cmb_balflag" combocodecol="value" combodatacol="label" enable="false"/>
  131. <Cell col="6" displaytype="combo" edittype="combo" style="align:left middle;padding:2 2 2 2;" text="bind:slipyn" combodataset="ds_cmb_slipyn" combocodecol="value" combodatacol="label" enable="false"/>
  132. <Cell col="7" displaytype="checkbox" edittype="checkbox" style="align:left middle;padding:2 2 2 2;" text="bind:acntuseyn" enable="true"/>
  133. <Cell col="8" style="align:left middle;padding:2 2 2 2;" text="bind:slipyn"/>
  134. </Band>
  135. </Format>
  136. </Formats>
  137. </Grid>
  138. <Static id="caption2" text="[ 예산 조회 여부로 선택된 계정이 보이게 됩니다. 예산 과목 관리를 확인하세요. ]" position="absolute 130 65 670 85" style="color:#ff6600ff;font:Dotum,9,bold;"/>
  139. <Shape id="line32" class="line_6" position="absolute -1 511 679 517" anchor="left right bottom"/>
  140. <Button id="btn_confirm" taborder="3" text="확인" class="btn4" position="absolute 564 516 620 538" anchor="right bottom" onclick="btn_confirm_onclick"/>
  141. <Button id="btn_cancel" taborder="4" text="취소" class="btn4" position="absolute 623 516 679 538" anchor="right bottom"/>
  142. </Layout>
  143. </Layouts>
  144. <Objects>
  145. <Dataset id="ds_send_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  146. <ColumnInfo>
  147. <Column id="instcd" type="STRING" size="256"/>
  148. <Column id="acntflag" type="STRING" size="256"/>
  149. <Column id="useyn" type="STRING" size="256"/>
  150. <Column id="jobgb" type="STRING" size="256"/>
  151. <Column id="srhtxt" type="STRING" size="256"/>
  152. <Column id="slipyn" type="STRING" size="256"/>
  153. <Column id="acntclsflag" type="STRING" size="256"/>
  154. <Column id="flag" type="STRING" size="256"/>
  155. </ColumnInfo>
  156. <Rows>
  157. <Row>
  158. <Col id="instcd"/>
  159. <Col id="acntflag"/>
  160. <Col id="useyn">Y</Col>
  161. <Col id="jobgb">1</Col>
  162. <Col id="srhtxt"/>
  163. <Col id="slipyn"/>
  164. <Col id="acntclsflag"/>
  165. <Col id="flag"/>
  166. </Row>
  167. </Rows>
  168. </Dataset>
  169. <Dataset id="ds_main_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  170. <ColumnInfo>
  171. <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
  172. <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
  173. <Column id="supacntnm" type="STRING" size="256" sumtext="상위계정명"/>
  174. <Column id="acntflag" type="STRING" size="256" sumtext="계정구분"/>
  175. <Column id="balflag" type="STRING" size="256" sumtext="잔액구분"/>
  176. <Column id="slipyn" type="STRING" size="256" sumtext="기표"/>
  177. <Column id="acntuseyn" type="STRING" size="256" sumtext="사용"/>
  178. <Column id="dayreportuseyn" type="STRING" size="256" sumtext="일계월계사용여부"/>
  179. </ColumnInfo>
  180. </Dataset>
  181. <Dataset id="ds_cmb_acntflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  182. <ColumnInfo>
  183. <Column id="label" type="STRING" size="256"/>
  184. <Column id="value" type="STRING" size="256"/>
  185. </ColumnInfo>
  186. <Rows>
  187. <Row>
  188. <Col id="label">자산</Col>
  189. <Col id="value">1</Col>
  190. </Row>
  191. <Row>
  192. <Col id="label">부채</Col>
  193. <Col id="value">2</Col>
  194. </Row>
  195. <Row>
  196. <Col id="label">자본</Col>
  197. <Col id="value">3</Col>
  198. </Row>
  199. <Row>
  200. <Col id="label">수익</Col>
  201. <Col id="value">4</Col>
  202. </Row>
  203. <Row>
  204. <Col id="label">비용</Col>
  205. <Col id="value">5</Col>
  206. </Row>
  207. </Rows>
  208. </Dataset>
  209. <Dataset id="ds_cmb_balflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  210. <ColumnInfo>
  211. <Column id="label" type="STRING" size="256"/>
  212. <Column id="value" type="STRING" size="256"/>
  213. </ColumnInfo>
  214. <Rows>
  215. <Row>
  216. <Col id="label">차변잔액</Col>
  217. <Col id="value">D</Col>
  218. </Row>
  219. <Row>
  220. <Col id="label">대변잔액</Col>
  221. <Col id="value">C</Col>
  222. </Row>
  223. </Rows>
  224. </Dataset>
  225. <Dataset id="ds_cmb_slipyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  226. <ColumnInfo>
  227. <Column id="label" type="STRING" size="256"/>
  228. <Column id="value" type="STRING" size="256"/>
  229. </ColumnInfo>
  230. <Rows>
  231. <Row>
  232. <Col id="label">가능</Col>
  233. <Col id="value">Y</Col>
  234. </Row>
  235. <Row>
  236. <Col id="label"/>
  237. <Col id="value">N</Col>
  238. </Row>
  239. </Rows>
  240. </Dataset>
  241. <Dataset id="ds_target_defaultvalue" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  242. <Dataset id="ds_target_validation" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  243. <Dataset id="ds_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  244. </Objects>
  245. <Bind>
  246. <BindItem id="item0" compid="group6.rdo_jobgb" propid="value" datasetid="ds_send_condition" columnid="jobgb"/>
  247. <BindItem id="item1" compid="group6.ipt_acntnms" propid="value" datasetid="ds_send_condition" columnid="srhtxt"/>
  248. <BindItem id="item2" compid="group6.cmb_acntflag" propid="value" datasetid="ds_send_condition" columnid="acntflag"/>
  249. <BindItem id="item3" compid="group6.cmb_useyns" propid="value" datasetid="ds_send_condition" columnid="useyn"/>
  250. </Bind>
  251. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  252. * System Name :
  253. * Job Name :
  254. * Creator :
  255. * Make Date : 2017-06-19
  256. * Description :
  257. *---------------------------------------------------------------------------------------
  258. * Modify Date Modifier Modify Description
  259. *---------------------------------------------------------------------------------------
  260. * 2017-06-19 Live Converter TF->XP
  261. *
  262. *---------------------------------------------------------------------------------------
  263. ****************************************************************************************/
  264. include "com_commonxp::comm_main.xjs";
  265. include "mis_miscommonxp::MIS.xjs";
  266. function PPRAC00100_oninit(obj:Form, e:InitEventInfo)
  267. {
  268. frmf_initForm(obj);
  269. }
  270. function PPRAC00100_onload(obj:Form, e:LoadEventInfo)
  271. {
  272. grdf_initGrid(grd_acntlist);
  273. fOpenForm();
  274. }
  275. function fOpenForm()
  276. {
  277. ds_main_acntlist.clearData();
  278. try
  279. {
  280. ds_target_defaultvalue.copyData(arg_ds_target_defaultvalue);
  281. }
  282. catch (e)
  283. {}
  284. try
  285. {
  286. ds_target_validation.copyData(arg_ds_target_validation);
  287. }
  288. catch (e)
  289. {}
  290. try
  291. {
  292. ds_target.copyData(arg_ds_target);
  293. }
  294. catch (e)
  295. {}
  296. if(ds_target_defaultvalue.getColumnInfo("slipyn"))
  297. {
  298. ds_send_condition.setColumn(0, "slipyn", ds_target_defaultvalue.getColumn(0, "slipyn"));
  299. }
  300. if(ds_target_defaultvalue.getColumnInfo("flag"))
  301. {
  302. ds_send_condition.setColumn(0, "flag", ds_target_defaultvalue.getColumn(0, "flag"));
  303. group6.cmb_acntflag.visible = false;
  304. group6.caption5.visible = false;
  305. caption2.visible = false;
  306. }
  307. if(!utlf_isNull(ds_target_defaultvalue.getColumnInfo("acntclsflag")))
  308. {
  309. ds_send_condition.setColumn(0, "acntclsflag", ds_target_defaultvalue.getColumn(0, "acntclsflag"));
  310. grd_acntlist.setFormatColProperty(6, "size", 0);
  311. grd_acntlist.setFormatColProperty(8, "size", 37);
  312. }
  313. else
  314. {
  315. grd_acntlist.setFormatColProperty(6, "size", 37);
  316. grd_acntlist.setFormatColProperty(8, "size", 0);
  317. }
  318. if(ds_target_defaultvalue.getColumnInfo("instcd"))
  319. {
  320. ds_send_condition.setColumn(0, "instcd", ds_target_defaultvalue.getColumn(0, "instcd"));
  321. }
  322. // if(model.getValue("/root/target/defaultvalue/instcd") != "")
  323. // {
  324. // model.setValue("/root/send/condition/instcd", model.getValue("/root/target/defaultvalue/instcd"));
  325. // }
  326. // else if(model.getValue("/root/target/defaultvalue/cmb_instcd") != "")
  327. // {
  328. // model.setValue("/root/send/condition/instcd", model.getValue("/root/target/defaultvalue/cmb_instcd"));
  329. // }
  330. if(ds_target_validation.rowcount == 0)
  331. {
  332. fGetAcntList();
  333. }
  334. else
  335. {
  336. //model.copyNode("/root/main", "/root/target/validation");
  337. }
  338. group6.ipt_acntnms.setFocus();
  339. }
  340. function fGetAcntList()
  341. {
  342. ds_main_acntlist.clearData();
  343. var oParam = {};
  344. oParam.id = "TRRAC00111";
  345. oParam.service = "miscommoncdrefapp.CommonCdRef";
  346. oParam.method = "reqGetAcntCdList";
  347. oParam.inds = "req=ds_send_condition";
  348. oParam.outds = "ds_main_acntlist=acntlist";
  349. oParam.async = false;
  350. //oParam.callback = "cf_TRRAC00111";
  351. tranf_submit(oParam);
  352. }
  353. function group6_ipt_acntnms_onkeydown(obj:Edit, e:KeyEventInfo)
  354. {
  355. if(e.keycode == 13)
  356. {
  357. obj.updateToDataset();
  358. group6.btn_search.click();
  359. }
  360. }
  361. function group6_cmb_acntflag_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  362. {
  363. ds_send_condition.setColumn(0, "jobgb", "1");
  364. ds_send_condition.setColumn(0, "srhtxt", "");
  365. fGetAcntList();
  366. }
  367. function group6_cmb_useyns_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  368. {
  369. fGetAcntList();
  370. }
  371. function group6_btn_search_onclick(obj:Button, e:ClickEventInfo)
  372. {
  373. fGetAcntList();
  374. }
  375. function grd_acntlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  376. {
  377. if(e.row > -1)
  378. {
  379. btn_confirm.click();
  380. }
  381. }
  382. function btn_confirm_onclick(obj:Button, e:ClickEventInfo)
  383. {
  384. var cur_row = ds_main_acntlist.rowposition;
  385. var sTrimAcntnm = ds_main_acntlist.getColumn(cur_row, "acntnm");
  386. if(!utlf_isNull(ds_target_defaultvalue.getColumn(0, "acntclsflag")))
  387. {
  388. var slipyn = ds_main_acntlist.getColumn(cur_row, "slipyn");
  389. if (slipyn != "Y")
  390. {
  391. sysf_messageBox("잘못된 선택입니다." ,"I000");
  392. return;
  393. }
  394. }
  395. else if (ds_send_condition.getColumn(0, "slipyn") == "Y")
  396. {
  397. var slipyn = ds_main_acntlist.getColumn(cur_row, "slipyn");
  398. if (slipyn != "Y")
  399. {
  400. sysf_messageBox("기표 가능 계정만 선택이 가능합니다." ,"I000");
  401. return;
  402. }
  403. }
  404. ds_main_acntlist.setColumn(cur_row, "acntnm", sTrimAcntnm.getTrimLeft());
  405. misfPopUpListReturn(grd_acntlist);
  406. }
  407. ]]></Script>
  408. </Form>
  409. </FDL>