YNU_JEUS/app_home/himed/xpapps/ast/healexamreqxp/xp/SMAHA03000_단체별실시예약조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHA03000" position="absolute 0 0 1196 765" titletext="미수관리" oninit="SMAHA03000_oninit" onload="SMAHA03000_onload">
    <Layouts>
      <Layout>
        <Tab position="absolute 0 67 1195 737" id="switch1" anchor="all">
          <Tabpages>
            <Tabpage text="실시자" id="case1">
              <Layouts>
                <Layout>
                  <Grid position="absolute 0 0 1195 641" id="grd_exelst" binddataset="ds_main_cmpylst_exelst" autoenter="select" cellsizingtype="col" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="26" band="left"/>
                          <Column size="139"/>
                          <Column size="80"/>
                          <Column size="86"/>
                          <Column size="70"/>
                          <Column size="116"/>
                          <Column size="88"/>
                          <Column size="82"/>
                          <Column size="81"/>
                          <Column size="81"/>
                          <Column size="81"/>
                          <Column size="81"/>
                          <Column size="70"/>
                          <Column size="100"/>
                          <Column size="200"/>
                          <Column size="200"/>
                          <Column size="0"/>
                          <Column size="0"/>
                          <Column size="0"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                          <Row size="24" band="summ"/>
                        </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="건진일자"/>
                          <Cell col="7" text="계약종류"/>
                          <Cell col="8" text="계약금액"/>
                          <Cell col="9" text="추가금액"/>
                          <Cell col="10" text="선납금"/>
                          <Cell col="11" text="회사청구금액"/>
                          <Cell col="12" text="부서명"/>
                          <Cell col="13" text="관계"/>
                          <Cell col="14" text="비고(전달사항)"/>
                          <Cell col="15" text="추가검사"/>
                          <Cell col="16"/>
                          <Cell col="17"/>
                          <Cell col="18"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" text="bind:cmpynm"/>
                          <Cell col="2" text="bind:clntempid"/>
                          <Cell col="3" text="bind:pid"/>
                          <Cell col="4" text="bind:hngnm"/>
                          <Cell col="5" text="bind:rrgstno" mask="######-#######" maskchar=" "/>
                          <Cell col="6" displaytype="date" text="bind:hopedd" calendardisplaynulltype="nulltext"/>
                          <Cell col="7" text="bind:contype"/>
                          <Cell col="8" displaytype="number" text="bind:contamt"/>
                          <Cell col="9" displaytype="number" text="bind:addexamamt"/>
                          <Cell col="10" displaytype="number" text="bind:ownbamt"/>
                          <Cell col="11" displaytype="number" text="bind:cmpyamt"/>
                          <Cell col="12" text="bind:clntdeptnm"/>
                          <Cell col="13" text="bind:famyrelanm"/>
                          <Cell col="14" style="align:left top;" text="bind:remcnts" wordwrap="word"/>
                          <Cell col="15" style="align:left top;" text="bind:pkgnm" wordwrap="word"/>
                          <Cell col="16" text="bind:rsrvno"/>
                          <Cell col="17" text="bind:condflag"/>
                          <Cell col="18" text="bind:clamseqno"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="1" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="총계"/>
                          <Cell col="2" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="3" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="4" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="5" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="6" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="7" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="8" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('contamt')"/>
                          <Cell col="9" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('addexamamt')"/>
                          <Cell col="10" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('ownbamt')"/>
                          <Cell col="11" displaytype="number" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;" text="expr:getSum('cmpyamt')"/>
                          <Cell col="12" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="13" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="14" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="15" style="background:#808080ff;background2:#808080ff;color:#ffffffff;color2:#ffffffff;font:arial,9,bold;"/>
                          <Cell col="16"/>
                          <Cell col="17"/>
                          <Cell col="18"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage text="예약자" id="case2">
              <Layouts>
                <Layout>
                  <Grid position="absolute 0 1 1195 641" id="grd_rsrvlst" binddataset="ds_main_cmpylst_rsrvlst" anchor="all" autoenter="select" cellsizingtype="col">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="26" band="left"/>
                          <Column size="139"/>
                          <Column size="80"/>
                          <Column size="86"/>
                          <Column size="70"/>
                          <Column size="116"/>
                          <Column size="88"/>
                          <Column size="82"/>
                          <Column size="81"/>
                          <Column size="81"/>
                          <Column size="81"/>
                          <Column size="81"/>
                          <Column size="70"/>
                          <Column size="100"/>
                          <Column size="200"/>
                          <Column size="200"/>
                          <Column size="0"/>
                          <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="건진일자"/>
                          <Cell col="7" text="계약종류"/>
                          <Cell col="8" text="계약금액"/>
                          <Cell col="9" text="추가금액"/>
                          <Cell col="10" text="선납금"/>
                          <Cell col="11" text="회사청구금액"/>
                          <Cell col="12" text="부서명"/>
                          <Cell col="13" text="관계"/>
                          <Cell col="14" text="비고(전달사항)"/>
                          <Cell col="15" text="추가검사"/>
                          <Cell col="16"/>
                          <Cell col="17"/>
                          <Cell col="18"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" text="bind:cmpynm"/>
                          <Cell col="2" text="bind:clntempid"/>
                          <Cell col="3" text="bind:pid"/>
                          <Cell col="4" text="bind:hngnm"/>
                          <Cell col="5" text="bind:rrgstno" mask="######-#######" maskchar=" "/>
                          <Cell col="6" displaytype="date" text="bind:hopedd" calendardisplaynulltype="nulltext"/>
                          <Cell col="7" text="bind:contype"/>
                          <Cell col="8" displaytype="number" text="bind:contamt"/>
                          <Cell col="9" displaytype="number" text="bind:addexamamt"/>
                          <Cell col="10" displaytype="number" text="bind:ownbamt"/>
                          <Cell col="11" displaytype="number" text="bind:cmpyamt"/>
                          <Cell col="12" text="bind:clntdeptnm"/>
                          <Cell col="13" text="bind:famyrelanm"/>
                          <Cell col="14" style="align:left top;" text="bind:remcnts" wordwrap="word"/>
                          <Cell col="15" style="align:left top;" text="bind:pkgnm" wordwrap="word"/>
                          <Cell col="16" text="bind:rsrvno"/>
                          <Cell col="17" text="bind:condflag"/>
                          <Cell col="18" text="bind:clamseqno"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Div id="grp_sea" taborder="1" position="absolute 0 25 1195 65" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption42" text="사업체   :" class="search_name" position="absolute 10 12 109 29"/>
              <Edit id="ipt_cmpycd" taborder="1" class="input_search" position="absolute 104 12 185 31" autoselect="true" autoskip="true" onkeyup="grp_sea_ipt_cmpycd_onkeyup"/>
              <Button id="btn_selcmpy" taborder="2" class="icon_search" position="absolute 190 13 206 29" onclick="grp_sea_btn_selcmpy_onclick"/>
              <Edit id="opt_cmpynm" taborder="3" readonly="true" position="absolute 210 11 360 30" autoselect="true" autoskip="true" class="output"/>
              <Static id="caption5" text="조회기간 :" class="search_name" position="absolute 375 11 475 28"/>
              <Calendar id="ipt_fromdate" taborder="4" class="input_essential" position="absolute 470 11 585 30" autoselect="true" autoskip="true"/>
              <Static id="caption93" text="~" class="search_n_b" position="absolute 593 11 605 28"/>
              <Calendar id="ipt_todate" taborder="5" class="input_essential" position="absolute 615 11 730 30" autoselect="true" autoskip="true"/>
              <Shape id="line8" linetype="vertical" class="line_4" position="absolute 1107 8 1113 33" anchor="top right"/>
              <Button id="btn_srchtrgtman" taborder="6" text="조회" class="btn1" position="absolute 1125 10 1181 32" anchor="top right" onclick="grp_sea_btn_srchtrgtman_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption2" text="단체별 실시자/미실시자 현황" class="tit_1" position="absolute 0 0 260 25"/>
        <Button id="btn_prntpsnspec" taborder="2" text="예약자 엑셀출력" class="btn7" position="absolute 125 738 245 760" anchor="left bottom" onclick="btn_prntpsnspec_onclick"/>
        <Button id="btn_prntcustspec" taborder="3" text="실시자 엑셀출력" class="btn7" position="absolute 0 738 121 760" anchor="left bottom" onclick="btn_prntcustspec_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_srchinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmpycd" type="STRING" size="256"/>
          <Column id="cmpynm" type="STRING" size="256"/>
          <Column id="pkgcd" type="STRING" size="256"/>
          <Column id="pkgnm" type="STRING" size="256"/>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="condflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cmpycd"/>
            <Col id="cmpynm"/>
            <Col id="pkgcd"/>
            <Col id="pkgnm"/>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="condflag">H</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_cmpylst_exelst" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmpynm" type="STRING" size="256" sumtext="단체명칭"/>
          <Column id="clntempid" type="STRING" size="256" sumtext="사번"/>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="hngnm" type="STRING" size="256" sumtext="성명"/>
          <Column id="rrgstno" type="STRING" size="256" sumtext="주민번호"/>
          <Column id="hopedd" type="STRING" size="256" sumtext="건진일자"/>
          <Column id="contype" type="STRING" size="256" sumtext="계약종류"/>
          <Column id="contamt" type="INT" size="256" sumtext="계약금액"/>
          <Column id="addexamamt" type="INT" size="256" sumtext="추가금액"/>
          <Column id="ownbamt" type="INT" size="256" sumtext="선납금"/>
          <Column id="cmpyamt" type="INT" size="256" sumtext="회사청구금액"/>
          <Column id="clntdeptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="famyrelanm" type="STRING" size="256" sumtext="관계"/>
          <Column id="remcnts" type="STRING" size="256" sumtext="비고(전달사항)"/>
          <Column id="pkgnm" type="STRING" size="256" sumtext="추가검사"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_cmpylst_rsrvlst" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmpynm" type="STRING" size="256" sumtext="단체명칭"/>
          <Column id="clntempid" type="STRING" size="256" sumtext="사번"/>
          <Column id="pid" type="STRING" size="256" sumtext="등록번호"/>
          <Column id="hngnm" type="STRING" size="256" sumtext="성명"/>
          <Column id="rrgstno" type="STRING" size="256" sumtext="주민번호"/>
          <Column id="hopedd" type="STRING" size="256" sumtext="건진일자"/>
          <Column id="contype" type="STRING" size="256" sumtext="계약종류"/>
          <Column id="contamt" type="INT" size="256" sumtext="계약금액"/>
          <Column id="addexamamt" type="INT" size="256" sumtext="추가금액"/>
          <Column id="ownbamt" type="INT" size="256" sumtext="선납금"/>
          <Column id="cmpyamt" type="INT" size="256" sumtext="회사청구금액"/>
          <Column id="clntdeptnm" type="STRING" size="256" sumtext="부서명"/>
          <Column id="famyrelanm" type="STRING" size="256" sumtext="관계"/>
          <Column id="remcnts" type="STRING" size="256" sumtext="비고(전달사항)"/>
          <Column id="pkgnm" type="STRING" size="256" sumtext="추가검사"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_cmpycd" propid="value" datasetid="ds_send_srchinfo" columnid="cmpycd"/>
      <BindItem id="item1" compid="grp_sea.opt_cmpynm" propid="value" datasetid="ds_send_srchinfo" columnid="cmpynm"/>
      <BindItem id="item2" compid="grp_sea.ipt_fromdate" propid="value" datasetid="ds_send_srchinfo" columnid="fromdd"/>
      <BindItem id="item3" compid="grp_sea.ipt_todate" propid="value" datasetid="ds_send_srchinfo" columnid="todd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-11-13
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-11-13      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "ast_healexamxp::AHA001.xjs";
function SMAHA03000_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAHA03000_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(switch1.case1.grd_exelst);
	grdf_initGrid(switch1.case2.grd_rsrvlst);
	
	var curDt = utlf_getCurrentDate();
	var startdate = String(curDt).substring(0, 4) + "0101";
	
	grp_sea.ipt_fromdate.value = startdate;
	grp_sea.ipt_todate.value = curDt;
}

