permissionsDeleteOne: function (req, res, next) {
var q = AccessPermission.delete().where(AccessPermission.id.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
res.status(204).end();
});
},
delete: function (req, res, next) {
var q = Translations.delete().where(req.params);
query(q, function (err, data) {
if (err) {
return next(err);
}
res.status(204).end();
});
},
select: function (req, res, next) {
var q = AccessMatrix.select().from(AccessMatrix);
query(q, function (err, data) {
if (err) {
return next(err);
}
res.json(data);
});
},
selectByParams: function (req, res, next) {
var q = Translations.select().from(Translations).where(req.params);
query(q, function (err, data) {
if (err) {
return next(err);
}
res.json(data);
});
},
select: function (req, res, next) {
var q = Language.select().from(Language);
query(q, function (err, data) {
if (err) {
return next(err);
}
res.json(data);
});
},
editOne: function (req, res, next) {
var q = Translations.update({'value': req.body.value}).where(req.params);
query(q, function (err, data) {
if (err) {
return next(err);
}
res.status(202).end();
});
},
insertOne: function (req, res, next) {
var q = Language.insert(req.body).returning(Language.id);
query(q, function (err, data) {
if (err) {
return next(err);
}
res.status(201).json(_.first(data));
});
}
permissionsSelect: function (req, res, next) {
var q = AccessPermission.select().from(AccessPermission).where(AccessPermission.matrixId.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
res.json(data);
});
},
selectOne: function (req, res, next) {
query(User.select().where(req.params), function (err, user) {
if (!err) {
res.json(_.first(user));
} else {
next(err);
}
});
},
editOne: function (req, res, next) {
var q = Language.update(req.body).where(Language.id.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
res.status(202).end();
});
},
selectOne: function (req, res, next) {
var q = Language.select().from(Language).where(Language.id.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
res.json(_.first(data));
});
},
delete: function (req, res, next) {
var q = EssenceRole.delete().where(EssenceRole.id.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
res.status(204).end();
});
},
deleteOne: function (req, res, next) {
query(
Right.delete().where(Right.id.equals(req.params.id)),
function (err) {
if (!err) {
res.status(204).end();
} else {
next(err);
}
});
}
deleteOne: function (req, res, next) {
query(
Role_rights.delete().where(req.params),
function (err) {
if (!err) {
res.status(204).end();
} else {
next(err);
}
});
},
selectOne: function (req, res, next){
var q = EssenceRole.select().from(EssenceRole).where(EssenceRole.id.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
if(!_.first(data)){
return next(new HttpError(404, 'Not found'));
}
res.json(_.first(data));
});
},
updateOne: function (req, res, next) {
query(
Right.update(req.body).where(Right.id.equals(req.params.id)),
function (err, data) {
if (!err) {
res.status(202).end();
} else {
next(err);
}
}
);
},
updateOne: function (req, res, next) {
query(
User.update(_.pick(req.body, User.whereCol)).where(User.id.equals(req.params.id)),
function (err, data) {
if (!err) {
res.status(202).end();
} else {
next(err);
}
}
);
},
updateSelf: function (req, res, next) {
query(
User.update(_.pick(req.body, User.editCols)).where(User.id.equals(req.user.id)),
function (err, data) {
if (!err) {
res.status(202).end();
} else {
next(err);
}
}
);
},
selectOne: function (req, res, next) {
var q = Organization.select().from(Organization).where(Organization.id.equals(req.params.id));
query(q, function (err, data) {
if (err) {
return next(err);
}
if(_.first(data)){
res.json(_.first(data));
}else{
next(new HttpError(404, 'Not found'));
}
});
},
checkRestoreToken: function (req, res, next) {
query(User.select().where(
User.resetPasswordToken.equals(req.params.token)
.and(User.resetPasswordExpires.gt(Date.now())
)), function (err, user) {
if (!err) {
if (!_.first(user)) {
return next(new HttpError(403, 'Token expired or does not exist'));
}
res.json(_.last(user));
} else {
next(err);
}
});
},
selectSelf: function (req, res, next) {
var request = 'ARRAY(' +
' SELECT "Rights"."action" FROM "RolesRights" ' +
' LEFT JOIN "Rights"' +
' ON ("RolesRights"."rightID" = "Rights"."id")' +
' WHERE "RolesRights"."roleID" = "Users"."roleID"' +
') AS rights';
query(User.select(User.star(), request).where(User.id.equals(req.user.id)), function (err, user) {
if (!err) {
res.json(_.first(user));
} else {
next(err);
}
});
},
logout: function (req, res, next) {
var id = req.params.id || req.user.id;
if (!id) {
return next(404);
}
query(
Token.delete().where(Token.userID.equals(id)),
function (err, data) {
if (!err) {
res.status(202).end();
}
else {
next(err);
}
}
);
},