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

<?php

namespace App\Http\Controllers;

use App\Components\AsyncResponse;
use App\Components\ErrorPush;
use App\ErrorTemp;
use App\Feature;
use App\MaterialBox;
use App\MaterialBoxModel;
use App\Owner;
use App\OwnerFeeDetail;
use App\OwnerPriceOperation;
use App\RejectedBill;
use App\Services\ForeignHaiRoboticsService;
use App\Station;
use App\StationTask;
use App\StationTaskMaterialBox;
use App\TaskTransaction;
use App\Unit;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Cookie;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Http;

class TestController extends Controller
{
    use AsyncResponse,ErrorPush;
    const ASNREFERENCE_2 = 'ASNREFERENCE2';
    private $data = [];

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

    public function method(Request $request, $method)
    {
        return call_user_func([$this, $method], $request);
    }
    public function lightUp()
    {
        app("CacheShelfService")->lightUp('HAIB1-02-02','3','0');
    }
    public function lightOff()
    {
        $params = [
            "areaCode" => "1004",
            'locCode' => "HAIB1-02-02",
            'PTLAction' => 0,
        ];
        $response = Http::post(config('api.haiq.storage.light'), $params);
        return json_decode($response->body());
    }
    private $key = "CACHE_SHELF_AVAILABLE";
    public function test()
    {
        $modelId = 1;
        $blacklist = [];
        $query = MaterialBox::query()->where("material_box_model_id",$modelId)
            ->where("status",4);
        $boxes = $query->whereNotIn("id",$query->select("id")->whereHas("performTask"));
        if ($blacklist)$boxes = $boxes->whereNotIn("id",$blacklist);
        dd($boxes->get());
    }

}