Report Help

Hello, This is a function for inquiry report in my software. public function inquiryReports(Request $request) { $templateData['inquiries'] = []; $helpTab = new HelpTabApi(); $templateData['help_tab_content'] = $helpTab->getHelpTabContent('report_inq_tab'); $templateData['params'] = $request->except(['_token', '_method', 'submit']); $templateData['status'] = $request->s

sartis's avatar
sartis's avatar LaryAILaravel
1

How to incorporate Eloquent API resource with Spatie QueryBuilder

In reading through the QB docs and other blog posts, I see references to using Eloquent API resources, but they are just a reference with no details. What I am trying to understand is how to use a collection for the primary model being returned, not just for a relationship inside that resource. For instance, here is a query that returns a model called WorkHours: return Inertia

wonder95's avatar
wonder95's avatar wonder95Laravel
2

How to get flterd data by time?

Hi, fellas. I have a very big table with meteo data, and want to query rows between some dates, not all, but, for example, for every 1 hour period and with pagination. So now i have all raws by $data = MeteoHistory::whereDevice($id) ->where('created_at', '<=', $end_date) ->where('created_at', '>=', $start_date) ->whereIn('dataType', $i

nsdonner's avatar
nsdonner's avatar nsdonnerEloquent
0

Paginating an API response in Livewire

I have an API endpoint that returns a LengthAwarePaginator result (so it simply paginates it's results). I'm querying this API from a Livewire component and would like to set up pagination for displaying the results as well. What would be the recommended approach to use the API response and turn it into a LengthAwarePaginator object as well? I only used it before with database

peterhrobar's avatar
peterhrobar's avatar peterhroba...Livewire
1

How to use visit() and see() methods during testing

Hi, I am trying to test page navigation by using $this->visit("/") and see("/?page=2") method. I want to ensure the following is correct: On the first page of results, there is a link to page 2 On the second page of results, there is a link to page 1, but that link must not include the parameter page=1 (this test will fail) on the homePage('/') there is

pshitote's avatar
pshitote's avatar pshitoteLaravel
0

API with JSON response: how to paginate when using Model query builder

I am writing an API and have a bit of a problem. I want to filter the model based on provided data, but i'm a bit lost on how to utilize the ResourceCollection properly, since I also want to paginate (dynamic options, not fixed). This is the URL that's being called: v1/configuration/companies?sort=&direction=asc&page=1&length=1&filter[full_name]=test So as you c

depalmo's avatar
depalmo's avatar LaryAILaravel
1

Which javascript framework or library to choose for Laravel in this scenario?

I want to do pagination without refreshing the page. What libraries or framework should I choose? I know that this should possible with advanced frameworks such as VueJS or ReactJS. There's a lot of information out there on updating without refreshing the page. However, pagination makes this issue a bit more challenging. My requirements are as follows: I want to stay as close

eventlistener's avatar
eventlistener's avatar m7vm7vJavaScript
4

Got Undefined variable $elements error when using Laravel Paginate Route package

Hi, I'm currently trying to prettify laravel pagination url using Laravel Paginate Route by @MichalOravec. It's an awesome package, but when I try to use custom paginate view, i got Undefined variable $elements error. This is how my controller looks like: public function index() { $limit = 1; $datas = Models::latest()->simplePaginate($limit); $cou

VTrace's avatar
VTrace's avatar VTraceLaravel
2

addEventListener is not working

I am working with ckeditor. I am using below code. addEventListener is not working here. function imageSelect(evt) { alert('hello'); } CKEDITOR.on( 'dialogDefinition', function( ev ) { var dialogName = ev.data.name; var dialogDefinition = ev.data.definition; if ( dialogName == 'image' ) { dialogDefinition.addContents({ id : 'uploadTab',

afoysal's avatar
afoysal's avatar LaryAIJavaScript
1

Getting extra checkbox while rendering Livewire component

I have a MSSQL database, where I will have a lot of products data. I have to list products on the basis of a column name GroupID. products are from different sources, so each source has an id ( sourceID ) so if 2 sources have same products, there are two rows of that product in the table ( don't ask me why, I cannot change DB, I am only allowed to read it and list the products.

eaglehdr's avatar
eaglehdr's avatar eaglehdrLivewire
3

"Error: Maximum call stack size exceeded". Any help please?

Hi, I have a SPA CRUD by Laravel+Vue 3+Inertia for managing categories in a blog admin panel. and by using modal windows, all 4 operations happen inside one page. After I add Update modal I got this error: Uncaught (in promise) RangeError: Maximum call stack size exceeded My code: (look at Update section) <script setup> import { ref, watch } from 'vue'; import BreezeButt

suddy's avatar
suddy's avatar LaryAIVue
1

Using paginate onEachSide with Breeze/Vue

Using Breeze/Vue with Inertia, I'd like to use the paginator onEachSide() feature, but it doesn't seem to work. In the docs, it looks like this may be used in the view file, but now the view is a vue file and the pagination links are passed in as props. I tried it in the controller, like: paginate(10)->onEachSide(3) but that doesn't seem to do anything. Has anyone dealt w

Max100's avatar
Max100's avatar Max100Laravel
4

Get All Categories

i have 10k products and each one have multi categories recorded in database and when user enter to category i want to add option to make user able to filter product by categories the problem is i have to use pagination of course to mange this amount of records so i cant get product categories by relation so what is the best solution

CrastyCrap's avatar
CrastyCrap's avatar CrastyCrapLaravel
8

Nested Persistant Layouts in Vue / Inertia

How can I have nested layouts in Vue / Inertia? I have a Persistent layout file that is defined in my app.js file like so: import './bootstrap'; import '../css/app.css'; import {createApp, h} from 'vue'; import {createInertiaApp, Link} from '@inertiajs/vue3'; import {resolvePageComponent} from 'laravel-vite-plugin/inertia-helpers'; import {ZiggyVue} from '../../vendor/tightenc

CamKem's avatar
CamKem's avatar CamKemVue
3

how to deal with ajax search in laravel

like users table now i want to do ajax search but the problem is pagination if i send pagination like return response()->json([ "result" => view( 'dashboard.withdraw-history.search-results', compact('withdrawHistories') )->render(), "pagination" => $withdrawHistories->links

ShamiCanCode's avatar
ShamiCanCode's avatar jlrdwLaravel
3

Javascript DOM

Hello folks, please help me. I was stucking the whole day. Thank you for your kindness. Question is!. After adding laravel livewire pagination, my javascript DOM :last-child gives me null. Why? const lastCard = document.querySelector('.parent); it's working. const lastCard = document.querySelector('.parent:last-child); give me null

shaungbhone's avatar
shaungbhone's avatar LaryAIJavaScript
1

How to Paginate an Array in Livewire?

Hey guys I have an array of products which are fetched dynamically and displayed in a table format, How can I add pagination to the array?

ap1234's avatar
ap1234's avatar SnapeyLivewire
8

Paginate not working while returning resource collection. What I'm doing wrong?

Hi, I'm trying to return resource collection. Pagination works in this case $journalQuery = new JournalQuery($validated); $transactions = $journalQuery->paginate(); but not in this (there is no meta in result): $journalQuery = new JournalQuery($validated); $transactions = JournalResource::collection($journalQuery->paginate()); According to docs, that should work. What's

kvads's avatar
kvads's avatar shariffEloquent
3

Help remapping an array / collection

Hello, I have an array that is like this: array:8 [▼ // routes/web.php:57 1 => "https://demo.test/users?page=1" 2 => "https://demo.test/users?page=2" 3 => "https://demo.test/users?page=3" 4 => "https://demo.test/users?page=4" 5 => "https://demo.test/users?page=5" 6 => "https://demo.test/users?p

CamKem's avatar
CamKem's avatar MaverickCh...Vue
5

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

I have a blade page with this code: {{$post->user_id ? $post->user->name : 'no name'}} This is my route in web.php Route::get('authors/{author:name}',function(User $author){ return view('admin.posts.index',['posts'=>$author->posts]); })->name('authors'); This is my controller: public function index() { $posts = Post::with(['categories', 'user', 'photo'])

IN2SITES's avatar
IN2SITES's avatar tykusLaravel
4

Vite with datatables.net is Missing CSS

I am trying to learn how to use VIte. I have installed datatables.net. The Javascript controls, including pagination and sorting appear to be working, but I am not getting any CSS with it. This is my App.js import './bootstrap'; import $ from "jquery"; window.$ = $ import DataTable from 'datatables.net'; window.DataTable = DataTable; This is my app.css: @tailwind

phayes0289's avatar
phayes0289's avatar LaryAIVite
1

Retrieving Data from Laravel API with Metronic 8

Hello, I'm using the Metronic Vue template and I'm trying to retrieve data from a Laravel API with server-side pagination, using KTDataTable with Vue and TypeScript. However, I'm not sure how to go about it. Can someone please guide me on how to accomplish this? Any helpful tips or code snippets would be greatly appreciated. Thank you in advance!

bassemshoukry's avatar
bassemshoukry's avatar LaryAIJavaScript
1

can I send meta data without using eloquent resources ?

Hello , I am trying to make pagination for the table , but I don't know how to pass meta data because I didn't use eloquent api resources public function index() { $users=User::has('learner') ->with('learner') ->orderBy('id') ->filter(request()->only('search')) ->paginate() ->withQueryString(); r

demonz's avatar
demonz's avatar David69Laravel
3

multiple where query

Hi, I'm new to laravel and have only been programming for 6 months. I've been able to make some great progress thanks to Laracast but I've run into an issue that I can not seem to resolve. So I'm hoping one of you can tell me why this is not returning the expected result Within my livewire dashboard class I'm calling the FilterAds method in my Ad Model. This method filters the

rfb's avatar
rfb's avatar rfbLaravel
19

Multiple resource collection at once

Hiho :) I have some of CollectionResources with pagination: class PageCollectionResource extends ResourceCollection { public function __construct($resource) { $this->resource = DB::table('pages')->paginate(); } } class BarCollectionResource extends ResourceCollection { public function __construct($resource) { $this->resource = DB::table('bars')->paginate()

maximos's avatar
maximos's avatar project1Laravel
7

Getting syntax error with paginate and table join

I have a scope for my Contact model that takes an array of filters. A contact belongs to an organisation and the scope works fine except when I use it with pagination. For brevity purposes, I won't show the whole scope but the part that breaks the pagination is the following (which is essentially used to filter to contacts that are a part of an organisation with given tags): -&

matthewknill's avatar
matthewknill's avatar matthewkni...Laravel
3

Return the user to the previous page

Hello! Need help. There is a list of records with pagination. URL: /admin/reviews Post editing form is on a separate page: /admin/reviews/45/edit When saving changes to the record, I would like to return the user to the previous page, given the page number of the page navigation on which the user was. Those. for example, if the user went to edit the post from the page admin/rev

mikola_systems's avatar
mikola_systems's avatar vicodevelo...Livewire
9

Multiple query on one instance

Hello guys! In my case , I need to return this data from model : 1- list of pagination users 2- count all users 3- count active users 4- count inactive users my query looks like: $userModel = User::query(); return Inertia::render('Home', [ 'users' => $userModel->paginate(), // list of users 'total_users' => $userModel->count(), // 10 'active_users' => $userMo

karrar's avatar
karrar's avatar pkboomLaravel
6

Error in paginator link, caused by /livewire/message/services-all?page=2

Hi, everyone! My project uses Laravel + livewire. I'm trying to use paginator with the Livewire component. The problem is the following, when the page is loaded for the first time, the mount() function is executed, and the paginator works fine, i.e. /user/service/?page=2. If you start switching between services (click on the tabs), the paginator doesn't work. It replaces all l

SolomonRei's avatar
SolomonRei's avatar danichangtLaravel
4

How to paginate over two models' search results

I have two models: one for products the other one is for collections (collection of products) I want to make a search on both of them after the search completes, I concatenate the result to a single variable called items to be displayed in the view by foreach statement I have a problem with pagination as it's not supported for laravel collections I'm using livewire component $

Ahmed Alaa's avatar
Ahmed Alaa's avatar PovilasKor...Livewire
5

Paging url rewrite

Hello everyone I would like to modify the pagination urls of my website by replacing the urls of this type tags/toto?page=2 to tags/toto/2 I am currently working on modifying a RouteServiceProvider with this code: $urlwithoutparams = request()->path(); redirect($urlwithoutparams.'/'.request()->input('page'), 301)->send(); exit(); Fin

leknoppix's avatar
leknoppix's avatar leknoppixLaravel
2

How to paginate eloquent related model data

Hello, I am trying to paginate the results for some data that shown in one of my views. My route look like this Route::get('posts/{post:slug}', function (Post $post) { $post->load(['comments' => fn($query) => $query->latest()]); return view('post', [ 'post' => $post ]); }); This is my method on my model class public function comments()

CamKem's avatar
CamKem's avatar SinnbeckEloquent
3

Get first, paginate later

Is there a way to get all the data first and paginate after? I need all the categories' names and ids to show in a select box, but in the same page I have a table that contains the same categories and I don't want that table to be too crowded -- therefore, paginate. So in a nutshell : select option should have all the data but table needs to be paginated. I don't want to use 2

motinska94's avatar
motinska94's avatar motinska94Eloquent
2

Paginating an existing table with Livewire

I have a plain HTML table being rendered with the results of an Eloquent query. // controller $this->tableData['headers'] = $tableHeaders; $this->tableData['rows'] = $query->get(); (classes, attributes and other removed for readability) <!-- view --> <table> <thead> <tr> @foreach( $tableData['headers'] as $val )

RileyGWeb's avatar
RileyGWeb's avatar Coaster132Livewire
5

Undefined method in web.php

I want to add a search bar to my application. Here's the logic I am trying to implement in my code: (My first time doing a search bar) Route::any ( '/search', function () { $q = Input::get('q'); if($q != ""){ $competition = Competition::where ( 'name', 'LIKE', '%' . $q . '%' )->orWhere ( 'email', 'LIKE', '%' . $q . '%' )->paginate (5)->setPath ( '

Yorkata's avatar
Yorkata's avatar SinnbeckLaravel
3

How to make param dynamic in paginate function?

In Builder.php the paginate function contains four parameters. public function paginate($perPage = 15, $columns = ['*'], $pageName = 'page', $page = null) First is the number of items per page, second is the number of the returned rows, third is the name of the pagination pages and the last one is the number of the page. My question is how to make the $page dynamic.

Yorkata's avatar
Yorkata's avatar YorkataLaravel
10

Count() a has many table without loading the data.

I want to do an @if that would check if a thread has more then 10 messages. however I don't want to load all messages (it might be a ton), I'm using my own pagination as I want to get infinate pagination (through livewire). Is there a way to accomplish this simple if check without loading all messages? @if (count($channel->message) >= 10) &

Dave Wize's avatar
Dave Wize's avatar Dave WizeEloquent
2

using paginate with eager loading on a relation with group

This is weird ;-) I have a search like this: \App\Models\Books::with('Reads')->paginate(15)->withQueryString(); I have the Model Books with the relations "Reads" as this: public function Reads() { return $this->hasMany(Reads::class, 'book_id', 'id') ->groupBy('field'); } The problem is that the groupBy is "affecting" the "with"

skater's avatar
skater's avatar jlrdwLaravel
11

Is it possible to start rendering page content while data is being fetched in the background?

I probably misunderstood the question, so I'll try to explain in more detail. I need to get two things: products from the catalog available product attributes It is elementary to get products from the catalog and if you use pagination, then very quickly. In order to get all the possible attributes of the products, more time is needed. The question is the following - can I pas

Rediska's avatar
Rediska's avatar SinnbeckEloquent
3

Load page in a div in swiper slider

Good afternoon Guys, I need help with my Swiper slider, I tried to load a project in a div but these project's are different but run in the same server , haw can I load each project in the same slide. I tied this but I get this error in the javascritp console Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at http://asiquoting.local.

Josadec's avatar
Josadec's avatar JosadecJavaScript
1

Returning UserAccount info with UserApp info, check if values are null

I have a two-part question. I am building a list of users that needs to pull information from a user and user_account table (with models of UserApp and UserAccount respectively). And then based on information from the UserAccount table I need to display the type of authentication method they are using (details below). I set up a one-to-one relationship on the UserApp model and

georgetown74's avatar
georgetown74's avatar georgetown...Laravel
7

How to remove double FROM when using raw queries?

I have some complex query which I need for pagination: SELECT ( SELECT COUNT(*) FROM table WHERE ... ) AS column1, SUM(CASE WHEN ... END) AS column2, column3, column4, column5 FROM table T WHERE ... GROUP BY ... And I need to paginate the result. But if I use it with eloquent or query builder RAW it adds antother from at the bottom: $data = Model::selectRaw('

Ligonsker's avatar
Ligonsker's avatar RooliganCode Review
1

I have worked with millions of records can please suggest regarding follows ?

which we use (Query Builder, ELoquent) Datatable , laravel pagination, or something else how to perform searching on table ? if something else usefull for maintain big data please share Thanks

tanveerkhanwd's avatar
tanveerkhanwd's avatar Tray2General
2

makeVisible() with paginate()

hello every one, i have a problem with using makeVisible() with paginate() functions in one query, i want to retrieve a hidden property with the makeVisible function, but when is use makeVisible(), the pagination details will be lose, for example: current_page, next_url_page, ... please suggest a solution for me. here is an example of my query: $questions = Quizes::paginate(20

shadkamel's avatar
shadkamel's avatar boogiefrom...Eloquent
5

Maatwebsite\Excel: impossible to download a file with 100 000 rows !

Hello I try to return an excel file of more than 100 000 rows but it seems not possible ; The sql request works very well and gives the results (with pagination) But when I try to use Maatwebsite\Excel it gives me : 502 Bad Gateway nginx errorLog: 2022/11/23 12:54:45 [error] 608722#608722: *60530 recv() failed (104: Connection reset by peer) while reading response header from u

GodziLaravel's avatar
GodziLaravel's avatar RooliganGeneral
1

Quiz App in Livewire

I am building a quiz app with each question on a page. I am thinking of using livewire with pagination one question per page but please is there any better way i can do it

TimiAde's avatar
TimiAde's avatar SinnbeckLivewire
2

Array Limit (500) To View Blade?

Just learning Laravel/PHP, and I have this set: variable $user_table with +500 records in array ---controller--- dd($user_table); return view('users', compact('user_table')); ---blade--- @dd($user_table) In Controller it is returning all records, In Blade View it only shows the first 500 records. Why? Not sure if its because Pagination, but I do not want to do anything with p

patrick1981's avatar
patrick1981's avatar SnapeyCode Review
16

Can I use get and paginate together?

I have a case where I want to get the the data then extract information from it, but also paginate it. In my case I want to pluck the id column from the query data Instead of just doing 2 queries (for the get and pagination, though not big deal)

Ligonsker's avatar
Ligonsker's avatar SinnbeckCode Review
7

Paginating data in nested foreach loop

I have a User model that has a hasMany relationship to Flight model, and I am showing the users with their flights on one page. I'm having a problem with how can I paginate the users and also paginate the flights that a user has. If we add pagination for each of the flights of the user isn't there a conflict in the URL because the system doesn't know which user flights to pagin

NoLAstNamE's avatar
NoLAstNamE's avatar SinnbeckLaravel
12

How to get records weekly -monthly -yearly by timestamps?

I need to get some information from the database to show on seperate weekly, monthly and yearly graphs. Is there a helper or a built-in eloquent tool to get them filtered by those formats? Like pagination, click a button to go previous week etc.

motinska94's avatar
motinska94's avatar farhankhan...Laravel
3