YNU_JEUS/app_home/himed/xpapps/ast/examcurestatsxp/xp/SMAES01900_영상의학년도대비실적통계.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMAES01900" position="absolute 0 0 1197 773" titletext="년도대비실적통계" oninit="SMAES01900_oninit" onload="SMAES01900_onload">
    <Layouts>
      <Layout>
        <Static id="caption1" text="년도대비실적통계" class="tit_2" position="absolute 0 79 135 96"/>
        <Shape id="line1" linetype="horizontal" class="line_1" position="absolute 0 95 1195 101" anchor="left top right"/>
        <Button id="btn_excsave" taborder="1" text="엑셀저장" class="btn7" position="absolute 1115 71 1194 93" anchor="top right" onclick="btn_excsave_onclick"/>
        <Grid id="grd_list" taborder="2" binddataset="ds_main_list" useinputpanel="false" position="absolute 0 100 1195 770" autofittype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="25" band="left"/>
                <Column size="248"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="82"/>
                <Column size="82"/>
                <Column size="82"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
                <Row size="24" band="summ"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="구분" taborder="undefined"/>
                <Cell col="2" text="2006년"/>
                <Cell col="3" text="2006년"/>
                <Cell col="4" text="2006년"/>
                <Cell col="5" text="2006년"/>
                <Cell col="6" text="2006년"/>
                <Cell col="7" text="2006년"/>
                <Cell col="8" text="2006년"/>
                <Cell col="9" text="2006년"/>
                <Cell col="10" text="2006년"/>
                <Cell col="11" text="2006년"/>
                <Cell col="12" text="2007년"/>
                <Cell col="13" text="2007년"/>
                <Cell col="14" rowspan="2" text="당해년도합계" taborder="undefined"/>
                <Cell col="15" rowspan="2" text="전년도합계" taborder="undefined"/>
                <Cell col="16" rowspan="2" text="증감(%)" taborder="undefined"/>
                <Cell row="1" col="2" text="3월"/>
                <Cell row="1" col="3" text="4월"/>
                <Cell row="1" col="4" text="5월"/>
                <Cell row="1" col="5" text="6월"/>
                <Cell row="1" col="6" text="7월"/>
                <Cell row="1" col="7" text="8월"/>
                <Cell row="1" col="8" text="9월"/>
                <Cell row="1" col="9" text="10월"/>
                <Cell row="1" col="10" text="11월"/>
                <Cell row="1" col="11" text="12월"/>
                <Cell row="1" col="12" text="1월"/>
                <Cell row="1" col="13" text="2월"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:currow + 1" autosizecol="none"/>
                <Cell col="1" text="bind:basecdnm" suppress="1"/>
                <Cell col="2" displaytype="number" text="bind:month1"/>
                <Cell col="3" displaytype="number" text="bind:month2"/>
                <Cell col="4" displaytype="number" text="bind:month3"/>
                <Cell col="5" displaytype="number" text="bind:month4"/>
                <Cell col="6" displaytype="number" text="bind:month5"/>
                <Cell col="7" displaytype="number" text="bind:month6"/>
                <Cell col="8" displaytype="number" text="bind:month7"/>
                <Cell col="9" displaytype="number" text="bind:month8"/>
                <Cell col="10" displaytype="number" text="bind:month9"/>
                <Cell col="11" displaytype="number" text="bind:month10"/>
                <Cell col="12" displaytype="number" text="bind:month11"/>
                <Cell col="13" displaytype="number" text="bind:month12"/>
                <Cell col="14" displaytype="number" text="bind:prestyearsum"/>
                <Cell col="15" displaytype="number" text="bind:bfyearsum"/>
                <Cell col="16" displaytype="number" text="bind:variation"/>
              </Band>
              <Band id="summary">
                <Cell/>
                <Cell col="1" text="합    계"/>
                <Cell col="2" displaytype="number"/>
                <Cell col="3" displaytype="number"/>
                <Cell col="4" displaytype="number"/>
                <Cell col="5" displaytype="number"/>
                <Cell col="6" displaytype="number"/>
                <Cell col="7" displaytype="number"/>
                <Cell col="8" displaytype="number"/>
                <Cell col="9" displaytype="number"/>
                <Cell col="10" displaytype="number"/>
                <Cell col="11" displaytype="number"/>
                <Cell col="12" displaytype="number"/>
                <Cell col="13" displaytype="number"/>
                <Cell col="14" displaytype="number" text="expr:getSum(&quot;prestyearsum&quot;)"/>
                <Cell col="15" displaytype="number" text="expr:getSum(&quot;bfyearsum&quot;)"/>
                <Cell col="16" displaytype="number"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Div id="group1" taborder="3" class="div_SA" position="absolute 0 25 1195 65" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1107 11 1113 31" anchor="top right"/>
              <Button id="button1" taborder="3" text="조회" class="btn1" position="absolute 1120 10 1176 32" anchor="top right" onclick="group1_button1_onclick"/>
              <Static id="caption2" text="조회기간 :" class="search_name" position="absolute 15 13 86 30" anchor="default"/>
              <Static id="caption3" text="비교기간 :" class="search_name" position="absolute 349 13 420 30" anchor="default"/>
              <Radio id="rdo_ioflag" taborder="8" columncount="4" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 755 12 1072 28" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn"/>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">I</Col>
                      <Col id="datacolumn">영상</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">S</Col>
                      <Col id="datacolumn">건진</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">C</Col>
                      <Col id="datacolumn">어린이병원</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption7" text="구분 :" class="search_name" position="absolute 706 13 751 30" anchor="default"/>
              <cp_monthCal id="ipt_fromdd" titletext="monthCalendar" taborder="9" text="cp_monthCal00" scrollbars="none" position="absolute 91 11 191 31"/>
              <Static id="caption5" text="~" class="search_no_b" position="absolute 197 13 209 30"/>
              <cp_monthCal id="ipt_todd" titletext="monthCalendar" taborder="10" text="cp_monthCal00" scrollbars="none" position="absolute 211 11 311 31"/>
              <cp_monthCal id="input2" titletext="monthCalendar" taborder="11" text="cp_monthCal00" scrollbars="none" enable="false" position="absolute 426 11 526 31"/>
              <Static id="caption4" text="~" class="search_no_b" position="absolute 532 12 544 29"/>
              <cp_monthCal id="input1" titletext="monthCalendar" taborder="12" text="cp_monthCal00" scrollbars="none" enable="false" position="absolute 546 11 646 31"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption6" text="년도대비실적통계" class="tit_1" position="absolute 0 0 200 25"/>
        <Shape id="line00" class="line_1" position="absolute 0 94 1195 100" anchor="left top right"/>
        <Shape id="line02" class="line_1" position="absolute 0 96 1195 102" anchor="left top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="basecdnm" type="STRING"/>
          <Column id="month1" type="STRING"/>
          <Column id="month2" type="STRING"/>
          <Column id="month3" type="STRING"/>
          <Column id="month4" type="STRING"/>
          <Column id="month5" type="STRING"/>
          <Column id="month6" type="STRING"/>
          <Column id="month7" type="STRING"/>
          <Column id="month8" type="STRING"/>
          <Column id="month9" type="STRING"/>
          <Column id="month10" type="STRING"/>
          <Column id="month11" type="STRING"/>
          <Column id="month12" type="STRING"/>
          <Column id="prestyearsum" type="STRING"/>
          <Column id="bfyearsum" type="STRING"/>
          <Column id="variation" type="STRING"/>
        </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="execfromdd" type="STRING" size="256"/>
          <Column id="exectodd" type="STRING" size="256"/>
          <Column id="comparefromdd" type="STRING" size="256"/>
          <Column id="comparetodd" type="STRING" size="256"/>
          <Column id="orddeptcd" type="STRING" size="256"/>
          <Column id="orddrid" type="STRING" size="256"/>
          <Column id="execdeptcd" type="STRING" size="256"/>
          <Column id="execdrid" type="STRING" size="256"/>
          <Column id="instance1" type="STRING" size="256"/>
          <Column id="suppdeptcd" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="execfromdd"/>
            <Col id="exectodd"/>
            <Col id="comparefromdd"/>
            <Col id="comparetodd"/>
            <Col id="orddeptcd"/>
            <Col id="orddrid"/>
            <Col id="execdeptcd"/>
            <Col id="execdrid"/>
            <Col id="instance1"/>
            <Col id="suppdeptcd"/>
            <Col id="ioflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_globalinstance" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instance1" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group1.rdo_ioflag" propid="value" datasetid="ds_send" columnid="ioflag"/>
    </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 "com_basiccodexp::ZBC001.xjs";
