summaryrefslogtreecommitdiff
path: root/app/Http/Controllers/LookupController.php
blob: 45543e6feaa98e500f4a342531849f7f53b98d49 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?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);
    }
}