YNU_JEUS/app_home/himed/xpapps/emr/csrxp/xp/SMMNG02700_세탁물이불보유현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMMNG02700" position="absolute 0 0 729 638" titletext="부서별 이불 보유량현황" oninit="SMMNG02700_oninit" onload="SMMNG02700_onload">
    <Layouts>
      <Layout>
        <Div position="absolute 0 0 720 25" id="grp_tle">
          <Layouts>
            <Layout>
              <Static text="부서별 이불 보유 현황" position="absolute 0 0 163 25" id="caption6" class="tit_1"/>
            </Layout>
          </Layouts>
        </Div>
        <Div position="absolute 0 63 725 513" id="grp_biz" scrollbars="autoboth">
          <Layouts>
            <Layout>
              <Static text="부서별 이불 보유 현황" position="absolute 5 9 158 25" id="caption12" class="tit_2" anchor="default"/>
              <Shape position="absolute 5 26 715 32" linetype="horizontal" id="line1" class="line_10" anchor="default"/>
              <Button position="absolute 678 3 720 22" id="btn_sav" class="btn5" text="저장" anchor="default" onclick="grp_biz_btn_sav_onclick"/>
              <Grid position="absolute 5 30 715 450" id="grd_pnmtlist" binddataset="ds_main_pnmtinfo_pnmtlist" anchor="default" cellsizingtype="both" extendsizetype="row">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25" band="left"/>
                      <Column size="0"/>
                      <Column size="173"/>
                      <Column size="74"/>
                      <Column size="100"/>
                      <Column size="323"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="0"/>
                      <Column size="0"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="물품코드"/>
                      <Cell col="2" text="부서명"/>
                      <Cell col="3" text="보유량"/>
                      <Cell col="4" text="관리자"/>
                      <Cell col="5" text="비고"/>
                      <Cell col="6" text="기관번호"/>
                      <Cell col="7" text="년월"/>
                      <Cell col="8" text="부서코드"/>
                      <Cell col="9" text="현부서코드"/>
                      <Cell col="10" text="관리자이름"/>
                      <Cell col="11" text="caption1"/>
                    </Band>
                    <Band id="body">
                      <Cell celltype="head"/>
                      <Cell col="1" text="bind:ioflag"/>
                      <Cell col="2" text="bind:deptnm"/>
                      <Cell col="3" displaytype="number" style="align:left;" text="bind:pnmtcnt" mask="#,##9"/>
                      <Cell col="4" text="bind:fstrgstrnm"/>
                      <Cell col="5" displaytype="text" edittype="text" text="bind:remark1"/>
                      <Cell col="6" text="bind:instcd"/>
                      <Cell col="7" text="bind:pnmtyymm"/>
                      <Cell col="8" text="bind:deptcd"/>
                      <Cell col="9" text="bind:pnmtdeptcd"/>
                      <Cell col="10" text="bind:fstrgstrid"/>
                      <Cell col="11" text="bind:remark2"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Radio position="absolute 220 5 610 20" id="rdo_gubuncd" enable="false" visible="false" columncount="2" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">01</Col>
                      <Col id="datacolumn">물품마스터</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">02</Col>
                      <Col id="datacolumn">창고마스터</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
            </Layout>
          </Layouts>
        </Div>
        <Shape position="absolute 0 25 725 60" id="roundrect1" class="roundrect_search" type="roundrectangle"/>
        <Static text="년월:" position="absolute 15 35 82 52" id="cap_csrreqdeptcd" class="search_name"/>
        <Button position="absolute 545 32 601 54" id="btn_search" class="btn1" taborder="2" text="조회" onclick="btn_search_onclick"/>
        <Calendar position="absolute 77 33 145 52" id="ipt_pnmtyymm" class="input_default" mask="yyyy-mm" autoskip="true" autoselect="true" onchanged="ipt_pnmtyymm_onchanged" dateformat="yyyy-MM" value="null" editformat="yyyy-MM"/>
        <Shape position="absolute 532 30 538 55" linetype="vertical" id="line2" class="line_4"/>
        <Button position="absolute 605 32 661 54" id="button3" class="btn7" text="엑셀" onclick="button3_onclick"/>
        <Button position="absolute 665 32 721 54" id="btn_prt" class="btn6" text="출력" onclick="btn_prt_onclick"/>
        <TextArea position="absolute 5 533 715 630" id="txt_remark2" wordwrap="word"/>
        <Static text="비고" position="absolute 5 515 70 531" id="caption1" class="tit_2"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_pnmtinfo_pnmtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_pnmtinfo_pnmtlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="pnmtcnt" type="STRING" size="256"/>
          <Column id="pnmtyymm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="ioflag" type="STRING" size="256"/>
          <Column id="remark1" type="STRING" size="256"/>
          <Column id="fstrgstrid" type="STRING" size="256"/>
          <Column id="pnmtdeptcd" type="STRING" size="256"/>
          <Column id="remark2" type="STRING" size="256"/>
          <Column id="fstrgstrnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="deptnm"/>
            <Col id="pnmtcnt"/>
            <Col id="pnmtyymm"/>
            <Col id="deptcd"/>
            <Col id="ioflag"/>
            <Col id="remark1"/>
            <Col id="fstrgstrid"/>
            <Col id="pnmtdeptcd"/>
            <Col id="remark2"/>
            <Col id="fstrgstrnm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_pnmtinfo_csrdeptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_main_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="pnmtyymm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_csrdeptlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="pnmtyymm" type="STRING" size="256"/>
          <Column id="pnmtdeptcd" type="STRING" size="256"/>
          <Column id="gubuncd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="gubuncd">01</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_send_report_pnmtlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_biz.rdo_gubuncd" propid="value" datasetid="ds_send" columnid="gubuncd"/>
      <BindItem id="item1" compid="ipt_pnmtyymm" propid="value" datasetid="ds_main_cond" columnid="pnmtyymm"/>
      <BindItem id="item2" compid="txt_remark2" propid="value" datasetid="ds_main_pnmtinfo_pnmtlist" columnid="remark2"/>
    </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 SMMNG02700_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMMNG02700_onload(obj:Form, e:LoadEventInfo)
{
	grdf_setRowTypeIcon(grp_biz.grd_pnmtlist,0);
	fInitialize();
}

// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
function fInitialize() 
{
	ds_main_cond.setColumn(0, "pnmtyymm", utlf_getCurrentDate().substr(0,6));

	dsf_makeValue(ds_send_reqdata,"instcd"    , "string", sysf_getUserInfo("dutplceinstcd"));
	dsf_makeValue(ds_send_reqdata,"useyn"    , "string", "Y");				
	
	var oParam = {};
    oParam.id          = "TRMNG00402";
    oParam.service     = "csrapp.CsrMngt";
    oParam.method      = "getCsrDeptList";
    oParam.inds        = "req=ds_send_reqdata";
    oParam.outds       = "ds_main_csrdeptlist=csrdeptlist";
    oParam.async       = false;

	tranf_submit(oParam);
					
	fSearch();

}

function fSearch() {
	ds_send.setColumn(0, "pnmtyymm", ds_main_cond.getColumn(0, "pnmtyymm"));
	ds_send.setColumn(0, "pnmtdeptcd", "0000000000");									//컬럼삭제하여도됨 소스수정필요
	ds_send.setColumn(0, "gubuncd", ds_send.getColumn(0, "gubuncd"));	 				//마스터코드구분 01:물품마스터02:창고마스터		
	
	var oParam = {};
    oParam.id          = "TRMNG02101";
    oParam.service     = "csrapp.CsrDryMngt";
    oParam.method      = "reqGetPnmtList";
    oParam.inds        = "req=ds_send";
    oParam.outds       = "ds_main_pnmtinfo_pnmtlist=pnmtlist";
    oParam.async       = false;

	tranf_submit(oParam);
	
	var ioflag;
	for(var i = 0; i < ds_main_pnmtinfo_pnmtlist.rowcount; i++) {
		ioflag = grp_biz.grd_pnmtlist.getCellValue(i, grp_biz.grd_pnmtlist.getBindCellIndex("body","ioflag"));
		
		if(ioflag == "N") {
			ds_main_pnmtinfo_pnmtlist.updatecontrol = false;
			ds_main_pnmtinfo_pnmtlist.enableevent = false;

			ds_main_pnmtinfo_pnmtlist.setRowType(i, "I");

			ds_main_pnmtinfo_pnmtlist.enableevent = true;
			ds_main_pnmtinfo_pnmtlist.updatecontrol = true;
			
			ds_main_pnmtinfo_pnmtlist.setColumn(i, "fstrgstrid", sysf_getUserInfo("userid"));
			ds_main_pnmtinfo_pnmtlist.setColumn(i, "fstrgstrnm", sysf_getUserInfo("usernm"));
		}
	}
}
				
