YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH04600_QI활동비부서별수령금액관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH04600" position="absolute 0 0 1198 766" titletext="QI활동비 부서별 수령금액 관리" oninit="SMRAH04600_oninit" onload="SMRAH04600_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="QI활동비 부서별 수령금액 관리" class="tit_1" position="absolute 0 0 302 25"/>
        <Shape id="line5" class="line_6" position="absolute 0 45 1195 51" anchor="left top right"/>
        <Button id="btn_print" taborder="1" text="출력" class="btn6" position="absolute 941 24 997 46" anchor="top right" onclick="btn_print_onclick"/>
        <Button id="btn_save" taborder="2" text="저장" class="btn4" position="absolute 999 24 1055 46" anchor="top right" onclick="btn_save_onclick"/>
        <Button id="btn_confirm" taborder="3" text="확정" class="btn4" position="absolute 1057 24 1113 46" anchor="top right" onclick="btn_confirm_onclick"/>
        <Button id="btn_cancel" taborder="4" text="확정취소" class="btn4" position="absolute 1115 24 1195 46" anchor="top right" onclick="btn_cancel_onclick"/>
        <Shape id="line1" class="line_10" position="absolute 0 119 1195 125" anchor="left top right"/>
        <Div id="group2" anchor="left top right" taborder="5" class="div_SA2" position="absolute 0 49 1195 89">
          <Layouts>
            <Layout>
              <Static id="caption9" text="구분" class="search_name" position="absolute 432 11 490 28"/>
              <Combo id="cmb_flagcd" taborder="1" innerdataset="@ds_init_codeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" position="absolute 486 10 630 29" onitemchanged="group2_cmb_flagcd_onitemchanged"/>
              <Combo id="cmb_instcd" taborder="2" enable="false" position="absolute 139 10 300 29" onitemchanged="group2_cmb_instcd_onitemchanged"/>
              <Static id="caption1" text="기관코드" class="search_name" position="absolute 60 11 140 28"/>
              <Shape id="line13" linetype="vertical" class="line_4" position="absolute 835 8 841 30" anchor="top right"/>
              <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 860 8 916 30" anchor="top right" onclick="group2_btn_search_onclick"/>
              <Combo id="cmb_cdid" taborder="4" innerdataset="@ds_init_dtlcodeinfo_codelist" codecolumn="cdid" datacolumn="cdnm" enable="false" position="absolute 726 10 810 29" onitemchanged="group2_cmb_cdid_onitemchanged"/>
              <Static id="caption3" text="상세구분" class="search_name" position="absolute 647 11 723 28"/>
              <Static id="caption5" text="년도" class="search_name" position="absolute 317 11 370 28"/>
              <MaskEdit id="ipt_year" taborder="5" type="string" mask="####" maskchar=" " trimtype="both" autoselect="true" autoskip="true" position="absolute 371 10 412 29"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption2" text="부서별 수령금액" class="tit_2" position="absolute 0 103 180 125"/>
        <Button id="btn_add" taborder="6" text="행추가" class="btn2" position="absolute 1003 100 1056 119" anchor="top right" onclick="btn_add_onclick"/>
        <Button id="btn_delete" taborder="7" text="행삭제" class="btn2" position="absolute 1059 100 1112 119" anchor="top right" onclick="btn_delete_onclick"/>
        <Grid id="grd_dedulist" taborder="8" binddataset="ds_main_datalist_dedulist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 124 1195 724" anchor="all" onexpanddown="grd_dedulist_onexpanddown">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="20" band="left"/>
                <Column size="0"/>
                <Column size="112"/>
                <Column size="104"/>
                <Column size="127"/>
                <Column size="166"/>
                <Column size="119"/>
                <Column size="109"/>
                <Column size="151"/>
                <Column size="400"/>
                <Column size="66"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="출력순서"/>
                <Cell col="2" colspan="2" text="부서" taborder="undefined"/>
                <Cell col="4" colspan="2" text="정산자" taborder="undefined"/>
                <Cell col="6" text="수령금액"/>
                <Cell col="7" text="계좌번호"/>
                <Cell col="8" text="계좌명"/>
                <Cell col="9" text="비고"/>
                <Cell col="10" text="확정여부"/>
                <Cell col="11" text="instcd"/>
                <Cell col="12" text="year"/>
                <Cell col="13" text="flagcd"/>
                <Cell col="14" text="cdid"/>
                <Cell col="15" text="old_buseocode"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="text" edittype="text" style="align:center middle;" text="bind:dispseq" mask="###" maskchar=" "/>
                <Cell col="2" displaytype="text" edittype="text" style="align:center middle;" text="bind:buseocode" expandshow="show"/>
                <Cell col="3" style="align:left middle;padding:0 0 0 3;" text="bind:buseoname"/>
                <Cell col="4" displaytype="text" edittype="text" style="align:center middle;" text="bind:sabun" expandshow="show"/>
                <Cell col="5" style="align:left middle;padding:0 0 0 3;" text="bind:usernm"/>
                <Cell col="6" displaytype="number" edittype="text" style="padding:0 3 0 0;" text="bind:amt"/>
                <Cell col="7" edittype="normal" style="align:left middle;padding:0 0 0 4;" text="bind:bankno"/>
                <Cell col="8" edittype="normal" style="align:left middle;padding:0 0 0 4;" text="bind:bankman"/>
                <Cell col="9" displaytype="text" edittype="text" style="padding:0 0 0 3;" text="bind:cmt"/>
                <Cell col="10" text="bind:cnfmyn"/>
                <Cell col="11" text="bind:instcd"/>
                <Cell col="12" text="bind:year"/>
                <Cell col="13" text="bind:flagcd"/>
                <Cell col="14" text="bind:cdid"/>
                <Cell col="15" text="bind:old_buseocode"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <MaskEdit id="ipt_sum" taborder="9" mask="(-)#,###.##" class="input_default" position="absolute 337 731 472 750" anchor="left bottom"/>
        <Static id="caption12" text="합 계 :" class="cell_1" position="absolute 265 729 335 752" style="align:center middle;font:Dotum,9,bold;" align="align:center middle;" anchor="left bottom"/>
        <Static id="caption4" text="※ 확정처리 후, 각 부서에 반영됩니다." position="absolute 970 59 1192 79" anchor="top right"/>
        <Button id="btn_download" taborder="10" text="엑셀출력" class="btn7" position="absolute 1115 100 1195 119" anchor="top right" onclick="btn_download_onclick"/>
        <Edit id="ipt_emplno" taborder="11" autoselect="true" autoskip="true" class="input_search" visible="false" position="absolute 296 99 366 118"/>
        <Button id="btn_emplno" taborder="12" onclick="btn_emplno_onclick" class="icon_search" visible="false" position="absolute 370 100 386 116"/>
        <Edit id="ipt_emplnm" taborder="13" class="input_search" enable="false" visible="false" position="absolute 390 99 465 118"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_retrparam_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="year" type="STRING" size="256"/>
          <Column id="flagcd" type="STRING" size="256"/>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cnfmyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="year"/>
            <Col id="flagcd"/>
            <Col id="cdid"/>
            <Col id="cnfmyn"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_datalist_dedulist" firefirstcount="0" firenextcount="0" useclientlayout="true" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_datalist_dedulist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="year" type="STRING" size="256" sumtext="년도"/>
          <Column id="flagcd" type="STRING" size="256" sumtext="구분코드"/>
          <Column id="cdid" type="STRING" size="256" sumtext="상세코드"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="dispseq" type="STRING" size="256" sumtext="출력순서"/>
          <Column id="amt" type="STRING" size="256" sumtext="금액"/>
          <Column id="cmt" type="STRING" size="256" sumtext="비고"/>
          <Column id="cnfmyn" type="STRING" size="256" sumtext="확정여부"/>
          <Column id="old_buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="sabun" type="STRING" size="256" sumtext="정산자사번"/>
          <Column id="usernm" type="STRING" size="256" sumtext="성명"/>
          <Column id="buseoname" type="STRING" size="256" sumtext="부서명"/>
          <Column id="bankno" type="STRING" size="256" sumtext="계좌번호"/>
          <Column id="bankman" type="STRING" size="256" sumtext="계좌명"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_codeinfo_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_init_dtlcodeinfo_codelist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_empldata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_datasum" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="sum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.cmb_instcd" propid="value" datasetid="ds_send_retrparam" columnid="instcd"/>
      <BindItem id="item1" compid="group2.ipt_year" propid="value" datasetid="ds_send_retrparam" columnid="year"/>
      <BindItem id="item2" compid="group2.cmb_flagcd" propid="value" datasetid="ds_send_retrparam" columnid="flagcd"/>
      <BindItem id="item3" compid="group2.cmb_cdid" propid="value" datasetid="ds_send_retrparam" columnid="cdid"/>
      <BindItem id="item4" compid="ipt_emplno" propid="value" datasetid="ds_empldata" columnid="emplno"/>
      <BindItem id="item5" compid="ipt_emplnm" propid="value" datasetid="ds_empldata" columnid="emplnm"/>
    </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_humtrafactmngtxp::RPB001.xjs";
