YNU_JEUS/app_home/himed/xpapps/mis/accountinginfoxp/xp/SMRAR01200_신용카드사용신청.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAR01200" position="absolute 0 0 1198 757" titletext="신용카드 사용신청" oninit="SMRAR01200_oninit" onload="SMRAR01200_onload">
    <Layouts>
      <Layout>
        <Shape id="line2" class="line_6" position="absolute 0 45 1194 51" anchor="left top right"/>
        <Button id="btn_print" taborder="1" text="출력" class="btn4" position="absolute 1075 24 1131 46" anchor="top right" onclick="btn_print_onclick"/>
        <Button id="btn_save" taborder="2" text="저장" class="btn4" position="absolute 1137 24 1193 46" anchor="top right" onclick="btn_save_onclick"/>
        <Static id="caption6" text="신용카드 사용신청" class="tit_1" position="absolute 0 0 293 25"/>
        <Div id="grp_sea" taborder="3" class="div_SA2" position="absolute 0 49 1195 89" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="button2" taborder="1" text="조회" class="btn1" position="absolute 1123 9 1179 31" anchor="top right" onclick="grp_sea_button2_onclick"/>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 1104 8 1110 30" anchor="top right"/>
              <Calendar id="ipt_frdate" taborder="2" class="input_s_essential" position="absolute 100 9 200 28" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
              <Static id="caption3" text="신청일자 :" class="search_name" position="absolute 11 11 100 28"/>
              <Calendar id="ipt_todate" taborder="3" class="input_s_essential" position="absolute 220 9 320 28" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
              <Static id="caption2" text="~" position="absolute 205 10 220 30"/>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line3" class="line_10" position="absolute 0 114 1194 120" anchor="left top right"/>
        <Grid id="grd_main" taborder="4" binddataset="ds_main_maindatalist" useinputpanel="false" position="absolute 0 119 1194 754" autoenter="select" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="26"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="100"/>
                <Column size="60"/>
                <Column size="60"/>
                <Column size="80"/>
                <Column size="80"/>
                <Column size="190"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="260"/>
                <Column size="250"/>
                <Column size="60"/>
                <Column size="90"/>
                <Column size="140"/>
                <Column size="70"/>
                <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="실사용금액"/>
                <Cell col="9" text="사용처"/>
                <Cell col="10" text="사용시작"/>
                <Cell col="11" text="사용종료"/>
                <Cell col="12" text="신청사유"/>
                <Cell col="13" text="참석인원"/>
                <Cell col="14" text="부서장"/>
                <Cell col="15" text="품의번호"/>
                <Cell col="16" text="카드번호"/>
                <Cell col="17" text="카드수령자"/>
                <Cell col="18" text="instcd"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:lastupdtrid" editautoselect="true"/>
                <Cell col="2" displaytype="date" edittype="date" style="align:center middle;" class="input_s_essential" text="bind:requestdate" editautoselect="true" calendardisplaynulltype="nulltext"/>
                <Cell col="3" text="bind:usebuseo" editautoselect="true"/>
                <Cell col="4" text="bind:usebuseonm" editautoselect="true"/>
                <Cell col="5" text="bind:seqno" editautoselect="true"/>
                <Cell col="6" text="bind:adminjeamu" editautoselect="true"/>
                <Cell col="7" displaytype="number" edittype="normal" class="input_s_essential" text="bind:yskeum" editautoselect="true"/>
                <Cell col="8" displaytype="number" edittype="normal" class="input_s_essential" text="bind:silkeum" editautoselect="true"/>
                <Cell col="9" displaytype="text" edittype="text" class="input_s_essential" text="bind:useplace" editautoselect="true"/>
                <Cell col="10" displaytype="date" edittype="date" style="align:center middle;" class="input_s_essential" text="bind:frdate" editautoselect="true" calendardisplaynulltype="nulltext"/>
                <Cell col="11" displaytype="date" edittype="date" style="align:center middle;" class="input_s_essential" text="bind:todate" editautoselect="true" calendardisplaynulltype="nulltext"/>
                <Cell col="12" displaytype="text" edittype="text" class="input_s_essential" text="bind:requestcause" editautoselect="true"/>
                <Cell col="13" displaytype="text" edittype="text" class="input_s_essential" text="bind:attend" editautoselect="true"/>
                <Cell col="14" text="bind:admindept" editautoselect="true"/>
                <Cell col="15" text="bind:pumno" editautoselect="true"/>
                <Cell col="16" text="bind:cardno" editautoselect="true"/>
                <Cell col="17" text="bind:receiptsabun" editautoselect="true"/>
                <Cell col="18" text="bind:instcd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button18" taborder="5" text="행삭제" class="btn2" position="absolute 1140 94 1193 113" anchor="top right" onclick="button18_onclick"/>
        <Button id="btn_addrow" taborder="6" text="행추가" class="btn2" position="absolute 1083 94 1136 113" anchor="top right" onclick="btn_addrow_onclick"/>
        <Static id="caption21" text="출력 목록" class="tit_2" position="absolute 0 98 131 119"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="frdate" type="STRING" size="256"/>
          <Column id="todate" type="STRING" size="256"/>
          <Column id="cardsearchtype" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="frdate"/>
            <Col id="todate"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_maindatalist" 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="lastupdtrid" type="STRING" size="256" sumtext=""/>
          <Column id="requestdate" type="STRING" size="256" sumtext=""/>
          <Column id="usebuseo" type="STRING" size="256" sumtext=""/>
          <Column id="usebuseonm" type="STRING" size="256" sumtext=""/>
          <Column id="seqno" type="STRING" size="256" sumtext=""/>
          <Column id="adminjeamu" type="STRING" size="256" sumtext=""/>
          <Column id="yskeum" type="STRING" size="256" sumtext=""/>
          <Column id="silkeum" type="STRING" size="256" sumtext=""/>
          <Column id="useplace" type="STRING" size="256" sumtext=""/>
          <Column id="frdate" type="STRING" size="256" sumtext=""/>
          <Column id="todate" type="STRING" size="256" sumtext=""/>
          <Column id="requestcause" type="STRING" size="256" sumtext=""/>
          <Column id="admindept" type="STRING" size="256" sumtext=""/>
          <Column id="admindeptnm" type="STRING" size="256" sumtext=""/>
          <Column id="pumno" type="STRING" size="256" sumtext=""/>
          <Column id="cardno" type="STRING" size="256" sumtext=""/>
          <Column id="receiptsabun" type="STRING" size="256" sumtext=""/>
          <Column id="adminceo" type="STRING" size="256" sumtext=""/>
          <Column id="lastupdtdt" type="STRING" size="256" sumtext=""/>
          <Column id="fstrgstdt" type="STRING" size="256" sumtext=""/>
          <Column id="attend" type="STRING" size="256" sumtext=""/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_cardnolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256" sumtext=""/>
          <Column id="value" type="STRING" size="256" sumtext=""/>
          <Column id="jobposcd" type="STRING" size="256" sumtext=""/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_main_printdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="usebuseonm" type="STRING" size="256"/>
          <Column id="yskeum" type="STRING" size="256"/>
          <Column id="useplace" type="STRING" size="256"/>
          <Column id="frdate" type="STRING" size="256"/>
          <Column id="todate" type="STRING" size="256"/>
          <Column id="requestcause" type="STRING" size="256"/>
          <Column id="requestdate" type="STRING" size="256"/>
          <Column id="admindeptnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="usebuseonm"/>
            <Col id="yskeum"/>
            <Col id="useplace"/>
            <Col id="frdate"/>
            <Col id="todate"/>
            <Col id="requestcause"/>
            <Col id="requestdate"/>
            <Col id="admindeptnm"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <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 SMRAR01200_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAR01200_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_main);
	grdf_setRowTypeIcon(grd_main, 0);
	
	ds_send.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	
	var dt = new Date();
	var lastdt = new Date(dt.getYear(), dt.getMonth()+1, 0);
	grp_sea.ipt_frdate.value = String(utlf_getCurrentDate()).substr(0, 6) + "01";
	grp_sea.ipt_todate.value = String(utlf_getCurrentDate()).substr(0, 6) + lastdt.getDate();
	
	grp_sea.ipt_frdate.setFocus();
	
	var oParam = {};
		oParam.id          = "TRRAR01202";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "getCardNoList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_cardnolist=cardnolist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAR01202";

	tranf_submit(oParam);
	
	grp_sea.button2.click();
}

