YNU_JEUS/app_home/himed/xpapps/pam/edimngtxp/xp/SPPIE00130_입고내역조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="workform" position="absolute 0 0 1000 602" titletext="입고내역조회" class="frm_POP" onload="workform_onload">
    <Layouts>
      <Layout>
        <Div id="group2" position="absolute 12 46 988 88" anchor="left top right" positiontype="position" class="div_SA">
          <Layouts>
            <Layout>
              <Button id="btn_srch" class="btn1" taborder="4" position="absolute 916 10 972 30" anchor="top right" text="조회" onclick="btn_srch_onclick" positiontype="position"/>
              <Shape id="line13" class="line_4" position="absolute 879 10 879 32" anchor="default" linetype="vertical" positiontype="position"/>
              <Edit id="ipt_srchcond2" class="input_search" taborder="3" position="absolute 469 10 564 30" anchor="left top" positiontype="position"/>
              <Radio id="rdo_srchcond1" columncount="4" rowcount="1" position="absolute 322 10 466 30" anchor="left top" onclick="rdo_srchcond1_onclick" codecolumn="codecolumn" datacolumn="datacolumn" positiontype="position" value="1" index="0" onitemchanged="group2_rdo_srchcond1_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">EDI</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">처방코드</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Static id="caption6" class="search_name" position="absolute 8 11 82 28" anchor="left top" text="입고일자" positiontype="position"/>
              <CheckBox id="chk_exp" visible="false" position="absolute 567 10 700 30" anchor="left top" text="EDI코드 적용일 제외" truevalue="Y" falsevalue="" positiontype="position"/>
              <CheckBox id="chk_dtl" visible="false" position="absolute 700 10 820 30" anchor="left top" text="입고상세조회여부" truevalue="Y" falsevalue="N" positiontype="position"/>
              <cp_periodCal id="cp_periodCal00" titletext="Period Calendar" taborder="5" text="cp_periodCal00" scrollbars="none" position="absolute 82 10 298 30" style="background:transparent; " anchor="left top"/>
              <CheckBox id="checkbox3" taborder="6" text="이송입고포함" position="absolute 821 9 921 29" truevalue="Y" anchor="left top" falsevalue="N"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption3" text="(실제 입고한 내역 조회결과)" position="absolute 91 95 251 115" style="color:#ff6600ff;"/>
        <Static id="caption2" text="입고내역" class="tit_2" position="absolute 12 98 91 118"/>
        <Grid id="grd_purcdetl" class="datagrid2" taborder="2" useinputpanel="false" position="absolute 12 118 988 567" anchor="all" binddataset="ds_grid_grd_purcdetl">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="25"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="168"/>
                <Column size="50"/>
                <Column size="51"/>
                <Column size="80"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="102"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="120"/>
                <Column size="100"/>
              </Columns>
              <Rows>
                <Row size="35" band="head"/>
                <Row size="23"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" text="C"/>
                <Cell col="2" text="EDI코드"/>
                <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="입출고유형"/>
                <Cell col="12" text="제조(수입)회사"/>
                <Cell col="13" text="구입기관&#10;사업자번호"/>
                <Cell col="14" text="구입기관&#10;사업자명"/>
                <Cell col="15" text="견적단가"/>
                <Cell col="16" text="비고"/>
                <Cell col="17" text="발주일자"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" style="align:left middle;" text="bind:chk" expr="expr:chk == 'true' || chk == '1' ? 1 : 0"/>
                <Cell col="2" style="align:left middle;" text="bind:edicd"/>
                <Cell col="3" style="align:left middle;" text="bind:goodcd"/>
                <Cell col="4" style="align:left middle;" text="bind:goodhngnm"/>
                <Cell col="5" style="align:right middle;" text="bind:spec"/>
                <Cell col="6" style="align:right middle;" text="bind:unit"/>
                <Cell col="7" style="align:center middle;" text="bind:windd" mask="####-##-##"/>
                <Cell col="8" style="align:right middle;" text="bind:winqty" mask="#,###"/>
                <Cell col="9" style="align:right middle;" text="bind:winunitcost" mask="#,###"/>
                <Cell col="10" style="align:right middle;" text="bind:winamt" mask="#,###"/>
                <Cell col="11" displaytype="combo" style="align:center;" text="bind:iokind" combodataset="ds_init_PK262" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="12" style="align:left middle;" text="bind:makecmpynm"/>
                <Cell col="13" style="align:left middle;" text="bind:makecmpycd"/>
                <Cell col="14" style="align:left middle;" text="bind:cmpynm"/>
                <Cell col="15" style="align:right middle;" text="bind:estmamt" mask="#,###"/>
                <Cell col="16" style="align:left middle;" text="bind:rem"/>
                <Cell col="17" style="align:center middle;" text="bind:purcdmnddd" mask="####-##-##"/>
                <Cell col="18"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption00" text="입고내역조회" class="sta_POP_title" position="absolute 12 8 161 28"/>
        <Button id="Button00" taborder="3" class="btn_POP_cls" position="absolute 974 12 988 25" anchor="top right" onclick="Button00_onclick"/>
        <Button id="btn_judgdiag" taborder="4" text="입고내역선택" onlbuttonup="btn_judgdiag_onlbuttonup" class="btn4" position="absolute 884 570 988 590" anchor="right bottom" onclick="btn_judgdiag_onclick"/>
        <Button id="button7" taborder="5" text="엑셀" onclick="group3_button7_onclick" class="btn7" position="absolute 936 98 987 117" anchor="top right"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_temp_grd_purcdetl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="appno" type="STRING"/>
          <Column id="edicd" type="STRING"/>
          <Column id="goodcd" type="STRING"/>
          <Column id="itemnm" type="STRING"/>
          <Column id="spec" type="STRING"/>
          <Column id="unit" type="STRING"/>
          <Column id="entrregno" type="STRING"/>
          <Column id="custnm" type="STRING"/>
          <Column id="purcdmnddd" type="STRING"/>
          <Column id="oneunitcost" type="STRING"/>
          <Column id="insubrpnt" type="STRING"/>
          <Column id="status" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_grid_grd_purcdetl" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false" oncolumnchanged="ds_grid_grd_purcdetl_oncolumnchanged">
        <ColumnInfo>
          <column id="chk" type="string"/>
          <column id="edicd" type="string"/>
          <column id="goodcd" type="string"/>
          <column id="goodhngnm" type="cdata"/>
          <column id="spec" type="string"/>
          <column id="unit" type="string"/>
          <column id="windd" type="string"/>
          <column id="winqty" type="string"/>
          <column id="winunitcost" type="string"/>
          <column id="winamt" type="string"/>
          <column id="makecmpycd" type="string"/>
          <column id="makecmpynm" type="string"/>
          <column id="cmpyno" type="string"/>
          <column id="cmpynm" type="string"/>
          <column id="estmamt" type="string"/>
          <column id="rem" type="cdata"/>
          <column id="purcdmnddd" type="string"/>
          <Column id="iokind" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_rslt_sppie00130_h802" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptcd" type="STRING" size="256"/>
          <Column id="itemflagno" type="STRING" size="256"/>
          <Column id="makecmpynm" type="STRING" size="256"/>
          <Column id="item" type="STRING" size="256"/>
          <Column id="spec" type="STRING" size="256"/>
          <Column id="unit" type="STRING" size="256"/>
          <Column id="lnnoremark" type="STRING" size="256"/>
          <Column id="avg" type="STRING" size="256"/>
          <Column id="fstpurcflag" type="STRING" size="256"/>
          <Column id="calcscorcd" type="STRING" size="256"/>
          <Column id="edicd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_rslt_sppie00130_h803" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="reptcd" type="STRING" size="256"/>
          <Column id="lnno" type="STRING" size="256"/>
          <Column id="cmpyno" type="STRING" size="256"/>
          <Column id="cmpynm" type="STRING" size="256"/>
          <Column id="purcdd" type="STRING" size="256"/>
          <Column id="purcqty" type="STRING" size="256"/>
          <Column id="purcunitcost" type="STRING" size="256"/>
          <Column id="purctotamt" type="STRING" size="256"/>
          <Column id="cmpyremark" type="STRING" size="256"/>
          <Column id="itemflaglnkno" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_PK262" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-10-07
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-10-07      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";
include 'pam_pamcomnxp::PAM001.xjs';

