YNU_JEUS/app_home/himed/xpapps/emr/csrxp/xp/SMMNG02401_세탁청구현황(칠곡병원).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMNG02401" position="absolute 0 0 1178 709" titletext="청구현황" oninit="SMMNG02401_oninit" onload="SMMNG02401_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 60 1178 709" id="grp_biz" scrollbars="autoboth" anchor="all">
          <Layouts>
            <Layout>
              <Static text="린넨수급현황" position="absolute 0 6 121 22" id="caption12" class="tit_2" anchor="default"/>
              <Shape position="absolute 0 23 1178 29" linetype="horizontal" id="line1" class="line_10" anchor="left top right"/>
              <Grid position="absolute 0 28 1178 649" id="grd_lnrqactinfo" binddataset="ds_main_lnrqact_lnrqactinfo" tabstop="false" selecttype="multirow" anchor="all" cellsizingtype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="130"/>
                      <Column size="130"/>
                      <Column size="130"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1"/>
                      <Cell col="2"/>
                    </Band>
                    <Band id="body">
                      <Cell style="align:left middle;" text="bind:lngoodnm"/>
                      <Cell col="1" style="align:left middle;" text="bind:goodcd"/>
                      <Cell col="2" style="align:left top;padding:5 2 1 2;" text="bind:goodcdseq" wordwrap="word"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
            </Layout>
          </Layouts>
        </Div>
        <Div id="group1" anchor="left top right" taborder="3" class="div_SA" position="absolute 0 24 1178 60">
          <Layouts>
            <Layout/>
          </Layouts>
        </Div>
        <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 5 33 91 53"/>
        <Edit id="opt_instcdnm" taborder="4" readonly="true" class="output" position="absolute 95 33 270 53" style="align:center middle;" align="align:center middle;"/>
        <Static id="cap_csrreqdeptcd" text="년월:" class="search_name" position="absolute 289 33 330 53"/>
        <Calendar id="ipt_reqfromdd" taborder="5" class="input_default" position="absolute 334 33 419 53" mask="yyyy-mm-dd"/>
        <Static id="caption2" text="~" position="absolute 430 33 445 53"/>
        <Calendar id="ipt_reqtodd" taborder="6" class="input_default" position="absolute 444 33 529 53" mask="yyyy-mm-dd"/>
        <Static id="caption1" text="청구부서:" class="search_name" position="absolute 557 33 642 53"/>
        <Combo id="cmb_deptcd" taborder="7" innerdataset="@ds_init_csrreqdeptlist" codecolumn="deptcd" datacolumn="deptnm" onitemchanged="cmb_deptcd_onitemchanged" class="combo_essential" position="absolute 629 33 775 53"/>
        <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1047 31 1053 55" anchor="top right"/>
        <Button id="btn_search" taborder="8" text="조회" onclick="btn_search_onclick" class="btn1" position="absolute 1055 32 1111 53" anchor="top right"/>
        <Button id="button3" taborder="9" text="엑셀" onclick="button3_onclick" class="btn7" position="absolute 1115 32 1171 53" anchor="top right"/>
        <Static id="caption6" text="린넨수급현황" class="tit_1" position="absolute 0 0 109 25"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_lnrqact" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="lnrqdept" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <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="reqfromdd" type="STRING" size="256"/>
          <Column id="instcdnm" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="reqtodd" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="reqfromdd"/>
            <Col id="instcdnm"/>
            <Col id="instcd"/>
            <Col id="reqtodd"/>
            <Col id="deptcd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_csrreqdeptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_lnrqact_lnrqactinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_lnrqact_lnrqactinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_lnrqact_lnrqdept" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_temp_lnrqact_lnrqmaxrow" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item1" compid="opt_instcdnm" propid="value" datasetid="ds_send" columnid="instcdnm"/>
      <BindItem id="item0" compid="ipt_reqfromdd" propid="value" datasetid="ds_send" columnid="reqfromdd"/>
      <BindItem id="item3" compid="ipt_reqtodd" propid="value" datasetid="ds_send" columnid="reqtodd"/>
      <BindItem id="item2" compid="cmb_deptcd" propid="value" datasetid="ds_send" columnid="deptcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-07-11
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-07-11      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

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

function SMMNG02401_onload(obj:Form, e:LoadEventInfo)
{
	fInitialize();
	ds_main_lnrqact_lnrqactinfo.addColumn("lngoodnm", "string");
	ds_main_lnrqact_lnrqactinfo.addColumn("goodcd", "string");
	ds_main_lnrqact_lnrqactinfo.addColumn("goodcdseq", "string");
}

// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
function fInitialize() 
{
	ds_send.setColumn(0, "instcdnm"	, sysf_getUserInfo("dutplceinstnm")); //기관코드
	ds_send.setColumn(0, "reqfromdd", utlf_getCurrentDate()); //년월일
	ds_send.setColumn(0, "reqtodd"	, utlf_getCurrentDate()); //년월일
	
	dsf_makeValue(ds_send,"instcd"     , "string", sysf_getUserInfo("dutplceinstcd")); //기관코드
	
	// 부서구분 조회
	var oParam = {};
    oParam.id          = "TRMNG00401";
    oParam.service     = "csrapp.CsrMngt";
    oParam.method      = "getCsrDeptList";
    oParam.inds        = "req=ds_send";
    oParam.outds       = "ds_init_csrreqdeptlist=csrdeptlist";
    oParam.async       = false;

	tranf_submit(oParam);
	
	frmf_addComboItem( "cmb_deptcd", "전체", "", "above");
}

function btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearch();
}

function fSearch() {
	ds_temp_lnrqact_lnrqactinfo.clearData();
	ds_temp_lnrqact_lnrqdept.clearData();
	ds_temp_lnrqact_lnrqmaxrow.clearData();
	
	//20180119 이돈희 추가 : 병동 변경시 그리드에 기존에 있는 값에서 추가됨
	ds_main_lnrqact_lnrqactinfo.clearData();
	
	var oParam = {};
    oParam.id          = "TRMNG02403";
    oParam.service     = "csrapp.CsrDryMngt";
    oParam.method      = "reqGetLnrqActInfo";
    oParam.inds        = "req=ds_send";
    oParam.outds       = "ds_temp_lnrqact_lnrqactinfo=lnrqactinfo ds_temp_lnrqact_lnrqdept=lnrqdept ds_temp_lnrqact_lnrqmaxrow=lnrqmaxrow";
    oParam.async       = false;

	tranf_submit(oParam);
	
	fDataset();
	
}

