ebayShop/app/Http/Controllers/SellerPackagePaymentController.php

<?php

namespace App\Http\Controllers;

use App\Models\User;
use App\Models\Wallet;
use App\Models\BusinessSetting;
use App\Models\AffiliateLog;
use Auth;
use Illuminate\Http\Request;
use App\Models\SellerPackagePayment;
use App\Models\SellerPackage;
use function array_column;
use function compact;
use function view;

class SellerPackagePaymentController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        //
    }

    public function offline_payment_request(){
        $package_payment_requests = SellerPackagePayment::where('offline_payment',1)->orderBy('id', 'desc')->paginate(10);
        if (Auth::user()->user_type == 'salesman') {
            $userIds = User::where('pid', Auth::user()->id)->get()->toArray();
            $package_payment_requests = SellerPackagePayment::where('offline_payment', 1)->whereIn('user_id', array_column($userIds, 'id'))->orderBy('id', 'desc')->paginate(10);
            return view('manual_payment_methods.seller_package_payment_request_salesman', compact('package_payment_requests'));
        }
        return view('manual_payment_methods.seller_package_payment_request', compact('package_payment_requests'));
    }

    public function offline_payment_approval(Request $request)
    {
        
        $package_payment    = SellerPackagePayment::findOrFail($request->id);
        
        $package_details    = SellerPackage::findOrFail($package_payment->seller_package_id);
        
        $package_payment->approval      = $request->status;
        if($package_payment->save()){
            if($request->status==1){ //通过
                $user= User::where('id', $package_payment->user_id)->get();
                $user=$user[0];
                $money=$package_details->amount;
                $osn = $package_payment->payment_details;
                if($user->invit_1 != null && $money>0){ //一级分佣
                    $invit_1=BusinessSetting::where('type', 'commission_store_level_1')->first()->value;
                    $invit_1=sprintf("%.2f",$money*$invit_1/100);
                    User::where('id', $user->invit_1)->increment('balance', $invit_1);
                    //写入日志
                    $affiliate_log = new AffiliateLog;
                    $affiliate_log->user_id = $user->id;
                    $affiliate_log->referred_by_user = $user->invit_1;
                    $affiliate_log->amount = $invit_1;
                    $affiliate_log->order_id = $osn;
                    $affiliate_log->note = $user->name.'('.$user->email.') Upgrade shop,First level commission bonus $'.$invit_1;
                    $affiliate_log->affiliate_type = 'upgrade_shop';
                    $affiliate_log->save();
                    if($user->invit_2 != null){ //二级分佣
                        $invit_2=BusinessSetting::where('type', 'commission_store_level_2')->first()->value;
                        $invit_2=sprintf("%.2f",$money*$invit_2/100);
                        User::where('id', $user->invit_2)->increment('balance', $invit_2);
                        //写入日志
                        $affiliate_log = new AffiliateLog;
                        $affiliate_log->user_id = $user->id;
                        $affiliate_log->referred_by_user = $user->invit_2;
                        $affiliate_log->amount = $invit_2;
                        $affiliate_log->order_id = $osn;
                        $affiliate_log->note = $user->name.'('.$user->email.') Upgrade shop,Second level commission bonus $'.$invit_2;
                        $affiliate_log->affiliate_type = 'upgrade_shop';
                        $affiliate_log->save();
                        if($user->invit_3 != null){ //三级分佣
                            $invit_3=BusinessSetting::where('type', 'commission_store_level_3')->first()->value;
                            $invit_3=sprintf("%.2f",$money*$invit_3/100);
                            User::where('id', $user->invit_3)->increment('balance', $invit_3);
                            //写入日志
                            $affiliate_log = new AffiliateLog;
                            $affiliate_log->user_id = $user->id;
                            $affiliate_log->referred_by_user = $user->invit_3;
                            $affiliate_log->amount = $invit_3;
                            $affiliate_log->order_id = $osn;
                            $affiliate_log->note = $user->name.'('.$user->email.') Upgrade shop,Three level commission bonus $'.$invit_3;
                            $affiliate_log->affiliate_type = 'upgrade_shop';
                            $affiliate_log->save();
                        }
                    }
                }
            }
            $seller                                 = $package_payment->user->shop;
            $seller->seller_package_id              = $package_payment->seller_package_id;
            $seller->product_upload_limit           = $package_details->product_upload_limit;
            $seller->package_invalid_at             = date('Y-m-d', strtotime( $seller->package_invalid_at. ' +'. $package_details->duration .'days'));
            if($seller->save()){
                return 1;
            }
        }
        return 0;
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }
}