<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\DB;

class UserController extends Controller
{



    function __construct()
    {
        $this->middleware('auth:admin');
    }


    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $users = User::orderBy('id', 'desc')->paginate(20);
        return view('user.index', ['users' => $users]);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    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)
    {
        $user = User::find($id);

        $data = DB::table('users')
        ->select(
            'users.id as id',
            'users.name as name',
            'users.email as email',
            'users.number as number',
            'users.enabled as enabled',
            'beneficiary.number as beneficiary_number',
            'product_transaction.amount as amount',
            'product_transaction.discount as discount',
            'payment_transactions.carrier as carrier',
            'payment_transactions.request_id as request_id',
            'payment_transactions.transaction_id as transaction_id',
            'payment_transactions.carrier_folio as carrier_folio',
            'payment_transactions.updated_at as transaction_date'
        )
        ->leftJoin('beneficiary', 'users.id', '=', 'beneficiary.user_id')
        ->leftJoin('product_transaction', 'beneficiary.id', '=', 'product_transaction.beneficiary_id')
        ->leftJoin('payment_transactions','product_transaction.id','=','payment_transactions.product_transaction_id')
        ->where('users.id', '=', $id)
        ->where('carrier', '!=', 'NULL')
        ->where('request_id', '!=', 'NULL')
        ->where('transaction_id', '!=', 'NULL')
        ->where('carrier_folio', '!=', 'NULL')
        ->orderBy('id', 'desc')
        ->get();



        //return $data;
        return view('user.show', [
            'user' => $user, 
            'data' => $data
        ]);
    
    }

    /**
     * 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  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update($id)
    {
        $user = User::find($id);
        $user->enabled = Input::get('enabled');
        $user->save();
        return redirect()->route('user.show', $id);
    }

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