Search scope in model returns 'Column in where clause is ambiguous'

I want to create a scope in the modal to run in a search I want to know if in an array of ids the products categories are included or not. This is the code I have right now, this doesn't work at all, it doesn't make a difference function scopeCategoryStore($query, $request, $active) { if ($request['query'] && $request["query"]["active"] != 'null'

eggplantSword's avatar
eggplantSword's avatar msslgomezGeneral
2

Github Issues API

I am currently building a Github Issues clone and I use Github Issues API to fetch the data. The returned values can be retrieved based on state but I can't seem to find the data for total count of issues in a repo. Only 'open_issues' and 'open_issues_count' are being retrieved, no total count and count for closed issues. I wanted to use this total count information for paginat

syntaxerron's avatar
syntaxerron's avatar syntaxerro...Requests
0

validate request and raise exception on undefined-parameters

Hi folks, i am trying to solve a problem but i am missing an idea how to do it elegantly. I would like to trigger an exception / 404 http error if a parameter was passed that was not defined in the validator. i don't want to duplicate the code for every controller, so i moved the code to a parent controller, but i have no access to the specific request validator there, so i hav

b166er's avatar
b166er's avatar b166erLaravel
6

filter isnt reseting , search isnt updating

please kindly help what m i doing wrong , filter isnt reseting , search isnt updating also pagination isnt work <?php namespace App\Http\Livewire; use App\Models\School; use App\Models\Status; use App\Models\Post; use App\Models\Vote; use Livewire\Component; use Livewire\WithPagination; class PostsIndex extends Component { use WithPagination; public $status;

Kikismedia's avatar
Kikismedia's avatar valentin_v...Livewire
8

[Vue warn]: Error in render: “TypeError: Cannot read property ‘next’ of undefined”

Hi, I am getting warning "next undefined" when page is mounted. Here next is the pagination link. I have also v-if to check if there is next or not this is my api response { data: [ { id: 19, name: 'abc', email:'[email protected] } } ], links: { first: "https://localhost:800/api/users?page=1", last: null, pr

david001's avatar
david001's avatar david001Vue
0

Pulling a dataset and only importing certain items

I am using an API to pull in a large data set, I am then rendering a table with HTML where users can tick which items they'd like to import. Here is my controller <?php namespace App\Http\Controllers\Admin; use App\Events\DealImportedFromHubspot; use App\Http\Controllers\Controller; use App\Hubspot\PipelineHubspot; use App\Models\Deal; use App\Models\DealStage; use Illumi

jesse_orange_newable's avatar
jesse_orange_newable's avatar jesse_oran...Code Review
0

How to get total rows count in laravel with simplePagination()

How can I get total rows count with simplePagination() in Laravel? paginate() runs two quires and both takes separate time to execute that I don't want. Is there any other way to get total rows count in pagination ?

sajjadali's avatar
sajjadali's avatar asajjad201Laravel
13

How to exclude the relation column from the collection result array- eager loading

I'm trying to figure out how to exclude/hide the relationship column in the eager load collection result array I have 2 models and here are the relations Product.php class Product extends Model { public function Category() { return $this->belongsTo(Category::class); } } Category.php class Category extends Model { public function Product() { return $this-&

M@rty's avatar
M@rty's avatar SilenceBri...Eloquent
10

How to include meta and links in Laravel API Resource Collection?

I am building an API for an SPA and I used Laravel API Resources with pagination. I have been using it on my previous projects but on the latest update, the meta data and links are gone. I am using the latest version of Laravel 7. I used this on my previous projects when retrieving a resource collection: UserResource::collection(User::all()); which returns: current_page: 1 data

syntaxerron's avatar
syntaxerron's avatar syntaxerro...Laravel
2

Add relationship to eloquent query to model with scopes

I have this code in my model, but then using eloquent if I add a with('parent') the query stops working. Important side note this is not my code. public function parent() { return $this->belongsTo(Category::class, 'category_id', 'id'); } function scopeName($query, $request) { if ($request['query'] && $request["query"][&q

eggplantSword's avatar
eggplantSword's avatar orestLaravel
2

500 (Internal Server Error) on Laravel ajax request localhost

I am facing 500 (internal server error) on laravel ajax request when sending ajax request to get pagination data on localhost. I have added in head section and in ajax script headers: {'X-CSRF-Token': $('meta[name="csrf-token"]').attr('content')}, also tested with token data: { "_token": $('meta[name="csrf-token"]').attr('content'), }, $.ajaxSetup

sajjadali's avatar
sajjadali's avatar Sergiu17Laravel
1

I keep getting this error"Uncaught TypeError: $(...).jscroll is not a function"

I am trying to implement infinite scroll with my posts in the social network website i am working on, but I keep getting this error in console "Uncaught TypeError: $(...).jscroll is not a function" my view <div id="post-result"> @if($post_num!=0) <br> <div class="scrolling-pagination"> @

mohamadAbdelhady's avatar
mohamadAbdelhady's avatar mohamadAbd...Laravel
0

Datatable acting funny on Forge but not on local dev environment

I have a data-table that works perfectly on my local dev environment. It filters through a paginated set of 11k records when user selects a filter type. But when I load the exact same code on Forge Servers, 4 core with 8G memory, the data-table rows do not show in the list. Every time they don't show records I see the pagination total counts correctly and the pagination button

suaveone's avatar
suaveone's avatar SnapeyForge
1

Same Paginate but twice in the view

Hi guys. I'm facing this tiny issue when I'm using livewire pagination and render it in both table position (top and botton) like {{ $connections->links() }} <table> //..... </table> {{ $connections->links()}} That's working, but on every re-render (I have a group of filters for datagrid's search) the top links() don't updated well as the bottom. I also have

prospero's avatar
prospero's avatar prosperoLivewire
1

Override getCountForPagination method

Good morning. I'd like to override in Laravel 8.x this method. Does anyone can give advise how we can do it in the good tradition on application level? Please do not suggest me to use patches. I looking for some way like plugins and preferences in magento 2. Thanks! public function getCountForPagination($columns = ['*']) { $results = $this->runPaginationCountQuer

BigSpender's avatar
BigSpender's avatar larateamLaravel
3

n+1 query results

Hi - I'm getting n+1 warnings when I run a query using a 'with' condition. Here's the model: class Ensemblemember extends Model { use HasFactory, SoftDeletes; protected $fillable = ['ensemble_id', 'instrumentation_id', 'schoolyear_id', 'teacher_user_id', 'user_id', ]; public function person() { return $this->belongsTo(Person::class, 'user_id', 'user

Rretzko's avatar
Rretzko's avatar RretzkoLaravel
9

custom Relation : matching Collection after addEagerConstraints()

I have 3 Models: Post, User, Comment They are linked to each others like this: Post.php Model has a trait with this: public function commentators(): CommentatorsRelation { /** @var \App\Contracts\CommentableInterface $this */ return new CommentatorsRelation($this); } User.php Model has a trait with this : public function commentatorComments(): H

pmusa's avatar
pmusa's avatar travelwebEloquent
4

vue unexpected reactivity

I just noticed an unexpected behaviour and now I don't know if it is normal or not. I have a component named follows and a child component named follow-list-modal I'm passing a followList (pagination ) from follows to its child component follow-list-modal In the follow-list-modal I store the paginated array in the variable members Follows.vue <template> <div>

orest's avatar
orest's avatar pweilVue
1

Paginate many to many relationship

Hello!. My trouble came to display all data of the pivot table with pagination in a many to many relation, in this case the pagination is not shown, no page anything, the pagination does not come out and all the records come out at once. I am somewhat new to laravel and although I have searched a lot I have not found an answer that has served me. On the other hand, with a livew

RodrigoG's avatar
RodrigoG's avatar RodrigoGLaravel
2

How Can I paginate while the deep relationships?

I have a This $page Object that has inside news attribute taken while relationship and setted as $page attribute . I want the pagination for this news but I can't set pagination for news because this returns me an error that news Is a type of array, how can I achieve this type of pagination without completely changing the $page object? or other suggestions. Project\Admin\Model

nativenova1's avatar
nativenova1's avatar ideepeshLaravel
1

Create Collection for PHP IMAP

Hello Team. I can receive emails with attachments and inline images. That works great. But i like create a collection, before render the emails. To get all the emails i use this: $this->mails = imap_sort($this->connection, SORTDATE, 1,SE_UID); This give me a array of all the emails with the UID. Then i can collect this, for create collection. $this->mails = collect($t

david19's avatar
david19's avatar david19PHP
0

How to Paginate with Laravel 8, Vue 3 and bootstrap 5 combination app

Hello, I want Nice Pagination with the latest Laravel 8, Vue 3 with axios and bootstrap 5. Would anyone help me with examples please? Is it good to use jquery datatable with it? Or we can do better with vue 3 and laravel 8? Has someone used this combination for pagination. Please help me out. Thanks. Regards,

bhojkamal's avatar
bhojkamal's avatar bhojkamalVue
0

livewire: $page overloaded and it affect queryString.

hi.. I have to use two components which use WithPagination ..something like modal pagination on pagination page. But one '$page' variable ( on modal ) affect the url which are exposed by another '$page' variable ( on Basic Page ) .. I guess I have to change variable name of '$page' of Modal layer. How can I do it ?

binggle's avatar
binggle's avatar binggleLivewire
1

LiveWire in use Alpine JS x-data = {show : false} value Treatment plan

Hi, Curious questions from novice front-end developer. LiveWire in use Alpine JS : x-data = {show : false} value @click= show = true, and even after changing the pagination, it remains show=true, making it a model show. Is there a way to initialize the script variable when the page changes?

NOHHANGYEOL's avatar
NOHHANGYEOL's avatar NOHHANGYEO...Livewire
1

Back relationship

Hello! In Blade, I need to display the rooms and the names of user who own the rooms + pagination. The rooms are displayed very well, but I do not know how to display related name of user near. i. imgur. com/mOVGuJk. png

georgewashington's avatar
georgewashington's avatar georgewash...Eloquent
2

Disappearing url query string

I am using laravel 8 , livewire 2.4 I used livewire pagination. My situation is like this. The 'page' variable is sent to 'show' page from 'index' page. After clicking in 'index' page with 'page' variable, it goes to 'show' page with 'page' variable. But in the 'show' page, the 'page' query-string is disappeared. I made video, you can see what happens. https://streamable.com/

binggle's avatar
binggle's avatar buzzwordli...General
5

How to store state while paginating through results - Laravel Inertia Vue

Is it possible to store the state of the select all checkbox or individual row checkbox while paginating through the results? As the props are passed on to the frontend through Inertia my paginator is requesting the pagination data and urls of the pages to paginate, from my props and then through Inertia link, navigating between the urls, it just seems to be like an spa, but i

ToxifiedM's avatar
ToxifiedM's avatar nemorightInertia
5

A better way to refactor below code

I am using Laravel scout, pagination, and custom filter in the below code. However, I think it is possible to clean up this. Please suggest a recommended way to refactor. public function index(Request $request) { $role = $request->input('role'); $keyword = $request->input('search'); $per_page = (int) $request->input('per_page') ?? 15;

noob_rider's avatar
noob_rider's avatar noob_riderLaravel
4

Converting a SQL query to Eloquent

hi guys, I have an SQL query that works just fine but it has a problem, here is the query: $products = DB::connection('mysql2') ->select(DB::raw(" select p.ID as id, p.post_title as title, p.post_name as url, max(case when m.meta_key = 'preview' then m.meta_value end) as preview, max(case when m.meta_key = '_thumbnail_id' then m.meta_value end) as

mozex's avatar
mozex's avatar mozexEloquent
2

Method Illuminate\Database\Eloquent\Collection::links does not exist

I implemented laravel scout(aglolia) for search indexing for my posts. So in my index I have something like below: <div class="col-md-8"> @forelse($threads as $thread) <div class="card mb-3"> <div class="card-header"> <div class="level">

CookieMonster's avatar
CookieMonster's avatar neilsteeLaravel
10

Scheduled Task not Running as Expected

Greetings, I am using the Adldap2-Laravel package and running the Import command nightly via a scheduled task. The Import command can be found here: https://adldap2.github.io/Adldap2-Laravel/#/auth/importing Because of LDAP pagination and available system resources I have to split up my imports as the staff import has 6,500 users but the student import has almost 40,000. To d

requincreative's avatar
requincreative's avatar requincrea...Laravel
2

Laravel Eloquent sorting through parent-child relationship

I have two models: User and Department Department hasMany User User belongsTo Department I want to sort the users based on department name with pagination. But results are still not sorted. $sortType = request("sortType") ?? "asc"; $users = User::with(["department" => function ($query) use ($sortType) { $query->orderBy("name&q

syntaxerron's avatar
syntaxerron's avatar erronEloquent
2

How can I update Laravel session data using Inertia Vue?

I have recently migrated from Laravel Livewire to Laravel Inertia Vue. During the course while using Livewire, I created a trait called WithPerPagePagination then created a public variable of perPage with the default value of 10 and mounted the value to the session $this->perPage = session()->get('perPage', $this->perPage);. Then with the help of lifecycle hook, create

ToxifiedM's avatar
ToxifiedM's avatar ToxifiedMInertia
0

Integrate livewire into a project

I’m new into livewire, i saw some videos of it i decided to give a chance, but i have some doubts. First I’m going to replace the tables with laravel pagination that i have, with livewire table with live pagination. How can i call the data that my controller send to the views? Can i call the laravel controller from the livewire component? All the examples that i see online say

PeytonBirch's avatar
PeytonBirch's avatar MugelCrinc...Laravel
3

Unable to update per page count from the frontend (Laravel, InertiaJS, VueJS)

I am migrating my current application from Laravel Livewire to Laravel InertiaJS VueJS. Currently I am stuck at setting the per page count from the front end and paginate the data accordingly. Currently I am using Laravel's default pagination along with the custom pagination component for VueJS and it works seamlessly. I just want to set the $per_page as per the input, the vari

ToxifiedM's avatar
ToxifiedM's avatar ToxifiedMInertia
5

The problem of inconsistency Datatable in Laravel

In Laravel I use the datatable plugin for my tables. For the users view section, because I wanted the administrator to be able to see brief information about that user by clicking on a button on the same page. I used livewire, which by clicking on that button opens a modal with information from that user. But there is a problem, after the modal is opened, the table as a whole b

UsmanBasharmal's avatar
UsmanBasharmal's avatar MichalOrav...Livewire
2

problem with Datatable in laravel

In Laravel I use the datatable plugin for my tables. For the users view section, because I wanted the administrator to be able to see brief information about that user by clicking on a button on the same page. I used livewire, which by clicking on that button opens a modal with information from that user. But there is a problem, after the modal is opened, the table as a whole b

mDelshad's avatar
mDelshad's avatar mDelshadLaravel
4

How to call data from two different model in a view

I have post reported page in admin dashboard. Trying to make a page where all reported post will be listed. This is a forum project so thread, comment and reply can be reported. I have two model, Thread and Comment (for comments and replies). Here I want to display latest 10 post from thread and comment reported in a single page. Currently I have this function and do not get ho

webfuelcode's avatar
webfuelcode's avatar webfuelcod...Laravel
2

'database' notification paginate ?

I am struggling with 'notifications' . I want to use notification pagination in livewire component. class RightMenu extends Component { use WithPagination; public function render() { $notifications = Auth::user()->notifications->paginate(); } } It cause error . livewire Illuminate\Notifications\DatabaseNotificationCollection::paginate does not ex

binggle's avatar
binggle's avatar binggleLaravel
4

How to implement Bootstrap DataTable in Livewire?

Hi guys, I'm done in my modal CRUD. I want to use Bootstrap DataTable in projects since it's complete from pagination, search and sorting so I download the bootstrap data table and include in my resources.. I merge the css/js in webpack.mix. When I tried to use it in app.blade.ph $(document).ready(function() { $('#contactTable').DataTable(); } ); I got this error run_c

anonymouse703's avatar
anonymouse703's avatar anonymouse...Livewire
5

How to get SUM from sum of relational field

i have two models Sell and Slip where: class Slip extends Model { protected $guarded = []; protected $dates = ['bill_date']; public function orders() { return $this->hasMany(Sell::class); } } class Sell extends Model { protected $guarded = []; function product() { return $this->belongsTo('App\Product'); } functi

shoaibsharif's avatar
shoaibsharif's avatar jlrdwEloquent
8

Stay on same page while reload the page

Hello Ariisan, I have a long list of users viewing UI. I have use eloquent pagination for viewing each block 8 users. Problem is that, while I click on 'load more' it fetch 4 records then If i visit any users and return BACK by browser PREVIOUS BUTTOn , it does not stay on same position. It return to first page withou loading previous data. Can you suggest me any solutions?

md_imran's avatar
md_imran's avatar martinbeanEloquent
5

inertia link error

hello it's not exactly related to vue but more to inertia i'm using vue 3 for this this is my page <template> <div class="bg-white rounded-md shadow overflow-x-auto"> <table class="w-full whitespace-nowrap"> <tr class="text-left font-bold"> <th class="px-6 pt-6 pb-4">Ac

Rymercyble's avatar
Rymercyble's avatar piljac1Vue
2

Understanding this code snippet, debug a $query

I have the task of debugging some code that isn't mine and quite frankly I have no clue what is happening in this code. The situation is that this code works for everyone else except a specific provider and I don't know why, and I need to find out what is happening. This is the method in my controller public function postData(Request $request) { $query = Product::qu

eggplantSword's avatar
eggplantSword's avatar msslgomezCode Review
2

Search Table

Hello guys, I am reaching out for some best practice. So I have basically a usertable where user data (mail, password, timestamps, etc.) is stored. In the app I have some community functionality where you can search this exact table by zip-code, gender, name , etc. and even by some relations data. I somehow have the feeling this is not best practice. I have not really bad exper

ChristophAust's avatar
ChristophAust's avatar ChristophA...Laravel
14

Accessing php classes in vue

I'm working on a laravel vue project where i make a get request to a 3rd party API to get all orders of a company The api has a limit of 100 orders per get request and they require you to use offset to get the next 100 Therefore i want to use pagination but this is new for me, so i'm not sure how to go about this Currently i'm making a get request in my php Client class and I'm

Jackvdb's avatar
Jackvdb's avatar tykusVue
3

-1 0 1 ErrorException Undefined property: Livewire\CompilerEngineForIgnition::$files

C:\xampp\htdocs\mic\vendor\livewire\livewire\src\CompilerEngineForIgnition.php:17 When using Pagination this error occurs my Component `<?php namespace App\Http\Livewire; use Livewire\Component; use Livewire\WithPagination; use Modules\LedGen\Entities\Ps4tekAttendence; class Attend extends Component

samehdev's avatar
samehdev's avatar samehdevLivewire
0

wire:loading for scroll.

I am using pagination to show content on scroll. I am using livewire and while fetching the content I want to show loading on the frontend. I tried <div wire:loading wire:target='fetch'> 'Getting content ...' </div> But it does not work. I am calling fetch function with an event. <script> window.addEventListener('load', ()=>{ if(isinscrollview(document

adityar15's avatar
adityar15's avatar adityar15Laravel
0

Delete edit row and display image in Boostrap-vue Datable

Hi, im looking how to delete and Edita row in Boostrap-vue Datable this is my Controller // edit post public function edit($id) { $produit = Produits::find($id); return response()->json($produit); } // update post public function update($id, Request $request) { $produit = Produits::find($id); $produit->update($requ

Rod2rick's avatar
Rod2rick's avatar Rod2rickVue
1

How to paginate data from a 3rd party api

I am working on a project where i get data from mediastack api, it is a news api. when i fetch data from api it gives a json format with pagination object and data array containing different objects. By default the api limit is set to 25, means it only show 25 result with pagination object. now how can i paginate the data help me json snippet "pagination": { "lim

hasnain_nisan's avatar
hasnain_nisan's avatar jlrdwLaravel
6