router.get('/get-skills', function(req, res, next) {
req.models.Skill.find({name: orm.like('%'+req.query.q+'%')}, function(err, result)
{
var skills = JSON.stringify(result);
res.end(skills);
});
});
exports.searchpx = function (req, res, next) {
var params = req.body.params;
var ids = [];
adminTag.search({name: orm.like("%" + params + "%"), status: 1, pid: 0}, '-createtime', function (data) {
data.list.forEach(function (item) {
ids.push(item.id);
});
res.json({result: ids});
});
};
index: function(req, res){
if (req.query.subName) {
var bothNames = req.query.subName.split(' ');
if (bothNames.length > 1) {
_.assign(req.query, { 'subfirstname': bothNames[0], 'sublastname': bothNames[1] });
} else {
var sublastname = { 'sublastname': orm.like(bothNames[0] + '%') },
subfirstname = { 'subfirstname': orm.like(bothNames[0] + '%') };
var foo = [sublastname, subfirstname];
_.assign(req.query, { 'or': foo });
}
delete req.query.subName;
}
req.models.subscriber.find(req.query)
.order('subnumber').run(function (err, subs) {
if (!err) {
console.log('Subs found: %d', subs.length);
res.json(subs);
} else {
res.send(404, 'No subs found.');
}
});
},
initDb(function(db) {
db.models.nodes.find({'hostname': orm.like('node%')}, function(err, nodes) {
console.log(err);
for (i = 0; i < 10; i++) {
var node = nodes[i];
async.parallel({
vendor: node.getVendor,
chassis: node.getChassis
}, function(err, results) {
console.log('vendor: ', results.vendor.name,
'chassis: ', results.chassis.name);
});
}
});
});
Cinema._queryConds = function(query, cb) {
var conds = {};
for (var key in query) {
switch (key) {
case 'name':
case 'suburb':
conds[key] = orm.like('%' + query[key] + '%');
break;
case 'state':
conds[key] = query[key].toUpperCase();
break;
case 'postcode':
conds[key] = query[key];
break;
}
}
Cinema.find(conds, cb);
};
exports.searchLevel1Tag = function (req, res, next) {
console.log(" 查询一级标签");
var tag = table.adminTagTable;
var type = req.body.type;
var isenable = req.body.isenable;
var initialflagName = req.body.initialflagName;
var name = req.body.name;
var pid = 0;
adminTag.search({
pid: pid,
type: type,
isenable: isenable,
initialflag: initialflagName,
name: orm.like("%" + name + "%"),
status: 1
}, '-createtime', function (data) {
adminTag.doSql("select pid,count(1) cnt from admin_tag where pid > 0 and status=1 group by pid", [], function (count) {
data.list.forEach(function (item) {
count.list.forEach(function (jtem) {
if (item.id == jtem.pid) {
item.cnt = jtem.cnt;
}
})
});
enable.search({}, function (da) {
var lasttime = da.list[0].lasttime;
data.list.forEach(function (item) {
if (item.lastmodifytime > lasttime) {
item.isFlash = 1;
} else {
item.isFlash = 0;
}
});
res.json({result: data, lasttime: lasttime});
});
});
});
};