App\Console\Commands\CreateDefaultFunds

Complexity

Total Complexity

2

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
class CreateDefaultFunds extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'fund:create-defaults';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Create a default savings fund for each tontine';

    /**
     * Execute the console command.
     *
      * @return int
     */
    public function handle()
    {
        DB::transaction(function() {
            foreach(Tontine::cursor() as $tontine)
            {
                // Create a default savings fund, if it doesn't exist yet.
                $fund = $tontine->funds()
                    ->withoutGlobalScope('user')
                    ->updateOrCreate(['title' => ''], ['active' => true]);

                // Update the savings and loans with the default fund id.
                Loan::whereNull('fund_id')
                    ->whereHas('member', function($query) use($tontine) {
                        $query->where('tontine_id', $tontine->id);
                    })
                    ->update(['fund_id' => $fund->id]);
                Saving::whereNull('fund_id')
                    ->whereHas('member', function($query) use($tontine) {
                        $query->where('tontine_id', $tontine->id);
                    })
                    ->update(['fund_id' => $fund->id]);
            }
        });

        return Command::SUCCESS;
    }