YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRSM00600_부서별물품별청구현황조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSM00600" position="absolute 0 0 1197 773" titletext="미등록물질 청구 부서 조회" oninit="SMRSM00600_oninit" onload="SMRSM00600_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="미등록물질 청구 부서 조회" class="tit_1" position="absolute 0 0 211 25" anchor="left top"/>
        <Shape id="line2" linetype="horizontal" class="line_6" position="absolute 0 38 1194 44" anchor="left top right"/>
        <Div id="grp_sea" taborder="1" class="div_SA2" position="absolute 0 41 1194 81" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption7" text="청구일자" class="search_name" position="absolute 71 11 150 28" anchor="left top"/>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 377 8 383 30" anchor="left top"/>
              <Button id="btn_search" taborder="2" text="조회" class="btn1" position="absolute 403 9 459 31" anchor="left top" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption1" text="~" position="absolute 247 13 258 28" anchor="left top"/>
              <Calendar id="ipt_fromdd" taborder="3" class="input_default" position="absolute 144 10 245 29" mask="yyyy-mm-dd" anchor="left top" autoselect="true"/>
              <Calendar id="ipt_todd" taborder="4" class="input_default" position="absolute 261 10 362 29" mask="yyyy-mm-dd" anchor="left top" autoselect="true"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" linetype="horizontal" class="line_10" position="absolute 0 113 1193 119" anchor="left top right"/>
        <Static id="caption21" text="부서별 미등록된 물류 MSDS물품 목록" class="tit_2" position="absolute 1 95 253 111"/>
        <Grid id="grd_goodlist" taborder="2" binddataset="ds_main_goodlist" useinputpanel="false" position="absolute 0 118 1193 718" anchor="all" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="29" band="left"/>
                <Column size="79"/>
                <Column size="202"/>
                <Column size="77"/>
                <Column size="313"/>
                <Column size="181"/>
                <Column size="139"/>
                <Column size="138"/>
              </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:currow + 1"/>
                <Cell col="1" style="align:center middle;" text="bind:reqdeptcd"/>
                <Cell col="2" style="align:left middle;" text="bind:reqdeptnm"/>
                <Cell col="3" style="align:center middle;" class="text_center" text="bind:goodcd"/>
                <Cell col="4" style="align:left middle;" text="bind:goodnm"/>
                <Cell col="5" style="align:left middle;" text="bind:goodspec"/>
                <Cell col="6" style="align:left middle;" text="bind:prodcmpynm"/>
                <Cell col="7" style="align:left middle;" text="bind:maincustlastsuplplcenm"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption3" text="※ 1. 소모품 청구건 만을 대상으로 합니다." position="absolute 5 725 1070 745" anchor="left right bottom" style="color:red;"/>
        <Button id="btn_excel" taborder="3" text="엑셀출력" class="btn7" position="absolute 1121 95 1193 114" anchor="top right" onclick="btn_excel_onclick"/>
        <Static id="caption2" text="2. 물류 물품마스터에서 물품코드의 제조회사를 변경하였을 경우, 해당 물품코드가 화학물질코드로 기등록된 것이면 제조회사와 무관하게 위의 목록 상에는 나타나지 않음을 양지하시기 바랍니다." position="absolute 20 745 1084 765" anchor="left right bottom" style="color:red;"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reqdeptcd" type="STRING"/>
          <Column id="reqdeptnm" type="STRING"/>
          <Column id="goodcd" type="STRING"/>
          <Column id="goodnm" type="STRING"/>
          <Column id="goodspec" type="STRING"/>
          <Column id="prodcmpynm" type="STRING"/>
          <Column id="maincustlastsuplplcenm" 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">
        <ColumnInfo>
          <Column id="fromdd" type="STRING" size="256"/>
          <Column id="todd" 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_fromdd" propid="value" datasetid="ds_main_condition" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_main_condition" columnid="todd"/>
    </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 SMRSM00600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRSM00600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_goodlist);
	fOpenForm();
}

//화면 로드시 초기화 함수
function fOpenForm()
{
	misfGridInit(grd_goodlist);

	ds_main_condition.setColumn(0, "fromdd", utlf_getCurrentDate().toDate().getAddDate(-1,"M").getDateFormat());
	ds_main_condition.setColumn(0, "todd", utlf_getCurrentDate());
	

}

//조회 버튼클릭
function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetGoodList();
}

//코드 목록 조회 함수					
function fGetGoodList()
{ 
	misfGridInit(grd_goodlist);
	ds_send.copyData(ds_main_condition);
	var oParam = {};
		oParam.id          = "TRRSM00601";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetDeptMsdsGoodList";
		oParam.inds        = "req=ds_main_condition";
		oParam.outds       = "ds_main_goodlist=goodlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSM00601";
	tranf_submit(oParam);
}

//엑셀출력
function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	misfSaveExcel(grd_goodlist);
}
]]></Script>
  </Form>
</FDL>