include "ast_examcurexp::AEZ0001.xjs";

var arErrorCode = new HashArray();
/******************************************************************
 * Argument          : 
 * Description       : 초기화
 ******************************************************************/
function SMAES01900_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMAES01900_onload(obj:Form, e:LoadEventInfo)
{
	lf_aezfSetSuppDeptcd();
	ds_send_globalinstance.setColumn(0, "instance1", frmf_getParameter("AST_DEPTCD"));
					
	var fromdd = utlf_getCurrentDate().substr(0, 4) + "01";
	var todd = utlf_getCurrentDate();
	var comparefromdd = utlf_getCurrentDate().substr(0,4).toDate().getAddDate(0,"Y").getDateFormat("YYYY") +  "01";
	var comparetodd = comparefromdd.substr(0,4) + todd.substr(4,2);
	
	ds_send.setColumn(0, "suppdeptcd", ds_send_globalinstance.getColumn(0, "instance1"));
	ds_send.setColumn(0, "execfromdd", fromdd);
	ds_send.setColumn(0, "exectodd", todd);
	ds_send.setColumn(0, "comparefromdd",comparefromdd);
	ds_send.setColumn(0, "comparetodd",comparetodd);
	ds_send.setColumn(0, "ioflag","");

	ds_main_list.clearData();
	
	//조회기간 달력 set
	group1.ipt_fromdd.setData(fromdd);
	group1.ipt_todd.setData(todd);
	
	//비교기간 달력 set
	group1.input2.setData(comparefromdd);
	group1.input1.setData(comparetodd);
	
	//조회기간 event
	group1.ipt_fromdd.setCallEvent("fn_Cal");
	group1.ipt_todd.setCallEvent("fn_toCal");
	
	//비교기간 event
	group1.input2.setCallEvent("fn_compareCal");
	group1.input1.setCallEvent("fn_compareToCal");
	
	setTitle();
}

