YNU_JEUS/app_home/himed/xpapps/mis/reqxp/xp/SMRSD10200_부가가치세 물품내역 조회(경북대).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSD10200" position="absolute 0 0 1204 780" titletext="부가가치세 집계물품내역 조회" oninit="SMRSD10200_oninit" onload="SMRSD10200_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="부가가치세 집계물품내역 조회" class="tit_1" position="absolute 0 0 273 25"/>
        <Shape id="line17" class="line_6" position="absolute 0 47 1195 53" anchor="left top right"/>
        <Button id="button2" taborder="1" text="미리보기" class="btn6" visible="false" position="absolute 60 26 140 48"/>
        <Button id="button8" taborder="2" text="출력" class="btn6" visible="false" position="absolute 0 26 56 48"/>
        <Div id="group6" anchor="left top right" taborder="3" class="div_SA2" position="absolute 0 51 1195 111">
          <Layouts>
            <Layout>
              <Shape id="line2" linetype="vertical" class="line_4" position="absolute 1097 9 1103 52" anchor="top right"/>
              <Static id="caption5" text="발생일자 :" class="search_name" position="absolute 360 9 461 26"/>
              <Static id="cap_goodcdA" text="물품코드 :" class="search_name" position="absolute 360 35 459 52"/>
              <Button id="btn_search" taborder="20" text="조회" class="btn1" position="absolute 1115 19 1171 41" anchor="top right" onclick="group6_btn_search_onclick"/>
              <Static id="cap_goodcdB" text="약품코드 :" class="search_name" visible="false" position="absolute 360 35 459 52"/>
              <Static id="caption2" text="집계구분 :" class="search_name" position="absolute 20 35 105 52"/>
              <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 20 10 106 27"/>
              <Edit id="opt_instcd" taborder="21" readonly="true" visible="false" position="absolute 10 8 40 27" class="output"/>
              <Edit id="opt_instcdnm" taborder="22" readonly="true" autoselect="true" autoskip="true" position="absolute 892 9 1072 28" class="output"/>
              <Calendar id="ipt_srchfromdd" taborder="23" autoselect="true" autoskip="true" class="input_essential" position="absolute 452 9 552 28"/>
              <Static id="caption11" text="~" class="search_no_b" position="absolute 555 12 567 29"/>
              <Calendar id="ipt_srchtodd" taborder="24" autoselect="true" autoskip="true" class="input_essential" position="absolute 570 9 670 28"/>
              <Radio id="rdo_goodflag" taborder="25" columncount="2" rowcount="0" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 108 33 208 53" onitemchanged="group6_rdo_goodflag_onitemchanged">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">A</Col>
                      <Col id="datacolumn">재료</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">B</Col>
                      <Col id="datacolumn">약품</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
              <Edit id="ipt_goodcd" taborder="26" autoselect="true" autoskip="true" class="input_search" position="absolute 452 34 597 53" onkeyup="group6_ipt_goodcd_onkeyup"/>
              <Static id="caption1" text="거래처 :" class="search_name" position="absolute 720 11 795 28"/>
              <Edit id="ipt_suplplcecd" taborder="27" autoselect="true" autoskip="true" class="input_search" position="absolute 800 9 865 28" onkeydown="group6_ipt_suplplcecd_onkeydown"/>
              <Button id="btn_suplplcecd" taborder="28" class="icon_search" position="absolute 870 12 886 28" onclick="group6_btn_suplplcecd_onclick"/>
              <Edit id="opt_suplplcenm" taborder="29" readonly="true" autoselect="true" autoskip="true" position="absolute 101 9 256 28" class="output"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_addtaxsumgoodlist" class="datagrid2" taborder="4" binddataset="ds_main_list_addtaxsumgoodinfo_addtaxsumgoodlist" autoenter="select" useinputpanel="false" cellsizingtype="col" position="absolute 0 143 1195 774" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="21" band="left"/>
                <Column size="100"/>
                <Column size="113"/>
                <Column size="258"/>
                <Column size="136"/>
                <Column size="94"/>
                <Column size="0"/>
                <Column size="100"/>
                <Column size="64"/>
                <Column size="63"/>
                <Column size="91"/>
                <Column size="91"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="82"/>
                <Column size="75"/>
                <Column size="55"/>
              </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="금액"/>
                <Cell col="12" text="금액(부가세적용)"/>
                <Cell col="13" text="원무부가세"/>
                <Cell col="14" text="구매집계여부"/>
                <Cell col="15" text="품의일자"/>
                <Cell col="16" text="품의번호"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" displaytype="date" text="bind:genrdd" calendardisplaynulltype="nulltext"/>
                <Cell col="2" text="bind:goodcd"/>
                <Cell col="3" style="align:left middle;padding:0 0 0 3;" text="bind:goodnm"/>
                <Cell col="4" style="align:left middle;padding:0 0 0 3;" text="bind:goodspec"/>
                <Cell col="5" style="align:left middle;padding:0 0 0 3;" text="bind:goodmodel"/>
                <Cell col="6" text="bind:cnts"/>
                <Cell col="7" style="align:left middle;padding:0 0 0 3;" text="bind:suplplcenm" wordwrap="word"/>
                <Cell col="8" text="bind:costconyn"/>
                <Cell col="9" displaytype="number" text="bind:totsumqty"/>
                <Cell col="10" displaytype="number" text="bind:goodunitcost"/>
                <Cell col="11" displaytype="number" text="bind:totsumamt"/>
                <Cell col="12" text="bind:totsumamttax"/>
                <Cell col="13" text="bind:totsumamtpamtax"/>
                <Cell col="14" text="bind:purcflag"/>
                <Cell col="15" displaytype="date" text="bind:purccnsttndd" calendardisplaynulltype="nulltext"/>
                <Cell col="16" text="bind:purccnsttnno"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption35" text="부가가치세 집계물품내역" class="tit_2" position="absolute 0 122 185 143"/>
        <Shape id="line15" linetype="horizontal" class="line_10" position="absolute 0 137 1195 146"/>
        <MaskEdit id="opt_totalsumamt" taborder="5" readonly="true" mask="#,###" class="output_default" position="absolute 910 118 1020 137" style="align:left middle;font:Dotum,9,bold;"/>
        <Static id="caption39" text="총 금액 :" class="tit_2" position="absolute 832 120 912 141"/>
        <Button id="button1" taborder="6" text="Excel 저장" class="btn5" position="absolute 1120 119 1195 138" anchor="top right" onclick="button1_onclick"/>
        <MaskEdit id="opt_totalsumqty" taborder="7" readonly="true" mask="#,###" class="output_default" position="absolute 770 118 825 137" style="align:left middle;font:Dotum,9,bold;"/>
        <Static id="caption3" text="총 수량 :" class="tit_2" position="absolute 692 120 772 141"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_cond_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="instnm" type="STRING" size="256"/>
          <Column id="srchfromdd" type="STRING" size="256"/>
          <Column id="srchtodd" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
          <Column id="suplplcecd" type="STRING" size="256"/>
          <Column id="suplplcenm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="instnm"/>
            <Col id="srchfromdd"/>
            <Col id="srchtodd"/>
            <Col id="goodflag">A</Col>
            <Col id="goodcd"/>
            <Col id="suplplcecd"/>
            <Col id="suplplcenm"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_addtaxsumgoodinfo_addtaxsumgoodlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="genrdd" type="STRING" size="256" sumtext="발생일자"/>
          <Column id="goodcd" type="STRING" size="256" sumtext="물품(약품)코드"/>
          <Column id="goodnm" type="STRING" size="256" sumtext="물품(약품)명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
          <Column id="goodmodel" type="STRING" size="256" sumtext="모델"/>
          <Column id="totsumqty" type="STRING" size="256" sumtext="총수량"/>
          <Column id="goodunitcost" type="STRING" size="256" sumtext="단가"/>
          <Column id="totsumamt" type="FLOAT" size="256" sumtext="금액"/>
          <Column id="totsumamttax" type="FLOAT" size="256" sumtext="금액(부가세적용)"/>
          <Column id="totsumamtpamtax" type="FLOAT" size="256" sumtext="원무(부가세적용)"/>
          <Column id="cnts" type="STRING" size="256" sumtext="함량"/>
          <Column id="suplplcecd" type="STRING" size="256" sumtext="거래처코드"/>
          <Column id="suplplcenm" type="STRING" size="256" sumtext="거래처명"/>
          <Column id="costconyn" type="STRING" size="256" sumtext="단가계약여부"/>
          <Column id="purcflag" type="STRING" size="256" sumtext="구매집계여부"/>
          <Column id="purccnsttndd" type="STRING" size="256" sumtext="품의일자"/>
          <Column id="purccnsttnno" type="STRING" size="256" sumtext="품의번호"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="totalsumqty" type="FLOAT" size="256"/>
          <Column id="totalsumamt" type="FLOAT" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="totalsumqty"/>
            <Col id="totalsumamt"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_main_reqcustomlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group6.opt_instcd" propid="value" datasetid="ds_cond" columnid="instcd"/>
      <BindItem id="item1" compid="group6.opt_suplplcenm" propid="value" datasetid="ds_cond" columnid="instnm"/>
      <BindItem id="item2" compid="group6.ipt_srchfromdd" propid="value" datasetid="ds_cond" columnid="srchfromdd"/>
      <BindItem id="item3" compid="group6.ipt_srchtodd" propid="value" datasetid="ds_cond" columnid="srchtodd"/>
      <BindItem id="item4" compid="group6.ipt_suplplcecd" propid="value" datasetid="ds_cond" columnid="suplplcecd"/>
      <BindItem id="item5" compid="group6.opt_instcdnm" propid="value" datasetid="ds_cond" columnid="suplplcenm"/>
      <BindItem id="item6" compid="group6.rdo_goodflag" propid="value" datasetid="ds_cond" columnid="goodflag"/>
      <BindItem id="item7" compid="group6.ipt_goodcd" propid="value" datasetid="ds_cond" columnid="goodcd"/>
      <BindItem id="item8" compid="opt_totalsumqty" propid="value" datasetid="ds_init" columnid="totalsumqty"/>
      <BindItem id="item9" compid="opt_totalsumamt" propid="value" datasetid="ds_init" columnid="totalsumamt"/>
    </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::RSZ001.xjs";

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

