YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRFC00406_재물조사통계.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRFC00406" position="absolute 0 0 1211 784" titletext="재물조사통계" oninit="SMRFC00406_oninit" onload="SMRFC00406_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="재물조사 통계 출력물" class="tit_1" position="absolute 0 0 186 25"/>
        <Shape id="line16" class="line_2" position="absolute 0 45 1195 48" anchor="left top right"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" visible="false" position="absolute 1069 22 1125 44" anchor="top right" onclick="btn_save_onclick"/>
        <Button id="btn_clear" taborder="2" text="초기화" class="btn4" position="absolute 1127 22 1195 44" anchor="top right" onclick="btn_clear_onclick"/>
        <Static id="caption8" text="&lt; 재물조사 총괄표 출력정보 &gt;" position="absolute 5 131 395 146" style="color:#003366ff;font:Dotum,9,bold;"/>
        <Static id="caption52" text="전년대비 자산증감 현황 _비고" class="cell_1" position="absolute 10 167 185 190" style="align:left middle;"/>
        <Static id="caption5" text="불용물품 현황_비고" class="cell_1" position="absolute 10 262 185 285" style="background:#d4d4ffff;align:left middle;"/>
        <Button id="button1" taborder="3" text="재물조사 총괄표" class="btn4" position="absolute 665 182 793 204" onclick="button1_onclick"/>
        <Button id="button2" taborder="4" text="부서,계정 자산총계표" class="btn4" position="absolute 665 222 817 244" onclick="button2_onclick"/>
        <Button id="button3" taborder="5" text="불용물품 현황" class="btn4" position="absolute 665 262 781 284" onclick="button3_onclick"/>
        <Shape id="line1" linetype="vertical" position="absolute 615 117 618 337"/>
        <Shape id="line3" class="line_10" position="absolute 0 107 1195 118" anchor="left top right"/>
        <Static id="caption12" text="재물조사 출력물" class="tit_2" position="absolute 0 93 390 114"/>
        <TextArea id="textarea1" taborder="6" wordwrap="word" autoselect="true" acceptstab="true" position="absolute 190 167 580 232"/>
        <TextArea id="textarea2" taborder="7" wordwrap="word" autoselect="true" acceptstab="true" position="absolute 190 262 580 327"/>
        <Div id="grp_sea" anchor="left top right" taborder="8" style="align: top;" class="div_SA2" position="absolute 0 47 1195 87">
          <Layouts>
            <Layout>
              <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 15 11 101 28" anchor="default"/>
              <Static id="cap_deptcd" text="기준년도 :" class="search_name" position="absolute 511 11 601 28" anchor="default"/>
              <Button id="btn_search" taborder="7" text="조회" class="btn1" visible="false" position="absolute 1125 8 1181 30" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Combo id="cmb_instcd" taborder="8" class="combo_essential" position="absolute 108 10 346 29" style="align:center middle;" columncount="-1" rowcount="-1" anchor="default" onitemchanged="grp_sea_cmb_instcd_onitemchanged" enable="false"/>
              <Edit id="ipt_yyyy" taborder="9" onkillfocus="grp_biz_grp_sea_ipt_yyyy_onkillfocus" class="input_search" position="absolute 605 10 710 29" style="align:center middle;" anchor="default" maxlength="4" autoskip="true" autoselect="true"/>
              <Edit id="ipt_byyyy" taborder="10" class="input_search" visible="false" position="absolute 750 10 855 29" style="align:center ;" anchor="default" autoskip="true" autoselect="true"/>
              <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1111 8 1117 34" anchor="top right"/>
            </Layout>
          </Layouts>
        </Div>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="yyyy" type="STRING" size="256"/>
          <Column id="byyyy" type="STRING" size="256"/>
          <Column id="flag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="yyyy"/>
            <Col id="byyyy"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmt1" type="STRING" size="256"/>
          <Column id="cmt2" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cmt1"/>
            <Col id="cmt2"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_prtinfo_goodssumlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="a" type="STRING" size="256" sumtext="의료기기수량"/>
          <Column id="b" type="STRING" size="256" sumtext="의료비품수량"/>
          <Column id="c" type="STRING" size="256" sumtext="일반비품 및 기타 수량"/>
          <Column id="a_sum" type="STRING" size="256" sumtext="의료기기 금액"/>
          <Column id="b_sum" type="STRING" size="256" sumtext="의료비품 금액"/>
          <Column id="c_sum" type="STRING" size="256" sumtext="일반비품 및 기타 금액"/>
          <Column id="tot_qty" type="STRING" size="256" sumtext="수량총합계"/>
          <Column id="tot_amt" type="STRING" size="256" sumtext="금액 총합계"/>
          <Column id="passnmin" type="STRING" size="256" sumtext="기준금액최소"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_prtinfo_variationlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="lastyear" type="STRING" size="256" sumtext="작년"/>
          <Column id="thisyear" type="STRING" size="256" sumtext="금년"/>
          <Column id="variation" type="STRING" size="256" sumtext="증감"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_prtinfo_uselesslist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="fixasetqty" type="STRING" size="256" sumtext="수량"/>
          <Column id="possnamt" type="STRING" size="256" sumtext="금액"/>
          <Column id="janjonsak" type="STRING" size="256" sumtext="잔존가"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_prtinfo_temp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cmt1" type="STRING" size="256"/>
          <Column id="cmt2" type="STRING" size="256"/>
          <Column id="yyyy" type="STRING" size="256"/>
          <Column id="byyyy" type="STRING" size="256"/>
          <Column id="cmt4" type="STRING" size="256"/>
          <Column id="cmt8" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_prtinfo_deptacntlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="mngtdeptnm" type="STRING" size="256" sumtext="사용부서"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="fixasetqty" type="STRING" size="256" sumtext="수량"/>
          <Column id="possnamt" type="STRING" size="256" sumtext="취득금액"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_prtinfo_uselessgoodlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="acntcd" type="STRING" size="256" sumtext="계정코드"/>
          <Column id="acntnm" type="STRING" size="256" sumtext="계정명"/>
          <Column id="fixasetcd" type="STRING" size="256" sumtext="자산코드"/>
          <Column id="goodflaghngnm" type="STRING" size="256" sumtext="자산명"/>
          <Column id="goodspec" type="STRING" size="256" sumtext="규격"/>
          <Column id="goodqty" type="STRING" size="256" sumtext="수량"/>
          <Column id="possndd" type="STRING" size="256" sumtext="취득년도"/>
          <Column id="possnamt" type="STRING" size="256" sumtext="취득금액"/>
          <Column id="janjonsak" type="STRING" size="256" sumtext="잔존가"/>
          <Column id="mngtdeptnm" type="STRING" size="256" sumtext="사용부서"/>
          <Column id="gubun" type="STRING" size="256" sumtext="계정구분"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item3" compid="textarea1" propid="value" datasetid="ds_temp" columnid="cmt1"/>
      <BindItem id="item4" compid="textarea2" propid="value" datasetid="ds_temp" columnid="cmt2"/>
      <BindItem id="item0" compid="grp_sea.cmb_instcd" propid="value" datasetid="ds_send" columnid="instcd"/>
      <BindItem id="item1" compid="grp_sea.ipt_yyyy" propid="value" datasetid="ds_send" columnid="yyyy"/>
      <BindItem id="item2" compid="grp_sea.ipt_byyyy" propid="value" datasetid="ds_send" columnid="byyyy"/>
    </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 SMRFC00406_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRFC00406_onload(obj:Form, e:LoadEventInfo)
{
	fInitialize();
}

