YNU_JEUS/app_home/himed/xpapps/com/userdeptinfoxp/xp/SPZSU30000_전공의시간외사용신청내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPZSU300000" position="absolute 0 0 1199 793" titletext="전공의 근무시간외 사용신청 내역" oninit="SPZSU300000_oninit" onload="SPZSU300000_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="전공의 근무시간외 사용신청 내역" class="tit_1" position="absolute 0 0 250 24"/>
        <Div id="div_search" anchor="left top right" taborder="1" class="div_SA" position="absolute 0 24 1195 64" onkeydown="div_search_onkeydown">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 1125 9 1181 31" anchor="top right" onclick="div_search_btn_search_onclick"/>
              <Shape id="line2" linetype="vertical" position="absolute 1112 9 1118 31" anchor="top right"/>
              <Calendar id="cal_fromdd" taborder="0" autoselect="true" autoskip="true" dateformat="yyyy-MM-dd" class="input_essential" position="absolute 64 10 164 30" anchor="default"/>
              <Static id="Static00" text="~" position="absolute 169 10 183 30" style="align:center middle;" anchor="default"/>
              <Calendar id="cal_todd" taborder="1" autoselect="true" dateformat="yyyy-MM-dd" class="input_essential" position="absolute 188 10 288 30" anchor="default"/>
              <Static id="caption3" text="기간 : " onclick="Tab00_tabpage_hie_Div00_caption3_onclick" class="search_name" position="absolute 14 10 69 30" anchor="default"/>
              <Static id="caption11" text="진료과 :" class="search_name" position="absolute 302 12 396 29" anchor="default"/>
              <Static id="caption6" text="진료의사 :" class="search_name" position="absolute 517 12 611 29" anchor="default"/>
              <Static id="caption00" text="연차 : " onclick="Tab00_tabpage_hie_Div00_caption3_onclick" class="search_name" position="absolute 745 10 800 30" anchor="default"/>
              <Edit id="ipt_anual" taborder="4" autoselect="true" class="input_search" position="absolute 793 10 823 29" maxlength="2" anchor="default" inputtype="number"/>
              <Combo id="cmb_orddrid" taborder="6" innerdataset="@ds_init_doct" codecolumn="doctid" datacolumn="doctnm" class="combo_search" position="absolute 591 11 731 30" style="itemheight:15;" columncount="-1" rowcount="-1"/>
              <Combo id="cmb_orddeptcd" taborder="7" position="absolute 363 11 503 30" innerdataset="@ds_init_dept" codecolumn="deptcd" datacolumn="depthngnm" class="combo_search" index="-1" onitemchanged="div_search_cmb_orddeptcd_onitemchanged"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line00" class="line_10" position="absolute 0 88 1195 97" anchor="left top right"/>
        <Grid id="grd_list" class="datagrid2" taborder="2" binddataset="ds_result" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 94 1195 750" anchor="left top right" oncellclick="grd_list_oncellclick" onselectchanged="grd_list_onselectchanged" onmousemove="grd_list_onmousemove" onmouseleave="grd_list_onmouseleave" tooltiptype="hover,mouseleave">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="0"/>
                <Column size="30"/>
                <Column size="105"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="20"/>
                <Column size="100"/>
                <Column size="400"/>
                <Column size="80"/>
                <Column size="40"/>
                <Column size="180"/>
              </Columns>
              <Rows>
                <Row size="20" band="head"/>
                <Row size="20" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="caption1"/>
                <Cell col="1" rowspan="2" style="align:center middle;" text="No." taborder="undefined"/>
                <Cell col="2" rowspan="2" text="진료과" taborder="undefined"/>
                <Cell col="3" rowspan="2" colspan="2" text="전공의" taborder="undefined"/>
                <Cell col="5" rowspan="2" colspan="3" text="신청시간" taborder="undefined"/>
                <Cell col="8" colspan="2" text="추가시간 요청" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="연차" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="비고" taborder="undefined"/>
                <Cell row="1"/>
                <Cell row="1" col="8" text="사 유"/>
                <Cell row="1" col="9" text="시간"/>
              </Band>
              <Band id="body">
                <Cell text="bind:coophospcd"/>
                <Cell col="1" expr="currow + 1"/>
                <Cell col="2" text="bind:orddeptnm"/>
                <Cell col="3" text="bind:orddrid"/>
                <Cell col="4" text="bind:orddrnm"/>
                <Cell col="5" text="bind:fromdt" mask="####.##.## ##:##"/>
                <Cell col="6" text="~"/>
                <Cell col="7" text="bind:todt" mask="####.##.## ##:##"/>
                <Cell col="8" style="align:left middle;padding:0 0 0 5;" text="bind:appresn"/>
                <Cell col="9" text="bind:hours"/>
                <Cell col="10" text="bind:anual"/>
                <Cell col="11" style="align:left middle;padding:0 0 0 5;" text="bind:remark"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption00" text="부서정보" class="tit_2" position="absolute 0 73 80 95"/>
        <Button id="btn_excel" taborder="3" text="엑셀" class="btn7" position="absolute 1140 67 1195 89" anchor="top right" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_reqdata" 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="orddeptcd" type="STRING" size="256"/>
          <Column id="orddrid" type="STRING" size="256"/>
          <Column id="anual" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_dept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_doct" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_result" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_doctor" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item5" compid="div_search.cal_fromdd" propid="value" datasetid="ds_send_reqdata" columnid="fromdd"/>
      <BindItem id="item7" compid="div_search.cal_todd" propid="value" datasetid="ds_send_reqdata" columnid="todd"/>
      <BindItem id="item17" compid="div_search.ipt_anual" propid="value" datasetid="ds_send_reqdata" columnid="anual"/>
      <BindItem id="item1" compid="div_search.cmb_orddeptcd" propid="value" datasetid="ds_send_reqdata" columnid="orddeptcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name			:	
 * Creator			:	
 * Make Date 		:	2020.02.03
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "emr_dentirecxp::MRE001.xjs";

