YNU_JEUS/app_home/himed/xpapps/lis/refprintmngtxp/xp/SPLNP90300_일계표(팝업).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPLNP90300" position="absolute 0 0 1010 739" titletext="일계표" oninit="SPLNP90300_oninit" onload="SPLNP90300_onload">
    <Layouts>
      <Layout>
        <Static id="caption1" text="환자 수 일계표" class="tit_2" position="absolute 0 0 108 22"/>
        <Grid id="grd_detllist" class="datagrid2" taborder="1" binddataset="ds_main_countlist" useinputpanel="false" position="absolute 0 21 1005 711" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="145" band="left"/>
                <Column size="60" band="left"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="45"/>
                <Column size="50"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="검사명"/>
                <Cell col="1" text="구분"/>
                <Cell col="2" text="1"/>
                <Cell col="3" text="2"/>
                <Cell col="4" text="3"/>
                <Cell col="5" text="4"/>
                <Cell col="6" text="5"/>
                <Cell col="7" text="6"/>
                <Cell col="8" text="7"/>
                <Cell col="9" text="8"/>
                <Cell col="10" text="9"/>
                <Cell col="11" text="10"/>
                <Cell col="12" text="11"/>
                <Cell col="13" text="12"/>
                <Cell col="14" text="13"/>
                <Cell col="15" text="14"/>
                <Cell col="16" text="15"/>
                <Cell col="17" text="16"/>
                <Cell col="18" text="17"/>
                <Cell col="19" text="18"/>
                <Cell col="20" text="19"/>
                <Cell col="21" text="20"/>
                <Cell col="22" text="21"/>
                <Cell col="23" text="22"/>
                <Cell col="24" text="23"/>
                <Cell col="25" text="24"/>
                <Cell col="26" text="25"/>
                <Cell col="27" text="26"/>
                <Cell col="28" text="27"/>
                <Cell col="29" text="28"/>
                <Cell col="30" text="29"/>
                <Cell col="31" text="30"/>
                <Cell col="32" text="31"/>
                <Cell col="33" text="합계"/>
              </Band>
              <Band id="body">
                <Cell style="background:#b5e8e3ff;background2:#b5e8e3ff;" text="bind:prcpnm" wordwrap="word" suppress="1" suppressalign="middle,over"/>
                <Cell col="1" style="background:#b5e8e3ff;background2:#b5e8e3ff;" text="bind:rownm"/>
                <Cell col="2" displaytype="number" text="bind:d01"/>
                <Cell col="3" displaytype="number" text="bind:d02"/>
                <Cell col="4" displaytype="number" text="bind:d03"/>
                <Cell col="5" displaytype="number" text="bind:d04"/>
                <Cell col="6" displaytype="number" text="bind:d05"/>
                <Cell col="7" displaytype="number" text="bind:d06"/>
                <Cell col="8" displaytype="number" text="bind:d07"/>
                <Cell col="9" displaytype="number" text="bind:d08"/>
                <Cell col="10" displaytype="number" text="bind:d09"/>
                <Cell col="11" displaytype="number" text="bind:d10"/>
                <Cell col="12" displaytype="number" text="bind:d11"/>
                <Cell col="13" displaytype="number" text="bind:d12"/>
                <Cell col="14" displaytype="number" text="bind:d13"/>
                <Cell col="15" displaytype="number" text="bind:d14"/>
                <Cell col="16" displaytype="number" text="bind:d15"/>
                <Cell col="17" displaytype="number" text="bind:d16"/>
                <Cell col="18" displaytype="number" text="bind:d17"/>
                <Cell col="19" displaytype="number" text="bind:d18"/>
                <Cell col="20" displaytype="number" text="bind:d19"/>
                <Cell col="21" displaytype="number" text="bind:d20"/>
                <Cell col="22" displaytype="number" text="bind:d21"/>
                <Cell col="23" displaytype="number" text="bind:d22"/>
                <Cell col="24" displaytype="number" text="bind:d23"/>
                <Cell col="25" displaytype="number" text="bind:d24"/>
                <Cell col="26" displaytype="number" text="bind:d25"/>
                <Cell col="27" displaytype="number" text="bind:d26"/>
                <Cell col="28" displaytype="number" text="bind:d27"/>
                <Cell col="29" displaytype="number" text="bind:d28"/>
                <Cell col="30" displaytype="number" text="bind:d29"/>
                <Cell col="31" displaytype="number" text="bind:d30"/>
                <Cell col="32" displaytype="number" text="bind:d31"/>
                <Cell col="33" displaytype="number" text="bind:dsum"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" class="line_10" position="absolute 0 16 1005 22" anchor="left top right"/>
        <Button id="btn_cfm" taborder="2" text="닫기" class="btn4" position="absolute 950 714 1006 736" anchor="right bottom" onclick="btn_cfm_onclick"/>
        <Button id="btn_excel" taborder="3" text="엑셀저장" class="btn7" position="absolute 60 714 140 736" anchor="left bottom" onclick="btn_excel_onclick"/>
        <Button id="button11" taborder="4" text="출력" class="btn6" position="absolute 0 714 56 736" anchor="left bottom" onclick="button11_onclick"/>
        <CheckBox id="checkbox1" taborder="5" text="총합출력" truevalue="1" position="absolute 144 717 244 732" anchor="left bottom" onclick="checkbox1_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_countlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpnm" type="STRING"/>
          <Column id="rownm" type="STRING"/>
          <Column id="d01" type="STRING"/>
          <Column id="d02" type="STRING"/>
          <Column id="d03" type="STRING"/>
          <Column id="d04" type="STRING"/>
          <Column id="d05" type="STRING"/>
          <Column id="d06" type="STRING"/>
          <Column id="d07" type="STRING"/>
          <Column id="d08" type="STRING"/>
          <Column id="d09" type="STRING"/>
          <Column id="d10" type="STRING"/>
          <Column id="d11" type="STRING"/>
          <Column id="d12" type="STRING"/>
          <Column id="d13" type="STRING"/>
          <Column id="d14" type="STRING"/>
          <Column id="d15" type="STRING"/>
          <Column id="d16" type="STRING"/>
          <Column id="d17" type="STRING"/>
          <Column id="d18" type="STRING"/>
          <Column id="d19" type="STRING"/>
          <Column id="d20" type="STRING"/>
          <Column id="d21" type="STRING"/>
          <Column id="d22" type="STRING"/>
          <Column id="d23" type="STRING"/>
          <Column id="d24" type="STRING"/>
          <Column id="d25" type="STRING"/>
          <Column id="d26" type="STRING"/>
          <Column id="d27" type="STRING"/>
          <Column id="d28" type="STRING"/>
          <Column id="d29" type="STRING"/>
          <Column id="d30" type="STRING"/>
          <Column id="d31" type="STRING"/>
          <Column id="dsum" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_total" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="totaltest" type="STRING" size="256"/>
          <Column id="totalpat" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="totaltest"/>
            <Col id="totalpat"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bdioflag" type="STRING" size="256"/>
          <Column id="recmonth" type="STRING" size="256"/>
          <Column id="tclscd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="bdioflag"/>
            <Col id="recmonth"/>
            <Col id="tclscd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_ref" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="bdioflag" type="STRING" size="256"/>
          <Column id="recmonth" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="bdioflag">O</Col>
            <Col id="recmonth">200808</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_cal" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="totalprint" type="STRING" size="256"/>
          <Column id="patsum" type="STRING" size="256"/>
          <Column id="testsum" type="STRING" size="256"/>
          <Column id="totaltest" type="STRING" size="256"/>
          <Column id="totalpat" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_hidden_Rex" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="prcpnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="checkbox1" propid="value" datasetid="ds_hidden_cal" columnid="totalprint"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2015-05-01
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2015-05-01      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
function SPLNP90300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPLNP90300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_detllist);
	
	fGetDayPatCountList();	
}

