From 1e5f2c58c07d893b0cd439f9a4bc73a916aef83b Mon Sep 17 00:00:00 2001
From: horus
Date: Thu, 15 Feb 2018 15:06:24 +0100
Subject: Add endpoint for looking up short address for better reporting.
 (website)

---
 site/app/Http/Controllers/LookupController.php | 26 ++++++++++++++++++++++++++
 site/routes/web.php                            |  2 ++
 2 files changed, 28 insertions(+)
 create mode 100644 site/app/Http/Controllers/LookupController.php

(limited to 'site')

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');
 });
-- 
cgit v1.2.3