WIKIPEDIA CloseController.php

Back Back Up Advanced Editor

<?php

namespace App\Http\Controllers;

use App\Bank\Payment;
use App\Classes\TransactionGeneration;
use App\CloseTopUp;
use App\DayCloseStore;
use App\Imali\MerchantContract;
use App\PeriodCloseStore;
use App\StoreConfig;
use Illuminate\Http\Request;
use DB;

class CloseController extends Controller
{
    public function getTopUpDailyClose($date1, $date2)
    {
        $top = CloseTopUp::query()
            ->leftJoin('admins', 'admins.id', '=', 'close_top_ups.user_id')
            ->orderByDesc('close_top_ups.created_at')
            ->where('close_top_ups.created_at', '>=', $date1)
            ->where('close_top_ups.created_at', '<=', $date2)
            ->select('close_top_ups.*', 'admins.name as username')
            ->get();

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

public function closePeriodOLD(Request $request)
    {
        $paymentsAmount = Payment::query()
            ->where('store_id', $request->user()->id)
            ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
            ->sum('payments.amount_credited');

$closes = PeriodCloseStore::query()
            ->where('store_id', $request->user()->id)
            ->where('date_reference', '=', date('Y-m-d', strtotime(' -1 day')))
            ->first();

if ($paymentsAmount > 0) {
            $trasactionGeneration = new TransactionGeneration();
            $transaction = $trasactionGeneration->generateTransaction();

$close = DayCloseStore::create([
                'transaction' => $transaction,
                'description' => 'Fecho ' . date('Y-m-d', strtotime(' -1 day')),
                'nib' => $request->user()->nib,
                'amount' => $paymentsAmount,
                'date_reference' => date('Y-m-d', strtotime(' -1 day')),
                'store_id' => $request->user()->id,
                'user_id' => 1,
            ]);
            if ($close) {
                DB::table('stores')->where('id', $request->user()->id)->decrement('balance', $paymentsAmount);
                $this->info('Fecho confirmado com Sucesso');
            }
        }
    }

public function getPeriodCloses(Request $request)
    {

$transactions = PeriodCloseStore::query()
            ->join('stores', 'stores.id', '=', 'period_close_stores.store_id')
            ->select('period_close_stores.*')
            ->where('period_close_stores.store_id', '=', $request->user()->id)
            ->where('period_close_stores.status', '=', 'fechado')
            ->orderByDesc('period_close_stores.created_at')
            ->get();

$lastPeriod = PeriodCloseStore::query()
            ->leftJoin('stores', 'stores.id', '=', 'period_close_stores.store_id')
            ->select('period_close_stores.*')
            ->where('period_close_stores.store_id', '=', $request->user()->id)
            ->get()->last();

$storeConfig = StoreConfig::query()
            ->where('store_id', '=', $request->user()->id)
            ->first();

if ($storeConfig) {
            $storeConfig->makeHidden(['id', 'store_id']);

if (!$lastPeriod) {
                return response()->json(['data' => $transactions, 'lastPeriod' => null, 'storeConfig' => $storeConfig]);
            } else {
                return response()->json(['data' => $transactions, 'lastPeriod' => $lastPeriod, 'storeConfig' => $storeConfig]);
            }
        } else {
            if (!$lastPeriod) {
                return response()->json(['data' => $transactions, 'lastPeriod' => null, 'storeConfig' => null]);
            } else {
                return response()->json(['data' => $transactions, 'lastPeriod' => $lastPeriod, 'storeConfig' => null]);
            }
        }

}

public function closePeriod(Request $request)
    {
        $this->validate($request, [
            'open_period' => 'required',
            'code' => 'required'
        ]);

$lastPeriod = PeriodCloseStore::query()
            ->join('stores', 'stores.id', '=', 'period_close_stores.store_id')
            ->select('period_close_stores.*')
            ->where('period_close_stores.store_id', '=', $request->user()->id)
            ->where('period_close_stores.code', '=', $request->code)
            ->first();
//            ->get()->last();

$periodDate = date_create($request->open_period);

$paymentsAmount = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'directo')
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->sum('payments.amount_credited');

$paymentsAmountRefundCredited = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'reembolso')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->sum('payments.amount_credited');

$amountTotal = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'directo')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->sum('payments.amount');

