YNU_JEUS/app_home/himed/xpapps/mis/purcbasexp/xp/SMRFC00917_컴퓨터현황.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRFC00917" position="absolute 0 0 1203 783" titletext="컴퓨터현황조회" oninit="SMRFC00917_oninit" onload="SMRFC00917_onload">
    <Layouts>
      <Layout>
        <Tab id="switch1" taborder="5" tabindex="0" position="absolute 0 118 1195 772" anchor="all" onchanged="switch1_onchanged">
          <Tabpages>
            <Tabpage id="case_fixasetlist" text="운영체제별">
              <Layouts>
                <Layout>
                  <Grid id="grd_fixasetlist" class="datagrid2" taborder="0" binddataset="ds_main_list_fixaset_fixasetlist" useinputpanel="false" position="absolute 0 0 850 625" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="24"/>
                          <Column size="100"/>
                          <Column size="90"/>
                          <Column size="90"/>
                          <Column size="90"/>
                          <Column size="90"/>
                          <Column size="90"/>
                          <Column size="90"/>
                          <Column size="150"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                          <Row size="24" band="summ"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="년도"/>
                          <Cell col="2" text="WinXP"/>
                          <Cell col="3" text="Win7-32bit"/>
                          <Cell col="4" text="Win7-64bit"/>
                          <Cell col="5" text="Win8"/>
                          <Cell col="6" text="Win8.1"/>
                          <Cell col="7" text="-"/>
                          <Cell col="8" text="계"/>
                        </Band>
                        <Band id="body">
                          <Cell celltype="head" expr="currow+1"/>
                          <Cell col="1" text="bind:possndd"/>
                          <Cell col="2" text="bind:os1"/>
                          <Cell col="3" text="bind:os2"/>
                          <Cell col="4" text="bind:os3"/>
                          <Cell col="5" text="bind:os5"/>
                          <Cell col="6" text="bind:os4"/>
                          <Cell col="7" text="bind:os0"/>
                          <Cell col="8" displaytype="number" style="align:center middle;color:#990000ff;color2:#990000ff;" text="bind:tt"/>
                        </Band>
                        <Band id="summary">
                          <Cell style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;"/>
                          <Cell col="1" style="background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="총계"/>
                          <Cell col="2" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('os1')"/>
                          <Cell col="3" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('os2')"/>
                          <Cell col="4" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('os3')"/>
                          <Cell col="5" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('os5')"/>
                          <Cell col="6" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('os4')"/>
                          <Cell col="7" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;font:arial,9,bold;" text="expr:getSum('os0')"/>
                          <Cell col="8" displaytype="number" style="align:center middle;background:#99ccffff;background2:#99ccffff;color:#990000ff;color2:#990000ff;font:arial,9,bold;" text="expr:getSum('tt')"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="case_fixasetmodel" text="기종별">
              <Layouts>
                <Layout>
                  <Div id="grp_biz" anchor="all" taborder="0" position="absolute 0 0 1195 620"/>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Static id="caption6" text="컴퓨터 현황 조회" class="tit_1" position="absolute 0 0 186 25"/>
        <Div id="group5" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 48 1195 108">
          <Layouts>
            <Layout>
              <Edit id="ipt_mngtdeptcd_search" taborder="21" class="input_search" position="absolute 103 32 188 51" onkeyup="group5_ipt_mngtdeptcd_search_onkeyup"/>
              <Button id="btn_mngtdeptcd_search" taborder="22" class="icon_search" position="absolute 192 34 208 50" onclick="group5_btn_mngtdeptcd_search_onclick"/>
              <Edit id="ipt_mngtdeptnm_search" taborder="23" class="input_search" position="absolute 211 32 408 51" onkeyup="group5_ipt_mngtdeptnm_search_onkeyup"/>
              <Static id="cap_possndd_search" text="취득일자 :" class="search_name" position="absolute 499 8 593 25"/>
              <Calendar id="ipt_possnfrdd_search" taborder="24" class="input_default" position="absolute 589 6 687 25" mask="yyyy" dateformat="yyyy" value="null" editformat="yyyy" onchanged="group5_ipt_possnfrdd_search_onchanged" style="align:center middle;"/>
              <Button id="btn_search" taborder="25" text="조회" class="btn1" position="absolute 1120 20 1176 42" anchor="top right" onclick="group5_btn_search_onclick"/>
              <Static id="cap_instcd_search" text="기관코드 :" class="search_name" position="absolute 11 8 128 25"/>
              <Combo id="cmb_instcd_search" taborder="26" class="combo_essential" enable="false" position="absolute 103 6 298 25"/>
              <Shape id="line12" linetype="vertical" class="line_4" position="absolute 1102 7 1108 53" anchor="top right"/>
              <Calendar id="ipt_possntodd_search" taborder="27" class="input_default" position="absolute 704 6 802 25" mask="yyyy" dateformat="yyyy" editformat="yyyy" onchanged="group5_ipt_possntodd_search_onchanged" style="align:center middle;"/>
              <Static id="caption2" text="~" position="absolute 690 7 705 27"/>
              <Static id="cap_installplcecd" text="운용부서 :" class="search_name" position="absolute 11 33 103 50"/>
              <Combo id="cmb_deptflag_search" taborder="28" position="absolute 937 6 1017 25"/>
              <Static id="caption1" text="부서구분 :" class="search_name" position="absolute 847 8 963 25"/>
              <Static id="caption3" text="정리구분 :" class="search_name" position="absolute 500 35 616 52"/>
              <Combo id="cmb_gubun" taborder="29" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 589 35 669 54">
                <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>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_excel" taborder="2" text="Excel 저장" class="btn5" position="absolute 1120 121 1195 140" anchor="top right" onclick="btn_excel_onclick"/>
        <Shape id="line16" linetype="vertical" class="line_1" position="absolute 0 199 1190 200"/>
        <Button id="btn_print" taborder="3" text="운영체체리스트" class="btn5" position="absolute 1014 121 1119 140" anchor="top right" onclick="btn_print_onclick"/>
        <Shape id="line14" class="line_6" position="absolute 0 44 1195 50" anchor="left top right"/>
        <Button id="btn_init" taborder="4" text="초기화" class="btn4" position="absolute 1127 23 1195 45" anchor="top right" onclick="btn_init_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_fixasetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_fixasetlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="mngtdeptcd" type="STRING" size="256"/>
          <Column id="mngtdeptnm" type="STRING" size="256"/>
          <Column id="possnfrdd" type="STRING" size="256"/>
          <Column id="possntodd" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="deptflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="mngtdeptcd"/>
            <Col id="mngtdeptnm"/>
            <Col id="possnfrdd"/>
            <Col id="possntodd"/>
            <Col id="gubun">A</Col>
            <Col id="deptflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_fixaset_fixasetlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="possndd" type="STRING" size="256" sumtext="년도              "/>
          <Column id="os1" type="STRING" size="256" sumtext="winxp     "/>
          <Column id="os2" type="STRING" size="256" sumtext="win7-32  "/>
          <Column id="os3" type="STRING" size="256" sumtext="win7-64   "/>
          <Column id="os5" type="STRING" size="256" sumtext="win8     "/>
          <Column id="os4" type="STRING" size="256" sumtext="win8.1   "/>
          <Column id="os0" type="STRING" size="256" sumtext="-        "/>
          <Column id="tt" type="STRING" size="256" sumtext="계               "/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_list_fixasetmodel" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드       "/>
          <Column id="possndd" type="STRING" size="256" sumtext="년도              "/>
          <Column id="goodspec" type="STRING" size="256" sumtext="기종             "/>
          <Column id="cnt" type="STRING" size="256" sumtext="자산수          "/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group5.cmb_instcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="instcd"/>
      <BindItem id="item1" compid="group5.ipt_mngtdeptcd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="mngtdeptcd"/>
      <BindItem id="item2" compid="group5.ipt_mngtdeptnm_search" propid="value" datasetid="ds_send_fixasetlist" columnid="mngtdeptnm"/>
      <BindItem id="item3" compid="group5.ipt_possnfrdd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="possnfrdd"/>
      <BindItem id="item4" compid="group5.ipt_possntodd_search" propid="value" datasetid="ds_send_fixasetlist" columnid="possntodd"/>
      <BindItem id="item5" compid="group5.cmb_deptflag_search" propid="value" datasetid="ds_send_fixasetlist" columnid="deptflag"/>
      <BindItem id="item6" compid="group5.cmb_gubun" propid="value" datasetid="ds_send_fixasetlist" 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 SMRFC00917_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRFC00917_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(switch1.case_fixasetlist.grd_fixasetlist);
	fInitialize();	
}