function SMRSD10200_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_addtaxsumgoodlist);
	
	fInitialize();	
}

function fInitialize() 
{	
	misfGridInit(grd_addtaxsumgoodlist);			
	var curdate = utlf_getCurrentDate();
	var cvtdate = curdate.toDate("YYYYMMDD");
	
	ds_cond.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_cond.setColumn(0, "instnm", sysf_getUserInfo("dutplceinstnm"));
	
	group6.ipt_srchfromdd.value = cvtdate.getAddDate(-1,"D").getDateFormat("YYYYMMDD");
	group6.ipt_srchtodd.value = curdate;
}

function ds_cond_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "suplplcecd")
	{
		var objFocus = this.getFocus();
		group6.ipt_suplplcecd.value = e.newvalue;
		group6.ipt_suplplcecd.setFocus();
		
		if(String(e.newvalue).length == 0) 
		{
			group6.opt_suplplcenm.value = "";
		}
		else
		{
			rszfValidationCheck("TRRSD00221", "reqcustomlist", "instcd,refcond,retrnm", 
							group6.opt_instcd.value +",," + e.newvalue ,"","suplplcecd,suplplcenm" ,
							group6.ipt_suplplcecd,"SPRSD00220","instcd","group6.opt_instcd");
			if(!utlf_isNull(ds_init_main_reqcustomlist.getColumn(0, "custcode")))
			{
				group6.ipt_suplplcecd.value = ds_init_main_reqcustomlist.getColumn(0, "custcode");
			}
		}
		
		objFocus.setFocus();
	}
}

