SPRBC01500_부서별예산코드HELP.xfdl 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPRBC01500" position="absolute 0 0 795 547" titletext="부서별 예산 편성 코드 조회" oninit="SPRBC01500_oninit" onload="SPRBC01500_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div position="absolute 8 0 790 522" id="group3" scrollbars="autoboth">
  8. <Layouts>
  9. <Layout>
  10. <Div position="absolute 0 0 580 5" id="group2"/>
  11. <Static text="부서코드별 예산 편성 리스트" position="absolute 0 47 205 63" id="caption1" class="tit_2"/>
  12. <Shape position="absolute 0 63 780 69" linetype="horizontal" id="line1" class="line_10"/>
  13. <Grid position="absolute 0 68 780 512" id="grd_acntlist" binddataset="ds_main_acntcode_acntcodelist" oncelldblclick="group3_grd_acntlist_oncelldblclick">
  14. <Formats>
  15. <Format id="default">
  16. <Columns>
  17. <Column size="24"/>
  18. <Column size="0"/>
  19. <Column size="81"/>
  20. <Column size="0"/>
  21. <Column size="70"/>
  22. <Column size="60"/>
  23. <Column size="180"/>
  24. <Column size="71"/>
  25. <Column size="111"/>
  26. <Column size="58"/>
  27. <Column size="0"/>
  28. <Column size="0"/>
  29. <Column size="0"/>
  30. <Column size="0"/>
  31. <Column size="0"/>
  32. <Column size="100"/>
  33. </Columns>
  34. <Rows>
  35. <Row size="24" band="head"/>
  36. <Row size="24"/>
  37. </Rows>
  38. <Band id="head">
  39. <Cell/>
  40. <Cell col="1" text="항코드"/>
  41. <Cell col="2" text="항"/>
  42. <Cell col="3" text="목코드"/>
  43. <Cell col="4" text="목"/>
  44. <Cell col="5" text="계정코드"/>
  45. <Cell col="6" text="계정과목명"/>
  46. <Cell col="7" text="프로젝트ID"/>
  47. <Cell col="8" text="프로젝트명"/>
  48. <Cell col="9" text="예산구분"/>
  49. <Cell col="10" text="예산코드"/>
  50. <Cell col="11" text="예산명"/>
  51. <Cell col="12" text="계정코드예산코드"/>
  52. <Cell col="13" text="선택"/>
  53. <Cell col="14" text="예산존재여부"/>
  54. <Cell col="15" text="가용액"/>
  55. </Band>
  56. <Band id="body">
  57. <Cell celltype="head" expr="currow + 1"/>
  58. <Cell col="1" text="bind:supacntcd3"/>
  59. <Cell col="2" text="bind:supacntnm3" suppress="1" suppressalign="middle,over"/>
  60. <Cell col="3" text="bind:supacntcd4"/>
  61. <Cell col="4" text="bind:supacntnm4" suppress="2" suppressalign="middle,over"/>
  62. <Cell col="5" text="bind:acntcd"/>
  63. <Cell col="6" style="align:left top;padding:5 2 1 2;" text="bind:acntnm" wordwrap="word"/>
  64. <Cell col="7" text="bind:projectid"/>
  65. <Cell col="8" text="bind:projectnm"/>
  66. <Cell col="9" displaytype="combo" edittype="none" style="align:center middle;padding:1 2 1 2;" text="bind:bugtflag" combodataset="ds_cbo_bugtflag" combocodecol="value" combodatacol="label" enable="false"/>
  67. <Cell col="10" text="bind:bugtcd"/>
  68. <Cell col="11" text="bind:bugtnm"/>
  69. <Cell col="12" text="bind:acntcdbugtcd"/>
  70. <Cell col="13" displaytype="checkbox" edittype="checkbox" text="bind:chk"/>
  71. <Cell col="14" text="bind:bugtyn"/>
  72. <Cell col="15" displaytype="number" text="bind:solubleamt"/>
  73. </Band>
  74. </Format>
  75. </Formats>
  76. </Grid>
  77. <Div position="absolute 0 5 780 40" id="group4" class="div_SA">
  78. <Layouts>
  79. <Layout>
  80. <Static text="조건 :" position="absolute 15 9 101 26" id="caption7" class="search_name" visible="true"/>
  81. <Edit position="absolute 80 8 360 27" id="ipt_acntcd" class="input_essential" taborder="2" visible="true" autoselect="true" onkeydown="group3_group4_ipt_acntcd_onkeydown"/>
  82. <Button position="absolute 715 5 771 27" align="align:left middle;" id="btn_search" class="btn1" taborder="4" text="조회" onclick="group3_group4_btn_search_onclick"/>
  83. <Shape position="absolute 702 5 708 32" linetype="vertical" id="line13" class="line_4"/>
  84. </Layout>
  85. </Layouts>
  86. </Div>
  87. </Layout>
  88. </Layouts>
  89. </Div>
  90. <Button id="btn_confirm" taborder="1" text="확인" class="btn4" position="absolute 661 517 717 539" onclick="btn_confirm_onclick"/>
  91. <Button id="btn_cancel" taborder="2" text="취소" class="btn4" position="absolute 720 517 776 539" onclick="btn_cancel_onclick"/>
  92. </Layout>
  93. </Layouts>
  94. <Objects>
  95. <Dataset id="ds_main_bugtcode_bugtcodelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  96. <Dataset id="ds_main_acntcode_acntcodelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  97. <ColumnInfo>
  98. <Column id="supacntcd3" type="STRING" size="256"/>
  99. <Column id="supacntnm3" type="STRING" size="256"/>
  100. <Column id="supacntcd4" type="STRING" size="256"/>
  101. <Column id="supacntnm4" type="STRING" size="256"/>
  102. <Column id="acntcd" type="STRING" size="256"/>
  103. <Column id="acntnm" type="STRING" size="256"/>
  104. <Column id="projectid" type="STRING" size="256"/>
  105. <Column id="projectnm" type="STRING" size="256"/>
  106. <Column id="bugtflag" type="STRING" size="256"/>
  107. <Column id="bugtcd" type="STRING" size="256"/>
  108. <Column id="bugtnm" type="STRING" size="256"/>
  109. <Column id="acntcdbugtcd" type="STRING" size="256"/>
  110. <Column id="chk" type="STRING" size="256"/>
  111. </ColumnInfo>
  112. <Rows>
  113. <Row>
  114. <Col id="supacntcd3"/>
  115. <Col id="supacntnm3"/>
  116. <Col id="supacntcd4"/>
  117. <Col id="supacntnm4"/>
  118. <Col id="acntcd"/>
  119. <Col id="acntnm"/>
  120. <Col id="projectid"/>
  121. <Col id="projectnm"/>
  122. <Col id="bugtflag"/>
  123. <Col id="bugtcd"/>
  124. <Col id="bugtnm"/>
  125. <Col id="acntcdbugtcd"/>
  126. <Col id="chk"/>
  127. </Row>
  128. </Rows>
  129. </Dataset>
  130. <Dataset id="ds_target" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  131. <Dataset id="ds_send_bugtref" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  132. <ColumnInfo>
  133. <Column id="acntcd" type="STRING" size="256"/>
  134. <Column id="acntnm" type="STRING" size="256"/>
  135. <Column id="bugtflag" type="STRING" size="256"/>
  136. <Column id="deptcd" type="STRING" size="256"/>
  137. <Column id="acntyy" type="STRING" size="256"/>
  138. <Column id="bugtflag" type="STRING" size="256"/>
  139. </ColumnInfo>
  140. <Rows>
  141. <Row>
  142. <Col id="acntcd"/>
  143. <Col id="acntnm"/>
  144. <Col id="bugtflag"/>
  145. <Col id="deptcd"/>
  146. <Col id="acntyy"/>
  147. <Col id="bugtflag"/>
  148. </Row>
  149. </Rows>
  150. </Dataset>
  151. <Dataset id="ds_init_refcond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  152. <ColumnInfo>
  153. <Column id="label" type="STRING" size="256"/>
  154. <Column id="value" type="STRING" size="256"/>
  155. </ColumnInfo>
  156. <Rows>
  157. <Row>
  158. <Col id="label">예산코드</Col>
  159. <Col id="value">bugtcd</Col>
  160. </Row>
  161. <Row>
  162. <Col id="label">예산명</Col>
  163. <Col id="value">bugtnm</Col>
  164. </Row>
  165. </Rows>
  166. </Dataset>
  167. <Dataset id="ds_cbo_bugtflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  168. <ColumnInfo>
  169. <Column id="label" type="STRING" size="256"/>
  170. <Column id="value" type="STRING" size="256"/>
  171. </ColumnInfo>
  172. <Rows>
  173. <Row>
  174. <Col id="label">수익</Col>
  175. <Col id="value">1</Col>
  176. </Row>
  177. <Row>
  178. <Col id="label">비용</Col>
  179. <Col id="value">2</Col>
  180. </Row>
  181. <Row>
  182. <Col id="label">수익 및 비용</Col>
  183. <Col id="value">3</Col>
  184. </Row>
  185. </Rows>
  186. </Dataset>
  187. <Dataset id="ds_target_validation_acntcodelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  188. <Dataset id="ds_source" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  189. <ColumnInfo>
  190. <Column id="projectid" type="STRING" size="256"/>
  191. </ColumnInfo>
  192. <Rows>
  193. <Row>
  194. <Col id="projectid"/>
  195. </Row>
  196. </Rows>
  197. </Dataset>
  198. </Objects>
  199. <Bind>
  200. <BindItem id="item0" compid="group3.group4.ipt_acntcd" propid="value" datasetid="ds_send_bugtref" columnid="acntcd"/>
  201. </Bind>
  202. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  203. * System Name :
  204. * Job Name :
  205. * Creator :
  206. * Make Date : 2017-06-19
  207. * Description :
  208. *---------------------------------------------------------------------------------------
  209. * Modify Date Modifier Modify Description
  210. *---------------------------------------------------------------------------------------
  211. * 2017-06-19 Live Converter TF->XP
  212. *
  213. *---------------------------------------------------------------------------------------
  214. ****************************************************************************************/
  215. include "com_commonxp::comm_main.xjs";
  216. include "mis_miscommonxp::MIS.xjs";
  217. var arErrorCode = new HashArray();
  218. function SPRBC01500_oninit(obj:Form, e:InitEventInfo)
  219. {
  220. frmf_initForm(obj); //폼 초기화
  221. }
  222. function SPRBC01500_onload(obj:Form, e:LoadEventInfo)
  223. {
  224. try{
  225. trace(arg_ds_target_defaultvalue.saveXML())
  226. ds_target.copyData(arg_ds_target_defaultvalue);
  227. }catch(e){
  228. sysf_catchTrace(e);
  229. }
  230. ds_main_acntcode_acntcodelist.clearData();
  231. ds_send_bugtref.setColumn(0, "deptcd", ds_target.getColumn(0, "deptcd"));
  232. ds_send_bugtref.setColumn(0, "acntyy", ds_target.getColumn(0, "acntyy"));
  233. ds_send_bugtref.setColumn(0, "bugtflag", ds_target.getColumn(0, "bugtflag"));
  234. misfMsterDetailSet(group3.grd_acntlist, null, "TRRBC99102", "N");
  235. if(ds_target_validation_acntcodelist.rowcount == 0)
  236. {
  237. misfMsterDetailRetrieve();//계정코드 조회
  238. }
  239. else
  240. {
  241. ds_main_acntcode_acntcodelist.copyData(ds_target_validation_acntcodelist);
  242. }
  243. fSetReadOnly();
  244. }
  245. //==============================================================
  246. // 읽기전용 컬럼 세팅
  247. //==============================================================
  248. function fSetReadOnly()
  249. {
  250. // for(var i = 0; i < ds_main_acntcode_acntcodelist.rowcount; i++)
  251. // {
  252. // if(ds_main_acntcode_acntcodelist.getColumn(i, "bugtyn") == "N")
  253. // {
  254. // grd_acntlist.isReadOnly(i, grd_acntlist.colRef("chk")) = true;
  255. //
  256. // }
  257. // }
  258. }
  259. //==============================================================
  260. // 계정항목 PopUp
  261. //==============================================================
  262. function fOpenPopupAcntHelp(pObj, sRecv)
  263. {
  264. misfOpenPopUpList("05", pObj, "", sRecv);
  265. }
  266. function group3_grd_acntlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  267. {
  268. if( e.row >= 0 && e.col >= 0 )
  269. {
  270. btn_confirm_onclick();
  271. }
  272. }
  273. function btn_confirm_onclick(obj:Button, e:ClickEventInfo)
  274. {
  275. ds_source.setColumn(0, "projectid", ds_main_acntcode_acntcodelist.getColumn(ds_main_acntcode_acntcodelist.rowposition, "projectid"));
  276. misfPopUpListReturn(group3.grd_acntlist);
  277. }
  278. function group3_group4_ipt_acntcd_onkeydown(obj:Edit, e:KeyEventInfo)
  279. {
  280. if(e.keycode == 13)
  281. {
  282. group3.group4.ipt_acntcd.updateToDataset();
  283. group3_group4_btn_search_onclick();
  284. }
  285. }
  286. function group3_group4_btn_search_onclick(obj:Button, e:ClickEventInfo)
  287. {
  288. misfMsterDetailRetrieve();
  289. fSetReadOnly();
  290. }
  291. function btn_cancel_onclick(obj:Button, e:ClickEventInfo)
  292. {
  293. this.close();
  294. }
  295. ]]></Script>
  296. </Form>
  297. </FDL>