function grp_sea_ipt_cmpycd_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		grp_sea.btn_selcmpy.click();
	}
}

function grp_sea_btn_selcmpy_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetComnCd("SMAHA02300", "08" , "nm", grp_sea.ipt_cmpycd.value, grp_sea.ipt_cmpycd, grp_sea.opt_cmpynm); 	
}

function grp_sea_btn_srchtrgtman_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(ds_send_srchinfo.getColumn(0, "cmpycd")))
	{
		sysf_messageBox("단체코드를 확인해주세요", "E");
		return false;
	}
	if(utlf_isNull(ds_send_srchinfo.getColumn(0,  "fromdd")))
	{
		syesf_messageBox("조회기간을 확인해주세요", "E");
		return false;
	}
	if(utlf_isNull(ds_send_srchinfo.getColumn(0,  "todd")))
	{
		sysf_messageBox("조회기간을 확인해주세요", "E");
		return false;
	}
	var oParam = {};
		oParam.id          = "TRAHA03001";
		oParam.service     = "healexamreqapp.UncoMngt";
		oParam.method      = "reqGetCmpyExeRsrvLst";
		oParam.inds        = "req=ds_send_srchinfo";
		oParam.outds       = "ds_main_cmpylst_exelst=exelst ds_main_cmpylst_rsrvlst=rsrvlst";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHA03001";

	tranf_submit(oParam);
}

function btn_prntcustspec_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(switch1.case1.grd_exelst, "excel", "SheetName", "true", "", "");
}

function btn_prntpsnspec_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(switch1.case2.grd_rsrvlst, "excel", "SheetName", "true", "", "");
}
]]></Script>
  </Form>
</FDL>