YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH02600_직원인건비내역.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH02600" position="absolute 0 0 834 580" titletext="직원인건비내역" oninit="SMRAH02600_oninit" onload="SMRAH02600_onload">
    <Layouts>
      <Layout>
        <Grid id="grd_dudulist" taborder="10" binddataset="ds_main_datalist_dedulist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 124 825 574" anchor="all" onexpanddown="grd_dudulist_onexpanddown" oncellclick="grd_dudulist_oncellclick">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="34"/>
                <Column size="106"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="86"/>
                <Column size="364"/>
                <Column size="0"/>
                <Column size="0"/>
                <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" text="지급일"/>
                <Cell col="3" text="사번"/>
                <Cell col="4" text="성명"/>
                <Cell col="5" text="금액"/>
                <Cell col="6" text="내  용"/>
                <Cell col="7" text="순번"/>
                <Cell col="8" text="old_jidate"/>
                <Cell col="9" text="old_sabun"/>
                <Cell col="10" text="year"/>
                <Cell col="11" text="bungi"/>
                <Cell col="12" text="gubun"/>
                <Cell col="13" text="buseocode"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" displaytype="checkbox" edittype="checkbox" text="bind:chk" expr="expr:chk == 'Y' ? 1 : 0"/>
                <Cell col="2" displaytype="date" edittype="date" text="bind:jidate" editautoselect="true" calendardisplaynulltype="nulltext"/>
                <Cell col="3" displaytype="text" edittype="text" text="bind:emplno" editautoselect="true" expandshow="show"/>
                <Cell col="4" text="bind:emplnm" editautoselect="true"/>
                <Cell col="5" displaytype="number" edittype="normal" text="bind:amt" editautoselect="true"/>
                <Cell col="6" displaytype="text" edittype="text" text="bind:cmt" editautoselect="true"/>
                <Cell col="7" text="bind:seq"/>
                <Cell col="8" text="bind:old_jidate"/>
                <Cell col="9" text="bind:old_emplno"/>
                <Cell col="10" text="bind:year"/>
                <Cell col="11" text="bind:bungi"/>
                <Cell col="12" text="bind:gubun"/>
                <Cell col="13" text="bind:buseocode"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" text="직원인건비 내역" class="tit_1" position="absolute 0 0 230 23"/>
        <Shape id="line5" class="line_6" position="absolute 0 45 825 51" anchor="left top right"/>
        <Button id="btn_print" taborder="3" text="영수증출력" class="btn6" position="absolute 615 24 707 46" anchor="top right" onclick="btn_print_onclick"/>
        <Button id="btn_save" taborder="4" text="저장" class="btn4" enable="false" position="absolute 709 24 765 46" anchor="top right" onclick="btn_save_onclick"/>
        <Button id="btn_close" taborder="5" text="닫기" class="btn4" position="absolute 767 24 823 46" anchor="top right" onclick="btn_close_onclick"/>
        <Grid id="grd_prntlist" taborder="6" binddataset="ds_main_prntlist" useinputpanel="false" cellsizingtype="col" autofittype="col" visible="false" position="absolute 235 234 725 309">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="27"/>
                <Column size="106"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="86"/>
                <Column size="89"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="지급일"/>
                <Cell col="2" text="사번"/>
                <Cell col="3" text="성명"/>
                <Cell col="4" text="금액"/>
                <Cell col="5" text="내  용"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:jidate"/>
                <Cell col="2" text="bind:emplno"/>
                <Cell col="3" text="bind:emplnm"/>
                <Cell col="4" text="bind:amt"/>
                <Cell col="5" text="bind:cmt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Shape id="line1" class="line_10" position="absolute 0 119 825 125" anchor="left top right"/>
        <Div id="group2" taborder="7" class="div_SA" position="absolute 0 49 825 89" anchor="left top right">
          <Layouts>
            <Layout>
              <Static id="caption9" text="년도 및 분기" class="search_name" position="absolute 35 11 134 28"/>
              <Static id="caption12" text="정산부서" class="search_name" position="absolute 492 11 570 28"/>
              <Static id="caption1" text="정산구분" class="search_name" position="absolute 285 11 365 28"/>
              <Static id="caption3" text="/ 4 분기" position="absolute 222 10 271 30"/>
              <Combo id="cmb_dateflag" taborder="5" codecolumn="codecolumn" datacolumn="datacolumn" enable="false" position="absolute 183 10 218 29">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">1</Col>
                      <Col id="datacolumn">1</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">2</Col>
                      <Col id="datacolumn">2</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">3</Col>
                      <Col id="datacolumn">3</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">4</Col>
                      <Col id="datacolumn">4</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Edit id="ipt_yyyy" taborder="6" enable="false" position="absolute 139 10 180 29" autoselect="true" autoskip="true"/>
              <Combo id="cmb_gubun" taborder="7" codecolumn="codecolumn" datacolumn="datacolumn" enable="false" position="absolute 366 10 470 29">
                <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>
              <Edit id="ipt_buseoname" taborder="8" enable="false" position="absolute 573 10 785 29"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption2" text="직원인건비 영수증 내역" class="tit_2" position="absolute 0 103 165 125"/>
        <Button id="btn_add" taborder="8" text="행추가" class="btn2" enable="false" position="absolute 715 100 768 119" anchor="top right" onclick="btn_add_onclick"/>
        <Button id="btn_delete" taborder="9" text="행삭제" class="btn2" enable="false" position="absolute 771 100 824 119" anchor="top right" onclick="btn_delete_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_retrparam" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="yyyy" type="STRING" size="256"/>
          <Column id="quarter" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="buseocode" type="STRING" size="256"/>
          <Column id="buseoname" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="yyyy"/>
            <Col id="quarter"/>
            <Col id="gubun"/>
            <Col id="buseocode"/>
            <Col id="buseoname"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_datalist_dedulist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_datalist_dedulist_oncolumnchanged">
        <ColumnInfo>
          <Column id="cmt" type="STRING" size="256" sumtext="비고"/>
          <Column id="amt" type="STRING" size="256" sumtext="금액"/>
          <Column id="year" type="STRING" size="256" sumtext="년도"/>
          <Column id="bungi" type="STRING" size="256" sumtext="분기"/>
          <Column id="buseocode" type="STRING" size="256" sumtext="부서코드"/>
          <Column id="gubun" type="STRING" size="256" sumtext="구분"/>
          <Column id="seq" type="STRING" size="256" sumtext="순번"/>
          <Column id="jidate" type="STRING" size="256" sumtext="지급일자"/>
          <Column id="emplno" type="STRING" size="256" sumtext="사번"/>
          <Column id="emplnm" type="STRING" size="256" sumtext="성명"/>
          <Column id="old_jidate" type="STRING" size="256" sumtext="지급일자"/>
          <Column id="old_emplno" type="STRING" size="256" sumtext="사번"/>
          <Column id="chk" type="STRING" size="256" sumtext="선택"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_prntlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="jidate" type="STRING" size="256"/>
          <Column id="emplno" type="STRING" size="256"/>
          <Column id="emplnm" type="STRING" size="256"/>
          <Column id="amt" type="STRING" size="256"/>
          <Column id="cmt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_datalist_oksigninfo" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="oksign" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="group2.ipt_yyyy" propid="value" datasetid="ds_send_retrparam" columnid="yyyy"/>
      <BindItem id="item1" compid="group2.cmb_dateflag" propid="value" datasetid="ds_send_retrparam" columnid="quarter"/>
      <BindItem id="item2" compid="group2.cmb_gubun" propid="value" datasetid="ds_send_retrparam" columnid="gubun"/>
      <BindItem id="item3" compid="group2.ipt_buseoname" propid="value" datasetid="ds_send_retrparam" columnid="buseoname"/>
    </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";

