YNU_JEUS/app_home/himed/xpapps/mis/delivexp/xp/SMRSO20700_월 재고수불장(부서재고)(경북대).xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSO20700" position="absolute 0 0 1200 699" titletext="월 재고수불장(부서재고)" oninit="SMRSO20700_oninit" onload="SMRSO20700_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="월 재고수불장(부서재고)" class="tit_1" position="absolute 0 0 243 25"/>
        <Div id="grp_search" taborder="1" class="div_SA" position="absolute 0 25 1195 65">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="7" text="조회" class="btn1" position="absolute 1129 9 1185 31" anchor="default" onclick="grp_search_btn_search_onclick"/>
              <Combo id="cmb_instcd" taborder="8" innerdataset="@ds_main_init" codecolumn="cnstcd" datacolumn="cnstnm" class="combo_default" enable="false" position="absolute 69 11 205 30" anchor="default"/>
              <Static id="cap_instcd" text="기관:" class="search_name" position="absolute 13 11 99 28" anchor="default"/>
              <Calendar id="ipt_reqdd" taborder="9" position="absolute 257 11 331 30" mask="yyyy-mm" anchor="default" autoselect="true" autoskip="true" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" onchanged="grp_search_ipt_reqdd_onchanged"/>
              <Static id="caption20" text="부서:" class="search_name" position="absolute 346 11 405 28" anchor="default"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1117 4 1123 36" anchor="default"/>
              <Button id="btn_reqdeptcd" taborder="10" class="icon_search" position="absolute 473 11 489 27" anchor="default" onclick="grp_search_btn_reqdeptcd_onclick"/>
              <Edit id="ipt_deptcd" taborder="11" class="input_default" position="absolute 401 11 471 30" anchor="default" autoselect="true" autoskip="true"/>
              <Edit id="ipt_deptnm" taborder="12" readonly="true" position="absolute 491 11 600 30" anchor="default" autoselect="true" autoskip="true" class="output"/>
              <Static id="caption9" text="월:" class="search_name" position="absolute 215 11 260 28" anchor="default"/>
              <Static id="caption2" text="계정:" class="search_name" position="absolute 615 11 740 28" anchor="default"/>
              <Combo id="combo1" taborder="13" innerdataset="@ds_init_acnt_acntlist" codecolumn="acntcd" datacolumn="acntnm" class="combo_default" position="absolute 670 11 815 30" anchor="default"/>
              <Static id="caption3" text="~" position="absolute 817 11 832 31" anchor="default"/>
              <Combo id="combo2" taborder="14" innerdataset="@ds_hidden_acnt_acntlist" codecolumn="acntcd" datacolumn="acntnm" class="combo_default" position="absolute 830 11 975 30" anchor="default"/>
              <Static id="caption4" text="구분:" class="search_name" position="absolute 986 11 1038 28" anchor="default"/>
              <Combo id="cmb_gubun" taborder="15" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 1038 11 1105 30" anchor="default" visible="true">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">무산정+창고</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" text="월 재고수불장(부서재고)" class="tit_2" position="absolute 0 74 180 96"/>
        <Shape id="line1" class="line_10" position="absolute 0 90 1195 96"/>
        <Grid id="grd_deptstocexcel" taborder="2" binddataset="ds_main_list_deptstocexcel" useinputpanel="false" visible="false" position="absolute 70 123 920 228" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="138"/>
                <Column size="97"/>
                <Column size="239"/>
                <Column size="184"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="90"/>
                <Column size="91"/>
                <Column size="90"/>
                <Column size="91"/>
                <Column size="90"/>
                <Column size="90"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" text="계정과목" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="품목코드" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="품목명" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="규격" taborder="undefined"/>
                <Cell col="4" colspan="2" text="전기이월" taborder="undefined"/>
                <Cell col="6" colspan="2" text="당월입고" taborder="undefined"/>
                <Cell col="8" colspan="2" taborder="undefined">
                  <Cell text="당월출고"/>
                  <Cell col="1" text="당월출고"/>
                </Cell>
                <Cell col="10" colspan="2" taborder="undefined">
                  <Cell text="당월재고"/>
                  <Cell col="1" text="당월재고"/>
                </Cell>
                <Cell row="1" col="4" text="수량"/>
                <Cell row="1" col="5" text="금액"/>
                <Cell row="1" col="6" text="수량"/>
                <Cell row="1" col="7" text="금액"/>
                <Cell row="1" col="8" text="수량"/>
                <Cell row="1" col="9" text="금액"/>
                <Cell row="1" col="10" text="수량"/>
                <Cell row="1" col="11" text="금액"/>
              </Band>
              <Band id="body">
                <Cell text="bind:acntnm"/>
                <Cell col="1" text="bind:goodcd"/>
                <Cell col="2" text="bind:goodnm"/>
                <Cell col="3" text="bind:goodspec"/>
                <Cell col="4" displaytype="number" text="bind:transqty"/>
                <Cell col="5" displaytype="number" text="bind:transamt"/>
                <Cell col="6" displaytype="number" text="bind:winqty"/>
                <Cell col="7" displaytype="number" text="bind:winamt"/>
                <Cell col="8" displaytype="number" text="bind:deliveqty"/>
                <Cell col="9" displaytype="number" text="bind:deliveamt"/>
                <Cell col="10" displaytype="number" text="bind:stocqty"/>
                <Cell col="11" displaytype="number" text="bind:stocamt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excel" taborder="3" text="엑셀" class="btn7" position="absolute 1141 71 1194 90" onclick="btn_excel_onclick"/>
        <Div id="grp_biz" taborder="4" position="absolute 0 97 1191 674"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="srchmm" type="STRING" size="256"/>
          <Column id="deptcd" type="STRING" size="256"/>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="fromacntcd" type="STRING" size="256"/>
          <Column id="toacntcd" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="srchmmdd" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="srchmm"/>
            <Col id="deptcd"/>
            <Col id="deptnm"/>
            <Col id="fromacntcd"/>
            <Col id="toacntcd"/>
            <Col id="gubun">1</Col>
            <Col id="srchmmdd"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_deptstocexcel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="goodcd" type="STRING" size="256" sumtext="품목코드"/>
          <Column id="endmonth" type="STRING" size="256" sumtext="마감월"/>
          <Column id="goodnm" type="STRING" size="256" sumtext="품목명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
          <Column id="transqty" type="STRING" size="256" sumtext="전기이월수량"/>
          <Column id="transamt" type="STRING" size="256" sumtext="전기이월금액"/>
          <Column id="winqty" type="STRING" size="256" sumtext="당월입고수량"/>
          <Column id="winamt" type="STRING" size="256" sumtext="당월입고금액"/>
          <Column id="deliveqty" type="STRING" size="256" sumtext="당월출고수량"/>
          <Column id="deliveamt" type="STRING" size="256" sumtext="당월출고금액"/>
          <Column id="stocqty" type="STRING" size="256" sumtext="당월재고수량"/>
          <Column id="stocamt" type="STRING" size="256" sumtext="당월재고금액"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_init" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cnstnm" type="STRING" size="256"/>
          <Column id="cnstcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_acnt_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_hidden_acnt_acntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="acntnm" type="STRING" size="256"/>
          <Column id="acntcd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_deptstocmmlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="goodcd" type="STRING" size="256" sumtext="품목코드"/>
          <Column id="endmonth" type="STRING" size="256" sumtext="마감월"/>
          <Column id="goodnm" type="STRING" size="256" sumtext="품목명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
          <Column id="transqty" type="STRING" size="256" sumtext="전기이월수량"/>
          <Column id="transamt" type="STRING" size="256" sumtext="전기이월금액"/>
          <Column id="winqty" type="STRING" size="256" sumtext="당월입고수량"/>
          <Column id="winamt" type="STRING" size="256" sumtext="당월입고금액"/>
          <Column id="deliveqty" type="STRING" size="256" sumtext="당월출고수량"/>
          <Column id="deliveamt" type="STRING" size="256" sumtext="당월출고금액"/>
          <Column id="stocqty" type="STRING" size="256" sumtext="당월재고수량"/>
          <Column id="stocamt" type="STRING" size="256" sumtext="당월재고금액"/>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="deptnm" type="STRING" size="256" sumtext="부서명"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_search.cmb_instcd" propid="value" datasetid="ds_cond" columnid="instcd"/>
      <BindItem id="item1" compid="grp_search.ipt_reqdd" propid="value" datasetid="ds_cond" columnid="srchmm"/>
      <BindItem id="item2" compid="grp_search.ipt_deptcd" propid="value" datasetid="ds_cond" columnid="deptcd"/>
      <BindItem id="item3" compid="grp_search.ipt_deptnm" propid="value" datasetid="ds_cond" columnid="deptnm"/>
      <BindItem id="item4" compid="grp_search.combo1" propid="value" datasetid="ds_cond" columnid="fromacntcd"/>
      <BindItem id="item5" compid="grp_search.combo2" propid="value" datasetid="ds_cond" columnid="toacntcd"/>
      <BindItem id="item6" compid="grp_search.cmb_gubun" propid="value" datasetid="ds_cond" columnid="gubun"/>
    </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";
