YNU_JEUS/app_home/himed/xpapps/crm/rulexp/xp/SMCRA00100_승인자관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMCRA00100" position="absolute 0 0 1198 784" titletext="승인자관리" oninit="SMCRA00100_oninit" onload="SMCRA00100_onload">
    <Layouts>
      <Layout>
        <Static id="caption1" text="전송승인자 설정" class="tit_1" position="absolute 0 0 145 25" anchor="left top"/>
        <Div id="group2" taborder="1" position="absolute 0 25 1194 65" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="btn_search" taborder="0" text="조회" class="btn1" position="absolute 1115 11 1171 33" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Shape id="line1" linetype="vertical" class="line_4" position="absolute 1096 11 1102 33" anchor="top right"/>
              <Static id="caption2" text="성 명 :" class="search_name" position="absolute 606 11 666 28" anchor="left top"/>
              <Edit id="ipt_usernm" taborder="1" class="input_search" position="absolute 677 10 797 29" anchor="left top" autoselect="true"/>
              <Edit id="ipt_deptnm" taborder="2" class="input_search" position="absolute 400 10 520 29" anchor="left top" autoselect="true"/>
              <Static id="caption4" text="부서명 :" class="search_name" position="absolute 321 11 381 28" anchor="left top"/>
              <Combo id="cmb_useyn" taborder="3" codecolumn="value" datacolumn="label" class="combo_search" position="absolute 108 10 213 29" anchor="left top" innerdataset="@ds_useryn" index="-1"/>
              <Static id="caption3" text="사용여부 :" class="search_name" position="absolute 16 11 88 28" anchor="left top"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption35" text="전체 :" position="absolute 14 73 54 90" anchor="left top"/>
        <Edit id="opt_countnode" taborder="2" readonly="true" position="absolute 50 71 80 90" anchor="left top" style="background:transparent 5,5;align:center middle;"/>
        <Static id="caption7" text="건" position="absolute 87 73 117 90" anchor="left top"/>
        <Button id="btn_smaple" taborder="3" text="샘플파일" class="btn2" position="absolute 1047 71 1111 90" onclick="btn_smaple_onclick" anchor="top right"/>
        <Button id="btn_insert" taborder="4" text="엑셀입력" class="btn7" position="absolute 1114 71 1194 90" onclick="btn_insert_onclick" anchor="top right"/>
        <Button id="btn_add" taborder="5" text="행추가" class="btn5" position="absolute 991 71 1044 90" onclick="btn_add_onclick" anchor="top right"/>
        <Button id="btn_del" taborder="6" text="행삭제" class="btn5" position="absolute 935 71 988 90" onclick="btn_del_onclick" anchor="top right"/>
        <Shape id="line2" linetype="horizontal" class="line_10" position="absolute -1 90 1194 96" anchor="left top right"/>
        <Grid id="grd_aprvlist" taborder="7" binddataset="ds_main_data_aprvlist" useinputpanel="false" position="absolute 0 95 1195 756" autofittype="col" anchor="all" onexpanddown="grd_aprvlist_onexpanddown" autoenter="select" cellsizingtype="col">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="24"/>
                <Column size="223"/>
                <Column size="236"/>
                <Column size="322"/>
                <Column size="149"/>
                <Column size="103"/>
                <Column size="115"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="승인자 ID"/>
                <Cell col="2" text="승인자 성명"/>
                <Cell col="3" text="부서명"/>
                <Cell col="4" text="마스터 권한 여부 Y/N"/>
                <Cell col="5" text="사용여부 Y/N"/>
                <Cell col="6" text="부서코드"/>
                <Cell col="7"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" style="align:center middle;" class="text_center" text="bind:aprvuserid"/>
                <Cell col="2" displaytype="text" edittype="text" style="align:center middle;" class="text_center" text="bind:aprvusernm" expandshow="show"/>
                <Cell col="3" style="align:center middle;" class="text_center" text="bind:posdeptnm"/>
                <Cell col="4" displaytype="combo" edittype="combo" style="align:center middle;" class="text_center" text="bind:mastauth" combodataset="ds_mastauth" combocodecol="value" combodatacol="label"/>
                <Cell col="5" displaytype="combo" edittype="combo" style="align:center middle;" class="text_center" text="bind:useyn" combodataset="ds_useyn" combocodecol="value" combodatacol="label"/>
                <Cell col="6" style="align:center middle;" class="text_center" text="bind:posdeptcd"/>
                <Cell col="7" class="text_center" text="bind:seq"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_save" taborder="8" text="저장" class="btn4" position="absolute 1139 759 1195 781" onclick="btn_save_onclick" anchor="right bottom"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_data_aprvlist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="aprvuserid" type="STRING"/>
          <Column id="aprvusernm" type="STRING"/>
          <Column id="posdeptnm" type="STRING"/>
          <Column id="mastauth" type="STRING"/>
          <Column id="useyn" type="STRING"/>
          <Column id="posdeptcd" type="STRING"/>
          <Column id="seq" type="STRING"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_searchdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="useryn" type="STRING" size="256"/>
          <Column id="posdeptnm" type="STRING" size="256"/>
          <Column id="aprvusernm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <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="countnode" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="countnode">0</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_useryn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <choices>
          <item>
            <label>전체</label>
            <value/>
          </item>
          <item>
            <label>사용</label>
            <value>Y</value>
          </item>
          <item>
            <label>미사용</label>
            <value>N</value>
          </item>
        </choices>
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">전체</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">사용</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">미사용</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_mastauth" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">권한자</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">미권한자</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_useyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">사용</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">미사용</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="aprvlist" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_useyn" propid="value" datasetid="ds_searchdata" columnid="useryn"/>
      <BindItem id="item1" compid="group2.ipt_deptnm" propid="value" datasetid="ds_searchdata" columnid="posdeptnm"/>
      <BindItem id="item2" compid="group2.ipt_usernm" propid="value" datasetid="ds_searchdata" columnid="aprvusernm"/>
      <BindItem id="item3" compid="opt_countnode" propid="value" datasetid="ds_temp" columnid="countnode"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2016-05-24
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2016-05-24      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/

