SMRBQ00700_분기별추경예산신청.xfdl 71 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRBQ00700" position="absolute 0 0 1199 794" titletext="추경 예산 신청" oninit="SMRBQ00700_oninit" onload="SMRBQ00700_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption6" text="분기별 추경예산 신청" class="tit_1" position="absolute 0 0 230 25"/>
  8. <Button id="btn_cancel" taborder="1" text="신청취소" class="btn4" visible="false" position="absolute 820 24 900 46" anchor="top right" onclick="btn_cancel_onclick"/>
  9. <Button id="btn_alldel" taborder="2" text="전체삭제" class="btn4" position="absolute 905 24 985 46" anchor="top right" onclick="btn_alldel_onclick"/>
  10. <Button id="btn_excelupload" taborder="3" text="엑셀저장" class="btn4" position="absolute 990 24 1070 46" anchor="top right" onclick="btn_excelupload_onclick"/>
  11. <Button id="btn_save" taborder="4" text="저장" class="btn4" enable="false" position="absolute 1075 24 1131 46" anchor="top right" onclick="btn_save_onclick"/>
  12. <Button id="btn_app" taborder="5" text="신청" class="btn4" enable="false" position="absolute 1135 24 1191 46" anchor="top right" onclick="btn_app_onclick"/>
  13. <Div id="group4" taborder="6" class="div_SA2" position="absolute 0 52 1194 92" anchor="left top right">
  14. <Layouts>
  15. <Layout>
  16. <Static id="caption7" text="예산년도 :" class="search_name" position="absolute 16 11 102 28"/>
  17. <Static id="caption8" text="부서 :" class="search_name" position="absolute 421 11 528 28"/>
  18. <Shape id="line4" linetype="vertical" class="line_4" position="absolute 1104 9 1110 31" anchor="top right"/>
  19. <Edit id="ipt_depthngnm" taborder="28" class="input_s_essential" position="absolute 590 10 740 29" autoselect="true" autoskip="true" onkeydown="group4_ipt_depthngnm_onkeydown"/>
  20. <Button id="btn_depthelp" taborder="29" class="icon_search" position="absolute 569 10 585 26"/>
  21. <Edit id="ipt_deptcd" taborder="30" class="input_s_essential" position="absolute 485 10 565 29" autoselect="true" autoskip="true" onkeydown="group4_ipt_deptcd_onkeydown"/>
  22. <Button id="btn_search" taborder="31" text="조회" class="btn1" position="absolute 1124 8 1180 30" anchor="top right" onclick="group4_btn_search_onclick"/>
  23. <Static id="caption5" text="예산구분 :" class="search_name" position="absolute 765 11 852 28"/>
  24. <Radio id="rdo_bugtflag" taborder="32" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 854 9 1105 29" onitemchanged="group4_rdo_bugtflag_onitemchanged">
  25. <Dataset id="innerdataset">
  26. <ColumnInfo>
  27. <Column id="codecolumn"/>
  28. <Column id="datacolumn"/>
  29. </ColumnInfo>
  30. <Rows>
  31. <Row>
  32. <Col id="codecolumn">1</Col>
  33. <Col id="datacolumn">수입</Col>
  34. </Row>
  35. <Row>
  36. <Col id="codecolumn">2</Col>
  37. <Col id="datacolumn">비용</Col>
  38. </Row>
  39. <Row>
  40. <Col id="codecolumn">3</Col>
  41. <Col id="datacolumn">구매</Col>
  42. </Row>
  43. <Row>
  44. <Col id="codecolumn">4</Col>
  45. <Col id="datacolumn">자본</Col>
  46. </Row>
  47. </Rows>
  48. </Dataset>
  49. </Radio>
  50. <Button id="button5" taborder="33" class="icon_next" position="absolute 195 11 208 26" onclick="group4_button5_onclick"/>
  51. <Edit id="ipt_acntyy" taborder="34" class="input_s_essential" position="absolute 125 10 193 29" autoselect="true" autoskip="true" style="align:center middle;"/>
  52. <Button id="btn_pre" taborder="35" class="icon_pre" position="absolute 110 11 123 26" onclick="group4_btn_pre_onclick"/>
  53. <Combo id="cmb_quarter" taborder="36" innerdataset="@ds_init_baseinfo_quarter" codecolumn="cd" datacolumn="nm" class="combo_s_essential" position="absolute 295 10 395 29" onitemchanged="group4_cmb_quarter_onitemchanged"/>
  54. <Static id="caption2" text="분기 :" class="search_name" position="absolute 231 11 338 28"/>
  55. </Layout>
  56. </Layouts>
  57. </Div>
  58. <Static id="caption10" text="분기별 추경예산 신청현황" class="tit_2" position="absolute 0 460 178 482" anchor="left bottom"/>
  59. <Grid id="grd_revbugtapplist" taborder="7" binddataset="ds_main_bugtlist_revbugtapplist" useinputpanel="false" position="absolute 0 481 585 785" anchor="left right bottom" autoenter="select" autofittype="col" cellsizingtype="col" oncellclick="grd_revbugtapplist_oncellclick" onexpanddown="grd_revbugtapplist_onexpanddown">
  60. <Formats>
  61. <Format id="default">
  62. <Columns>
  63. <Column size="26"/>
  64. <Column size="0"/>
  65. <Column size="0"/>
  66. <Column size="0"/>
  67. <Column size="0"/>
  68. <Column size="0"/>
  69. <Column size="0"/>
  70. <Column size="0"/>
  71. <Column size="90"/>
  72. <Column size="190"/>
  73. <Column size="0"/>
  74. <Column size="0"/>
  75. <Column size="55"/>
  76. <Column size="100"/>
  77. <Column size="100"/>
  78. <Column size="0"/>
  79. <Column size="0"/>
  80. <Column size="0"/>
  81. <Column size="0"/>
  82. <Column size="0"/>
  83. </Columns>
  84. <Rows>
  85. <Row size="24" band="head"/>
  86. <Row size="24"/>
  87. </Rows>
  88. <Band id="head">
  89. <Cell/>
  90. <Cell col="1" text="기관코드"/>
  91. <Cell col="2" text="회계년도"/>
  92. <Cell col="3" text="부서코드"/>
  93. <Cell col="4" text="항 계정코드"/>
  94. <Cell col="5" text="항"/>
  95. <Cell col="6" text="목 계정코드"/>
  96. <Cell col="7" text="목"/>
  97. <Cell col="8" text="계정과목"/>
  98. <Cell col="9" text="계정명"/>
  99. <Cell col="10" text="예산구분"/>
  100. <Cell col="11" text="분기"/>
  101. <Cell col="12" text="배정월"/>
  102. <Cell col="13" text="본예산액 (A)"/>
  103. <Cell col="14" text="추경신청액"/>
  104. <Cell col="15" text="증감액"/>
  105. <Cell col="16" text="적요"/>
  106. <Cell col="17" text="계산근거"/>
  107. <Cell col="18" text="삭제가능여부"/>
  108. <Cell col="19" text="UID상태"/>
  109. </Band>
  110. <Band id="body">
  111. <Cell celltype="head"/>
  112. <Cell col="1" text="bind:instcd"/>
  113. <Cell col="2" text="bind:acntyy"/>
  114. <Cell col="3" text="bind:deptcd"/>
  115. <Cell col="4" text="bind:supacntcd3"/>
  116. <Cell col="5" text="bind:supacntnm3"/>
  117. <Cell col="6" text="bind:supacntcd4"/>
  118. <Cell col="7" text="bind:supacntnm4"/>
  119. <Cell col="8" displaytype="text" edittype="text" style="align:left middle;padding:2 2 2 2;" text="bind:acntcd" editautoselect="true" expandshow="show"/>
  120. <Cell col="9" style="align:left middle;padding:2 2 2 2;" text="bind:acntnm" editautoselect="true"/>
  121. <Cell col="10" displaytype="combo" edittype="combo" text="bind:bugtflag" editautoselect="true"/>
  122. <Cell col="11" text="bind:quarter" editautoselect="true"/>
  123. <Cell col="12" displaytype="combo" edittype="combo" style="align:center middle;" text="bind:assgym" editautoselect="true" combodataset="ds_contextmenu_assgym_item" combocodecol="value" combodatacol="label"/>
  124. <Cell col="13" displaytype="number" text="bind:orgbugtamt" editautoselect="true"/>
  125. <Cell col="14" displaytype="number" text="bind:revapptotalamt" editautoselect="true"/>
  126. <Cell col="15" text="bind:revsupmbugtappamt" mask="(-)#,###"/>
  127. <Cell col="16" displaytype="text" edittype="text" text="bind:mainrec"/>
  128. <Cell col="17" displaytype="text" edittype="text" text="bind:calcbase"/>
  129. <Cell col="18" displaytype="text" edittype="text" text="bind:delflag"/>
  130. <Cell col="19" displaytype="text" edittype="text" text="bind:status"/>
  131. </Band>
  132. </Format>
  133. </Formats>
  134. </Grid>
  135. <Shape id="line9" class="line_10" position="absolute 0 117 1194 123" anchor="left top right"/>
  136. <Static id="caption11" text="분기별 추경예산 신청" class="tit_2" position="absolute 0 101 152 123"/>
  137. <Shape id="line10" linetype="vertical" class="line_1" position="absolute 0 477 1195 478"/>
  138. <Grid id="grd_revbugtlist" taborder="8" binddataset="ds_main_acntlist_revacntlist" useinputpanel="false" position="absolute 0 122 1195 444" autoenter="select" cellsizingtype="col" anchor="all" oncellclick="grd_revbugtlist_oncellclick">
  139. <Formats>
  140. <Format id="default">
  141. <Columns>
  142. <Column size="22"/>
  143. <Column size="0"/>
  144. <Column size="0"/>
  145. <Column size="0"/>
  146. <Column size="0"/>
  147. <Column size="0"/>
  148. <Column size="120"/>
  149. <Column size="120"/>
  150. <Column size="150"/>
  151. <Column size="0"/>
  152. <Column size="230"/>
  153. <Column size="105"/>
  154. <Column size="105"/>
  155. <Column size="105"/>
  156. <Column size="105"/>
  157. <Column size="105"/>
  158. <Column size="0"/>
  159. <Column size="0"/>
  160. <Column size="0"/>
  161. <Column size="105"/>
  162. <Column size="0"/>
  163. <Column size="0"/>
  164. <Column size="105"/>
  165. <Column size="105"/>
  166. <Column size="105"/>
  167. <Column size="0"/>
  168. </Columns>
  169. <Rows>
  170. <Row size="24" band="head"/>
  171. <Row size="24"/>
  172. </Rows>
  173. <Band id="head">
  174. <Cell/>
  175. <Cell col="1" text="기관코드"/>
  176. <Cell col="2" text="회계년도"/>
  177. <Cell col="3" text="부서코드"/>
  178. <Cell col="4" text="예산구분"/>
  179. <Cell col="5" text="분기"/>
  180. <Cell col="6" text="관"/>
  181. <Cell col="7" text="항"/>
  182. <Cell col="8" text="목"/>
  183. <Cell col="9" text="계정과목"/>
  184. <Cell col="10" text="계정"/>
  185. <Cell col="11" text="분기별합계액"/>
  186. <Cell col="12" text="본예산 (A)"/>
  187. <Cell col="13" text="실적 (B)"/>
  188. <Cell col="14" text="집행율 (B/A)"/>
  189. <Cell col="15" text="추경신청액 (C)"/>
  190. <Cell col="16" text="추경예산"/>
  191. <Cell col="17" text="추경조정"/>
  192. <Cell col="18" text="증감액(신청-조정)"/>
  193. <Cell col="19" text="증감액(C-A)"/>
  194. <Cell col="20" text="가용액"/>
  195. <Cell col="21" text="추산액"/>
  196. <Cell col="22" text="조정예산"/>
  197. <Cell col="23" text="이월조정예산"/>
  198. <Cell col="24" text="계정대체"/>
  199. <Cell col="25" text="예산신청여부"/>
  200. </Band>
  201. <Band id="body">
  202. <Cell celltype="head" expr="currow+1"/>
  203. <Cell col="1" text="bind:instcd"/>
  204. <Cell col="2" text="bind:acntyy"/>
  205. <Cell col="3" text="bind:deptcd"/>
  206. <Cell col="4" text="bind:bugtflag"/>
  207. <Cell col="5" text="bind:quarter"/>
  208. <Cell col="6" style="align:left middle;padding:2 2 2 2;background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:supacntnm2" editautoselect="true" suppress="1" suppressalign="middle,over"/>
  209. <Cell col="7" style="align:left middle;padding:2 2 2 2;background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:supacntnm3" editautoselect="true" suppress="2" suppressalign="middle,over"/>
  210. <Cell col="8" style="align:left middle;padding:2 2 2 2;background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:supacntnm4" editautoselect="true" suppress="3" suppressalign="middle,over"/>
  211. <Cell col="9" style="align:left middle;padding:2 2 2 2;background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:acntcd" editautoselect="true"/>
  212. <Cell col="10" style="align:left middle;padding:2 2 2 2;background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:acntnm" editautoselect="true" suppress="4" suppressalign="middle,over"/>
  213. <Cell col="11" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:totalamt" editautoselect="true"/>
  214. <Cell col="12" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:orgbugtamt" editautoselect="true"/>
  215. <Cell col="13" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:bugtexecamt" editautoselect="true"/>
  216. <Cell col="14" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:exerate" editautoselect="true"/>
  217. <Cell col="15" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:bugtappsumamt" editautoselect="true"/>
  218. <Cell col="16" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:bugtsumamt" editautoselect="true"/>
  219. <Cell col="17" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:revsupmadjtamt" editautoselect="true"/>
  220. <Cell col="18" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:bugtupdownamt" editautoselect="true"/>
  221. <Cell col="19" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:revsupmappamt" editautoselect="true"/>
  222. <Cell col="20" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:availableamt" editautoselect="true"/>
  223. <Cell col="21" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:bugtexpcamt" editautoselect="true"/>
  224. <Cell col="22" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:cntramt" editautoselect="true"/>
  225. <Cell col="23" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:transamt" editautoselect="true"/>
  226. <Cell col="24" displaytype="number" style="background:EXPR(acntcd == '99999999' ? '#dddddd' : '');background2:EXPR(acntcd == '99999999' ? '#dddddd' : '');" text="bind:interchangeamt" editautoselect="true"/>
  227. <Cell col="25" text="bind:revsupmbugtappyn"/>
  228. </Band>
  229. </Format>
  230. </Formats>
  231. </Grid>
  232. <Button id="btn_excel" taborder="9" text="엑셀출력" class="btn7" position="absolute 1114 98 1194 117" anchor="top right" onclick="btn_excel_onclick"/>
  233. <Button id="btn_delrow" taborder="10" text="행삭제" class="btn2" position="absolute 534 457 587 476" anchor="right bottom" onclick="btn_delrow_onclick"/>
  234. <Button id="btn_addrow" taborder="11" text="행추가" class="btn2" position="absolute 479 457 532 476" anchor="right bottom" onclick="btn_addrow_onclick"/>
  235. <Grid id="grd_revbugtdetaillist" taborder="12" binddataset="ds_main_revbgdtlist_revbugtdetaillist" useinputpanel="false" position="absolute 590 481 1195 785" anchor="right bottom" autoenter="select" autofittype="col" cellsizingtype="col">
  236. <Formats>
  237. <Format id="default">
  238. <Columns>
  239. <Column size="25"/>
  240. <Column size="0"/>
  241. <Column size="0"/>
  242. <Column size="0"/>
  243. <Column size="0"/>
  244. <Column size="0"/>
  245. <Column size="0"/>
  246. <Column size="0"/>
  247. <Column size="180"/>
  248. <Column size="100"/>
  249. <Column size="170"/>
  250. <Column size="0"/>
  251. <Column size="100"/>
  252. <Column size="0"/>
  253. <Column size="0"/>
  254. </Columns>
  255. <Rows>
  256. <Row size="24" band="head"/>
  257. <Row size="24"/>
  258. </Rows>
  259. <Band id="head">
  260. <Cell/>
  261. <Cell col="1" text="기관코드"/>
  262. <Cell col="2" text="회계년도"/>
  263. <Cell col="3" text="부서코드"/>
  264. <Cell col="4" text="계정코드"/>
  265. <Cell col="5" text="예산구분"/>
  266. <Cell col="6" text="배정월"/>
  267. <Cell col="7" text="분기"/>
  268. <Cell col="8" text="산출내역"/>
  269. <Cell col="9" text="본예산액"/>
  270. <Cell col="10" text="추경근거"/>
  271. <Cell col="11" text="본추경차액(입력값)"/>
  272. <Cell col="12" text="추경신청액"/>
  273. <Cell col="13" text="삭제가능여부"/>
  274. <Cell col="14" text="입력상태"/>
  275. </Band>
  276. <Band id="body">
  277. <Cell celltype="head"/>
  278. <Cell col="1" text="bind:instcd"/>
  279. <Cell col="2" text="bind:acntyy"/>
  280. <Cell col="3" text="bind:deptcd"/>
  281. <Cell col="4" text="bind:acntcd"/>
  282. <Cell col="5" text="bind:bugtflag"/>
  283. <Cell col="6" text="bind:assgym"/>
  284. <Cell col="7" text="bind:quarter"/>
  285. <Cell col="8" displaytype="text" edittype="text" text="bind:appresn" editautoselect="true"/>
  286. <Cell col="9" displaytype="number" edittype="normal" text="bind:orgappamt" editautoselect="true"/>
  287. <Cell col="10" displaytype="text" edittype="text" text="bind:appbase" editautoselect="true"/>
  288. <Cell col="11" text="bind:appamt" mask="(-)#,###" editautoselect="true"/>
  289. <Cell col="12" displaytype="number" edittype="normal" text="bind:sumamt" editautoselect="true"/>
  290. <Cell col="13" text="bind:delflag"/>
  291. <Cell col="14" text="bind:status"/>
  292. </Band>
  293. </Format>
  294. </Formats>
  295. </Grid>
  296. <Button id="btn_detaildelrow" taborder="13" text="행삭제" class="btn2" position="absolute 1140 457 1193 476" anchor="right bottom" onclick="btn_detaildelrow_onclick"/>
  297. <Static id="caption1" text="분기별 추경예산 산출내역" class="tit_2" position="absolute 589 460 767 482" anchor="right bottom"/>
  298. <Button id="btn_detailaddrow" taborder="14" text="행추가" class="btn2" position="absolute 1085 457 1138 476" anchor="right bottom" onclick="btn_detailaddrow_onclick"/>
  299. <Button id="btn_acntaddrow" taborder="15" text="항목추가" class="btn2" position="absolute 407 457 471 476" anchor="right bottom" onclick="btn_acntaddrow_onclick"/>
  300. <Shape id="line1" linetype="vertical" class="line_10" position="absolute 585 477 591 782" anchor="right bottom"/>
  301. <Shape id="line00" class="line_10" position="absolute 0 475 1195 484" anchor="left right bottom"/>
  302. <Shape id="line7" class="line_6" position="absolute 0 47 1194 53" anchor="left top right"/>
  303. </Layout>
  304. </Layouts>
  305. <Objects>
  306. <Dataset id="ds_send_retrparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_retrparam_oncolumnchanged">
  307. <ColumnInfo>
  308. <Column id="instcd" type="STRING" size="256"/>
  309. <Column id="acntyy" type="STRING" size="256"/>
  310. <Column id="deptcd" type="STRING" size="256"/>
  311. <Column id="depthngnm" type="STRING" size="256"/>
  312. <Column id="bugtflag" type="STRING" size="256"/>
  313. <Column id="quarter" type="STRING" size="256"/>
  314. </ColumnInfo>
  315. <Rows>
  316. <Row>
  317. <Col id="instcd"/>
  318. <Col id="acntyy"/>
  319. <Col id="deptcd"/>
  320. <Col id="depthngnm"/>
  321. <Col id="bugtflag">2</Col>
  322. <Col id="quarter"/>
  323. </Row>
  324. </Rows>
  325. </Dataset>
  326. <Dataset id="ds_send_retrparam2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  327. <ColumnInfo>
  328. <Column id="instcd" type="STRING" size="256"/>
  329. <Column id="acntyy" type="STRING" size="256"/>
  330. <Column id="deptcd" type="STRING" size="256"/>
  331. <Column id="acntcd" type="STRING" size="256"/>
  332. <Column id="bugtflag" type="STRING" size="256"/>
  333. <Column id="quarter" type="STRING" size="256"/>
  334. </ColumnInfo>
  335. <Rows>
  336. <Row>
  337. <Col id="instcd"/>
  338. <Col id="acntyy"/>
  339. <Col id="deptcd"/>
  340. <Col id="acntcd"/>
  341. <Col id="bugtflag"/>
  342. <Col id="quarter"/>
  343. </Row>
  344. </Rows>
  345. </Dataset>
  346. <Dataset id="ds_send_retrparam3" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  347. <ColumnInfo>
  348. <Column id="instcd" type="STRING" size="256"/>
  349. <Column id="acntyy" type="STRING" size="256"/>
  350. <Column id="deptcd" type="STRING" size="256"/>
  351. <Column id="acntcd" type="STRING" size="256"/>
  352. <Column id="bugtflag" type="STRING" size="256"/>
  353. <Column id="assgym" type="STRING" size="256"/>
  354. <Column id="quarter" type="STRING" size="256"/>
  355. </ColumnInfo>
  356. <Rows>
  357. <Row>
  358. <Col id="instcd"/>
  359. <Col id="acntyy"/>
  360. <Col id="deptcd"/>
  361. <Col id="acntcd"/>
  362. <Col id="bugtflag"/>
  363. <Col id="assgym"/>
  364. <Col id="quarter"/>
  365. </Row>
  366. </Rows>
  367. </Dataset>
  368. <Dataset id="ds_send_retrparam4" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  369. <ColumnInfo>
  370. <Column id="instcd" type="STRING" size="256"/>
  371. <Column id="mngtcd" type="STRING" size="256"/>
  372. </ColumnInfo>
  373. <Rows>
  374. <Row>
  375. <Col id="instcd"/>
  376. <Col id="mngtcd">bugtdept</Col>
  377. </Row>
  378. </Rows>
  379. </Dataset>
  380. <Dataset id="ds_send_appcancelparams" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  381. <ColumnInfo>
  382. <Column id="instcd" type="STRING" size="256"/>
  383. <Column id="acntyy" type="STRING" size="256"/>
  384. <Column id="deptcd" type="STRING" size="256"/>
  385. <Column id="bugtflag" type="STRING" size="256"/>
  386. <Column id="flag" type="STRING" size="256"/>
  387. <Column id="quarter" type="STRING" size="256"/>
  388. </ColumnInfo>
  389. <Rows>
  390. <Row>
  391. <Col id="instcd"/>
  392. <Col id="acntyy"/>
  393. <Col id="deptcd"/>
  394. <Col id="bugtflag"/>
  395. <Col id="flag"/>
  396. <Col id="quarter"/>
  397. </Row>
  398. </Rows>
  399. </Dataset>
  400. <Dataset id="ds_main_acntlist_revacntlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  401. <ColumnInfo>
  402. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  403. <Column id="acntyy" type="STRING" size="256" sumtext="회계년도"/>
  404. <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
  405. <Column id="bugtflag" type="STRING" size="256" sumtext="예산구분"/>
  406. <Column id="quarter" type="STRING" size="256" sumtext="예산분기"/>
  407. <Column id="supacntnm2" type="STRING" size="256" sumtext="상위계정명2"/>
  408. <Column id="supacntnm3" type="STRING" size="256" sumtext="상위계정명3"/>
  409. <Column id="supacntnm4" type="STRING" size="256" sumtext="상위계정명4"/>
  410. <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
  411. <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
  412. <Column id="orgbugtamt" type="STRING" size="256" sumtext="본예산액"/>
  413. <Column id="bugtexpcamt" type="STRING" size="256" sumtext="추산액"/>
  414. <Column id="bugtexecamt" type="STRING" size="256" sumtext="집행액"/>
  415. <Column id="cntramt" type="STRING" size="256" sumtext="조정액"/>
  416. <Column id="transamt" type="STRING" size="256" sumtext="이월조정액"/>
  417. <Column id="interchangeamt" type="STRING" size="256" sumtext="계정대체"/>
  418. <Column id="exerate" type="STRING" size="256" sumtext="집행률"/>
  419. <Column id="revsupmappamt" type="STRING" size="256" sumtext="추산신청액"/>
  420. <Column id="revsupmadjtamt" type="STRING" size="256" sumtext="추산조정액"/>
  421. <Column id="bugtupdownamt" type="STRING" size="256" sumtext="추산조정액"/>
  422. <Column id="bugtsumamt" type="STRING" size="256" sumtext="총예산"/>
  423. <Column id="bugtappsumamt" type="STRING" size="256" sumtext="본예산+추경신청"/>
  424. <Column id="availableamt" type="STRING" size="256" sumtext="가용액"/>
  425. <Column id="revsupmbugtappyn" type="STRING" size="256" sumtext="예산신청여부"/>
  426. <Column id="totalamt" type="STRING" size="256" sumtext="분기합계금액"/>
  427. <Column id="orgbugtappyn" type="STRING" size="256"/>
  428. </ColumnInfo>
  429. </Dataset>
  430. <Dataset id="ds_main_bugtlist_revbugtapplist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_bugtlist_revbugtapplist_oncolumnchanged">
  431. <ColumnInfo>
  432. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  433. <Column id="acntyy" type="STRING" size="256" sumtext="회계년도"/>
  434. <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
  435. <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
  436. <Column id="acntnm" type="STRING" size="256" sumtext="계정코드"/>
  437. <Column id="bugtflag" type="STRING" size="256" sumtext="예산구분"/>
  438. <Column id="assgym" type="STRING" size="256" sumtext="배정년월"/>
  439. <Column id="quarter" type="STRING" size="256" sumtext="예산분기"/>
  440. <Column id="orgbugtamt" type="BIGDECIMAL" size="256" sumtext="본예산액"/>
  441. <Column id="revapptotalamt" type="BIGDECIMAL" size="256" sumtext="본예산+추경신청"/>
  442. <Column id="revsupmbugtappamt" type="BIGDECIMAL" size="256" sumtext="본추경신청차액"/>
  443. <Column id="revadjttotalamt" type="BIGDECIMAL" size="256" sumtext="본예산+추경조정"/>
  444. <Column id="revsupmbugtadjtamt" type="BIGDECIMAL" size="256" sumtext="본추경조정차액"/>
  445. <Column id="differenceamt" type="BIGDECIMAL" size="256" sumtext="추경신청조정차액"/>
  446. <Column id="mainrec" type="STRING" size="256" sumtext="적요"/>
  447. <Column id="calcbase" type="STRING" size="256" sumtext="계산근거"/>
  448. <Column id="delflag" type="BIGDECIMAL" size="256" sumtext="삭제가능구분"/>
  449. <Column id="status" type="BIGDECIMAL" size="256" sumtext="UID상태"/>
  450. </ColumnInfo>
  451. </Dataset>
  452. <Dataset id="ds_main_revbgdtlist_revbugtdetaillist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_revbgdtlist_revbugtdetaillist_oncolumnchanged">
  453. <ColumnInfo>
  454. <Column id="instcd" type="STRING" size="256" sumtext="회계년도"/>
  455. <Column id="acntyy" type="STRING" size="256" sumtext="회계년도"/>
  456. <Column id="deptcd" type="STRING" size="256" sumtext="부서코드"/>
  457. <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
  458. <Column id="bugtflag" type="STRING" size="256" sumtext="예산구분"/>
  459. <Column id="assgym" type="STRING" size="256" sumtext="배정년월"/>
  460. <Column id="quarter" type="STRING" size="256" sumtext="예산분기"/>
  461. <Column id="orgappamt" type="BIGDECIMAL" size="256" sumtext="본예산신청액"/>
  462. <Column id="appamt" type="BIGDECIMAL" size="256" sumtext="추경예산신청액"/>
  463. <Column id="sumamt" type="BIGDECIMAL" size="256" sumtext="추경예산신청+본예산"/>
  464. <Column id="adjtamt" type="BIGDECIMAL" size="256" sumtext="추경예산조정액"/>
  465. <Column id="adjtsumamt" type="BIGDECIMAL" size="256" sumtext="추경예산조정+본예산"/>
  466. <Column id="appresn" type="STRING" size="256" sumtext="추경예산신청산출내역"/>
  467. <Column id="appbase" type="STRING" size="256" sumtext="추경예산신청산출근거"/>
  468. <Column id="adjtresn" type="STRING" size="256" sumtext="추경예산신청조정산출내역 "/>
  469. <Column id="adjtbase" type="STRING" size="256" sumtext="추경예산신청조정산출근거 "/>
  470. <Column id="delflag" type="STRING" size="256" sumtext="삭제가능구분"/>
  471. <Column id="status" type="STRING" size="256" sumtext="UID상태"/>
  472. </ColumnInfo>
  473. </Dataset>
  474. <Dataset id="ds_contextmenu_assgym_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  475. <ColumnInfo>
  476. <Column id="label" type="STRING" size="256"/>
  477. <Column id="value" type="STRING" size="256"/>
  478. </ColumnInfo>
  479. <Rows>
  480. <Row>
  481. <Col id="label">년간</Col>
  482. <Col id="value">-</Col>
  483. </Row>
  484. <Row>
  485. <Col id="label">3월</Col>
  486. <Col id="value">03</Col>
  487. </Row>
  488. <Row>
  489. <Col id="label">4월</Col>
  490. <Col id="value">04</Col>
  491. </Row>
  492. <Row>
  493. <Col id="label">5월</Col>
  494. <Col id="value">05</Col>
  495. </Row>
  496. <Row>
  497. <Col id="label">6월</Col>
  498. <Col id="value">06</Col>
  499. </Row>
  500. <Row>
  501. <Col id="label">7월</Col>
  502. <Col id="value">07</Col>
  503. </Row>
  504. <Row>
  505. <Col id="label">8월</Col>
  506. <Col id="value">08</Col>
  507. </Row>
  508. <Row>
  509. <Col id="label">9월</Col>
  510. <Col id="value">09</Col>
  511. </Row>
  512. <Row>
  513. <Col id="label">10월</Col>
  514. <Col id="value">10</Col>
  515. </Row>
  516. <Row>
  517. <Col id="label">11월</Col>
  518. <Col id="value">11</Col>
  519. </Row>
  520. <Row>
  521. <Col id="label">12월</Col>
  522. <Col id="value">12</Col>
  523. </Row>
  524. <Row>
  525. <Col id="label">1월</Col>
  526. <Col id="value">01</Col>
  527. </Row>
  528. <Row>
  529. <Col id="label">2월</Col>
  530. <Col id="value">02</Col>
  531. </Row>
  532. </Rows>
  533. </Dataset>
  534. <Dataset id="ds_init_comlist_acntyylist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  535. <ColumnInfo>
  536. <Column id="acntyy" type="STRING" size="256" sumtext="회계년도"/>
  537. <Column id="quarter" type="STRING" size="256" sumtext="회계분기"/>
  538. </ColumnInfo>
  539. </Dataset>
  540. <Dataset id="ds_init_code_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  541. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  542. <ColumnInfo>
  543. <Column id="updateflag" type="STRING" size="256"/>
  544. <Column id="bugtaddflag" type="STRING" size="256"/>
  545. <Column id="quarter" type="STRING" size="256"/>
  546. </ColumnInfo>
  547. <Rows>
  548. <Row>
  549. <Col id="updateflag">Y</Col>
  550. <Col id="bugtaddflag">N</Col>
  551. <Col id="quarter"/>
  552. </Row>
  553. </Rows>
  554. </Dataset>
  555. <Dataset id="ds_init_baseinfo_quarter" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  556. <ColumnInfo>
  557. <Column id="cd" type="STRING" size="256"/>
  558. <Column id="nm" type="STRING" size="256"/>
  559. </ColumnInfo>
  560. <Rows>
  561. <Row>
  562. <Col id="cd">1</Col>
  563. <Col id="nm">1분기</Col>
  564. </Row>
  565. <Row>
  566. <Col id="cd">2</Col>
  567. <Col id="nm">2분기</Col>
  568. </Row>
  569. <Row>
  570. <Col id="cd">3</Col>
  571. <Col id="nm">3분기</Col>
  572. </Row>
  573. <Row>
  574. <Col id="cd">4</Col>
  575. <Col id="nm">4분기</Col>
  576. </Row>
  577. </Rows>
  578. </Dataset>
  579. </Objects>
  580. <Bind>
  581. <BindItem id="item0" compid="group4.ipt_acntyy" propid="value" datasetid="ds_send_retrparam" columnid="acntyy"/>
  582. <BindItem id="item1" compid="group4.cmb_quarter" propid="value" datasetid="ds_send_retrparam" columnid="quarter"/>
  583. <BindItem id="item2" compid="group4.ipt_deptcd" propid="value" datasetid="ds_send_retrparam" columnid="deptcd"/>
  584. <BindItem id="item3" compid="group4.ipt_depthngnm" propid="value" datasetid="ds_send_retrparam" columnid="depthngnm"/>
  585. <BindItem id="item4" compid="group4.rdo_bugtflag" propid="value" datasetid="ds_send_retrparam" columnid="bugtflag"/>
  586. </Bind>
  587. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  588. * System Name :
  589. * Job Name :
  590. * Creator :
  591. * Make Date : 2017-06-19
  592. * Description :
  593. *---------------------------------------------------------------------------------------
  594. * Modify Date Modifier Modify Description
  595. *---------------------------------------------------------------------------------------
  596. * 2017-06-19 Live Converter TF->XP
  597. *
  598. *---------------------------------------------------------------------------------------
  599. ****************************************************************************************/
  600. include "com_commonxp::comm_main.xjs";
  601. include "mis_miscommonxp::MIS.xjs";
  602. include "mis_acntcommonxp::RAD001.xjs";
  603. include "mis_miscommonxp::RAC001.xjs";
  604. include "mis_bugtcommonxp::RBC001.xjs";
  605. var Instcd = sysf_getUserInfo("dutplceinstcd");
  606. var Deptcd = sysf_getUserInfo("dutplcecd");
  607. var Deptnm = sysf_getUserInfo("dutplcenm");
  608. var Emplno = sysf_getUserInfo("userid");
  609. var DeptAcnt = "";
  610. var sYn;
  611. function SMRBQ00700_oninit(obj:Form, e:InitEventInfo)
  612. {
  613. frmf_initForm(obj);
  614. }
  615. function SMRBQ00700_onload(obj:Form, e:LoadEventInfo)
  616. {
  617. grdf_initGrid(grd_revbugtlist);
  618. grdf_initGrid(grd_revbugtapplist);
  619. grdf_setRowTypeIcon(grd_revbugtapplist, 0);
  620. grdf_initGrid(grd_revbugtdetaillist);
  621. grdf_setRowTypeIcon(grd_revbugtdetaillist, 0);
  622. fCheckAuth();
  623. fResetForm();
  624. }
  625. function fCheckAuth()
  626. {
  627. group4.btn_search.enable = frmf_checkAuth("R");
  628. btn_save.enable = frmf_checkAuth("X");
  629. }
  630. function fResetForm()
  631. {
  632. if(radfCheckInstMngt(sysf_getUserInfo("dutplceinstcd"), "condition4") == "Y")
  633. {
  634. DeptAcnt = "Y";
  635. btn_acntaddrow.visible = false;
  636. }
  637. else
  638. {
  639. DeptAcnt = "N";
  640. btn_acntaddrow.visible = true;
  641. }
  642. ds_send_retrparam.enableevent = false
  643. ds_send_retrparam.setColumn(0, "instcd", Instcd);
  644. ds_send_retrparam.setColumn(0, "deptcd", Deptcd);
  645. ds_send_retrparam.setColumn(0, "depthngnm", Deptnm);
  646. ds_send_retrparam.enableevent = true
  647. var oParam = {};
  648. oParam.id = "TRRBC10201";
  649. oParam.service = "bugtcommonapp.BugtCommon";
  650. oParam.method = "reqGetQuarterAppAcntyy";
  651. oParam.inds = "req=ds_send_retrparam";
  652. oParam.outds = "ds_init_comlist_acntyylist=acntyylist";
  653. oParam.async = false;
  654. oParam.callback = "cf_TRRBC10201";
  655. tranf_submit(oParam);
  656. ds_send_retrparam4.setColumn(0, "instcd", Instcd);
  657. var oParam = {};
  658. oParam.id = "TRRAZ00001";
  659. oParam.service = "acntcommonapp.AcntCommon";
  660. oParam.method = "reqGetAcntMngtCodeList";
  661. oParam.inds = "req=ds_send_retrparam4";
  662. oParam.outds = "ds_init_code_codelist=codelist";
  663. oParam.async = false;
  664. //oParam.callback = "cf_TRRAZ00001";
  665. tranf_submit(oParam);
  666. group4.btn_search.click();
  667. }
  668. function cf_TRRBC10201(sSvcId, nErrorCode, sErrorMsg)
  669. {
  670. if(nErrorCode < 0)
  671. {
  672. return;
  673. }
  674. else
  675. {
  676. ds_send_retrparam.setColumn(0, "acntyy", ds_init_comlist_acntyylist.getColumn(0, "acntyy"))
  677. ds_send_retrparam.setColumn(0, "quarter", ds_init_comlist_acntyylist.getColumn(0, "quarter"))
  678. }
  679. }
  680. function ds_send_retrparam_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  681. {
  682. if(e.columnid == "acntyy")
  683. {
  684. fRetrieve();
  685. }
  686. if(e.columnid == "deptcd")
  687. {
  688. group4.ipt_deptcd.value = e.newvalue;
  689. group4.ipt_deptcd.setFocus();
  690. racfDeptValidCheck("deptcd,depthngnm", "code");
  691. if(!utlf_isNull(e.newvalue) && !utlf_isNull(group4.ipt_depthngnm.value))
  692. {
  693. group4.btn_search.click();
  694. }
  695. }
  696. if(e.columnid == "depthngnm")
  697. {
  698. group4.ipt_depthngnm.value = e.newvalue;
  699. group4.ipt_depthngnm.setFocus();
  700. racfDeptValidCheck("deptcd,depthngnm", "name");
  701. if(!utlf_isNull(e.newvalue) && !utlf_isNull(group4.ipt_deptcd.value))
  702. {
  703. group4.btn_search.click();
  704. }
  705. }
  706. }
  707. function group4_btn_pre_onclick(obj:Button, e:ClickEventInfo)
  708. {
  709. var vYYYY = group4.ipt_acntyy.value;
  710. var vNum = parseInt(vYYYY, 10);
  711. if (vNum != 1)
  712. {
  713. vNum--;
  714. }
  715. else
  716. {
  717. return;
  718. }
  719. group4.ipt_acntyy.value = vNum;
  720. fRetrieve();
  721. }
  722. function group4_button5_onclick(obj:Button, e:ClickEventInfo)
  723. {
  724. var vYYYY = group4.ipt_acntyy.value;
  725. var vNum = parseInt(vYYYY, 10);
  726. if (vNum != 1)
  727. {
  728. vNum++;
  729. }
  730. else
  731. {
  732. return;
  733. }
  734. group4.ipt_acntyy.value = vNum;
  735. fRetrieve();
  736. }
  737. function group4_cmb_quarter_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  738. {
  739. fRetrieve();
  740. }
  741. function group4_ipt_deptcd_onkeydown(obj:Edit, e:KeyEventInfo)
  742. {
  743. if(e.keycode == 13)
  744. {
  745. obj.updateToDataset();
  746. racfDeptValidCheck("deptcd,depthngnm", "code");
  747. if(!utlf_isNull(obj.value) && !utlf_isNull(group4.ipt_depthngnm.value))
  748. {
  749. group4.btn_search.click();
  750. }
  751. }
  752. }
  753. function group4_ipt_depthngnm_onkeydown(obj:Edit, e:KeyEventInfo)
  754. {
  755. if(e.keycode == 13)
  756. {
  757. obj.updateToDataset();
  758. racfDeptValidCheck("deptcd,depthngnm", "name");
  759. if(!utlf_isNull(obj.value) && !utlf_isNull(group4.ipt_deptcd.value))
  760. {
  761. group4.btn_search.click();
  762. }
  763. }
  764. }
  765. function group4_rdo_bugtflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
  766. {
  767. group4.btn_search.click();
  768. }
  769. function group4_btn_search_onclick(obj:Button, e:ClickEventInfo)
  770. {
  771. if(utlf_isNull(group4.ipt_deptcd.value))
  772. {
  773. sysf_messageBox("부서를 선택하세요", "I000");
  774. return;
  775. }
  776. if(utlf_isNull(group4.ipt_acntyy.value))
  777. {
  778. sysf_messageBox("예산년도를 입력하세요", "I000");
  779. return;
  780. }
  781. fRetrieve();
  782. }
  783. function fRetrieve()
  784. {
  785. ds_main_acntlist_revacntlist.clearData();
  786. ds_main_bugtlist_revbugtapplist.clearData();
  787. ds_main_revbgdtlist_revbugtdetaillist.clearData();
  788. var bugtsearchyn = "";
  789. var bugtinputyn = "";
  790. var bugtreqyn = "";
  791. var bugtdeptcd = ds_init_code_codelist.getColumn(0, "cdid");
  792. var vAppCheck = rbcfgetAppPossibleDeptCheck(sysf_getUserInfo("dutplceinstcd"), group4.ipt_acntyy.value, group4.ipt_deptcd.value);
  793. var vDeptcd = group4.ipt_deptcd.value;
  794. if(vDeptcd == Deptcd || bugtdeptcd == Deptcd)
  795. {
  796. bugtsearchyn = "Y";
  797. bugtinputyn = "Y";
  798. bugtreqyn = "Y";
  799. }
  800. else
  801. {
  802. bugtsearchyn = radfCheckBugtAuth(Instcd, Emplno, vDeptcd, "BUGTSEARCHYN");
  803. bugtinputyn = radfCheckBugtAuth(Instcd, Emplno, vDeptcd, "BUGTINPUTYN");
  804. bugtreqyn = radfCheckBugtAuth(Instcd, Emplno, vDeptcd, "BUGTREQYN");
  805. }
  806. if(bugtsearchyn == "Y")
  807. {
  808. btn_save.enable = true;
  809. btn_app.enable = true;
  810. btn_alldel.enable = true;
  811. var oParam = {};
  812. oParam.id = "TRRBQ00701";
  813. oParam.service = "bugtappapp.BugtApp";
  814. oParam.method = "reqGetQuarterRevBugtStatList";
  815. oParam.inds = "req=ds_send_retrparam";
  816. oParam.outds = "ds_main_acntlist_revacntlist=revacntlist";
  817. oParam.async = false;
  818. //oParam.callback = "cf_TRRBQ00701";
  819. tranf_submit(oParam);
  820. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  821. {
  822. bugtinputyn = "N";
  823. }
  824. }
  825. else
  826. {
  827. btn_save.enable = false;
  828. btn_app.enable = false;
  829. btn_alldel.enable = false;
  830. return false;
  831. }
  832. if(bugtinputyn == "Y" && vAppCheck == "Y")
  833. {
  834. btn_save.enable = true;
  835. btn_excelupload.enable = true;
  836. btn_acntaddrow.enable = true;
  837. btn_addrow.enable = true;
  838. btn_delrow.enable = true;
  839. btn_detailaddrow.enable = true;
  840. btn_detaildelrow.enable = true;
  841. }
  842. else
  843. {
  844. btn_save.enable = false;
  845. btn_excelupload.enable = false;
  846. btn_acntaddrow.enable = false;
  847. btn_addrow.enable = false;
  848. btn_delrow.enable = false;
  849. btn_detailaddrow.enable = false;
  850. btn_detaildelrow.enable = false;
  851. }
  852. if(bugtreqyn == "Y")
  853. {
  854. btn_app.enable = true;
  855. btn_alldel.enable = true;
  856. btn_cancel.enable = true;
  857. }
  858. else
  859. {
  860. btn_app.enable = false;
  861. btn_alldel.enable = false;
  862. btn_cancel.enable = false;
  863. }
  864. }
  865. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  866. {
  867. grdf_exportExcel(grd_revbugtlist, "excel", "see", false);
  868. }
  869. function grd_revbugtlist_oncellclick(obj:Grid, e:GridClickEventInfo)
  870. {
  871. ds_main_bugtlist_revbugtapplist.clearData();
  872. ds_main_revbgdtlist_revbugtdetaillist.clearData();
  873. ds_send_retrparam2.setColumn(0, "instcd", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "instcd"));
  874. ds_send_retrparam2.setColumn(0, "acntyy", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntyy"));
  875. ds_send_retrparam2.setColumn(0, "deptcd", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "deptcd"));
  876. ds_send_retrparam2.setColumn(0, "acntcd", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntcd"));
  877. ds_send_retrparam2.setColumn(0, "bugtflag", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "bugtflag"));
  878. ds_send_retrparam2.setColumn(0, "quarter", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "quarter"));
  879. var oParam = {};
  880. oParam.id = "TRRBQ00702";
  881. oParam.service = "bugtappapp.BugtApp";
  882. oParam.method = "reqGetQuarterRevAcntBugtList";
  883. oParam.inds = "req=ds_send_retrparam2";
  884. oParam.outds = "ds_main_bugtlist_revbugtapplist=revbugtapplist";
  885. oParam.async = false;
  886. //oParam.callback = "cf_TRRBQ00702";
  887. tranf_submit(oParam);
  888. ds_hidden.setColumn(0, "updateflag", "N");
  889. misfSetReadOnlyCol(grd_revbugtapplist, "acntcd,acntnm,assgym", true);
  890. if(ds_main_bugtlist_revbugtapplist.rowcount > 0)
  891. {
  892. ds_main_bugtlist_revbugtapplist.rowposition = 0;
  893. grd_revbugtapplist_oncellclick();
  894. }
  895. if(DeptAcnt == "Y")
  896. {
  897. var vDeptAcnt = ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "deptacnt");
  898. if(vDeptAcnt == "Y")
  899. {
  900. btn_addrow.enable = true;
  901. }
  902. else
  903. {
  904. btn_addrow.enable = false;
  905. }
  906. }
  907. }
  908. function grd_revbugtapplist_oncellclick(obj:Grid, e:GridClickEventInfo)
  909. {
  910. if(ds_hidden.getColumn(0, "updateflag") == "Y")
  911. {
  912. grd_revbugtlist_oncellclick();
  913. return;
  914. }
  915. ds_main_revbgdtlist_revbugtdetaillist.clearData();
  916. ds_send_retrparam3.setColumn(0, "instcd", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "instcd"));
  917. ds_send_retrparam3.setColumn(0, "acntyy", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "acntyy"));
  918. ds_send_retrparam3.setColumn(0, "deptcd", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "deptcd"));
  919. ds_send_retrparam3.setColumn(0, "acntcd", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "acntcd"));
  920. ds_send_retrparam3.setColumn(0, "assgym", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym"));
  921. ds_send_retrparam3.setColumn(0, "bugtflag", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "bugtflag"));
  922. ds_send_retrparam3.setColumn(0, "quarter", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "quarter"));
  923. var oParam = {};
  924. oParam.id = "TRRBQ00703";
  925. oParam.service = "bugtappapp.BugtApp";
  926. oParam.method = "reqGetQuarterRevAcntBugtDetailList";
  927. oParam.inds = "req=ds_send_retrparam3";
  928. oParam.outds = "ds_main_revbgdtlist_revbugtdetaillist=revbugtdetaillist";
  929. oParam.async = false;
  930. //oParam.callback = "cf_TRRBQ00703";
  931. tranf_submit(oParam);
  932. if(ds_main_acntlist_revacntlist.getColumn(0, "orgbugtappyn") == "Y")
  933. {
  934. misfSetReadOnlyCol(grd_revbugtdetaillist, "appresn,appbase,sumamt", true);
  935. }
  936. else
  937. {
  938. misfSetReadOnlyCol(grd_revbugtdetaillist, "appresn", true);
  939. }
  940. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = false
  941. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  942. {
  943. if(ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "status") == "1")
  944. {
  945. ds_main_revbgdtlist_revbugtdetaillist.setRowType(i, "i");
  946. }
  947. else if(ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "status") == "0")
  948. {
  949. ds_main_revbgdtlist_revbugtdetaillist.setRowType(i, "");
  950. }
  951. }
  952. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = true;
  953. }
  954. function grd_revbugtapplist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
  955. {
  956. misfOpenPopUpList("10", ds_main_bugtlist_revbugtapplist, "", "supacntcd3,supacntnm3,supacntcd4,supacntnm4,acntcd,acntnm", group4.rdo_bugtflag.value, "bugtflag");
  957. }
  958. function ds_main_bugtlist_revbugtapplist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  959. {
  960. if (obj.getColumn(e.row, "assgym") == "01" || obj.getColumn(e.row, "assgym") == "02" || obj.getColumn(e.row, "assgym") == "03")
  961. {
  962. ds_hidden.setColumn(0, "quarter", "1");
  963. obj.setColumn(e.row, "quarter", ds_hidden.getColumn(0, "quarter"));
  964. }
  965. else if (obj.getColumn(e.row, "assgym") == "04" || obj.getColumn(e.row, "assgym") == "05" || obj.getColumn(e.row, "assgym") == "06")
  966. {
  967. ds_hidden.setColumn(0, "quarter", "2");
  968. obj.setColumn(e.row, "quarter", ds_hidden.getColumn(0, "quarter"));
  969. }
  970. else if (obj.getColumn(e.row, "assgym") == "07" || obj.getColumn(e.row, "assgym") == "08" || obj.getColumn(e.row, "assgym") == "09")
  971. {
  972. ds_hidden.setColumn(0, "quarter", "3");
  973. obj.setColumn(e.row, "quarter", ds_hidden.getColumn(0, "quarter"));
  974. }
  975. else if (obj.getColumn(e.row, "assgym") == "10" || obj.getColumn(e.row, "assgym") == "11" || obj.getColumn(e.row, "assgym") == "12")
  976. {
  977. ds_hidden.setColumn(0, "quarter", "3");
  978. obj.setColumn(e.row, "quarter", ds_hidden.getColumn(0, "quarter"));
  979. }
  980. else if (obj.getColumn(e.row, "assgym") == "-")
  981. {
  982. ds_hidden.setColumn(0, "quarter", group4.cmb_quarter.value);
  983. obj.setColumn(e.row, "quarter", ds_hidden.getColumn(0, "quarter"));
  984. }
  985. if(e.columnid == "acntcd")
  986. {
  987. var Vacntcd = e.newvalue;
  988. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  989. {
  990. ds_main_revbgdtlist_revbugtdetaillist.setColumn(i, "acntcd", Vacntcd);
  991. }
  992. }
  993. else if(e.columnid == "assgym")
  994. {
  995. fCheckDupData();
  996. var Vassgym = e.newvalue;
  997. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  998. {
  999. ds_main_revbgdtlist_revbugtdetaillist.setColumn(i, "assgym", Vassgym);
  1000. }
  1001. }
  1002. }
  1003. function fCheckDupData()
  1004. {
  1005. var iInsCnt = 0;
  1006. var iDupCnt = 0;
  1007. var bDel = false;
  1008. for(var i = 0; i < ds_main_bugtlist_revbugtapplist.rowcount; i++)
  1009. {
  1010. if(i == ds_main_bugtlist_revbugtapplist.rowposition)
  1011. {
  1012. continue;
  1013. }
  1014. if(ds_main_bugtlist_revbugtapplist.getColumn(i, "assgym") == ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym"))
  1015. {
  1016. sysf_messageBox("같은 예산코드에 동일 배정 [년/월]을 지정할 수", "I004");
  1017. ds_main_bugtlist_revbugtapplist.setColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym", "");
  1018. return;
  1019. }
  1020. if(ds_main_bugtlist_revbugtapplist.getColumn(i, "assgym") == "-" && ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym") != "-")
  1021. {
  1022. sysf_messageBox("년간 배정이 있어 월간 배정을 할 수", "I004");
  1023. ds_main_bugtlist_revbugtapplist.setColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym", "");
  1024. return;
  1025. }
  1026. if(ds_main_bugtlist_revbugtapplist.getColumn(i, "assgym") != "-" && ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym") == "-")
  1027. {
  1028. sysf_messageBox("월간 배정이 있어 년간 배정을 할 수", "I004");
  1029. ds_main_bugtlist_revbugtapplist.setColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym", "");
  1030. return;
  1031. }
  1032. }
  1033. }
  1034. function ds_main_revbgdtlist_revbugtdetaillist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  1035. {
  1036. var vCol = e.columnid;
  1037. var vRow = e.row;
  1038. var iInsCnt = 0;
  1039. var iDupCnt = 0;
  1040. var bDel = false;
  1041. if(vCol == "appresn")
  1042. {
  1043. for(var i = 0; i < obj.rowcount; i++)
  1044. {
  1045. if(i == e.row)
  1046. {
  1047. continue;
  1048. }
  1049. if(obj.getColumn(i, "appresn") == obj.getColumn(e.row, "appresn"))
  1050. {
  1051. sysf_messageBox("신청 내역이 있습니다. 신청 내역을 수정하세요.", "I999");
  1052. obj.getColumn(e.row, "appresn", "");
  1053. return false;
  1054. }
  1055. }
  1056. }
  1057. if(vCol == "sumamt")
  1058. {
  1059. if(utlf_isNull(e.newvalue))
  1060. {
  1061. obj.setColumn(e.row, "sumamt", "0");
  1062. }
  1063. obj.setColumn(vRow, "appamt", parseInt(e.newvalue)-parseInt(obj.getColumn(vRow, "orgappamt")));
  1064. fSetDetailListOrgAmt();
  1065. ds_hidden.setColumn(0, "updateflag", "Y");
  1066. }
  1067. }
  1068. function fSetDetailListOrgAmt()
  1069. {
  1070. var iSumAppAmt = 0;
  1071. var iSumTotAmt = 0;
  1072. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  1073. {
  1074. if(ds_main_revbgdtlist_revbugtdetaillist.getRowType(i) != 8)
  1075. {
  1076. var sAppAmt = utlf_isNull(ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "appamt")) ? 0 : ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "appamt");
  1077. iSumAppAmt += parseInt(sAppAmt);
  1078. var sTotAmt = utlf_isNull(ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "sumamt")) ? 0 : ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "sumamt");
  1079. iSumTotAmt += parseInt(sTotAmt);
  1080. }
  1081. }
  1082. ds_main_bugtlist_revbugtapplist.setColumn(ds_main_bugtlist_revbugtapplist.rowposition, "revsupmbugtappamt", iSumAppAmt);
  1083. ds_main_bugtlist_revbugtapplist.setColumn(ds_main_bugtlist_revbugtapplist.rowposition, "revapptotalamt", iSumTotAmt);
  1084. if(ds_main_bugtlist_revbugtapplist.getRowType(ds_main_bugtlist_revbugtapplist.rowposition) != 2)
  1085. {
  1086. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1087. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "u");
  1088. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1089. }
  1090. }
  1091. function btn_acntaddrow_onclick(obj:Button, e:ClickEventInfo)
  1092. {
  1093. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  1094. {
  1095. sysf_messageBox("신청된 예산이므로 추가 또는 삭제를 할 수", "I004");
  1096. return;
  1097. }
  1098. ds_main_bugtlist_revbugtapplist.clearData();
  1099. ds_main_revbgdtlist_revbugtdetaillist.clearData();
  1100. var addRow = ds_main_bugtlist_revbugtapplist.addRow();
  1101. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "instcd", ds_send_retrparam.getColumn(0, "instcd"));
  1102. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "acntyy", ds_send_retrparam.getColumn(0, "acntyy"));
  1103. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "deptcd", ds_send_retrparam.getColumn(0, "deptcd"));
  1104. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "acntcd", "");
  1105. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "acntnm", "");
  1106. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "bugtflag", ds_send_retrparam.getColumn(0, "bugtflag"));
  1107. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "quarter", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "quarter"));
  1108. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "assgym", "-");
  1109. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "orgbugtamt", 0);
  1110. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "revapptotalamt", 0);
  1111. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "revsupmbugtappamt", 0);
  1112. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "mainrec", "");
  1113. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "calcbase", "");
  1114. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "delflag", "Y");
  1115. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "status", "1");
  1116. grd_revbugtapplist.setCellPos(grd_revbugtapplist.getBindCellIndex("body", "acntcd"));
  1117. grd_revbugtapplist.showEditor(true);
  1118. grd_revbugtapplist_onexpanddown();
  1119. ds_hidden.setColumn(0, "bugtaddflag", "Y");
  1120. }
  1121. function btn_addrow_onclick(obj:Button, e:ClickEventInfo)
  1122. {
  1123. if(ds_hidden.getColumn(0, "updateflag") == "Y")
  1124. {
  1125. grd_revbugtlist_oncellclick();
  1126. }
  1127. if(ds_main_acntlist_revacntlist.rowposition > -1)
  1128. {
  1129. if(ds_main_bugtlist_revbugtapplist.rowcount == 1)
  1130. {
  1131. if(ds_main_bugtlist_revbugtapplist.getColumn(0, "assgym") == "-")
  1132. {
  1133. sysf_messageBox("년간 배정이 있어 추가 배정이 불가능 합니다.", "I000");
  1134. return false;
  1135. }
  1136. }
  1137. if(ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntcd") == "99999999")
  1138. {
  1139. return;
  1140. }
  1141. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  1142. {
  1143. sysf_messageBox("신청된 예산이므로 추가 또는 삭제를 할 수", "I004");
  1144. return;
  1145. }
  1146. ds_main_revbgdtlist_revbugtdetaillist.clearData();
  1147. var addRow = ds_main_bugtlist_revbugtapplist.addRow();
  1148. misfSetReadOnlyCol(grd_revbugtapplist, "acntcd,acntnm,assgym", false, grd_revbugtapplist.row);
  1149. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "instcd", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "instcd"));
  1150. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "acntyy", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntyy"));
  1151. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "deptcd", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "deptcd"));
  1152. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "acntcd", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntcd"));
  1153. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "acntnm", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntnm"));
  1154. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "bugtflag", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "bugtflag"));
  1155. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "mainrec", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "acntnm"));
  1156. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "quarter", ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "quarter"));
  1157. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "orgbugtamt", 0);
  1158. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "revapptotalamt", 0);
  1159. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "revsupmbugtappamt", 0);
  1160. ds_main_bugtlist_revbugtapplist.setColumn(addRow, "status", "1");
  1161. ds_hidden.setColumn(0, "updateflag", "Y");
  1162. if(ds_main_bugtlist_revbugtapplist.rowcount == 1)
  1163. {
  1164. ds_main_bugtlist_revbugtapplist.setColumn(0, "assgym", "-");
  1165. }
  1166. }
  1167. }
  1168. function btn_delrow_onclick(obj:Button, e:ClickEventInfo)
  1169. {
  1170. if(ds_main_bugtlist_revbugtapplist.getColumn(0, "delflag") == "N")
  1171. {
  1172. sysf_messageBox("본예산 신청내역은 삭제 할 수", "I004");
  1173. return;
  1174. }
  1175. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  1176. {
  1177. sysf_messageBox("신청된 예산이므로 추가 또는 삭제를 할 수", "I004");
  1178. return;
  1179. }
  1180. // for(var i = 0; i < ds_main_bugtlist_revbugtapplist.rowcount; i++)
  1181. // {
  1182. // grd_revbugtapplist.select(i, grd_revbugtapplist.colRef("acntcd"), i, grd_revbugtapplist.colRef("mainrec")) = false;
  1183. // }
  1184. var iRowStatus = ds_main_bugtlist_revbugtapplist.getRowType(ds_main_bugtlist_revbugtapplist.rowposition);
  1185. if (iRowStatus == 8)
  1186. {
  1187. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1188. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "");
  1189. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1190. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = false;
  1191. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  1192. {
  1193. ds_main_revbgdtlist_revbugtdetaillist.setRowType(i, "");
  1194. }
  1195. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = true;
  1196. }
  1197. else if(iRowStatus == 2)
  1198. {
  1199. ds_main_bugtlist_revbugtapplist.deleteRow(ds_main_bugtlist_revbugtapplist.rowposition);
  1200. grd_revbugtapplist_oncellclick();
  1201. }
  1202. else if(iRowStatus == 1 || iRowStatus == 4)
  1203. {
  1204. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1205. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "d");
  1206. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1207. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = false;
  1208. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  1209. {
  1210. ds_main_revbgdtlist_revbugtdetaillist.setRowType(i, "d");
  1211. }
  1212. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = true;
  1213. }
  1214. fSetRevAmt();
  1215. }
  1216. function fSetRevAmt()
  1217. {
  1218. var iSumAppAmt = 0;
  1219. for(var i = 0; i < ds_main_bugtlist_revbugtapplist.rowcount; i++)
  1220. {
  1221. iSumAppAmt += utlf_isNull(parseInt(ds_main_bugtlist_revbugtapplist.getColumn(i, "revapptotalamt"))) ? 0 : ds_main_bugtlist_revbugtapplist.getColumn(i, "revapptotalamt");
  1222. }
  1223. ds_main_acntlist_revacntlist.setColumn(ds_main_acntlist_revacntlist.rowposition, "bugtappsumamt", iSumAppAmt);
  1224. ds_main_acntlist_revacntlist.setColumn(ds_main_acntlist_revacntlist.rowposition, "revsupmappamt", parseInt(ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "bugtappsumamt")) - parseInt(ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "orgbugtamt")));
  1225. }
  1226. function btn_detailaddrow_onclick(obj:Button, e:ClickEventInfo)
  1227. {
  1228. if(ds_main_bugtlist_revbugtapplist.rowcount > 1 && ds_main_bugtlist_revbugtapplist.rowposition > -1)
  1229. {
  1230. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  1231. {
  1232. sysf_messageBox("신청된 예산이므로 추가 할 수", "I004");
  1233. return;
  1234. }
  1235. if(utlf_isNull(ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "acntcd")))
  1236. {
  1237. sysf_messageBox("본예산 신청할 계정을 선택하세요", "I999");
  1238. return;
  1239. }
  1240. var addRow = ds_main_revbgdtlist_revbugtdetaillist.addRow();
  1241. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "instcd", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "instcd"));
  1242. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "acntyy", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "acntyy"));
  1243. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "deptcd", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "deptcd"));
  1244. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "acntcd", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "acntcd"));
  1245. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "bugtflag", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "bugtflag"));
  1246. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "assgym", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "assgym"));
  1247. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "quarter", ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "quarter"));
  1248. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "appamt", 0);
  1249. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "sumamt", 0);
  1250. ds_main_revbgdtlist_revbugtdetaillist.setColumn(addRow, "orgappamt", 0);
  1251. grd_revbugtdetaillist.setCellPos(grd_revbugtdetaillist.getBindCellIndex("body", "appresn"));
  1252. grd_revbugtdetaillist.showEditor(true);
  1253. }
  1254. }
  1255. function btn_detaildelrow_onclick(obj:Button, e:ClickEventInfo)
  1256. {
  1257. if(ds_main_revbgdtlist_revbugtdetaillist.getColumn(ds_main_revbgdtlist_revbugtdetaillist.rowposition, "delflag") == "N")
  1258. {
  1259. sysf_messageBox("본예산 신청내역은 삭제 할 수", "I004");
  1260. return;
  1261. }
  1262. if(ds_main_acntlist_revacntlist.getColumn(ds_main_acntlist_revacntlist.rowposition, "revsupmbugtappyn") == "Y")
  1263. {
  1264. sysf_messageBox("신청된 예산이므로 삭제 할 수", "I004");
  1265. return;
  1266. }
  1267. var iRowStatus = ds_main_revbgdtlist_revbugtdetaillist.getRowType(ds_main_revbgdtlist_revbugtdetaillist.rowposition);
  1268. if (iRowStatus == 8)
  1269. {
  1270. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = false;
  1271. ds_main_revbgdtlist_revbugtdetaillist.setRowType(ds_main_revbgdtlist_revbugtdetaillist.rowposition, "");
  1272. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = true;
  1273. }
  1274. else if(iRowStatus == 2)
  1275. {
  1276. ds_main_revbgdtlist_revbugtdetaillist.deleteRow(ds_main_revbgdtlist_revbugtdetaillist.rowposition);
  1277. }
  1278. else if(iRowStatus == 1 || iRowStatus == 4)
  1279. {
  1280. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = false;
  1281. ds_main_revbgdtlist_revbugtdetaillist.setRowType(ds_main_revbgdtlist_revbugtdetaillist.rowposition, "d");
  1282. ds_main_revbgdtlist_revbugtdetaillist.updatecontrol = true;
  1283. }
  1284. fSetDetailListOrgAmt();
  1285. var iCnt = 0;
  1286. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  1287. {
  1288. if(ds_main_revbgdtlist_revbugtdetaillist.getRowType(i) == 8)
  1289. {
  1290. iCnt ++ ;
  1291. }
  1292. }
  1293. if(ds_main_revbgdtlist_revbugtdetaillist.rowcount == iCnt)
  1294. {
  1295. if(ds_main_bugtlist_revbugtapplist.getRowType(ds_main_bugtlist_revbugtapplist.rowposition) != 2)
  1296. {
  1297. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1298. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "d");
  1299. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1300. }
  1301. else
  1302. {
  1303. ds_main_bugtlist_revbugtapplist.deleteRow(ds_main_bugtlist_revbugtapplist.rowposition);
  1304. }
  1305. }
  1306. else
  1307. {
  1308. if(ds_main_bugtlist_revbugtapplist.getRowType(ds_main_bugtlist_revbugtapplist.rowposition) != 2)
  1309. {
  1310. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1311. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "u");
  1312. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1313. }
  1314. }
  1315. }
  1316. function btn_cancel_onclick(obj:Button, e:ClickEventInfo)
  1317. {
  1318. fSetRevAmtAppCancel();
  1319. }
  1320. function fSetRevAmtAppCancel()
  1321. {
  1322. if(String(group4.ipt_acntyy.value).length != 4 || (utlf_isNull(group4.ipt_deptcd.value) && utlf_isNull(group4.ipt_depthngnm.value)))
  1323. {
  1324. sysf_messageBox("회계년도 또는 부서코드가", "I004");
  1325. return;
  1326. }
  1327. var sName = this.getFocus().name;
  1328. var iRet;
  1329. if(sName == "btn_app")
  1330. {
  1331. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  1332. {
  1333. sysf_messageBox("이미 신청된 예산", "E008");
  1334. return;
  1335. }
  1336. iRet = sysf_messageBox("추경예산 신청 하시겠습니까", "Q999");
  1337. }
  1338. else if(sName == "btn_cancel")
  1339. {
  1340. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "N")
  1341. {
  1342. sysf_messageBox("신청되지 않은 예산", "E008");
  1343. return;
  1344. }
  1345. iRet = sysf_messageBox("추경예산 신청 취소 하시겠습니까", "Q999");
  1346. }
  1347. if(iRet == 6)
  1348. {
  1349. if(sName == "btn_app")
  1350. {
  1351. ds_send_appcancelparams.setColumn(0, "flag", "revapp");
  1352. sYn = "Y";
  1353. }
  1354. else if(sName == "btn_cancel")
  1355. {
  1356. ds_send_appcancelparams.setColumn(0, "flag", "revcancel");
  1357. sYn = "N";
  1358. }
  1359. ds_send_appcancelparams.setColumn(0, "instcd", ds_send_retrparam.getColumn(0, "instcd"));
  1360. ds_send_appcancelparams.setColumn(0, "acntyy", ds_send_retrparam.getColumn(0, "acntyy"));
  1361. ds_send_appcancelparams.setColumn(0, "deptcd", ds_send_retrparam.getColumn(0, "deptcd"));
  1362. ds_send_appcancelparams.setColumn(0, "bugtflag", ds_send_retrparam.getColumn(0, "bugtflag"));
  1363. ds_send_appcancelparams.setColumn(0, "quarter", ds_send_retrparam.getColumn(0, "quarter"));
  1364. var oParam = {};
  1365. oParam.id = "TXRBQ00603";
  1366. oParam.service = "bugtappapp.BugtApp";
  1367. oParam.method = "reqExeQuarterSaveBugtApp";
  1368. oParam.inds = "req=ds_send_appcancelparams";
  1369. oParam.outds = "";
  1370. oParam.async = false;
  1371. oParam.callback = "cf_TXRBQ00603";
  1372. tranf_submit(oParam);
  1373. }
  1374. group4.btn_search.click();
  1375. }
  1376. function cf_TXRBQ00603(sSvcId, nErrorCode, sErrorMsg)
  1377. {
  1378. if(nErrorCode < 0)
  1379. {
  1380. return;
  1381. }
  1382. else
  1383. {
  1384. for(var i = 0; i < ds_main_acntlist_revacntlist.rowcount; i++)
  1385. {
  1386. ds_main_acntlist_revacntlist.setRowType(i, "revsupmbugtappyn", sYn);
  1387. }
  1388. }
  1389. }
  1390. function btn_alldel_onclick(obj:Button, e:ClickEventInfo)
  1391. {
  1392. if(ds_main_acntlist_revacntlist.getColumn(0, "revsupmbugtappyn") == "Y")
  1393. {
  1394. sysf_messageBox("이미 신청된 예산", "E008");
  1395. return;
  1396. }
  1397. if (sysf_messageBox("추경 [" + group4.rdo_bugtflag.text + "] 전체 내역을", "Q001") == "6")
  1398. {
  1399. var oParam = {};
  1400. oParam.id = "TXRBQ00703";
  1401. oParam.service = "bugtappapp.BugtApp";
  1402. oParam.method = "reqExeQuarterDelAllRevAcnt";
  1403. oParam.inds = "req=ds_send_retrparam";
  1404. oParam.outds = "";
  1405. oParam.async = false;
  1406. //oParam.callback = "cf_TXRBQ00703";
  1407. tranf_submit(oParam);
  1408. group4.btn_search.click();
  1409. }
  1410. }
  1411. function btn_excelupload_onclick(obj:Button, e:ClickEventInfo)
  1412. {
  1413. dsf_createDsRow("ds_source_slipinfo", [{col:"acntyy", type:"STRING", size:256 , val : group4.ipt_acntyy.value}
  1414. , {col:"deptcd", type:"STRING", size:256 , val : group4.ipt_deptcd.value}
  1415. , {col:"depthngnm", type:"STRING", size:256 , val : group4.ipt_depthngnm.value}
  1416. , {col:"workflag", type:"STRING", size:256 , val : "2"}]);
  1417. var objArg = new Object();
  1418. objArg.arg_ds_target = ds_source_slipinfo;
  1419. frmf_modal("SMRBQ00500", "SMRBQ00500", objArg, "", "", "", "", "", "", "", "", "", "M");
  1420. group4.btn_search.click();
  1421. }
  1422. function btn_save_onclick(obj:Button, e:ClickEventInfo)
  1423. {
  1424. fSave();
  1425. misfSetReadOnlyCol(grd_revbugtapplist, "acntcd,acntnm,assgym", true);
  1426. fSetRevAmt()
  1427. if(ds_hidden.getColumn(0, "bugtaddflag") == "Y")
  1428. {
  1429. group4.btn_search.click();
  1430. ds_hidden.setColumn(0, "bugtaddflag", "N");
  1431. }
  1432. }
  1433. function fSave()
  1434. {
  1435. if(ds_main_bugtlist_revbugtapplist.rowcount == 0)
  1436. {
  1437. return;
  1438. }
  1439. for(var i = 0; i < ds_main_bugtlist_revbugtapplist.rowcount; i++)
  1440. {
  1441. if(utlf_isNull(ds_main_bugtlist_revbugtapplist.getColumn(i, "assgym")))
  1442. {
  1443. sysf_messageBox("배정월에 공백을 삽입할 수", "I004");
  1444. return;
  1445. }
  1446. }
  1447. for(var i = 0; i < ds_main_revbgdtlist_revbugtdetaillist.rowcount; i++)
  1448. {
  1449. if(utlf_isNull(ds_main_revbgdtlist_revbugtdetaillist.getColumn(i, "appresn")))
  1450. {
  1451. sysf_messageBox("산출 내역에 공백을 삽입할 수", "I004");
  1452. return;
  1453. }
  1454. }
  1455. var updtdata_bugtapplist = grdf_getGridUpdateData(grd_revbugtapplist).rowcount;
  1456. var updtdata_bugtdetaillist = grdf_getGridUpdateData(grd_revbugtdetaillist).rowcount;
  1457. if(updtdata_bugtapplist == 0 && updtdata_bugtdetaillist == 0)
  1458. {
  1459. sysf_messageBox("변경된 내역이", "I004");
  1460. return;
  1461. }
  1462. if(ds_main_bugtlist_revbugtapplist.getColumn(ds_main_bugtlist_revbugtapplist.rowposition, "status") == "1")
  1463. {
  1464. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1465. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "i");
  1466. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1467. }
  1468. if(updtdata_bugtapplist != 0)
  1469. {
  1470. vRowStatus = ds_main_bugtlist_revbugtapplist.getRowType(ds_main_bugtlist_revbugtapplist.rowposition);
  1471. var oParam = {};
  1472. oParam.id = "TXRBQ00701";
  1473. oParam.service = "bugtappapp.BugtApp";
  1474. oParam.method = "reqExeSaveQuarterRevAcntApp";
  1475. oParam.inds = "applist=ds_main_bugtlist_revbugtapplist:u";
  1476. oParam.outds = "";
  1477. oParam.async = false;
  1478. //oParam.callback = "cf_TXRBQ00701";
  1479. tranf_submit(oParam);
  1480. if(vRowStatus == 8)
  1481. {
  1482. var oParam = {};
  1483. oParam.id = "TRRBQ00702";
  1484. oParam.service = "bugtappapp.BugtApp";
  1485. oParam.method = "reqGetQuarterRevAcntBugtList";
  1486. oParam.inds = "req=ds_send_retrparam2";
  1487. oParam.outds = "ds_main_bugtlist_revbugtapplist=revbugtapplist";
  1488. oParam.async = false;
  1489. //oParam.callback = "cf_TRRBQ00702";
  1490. tranf_submit(oParam);
  1491. if(ds_main_bugtlist_revbugtapplist.rowcount > 1)
  1492. {
  1493. ds_main_bugtlist_revbugtapplist.rowposition = 0;
  1494. grd_revbugtapplist_oncellclick();
  1495. }
  1496. }
  1497. else
  1498. {
  1499. ds_main_bugtlist_revbugtapplist.updatecontrol = false;
  1500. ds_main_bugtlist_revbugtapplist.setRowType(ds_main_bugtlist_revbugtapplist.rowposition, "");
  1501. ds_main_bugtlist_revbugtapplist.updatecontrol = true;
  1502. }
  1503. }
  1504. var oParam = {};
  1505. oParam.id = "TXRBQ00702";
  1506. oParam.service = "bugtappapp.BugtApp";
  1507. oParam.method = "reqExeSaveQuarterRevAcntAppDetail";
  1508. oParam.inds = "detaillist=ds_main_revbgdtlist_revbugtdetaillist:u";
  1509. oParam.outds = "";
  1510. oParam.async = false;
  1511. //oParam.callback = "cf_TXRBQ00702";
  1512. tranf_submit(oParam);
  1513. grd_revbugtapplist_oncellclick();
  1514. ds_hidden.setColumn(0, "updateflag", "N");
  1515. }
  1516. function btn_app_onclick(obj:Button, e:ClickEventInfo)
  1517. {
  1518. fSetRevAmtAppCancel();
  1519. }
  1520. ]]></Script>
  1521. </Form>
  1522. </FDL>