I would like to ask laravel how to obtain the data of the b table associated with polymorphism through table an and filter it by page.

problem description

I now have a publish table that records the published data with the following fields:

clipboard.png

publish_articlepublish_activity:

clipboard.png

publish table has polymorphic association with other data tables . I need to get the specified amount of data from all the data published by a user, and perform Filter on the data, removing the data with is_drafts = 1 and visible = 0

.

what methods have you tried

1 I have tried to change the table and move the fields used for judgment (is_drafts,visible) to the publish table, but in addition, my praise table and favorite table also have the same structure and function as the publish table, and I don"t want to have these fields in every table, so I feel that the fields are redundant, so this method is abandoned by me.
2 I have also tried to fetch the paged data from the publish table and then go to Filter to get detailed data, but the data after Filter does not reach the amount required by paging. So I gave up, too.

at present, there are only these two methods that can be thought of. How can you achieve the effect of paging and Filter data in the case of polymorphic association?

Php laravel git
Dec.21,2021

two schemes, inline, HasOne

< H2 > UserPublish.php < / H2 >

clipboard.png

clipboard.png

clipboard.png

clipboard.png

here is my table structure, user_publish is the record table, and the others are related data tables 

$data = $this->model->whereHas('publish', function($query) {
    $query->where('is_drafts', 0);
})->get();

Previous: How does Mysql write a stored procedure and insert data into two tables at the same time, with input parameters?

Next: How does js get the specific value in json format

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3a7d5-2c231.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3a7d5-2c231.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?