<?php

namespace App\Http\Controllers;

require_once __DIR__ . './../../../config/info-bit.php';

use App\Bank\Profit;
use App\Classes\SendSMS;
use Illuminate\Http\Request;
use infobip\api\client\SendSingleTextualSms;
use infobip\api\configuration\BasicAuthConfiguration;
use infobip\api\model\sms\mt\send\textual\SMSTextualRequest;

class ProfitController extends Controller
{

    public function sendSMS()
    {
        $sms = new SendSMS();
//        873035450  MACHADO

        $sms->sendMessageTest(821464567);
    }

    public function getProfits($date1, $date2)
    {
        if ($date1 === 'null' || $date2 === 'null') {

            $profit = Profit::query()
                ->leftJoin('users', 'users.id', 'profits.payer_id')
                ->leftJoin('users as payer', 'users.id', 'profits.transfer_id')
                ->leftJoin('payments', 'payments.id', '=', 'profits.payment_id')
                ->leftJoin('stores', 'stores.id', '=', 'profits.profit_payer_id')
                ->leftJoin('transfer_histories', 'transfer_histories.id', '=', 'profits.transfer_id')
                ->orderByDesc('profits.created_at')
                ->select('profits.*', 'users.name as client', 'payments.transaction_id as payment_transaction', 'stores.name as profit_payer_name', 'payer.name as profit_payer_name2')
                ->get();

            return response()->json(['data' => $profit], 200);

        } elseif ($date1 == $date2) {

            $profit = Profit::query()
                ->leftJoin('users', 'users.id', 'profits.payer_id')
                ->leftJoin('payments', 'payments.id', '=', 'profits.payment_id')
                ->leftJoin('stores', 'stores.id', '=', 'profits.profit_payer_id')
                ->leftJoin('transfer_histories', 'transfer_histories.id', '=', 'profits.transfer_id')
                ->whereDate('profits.created_at', $date1)
                ->orderByDesc('profits.created_at')
                ->select('profits.*', 'users.name as client', 'payments.transaction_id as payment_transaction', 'stores.name as profit_payer_name')
                ->get();

            return response()->json(['data' => $profit], 200);

        } else {

            $profit = Profit::query()
                ->leftJoin('users', 'users.id', 'profits.payer_id')
                ->leftJoin('payments', 'payments.id', '=', 'profits.payment_id')
                ->leftJoin('stores', 'stores.id', '=', 'profits.profit_payer_id')
                ->leftJoin('transfer_histories', 'transfer_histories.id', '=', 'profits.transfer_id')
                ->whereDate('profits.created_at', '>=', $date1)
                ->whereDate('profits.created_at', '<=', $date2)
                ->orderByDesc('profits.created_at')
                ->select('profits.*', 'users.name as client', 'payments.transaction_id as payment_transaction', 'stores.name as profit_payer_name')
                ->get();

            return response()->json(['data' => $profit], 200);


        }


    }
}