123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456 |
- <?xml version="1.0" encoding="utf-8"?>
- <FDL version="1.5">
- <TypeDefinition url="..\..\..\default_typedef.xml"/>
- <Form id="SMMNH06900" position="absolute 0 0 1200 740" titletext="기부금영수증 발행 관리" oninit="SMMNH06900_oninit" onload="SMMNH06900_onload">
- <Layouts>
- <Layout>
- <Div position="absolute 0 13 1195 733" id="group5" class="datagrid2" scrollbars="autoboth" anchor="all">
- <Layouts>
- <Layout>
- <Div position="absolute 0 11 1195 56" align="align:center top;" id="grp_sea" class="div_SA" anchor="left top right">
- <Layouts>
- <Layout>
- <Static text="회원구분 :" position="absolute 524 12 610 29" id="caption2" class="search_name" anchor="default"/>
- <Button position="absolute 1065 10 1121 32" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="group5_grp_sea_btn_search_onclick"/>
- <Shape position="absolute 1051 10 1057 32" linetype="vertical" id="line13" class="line_4" anchor="top right"/>
- <Combo position="absolute 608 10 703 29" id="cmb_conmembflag" class="combo_search" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">
- </Col>
- <Col id="datacolumn">전체</Col>
- </Row>
- <Row>
- <Col id="codecolumn">01</Col>
- <Col id="datacolumn">봉사자</Col>
- </Row>
- <Row>
- <Col id="codecolumn">02</Col>
- <Col id="datacolumn">직원</Col>
- </Row>
- <Row>
- <Col id="codecolumn">03</Col>
- <Col id="datacolumn">일반</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Combo position="absolute 408 11 503 30" id="cmb_conposflag" class="combo_search" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">
- </Col>
- <Col id="datacolumn">전체</Col>
- </Row>
- <Row>
- <Col id="codecolumn">01</Col>
- <Col id="datacolumn">개인</Col>
- </Row>
- <Row>
- <Col id="codecolumn">02</Col>
- <Col id="datacolumn">단체</Col>
- </Row>
- <Row>
- <Col id="codecolumn">03</Col>
- <Col id="datacolumn">익명</Col>
- </Row>
- </Rows>
- </Dataset>
- </Combo>
- <Static text="소속구분 :" position="absolute 327 13 413 30" id="caption13" class="search_name" anchor="default"/>
- <Static text="발행일자 :" position="absolute 12 13 98 30" id="caption4" class="search_name" anchor="default"/>
- <Edit position="absolute 863 10 963 29" id="input1" anchor="default" onkeyup="group5_grp_sea_input1_onkeyup" autoselect="true"/>
- <Radio position="absolute 722 9 862 30" id="rdo_membflag" columncount="2" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
- <Dataset id="innerdataset">
- <ColumnInfo>
- <Column id="codecolumn"/>
- <Column id="datacolumn"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="codecolumn">2</Col>
- <Col id="datacolumn">회원명</Col>
- </Row>
- <Row>
- <Col id="codecolumn">1</Col>
- <Col id="datacolumn">회원번호</Col>
- </Row>
- </Rows>
- </Dataset>
- </Radio>
- <Calendar position="absolute 95 11 195 30" id="ipt_fromdd" class="input_s_essential" anchor="default" dateformat="yyyy-MM-dd" value="null" autoselect="true"/>
- <Calendar position="absolute 212 11 312 30" id="ipt_todd" class="input_s_essential" anchor="default" dateformat="yyyy-MM-dd" value="null" autoselect="true"/>
- <Static text="~" position="absolute 198 12 213 32" id="caption1" anchor="default"/>
- <Button position="absolute 1125 10 1181 32" id="button10" class="btn7" text="엑셀" anchor="top right" onclick="group5_grp_sea_button10_onclick"/>
- </Layout>
- </Layouts>
- </Div>
- <Static text="기부금 영수증 발행 내역" position="absolute 1 65 254 86" id="caption7" class="tit_2" anchor="default"/>
- <Shape position="absolute 0 81 746 87" linetype="horizontal" id="line1" class="line_1" anchor="default" style="strokepen:3 solid #33bbbbff;"/>
- <Button position="absolute 1064 61 1194 80" id="button6" class="btn2" text="기부금 영수증 재출력" anchor="top right" onclick="group5_button6_onclick"/>
- <Grid position="absolute 0 86 746 719" id="grd_prtlist" binddataset="ds_main_prtinfo_prtlist" anchor="left top bottom" oncellclick="group5_grd_prtlist_oncellclick" cellsizingtype="col" selecttype="multirow">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="90"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="80"/>
- <Column size="118"/>
- <Column size="80"/>
- <Column size="100"/>
- <Column size="100"/>
- </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="발행매수"/>
- </Band>
- <Band id="body">
- <Cell displaytype="date" text="bind:prtdd" calendardisplaynulltype="none"/>
- <Cell col="1" displaytype="combo" edittype="combo" text="bind:posflag" combodataset="ds_cmb_posflag" combocodecol="value" combodatacol="label" enable="false"/>
- <Cell col="2" displaytype="combo" edittype="combo" style="align:center;" text="bind:membflag" combodataset="ds_cmb_membflag" combocodecol="value" combodatacol="label" enable="false"/>
- <Cell col="3" text="bind:membno"/>
- <Cell col="4" style="align:left top;" text="bind:cmntnm" wordwrap="word"/>
- <Cell col="5" text="bind:membnm"/>
- <Cell col="6" text="bind:rrgstno" mask="######-####aaa" maskchar="*"/>
- <Cell col="7" text="bind:cnt"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Grid position="absolute 755 86 1193 719" id="grd_prtdetllist" binddataset="ds_main_prtdetlinfo_prtdetllist" anchor="all" cellsizingtype="col" selecttype="multirow">
- <Formats>
- <Format id="default">
- <Columns>
- <Column size="25"/>
- <Column size="50"/>
- <Column size="86"/>
- <Column size="80"/>
- <Column size="72"/>
- <Column size="100"/>
- <Column size="0"/>
- <Column size="0"/>
- </Columns>
- <Rows>
- <Row size="24" band="head"/>
- <Row size="24"/>
- </Rows>
- <Band id="head">
- <Cell/>
- <Cell col="1" text="구분"/>
- <Cell col="2" text="일련번호"/>
- <Cell col="3" text="회원번호"/>
- <Cell col="4" text="회원명"/>
- <Cell col="5" text="단체명"/>
- <Cell col="6" text="caption1"/>
- <Cell col="7" text="caption2"/>
- </Band>
- <Band id="body">
- <Cell displaytype="checkbox" edittype="checkbox" text="bind:chkyn" expr="expr:chkyn == 'Y' || chkyn == '1' ? 1 : 0"/>
- <Cell col="1" displaytype="combo" edittype="combo" style="align:center;" text="bind:prtflag" combodataset="ds_cmb_prtflag" combocodecol="value" combodatacol="label" enable="false"/>
- <Cell col="2" text="bind:seqno"/>
- <Cell col="3" text="bind:membno"/>
- <Cell col="4" text="bind:membnm"/>
- <Cell col="5" text="bind:cmntnm"/>
- <Cell col="6" text="bind:prtyy"/>
- <Cell col="7" text="bind:prtseq"/>
- </Band>
- </Format>
- </Formats>
- </Grid>
- <Shape position="absolute 755 81 1193 87" linetype="horizontal" id="line2" class="line_1" anchor="left top right" style="strokepen:3 solid #33bbbbff;"/>
- <Static text="기부금 영수증 발행 상세" position="absolute 755 65 1008 86" id="caption3" class="tit_2" anchor="default"/>
- </Layout>
- </Layouts>
- </Div>
- <Static id="caption6" text="기부금영수증발행관리" class="tit_1" position="absolute 0 1 167 24"/>
- </Layout>
- </Layouts>
- <Objects>
- <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="fromdd" type="STRING" size="256" sumtext="시작일자"/>
- <Column id="todd" type="STRING" size="256" sumtext="종료일자"/>
- <Column id="conposflag" type="STRING" size="256" sumtext="소속구분"/>
- <Column id="conmembflag" type="STRING" size="256" sumtext="회원구분"/>
- <Column id="membnm" type="STRING" size="256" sumtext="회원명"/>
- <Column id="membflag" type="STRING" size="256" sumtext="회원조회구분"/>
- <Column id="prtseq" type="STRING" size="256"/>
- <Column id="prtyy" type="STRING" size="256"/>
- <Column id="seqno" type="STRING" size="256"/>
- <Column id="prtflag" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="membflag">2</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_cmb_membflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="label" type="STRING" size="256"/>
- <Column id="value" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="label">봉사자</Col>
- <Col id="value">01</Col>
- </Row>
- <Row>
- <Col id="label">직원</Col>
- <Col id="value">02</Col>
- </Row>
- <Row>
- <Col id="label">일반</Col>
- <Col id="value">03</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_cmb_posflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="label" type="STRING" size="256"/>
- <Column id="value" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="label">개인</Col>
- <Col id="value">01</Col>
- </Row>
- <Row>
- <Col id="label">단체</Col>
- <Col id="value">02</Col>
- </Row>
- <Row>
- <Col id="label">익명</Col>
- <Col id="value">03</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_main_prtinfo_prtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="prtdd" type="STRING" size="256" sumtext="출력일자"/>
- <Column id="posflag" type="STRING" size="256" sumtext="소속구분"/>
- <Column id="membflag" type="STRING" size="256" sumtext="회원구분"/>
- <Column id="membno" type="STRING" size="256" sumtext="회원번호"/>
- <Column id="cmntnm" type="STRING" size="256" sumtext="단체명 "/>
- <Column id="membnm" type="STRING" size="256" sumtext="회원명 "/>
- <Column id="rrgstno" type="STRING" size="256" sumtext="주민번호"/>
- <Column id="cnt" type="STRING" size="256" sumtext="발행매수"/>
- </ColumnInfo>
- </Dataset>
- <Dataset id="ds_main_prtdetlinfo_prtdetllist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_prtdetlinfo_prtdetllist_oncolumnchanged"/>
- <Dataset id="ds_cmb_prtflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="label" type="STRING" size="256"/>
- <Column id="value" type="STRING" size="256"/>
- </ColumnInfo>
- <Rows>
- <Row>
- <Col id="label">소득세</Col>
- <Col id="value">1</Col>
- </Row>
- <Row>
- <Col id="label">법인세</Col>
- <Col id="value">2</Col>
- </Row>
- </Rows>
- </Dataset>
- <Dataset id="ds_tmp_prtinfo_memberacntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
- <ColumnInfo>
- <Column id="seqno" type="STRING" size="256" sumtext="출력번호"/>
- <Column id="membno" type="STRING" size="256" sumtext="회원번호"/>
- <Column id="membnm" type="STRING" size="256" sumtext="회원이름"/>
- <Column id="cmntnm" type="STRING" size="256" sumtext="단체명 "/>
- <Column id="rrgstno" type="STRING" size="256" sumtext="주민번호"/>
- <Column id="prtflag" type="STRING" size="256" sumtext="출력구분"/>
- <Column id="payindd" type="STRING" size="256" sumtext="기부일자"/>
- <Column id="aidamt" type="STRING" size="256" sumtext="기부금"/>
- <Column id="bizmngrgstno" type="STRING" size="256" sumtext="사업자번호"/>
- <Column id="posflag" type="STRING" size="256" sumtext="환자구분"/>
- <Column id="addr" type="STRING" size="256" sumtext="주소"/>
- </ColumnInfo>
- </Dataset>
- </Objects>
- <Bind>
- <BindItem id="item0" compid="group5.grp_sea.ipt_fromdd" propid="value" datasetid="ds_temp" columnid="fromdd"/>
- <BindItem id="item1" compid="group5.grp_sea.ipt_todd" propid="value" datasetid="ds_temp" columnid="todd"/>
- <BindItem id="item2" compid="group5.grp_sea.cmb_conposflag" propid="value" datasetid="ds_temp" columnid="conposflag"/>
- <BindItem id="item3" compid="group5.grp_sea.cmb_conmembflag" propid="value" datasetid="ds_temp" columnid="conmembflag"/>
- <BindItem id="item4" compid="group5.grp_sea.rdo_membflag" propid="value" datasetid="ds_temp" columnid="membflag"/>
- <BindItem id="item5" compid="group5.grp_sea.input1" propid="value" datasetid="ds_temp" columnid="membnm"/>
- </Bind>
- <Script type="xscript4.0"><![CDATA[/***************************************************************************************
- * System Name :
- * Job Name :
- * Creator :
- * Make Date : 2016-10-31
- * Description :
- *---------------------------------------------------------------------------------------
- * Modify Date Modifier Modify Description
- *---------------------------------------------------------------------------------------
- * 2016-10-31 Live Converter TF->XP
- *
- *---------------------------------------------------------------------------------------
- ****************************************************************************************/
- include "com_commonxp::comm_main.xjs";
- function SMMNH06900_oninit(obj:Form, e:InitEventInfo)
- {
- frmf_initForm(obj);
- }
- function SMMNH06900_onload(obj:Form, e:LoadEventInfo)
- {
- ds_temp.setColumn(0, "fromdd", utlf_getCurrentDate());
- ds_temp.setColumn(0, "todd", utlf_getCurrentDate());
-
- group5.grp_sea.cmb_conmembflag.index = 0;
- group5.grp_sea.cmb_conposflag.index = 0;
-
- fSearch();
- }
- function fSearch()
- {
- var oParam = {};
- oParam.id = "TRMNH06901";
- oParam.service = "hospiceapp.HospiceAidAssocnMngt";
- oParam.method = "reqGetPrtList";
- oParam.inds = "req=ds_temp";
- oParam.outds = "ds_main_prtinfo_prtlist=prtlist";
- oParam.async = false;
- //oParam.callback = "cf_TRMNH06901";
- tranf_submit(oParam);
- }
- function group5_grp_sea_input1_onkeyup(obj:Edit, e:KeyEventInfo)
- {
- if(e.keycode == 13)
- {
- obj.updateToDataset();
- group5_grp_sea_btn_search_onclick();
- }
- }
- function group5_grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
- {
- fSearch();
- }
- function group5_grd_prtlist_oncellclick(obj:Grid, e:GridClickEventInfo)
- {
- if(e.row > -1)
- {
- dsf_createDsRow("ds_send_reqdata", [{col:"prtdd", type:"STRING", size:256 , val : ds_main_prtinfo_prtlist.getColumn(e.row, "prtdd")}
- , {col:"membno", type:"STRING", size:256 , val : ds_main_prtinfo_prtlist.getColumn(e.row, "membno")}]);
-
- var oParam = {};
- oParam.id = "TRMNH06901";
- oParam.service = "hospiceapp.HospiceAidAssocnMngt";
- oParam.method = "reqGetPrtDetlList";
- oParam.inds = "req=ds_send_reqdata";
- oParam.outds = "ds_main_prtdetlinfo_prtdetllist=prtdetllist";
- oParam.async = false;
- //oParam.callback = "cf_TRMNH06901";
- tranf_submit(oParam);
-
- if( utlf_isNull(ds_main_prtdetlinfo_prtdetllist.getColumnInfo("chkyn")) ){
- ds_main_prtdetlinfo_prtdetllist.addColumn("chkyn", "string");
- }
- }
- }
- function ds_main_prtdetlinfo_prtdetllist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
- {
- if(e.columnid == "chkyn")
- {
- obj.setColumn(e.row, "chkyn", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
- }
- }
- function group5_button6_onclick(obj:Button, e:ClickEventInfo)
- {
- ds_main_prtdetlinfo_prtdetllist.filterstr = "chkyn == 'Y'";
- var node = ds_main_prtdetlinfo_prtdetllist.rowcount;
- ds_main_prtdetlinfo_prtdetllist.filterstr = "";
-
- if(node == 0)
- {
- sysf_messageBox("기부금 영수증 재출력할 항목을 선택하여 주십시오.", "E");
- return;
- }
-
- var chkyn = "";
-
- for(var i = 0; i < ds_main_prtdetlinfo_prtdetllist.rowcount; i++)
- {
- chkyn = ds_main_prtdetlinfo_prtdetllist.getColumn(i, "chkyn");
-
- if(chkyn == "Y")
- {
- ds_temp.setColumn(0, "prtseq", ds_main_prtdetlinfo_prtdetllist.getColumn(i, "prtseq"));
- ds_temp.setColumn(0, "prtyy", ds_main_prtdetlinfo_prtdetllist.getColumn(i, "prtyy"));
- ds_temp.setColumn(0, "seqno", ds_main_prtdetlinfo_prtdetllist.getColumn(i, "seqno"));
- ds_temp.setColumn(0, "prtflag", ds_main_prtdetlinfo_prtdetllist.getColumn(i, "prtflag"));
-
- var oParam = {};
- oParam.id = "TRMNH06901";
- oParam.service = "hospiceapp.HospiceAidAssocnMngt";
- oParam.method = "reqGetRePrtlist";
- oParam.inds = "req=ds_temp";
- oParam.outds = "ds_tmp_prtinfo_memberacntlist=memberacntlist";
- oParam.async = false;
- //oParam.callback = "cf_TRMNH06901";
- tranf_submit(oParam);
-
- var objDOM = rptf_createDOM();
- rptf_setNodeListToDOM(objDOM, "/root/temp", ds_temp);
- rptf_setNodeListToDOM(objDOM, "/root/tmp/prtinfo/memberacntlist", ds_tmp_prtinfo_memberacntlist);
-
- var objParam = new Object();
- objParam.xml_data_XML1 = objDOM.documentElement.source;
-
- var option = "open=1;save=0;directprint=0;printdialog=0;print=0;zoom=0;";
-
- rptf_exeReportPreview30(["RPMNH02400"],[objParam], option);
- }
- }
- }
- function group5_grp_sea_button10_onclick(obj:Button, e:ClickEventInfo)
- {
- if(ds_main_prtinfo_prtlist.rowcount == 0)
- {
- sysf_messageBox("엑셀저장할 내역이", "I004");
- }
- else
- {
- grdf_exportExcel(group5.grd_prtlist, "선납재료관리", "see");
- }
- }
- ]]></Script>
- </Form>
- </FDL>
|