芝麻web文件管理V1.00

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

class SubAgentController extends Controller
{

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

function makeSubAgent()
    {
        $sub_agent = SubAgentModel::where('customer_id', Auth::user()->customer_id)->get();
        return view('back.sub_agent.add_sub_agent', compact('sub_agent'));
    }

function storeSubAgent(Request $request)
    {
    	$request->validate([
    		'name' => ['required', 'string'],
    		'mobile' => ['required', 'string'],
    	]);

$sub_agent = SubAgentModel::create([
    		'customer_id' => $request->customer_id,
    		'name' => $request->name,
    		'mobile' => $request->mobile,
    		'address' => $request->address,
    	]);

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

function manageSubAgent()
    {    
       
       $due = DueBalanceModel::where('customer_id', Auth::user()->customer_id)->select(DB::raw('SUM(due_amount) as due_amount, sub_agent_id'))->where('sub_agent_id', !NULL)->groupBy('sub_agent_id')->get();
        return view('back.sub_agent.manage_sub_agent', compact('due'));
    }

function manage_sub_agent_due($id)
    {
        $passenger = DueBalanceModel::where('customer_id', Auth::user()->customer_id)->where('sub_agent_id', $id)->get();
        return view('back.sub_agent.sub_agent_passenger_due', compact('passenger'));
    }

}