SMRAD02400_구매지출일자일괄변경.xfdl 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRAD02400" position="absolute 0 0 1196 800" titletext="구매지출일자일괄변경" onload="SMRAD02400_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div id="grp_srch" taborder="9" position="absolute 0 51 1195 91" class="div_SA2" anchor="left top right"/>
  8. <Div position="absolute 0 25 1195 53" id="grp_btn" scrollbars="autoboth" anchor="left top right">
  9. <Layouts>
  10. <Layout>
  11. <Button position="absolute 1139 1 1195 23" id="button36" class="btn4" text="저장" anchor="right" onclick="grp_btn_button36_onclick"/>
  12. <Button position="absolute 1068 1 1136 23" id="button35" class="btn4" visible="false" text="초기화" anchor="right" onclick="grp_btn_button35_onclick"/>
  13. <Shape position="absolute 0 22 1195 28" id="line9" class="line_6" anchor="left top right"/>
  14. </Layout>
  15. </Layouts>
  16. </Div>
  17. <Static id="caption6" text="구매지출일자일괄변경" class="tit_1" position="absolute 0 0 180 25"/>
  18. <Button id="btn_search" taborder="1" text="조회" class="btn1" position="absolute 1126 60 1182 82" onclick="btn_search_onclick" anchor="right"/>
  19. <Shape id="line13" linetype="vertical" class="line_4" visible="false" position="absolute 1110 60 1116 82" anchor="right"/>
  20. <Shape id="line1" class="line_10" position="absolute 0 115 1195 121" anchor="left top right"/>
  21. <Combo id="cmb_instcd" taborder="2" class="combo_essential" enable="false" position="absolute 78 61 193 80"/>
  22. <Static id="caption2" text="기관 :" class="search_name" position="absolute 12 62 73 79"/>
  23. <Grid id="grd_grntpsn1" taborder="3" binddataset="ds_main_grnt_grntlist2" useinputpanel="false" position="absolute 0 120 1195 799" anchor="all">
  24. <Formats>
  25. <Format id="default">
  26. <Columns>
  27. <Column size="25" band="left"/>
  28. <Column size="114"/>
  29. <Column size="203"/>
  30. <Column size="117"/>
  31. <Column size="123"/>
  32. <Column size="118"/>
  33. <Column size="125"/>
  34. <Column size="292"/>
  35. <Column size="54"/>
  36. <Column size="0"/>
  37. <Column size="0"/>
  38. <Column size="0"/>
  39. </Columns>
  40. <Rows>
  41. <Row size="24" band="head"/>
  42. <Row size="24"/>
  43. </Rows>
  44. <Band id="head">
  45. <Cell/>
  46. <Cell col="1" text="사업자번호"/>
  47. <Cell col="2" text="업체명"/>
  48. <Cell col="3" text="검수일자"/>
  49. <Cell col="4" text="예정일자"/>
  50. <Cell col="5" text="구입금액"/>
  51. <Cell col="6" text="매입채무액"/>
  52. <Cell col="7" text="계약건명"/>
  53. <Cell col="8" text="전송"/>
  54. <Cell col="9" text="caption2"/>
  55. <Cell col="10" text="caption3"/>
  56. <Cell col="11" text="caption6"/>
  57. </Band>
  58. <Band id="body">
  59. <Cell celltype="head" text="expr:currow+1"/>
  60. <Cell col="1" displaytype="text" text="bind:entrregno" enable="false"/>
  61. <Cell col="2" displaytype="text" text="bind:custnm"/>
  62. <Cell col="3" text="bind:ibgoymd" mask="####-##-##"/>
  63. <Cell col="4" displaytype="date" edittype="date" style="padding:0 0 0 0;" text="bind:yejungymd" calendardisplay="display"/>
  64. <Cell col="5" displaytype="number" text="bind:keumak"/>
  65. <Cell col="6" displaytype="number" text="bind:keumak1"/>
  66. <Cell col="7" displaytype="text" text="bind:rmrk"/>
  67. <Cell col="8" text="bind:signflag"/>
  68. <Cell col="9" text="bind:kydate"/>
  69. <Cell col="10" text="bind:kyseq"/>
  70. <Cell col="11" text="bind:ymdaction"/>
  71. </Band>
  72. </Format>
  73. </Formats>
  74. </Grid>
  75. <Calendar id="ipt_unsldd" taborder="4" class="input_essential" position="absolute 350 61 465 80" onchanged="ipt_unsldd_onchanged"/>
  76. <Static id="caption5" text="지출예정일자 :" class="search_name" position="absolute 230 62 342 79"/>
  77. <Static id="caption1" text="구매검수내역" class="tit_2" position="absolute 0 99 131 116"/>
  78. <Static id="caption3" text="=&gt;" position="absolute 474 61 499 81"/>
  79. <Calendar id="input1" taborder="5" class="input_essential" position="absolute 500 61 615 80" onchanged="input1_onchanged"/>
  80. <Button id="button3" taborder="6" text="일괄변경" class="btn2" position="absolute 630 60 697 82" onclick="button3_onclick"/>
  81. <Static id="caption4" text="총금액" position="absolute 740 96 785 116" style="font:Dotum,9,bold;"/>
  82. <Static id="caption7" text="건수" position="absolute 935 96 970 116" style="font:Dotum,9,bold;"/>
  83. <MaskEdit id="input2" taborder="7" mask="(-)#,###" position="absolute 791 96 911 115"/>
  84. <MaskEdit id="input3" taborder="8" mask="(-)#,###" position="absolute 975 96 1045 115"/>
  85. </Layout>
  86. </Layouts>
  87. <Objects>
  88. <Dataset id="ds_hidden_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  89. <ColumnInfo>
  90. <Column id="pumno" type="STRING" size="256"/>
  91. </ColumnInfo>
  92. </Dataset>
  93. <Dataset id="ds_send_paydedu" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  94. <ColumnInfo>
  95. <Column id="instcd" type="STRING" size="256"/>
  96. <Column id="fromdd" type="STRING" size="256"/>
  97. <Column id="todd" type="STRING" size="256"/>
  98. <Column id="kyno" type="STRING" size="256"/>
  99. <Column id="totamt" type="STRING" size="256"/>
  100. <Column id="totcnt" type="STRING" size="256"/>
  101. </ColumnInfo>
  102. <Rows>
  103. <Row>
  104. <Col id="instcd"/>
  105. <Col id="fromdd"/>
  106. <Col id="todd"/>
  107. <Col id="kyno"/>
  108. <Col id="totamt"/>
  109. <Col id="totcnt"/>
  110. </Row>
  111. </Rows>
  112. </Dataset>
  113. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  114. <ColumnInfo/>
  115. </Dataset>
  116. <Dataset id="ds_main_grnt_grntlist2" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  117. <ColumnInfo>
  118. <Column id="entrregno" type="STRING" size="256"/>
  119. <Column id="custnm" type="STRING" size="256"/>
  120. <Column id="ibgoymd" type="STRING" size="256"/>
  121. <Column id="yejungymd" type="STRING" size="256"/>
  122. <Column id="keumak" type="STRING" size="256"/>
  123. <Column id="keumak1" type="STRING" size="256"/>
  124. <Column id="rmrk" type="STRING" size="256"/>
  125. <Column id="signflag" type="STRING" size="256"/>
  126. <Column id="kydate" type="STRING" size="256"/>
  127. <Column id="kyseq" type="STRING" size="256"/>
  128. <Column id="ymdaction" type="STRING" size="256"/>
  129. </ColumnInfo>
  130. <Rows>
  131. <Row>
  132. <Col id="entrregno"/>
  133. <Col id="custnm"/>
  134. <Col id="ibgoymd"/>
  135. <Col id="yejungymd"/>
  136. <Col id="keumak"/>
  137. <Col id="keumak1"/>
  138. <Col id="rmrk"/>
  139. <Col id="signflag"/>
  140. <Col id="kydate"/>
  141. <Col id="kyseq"/>
  142. <Col id="ymdaction"/>
  143. </Row>
  144. </Rows>
  145. </Dataset>
  146. <Dataset id="ds_send_save" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  147. <ColumnInfo>
  148. <Column id="grntlist1" type="STRING" size="256"/>
  149. </ColumnInfo>
  150. <Rows>
  151. <Row>
  152. <Col id="grntlist1"/>
  153. </Row>
  154. </Rows>
  155. </Dataset>
  156. </Objects>
  157. <Bind>
  158. <BindItem id="item0" compid="cmb_instcd" propid="value" datasetid="ds_send_paydedu" columnid="instcd"/>
  159. <BindItem id="item1" compid="ipt_unsldd" propid="value" datasetid="ds_send_paydedu" columnid="fromdd"/>
  160. <BindItem id="item2" compid="input1" propid="value" datasetid="ds_send_paydedu" columnid="todd"/>
  161. <BindItem id="item3" compid="input2" propid="value" datasetid="ds_send_paydedu" columnid="totamt"/>
  162. <BindItem id="item4" compid="input3" propid="value" datasetid="ds_send_paydedu" columnid="totcnt"/>
  163. </Bind>
  164. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  165. * System Name :
  166. * Job Name :
  167. * Creator :
  168. * Make Date : 2017-12-04
  169. * Description :
  170. *---------------------------------------------------------------------------------------
  171. * Modify Date Modifier Modify Description
  172. *---------------------------------------------------------------------------------------
  173. * 2017-06-19 Live Converter TF->XP
  174. *
  175. *---------------------------------------------------------------------------------------
  176. ****************************************************************************************/
  177. //=======================================================================================
  178. // Lib Include
  179. //---------------------------------------------------------------------------------------
  180. include "com_commonxp::comm_main.xjs";
  181. include "mis_miscommonxp::MIS.xjs";
  182. include "mis_paybaseinfomngtxp::RWC001.xjs";
  183. include "mis_humtrafactmngtxp::RPB001.xjs";
  184. include "mis_miscommonxp::RAC001.xjs";
  185. include "mis_acntcommonxp::RAD001.xjs";
  186. //=======================================================================================
  187. // Global Form Variable
  188. //---------------------------------------------------------------------------------------
  189. var arErrorCode = new HashArray();
  190. //=======================================================================================
  191. // Function
  192. //---------------------------------------------------------------------------------------
  193. /*-**************************************************************************************
  194. * Argument : N/A
  195. * Description :
  196. ****************************************************************************************/
  197. // function fOpenPopupDeptHelp(pControl, pInstance)
  198. // {
  199. // misfOpenPopUpList("02", pControl, "", pInstance);
  200. //
  201. // //model.refresh();
  202. //
  203. // }
  204. // function fOpenPopupHelp(pHelper, pControl, pInstance, pCdgrupid, pValueControl, pNodeName)
  205. // {
  206. // misfOpenPopUpList(pHelper, pControl, pCdgrupid, pInstance, pValueControl, pNodeName);
  207. //
  208. // //model.refresh();
  209. //
  210. // }
  211. /*-**************************************************************************************
  212. * Argument : N/A
  213. * Description : 초기화
  214. ****************************************************************************************/
  215. function initialize(){
  216. misfGridInit(grd_grntpsn1);
  217. misfMsterDetailSet(grd_grntpsn1,null, "TRRAD02401" ,"Y");
  218. var curdate = utlf_getCurrentDate();
  219. cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
  220. var deptcd = sysf_getUserInfo("dutplcecd");
  221. var deptnm = sysf_getUserInfo("dutplcenm");
  222. ds_send_paydedu.setColumn( 0, "fromdd", curdate);
  223. ds_send_paydedu.setColumn( 0, "todd", utlf_getCurrentDate().toDate().getAddDate(+1,"D").getDateFormat("YYYYMMDD"));
  224. misfComboInstCdListMulti("cmb_instcd",utlf_getCurrentDate(),"","N");
  225. btn_search.click();
  226. }
  227. // function Popup(){
  228. // var ymd = ds_main_grnt_grntlist1.getColumn(0, "junpyodate");
  229. // var mdeptcd = ds_main_grnt_grntlist1.getColumn(0, "makedeptcd");
  230. // var ydeptcd = ds_main_grnt_grntlist1.getColumn(0, "yogudeptcd");
  231. // if (ymd != "" && mdeptcd != "" && ydeptcd != ""){
  232. // ds_popdata.setColumn( 0, "junpyodate", ymd);
  233. // ds_popdata.setColumn( 0, "makedeptcd", mdeptcd);
  234. // ds_popdata.setColumn( 0, "yogudeptcd", ydeptcd);
  235. // ds_popdata.setColumn( 0, "pumgubun", "3");
  236. // frmf_modal("SPRAD00400", "SPRAD00400", "ds_popdata""-"ds_popdata"", "", "", "", "", "", "", "", "", "", "M");
  237. // }
  238. // }
  239. // function Maxseq(){
  240. // var flag = ds_main_grnt_grntlist2.getColumn(grd_grntpsn1.row, "flag");
  241. // if (flag == "Y"){
  242. // var ymd = ds_main_grnt_grntlist2.getColumn(grd_grntpsn1.row, "ymdwrite");
  243. // var maxseq = 0;
  244. // var maxseq1 = 0;
  245. // var maxseq2 = 0;
  246. // var ymd1 = "";
  247. // /*
  248. // for (var i = 1; i < grd_grntpsn1.rows; i++){
  249. // ymd1 = ds_main_grnt_grntlist2.getColumn(i, "ymdwrite");
  250. // if (ymd == ymd1){
  251. // maxseq1 = ds_main_grnt_grntlist2.getColumn(i, "maxseq");
  252. // if (isNaN(maxseq1)){
  253. // maxseq1 = 0;
  254. // }
  255. // if (parseInt(maxseq1) > parseInt(maxseq)){
  256. // maxseq = maxseq1;
  257. // }
  258. // }
  259. // }
  260. // if (maxseq == 0){
  261. // maxseq = 1;
  262. // }
  263. // */
  264. // for (var i = 1; i < grd_grntpsn1.rows; i++){
  265. // ymd1 = ds_main_grnt_grntlist2.getColumn(i, "ymdwrite");
  266. // //if (ymd == ymd1){
  267. // maxseq1 = ds_main_grnt_grntlist2.getColumn(i, "gipyoseq");
  268. // if (isNaN(maxseq1)){
  269. // maxseq1 = 0;
  270. // }
  271. // if (parseInt(maxseq1) > parseInt(maxseq)){
  272. // maxseq = maxseq1;
  273. // }
  274. // //}
  275. // }
  276. // maxseq = parseInt(maxseq) + 1;
  277. // ds_main_grnt.setColumn( 0, "grntlist2[" + grd_grntpsn1.row + "]_gipyoseq", maxseq);
  278. // grd_grntpsn1.rowStatus(grd_grntpsn1.row) = 2;
  279. // }else{
  280. // ds_main_grnt.setColumn( 0, "grntlist2[" + grd_grntpsn1.row + "]_gipyoseq", "");
  281. // if (ds_main_grnt_grntlist2.getColumn(grd_grntpsn1.row, "seqwrite") == ""){
  282. // grd_grntpsn1.rowStatus(grd_grntpsn1.row) = 0;
  283. // }
  284. // }
  285. //
  286. // //model.refresh();
  287. //
  288. // }
  289. //=======================================================================================
  290. // Event
  291. //---------------------------------------------------------------------------------------
  292. /****************************************************************************************
  293. * Components : Form
  294. * Description : 화면 처음 초기화시 폼초기화
  295. ****************************************************************************************/
  296. function SMRAD02400_onload(obj:Form, e:LoadEventInfo)
  297. {
  298. frmf_initForm(obj);
  299. //grdf_initGrid(grd_XXX);
  300. grdf_setGridSort(grd_grntpsn1);
  301. //grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값);
  302. initialize();
  303. }
  304. /****************************************************************************************
  305. * Components : Button
  306. * Description : 조회
  307. ****************************************************************************************/
  308. function btn_search_onclick(obj:Button, e:ClickEventInfo) {
  309. misfMsterDetailRetrieve();
  310. ds_main_grnt_grntlist2.rowposition = 0;
  311. var totamt = 0;
  312. var totcnt = 0;
  313. var amt = 0;
  314. for (var i = 0; i < ds_main_grnt_grntlist2.rowcount; i++){
  315. amt = ds_main_grnt_grntlist2.getColumn(i, "keumak");
  316. totamt = parseFloat(totamt) + parseFloat(amt);
  317. totcnt = parseFloat(totcnt) + 1;
  318. }
  319. ds_send_paydedu.setColumn( 0, "totamt", totamt);
  320. ds_send_paydedu.setColumn( 0, "totcnt", totcnt);
  321. }
  322. /****************************************************************************************
  323. * Components : Button
  324. * Description : 일괄변경
  325. ****************************************************************************************/
  326. function button3_onclick(obj:Button, e:ClickEventInfo) {
  327. if( sysf_messageBox("데이타를 일괄변경하시겠습니까?" , "Q99" ) == 6 ){
  328. for (var i = 0; i < ds_main_grnt_grntlist2.rowcount; i++){
  329. ds_main_grnt_grntlist2.setColumn( i , "yejungymd", ds_send_paydedu.getColumn(0, "todd"));
  330. grdf_setStatus(grdObj, "U", [i]);
  331. }
  332. }
  333. }
  334. /****************************************************************************************
  335. * Components : Button
  336. * Description : 저장
  337. ****************************************************************************************/
  338. function grp_btn_button36_onclick(obj:Button, e:ClickEventInfo) {
  339. misfSave("TXRAD02401");
  340. }
  341. /****************************************************************************************
  342. * Components : Button
  343. * Description : 초기화(사용안함)
  344. ****************************************************************************************/
  345. function grp_btn_button35_onclick(obj:Button, e:ClickEventInfo) {
  346. // ds_main_grnt_grntlist1.clearData(); ds_main_grnt_grntlist1.addRow();
  347. // group3.enable = true;
  348. // grd_grntpsn1.enable = true;
  349. // ipt_unsldd.enable = true;
  350. // ipt_costcntrdeptcd.enable = true;
  351. // combo1.enable = true;
  352. // input4.enable = true;
  353. // input14.enable = false;
  354. // input15.enable = false;
  355. // input10.enable = false;
  356. // ds_send_paydedu.setColumn( 0, "pumno1", "");
  357. // ds_send_paydedu.setColumn( 0, "pumno2", "");
  358. //
  359. // initialize();
  360. }
  361. /****************************************************************************************
  362. * Components : Calendar
  363. * Description : 예정일자 변경
  364. ****************************************************************************************/
  365. function ipt_unsldd_onchanged(obj:Calendar, e:ChangeEventInfo)
  366. {
  367. btn_search.click();
  368. }
  369. /****************************************************************************************
  370. * Components : Calendar
  371. * Description : 예정일자 수정
  372. ****************************************************************************************/
  373. function input1_onchanged(obj:Calendar, e:ChangeEventInfo)
  374. {
  375. button3.click();
  376. }
  377. ]]></Script>
  378. </Form>
  379. </FDL>