//20180122 이돈희 수정 : 청구부서를 전체로 조회시 total만 나오도록 수정
//                       : 안전재고량과 실재고량 삭제
function fDataset() {
	var caption = "린넨품명^물품코드^상세코드";
	var caption1 = "린넨품명^물품코드^상세코드";
	
	var sColumnInfo = "";
	var sRowInfo = "";
	var sHeadInfo = "";
	var sHeadInfo2 = "";
	var sBodyInfo = "";
	var sFormatInfo = "";
	
	sColumnInfo += '<Columns size="180" /> \r\n';
	sColumnInfo += '<Columns size="150" />  \r\n'
	sColumnInfo += '<Columns size="150" />  \r\n'
	
	sRowInfo += '<Row size="24" band="head" /> \r\n';
	sRowInfo += '<Row size="24" band="head" /> \r\n';
	sRowInfo += '<Row size="24" /> \r\n';
	
	sHeadInfo = '<Cell rowspan="2" text="린넨품명"/> \r\n';
	sHeadInfo += '<Cell col="1" rowspan="2" text="물품코드"/> \r\n';
	sHeadInfo += '<Cell col="2" rowspan="2" text="상세코드"/> \r\n';
	
	sBodyInfo += '<Cell col="0" text="bind:lngoodnm" style="align:left&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word"/> \r\n';
	sBodyInfo += '<Cell col="1" text="bind:goodcd" style="align:left&#32;center;"/> \r\n';
	sBodyInfo += '<Cell col="2"  text="bind:goodcdseq" style="align:left&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word"/> \r\n';
	
	var colnum = 3;
	//전체 인 경우
	if(utlf_isNull(cmb_deptcd.value)){
		// total에 대한 데이터셋 컬럼 추가
		ds_main_lnrqact_lnrqactinfo.addColumn("reqsum" , "string");//청구량
		ds_main_lnrqact_lnrqactinfo.addColumn("outsum" , "string");//불출량
		
		sColumnInfo += '<Columns size="60" /> \r\n';
		sColumnInfo += '<Columns size="60" /> \r\n';
		
		//total에 대한 head format
		sHeadInfo += '<Cell colspan="2" col="' + colnum + '"  text="TOTAL"/> \r\n';
		
		sHeadInfo2 += '<Cell style="align:center&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word" row="1" col="' + colnum + '" text="청구량"/>  \r\n';
		sHeadInfo2 += '<Cell row="1" col="' + (colnum+1) + '" text="불출량"/>  \r\n';	
		
		//total에 대한 body format	
		sBodyInfo += '<Cell style="align:left&#32;center;" col="'+colnum+'" displaytype="normal" edittype="none" text="bind:reqsum"/> \r\n';	
		sBodyInfo += '<Cell style="align:left&#32;center;" col="'+(colnum+1)+'" displaytype="normal" edittype="none" text="bind:outsum"/> \r\n';	
			
		sHeadInfo += sHeadInfo2;
		
		sColumnInfo = '<Columns> \r\n' + sColumnInfo + '</Columns> \r\n' ;
		sRowInfo = '<Rows> \r\n' + sRowInfo + '</Rows> \r\n';
		sHeadInfo = '<Band id="head"> \r\n' + sHeadInfo + '</Band> \r\n';
		sBodyInfo = '<Band id="body"> \r\n' + sBodyInfo + '</Band> \r\n';

		sFormatInfo = '<Formats> \r\n';
		sFormatInfo += '<Format id="default"> \r\n';
		sFormatInfo += sColumnInfo + sRowInfo + sHeadInfo + sBodyInfo;
		sFormatInfo += '</Format> \r\n';
		sFormatInfo += '</Formats>';
		
		grp_biz.grd_lnrqactinfo.enableredraw = false;
		grp_biz.grd_lnrqactinfo.formats = sFormatInfo;
		grp_biz.grd_lnrqactinfo.enableredraw = true;
			
		var reqcol = 0;
		var outcol = 0;

		for ( h=0; h< ds_temp_lnrqact_lnrqmaxrow.getColumn(0, "maxrow"); h++) {
			ds_main_lnrqact_lnrqactinfo.addRow();
		}
		
		//grp_biz.grd_lnrqactinfo.updateToDataset();
		
		for ( k=0; k< ds_temp_lnrqact_lnrqactinfo.rowcount; k++) {

			var row = ds_temp_lnrqact_lnrqactinfo.getColumn(k, "rnum")-2;
			var col = ds_temp_lnrqact_lnrqactinfo.getColumn(k, "col");
			
			//col 값이 null이면 total에 해당하는 값임
			if ( utlf_isNull(col) ) {
				reqcol 	= "reqsum";
				outcol 	= "outsum";
							
				ds_main_lnrqact_lnrqactinfo.setColumn(row, "goodcd"		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "goodcd"));
				ds_main_lnrqact_lnrqactinfo.setColumn(row, "goodcdseq"	, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "goodcdseq"));
				ds_main_lnrqact_lnrqactinfo.setColumn(row, reqcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "reqcnt"));
				ds_main_lnrqact_lnrqactinfo.setColumn(row, outcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "outcnt"));
			} 	
			
			// 린넨 품명 입력
			if ( !utlf_isNull(ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lngoodnm"))  ) {
				ds_main_lnrqact_lnrqactinfo.setColumn(row, "lngoodnm", ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lngoodnm"));
			}				

		}	

		
	}
	//특정 부서인 경우
	else {
		// caption 및 컬럼 동적생성
		for ( i = 0;  i < ds_temp_lnrqact_lnrqdept.rowcount; i++) {
			
			for( jj=1; jj < 3; jj++) {
				ds_main_lnrqact_lnrqactinfo.addColumn("col"+ colnum , "string");
				sColumnInfo += '<Columns size="60" /> \r\n';
				if(jj==1){
					sHeadInfo += '<Cell col="' + colnum + '"  colspan="2"  text="'+ ds_temp_lnrqact_lnrqdept.getColumn(i, "deptnm") +'"/> \r\n';
				}
				if(jj==1){
					sHeadInfo2 += '<Cell style="align:center&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word" row="1" col="' + colnum + '" text="청구량"/>  \r\n';
				}
				if(jj==2){
					sHeadInfo2 += '<Cell row="1" col="' + colnum+ '" text="불출량"/>  \r\n';
				}
				
				sBodyInfo += '<Cell style="align:left&#32;center;" col="'+colnum+'" displaytype="normal" edittype="none" text="bind:col'+  colnum  + '"/> \r\n';			
				colnum++;
			}
		}
		
		// total에 대한 데이터셋 컬럼 추가
		ds_main_lnrqact_lnrqactinfo.addColumn("reqsum" , "string");//청구량
		ds_main_lnrqact_lnrqactinfo.addColumn("outsum" , "string");//불출량
		
		sColumnInfo += '<Columns size="60" /> \r\n';
		sColumnInfo += '<Columns size="60" /> \r\n';
		
		//total에 대한 head format
		sHeadInfo += '<Cell colspan="2" col="' + colnum + '"  text="TOTAL"/> \r\n';
		
		sHeadInfo2 += '<Cell style="align:center&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word" row="1" col="' + colnum + '" text="청구량"/>  \r\n';
		sHeadInfo2 += '<Cell row="1" col="' + (colnum+1) + '" text="불출량"/>  \r\n';	
		
		//total에 대한 body format	
		sBodyInfo += '<Cell style="align:left&#32;center;" col="'+colnum+'" displaytype="normal" edittype="none" text="bind:reqsum"/> \r\n';	
		sBodyInfo += '<Cell style="align:left&#32;center;" col="'+(colnum+1)+'" displaytype="normal" edittype="none" text="bind:outsum"/> \r\n';	
			
		sHeadInfo += sHeadInfo2;
		
		sColumnInfo = '<Columns> \r\n' + sColumnInfo + '</Columns> \r\n' ;
		sRowInfo = '<Rows> \r\n' + sRowInfo + '</Rows> \r\n';
		sHeadInfo = '<Band id="head"> \r\n' + sHeadInfo + '</Band> \r\n';
		sBodyInfo = '<Band id="body"> \r\n' + sBodyInfo + '</Band> \r\n';

		sFormatInfo = '<Formats> \r\n';
		sFormatInfo += '<Format id="default"> \r\n';
		sFormatInfo += sColumnInfo + sRowInfo + sHeadInfo + sBodyInfo;
		sFormatInfo += '</Format> \r\n';
		sFormatInfo += '</Formats>';
		
		grp_biz.grd_lnrqactinfo.enableredraw = false;
		grp_biz.grd_lnrqactinfo.formats = sFormatInfo;
		grp_biz.grd_lnrqactinfo.enableredraw = true;
			
		var reqcol = 0;
		var outcol = 0;

		for ( h=0; h< ds_temp_lnrqact_lnrqmaxrow.getColumn(0, "maxrow"); h++) {
			ds_main_lnrqact_lnrqactinfo.addRow();
		}
		
		//grp_biz.grd_lnrqactinfo.updateToDataset();
		
		for ( k=0; k< ds_temp_lnrqact_lnrqactinfo.rowcount; k++) {

			var row = ds_temp_lnrqact_lnrqactinfo.getColumn(k, "rnum")-2;
			var col = ds_temp_lnrqact_lnrqactinfo.getColumn(k, "col");
			
			//col 값이 null이면 total에 해당하는 값임
			if ( utlf_isNull(col) ) {
				reqcol 	= "reqsum";
				outcol 	= "outsum";
			} else {
				reqcol 	= (col-1)*2 + 3;
				outcol 	= (col-1)*2 + 4;
				
				reqcol = grp_biz.grd_lnrqactinfo.getCellProperty("Body", reqcol, "text");
				reqcol = reqcol.replace("bind:", "");
				outcol = grp_biz.grd_lnrqactinfo.getCellProperty("Body", outcol, "text");
				outcol = outcol.replace("bind:", "");
			}
			
			// 린넨 품명 입력
			if ( !utlf_isNull(ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lngoodnm"))  ) {
				ds_main_lnrqact_lnrqactinfo.setColumn(row, "lngoodnm", ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lngoodnm"));
			}
			
			ds_main_lnrqact_lnrqactinfo.setColumn(row, "goodcd"		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "goodcd"));
			ds_main_lnrqact_lnrqactinfo.setColumn(row, "goodcdseq"	, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "goodcdseq"));
			ds_main_lnrqact_lnrqactinfo.setColumn(row, reqcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "reqcnt"));
			ds_main_lnrqact_lnrqactinfo.setColumn(row, outcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "outcnt"));
		}	


	}
}


