芝麻web文件管理V1.00

编辑当前文件:/home/rejoandoctor/test.joruridoctor.com/app/Http/Controllers/back/DueController.php

<?php

namespace App\Http\Controllers\back;

use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Hash;
use Illuminate\Http\Request;
use Illuminate\Validation\Rules;
use Illuminate\Database\Eloquent\Builder;
use App\Models\back\PrimaryModel;  
use App\Models\back\DueModel;
use App\Models\back\BankModel;
use App\Models\back\BankAccountModel;
use App\Models\back\StockModel;
use App\Models\back\DueBalanceModel;
use App\Models\User;
use Auth;
use DB;
use Carbon\Carbon;
use Session;

class DueController extends Controller
{

function __construct()
    {
        $this->middleware('auth');
    }

function manageDue()
	{
        $due = DueBalanceModel::where('customer_id', Auth::user()->customer_id)->get();
		return view('back.due.manage_due', compact('due'));
	}

function viewDue($id)
    {
        $passenger_info = DueModel::where('customer_id', Auth::user()->customer_id)->where('passenger_id', $id)->first();
        $due = DueModel::where('customer_id', Auth::user()->customer_id)->where('passenger_id', $id)->get();
        // dd($due);
        $buy_amount = $due->sum('ticket_price');
        $paid_amount = $due->sum('paid_amount');
        return view('back.due.view_single_due', compact('due', 'paid_amount', 'buy_amount', 'passenger_info'));
    }

function returnDue($id)
    {   
        $due = DueBalanceModel::where('customer_id', Auth::user()->customer_id)->where('id', $id)->first();
        $bank = BankModel::get(['id', 'bank_name']);
        return view('back.due.return_due', compact('due', 'bank'));
    }

function storeReturnDue(Request $request)
    {
        $request->validate([
            'paid_amount' => ['required', 'string'],
            'due_return_date' => ['required', 'string'],
        ]);

$bank_id = $request->bank_id;
        
        $passengerID = $request->passenger_id;

$due = DueModel::create([
            'customer_id' => $request->customer_id,
            'passenger_id' => $request->passenger_id,
            'ticket_id' => $request->ticket_id,
            'bank_id' => $request->bank_id,
            'paid_amount' => $request->paid_amount,
            'due_return_date' => $request->due_return_date,
            'type' => 'due_return',
        ]);

// Reduce due amount from due balance table
        $check_pass_id = DueBalanceModel::where('customer_id', Auth::user()->customer_id)->where('passenger_id', $passengerID)->first();
        $getamount = $check_pass_id->due_amount - $request->paid_amount;
        $due_return = DueBalanceModel::where('customer_id', Auth::user()->customer_id)->where('passenger_id', $passengerID);
        $due_return->update([
            'due_amount' => $getamount,
        ]);

// Create due amount in bank account table
        $bank = BankAccountModel::create([

'customer_id' => $request->customer_id,
            'bank_id' => $bank_id,
            'due_return_amount' => $request->paid_amount,
            'due_return_date' => $request->due_return_date,
            'type' => 'due_return',
        ]);

// check bank account then insert or update amount
        $check_bank = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $bank_id)->first();
        if(isset($check_bank))
        {
            $bank = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $bank_id)->first(['customer_id','bank_id', 'bank_amount']);

$getamount = $bank->bank_amount + $request->paid_amount;
            $update_amount = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $bank_id);
            $update_amount->update([
                
                'bank_amount' => $getamount,
            ]);
        }else{

$due_amount = StockModel::create([
                'customer_id' => $request->customer_id,
                'bank_id' => $bank_id,
                'bank_amount' => $request->paid_amount,
            ]);
        }
        Session::flash('success', 'Due Return Successfully');
        return redirect()->route('manageDue');
    }

}