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 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 site/app/Http/Controllers/LookupController.php

(limited to 'site/app')

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