function SMRAH04600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAH04600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dedulist);
	grdf_setRowTypeIcon(grd_dedulist, 0);
	
	misfGridInit(grd_dedulist);
	misfMsterDetailSet(grd_dedulist, null, "TRRAH04601" ,"Y");  //TRRAH03501

	misfComboInstCdListMulti("group2.cmb_instcd",utlf_getCurrentDate(),"","N");					   		     					
	
	ds_send_retrparam.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	ds_send_retrparam.setColumn(0, "year", String(utlf_getCurrentDate()).substr(0,4));

	var oParam = {};
		oParam.id          = "TRRAH04302";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQIComboList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_codeinfo_codelist=codelist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH04302";

	tranf_submit(oParam);
}

function group2_cmb_instcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(grd_dedulist);		
}

function ds_send_retrparam_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "year")
	{
		misfGridInit(grd_dedulist);		
	}
}

function group2_cmb_flagcd_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(grd_dedulist);	
	
	var oParam = {};
		oParam.id          = "TRRAH04602";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetQIDtlComboList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_init_dtlcodeinfo_codelist=codelist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAH04602";

	tranf_submit(oParam);
}

function cf_TRRAH04602(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) return;
    else
    {
		if(ds_init_dtlcodeinfo_codelist.rowcount > 0)
		{
			group2.cmb_cdid.enable = true;
		}
		else
		{
			group2.cmb_cdid.enable = false;
		}
		group2.cmb_cdid.value = "";
    }
}

