|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
static function actions_logs($type, $options=null){ DB::enableQueryLog(); $result = DB::table('member_action_log as a') ->join('member as b', 'b.id', '=', 'a.editor') ->leftJoin('member as c', 'c.id', '=', 'a.member') ->join('options as d', 'd.id', '=', 'a.action_id') ->select('a.*', 'b.username as editor_name', 'c.username as member_name', 'd.name as action_name') ->where('b.type', '=', $type); if(val($options, 'keyword') != false){ $keyword = val($options, 'keyword'); $result = $result->where(function ($query) use ($keyword) { $query->orWhere('b.username', 'like', "%" . $keyword . "%") ->orWhere('b.name', 'like', "%" . $keyword . "%"); }); } $result = $result->orderBy('a.created_time', 'desc') ->get(); $queries = DB::getQueryLog(); logg(end($queries)); return $result; } |
Reference: