问查询相关BelongsToMany

EN

    var User = db.Model.extend({
    initialize: function() {
      this.on('creating', this.generateId, this);
    },
    tableName: 'users',
    hasTimestamps: true,
    hidden: ['password'],
    companies: function(){
      return this.belongsToMany(
        require('./company'),
        'users_companies',
        'user_id',
        'company_id'
      )
    },
    charities: function(){
      return this.belongsToMany(
        require('./charity'),
        'users_charities',
        'user_id',
        'charity_id'
      ).withPivot(['company_id']);
    },
    generateId: function(model, attrs, options) {
      model.set('id', uuid.v4());
    }
});

exports.getAllCharities = function(req, res){
  new User({ id: req.user.id })
  .charities()
  .fetch()
  .then(function(charities){
    return res.json(charities.toJSON());
  })

new User({ id: req.user.id })
  .charities()
  .query('where', 'company_id', '=', req.query.companyid)
  .fetch()
  .then(function(charities){
    return res.json(charities.toJSON())
  })