SMRAR01500_월감가상각조회.xfdl 25 KB

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