$tickets = Ticket::select("tickets.cust_id","tickets.ticket_id","tickets.category_id","tickets.subject","tickets.priority","tickets.message","tickets.status","tickets.createdticket","tickets.last_reply","tickets.closing_ticket","tickets.auto_close_ticket","tickets.created_at","tickets.updated_at","groups_categories.group_id","groups_users.users_id")
->leftJoin('groups_categories','groups_categories.category_id','tickets.category_id')
->leftJoin('groups_users','groups_users.groups_id','groups_categories.group_id')
->get();
上面的代碼是我的查詢。我希望根據登錄用戶顯示票證
uj5u.com熱心網友回復：
where('groups_users.users_id', Auth::id())在 Laravel 查詢中使用基于登錄用戶獲取票證：
$tickets = Ticket::leftJoin('groups_categories','groups_categories.id','tickets.category_id')
->leftJoin('groups_users','groups_users.id','groups_categories.group_id')
->select("tickets.cust_id","tickets.ticket_id","tickets.category_id","tickets.subject","tickets.priority","tickets.message","tickets.status","tickets.createdticket","tickets.last_reply","tickets.closing_ticket","tickets.auto_close_ticket","tickets.created_at","tickets.updated_at","groups_categories.group_id","groups_users.users_id")
->where('groups_users.users_id', Auth::id())
->get();
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/321846.html
標籤：拉拉维尔 laravel-5 雄辩 laravel-4
上一篇：不使用用戶模型發送通知