<?php

namespace App\Http\Controllers;

use App\Batch;
use App\CommodityBarcode;
use App\Components\AsyncResponse;
use App\Components\Database;
use App\Components\ErrorPush;
use App\Exceptions\Exception;
use App\OracleDOCWaveDetails;
use App\Order;
use App\OrderBin;
use App\OrderCommodity;
use App\Rejected;
use App\RejectedBill;
use App\RejectedBillItem;
use App\Services\LogService;
use App\Services\OracleDOCOrderHeaderService;
use App\Services\OrderCommodityService;
use App\Services\OrderService;
use App\Services\WaveService;
use App\Services\WaybillService;
use App\SortingStation;
use App\User;
use App\UserToken;
use App\Waybill;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Str;
use Zttp\Zttp;

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)
    {
        $list = DB::connection("aliyunMysql")->select("select * from equipment where category_id = 0 and type = 0 and parent_id is null");
        foreach ($list as $item) {
            $obj = json_decode($item->info);
            var_dump(DB::connection("aliyunMysql")->update("update equipment set category_id = {$obj->id} where id = {$item->id} or parent_id = {$item->id}"));
        }
    }
}