function fGetDayPatCountList()
{
	ds_main_countlist.clearData();
	ds_main_total.clearData();
	
	ds_send.setColumn(0, "bdioflag", "O");
	
	ds_hidden_ref.setColumn(0, "recmonth", opener.ds_send.getColumn(0, "srchym"));
	ds_send.setColumn(0, "recmonth", opener.ds_send.getColumn(0, "srchym"));
	ds_send.setColumn(0, "tclscd", opener.ds_send.getColumn(0, "tclscd"));
	
	var oParam = {};
		oParam.id          = "TRLNP90101";
		oParam.service     = "refprintmngtapp.NmedRefPrintMngt";
		oParam.method      = "reqGetDayPatCountList";
		oParam.inds        = "cond=ds_send";
		oParam.outds       = "ds_main_countlist=getDayPatCountList ds_main_total=getDayTotalCountList";
		oParam.async       = false;
		//oParam.callback    = "cf_TRLNP90101";

	tranf_submit(oParam);
}	
function button11_onclick(obj:Button,  e:ClickEventInfo)
{
	fPrintRex();
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_detllist, "", "");	
}

function checkbox1_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	if(obj.value == "1")
	{
	
	}
	else
	{
		ds_hidden_cal.setColumn(0, "totalprint", "");
	}
}

