Add endpoint for looking up short address for better reporting. (website)

2 files changed, 28 insertions, 0 deletions

diff --git a/site/app/Http/Controllers/LookupController.php b/site/app/Http/Controllers/LookupController.php
new file mode 100644
index 0000000..5215704
--- /dev/null
+++ b/site/app/Http/Controllers/LookupController.php
@@ -0,0 +1,26 @@
+<?php                                                                                                                                                                                                                
+namespace App\Http\Controllers;
+use Illuminate\Http\Request;
+use App\Helpers\CryptoHelper;
+
+use Illuminate\Support\Facades\DB;
+use App\Http\Controllers\Controller;
+
+use Illuminate\Support\Facades\Input;
+
+class LookupController extends Controller {
+    /**
+     * Shows the index page.
+     *
+     * @return Response
+     */
+    public function showPage(Request $request) {
+  
+
+	$query = "SELECT name, shop, spirit_type FROM all_view WHERE short_url = ? LIMIT 1)";
+
+	$data = DB::table('all_view')->select('name', 'shop', 'spirit_type')->where('url', "https://l.fuselkoenig.de/" . Input::get('short_url'))->limit(1)->get(); #$query, "https://l.fuselkoenig.de/" . Input::get('short_url'));
+
+	return response()->json($data);
+    }
+} 
diff --git a/site/routes/web.php b/site/routes/web.php
index f2dc390..d467ce0 100644
--- a/site/routes/web.php
+++ b/site/routes/web.php
@@ -32,6 +32,8 @@ Route::get('/misc/feed', 'FeedController@showPage')->name('misc_feed');
 Route::get('/all/feed', 'FeedController@showPage')->name('all_feed');
 Route::get('/search/feed', 'FeedController@showPage')->name('search_feed');
 
+Route::get('/_/api/lookup', 'LookupController@showPage')->name('lookup');
+
 Route::get('/welcome', function () {
     return view('welcome');
 });