BookRoles.php 537 B

12345678910111213141516171819202122
  1. <?php
  2. namespace App\Modules\Book\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. class BookRoles extends Model
  5. {
  6. protected $table = 'book_roles';
  7. protected $fillable = ['bid','role'];
  8. public static function getRolesByBid($bid) {
  9. return self::where('bid',$bid)->get();
  10. }
  11. public static function getBidsByRole($role) {
  12. return self::where('role',$role)->select('bid')->get()->pluck('bid')->all();
  13. }
  14. public static function getById($id){
  15. return self::where('id',$id)->first();
  16. }
  17. }