php - Laravel 爆炸并加入

Question

我有一个问题，我请求数据库中的一些数据，其中之一被连接起来，字段的形式如下:

 1 | 2 | 3 | ... | n-1 | n,

问题是我必须将每个数值与另一个表连接起来。

$Metro  = DB::table('fijacion')->where('tipo','Metro')->join('adp', 'fijacion.id', '=', "adp.id_fijacion")->get();

我想到的解决方案是链将其分开

foreach($Metro as $Metro){ 
    $array = explode("|", $Metro->nr);
    $MetroXI = DB::table('users')
              ->select('numero','nombre','apellido')
              ->whereIn('numero',$array)
              ->where('categoria', 1)
              ->join('puntos', 'users.numero', '=', "puntos.nr")
              ->orderBy('puntos.Total', 'asc')
              ->get();
 }

这打破了链条，但它只向我显示了结果

我知道这很难理解，但如果有人能指导我如何正确制作前壁或一些想法，我将不胜感激

$地铁:

[{"id":1,"semana":32,"fecha":"2017-08-11","dia":"Viernes","tipo":"Metro","categoria":null,"hora":"20:30 ","cancha":"CAPITOL ","partido":"CAPITOL \u2013 TABAR\u00c9 ","nr_1":null,"arbitro_1":null,"nr_2":null,"arbitro_2":null,"nr_3":null,"arbitro_3":null,"aux":1,"updated_at":"2017-08-07 12:04:04","created_at":"2017-08-07 12:03:57","id_fijacion":1,"nr":"7|22|29|31|32|40|53|59|66|67|68|77|5|12|13|17|18|20|24|27|28|33|35|37|44|46|50|52|61|64|65|75|23|25|26|39|47|48|51|58|69|74|80|82|83|86|93|96|104|109|117|120","designado":0},{"id":2,"semana":32,"fecha":"2017-08-11","dia":"Viernes","tipo":"Metro","categoria":null,"hora":"20:30 ","cancha":"MIRAMAR ","partido":"MIRAMAR \u2013 COL\u00d3N ","nr_1":null,"arbitro_1":null,"nr_2":null,"arbitro_2":null,"nr_3":null,"arbitro_3":null,"aux":1,"updated_at":"2017-08-07 12:04:04","created_at":"2017-08-07 12:03:57","id_fijacion":2,"nr":"7|22|29|31|32|40|53|59|66|67|68|77|5|12|13|17|18|20|24|27|28|33|35|37|44|46|50|52|61|64|65|75|23|25|26|39|47|48|51|58|69|74","designado":0},{"id":3,"semana":32,"fecha":"2017-08-11","dia":"Viernes","tipo":"Metro","categoria":null,"hora":"20:30 ","cancha":"SAYAGO ","partido":"ATENAS \u2013 AURIBLANCO ","nr_1":null,"arbitro_1":null,"nr_2":null,"arbitro_2":null,"nr_3":null,"arbitro_3":null,"aux":1,"updated_at":"2017-08-07 12:04:04","created_at":"2017-08-07 12:03:57","id_fijacion":3,"nr":"28|33|35|37|44|46|50|52|61|64|65|75|23|25|26|39|47|48|51|58|69|74|80|82|83|86|93|96|104|109|117|120","designado":0},{"id":4,"semana":32,"fecha":"2017-08-11","dia":"Viernes","tipo":"Metro","categoria":null,"hora":"20:30 ","cancha":"CORD\u00d3N \u2013 SIN P\u00daBLICO VISITANTE ","partido":"CORD\u00d3N \u2013 25 DE AGOSTO ","nr_1":null,"arbitro_1":null,"nr_2":null,"arbitro_2":null,"nr_3":null,"arbitro_3":null,"aux":1,"updated_at":"2017-08-07 12:04:05","created_at":"2017-08-07 12:03:57","id_fijacion":4,"nr":"7|22|29|31|32|40|53|59|66|67|68|77|5|12|13|17|18|20|35|37|44|46|50|52|61|64|65|75|23|25|26|39|47|48|51|58|69|74|80|82|83|86|93|96|104|109|117|120","designado":0},{"id":5,"semana":32,"fecha":"2017-08-11","dia":"Viernes","tipo":"Metro","categoria":null,"hora":"20:30 ","cancha":"STOCKOLMO ","partido":"STOCKOLMO \u2013 UNI\u00d3N ATL\u00c9TICA ","nr_1":null,"arbitro_1":null,"nr_2":null,"arbitro_2":null,"nr_3":null,"arbitro_3":null,"aux":1,"updated_at":"2017-08-07 12:04:05","created_at":"2017-08-07 12:03:57","id_fijacion":5,"nr":"7|22|29|31|32|40|53|59|66|67|68|77|5|12|13|17|18|20|24|27|28|33|35|37|44|46|50|52|61|64|65|75|23|25|26|39|47|83|86|93|96|104|109|117|120","designado":0}]

在 nr 值中是我必须加入的地方

感谢@yoeunes loger avanasa，但现在我认为我有错误。

我意识到我没有将 $ Metro 与 $ MetroXI 联系起来 [ ]

这是我的 .blade 的参数这是我的观点:

                @foreach($Metro as $Metro)
                    <tr>
                    <th>{{$Metro->dia}}</th>
                    <th>{{$Metro->fecha}}</th>
                    <th>{{$Metro->categoria}}</th>
                    <th>{{$Metro->hora}}</th>
                    <th>{{$Metro->cancha}}</th>
                    <th>{{$Metro->partido}}</th>
                    <th>@php$array = explode("|", $Metro->nr);$pepe = count($array);@endphp{{ $pepe }}</th>


                    <select class="form-control" name="select1" id="arbitro_1">
                        <option selected="true" disabled="disabled">Selecione 1º Arbitro</option>
                        <option disabled="disabled">---Internacional---</option>
                        @foreach($MetroXI as $MetroXI)
                          <option value="{{$MetroXI->numero}}">{{$MetroXI->nombre}}. {{$MetroXI->apellido}}</option>
                        @endforeach
                    </select>

        @endforeach

你给我的错误是:

Property [nr] does not exist on this collection instance.

并且与 3 个变量一起发生。

Answer 1

尝试使用这个:

$MetroXI = [];
foreach($Metro as $Metro){ 
    $array = explode("|", $Metro->nr);
    $MetroXI[] = DB::table('users')
              ->select('numero','nombre','apellido')
              ->whereIn('numero',$array)
              ->where('categoria', 1)
              ->join('puntos', 'users.numero', '=', "puntos.nr")
              ->orderBy('puntos.Total', 'asc')
              ->get();
 }

然后检查 $MetroXI 数组，它将包含所有结果；