$amountRefund = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'reembolso')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->sum('payments.amount');

$fee = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'directo')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->sum('payments.comissao');

$feeRefund = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'reembolso')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->sum('payments.comissao');

$countRefund = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'reembolso')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->count();

$countDirect = Payment::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('payment_type', '=', 'directo')
//            ->whereDate('created_at', '<=', date('Y-m-d'))
//            ->whereDate('created_at', '>=', date_format($periodDate, "Y-m-d"))
            ->where('created_at', '<=', date('Y-m-d H:i:s'))
            ->where('created_at', '>=', $request->open_period)
            ->count();

$closes = PeriodCloseStore::query()
            ->where('store_id', '=', $request->user()->id)
            ->where('code', '=', $request->code)
            ->where('status', '=', 'fechado')
            ->first();

if ($closes) {
            return response()->json(['message' => 'Este período já foi fechado'], 400);
        } else {

$valorAPagar = $paymentsAmountRefundCredited;
            $contractoComerciante = MerchantContract::query()->where('store_id', $request->user()->id)->first();

$taxaDesconto = $valorAPagar * ($contractoComerciante->taxa) / 100;

$period = PeriodCloseStore::query()
                ->where('store_id', '=', $request->user()->id)
                ->where('code', '=', $request->code)
                ->where('open_period', '=', $request->open_period)
                ->where('status', '=', 'aberto')
                ->first();

$period->update([
                'amount' => $amountTotal,
                'amount_credited' => $paymentsAmount,
                'amount_credited_refund' => $paymentsAmountRefundCredited + $feeRefund,
                'amount_total_credited' => $paymentsAmount - $paymentsAmountRefundCredited,
                'fee' => $fee,
                'fee_refund' => $feeRefund,
                'total_payments' => $countDirect,
                'total_refunds' => $countRefund,
                'amount_refund' => $amountRefund,
                'close_period' => now(),
                'date_reference' => date('Y-m-d'),
                'status' => 'fechado'
            ]);

$refund = $paymentsAmountRefundCredited + $feeRefund;
            $total = $paymentsAmount - $refund;

//            DB::table('stores')->where('id', $request->user()->id)->decrement('balance', $paymentsAmount - $paymentsAmountRefundCredited);

//            DB::table('stores')->where('id', $request->user()->id)->decrement('balance', $total);

return response()->json(['message' => 'Período fechado com sucesso', 'dataPeriod' => $period], 200);

}

public function openPeriod(Request $request)
    {
        $this->validate($request, [
            'period_time' => 'required',
            'description' => 'required'
        ]);

$lastPeriod = PeriodCloseStore::query()
            ->join('stores', 'stores.id', '=', 'period_close_stores.store_id')
            ->select('period_close_stores.*')
            ->where('period_close_stores.store_id', '=', $request->user()->id)
            ->where('period_close_stores.status', '=', 'aberto')
            ->get()->last();

if ($lastPeriod) {
            return response()->json(['message' => 'Ainda tens um período aberto'], 400);
        }

$storeConfig = StoreConfig::query()->where('store_id', '=', $request->user()->id)->first();

if ($storeConfig) {
            if ($storeConfig->use_period == 0) {
                return response()->json(['message' => 'Está loja não aceita períodos'], 400);
            }
        } else {
            return response()->json(['message' => 'Está loja ainda não foi configurada'], 400);
        }

$trasactionGeneration = new TransactionGeneration();
        $transaction = $trasactionGeneration->generateTransaction();

$codigo = $trasactionGeneration->generateCode();

PeriodCloseStore::create([
            'transaction' => $transaction,
            'code' => $trasactionGeneration->generateCode(),
            'description' => $request->description,
            'designation' => 'Período ' . $codigo,
            'nib' => $request->user()->nib,
            'open_period' => now(),
            'period_time' => $request->period_time,
            'date_reference' => date('Y-m-d'),
            'store_id' => $request->user()->id,
            'admin_user_id' => 1,
        ]);

return response()->json(['message' => 'Período aberto com sucesso'], 200);

}
}