function SPZSU300000_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPZSU300000_onload(obj:Form, e:LoadEventInfo)
{
	fInit();
}

function fInit()
{
	grdf_initGrid(grd_list);
	
	// 진료과 셋팅
	lf_mmbfGetDeptCodeComboList(ds_init_dept, "A");
	grdf_sortNodeList(ds_init_dept, "depthngnm", "asc"); // 가나다 순으로 정리되도록 수정.
	dsf_addDsItem(ds_init_dept, "deptcd", "depthngnm", "- 전 체 -", "", "above");
	div_search.cmb_orddeptcd.index = 0;
	
	// 조회기간 셋팅
	var curDate   = utlf_getCurrentDate();	
	
	ds_send_reqdata.setColumn(0, "fromdd", curDate - 1);
	ds_send_reqdata.setColumn(0, "todd", curDate);
}	



// 조회
function div_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{	
	ds_send_reqdata.setColumn(0, "orddeptcd", div_search.cmb_orddeptcd.value);
	ds_send_reqdata.setColumn(0, "orddrid", div_search.cmb_orddrid.value);
	
	if(fChkSearchCond()){
		ds_result.clearData();
	
		var oParam = {};
			oParam.id          = "TRZSU30001";
			oParam.service     = "userdeptinfoapp.UserDeptInfo";
			oParam.method      = "reqGetResiOvtLoginInfo";
			oParam.inds        = "req=ds_send_reqdata";
			oParam.outds	   = "ds_result=result";
			oParam.async       = false;
			oParam.callback    = "cf_TRZSU30001";

		tranf_submit(oParam);	
	}	
}


function cf_TRZSU30001(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) 
    {
		// 에러처리
		return;
	}
    else
    {
    }
}

function fChkSearchCond()
{
	var fromdd = ds_send_reqdata.getColumn(0, "fromdd");
	var todd = ds_send_reqdata.getColumn(0, "todd");
	
	if(fromdd > todd)
	{
		sysf_messageBox("조회기간을 ", "I007");	// 확인하십시오.
		div_search.cal_fromdd.setFocus();
		return false;
	}
	
	return true;
}


