<?php

namespace App\Http\Controllers;

use App\Components\AsyncResponse;
use App\Components\Database;
use App\Components\ErrorPush;
use App\Services\WaybillService;
use App\Waybill;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

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(){
        $arr = DB::connection("oracle")->select(DB::raw("SELECT LOCATIONID FROM INV_LOT_LOC_ID
where LOCATIONID like 'IDE%' and CUSTOMERID in ('PUHE')
group by CUSTOMERID,LOCATIONID order by CUSTOMERID"));
        $str = "";

        foreach ($arr as $item){
            $str .= '"'.$item->locationid.'",';
        }
        dd($str);
    }
}