SMRIM00100_과제종류별 세목.xfdl 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRIM00100" position="absolute 0 0 1156 703" titletext="과제종류별 세목" onload="SMRIM00100_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption10" class="tit_1" position="absolute 0 0 160 26" style="" text="과제종류별 세목"/>
  8. <Static id="caption_cdgrup_list" class="tit_2" position="absolute 0 29 118 45" style="" text="과제종류" anchor="left top"/>
  9. <Static id="caption1" class="tit_2" position="absolute 249 29 307 45" style="" text="분류"/>
  10. <Grid id="grd_acntlist" binddataset="ds_main_cond_acntinfo_acntlist" visible="true" position="absolute 0 55 245 700" style="align:center middle;" oncelldblclick="grd_acntlist_oncelldblclick" anchor="left top bottom" autofittype="col">
  11. <Formats>
  12. <Format id="default">
  13. <Columns>
  14. <Column size="220"/>
  15. <Column size="0"/>
  16. </Columns>
  17. <Rows>
  18. <Row size="24" band="head"/>
  19. <Row size="24"/>
  20. </Rows>
  21. <Band id="head">
  22. <Cell text="과제종류"/>
  23. <Cell col="1" text="acntcd"/>
  24. </Band>
  25. <Band id="body">
  26. <Cell style="align:left middle;" text="bind:acntnm"/>
  27. <Cell col="1" text="bind:acntcd"/>
  28. </Band>
  29. </Format>
  30. </Formats>
  31. </Grid>
  32. <Grid id="grd_detl" binddataset="ds_main_cond_acntdetinfo" position="absolute 249 55 1154 700" style="align:center ;" anchor="all" autofittype="col">
  33. <Formats>
  34. <Format id="default">
  35. <Columns>
  36. <Column size="191"/>
  37. <Column size="231"/>
  38. <Column size="114"/>
  39. <Column size="0"/>
  40. <Column size="0"/>
  41. <Column size="0"/>
  42. <Column size="0"/>
  43. <Column size="0"/>
  44. <Column size="0"/>
  45. <Column size="0"/>
  46. <Column size="0"/>
  47. <Column size="0"/>
  48. </Columns>
  49. <Rows>
  50. <Row size="24" band="head"/>
  51. <Row size="24"/>
  52. </Rows>
  53. <Band id="head">
  54. <Cell text="중분류"/>
  55. <Cell col="1" text="소분류(계정명)"/>
  56. <Cell col="2" text="계정코드"/>
  57. <Cell col="3" text="supacntcd2"/>
  58. <Cell col="4" text="supacntcd3"/>
  59. <Cell col="5" text="supacntcd4"/>
  60. <Cell col="6" text="supacntcd5"/>
  61. <Cell col="7" text="계정과목코드"/>
  62. <Cell col="8" text="목 코드"/>
  63. <Cell col="9" text="세목 코드"/>
  64. <Cell col="10" text="입출금 구분"/>
  65. <Cell col="11" text="금액코드"/>
  66. </Band>
  67. <Band id="body">
  68. <Cell text="bind:lrgnm" suppress="1" suppressalign="middle,over"/>
  69. <Cell col="1" style="align:left middle;" text="bind:mdlnm" taborder="0" suppress="2" suppressalign="middle,over"/>
  70. <Cell col="2" text="bind:mdlcd" taborder="3" suppress="3" suppressalign="middle,over"/>
  71. <Cell col="3" text="bind:supacntcd2"/>
  72. <Cell col="4" text="bind:supacntcd3"/>
  73. <Cell col="5" text="bind:supacntcd4"/>
  74. <Cell col="6" text="bind:supacntcd5"/>
  75. <Cell col="7" text="bind:acntcd"/>
  76. <Cell col="8" text="bind:lrgcd"/>
  77. <Cell col="9" text="bind:mdlcd"/>
  78. <Cell col="10" text="bind:bizflag"/>
  79. <Cell col="11" text="bind:amtcd"/>
  80. </Band>
  81. </Format>
  82. </Formats>
  83. </Grid>
  84. <Shape id="line4" class="line_1" linetype="horizontal" position="absolute 0 50 246 53" style="" anchor="left top" type="rectangle"/>
  85. <Shape id="line1" class="line_1" linetype="horizontal" position="absolute 249 50 1153 53" style="" anchor="left top right" type="rectangle"/>
  86. <Radio datacolumn="datacolumn" codecolumn="codecolumn" columncount="-1" rowcount="-1" id="radio1" position="absolute 312 26 422 46" style="" onitemchanged="radio1_onitemchanged">
  87. <Dataset id="innerdataset">
  88. <ColumnInfo>
  89. <Column id="codecolumn"/>
  90. <Column id="datacolumn"/>
  91. </ColumnInfo>
  92. <Rows>
  93. <Row>
  94. <Col id="codecolumn">O</Col>
  95. <Col id="datacolumn">비용</Col>
  96. </Row>
  97. <Row>
  98. <Col id="codecolumn">I</Col>
  99. <Col id="datacolumn">수익</Col>
  100. </Row>
  101. </Rows>
  102. </Dataset>
  103. </Radio>
  104. <Button id="button1" class="btn7" position="absolute 1084 30 1153 49" style="" text="Excel" onclick="button1_onclick" anchor="top right"/>
  105. </Layout>
  106. </Layouts>
  107. <Objects>
  108. <Dataset id="ds_main_cond_acntdetinfo_acntdetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  109. <ColumnInfo>
  110. <Column id="supacnt2nm" type="STRING" size="256"/>
  111. <Column id="supacnt3nm" type="STRING" size="256"/>
  112. <Column id="supacnt4nm" type="STRING" size="256"/>
  113. <Column id="supacnt5nm" type="STRING" size="256"/>
  114. <Column id="acntnm" type="STRING" size="256"/>
  115. <Column id="lrgnm" type="STRING" size="256"/>
  116. <Column id="mdlnm" type="STRING" size="256"/>
  117. <Column id="supacntcd2" type="STRING" size="256"/>
  118. <Column id="supacntcd3" type="STRING" size="256"/>
  119. <Column id="supacntcd4" type="STRING" size="256"/>
  120. <Column id="supacntcd5" type="STRING" size="256"/>
  121. <Column id="acntcd" type="STRING" size="256"/>
  122. <Column id="lrgcd" type="STRING" size="256"/>
  123. <Column id="mdlcd" type="STRING" size="256"/>
  124. <Column id="bizflag" type="STRING" size="256"/>
  125. <Column id="amtcd" type="STRING" size="256"/>
  126. </ColumnInfo>
  127. <Rows>
  128. <Row>
  129. <Col id="supacnt2nm"/>
  130. <Col id="supacnt3nm"/>
  131. <Col id="supacnt4nm"/>
  132. <Col id="supacnt5nm"/>
  133. <Col id="acntnm"/>
  134. <Col id="lrgnm"/>
  135. <Col id="mdlnm"/>
  136. <Col id="supacntcd2"/>
  137. <Col id="supacntcd3"/>
  138. <Col id="supacntcd4"/>
  139. <Col id="supacntcd5"/>
  140. <Col id="acntcd"/>
  141. <Col id="lrgcd"/>
  142. <Col id="mdlcd"/>
  143. <Col id="bizflag"/>
  144. <Col id="amtcd"/>
  145. </Row>
  146. </Rows>
  147. </Dataset>
  148. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  149. <ColumnInfo>
  150. <Column id="hidden" type="STRING" size="256"/>
  151. </ColumnInfo>
  152. <Rows>
  153. <Row>
  154. <Col id="hidden"/>
  155. </Row>
  156. </Rows>
  157. </Dataset>
  158. <Dataset id="ds_main_cond_acntinfo_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  159. <ColumnInfo>
  160. <Column id="acntnm" type="STRING" size="256"/>
  161. <Column id="acntcd" type="STRING" size="256"/>
  162. </ColumnInfo>
  163. <Rows>
  164. <Row>
  165. <Col id="acntnm"/>
  166. <Col id="acntcd"/>
  167. </Row>
  168. </Rows>
  169. </Dataset>
  170. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  171. <ColumnInfo>
  172. <Column id="init" type="STRING" size="256"/>
  173. </ColumnInfo>
  174. </Dataset>
  175. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  176. <ColumnInfo/>
  177. </Dataset>
  178. <Dataset id="ds_main_cond_acntdetinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  179. <ColumnInfo/>
  180. </Dataset>
  181. <Dataset id="ds_main_cond_acntinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  182. <ColumnInfo/>
  183. </Dataset>
  184. <Dataset id="ds_resrchdept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  185. <ColumnInfo>
  186. <Column id="resrchdept" type="STRING" size="256"/>
  187. </ColumnInfo>
  188. <Rows>
  189. <Row>
  190. <Col id="resrchdept"/>
  191. </Row>
  192. </Rows>
  193. </Dataset>
  194. <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  195. <ColumnInfo>
  196. <Column id="bizflag" type="STRING" size="256"/>
  197. </ColumnInfo>
  198. <Rows>
  199. <Row>
  200. <Col id="bizflag">O</Col>
  201. </Row>
  202. </Rows>
  203. </Dataset>
  204. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  205. <ColumnInfo>
  206. <Column id="send" type="STRING" size="256"/>
  207. </ColumnInfo>
  208. <Rows>
  209. <Row>
  210. <Col id="send"/>
  211. </Row>
  212. </Rows>
  213. </Dataset>
  214. </Objects>
  215. <Bind>
  216. <BindItem id="item0" compid="radio1" propid="value" datasetid="ds_main_cond" columnid="bizflag"/>
  217. </Bind>
  218. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  219. * System Name :
  220. * Job Name :
  221. * Creator :
  222. * Make Date : 2017-01-10
  223. * Description :
  224. *---------------------------------------------------------------------------------------
  225. * Modify Date Modifier Modify Description
  226. *---------------------------------------------------------------------------------------
  227. * 2018-01-10 Live Converter TF->XP
  228. *
  229. *---------------------------------------------------------------------------------------
  230. ****************************************************************************************/
  231. include "com_commonxp::comm_main.xjs";
  232. function SMRIM00100_onload(obj:Form, e:LoadEventInfo) {
  233. frmf_initForm(obj);
  234. grdf_initGrid(grd_acntlist);
  235. grdf_initGrid(grd_detl);
  236. //grdf_setGridSort(grd_XXX);
  237. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  238. ds_send.clearData();
  239. dsf_makeValue( ds_send, "cdgrupid", "string", "I0011");
  240. var oParam = {};
  241. oParam.id = "TRRIM00110";
  242. oParam.service = "ctmsapp.StudyProjMngt";
  243. oParam.method = "reqGetAcntList";
  244. oParam.inds = "req=ds_send";
  245. oParam.outds = "ds_main_cond_acntinfo_acntlist=acntlist";
  246. oParam.async = false;
  247. //oParam.callback = "cf_TRRIM00110";
  248. tranf_submit(oParam);
  249. }
  250. function grd_acntlist_oncelldblclick(obj:Grid, e:GridClickEventInfo) {
  251. var cRow = ds_main_cond_acntinfo_acntlist.rowposition;
  252. ds_send.clearData();
  253. dsf_makeValue( ds_send, "acntcd", "string", ds_main_cond_acntinfo_acntlist.getColumn(cRow, "acntcd") );
  254. dsf_makeValue( ds_send, "bizflag", "string", ds_main_cond.getColumn(0, "bizflag") );
  255. var oParam = {};
  256. oParam.id = "TRRIM00120";
  257. oParam.service = "ctmsapp.StudyProjMngt";
  258. oParam.method = "reqGetAcntDetail";
  259. oParam.inds = "req=ds_send";
  260. oParam.outds = "ds_main_cond_acntdetinfo=acntdetlist";
  261. oParam.async = false;
  262. //oParam.callback = "cf_TRRIM00120";
  263. tranf_submit(oParam);
  264. }
  265. function radio1_onitemchanged(obj:Radio, e:ItemChangeEventInfo) {
  266. grd_acntlist_oncelldblclick(grd_acntlist);
  267. }
  268. function button1_onclick(obj:Button, e:ClickEventInfo) {
  269. if(ds_main_cond_acntdetinfo_acntdetlist.rowcount == 0)
  270. {
  271. sysf_messageBox("엑셀저장할 내역이", "I004"); ///엑셀저장할 내역이 없습니다.
  272. }
  273. else
  274. {
  275. var sPrntDD = utlf_getCurrentDate();
  276. grdf_exportExcel(grd_detl, "과제종류별 세목", "see");
  277. }
  278. }
  279. ]]></Script>
  280. </Form>
  281. </FDL>