baoshi-was/app/Http/Controllers/TestController.php

<?php

namespace App\Http\Controllers;

use App\Components\AsyncResponse;
use App\Components\Database;
use App\Components\ErrorPush;
use App\DeliveryAppointment;
use App\MaterialBox;
use App\MaterialBoxModel;
use App\OracleDOCASNHeader;
use App\Order;
use App\OrderDetail;
use App\OrderIssue;
use App\OrderIssueRejectedBill;
use App\RejectedBill;
use App\Role;
use App\Services\common\BatchUpdateService;
use App\Services\DeliveryAppointmentService;
use App\Services\OracleDocAsnHerderService;
use App\Services\OrderRejectedBillRelationService;
use App\Services\OrderRejectingStatusService;
use App\Services\OwnerService;
use App\Services\RejectedService;
use App\Services\UserService;
use App\Services\WaybillService;
use App\User;
use App\Waybill;
use App\WorkOrder;
use Illuminate\Database\Capsule\Manager;
use Illuminate\Database\DatabaseManager;
use Illuminate\Foundation\Auth\AuthenticatesUsers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Log;
use Oursdreams\Export\Export;
use Workerman\Worker;

class TestController extends Controller
{
    use AsyncResponse, ErrorPush, Database;

    const ASNREFERENCE_2 = 'ASNREFERENCE2';

    public function __construct()
    {
        $this->data["active_test"] = "active";
    }

    public function method(Request $request, $method)
    {
        try {
            return call_user_func([$this, $method], $request);
        }catch (\BadMethodCallException $e){
            dd("方法不存在");
        }
    }
    public function test(Request $request){
        $users = User::query()->with(["roles.owners"])->get();
        foreach ($users as $user){
            $owners = [];
            foreach ($user->roles as $role){
                foreach ($role->owners as $owner){
                    $owners[] = $owner->id;
                }
            }
            $user->owners()->sync($owners);
        }
    }

    public function test123()
    {
        $codes = ['OCGBS202202160032'];
        $items = OracleDOCASNHeader::query()->select('asnNo')->whereIn('ASNReference1',$codes)->get();
        dd($items);
    }
}