51 lines
2.1 KiB
JavaScript
51 lines
2.1 KiB
JavaScript
const Service = require('egg').Service;
|
|
const { v4: uuidv4 } = require('uuid');
|
|
const axios = require('axios');
|
|
|
|
class Express extends Service {
|
|
async aotoCheckLanshou(){
|
|
let orders = await this.app.mysql.get('dbwms').query(`
|
|
select POSTNUM,POSTCODE from yj_wmsorder where DISPLAYFLAG=0 and OPERATERECORDS not like "%揽收%" and WAREHOUSEID=5400 and POSTFLAG=1 and POSTCODE in ('p01','p02','p03','p04','p32');
|
|
`);
|
|
let pageSize = 200;
|
|
let responses = [];
|
|
let page_count = parseInt(orders.length / pageSize);
|
|
const apiUrl = 'http://express.gztbyc.com/query_tasks2';
|
|
for (let i = 0; i < page_count+1; i++) {
|
|
const promises = orders.slice(i*pageSize, (i+1)*pageSize).map(async order => {
|
|
try {
|
|
/* code */
|
|
let parmas = [`${order.POSTNUM}|${order.POSTNUM}|${order.POSTCODE}`];
|
|
const response = await axios.post(apiUrl, parmas);
|
|
if(response.data.length>0){
|
|
responses.push(response.data[0].waybillNo);
|
|
}
|
|
} catch (e) {
|
|
console.log(e);
|
|
}
|
|
})
|
|
await Promise.all(promises);
|
|
}
|
|
let postnums = responses.map(item=>{
|
|
return `'${item}'`;
|
|
})
|
|
postnums = postnums.join(",")
|
|
const currentTime =await this.getCurrentChinaTime();
|
|
let sql = `UPDATE yj_wmsorder SET OPERATERECORDS = CONCAT(OPERATERECORDS, '检测到揽收;${currentTime};自动任务|') WHERE POSTNUM IN (${postnums})`;
|
|
const result = await this.app.mysql.get('dbwms').query(sql);
|
|
return [result,postnums];
|
|
}
|
|
async getCurrentChinaTime() {
|
|
const now = new Date();
|
|
|
|
const year = now.getFullYear();
|
|
const month = String(now.getMonth() + 1).padStart(2, '0'); // 补零
|
|
const day = String(now.getDate()).padStart(2, '0'); // 补零
|
|
const hours = String(now.getHours()).padStart(2, '0'); // 补零
|
|
const minutes = String(now.getMinutes()).padStart(2, '0'); // 补零
|
|
const seconds = String(now.getSeconds()).padStart(2, '0'); // 补零
|
|
|
|
return `${year}年${month}月${day}日 ${hours}:${minutes}:${seconds}`;
|
|
}
|
|
}
|
|
module.exports = Express; |