function grp_sea_button2_onclick(obj:Button,  e:ClickEventInfo)
{
	var oParam = {};
		oParam.id          = "TRRAR01101";
		oParam.service     = "accountinginfoapp.AccountingInfo";
		oParam.method      = "getCreditCardList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_maindatalist=maindatalist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAR01101";

	tranf_submit(oParam);
}

function btn_addrow_onclick(obj:Button,  e:ClickEventInfo)
{
	var insert_cnt = 0;						
	for ( var i = 0; i < ds_main_maindatalist.rowcount; i++ ) 
	{
		if(ds_main_maindatalist.getRowType(i) == "2")
		{
			insert_cnt = insert_cnt + 1 ;
		}
	}
	
	if ( insert_cnt > 0) 
	{
		alert("카드사용신청은 한번에 1건식 처리 가능합니다.\n\n1건만 저장 후 다시 해 주세요");
	}
	else
	{
		var addRow = ds_main_maindatalist.addRow();
		
		ds_main_maindatalist.setColumn(addRow, "instcd", sysf_getUserInfo("dutplceinstcd"));
		ds_main_maindatalist.setColumn(addRow, "lastupdtrid", sysf_getUserInfo("userid"));
		ds_main_maindatalist.setColumn(addRow, "receiptsabun", sysf_getUserInfo("userid"));
		ds_main_maindatalist.setColumn(addRow, "usebuseo", sysf_getUserInfo("dutplcecd"));
		ds_main_maindatalist.setColumn(addRow, "requestdate", utlf_getCurrentDate());
		
		if (String(ds_init_cardnolist.getColumn(0, "jobposcd")).length > 0 )
		{
			ds_main_maindatalist.setColumn(addRow, "admindept", sysf_getUserInfo("userid"));
		}
	}
}

