router.get('/', function(req, res, next) {
var status = 0;
var errMsg = null;
if (req.query) {
status = req.query.status || 0;
errMsg = req.query.errMsg;
}
var query = new AV.Query(Record);
query.equalTo('status', parseInt(status));
query.include('author');
query.descending('updatedAt');
query.limit(50);
query.find({
success: function(results) {
res.render('records', {
title: 'Record 列表',
user: AV.User.current(),
records: results,
status: status,
errMsg: errMsg
});
},
error: function(err) {
next(err);
}
})
});
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);
});
});
function getAgentCommissionRuleList(skip, limit) {
var agentCommissionRuleQuery = new AV.Query(AgentCommissionRule);
if (skip != null) {
agentCommissionRuleQuery.skip(skip);
}
if (limit != null) {
agentCommissionRuleQuery.limit(limit);
}
agentCommissionRuleQuery.equalTo('isDeleted', false);
return agentCommissionRuleQuery.find();
}
function getAgentCommissionRuleMapList(skip, limit) {
var agentCommissionRuleMapQuery = new AV.Query(AgentCommissionRuleMap);
if (skip != null) {
agentCommissionRuleMapQuery.skip(skip);
}
if (limit != null) {
agentCommissionRuleMapQuery.limit(skip);
}
agentCommissionRuleMapQuery.equalTo('isDeleted', false);
agentCommissionRuleMapQuery.include('source');
agentCommissionRuleMapQuery.include('agentCommissionRule');
return agentCommissionRuleMapQuery.find();
}
router.get('/', function(req, res, next) {
var query = new AV.Query(MoneyPackage);
query.limit(10);
query.addDescending('createdAt');
query.find().then(function(pkgs) {
res.render('money-package', {
moneyPackages: pkgs
});
}).catch(function(err) {
if (err.code === 101) {
res.render('money-package/index', {
moneyPackages: []
});
}
next(err);
});
});
function listOrdersP(user, skip, limit, state) {
var query = new AV.Query(Order);
query.equalTo('user', user);
query.equalTo('isDeleted', false);
query.descending('createdAt');
query.include(["route.source", "route.dest"]);
if (skip != null) {
query.skip(skip);
}
if (limit != null) {
query.limit(limit);
}
if (state != null) {
query.equalTo(state);
}
return query.find();
}
it('', function (done) {
this.timeout(10000000);
var query = new AV.Query(Model.User);
query.limit(1000);
query.find().done(function (userList) {
_.each(userList, function (user, index) {
setTimeout(function () {
InitiativeRecommend.initiativeRecommendToOneUser(user).done(function (re) {
console.info(re);
console.info(user.attributes);
}).fail(function (err) {
console.error(err);
console.error(user.attributes);
})
}, index * 100);
});
})
})
function getAgentList(skip, limit) {
var userQuery = new AV.Query(User);
if (skip != null) {
userQuery.skip(skip);
}
if (limit != null) {
userQuery.limit(limit);
}
userQuery.equalTo('isDeleted', false);
userQuery.equalTo('isAgent', true);
userQuery.include('agentInfo');
userQuery.include('agentInfo.agentSource');
userQuery.include('agentInfo.agentCommissionRule')
return userQuery.find();
}
new AV.Promise(resolve => {
let query1 = new AV.Query(ProductCategory1);
let query2 = new AV.Query(ProductCategory2);
query2.limit(1000);
{
//按index排序
query1.ascending('index');
//productMethod
query1.equalTo('productMethodId',productMethodId);
}
query1.find().done(items=> {
data = extend(data, {
category: items
});
query2.ascending('index');
return query2.find();
}).done(items2 => {
data.category.forEach(item1 => {
item1.contents = [];
items2.forEach(item2 => {
if (item1.get('category1Id') === item2.get('category1Id')) {
item1.contents.push(item2);
}
});
//对二级分类进行index排序
//item1.contents.sort((a,b)=> {
// return a.get('index') > b.get('index');
//});
});
resolve();
});
})
friendQuery.find().then(function(results){
var friendArray = [];
var y=0;
for(var i=0; i<results.length;i++){
var user = new User();
user.id = results[i].get('friendUserId');
friendArray[y] = user;
y=y+1;
}
//response.success({'results':friendArray});
var location = userDynamicData.get('location');
var userListQuery = new AV.Query(UserDynamicData);
userListQuery.near('location', location);
userListQuery.notContainedIn('datingStatus',[2,3,4]);
userListQuery.notContainedIn('objectId',[userDynamicData.id]);
userListQuery.notContainedIn('userId', friendArray);
userListQuery.equalTo('onlineStatus',true);
userListQuery.limit(10);
userListQuery.include("userId");
userListQuery.descending('reportedScore');
userListQuery.find().then(function(results){
var userArray = [];
var x=0;
for(var i=0;i<results.length;i++){
var distance = location.kilometersTo(results[i].get("location"));
if(results[i].get("userId")){
results[i]=results[i].get("userId");
results[i].add("distance",distance);
userArray[x]=results[i];
x=x+1;
}
}
var finalResult = {'code':200,'results':userArray};
response.success(finalResult);
},
function(error){
response.error({"code":500, "result":"查询用户列表(step=2), errormsg:" + error.message});
});
},
AV.Cloud.define('friendList', function(request, response) {
var userId = request.params.userId;
var count = request.params.count;
if(!userId || userId===''){
response.error({"code":500, "result":"参数不能为空"});
}else{
if(!count || count <=0){
count = 3;
}
var friendQuery = new AV.Query(Friend);
friendQuery.equalTo('userId', userId);
friendQuery.equalTo('isActive',true);
friendQuery.descending('updatedAt');
friendQuery.limit(count);
friendQuery.find().then(function(results){
return response.success({"code":200, "results":results});
},
function(error){
response.error({"code":500, "result":"查询好友列表异常, userId=" + userId + ", errormsg:" + error.message});
});
}
});
function(trade_obj) {
console.log("trade save");
var purse_query = new AV.Query(kongcv_purse_cls);
var trade_money = trade_obj.get("money");
var verify_trade_money = trade_obj.get("money");
var verify_trade_price = trade_obj.get("price");
if ("money" === pay_type || "balance" === pay_type) {
if (verify_trade_money != verify_trade_price) {
_kongcv_insert_trade_log(bill_id, request, "verify_price");
}
}
if ("money" === pay_type && "community" === mode) {
var park_obj = trade_obj.get("park_community");
if (typeof(park_obj) != "undefined") {
park_obj.set("park_space", 0);
}
park_obj.save().then(
function(park_obj) {
},
function(error) {
_kongcv_insert_trade_log(bill_id, request, "park_save" + error);
}
);
}
else if ("balance" === pay_type && "curb" === mode) {
var curb_rate = trade_obj.get("curb_rate");
var hirer_obj = trade_obj.get("hirer");
var user_obj = trade_obj.get("user");
purse_query.equalTo("user", hirer_obj);
purse_query.limit(1);
purse_query.find({
success : function(results) {
var hirer_purse_obj;
if (1 === results.length) {
hirer_purse_obj = results[0];
}
else if (0 === results.length) {
hirer_purse_obj = new kongcv_purse_cls();
hirer_purse_obj.set("user", hirer_obj);
}
var own_trade_money;
var own_rate;
if (curb_rate > 0) {
own_rate = curb_rate;
}
else {
own_rate = kongcv_rate;
}
own_trade_money = trade_money * own_rate;
if (own_trade_money > limit_price) {
own_trade_money = parseInt(own_trade_money);
}
else {
own_trade_money = Number(own_trade_money.toFixed(2));
}
var tmp_purse_amount = hirer_purse_obj.get("amount");
var tmp_purse_money = hirer_purse_obj.get("money");
var tmp_new_purse_amount = tmp_purse_amount + own_trade_money;
var tmp_new_purse_money = tmp_purse_money + own_trade_money;
hirer_purse_obj.set("amount", Number(tmp_new_purse_amount.toFixed(2)));
hirer_purse_obj.set("money", Number(tmp_new_purse_money.toFixed(2)));
//hirer_purse_obj.increment("amount", own_trade_money);
//hirer_purse_obj.increment("money", own_trade_money);
hirer_purse_obj.save().then(
function(hirer_purse_obj) {
},
function(error) {
_kongcv_insert_trade_log(bill_id, request, "hirer_purse_save" + error);
}
);
},
error : function(error) {
_kongcv_insert_trade_log(bill_id, request, "hirer_purse_query" + error);
}
});
}
console.log("expense start");
if ("handsel" != pay_type) {
purse_query.equalTo("user", user_obj);
purse_query.limit(1);
purse_query.find({
success : function(results) {
var user_purse_obj;
if (1 === results.length) {
user_purse_obj = results[0];
}
else if (0 === results.length) {
user_purse_obj = new kongcv_purse_cls();
user_purse_obj.set("user", user_obj);
}
var tmp_purse_expense = user_purse_obj.get("expense");
var tmp_new_purse_expense = tmp_purse_expense + trade_money;
user_purse_obj.set("expense", Number(tmp_new_purse_expense.toFixed(2)));
//user_purse_obj.increment("expense", trade_money);
user_purse_obj.save().then(
function(user_purse_obj) {
console.log("expense save");
},
function(error) {
_kongcv_insert_trade_log(bill_id, request, "user_purse_save" + error);
}
);
},
error : function(error) {
_kongcv_insert_trade_log(bill_id, request, "user_purse_query" + error);
}
});
}
},