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

1 files changed, 26 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);
+    }
+}