YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRSM00500_물류MSDS물품일괄등록.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSM00500" position="absolute 0 0 1197 782" titletext="신규물질 등록 조회(물류)" oninit="SMRSM00500_oninit" onload="SMRSM00500_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="신규물질 등록 조회(물류)" class="tit_1" position="absolute 0 0 203 25" anchor="left top"/>
        <Shape id="line2" linetype="horizontal" class="line_2" position="absolute 0 35 1194 41" anchor="top right"/>
        <Button id="btn_save" taborder="1" text="일괄등록" class="btn4" position="absolute 1112 14 1192 36" anchor="top right" onclick="btn_save_onclick"/>
        <Div id="grp_sea" taborder="2" class="div_SA2" position="absolute 0 39 1194 79" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption7" text="물품코드 최종 Update 일자" class="search_name" position="absolute 24 11 210 28" anchor="left top"/>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 477 6 483 28" anchor="right"/>
              <Button id="btn_search" taborder="2" text="조회" class="btn1" position="absolute 498 7 554 29" anchor="right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption1" text="~" position="absolute 326 12 337 27" anchor="left top"/>
              <Calendar id="ipt_fromdd" taborder="3" class="input_default" position="absolute 220 9 321 28" mask="yyyy-mm-dd" anchor="left top" autoskip="true" autoselect="true"/>
              <Calendar id="ipt_todd" taborder="4" class="input_default" position="absolute 344 9 445 28" mask="yyyy-mm-dd" anchor="left top" autoselect="true" autoskip="true"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" class="line_10" position="absolute 0 105 765 111" anchor="left top right"/>
        <Shape id="line1" linetype="horizontal" class="line_10" position="absolute 770 105 1190 111" anchor="top right"/>
        <Static id="caption21" text="미등록된 물류 MSDS물품 목록" class="tit_2" position="absolute 1 89 215 104" anchor="left top"/>
        <Static id="caption20" text="상세내역" class="tit_2" position="absolute 771 89 845 105" anchor="top right"/>
        <Grid id="grd_goodlist" taborder="3" binddataset="ds_main_goodlist" useinputpanel="false" position="absolute 0 110 765 740" anchor="all" oncellclick="grd_goodlist_oncellclick" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26" band="left"/>
                <Column size="30"/>
                <Column size="77"/>
                <Column size="188"/>
                <Column size="86"/>
                <Column size="94"/>
                <Column size="94"/>
                <Column size="157"/>
                <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="비고"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" class="text_center" text="bind:checkflag" expr="expr:checkflag == 'Y' || checkflag == '1' ? 1 : 0"/>
                <Cell col="2" class="text_center" text="bind:goodcd"/>
                <Cell col="3" style="align:left top;padding:4 2 2 2;" text="bind:goodnm" wordwrap="word"/>
                <Cell col="4" style="align:left middle;" text="bind:goodspec"/>
                <Cell col="5" style="align:left middle;" text="bind:prodcmpynm"/>
                <Cell col="6" style="align:left middle;" text="bind:maincustlastsuplplcenm"/>
                <Cell col="7" style="align:left top;padding:4 2 2 2;" text="bind:matrnm" wordwrap="word"/>
                <Cell col="8" text="bind:prodcmpycd"/>
                <Cell col="9" text="bind:maincustlastsuplplce"/>
                <Cell col="10" text="bind:frgstdd"/>
                <Cell col="11" text="bind:cmt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="cap_matrnm" text="물 질 명" class="cell_1" position="absolute 770 110 878 135" anchor="top right"/>
        <Edit id="ipt_matrnm" taborder="4" class="input_essential" position="absolute 881 113 1186 132" autoselect="true" anchor="top right"/>
        <Shape id="line4" linetype="horizontal" class="line_2" position="absolute 770 133 1191 139" anchor="top right"/>
        <Shape id="line17" linetype="horizontal" class="line_2" position="absolute 770 295 1190 301" anchor="top right"/>
        <Shape id="line18" linetype="horizontal" class="line_2" position="absolute 770 355 1190 361" anchor="top right"/>
        <Static id="caption25" text="(물류)물품코드" class="cell_1" position="absolute 770 137 878 162" anchor="top right"/>
        <Static id="caption27" text="비 고" class="cell_1" position="absolute 770 299 878 357" anchor="top right"/>
        <Static id="caption29" text="최초등록일" class="cell_1" position="absolute 770 272 878 297" anchor="top right"/>
        <Calendar id="ipt_frgstdd" taborder="5" class="input_default" position="absolute 881 275 979 294" mask="yyyy-mm-dd" autoselect="true" anchor="top right"/>
        <Shape id="line19" linetype="horizontal" class="line_2" position="absolute 770 160 1190 166" anchor="top right"/>
        <Static id="caption2" text="(물류)물품명" class="cell_1" position="absolute 770 164 878 189" anchor="top right"/>
        <Shape id="line7" linetype="horizontal" class="line_2" position="absolute 770 187 1191 193" anchor="top right"/>
        <Shape id="line20" linetype="horizontal" class="line_2" position="absolute 770 214 1191 220" anchor="top right"/>
        <Static id="caption11" text="규 격" class="cell_1" position="absolute 770 191 878 216" anchor="top right"/>
        <Shape id="line9" linetype="horizontal" class="line_2" position="absolute 770 241 1191 247" anchor="top right"/>
        <Static id="caption8" text="제조회사" class="cell_1" position="absolute 770 218 878 243" anchor="top right"/>
        <Shape id="line10" linetype="horizontal" class="line_2" position="absolute 770 268 1191 274" anchor="top right"/>
        <Static id="caption12" text="주거래처" class="cell_1" position="absolute 770 245 878 270" anchor="top right"/>
        <Button id="btn_prodcmpycd" taborder="6" class="icon_search" position="absolute 935 222 951 238" anchor="top right" onclick="btn_prodcmpycd_onclick"/>
        <Edit id="ipt_prodcmpycd" taborder="7" class="input_default" position="absolute 881 221 931 240" autoselect="true" anchor="top right"/>
        <Edit id="opt_maincustlastsuplplcenm" taborder="8" readonly="true" position="absolute 955 248 1185 267" autoselect="true" anchor="top right" class="output"/>
        <Edit id="ipt_maincustlastsuplplce" taborder="9" class="input_default" position="absolute 881 248 931 267" autoselect="true" anchor="top right"/>
        <Button id="btn_maincustlastsuplplce" taborder="10" class="icon_search" position="absolute 935 249 951 265" anchor="top right" onclick="btn_maincustlastsuplplce_onclick"/>
        <Edit id="opt_goodcd" taborder="11" readonly="true" position="absolute 881 140 974 159" autoselect="true" anchor="top right" class="output"/>
        <Edit id="opt_goodnm" taborder="12" readonly="true" position="absolute 881 167 1186 186" autoselect="true" anchor="top right" class="output"/>
        <Edit id="opt_goodspec" taborder="13" readonly="true" position="absolute 881 193 1186 212" autoselect="true" anchor="top right" class="output"/>
        <TextArea id="ta_cmt" taborder="14" position="absolute 881 301 1186 353" autoselect="true" wordwrap="word" anchor="top right"/>
        <Static id="caption3" text="※ 물류 물품마스터에서 물품코드의 제조회사를 변경하였을 경우, 해당 물품코드가 화학물질코드로 기등록된 것이면 제조회사와 무관하게 위의 목록 상에는 나타나지 않음을 양지하시기 바랍니다." position="absolute 5 746 1055 766" anchor="left right bottom" style="color:#ff0000ff;"/>
        <Edit id="ipt_prodcmpynm" taborder="15" class="input_default" position="absolute 955 221 1185 240" autoselect="true" anchor="top right"/>
        <Button id="btn_excel" taborder="16" text="엑셀출력" class="btn7" position="absolute 689 85 763 104" anchor="top right" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_goodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false" oncolumnchanged="ds_main_goodlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="checkflag" 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"/>
          <Column id="matrnm" type="STRING"/>
          <Column id="prodcmpycd" type="STRING"/>
          <Column id="maincustlastsuplplce" type="STRING"/>
          <Column id="frgstdd" type="STRING"/>
          <Column id="cmt" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_condition" firefirstcount="0" firenextcount="0" useclientlayout="true" 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"/>
      <Dataset id="ds_main_goodinfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="matrnm" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
          <Column id="goodnm" type="STRING" size="256"/>
          <Column id="goodspec" type="STRING" size="256"/>
          <Column id="prodcmpycd" type="STRING" size="256"/>
          <Column id="prodcmpynm" type="STRING" size="256"/>
          <Column id="maincustlastsuplplce" type="STRING" size="256"/>
          <Column id="maincustlastsuplplcenm" type="STRING" size="256"/>
          <Column id="frgstdd" type="STRING" size="256"/>
          <Column id="cmt" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </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"/>
      <BindItem id="item2" compid="ta_cmt" propid="value" datasetid="ds_main_goodinfo" columnid="cmt"/>
      <BindItem id="item3" compid="ipt_frgstdd" propid="value" datasetid="ds_main_goodinfo" columnid="frgstdd"/>
      <BindItem id="item4" compid="ipt_maincustlastsuplplce" propid="value" datasetid="ds_main_goodinfo" columnid="maincustlastsuplplce"/>
      <BindItem id="item5" compid="opt_maincustlastsuplplcenm" propid="value" datasetid="ds_main_goodinfo" columnid="maincustlastsuplplcenm"/>
      <BindItem id="item6" compid="ipt_prodcmpynm" propid="value" datasetid="ds_main_goodinfo" columnid="prodcmpynm"/>
      <BindItem id="item7" compid="ipt_prodcmpycd" propid="value" datasetid="ds_main_goodinfo" columnid="prodcmpycd"/>
      <BindItem id="item8" compid="opt_goodspec" propid="value" datasetid="ds_main_goodinfo" columnid="goodspec"/>
      <BindItem id="item9" compid="opt_goodnm" propid="value" datasetid="ds_main_goodinfo" columnid="goodnm"/>
      <BindItem id="item10" compid="opt_goodcd" propid="value" datasetid="ds_main_goodinfo" columnid="goodcd"/>
      <BindItem id="item11" compid="ipt_matrnm" propid="value" datasetid="ds_main_goodinfo" columnid="matrnm"/>
    </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 SMRSM00500_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRSM00500_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_goodlist);
	grdf_setRowTypeIcon(grd_goodlist, 0);
	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_main_goodlist.clearData();	//조회시 기존 데이터 삭제								
	
	ds_send.copyData(ds_main_condition);
	
	var oParam = {};
		oParam.id          = "TRRSM00501";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetMsdsGoodList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_goodlist=goodlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSM00501";
	tranf_submit(oParam);
	
	
}

function grd_goodlist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	if(ds_main_goodlist.rowcount == 0 || e.col < 1) return;
	
	if( !utlf_isNull(opt_goodcd.value))
	{
		fPutGoodInfo();
	}	

	var cur_row = ds_main_goodlist.rowposition;
	fGetGoodInfo(cur_row);
}

//상세내역 -> 목록
function fPutGoodInfo()
{
	
	if( true )
	{		
		var iRow = ds_main_goodlist.findRow("goodcd", opt_goodcd.value);
		ds_main_goodlist.enableevent = false;
		ds_main_goodlist.updatecontrol = false;
		ds_main_goodlist.setColumn(iRow, "matrnm", String(utlf_transNullToEmpty(ipt_matrnm.value)).replace("\n", ""));
		ds_main_goodlist.setColumn(iRow, "prodcmpycd", utlf_trim(utlf_transNullToEmpty(ipt_prodcmpycd.value)));
		ds_main_goodlist.setColumn(iRow, "prodcmpynm", utlf_transNullToEmpty(ipt_prodcmpynm.value));
		ds_main_goodlist.setColumn(iRow, "maincustlastsuplplce", utlf_trim(utlf_transNullToEmpty(ipt_maincustlastsuplplce.value)));
		ds_main_goodlist.setColumn(iRow, "maincustlastsuplplcenm", utlf_transNullToEmpty(opt_maincustlastsuplplcenm.value));
		ds_main_goodlist.setColumn(iRow, "frgstdd", utlf_transNullToEmpty(ipt_frgstdd.value));
		ds_main_goodlist.setColumn(iRow, "cmt", utlf_transNullToEmpty(ta_cmt.value));
		ds_main_goodlist.updatecontrol = true;
		ds_main_goodlist.enableevent = true;		
	}
}