var toggleVal = "Y";
function SMRAH02600_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAH02600_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_dudulist);
	grdf_setRowTypeIcon(grd_dudulist, 0);
	
	grdf_initGrid(grd_prntlist);
	grdf_setRowTypeIcon(grd_prntlist, 0);
	
	if(frmf_checkOpener())
	{
		ds_send_retrparam.setColumn(0, "yyyy", opener.ds_send_retrparam.getColumn(0, "yyyy"));
		ds_send_retrparam.setColumn(0, "quarter", opener.ds_send_retrparam.getColumn(0, "quarter"));
		ds_send_retrparam.setColumn(0, "gubun", opener.ds_send_retrparam.getColumn(0, "gubun"));
		ds_send_retrparam.setColumn(0, "buseocode", opener.ds_send_retrparam.getColumn(0, "buseocode"));
		ds_send_retrparam.setColumn(0, "buseoname", opener.ds_send_retrparam.getColumn(0, "buseoname"));
	}	

	var oParam = {};
		oParam.id          = "TRRAH02601";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetDeduList";
		oParam.inds        = "req=ds_send_retrparam";
		oParam.outds       = "ds_main_datalist_dedulist=dedulist ds_main_datalist_oksigninfo=oksigninfo";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAH02601";

	tranf_submit(oParam);	
}

