|
- let AbstractTrigger = require('AbstractTrigger');
- class MyTrigger extends AbstractTrigger {
- execute(request){
-
- //获取当前日期yyyy-MM-dd格式
- let dtNow = new Date();
- let sNowYear = dtNow.getFullYear().toString();
- let sNowMonth = ((dtNow.getMonth() + 1).toString());
- sNowMonth = sNowMonth.length < 2 ? '0' + sNowMonth : sNowMonth;
- let sNowDay = dtNow.getDate().toString();
- sNowDay = sNowDay.length < 2 ? '0' + sNowDay : sNowDay;
- // let sNowFmt = sNowYear + "-" + sNowMonth + "-" + sNowDay;
- let sNowFmt = "2023-04-06";
-
- //更新交易类型-普通销售过账
- let sqlBustype1 = "select id from AT176AE5641C400003.AT176AE5641C400003.salesDailyIm where dDate='" + sNowFmt + "' and dailyRptBizType='1495263289144770567'";
- let resBustype1 = ObjectStore.queryByYonQL(sqlBustype1);
- for(let i = 0; i < resBustype1.length; i++){
- let inputType1 = {};
- inputType1["id"] = resBustype1[i].id;
- inputType1["bustype"]="1697945330186715143";
- inputType1["_status"]="Update";
- // var objectBustype1 = {"id":"","bustype:"1697945330186715143",_status:"Update"};
- ObjectStore.updateById("AT176AE5641C400003.AT176AE5641C400003.salesDailyIm",inputType1,"yb4a57bc49List");
- // throw new Error(JSON.stringify(resBustype1))
- }
-
- //更新交易类型-普通退货过账
- let sqlBustype2="select id from AT176AE5641C400003.AT176AE5641C400003.salesDailyIm where dDate='" + sNowFmt + "' and dailyRptBizType='1502611162156498946'";
- let resBustype2 = ObjectStore.queryByYonQL(sqlBustype2);
- for(let i = 0; i < resBustype2.length; i++){
- let inputType2 = {};
- inputType2["id"] = resBustype2[i].id;
- inputType2["bustype"]="1697945330186715143";
- inputType2["_status"]="Update";
- // var objectBustype1 = {"id":"","bustype:"1697945330186715143",_status:"Update"};
- ObjectStore.updateById("AT176AE5641C400003.AT176AE5641C400003.salesDailyIm",inputType2,"yb4a57bc49List");
- // throw new Error(JSON.stringify(resBustype1))
- }
-
- //主子实体一起查询,交易类型=【普通销售过账】
- let sqlPush1="select id from AT176AE5641C400003.AT176AE5641C400003.salesDailyIm where dDate='" + sNowFmt + "' and bustype ='1697945330186715143' and iscreatpo=0";
- let resPush1 = ObjectStore.queryByYonQL(sqlPush1);
- throw new Error(JSON.stringify(resPush1))
-
- //下推业务流1,交易类型为【普通销售过账】
- let billnum="yb4a57bc49"; //详情页单据编码
- let runleid="5e149076-d539-11ed-8167-fa163e279374"; //推单规则的id。打开业务流设计器,开启F12,点击规则,从list请求中获取
- let ids1 = [];
- // for(let i=0;i<resPush1.length;i++){
-
- // ids1.push(resPush1[i].id);
- // }
- resPush1.forEach(x => ids1.push(x.id));
- // let ids=["id1","id2"]; //填写上游单据的主键
-
- // ids1 = [...new Set(ids1)];
- busWorkFlowPush(billnum, runleid, ids1);
-
- //主子实体一起查询,交易类型=【普通退货过账】
- let sqlPush2 = "select id from AT176AE5641C400003.AT176AE5641C400003.salesDailyIm where dDate='" + sNowFmt + "' and bustype ='1697945493389180930' and iscreatpo=0";
- let resPush2 = ObjectStore.queryByYonQL(sqlPush2);
- // throw new Error(JSON.stringify(res2))
-
- //下推业务流2,交易类型为【普通退货过账】
- billnum = "yb4a57bc49"; //详情页单据编码
- runleid = "5e14ff48-d539-11ed-9f2d-fa163e278072"; //推单规则的id。打开业务流设计器,开启F12,点击规则,从list请求中获取
- let ids2 = [];
- resPush2.forEach(x => ids2.push(x.id));
- // let ids=["id1","id2"]; //填写上游单据的主键
- busWorkFlowPush(billnum, runleid, ids2);
-
- return {};
- }
- }
- exports({"entryPoint":MyTrigger});
复制代码 |
|