<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;

use App\Http\Requests;
use App\Http\Controllers\Controller;

class CampaignController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function indexAction()
    {
            $campaigns = DB::table('campaigns')->get();
            $return['campaigns'] = $campaigns;
            
            $return = array();
            for ($i = 0; $i <= 14; $i++){
                $return['campaign'.$i] = DB::table('campaigns')->where('sort',$i)->first();
            }
            // $return['campaign1'] = DB::table('campaigns')->where('sort','1')->first();
            // $return['campaign2'] = DB::table('campaigns')->where('sort','2')->first();
            // $return['campaign3'] = DB::table('campaigns')->where('sort','3')->first();
            // $return['campaign4'] = DB::table('campaigns')->where('sort','4')->first();
            // $return['campaign5'] = DB::table('campaigns')->where('sort','5')->first();
            // $return['campaign6'] = DB::table('campaigns')->where('sort','6')->first();
            // $return['campaign7'] = DB::table('campaigns')->where('sort','7')->first();
            // $return['campaign8'] = DB::table('campaigns')->where('sort','8')->first();
            // $return['campaign9'] = DB::table('campaigns')->where('sort','9')->first();
            // $return['campaign10'] = DB::table('campaigns')->where('sort','10')->first();
            // $return['campaign11'] = DB::table('campaigns')->where('sort','11')->first();
            // $return['campaign12'] = DB::table('campaigns')->where('sort','12')->first();
            // $return['campaign13'] = DB::table('campaigns')->where('sort','13')->first();
            // $return['campaign14'] = DB::table('campaigns')->where('sort','14')->first();

        return view('index', $return);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */

    public function singlepage1(){
        $return['campaign'] = DB::table('campaigns')->where('sort','0')->first();
        return view('podstrona', $return);
    }

    public function singlepage2(){
        $return['campaign'] = DB::table('campaigns')->where('sort','1')->first();
        return view('podstrona', $return);
    }

     public function singlepage3(){
        $return['campaign'] = DB::table('campaigns')->where('sort','2')->first();
        return view('podstrona', $return);
    }

     public function singlepage4(){
        $return['campaign'] = DB::table('campaigns')->where('sort','3')->first();
        return view('podstrona', $return);
    }

     public function singlepage5(){
        $return['campaign'] = DB::table('campaigns')->where('sort','4')->first();
        return view('podstrona', $return);
    }

     public function singlepage6(){
        $return['campaign'] = DB::table('campaigns')->where('sort','5')->first();
        return view('podstrona', $return);
    }

     public function singlepage7(){
        $return['campaign'] = DB::table('campaigns')->where('sort','6')->first();
        return view('podstrona', $return);
    }

     public function singlepage8(){
        $return['campaign'] = DB::table('campaigns')->where('sort','7')->first();
        return view('podstrona', $return);
    }

     public function singlepage9(){
        $return['campaign'] = DB::table('campaigns')->where('sort','8')->first();
        return view('podstrona', $return);
    }

     public function singlepage10(){
        $return['campaign'] = DB::table('campaigns')->where('sort','9')->first();
        return view('podstrona', $return);
    }

     public function singlepage11(){
        $return['campaign'] = DB::table('campaigns')->where('sort','10')->first();
        return view('podstrona', $return);
    }

     public function singlepage12(){
        $return['campaign'] = DB::table('campaigns')->where('sort','11')->first();
        return view('podstrona', $return);
    }

     public function singlepage13(){
        $return['campaign'] = DB::table('campaigns')->where('sort','12')->first();
        return view('podstrona', $return);
    }

     public function singlepage14(){
        $return['campaign'] = DB::table('campaigns')->where('sort','13')->first();
        return view('podstrona', $return);
    }

    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}