芝麻web文件管理V1.00

编辑当前文件:/home/rejoandoctor/test.joruridoctor.com/app/Http/Controllers/back/LoanController.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\CustomerModel;
use App\Models\back\StockModel;
use App\Models\back\LoanModel;
use App\Models\back\LoanBalanceModel;
use App\Models\back\AgentAccountModel;
use App\Models\back\BankModel;
use App\Models\back\LoanDetailsModel;
use App\Models\back\BankAccountModel;
use App\Models\User;
use Auth;
use DB;
use Carbon\Carbon;
use Session;

class LoanController extends Controller
{

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

function makeTakeLoan()
    {
    	$bank = BankModel::get(['id', 'bank_name']);
    	return view('back.loan.add_take_loan', compact('bank'));
    }

function loan_search(Request $request)
    {
         $search = $request->search;

if($search == ''){
             $loan = LoanModel::select('id','customer_id', 'name', 'mobile', 'details')->limit(5)->where('customer_id', Auth::user()->customer_id)->get();
          }else{
             $loan = LoanModel::select('id','customer_id', 'name', 'mobile', 'details')->where('name', 'like', '%' .$search . '%')->limit(5)->where('customer_id', Auth::user()->customer_id)->get();
          }

$response = array();
          foreach($loan as $loan){
             $response[] = array("label"=>[$loan->name,  "Mobile: ", $loan->mobile], "value_id"=>$loan->id, "value_name"=>$loan->name, "value_mobile"=>$loan->mobile, "value_address"=>$loan->details);
          }
          
          return response()->json($response);   
    }

function storeTakeLoan(Request $request)
    {

$request->validate([
            'name' => ['required', 'string', 'max:100'],
            'bank_id' => ['required', 'string', 'max:100'],
            'mobile' => ['required', 'string', 'max:100', 'unique:loan'],
            'take_loan_amount' => ['required', 'string', 'max:100'],
        ]);

$loan_person = LoanModel::create([
            'customer_id' => $request->customer_id,
            'name' => $request->name, 
            'mobile' => $request->mobile, 
            'address' => $details = $request->address,
        ]);

$loan_details = LoanDetailsModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id, 
            'person_id' => $personId = DB::getPdo()->lastInsertId(), 
            'mobile' => $request->mobile, 
            'details' => $details,
            'loan_amount' => $request->take_loan_amount, 
            'loan_date' => $request->loan_date, 
            'type' => 'take_debit',
        ]);

$loan = LoanBalanceModel::create([
            'customer_id' => $request->customer_id, 
            'person_id' => $personId, 
            'take_loan_amount' => $request->take_loan_amount,
        ]);

// Deposit receive money in bank account for purchase ticket
        $payment_through = BankAccountModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id,
            'person_id' => $personId,
            'loan_amount' => $request->take_loan_amount,
            'loan_date' => $request->loan_date,     
            'type' => 'loan_take_debit',     
        ]);

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

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

$sale_amount = StockModel::create([
                'customer_id' => $request->customer_id,
                'bank_id' => $request->bank_id,
                'bank_amount' => $request->give_loan_amount,
            ]);
        }

Session::flash('success', 'Loan Successfully');
        return redirect()->route('manageTakeLoan');    
    }
    
    function manageTakeLoan()
    {
        $loan = LoanBalanceModel::get();
        return view('back.loan.manage_take_loan', compact('loan'));
    }

function reTakeLoan($id)
    {
        $bank = BankModel::get(['id', 'bank_name']);
        $loan = LoanDetailsModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        $prev_loan = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        return view('back.loan.re_take_loan', compact('loan', 'bank', 'prev_loan'));
    }

function storeReTakeLoan(Request $request, $id)
    {

$personID = $request->person_id;

$loan_details = LoanDetailsModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id, 
            'person_id' => $personID, 
            'mobile' => $request->mobile, 
            'details' => $request->details,
            'loan_amount' => $request->loan_amount, 
            'loan_date' => $request->loan_date, 
            'type' => 'take_debit',
        ]);

