<?php

namespace App\Http\Controllers;

use App\Influencer;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Input;
use Illuminate\Support\Facades\Hash;
use Validator;

class InfluencerController extends Controller
{


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


    public function index()
    {
        $influencers = Influencer::all()->sortByDesc('id');

        return view('influencers.index', [
            'influencers' => $influencers
        ]);

    }


    public function showCreateForm()
    {
        return view('influencers.create');
    }



    public function create(Request $request)
    {


        $validator = Validator::make($request->all(), [
            'name' => 'required|max:255',
            'code' => 'required|max:255'
        ]);


        if($validator->passes())
        {
            $influencer = new Influencer();
            $influencer->name = Input::get('name');
            $influencer->email = Input::get('email');
            $influencer->code = Input::get('code');
            $influencer->residual = Input::get('residual');
            $influencer->password = Hash::make(Input::get('password'));
            $influencer->save();

            return redirect(route('influencers.index'));
        }
        else
        {
            return redirect(route('influencer.create'));
        }

    }


    public function showInfo($id)
    {
        //$influencer = Influencer::find($id);

        $influencer = \DB::select(\DB::raw("
                select
                influencers.name influencer_name,
                influencers.code influencer_code,
                influencers.residual influencer_residual,
                users.name user_name,
                users.email user_email,
                users.number user_number,
                users.enabled user_enabled,
                
                payment_transactions.created_at user_created,
                
                beneficiary.number beneficiary_number,
                product_transaction.sku product_transaction_sku,
                product_transaction.amount product_transaction_amount,
                product_transaction.discount product_transaction_discount,
                payment_transactions.carrier payment_transactions_carrier,
                payment_transactions.request_id payment_transactions_request_id,
                payment_transactions.transaction_id payment_transactions_transaction_id,
                payment_transactions.carrier_folio payment_transactions_carrier_folio,
                product.telecom_pct telecom_pct,
                product.discount_pct discount_pct
                from users
                left join influencers
                on influencers.id = users.influencer_id
                left join beneficiary
                on users.id = beneficiary.user_id
                left join product_transaction
                on beneficiary.id = product_transaction.beneficiary_id
                left join payment_transactions
                on product_transaction.id = payment_transactions.product_transaction_id
                left join product
                on product.sku like product_transaction.sku
                where influencers.id = $id
                and payment_transactions.carrier IS NOT NULL
                and payment_transactions.request_id IS NOT NULL
                and payment_transactions.transaction_id IS NOT NULL
                and payment_transactions.carrier_folio IS NOT NULL;
        "));

        $graficas = \DB::select(\DB::raw("

            select
                influencers.name influencer_name,
                influencers.code influencer_code,
                influencers.residual influencer_residual,
                users.name user_name,
                users.email user_email,
                users.number user_number,
                users.enabled user_enabled,
                
                payment_transactions.created_at user_created,

                beneficiary.number beneficiary_number,
                product_transaction.sku product_transaction_sku,
                product_transaction.amount product_transaction_amount,
                product_transaction.discount product_transaction_discount,
                payment_transactions.carrier payment_transactions_carrier,
                payment_transactions.request_id payment_transactions_request_id,
                payment_transactions.transaction_id payment_transactions_transaction_id,
                payment_transactions.carrier_folio payment_transactions_carrier_folio,
                payment_transactions.updated_at payment_transactions_transaction_date,

                sum( ((product.telecom_pct  - product.discount_pct - influencers.residual)/100) *  (product_transaction.amount) ) margen_cliqa,
                monthname(payment_transactions.updated_at) mes,
                product.telecom_pct telecom_pct,
                product.discount_pct discount_pct

                from users
                left join influencers
                on influencers.id = users.influencer_id
                left join beneficiary
                on users.id = beneficiary.user_id
                left join product_transaction
                on beneficiary.id = product_transaction.beneficiary_id
                left join payment_transactions
                on product_transaction.id = payment_transactions.product_transaction_id
                left join product
                on product.sku like product_transaction.sku
                where influencers.id = $id
                
                and payment_transactions.carrier IS NOT NULL
                and payment_transactions.request_id IS NOT NULL
                and payment_transactions.transaction_id IS NOT NULL
                and payment_transactions.carrier_folio IS NOT NULL
                group by month(payment_transactions.updated_at);

        "));


        $grafica_meses = [];
        $grafica_suma_residual = [];

        for($i = 0; $i < count($graficas); $i++)
        {
            $grafica_suma_residual[] = $graficas[$i]->margen_cliqa;
        }


        for($i = 0; $i < count($graficas); $i++)
        {
            $grafica_meses[] = $graficas[$i]->mes;
        }



        /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
        ///
        ///
        ///
        ///
        ///
        $sum_residual = 0;

        for($i = 0; $i < count($influencer); $i++)
        {
            $sum_residual += (($influencer[$i]->influencer_residual * $influencer[$i]->product_transaction_amount)/100); 
        }

        
        $sum_telecom = 0;

        for($i = 0; $i < count($influencer); $i++)
        {
            $sum_telecom += $influencer[$i]->product_transaction_amount;
        }

        
        $sum_margen = 0;

        //cuando se cambie el descuento del usuario cambiar el valor 0
        for($i = 0; $i < count($influencer); $i++)
        {
            $sum_margen += (($influencer[$i]->telecom_pct - $influencer[$i]->discount_pct - $influencer[$i]->influencer_residual)/100) * ($influencer[$i]->product_transaction_amount);
        }


 
        
        //return var_dump(json_encode($grafica_meses));

        return view('influencers.info', [
            'influencer' => $influencer,
            'sum_residual' => $sum_residual,
            'sum_telecom' => $sum_telecom,
            'sum_margen' => $sum_margen,
            'grafica_suma_residual' => $grafica_suma_residual,
            'grafica_meses' => $grafica_meses
        ]);
    }


    public function showUpdateForm($id)
    {
        $influencer = Influencer::find($id);
        return view('influencers.edit', ['influencer' => $influencer]);
    }




    public function update($id, Request $request)
    {


        $validator = Validator::make($request->all(), [
            'name' => 'required|max:255',
            'code' => 'required|max:255'
        ]);


        if($validator->passes())
        {
            $influencer = Influencer::find($id);
            $influencer->name = Input::get('name');

            if(Input::has('email'))
            {
                $influencer->email = Input::get('email');
            }

            $influencer->code = Input::get('code');
            $influencer->residual = Input::get('residual');

            if(Input::has('password'))
            {
                $influencer->password = Hash::make(Input::get('password'));    
            }
            
            $influencer->save();

            return redirect(route('influencers.index'));
        }
        else
        {
            return redirect(route('influencer.index'));
        }

    }




}
