付款申请单

一、背景

客户已经做了预付款。然后走【采购发票】-【应付事项】流程 【应付事项】下推财务【付款】时，增加审批流流程：【付款申请单】。 【付款申请单】审批通过后进入财务【付款】单

二、能力清单

三、业务流程

• 开发单据：【付款申请单】

四、操作流程

五、数据建模

5.1、应付事项实体

• 该实体仅用来构建页面，不存储业务数据

5.2、付款申请实体

• 可通过复制已有实体:付款申请主表快速实现

5.3、付款申请支付明细实体

5.4、预付款申请实体

• 可通过复制【预付款申请】实体快速实现
• 该实体仅用来构建页面，不存储业务数据

六、页面建模

6.1、【付款申请】一主多子页面

• 新建【付款申请】一主多子类型

6.2、应付事项单表弹框

• 创建一个单表应付事项页面

• 进入页面设计器

• 调整页面布局
• 删除系统预制的按钮栏，工具栏
• 新增底部栏，添加两个按钮,实现如下布局

• 取消按钮绑定事件,点击配置填写以下函数，保存即可

function (event) {
  var viewModel = this;
  //关闭模态框
  viewModel.communication({type:'modal',payload:{data:false}});
}

• 调用开放平台【应付事项列表查询】接口，接口文档地址如下： 注意该地址是沙箱环境开放平台地址:
• https://open-dbox.yyuap.com/#/doc-center/docDes/api?code=yonbip&section=919fc8d70213459985e4afaa37d6d40a

• 新增API函数【应付事项列表查询】，如下图

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
    //使用公共函数--------------begin
    let func1 = extrequire("GT10894AT82.common.getOpenApiToken");
    let res = func1.execute(request);
    let configfun = extrequire("GT10894AT82.common.config");
    let config = configfun.execute(request);
    //使用公共函数--------------end
    var token = res.access_token;
    var deptId = request;
    var requrl = config.config.sandboxopenapiurl+"/yonbip/fi/oap/list?access_token="+token;
    var header = {'Content-Type':"application/json;charset=UTF-8"};
    var apiData = {
      "pageIndex":1,
      "pageSize":20
    }
    var queryQ = request.queryCondition;
    for(let i in queryQ){
      apiData[queryQ[i].itemName] = queryQ[i].value1;
    }
    var strResponse = postman("POST", requrl,JSON.stringify(header),JSON.stringify(apiData));
    var responseObj = JSON.parse(strResponse);
   return {responseObj};
 }
}
exports({"entryPoint":MyAPIHandler});

• 绑定页面初始化函数,并配置以下函数
• 函数主要功能调用应付事项API函数

function (event) {
  var viewModel = this;
  //取消自动查询
  viewModel.getParams().autoLoad = false;
  var gridModel = viewModel.getGridModel();
  //设置取消复现框
  gridModel.setState("showCheckBox",false);
  var queryCondition;
  //查询前事件
  viewModel.on("beforeSearch",function(params){
    queryCondition = params.params.condition.commonVOs;
  })
  //查询后事件
  viewModel.on("afterSearch",function(params){
    //调用应付事项接口
    cb.rest.invokeFunction("GT10894AT82.fioap.fiaoplist", {'queryCondition':queryCondition},
      function(err, res) {
        if(err!=null){
          cb.utils.alert(err,"error");
        }else{
          console.log(res);
          //循环增行
          var resP = res.responseObj.data.recordList;
          for(let i in resP){
            if(resP[i].id!=undefined)
            gridModel.appendRow(resP[i]);
          }
        }
    })    
  })
}

• 确定按钮绑定事件,点击配置填写以下函数，保存即可

• 新增获取应付事项详情API函数

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
    //使用公共函数--------------begin
    let func1 = extrequire("GT12951AT32.config.getApiAccessToken");
    let res = func1.execute(request);
    let configfun = extrequire("GT12951AT32.config.baseConfig");
    let config = configfun.execute(request);
    //使用公共函数--------------end
    var token = res.access_token;
    var id = request;
    var requrl = config.config.baseUrl+"/yonbip/fi/oap/detail?access_token="+token+"&id="+id;
    var header = {'Content-Type':"application/json;charset=UTF-8"};
    var strResponse = postman("GET", requrl,JSON.stringify(header));
    var responseObj = JSON.parse(strResponse);
   return {responseObj};
 }
}
exports({"entryPoint":MyAPIHandler});