function SMRSO20700_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRSO20700_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_deptstocexcel);
	
	var objDOM = rptf_createDOM();
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;	
	
	var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
	rptf_exeReportPreview30(["RPRSO20702"],[objParam], option, "", "grp_biz")
	
	misfComboInstCdListMulti("grp_search.cmb_instcd",utlf_getCurrentDate(),"","N");					   		     
	
	ds_cond.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_cond.setColumn(0, "srchmm", String(utlf_getCurrentDate()).substr(0,6));
	
	var oParam = {};
		oParam.id          = "TRRSO20602";
		oParam.service     = "deliveapp.DeliveMngt";
		oParam.method      = "reqGetAcntList";
		oParam.inds        = "req=ds_cond";
		oParam.outds       = "ds_init_acnt_acntlist=acntlist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRSO20602";

	tranf_submit(oParam);
	
	var srchmmdd = ds_cond.getColumn(0, "srchmm")+"01";
	
	ds_cond.setColumn(0, "srchmm", srchmmdd);
}

function cf_TRRSO20602(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		ds_hidden_acnt_acntlist.copyData(ds_init_acnt_acntlist);
	}
}

function grp_search_ipt_reqdd_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	var date = String(obj.value).substr(0,6);
	
	ds_cond.setColumn(0, "srchmm", date)
	ds_cond.setColumn(0, "srchmmdd", date+"01");
}