function cf_TRRAH02601(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		if (opener.ds_send_retrparam.getColumn(0, "opener") == "SMRAH01400") 
		{
			btn_save.enable = true;
			btn_add.enable = true;
			btn_delete.enable = true;
		} 
		else 
		{
			if(ds_main_datalist_oksigninfo.getColumn(0, "oksign") != "Y")
			{
				btn_save.enable = true;
				btn_add.enable = true;
				btn_delete.enable = true;
			}
		}	
	}
}

function grd_dudulist_onexpanddown(obj:Grid, e:GridMouseEventInfo)
{
	var recv_list = "emplno,emplnm" ;
	rpbfOpenPopUpList("SPRPB00101", grd_dudulist, recv_list,"","N");
}

function grd_dudulist_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	if( ds_main_datalist_dedulist.rowcount < 1 )
	{
		return;
	}
						
	if( e.row == -1 && e.cell == grd_dudulist.getBindCellIndex("Head", "chk"))
	{
		for(var i = 0; i < ds_main_datalist_dedulist.rows; i++) 
		{
			ds_main_datalist_dedulist.setColumn(i, "chk", toggleVal);
		}
		
		if( toggleVal == "Y" )
		{
			toggleVal = "N"
		}
		else 
		{
			toggleVal = "Y";
		}
		obj.setCellPos(obj.getBindCellIndex("body", "emplnm"));
		obj.showEditor(true);
	}
}

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


function fAddDelRow(sStatus)
{
	if(sStatus == "A")
	{
		var addRow = ds_main_datalist_dedulist.addRow();
		
		ds_main_datalist_dedulist.setColumn(addRow, "year", ds_send_retrparam.getColumn(0, "yyyy"));
		ds_main_datalist_dedulist.setColumn(addRow, "bungi", ds_send_retrparam.getColumn(0, "quarter"));
		ds_main_datalist_dedulist.setColumn(addRow, "gubun", ds_send_retrparam.getColumn(0, "gubun"));
		ds_main_datalist_dedulist.setColumn(addRow, "buseocode", ds_send_retrparam.getColumn(0, "buseocode"));		
	}
	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;
		}								
	}
}

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

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	misfGridInit(grd_prntlist);
					
	for(var i = 0; i < ds_main_datalist_dedulist.rowcount; i++) 
	{
		if(ds_main_datalist_dedulist.getColumn(i, "chk") == "Y") 
		{
			var addRow = ds_main_prntlist.addRow();
			
			ds_main_prntlist.setColumn(addRow, "jidate", ds_main_datalist_dedulist.getColumn(i, "jidate"));
			ds_main_prntlist.setColumn(addRow, "emplno", ds_main_datalist_dedulist.getColumn(i, "emplno"));
			ds_main_prntlist.setColumn(addRow, "emplnm", ds_main_datalist_dedulist.getColumn(i, "emplnm"));
			ds_main_prntlist.setColumn(addRow, "amt", ds_main_datalist_dedulist.getColumn(i, "amt"));
			ds_main_prntlist.setColumn(addRow, "cmt", ds_main_datalist_dedulist.getColumn(i, "cmt"));
		}
	}	

	if(ds_main_prntlist.rowcount < 1)
	{
		sysf_messageBox("출력할 대상이 선택되지 않았습니다. \n영수증 내역 중 출력할 대상을 선택하십시요. ", "E999", "");
		return;
	}	
	
	var objDOM = rptf_createDOM();
		rptf_setNodeListToDOM(objDOM, "/root/main/prntlist", ds_main_prntlist);
	var objParam = new Object();
		objParam.xml_data_XML1 = objDOM.documentElement.source; 
	var option = ""; 
	rptf_exeReportPreview30(["SMRAH02601"],[objParam], option);
}

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