/******************************************************************
 * Argument          : 
 * Description       : 조회기간(fromdd) event
 ******************************************************************/
function fn_Cal(){
	var execfromdd = group1.ipt_fromdd.getData();
	var exectodd = group1.ipt_todd.getData();
	var execFrom = (execfromdd + "01").toDate();
	var execTo = (exectodd + "01").toDate();
	var setExecFromdd = "";
	var setCompareFromdd = "";
	
	if( execFrom > execTo ){
		sysf_messageBox("시작일이 종료일보다 클 수 없습니다.", "I");
		group1.ipt_fromdd.setFocus();
		return;
	}
	
	if( execFrom < execTo.getAddDate(-11, "M") ) 
	{
		sysf_messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
		execFrom = execTo;
	}
	
	setExecFromdd = execFrom.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "execfromdd", setExecFromdd);
	group1.ipt_fromdd.setData(setExecFromdd);
	
	setCompareFromdd = execFrom.getAddDate(-12, "M");
	setCompareFromdd = setCompareFromdd.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "comparefromdd", setCompareFromdd);
	group1.input2.setData(setCompareFromdd);

	
	setTitle();
}

/******************************************************************
 * Argument          : 
 * Description       : 조회기간(todd) event
 ******************************************************************/
function fn_toCal(){
	var execfromdd = group1.ipt_fromdd.getData();
	var exectodd = group1.ipt_todd.getData();
	var execFrom = (execfromdd + "01").toDate();
	var execTo = (exectodd + "01").toDate();
	var setExecTodd = "";
	var setCompareTodd = "";
	
	if( execfromdd > exectodd ){
		sysf_messageBox("종료일이 시작일보다 작을 수 없습니다..", "I");
		group1.ipt_todd.setFocus();
		return;
	}
	
	if( execFrom.getAddDate(11, "M") < execTo ) 
	{
		sysf_messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
		execTo = execFrom;
	}
	
	setExecTodd = execTo.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "execfromdd", setExecTodd);
	group1.ipt_todd.setData(setExecTodd);
	
	setCompareTodd = execTo.getAddDate(-12, "M");
	setCompareTodd = setCompareTodd.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "comparefromdd", setCompareTodd);
	group1.input1.setData(setCompareTodd);
	
	setTitle();
}

