I am summing the columns from different tables each in a different database. Created the models for each of the 8 connections and added them to the controller. use AppModelsobjectMapping1; use AppModelsobjectMapping2; use AppModelsobjectMapping3; use AppModelsobjectMapping4; use AppModelsobjectMapping5; use AppModelsobjectMapping6;…
I have created a variable inside a controller whereby I want to put a href link inside the variable. everything works well but I want to add a download link for the to be able to view the link in…
I try to set up kakao login to my Shopify store, but when I run the test I encountered this message error, what should I do? Thank you
Stack: Laravel v8, MySQL. I working on a payroll system with Laravel. I want the value of some columns to update if another column it depends on changes. For example, if the Number of working days changes on the payrolls…
I'm trying to route directly to the route with ajax in Laravel, but I'm getting an error. I'm taking my first crack at Ajax with jQuery. I'm getting my data onto my page, but I'm having some trouble with the JSON data…
Im writing something to welcome.blade.php and want to use css to change the background but it doesnt works.(my css file is in the public folder)here is my blade.php codes; <html lang="en"> <head> <link rel="stylesheet" type="text/css" href="{{ asset('css/app.css') }}" > <meta…
$star = $request->input('start_date'). ' ' . '19:00:00'; $end = $request->input('end_date'). ' ' . '07:00:00'; $employee_qty_in_shift2 = PatrolGateSurveillanceTransaction::where('type', 1) ->where('client_location_id', $request->client_location_id) ->where('created_at', '>=', $star) ->where('created_at', '<=', $end) ->sum('employee_qty'); dd($employee_qty_in_shift2); The above code cannot filter data from 19:00:00 to 07:00:00 Expected result:…
How to display a loader after form submit in laravel, i am currently using css for this option...but its not working as expected. <button type="submit" id="submit" class="w-full px-3 py-3 font-medium text-white bg-green-400 rounded-lg">Request now</button>
I have two components : Page.vue Component.vue In my Laravel route I do return inertia('Page', [ 'foo' => Model::all()->map(...) ]); In Page I do: <template> <Component/> </template> <script setup> defineProps({ foo: Array }); </script> Would it be possible to access…
I have a table called services with multiple columns and one column named staff_assigned with this content: [{"user_id":"15549","price":"100"},{"user_id":"15548","price":"300"},{"user_id":"15552","price":"95"},{"user_id":"15553","price":"600"}] How can I find all services where user_id is 15548 with Laravel eloquent? Note that Service::where('staff_assign->user_id', "15548")->get(); doesn't work because column contains…