router.post('/updata', function (req, res, next) {
var objectId = req.body.objectId;
var password = req.body.password;
AV.Query.doCloudQuery('update _User set password="******" where objectId="' + objectId + '"').then(function (data) {
var results = data.results;
json.msg = '修改成功!';
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/del', function (req, res, next) {
var objectId = req.body.objectId;
AV.Query.doCloudQuery('delete from _User where objectId="' + objectId + '"').then(function (data) {
var results = data.results;
json.data = results;
json.msg = '删除成功!';
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.get('/', function (req, res, next) {
var cql = 'select * from _User';
var pvalues = [0, 1];
AV.Query.doCloudQuery(cql, pvalues).then(function (data) {
var results = data.results;
json.data = results;
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.get('/queryRecommend', function (req, res, next) {
var cql = 'select * from Article where recommend="' + req.query.recommend + '" order by -updatedAt ';
var pvalues = [0];
AV.Query.doCloudQuery(cql, pvalues).then(function (data) {
var results = data.results;
json.data = results;
json.msg = '获取成功!';
res.send(json);
}, function (error) {
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/del', function (req, res, next) {
AV.Query.doCloudQuery('delete from Article where objectId="' + req.body.objectId + '"').then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results;
json.msg = '删除成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/queryCategory', function (req, res, next) {
var cql = 'select * from Article where category=' + req.body.categoryId + '';
var pvalues = [0];
AV.Query.doCloudQuery(cql, pvalues).then(function (data) {
var results = data.results;
json.data = results;
json.msg = '获取成功!';
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.get('/query', function (req, res, next) {
var cql = 'select * from Article where objectId="' + req.query.objectId + '"';
var pvalues = [0];
AV.Query.doCloudQuery(cql, pvalues).then(function (data) {
var results = data.results;
json.data = results[0];
json.msg = '获取成功!';
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/del', function (req, res) {
var cql = 'delete from _File where objectId="' + req.body.objectId + '"';
var pvalues = [0];
AV.Query.doCloudQuery(cql, pvalues).then(function (data) {
var results = data.results;
json.data = results;
json.msg = '删除成功!';
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.get('/list', function(req,res,next){
if(!req.session.logined){
return res.send({code:10003,msg:'未登录'});
}
var keyword = req.query.k;
if(typeof (keyword) != 'undefined'){
keyword = decodeURIComponent(keyword);
}
var pageSize = req.query.s ? req.query.s : 10;
var pageNum = req.query.n ? req.query.n : 0;
var queryString = 'select * from patient ';
var queryCountString = 'select count(*) from patient ';
var option = '';
if(!_.isNull(keyword) && !_.isUndefined(keyword) && keyword.length > 0 ){
option += "where name like '%" + keyword + "%' or ";
option += "number like '%" + keyword + "%' or ";
option += "sex like '%" + keyword + "%' or ";
option += "age like '%" + keyword + "%'";
queryString += option;
queryCountString += option;
}
queryString += " limit " + (pageNum * pageSize) + "," + pageSize;
AV.Promise.when(AV.Query.doCloudQuery(queryCountString),AV.Query.doCloudQuery(queryString))
.then(function(total,list){
return res.send({code:0,msg:'',total:total.count,list:list.results});
})
.catch(function(error){
return res.send({code:10001,msg:'查询列表失败.'});
});
});
router.post('/search', function (req, res, next) {
var sql = 'select * from Article where title like "%'+req.body.title+'%"';
AV.Query.doCloudQuery(sql).then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results;
json.msg = '搜索成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/updata', function (req, res, next) {
var title = req.body.title;//头像
var url = req.body.url;//个性签名
var sort = req.body.sort;//微博地址
AV.Query.doCloudQuery('update Linkfriend set title="' + title + '", url="' + url + '",sort="' + sort + '" where objectId="' + req.body.objectId + '"').then(function (data) {
var results = data.results;
json.data = results[0];
json.msg = '设置成功!';
res.send(json);
}, function (error) {
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
AV.Cloud.define('rank', function (request, response) {
AV.Query.doCloudQuery('select user from Action').then(function (data) {
var users = [];
users = _.chain(data.results)
.countBy(function(item){
return item.get('user');
})
.toPairs()
.sortBy(1)
.reverse()
.mapValues(0)
.value();
response.success(users);
}, function (error) {
console.log(error);
response.success(error);
});
});
router.post('/', function (req, res, next) {
var title = req.body.title;//头像
var url = req.body.url;//个性签名
var sort = req.body.sort;//微博地址
// 执行 CQL 语句实现新增一个 Information 对象
AV.Query.doCloudQuery('insert into Linkfriend(title, url,sort) values("' + title + '","' + url + '","' + sort + '")').then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results[0];
json.msg = '设置成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/', function (req, res, next) {
var title = req.body.title;//文章标题
var category = req.body.category;//文章栏目
var recommend = req.body.recommend;//文章推荐位
var tag = req.body.tag;//文章标签
var description = req.body.description;//文章描述
var content = req.body.content;//文章内容
var fileId = req.body.fileId;//图片id
AV.Query.doCloudQuery('insert into Article(title,tag,description,content,recommend,category,fileId) values("' + title + '","' + tag + '","' + description + '","' + content + '","' + recommend + '",' + category + ',"' + fileId + '")').then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results;
json.msg = '设置成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/update', function (req, res, next) {
var title = req.body.title;//文章标题
var category = parseInt(req.body.category);//文章栏目
var recommend = req.body.recommend;//文章推荐位
var tag = req.body.tag;//文章标签
var description = req.body.description;//文章描述
var content = req.body.content;//文章内容
var fileId = req.body.fileId;//图片id
AV.Query.doCloudQuery('update Article set title="' + title + '",tag="' + tag + '",description="' + description + '",content="' + content + '",recommend="' + recommend + '",category=' + category + ',fileId="' + fileId + '" where objectId="' + req.body.objectId + '"').then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results;
json.msg = '修改成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/update', function (req, res, next) {
var title = req.body.title;//文章标题
var category = parseInt(req.body.category);//文章栏目
var recommend = req.body.recommend;//文章推荐位
var tag = req.body.tag;//文章标签
var description = req.body.description;//文章描述
var content = encodeURIComponent(req.body.content);//文章内容
var fileId = req.body.fileId;//图片id
var cql = 'update Article set title=?,tag=?,description=?,content=?,recommend=?,category=?,fileId=? where objectId=?';
var pvalues = [title, tag, description, content, recommend, parseInt(category), fileId , req.body.objectId];
AV.Query.doCloudQuery(cql,pvalues).then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results;
json.msg = '修改成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
console.log(error);
json.code = error.code;
json.msg = error.message;
res.send(json);
});
});
router.post('/', function (req, res, next) {
var title = req.body.title;//文章标题
var category = req.body.category;//文章栏目
var recommend = req.body.recommend;//文章推荐位
var tag = req.body.tag;//文章标签
var description = req.body.description;//文章描述
var content = encodeURIComponent(req.body.content);//文章内容
var fileId = req.body.fileId;//图片id
var cql = 'insert into Article(title,tag,description,content,recommend,category,fileId) values(?,?,?,?,?,?,?)';
var pvalues = [title, tag, description, content, recommend, parseInt(category), fileId];
AV.Query.doCloudQuery(cql, pvalues).then(function (data) {
// data 中的 results 是本次查询返回的结果，AV.Object 实例列表
var results = data.results;
json.data = results;
json.msg = '设置成功!';
res.send(json);
}, function (error) {
//查询失败，查看 error
json.data = [];
json.code = 0;
json.msg = '设置失败!';
res.send(json)
});
});