YNU_JEUS/app_home/himed/xpapps/mis/acntknuhxp/xp/SMRAH02400_계산서(청구)발급분조회및입금확인.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRAH02400" position="absolute 0 0 1200 731" titletext="계산서(청구) 발급분 조회 및 입금 확인" oninit="SMRAH02400_oninit" onload="SMRAH02400_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="계산서(청구) 발급분 조회 및 입금 확인" class="tit_1" position="absolute 0 0 293 25"/>
        <Shape id="line2" class="line_6" position="absolute 0 45 1195 51" anchor="left top right"/>
        <Button id="btn_save" taborder="1" text="저장" class="btn4" position="absolute 1138 24 1194 46" anchor="top right" onclick="btn_save_onclick"/>
        <Div id="grp_sea" taborder="2" class="div_SA2" position="absolute 0 49 1195 89" anchor="left top right">
          <Layouts>
            <Layout>
              <Shape id="line5" linetype="vertical" class="line_4" position="absolute 1022 7 1028 34" anchor="top right"/>
              <Button id="btn_search" taborder="5" text="조회" class="btn1" position="absolute 1045 10 1101 32" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption1" text="조회일자 :" class="search_name" position="absolute 55 12 127 29"/>
              <Static id="cap_1" text="~" position="absolute 244 13 259 28"/>
              <Calendar id="ipt_todd" taborder="6" class="input_default" position="absolute 257 10 361 29" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
              <Calendar id="ipt_fromdd" taborder="7" class="input_default" position="absolute 138 10 242 29" mask="yyyy-mm-dd" autoselect="true" autoskip="true"/>
              <Static id="caption2" text="신청부서 :" class="search_name" position="absolute 385 11 475 28"/>
              <Combo id="cmb_buseocode" taborder="8" innerdataset="@ds_init_buseocodeinfo_buseolist" codecolumn="buseocode" datacolumn="deptnm" class="combo_default" enable="false" position="absolute 477 10 675 29"/>
              <Static id="caption8" text="입금일자 :" class="search_name" position="absolute 710 11 800 28"/>
              <Radio id="rdo_gubun" taborder="9" columncount="-1" rowcount="-1" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 800 10 960 30">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">미입력</Col>
                      <Col id="datacolumn">미입력</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">입력</Col>
                      <Col id="datacolumn">입력</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">전체</Col>
                      <Col id="datacolumn">전체</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Radio>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption21" text="계산서(청구) 발급분 조회" class="tit_2" position="absolute 0 103 175 124"/>
        <Shape id="line3" class="line_10" position="absolute 0 119 1195 125" anchor="left top right"/>
        <Grid id="datagrid1" taborder="3" binddataset="ds_main_itemgridlist_list" useinputpanel="false" position="absolute 0 124 1195 724" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="23"/>
                <Column size="66"/>
                <Column size="79"/>
                <Column size="78"/>
                <Column size="227"/>
                <Column size="73"/>
                <Column size="320"/>
                <Column size="83"/>
                <Column size="68"/>
                <Column size="68"/>
                <Column size="90"/>
                <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="기관코드"/>
              </Band>
              <Band id="body">
                <Cell celltype="head"/>
                <Cell col="1" text="bind:noseq" editautoselect="true"/>
                <Cell col="2" displaytype="date" text="bind:inputymd" editautoselect="true" expandshow="hide" calendardisplaynulltype="nulltext"/>
                <Cell col="3" displaytype="date" text="bind:sekeumdate" editautoselect="true" expandshow="hide" calendardisplaynulltype="nulltext"/>
                <Cell col="4" text="bind:custnm" editautoselect="true"/>
                <Cell col="5" text="bind:custcode" editautoselect="true"/>
                <Cell col="6" text="bind:kyname" editautoselect="true"/>
                <Cell col="7" displaytype="number" text="bind:kykeumak" editautoselect="true"/>
                <Cell col="8" text="bind:usernm" editautoselect="true"/>
                <Cell col="9" text="bind:usernm2" editautoselect="true"/>
                <Cell col="10" displaytype="date" edittype="date" text="bind:ibymd" editautoselect="true" expandshow="hide" calendardisplaynulltype="nulltext"/>
                <Cell col="11" text="bind:instcd"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="button1" taborder="4" text="엑셀출력" class="btn7" position="absolute 1115 98 1195 117" anchor="top right" onclick="button1_onclick"/>
      </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="fromdd" type="STRING" size="256"/>
          <Column id="todd" type="STRING" size="256"/>
          <Column id="buseocode" type="STRING" size="256"/>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="gubun" type="STRING" size="256"/>
          <Column id="sekeumgubun" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="fromdd"/>
            <Col id="todd"/>
            <Col id="buseocode"/>
            <Col id="instcd"/>
            <Col id="gubun"/>
            <Col id="sekeumgubun"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_itemgridlist_list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_itemgridlist_list_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256" sumtext="기관코드"/>
          <Column id="noseq" type="STRING" size="256" sumtext="신청번호"/>
          <Column id="inputymd" type="STRING" size="256" sumtext="신청일자"/>
          <Column id="sekeumdate" type="STRING" size="256" sumtext="계산서일자"/>
          <Column id="custnm" type="STRING" size="256" sumtext="거래처명"/>
          <Column id="custcode" type="STRING" size="256" sumtext="거래처코드"/>
          <Column id="kyname" type="STRING" size="256" sumtext="계약건명"/>
          <Column id="kykeumak" type="STRING" size="256" sumtext="계약금액"/>
          <Column id="usernm" type="STRING" size="256" sumtext="담당자"/>
          <Column id="usernm2" type="STRING" size="256" sumtext="부서장"/>
          <Column id="ibymd" type="STRING" size="256" sumtext="입금일자"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_buseocodeinfo_buseolist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="deptnm" type="STRING" size="256"/>
          <Column id="buseocode" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_authchk_userauth" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="slipreqapproval" type="STRING" size="256" sumtext="전표승인요청권한"/>
          <Column id="slipreqcancel" type="STRING" size="256" sumtext="전표승인요청취소권한"/>
          <Column id="sliprecognition" type="STRING" size="256" sumtext="전표승인권한"/>
          <Column id="slipcancel" type="STRING" size="256" sumtext="전표승인취소권한"/>
          <Column id="authmgt" type="STRING" size="256" sumtext="권한부여 권한"/>
          <Column id="etctax" type="STRING" size="256" sumtext="기타소득세 권한"/>
          <Column id="custstat" type="STRING" size="256" sumtext="거래처지급중지권한"/>
          <Column id="rcvcheck" type="STRING" size="256" sumtext="계산서입금확인권한"/>
          <Column id="incmcnfm" type="STRING" size="256" sumtext="소득확인현황권한"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_temp_prvg" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cnt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_send" columnid="fromdd"/>
      <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_send" columnid="todd"/>
      <BindItem id="item2" compid="grp_sea.cmb_buseocode" propid="value" datasetid="ds_send" columnid="buseocode"/>
      <BindItem id="item3" compid="grp_sea.rdo_gubun" propid="value" datasetid="ds_send" 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 SMRAH02400_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRAH02400_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(datagrid1);
	grdf_setRowTypeIcon(datagrid1, 0);
	
	fOpenForm();
}

