/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $states = -1; $approach = -1; $key = ''; if ($request->has('key')) { $key = $request->input('key'); $query = ActivityOrder::where('code', 'like', '%' . $key . '%'); } else { $query = ActivityOrder::select(); } if ($request->has('states')) { $states = $request->input('states'); $query->where('states', $states); } if ($request->has('approach')) { $approach = $request->input('approach'); $query->where('pay_approach', $approach); } $orders = $query->orderBy('activity_id', 'asc')->orderBy('id', 'desc')->with('activity', 'user')->paginate(20); return view('admin.activity.orders', compact('key', 'orders', 'states', 'approach')); }
public static function exists($userId, $activityId) { return ActivityOrder::where('user_id', $userId)->where('activity_id', $activityId)->count() > 0; }