//목록 -> 상세내역
function fGetGoodInfo(pRow)
{					
	if ( pRow >= 0 )
	{
		ds_main_goodinfo.copyRow(0, ds_main_goodlist, pRow);						
	}
}

//일괄등록
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	fClickSaveBtn();
}

// 저장버튼 클릭시 저장 수행 함수
function fClickSaveBtn()
{
	var iCheckCount = 0;
	for(var i = 0; i < ds_main_goodlist.rowcount; i++)
	{
		if(ds_main_goodlist.getColumn(i, "checkflag") == "Y")
		{
			iCheckCount = 1;
			break;
		}	
	}	
	if(iCheckCount == 0)
	{
		sysf_messageBox("선택된 물품이 없습니다. 먼저 코드 등록할 물품을 선택하십시요. ", "E999", "");
		return false;
	}	
	
	if( !utlf_isNull(opt_goodcd.value))
	{
		fPutGoodInfo();
	}	
	
	
	if(!fIsValidForSave())		//저장전 유효성 검사
	{
		return;
	}
	
	//model.makeValue("/root/send/goodlist", grd_goodlist.getUpdateData());
	
	
	var oParam = {};
		oParam.id          = "TXRSM00501";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqExeSaveMsdsGood";
		oParam.inds        = "goodlist=ds_main_goodlist:U";
		oParam.async       = false;
		oParam.callback    = "cf_TXRSM00501";
	tranf_submit(oParam);
}

