YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRSM00700_월별취급대장입력현황조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSM00700" position="absolute 0 0 1196 759" titletext="특별관리물질취급일지 입력현황 조회" oninit="SMRSM00700_oninit" onload="SMRSM00700_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="특별관리물질취급일지 입력현황 조회" class="tit_1" position="absolute 0 0 267 25"/>
        <Shape id="line2" linetype="horizontal" class="line_6" position="absolute 0 30 1194 36" anchor="left top right"/>
        <Button id="btn_gen" taborder="1" text="취급일지" class="btn4" visible="false" position="absolute 1113 11 1193 33" anchor="top right"/>
        <Div id="grp_sea" taborder="2" class="div_SA2" position="absolute 0 33 1194 73" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption7" text="입력년월" class="search_name" position="absolute 476 9 558 26" anchor="default"/>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 657 6 663 28" anchor="top right"/>
              <Button id="btn_search" taborder="4" text="조회" class="btn1" position="absolute 678 7 734 29" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Calendar id="ipt_ym" taborder="5" class="input_default" position="absolute 559 8 635 27" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" autoselect="true"/>
              <Edit id="opt_deptnm" taborder="6" readonly="true" position="absolute 248 8 448 27" anchor="default" class="output"/>
              <Static id="caption1" text="부서코드" class="search_name" position="absolute 70 9 146 26" anchor="default"/>
              <Edit id="ipt_deptcd" taborder="7" class="input_default" position="absolute 151 8 226 27" anchor="default" autoselect="true" onkeydown="grp_sea_ipt_deptcd_onkeydown"/>
              <Button id="btn_deptcd" taborder="8" class="icon_search" position="absolute 229 9 245 25" anchor="default" onclick="grp_sea_btn_deptcd_onclick"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" linetype="horizontal" class="line_10" position="absolute 0 112 1193 118" anchor="left top right"/>
        <Static id="caption21" text="취급일지 입력현황" class="tit_2" position="absolute 1 96 131 113"/>
        <Grid id="grd_matrlist" taborder="3" binddataset="ds_main_matrlist" useinputpanel="false" position="absolute 0 117 1193 757" anchor="all" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30" band="left"/>
                <Column size="88"/>
                <Column size="202"/>
                <Column size="61"/>
                <Column size="267"/>
                <Column size="139"/>
                <Column size="64"/>
                <Column size="64"/>
              </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="확정여부"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" text="expr:expr:currow == ds_main_matrlist.rowposition ? '▶' : ''"/>
                <Cell col="1" text="bind:deptcd" suppress="1" suppressalign="middle,over"/>
                <Cell col="2" style="align:left middle;" text="bind:deptnm" suppress="1" suppressalign="middle,over"/>
                <Cell col="3" class="text_center" text="bind:matrcd"/>
                <Cell col="4" style="align:left middle;" text="bind:matrnm"/>
                <Cell col="5" style="align:left middle;" text="bind:prodcmpynm"/>
                <Cell col="6" text="bind:cnt"/>
                <Cell col="7" text="bind:cnfm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excel" taborder="4" text="엑셀출력" class="btn7" position="absolute 1113 95 1193 114" anchor="top right" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_matrlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptcd" type="STRING"/>
          <Column id="deptnm" type="STRING"/>
          <Column id="matrcd" type="STRING"/>
          <Column id="matrnm" type="STRING"/>
          <Column id="prodcmpynm" type="STRING"/>
          <Column id="cnt" type="STRING"/>
          <Column id="cnfm" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_condition" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_condition_oncolumnchanged">
        <ColumnInfo>
          <Column id="ym" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" 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"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_ym" propid="value" datasetid="ds_main_condition" columnid="ym"/>
      <BindItem id="item1" compid="grp_sea.opt_deptnm" propid="value" datasetid="ds_main_condition" columnid="deptnm"/>
      <BindItem id="item2" compid="grp_sea.ipt_deptcd" propid="value" datasetid="ds_main_condition" columnid="deptcd"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
 
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::RAC001.xjs";
include "mis_miscommonxp::RSZ001.xjs";

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

function SMRSM00700_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_matrlist);
	fOpenForm();
}

//화면 로드시 초기화 함수
function fOpenForm()
{
	misfGridInit(grd_matrlist);
	ds_main_condition.setColumn(0, "ym", utlf_getCurrentDate().substr(0, 6)); //기간 설정
}

//부서코드 조회
function grp_sea_btn_deptcd_onclick(obj:Button,  e:ClickEventInfo)
{
	var vOrigDeptcd = grp_sea.ipt_deptcd.value;  //popup을 열기전 부서 저장						       
	var recv_list = "deptcd,deptnm";
	misfOpenPopUpList("02", grp_sea.ipt_deptcd,"", recv_list);
	 
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_condition.getColumn(0, "ym").length < 6)
	{
		sysf_messageBox("입력년월을 정확하게 입력하십시요. ", "E999", "");
		grp_sea.ipt_ym.setFocus();
		return;
	}	
	fGetMatrList();
}

//코드 목록 조회 함수					
function fGetMatrList()
{ 						
	misfGridInit(grd_matrlist);							
	ds_send.copyData(ds_main_condition);
	
	var oParam = {};
		oParam.id          = "TRRSM00701";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetDeptInputStateList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_matrlist=matrlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSM00701";
	tranf_submit(oParam);
}

//엑셀출력
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_matrlist);
}

function ds_main_condition_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	switch( e.columnid ){
		case "deptcd" :
			//2013.02.26 박준범 : 부서코드 변경시 부서코드명을 먼저 지워준다.
			var objFocus = this.getFocus();
			grp_sea.opt_deptnm.value = "";
			
			grp_sea.ipt_deptcd.setFocus();
			misfValidationCheck("02", "", "deptcd,deptnm" );
			objFocus.setFocus();
			break;
			
		case "ym" :
			obj.setColumn(e.row, e.columnid, (e.newvalue+"").substr(0, 6));
			break;
			
		default :
			break;
	}
}

function grp_sea_ipt_deptcd_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if( e.keycode == 13 ){
		obj.updateToDataset();
	}
}
]]></Script>
  </Form>
</FDL>