SMRSG02700_월별 1식당 평균단가(영양).xfdl 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562
  1. <?xml version="1.0" encoding="utf-8" standalone="no"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMRSG02700" position="absolute 0 0 1204 784" titletext="거래처별 지출현황" onload="SMRSG02700_onload">
  5. <Layouts>
  6. <Layout>
  7. <Div id="group1" position="absolute 0 0 1195 21" style="" scrollbars="none">
  8. <Layouts>
  9. <Layout>
  10. <Static id="caption6" class="tit_1" position="absolute 0 0 189 22" style="" text="월별 1식당 평균단가" anchor="default"/>
  11. </Layout>
  12. </Layouts>
  13. </Div>
  14. <Div id="group5" scrollbars="autoboth" position="absolute 0 38 1195 782" style="">
  15. <Layouts>
  16. <Layout>
  17. <Static id="caption21" class="tit_2" position="absolute 1 54 163 72" style="" text="월별 1식당 평균단가"/>
  18. <Div id="group6" position="absolute 0 10 1195 45" style="align: top;">
  19. <Layouts>
  20. <Layout>
  21. <Shape id="roundrect3" anchor="default" type="roundrectangle" position="absolute 0 0 1195 35" style="border:1 solid #ffd799 #ffd799;background:#fffbf2 ;"/>
  22. <Static id="caption4" class="search_name" position="absolute 226 9 312 26" style="" text="조회년월 :"/>
  23. <Static id="caption2" class="search_name" position="absolute 15 9 101 26" style="" text="기관코드 :"/>
  24. <Button id="btn_search" class="btn1" position="absolute 1125 7 1181 29" style="" text="조회" onclick="group5_group6_btn_search_onclick"/>
  25. <Shape id="line13" class="line_4" linetype="vertical" position="absolute 1110 7 1113 29" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
  26. <Combo innerdataset="" datacolumn="" codecolumn="" columncount="-1" rowcount="-1" id="cmb_instcd" class="combo_search" position="absolute 100 8 200 27" style=""/>
  27. <Calendar id="ipt_stocfrym" class="input_essential" mask="yyyy-mm" position="absolute 312 8 412 27" style="align:center ;" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true"/>
  28. <Edit id="ipt_goodflag" visible="false" position="absolute 632 9 683 28" style="" anchor="default"/>
  29. <Edit id="ipt_reqdeptcd" visible="false" position="absolute 688 8 732 27" style="" anchor="default"/>
  30. <Static id="caption1" position="absolute 415 5 424 30" style="font:,,bold;align: middle;" text="~"/>
  31. <Calendar id="ipt_stoctoym" class="input_essential" mask="yyyy-mm" position="absolute 430 8 530 27" style="align:center ;" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true"/>
  32. </Layout>
  33. </Layouts>
  34. </Div>
  35. <Shape id="line15" class="line_10" linetype="horizontal" position="absolute 0 71 1195 74" style="" anchor="default"/>
  36. <Button id="button14" class="btn7" position="absolute 1144 51 1195 70" style="" text="엑셀" onclick="group5_button14_onclick"/>
  37. <Grid id="grd_avgwinamtlist" binddataset="ds_main_list_avgwinamtlist" position="absolute 0 74 1195 734" style="" cellsizingtype="col" autoenter="select" onkeydown="group5_grd_avgwinamtlist_onkeydown">
  38. <Formats>
  39. <Format id="default">
  40. <Columns>
  41. <Column size="25"/>
  42. <Column size="56"/>
  43. <Column size="90"/>
  44. <Column size="80"/>
  45. <Column size="80"/>
  46. <Column size="90"/>
  47. <Column size="80"/>
  48. <Column size="80"/>
  49. <Column size="90"/>
  50. <Column size="80"/>
  51. <Column size="80"/>
  52. <Column size="90"/>
  53. <Column size="80"/>
  54. <Column size="80"/>
  55. <Column size="92"/>
  56. <Column size="0"/>
  57. <Column size="0"/>
  58. <Column size="0"/>
  59. <Column size="0"/>
  60. <Column size="0"/>
  61. </Columns>
  62. <Rows>
  63. <Row size="25" band="head"/>
  64. <Row size="25" band="head"/>
  65. <Row size="25" band="head"/>
  66. <Row size="25"/>
  67. </Rows>
  68. <Band id="head">
  69. <Cell rowspan="3" taborder="undefined"/>
  70. <Cell col="1" rowspan="3" text="년월" taborder="undefined"/>
  71. <Cell col="2" colspan="6" text="환자식" taborder="undefined"/>
  72. <Cell col="8" colspan="6" text="직원식" taborder="undefined"/>
  73. <Cell col="14" rowspan="3" text="평균단가" taborder="undefined"/>
  74. <Cell col="15"/>
  75. <Cell col="16" text="년월"/>
  76. <Cell col="17" text="일반식(G)"/>
  77. <Cell col="18" text="일반식(G)"/>
  78. <Cell col="19" text="일반식(G)"/>
  79. <Cell col="20" text="치료식(T)"/>
  80. <Cell col="21" text="치료식(T)"/>
  81. <Cell col="22" text="치료식(T)"/>
  82. <Cell col="23" text="직원식(S)"/>
  83. <Cell col="24" text="직원식(S)"/>
  84. <Cell col="25" text="직원식(S)"/>
  85. <Cell col="26" text="야식(N)"/>
  86. <Cell col="27" text="야식(N)"/>
  87. <Cell col="28" text="야식(N)"/>
  88. <Cell col="29" text="평균단가"/>
  89. <Cell col="30"/>
  90. <Cell col="31" text="년월"/>
  91. <Cell col="32" text="급식비"/>
  92. <Cell col="33" text="식수"/>
  93. <Cell col="34" text="1식단가"/>
  94. <Cell col="35" text="급식비"/>
  95. <Cell col="36" text="식수"/>
  96. <Cell col="37" text="1식단가"/>
  97. <Cell col="38" text="급식비"/>
  98. <Cell col="39" text="식수"/>
  99. <Cell col="40" text="1식단가"/>
  100. <Cell col="41" text="급식비"/>
  101. <Cell col="42" text="식수"/>
  102. <Cell col="43" text="1식단가"/>
  103. <Cell col="44" text="평균단가"/>
  104. <Cell col="45"/>
  105. <Cell row="1" col="2" colspan="3" text="일반식(G)" taborder="undefined"/>
  106. <Cell row="1" col="5" colspan="3" text="치료식(T)" taborder="undefined"/>
  107. <Cell row="1" col="8" colspan="3" text="직원식(S)" taborder="undefined"/>
  108. <Cell row="1" col="11" colspan="3" text="야식(N)" taborder="undefined"/>
  109. <Cell row="1" col="15"/>
  110. <Cell row="2" col="2" text="급식비"/>
  111. <Cell row="2" col="3" text="식수"/>
  112. <Cell row="2" col="4" text="1식단가"/>
  113. <Cell row="2" col="5" text="급식비"/>
  114. <Cell row="2" col="6" text="식수"/>
  115. <Cell row="2" col="7" text="1식단가"/>
  116. <Cell row="2" col="8" text="급식비"/>
  117. <Cell row="2" col="9" text="식수"/>
  118. <Cell row="2" col="10" text="1식단가"/>
  119. <Cell row="2" col="11" text="급식비"/>
  120. <Cell row="2" col="12" text="식수"/>
  121. <Cell row="2" col="13" text="1식단가"/>
  122. <Cell row="2" col="15"/>
  123. </Band>
  124. <Band id="body">
  125. <Cell celltype="head"/>
  126. <Cell col="1" displaytype="date" style="align:center middle;" text="bind:winym" mask="yyyy-MM"/>
  127. <Cell col="2" displaytype="number" text="bind:custpatwinamt"/>
  128. <Cell col="3" displaytype="number" edittype="masknumber" text="bind:custpatmonqty" editautoselect="true"/>
  129. <Cell col="4" displaytype="number" text="bind:custpatdayamt"/>
  130. <Cell col="5" displaytype="number" text="bind:custcurwinamt"/>
  131. <Cell col="6" displaytype="number" edittype="masknumber" text="bind:custcurmonqty" editautoselect="true"/>
  132. <Cell col="7" displaytype="number" text="bind:custcurdayamt"/>
  133. <Cell col="8" displaytype="number" text="bind:custempwinamt"/>
  134. <Cell col="9" displaytype="number" edittype="masknumber" text="bind:custempmonqty" editautoselect="true"/>
  135. <Cell col="10" displaytype="number" text="bind:custempdayamt"/>
  136. <Cell col="11" displaytype="number" text="bind:custempnigtwinamt"/>
  137. <Cell col="12" displaytype="number" edittype="masknumber" text="bind:custempnigtmonqty" editautoselect="true"/>
  138. <Cell col="13" displaytype="number" text="bind:custempnigtdayamt"/>
  139. <Cell col="14" displaytype="number" text="bind:custtotavgamt"/>
  140. <Cell col="15" text="bind:instcd"/>
  141. <Cell col="16" text="bind:reqdeptcd"/>
  142. <Cell col="17" text="bind:goodflag"/>
  143. <Cell col="18" text="bind:totwinamt"/>
  144. <Cell col="19" text="bind:totavgcout"/>
  145. </Band>
  146. </Format>
  147. </Formats>
  148. </Grid>
  149. </Layout>
  150. </Layouts>
  151. </Div>
  152. <Div id="group4" position="absolute 0 18 1195 45" style="" scrollbars="none">
  153. <Layouts>
  154. <Layout>
  155. <Button id="button34" class="btn6" visible="false" position="absolute 0 3 56 25" style="" text="출력" anchor="default"/>
  156. <Shape id="line17" class="line_6" linetype="horizontal" position="absolute 0 26 1195 29" style="" anchor="default"/>
  157. <Button id="btn_init" class="btn4" position="absolute 1127 3 1195 25" style="" text="초기화" onclick="group4_btn_init_onclick" anchor="default"/>
  158. <Button id="btn_save" class="btn4" position="absolute 1070 3 1126 25" style="" text="저장" onclick="group4_btn_save_onclick" anchor="default"/>
  159. </Layout>
  160. </Layouts>
  161. </Div>
  162. </Layout>
  163. </Layouts>
  164. <Objects>
  165. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  166. <ColumnInfo>
  167. <Column id="instcd" type="STRING" size="256"/>
  168. <Column id="stocfrym" type="STRING" size="256"/>
  169. <Column id="goodflag" type="STRING" size="256"/>
  170. <Column id="reqdeptcd" type="STRING" size="256"/>
  171. <Column id="stoctoym" type="STRING" size="256"/>
  172. <Column id="avgwinamtlist" type="STRING" size="256"/>
  173. </ColumnInfo>
  174. <Rows>
  175. <Row>
  176. <Col id="instcd"/>
  177. <Col id="stocfrym"/>
  178. <Col id="goodflag"/>
  179. <Col id="reqdeptcd"/>
  180. <Col id="stoctoym"/>
  181. <Col id="avgwinamtlist"/>
  182. </Row>
  183. </Rows>
  184. </Dataset>
  185. <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  186. <ColumnInfo>
  187. <Column id="temp" type="STRING" size="256"/>
  188. </ColumnInfo>
  189. <Rows>
  190. <Row>
  191. <Col id="temp"/>
  192. </Row>
  193. </Rows>
  194. </Dataset>
  195. <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  196. <ColumnInfo>
  197. <Column id="hidden" type="STRING" size="256"/>
  198. </ColumnInfo>
  199. </Dataset>
  200. <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  201. <ColumnInfo>
  202. <Column id="avgwinamtlist" type="STRING" size="256"/>
  203. </ColumnInfo>
  204. <Rows>
  205. <Row>
  206. <Col id="avgwinamtlist"/>
  207. </Row>
  208. </Rows>
  209. </Dataset>
  210. <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  211. <ColumnInfo/>
  212. </Dataset>
  213. <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
  214. <ColumnInfo>
  215. <Column id="init" type="STRING" size="256"/>
  216. </ColumnInfo>
  217. <Rows>
  218. <Row>
  219. <Col id="init"/>
  220. </Row>
  221. </Rows>
  222. </Dataset>
  223. <Dataset id="ds_main_list_avgwinamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  224. </Objects>
  225. <Bind>
  226. <BindItem id="item0" compid="group5.group6.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
  227. <BindItem id="item1" compid="group5.group6.ipt_stocfrym" propid="value" datasetid="ds_send" columnid="stocfrym"/>
  228. <BindItem id="item2" compid="group5.group6.ipt_goodflag" propid="value" datasetid="ds_send" columnid="goodflag"/>
  229. <BindItem id="item3" compid="group5.group6.ipt_reqdeptcd" propid="value" datasetid="ds_send" columnid="reqdeptcd"/>
  230. <BindItem id="item4" compid="group5.group6.ipt_stoctoym" propid="value" datasetid="ds_send" columnid="stoctoym"/>
  231. </Bind>
  232. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  233. * System Name :
  234. * Job Name :
  235. * Creator :
  236. * Make Date : 2017-06-19
  237. * Description :
  238. *---------------------------------------------------------------------------------------
  239. * Modify Date Modifier Modify Description
  240. *---------------------------------------------------------------------------------------
  241. * 2017-06-19 Live Converter TF->XP
  242. *
  243. *---------------------------------------------------------------------------------------
  244. ****************************************************************************************/
  245. include "com_commonxp::comm_main.xjs";
  246. include "mis_miscommonxp::MIS.xjs";
  247. include "mis_miscommonxp::RSZ001.xjs";
  248. var RetrYn = "Y";
  249. function SMRSG02700_onload(obj:Form, e:LoadEventInfo) {
  250. frmf_initForm(obj);
  251. //grdf_initGrid(grd_XXX);
  252. //grdf_setGridSort(grd_XXX);
  253. grdf_setRowTypeIcon(group5.grd_avgwinamtlist, 0);
  254. //화면 Control을 초기화한다
  255. fInitialize();
  256. }
  257. function fInitialize() {
  258. misfGridInit(group5.grd_avgwinamtlist);
  259. // group5.grd_avgwinamtlist.rowHeight(0) = "20";
  260. // group5.grd_avgwinamtlist.rowHeight(1) = "20";
  261. rszfUserInstList(group5.group6.cmb_instcd,sysf_getUserInfo("userid"));
  262. //misfMsterDetailSet(group5.grd_avgwinamtlist,null, "TRRSG02701" ,"N");
  263. var curdate = utlf_getCurrentDate();
  264. ds_send.setColumn(0,"stocfrym",curdate);
  265. ds_send.setColumn(0,"stoctoym",curdate);
  266. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
  267. ds_send.setColumn(0,"goodflag","PH");
  268. // hidden column
  269. // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= S) => (goodflag= SF)
  270. ds_send.setColumn(0,"goodflag","SF");
  271. ds_send.setColumn(0,"reqdeptcd", sysf_getUserInfo("dutplcecd"));
  272. ds_send.setColumn(0,"instcd", sysf_getUserInfo("dutplceinstcd"));
  273. }
  274. function fCheckRetrieveData(pmsg)
  275. {
  276. if(utlf_isNull(group5.group6.cmb_instcd.value))
  277. {
  278. if(pmsg == true)
  279. {
  280. sysf_messageBox("기관코드를 " ,"C002");
  281. group5.group6.cmb_instcd.setFocus();
  282. }
  283. return false;
  284. }
  285. if(utlf_isNull(group5.group6.ipt_stocfrym.value))
  286. {
  287. if(pmsg == true)
  288. {
  289. sysf_messageBox("조회시작년월 " ,"C002");
  290. group5.group6.ipt_stocfrym.setFocus();
  291. }
  292. return false;
  293. }
  294. if(utlf_isNull(group5.group6.ipt_stoctoym.value))
  295. {
  296. if(pmsg == true)
  297. {
  298. sysf_messageBox("조회끝년월 " ,"C002");
  299. group5.group6.ipt_stoctoym.setFocus();
  300. }
  301. return false;
  302. }
  303. return true;
  304. }
  305. function group5_group6_btn_search_onclick(obj:Button, e:ClickEventInfo) {
  306. //if(fCheckRetrieveData(false) == false)return;
  307. //misfMsterDetailRetrieve();
  308. //fAfterRetrieve();
  309. ds_send.setColumn(0,"stocfrym",ds_send.getColumn(0,"stocfrym").substring(0,6));
  310. ds_send.setColumn(0,"stoctoym",ds_send.getColumn(0,"stoctoym").substring(0,6));
  311. var oParam = {};
  312. oParam.id = "TRRSG02701";
  313. oParam.service = "stocsumapp.StocSumMngt";
  314. oParam.method = "reqGetAvgWinAmtList";
  315. oParam.inds = "req=ds_send";
  316. oParam.outds = "ds_main_list_avgwinamtlist=avgwinamtlist";
  317. oParam.async = false;
  318. //oParam.callback = "cf_TRRSG02701";
  319. tranf_submit(oParam);
  320. ds_main_list_avgwinamtlist.addColumn("reqdeptcd","string");
  321. }
  322. function group5_button14_onclick(obj:Button, e:ClickEventInfo) {
  323. // misfSaveExcel(group5.grd_avgwinamtlist,"월별 1식당 평균단가");
  324. grdf_exportExcel(group5.grd_avgwinamtlist, "월별 1식당 평균단가", "월별 1식당 평균단가", "true", "", "");
  325. }
  326. function group4_btn_init_onclick(obj:Button, e:ClickEventInfo) {
  327. // var data = getGridUpdateData(grd_rsthrstnlist);
  328. var row = grdf_getUpdateRows("group5.grd_avgwinamtlist", "update", "");
  329. if(row > 0 )
  330. {
  331. if(sysf_messageBox("작업중인 Data 가 있습니다.","Q003") != 6 )return;
  332. }
  333. fInitialize();
  334. }
  335. function group4_btn_save_onclick(obj:Button, e:ClickEventInfo) {
  336. // if(sysf_messageBox("","Q002") != 6) return;
  337. if(fCheckRetrieveData()== false) return;
  338. //ds_send.setColumn( 0, "avgwinamtlist", group5.grd_avgwinamtlist.getUpdateData());
  339. //misfSave("TXRSG02701");
  340. var oParam = {};
  341. oParam.id = "TXRSG02701";
  342. oParam.service = "stocsumapp.StocSumMngt";
  343. oParam.method = "reqExeAvgWinAmtList";
  344. oParam.inds = "req=ds_main_list_avgwinamtlist:U";
  345. oParam.outds = "";
  346. oParam.async = false;
  347. oParam.callback = "cf_TXRSG02701";
  348. tranf_submit(oParam);
  349. // group5.group6.btn_search.dispatch("DOMActivate");
  350. //
  351. //model.refresh();
  352. }
  353. function cf_TXRSG02701(sSvcId, nErrorCode, sErrorMsg) {
  354. if(nErrorCode < 0) return;
  355. group5.group6.btn_search.click();
  356. }
  357. function group5_grd_avgwinamtlist_onkeydown(obj:Grid, e:KeyEventInfo)
  358. {
  359. if (e.keycode == "13" ) {
  360. obj.updateToDataset();
  361. var ind = obj.getCellPos();
  362. var row = ds_main_list_avgwinamtlist.rowposition;
  363. var patqty = ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"); //3
  364. var custqty = ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"); //6
  365. var empqty = ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"); //9
  366. var empnqty = ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty");//12
  367. //custpatmonqty 환자 일반식
  368. if(ind == "3" && !utlf_isNull(patqty) && patqty != 0) {
  369. var custpatwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custpatwinamt"));
  370. //식수cout가 0일 경우
  371. if(custpatwinamt == 0)
  372. {
  373. ds_main_list_avgwinamtlist.setColumn(row,"custpatmonqty", 0);
  374. } else {
  375. var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custpatmonqty"));
  376. var custpatdayamt = 0;
  377. //alert(custpatwinamt + ":"+custpatmonqty+":");
  378. //alert(custpatwinamt / custpatmonqty +":"+ Math.round(custpatwinamt / custpatmonqty));
  379. custpatdayamt = parseFloat(Math.round(custpatwinamt / custpatmonqty));
  380. ds_main_list_avgwinamtlist.setColumn(row,"custpatdayamt", custpatdayamt);
  381. ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
  382. grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
  383. //평균단가를 구하기 위해서
  384. var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"));
  385. var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"));
  386. var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty"));
  387. var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
  388. var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
  389. totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
  390. ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
  391. }
  392. //custcurmonqty 환자 치료식
  393. } else if(ind == "6" && !utlf_isNull(custqty) && custqty != 0) {
  394. var custcurwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custcurwinamt"));
  395. //식수cout가 0일 경우
  396. if(custcurwinamt == 0)
  397. {
  398. ds_main_list_avgwinamtlist.setColumn(row,"custcurmonqty",0);
  399. } else {
  400. var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custcurmonqty"));
  401. var custcurdayamt = 0;
  402. custcurdayamt = parseFloat(Math.round(custcurwinamt / custcurmonqty));
  403. ds_main_list_avgwinamtlist.setColumn(row,"custcurdayamt", custcurdayamt);
  404. ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
  405. grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
  406. //평균단가를 구하기 위해서
  407. var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"));
  408. var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"));
  409. var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty"));
  410. var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
  411. var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
  412. totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
  413. ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
  414. }
  415. //직원식
  416. } else if(ind == "9" && !utlf_isNull(empqty) && empqty != 0) {
  417. var custempwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custempwinamt"));
  418. //식수cout가 0일 경우
  419. if(custempwinamt == 0)
  420. {
  421. ds_main_list_avgwinamtlist.setColumn(row,"custempmonqty", 0);
  422. } else {
  423. var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custempmonqty"));
  424. var custempdayamt = 0;
  425. custempdayamt = parseFloat(Math.round(custempwinamt / custempmonqty));
  426. ds_main_list_avgwinamtlist.setColumn(row,"custempdayamt", custempdayamt);
  427. ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
  428. grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
  429. trace('11');
  430. //평균단가를 구하기 위해서
  431. var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"));
  432. var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"));
  433. var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty"));
  434. var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
  435. var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
  436. totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
  437. ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
  438. }
  439. //직원식 야식
  440. } else if(ind == "12" && !utlf_isNull(empnqty) && empnqty != 0) {
  441. var custempnigtwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custempnigtwinamt"));
  442. //식수cout가 0일 경우
  443. if(custempnigtwinamt == 0)
  444. {
  445. ds_main_list_avgwinamtlist.setColumn(row,"custempnigtmonqty", 0);
  446. } else {
  447. var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row, "custempnigtmonqty"));
  448. var custempnigtdayamt = 0;
  449. custempnigtdayamt = parseFloat(Math.round(custempnigtwinamt / custempnigtmonqty));
  450. ds_main_list_avgwinamtlist.setColumn(row,"custempnigtdayamt", custempnigtdayamt);
  451. ds_main_list_avgwinamtlist.setColumn(row,"custempdayamt", custempdayamt);
  452. ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
  453. grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
  454. //평균단가를 구하기 위해서
  455. var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"));
  456. var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"));
  457. var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"));
  458. var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
  459. var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
  460. totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
  461. ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
  462. }
  463. }
  464. }
  465. }
  466. ]]></Script>
  467. </Form>
  468. </FDL>