function btn_cfm_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}

function fPrintRex()
{
	var patsum = 0;
	var testsum = 0;
	var row = 0;
	for(var i = 0; i < ds_main_countlist.rowcount; i++)
	{
		if(i%2 == 0)
		{
			dsf_makeValue(ds_hidden_Rex, "prcpnm", "string", ds_main_countlist.getColumn(i, "prcpnm"), row);
			dsf_makeValue(ds_hidden_Rex, "rownm", "string", ds_main_countlist.getColumn(i, "rownm"), row);
			
			dsf_makeValue(ds_hidden_Rex, "d01", "string", ds_main_countlist.getColumn(i, "d01"), row);
			dsf_makeValue(ds_hidden_Rex, "d02", "string", ds_main_countlist.getColumn(i, "d02"), row);
			dsf_makeValue(ds_hidden_Rex, "d03", "string", ds_main_countlist.getColumn(i, "d03"), row);
			dsf_makeValue(ds_hidden_Rex, "d04", "string", ds_main_countlist.getColumn(i, "d04"), row);
			dsf_makeValue(ds_hidden_Rex, "d05", "string", ds_main_countlist.getColumn(i, "d05"), row);
			dsf_makeValue(ds_hidden_Rex, "d06", "string", ds_main_countlist.getColumn(i, "d06"), row);
			dsf_makeValue(ds_hidden_Rex, "d07", "string", ds_main_countlist.getColumn(i, "d07"), row);
			dsf_makeValue(ds_hidden_Rex, "d08", "string", ds_main_countlist.getColumn(i, "d08"), row);
			dsf_makeValue(ds_hidden_Rex, "d09", "string", ds_main_countlist.getColumn(i, "d09"), row);
			dsf_makeValue(ds_hidden_Rex, "d10", "string", ds_main_countlist.getColumn(i, "d10"), row);
			dsf_makeValue(ds_hidden_Rex, "d11", "string", ds_main_countlist.getColumn(i, "d11"), row);
			dsf_makeValue(ds_hidden_Rex, "d12", "string", ds_main_countlist.getColumn(i, "d12"), row);
			dsf_makeValue(ds_hidden_Rex, "d13", "string", ds_main_countlist.getColumn(i, "d13"), row);
			dsf_makeValue(ds_hidden_Rex, "d14", "string", ds_main_countlist.getColumn(i, "d14"), row);
			dsf_makeValue(ds_hidden_Rex, "d15", "string", ds_main_countlist.getColumn(i, "d15"), row);
			dsf_makeValue(ds_hidden_Rex, "d16", "string", ds_main_countlist.getColumn(i, "d16"), row);
			dsf_makeValue(ds_hidden_Rex, "d17", "string", ds_main_countlist.getColumn(i, "d17"), row);
			dsf_makeValue(ds_hidden_Rex, "d18", "string", ds_main_countlist.getColumn(i, "d18"), row);
			dsf_makeValue(ds_hidden_Rex, "d19", "string", ds_main_countlist.getColumn(i, "d19"), row);
			dsf_makeValue(ds_hidden_Rex, "d20", "string", ds_main_countlist.getColumn(i, "d20"), row);
			dsf_makeValue(ds_hidden_Rex, "d21", "string", ds_main_countlist.getColumn(i, "d21"), row);
			dsf_makeValue(ds_hidden_Rex, "d22", "string", ds_main_countlist.getColumn(i, "d22"), row);
			dsf_makeValue(ds_hidden_Rex, "d23", "string", ds_main_countlist.getColumn(i, "d23"), row);
			dsf_makeValue(ds_hidden_Rex, "d24", "string", ds_main_countlist.getColumn(i, "d24"), row);
			dsf_makeValue(ds_hidden_Rex, "d25", "string", ds_main_countlist.getColumn(i, "d25"), row);
			dsf_makeValue(ds_hidden_Rex, "d26", "string", ds_main_countlist.getColumn(i, "d26"), row);
			dsf_makeValue(ds_hidden_Rex, "d27", "string", ds_main_countlist.getColumn(i, "d27"), row);
			dsf_makeValue(ds_hidden_Rex, "d28", "string", ds_main_countlist.getColumn(i, "d28"), row);
			dsf_makeValue(ds_hidden_Rex, "d29", "string", ds_main_countlist.getColumn(i, "d29"), row);
			dsf_makeValue(ds_hidden_Rex, "d30", "string", ds_main_countlist.getColumn(i, "d30"), row);
			dsf_makeValue(ds_hidden_Rex, "d31", "string", ds_main_countlist.getColumn(i, "d31"), row);
			dsf_makeValue(ds_hidden_Rex, "dsum", "string", ds_main_countlist.getColumn(i, "dsum"), row);
			
			if(i < ds_main_countlist.rowcount-2)
			{
				patsum = patsum + parseInt(ds_main_countlist.getColumn(i, "dsum"));
			}
		}
		else
		{
			dsf_makeValue(ds_hidden_Rex, "prcpnm", "string", ds_main_countlist.getColumn(i, "prcpnm"), row);
			dsf_makeValue(ds_hidden_Rex, "erownm", "string", ds_main_countlist.getColumn(i, "rownm"), row);
			
			dsf_makeValue(ds_hidden_Rex, "e01", "string", ds_main_countlist.getColumn(i, "d01"), row);
			dsf_makeValue(ds_hidden_Rex, "e02", "string", ds_main_countlist.getColumn(i, "d02"), row);
			dsf_makeValue(ds_hidden_Rex, "e03", "string", ds_main_countlist.getColumn(i, "d03"), row);
			dsf_makeValue(ds_hidden_Rex, "e04", "string", ds_main_countlist.getColumn(i, "d04"), row);
			dsf_makeValue(ds_hidden_Rex, "e05", "string", ds_main_countlist.getColumn(i, "d05"), row);
			dsf_makeValue(ds_hidden_Rex, "e06", "string", ds_main_countlist.getColumn(i, "d06"), row);
			dsf_makeValue(ds_hidden_Rex, "e07", "string", ds_main_countlist.getColumn(i, "d07"), row);
			dsf_makeValue(ds_hidden_Rex, "e08", "string", ds_main_countlist.getColumn(i, "d08"), row);
			dsf_makeValue(ds_hidden_Rex, "e09", "string", ds_main_countlist.getColumn(i, "d09"), row);
			dsf_makeValue(ds_hidden_Rex, "e10", "string", ds_main_countlist.getColumn(i, "d10"), row);
			dsf_makeValue(ds_hidden_Rex, "e11", "string", ds_main_countlist.getColumn(i, "d11"), row);
			dsf_makeValue(ds_hidden_Rex, "e12", "string", ds_main_countlist.getColumn(i, "d12"), row);
			dsf_makeValue(ds_hidden_Rex, "e13", "string", ds_main_countlist.getColumn(i, "d13"), row);
			dsf_makeValue(ds_hidden_Rex, "e14", "string", ds_main_countlist.getColumn(i, "d14"), row);
			dsf_makeValue(ds_hidden_Rex, "e15", "string", ds_main_countlist.getColumn(i, "d15"), row);
			dsf_makeValue(ds_hidden_Rex, "e16", "string", ds_main_countlist.getColumn(i, "d16"), row);
			dsf_makeValue(ds_hidden_Rex, "e17", "string", ds_main_countlist.getColumn(i, "d17"), row);
			dsf_makeValue(ds_hidden_Rex, "e18", "string", ds_main_countlist.getColumn(i, "d18"), row);
			dsf_makeValue(ds_hidden_Rex, "e19", "string", ds_main_countlist.getColumn(i, "d19"), row);
			dsf_makeValue(ds_hidden_Rex, "e20", "string", ds_main_countlist.getColumn(i, "d20"), row);
			dsf_makeValue(ds_hidden_Rex, "e21", "string", ds_main_countlist.getColumn(i, "d21"), row);
			dsf_makeValue(ds_hidden_Rex, "e22", "string", ds_main_countlist.getColumn(i, "d22"), row);
			dsf_makeValue(ds_hidden_Rex, "e23", "string", ds_main_countlist.getColumn(i, "d23"), row);
			dsf_makeValue(ds_hidden_Rex, "e24", "string", ds_main_countlist.getColumn(i, "d24"), row);
			dsf_makeValue(ds_hidden_Rex, "e25", "string", ds_main_countlist.getColumn(i, "d25"), row);
			dsf_makeValue(ds_hidden_Rex, "e26", "string", ds_main_countlist.getColumn(i, "d26"), row);
			dsf_makeValue(ds_hidden_Rex, "e27", "string", ds_main_countlist.getColumn(i, "d27"), row);
			dsf_makeValue(ds_hidden_Rex, "e28", "string", ds_main_countlist.getColumn(i, "d28"), row);
			dsf_makeValue(ds_hidden_Rex, "e29", "string", ds_main_countlist.getColumn(i, "d29"), row);
			dsf_makeValue(ds_hidden_Rex, "e30", "string", ds_main_countlist.getColumn(i, "d30"), row);
			dsf_makeValue(ds_hidden_Rex, "e31", "string", ds_main_countlist.getColumn(i, "d31"), row);
			dsf_makeValue(ds_hidden_Rex, "esum", "string", ds_main_countlist.getColumn(i, "dsum"), row);
			
			if(i < ds_main_countlist.rowcount-2)
			{
				testsum = testsum + parseInt(ds_main_countlist.getColumn(i, "dsum"));
			}
			row = ds_hidden_Rex.addRow();
		}
	}

	ds_hidden_Rex.deleteRow(ds_hidden_Rex.rowcount-1);
	
	ds_hidden_cal.setColumn(0, "patsum", patsum);
	ds_hidden_cal.setColumn(0, "testsum", testsum);
	ds_hidden_cal.setColumn(0, "totaltest", ds_main_total.getColumn(0, "totaltest"));
	ds_hidden_cal.setColumn(0, "totalpat", ds_main_total.getColumn(0, "totalpat"));
	
	var objDOM = rptf_createDOM();                // DOM 객체 설정 
		rptf_setNodeListToDOM(objDOM, "/root/hidden/Rex", ds_hidden_Rex); 
		rptf_setNodeListToDOM(objDOM, "/root/hidden/ref", ds_hidden_ref); 
		rptf_setNodeListToDOM(objDOM, "/root/hidden/cal", ds_hidden_cal); 
		
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;          // 최상의노드 XML 스트링 추출
	var option = "";
	 
	rptf_exeReportPreview30(["RPLNP90300"],[objParam], option);
}	
]]></Script>
  </Form>
</FDL>