@php use Illuminate\Support\Facades\DB; $OrderHD = DB::table('tdoctorhd') ->join('tmstmproduct', 'tdoctorhd.xvpdtcode', '=', 'tmstmproduct.xvpdtcode') ->Where('XBOrhIsReferedFR','false') ->Where('XVOrhDocStatus','3') ->get() ->toArray() @endphp