include "com_commonxp::comm_main.xjs";

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

function SMCRA00100_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_aprvlist);
	grdf_setRowTypeIcon(grd_aprvlist, 0);
	
	group2.cmb_useyn.index = 0;
	fSearchAprvlist();
}

// 승인자 조회
function fSearchAprvlist()
{
	var oParam = {};
		oParam.id          = "TRCRA00101";
		oParam.service     = "rulemngtapp.RuleMngt";
		oParam.method      = "reqGetAprvList";
		oParam.inds        = "req=ds_searchdata";
		oParam.outds       = "ds_main_data_aprvlist=aprvlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRCRA00101";
	tranf_submit(oParam);
	
	var gird_rows = ds_main_data_aprvlist.rowcount;
	
	ds_temp.setColumn(0, "countnode", gird_rows);
}

//조회
function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fSearchAprvlist();
}

//행삭제
function btn_del_onclick(obj:Button,  e:ClickEventInfo)
{
	fDelRow(grd_aprvlist);
	var grid_rows = ds_main_data_aprvlist.rowcount;
	ds_temp.setColumn(0, "countnode", grid_rows);
}

function fDelRow(grid)
{
	var fRow = ds_main_data_aprvlist.rowcount;
	var sRow = ds_main_data_aprvlist.rowposition;

	if ( sRow  > -1 )
	{
		if(	ds_main_data_aprvlist.getRowType(sRow) == 2)
		{
			ds_main_data_aprvlist.deleteRow(sRow);
		}
		else
		{	
			var arrPostion = new Array();
			arrPostion[0]  = ds_main_data_aprvlist.rowposition;
			grdf_setStatus(grd_aprvlist, "D", arrPostion);
		}
	}
	else
	{
		sysf_messageBox("삭제할 행을", "C002");
	}
}

//행추가
function btn_add_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_data_aprvlist.addRow();
	var grid_rows = ds_main_data_aprvlist.rowcount
	ds_temp.setColumn(0, "countnode", grid_rows);
}

//샘플파일
function btn_smaple_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_aprvlist, "샘플파일"+"_" + "excel", "sheet1", false);
}

//엑셀입력
function btn_insert_onclick(obj:Button,  e:ClickEventInfo)
{
	var fd = new FileDialog();
	var file = fd.open("open", FileDialog.LOAD,"%MYDOCUMENT%");
	
	if(utlf_isNull(file))
	{
	
	}
	
	file.open(VirtualFile.openRead | VirtualFile.openBinary);
	
	ds_main_data_aprvlist.deleteRow(0);
	
	
	var grid_rows = ds_main_data_aprvlist.rowcount;
	var idx = 0;
	ds_temp.setColumn(0, "countnode", grid_rows);
	for(idx = 0; idx < grid_rows; idx++)
	{
		ds_main_data_aprvlist.setRowType(idx, "i")
	}
}

//저장
function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	fSaveAprvList(grd_aprvlist);
}

function fSaveAprvList(srcGrid)
{				
	var oParam = {};
		oParam.id          = "TXCRA00101";
		oParam.service     = "rulemngtapp.RuleMngt";
		oParam.method      = "reqExeAprvList";
		oParam.inds        = "aprvlist=ds_main_data_aprvlist:A";
		oParam.outds       = "";
		oParam.async       = false;
		//oParam.callback    = "cf_TXCRA00101";
	tranf_submit(oParam);

	fSearchAprvlist();	
	ds_send.setColumn(0, "aprvlist", "");
}	

function grd_aprvlist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
{
	var row = ds_main_data_aprvlist.rowposition;
				
	var search_condition = "empnm";
	var search_term = ds_main_data_aprvlist.getColumn(row, "aprvusernm");
	
	frmf_setParameter("search_condition", search_condition);
	frmf_setParameter("search_term", search_term);
	
	var rtn = frmf_modal("SPCCM00400", "SPCCM00400", "", "", "", "", "", "", "", "", "", "", "M");
	
	if(!utlf_isNull(rtn))
	{
		ds_main_data_aprvlist.setColumn(row, "aprvuserid", rtn.empid);
		ds_main_data_aprvlist.setColumn(row, "aprvusernm", rtn.empnm);
		ds_main_data_aprvlist.setColumn(row, "posdeptcd", rtn.deptcd);
		ds_main_data_aprvlist.setColumn(row, "posdeptnm", rtn.deptnm);
	}
	
	frmf_clearParameter("search_condition");
	frmf_clearParameter("search_term");
	
	ds_main_data_aprvlist.updatecontrol = false;
	ds_main_data_aprvlist.setRowType(row, "u");
	ds_main_data_aprvlist.updatecontrol = true;
}
]]></Script>
  </Form>
</FDL>