php 如何使用laravel中的join来合并3个不同的表？一个表用于多-多关系表，视图中需要附加变量

piwo6bdm  于 2023-05-16  发布在  PHP
关注(0)|答案(1)|浏览(135)

数据库中有3个表：users、bukus和bukus_users（用于以后处理项目时可能需要的多对多关系）
表的列和类型变量如下：
用户：id，name（string），email（string），username（string），password（string）
bukus：id，nama_buku（string），cover（string），author（string），barcode（string）
bukus_users：id，bukus_id（bigint），users_id（bigint），tgl_pinjam（datetime），tgl_tenggat（datetime），status（boolean）
我需要一个从bukus_users中检索表数据的表视图，用nama_buku替换bukus_id，用username/email/name替换user_id，可能会得到如下表示例：
不想|用户名/电子邮件/名称|纳马布库|tgl_pinjam| tgl_tenggal|地位
1| user1，us1@email.com|图书1| 10/02/22| 21/02/22|不想
二|user1，us1@email.com|图书2| 2019 - 05 - 09| 20/02/23|是的
三|user2，us2@email.com|图书2| 10/02/22| 21/02/22|不想
四个|user2，us2@email.com|图书1| 2019 - 05 - 09| 20/02/23|是的
下面是我做的代码（你可以忽略许多代码注解）：
Model/Buku.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use App\Models\User;
use App\Models\bukus_users;
class Buku extends Model
{
    use HasFactory;
    /*protected function users(){
        return $this->belongsToMany('App\Models\User');
    }*/
    public function users()
    {
        return $this->belongsToMany(
            User::class,
            bukus_users::class,
            'bukus_id',
            'users_id'
        )->withPivot((new bukus_users())->getColumns());
    }
        /*protected function pinjam(){
            return $this->hasMany('App\Models\bukus_user');
        }*/
        protected $fillable = [
            'cover',
            'nama_buku',
            'author',
            'terbitan',
            'barcode',
            'ketersediaan',
        ]; 
}

Model/User.php

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Sanctum\HasApiTokens;
use App\Models\Buku;
use App\Models\bukus_users;

class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;
    public function bukus()
    {
        return $this->belongsToMany(
            Buku::class,
            bukus_users::class,
            'users_id',
            'bukus_id',
        )->withPivot((new bukus_users())->getColumns());
    }
        /*protected function pinjam(){
            return $this->hasMany('App\Models\bukus_user');
        }*/
        protected $fillable = [
            'name',
            'email',
            'username',
            'password',
            'address',
            'phone',
        ]; 
}

Model/bukus_users.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use App\Models\User;
use App\Models\Buku;
use Illuminate\Database\Eloquent\Relations\HasOne;

class bukus_users extends Model
{
    use HasFactory;
    public function user()
    {
        return $this->hasOne(User::class, 'id', 'users_id');
    }
    public function buku()
    {
        return $this->hasOne(Buku::class, 'id', 'bukus_id');
    }
    protected $fillable = [
        'bukus_id',
        'users_id',
        'tgl_pinjam',
        'tgl_tenggat',
        'status_pengembalian',
    ];
}

controller.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Providers\RouteServiceProvider;
use App\Models\bukus_users;
use Carbon\Carbon;
class PinjamController extends Controller
{
protected function index()
{
    //$rows = bukus_users::orderBy('id')->paginate(5);
    $i = 0;
    $rows = bukus_users::query()->with(['buku', 'user'])->paginate(5)->toArray(); // the rows will be in data key
    //ddd('dumping this one', $rows);
    return view('admin.pinjam.index', compact('rows', 'i'));
} }

admin/pinjam/index.blade.php：

<table class="table table-bordered">
            <thead>
                <tr>
                    <th>No</th>
                    <th>Nama User</th>
                    <th>Nama Buku Pinjaman</th>
                    <th>Tanggal Pinjam</th>
                    <th>Tanggal Tenggat</th>
                    <th>Status</th>
                    <th width="280px">Action</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($rows as $pinjam)
                <tr>
                    <td>{{ $i++ }}</td>
                    <td>
                    {{ $pinjam->user->name }}, {{ $pinjam->user->username }}, {{ $pinjam->user->email }}
                    </td>
                    <td>
                    {{ $pinjam->buku->nama_buku }}
                    </td>
                    <td>{{ $pinjam->tgl_pinjam }}</td>
                    <td>{{ $pinjam->tgl_tenggat }}</td>
                    <td>{{ $pinjam->status_pengembalian}}</td>
                    <td>
                        <form action="{{ route('pinjam.destroy',$pinjam->id) }}" method="Post">
                            <a class="btn btn-primary" href="{{ route('pinjam.edit',$pinjam->id) }}">Edit</a>
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
            </tbody>
        </table>