function fInitialize()
{
	misfGridInit(switch1.case_fixasetlist.grd_fixasetlist);
					
	misfComboComCdListMulti("C0048,R0480", "group5.cmb_instcd_search,group5.cmb_deptflag_search");
	frmf_addComboItem("group5.cmb_deptflag_search", "전체", "", "above" );
	
	ds_send_fixasetlist.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd")); 
	
	ds_main_list_fixaset_fixasetlist.clearData();
	
	//misfMsterDetailSet(grd_fixasetlist, null, "TRRFC00917", "Y" , "byrow");
	
	var curdate = utlf_getCurrentDate();
	
	ds_send_fixasetlist.setColumn(0, "possnfrdd", "2000");
	ds_send_fixasetlist.setColumn(0, "possntodd", String(curdate).substr(0,4));
	
	var objDOM = rptf_createDOM();
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source;	
	
	var option = null;
	//rptf_exeReportPreview30(["RPRFC00918"],[objParam], option, "", "switch1.case_fixasetmodel.grp_biz")
}			
	
function ds_send_fixasetlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "mngtdeptcd")
	{
		group5.ipt_mngtdeptnm_search.setFocus();
		misfSearchDept(group5.ipt_mngtdeptnm_search);
	}
}

function group5_ipt_mngtdeptcd_search_onkeyup(obj:Edit, e:KeyEventInfo)
{
	if(e.keycode == 13)
	{
		obj.updateToDataset();
	}
}

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