function workform_onload(obj:Form, e:LoadEventInfo)
{
	frmf_initForm(obj);  // 화면공통
	grdf_initGrid(grd_purcdetl); 
	grdf_setToolTipBind(grd_purcdetl);	
	
	var arrParam = new Array();
	arrParam = [{dsNm: "ds_init_PK262", cdGrpId: "PK262", showValue: false}];
	pamfGetCodeList(arrParam, true, "");

	if(frmf_checkOpener()) {
		try {
			ds_send.copyData(args_ds_cond_sppie00130_h802);
			
			group2.cp_periodCal00.cal_from.value = ds_send.getColumn(0,"fromdd");
			group2.cp_periodCal00.cal_to.value = ds_send.getColumn(0,"todd");
			group2.rdo_srchcond1.value = ds_send.getColumn(0,"srchcond1");
			group2.ipt_srchcond2.value = ds_send.getColumn(0,"srchcond2");
			group2.ipt_srchcond2.value = ds_send.getColumn(0,"srchcond2");
			group2.chk_dtl.value = ds_send.getColumn(0,"dtlselectyn");
			group2.checkbox3.value =  ds_send.getColumn(0,"iokindyn");
			
			if (!utlf_isNull(group2.rdo_srchcond1.value) || !utlf_isNull(group2.ipt_srchcond2.value)) {
				var Date = new Array(2);
				Date = group2.cp_periodCal00.getData();

				var sInDs = dsf_createDsRow("ds_search"
								,[{col: "fromdd"	, val: Date[0] }
								, {col: "todd"		, val: Date[1] }
								, {col: "srchcond1"	, val: group2.rdo_srchcond1.value }
								, {col: "srchcond2"	, val: group2.ipt_srchcond2.value }
								, {col: "exceptfromdd"	, val: "" } // 적용일제외
								, {col: "offset"	, val: "0" }  //시작번호
								, {col: "pagesize"	, val: "10000" }  //페이지
								, {col: "iokindyn"	, val: group2.checkbox3.value }  //페이지
								]);

				var oParam = {};
					oParam.id          = "TRPIE00130";
					oParam.service     = "edimngtapp.EdiMngt";
					oParam.method      = "reqGetRsihinptByMis";
					oParam.inds        = "req="+sInDs;
					oParam.outds       = "ds_grid_grd_purcdetl=gridpurcdetl";
					oParam.async       = true;
					oParam.progress    = false;
					oParam.callback    = "cf_TRPIE00130";

				tranf_submit(oParam);
				
				grd_purcdetl.nodatatext = "조회중입니다...";
			}
			
		} catch(e){
			group2.cp_periodCal00.cal_from.value = utlf_getCurrentDate();
			group2.cp_periodCal00.cal_to.value = utlf_getCurrentDate();
			group2.rdo_srchcond1.value = 1;
		}
	} 
	
	
}