//前一个错误
但是，我得到了错误SQL加入字段：SQLSTATE[42S22]：未找到列：1054 Unknown column 'bukus.bukus_users_id' in 'field list'，so what did I do wrong？是因为数据库中的表吗？或者我只是强制连接表，需要更好的外部或内部连接代码的方式？
这里是错误的ss
SQLSTATE[42S22]
我希望视图上的表从bukus_users表中检索数据，表的最左边包含username和nama_buku，在id列之后的相应列中替换users_id和bukus_id。所以我只需要bukus_user在有少量用户的视图上，左边的bukus数据与bukus_user数据库表中保存的相应id相对应。
我希望数据库看起来像这样：
身份证|布库斯ID|用户ID| tgl_pinjam| tgl_tenggat|地位
1| 1| 1| 10/02/22| 21/02/22|不想
二|二|1| 2019 - 05 - 09| 20/02/23|是的
三|二|二|10/02/22| 21/02/22|不想
四个|1|二|2019 - 05 - 09| 20/02/23|是的
Into views表的显示方式如下：
不想|用户名/电子邮件|纳马布库|平占|腾格山|地位
1| user1，us1@email.com|图书1| 10/02/22| 21/02/22|不想
二|user1，us1@email.com|图书2| 2019 - 05 - 09| 20/02/23|是的
三|user2，us2@email.com|图书2| 10/02/22| 21/02/22|不想
四个|user2，us2@email.com|图书1| 2019 - 05 - 09| 20/02/23|是的
更新2：新错误是尝试读取int上的属性“user”
堆垛轨道