function fOpenForm() 
{
	ds_main_itemgridlist_list.clearData();
	
	ds_send.setColumn(0, "sekeumgubun", "2");
	
	var oParam = {};
		oParam.id          = "TRRAH02403";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetbuseoList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_init_buseocodeinfo_buseolist=buseolist";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAH02403";

	tranf_submit(oParam);

	var vdate = utlf_getCurrentDate();
	grp_sea.ipt_fromdd.value = String(vdate).substr(0,4) - 1 + String(vdate).substr(4,4);
	grp_sea.ipt_todd.value = vdate;
	
	grp_sea.rdo_gubun.value = "미입력";

	var instcd = sysf_getUserInfo("dutplceinstcd");
	
	ds_send.setColumn(0, "instcd", instcd);
	
	var oParam = {};
		oParam.id          = "TRRAI00301";
		oParam.service     = "accountinfoapp.AccountInfo";
		oParam.method      = "reqGetAuthchk";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_temp_authchk_userauth=userauth";
		oParam.async       = false;
		oParam.callback    = "cf_TRRAI00301";

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

function cf_TRRAH02403(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		return;
	}
	else
	{
		frmf_addComboItem("grp_sea.cmb_buseocode","--전체--","%","above");
	}
}

function cf_TRRAI00301(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0) 
    {
		grp_sea.btn_search.enable = false;
		btn_save.enable = false;
		return;
	}
	else
	{
		if(ds_temp_authchk_userauth.getColumn(0, "rcvcheck") != "Y")
		{
			sysf_messageBox("해당 프로그램의 사용 권한이 없습니다. " + "\n\n" + 
								"권한 부여에 관해서는 재무파트의 담당자에게 문의바랍니다. ", "C000");
			grp_sea.btn_search.enable = false;
			btn_save.enable = false;
			return;
		}	
		
		var oParam = {};
			oParam.id          = "TRRAH02402";
			oParam.service     = "acntknuhapp.Acntknuh";
			oParam.method      = "reqGetMngtPrvg";
			oParam.inds        = "req=ds_send";
			oParam.outds       = "ds_temp_prvg=prvglist";
			oParam.async       = false;
			oParam.callback    = "cf_TRRAH02402";

		tranf_submit(oParam);
	}
}

function cf_TRRAH02402(sSvcId, nErrorCode, sErrorMsg) 
{
    if(nErrorCode < 0)
    {
		return;
	}
	else
	{
		if(ds_temp_prvg.getColumn(0, "cnt") == "1")
		{
			grp_sea.cmb_buseocode.enable = true;
			grp_sea.cmb_buseocode.value = "%";
		}
		else 
		{
			grp_sea.cmb_buseocode.value = sysf_getUserInfo("dutplcecd");
		}
	}
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetNoteList();
}

function fGetNoteList()
{
	var oParam = {};
		oParam.id          = "TRRAH02401";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqGetDeptTaxList";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_main_itemgridlist_list=list";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRAH02401";

	tranf_submit(oParam);
}

function ds_main_itemgridlist_list_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid = "ibymd")
	{
		var datalength = String(e.newvalue).length;
		
		if(datalength != 0 && datalength != 8) 
		{
			sysf_messageBox("입금일자가 정확하지 않습니다. 다시 입력하십시요. " , "E999", "");
			obj.setColumn(e.row, "ibymd", "");
			return;
		}
	}
}

function button1_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(datagrid1, "excel", "", false, "", "user", false);
}

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

function fSaveData()
{
	var oParam = {};
		oParam.id          = "TXRAH02401";
		oParam.service     = "acntknuhapp.Acntknuh";
		oParam.method      = "reqExeSaveDeptTaxList";
		oParam.inds        = "req=ds_main_itemgridlist_list:u";
		oParam.outds       = "ds_=seqno";
		oParam.async       = false;
		oParam.callback    = "cf_TXRAH02401";

	tranf_submit(oParam);
}

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