if (arr.length > 0) {
const arrList = [];
arr.forEach(item => {
const send = {
actname: item.act_name, sid: item.sid, ordertitle: item.order_title, pubid: item.pub_id, jtksharerate: item.jtk_share_fee * 0.8, jtksharefee: item.jtk_share_fee, orderprice: item.order_price, payprice: item.pay_price, status: item.status, statusdesc: item.status_desc,
subsharerate: item.sub_share_rate, subsharefee: item.sub_share_fee, extension: item.extension, ordersn: item.order_sn, pay_time: item.pay_time, modified_time: item.modified_time,
};
arrList.push(send);
});
// console.log(arrList, 2222);
const dataList = await this.app.model.Order.bulkCreate(arrList, { updateOnDuplicate: ['actname', 'sid', 'ordertitle', 'pubid', 'jtksharerate', 'jtksharefee', 'orderprice', 'payprice', 'status', 'statusdesc', 'subsharerate', 'subsharefee', 'extension', 'ordersn', 'pay_time', 'modified_time'] });
// const dataList = await this.app.model.Order.bulkCreate(arrList, { updateOnDuplicate: arrList });
console.log(dataList, 666);
}
ordersn: {
type: STRING(100),
allowNull: false,
defaultValue: '',
comment: '订单号',
unique: true,
},
let params = [{"name": "张三", "age": 21},{"name": "小李", "age": 20}];
let where = ["张三","小李"];
let ParamsFind = await model.findAll({ //批量查询数据
attributes:['name','age'],
where:{
name:{
[Op.in]: where
}
}
})
for(let item of ParamsFind){ //查到的sql
for (var i = params .length - 1; i >= 0; i--) { //过滤的数组
if(params[i].name== item.dataValues.name) {
params.splice(i, 1);
}
}
}
let data = await model.bulkCreate(params);