[previous exception] [object] (ErrorException(code: 0): Attempt to read property \"user\" on int at C:\\xampp\\htdocs\\perpusperkantas\\storage\\framework\\views\\33cf3e32f260a058cbd92996194f24de8700ba85.php:35)
[stacktrace]
#0 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Bootstrap\\HandleExceptions.php(266): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(2, 'Attempt to read...', 'C:\\\\xampp\\\\htdocs...', 35)
#1 C:\\xampp\\htdocs\\perpusperkantas\\storage\\framework\\views\\33cf3e32f260a058cbd92996194f24de8700ba85.php(35): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}(2, 'Attempt to read...', 'C:\\\\xampp\\\\htdocs...', 35)
#2 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Filesystem\\Filesystem.php(109): require('C:\\\\xampp\\\\htdocs...')
#3 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Filesystem\\Filesystem.php(110): Illuminate\\Filesystem\\Filesystem::Illuminate\\Filesystem\\{closure}()
#4 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\PhpEngine.php(58): Illuminate\\Filesystem\\Filesystem->getRequire('C:\\\\xampp\\\\htdocs...', Array)
#5 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Engines\\CompilerEngine.php(70): Illuminate\\View\\Engines\\PhpEngine->evaluatePath('C:\\\\xampp\\\\htdocs...', Array)
#6 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(195): Illuminate\\View\\Engines\\CompilerEngine->get('C:\\\\xampp\\\\htdocs...', Array)
#7 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(178): Illuminate\\View\\View->getContents()
#8 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\View\\View.php(147): Illuminate\\View\\View->renderContents()
#9 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Response.php(69): Illuminate\\View\\View->render()
#10 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Response.php(35): Illuminate\\Http\\Response->setContent(Object(Illuminate\\View\\View))
#11 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(906): Illuminate\\Http\\Response->__construct(Object(Illuminate\\View\\View), 200, Array)
#12 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(875): Illuminate\\Routing\\Router::toResponse(Object(Illuminate\\Http\\Request), Object(Illuminate\\View\\View))
#13 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(797): Illuminate\\Routing\\Router->prepareResponse(Object(Illuminate\\Http\\Request), Object(Illuminate\\View\\View))
#14 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#15 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#16 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#17 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Auth\\Middleware\\Authenticate.php(44): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#18 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'admin')
#19 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken.php(78): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#20 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#21 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\View\\Middleware\\ShareErrorsFromSession.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#22 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#23 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(121): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#24 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Session\\Middleware\\StartSession.php(64): Illuminate\\Session\\Middleware\\StartSession->handleStatefulRequest(Object(Illuminate\\Http\\Request), Object(Illuminate\\Session\\Store), Object(Closure))
#25 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#26 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse.php(37): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#27 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#28 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Cookie\\Middleware\\EncryptCookies.php(67): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#29 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#30 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#31 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(797): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#32 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#33 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#34 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#35 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(190): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#36 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#37 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#38 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#39 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#40 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#41 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#42 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#43 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#44 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#45 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#46 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#47 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#48 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#49 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#50 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#51 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#52 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#53 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#54 C:\\xampp\\htdocs\\perpusperkantas\\public\\index.php(51): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#55 C:\\xampp\\htdocs\\perpusperkantas\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\resources\\server.php(16): require_once('C:\\\\xampp\\\\htdocs...')
#56 {main}
"}

var_dump响应

array(13) { ["current_page"]=> int(1) ["data"]=> array(1) { [0]=> array(10) { ["id"]=> int(5) ["bukus_id"]=> int(4) ["users_id"]=> int(1) ["tgl_pinjam"]=> string(19) "2023-04-13 08:39:57" ["tgl_tenggat"]=> string(19) "2023-04-24 08:39:57" ["status_pengembalian"]=> int(1) ["created_at"]=> string(27) "2023-04-13T08:39:57.000000Z" ["updated_at"]=> string(27) "2023-04-13T08:39:57.000000Z" ["buku"]=> array(9) { ["id"]=> int(4) ["cover"]=> string(18) "20230412074134.jpg" ["nama_buku"]=> string(17) "Pemrograman Web X" ["author"]=> string(10) "Yudishtira" ["terbitan"]=> string(4) "2014" ["barcode"]=> string(13) "9789790929999" ["ketersediaan"]=> int(1) ["created_at"]=> string(27) "2023-04-12T07:41:34.000000Z" ["updated_at"]=> string(27) "2023-04-12T07:41:34.000000Z" } ["user"]=> array(9) { ["id"]=> int(1) ["name"]=> string(14) "Muhammad Yusuf" ["username"]=> string(8) "pengguna" ["email"]=> string(22) "betweenerkex@gmail.com" ["email_verified_at"]=> NULL ["address"]=> string(13) "Kudus, Jateng" ["phone"]=> string(12) "087874837301" ["created_at"]=> string(27) "2023-04-06T03:31:33.000000Z" ["updated_at"]=> string(27) "2023-04-06T03:31:33.000000Z" } } } ["first_page_url"]=> string(41) "http://127.0.0.1:8000/admin/pinjam?page=1" ["from"]=> int(1) ["last_page"]=> int(1) ["last_page_url"]=> string(41) "http://127.0.0.1:8000/admin/pinjam?page=1" ["links"]=> array(3) { [0]=> array(3) { ["url"]=> NULL ["label"]=> string(16) "« Previous" ["active"]=> bool(false) } [1]=> array(3) { ["url"]=> string(41) "http://127.0.0.1:8000/admin/pinjam?page=1" ["label"]=> string(1) "1" ["active"]=> bool(true) } [2]=> array(3) { ["url"]=> NULL ["label"]=> string(12) "Next »" ["active"]=> bool(false) } } ["next_page_url"]=> NULL ["path"]=> string(34) "http://127.0.0.1:8000/admin/pinjam" ["per_page"]=> int(5) ["prev_page_url"]=> NULL ["to"]=> int(1) ["total"]=> int(1) }

vardump response

php

1条答案

按热度按时间
thtygnil

thtygnil1#

你需要在Book模型中使用belongsToMany关系：

public function users(): BelongsToMany
{
    return $this->belongsToMany(
        User::class,
        BookUserPivot::class,
        'book_id',
        'user_id'
    )->withPivot((new BookUserPivot())->getColumns());
}

这将检索包含用户的书籍集合，每个用户都有一个透视键，您可以在其中找到透视值。
//测试它

foreach (Book::query()->with('users')->get() as $book) {
    echo ($firstUser = $book->users->first())?->name . ' ' . $book->name . ' ' . $firstUser?->pivot->borrowdate;
{

或

foreach (Book::query()->with('users')->get() as $book) {
    foreach ($book->users as $user) {
        echo $user->name . ' ' . $book->name . ' ' . $user->pivot->borrowdate;
    {
{

//或者在视图中使用它

return \view('views.view', ['rows' => Book::query()->with('users')->get()]) // {{$rows}} in the blade

//对于分页返回json到fe AJAX 调用：

return \response()->json(Book::query()->with('users')->paginate(
    \max(1, $allRequest['limit'] ?? 10),
    ['*'],
    'page',
    \max((int)($allRequest['page'] ?? 1), 1)
)->toArray())

更新
Model/Buku.php

public function users()
{
    return $this->belongsToMany(
        User::class,
        bukus_users::class,
        'bukus_id',
        'users_id'
    )->withPivot((new bukus_users())->getColumns());
}

Model/User.php

public function bukus()
{
    return $this->belongsToMany(
        Buku::class,
        bukus_users::class,
        'users_id',
        'bukus_id',
    )->withPivot((new bukus_users())->getColumns());
}

Model/bukus_users.php

use Illuminate\Database\Eloquent\Relations\HasOne;

public function user(): HasOne
{
    return $this->hasOne(User::class, 'id', 'users_id');
}
public function buku(): HasOne
{
    return $this->hasOne(Buku::class, 'id', 'bukus_id');
}

controller.php

protected function index()
{
    $rows = bukus_users::query()->with(['buku', 'user'])->paginate(5)->toArray(); // the rows will be in data key
    return view('admin.pinjam.index', ['rows' => $rows]);
}

 
["current_page"]=> int(1) 
    ["data"]=> array(1) {
    [0]=> array(10) {
        ["id"]=> int(5)
            ["bukus_id"]=> int(4)
            ["users_id"]=> int(1)
            ["tgl_pinjam"]=> string(19) "2023-04-13 08:39:57"
            ["tgl_tenggat"]=> string(19) "2023-04-24 08:39:57"
            ["status_pengembalian"]=> int(1)
            ["created_at"]=> string(27) "2023-04-13T08:39:57.000000Z"
            ["updated_at"]=> string(27) "2023-04-13T08:39:57.000000Z"
            ["buku"]=> array(9) {
                ["id"]=> int(4)
                ["cover"]=> string(18) "20230412074134.jpg"
                ["nama_buku"]=> string(17) "Pemrograman Web X" 
                ["author"]=> string(10) "Yudishtira"
                ["terbitan"]=> string(4) "2014"
                ["barcode"]=> string(13) "9789790929999"
                ["ketersediaan"]=> int(1)
                ["created_at"]=> string(27) "2023-04-12T07:41:34.000000Z"
                ["updated_at"]=> string(27) "2023-04-12T07:41:34.000000Z"
            }
            ["user"]=> array(9) {
                ["id"]=> int(1)
                ["name"]=> string(14) "Muhammad Yusuf"
                ["username"]=> string(8) "pengguna"
                ["email"]=> string(22) "betweenerkex@gmail.com"
                ["email_verified_at"]=> NULL
                ["address"]=> string(13) "Kudus, Jateng"
                ["phone"]=> string(12) "087874837301"
                ["created_at"]=> string(27) "2023-04-06T03:31:33.000000Z"
                ["updated_at"]=> string(27) "2023-04-06T03:31:33.000000Z"
            }
    } } ["first_page_url"]=> string(41) "http://127.0.0.1:8000/admin/pinjam?page=1" ["from"]=> int(1) ["last_page"]=> int(1) ["last_page_url"]=> string(41) "http://127.0.0.1:8000/admin/pinjam?page=1" ["links"]=> array(3) { [0]=> array(3) { ["url"]=> NULL ["label"]=> string(16) "« Previous" ["active"]=> bool(false) } [1]=> array(3) { ["url"]=> string(41) "http://127.0.0.1:8000/admin/pinjam?page=1" ["label"]=> string(1) "1" ["active"]=> bool(true) } [2]=> array(3) { ["url"]=> NULL ["label"]=> string(12) "Next »" ["active"]=> bool(false) } } ["next_page_url"]=> NULL ["path"]=> string(34) "http://127.0.0.1:8000/admin/pinjam" ["per_page"]=> int(5) ["prev_page_url"]=> NULL ["to"]=> int(1) ["total"]=> int(1) }
赞(0）分享  回复(0）举报  2023-05-16
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com