YNU_JEUS/app_home/himed/xpapps/pam/pamexcuxp/xp/SMPEA00101_예약자별통합검사예약현황.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMPEA00101" position="absolute 0 0 1196 765" titletext="예약자별 통합 검사 예약 현황" onload="SMPEA00101_onload">
    <Layouts>
      <Layout>
        <Div id="grp_srch" taborder="7" position="absolute 0 25 1195 65" class="div_SA" anchor="left top right"/>
        <Static id="cap_title" class="tit_1" position="absolute 0 0 220 25" text="예약자별 통합 검사 예약 현황"/>
        <Static id="caption35" class="search_name" position="absolute 5 38 81 55" style="" text="예약일 :"/>
        <Calendar id="ipt_fromdd" class="input_search" mask="yyyy-mm-dd" position="absolute 85 36 175 55" style="" anchor="default" dateformat="yyyy-MM-dd"/>
        <Static id="caption2" position="absolute 175 37 190 57" style="align:center ;" text="~"/>
        <Calendar id="ipt_todd" class="input_search" mask="yyyy-mm-dd" position="absolute 190 36 280 55" style="" anchor="default" dateformat="yyyy-MM-dd" value="null"/>
        <Static id="caption1" class="search_name" position="absolute 320 38 386 55" style="" text="부서 :"/>
        <Combo innerdataset="ds_init_deptlist_deptinfo" datacolumn="deptnm" codecolumn="deptcd" columncount="-1" rowcount="-1" id="cmb_deptcd" class="combo_search" taborder="2" position="absolute 386 36 526 55" style=""/>
        <Shape id="line13" linetype="vertical" position="absolute 1120 34 1123 59" style="border: solid #FFD799 #FFD799;" anchor="top right"/>
        <Button id="btn_search" class="btn1" taborder="6" position="absolute 1130 35 1186 57" text="조회" onclick="btn_search_onclick" anchor="top right"/>
        <Static id="caption7" class="tit_2" position="absolute 0 73 93 90" style="font:,,bold;" text="조회 내역"/>
        <Shape id="line1" class="line_10" linetype="horizontal" position="absolute 0 89 1195 95" style="" anchor="left top right"/>
        <Grid id="grd_work" binddataset="ds_main_worklist_workinfo" position="absolute 0 94 1195 764" style="align:center ;" selecttype="multirow" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="120"/>
                <Column size="35"/>
                <Column size="50"/>
                <Column size="35"/>
                <Column size="120"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="120"/>
                <Column size="160"/>
                <Column size="100"/>
                <Column size="190"/>
                <Column size="124"/>
              </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="검사일시"/>
              </Band>
              <Band id="body">
                <Cell style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:dutplcenm" wordwrap="char" suppress="1" suppressalign="middle,over"/>
                <Cell col="1" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:dcnt" wordwrap="char" suppress="2" suppressalign="middle,over"/>
                <Cell col="2" displaytype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:rsrvrnm" wordwrap="char" suppress="3" suppressalign="middle,over"/>
                <Cell col="3" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:rcnt" wordwrap="char" suppress="4" suppressalign="middle,over"/>
                <Cell col="4" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:lastupdtdt" wordwrap="char" mask="expr:utlf_isNull(lastupdtdt) ? '' : '####-##-## ##:##'" suppress="5" suppressalign="middle,over"/>
                <Cell col="5" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:pid" wordwrap="char" suppress="6" suppressalign="middle,over"/>
                <Cell col="6" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:prcpdd" wordwrap="char" mask="expr:utlf_isNull(prcpdd) ? '' : '####-##-##'" suppress="7" suppressalign="middle,over"/>
                <Cell col="7" displaytype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:suppdeptnm" wordwrap="char" suppress="8" suppressalign="middle,over"/>
                <Cell col="8" displaytype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:excuroomnm" wordwrap="char" suppress="9" suppressalign="middle,over"/>
                <Cell col="9" displaytype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:calcscorcd"/>
                <Cell col="10" displaytype="text" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:calcscornm"/>
                <Cell col="11" style="background:BIND(bgcolor);background2:BIND(bgcolor);" text="bind:rsrvdt" mask="expr:utlf_isNull(rsrvdt) ? '' : '####-##-## ##:##'"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excel" class="btn7" position="absolute 1119 67 1195 89" style="" text="엑셀저장" onclick="btn_excel_onclick" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_worklist_workinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="dutplcecd" type="STRING" size="256"/>
          <Column id="dutplcenm" type="STRING" size="256"/>
          <Column id="dcnt" type="STRING" size="256"/>
          <Column id="rsrvrid" type="STRING" size="256"/>
          <Column id="rsrvrnm" type="STRING" size="256"/>
          <Column id="rcnt" type="STRING" size="256"/>
          <Column id="pid" type="STRING" size="256"/>
          <Column id="prcpdd" type="STRING" size="256"/>
          <Column id="suppdeptcd" type="STRING" size="256"/>
          <Column id="suppdeptnm" type="STRING" size="256"/>
          <Column id="excuroomcd" type="STRING" size="256"/>
          <Column id="excuroomnm" type="STRING" size="256"/>
          <Column id="calcscorcd" type="STRING" size="256"/>
          <Column id="calcscornm" type="STRING" size="256"/>
          <Column id="rsrvdt" type="STRING" size="256"/>
          <Column id="logno" type="STRING" size="256"/>
          <Column id="lastupdtdt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="dutplcecd"/>
            <Col id="dutplcenm"/>
            <Col id="dcnt"/>
            <Col id="rsrvrid"/>
            <Col id="rsrvrnm"/>
            <Col id="rcnt"/>
            <Col id="pid"/>
            <Col id="prcpdd"/>
            <Col id="suppdeptcd"/>
            <Col id="suppdeptnm"/>
            <Col id="excuroomcd"/>
            <Col id="excuroomnm"/>
            <Col id="calcscorcd"/>
            <Col id="calcscornm"/>
            <Col id="rsrvdt"/>
            <Col id="logno"/>
            <Col id="lastupdtdt"/>
          </Row>
        </Rows>
      </Dataset>
      <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="dutplcecd" type="STRING" size="256"/>
          <Column id="bscdflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="dutplcecd"/>
            <Col id="bscdflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_deptlist_deptinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="deptcd"/>
            <Col id="deptnm"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item2" compid="cmb_deptcd" propid="value" datasetid="ds_send" columnid="dutplcecd"/>
    </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			: currow : row 인덱스
 * Description		: 색상설정
 ****************************************************************************************/