function div_search_onkeydown(obj:Div, e:KeyEventInfo)
{
	if (e.keycode == 13) {
		ds_send_reqdata.setColumn(0, "anual", div_search.ipt_anual.value);
		div_search_btn_search_onclick();
	}
}

// 진료과 선택시 진료의사 목록 셋팅
function div_search_cmb_orddeptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var orddd = ds_send_reqdata.getColumn(0, "fromdd");
	var orddeptcd = ds_send_reqdata.getColumn(0, "orddeptcd");
	
	fDoctSearch(ds_init_doct, orddd, orddeptcd);
}


// 진료과별 의사목록 조회
function fDoctSearch(dsObj, orddd, orddeptcd)
{
	//  진료의사
	dsObj.clearData(); 
	//ds_init_doct.addRow();
	
	ds_send_doctor.clearData();	
	dsf_makeValue( ds_send_doctor, "orddd", "string", orddd );		
	dsf_makeValue( ds_send_doctor, "orddeptcd", "string",  orddeptcd);

	var oParam = {};
    oParam.id          = "TRARC01302";
    oParam.service     = "healcarecoopapp.ReqAgnMngt";
    oParam.method      = "reqGetDoctList";
    oParam.inds        = "req=ds_send_doctor";
    oParam.outds       = "ds_init_doct=medispcl";
    oParam.async       = false;
    oParam.callback    = "cf_TRARC01302";

	tranf_submit(oParam);
	//div_search.cmb_orddrid.index = 0;
}

function cf_TRARC01302(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) 
    {
		// 에러처리
		return;
	}
    else
    {
		trace(ds_init_doct.saveXML());
		div_search.cmb_orddrid.index = 0;
		trace("index : " + div_search.cmb_orddrid.index + " , value : " + div_search.cmb_orddrid.value);
		trace(ds_send_reqdata.saveXML());
    }
}

// 엑셀 저장
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	fExcel();
}

function fExcel() 
{
	if (ds_result.rowcount == 0)
	{
		sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
		return;
	}
	
	var title = "전공의 근무시간외 사용신청 내역";
	var sheetNm = "전공의 근무시간외 사용신청 내역";

	grdf_exportExcel(grd_list, title, sheetNm);
}

// 그리드 Tooltip 처리
function grd_list_onmousemove(obj:Grid, e:GridMouseEventInfo)
{	
	if(e.row >= 0 && (e.col == 8 || e.col == 11)){
		// 실제 Cell Size보다 Text가 더 길경우 처리를 위한 로직
		if(e.col == 8){
			var text = ds_result.getColumn(e.row, "appresn");
		}else{
			var text = ds_result.getColumn(e.row, "remark");
		}
		
		var ctrlObj = grd_list;
		var font = ctrlObj.getCellProperty("body", e.col, "font");
		if(utlf_isNull(font)) font = "Dotum,9";
	
		var fontStyle = font.toString().split(',');
		var bold = false;
		if(fontStyle.length > 2 && fontStyle[2] == "bold") bold = true;
		
		var objFont = utlf_getObjFont(fontStyle[1], fontStyle[0], bold);	// 실제 폰트의 너비
		var objFontSize = utlf_getTextSize(text, objFont);
		
		var paddingSize = 0;
		var padding = ctrlObj.getCellProperty("body", e.col, "padding");
		if(!utlf_isNull(padding) && padding.length == 4) {
			paddingSize = padding[1] + padding[3];
		}
	
		var arrCellRect = ctrlObj.getCellRect(0, e.col);
		var width = arrCellRect.width - paddingSize - ctrlObj.vscrollbar.position.width + 12;		// 실제 글자가 들어갈 수 있는 영역 너비(width - padding 좌우영역 - 세로 스크롤 넓이 + 10은 보정값)
		
		if(e.col != 8 && e.col != 11){
			obj.tooltiptext = "";
		} else {
			if(objFontSize.cx > width) {
				obj.tooltiptext = text;
			}else{
				obj.tooltiptext = "";
			}
		}
	} else {
		obj.tooltiptext = "";
	}
}

function grd_list_onmouseleave(obj:Grid, e:MouseEventInfo)
{
	obj.tooltiptext = "";
}

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