function group5_btn_mngtdeptcd_search_onclick(obj:Button,  e:ClickEventInfo)
{
	misfOpenPopUpList("02", group5.ipt_mngtdeptcd_search,"","mngtdeptcd,mngtdeptnm");
}

function group5_ipt_possntodd_search_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send_fixasetlist.setColumn(0, "possntodd", String(obj.value).substr(0,4));
}

function group5_ipt_possnfrdd_search_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send_fixasetlist.setColumn(0, "possnfrdd", String(obj.value).substr(0,4));
}

function group5_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(switch1.tabindex == 0)
	{
		misfGridInit(switch1.case_fixasetlist.grd_fixasetlist);
		
		var oParam = {};
			oParam.id          = "TRRFC00917";
			oParam.service     = "purcbaseapp.PurcBaseMngt";
			oParam.method      = "reqGetOsFixAsetList";
			oParam.inds        = "req=ds_send_fixasetlist";
			oParam.outds       = "ds_main_list_fixaset_fixasetlist=fixasetlist";
			oParam.async       = false;
			//oParam.callback    = "cf_TRRFC00917";

		tranf_submit(oParam);
		
		if(ds_main_list_fixaset_fixasetlist.rowcount > 0)
		{
			ds_main_list_fixaset_fixasetlist.rowposition = 0;
		}
	}
	else if(switch1.tabindex == 1)
	{
		var oParam = {};
			oParam.id          = "TRRFC00918";
			oParam.service     = "purcbaseapp.PurcBaseMngt";
			oParam.method      = "reqGetModelFixAsetList";
			oParam.inds        = "req=ds_send_fixasetlist";
			oParam.outds       = "ds_main_list_fixasetmodel=fixasetmodel";
			oParam.async       = false;
			oParam.callback    = "cf_TRRFC00918";

		tranf_submit(oParam);
	}
}

function cf_TRRFC00918(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) return;
	else
	{
		var objDOM = rptf_createDOM();
			rptf_setNodeListToDOM(objDOM, "/root/main/list/fixasetmodel/fixasetmodel", ds_main_list_fixasetmodel);
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source;	
		
		var option = null;
		rptf_exeReportPreview30(["RPRFC00918"],[objParam], option, "", "switch1.case_fixasetmodel.grp_biz")
	}
}

function switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
{
	fDisableSetting();
}

function fDisableSetting()
{
	var disValue = "";
	if(switch1.tabindex == 0)
	{
		disValue = true;
	}
	else 
	{
		disValue = false;
	}
	
	btn_excel.enable = disValue;
	btn_print.enable = disValue;	
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/list/fixaset/fixasetlist", ds_main_list_fixaset_fixasetlist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["RPRFC00917"],[objParam], option);
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	if( ds_main_list_fixaset_fixasetlist.rowcount > 0)
	{
		var fileName = "컴퓨터현황_" + utlf_getCurrentDate();
		grdf_exportExcel(switch1.case_fixasetlist.grd_fixasetlist, fileName, "Sheet", "true", "", "");
	}
	else 
	{
		sysf_messageBox("저장 데이터가","I004");
	}
}

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