WIKIPEDIA StoreConfigController.php

Back Back Up Advanced Editor

<?php

namespace App\Http\Controllers;

use App\Bank\Payment;
use App\Classes\TransactionGeneration;
use App\DayCloseStore;
use App\Store;
use App\StoreConfig;
use Illuminate\Http\Request;
use DB;

class StoreConfigController extends Controller
{
    public function addOrUpdateConfigs(Request $request) {

$this->validate($request, [
            'store_id' => 'required',
            'notify' => 'required',
            'notify_sms' => 'required',
            'notify_email' => 'required',
            'notify_push' => 'required',
            'use_period' => 'required',
            'on_map' => 'required',
            'accept_payment' => 'required',
            'close_period' => 'required',
            'coin' => 'required',
            'bank_default' => 'required',
        ]);

if ($request->isJson()) {

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

if ($storeConfig) {
                $storeConfig->update([
                    'notify' => $request->notify,
                    'notify_sms' => $request->notify_sms,
                    'notify_email' => $request->notify_email,
                    'notify_push' => $request->notify_push,
                    'use_period' => $request->use_period,
                    'use_refund' => $request->use_refund,
                    'on_map' => $request->on_map,
                    'accept_payment' => $request->accept_payment,
                    'close_period' => $request->close_period,
                    'coin' => $request->coin,
                    'bank_default' => $request->bank_default,
                ]);

return response()->json(['message' => 'Configurações actualizadas com sucesso']);
            } else {

StoreConfig::create([
                    'notify' => $request->notify,
                    'notify_sms' => $request->notify_sms,
                    'notify_email' => $request->notify_email,
                    'notify_push' => $request->notify_push,
                    'use_period' => $request->use_period,
                    'use_refund' => $request->use_refund,
                    'on_map' => $request->on_map,
                    'accept_payment' => $request->accept_payment,
                    'close_period' => $request->close_period,
                    'coin' => $request->coin,
                    'bank_default' => $request->bank_default,
                    'store_id' => $request->store_id
                ]);
                return response()->json(['message' => 'Configurações adicionadas com sucesso']);
            }
        }
    }

public function getStoreConfig($id) {

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

if ($config) {
            return response()->json($config);
        } else {
            return response()->json(['message' => 'Está loja ainda não tem configurações.'],400);
        }
    }

public function fecho(){

$stores = Store::query()->get();

foreach ($stores as $store) {

if ($store) {

$paymentsAmountCredited = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'directo')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->sum('payments.amount_credited');

$paymentsAmountRefundCredited = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'reembolso')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->sum('payments.amount_credited');

$amountTotal = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'directo')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->sum('payments.amount');

$amountRefund = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'reembolso')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->sum('payments.amount');

$fee = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'directo')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->sum('payments.comissao');

$feeRefund = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'reembolso')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->sum('payments.comissao');

$countRefund = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'reembolso')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->count();

$countDirect = Payment::query()
                    ->where('store_id', '=', $store->id)
                    ->where('payment_type', '=', 'directo')
                    ->whereDate('created_at', '=', date('Y-m-d', strtotime(' -1 day')))
                    ->count();

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

if ($closes) {
                    $this->info('Já foi feito o fecho nessa data');
                } else {

if ($paymentsAmountCredited > 0) {

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

$close = DayCloseStore::create([
                            'transaction' => $transaction,
                            'description' => 'Fecho ' . date('Y-m-d', strtotime(' -1 day')),
                            'date_reference' => date('Y-m-d', strtotime(' -1 day')),
                            'nib' => $store->nib,
                            'amount' => $amountTotal,
                            'amount_credited' => $paymentsAmountCredited,
                            'fee' => $fee,
                            'amount_refund' => $amountRefund,
                            'amount_credited_refund' => $paymentsAmountRefundCredited,
                            'fee_refund' => $feeRefund,
                            'amount_total_credited' => $paymentsAmountCredited - $paymentsAmountRefundCredited,
                            'total_payments' => $countDirect,
                            'total_refunds' => $countRefund,
                            'store_id' => $store->id,
                            'user_id' => 1,
                        ]);

if ($close) {
//                            DB::table('stores')->where('id', $store->id)->decrement('balance', ($paymentsAmountCredited - $paymentsAmountRefundCredited));

$storeCheck = Store::query()->where('id', '=',$store->id)->first();
//                            DB::table('merchant_accounts')->where('id', $storeCheck->merchant_account_id)->increment('balance', ($paymentsAmountCredited - $paymentsAmountRefundCredited));

return response()->json(['amount' => $paymentsAmountCredited - $paymentsAmountRefundCredited]);

//                            DB::table('merchant_accounts')->update('id', $storeCheck->merchant_account_id)->increment('balance', ($paymentsAmountCredited - $paymentsAmountRefundCredited));
//                            MerchantAccount::query()->update()

//                            $this->info('Fecho confirmado com Sucesso');
                        }
                    } else {
                        $this->info('Sem pagamentos');
                    }
                }

} else {
                $this->info('Loja Inválida');
            }

}
    }
}