function fSaveClick() 
{
	var updtdata = grdf_getGridUpdateData(grd_dudulist).rowcount;
	
	if (updtdata == 0) 
	{
		sysf_messageBox("변경된 데이터가","I004");
		return;
	}
	
	for(var i = 0; i < ds_main_datalist_dedulist.rowcount; i++)
	{
		if( ds_main_datalist_dedulist.getRowType(i) == 8 ) 
		{
			continue;
		}

		var sJiyear = String(ds_main_datalist_dedulist.getColumn(i, "jidate")).substr(0,4);
		var sJimonth = String(ds_main_datalist_dedulist.getColumn(i, "jidate")).substr(4,2);
		var yyyy = ds_send_retrparam.getColumn(0, "yyyy");
		var quarter = group2.cmb_dateflag.value;
		
		if(yyyy != sJiyear)
		{
			sysf_messageBox("[ " + i+1 + " ]번째 행의 지급일의 년도가 적합하지 않습니다.", "I000");
			return;
		}
		
		if(quarter == "1")
		{
			if(sJimonth < "01" || sJimonth > "03")
			{
				sysf_messageBox("[ " + i+1 + " ]번째 행의 지급일이 1분기에 적합하지 않습니다.", "I000");
				return;
			}
		}
		else if(quarter == "2")
		{
			if(sJimonth < "04" || sJimonth > "06")
			{
				sysf_messageBox("[ " + i+1 + " ]번째 행의 지급일이 2분기에 적합하지 않습니다.", "I000");
				return;
			}
		}
		else if(quarter == "3")
		{
			if(sJimonth < "07" || sJimonth > "09")
			{
				sysf_messageBox("[ " + i+1 + " ]번째 행의 지급일이 3분기에 적합하지 않습니다.", "I000");
				return;
			}
		}
		else if(quarter == "4")
		{
			if(sJimonth < "10" || sJimonth > "12")
			{
				sysf_messageBox("[ " + i+1 + " ]번째 행의 지급일이 4분기에 적합하지 않습니다.", "I000");
				return;
			}
		}
	}										
						
	var oParam = {};
		oParam.id          = "TXRAH02601";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveDeduList";
		oParam.inds        = "req=ds_main_datalist_dedulist:u";
		oParam.outds       = "";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH02601";

	tranf_submit(oParam);
}

function cf_TXRAH02601(sSvcId, nErrorCode, sErrorMsg)
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		var oParam = {};
			oParam.id          = "TRRAH02601";
			oParam.service     = "acntknuhapp.Acntknuh";
			oParam.method      = "reqGetDeduList";
			oParam.inds        = "req=ds_send_retrparam";
			oParam.outds       = "ds_main_datalist_dedulist=dedulist ds_main_datalist_oksigninfo=oksigninfo";
			oParam.async       = false;
			//oParam.callback    = "cf_TRRAH02601";

		tranf_submit(oParam);
		
		sysf_messageBox("저장되었습니다.", "I999", "");
	}
}

function btn_close_onclick(obj:Button,  e:ClickEventInfo)
{
	this.close();
}

function ds_main_datalist_dedulist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if( e.columnid == "chk" )
	{
		obj.setColumn(e.row, "chk", (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "N");
	}
}
]]></Script>
  </Form>
</FDL>