TimeUpdate.js 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. // 自动更新数据库的支付状态
  2. const {getUnixTimeStamp} = require('../until/time')
  3. const db_user = require('../database/d_user')
  4. const handle = require("../until/handle");
  5. const {payState_cancel} = require("../maps/field");
  6. let orders = [];
  7. let payLock = false;
  8. // 订单超过15分钟的自动过期
  9. let expire = 60 * 15;
  10. let timerHandle = null;
  11. function tick (t,fn){
  12. setTimeout(async ()=>{
  13. await fn();
  14. tick(t,fn);
  15. },t)
  16. }
  17. async function check(){
  18. if(payLock){
  19. return;
  20. }
  21. let nowUnix = getUnixTimeStamp();
  22. for (let i = 0; i < orders.length; i++) {
  23. let order = orders[i];
  24. if(!order){
  25. break;
  26. }
  27. if(nowUnix>order.endTime){
  28. let [err,result] = await handle(db_user.changeOrder(order.id,{payState:payState_cancel}));
  29. if(err){console.log(err)}
  30. console.log(`订单${order.id},超时过期`);
  31. }
  32. }
  33. }
  34. async function main(){
  35. let [err,result] = await handle(db_user.waitPayOrder());
  36. if(err){
  37. console.log('获取用户数据失败')
  38. console.error(err);
  39. }
  40. orders = result.map(order=>{
  41. return {
  42. id: order.id,
  43. endTime: order.createTime + expire
  44. }
  45. });
  46. tick(1000,check);
  47. }
  48. main();
  49. console.log('检测订单');
  50. async function payOrder(orderId){
  51. payLock=true;
  52. let [err,result] = await handle(db_user.payOrder(orderId));
  53. if(err){console.log(err)}
  54. }