online_facade.js 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. /**
  2. * Created by zhang on 2019/4/16.
  3. */
  4. module.exports = {
  5. setOnlineTimes:setOnlineTimes,
  6. getOnlineInfo:getOnlineInfo
  7. };
  8. let mongoose = require("mongoose");
  9. let logs_model = mongoose.model("online_logs");
  10. async function getOnlineInfo(filter) {
  11. let datas = [];
  12. let logs = await logs_model.find(filter, null, { sort: {_id: -1}});
  13. let less = 0;
  14. for(let l of logs){
  15. let d = getTimeString(l.online_times);
  16. let online_times = d.s;
  17. less += d.less;
  18. if(online_times!=""){
  19. datas.push({dateString:l.dateString,dateTime:l.online_times,online_times:online_times})
  20. }
  21. }
  22. if(datas.length>1){//大于2个才把不够1分钟的累积到最后一条记录
  23. let last = datas[datas.length - 1];
  24. last.online_times = getTimeString(last.dateTime + less).s;
  25. }
  26. return datas;
  27. }
  28. async function setOnlineTimes(userList,condition){
  29. for(let u of userList){
  30. let filter = {'userID':u._id.toString()};
  31. if(u.latest_used) filter["compilationID"] = u.latest_used;
  32. if(condition.latest_login && condition.latest_login == ""){
  33. let startTime = condition.latest_login['$gte']; //- 24*60*60*1000 //往前推一天 {'$gte': startTime, '$lt': endTime}latest_login
  34. filter['dateTime'] = {'$gte': startTime, '$lt': condition.latest_login['$lt']}
  35. }
  36. let result = await logs_model.aggregate([
  37. {$match: filter},
  38. {$group: {_id: "$userID", total: {$sum: "$online_times"}}}
  39. ]);
  40. u._doc.filter = JSON.stringify(filter);
  41. if(result.length > 0) u._doc.online_times = getTimeString(result[0].total).s;
  42. u._doc.online_list = await this.getOnlineInfo(filter);
  43. }
  44. }
  45. function getTimeString(times) {
  46. let s = "",perHour = 1000 * 60 * 60,perMin = 1000 * 60,perDay = 24*perHour;
  47. let day = parseInt(times/perDay);
  48. let hour = parseInt(parseInt(times % perDay) / perHour);
  49. let min = parseInt((times % perHour)/perMin);
  50. let less = (times % perHour)%perMin;//不够一分钟的时间
  51. if(day > 0) s = s+`${day}天`;
  52. if(hour > 0) s = s+`${hour}小时`;
  53. if(min > 0) s= s+`${min}分钟`;
  54. return {s:s,less:less}
  55. }