Facing performance issue while custom exporting 20M records

Community i am facing performance issue. let me tell you i am custom export data around 20M and it takes too much time like one or two day. in custom export i already job queue with pagination wise export data with per page around 10k records append and write data with same excel file. so guys, provide solution how to manage export 20 M records within particular time

soham-laravel-dev's avatar
soham-laravel-dev's avatar VladPtashn...Laravel
18

The Like/Dislike buttons disappear for all but the first recipe after changing the sort order. Livewire 3

Hello Problem description: In my RecipeList.php I am showing the list of recipes: @forelse($recipes as $recipe) <x-recipe-card :recipe="$recipe"/> @empty <p>error</p> @endforelse Inside <x-recipe-card :recipe="$recipe"/> I have another livewire component: <livewire:like-dislike :recipe="$recipe"/> Upon the

dmytroshved's avatar
dmytroshved's avatar SnapeyLivewire
2

refactor logic in an Eloquent Model with many relations to a Service Class

Hello Laracast community, I'm trying to refactor my Model Class into it's own Service Class to separate Logic from the Models and make the Controller easier to read and maintain. On top of that, I know that my controller sucks big time and needs a lot of improvement to make it more "eloquentish". No question about that. I'm having this relation in my ItemModel (beside

mkocurek's avatar
mkocurek's avatar martinbeanEloquent
7

Custom livewire datatable component is unable to send request when a row gets checked