• api函数插入付款申请

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
      var id = request.id;
      var code = request.code;
      //校验code是否已经存在
      var isCodeExist = ObjectStore.queryByYonQL('select code, id from GT12951AT32.GT12951AT32.paymentnishch where dr=0 and orderno="'+code+'"');
      if(isCodeExist.length>0){
        throw new Error("该单据已经生成付款申请单");
      }
      //获取应付事项详情
      let func1 = extrequire("GT12951AT32.fiaoplist.fioapdetail");
      let fiaopD = func1.execute(id);
      var insertData = fiaopD.responseObj.data;
      insertData.paybillbnishch2List = insertData.oapDetail;
      //查出来付款金额---只考虑子表有一条数据的情况,不做太复杂了
      var orderno = insertData.paybillbnishch2List[0].orderno;
      //设置原单金额
      insertData.sourcebillnum = insertData.oriSum;
      //查询付款申请进行抵消
      var chSum = ObjectStore.queryByYonQL('select oriSum, id,isSync from GT12951AT32.GT12951AT32.prepaymentnishch where dr=0 and  orderno="'+orderno+'"');
      if(chSum.length>0){
        for(let j in chSum){
          if(chSum[j].isSync=="2"){
            throw new Error("当前未同步付款的预付款申请流程");
          }
          insertData.oriSum = insertData.oriSum-chSum[j].oriSum;
        }
      }
      //子表款项类型=应付款
      insertData.paybillbnishch2List[0].quickType_code = "6";
      insertData.paybillbnishch2List[0].oriSum = insertData.oriSum;
      insertData.paybillbnishch2List[0].natSum = insertData.oriSum;
      insertData.paybillbnishch2List[0].product = insertData.paybillbnishch2List[0].material;//子表物料
      //主表金额
      insertData.natSum = insertData.oriSum;
      insertData.balance = insertData.oriSum;
      insertData.sourcebillcode = insertData.code;
      insertData.bustype = "2281177064296712";
      delete insertData.code;
      delete insertData.oapDetail;
      var res = ObjectStore.insert("GT12951AT32.GT12951AT32.paymentnishch2",insertData,"294cbb05");
   return {res};
 }
}
exports({"entryPoint":MyAPIHandler});

function (event) {
  var viewModel = this;
  //获取表格模型
  var gridModel = viewModel.getGridModel();
  //获取表格选中行
  var rows = gridModel.getSelectedRows();
  if(rows.length==0)return cb.utils.alert("请选择数据","alert");
  //执行保存逻辑
  cb.rest.invokeFunction("GT10894AT82.fioap.insertPayMentApply", {id:rows[0].id,code:rows[0].code},
  function(err, res) {
    if(err!=null){
      cb.utils.alert(err.message);
    }else{
      //获取父model
      var parentViewModel = viewModel.getCache('parentViewModel');
      //属性父model页面
      parentViewModel.execute("refresh");
      //关闭模态框
      viewModel.communication({type:'modal',payload:{data:false}});
    }
  })
}

6.3、付款申请列表新增【应付事项】按钮打开【应付事项弹框】

• 进入列表页面设计器新增一个按钮,修改多语标题为【应付事项】
• 页面布局可根据情况调整，不影响功能效果

• 应付事项按钮绑定点击事件，功能：打开【应付事项弹框】

function (event) {
  var viewModel = this;
  let data = {
    billtype: 'VoucherList',// 单据类型
    billno: '9b372483',// 单据号
    params: {
      mode: 'browse', 
    }
  };
  //打开一个单据，并在当前页面显示
  cb.loader.runCommandLine('bill', data, viewModel);
}

6.4、【付款申请列表】功能测试

• 预览，点击付款申请

• 点击模态框查询

• 选择一行数据保存，付款申请新增一条数据

6.5、【付款申请】卡片页面设计器内容调整

• 进入卡片页面设计器，调整布局

• 如下图调整布局,可根据情况调整，不影响功能效果

• 设置原单金额、是否同步不允许修改,其它根据情况调整，不影响功能效果

6.6、【付款申请】卡片联查预付款

• 实现效果如下

• 功能实现
• 调整预付款列表AP函数

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
     var orderno = request.orderno;
     var sql = "select distinct vouchdate ,accentity ,accentity.name, oriSum, natSum, balance, supplier, supplierbankname, supplierbankaccount_accountname,"+
                   " period,settlemode,currency,currency_priceDigit,currency_moneyDigit,natCurrency,code "+
                   "from GT12951AT32.GT12951AT32.prepaymentnishch where orderno = '"+orderno+"'";
     var res = ObjectStore.queryByYonQL(sql);
   return {res};
 }
}
exports({"entryPoint":MyAPIHandler});

• 初始化函数绑定前端函数，调用预付款列表API函数