function btn_judgdiag_onlbuttonup(obj:Button, e:MouseEventInfo)
{					
	
	ds_rslt_sppie00130_h802.clearData();
	ds_rslt_sppie00130_h803.clearData();

	var max = 1;
	var oldedicd = "";
	var edicd = ""

	for (var iRow = 0; iRow < ds_grid_grd_purcdetl.rowcount; iRow++) {
		edicd = ds_grid_grd_purcdetl.getColumn(iRow, "edicd");
		if (ds_grid_grd_purcdetl.getColumn(iRow, "chk") == "true" && edicd != oldedicd) {
			max = ds_rslt_sppie00130_h802.addRow();
			ds_rslt_sppie00130_h802.setColumn(max, "reptcd", ds_grid_grd_purcdetl.getColumn(iRow, "edicd"));
			ds_rslt_sppie00130_h802.setColumn(max, "itemflagno", "");
			ds_rslt_sppie00130_h802.setColumn(max, "makecmpynm", ds_grid_grd_purcdetl.getColumn(iRow, "makecmpynm"));
			ds_rslt_sppie00130_h802.setColumn(max, "item", ds_grid_grd_purcdetl.getColumn(iRow, "goodhngnm"));
			ds_rslt_sppie00130_h802.setColumn(max, "spec", ds_grid_grd_purcdetl.getColumn(iRow, "spec"));
			ds_rslt_sppie00130_h802.setColumn(max, "unit", ds_grid_grd_purcdetl.getColumn(iRow, "unit"));
			ds_rslt_sppie00130_h802.setColumn(max, "lnnoremark", "");
			ds_rslt_sppie00130_h802.setColumn(max, "avg", ds_grid_grd_purcdetl.getColumn(iRow, "edicd"));
			ds_rslt_sppie00130_h802.setColumn(max, "fstpurcflag", "B");
			ds_rslt_sppie00130_h802.setColumn(max, "calcscorcd", ds_grid_grd_purcdetl.getColumn(iRow, "goodcd"));
			
			oldedicd = ds_grid_grd_purcdetl.getColumn(iRow, "edicd");
		}
	}
	
	for (var iRow = 0; iRow < ds_grid_grd_purcdetl.rowcount; iRow++) {
		if (ds_grid_grd_purcdetl.getColumn(iRow, "chk") == "true") {
			max = ds_rslt_sppie00130_h803.addRow();
			ds_rslt_sppie00130_h803.setColumn(max, "reptcd", ds_grid_grd_purcdetl.getColumn(iRow, "edicd"));
			ds_rslt_sppie00130_h803.setColumn(max, "lnno", "");
			ds_rslt_sppie00130_h803.setColumn(max, "cmpyno", ds_grid_grd_purcdetl.getColumn(iRow, "cmpyno"));
			ds_rslt_sppie00130_h803.setColumn(max, "cmpynm", ds_grid_grd_purcdetl.getColumn(iRow, "cmpynm"));
			ds_rslt_sppie00130_h803.setColumn(max, "purcdd", ds_grid_grd_purcdetl.getColumn(iRow, "windd"));
			ds_rslt_sppie00130_h803.setColumn(max, "purcqty", ds_grid_grd_purcdetl.getColumn(iRow, "winqty"));
			ds_rslt_sppie00130_h803.setColumn(max, "purcunitcost", ds_grid_grd_purcdetl.getColumn(iRow, "winunitcost"));
			ds_rslt_sppie00130_h803.setColumn(max, "purctotamt", ds_grid_grd_purcdetl.getColumn(iRow, "winamt"));
			ds_rslt_sppie00130_h803.setColumn(max, "cmpyremark", "");
			ds_rslt_sppie00130_h803.setColumn(max, "itemflaglnkno", "");					
		}
	}
	opener.ds_rslt_sppie00130_h802.clearData();
	opener.ds_rslt_sppie00130_h803.clearData();
	
	opener.ds_rslt_sppie00130_h802.copyData(ds_rslt_sppie00130_h802);
	opener.ds_rslt_sppie00130_h803.copyData(ds_rslt_sppie00130_h803);

	this.close();
					
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : btn_srch
 * Event 		    : onclick
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function btn_srch_onclick(obj:Button, e:ClickEventInfo)
{


	if( utlf_isNull(group2.cp_periodCal00.getData()) ) {
		sysf_messageBox("입고일자", "C001");
		group2.cp_periodCal00.setFocus();
		return true;
	}

	if( utlf_isNull(group2.ipt_srchcond2.value) ) {
		sysf_messageBox("EDI코드나 처방코드를", "C001");
		group2.ipt_srchcond2.setFocus();
		return true;
	}

	ds_grid_grd_purcdetl.clearData();

	var Date = new Array(2);
	Date = group2.cp_periodCal00.getData();
	

	var sInDs = dsf_createDsRow("ds_search"
					,[{col: "fromdd"	, val: Date[0] }
					, {col: "todd"		, val: Date[1] }
					, {col: "srchcond1"	, val: group2.rdo_srchcond1.value }
					, {col: "srchcond2"	, val: group2.ipt_srchcond2.value }
					, {col: "exceptfromdd"	, val: "" } // 적용일제외
					, {col: "offset"	, val: "0" }  //시작번호
					, {col: "pagesize"	, val: "10000" }  //페이지
					, {col: "iokindyn"	, val: group2.checkbox3.value }  //이송입고포함여부
					]);
	
	var oParam = {};
		oParam.id          = "TRPIE00130";
		oParam.service     = "edimngtapp.EdiMngt";
		oParam.method      = "reqGetRsihinptByMis";
		oParam.inds        = "req="+sInDs;
		oParam.outds       = "ds_grid_grd_purcdetl=gridpurcdetl";
		oParam.async       = true;
		oParam.progress    = false;
		oParam.callback    = "cf_TRPIE00130";

	tranf_submit(oParam);
	
	grd_purcdetl.nodatatext = "조회중입니다...";
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : rdo_srchcond1
 * Event 		    : onclick
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function rdo_srchcond1_onclick(obj:Radio, e:ClickEventInfo)
{
						model.resetInstanceNode("/root/send/srchcond2");
						model.setFocus("ipt_srchcond2");
						model.refresh();
					
}

/****************************************************************************************
 * Components	    : 
 * Components ID  : ipt_fromdd
 * Event 		    : onmouseleave
 * Argument		: 01.obj	: Object Event has occurred
 *				: 02.e		: Event Object
 * Description	: 
 ****************************************************************************************/
function ipt_fromdd_onmouseleave(obj:Calendar, e:MouseEventInfo)
{
							//ipt_todd.value = ipt_fromdd.value;
						
}

function Button00_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}



function ds_grid_grd_purcdetl_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if( e.columnid == "chk" ){
		obj.setColumn(e.row, "chk", (e.newvalue == "true" || e.newvalue == 1) ? "true" : "false");
	}
}

function group3_button7_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_grid_grd_purcdetl.rowcount > 0) {
		grdf_exportExcel(grd_purcdetl,"입고세부내역","sheet1");
	} else {
		sysf_messageBox("조회된 데이터가 ", "I004");
	}
}

function cf_TRPIE00130(sSvcId, nErrorCode, sErrorMsg) {
    if(nErrorCode < 0) return;
    
    grd_purcdetl.nodatatext = "";
}
function group2_rdo_srchcond1_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	group2.ipt_srchcond2.value = "";
	group2.ipt_srchcond2.setFocus();
}
]]></Script>
  </Form>
</FDL>