function group2_cmb_cdid_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	misfGridInit(grd_dedulist);		
}

function group2_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	if(String(group2.ipt_year.value).length != 4) 
	{
		sysf_messageBox("년도를 확인하십시요. ", "E999", "");
		group2.ipt_year.setFocus();
		return;
	}	
	
	if(utlf_isNull(group2.cmb_flagcd.value))
	{
		sysf_messageBox("구분을 선택하십시요. ", "E999", "");
		group2.cmb_flagcd.setFocus();
		return;
	}	
	misfGridInit(grd_dedulist);
				
	misfMsterDetailRetrieve(); 
	
	fCalcSum(); //합계 계
}

function fCalcSum()
{					
	var sum = 0;	
	var amt = 0;
	
	for(var i = 0; i < ds_main_datalist_dedulist.rowcount; i++) 
	{
		amt = parseFloat(ds_main_datalist_dedulist.getColumn(i, "amt")); 
		
		sum += amt;
	}
	
	ipt_sum.value = sum;
}	

function grd_dedulist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
{
	if(e.cell == obj.getBindCellIndex("Body", "buseocode"))
	{
		misfOpenPopUpList("02", grd_dedulist, "", "buseocode,buseoname");	
	}
	else if(e.cell == obj.getBindCellIndex("Body", "sabun"))
	{
		btn_emplno.click();
		ds_main_datalist_dedulist.setColumn(ds_main_datalist_dedulist.rowposition, "sabun", ds_empldata.getColumn(0, "emplno"));
		ds_main_datalist_dedulist.setColumn(ds_main_datalist_dedulist.rowposition, "usernm", ds_empldata.getColumn(0, "emplnm"));
		
		ds_main_datalist_dedulist.updatecontrol = false;
		ds_main_datalist_dedulist.setRowType(ds_main_datalist_dedulist.rowposition, "u");
		ds_main_datalist_dedulist.updatecontrol = true;
	}
}

