param.targets.forEach(function(target) {
var query = new AV.Query(target.leancloudClass);
query.equalTo('size', model.modelSize);
query.equalTo('loadGrade', model.loadGrade);
query.equalTo(param.leancloudName, param.roundedValue);
query.find().then(function(results) {
queryCount += 1;
if (results.length == 1) {
console.log(target.name + '查找成功');
target.value = results[0].get('value');
} else if (results.length > 1) {
console.log('***' + target.name +'结果不唯一');
} else {
console.log('***' + target.name + '无匹配结果');
}
},
function(error) {
console.log('Error: ' + error.code + ' ' + error.message);
})
.then(function(results) {
if (queryCount === 8) {
queryCount = 0;
callback();
}
});
});
lines.forEach(function (l) {
var parts = l.split(' ');
var credential = new Credential();
credential.set('protocol', parts[0]);
credential.set('host', parts[2]);
credential.set('username', parts[5]);
credential.set('password', parts[8]);
var query = new AV.Query(Credential);
query.equalTo('protocol', parts[0]);
query.equalTo('host', parts[2]);
query.equalTo('username', parts[5]);
query.equalTo('password', parts[8]);
query.first().then(function (c) {
if (!c) {
return credential.save();
}
}, function (err) {
return credential.save();
}).then(function (c) {
console.log(c.id);
}, function (err) {
console.log(err);
})
})
/*记录订单支付的交易信息
params :order(object)[DBdoc中的格式], charge(object)[ping++返回的charge对象], isFinished(boolean)
在数据库里创建一个新的transaction
*/
function logOrderPayTransactionP(order, charge, isFinished) {
var query = new AV.Query(Transaction);
query.equalTo('order', order);
query.equalTo('chargeId', charge.id);
return query.find().then(function (results) {
if (results.length == 0) {
var transaction = new Transaction();
transaction.set('chargeId', charge.id);
transaction.set('order', order);
transaction.set('user', order.get('user'));
transaction.set('channel', charge.channel);
transaction.set('amount', charge.amount);
transaction.set('currency', charge.currency);
transaction.set('type', 'pay');
transaction.set('paid', charge.paid);
transaction.set('extra',JSON.stringify(charge.extra));
transaction.set('isFinished', isFinished);
transaction.set('isDeleted', false);
return transaction.save();
} else {
results[0].set('paid', charge.paid);
results[0].set('isFinished', isFinished);
results[0].set('extra',JSON.stringify(charge.extra));
return results[0].save();
}
});
}
.then(function(result) {
var src = new Location();
src.id = result.get('source').id;
var agentInfoQuery = new AV.Query('AgentInfo');
agentInfoQuery.equalTo('agentSource', src);
agentInfoQuery.equalTo('isDeleted', false);
return agentInfoQuery.find();
})
userDynamicQuery.get(userDynamicDataId).then(function(userDynamicData){
if(userDynamicData){
//查询用户好友列表，作为排除
var friendQuery = new AV.Query(Friend);
friendQuery.equalTo('userId', userDynamicData.get("userId").id);
friendQuery.equalTo('isActive',true);
friendQuery.descending('updatedAt');
//friendQuery.limit(10);
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});
});
},
function(error){
response.error({"code":500, "result":"查询好友列表异常, userId=" + userId + ", errormsg:" + error.message});
});
}else{
response.error({"code":500, "result":"dynamicData不存在(setep=1), userId=" + userDynamicDataId});
}
},
function refreshRunningBalance(targetPeople, successCallBack, errorCallBack)
{
console.log('refreshRunningBalance people: ' + targetPeople.get('userName'));
var FeeClass = AV.Object.extend("Fee");
var queryFee = new AV.Query(FeeClass);
queryFee.equalTo("owner", targetPeople);
var PaymentClass = AV.Object.extend("Payment");
var queryPayment = new AV.Query(PaymentClass);
queryPayment.equalTo("isApproved", true);
//queryFee.equalTo("isSettled", false);
queryFee.find({
success: function(outstandingFees) {
queryPayment.equalTo("owner", targetPeople);
queryPayment.find({
success: function (paymentLists) {
var runningBalance = 0.0;
for (var i = 0; i < outstandingFees.length; i++) {
var outstandingFee = outstandingFees[i];
var feeAmount = outstandingFee.get('amount') ;
runningBalance = runningBalance - feeAmount;
}
for (var i = 0; i < paymentLists.length; i++)
{
var payment = paymentLists[i];
runningBalance = runningBalance + payment.get('amount');
}
var paymentAccount = targetPeople.get('accountRef');
paymentAccount.set('runningBalance', runningBalance);
paymentAccount.save();
successCallBack();
console.log('refreshRunningBalance people: ' + targetPeople.get('userName') + ' running balance: ' + runningBalance);
},
error: function(error)
{
errorCallBack(error);
}
});
}
});
}
AV.Cloud.define("approvePayment", function(request, respond) {
var approveIDList = request.params.approveList;
var rejectIDList = request.params.rejectList;
var PaymentClass = AV.Object.extend("Payment");
var queryApprovedPayment = new AV.Query(PaymentClass);
queryApprovedPayment.equalTo("isApproved", false);
queryApprovedPayment.containedIn("objectId", approveIDList );
var queryRejectedPayment = new AV.Query(PaymentClass);
queryRejectedPayment.equalTo("isApproved", false);
queryRejectedPayment.containedIn("objectId", rejectIDList);
queryRejectedPayment.find({
success: function(rejectList)
{
AV.Object.destroyAll(rejectList).then(function(success) {
// All the objects were deleted
queryApprovedPayment.find(
{
success: function(approveList)
{
for(var i = 0 ; i < approveList.length ; i++)
{
approveList[i].set('isApproved', true);
}
AV.Object.saveAll(approveList, {
success: function (list) {
respond.success();
},
error: function (error) {
respond.error(error.message);
}
});
},
error: function(error)
{
respond.error(error.message);
}
});
}, function(error) {
respond.error(error.message);
});
},
error: function(error)
{
respond.error(error.message);
}
});
});
router.post('/transaction/refund', function(req, res) {
var refundObj = req.body.data.object;
var chargeId = refundObj.charge;
console.log('退款请求:');
console.log('chargeId :' + chargeId);
if (refundObj.status == 'pending') {
console.log('等待ping++处理结果');
if (refundObj.failure_msg != null) {
var query = new AV.Query(TransactionQuery);
query.equalTo('chargeId', chargeId);
query.equalTo('state', 'pending');
query.find().then(function(trQuery) {
if (trQuery.length == 0) {
console.error('未查找到对应的transaction query');
return;
}
if (typeof refundObj.failure_msg === 'string') {
trQuery[0].set('extra', refundObj.failure_msg);
} else {
trQuery[0].set('extra', JSON.stringify(refundObj.failure_msg));
}
trQuery[0].save();
}, function(error) {
console.error(error);
});
}
} else if (refundObj.succeed) {
var query = new AV.Query(TransactionQuery);
query.equalTo('chargeId', chargeId);
query.equalTo('state', 'pending');
query.find().then(function(trQuery) {
if (trQuery.length == 0) {
console.error('未查找到对应的transaction query');
return;
}
console.log('ping++已处理');
trQuery[0].set('state', 'finished');
transactionMethod.logOrderRefundTransactionP(trQuery[0], refundObj).then(function() {
return trQuery[0].get('order').fetch();
}).then(function(order) {
order.set('state', 'cancelled');
return order.save();
}).catch(function(error) {
console.error(error);
});
}, function(error) {
console.error(error);
})
}
res.sendStatus(200);
});
AV.Cloud.define('report', function(request, response){
var userId = request.params.userId;
var code = request.params.code;
var reportedUserId = request.params.reportedUserId;
if(!userId || userId==='' || !reportedUserId || reportedUserId==='' || !code || code === ''){
response.error({"code":500, "result":"参数不能为空"});
}else{
var report = new Report();
report.set('userId', userId);
report.set('reportedUserId', reportedUserId);
report.set('code', code);
var reportQuery = new AV.Query(Report);
reportQuery.equalTo('userId', userId);
reportQuery.equalTo('reportedUserId', reportedUserId);
reportQuery.find().then(function(results){
if(results.length == 0){
//需要扣减分数
var user = new User();
user.id = reportedUserId;
var userDynamicQuery = new AV.Query(UserDynamicData);
userDynamicQuery.equalTo('userId', user);
userDynamicQuery.find().then(function(results){
if(results.length > 0){
var userDynamicData = results[0];
var reportedScore = userDynamicData.get('reportedScore');
if(reportedScore > 0){
reportedScore=reportedScore -1*2;
userDynamicData.set('reportedScore', reportedScore);
userDynamicData.save();
}
report.save();
response.success({"code":200, "result":"举报成功"});
}else{
response.error({"code":500, "result":"dynamicData不存在"});
}
},
function(error){
response.error({"code":500, result:"被举报人不存在"});
});
}else{
report.save();
response.success({"code":200, "result":"举报成功"});
}
},
function(error){
response.error({"code":500, "result":"举报失败"});
});
}
});
//删除过期未支付订单
function deleteTimeOutOrderP() {
var query = new AV.Query(Order);
var routesToUpdate = [];
query.equalTo('isDeleted', false);
query.equalTo('state', 'unpay');
query.include('route');
return query.find().then(function (orders) {
if (orders.length != 0) {
console.log('查找到订单数 ：' + orders.length);
}
var now = moment();
var promises = [];
orders.forEach(function (order) {
if ((moment(order.createdAt).add(10, 'm')).isBefore(now)) {
var promise = order.relation('coupons').query().find();
promise = promise.then(function (coupons) {
coupons.forEach(function (coupon) {
coupon.set('order', null);
});
if (coupons.length != 0) {
order.relation('coupons').remove(coupons);
}
order.set('isDeleted', true);
return order.save();
});
promises.push(promise);
console.log('删除订单:' + order.id);
console.log(order.createdAt);
//将路线加入待更新路线数组中，剔除重复的
var contain = false;
for(var i =0;i<routesToUpdate.length;i++){
if(routesToUpdate[i].id == order.get('route').id){
contain = true;
break;
}
}
if(!contain){
routesToUpdate.push(order.get('route'));
}
}
});
timerPromisefy(10000).then(function(){
//更新各路线人数
routesToUpdate.forEach(function(route){
routeMethod.recountPassengerNumber(route);
});
})
return AV.Promise.all(promises);
});
}
function deleteAgentCommissionRule(agentCommissionRuleId) {
var agentInfoQuery = new AV.Query(AgentInfo);
var agentCommissionRule = new AgentCommissionRule();
agentCommissionRule.id = agentCommissionRuleId;
agentInfoQuery.equalTo('agentCommissionRule', agentCommissionRule);
agentInfoQuery.equalTo('isDeleted', false);
return agentInfoQuery.find()
.then(function(results) {
if (results.length != 0) {
return AV.Promise.error('该规则已绑定代理，请先取消绑定');
}
agentCommissionRule.set('isDeleted', true);
return agentCommissionRule.save();
});
}
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);
}
})
});
LeanStore.prototype.get_ = function(id, callback) {
var self = this;
var query = new AV.Query(Session);
query.equalTo('identity', id);
query.first({
success: function (foundSession)
{
if (!foundSession)
{
callback(Error.get(Error.ENOENT), null);
}
else if (foundSession.get('destroyAt') < new Date())
{
self.destroy(foundSession, callback)
}
else
{
callback(null, foundSession);
}
},
error: function (error)
{
callback(error, null);
}
});
};
router.get('/api/show-purchase-orders', async (req, res) => {
const user = req.currentUser;
const PurchaseOrder = new av.Query('PurchaseOrder');
try {
const results = await PurchaseOrder.equalTo('user', user)
.equalTo('isDel', false)
.include(['vender'])
.find();
const orders = results.map(order => ({
date: order.get('createdAt'),
note: order.get('note'),
vender: order.get('vender').get('name'),
status: order.get('status'),
orderId: order.get('orderId'),
objectId: order.id
}));
res.send({
errNo: 0,
orders
});
} catch (e) {
res.send({
errNo: e.code,
errMsg: '出错了'
});
}
});
router.post("/users/pwdreset", function (req, res) {
var username = req.body.username;
var query = new AV.Query(AV.User);
query.equalTo("username", username); // find all the women
query.first({
success: function (userinfo) {
// Do stuff
console.log(userinfo)
if (userinfo != null) {
var useremail = userinfo.attributes.email;
res.render('users/sendpwdresetemail', {user: username, useremail: useremail, layout: 'share/layout'});
}
else {
//res.send("<script language='javascript'> alert('该用户不存在');</script>")
res.send("<script language='javascript'>if(confirm('该用户不存在！')){document.location.replace('/users/pwdreset')}else{document.location.replace('/users/pwdreset')};</script>");
}
}
});
});
store.getClass(function (er, classObj) {
if(er) return fn(er);
store.emit('lock');
debug('SET "%s" %s', sid, jsess);
var query = new AV.Query(classObj);
query.equalTo('sid', psid);
query.find().then(function (result) {
if (result.length > 0) {
result[0].set('value', jsess);
result[0].save();
} else {
var AVSession = new classObj();
AVSession.set('sid', psid);
AVSession.set('value', jsess);
AVSession.save();
debug('SET NEW SESSION "%s" %s', sid, jsess);
}
debug('SET complete');
fn.apply(null);
store.emit('unlock');
});
});
router.get('/api/show-purchase-order-items', async (req, res) => {
const PurchaseItems = new av.Query('PurchaseItems');
const order = av.Object.createWithoutData(
'PurchaseOrder',
req.query.orderObjectId
);
try {
const items = await PurchaseItems.equalTo('purchaseOrder', order)
.include(['shoeType'])
.find();
const retData = items.map(item => ({
itemId: item.id,
shoeType: {
shoeObjectId: item.get('shoeType').id,
brand: item.get('shoeType').get('brand'),
color: item.get('shoeType').get('color'),
shoeId: item.get('shoeType').get('shoeId')
},
sizes: item.get('sizes')
}));
res.send({
errNo: 0,
retData
});
} catch (e) {
res.send({ errNo: e.code });
}
});
reportQuery.find().then(function(results){
if(results.length == 0){
//需要扣减分数
var user = new User();
user.id = reportedUserId;
var userDynamicQuery = new AV.Query(UserDynamicData);
userDynamicQuery.equalTo('userId', user);
userDynamicQuery.find().then(function(results){
if(results.length > 0){
var userDynamicData = results[0];
var reportedScore = userDynamicData.get('reportedScore');
if(reportedScore > 0){
reportedScore=reportedScore -1*2;
userDynamicData.set('reportedScore', reportedScore);
userDynamicData.save();
}
report.save();
response.success({"code":200, "result":"举报成功"});
}else{
response.error({"code":500, "result":"dynamicData不存在"});
}
},
function(error){
response.error({"code":500, result:"被举报人不存在"});
});
}else{
report.save();
response.success({"code":200, "result":"举报成功"});
}
},
AV.Cloud.define('createUserDynamicData', function(request, response) {
var userId = request.params.userId;
if(!userId || userId === ''){
response.error({"code":500, "result":"参数userId不为空"});
}else{
var user = new User();
user.id = userId;
var userDynamicQuery = new AV.Query(UserDynamicData);
userDynamicQuery.equalTo('userId',user);
userDynamicQuery.find().then(function(results){
if(results.length > 0){
//已经存在则更新坐标和状态
response.success({"code":200, "result":results[0]});
}else{
var userDynamicData = new UserDynamicData();
userDynamicData.set('userId', user);
userDynamicData.set('datingStatus', 1);
userDynamicData.set('onlineStatus', true);
userDynamicData.save().then(function(userDynamicData){
response.success({"code":200, "result":userDynamicData})
},
function(error){
response.error({"code":500, "result":"保存用户DynamicData异常"});
});
}
},
function(error){
response.error({"code":500, "result":"查询用户DynamicData异常，userId=" + userId});
});
}
});
router.get('/getallimages',function (req,res){
var args = url.parse(req.url, true).query;
var query = new AV.Query(Road_Image);
query.equalTo("RoadId", args.RoadID);
query.ascending("createdAt");
query.find({
success: function (results) {
//alert("Successfully retrieved " + results.length + " scores.");
// Do something with the returned AV.Object values
var imgs=new Array();
for (var i = 0; i < results.length; i++) {
var object = results[i];
var img = new Object();
img.id = object.id;
img.imageurl = object.get('Image').thumbnailURL(150, 150);
imgs.push(img);
//console.log(points);
}
res.send(imgs);
},
error: function (error) {
// alert("Error: " + error.code + " " + error.message);
res.send('false');
}
});
});
AV.Cloud.define('updateUserDynamicData', function(request, response) {
var userId = request.params.userId;
if(!userId || userId === ''){
response.error({"code":500, "result":"参数userId不为空"});
}else{
var userDynamicQuery = new AV.Query(UserDynamicData);
var user = new User();
user.id = userId;
userDynamicQuery.equalTo('userId',user);
userDynamicQuery.find().then(function(results){
if(results.length > 0){
var latitude = request.params.latitude;
var longitude = request.params.longitude;
if(latitude && latitude != '' && longitude && longitude != ''){
var location = new AV.GeoPoint({"latitude": latitude, "longitude": longitude});
results[0].set('location',location);
}
results[0].set('onlineStatus', true);
results[0].save();
response.success({"code":200, "result":results[0]});
}else{
response.error({"code":500, "result":"用户DynamicData不存在, userId=" + userId});
}
},function(error){
response.error({"code":500, "result":"查询用户DynamicData异常，userId=" + userId});
});
}
});
/*
**保存公告数据
** data:一个保存了表单信息的json。find：需要查找是否存在相同的元素。callback：回调函数；成功返回“success”，失败返回“error”；
*/
function saveAnnounceData(data,find,callback){
var post = AV.Object.new('Announce');
console.log(data);
var query = new AV.Query('Announce');
query.equalTo(find, data[find]);
query.find().then(function(results) {
console.log('Successfully retrieved ' + results.length + ' posts.');
// 处理返回的结果数据
console.log(results.length);
if(results.length=="0"){
for(var key in data){
post.set(key, data[key]);
}
post.save().then(function(post) {
// 成功保存之后，执行其他逻辑.
console.log('New object created with objectId: ' + post.id);
callback.success("success");
}, function(err) {
// 失败之后执行其他逻辑
// error 是 AV.Error 的实例，包含有错误码和描述信息.
console.log('Failed to create new object, with error message: ' + err.message);
callback.error(err);
});
}
}, function(error) {
console.log('Error: ' + error.code + ' ' + error.message);
});
}
promise = promise.then(function() {
var query = new AV.Query(Order);
query.equalTo('orderNumber', charge.order_no);
query.include('route');
query.include('user');
return query.find();
});
new AV.Promise(resolve => {
let query = new AV.Query(Product);
query.equalTo('productId',productId);
query.first().then(product => {
product.save({
name,
nameEn,
mainImage,
productMethod,
category1,
category2,
bannerId,
detail,
review,
property,
instruction,
use,
detailImage,
isPublic
}).then(result => {
resolve(result);
});
});
}),
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);
});
});
router.get('/role/search', restrict, function(req, res) {
var query = new AV.Query(AV.Role);
query.equalTo("name", "admin");
query.first({
success: function (obj) {
console.dir(arguments);
if (obj) {
obj.relation("users").query().find({
success: function (results) {
console.log(results.length);
res.send(results);
},
error: function (error) {
res.send(error);
}
});
} else {
res.send("null");
}
},
error: function (error) {
console.error(error);
res.send("false");
}
});
});
success: function (pointresults) {
for (var i = 0; i < pointresults.length; i++) {
var point = pointresults[i];
var pointid = point.id;
var querypimg = new AV.Query(Point_Image);
querypimg.equalTo("PointId", pointid);
querypimg.find({
success: function (pimgresults) {
for (var i = 0; i < pimgresults.length; i++) {
var pimg = pimgresults[i];
var imgfile = pimg.get('Image');
imgfile.destroy();
}
AV.Object.destroyAll(pimgresults);
},
error: function (error) {
console.log("Error: " + error.code + " " + error.message);
}
});
point.destroy();
}
AV.Object.destroyAll(pointresults);
},
router.post('/:productBrandId', (req, res) => {
base.isAdminUserLogin(req, res); //判断是否登录
let productBrandId = parseInt(req.params.productBrandId);
let name = req.body['name'];
let brandName = req.body['brand-name'];
let brandInfo = req.body['brand-info'];
let brandLogoImage = req.body['brand-logo-image'];
let brandDetail = req.body['brand-detail'];
let authorName = req.body['author-name'];
let authorInfo = req.body['author-info'];
let authorImage = req.body['author-image'];
let authorDetail = req.body['author-detail'];
let url = req.body['url'];
let comment = req.body['comment'];
let query = new AV.Query(ProductBrand);
query.equalTo('productBrandId',productBrandId);
query.first().then(item => {
return item.save({
name,brandName,brandInfo,brandLogoImage,brandDetail,authorName,authorInfo,authorImage,authorDetail,url,comment
});
}).then(() => {
req.flash('success','编辑品牌成功!');
res.redirect('/admin/product-brand');
});
});
router.post('/api/create-client', async (req, res) => {
const user = req.currentUser;
const { name, mobilephone, telephone, address, note } = req.body;
const Client = new av.Query('Clients');
try {
const clients = Client.equalTo('user', user)
.equalTo('name', name)
.equalTo('isDel', false)
.find();
if (!clients.length) {
let newClient = new av.Object('Clients');
newClient
.set('user', user)
.set('name', name)
.set('mobilephone', mobilephone)
.set('telephone', telephone)
.set('address', address)
.set('note', note);
const { id } = await newClient.save();
res.send({
errNo: 0,
retData: { id }
});
} else {
throw {
code: -1,
errMsg: '已存在该客户'
};
}
} catch ({ code, errMsg }) {
res.send({ errNo: code, errMsg });
}
});
const queryComments = () => {
const targetArticle = AV.Object.createWithoutData('ContentList', articleId)
const query = new AV.Query('Comments')
query.ascending('createdAt')
query.equalTo('pointerArticle', targetArticle)
return query.find()
}