/******************************************************************
 * Argument          : 
 * Description       : 비교기간(fromdd) event
 ******************************************************************/
function fn_compareCal(){
	var comparefromdd = group1.input2.getData();
	var comparetodd = group1.input1.getData();
	var cFromdd = (omparefromdd + "01").toDate();
	var cTodd = (comparetodd + "01").toDate();
	var setCompareFromdd = "";
	var setExecFromdd = "";
	
	if( cFromdd < cTodd.getAddDate(-11, "M") ) 
	{
		sysf_messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
		cFromdd = cTodd;
	}
	
	setCompareFromdd = cFromdd.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "execfromdd", setCompareFromdd);
	group1.input2.setData(setCompareFromdd);
	
	setExecFromdd = execTo.getAddDate(-12, "M");
	setExecFromdd = setExecFromdd.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "comparefromdd", setExecFromdd);
	group1.input1.setData(setExecFromdd);
	
	setTitle();
}

/******************************************************************
 * Argument          : 
 * Description       : 비교기간(todd) event
 ******************************************************************/
function fn_compareToCal(){
	var comparefromdd = group1.input2.getData();
	var comparetodd = group1.input1.getData();
	var cFromdd = (omparefromdd + "01").toDate();
	var cTodd = (comparetodd + "01").toDate();
	var setCompareTodd = "";
	var setExecTodd = "";
	
	if( cFromdd.getAddDate(-11, "M") < cTodd ) 
	{
		sysf_messageBox("1년이상의 자료는 검색할수 없습니다.", "I");
		cTodd = cFromdd;
	}
	
	setCompareTodd = cTodd.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "execfromdd", setCompareTodd);
	group1.input2.setData(setCompareTodd);
	
	setExecTodd = cTodd.getAddDate(-12, "M");
	setExecTodd = setExecTodd.getDateFormat("YYYYMM");
	ds_send.setColumn(0, "comparefromdd", setExecTodd);
	group1.input1.setData(setExecTodd);
	
	setTitle();
}

/******************************************************************
 * Argument          : 
 * Description       : setTitle
 ******************************************************************/