function fInitialize()
{					
	misfComboComCdList("C0048",grp_sea.cmb_instcd,"Y");
	grp_sea.cmb_instcd.value = sysf_getUserInfo("dutplceinstcd");
	
	ds_send.setColumn(0, "yyyy", String(utlf_getCurrentDate()).substring(0, 4));
	
	var curdate = utlf_getCurrentDate();
	var cvtdate = curdate.toDate("YYYY");
	var byyyy = cvtdate.getAddDate(-1,"Y").getDateFormat("YYYY");
	
	ds_send.setColumn(0, "byyyy", cvtdate.getAddDate(-1,"Y").getDateFormat("YYYY"));
}

function grp_sea_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	grp_sea.btn_search.click();
}

function ds_send_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "yyyy")
	{
		var yyyy = e.newvalue;
		obj.setColumn(0, "byyyy", parseInt(yyyy)-1);
	}
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fsearch();	
}

function fsearch()
{
	arrCompId = new Array("grp_sea.cmb_instcd");
	frmf_isRequiredControls(arrCompId);
 
	//misfMsterDetailRetrieve();			
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var yyyy = ds_send.getColumn(0,"yyyy");
    if(yyyy > "2018"){
    	ds_send.setColumn(0,"flag","after");
    }else{
        ds_send.setColumn(0,"flag","before");
    }
   // alert(ds_send.getColumn(0,"flag"));
	
	
	var oParam = {};
		oParam.id          = "TRRFC00407";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetGoodssumlist";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_prtinfo_goodssumlist=goodssumlist ds_prtinfo_variationlist=variationlist ds_prtinfo_uselesslist=uselesslist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRFC00407";

	tranf_submit(oParam);
	
	ds_prtinfo_temp.copyData(ds_temp);
	
	dsf_makeValue(ds_prtinfo_temp, "yyyy", "string", ds_send.getColumn(0, "yyyy"), 0);
	dsf_makeValue(ds_prtinfo_temp, "byyyy", "string", ds_send.getColumn(0, "byyyy"), 0);
	
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/temp", ds_prtinfo_temp);
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/goodssumlist", ds_prtinfo_goodssumlist);
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/variationlist", ds_prtinfo_variationlist);
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/uselesslist", ds_prtinfo_uselesslist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["RPRFC00401"],[objParam], option);
}

