123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562 |
- <?xml version="1.0" encoding="utf-8" standalone="no"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMRSG02700" position="absolute 0 0 1204 784" titletext="거래처별 지출현황" onload="SMRSG02700_onload">
- <Layouts>
- <Layout>
- <Div id="group1" position="absolute 0 0 1195 21" style="" scrollbars="none">
- <Layouts>
- <Layout>
- <Static id="caption6" class="tit_1" position="absolute 0 0 189 22" style="" text="월별 1식당 평균단가" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- <Div id="group5" scrollbars="autoboth" position="absolute 0 38 1195 782" style="">
- <Layouts>
- <Layout>
- <Static id="caption21" class="tit_2" position="absolute 1 54 163 72" style="" text="월별 1식당 평균단가"/>
- <Div id="group6" position="absolute 0 10 1195 45" style="align: top;">
- <Layouts>
- <Layout>
- <Shape id="roundrect3" anchor="default" type="roundrectangle" position="absolute 0 0 1195 35" style="border:1 solid #ffd799 #ffd799;background:#fffbf2 ;"/>
- <Static id="caption4" class="search_name" position="absolute 226 9 312 26" style="" text="조회년월 :"/>
- <Static id="caption2" class="search_name" position="absolute 15 9 101 26" style="" text="기관코드 :"/>
- <Button id="btn_search" class="btn1" position="absolute 1125 7 1181 29" style="" text="조회" onclick="group5_group6_btn_search_onclick"/>
- <Shape id="line13" class="line_4" linetype="vertical" position="absolute 1110 7 1113 29" style="border:1 solid #ffe4bb #ffe4bb;" anchor="default"/>
- <Combo innerdataset="" datacolumn="" codecolumn="" columncount="-1" rowcount="-1" id="cmb_instcd" class="combo_search" position="absolute 100 8 200 27" style=""/>
- <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"/>
- <Edit id="ipt_goodflag" visible="false" position="absolute 632 9 683 28" style="" anchor="default"/>
- <Edit id="ipt_reqdeptcd" visible="false" position="absolute 688 8 732 27" style="" anchor="default"/>
- <Static id="caption1" position="absolute 415 5 424 30" style="font:,,bold;align: middle;" text="~"/>
- <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"/>
- </Layout>
- </Layouts>
- </Div>
- <Shape id="line15" class="line_10" linetype="horizontal" position="absolute 0 71 1195 74" style="" anchor="default"/>
- <Button id="button14" class="btn7" position="absolute 1144 51 1195 70" style="" text="엑셀" onclick="group5_button14_onclick"/>
- <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">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25"/>
- <Column size="56"/>
- <Column size="90"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="90"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="90"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="90"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="92"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- <Column size="0"/>
- </Columns>
- <Rows>
- <Row size="25" band="head"/>
- <Row size="25" band="head"/>
- <Row size="25" band="head"/>
- <Row size="25"/>
- </Rows>
- <Band id="head">
- <Cell rowspan="3" taborder="undefined"/>
- <Cell col="1" rowspan="3" text="년월" taborder="undefined"/>
- <Cell col="2" colspan="6" text="환자식" taborder="undefined"/>
- <Cell col="8" colspan="6" text="직원식" taborder="undefined"/>
- <Cell col="14" rowspan="3" text="평균단가" taborder="undefined"/>
- <Cell col="15"/>
- <Cell col="16" text="년월"/>
- <Cell col="17" text="일반식(G)"/>
- <Cell col="18" text="일반식(G)"/>
- <Cell col="19" text="일반식(G)"/>
- <Cell col="20" text="치료식(T)"/>
- <Cell col="21" text="치료식(T)"/>
- <Cell col="22" text="치료식(T)"/>
- <Cell col="23" text="직원식(S)"/>
- <Cell col="24" text="직원식(S)"/>
- <Cell col="25" text="직원식(S)"/>
- <Cell col="26" text="야식(N)"/>
- <Cell col="27" text="야식(N)"/>
- <Cell col="28" text="야식(N)"/>
- <Cell col="29" text="평균단가"/>
- <Cell col="30"/>
- <Cell col="31" text="년월"/>
- <Cell col="32" text="급식비"/>
- <Cell col="33" text="식수"/>
- <Cell col="34" text="1식단가"/>
- <Cell col="35" text="급식비"/>
- <Cell col="36" text="식수"/>
- <Cell col="37" text="1식단가"/>
- <Cell col="38" text="급식비"/>
- <Cell col="39" text="식수"/>
- <Cell col="40" text="1식단가"/>
- <Cell col="41" text="급식비"/>
- <Cell col="42" text="식수"/>
- <Cell col="43" text="1식단가"/>
- <Cell col="44" text="평균단가"/>
- <Cell col="45"/>
- <Cell row="1" col="2" colspan="3" text="일반식(G)" taborder="undefined"/>
- <Cell row="1" col="5" colspan="3" text="치료식(T)" taborder="undefined"/>
- <Cell row="1" col="8" colspan="3" text="직원식(S)" taborder="undefined"/>
- <Cell row="1" col="11" colspan="3" text="야식(N)" taborder="undefined"/>
- <Cell row="1" col="15"/>
- <Cell row="2" col="2" text="급식비"/>
- <Cell row="2" col="3" text="식수"/>
- <Cell row="2" col="4" text="1식단가"/>
- <Cell row="2" col="5" text="급식비"/>
- <Cell row="2" col="6" text="식수"/>
- <Cell row="2" col="7" text="1식단가"/>
- <Cell row="2" col="8" text="급식비"/>
- <Cell row="2" col="9" text="식수"/>
- <Cell row="2" col="10" text="1식단가"/>
- <Cell row="2" col="11" text="급식비"/>
- <Cell row="2" col="12" text="식수"/>
- <Cell row="2" col="13" text="1식단가"/>
- <Cell row="2" col="15"/>
- </Band>
- <Band id="body">
- <Cell celltype="head"/>
- <Cell col="1" displaytype="date" style="align:center middle;" text="bind:winym" mask="yyyy-MM"/>
- <Cell col="2" displaytype="number" text="bind:custpatwinamt"/>
- <Cell col="3" displaytype="number" edittype="masknumber" text="bind:custpatmonqty" editautoselect="true"/>
- <Cell col="4" displaytype="number" text="bind:custpatdayamt"/>
- <Cell col="5" displaytype="number" text="bind:custcurwinamt"/>
- <Cell col="6" displaytype="number" edittype="masknumber" text="bind:custcurmonqty" editautoselect="true"/>
- <Cell col="7" displaytype="number" text="bind:custcurdayamt"/>
- <Cell col="8" displaytype="number" text="bind:custempwinamt"/>
- <Cell col="9" displaytype="number" edittype="masknumber" text="bind:custempmonqty" editautoselect="true"/>
- <Cell col="10" displaytype="number" text="bind:custempdayamt"/>
- <Cell col="11" displaytype="number" text="bind:custempnigtwinamt"/>
- <Cell col="12" displaytype="number" edittype="masknumber" text="bind:custempnigtmonqty" editautoselect="true"/>
- <Cell col="13" displaytype="number" text="bind:custempnigtdayamt"/>
- <Cell col="14" displaytype="number" text="bind:custtotavgamt"/>
- <Cell col="15" text="bind:instcd"/>
- <Cell col="16" text="bind:reqdeptcd"/>
- <Cell col="17" text="bind:goodflag"/>
- <Cell col="18" text="bind:totwinamt"/>
- <Cell col="19" text="bind:totavgcout"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- </Layout>
- </Layouts>
- </Div>
- <Div id="group4" position="absolute 0 18 1195 45" style="" scrollbars="none">
- <Layouts>
- <Layout>
- <Button id="button34" class="btn6" visible="false" position="absolute 0 3 56 25" style="" text="출력" anchor="default"/>
- <Shape id="line17" class="line_6" linetype="horizontal" position="absolute 0 26 1195 29" style="" anchor="default"/>
- <Button id="btn_init" class="btn4" position="absolute 1127 3 1195 25" style="" text="초기화" onclick="group4_btn_init_onclick" anchor="default"/>
- <Button id="btn_save" class="btn4" position="absolute 1070 3 1126 25" style="" text="저장" onclick="group4_btn_save_onclick" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="instcd" type="STRING" size="256"/>
- <Column id="stocfrym" type="STRING" size="256"/>
- <Column id="goodflag" type="STRING" size="256"/>
- <Column id="reqdeptcd" type="STRING" size="256"/>
- <Column id="stoctoym" type="STRING" size="256"/>
- <Column id="avgwinamtlist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="instcd"/>
- <Col id="stocfrym"/>
- <Col id="goodflag"/>
- <Col id="reqdeptcd"/>
- <Col id="stoctoym"/>
- <Col id="avgwinamtlist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="temp" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="temp"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_hidden" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="hidden" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="avgwinamtlist" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="avgwinamtlist"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="init" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="init"/>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_list_avgwinamtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group5.group6.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
- <BindItem id="item1" compid="group5.group6.ipt_stocfrym" propid="value" datasetid="ds_send" columnid="stocfrym"/>
- <BindItem id="item2" compid="group5.group6.ipt_goodflag" propid="value" datasetid="ds_send" columnid="goodflag"/>
- <BindItem id="item3" compid="group5.group6.ipt_reqdeptcd" propid="value" datasetid="ds_send" columnid="reqdeptcd"/>
- <BindItem id="item4" compid="group5.group6.ipt_stoctoym" propid="value" datasetid="ds_send" columnid="stoctoym"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2017-06-19
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2017-06-19 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- include "mis_miscommonxp::MIS.xjs";
- include "mis_miscommonxp::RSZ001.xjs";
- var RetrYn = "Y";
- function SMRSG02700_onload(obj:Form, e:LoadEventInfo) {
- frmf_initForm(obj);
- //grdf_initGrid(grd_XXX);
- //grdf_setGridSort(grd_XXX);
- grdf_setRowTypeIcon(group5.grd_avgwinamtlist, 0);
- //화면 Control을 초기화한다
- fInitialize();
- }
- function fInitialize() {
- misfGridInit(group5.grd_avgwinamtlist);
- // group5.grd_avgwinamtlist.rowHeight(0) = "20";
- // group5.grd_avgwinamtlist.rowHeight(1) = "20";
- rszfUserInstList(group5.group6.cmb_instcd,sysf_getUserInfo("userid"));
- //misfMsterDetailSet(group5.grd_avgwinamtlist,null, "TRRSG02701" ,"N");
- var curdate = utlf_getCurrentDate();
- ds_send.setColumn(0,"stocfrym",curdate);
- ds_send.setColumn(0,"stoctoym",curdate);
- // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= P) => (goodflag= PH)
- ds_send.setColumn(0,"goodflag","PH");
-
- // hidden column
- // [2010.08.26]AS-IS 코드 TO_BE 코드 전환을 위한 물품구분 변경 (goodflag= S) => (goodflag= SF)
- ds_send.setColumn(0,"goodflag","SF");
-
- ds_send.setColumn(0,"reqdeptcd", sysf_getUserInfo("dutplcecd"));
- ds_send.setColumn(0,"instcd", sysf_getUserInfo("dutplceinstcd"));
- }
- function fCheckRetrieveData(pmsg)
- {
- if(utlf_isNull(group5.group6.cmb_instcd.value))
- {
- if(pmsg == true)
- {
- sysf_messageBox("기관코드를 " ,"C002");
- group5.group6.cmb_instcd.setFocus();
- }
- return false;
- }
- if(utlf_isNull(group5.group6.ipt_stocfrym.value))
- {
- if(pmsg == true)
- {
- sysf_messageBox("조회시작년월 " ,"C002");
- group5.group6.ipt_stocfrym.setFocus();
- }
- return false;
- }
- if(utlf_isNull(group5.group6.ipt_stoctoym.value))
- {
- if(pmsg == true)
- {
- sysf_messageBox("조회끝년월 " ,"C002");
- group5.group6.ipt_stoctoym.setFocus();
- }
- return false;
- }
- return true;
- }
- function group5_group6_btn_search_onclick(obj:Button, e:ClickEventInfo) {
- //if(fCheckRetrieveData(false) == false)return;
- //misfMsterDetailRetrieve();
- //fAfterRetrieve();
-
- ds_send.setColumn(0,"stocfrym",ds_send.getColumn(0,"stocfrym").substring(0,6));
- ds_send.setColumn(0,"stoctoym",ds_send.getColumn(0,"stoctoym").substring(0,6));
-
- var oParam = {};
- oParam.id = "TRRSG02701";
- oParam.service = "stocsumapp.StocSumMngt";
- oParam.method = "reqGetAvgWinAmtList";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_list_avgwinamtlist=avgwinamtlist";
- oParam.async = false;
- //oParam.callback = "cf_TRRSG02701";
- tranf_submit(oParam);
-
- ds_main_list_avgwinamtlist.addColumn("reqdeptcd","string");
- }
- function group5_button14_onclick(obj:Button, e:ClickEventInfo) {
- // misfSaveExcel(group5.grd_avgwinamtlist,"월별 1식당 평균단가");
- grdf_exportExcel(group5.grd_avgwinamtlist, "월별 1식당 평균단가", "월별 1식당 평균단가", "true", "", "");
- }
- function group4_btn_init_onclick(obj:Button, e:ClickEventInfo) {
- // var data = getGridUpdateData(grd_rsthrstnlist);
- var row = grdf_getUpdateRows("group5.grd_avgwinamtlist", "update", "");
- if(row > 0 )
- {
- if(sysf_messageBox("작업중인 Data 가 있습니다.","Q003") != 6 )return;
- }
- fInitialize();
- }
- function group4_btn_save_onclick(obj:Button, e:ClickEventInfo) {
- // if(sysf_messageBox("","Q002") != 6) return;
- if(fCheckRetrieveData()== false) return;
- //ds_send.setColumn( 0, "avgwinamtlist", group5.grd_avgwinamtlist.getUpdateData());
- //misfSave("TXRSG02701");
-
- var oParam = {};
- oParam.id = "TXRSG02701";
- oParam.service = "stocsumapp.StocSumMngt";
- oParam.method = "reqExeAvgWinAmtList";
- oParam.inds = "req=ds_main_list_avgwinamtlist:U";
- oParam.outds = "";
- oParam.async = false;
- oParam.callback = "cf_TXRSG02701";
- tranf_submit(oParam);
-
- // group5.group6.btn_search.dispatch("DOMActivate");
- //
- //model.refresh();
- }
- function cf_TXRSG02701(sSvcId, nErrorCode, sErrorMsg) {
- if(nErrorCode < 0) return;
- group5.group6.btn_search.click();
- }
- function group5_grd_avgwinamtlist_onkeydown(obj:Grid, e:KeyEventInfo)
- {
- if (e.keycode == "13" ) {
-
- obj.updateToDataset();
-
- var ind = obj.getCellPos();
- var row = ds_main_list_avgwinamtlist.rowposition;
- var patqty = ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"); //3
- var custqty = ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"); //6
- var empqty = ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"); //9
- var empnqty = ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty");//12
-
- //custpatmonqty 환자 일반식
- if(ind == "3" && !utlf_isNull(patqty) && patqty != 0) {
- var custpatwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custpatwinamt"));
- //식수cout가 0일 경우
- if(custpatwinamt == 0)
- {
- ds_main_list_avgwinamtlist.setColumn(row,"custpatmonqty", 0);
- } else {
- var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custpatmonqty"));
- var custpatdayamt = 0;
- //alert(custpatwinamt + ":"+custpatmonqty+":");
- //alert(custpatwinamt / custpatmonqty +":"+ Math.round(custpatwinamt / custpatmonqty));
- custpatdayamt = parseFloat(Math.round(custpatwinamt / custpatmonqty));
-
- ds_main_list_avgwinamtlist.setColumn(row,"custpatdayamt", custpatdayamt);
-
- ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
-
-
- grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
- //평균단가를 구하기 위해서
- var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"));
- var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"));
- var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty"));
- var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
- var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
- totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
- ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
- }
- //custcurmonqty 환자 치료식
- } else if(ind == "6" && !utlf_isNull(custqty) && custqty != 0) {
-
- var custcurwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custcurwinamt"));
- //식수cout가 0일 경우
- if(custcurwinamt == 0)
- {
- ds_main_list_avgwinamtlist.setColumn(row,"custcurmonqty",0);
- } else {
- var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custcurmonqty"));
- var custcurdayamt = 0;
-
- custcurdayamt = parseFloat(Math.round(custcurwinamt / custcurmonqty));
-
- ds_main_list_avgwinamtlist.setColumn(row,"custcurdayamt", custcurdayamt);
- ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
- grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
- //평균단가를 구하기 위해서
- var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"));
- var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"));
- var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty"));
- var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
- var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
- totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
- ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
- }
- //직원식
- } else if(ind == "9" && !utlf_isNull(empqty) && empqty != 0) {
-
- var custempwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custempwinamt"));
- //식수cout가 0일 경우
- if(custempwinamt == 0)
- {
-
- ds_main_list_avgwinamtlist.setColumn(row,"custempmonqty", 0);
-
- } else {
-
- var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custempmonqty"));
- var custempdayamt = 0;
- custempdayamt = parseFloat(Math.round(custempwinamt / custempmonqty));
- ds_main_list_avgwinamtlist.setColumn(row,"custempdayamt", custempdayamt);
- ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
- grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
-
- trace('11');
- //평균단가를 구하기 위해서
- var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"));
- var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"));
- var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempnigtmonqty"));
- var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
- var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
- totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
- ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
-
- }
- //직원식 야식
- } else if(ind == "12" && !utlf_isNull(empnqty) && empnqty != 0) {
-
- var custempnigtwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row ,"custempnigtwinamt"));
- //식수cout가 0일 경우
- if(custempnigtwinamt == 0)
- {
-
- ds_main_list_avgwinamtlist.setColumn(row,"custempnigtmonqty", 0);
-
- } else {
-
- var custempnigtmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row, "custempnigtmonqty"));
- var custempnigtdayamt = 0;
-
- custempnigtdayamt = parseFloat(Math.round(custempnigtwinamt / custempnigtmonqty));
-
- ds_main_list_avgwinamtlist.setColumn(row,"custempnigtdayamt", custempnigtdayamt);
- ds_main_list_avgwinamtlist.setColumn(row,"custempdayamt", custempdayamt);
- ds_main_list_avgwinamtlist.setColumn(row,"reqdeptcd", ds_send.getColumn(0,"reqdeptcd"));
- grdf_setStatus(group5.grd_avgwinamtlist, "U", row);
-
- //평균단가를 구하기 위해서
- var custpatmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custpatmonqty"));
- var custcurmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custcurmonqty"));
- var custempmonqty = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"custempmonqty"));
- var totwinamt = parseFloat(ds_main_list_avgwinamtlist.getColumn(row,"totwinamt"));
- var totmonqty = custpatmonqty+ custcurmonqty + custempmonqty + custempnigtmonqty ;
- totavgamt = parseFloat(Math.round(totwinamt / totmonqty));
- ds_main_list_avgwinamtlist.setColumn(row,"custtotavgamt", totavgamt);
-
- }
- }
- }
- }
- ]]></Script>
- </Form>
- </FDL>
|