function button18_onclick(obj:Button,  e:ClickEventInfo)
{
	if ( ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "adminjeamu") =="Y" ) 
	{
		alert("재무팀에서 확인된 자료의 삭제 불가 합니다!!");
	}
	else if (String(ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "pumno")).length > 0 )
	{
		alert("품의 번호가 있는 자료는 삭제 불가 합니다!!");
	}
	else
	{
		if(ds_main_maindatalist.getRowType(ds_main_maindatalist.rowposition) == "2")
		{
			ds_main_maindatalist.deleteRow(ds_main_maindatalist.rowposition);
		}
		else
		{
			ds_main_maindatalist.updatecontrol = false;
			ds_main_maindatalist.setRowType(ds_main_maindatalist.rowposition, "d");
			ds_main_maindatalist.updatecontrol = true;
		}
		btn_save.click();
	}   
}

function btn_print_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_main_maindatalist.rowposition < 0) 
	{
		alert("프린트할 Data를 선택해 주세요.");
	}
	else
	{
		ds_main_printdata.clearData();
		ds_main_printdata.addRow();
		
		ds_main_printdata.setColumn(0, "usebuseonm", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "usebuseonm"));
		ds_main_printdata.setColumn(0, "yskeum", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "yskeum"));
		ds_main_printdata.setColumn(0, "useplace", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "useplace"));
		ds_main_printdata.setColumn(0, "frdate", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "frdate"));
		ds_main_printdata.setColumn(0, "todate", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "todate"));
		ds_main_printdata.setColumn(0, "requestcause", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "requestcause"));
		ds_main_printdata.setColumn(0, "requestdate", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "requestdate"));
		ds_main_printdata.setColumn(0, "admindeptnm", ds_main_maindatalist.getColumn(ds_main_maindatalist.rowposition, "admindeptnm"));
		
		var objDOM = rptf_createDOM();
			rptf_setNodeListToDOM(objDOM, "/root/main/printdata", ds_main_printdata);
		var objParam = new Object();
			objParam.xml_data_XML1 = objDOM.documentElement.source;  
		var option = ""; 
		
		exeReportPreview("SMRAR01201", "XMLSTR");
	}
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	if(fSetChackValue()) 
	{
		rtn = sysf_messageBox("Data변경이 일어났습니다.","Q002");
		
		if ( rtn == "6" ) 
		{	
			var oParam = {};
				oParam.id          = "TXRAR01201";
				oParam.service     = "accountinginfoapp.AccountingInfo";
				oParam.method      = "setCreditcardRequest";
				oParam.inds        = "req=ds_main_maindatalist:u";
				oParam.outds       = "ds_=line";
				oParam.async       = false;
				oParam.callback    = "cf_TXRAR01201";

			tranf_submit(oParam);				
		}
	}		
}

function cf_TXRAR01201(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		grp_sea.button2.click();
	}
}

function fSetChackValue() 
{
	var updtdata = grdf_getGridUpdateData(grd_main).rowcount;
	if (updtdata == 0)
	{
		sysf_messageBox("변경된 데이터가","I004");
		return false;
	}
	var row = ds_main_maindatalist.rowposition;
	
	for ( var i = 0; i < ds_main_maindatalist.rowcount; i++ ) 
	{
		if ( ds_main_maindatalist.getRowType(i) == "2" || ds_main_maindatalist.getRowType(i) == "4")
		{
			if ( String(ds_main_maindatalist.getColumn(i, "pumno")).length > 0 )
			{
				alert("품의번호가 있는 예산 합의가 종료된 자료의 변경은 불가 합니다!!");
				ds_main_maindatalist.rowposition = i;
				return false;
			}
			
			if (  String(ds_main_maindatalist.getColumn(i, "yskeum")).length == 0)
			{
				sysf_messageBox("예상금액을" ,"C001");
				ds_main_maindatalist.rowposition = i;
				grd_main.setCellPos(grd_main.getBindCellIndex("body", "yskeum"));
				grd_main.showEditor(true);
				return false;
			}
			if (  String(ds_main_maindatalist.getColumn(i, "useplace")).length == 0)
			{
				sysf_messageBox("사용처를" ,"C001");
				ds_main_maindatalist.rowposition = i;
				grd_main.setCellPos(grd_main.getBindCellIndex("body", "useplace"));
				grd_main.showEditor(true);
				return false;
			}
			if (  String(ds_main_maindatalist.getColumn(i, "requestcause")).length == 0)
			{
				sysf_messageBox("신청사유를" ,"C001");
				ds_main_maindatalist.rowposition = i;
				grd_main.setCellPos(grd_main.getBindCellIndex("body", "requestcause"));
				grd_main.showEditor(true);
				return false;
			}
		}
	}
	return true;
}]]></Script>
  </Form>
</FDL>