function button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var yyyy = ds_send.getColumn(0,"yyyy");
    if(yyyy > "2018"){
    	ds_send.setColumn(0,"flag","after");
    }else{
        ds_send.setColumn(0,"flag","before");
    }
	
	
	var oParam = {};
		oParam.id          = "TRRFC00408";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetDeptAcntlist";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_prtinfo_deptacntlist=deptacntlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRFC00408";

	tranf_submit(oParam);

	dsf_makeValue(ds_prtinfo_temp, "yyyy", "string", ds_send.getColumn(0, "yyyy"), 0);

	if(ds_prtinfo_deptacntlist.rowcount == 0){
		ds_prtinfo_deptacntlist.addRow();
	}

	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/temp", ds_prtinfo_temp);
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/deptacntlist", ds_prtinfo_deptacntlist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["RPRFC00402"],[objParam], option);
}

function button3_onclick(obj:Button,  e:ClickEventInfo)
{
	var yyyy = ds_send.getColumn(0,"yyyy");
    if(yyyy > "2018"){
    	ds_send.setColumn(0,"flag","after");
    }else{
        ds_send.setColumn(0,"flag","before");
    }
	
	var oParam = {};
		oParam.id          = "TRRFC00409";
		oParam.service     = "purcbaseapp.PurcBaseMngt";
		oParam.method      = "reqGetUselessGoodlist";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_prtinfo_uselessgoodlist=uselessgoodlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRFC00409";

	tranf_submit(oParam);
	
	dsf_makeValue(ds_prtinfo_temp, "yyyy", "string", ds_send.getColumn(0, "yyyy"), 0);
	
	if( ds_prtinfo_uselessgoodlist.rowcount < 1 ){
		ds_prtinfo_uselessgoodlist.addRow();
	}
	
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/temp", ds_prtinfo_temp);
		rptf_setNodeListToDOM(objDOM, "/root/prtinfo/uselessgoodlist", ds_prtinfo_uselessgoodlist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["RPRFC00403"],[objParam], option);
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	
}

function btn_clear_onclick(obj:Button,  e:ClickEventInfo)
{
	fInitialize();	
}
]]></Script>
  </Form>
</FDL>