function grp_biz_btn_sav_onclick(obj:Button,  e:ClickEventInfo)
{
	var updtdata = grdf_getGridUpdateData(grp_biz.grd_pnmtlist);
	grdf_setStatusColumn(updtdata, "status");
	
	dsf_createDs("ds_send_savedata_pnmtlist");
	ds_send_savedata_pnmtlist.copyData(updtdata, true);
						
	var oParam = {};
    oParam.id          = "TXMNG02701";
    oParam.service     = "csrapp.CsrDryMngt";
    oParam.method      = "reqExePnmtList";
    oParam.inds        = "req=ds_send_savedata_pnmtlist";
    oParam.outds       = "";
    oParam.async       = false;

	tranf_submit(oParam);

	fSearch();
}

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

function ipt_pnmtyymm_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_main_cond.setColumn(0, "pnmtyymm", utlf_transNullToEmpty(e.postvalue+"").substr(0, 6));
	
	fSearch();
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	if (changeSavedataChk() == true) {
		grdf_exportExcel(grp_biz.grd_pnmtlist, "세탁물이불보유현황", "sheetname1" , true, "" , "" , true);	
	}
}

function btn_prt_onclick(obj:Button,  e:ClickEventInfo)
{
	fPrintRex();
}

function fPrintRex() {
					//
	if (changeSavedataChk() == true) {
		dsf_createDs("ds_send_report_pnmtlist");
		
		ds_send_report_pnmtlist.copyData(ds_main_pnmtinfo_pnmtlist);
		
		//미리보기출력
		var objDOM = rptf_createDOM();			
		rptf_setNodeListToDOM(objDOM, "root/main/pnmtinfo/pnmtlist", ds_send_report_pnmtlist);	// 데이터셋 1	
		
		var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;														// 최상의노드 XML 스트링 추출
		
		var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
		rptf_exeReportPreview30(["RPMNG02700"],[objParam], option);
	}

}

function changeSavedataChk() {
	var updtdata = grdf_getGridUpdateData(grp_biz.grd_pnmtlist);
	
	if (updtdata.rowcount == 0){
		return true;
	} else {
		sysf_messageBox("입력된 정보가 있어서 출력할 수 없습니다.", "E999");
		return false;
	}
}

function ds_main_pnmtinfo_pnmtlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid =="remark2"){
		var remark2 = "";
		remark2 =	ds_main_pnmtinfo_pnmtlist.getColumn(0, "remark2");

		for(var i = 0; i < ds_main_pnmtinfo_pnmtlist.rowcount; i++) {

			if (ds_main_pnmtinfo_pnmtlist.getRowType(i)  == "2" ) {
				ds_main_pnmtinfo_pnmtlist.updatecontrol = false;
				ds_main_pnmtinfo_pnmtlist.enableevent = false;

				ds_main_pnmtinfo_pnmtlist.setRowType(i, "I");

				ds_main_pnmtinfo_pnmtlist.enableevent = true;
				ds_main_pnmtinfo_pnmtlist.updatecontrol = true;

			} else if (ds_main_pnmtinfo_pnmtlist.getRowType(i)  == "1"  || ds_main_pnmtinfo_pnmtlist.getRowType(i)  == "4") {
				ds_main_pnmtinfo_pnmtlist.updatecontrol = false;
				ds_main_pnmtinfo_pnmtlist.enableevent = false;

				ds_main_pnmtinfo_pnmtlist.setRowType(i, "U");

				ds_main_pnmtinfo_pnmtlist.enableevent = true;
				ds_main_pnmtinfo_pnmtlist.updatecontrol = true;
			}
			ds_main_pnmtinfo_pnmtlist.setColumn(i, "remark2", remark2);
		}
	}
}
]]></Script>
  </Form>
</FDL>