YNU_JEUS/app_home/himed/xpapps/ast/healexamstatxp/xp/SMAHS03700_업체별건진결과.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAHS03700" position="absolute 0 0 1196 765" titletext="업체별건진결과" onload="SMAHS03700_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 25 1195 65" id="grp_srch" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Static text="기간 :" position="absolute 15 12 88 29" id="caption2" class="search_name" anchor="default"/>
              <Shape position="absolute 1106 9 1112 31" linetype="vertical" id="line2" class="line_4" anchor="top right"/>
              <Button position="absolute 1124 9 1180 31" id="btn_search" class="btn1" text="조회" anchor="top right" onclick="grp_srch_btn_search_onclick"/>
              <Calendar position="absolute 82 11 195 30" id="ipt_fromdd" class="input_essential" taborder="7" anchor="default" autoselect="true" autoskip="true" onchanged="grp_srch_ipt_fromdd_onchanged"/>
              <Calendar id="ipt_todd" taborder="8" autoselect="true" autoskip="true" class="input_essential" position="absolute 210 11 323 30"/>
              <Static id="Static00" text="~" position="absolute 197 13 208 30"/>
              <Combo id="cmb_cmpycd" taborder="9" position="absolute 425 11 637 31" index="-1" class="combo_essential" innerdataset="ds_init_cmpylist" codecolumn="cdid" datacolumn="cdnm" onitemchanged="grp_srch_cmb_cmpycd_onitemchanged"/>
              <Static id="caption00" text="업체 :" class="search_name" position="absolute 359 12 424 29"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption60" text="업체별 건진결과" class="tit_1" position="absolute 0 0 140 25"/>
        <Button id="btn_excel" taborder="1" text="엑셀저장" position="absolute 1119 67 1195 89" class="btn7" onclick="btn_excel_onclick"/>
        <Shape id="line1" class="line_10" position="absolute 0 89 1195 95"/>
        <Grid id="grd_main" taborder="2" useinputpanel="false" position="absolute 0 94 1195 764" cellsizingtype="col" selecttype="multirow" scrollpixel="all" binddataset="ds_main_item" cellsizebandtype="allband">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="100" band="left"/>
                <Column size="50" band="left"/>
                <Column size="60" band="left"/>
                <Column size="100" band="left"/>
                <Column size="80" band="left"/>
                <Column size="300" band="left"/>
              </Columns>
              <Rows>
                <Row size="30" 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="종합판정"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow+1"/>
                <Cell col="1" text="bind:hosp" wordwrap="char" suppress="1" suppressalign="middle,over"/>
                <Cell col="2" text="bind:gubun" wordwrap="char" suppress="2" suppressalign="middle,over"/>
                <Cell col="3" text="bind:name"/>
                <Cell col="4" text="bind:rgstno" mask="######-#######"/>
                <Cell col="5" text="bind:examdd" mask="####-##-##"/>
                <Cell col="6" displaytype="text" style="align:left top;padding:4 2 1 2;" text="bind:judg" wordwrap="char" autosizerow="limitmin"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="cmpycd" type="STRING" size="256"/>
          <Column id="clscd" type="STRING" size="256"/>
          <Column id="etccd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="cmpycd"/>
            <Col id="clscd">G</Col>
            <Col id="etccd">P99</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_cmpylist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_title" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="hosp" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="rgstno" type="STRING" size="256"/>
          <Column id="examdd" type="STRING" size="256"/>
          <Column id="judg" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_srch.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_srch.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item2" compid="grp_srch.cmb_cmpycd" propid="value" datasetid="ds_send" columnid="cmpycd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-12-04
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
//=======================================================================================
// Lib Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";

//=======================================================================================
// Global Form Variable
//---------------------------------------------------------------------------------------
var arErrorCode = new HashArray();

//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------
/*-**************************************************************************************
 * Argument			: N/A
 * Description		: 업체리스트 조회
 ****************************************************************************************/
function fn_getCmpyList() {
	ds_init_cmpylist.clearData();
	var oParam = {};
		oParam.id          = "TRAHS03701";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetCmpyCodeList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_cmpylist=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS03701";

	tranf_submit(oParam);
}

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMAHS03700_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj); 
	
	ds_send.setColumn(0, "fromdd"	, String(utlf_getCurrentDate()).substr(0,8));
	ds_send.setColumn(0, "todd"		, String(utlf_getCurrentDate()).substr(0,8));
	
	fn_getCmpyList();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function grp_srch_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(utlf_isNull(ds_send.getColumn(0, "cmpycd"))) {
		sysf_messageBox("업체는", "I003");
		grp_srch.cmb_cmpycd.setFocus();
		return;
	}
	
	ds_main_item.clearData();
	var oParam = {};
		oParam.id          = "TRAHS03703";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetStatExamcureResult";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_item=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS03703";

	tranf_submit(oParam);
}

/****************************************************************************************
 * Components		: Combo
 * Description		: 업체 선택하여 그리드 헤더 조회
 ****************************************************************************************/
function grp_srch_cmb_cmpycd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	for(var i = grd_main.getCellCount("head") - 7; i >= 0 ; i--) {
		grd_main.deleteContentsCol(i);
	}
	
	ds_temp_title.clearData();
	ds_main_item.clearData();
	var oParam = {};
		oParam.id          = "TRAHS03702";
		oParam.service     = "healexamstatapp.StatRef";
		oParam.method      = "reqGetStatHeader";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_temp_title=item";
		oParam.async       = false;
		//oParam.callback    = "cf_TRAHS03702";

	tranf_submit(oParam);
	
	var row 	= 0;
	var cnt 	= ds_temp_title.rowcount;
	var colidx 	= 0;
	if(ds_temp_title.rowcount > 0) {
		for(var i = 7 ; i < 7 + cnt ; i++) {
			var col 	= grd_main.appendContentsCol();
			var code 	= ds_temp_title.getColumn(row, "code");
			var title 	= ds_temp_title.getColumn(row, "title");
			grd_main.setCellProperty("head", col, "text", title);
			grd_main.setCellProperty("body", col, "text", "bind:col"+colidx);
			grd_main.setCellProperty("body", col, "displaytype", "text");
			grd_main.setCellProperty("body", col, "align", "left top");
			grd_main.setCellProperty("body", col, "padding", "4 2 1 2");
			colidx++;
			grd_main.setFormatColProperty(col, "size", title.length * 18);
			row++;
		}
		grdf_setToolTipBind(grd_main);
	}
	
	if(ds_init_cmpylist.getColumn(e.postindex, "pointyn") == "Y") {
		var ccol = grd_main.appendContentsCol();
		grd_main.setCellProperty("head", ccol, "text", "우울증평가");
		grd_main.setCellProperty("body", ccol, "text", "bind:point");
		grd_main.setFormatColProperty(ccol, "size", 70);
// 		grd_main.setCellProperty("body", ccol, "displaytype", "text");
// 		grd_main.setCellProperty("body", ccol, "align", "left top");
// 		grd_main.setCellProperty("body", ccol, "padding", "4 2 1 2");
	}
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_item.rowcount > 0 ){
		var title = grp_srch.cmb_cmpycd.text + " 검진결과("+ds_send.getColumn(0, "fromdd")+"_"+ds_send.getColumn(0, "todd")+")";
		grdf_exportExcel(grd_main, title, "Sheet1", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}

/**
* 시작일자 클릭시 종료일자 자동 세팅
*/
function grp_srch_ipt_fromdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
//	ds_send.setColumn(0, "todd", utlf_getLastDate(utlf_addMonth(ds_send.getColumn(0, "fromdd"), 1)));
}
]]></Script>
  </Form>
</FDL>