function fn_setRowStyle() {
	var cnt = ds_main_worklist_workinfo.rowcount;
	if(cnt == 0) return;
	
	var gColor = "";
	for(var currow = 0 ; currow < cnt ; currow++) {
		if(currow == 0) gColor = "#ffffff";
		else {
			var pVal = dsf_getColumnNullToEmpty(ds_main_worklist_workinfo, (currow-1), "rsrvrid");
			var cVal = dsf_getColumnNullToEmpty(ds_main_worklist_workinfo, currow, "rsrvrid");
			
			if(pVal == cVal) gColor = gColor;
			else gColor = (gColor == "#ffffff" ? "#f0f0f0" : "#ffffff");
		}
		dsf_makeValue(ds_main_worklist_workinfo, "bgcolor", "string", gColor, currow);
	}
}

//=======================================================================================
// Event
//---------------------------------------------------------------------------------------
/****************************************************************************************
 * Components		: Form
 * Description		: 화면 처음 초기화시 폼초기화
 ****************************************************************************************/
function SMPEA00101_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	ds_send.setColumn( 0, "fromdd", utlf_getCurrentDate());
	ds_send.setColumn( 0, "todd",   utlf_getCurrentDate());

	ds_init_deptlist_deptinfo.clearData();
	var oParam = {};
		oParam.id          = "TRPEA00107";
		oParam.service     = "pamexcuapp.PamExcu";
		oParam.method      = "reqGetDeptList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_deptlist_deptinfo=dept";
		oParam.async       = false;
		//oParam.callback    = "cf_TRPEA00107";

	tranf_submit(oParam);

	frmf_addComboItem("cmb_deptcd", "전체", "T");
	cmb_deptcd.index = 0;
}

/****************************************************************************************
 * Components		: Button
 * Description		: 조회
 ****************************************************************************************/
function btn_search_onclick(obj:Button, e:ClickEventInfo) {
	ds_main_worklist_workinfo.clearData();
	var oParam = {};
		oParam.id          = "TRPEA00111";
		oParam.service     = "pamexcuapp.PamExcu";
		oParam.method      = "reqGetRsrvWorkStat";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_worklist_workinfo=work";
		oParam.async       = false;
		oParam.callback    = "cf_TRPEA00111";

	tranf_submit(oParam);
}

function cf_TRPEA00111(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    fn_setRowStyle();
}

/****************************************************************************************
 * Components		: Button
 * Description		: 엑셀저장
 ****************************************************************************************/
function btn_excel_onclick(obj:Button, e:ClickEventInfo) {
	var period = ds_send.getColumn(0, "fromdd") + "-" + ds_send.getColumn(0, "todd");
	var filename = "예약자별 통합 검사 예약 현황_" + period;
	if( ds_main_worklist_workinfo.rowcount > 0 ){
		grdf_exportExcel(grd_work, filename, "예약현황", false, "", "user", false);
		sysf_messageBox("엑셀 저장이 완료되었습니다.", "I999");
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}

]]></Script>
  </Form>
</FDL>