function setTitle() {
						
	ds_main_list.clearData();
	
	// 그리드 초기화
	var mergeCol = grd_list.getCellCount("Head");
	if( mergeCol != 28 ){
		mergeCol = 29 - mergeCol;
		grd_list.splitContentsCell("Head", 0, 3, 0, mergeCol, true);
		
		for( var j = mergeCol+2; j <= 13; j++ ){
			grd_list.setFormatColProperty(j, "size", 62);
		}
	}
	
	var stYearMonth = group1.ipt_fromdd.getData() + "01";
	var dtYearMonth = stYearMonth.toDate();
	
	var stEndMonth = group1.ipt_todd.getData() + "01";
	var dtEndMonth = stEndMonth.toDate();;

	var fromYear = dtYearMonth.getDateFormat("YYYY");
	var toYear = dtEndMonth.getDateFormat("YYYY");

	var colIdx = 17;
	var colNum = 2;
	
	for( var i = 0; i < 12; i++ ){
		var stYear = dtYearMonth.getDateFormat("YYYY");
		var stMonth = dtYearMonth.getDateFormat("MM");
		
		if( dtYearMonth.getDateFormat("YYYYMM") <= dtEndMonth.getDateFormat("YYYYMM") ){
			grd_list.setCellProperty("Head", i+2, "text", stYear + "년");
			grd_list.setCellProperty("Head", colIdx, "text", stMonth + "월");
		} else {
			grd_list.setFormatColProperty(colNum, "size", 0);
		}
		
		colIdx = colIdx + 1;
		colNum = colNum + 1;
		dtYearMonth.getAddDate(1, "M");
	}

	var stNum = 0;
	var dtNum = 0;
	var lastCol = 0;
	if( fromYear == toYear ){
		stNum = utlf_diffMonth(stYearMonth, stEndMonth) + 2;
		grd_list.mergeContentsCell("Head" , 0, 2, 0, stNum, 2, false);
	} else {
		stNum = utlf_diffMonth(stYearMonth, fromYear+"1201") + 3 ;
		dtNum = utlf_diffMonth(toYear+"0101", stEndMonth);
		lastCol = stNum + dtNum;
		
		grd_list.mergeContentsCell("Head" , 0, stNum, 0, lastCol, stNum, false);
		grd_list.mergeContentsCell("Head" , 0, 2, 0, stNum - 1, 2, false);
	}
}

/******************************************************************
 * Argument          : 
 * Description       : 조회 button event
 ******************************************************************/
function group1_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	frmf_openLoadingBar("영상의학 연보 자료 조회 중입니다...");
	
	var oParam = {};
		oParam.id          = "TRAES01901";
		oParam.service     = "examcurestatsapp.ImgMediSc";
		oParam.method      = "reqGetYYAchivStats";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_list=item";
		oParam.async       = false;
		oParam.callback    = "cf_TRAES01901";

	tranf_submit(oParam);
	
	var nRow = ds_main_list.rowcount;
	var prestyearsum = ds_main_list.getSum("prestyearsum");
	var bfyearsum = ds_main_list.getSum("bfyearsum");
	var variation = 0;

	if( bfyearsum == 0 ) {
		variation =  (( eval(prestyearsum) - eval(bfyearsum))) * 100; 
	} else {
		variation =  (( eval(prestyearsum) - eval(bfyearsum) ) / eval(bfyearsum)) * 100; 
	}
	variation = variation.toString().getRound(-1,"HALF_UP");
	grd_list.setCellProperty("summ", 16,"text", variation);
	
 	frmf_closeLoadingBar() ;//처리중 화면을 close한다. 
}

function cf_TRAES01901(sSvcId, nErrorCode, sErrorMsg) {
    arErrorCode.push(sSvcId, nErrorCode);
    var colid = 2;
	var sum = 0;
	for(var i = 0; i < ds_main_list.colcount ; i++) {
		if(ds_main_list.getColID(i).substr(0,5) == "month") {
			grd_list.setCellProperty("body",colid,"text","bind:"+ds_main_list.getColID(i));
			sum = ds_main_list.getSum(ds_main_list.getColID(i));
			grd_list.setCellProperty("summ", colid,"text",sum);
			colid++;
		}
	}
}

/******************************************************************
 * Argument          : 
 * Description       : excel 저장
 ******************************************************************/
function btn_excsave_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_list.rowcount > 1 ){
		grdf_exportExcel(grd_list, "년도대비실적통계", "년도대비실적통계", false, "", "user", false);
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}
]]></Script>
  </Form>
</FDL>