function grp_search_btn_reqdeptcd_onclick(obj:Button,  e:ClickEventInfo)
{
	var recv_list = "deptcd,deptnm";
	misfOpenPopUpList("02", ds_cond, "", recv_list) ; 		
}

function grp_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRSO20701";
		oParam.service     = "deliveapp.DeliveMngt";
		oParam.method      = "reqGetDeptStocMMList";
		oParam.inds        = "cond=ds_cond";
		oParam.outds       = "ds_main_list_deptstocmmlist=deptstocmmlist ds_main_list_deptstocexcel=deptstocexcel";
		oParam.async       = false;
		oParam.callback    = "cf_TRRSO20701";

	tranf_submit(oParam);
}

function cf_TRRSO20701(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		var objDOM = rptf_createDOM(); 
			rptf_setNodeListToDOM(objDOM, "/root/main/list/deptstocmmlist", ds_main_list_deptstocmmlist);
			
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source;
		
		var option = "open=1;save=1;directprint=0;print=1;zoom=0;";	
		rptf_exeReportPreview30(["RPRSO20702"],[objParam], option, "", "grp_biz")
	}
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_list_deptstocexcel.rowcount < 1)
	{
		return;
	}
	
	grdf_exportExcel(grd_deptstocexcel, "excel", false, false, "", "user", false);
}

]]></Script>
  </Form>
</FDL>