//부서별 안전재고량/청구량/불출량/실재고량 표시 함수
function fDataset_20180119() {
	var caption = "린넨품명^물품코드^상세코드";
	var caption1 = "린넨품명^물품코드^상세코드";
	
	var sColumnInfo = "";
	var sRowInfo = "";
	var sHeadInfo = "";
	var sHeadInfo2 = "";
	var sBodyInfo = "";
	var sFormatInfo = "";
	
	sColumnInfo += '<Columns size="150" /> \r\n';
	sColumnInfo += '<Columns size="100" />  \r\n'
	sColumnInfo += '<Columns size="100" />  \r\n'
	
	sRowInfo += '<Row size="24" band="head" /> \r\n';
	sRowInfo += '<Row size="24" band="head" /> \r\n';
	sRowInfo += '<Row size="24" /> \r\n';
	
	sHeadInfo = '<Cell rowspan="2" text="린넨품명"/> \r\n';
	sHeadInfo += '<Cell col="1" rowspan="2" text="물품코드"/> \r\n';
	sHeadInfo += '<Cell col="2" rowspan="2" text="상세코드"/> \r\n';
	
	sBodyInfo += '<Cell col="0" text="bind:lngoodnm" style="align:left&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word"/> \r\n';
	sBodyInfo += '<Cell col="1" text="bind:goodcd" style="align:left&#32;center;"/> \r\n';
	sBodyInfo += '<Cell col="2"  text="bind:goodcdseq" style="align:left&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word"/> \r\n';
	
	
	var colnum = 3;
	// caption 및 컬럼 동적생성
	for ( i = 0;  i < ds_temp_lnrqact_lnrqdept.rowcount-1; i++) {
		
		for( jj=1; jj < 5; jj++) {
			ds_main_lnrqact_lnrqactinfo.addColumn("col"+ colnum , "string");
			sColumnInfo += '<Columns size="60" /> \r\n';
			if(jj==1){
				sHeadInfo += '<Cell col="' + colnum + '"  colspan="4"  text="'+ ds_temp_lnrqact_lnrqdept.getColumn(i, "deptnm") +'"/> \r\n';
			}
			if(jj==1){
				sHeadInfo2 += '<Cell style="align:center&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word" row="1" col="' + colnum + '" text="안전재고량"/>  \r\n';
			}
			if(jj==2){
				sHeadInfo2 += '<Cell row="1" col="' + colnum+ '" text="청구량"/>  \r\n';
			}
			if(jj==3){
				sHeadInfo2 += '<Cell row="1" col="' + colnum + '" text="불출량"/>  \r\n';
			}
			if(jj==4){
				sHeadInfo2 += '<Cell row="1" col="' + colnum + '" text="실재고량"/>  \r\n';
			}
			
			sBodyInfo += '<Cell style="align:left&#32;center;" col="'+colnum+'" displaytype="normal" edittype="none" text="bind:col'+  colnum  + '"/> \r\n';			
			colnum++;
		}
	}

	ds_main_lnrqact_lnrqactinfo.addColumn("lnsfsum" , "string");
	ds_main_lnrqact_lnrqactinfo.addColumn("reqsum" , "string");
	ds_main_lnrqact_lnrqactinfo.addColumn("outsum" , "string");
	ds_main_lnrqact_lnrqactinfo.addColumn("lnrlsum" , "string");
	
	sColumnInfo += '<Columns size="60" /> \r\n';
	sColumnInfo += '<Columns size="60" /> \r\n';
	sColumnInfo += '<Columns size="60" /> \r\n';
	sColumnInfo += '<Columns size="60" /> \r\n';
	
	sHeadInfo += '<Cell colspan="4" col="' + colnum + '"  text="TOTAL"/> \r\n';
	
	sHeadInfo2 += '<Cell style="align:center&#32;top;padding:5&#32;2&#32;1&#32;2;" wordwrap="word" row="1" col="' + colnum + '" text="안전재고량"/>  \r\n';
	sHeadInfo2 += '<Cell row="1" col="' + (colnum+1) + '" text="청구량"/>  \r\n';
	sHeadInfo2 += '<Cell row="1" col="' + (colnum+2) + '" text="불출량"/>  \r\n';
	sHeadInfo2 += '<Cell row="1" col="' + (colnum+3) + '" text="실재고량"/>  \r\n';
	
	sBodyInfo += '<Cell style="align:left&#32;center;" col="'+colnum+'" displaytype="normal" edittype="none" text="bind:lnsfsum"/> \r\n';	
	sBodyInfo += '<Cell style="align:left&#32;center;" col="'+(colnum+1)+'" displaytype="normal" edittype="none" text="bind:reqsum"/> \r\n';	
	sBodyInfo += '<Cell style="align:left&#32;center;" col="'+(colnum+2)+'" displaytype="normal" edittype="none" text="bind:outsum"/> \r\n';	
	sBodyInfo += '<Cell style="align:left&#32;center;" col="'+(colnum+3)+'" displaytype="normal" edittype="none" text="bind:lnrlsum"/> \r\n';
		
	sHeadInfo += sHeadInfo2;
	
	sColumnInfo = '<Columns> \r\n' + sColumnInfo + '</Columns> \r\n' ;
	sRowInfo = '<Rows> \r\n' + sRowInfo + '</Rows> \r\n';
	sHeadInfo = '<Band id="head"> \r\n' + sHeadInfo + '</Band> \r\n';
	sBodyInfo = '<Band id="body"> \r\n' + sBodyInfo + '</Band> \r\n';

	sFormatInfo = '<Formats> \r\n';
	sFormatInfo += '<Format id="default"> \r\n';
	sFormatInfo += sColumnInfo + sRowInfo + sHeadInfo + sBodyInfo;
	sFormatInfo += '</Format> \r\n';
	sFormatInfo += '</Formats>';
	
	grp_biz.grd_lnrqactinfo.enableredraw = false;
	grp_biz.grd_lnrqactinfo.formats = sFormatInfo;
	grp_biz.grd_lnrqactinfo.enableredraw = true;
		
		
	var lnsfcol = 0;
	var reqcol = 0;
	var outcol = 0;
	var lnrlcol = 0;

	for ( h=0; h< ds_temp_lnrqact_lnrqmaxrow.getColumn(0, "maxrow"); h++) {
		ds_main_lnrqact_lnrqactinfo.addRow();
	}
	
	grp_biz.grd_lnrqactinfo.updateToDataset();
	
	for ( k=0; k< ds_temp_lnrqact_lnrqactinfo.rowcount; k++) {

		var row = ds_temp_lnrqact_lnrqactinfo.getColumn(k, "rnum")-2;
		var col = ds_temp_lnrqact_lnrqactinfo.getColumn(k, "col");
		if ( utlf_isNull(col) ) {
			lnsfcol = "lnsfsum";
			reqcol 	= "reqsum";
			outcol 	= "outsum";
			lnrlcol = "lnrlsum";
		} else {
			lnsfcol = (col-1)*4 + 3;
			
			reqcol 	= (col-1)*4 + 4;
			
			outcol 	= (col-1)*4 + 5;
			
			lnrlcol = (col-1)*4 + 6;
			
			lnsfcol = grp_biz.grd_lnrqactinfo.getCellProperty("Body", lnsfcol, "text");
			lnsfcol = lnsfcol.replace("bind:", "");
			
			reqcol = grp_biz.grd_lnrqactinfo.getCellProperty("Body", reqcol, "text");
			reqcol = reqcol.replace("bind:", "");
			outcol = grp_biz.grd_lnrqactinfo.getCellProperty("Body", outcol, "text");
			outcol = outcol.replace("bind:", "");
			lnrlcol = grp_biz.grd_lnrqactinfo.getCellProperty("Body", lnrlcol, "text");
			lnrlcol = lnrlcol.replace("bind:", "");
		}
		
		if ( !utlf_isNull(ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lngoodnm"))  ) {
			ds_main_lnrqact_lnrqactinfo.setColumn(row, "lngoodnm", ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lngoodnm"));
		}
		
		ds_main_lnrqact_lnrqactinfo.setColumn(row, "goodcd"		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "goodcd"));
		ds_main_lnrqact_lnrqactinfo.setColumn(row, "goodcdseq"	, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "goodcdseq"));
		ds_main_lnrqact_lnrqactinfo.setColumn(row, lnsfcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lnsfcnt"));
		ds_main_lnrqact_lnrqactinfo.setColumn(row, reqcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "reqcnt"));
		ds_main_lnrqact_lnrqactinfo.setColumn(row, outcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "outcnt"));
		ds_main_lnrqact_lnrqactinfo.setColumn(row, lnrlcol		, ds_temp_lnrqact_lnrqactinfo.getColumn(k, "lnrlcnt"));
	}	
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grp_biz.grd_lnrqactinfo, "린넨부서별청구현황", "sheetname1" , true, "" , "" , true);	
}

function cmb_deptcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fSearch();
}
]]></Script>
  </Form>
</FDL>