55 lines
1.5 KiB
JavaScript
55 lines
1.5 KiB
JavaScript
const axios = require('axios');
|
|
const herader = {
|
|
'Content-Type': 'application/json',
|
|
'Uuid':"5e74228e138c4da891f9d49e198ed5b6"
|
|
}
|
|
const db=require("../comman/db")
|
|
let query = {"msisdn":"1441026718896","pageSize":10,"currentPage":1}
|
|
// testgetliuliang();
|
|
|
|
async function testgetliuliang(){
|
|
let resulat=await getliuliang(query);
|
|
console.log(resulat);
|
|
|
|
}
|
|
|
|
async function getsiminfobymsisdn(msisdn){
|
|
let query = {"msisdn":msisdn,"pageSize":10,"currentPage":1}
|
|
let resulat=await getliuliang(query);
|
|
return resulat;
|
|
|
|
}
|
|
exports.updatasimdb=updatasimdb;
|
|
const initdb=require("../comman/initdb")
|
|
async function updatasimdb(){
|
|
|
|
initdb.initdb();
|
|
let sql="select * from devuser where 1"
|
|
let result=await db.queryacy(sql);
|
|
for (let i = 0; i < result.length; i++) {
|
|
let siminfo=await getsiminfobymsisdn(result[i].simnumber);
|
|
// console.log(siminfo);
|
|
if(siminfo.length>0){
|
|
simtotal=siminfo[0].periodCanUsage
|
|
simused=siminfo[0].hasUseRate
|
|
simdateline=siminfo[0].exitTime
|
|
//更新simtotal和 simused simdateline
|
|
sql="update devuser set simtotal='"+simtotal+"',simused='"+simused+"',simdateline='"+simdateline+"' where autoid="+result[i].autoid;
|
|
|
|
await db.queryacy(sql);
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
async function getliuliang(query){
|
|
let result=await axios.post('https://api.wl1688.net/client/card/findMyPage', query, { headers: herader });
|
|
// console.log(result.data.data.list);
|
|
return result.data.data.list;
|
|
|
|
}
|
|
|