// Loan amount insert into loan balance
        $check = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
        if(empty($check))
        {
            $loan = LoanBalanceModel::create([
                'customer_id' => $request->customer_id, 
                'person_id' => $personId, 
                'take_loan_amount' => $request->take_loan_amount,
            ]);
        }else{

$amount = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
            $getamount = $amount->take_loan_amount + $request->take_loan_amount;

$loan = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID);
            $loan->update([
                'take_loan_amount' => $getamount,
            ]);
        }

// Deposit receive money in bank account for purchase ticket
            $payment_through = BankAccountModel::create([
                'customer_id' => $request->customer_id,
                'bank_id' => $request->bank_id,
                'person_id' => $personID,
                'loan_amount' => $request->take_loan_amount,
                'loan_date' => $request->loan_date,     
                'type' => 'loan_take_debit',     
            ]);

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

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

$sale_amount = StockModel::create([
                    'customer_id' => $request->customer_id,
                    'bank_id' => $request->bank_id,
                    'bank_amount' => $request->loan_amount,
                ]);
            }

Session::flash('success', 'Loan Taken Successfully');
        return redirect()->route('manageTakeLoan');   
    }

function returnTakeLoan($id)
    {
        $bank = BankModel::get(['id', 'bank_name']);
        $loan = LoanDetailsModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        $prev_loan = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        return view('back.loan.return_take_loan', compact('loan', 'bank', 'prev_loan'));
    }

function storeReturnTakeLoan(Request $request, $id)
    {

$personID = $request->person_id;

$loan_details = LoanDetailsModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id, 
            'person_id' => $personID, 
            'mobile' => $request->mobile, 
            'details' => $request->details,
            'return_amount' => $request->return_amount, 
            'return_date' => $request->return_date, 
            'type' => 'take_credit',
        ]);

// Loan amount insert into loan balance
        $check = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
        if(empty($check))
        {
            $loan = LoanBalanceModel::create([
                'customer_id' => $request->customer_id, 
                'person_id' => $personId, 
                'return_amount' => $request->return_amount,
            ]);
        }else{

$amount = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
            $getamount = $amount->take_loan_amount - $request->return_amount;

// Deposit receive money in bank account for purchase ticket
            $payment_through = BankAccountModel::create([
                'customer_id' => $request->customer_id,
                'bank_id' => $request->bank_id,
                'person_id' => $personID,
                'loan_amount' => $request->return_amount,
                'loan_date' => $request->loan_date,     
                'type' => 'loan_take_credit',     
            ]);

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

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

$sale_amount = StockModel::create([
                    'customer_id' => $request->customer_id,
                    'bank_id' => $request->bank_id,
                    'bank_amount' => $request->return_amount,
                ]);
            }

Session::flash('success', 'Loan Return Successfully');
        return redirect()->route('manageTakeLoan');   
    }

function viewSingleLoan($id)
    {
        $loan = LoanDetailsModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        $loan_details = LoanDetailsModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->get();
        $take_amount = $loan->sum('loan_amount');
        $return_amount = $loan->sum('return_amount');
        return view('back.loan.view_single_loan', compact('loan', 'loan_details', 'take_amount', 'return_amount'));
    }

//Give loan start

function makeGiveLoan()
    {
        $bank = BankModel::get(['id', 'bank_name']);
        return view('back.loan.add_give_loan', compact('bank'));
    }

function storeGiveLoan(Request $request)
    {

$request->validate([
            'name' => ['required', 'string', 'max:100'],
            'bank_id' => ['required', 'string', 'max:100'],
            'mobile' => ['required', 'string', 'max:100', 'unique:loan'],
            'give_loan_amount' => ['required', 'string', 'max:100'],
        ]);

$loan_details = LoanDetailsModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id, 
            'person_id' => $personId = DB::getPdo()->lastInsertId(), 
            'mobile' => $request->mobile, 
            'details' => $details,
            'loan_amount' => $request->give_loan_amount, 
            'loan_date' => $request->loan_date, 
            'type' => 'give_debit',
        ]);

$loan = LoanBalanceModel::create([
            'customer_id' => $request->customer_id, 
            'person_id' => $personId, 
            'give_loan_amount' => $request->give_loan_amount,
        ]);