function ds_main_datalist_dedulist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "amt")
	{			
		fCalcSum();
	}	
}

function btn_emplno_onclick(obj:Button,  e:ClickEventInfo)
{
	rpbfOpenPopUpList("SPRPB00101", ipt_emplno, "emplno,emplnm", "", "N");
}

function btn_add_onclick(obj:Button,  e:ClickEventInfo)
{
	fAddDelRow( "A");	
}

function fAddDelRow(sStatus)
{
	if(sStatus == "A")
	{
		misfGridIUD(grd_dedulist, sStatus);
	}
	else if (sStatus == "D")
	{
		var status = ds_main_datalist_dedulist.getRowType(ds_main_datalist_dedulist.rowposition);

		if(status == 1) 
		{
			ds_main_datalist_dedulist.updatecontrol = false;
			ds_main_datalist_dedulist.setRowType(ds_main_datalist_dedulist.rowposition, "d");
			ds_main_datalist_dedulist.updatecontrol = true;
		}
		else if(status == 2) 
		{
			ds_main_datalist_dedulist.deleteRow(ds_main_datalist_dedulist.rowposition);
		}
		else if(status == 4)
		{
			ds_main_datalist_dedulist.updatecontrol = false;
			ds_main_datalist_dedulist.setRowType(ds_main_datalist_dedulist.rowposition, "d");
			ds_main_datalist_dedulist.updatecontrol = true;
		}
		else if(status == 8)
		{
			ds_main_datalist_dedulist.updatecontrol = false;
			ds_main_datalist_dedulist.setRowType(ds_main_datalist_dedulist.rowposition, "");
			ds_main_datalist_dedulist.updatecontrol = true;
		}
	}
}

function btn_delete_onclick(obj:Button,  e:ClickEventInfo)
{
	fAddDelRow("D");
}

function btn_download_onclick(obj:Button,  e:ClickEventInfo)
{
	if(ds_main_datalist_dedulist.rowcount == 0)
	{
		sysf_messageBox("조회된 결과가 존재하지 않습니다. \n\n먼저 조회 후 작업하십시요. ", "E999", "");							
		return;
	}

	grdf_exportExcel(grd_dedulist, "excel", "Sheet1", "true", "", "open");
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_makeValue(ds_send_retrparam, "flagnm", "string", group2.cmb_flagcd.text, 0);
	dsf_makeValue(ds_send_retrparam, "cdnm", "string", group2.cmb_cdid.text, 0);
	
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/datasum", ds_main_datasum);
		rptf_setNodeListToDOM(objDOM, "/root/send/retrparam", ds_send_retrparam);
		rptf_setNodeListToDOM(objDOM, "/root/main/datalist/dedulist", ds_main_datalist_dedulist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["SMRAH04601"],[objParam], option);
}

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

function btn_confirm_onclick(obj:Button,  e:ClickEventInfo)
{
	fConfirm("Y");
}

function btn_cancel_onclick(obj:Button,  e:ClickEventInfo)
{
	fConfirm("");	
}

function fSaveClick() 
{					
	var updtdata = grdf_getGridUpdateData(grd_dedulist).rowcount;
	
	if (updtdata == 0)
	{
		sysf_messageBox("변경된 데이터가","I004");
		return;
	}
						
	var oParam = {};
		oParam.id          = "TXRAH04601";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveQIDeptAmtList";
		oParam.inds        = "req=ds_main_datalist_dedulist:u";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH04601";

	tranf_submit(oParam);
}

function cf_TXRAH04601(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) return;
    else group2.btn_search.click();
}

function fConfirm(cnfmFlag) 
{														
	if(ds_main_datalist_dedulist.rowcount == 0)
	{
		sysf_messageBox("조회된 자료가 없습니다. 조회 후 처리하시기 바랍니다.", "E999", "");
		return;
	}	
	
	ds_send_retrparam.setColumn(0, "cnfmyn", cnfmFlag);
	
	var oParam = {};
		oParam.id          = "TXRAH04602";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveQIDeptAmtConfirm";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH04602";

	tranf_submit(oParam);
}

function cf_TXRAH04602(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) return;
    else group2.btn_search.click();
}
]]></Script>
  </Form>
</FDL>