How to use the orm.not_in function in orm
To help you get started, we’ve selected a few orm examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
gomeplusFED / DataPlatform / controllers / manage / achievements / shopRun.js View on Github 
params(query , params , sendData){
let shop_type = params.shop_type;
params.shop_type = shop_type ? shop_type : "all";
if(query.search_key && NumberReg.test(query.search_key)){
//店铺名
params.shop_name = query.search_key;
}else if(query.search_key){
//店铺ID
params.shop_id = query.search_key;
}else{
params.shop_name = orm.not_in(["ALL"]);
}
delete params.search_key;
return params;
},
rows : [return (req , res , next)=>{
let query = req.query;
let ep = new eventproxy();
req.models.ads2_new_rebate_order_shop_info.find({
date : orm.between(query.startTime , query.endTime),
day_type : query.day_type,
rebate_type : orm.not_in(["ALL"]),
plan_id : orm.not_in(["ALL"]),
unique_plan_id_num : orm.gt(0)
} , {
limit : query.limit / 1 || 20,
offset : query.limit * (query.page - 1) / 1 || 0,
order : ["-unique_is_rebate_order_num"]
} , (err , data) => {
ep.emit("one" , data);
});
req.models.ads2_new_rebate_order_shop_info.find({
date : orm.between(query.startTime , query.endTime),
day_type : query.day_type,
}).count((err , data) => {
ep.emit("two" , data);
});return (req , res , next)=>{
let query = req.query;
let ep = new eventproxy();
req.models.ads2_new_rebate_order_shop_info.find({
date : orm.between(query.startTime , query.endTime),
day_type : query.day_type,
rebate_type : orm.not_in(["ALL"]),
plan_id : orm.not_in(["ALL"]),
unique_plan_id_num : orm.gt(0)
} , {
limit : query.limit / 1 || 20,
offset : query.limit * (query.page - 1) / 1 || 0,
order : ["-unique_is_rebate_order_num"]
} , (err , data) => {
ep.emit("one" , data);
});
req.models.ads2_new_rebate_order_shop_info.find({
date : orm.between(query.startTime , query.endTime),
day_type : query.day_type,
}).count((err , data) => {
ep.emit("two" , data);
});params(query, params) {
params.play_id = params.play_id ? params.play_id : orm.not_in(["all"]);
params.ver = "all";
return params;
},
date_picker_data : 1,params(query , params , sendData){
if(!query.type){
params.type = "ALL";
}
params.order_source = orm.not_in(["ALL"]);
return params;
},
filter(data, query, dates) {params(query, params) {
if(query.filter_key === "all") {
params.share_source_name = ["all"];
delete params.share_source;
} else {
params.share_source = query.filter_key;
params.share_source_name = orm.not_in(["all"]);
}
return params;
},
filter_select: [{params(query) {
var now = new Date(),
ydate = util.getDate(new Date(now.getTime() - 24 * 60 * 60 * 1000));
return {
date : orm.between(new Date(ydate + " 00:00:00"), new Date(ydate + " 23:59:59")),
type : query.type || 'ios',
region : orm.not_in(["ALL"]),
day_type : 1
}
},
flexible_btn: [{params() {
var now = new Date(),
ydate = util.getDate(new Date(now.getTime() - 24 * 60 * 60 * 1000));
return {
date : orm.between(new Date(ydate + " 00:00:00"), new Date(ydate + " 23:59:59")),
type : "H5",
region : orm.not_in(["ALL"]),
day_type : 1
}
},
flexible_btn: [{secondParams(query, params) {
params.plan_type = orm.not_in([4]);
return params;
},
flexible_btn : [{