function cf_TXRSM00501(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) return;
    else
    {
		sysf_messageBox("정상적으로 처리되었습니다. .", "I999", "");	
		
		fGetGoodList(); //등록 후 재조회
    }
}

function ds_main_goodlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "checkflag")
	{
		obj.setColumn(e.row, "checkflag", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
	}
}

function btn_prodcmpycd_onclick(obj:Button,  e:ClickEventInfo)
{
	rszfOpenPopUpListByWndName(ipt_prodcmpycd,"","prodcmpycd,prodcmpynm","SPRSD00160","","");
}

function btn_maincustlastsuplplce_onclick(obj:Button,  e:ClickEventInfo)
{
	rszfOpenPopUpListByWndName(ipt_maincustlastsuplplce,"","maincustlastsuplplce,maincustlastsuplplcenm","SPRSD00220");
}

//저장전 유효성 검사
function fIsValidForSave()
{
	for(var i = 0; i < ds_main_goodlist; i++)
	{
		if(ds_main_goodlist.getColumn(i, "checkflag") == "N")	continue;
	
		if( utlf_isNull(ds_main_goodlist.getColumn(i, "matrnm")))
		{
			sysf_messageBox("물품코드 " + ds_main_goodlist.getColumn(i, "goodcd") + " 의 물질명이 등록되지 않았습니다. ", "E999", "");
			return false;
		}
	}
	return true;
}

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