// Deposit receive money in bank account for purchase ticket
        $payment_through = BankAccountModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id,
            'person_id' => $personId,
            'loan_amount' => $request->give_loan_amount,
            'loan_date' => $request->loan_date,     
            'type' => 'loan_give_debit',     
        ]);

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

Session::flash('success', 'Loan Successfully');
        return redirect()->route('manageGiveLoan');    
    }
    
    function manageGiveLoan()
    {
        $loan = LoanBalanceModel::get();
        return view('back.loan.manage_give_loan', compact('loan'));
    }

function reGiveLoan($id)
    {
        $bank = BankModel::get(['id', 'bank_name']);
        $loan = LoanDetailsModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        $prev_loan = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        return view('back.loan.re_give_loan', compact('loan', 'bank', 'prev_loan'));
    }

function storeReGiveLoan(Request $request, $id)
    {

$personID = $request->person_id;

$loan_details = LoanDetailsModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id, 
            'person_id' => $personID, 
            'mobile' => $request->mobile, 
            'details' => $request->details,
            'loan_amount' => $request->give_loan_amount, 
            'loan_date' => $request->loan_date, 
            'type' => 'give_debit',
        ]);

// Loan amount insert into loan balance
        $check = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
        if(empty($check))
        {
            $loan = LoanBalanceModel::create([
                'customer_id' => $request->customer_id, 
                'person_id' => $personId, 
                'give_loan_amount' => $request->give_loan_amount,
            ]);
        }else{

$amount = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
            $getamount = $amount->give_loan_amount - $request->give_loan_amount;

$loan = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID);
            $loan->update([
                'give_loan_amount' => $getamount,
            ]);
        }

// Deposit receive money in bank account for purchase ticket
            $payment_through = BankAccountModel::create([
                'customer_id' => $request->customer_id,
                'bank_id' => $request->bank_id,
                'person_id' => $personID,
                'loan_amount' => $request->give_loan_amount,
                'loan_date' => $request->loan_date,     
                'type' => 'loan_give_debit',     
            ]);

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

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

$sale_amount = StockModel::create([
                    'customer_id' => $request->customer_id,
                    'bank_id' => $request->bank_id,
                    'bank_amount' => $request->give_loan_amount,
                ]);
            }

Session::flash('success', 'Loan Taken Successfully');
        return redirect()->route('manageGiveLoan');   
    }

function returnGiveLoan($id)
    {
        $bank = BankModel::get(['id', 'bank_name']);
        $loan = LoanDetailsModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        $prev_loan = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $id)->first();
        return view('back.loan.return_give_loan', compact('loan', 'bank', 'prev_loan'));
    }

function storeReturnGiveLoan(Request $request, $id)
    {

$personID = $request->person_id;

$loan_details = LoanDetailsModel::create([
            'customer_id' => $request->customer_id,
            'bank_id' => $request->bank_id, 
            'person_id' => $personID, 
            'mobile' => $request->mobile, 
            'details' => $request->details,
            'return_amount' => $request->return_amount, 
            'return_date' => $request->return_date, 
            'type' => 'give_credit',
        ]);

// Loan amount insert into loan balance
        $check = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
        if(empty($check))
        {
            $loan = LoanBalanceModel::create([
                'customer_id' => $request->customer_id, 
                'person_id' => $personId, 
                'return_amount' => $request->return_amount,
            ]);
        }else{

$amount = LoanBalanceModel::where('customer_id', Auth::user()->customer_id)->where('person_id', $personID)->first();
            $getamount = $amount->give_loan_amount - $request->return_amount;

// Deposit receive money in bank account for purchase ticket
            $payment_through = BankAccountModel::create([
                'customer_id' => $request->customer_id,
                'bank_id' => $request->bank_id,
                'person_id' => $personID,
                'loan_amount' => $request->return_amount,
                'loan_date' => $request->loan_date,     
                'type' => 'loan_give_credit',     
            ]);

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

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

Session::flash('success', 'Loan Return Successfully');
        return redirect()->route('manageGiveLoan');   
    }

}