router.get('/getinfo', function(req, res, next) {
var date = req.query.date == null ? null : req.query.date;
var post = req.query.post == null ? null : req.query.post;
var query = new AV.Query('TempInfo');
query.addDescending('updatedAt');
if (post != null) {
query.equalTo('post', post);
}
if (date != null) {
console.log(date);
query.greaterThan('updatedAt', new Date(date + ' 00:00:00'));
query.lessThan('updatedAt', new Date(date + ' 23:59:59'));
}
query.limit(1000);
query.addAscending('updatedAt');
query.find().then(function (resultes) {
console.log();
for (var i = 0 ; i < resultes.length; i++) {
resultes[i].updatedAt = moment(resultes[i].updatedAt).format("YYYY-MM-DD HH:mm:ss");
resultes[i].createdAt = moment(resultes[i].createdAt).format("YYYY-MM-DD HH:mm:ss");
}
var data = {
code : 200,
data : resultes,
message : '操作成功'
}
res.send(data);
});
});
AV.Cloud.define('checkAndUpdateUserOnlineStatus', function(request, response) {
var userDynamicQuery = new AV.Query(UserDynamicData);
var time = new Date().getTime() - 20 * 2 * 1000;
var date = new Date();
date.setTime(time);
userDynamicQuery.lessThan('updatedAt',date);
userDynamicQuery.find().then(function(results){
for (var i = 0; i < results.length; i++) {
var object = results[i];
object.set('onlineStatus', false);
object.save();
}
response.success({"code":200,"results":results.length + "个用户在线状态更新"});
}, function(error){
response.error({"code":500, "result":"查询用户列表异常(step=1), errormsg:" + error.message});
});
});
AV.Cloud.define('checkAndUpdateSpeedDataValid', function(request, response) {
var query = new AV.Query(SpeedDate);
var time = new Date().getTime() - 24 * 60 * 60 * 1000;
var date = new Date();
date.setTime(time);
query.equalTo('status', 1);
query.lessThan('createdAt',date);
query.equalTo('isValid', true);
query.find().then(function(results){
for (var i = 0; i < results.length; i++) {
var object = results[i];
object.set('isValid', false);
object.save();
}
response.success({"code":200,"results":results.length + "个SpeedDate记录无效"});
},
function(error){
response.error({"code":500, "result":"查询SpeedDate异常(setep=1) ,message=" + error.message});
});
});