SMRAR02000_년감가상각조회.xfdl 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRAR02000" position="absolute 0 0 1198 785" titletext="년감가상각조회" oninit="SMRAR02000_oninit" onload="SMRAR02000_onload">
  5. <Layouts>
  6. <Layout>
  7. <Static id="caption6" text="년 감가상각 조회" class="tit_1" position="absolute 0 0 245 25"/>
  8. <Shape id="line2" class="line_6" position="absolute 0 38 1195 44" anchor="left top right"/>
  9. <Div id="grp_sea" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 42 1195 104">
  10. <Layouts>
  11. <Layout>
  12. <Shape id="line5" linetype="vertical" class="line_4" position="absolute 1119 8 1125 55" anchor="top right"/>
  13. <Button id="button2" taborder="10" text="조회" class="btn1" position="absolute 1133 21 1189 43" anchor="top right" onclick="grp_sea_button2_onclick"/>
  14. <Combo id="cmb_instcd_search" taborder="11" class="combo_s_essential" enable="false" position="absolute 100 10 250 29" onitemchanged="grp_sea_cmb_instcd_search_onitemchanged"/>
  15. <MaskEdit id="ipt_yyyy" taborder="12" mask="####" autoselect="true" autoskip="true" class="input_s_essential" position="absolute 350 35 450 54" style="align:left middle;" maskchar=" " type="string" trimtype="both"/>
  16. <Edit id="ipt_fixasetcd_search" taborder="13" autoselect="true" autoskip="true" class="input_search" position="absolute 807 33 902 52"/>
  17. <Edit id="ipt_fixasetnm_search" taborder="14" autoselect="true" autoskip="true" class="input_search" position="absolute 925 33 1110 52"/>
  18. <Static id="caption2" text="대 분 류 :" class="search_name" position="absolute 461 11 550 28"/>
  19. <Button id="btn_fixasetcd" taborder="15" class="icon_search" position="absolute 906 35 922 51" onclick="grp_sea_btn_fixasetcd_onclick"/>
  20. <Static id="caption3" text="기관코드 :" class="search_name" position="absolute 11 10 100 27"/>
  21. <Combo id="cmb_lrgcd_search" taborder="16" position="absolute 550 10 700 29" onitemchanged="grp_sea_cmb_lrgcd_search_onitemchanged"/>
  22. <Combo id="cmb_goodflag_search" taborder="17" innerdataset="@ds_init_goodflag" codecolumn="value" datacolumn="label" class="input_s_essential" position="absolute 350 10 450 29" onitemchanged="grp_sea_cmb_goodflag_search_onitemchanged"/>
  23. <Static id="cap_codeflag" text="상각년도 :" class="search_name" position="absolute 260 35 350 52"/>
  24. <Static id="caption8" text="자산구분 :" class="search_name" position="absolute 260 10 350 27"/>
  25. <Static id="caption9" text="자산코드 :" class="search_name" position="absolute 715 34 825 51"/>
  26. <Edit id="ipt_mngtdeptcd_search" taborder="18" autoselect="true" autoskip="true" class="input_search" position="absolute 807 8 902 27"/>
  27. <Static id="cap_installplcecd" text="사용부서 :" class="search_name" position="absolute 715 9 807 26"/>
  28. <Button id="btn_mngtdeptcd_search" taborder="19" class="icon_search" position="absolute 906 8 922 24" onclick="grp_sea_btn_mngtdeptcd_search_onclick"/>
  29. <Edit id="ipt_mngtdeptnm_search" taborder="20" autoselect="true" autoskip="true" class="input_search" position="absolute 925 8 1110 27"/>
  30. <Combo id="cmb_acntcd_search" taborder="21" innerdataset="@ds_init_acntlist" codecolumn="acntcd" datacolumn="acntnm" position="absolute 550 35 700 54" onitemchanged="grp_sea_cmb_acntcd_search_onitemchanged"/>
  31. <Static id="caption5" text="계정과목 :" class="search_name" position="absolute 460 35 550 52"/>
  32. <Static id="caption10" text="조회범위 :" class="search_name" position="absolute 11 35 100 52"/>
  33. <Combo id="cmb_page_search" taborder="22" innerdataset="@ds_init_pagelist" codecolumn="value" datacolumn="label" class="input_s_essential" position="absolute 100 35 250 54"/>
  34. </Layout>
  35. </Layouts>
  36. </Div>
  37. <Shape id="line3" class="line_10" position="absolute 0 132 1195 138" anchor="left top right"/>
  38. <Button id="btn_excel" taborder="2" text="Excel 저장" class="btn5" position="absolute 1119 113 1194 132" anchor="top right" onclick="btn_excel_onclick"/>
  39. <Grid id="grd_main" taborder="3" binddataset="ds_grd_main" useinputpanel="false" position="absolute 0 137 1194 747" autoenter="select" cellsizingtype="col" anchor="all">
  40. <Formats>
  41. <Format id="default">
  42. <Columns>
  43. <Column size="21"/>
  44. <Column size="100"/>
  45. <Column size="0"/>
  46. <Column size="112"/>
  47. <Column size="99"/>
  48. <Column size="180"/>
  49. <Column size="100"/>
  50. <Column size="60"/>
  51. <Column size="50"/>
  52. <Column size="90"/>
  53. <Column size="80"/>
  54. <Column size="100"/>
  55. <Column size="120"/>
  56. <Column size="70"/>
  57. <Column size="120"/>
  58. <Column size="70"/>
  59. <Column size="90"/>
  60. <Column size="100"/>
  61. <Column size="100"/>
  62. <Column size="90"/>
  63. <Column size="80"/>
  64. </Columns>
  65. <Rows>
  66. <Row size="24" band="head"/>
  67. <Row size="24"/>
  68. </Rows>
  69. <Band id="head">
  70. <Cell/>
  71. <Cell col="1" text="기관코드"/>
  72. <Cell col="2" text="계정코드"/>
  73. <Cell col="3" text="계정명"/>
  74. <Cell col="4" text="자산코드"/>
  75. <Cell col="5" text="자산명"/>
  76. <Cell col="6" text="규격"/>
  77. <Cell col="7" text="단위"/>
  78. <Cell col="8" text="수량"/>
  79. <Cell col="9" text="구입금액"/>
  80. <Cell col="10" text="구입일"/>
  81. <Cell col="11" text="사용부서"/>
  82. <Cell col="12" text="공급처"/>
  83. <Cell col="13" text="내용년수"/>
  84. <Cell col="14" text="모델명"/>
  85. <Cell col="15" text="취득금액"/>
  86. <Cell col="16" text="전년누계액"/>
  87. <Cell col="17" text="당기상각액"/>
  88. <Cell col="18" text="폐기상각비"/>
  89. <Cell col="19" text="감가누계"/>
  90. <Cell col="20" text="잔존가액"/>
  91. </Band>
  92. <Band id="body">
  93. <Cell celltype="head" expr="currow+1"/>
  94. <Cell col="1" text="bind:instcd"/>
  95. <Cell col="2" text="bind:acntcd"/>
  96. <Cell col="3" text="bind:acntnm"/>
  97. <Cell col="4" text="bind:fixasetcd"/>
  98. <Cell col="5" displaytype="date" style="align:center middle;" text="bind:goodflaghngnm" calendardisplaynulltype="nulltext"/>
  99. <Cell col="6" text="bind:goodspec"/>
  100. <Cell col="7" text="bind:fixasetunit"/>
  101. <Cell col="8" text="bind:qty"/>
  102. <Cell col="9" displaytype="number" text="bind:possnamt"/>
  103. <Cell col="10" displaytype="date" text="bind:possndd" calendardisplaynulltype="nulltext"/>
  104. <Cell col="11" text="bind:mngtdeptnm"/>
  105. <Cell col="12" text="bind:suplplcenm"/>
  106. <Cell col="13" text="bind:cntsyearno"/>
  107. <Cell col="14" text="bind:goodmodel"/>
  108. <Cell col="15" displaytype="number" text="bind:basejsak"/>
  109. <Cell col="16" displaytype="number" text="bind:bbaseksckeum"/>
  110. <Cell col="17" displaytype="number" text="bind:danggisangak"/>
  111. <Cell col="18" displaytype="number" text="bind:cheobunsangak"/>
  112. <Cell col="19" displaytype="number" text="bind:baseksckeum"/>
  113. <Cell col="20" displaytype="number" text="bind:janjonsak"/>
  114. </Band>
  115. </Format>
  116. </Formats>
  117. </Grid>
  118. <Static id="caption21" text="출력 목록" class="tit_2" position="absolute 0 116 131 137"/>
  119. <Static id="caption7" text="(* 10,000건 이상인 경우 10,000건만 조회가 됩니다. 조회범위 조건을 입력 하신후 조회하세요.)" position="absolute 85 114 645 128"/>
  120. <Static id="caption1" text="가수금합계" class="cell_1" visible="false" position="absolute 134 750 254 773" anchor="left bottom" style="align:center middle;"/>
  121. <MaskEdit id="cpt_gaamtsum" taborder="4" position="absolute 256 750 407 773" style="background:#ffccccff;" mask="9,9999999999999999" anchor="left bottom" visible="false"/>
  122. </Layout>
  123. </Layouts>
  124. <Objects>
  125. <Dataset id="ds_send_fixasetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_fixasetlist_oncolumnchanged">
  126. <ColumnInfo>
  127. <Column id="instcd_search" type="STRING" size="256"/>
  128. <Column id="fixasetcd_search" type="STRING" size="256"/>
  129. <Column id="fixasetnm_search" type="STRING" size="256"/>
  130. <Column id="lrgcd_search" type="STRING" size="256"/>
  131. <Column id="before_yyyy" type="STRING" size="256"/>
  132. <Column id="excute_yyyy" type="STRING" size="256"/>
  133. <Column id="goodflag_search" type="STRING" size="256"/>
  134. <Column id="mngtdeptcd_search" type="STRING" size="256"/>
  135. <Column id="mngtdeptnm_search" type="STRING" size="256"/>
  136. <Column id="acntcd_search" type="STRING" size="256"/>
  137. <Column id="page_search" type="STRING" size="256"/>
  138. </ColumnInfo>
  139. <Rows>
  140. <Row>
  141. <Col id="instcd_search"/>
  142. <Col id="fixasetcd_search"/>
  143. <Col id="fixasetnm_search"/>
  144. <Col id="lrgcd_search"/>
  145. <Col id="before_yyyy"/>
  146. <Col id="excute_yyyy"/>
  147. <Col id="goodflag_search"/>
  148. <Col id="mngtdeptcd_search"/>
  149. <Col id="mngtdeptnm_search"/>
  150. <Col id="acntcd_search"/>
  151. <Col id="page_search"/>
  152. </Row>
  153. </Rows>
  154. </Dataset>
  155. <Dataset id="ds_main_maindatalist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  156. <ColumnInfo>
  157. <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
  158. <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
  159. <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
  160. <Column id="fixasetcd" type="STRING" size="256" sumtext="자산코드"/>
  161. <Column id="goodflaghngnm" type="STRING" size="256" sumtext="자산명"/>
  162. <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
  163. <Column id="fixasetunit" type="STRING" size="256" sumtext="단위"/>
  164. <Column id="qty" type="STRING" size="256" sumtext="수량"/>
  165. <Column id="possnamt" type="STRING" size="256" sumtext="구입금액"/>
  166. <Column id="possndd" type="STRING" size="256" sumtext="구입일"/>
  167. <Column id="mngtdeptnm" type="STRING" size="256" sumtext="사용부서"/>
  168. <Column id="suplplcenm" type="STRING" size="256" sumtext="공급처"/>
  169. <Column id="cntsyearno" type="STRING" size="256" sumtext="내용년수"/>
  170. <Column id="goodmodel" type="STRING" size="256" sumtext="모델명"/>
  171. <Column id="basejsak" type="STRING" size="256" sumtext="취득금액"/>
  172. <Column id="bbaseksckeum" type="STRING" size="256" sumtext="전년누계액"/>
  173. <Column id="danggisangak" type="STRING" size="256" sumtext="당기상각액"/>
  174. <Column id="cheobunsangak" type="STRING" size="256" sumtext="폐기상각비"/>
  175. <Column id="baseksckeum" type="STRING" size="256" sumtext="감가누계"/>
  176. <Column id="janjonsak" type="STRING" size="256" sumtext="잔존가액"/>
  177. </ColumnInfo>
  178. </Dataset>
  179. <Dataset id="ds_init_pagelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  180. <Dataset id="ds_init_goodflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  181. <Dataset id="ds_init_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  182. <ColumnInfo>
  183. <Column id="acntnm" type="STRING" size="256"/>
  184. <Column id="acntcd" type="STRING" size="256"/>
  185. </ColumnInfo>
  186. <Rows>
  187. <Row>
  188. <Col id="acntnm">--전체--</Col>
  189. <Col id="acntcd"/>
  190. </Row>
  191. </Rows>
  192. </Dataset>
  193. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  194. </Objects>
  195. <Bind>
  196. <BindItem id="item0" compid="grp_sea.cmb_instcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="instcd_search"/>
  197. <BindItem id="item1" compid="grp_sea.cmb_goodflag_search" propid="value" datasetid="ds_send_fixasetlist" columnid="goodflag_search"/>
  198. <BindItem id="item2" compid="grp_sea.cmb_lrgcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="lrgcd_search"/>
  199. <BindItem id="item3" compid="grp_sea.ipt_mngtdeptcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="mngtdeptcd_search"/>
  200. <BindItem id="item4" compid="grp_sea.ipt_mngtdeptnm_search" propid="value" datasetid="ds_send_fixasetlist" columnid="mngtdeptnm_search"/>
  201. <BindItem id="item5" compid="grp_sea.cmb_page_search" propid="value" datasetid="ds_send_fixasetlist" columnid="page_search"/>
  202. <BindItem id="item6" compid="grp_sea.ipt_yyyy" propid="value" datasetid="ds_send_fixasetlist" columnid="excute_yyyy"/>
  203. <BindItem id="item7" compid="grp_sea.cmb_acntcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="acntcd_search"/>
  204. <BindItem id="item8" compid="grp_sea.ipt_fixasetcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="fixasetcd_search"/>
  205. <BindItem id="item9" compid="grp_sea.ipt_fixasetnm_search" propid="value" datasetid="ds_send_fixasetlist" columnid="fixasetnm_search"/>
  206. </Bind>
  207. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  208. * System Name :
  209. * Job Name :
  210. * Creator :
  211. * Make Date : 2017-06-19
  212. * Description :
  213. *---------------------------------------------------------------------------------------
  214. * Modify Date Modifier Modify Description
  215. *---------------------------------------------------------------------------------------
  216. * 2017-06-19 Live Converter TF->XP
  217. *
  218. *---------------------------------------------------------------------------------------
  219. ****************************************************************************************/
  220. include "com_commonxp::comm_main.xjs";
  221. include "mis_miscommonxp::MIS.xjs";
  222. include "mis_miscommonxp::RSZ001.xjs";
  223. function SMRAR02000_oninit(obj:Form, e:InitEventInfo)
  224. {
  225. frmf_initForm(obj);
  226. }
  227. function SMRAR02000_onload(obj:Form, e:LoadEventInfo)
  228. {
  229. grdf_initGrid(grd_main);
  230. fInitialize();
  231. }
  232. function fInitialize()
  233. {
  234. misfComboComCdList("Z0007", grp_sea.cmb_instcd_search, "N"); //기관코드
  235. grp_sea.cmb_instcd_search.value = sysf_getUserInfo("dutplceinstcd");
  236. rszfGoodFlagListByPgmGubn(grp_sea.cmb_goodflag_search,"2","N"); //유형자산구분
  237. grp_sea.cmb_goodflag_search.index = 0;
  238. rszfLMSComboList(grp_sea.cmb_goodflag_search.value, "", "", "grp_sea.cmb_lrgcd_search", "", "L");
  239. frmf_addComboItem("grp_sea.cmb_goodflag_search","--전체--","","above");
  240. frmf_addComboItem("grp_sea.cmb_lrgcd_search","--전체--","","above");
  241. grp_sea.cmb_goodflag_search.index = 0;
  242. grp_sea.cmb_lrgcd_search.index = 0;
  243. ds_columnidChange();
  244. fGetPageList();
  245. }
  246. function ds_columnidChange()
  247. {
  248. dsf_makeValue(ds_send, "instcd", "string", ds_send_fixasetlist.getColumn(0, "instcd_search"), 0);
  249. dsf_makeValue(ds_send, "yyyy", "string", ds_send_fixasetlist.getColumn(0, "excute_yyyy"), 0);
  250. dsf_makeValue(ds_send, "goodflag", "string", ds_send_fixasetlist.getColumn(0, "goodflag_search"), 0);
  251. dsf_makeValue(ds_send, "lrgcd", "string", ds_send_fixasetlist.getColumn(0, "lrgcd_search"), 0);
  252. dsf_makeValue(ds_send, "acntcd", "string", ds_send_fixasetlist.getColumn(0, "acntcd_search"), 0);
  253. dsf_makeValue(ds_send, "mngtdeptcd", "string", ds_send_fixasetlist.getColumn(0, "mngtdeptcd_search"), 0);
  254. dsf_makeValue(ds_send, "fixasetcd", "string", ds_send_fixasetlist.getColumn(0, "fixasetcd_search"), 0);
  255. }
  256. function fGetPageList()
  257. {
  258. if(String(grp_sea.ipt_yyyy.value).length == 4)
  259. {
  260. ds_columnidChange();
  261. var oParam = {};
  262. oParam.id = "TRRAR02003";
  263. oParam.service = "accountinginfoapp.AccountingInfo";
  264. oParam.method = "getYearSanggakPageList";
  265. oParam.inds = "req=ds_send";
  266. oParam.outds = "ds_init_pagelist=pagelist";
  267. oParam.async = false;
  268. //oParam.callback = "cf_TRRAR02003";
  269. tranf_submit(oParam);
  270. }
  271. if(String(grp_sea.ipt_yyyy.value).length != 4 || ds_init_pagelist.rowcount == 1)
  272. {
  273. ds_init_pagelist.clearData();
  274. dsf_makeValue(ds_init_pagelist, "label", "string", "--전체--", 0);
  275. dsf_makeValue(ds_init_pagelist, "value", "string", "", 0);
  276. }
  277. grp_sea.cmb_page_search.index = 0;
  278. }
  279. function grp_sea_cmb_instcd_search_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  280. {
  281. fGetPageList();
  282. }
  283. function grp_sea_cmb_goodflag_search_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  284. {
  285. rszfLMSComboList(obj.value, "", "", "grp_sea.cmb_lrgcd_search", "", "L");
  286. frmf_addComboItem("grp_sea.cmb_lrgcd_search","--전체--","","above");
  287. grp_sea.cmb_lrgcd_search.index = 0;
  288. frmf_inputEnterKey("grp_sea.cmb_lrgcd_search", "onitemchanged", new ItemChangeEventInfo );
  289. fGetPageList();
  290. }
  291. function grp_sea_cmb_lrgcd_search_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  292. {
  293. fGetAcntcdList();
  294. fGetPageList();
  295. }
  296. function fGetAcntcdList()
  297. {
  298. if(String(grp_sea.ipt_yyyy.value).length == 4)
  299. {
  300. ds_columnidChange();
  301. var oParam = {};
  302. oParam.id = "TRRAR02002";
  303. oParam.service = "accountinginfoapp.AccountingInfo";
  304. oParam.method = "getYearSanggakAcntList";
  305. oParam.inds = "req=ds_send";
  306. oParam.outds = "ds_init_acntlist=acntlist";
  307. oParam.async = false;
  308. //oParam.callback = "cf_TRRAR02002";
  309. tranf_submit(oParam);
  310. frmf_addComboItem("grp_sea.cmb_acntcd_search","--전체--","","above");
  311. if(ds_init_acntlist.rowcount != 0)
  312. {
  313. grp_sea.cmb_acntcd_search.index = 0;
  314. }
  315. }
  316. }
  317. function grp_sea_cmb_acntcd_search_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  318. {
  319. fGetPageList();
  320. }
  321. function ds_send_fixasetlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
  322. {
  323. if(e.columnid == "excute_yyyy")
  324. {
  325. grp_sea.ipt_yyyy.value = e.newvalue;
  326. grp_sea.ipt_yyyy.setFocus();
  327. fGetAcntcdList();
  328. fGetPageList();
  329. }
  330. if(e.columnid == "mngtdeptcd_search")
  331. {
  332. grp_sea.ipt_mngtdeptcd_search.value = e.newvalue;
  333. grp_sea.ipt_mngtdeptcd_search.setFocus();
  334. if(String(e.newvalue).length == 0)
  335. {
  336. grp_sea.ipt_mngtdeptnm_search.value = "";
  337. }
  338. else
  339. {
  340. rszfValidationCheck("TRRPZ00201", "deptcodelist", "refcond,deptcd", "deptcd," + e.newvalue, "", "mngtdeptcd_search,mngtdeptnm_search",grp_sea.ipt_mngtdeptcd_search, "SPRPZ00200", "","");
  341. }
  342. fGetPageList();
  343. }
  344. if(e.columnid == "mngtdeptnm_search")
  345. {
  346. grp_sea.ipt_mngtdeptnm_search.value = e.newvalue;
  347. grp_sea.ipt_mngtdeptnm_search.setFocus();
  348. if(String(e.newvalue).length == 0)
  349. {
  350. grp_sea.ipt_mngtdeptcd_search.value = "";
  351. }
  352. else
  353. {
  354. rszfValidationCheck("TRRPZ00201", "deptcodelist", "refcond,deptnm", "deptnm," + e.newvalue, "", "mngtdeptcd_search,mngtdeptnm_search",grp_sea.ipt_mngtdeptcd_search, "SPRPZ00200", "","");
  355. }
  356. }
  357. if(e.columnid == "fixasetcd_search")
  358. {
  359. grp_sea.ipt_fixasetcd_search.value = e.newvalue;
  360. grp_sea.ipt_fixasetcd_search.setFocus();
  361. if(!utlf_isNull(e.newvalue))
  362. {
  363. rszfValidationCheck("TRRSD00241", "rfcmfacdlist", "instcd,requirementcd,requirementnm,goodflag", grp_sea.cmb_instcd_search.value +",fixasetcd," + e.newvalue+"," + grp_sea.cmb_goodflag_search.value,
  364. "", "fixasetcd_search,fixasetnm_search", grp_sea.ipt_fixasetcd_search, "SPRSD00240","instcd,goodflag","grp_sea.cmb_instcd_search,grp_sea.cmb_goodflag_search");
  365. }
  366. else
  367. {
  368. grp_sea.ipt_fixasetnm_search.value = "";
  369. }
  370. }
  371. }
  372. function grp_sea_btn_mngtdeptcd_search_onclick(obj:Button, e:ClickEventInfo)
  373. {
  374. misfOpenPopUpList("02", grp_sea.ipt_mngtdeptcd_search,"","mngtdeptcd_search,mngtdeptnm_search");
  375. }
  376. function grp_sea_btn_fixasetcd_onclick(obj:Button, e:ClickEventInfo)
  377. {
  378. rszfOpenPopUpListByWndName(grp_sea.ipt_fixasetcd_search, "", "fixasetcd_search,fixasetnm_search","SPRSD00240","instcd,goodflag","grp_sea.cmb_instcd_search,grp_sea.cmb_goodflag_search");
  379. }
  380. function grp_sea_button2_onclick(obj:Button, e:ClickEventInfo)
  381. {
  382. if( fGetMainDataList() )
  383. {
  384. var oParam = {};
  385. oParam.id = "TRRAR02001";
  386. oParam.service = "accountinginfoapp.AccountingInfo";
  387. oParam.method = "getYearSanggaklist";
  388. oParam.inds = "req=ds_send_fixasetlist";
  389. oParam.outds = "ds_main_maindatalist=maindatalist";
  390. oParam.async = false;
  391. //oParam.callback = "cf_TRRAR02001";
  392. tranf_submit(oParam);
  393. }
  394. }
  395. function fGetMainDataList()
  396. {
  397. if (utlf_isNull(grp_sea.ipt_yyyy.value))
  398. {
  399. sysf_messageBox("작업년도를 ","C001");
  400. return false;
  401. }
  402. if ( String(grp_sea.ipt_yyyy.value).length != 4 )
  403. {
  404. sysf_messageBox("작업년도를 4 자리로","C001");
  405. return false;
  406. }
  407. return true;
  408. }
  409. function btn_excel_onclick(obj:Button, e:ClickEventInfo)
  410. {
  411. if( ds_main_maindatalist.rowcount > 0)
  412. {
  413. var fileName ="";
  414. if(ds_init_pagelist.rowcount == 1)
  415. {
  416. fileName = "년감가상각조회List_" + utlf_getCurrentDate();
  417. }
  418. else
  419. {
  420. fileName = "년감가상각조회List_" + utlf_getCurrentDate() + "_" + String(grp_sea.cmb_page_search.text).replace("/","of");
  421. }
  422. grdf_exportExcel(grd_main, fileName, "Sheet", "true", "", "");
  423. }
  424. else
  425. {
  426. sysf_messageBox("저장 데이터가","I004");
  427. }
  428. }
  429. ]]></Script>
  430. </Form>
  431. </FDL>