YNU_JEUS/app_home/himed/xpapps/ast/examcurexp/xp/SMAEA00300_개인별예약현황조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAEA00300" position="absolute 0 0 1256 805" titletext="개인별 예약현황 조회" oninit="model1_oninit" onload="SMAEA00300_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" class="tit_1" position="absolute 0 3 172 28" anchor="default" positiontype="position" text="개인별 예약현황 조회"/>
        <Grid id="grd_rsrvprescond" position="absolute 0 97 938 782" anchor="default" positiontype="position" binddataset="ds_grd_rsrvprescond" extendsizetype="none" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20"/>
                <Column size="111"/>
                <Column size="89"/>
                <Column size="249"/>
                <Column size="70"/>
                <Column size="85"/>
                <Column size="107"/>
                <Column size="85"/>
                <Column size="63"/>
                <Column size="123"/>
                <Column size="84"/>
                <Column size="77"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="22" 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="caption1"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" style="align:center middle;" text="bind:rsrvdt" mask="####-##-## ##:##"/>
                <Cell col="2" style="align:left middle;" text="bind:prcpcd"/>
                <Cell col="3" style="align:left middle;" text="bind:prcpnm"/>
                <Cell col="4" displaytype="combo" edittype="combo" text="bind:prcpstatcd" combodataset="ds_init_Z_M0011" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="5" style="align:center middle;" text="bind:prcpdd" mask="####-##-##"/>
                <Cell col="6" style="align:center middle;" text="bind:execdt" mask="expr:execdt == null ? '':'####-##-## ##:##'"/>
                <Cell col="7" style="align:left middle;" text="bind:orddeptnm"/>
                <Cell col="8" style="align:left middle;" text="bind:orddrnm"/>
                <Cell col="9" style="align:left middle;" text="bind:excuroomnm"/>
                <Cell col="10" text="bind:execrid"/>
                <Cell col="11" style="align:left middle;" text="bind:usernm"/>
                <Cell col="12" text="bind:hngnm"/>
                <Cell col="13"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button3" class="btn7" position="absolute 1180 74 1256 94" anchor="default" positiontype="position" text="엑셀저장" onlbuttonup="button3_onlbuttonup" onclick="button3_onclick"/>
        <Grid id="grd_ordprescond" position="absolute 948 97 1256 782" anchor="default" positiontype="position" binddataset="ds_grd_ordprescond" autofittype="col" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20"/>
                <Column size="110"/>
                <Column size="80"/>
                <Column size="80"/>
              </Columns>
              <Rows>
                <Row size="22" band="head"/>
                <Row size="20"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="진료일자"/>
                <Cell col="2" text="진료과"/>
                <Cell col="3" text="진료의"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" style="align:left middle;" text="bind:rsrvdt" mask="####-##-## ##:##"/>
                <Cell col="2" style="align:left middle;" text="bind:orddepthngnm"/>
                <Cell col="3" style="align:left middle;" text="bind:orddrnm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption2" class="tit_2" position="absolute 0 77 97 97" anchor="default" positiontype="position" text="예약현황"/>
        <Static id="caption3" class="tit_2" position="absolute 948 77 1045 97" anchor="default" positiontype="position" text="진료현황"/>
        <Button id="btn_cls" class="btn4" position="absolute 1200 785 1256 805" anchor="default" positiontype="position" text="닫기" onclick="btn_cls_onclick"/>
        <Div id="grp_sea" anchor="left top right" taborder="6" style="align:center top;" class="div_SA" position="absolute 0 29 1256 68" align="align:center top;" positiontype="position" onmouseenter="grp_sea_onmouseenter">
          <Layouts>
            <Layout>
              <Static id="caption1" text="적용일자" class="search_name" position="absolute 332 10 406 30" anchor="default" positiontype="position"/>
              <Button id="btn_sea" taborder="20" text="조회" onlbuttonup="btn_sea_onlbuttonup" class="btn1" position="absolute 1189 10 1245 30" anchor="top right" onclick="btn_sea_onclick" positiontype="position"/>
              <Calendar id="ipt_endrsrvdd" taborder="22" class="input_default" position="absolute 495 10 581 30" anchor="default" align="align:center middle;" positiontype="position"/>
              <Calendar id="ipt_startrsrvdd" taborder="25" class="input_default" position="absolute 406 10 492 30" onmouseenter="ipt_startrsrvdd_onmouseenter" anchor="default" align="align:center middle;" positiontype="position"/>
              <Edit id="opt_pathngnm" taborder="28" readonly="true" position="absolute 213 10 313 30" anchor="default" onkeydown="grp_sea_opt_pathngnm_onkeydown" positiontype="position"/>
              <Static id="caption13" text="등록번호 :" class="search_name" position="absolute 20 11 106 28" anchor="default"/>
              <Edit id="ipt_pid" taborder="29" position="absolute 109 10 189 29" anchor="default" onkeydown="grp_sea_ipt_pid_onkeydown"/>
              <Button id="btn_ptbs_search" taborder="30" class="icon_search" position="absolute 192 11 208 27" anchor="default" onclick="grp_sea_btn_ptbs_search_onclick"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_grd_rsrvprescond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rsrvdt" type="STRING"/>
          <Column id="prcpcd" type="STRING"/>
          <Column id="prcpnm" type="STRING"/>
          <Column id="prcpstatcd" type="STRING"/>
          <Column id="prcpdd" type="STRING"/>
          <Column id="execdt" type="STRING"/>
          <Column id="orddeptnm" type="STRING"/>
          <Column id="orddrnm" type="STRING"/>
          <Column id="excuroomnm" type="STRING"/>
          <Column id="execrid" type="STRING"/>
          <Column id="usernm" type="STRING"/>
          <Column id="hngnm" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grd_ordprescond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="rsrvdt"/>
          <Column id="orddepthngnm"/>
          <Column id="orddrnm"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_Z_M0011" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdnm" type="STRING" size="255"/>
          <Column id="cdval" type="STRING" size="255"/>
          <Column id="minopercd" type="STRING" size="255"/>
          <Column id="cdgrupid" type="STRING" size="255"/>
          <Column id="valitodd" type="STRING" size="255"/>
          <Column id="detldesc" type="STRING" size="255"/>
          <Column id="lastupdtrid" type="STRING" size="255"/>
          <Column id="fstrgstdt" type="STRING" size="255"/>
          <Column id="cdsid" type="STRING" size="255"/>
          <Column id="cdengabbrnm" type="STRING" size="255"/>
          <Column id="minval" type="STRING" size="255"/>
          <Column id="fstrgstrid" type="STRING" size="255"/>
          <Column id="lastupdtdt" type="STRING" size="255"/>
          <Column id="valifromdd" type="STRING" size="255"/>
          <Column id="maxopercd" type="STRING" size="255"/>
          <Column id="cdid" type="STRING" size="255"/>
          <Column id="dispseq" type="BIGDECIMAL" size="255"/>
          <Column id="maxval" type="STRING" size="255"/>
          <Column id="bizflag" type="STRING" size="255"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="srchpid"/>
          <Column id="basesuppdeptcd"/>
          <Column id="frdt"/>
          <Column id="todt"/>
          <Column id="instcd"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchpid"/>
            <Col id="basesuppdeptcd"/>
            <Col id="frdt"/>
            <Col id="todt"/>
            <Col id="instcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp_paminfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_patinfolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item4" compid="grp_sea.ipt_pid" propid="value" datasetid="ds_send" columnid="srchpid"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * File Name 		:	SMAEA00300_개인별예약현황조회.xfdl
 * Creator 	    :	
 *                                                                                        
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	Modify Description                                     
 *--------------------------------------------------------------------------------------- 
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/