function group6_btn_suplplcecd_onclick(obj:Button,  e:ClickEventInfo)
{
	rszfOpenPopUpListByWndName(group6.ipt_suplplcecd,"","suplplcecd,suplplcenm","SPRSD00220","instcd","group6.opt_instcd");
}

function group6_rdo_goodflag_onitemchanged(obj:Radio, e:ItemChangeEventInfo)
{
	if(obj.value== "A")
	{
		group6.cap_goodcdA.visible = true;
		group6.cap_goodcdB.visible = false;
	}
	else
	{
		group6.cap_goodcdA.visible = false;
		group6.cap_goodcdB.visible = true;
	}
}

function group6_ipt_goodcd_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
		group6.btn_search.click();
	}
}

function group6_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRSD10201";
		oParam.service     = "reqapp.ReqMngt";
		oParam.method      = "reqGetAddTaxSumGoodInfo";
		oParam.inds        = "cond=ds_cond";
		oParam.outds       = "ds_main_list_addtaxsumgoodinfo_addtaxsumgoodlist=addtaxsumgoodlist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRSD10201";

	tranf_submit(oParam);
}

function cf_TRRSD10201(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		fGridChange();
		
		var totalSumQty = 0;
		var totalSumAmt = 0;							
		for(var i = 0; i < ds_main_list_addtaxsumgoodinfo_addtaxsumgoodlist.rowcount; i++ )
		{
			totalSumQty += parseFloat(ds_main_list_addtaxsumgoodinfo_addtaxsumgoodlist.getColumn(i, "totsumqty"));
			totalSumAmt += parseFloat(ds_main_list_addtaxsumgoodinfo_addtaxsumgoodlist.getColumn(i, "totsumamt"));
		}
		ds_init.setColumn(0, "totalsumqty", totalSumQty);
		ds_init.setColumn(0, "totalsumamt", totalSumAmt);
	}
}

function fGridChange()
{
	if(group6.rdo_goodflag.value == "A")
	{
		grd_addtaxsumgoodlist.setCellProperty("Head", 2, "text", "물품코드");
		grd_addtaxsumgoodlist.setCellProperty("Head", 3, "text", "물품명");
		
		grd_addtaxsumgoodlist.setFormatColProperty(4, "size", 136);
		grd_addtaxsumgoodlist.setFormatColProperty(5, "size", 94);
		grd_addtaxsumgoodlist.setFormatColProperty(6, "size", 0);
		grd_addtaxsumgoodlist.setFormatColProperty(8, "size", 64);
	}
	else
	{
		grd_addtaxsumgoodlist.setCellProperty("Head", 2, "text", "약품코드");
		grd_addtaxsumgoodlist.setCellProperty("Head", 3, "text", "약품명");
		
		grd_addtaxsumgoodlist.setFormatColProperty(4, "size", 0);
		grd_addtaxsumgoodlist.setFormatColProperty(5, "size", 0);
		grd_addtaxsumgoodlist.setFormatColProperty(6, "size", 94);
		grd_addtaxsumgoodlist.setFormatColProperty(8, "size", 0);
	}
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_addtaxsumgoodlist, "부가가치세 집계물품내역", "Sheet1", "true", "", "");
}

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