芝麻web文件管理V1.00

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

class ExpenseController extends Controller
{

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

function makeExpense()
	{
		$bank = StockModel::where('customer_id', Auth::user()->customer_id)->whereNotNull('bank_id')->get();
		return view('back.expense.add_expense', compact('bank'));
	}

function storeExpense(Request $request)
	{

$request->validate([
			'expense_title' => ['required', 'string'],
			'expense_amount' => ['required', 'string'],
			'expense_date' => ['required', 'string'],
			'bank_id' => ['required', 'string'],

]);

$expense = ExpenseModel::create([
			'customer_id' => $request->customer_id,
			'expense_title' => $request->expense_title,
			'expense_amount' => $amount = $request->expense_amount,
			'expense_date' => $date = $request->expense_date,
			'bank_id' => $bank = $request->bank_id,
			'expense_purpose' => $request->expense_purpose,
		]);

$bank = BankAccountModel::create([
			'customer_id' => $request->customer_id,
			'bank_id' => $bank,
			'expense_id' => DB::getPdo()->lastInsertId(),
			'expense_amount' => $amount,
			'expense_date' => $date,
			'type' => 'expense',
		]);

$stock = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $request->bank_id)->first(['id','customer_id','bank_id','bank_amount']);
		$getamount = $stock->bank_amount - $request->expense_amount;

$stock = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $request->bank_id);
		$stock->update([
			'bank_amount' => $getamount,
		]);

Session::flash('success', 'Added Successfully');
        return redirect()->route('manageExpense');
	}

function manageExpense()
	{
		$expense = ExpenseModel::where('customer_id', Auth::user()->customer_id)->get();
		return view('back.expense.manage_expense', compact('expense'));
	}

function editExpense($id)
	{
		$bank = StockModel::where('customer_id', Auth::user()->customer_id)->whereNotNull('bank_id')->get();
		$expense = ExpenseModel::where('customer_id', Auth::user()->customer_id)->where('id', $id)->first();
		return view('back.expense.edit_expense', compact('expense', 'bank'));
	}

function updateExpense(Request $request, $id)
	{
		
		$expense = ExpenseModel::where('customer_id', Auth::user()->customer_id)->where('id', $id)->first();
		$stock = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $request->bank_id)->first();
		$getamount = $stock->bank_amount + $expense->expense_amount;
		$stock = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $request->bank_id);
		$stock->update([
			'bank_amount' => $getamount,
		]);

$stock = StockModel::where('customer_id', Auth::user()->customer_id)->where('bank_id', $request->bank_id);
		$stock->update([
			'bank_amount' => $getamount,
		]);

$expense = ExpenseModel::where('customer_id', Auth::user()->customer_id)->where('id', $id);
		$expense->update([
			'expense_title' => $request->expense_title,
			'expense_amount' => $amount = $request->expense_amount,
			'expense_date' => $date = $request->expense_date,
			'bank_id' => $bank = $request->bank_id,
			'expense_purpose' => $request->expense_purpose,
		]);

$bank_account = BankAccountModel::where('customer_id', Auth::user()->customer_id)->where('expense_id', $id);
		$bank_account->update([
			'bank_id' => $bank,
			'expense_amount' => $amount,
			'expense_date' => $date,
		]);

Session::flash('success', 'Update Successfully');
        return redirect()->route('manageExpense');
	}
}