<?php                                                                                                                                                                                                                
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Helpers\CryptoHelper;

use Illuminate\Support\Facades\DB;
use App\Http\Controllers\Controller;

class LookupController extends Controller {
    /**
     * Shows the index page.
     *
     * @return Response
     */
    public function showPage(Request $request) {
  
	    // Used by external linkshorter for better reporting in web analytics.
	    $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/" . $request->get('short_url'))->limit(1)->get();
	    
	    return response()->json($data);
    }
}