function (event) {
  var viewModel = this;

  //数据加载完成之后
  viewModel.on("afterLoadData",function(){
    getPrePay();    
  })

  function getPrePay(){
    var gridModel = viewModel.get("paybillbapply0526List");
    //获取预付款表格
    var gridModelPre = viewModel.get("prepaymentchList");
    if(gridModelPre.getRows().length>0){
      //说明已经请求过数据不再发起请求
      return true;
    }
    var orderno = viewModel.get('orderno').getValue();
    cb.rest.invokeFunction("GT10894AT82.prepayment.getInfoByOrderNo", {orderno:orderno},
    function(err, res) {
      if(err!=null){
        cb.utils.alert(JSON.stringify(err));
      }else{
        var data = res.res
        for(let i in data){
           if(data[i].id!=undefined)
           preGridModel.appendRow(data[i]);
        }
      }
    })
  }
}

6.7、【付款申请】卡片，付款功能实现

• 目的：点击付款，调用付款保存接口，生成付款单

• 经过前面调用开放平台接口发现，可以经基本的请求进行一个封装

• 新增获取开放平台接口公共方法

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
    var reqBodyData = request.reqBody;
    var uri = request.uri;
     //获取开放平台token
    let tokenFun = extrequire("GT12951AT32.config.getApiAccessToken");
    let tokenRes = tokenFun.execute(request);
    var access_token = tokenRes.access_token;
    //获取配置文件基础路径
    let configFun = extrequire("GT12951AT32.config.baseConfig");
    let configRes = configFun.execute(request);
    var baseUrl = configRes.config.baseUrl;
    var useUrl = baseUrl+uri+"?access_token="+access_token;
    var header = {'Content-Type':"application/json;charset=UTF-8"};
    var strResponse = postman("POST", useUrl,JSON.stringify(header),JSON.stringify(reqBodyData));
    var responseObj = JSON.parse(strResponse);
   return {responseObj};
 }
}
exports({"entryPoint":MyAPIHandler});

• 新增付款保存api函数

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
    var main = request.params.billData;
    main._status = "Insert";
    var ch = request.params.billData.paybillbapply0526List;
    for(let i in ch){
      ch[i]._status = "Insert";
    }
    main.PayBillb = ch;
    delete main.paybillbapply0526List;
    var apiData = {"data":[main]};
    //apiData请求数据
    //使用公共函数--------------begin
    let func1 = extrequire("GT10894AT82.common.getOpenApiToken");
    let res = func1.execute(request);
    let configfun = extrequire("GT10894AT82.common.config");
    let config = configfun.execute(request);
    //使用公共函数--------------end
    var token = res.access_token;
    var deptId = request;
    var requrl = config.config.sandboxopenapiurl+"/yonbip/fi/payment/save?access_token="+token;
    var header = {'Content-Type':"application/json;charset=UTF-8"};
    var strResponse = postman("POST", requrl,JSON.stringify(header),JSON.stringify(apiData));
    var responseObj = JSON.parse(strResponse);
    if(responseObj.data.failCount==0){
      var object = {id:main.id,isSync:"1"};
      ObjectStore.updateById("GT10894AT82.GT10894AT82.paymentapply0526",object,"b1c1b909");
    }
   return {responseObj};
 }
}
exports({"entryPoint":MyAPIHandler});

• 付款申请卡片增加付款按钮，绑定前端函数点击事件，调用付款保存api函数

let AbstractAPIHandler = require('AbstractAPIHandler');
  class MyAPIHandler extends AbstractAPIHandler {
   execute(request){
    //调用了付款保存接口
    request.uri = "/yonbip/fi/payment/save";
    var reqBody = request.params.billData;
    reqBody._status = "Insert";
    reqBody.tradetype = reqBody.bustype;
    var ch = reqBody.paybillbnishch2List;
    for(let i  in ch){
      ch[i]._status = "Insert";
    }
    reqBody.PayBillb = ch;
    delete reqBody.paybillbnishch2List;
    request.reqBody = {"data":[reqBody]};
    let apiUtilFunc = extrequire("GT12951AT32.config.openApiUtils");
    let apiUtilRes = apiUtilFunc.execute(request);
    if(apiUtilRes.responseObj.data.failCount==0){
      var object = {id:reqBody.id,isSync:"1"};
      var res = ObjectStore.updateById("GT12951AT32.GT12951AT32.paymentnishch2",object,"294cbb05");
    }
   return {responseObj:apiUtilRes.responseObj};
 }
}
exports({"entryPoint":MyAPIHandler});

七、配置审批流

八、付款测试

• 预付款联查

• 付款前校验

• 审批单据

• 付款,多次付款会禁止

• 查看付款单,款项类型为:应付款
• 可根据情况，付款保存函数字段对应情况，此处仅实现流程并未完全对应