//=======================================================================================
// xjs Include
//---------------------------------------------------------------------------------------
include "com_commonxp::comm_main.xjs";
include "ast_examcurexp::AEZ0001.xjs";
include "com_basiccodexp::ZBC001.xjs";


//=======================================================================================
// Function 
//---------------------------------------------------------------------------------------

function fInit()
{
	lf_aezfSetSuppDeptcd();
	ds_send.setColumn(0, "basesuppdeptcd", suppdeptcd);
	// 공통 코드 셋팅
	
	appf_getCodeList([{dsNm: "ds_init_Z_M0011", cdGrpId: "M0011"}], true);
	// 조회기간 셋팅
	var cDate = utlf_getCurrentDate();
	grp_sea.ipt_endrsrvdd.value = cDate;
	grp_sea.ipt_startrsrvdd.value = utlf_addMonth(cDate, -12);
	grdf_initGrid(grd_rsrvprescond);
	grp_sea.ipt_pid.setFocus();
	
	// 통합 예약에서 전달받은 pid 확인
	var pid = opener.frmf_getParameter("SMPEA00100_pid");
	
	if (!utlf_isNull(pid)) {
		ds_send.setColumn(0, "srchpid", pid);
	} else if(!utlf_isNull(getOwnerFrame().sArg01)&& getOwnerFrame().sArg01!=""){
		ds_send.setColumn(0,"srchpid",sArg01);
		grp_sea.ipt_pid.value = sArg01;
		
		grp_sea.opt_pathngnm.value = sArg02;
	}
	
	var srchpid = grp_sea.ipt_pid.value
	if( !utlf_isNull(srchpid) && srchpid != "000000000" )
	{
		fSearch();
	}
	else
	{
		var paminfo = sysf_getGlobalVariable("paminfo");	//프로그램에 따라 원무정보(paminfo), 환자기본정보(patflag) get
		var gv_pid = sysf_getGlobalVariable("gv_pid", "A");
		
		if( !utlf_isNull(paminfo) ) //원무 정보(기본 정보)가 있는 경우
		{
			dsf_setCSVToDs("ds_temp_paminfo",paminfo);
			var pid = ds_temp_paminfo.getColumn(0, "pid");
			ds_send.setColumn(0, "srchpid", pid);
			grp_sea.ipt_pid.value = pid;
			
			fSearch();
		}
		
		
		else if( !utlf_isNull(gv_pid) ) //글로벌변수(등록번호)가 있는경우
		{
			ds_send.setColumn(0, "srchpid", gv_pid);
			grp_sea.ipt_pid.value = gv_pid;
			
			fSearch();
		}
	}	
}


