SMRBP01900_예산집행실적총괄(월별).xfdl 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRBP01900" position="absolute 0 0 1200 750" titletext="예산집행실적총괄(월별)" oninit="SMRBP01900_oninit" onload="SMRBP01900_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption6" text="예산집행실적총괄(월별)" class="tit_1" position="absolute 0 0 250 25"/>
  8. <Button id="btn_print" taborder="1" text="출력" class="btn6" position="absolute 1062 96 1112 116" anchor="top right" onclick="btn_print_onclick"/>
  9. <Button id="btn_5" taborder="2" text="엑셀저장" class="btn7" position="absolute 1113 96 1193 116" anchor="top right" onclick="btn_5_onclick"/>
  10. <Static id="caption2" text="예산집행실적총괄(월별)" class="tit_2" position="absolute 0 100 167 121"/>
  11. <Shape id="line1" class="line_10" position="absolute 0 116 1195 122" anchor="left top right"/>
  12. <Grid id="grd_bugtexecist" taborder="3" binddataset="ds_main_list_datalist" useinputpanel="false" position="absolute 0 121 1194 741" autoenter="select" cellsizingtype="col" anchor="all">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="20"/>
  17. <Column size="80"/>
  18. <Column size="80"/>
  19. <Column size="90"/>
  20. <Column size="150"/>
  21. <Column size="100"/>
  22. <Column size="100"/>
  23. <Column size="100"/>
  24. <Column size="100"/>
  25. <Column size="100"/>
  26. <Column size="100"/>
  27. <Column size="100"/>
  28. <Column size="100"/>
  29. <Column size="100"/>
  30. <Column size="100"/>
  31. <Column size="100"/>
  32. <Column size="100"/>
  33. <Column size="100"/>
  34. <Column size="100"/>
  35. <Column size="100"/>
  36. <Column size="100"/>
  37. <Column size="100"/>
  38. <Column size="100"/>
  39. <Column size="0"/>
  40. <Column size="0"/>
  41. </Columns>
  42. <Rows>
  43. <Row size="24" band="head"/>
  44. <Row size="24" band="head"/>
  45. <Row size="24"/>
  46. </Rows>
  47. <Band id="head">
  48. <Cell rowspan="2" celltype="head" taborder="undefined"/>
  49. <Cell col="1" colspan="4" text="계정과목" taborder="undefined"/>
  50. <Cell col="5" rowspan="2" text="조정후예산액" taborder="undefined"/>
  51. <Cell col="6" rowspan="2" text="배정누계" taborder="undefined"/>
  52. <Cell col="7" rowspan="2" text="집행실적" taborder="undefined"/>
  53. <Cell col="8" rowspan="2" text="예산대비&#10;집행잔액" taborder="undefined"/>
  54. <Cell col="9" rowspan="2" text="누계대비&#10;집행잔액" taborder="undefined"/>
  55. <Cell col="10" rowspan="2" text="배정잔액" taborder="undefined"/>
  56. <Cell col="11" colspan="12" text="월별집행실적" taborder="undefined"/>
  57. <Cell col="23" text="예산년도"/>
  58. <Cell col="24" text="구분"/>
  59. <Cell row="1" col="1" text="관"/>
  60. <Cell row="1" col="2" text="항"/>
  61. <Cell row="1" col="3" text="목"/>
  62. <Cell row="1" col="4" text="세목"/>
  63. <Cell row="1" col="11" text="1월"/>
  64. <Cell row="1" col="12" text="2월"/>
  65. <Cell row="1" col="13" text="3월"/>
  66. <Cell row="1" col="14" text="4월"/>
  67. <Cell row="1" col="15" text="5월"/>
  68. <Cell row="1" col="16" text="6월"/>
  69. <Cell row="1" col="17" text="7월"/>
  70. <Cell row="1" col="18" text="8월"/>
  71. <Cell row="1" col="19" text="9월"/>
  72. <Cell row="1" col="20" text="10월"/>
  73. <Cell row="1" col="21" text="11월"/>
  74. <Cell row="1" col="22" text="12월"/>
  75. <Cell row="1" col="23" text="예산년도"/>
  76. <Cell row="1" col="24" text="구분"/>
  77. </Band>
  78. <Band id="body">
  79. <Cell celltype="head" expr="currow+1"/>
  80. <Cell col="1" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:supacntnm2" editautoselect="true" suppress="1" suppressalign="first"/>
  81. <Cell col="2" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:supacntnm3" editautoselect="true" suppress="2" suppressalign="first,over"/>
  82. <Cell col="3" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:supacntnm4" editautoselect="true" suppress="3" suppressalign="first,over"/>
  83. <Cell col="4" style="align:left middle;padding:2 2 2 2;background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:acntnm" editautoselect="true" suppress="4" suppressalign="first,over"/>
  84. <Cell col="5" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:totalrevsupmbugtamt" editautoselect="true"/>
  85. <Cell col="6" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:quarterorgbugtamt" editautoselect="true"/>
  86. <Cell col="7" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:totalbugtexecamt" editautoselect="true"/>
  87. <Cell col="8" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:janamt1" editautoselect="true"/>
  88. <Cell col="9" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:janamt2" editautoselect="true"/>
  89. <Cell col="10" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:janamt3" editautoselect="true"/>
  90. <Cell col="11" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:jan" editautoselect="true"/>
  91. <Cell col="12" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:feb" editautoselect="true"/>
  92. <Cell col="13" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:mar" editautoselect="true"/>
  93. <Cell col="14" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:apr" editautoselect="true"/>
  94. <Cell col="15" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:may" editautoselect="true"/>
  95. <Cell col="16" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:jun" editautoselect="true"/>
  96. <Cell col="17" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:jul" editautoselect="true"/>
  97. <Cell col="18" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:aug" editautoselect="true"/>
  98. <Cell col="19" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:sep" editautoselect="true"/>
  99. <Cell col="20" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:oct" editautoselect="true"/>
  100. <Cell col="21" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:nov" editautoselect="true"/>
  101. <Cell col="22" displaytype="number" style="background:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');background2:EXPR(gubn == '0' ? '#ff99cc' : gubn == '1' ? '#ffcc99' : gubn == '2' ? '#ffff99' : gubn == '3' ? '#ccffcc' : gubn == '4' ? '#ffffff' : gubn == '5' ? '#ffffff' : '');" text="bind:dec" editautoselect="true"/>
  102. <Cell col="23" text="bind:acntyy"/>
  103. <Cell col="24" text="bind:gubn"/>
  104. </Band>
  105. </Format>
  106. </Formats>
  107. </Grid>
  108. <Div id="group2" taborder="4" class="div_SA" position="absolute 0 25 1194 85" anchor="left top right">
  109. <Layouts>
  110. <Layout>
  111. <Static id="caption9" text="예산년도 :" class="search_name" position="absolute 365 8 451 25" anchor="default"/>
  112. <Button id="btn_search" taborder="28" text="조회" class="btn1" position="absolute 1123 21 1179 43" anchor="top right" onclick="group2_btn_search_onclick"/>
  113. <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1104 8 1110 53" anchor="top right"/>
  114. <Edit id="ipt_acntyy" taborder="29" class="input_s_essential" position="absolute 455 7 555 26" anchor="default" autoselect="true" autoskip="true" maxlength="4" style="align:center middle;"/>
  115. <Combo id="cmb_instcd" taborder="30" class="combo_search" position="absolute 102 7 255 26" anchor="default"/>
  116. <Static id="caption8" text="소속기관 :" class="search_name" position="absolute 14 8 100 25" anchor="default"/>
  117. <Radio id="rdo_bugtflag" taborder="31" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 454 33 660 53" anchor="default" onitemchanged="group2_rdo_bugtflag_onitemchanged">
  118. <Dataset id="innerdataset">
  119. <ColumnInfo>
  120. <Column id="codecolumn"/>
  121. <Column id="datacolumn"/>
  122. </ColumnInfo>
  123. <Rows>
  124. <Row>
  125. <Col id="codecolumn">1</Col>
  126. <Col id="datacolumn">수입</Col>
  127. </Row>
  128. <Row>
  129. <Col id="codecolumn">2</Col>
  130. <Col id="datacolumn">비용</Col>
  131. </Row>
  132. <Row>
  133. <Col id="codecolumn">3</Col>
  134. <Col id="datacolumn">구매</Col>
  135. </Row>
  136. <Row>
  137. <Col id="codecolumn">4</Col>
  138. <Col id="datacolumn">자본</Col>
  139. </Row>
  140. </Rows>
  141. </Dataset>
  142. </Radio>
  143. <Static id="caption5" text="예산구분 :" class="search_name" position="absolute 365 35 452 52" anchor="default"/>
  144. <Edit id="ipt_depthngnm" taborder="32" class="input_search" enable="false" position="absolute 183 33 333 52" anchor="default"/>
  145. <Button id="btn_depthelp" taborder="33" class="icon_search" position="absolute 162 34 178 50" anchor="default" onclick="group2_btn_depthelp_onclick"/>
  146. <Static id="caption3" text="부서 :" class="search_name" position="absolute 14 34 121 51" anchor="default"/>
  147. <Edit id="ipt_deptcd" taborder="34" class="input_s_essential" position="absolute 78 33 158 52" anchor="default" autoselect="true" autoskip="true"/>
  148. <Button id="button4" taborder="35" text="찾기" class="btn2" position="absolute 914 33 956 52" anchor="default" onclick="group2_button4_onclick"/>
  149. <Static id="caption1" text="조 회 :" class="search_name" position="absolute 689 34 800 51" anchor="default"/>
  150. <Edit id="input1" taborder="36" class="input_s_essential" position="absolute 779 33 909 52" anchor="default" autoselect="true" autoskip="true" onkeydown="group2_input1_onkeydown"/>
  151. </Layout>
  152. </Layouts>
  153. </Div>
  154. </Layout>
  155. </Layouts>
  156. <Objects>
  157. <Dataset id="ds_send_retrparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  158. <ColumnInfo>
  159. <Column id="instcd" type="STRING" size="256"/>
  160. <Column id="acntyy" type="STRING" size="256"/>
  161. <Column id="deptcd" type="STRING" size="256"/>
  162. <Column id="depthngnm" type="STRING" size="256"/>
  163. <Column id="bugtflag" type="STRING" size="256"/>
  164. <Column id="quarter" type="STRING" size="256"/>
  165. </ColumnInfo>
  166. <Rows>
  167. <Row>
  168. <Col id="instcd"/>
  169. <Col id="acntyy"/>
  170. <Col id="deptcd"/>
  171. <Col id="depthngnm"/>
  172. <Col id="bugtflag"/>
  173. <Col id="quarter"/>
  174. </Row>
  175. </Rows>
  176. </Dataset>
  177. <Dataset id="ds_main_list_datalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  178. <ColumnInfo>
  179. <Column id="acntyy" type="STRING" size="256" sumtext="예산년도"/>
  180. <Column id="gubn" type="STRING" size="256" sumtext="예산년도"/>
  181. <Column id="supacntnm2" type="STRING" size="256" sumtext="예산년도"/>
  182. <Column id="supacntnm3" type="STRING" size="256" sumtext="예산년도"/>
  183. <Column id="supacntnm4" type="STRING" size="256" sumtext="예산년도"/>
  184. <Column id="acntnm" type="STRING" size="256" sumtext="예산년도"/>
  185. <Column id="totalrevsupmbugtamt" type="STRING" size="256" sumtext="예산년도"/>
  186. <Column id="quarterorgbugtamt" type="STRING" size="256" sumtext="예산년도"/>
  187. <Column id="totalbugtexecamt" type="STRING" size="256" sumtext="예산년도"/>
  188. <Column id="janamt1" type="STRING" size="256" sumtext="예산년도"/>
  189. <Column id="janamt2" type="STRING" size="256" sumtext="예산년도"/>
  190. <Column id="janamt3" type="STRING" size="256" sumtext="예산년도"/>
  191. <Column id="jan" type="STRING" size="256" sumtext="예산년도"/>
  192. <Column id="feb" type="STRING" size="256" sumtext="예산년도"/>
  193. <Column id="mar" type="STRING" size="256" sumtext="예산년도"/>
  194. <Column id="apr" type="STRING" size="256" sumtext="예산년도"/>
  195. <Column id="may" type="STRING" size="256" sumtext="예산년도"/>
  196. <Column id="jun" type="STRING" size="256" sumtext="예산년도"/>
  197. <Column id="jul" type="STRING" size="256" sumtext="예산년도"/>
  198. <Column id="aug" type="STRING" size="256" sumtext="예산년도"/>
  199. <Column id="sep" type="STRING" size="256" sumtext="예산년도"/>
  200. <Column id="oct" type="STRING" size="256" sumtext="예산년도"/>
  201. <Column id="nov" type="STRING" size="256" sumtext="예산년도"/>
  202. <Column id="dec" type="STRING" size="256" sumtext="예산년도"/>
  203. </ColumnInfo>
  204. </Dataset>
  205. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  206. <ColumnInfo>
  207. <Column id="date" type="STRING" size="256"/>
  208. </ColumnInfo>
  209. <Rows>
  210. <Row/>
  211. </Rows>
  212. </Dataset>
  213. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  214. <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  215. <ColumnInfo>
  216. <Column id="nm" type="STRING" size="256"/>
  217. </ColumnInfo>
  218. <Rows>
  219. <Row/>
  220. </Rows>
  221. </Dataset>
  222. <Dataset id="ds_popdept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  223. <ColumnInfo>
  224. <Column id="instcd" type="STRING" size="256"/>
  225. <Column id="selectyn" type="STRING" size="256"/>
  226. <Column id="deptcd" type="STRING" size="256"/>
  227. <Column id="depthngnm" type="STRING" size="256"/>
  228. </ColumnInfo>
  229. <Rows>
  230. <Row>
  231. <Col id="instcd"/>
  232. <Col id="selectyn"/>
  233. <Col id="deptcd"/>
  234. <Col id="depthngnm"/>
  235. </Row>
  236. </Rows>
  237. </Dataset>
  238. </Objects>
  239. <Bind>
  240. <BindItem id="item0" compid="group2.cmb_instcd" propid="value" datasetid="ds_send_retrparams" columnid="instcd"/>
  241. <BindItem id="item1" compid="group2.ipt_acntyy" propid="value" datasetid="ds_send_retrparams" columnid="acntyy"/>
  242. <BindItem id="item2" compid="group2.ipt_deptcd" propid="value" datasetid="ds_send_retrparams" columnid="deptcd"/>
  243. <BindItem id="item3" compid="group2.ipt_depthngnm" propid="value" datasetid="ds_send_retrparams" columnid="depthngnm"/>
  244. <BindItem id="item4" compid="group2.rdo_bugtflag" propid="value" datasetid="ds_send_retrparams" columnid="bugtflag"/>
  245. <BindItem id="item5" compid="group2.input1" propid="value" datasetid="ds_send_search" columnid="nm"/>
  246. </Bind>
  247. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  248. * System Name :
  249. * Job Name :
  250. * Creator :
  251. * Make Date : 2017-06-19
  252. * Description :
  253. *---------------------------------------------------------------------------------------
  254. * Modify Date Modifier Modify Description
  255. *---------------------------------------------------------------------------------------
  256. * 2017-06-19 Live Converter TF->XP
  257. *
  258. *---------------------------------------------------------------------------------------
  259. ****************************************************************************************/
  260. include "com_commonxp::comm_main.xjs";
  261. include "mis_miscommonxp::MIS.xjs";
  262. include "mis_acntcommonxp::RAD001.xjs";
  263. include "mis_miscommonxp::RAC001.xjs";
  264. include "mis_bugtcommonxp::RBC001.xjs";
  265. var acntdept = "";
  266. var bugtdept = "";
  267. var Deptcd = sysf_getUserInfo("dutplcecd");
  268. var Deptnm = sysf_getUserInfo("dutplcenm");
  269. function SMRBP01900_oninit(obj:Form, e:InitEventInfo)
  270. {
  271. frmf_initForm(obj);
  272. }
  273. function SMRBP01900_onload(obj:Form, e:LoadEventInfo)
  274. {
  275. grdf_initGrid(grd_bugtexecist);
  276. fCheckAuth();
  277. fInitialize();
  278. }
  279. function fCheckAuth()
  280. {
  281. group2.btn_search.enable = frmf_checkAuth("R");
  282. }
  283. function fInitialize()
  284. {
  285. ds_main_list_datalist.clearData();
  286. misfComboComCdListMulti("Z0007","group2.cmb_instcd");
  287. ds_send_retrparams.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
  288. ds_send.setColumn(0, "date", utlf_getCurrentDate());
  289. racfGetCadlYmd("ds_send", "ds_temp");
  290. ds_send_retrparams.setColumn(0, "acntyy", utlf_getCurrentDate().toString().substr(0,4));
  291. ds_send_retrparams.setColumn(0, "deptcd", Deptcd);
  292. ds_send_retrparams.setColumn(0, "depthngnm", Deptnm);
  293. group2.rdo_bugtflag.value = "2";
  294. group2.ipt_deptcd.setFocus();
  295. }
  296. function group2_btn_depthelp_onclick(obj:Button, e:ClickEventInfo)
  297. {
  298. ds_popdept.clearData();
  299. ds_popdept.addRow();
  300. ds_popdept.setColumn(0, "instcd", group2.cmb_instcd.value);
  301. ds_popdept.setColumn(0, "selectyn", "");
  302. var objArg = new Object();
  303. objArg.arg_ds_popdata = ds_popdept;
  304. frmf_modal("SPRBP00100", "SPRBP00100", objArg, "", "", "", "", "", "", "", "", "", "M");
  305. if(ds_popdept.getColumn(0, "selectyn")== "Y")
  306. {
  307. group2.ipt_deptcd.value = ds_popdept.getColumn(0, "deptcd");
  308. group2.ipt_depthngnm.value = ds_popdept.getColumn(0, "depthngnm");
  309. }
  310. }
  311. function group2_rdo_bugtflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  312. {
  313. group2.btn_search.click();
  314. }
  315. function group2_input1_onkeydown(obj:Edit, e:KeyEventInfo)
  316. {
  317. if(e.keycode == 13)
  318. {
  319. obj.updateToDataset();
  320. group2.button4.click();
  321. }
  322. }
  323. function group2_button4_onclick(obj:Button, e:ClickEventInfo)
  324. {
  325. var vPrntnmCol = "acntnm";
  326. var searchnm = ds_send_search.getColumn(0, "nm");
  327. var findRow = ds_main_list_datalist.findRow(vPrntnmCol, searchnm);
  328. ds_main_list_datalist.rowposition = findRow;
  329. }
  330. function group2_btn_search_onclick(obj:Button, e:ClickEventInfo)
  331. {
  332. ds_main_list_datalist.clearData();
  333. var oParam = {};
  334. oParam.id = "TRRBP01901";
  335. oParam.service = "bugtexecapp.BugtExec";
  336. oParam.method = "reqGetBugtExecMonsList";
  337. oParam.inds = "req=ds_send_retrparams";
  338. oParam.outds = "ds_main_list_datalist=datalist";
  339. oParam.async = false;
  340. //oParam.callback = "cf_TRRBP01901";
  341. tranf_submit(oParam);
  342. }
  343. function btn_print_onclick(obj:Button, e:ClickEventInfo)
  344. {
  345. fPrint();
  346. }
  347. function fPrint()
  348. {
  349. var objDOM = rptf_createDOM();
  350. rptf_setNodeListToDOM(objDOM, "/root/main/list/datalist", ds_main_list_datalist);
  351. rptf_setNodeListToDOM(objDOM, "/root/send/retrparams", ds_send_retrparams);
  352. var objParam = new Object();
  353. objParam.xml_data_XML1 = objDOM.documentElement.source;
  354. var option = "";
  355. rptf_exeReportPreview30(["RPRBP01900"],[objParam], option);
  356. }
  357. function btn_5_onclick(obj:Button, e:ClickEventInfo)
  358. {
  359. grdf_exportExcel(grd_bugtexecist, "excel", "see", false);
  360. }
  361. ]]></Script>
  362. </Form>
  363. </FDL>