setTokenAuth( env('MATOMO_LINK_SHORTER_AUTH_TOKEN') ); #$matomo->setVisitorId( $matomo->getVisitorId() ); $matomo->setIp( $request->header('X_REAL_IP') ); $matomo->setUrl( $shortlink ); $matomo->setUrlReferrer( $request->server('HTTP_REFERER') ); $matomo->setBrowserLanguage( $request->server('HTTP_ACCEPT_LANGUAGE') ); $matomo->setUserAgent( $request->server('HTTP_USER_AGENT') ); #$data = DB::table('all_view')->select('name', 'shop', 'spirit_type', 'long_url')->where('url', $shortlink)->limit(1)->get()->first(); $data = DB::table('angebot')->select('name', 'shop', 'spirit_type', 'url as long_url')->where('short_url', $shortlink)->limit(1)->get()->first(); $matomo->doTrackPageView( $data->name . " - " . $data->shop ); $matomo->doTrackEvent("Redirect", "Shop", $data->shop); $matomo->doTrackEvent("Redirect", "Name", $data->name); $matomo->doTrackEvent("Redirect", "Spirit Type", $data->spirit_type); $matomo->doTrackEvent("Redirect", "Short URL", env('LINK_SHORTER_BASE_DOMAIN') . $shortlink); $matomo->doTrackEvent("Redirect", "Long URL", $data->long_url); #return response()->json($data); return redirect()->away($data->long_url, 302); } }