function fSearch()
{
	var pid = ds_send.getColumn(0, "srchpid");
	
	var frdt = grp_sea.ipt_startrsrvdd.value;
	var todt = grp_sea.ipt_endrsrvdd.value;
	
	ds_send.setColumn(0, "srchpid", pid);
	ds_send.setColumn(0, "frdt", frdt);
	ds_send.setColumn(0, "todt", todt);
	
	if( utlf_isNull(grp_sea.ipt_pid.value) )
	{
		sysf_messageBox("필수입력사항인 등록번호를 입력해 주십시오.", "I999");
		grp_sea.ipt_pid.setFocus();
	}
	else if( utlf_isNull(frdt) && !utlf_isNull(todt) )
	{
		sysf_messageBox("검색하실 날짜 범위의 시작일자를 입력해 주십시오." , "I999");
		grp_sea.ipt_startrsrvdd.setFocus();
	}
	else if( !utlf_isNull(frdt) && utlf_isNull(todt) )
	{
		sysf_messageBox("검색하실 날짜 범위의 마지막 일자를 입력해 주십시오." , "I999");
		grp_sea.ipt_endrsrvdd.setFocus();
	}
	else if ( utlf_getDateInterval(frdt, todt) < 0 )
	{
		sysf_messageBox("입력하신 날짜 범위로는 검색할 수 없습니다. 입력하신 날짜를 확인해 주십시오." , "I999");
		grp_sea.ipt_startrsrvdd.setFocus();
	}
	else
	{
		submit_TRAEA00301();
		submit_TRAEA00302();
		
		if( ds_grd_rsrvprescond.rowcount == 0 && ds_grd_ordprescond.rowcount == 0 )
		{
			sysf_messageBox("입력하신 등록번호/일자에 해당하는 환자의 예약 및 진료 정보가 DB에 존재하지 않습니다.", "I999");
		}
		else
		{
			var _dt = "";
			var hngnm = ds_grd_rsrvprescond.getColumn(0, "hngnm");
			grp_sea.opt_pathngnm.value = hngnm;
		}
	}	
}

