I have relation like this: DB relation I have a code in my model that retrieves me just one parent: public function AllParents() { return $this->belongsToMany($this, ‘parent’, ‘product_id’, ‘parent_id’) ->select(‘parent’, ‘name’); } I get it in my controller like this: private function product(Product $product) { return $product->Product() ->with(‘AllParents’) ->get(); } Finally I need data like ..
Category : eloquent
I’m implementing a database fetching where an orders table saves different product ids in a column. I wonder if this approach of storing all the products in a single column as an array is good enough or if I should implement an intermediate table storing order ids and products ids. Or if there is an ..
I have a page that displays all the records from the ‘Receita’ table like this: public function mostrarTodos() { $receitas = Receita::all()->toArray(); $ingredientes = Ingrediente::all()->toArray(); return view(‘home’, compact(‘receitas’, ‘ingredientes’)); } on the top of the page there is a form with many checkboxes that will filter the results displayed on the front page: <div class="col-span-2 ..
Kind of a backstory, I inherited a Laravel project that initially used migrations and Eloquent to handle schema changes on it’s database, but through the course of development the original developer decided it would be better to just ditch to migration workflow and directly make the changes to the schema via sql/ phpmyadmin and in ..
I’m seeding the test database with fake users, posts and categories but for some reason when I seed the database with more than 15 records Laravel throws this error: IlluminateDatabaseQueryException SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: categories.name (SQL: insert into "categories" ("name", "slug", "updated_at", "created_at") values (id, quibusdam-nihil-dignissimos-vitae-sint-minus-est-nostrum, 2021-06-22 17:52:02, 2021-06-22 17:52:02)) If ..
Each Product can have several Category On each product page, I need to display 10 "related products". To that end, I would like to create a function on the Product model, that would return other products that have the most Category in common, and that would go like so: public function related_products() { return Product::with(‘categories’)->whereHas(‘categories’,function($query) ..
Is there a way to write this query in Eloquent? select * from (select distinct source_id from csv_report) CR JOIN source SRC on CR.source_id = SRC.id; I don’t have the Models relations set up yet. Thanks. EDIT: Sorry if I didn’t ask the question correctly (because of the negative point). I figured the table details ..
I am trying to fetch a grouped By list of all my Summaries with the according Sum of the total field. To visualise it it would look something like this ID. Code. Total. Created_at. Updated_at 1 61B5A4C5 1437.64 2021-06-22 11:18:09 2021-06-22 11:18:09 2 A9B5311C 711.44 2021-06-22 11:19:10 2021-06-22 11:19:10 3 1426CDC5 711.44 2021-06-22 11:19:27 2021-06-22 ..
I am running into this issue where I can’t retrieve the softdeleted data of the relation tables. My approach was to use the withTrashed method, but it gave me no luck whatsoever. This is the line of code: return response()->json($user->orders()->withTrashed()->with(‘order_details’, ‘order_details.product’, ‘address’)->get()); It like ignores what’s inside the with clause. How do I fix this ..
I have simple hasOne relationship and fixed list of displayed columns. If to put columns on paginate method, outputed relation data will be null. $model->with([‘item:id,title’])->paginate(5); // item filled correctly $model->with([‘item:id,title’])->paginate(5, [‘id’,’name’]); // item will be null How to make it work together? Sourc..
I am working with Laravel 8 to develop online ordering project and in this project, I want to show all the orders from orders table if the status of each order is set to awaiting, so here is my code: public function awaiting() { $orders = Order::with(‘user’)->where(‘status’, ‘awaiting’)->whereHas(‘user’)->latest()->paginate(20); return view(‘admin.orders.awaiting’, compact(‘orders’)); } But now the ..
So, in my application I have models: user, category, service(i.e subcategory) and userService. There exists many to many relationship between user and category, user and service. And one to many between category and service. // Tables Users : id, name, email, password Categories : id, name Services : id, name, category_id user_services: id, user_id, category_id, ..
i have a problem, i need to add the debt of a user controller: public function cliente($id){ // $nota = AppNota::find($id); //Aquí valida si existe sino redirije al 404 $datos = [ ‘category_name’ => ‘datatable’, ‘page_name’ => ‘multiple_tables’, ‘registro’ => Registro::find($id), ]; $cliente = AppModelsUser::findOrFail($id); return view(‘cliente’, compact(‘cliente’))->with($datos); } blade.php <div class="row"> <div class="col"> <h4>Debt ..
I am trying to execute the following code, the error applies to the $waitingToBeShipped… section of the code. As you can see I am using an innerJoin. I want to retrieve all of the rows that have orders containing products that are still waiting to be shipped. public function destroyMany($ids) { $status = false; $ids ..
I have the following table structure as shown in the diagram: Briefly, it is composed of several many-to-many polymorphic relationships as described: many resources can have many sources and the pivot table sourceables contains catalog_number and lot_number information to make each row in the pivot table unique. Many resources could also come from the same ..
I have an app that has been coming under some performance pressure. Mainly due to fairly complex DB queries and frequency. I am making ajax calls to an endpoint which queries the DB and the ajax call fires every time a user updates a map position or changes a filter parameter. Each time filtering through ..
I am new to Laravel and trying to support an existing application that is in Laravel 5. I am trying to convert the following SQL to eloquent structure SELECT s.id, CONCAT(u.first_name, ‘ ‘, u.last_name) AS user_name, u.avatar_location AS user_img, s.employee_photo, d.name AS department, seg.name AS segment, s.survey_title, s.before_action, s.before_picture, s.action, s.action_date, s.after_action, s.after_picture, s.nominated, s.awarded, ..
Following query is ignoring the where(‘contact_id’,$id) causing to return results that does not belong to this contact. Why? Transaction::where(‘contact_id’,$id) ->with(‘allocations’) ->whereHas("allocations",function ($query){ $query->select(‘transaction_id’) ->havingRaw(‘transactions.amount > sum(amount)’) ->groupBy(‘transaction_id’); }) ->orDoesntHave("allocations") ->get(); if I remove the whereHas part, it is bringing back the correct result. But I need the whereHas part. ->whereHas("allocations",function ($query){ $query->select(‘transaction_id’) ->havingRaw(‘transactions.amount > sum(amount)’) ..
I have a litte problem inputting data from client to server, where the value does not match and has an error. I want to add data using a pivot table with attach but the value I get does not match I tried several ways but failed. What I want after creating the document data then ..
I am trying to fetch the most popular product of all my summaries. Preverable the name of the product that is the most common among all the summaries. I have a Summaries table and a products table with a pivot table in between. The relation is as follows: Product model public function summaries() { return ..
$data = User::where(‘inet_id’, "like", "%" . $inet . "%") ->orWhere(’email’, "like", "%" . $email . "%") ->orWhere(‘phone’, "like", "%" . $phone . "%") ->get(); It only executes the query when searching all 3 data once. But I want to search by separate data too. Sourc..
I’m developing an application for Pharmacy Company, Products have many Batches. When New Invoice Creation. They don’t enter the same product with the same batch number in the Invoice Item List. How to validate using laravel Rule. My Blade (Dynamic Row) : <tr class="item_row" id="item-row-0"> <td> <select class="form-control boxed" name="items[0][product_id]" id="product_id0" onchange="productattribute(0)" data-width="100%" required> <option ..
I have categories and product table. i want to show the categories which has at least 1 product Sourc..
I have two model named as Product and Category. In the products table i have category_id as as a foreign key of categories. Both table have title column. I want to search on both title and when it is related to categories table then all products of that category will come in result but when ..
Here’s my JSON: [ { "ID": 1, "SOURCEID": 1, "TIMESTAMP": "2020-04-05 07:05:29", "VALUE": "30" }, { "ID": 4, "SOURCEID": 2, "TIMESTAMP": "2020-04-05 07:05:17", "VALUE": "40" }, { "ID": 3, "SOURCEID": 1, "TIMESTAMP": "2020-04-06 12:04:59", "VALUE": "35" }, { "ID": 5, "SOURCEID": 1, "TIMESTAMP": "2020-06-17 12:01:32", "VALUE": "1" }, { "ID": 6, "SOURCEID": 2, "TIMESTAMP": "2021-06-17 ..
Web Development Company
Free Hosting Company