I have tried to integrate custom livewire datatable into my project. When I check an item, it is not being marked with background color in real time. Moreover, I do not see the action button when an item is checked. It only works when I move to the next page with pagination link. I think my datatable livewire component is unable to send request when the item gets checked. (data

Prawin's avatar
Prawin's avatar PrawinLivewire
2

<Link> tag isnt working

Hi all I was redirected here from the vue forum, im following Lukes guide on building a forum from scratch on Episode 8 he use pagination and a Link instead of an a ive been looking through his github for discrepancies and mine but I can't find anything the page goes white when I try to use the Link template and I can't see anything when its the a it works fine any help would b

Corronica's avatar
Corronica's avatar CorronicaInertia
7

<Link> tag isn't working for me

Hello im following Lukes forum from scratch videos and 8th one he goes through pagination as well as using tailwind and heroicons for it. My issues is when I use the <Link> tag instead of the tag the entire posts page breaks and shows nothing but a white window im using vue with inertia i've tried to alter the app.js as others suggested on here and other sites but its st

Corronica's avatar
Corronica's avatar CorronicaVue
5

The dreaded The GET method is not supported for route ...

I'm working on this web app where I have a search field and some dropdown buttons with checkboxes and what nots. without doing anything, the app shows the items we have in the database in a table Based on what you do with the checkboxes, the number of items in the table gets fewer. Without doing anything, the pagination works nicely. But if I check a checkbox or write something

trondhuso's avatar
trondhuso's avatar trondhusoLivewire
4

Laravel 12.x w/ Livewire Starter Kit + Flux Question

I started a new project as something on the side for work and I noticed it has some decent amount of Flux components. But one I was hoping to use was Flux Pagination (https://fluxui.dev/components/pagination). It doesn't seem to be limited to the Pro tier (paying $300 would be worth it if I keep making Laravel projects though). So I'm wondering how do I get this component? Can

ctrlaltdelme's avatar
ctrlaltdelme's avatar jlrdwLaravel
7

Laravel 12 Vue inertia shadcn ssr datatable

Has anybody got working shadcn datatable with server-side rendering? I got pagination working but if I search then it doesnt update table but in network tab it is getting correctly data. <script setup lang="ts"> import { ref, watch, watchEffect, defineProps, computed } from 'vue' import { useVueTable, getCoreRowModel, getSortedRowModel, FlexRender, Sor

VeItix's avatar
VeItix's avatar VeItixVue
0

Best Way to Handle 1M+ Records in Laravel & Livewire?

Hello Laravel experts, I'm currently working on a Laravel + Livewire project that needs to display and manage over 9 million transaction records. 🔍 My Current Setup: Laravel 10 with Livewire MySQL (InnoDB) Transactions Table (~9 million rows) with indexing on id, created_at , etc ⚡ Performance Issues: Query execution is slow, even with pagination (->paginate(100)) Livewir

devaspid's avatar
devaspid's avatar JussiManni...Livewire
2

Shadcn-vue -> Can't add component

Exploring laravel 12 with vue starter kit. i start bump into something when i want to add component from shadcn-vue: laravel12 % npx shadcn-vue@latest add pagination An invalid components.json file was found at /Users/KerelKA/Website/laravel/laravel12. Before you can add components, you must create a valid components.json file by running the init command. Learn more at htt

kerelka's avatar
kerelka's avatar GabrielLac...Laravel
12

Add order_by to the lengthawarepaginator

What would be a elegant way of adding what the order_by and order_direction to the frontend, so it can be rendered in the front properly. Is there a way of adding that data to the length aware pagination meta. $order_by = $request->input('order_by', 'created_at') $order_direction = $request->input('order_direction', 'ASC'); return Inertia('Posts/Show', [ 'post

DynamoKat21's avatar
DynamoKat21's avatar LaryAILaravel
1

Code Review

Hello everybody, Just looking for guidance, suggestions and quality of life improvements for future developement. I'm creating an admin control panel for Spatie Laravel Permissions, using Flux UI Pro. With the below code I have crud functionality to add/edit/delete and view: users, roles and permissions. I've also implemented the logic so that if you can't "add permission&

PrinceMinky's avatar
PrinceMinky's avatar tykusCode Review
3

Handling Deletion on the Last Page in Paginated Resources using laravel, vue and inertia

Hey everyone! 👋 I wanted to share this solution for handling delete actions when removing the last item on a paginated page using the paginate() function of laravel. How It Works When meta.from becomes null (which happens when deleting all items on a page), this script automatically redirects to the previous page using the Inertia.js router. This ensures a smooth user experienc

Abderrahim_20_'s avatar
Abderrahim_20_'s avatar LaryAIVue
1

SyntaxError: "undefined" is not valid JSON

When i use inertia ssr, i cannot see my css and i get this error. what can i do to fix this ssr.ts // import "./bootstrap"; import "vue-skeletor/dist/vue-skeletor.css"; import "../css/NProgress.css"; import { createSSRApp, h } from "vue"; import type { DefineComponent } from "vue"; import { trail } from "momentum-trail&qu

azbx's avatar
azbx's avatar azbxInertia
24

Need help implementing Inertia V2's infinite scroll with React

So I was ecstatic when I heard about the new way to implement infinite scrolling with Inertia 2.0 and decided to give it a test, so I made a quick project following their docs and now I don't understand how to use The new <WhenVisible> component to load more "articles". This is the controller, implementing basic pagination and the new merge functionality: class

thetanaz's avatar
thetanaz's avatar deviceafra...Inertia
2

Issue with Preline DataTables and Livewire: Table Disappears When Data Is Updated Without wire:ignore

I’m working with Livewire and Preline DataTables in a Laravel project. I have a table that uses Preline DataTables to display data dynamically managed by Livewire. When I add new data (without using wire:ignore), the table data updates successfully, but the DataTable functionality (like sorting and pagination) disappears. If I add wire:ignore to the table, the DataTable functio

zikrimuhammad09's avatar
zikrimuhammad09's avatar zikrimuham...Livewire
1

Im getting the timeout issue while hitting the zoho apis

[2024-11-11 12:27:27] local.ERROR: cURL error 28: Failed to connect to www.zohoapis.com port 443 after 10002 ms: Timeout was reached (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://www.zohoapis.com/crm/v2/Contacts?per_page=200&page=3 {"userId":1,"exception":"[object] (Illuminate\Http\Client\ConnectionException(code: 0): cURL err

swamydeshetty's avatar
swamydeshetty's avatar swamydeshe...Laravel
0

Proper way to use ->when() condition for optional request parameter

I have a request that should use simplePagination only if paginate is 0 in the query. if paginate doesn't exist or is any other value the response should use classic pagination. How can I achieve this in the code below. Controller public function index(Request $request){ Post::pagination($request); } Post Model public function scopePagination($query, $request){ $qu

Devio's avatar
Devio's avatar DevioEloquent
13

Best Practices for Handling Large Datasets in Laravel

Hey everyone, I've been working on a Laravel project that requires handling large datasets (millions of records), and I've run into some performance issues, especially when it comes to querying and displaying data. I'm using Laravel 10 with MySQL. I've already implemented some optimizations like: Using chunk() instead of get() for large query results. Leveraging Eloquent eager

HilariousNeckbeard's avatar
HilariousNeckbeard's avatar HilariousN...General
0

Showing data from http request in laravel nova

Hi, I'm newbie in laravel nova (also in php at all) and I have an issue, I need to show resource for data, that is not stored in my DB, either it is stored is another server, that provided http route. Now, I want to know, where is query that is builded step by pagination, filters and etc is called and override this method, like: class MyClass extends Resource { .... pub

SunatSS's avatar
SunatSS's avatar diegodNova
1

Passing Data in Laravel with Inertia: Controller vs. API Calls in Vue Components – Which is Better Design?

Is it better design to pass data through a Laravel index method like this: public function index() { $events = Event::paginate(10); return Inertia::render('Event/Index', [ 'events' => $events, ]); } Or should the web EventController index method look like this: public function index() { return Inertia::render('Event/Index'); } and call the API from

james1232's avatar
james1232's avatar martinbeanInertia
5

Image gallery where images are stored on a remote SFTP

I have an app where only logged in users can view images. The files are stored on a remote server that is not exposed to public download, so they are downloaded using SFTP. The filenames are stored in a DB table, images. In an image CRUD, users filters on images and can get max 10 filenames at a time, for that I will let the user use various filtering, sorting and then I will u

muuucho's avatar
muuucho's avatar SnapeyDesign
4

None CRUD Operation While Using Resources Controllers

I'm currently working on a tasks application and aiming to keep my controllers as small and uniform as possible by primarily using resource controllers for my main models. I really appreciate the simplicity and structure they offer. However, I'm running into some challenges and was hoping to get some advice. One of my main concerns is how to handle assigning tasks and roles to

james1232's avatar
james1232's avatar MouteeGeneral
8

Illuminate\Pagination\LengthAwarePaginator::$username

Hi, I have a scorelist. I created a component for this. this is the code of my component: <?php namespace App\View\Components; use App\Models\User; use Closure; use Illuminate\Contracts\View\View; use Illuminate\Support\Facades\DB; use Illuminate\View\Component; class Scorelist extends Component { /** * Create a new component instance. */ public function

lukeboy_2002's avatar
lukeboy_2002's avatar JussiManni...Livewire
2

why paginate() show only next and previous with out page numbers

Hello friends my regular pagination method ->paginate() show only next and previus buttons without page number using laravel 11 + livewire 3 <?php namespace App\Livewire\Admin\Task; use Livewire\Component; use App\Traits\HasModal; use Livewire\WithPagination; class TaskIndex extends Component { use HasModal, WithPagination; #[Computed] public function t

Respect's avatar
Respect's avatar RespectLivewire
12

Carousel, Livewire & Search Input

Hello, I have the following code which should do the following: When the user searches on the input box, this should show up and filter the results. This works okay before adding the Carousel. The items are then added or removed from the carousel depending on the search and the categories. When adding the carousel code and updating the foreach array, this is throwing the foll

Unsociable's avatar
Unsociable's avatar UnsociableLivewire
1

Alpine JS x-data

When I have a lookup table I currently have a modal inside an object, that way I have full control and I can have a search and have pagination. All works just fine. And I use axios js to return the data. An example https://laracasts.com/discuss/channels/laravel/can-i-redirect-a-get-request-to-a-post-request-for-inertia-partial-reloads?page=1&replyId=905775 However, would al

jlrdw's avatar
jlrdw's avatar jlrdwJavaScript
6

Filtering posts by type, province, town and search term

Hello I'm making a project where I have a sub-header where you can apply filters for posts and this filters go to a grid parent component where the posts appear. Right now it's working what I have but I would like to know if i'm doing it well since now i'm trying to add Pagination and it's giving me a headache to add the Pagination with what I have already built. I just want to

ignaaaam's avatar
ignaaaam's avatar ignaaaamLivewire
1

Why isn't the reverse() working in this method?

I'm trying to reverse the messages so the newest one can be at the bottom, but I think either the pagination or something else is interferring : public function view(Request $request) { $userId = $request->user()->id; $conversations = Conversation::where(function ($query) use ($userId) { $query->where('participant1_id', $userId)

thetanaz's avatar
thetanaz's avatar thetanazEloquent
4

Updating elements in Interia

In my app I have a table of items and a button that says submit, when I press submit I thought Inertia would refresh the state in the background. Here is the Vue file: <template> <Head title="My nominations" /> <Container> <div class="max-w-6xl px-4 pt-6 lg:pt-10 pb-12 sm:px-6 lg:px-8 mx-auto"> <Breadcru

jesse_orange_newable's avatar
jesse_orange_newable's avatar LaryAIInertia
1

Best Practices for Returning Large Datasets in JSON with Eloquent

Hi Everyone, I'm working on an API endpoint that returns data from an Eloquent model, which contains around 400,000 records. While I've already implemented pagination, the requirement is to return the entire dataset in the JSON response when hitting the endpoint in Postman. Given the size of the dataset, what are some best practices or optimization techniques I can use to handl

FazBeni24's avatar
FazBeni24's avatar JussiManni...Laravel
3

Add a custom filter after paginate (or any other solution) ?

Hi everyone ! I'm using Laravel 11 with Inertia-Vue. I have invoices with payments attached. invoices |_ id |_ client_id |_ date |_ amount payments |_ id |_ invoice_id |_ is_settled |_ amount To check if an invoice is paid I have to add all settled payments and compare to the invoice amount. I made the accessor 'balance' for that. I can't store this status in the database be

Pierre_AIR's avatar
Pierre_AIR's avatar Pierre_AIRLaravel
3

Resetting Infinite Scroll Page upon return back on the page

Basically I have a page List/Show.vue that contains books that are in reading list of current user. I am utilizing pagination functionality in Laravel to send 10 books per page, and then they are rendered in frontend Vue component by scrolling. It all works fine regarding the infinite scroll functionality, the issue I am having is when I click on one of those books and the link

jasko's avatar
jasko's avatar jaskoInertia
2

Laravel interiajs and multiple paginators on same page?

I have some issue with couple paginations in one main component return Inertia::render('Company/Show', [ 'reviews' => fn () => CompanyReviewResource::collection($filterable->builder->paginate(5)), 'gallery' => fn () => GalleryResource::collection( $company->media()->where('collection_name', 'gallery')->paginate(5)

gidaban79's avatar
gidaban79's avatar LaryAIInertia
3

customize "data" attribute

Dear laravel artisans; is it possible to customize the data attribute laravel is wrapping around my resource? OrderCollection class OrderCollection extends ResourceCollection { public function toArray(Request $request): array { return [ 'a_custom_name' => $this->collection, ]; } //remove some links from pagination public function paginationInfor

t0berius's avatar
t0berius's avatar SnapeyLaravel
5

keep Resource order when adding datausing toArray()

Assume the following laravel code class OrderCollection extends ResourceCollection { public function toArray($request) { return [ 'data' => $this->collection->map(function ($order) { return new OrderResource($order); }), 'meta' => [ 'server' => "someserver", ] ]; } //remove some links from

t0berius's avatar
t0berius's avatar t0beriusLaravel
3

Call to undefined method App\\Models\\Order::mapInto() laravel API Resource

Assume my controller action: return OrderCollection::collection(Order::filter($filters)->paginate()); OrderCollection <?php namespace App\Http\Resources\Api\V1; use Illuminate\Http\Resources\Json\ResourceCollection; class OrderCollection extends ResourceCollection { public function paginationInformation($request, $paginated, $default) { $default['links']['c

t0berius's avatar
t0berius's avatar LaryAILaravel
1

Getting a yellow squiggly line and an error but my query works as expected

I have this controller method : public function showByCategory(Request $request, $categorySlug) { $category = Category::where('name', $categorySlug)->firstOrFail(); $listings = Listing::whereHas('item', function ($query) use ($category) { $query->whereHas('sub_category', function ($subQuery) use ($category) { $subQuery-

thetanaz's avatar
thetanaz's avatar thetanazEloquent
11

Laravel Excel skip and take not working

Hello everyone thank you for your time firstly, I was working with Laravel excel to export data from my database to excel, everything was going well but right now I am stuck on a small problem, I dont want the user to be able to export the entire table at once I want to allow him to export only 10-25-50-100 per time, and at the same time i have pagination so if the user is in p

WhisperingWolf's avatar
WhisperingWolf's avatar Whispering...Laravel
4

Add e.preventDefault() to generated JS

Hi all. New to livewire. Currently implementing the classic loading of a table data dynamically with pagination and all is going well except that when I click the page numbers, the page jumps up to the top before dynamically reloading the table. In the old days when I had to write JS, I would add the preventDefault() method to the top of the handler code to prevent that from ha

0RuiAlvel0's avatar
0RuiAlvel0's avatar 0RuiAlvel0Livewire
4

Livewire and AlpineJS modal load slowly

I have nested livewire components in foreach loop. Each nesting is an instance of AlpinJS modal from livewire screencasts. I'm using pagination with 25 items, and still while it loads all the nested components/modals is takes multiple seconds. And inside of each component there is another instance of AlpineJS modal, which makes it also slow. However, I'm coming from JQuery worl

valentin_vranic's avatar
valentin_vranic's avatar valentin_v...Livewire
6

inertiajs with vue website not visual in production in cPanel hosting

i've build using npm run build and host in cPanel but it shows my page location not found. here is my app.js file code import { createApp, h } from 'vue' import { Head, Link, createInertiaApp } from '@inertiajs/vue3' import Alink from './Shared/Alink.vue'; import ImageProcess from './Shared/ImageProcess.vue'; import Pagination from './Shared/Pagination.vue'; import {layout

blacknet's avatar
blacknet's avatar blacknetInertia
2

JetStream $request->user() Null.

I'm trying to access backend route for get data from a external API inside a Livewire component method. But inside the Laravel Controller method i can not access $request->user() or auth()->user() if i already logged in. Thus the route is a public one both logged in and not logged in users can access that. the difference is auth user have different params and guest users

Hasith's avatar
Hasith's avatar SnapeyLaravel
3

Paginating A Relationship

I need to paginate a relationship. Therefore, it is my understanding that I cannot use with. Therefore I do something like this: $post = Post::where('slug', $slug)->firstOrFail(); $post->comments()->cursorPaginate(10); I have a post API resource too which organises the comments relationship: public function toArray(Request $request): array { return [

panthro's avatar
panthro's avatar SnapeyLaravel
2

Help on Indentation in Nvim

I'm new to laravel and I use nvim to edit my stuff. lsp is working, using intellephense and phpactor alongside laravel.nvim. Only problem is the @ directives. They don't want to indent. Can someone help? Intended @if ($paginator->hasPages()) <nav> <ul class="pagination"> {{-- Previous Page Link --}} @if ($paginator-&g

Miryoku's avatar
Miryoku's avatar MiryokuTips
0

Does have any how or any script that I can transform my json into pest assertJsonStructure format ?

hello , I have been working with Pest , and sometimes I have to check ( assertJsonStructure ) of a list . and sometimes , this list have many items to check . I wold like to know if in laravel or Pest , it has any script that could transform that list , with json format , something from this - {"data":[{"id":"5687dd60-f0dd-46cc-a2f4-9f555c26d408"

murilo's avatar
murilo's avatar muriloLaravel
2

Laravel YarjaBox Datatables ajax

I have the laravel YarjaBox datatable ajax. Here is the controller code. if ($request->ajax()) { $query = Feedback::query(); // Apply search filter if ($request->has('search') && $request->search['value'] != '') { $search = $request->search['value']; $query->where(function ($q) use ($se

vidhyaprakash85's avatar
vidhyaprakash85's avatar vidhyaprak...Laravel
0

How to stop paginate() from jumping to the top of the page?

Hi, So I integrated pagination for my tables, but is there any simple way (without AJAX) to make clicking the next page of the table stop going to the top of the page? Route: Route::get('/beheerder', [UserController::class, 'showModPage'])->middleware('auth', 'IsVerified', 'MustBeAdmin'); Blade template: <table class="table table-striped table-bordered table-hov

Jdagger's avatar
Jdagger's avatar JdaggerLaravel
2

diference between load and with when paginate

hello , I have been working with laravel resource . I have this Resorce - class UserResorce extends JsonResource { /** * Transform the resource into an array. * * @return array<string, mixed> */ public function toArray(Request $request): array { return [ "email" => $this->email, "associat

murilo's avatar
murilo's avatar SnapeyLaravel
3