function submit_TRAEA00301()
{
	var objParam = new Object();
	objParam.id = "TRAEA00301";
	objParam.service = "examcureacptexecapp.ExamCurePrcs";
	objParam.method = "reqGetPidRsrvPresCondList";
	objParam.inds = "req=ds_send";
	objParam.outds ="ds_grd_rsrvprescond=rsrvlist";
	

	tranf_submit(objParam);
}

function submit_TRAEA00302()
{
	var objParam = new Object();
	objParam.id = "TRAEA00302";
	objParam.service = "examcureacptexecapp.ExamCurePrcs";
	objParam.method = "reqGetPidOrdPresCondList";
	objParam.inds = "req=ds_send";
	objParam.outds ="ds_grd_ordprescond=ordlist";
	

	tranf_submit(objParam);
}

function temp(obj:Edit, e:KeyEventInfo)
{
	if( e.keycode == 13 )
	{
		fSearch();
	}
}

function pid_keyDown(obj:Edit, e:KeyEventInfo)
{
	if( e.keycode == 13 )
	{
		if( utlf_isNull(grp_sea.ipt_pid.value) )
		{
			grp_sea.opt_pathngnm.value = "";
		}
		else
		{
			fSearch();
		}
	}
}

function pid_text(obj:Edit,  e:TextChangedEventInfo)
{
	if( obj.value == "" )
	{
		grp_sea.opt_pathngnm.value = "";
		grp_sea.ipt_pid.value = "";
	}
}
//=======================================================================================
// Event
//---------------------------------------------------------------------------------------

/****************************************************************************************
 * Components	    : 
 * Components ID  : SMAEA00300
 * Event 		    : onload
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function SMAEA00300_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);  // 화면공통
	
	fInit();			
	//grp_sea.ipt_pid.onkeyup.addHandler(temp);
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : btn_sea
 * Event 		    : onclick
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 조회버튼
 ****************************************************************************************/
function btn_sea_onclick(obj:Button, e:ClickEventInfo)
{
	fSearch();									
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : button3
 * Event 		    : onclick
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 엑셀저장
 ****************************************************************************************/
function button3_onclick(obj:Button, e:ClickEventInfo)
{

	if( ds_grd_rsrvprescond.rowcount <= 0 && ds_grd_ordprescond.rowcount <= 0 )
	{
		sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
		return;
	}
	else
	{
		grdf_exportExcel(grd_rsrvprescond, "예약현황", "Sheet");
		grdf_exportExcel(grd_ordprescond, "진료현황", "Sheet");
	}					
}

// 닫기 버튼
function btn_cls_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}



function grp_sea_btn_ptbs_search_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_createDsRow("ds_send_srchpid", [{col: "srchpid", 	val:utlf_transNullToEmpty(grp_sea.ipt_pid.value)} 										
 										 ]);
	var objArg = new Object();
	objArg.arg_ds_send = ds_send_srchpid;
	
	// 환자조회화면 호출
	frmf_modal("SPPMC02500", "SPPMC02500", objArg, "", "", "", "", "", "", "", "", "", "M");
	
	grp_sea.ipt_pid.value = ds_patinfolist.getColumn(0,"pid");
	grp_sea.opt_pathngnm.value = ds_patinfolist.getColumn(0,"hngnm");
}

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

function grp_sea_opt_pathngnm_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		dsf_createDsRow("ds_send_srchpid", [{col: "srchpid", 	val:utlf_transNullToEmpty(grp_sea.ipt_pid.value)} 										
											 ]);
		var objArg = new Object();
		objArg.arg_ds_send = ds_send_srchpid;
		
		// 환자조회화면 호출
		frmf_modal("SPPMC02500", "SPPMC02500", objArg, "", "", "", "", "", "", "", "", "", "M");
		
		grp_sea.ipt_pid.value = ds_patinfolist.getColumn(0,"pid");
		grp_sea.ipt_patnm.value = ds_patinfolist.getColumn(0,"hngnm");
	}
}
]]></Script>
  </Form>
</FDL>