| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230 |
- <?xml version="1.0" encoding="utf-8" standalone="no"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SPPAE00203" position="absolute 0 0 1195 799" titletext="일일 마감관리 현황" onload="SPPAE00203_onload">
- <Layouts>
- <Layout>
- <Div id="Div00" taborder="4" position="absolute 0 25 1195 60" class="div_SA2">
- <Layouts>
- <Layout width="1195" height="37">
- <Static id="caption35" text="마감일자 :" class="search_name" position="absolute 5 5 80 30" anchor="default"/>
- <Calendar id="ipt_fromdd" taborder="1" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" position="absolute 90 5 180 30" anchor="default"/>
- <Static id="caption4" text="~" position="absolute 185 5 196 30" style="align:center ;" anchor="default"/>
- <Calendar id="ipt_todd" taborder="2" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" position="absolute 200 5 290 30" anchor="default"/>
- <Button id="btn_search" taborder="3" text="조회" onclick="btn_search_onclick" class="btn1" position="absolute 1133 5 1189 30" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- <Static id="caption6" class="tit_1" position="absolute 0 0 142 25" style="" text="일일 마감관리 현황"/>
- <Static id="caption77" class="tit_2" position="absolute 0 70 80 89" style="" text="마감 내역"/>
- <Grid id="grd_magm" binddataset="ds_main_magmlist_magminfo" position="absolute 0 90 1195 780" style="" autofittype="col">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="80"/>
- <Column size="60"/>
- <Column size="70"/>
- <Column size="70"/>
- <Column size="75"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="90"/>
- <Column size="125"/>
- <Column size="125"/>
- <Column size="125"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell text="수납일"/>
- <Cell col="1" text="수납자수"/>
- <Cell col="2" text="마감"/>
- <Cell col="3" text="결제"/>
- <Cell col="4" text="마감후수납"/>
- <Cell col="5" text="현금"/>
- <Cell col="6" text="카드"/>
- <Cell col="7" text="온라인"/>
- <Cell col="8" text="수입 합계"/>
- <Cell col="9" text="미수"/>
- <Cell col="10" text="담당자결재"/>
- <Cell col="11" text="팀장결재"/>
- <Cell col="12" text="부서장결재"/>
- </Band>
- <Band id="body">
- <Cell displaytype="date" style="align:center middle;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:rcptexecdd" mask="yyyy-MM-dd" calendardisplaynulltype="none"/>
- <Cell col="1" displaytype="number" style="align:center middle;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:rcptrcnt" mask="9,999"/>
- <Cell col="2" style="align:center middle;background:EXPR(magmflag == "Y" ? "#ffffb4" : "#ffffff");background2:EXPR(magmflag == "Y" ? "#ffffb4" : "#ffffff");color:EXPR(magmflag == "Y" ? "crimson" : "");color2:EXPR(magmflag == "Y" ? "crimson" : "");font:EXPR(magmflag == "Y" ? "돋움,9,bold" : "돋움,9");selectbackground:EXPR(magmflag == "Y" ? "#ffffb4" : "#ffffff");" text="bind:magmcnt"/>
- <Cell col="3" style="align:center middle;background:EXPR(aprvflag == "Y" ? "#ffffb4" : "#ffffff");background2:EXPR(aprvflag == "Y" ? "#ffffb4" : "#ffffff");color:EXPR(aprvflag == "Y" ? "blue" : "");color2:EXPR(aprvflag == "Y" ? "blue" : "");font:EXPR(aprvflag == "Y" ? "돋움,9,bold" : "돋움,9");selectbackground:EXPR(aprvflag == "Y" ? "#ffffb4" : "#ffffff");" text="bind:aprvcnt"/>
- <Cell col="4" style="align:center;background:EXPR(mrflag == "Y" ? "#ffffb4" : "#ffffff");background2:EXPR(mrflag == "Y" ? "#ffffb4" : "#ffffff");color:EXPR(mrflag == "Y" ? "darkmagenta" : "");color2:EXPR(mrflag == "Y" ? "darkmagenta" : "");font:EXPR(mrflag == "Y" ? "돋움,9,bold" : "돋움,9");selectbackground:EXPR(mrflag == "Y" ? "#ffffb4" : "#ffffff");" text="bind:mrcnt"/>
- <Cell col="5" displaytype="number" style="padding:0 5 0 0;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:cashamt"/>
- <Cell col="6" displaytype="number" style="padding:0 5 0 0;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:cardamt"/>
- <Cell col="7" displaytype="number" style="padding:0 5 0 0;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:onlineamt"/>
- <Cell col="8" displaytype="number" style="padding:0 5 0 0;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:suipamt"/>
- <Cell col="9" displaytype="number" style="padding:0 5 0 0;background:#ffffffff;background2:#ffffffff;selectbackground:#ffffffff;" text="bind:uncoamt"/>
- <Cell col="10" style="align:center;background:EXPR(aprv2flag == "Y" ? "#ffffb4" : "#ffffff");background2:EXPR(aprv2flag == "Y" ? "#ffffb4" : "#ffffff");color:EXPR(aprv2flag == "Y" || aprv3flag == "Y" || aprv4flag == "Y" ? "darkblue" : "");color2:EXPR(aprv2flag == "Y" || aprv3flag == "Y" || aprv4flag == "Y" ? "darkblue" : "");font:EXPR(aprv2flag == "Y" ? "돋움,9,bold" : "돋움,9");selectbackground:EXPR(aprv2flag == "Y" ? "#ffffb4" : "#ffffff");" text="bind:aprv2"/>
- <Cell col="11" style="align:center;background:EXPR(aprv3flag == "Y" ? "#ffffb4" : "#ffffff");background2:EXPR(aprv3flag == "Y" ? "#ffffb4" : "#ffffff");color:EXPR(aprv2flag == "Y" || aprv3flag == "Y" || aprv4flag == "Y" ? "darkblue" : "");color2:EXPR(aprv2flag == "Y" || aprv3flag == "Y" || aprv4flag == "Y" ? "darkblue" : "");font:EXPR(aprv3flag == "Y" ? "돋움,9,bold" : "돋움,9");selectbackground:EXPR(aprv3flag == "Y" ? "#ffffb4" : "#ffffff");" text="bind:aprv3"/>
- <Cell col="12" style="align:center;background:EXPR(aprv4flag == "Y" ? "#ffffb4" : "#ffffff");background2:EXPR(aprv4flag == "Y" ? "#ffffb4" : "#ffffff");color:EXPR(aprv2flag == "Y" || aprv3flag == "Y" || aprv4flag == "Y" ? "darkblue" : "");color2:EXPR(aprv2flag == "Y" || aprv3flag == "Y" || aprv4flag == "Y" ? "darkblue" : "");font:EXPR(aprv4flag == "Y" ? "돋움,9,bold" : "돋움,9");selectbackground:EXPR(aprv4flag == "Y" ? "#ffffb4" : "#ffffff");" text="bind:aprv4"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Button id="btn_xls" class="btn2" position="absolute 1150 64 1195 89" text="엑셀" onclick="btn_xls_onclick"/>
- <Button id="btn_prt" class="btn2" position="absolute 1104 64 1149 89" text="출력" onclick="btn_prt_onclick"/>
- </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="fromdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="enddd" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="fromdd"/>
- <Col id="todd"/>
- <Col id="enddd"/>
- </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_report_prtinfo" 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="fromdd" type="STRING" size="256"/>
- <Column id="todd" type="STRING" size="256"/>
- <Column id="prtdt" type="STRING" size="256"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_report" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main_magmlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo/>
- </Dataset>
- <Dataset id="ds_main_magmlist_magminfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
- <ColumnInfo>
- <Column id="rcptexecdd" type="STRING" size="256"/>
- <Column id="rcptrcnt" type="STRING" size="256"/>
- <Column id="rcptcnt" type="STRING" size="256"/>
- <Column id="magmflag" type="STRING" size="256"/>
- <Column id="magmcnt" type="STRING" size="256"/>
- <Column id="aprvflag" type="STRING" size="256"/>
- <Column id="aprvcnt" type="STRING" size="256"/>
- <Column id="mrflag" type="STRING" size="256"/>
- <Column id="mrcnt" type="STRING" size="256"/>
- <Column id="cashamt" type="STRING" size="256"/>
- <Column id="cardamt" type="STRING" size="256"/>
- <Column id="onlineamt" type="STRING" size="256"/>
- <Column id="suipamt" type="STRING" size="256"/>
- <Column id="uncoamt" type="STRING" size="256"/>
- <Column id="aprv2flag" type="STRING" size="256"/>
- <Column id="aprv2" type="STRING" size="256"/>
- <Column id="aprv3flag" type="STRING" size="256"/>
- <Column id="aprv3" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="rcptexecdd"/>
- <Col id="rcptrcnt"/>
- <Col id="rcptcnt"/>
- <Col id="magmflag"/>
- <Col id="magmcnt"/>
- <Col id="aprvflag"/>
- <Col id="aprvcnt"/>
- <Col id="mrflag"/>
- <Col id="mrcnt"/>
- <Col id="cashamt"/>
- <Col id="cardamt"/>
- <Col id="onlineamt"/>
- <Col id="suipamt"/>
- <Col id="uncoamt"/>
- <Col id="aprv2flag"/>
- <Col id="aprv2"/>
- <Col id="aprv3flag"/>
- <Col id="aprv3"/>
- </Row>
- </Rows>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="Div00.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
- <BindItem id="item1" compid="Div00.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[include 'com_commonxp::comm_main.xjs';
- var arErrorCode = new HashArray();
- function SPPAE00203_onload(obj:Form, e:LoadEventInfo) {
- frmf_initForm(obj);
- var fromdd = utlf_getCurrentDate().toDate().getAddDate(-1).getDateFormat();
- ds_send.setColumn(0, "fromdd", fromdd);
- ds_send.setColumn(0, "todd", fromdd);
- }
- function btn_search_onclick(obj: Button, e: ClickEventInfo) {
-
- var dd = utlf_getDateInterval(ds_send.getColumn(0, "fromdd"), ds_send.getColumn(0, "todd"), "mm");
-
- if (dd > 5) {
- sysf_messageBox("6개월 이상은 조회할 수 없습니다.", "E999");
- return;
- }
-
- ds_main_magmlist_magminfo.clearData();
-
- var oParam = {};
- oParam.id = "TRPAE00203";
- oParam.service = "pamendstatsapp.PamEndStats";
- oParam.method = "reqGetRcptMagmStat";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_main_magmlist_magminfo=magminfo";
- oParam.async = true;
-
- tranf_submit(oParam);
- }
- function btn_xls_onclick(obj:Button, e:ClickEventInfo) {
- var days = ds_send.getColumn(0, "fromdd") + "-" + ds_send.getColumn(0, "todd");
- grdf_exportExcel(grd_magm, "마감 현황_" + days, "Sheet1", true, "" , 'user' , true);
- }
- function btn_prt_onclick(obj:Button, e:ClickEventInfo) {
-
- ds_send.setColumn(0, "enddd", ds_send.getColumn(0, "fromdd"));
- var oParam = {};
- oParam.id = "TRPAE00107";
- oParam.service = "pamendstatsapp.PamEndStats";
- oParam.method = "reqGetRcptPrtInfo";
- oParam.inds = "req=ds_send";
- oParam.outds = "ds_report_prtinfo=prtinfo";
- oParam.async = false;
-
- tranf_submit(oParam);
-
- dsf_makeValue(ds_report_prtinfo, "fromdd", "STRING", ds_send.getColumn(0, "fromdd"));
- dsf_makeValue(ds_report_prtinfo, "todd", "STRING", ds_send.getColumn(0, "todd"));
-
- var objDOM = rptf_createDOM();
- var objParam = new Object();
-
- rptf_setNodeListToDOM(objDOM, "root/main/magmlist/magminfo", ds_main_magmlist_magminfo);
- rptf_setNodeListToDOM(objDOM, "root/report/prtinfo", ds_report_prtinfo);
-
- objParam.xml_data_XML1 = objDOM.documentElement.source;
-
- var option = "open=1;save=1;directprint=0;printdialog=1;print=1;zoom=0";
-
- rptf_exeReportPreview30(["RPPAE00104"],[objParam], option);
- }]]></Script>
- </Form>
- </FDL>
|
