<?php

namespace App\Http\Controllers;


use Illuminate\Support\Facades\Auth;

use Illuminate\Http\Request;

class InfluencerAdminController extends Controller
{
    
    
    function __construct()
    {
        $this->middleware('auth:influencer');
    }



    public function showInfluencerLogin()
    {
        return view('influencer.login');
    }



    public function showInfluencerDetail()
    {
        
        $id = Auth::guard('influencer')->user()->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
                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
                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((influencers.residual *  product_transaction.amount)/100) suma_mes_residual,
                monthname(payment_transactions.updated_at) mes

                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
                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]->suma_mes_residual;
        }


        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]->product_transaction_discount - 0 - ($influencer[$i]->influencer_residual/100)) * ($influencer[$i]->product_transaction_amount);
        }

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

        return view('influencer.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
        ]);
        //return view('influencer.info', ['influencer' => $influencer]);
    }


}
