LogController.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. /**
  3. * 日志管理
  4. *
  5. * @author fzs
  6. * @Time: 2017/07/14 15:57
  7. * @version 1.0 版本号
  8. */
  9. namespace App\Http\Controllers;
  10. use App\Models\Log;
  11. use Illuminate\Http\Request;
  12. class LogController extends Controller
  13. {
  14. /**
  15. * 日志列表
  16. */
  17. public function index(Request $request)
  18. {
  19. return $this->show($request);
  20. }
  21. public function lout(){
  22. Session::Remove('email');
  23. return redirect('/login');
  24. }
  25. /**
  26. * 根据条件日志列表查询
  27. */
  28. public function show(Request $request)
  29. {
  30. $sql = Log::with('user.roles');
  31. $sql->leftJoin(config('admin.user_table') . " as users", "users.id" , "=", "admin_logs.admin_id");
  32. if(true == $request->has('title')&&true == $request->has('status')) {
  33. $sql->where('admin_logs.'.$request->input('status'), 'LIKE', '%'.trim($request->input('title')).'%');
  34. }
  35. if(true == $request->has('begin')) {
  36. $sql->where('admin_logs.log_time', '>=', trim($request->input('begin')));
  37. }
  38. $sql->select('admin_logs.*');
  39. $pager = $sql->orderBy('admin_logs.id', 'desc')->paginate()->appends($request->all());
  40. return view('logs.list', ['pager'=>$pager,'input'=>$request->all()]);
  41. }
  42. }