YNU_JEUS/app_home/himed/xpapps/lis/refprintmngtxp/xp/SMLNP00600_소모분석자료.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMLNP00600" position="absolute 0 0 1197 783" titletext="소모분석자료" oninit="SMLNP00600_oninit" onload="SMLNP00600_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="소모분석 자료관리" class="tit_1" position="absolute 0 0 224 23"/>
        <Button id="button11" taborder="1" text="출력" class="btn6" position="absolute 0 24 56 46" onclick="button11_onclick"/>
        <Button id="btn_reset" taborder="2" text="초기화" class="btn4" position="absolute 1127 24 1195 46" anchor="top right" onclick="btn_reset_onclick"/>
        <Shape id="line32" linetype="horizontal" class="line_6" position="absolute 0 45 1194 51" anchor="left top right"/>
        <Shape id="line1" class="line_10" position="absolute 0 109 1194 115" anchor="left top right"/>
        <Div id="group1" anchor="left top right" taborder="3" class="div_SA" position="absolute 0 49 1195 84">
          <Layouts>
            <Layout>
              <Shape id="line3" linetype="vertical" class="line_4" position="absolute 1105 7 1111 29" anchor="top right"/>
              <Button id="btn_Ref" taborder="1" text="조회" class="btn1" position="absolute 1123 7 1179 29" anchor="top right" onclick="group1_btn_Ref_onclick"/>
              <Static id="caption11" text="기준월 :" class="search_name" position="absolute 40 10 131 27"/>
              <Calendar id="input3" taborder="2" autoselect="true" autoskip="true" dateformat="yyyy-MM" editformat="yyyy-MM" class="input_default" position="absolute 125 8 215 27" mask="yyyy-mm" onchanged="group1_input3_onchanged"/>
              <Calendar id="input1" taborder="3" autoselect="true" autoskip="true" dateformat="yyyy-MM" editformat="yyyy-MM" class="input_default" position="absolute 245 8 335 27" mask="yyyy-mm" onchanged="group1_input1_onchanged"/>
              <Static id="caption8" text="~" position="absolute 222 8 234 28"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption3" text="소모분석리스트" class="tit_2" position="absolute 1 93 135 115"/>
        <Grid id="grd_usevallist" taborder="4" binddataset="ds_main_usevallist" useinputpanel="false" position="absolute 0 114 1194 754" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="120"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="3"/>
                <Column size="120"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="3"/>
                <Column size="120"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
                <Column size="55"/>
              </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"/>
                <Cell col="7" text="핵종명"/>
                <Cell col="8" text="전월량"/>
                <Cell col="9" text="입고량"/>
                <Cell col="10" text="사용량"/>
                <Cell col="11" text="관리"/>
                <Cell col="12" text="잔량"/>
                <Cell col="13"/>
                <Cell col="14" text="핵종명"/>
                <Cell col="15" text="전월량"/>
                <Cell col="16" text="입고량"/>
                <Cell col="17" text="사용량"/>
                <Cell col="18" text="관리"/>
                <Cell col="19" text="잔량"/>
              </Band>
              <Band id="body">
                <Cell text="bind:itemnm"/>
                <Cell col="1" text="bind:bfcnt"/>
                <Cell col="2" text="bind:icnt"/>
                <Cell col="3" text="bind:ocnt"/>
                <Cell col="4" text="bind:mcnt"/>
                <Cell col="5" text="bind:scnt"/>
                <Cell col="6" text="bind:tab"/>
                <Cell col="7" text="bind:itemnm2"/>
                <Cell col="8" text="bind:bfcnt2"/>
                <Cell col="9" text="bind:icnt2"/>
                <Cell col="10" text="bind:ocnt2"/>
                <Cell col="11" text="bind:mcnt2"/>
                <Cell col="12" text="bind:scnt2"/>
                <Cell col="13" text="bind:tab2"/>
                <Cell col="14" text="bind:itemnm3"/>
                <Cell col="15" text="bind:bfcnt3"/>
                <Cell col="16" text="bind:icnt3"/>
                <Cell col="17" text="bind:ocnt3"/>
                <Cell col="18" text="bind:mcnt3"/>
                <Cell col="19" text="bind:scnt3"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excel" taborder="5" text="엑셀저장" class="btn7" position="absolute 0 758 80 777" anchor="left bottom" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_usevallist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="itemnm" type="STRING"/>
          <Column id="bfcnt" type="STRING"/>
          <Column id="icnt" type="STRING"/>
          <Column id="ocnt" type="STRING"/>
          <Column id="mcnt" type="STRING"/>
          <Column id="scnt" type="STRING"/>
          <Column id="tab" type="STRING"/>
          <Column id="itemnm2" type="STRING"/>
          <Column id="bfcnt2" type="STRING"/>
          <Column id="icnt2" type="STRING"/>
          <Column id="ocnt2" type="STRING"/>
          <Column id="mcnt2" type="STRING"/>
          <Column id="scnt2" type="STRING"/>
          <Column id="tab2" type="STRING"/>
          <Column id="itemnm3" type="STRING"/>
          <Column id="bfcnt3" type="STRING"/>
          <Column id="icnt3" type="STRING"/>
          <Column id="ocnt3" type="STRING"/>
          <Column id="mcnt3" type="STRING"/>
          <Column id="scnt3" 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="srchym" type="STRING" size="256"/>
          <Column id="srchym2" type="STRING" size="256"/>
          <Column id="srchbdioflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="srchym"/>
            <Col id="srchym2"/>
            <Col id="srchbdioflag"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group1.input3" propid="value" datasetid="ds_send" columnid="srchym"/>
      <BindItem id="item1" compid="group1.input1" propid="value" datasetid="ds_send" columnid="srchym2"/>
    </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 SMLNP00600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMLNP00600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_usevallist);
	fSetInit();
}

function fSetInit()
{
	ds_main_usevallist.clearData();
	
	var toDay = utlf_getCurrentDate();
	var toDays = toDay.substr(0,6)
	
	ds_send.setColumn(0, "srchbdioflag", "O");
	ds_send.setColumn(0, "srchym", toDays);
	ds_send.setColumn(0, "srchym2", toDays);
}

function group1_input3_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send.setColumn(0, "srchym", String(obj.value).substr(0,6));
}

function group1_input1_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send.setColumn(0, "srchym2", String(obj.value).substr(0,6));
}

function group1_btn_Ref_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetUseValList();	
}

function btn_reset_onclick(obj:Button,  e:ClickEventInfo)
{
	fSetInit();
}

function button11_onclick(obj:Button,  e:ClickEventInfo)
{
	fReportPrint();	
}

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

function fGetUseValList()
{
	var oParam = {};
		oParam.id          = "TRLNP00501";
		oParam.service     = "refprintmngtapp.NmedRefPrintMngt";
		oParam.method      = "reqGetUseValList";
		oParam.inds        = "cond=ds_send";
		oParam.outds       = "ds_main_usevallist=getUseValList";
		oParam.async       = false;
		//oParam.callback    = "cf_TRLNP00501";

	tranf_submit(oParam);
}

function fReportPrint()
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/usevallist", ds_main_usevallist);
		rptf_setNodeListToDOM(objDOM, "/root/send", ds_send);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;   
	var option = ""; 
	rptf_exeReportPreview30(["RPLNP00600"],[objParam], option);
}]]></Script>
  </Form>
</FDL>