I am making a query to the DB from a view with eloquent to print a table, the case is that it works but before the table, where I have the query, it prints the array.
How should I do the query so that it only saves the data to be used in the table but does not print it on the page?
{{ $zero_users = DB::table('empleados')->where('estado', 0)->get() }}
I'm trying to display the contents of two related tables, but I don't think I'm getting the relationship right. I have 2 tables, categories and products . The categories table contains the cat_id and cat_name fields . One of the fields in the products table is cat_prod , which stores the same thing as the id_cat field , obviously, being the id of the category to which the product belongs. I haven't migrated any of these models with commands, but I created them directly in phpMyAdmin, and so far I don't know if this gives me any problems.
This is the Category model :
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class Categoria extends Model
{
use SoftDeletes;
const UPDATED_AT = null;
const CREATED_AT = null;
protected $primaryKey = "id_cat";
public $fillable = ['nom_cat'];
public $incrementing = false;
public $timestamps = false;
}
And this is the Product model :
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class Producto extends Model
{
use SoftDeletes;
const UPDATED_AT = null;
const CREATED_AT = null;
protected $primaryKey = "id_prod";
public $fillable = ['nom_prod'];
public $incrementing = false;
public $timestamps = false;
//Aqui intento hacer la relacion para tener acceso al atributo NOMBRE de la categoria correspondiente//
public function categoria(){
return $this->hasOne(Categoria::class, 'id_cat', 'cat_prod');
}
}
Once this is done, I try to display the cat_name attribute on the screen
<tbody>
@foreach ($productos as $prod)
<tr>
<td class="body-td">{{$prod->id_prod}}</td>
<td class="body-td">{{$prod->nom_prod}}</td>
<td class="body-td"></td>
<td class="body-td">{{$prod->categoria->nom_cat}}</td> //Esta linea genera el error//
<td class="body-td"></td>
<td class="body-td"></td>
<td class="body-td"></td>
<td class="body-td"></td>
</tr>
@endforeach
</tbody>
If I remove that line, it shows me the rest, but I have not been able to solve this error
Undefined property: stdClass::$category
This is the query with which I get the attributes of the product table :
public function getProductos(){
$productos = DB::table('productos')->select('*')
->whereNull('deleted_at')
->get();
return view('admin.productos.home', compact('productos'));
}
Regarding this query, I can display the obtained data without any problem.
And according to the video that I am following, with this code it is enough to obtain the data that I want to show:
//Aqui intento hacer la relacion para tener acceso al atributo NOMBRE de la categoria correspondiente//
public function categoria(){
return $this->hasOne(Categoria::class, 'id_cat', 'cat_prod');
}
(I already referenced this code snippet above)
What mistake am I making? How can I solve it?
Thanks in advance.
I am developing a system similar to what would be a "playstore" for an academic project. In the application there are 2 types of users, a developer user who can make a CRUD of applications for the system and another client user, who can see and list the apps of said developers (both types of users are in the Users table, use the Spatie Roles package to differentiate them and that each one has their access to certain routes, I understand that this is not a good practice, I am in the process of iterations).
I have created the application table migration with the foreign key pointing to the user id inside the "created_by" field. The relationship would be from 1 to N since 1 developer can be related to several applications, and an application is related to 1 developer.
Schema::create('applications', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('category');
$table->string('description');
$table->integer('price');
$table->text('logo_url');
$table->timestamps();
$table->engine = 'InnoDB';
});
Here I define the foreign key in this migration:
Schema::table('applications', function (Blueprint $table) {
$table->unsignedBigInteger('created_by');
$table->foreign('created_by')->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade');
});
Now I define the relations, in the User model:
public function apps() {
return $this->hasMany(Application::class,'created_by');
}
And in the Application model:
public function developer() {
return $this->belongsTo(User::class,'created_by');
}
Now, when the user logs in as a developer, he has to be redirected to a page where he can see the applications he created, to perform the corresponding CRUD, and at this point is where I basically have my problem ., I don't know if I'm using eloquent correctly (almost certainly not xd), but I made different tests that lead to the same undesired result. What I am looking for is to send to the view of the developer user, the applications that are related to their ID, which therefore will be the value of the "created_by" field of the previously mentioned applications table. And if there is no application for this developer, display a custom message with a button that points to the corresponding path to create your first application (although the latter is perhaps not as relevant).
At the moment what I have in the controller is this:
class DashboardController extends Controller
{
public function index(User $dev) {
$appsDev = $dev::has('apps')->get();
return view('dev.dashboard',compact('appsDev'));
}
}
However, when doing a print_r of the appsDev variable on the view, I run into this monstrosity:
App\Models\User Object
(
[fillable:protected] => Array
(
[0] => name
[1] => surname
[2] => alias
[3] => email
[4] => password
)
[hidden:protected] => Array
(
[0] => password
[1] => remember_token
[2] => two_factor_recovery_codes
[3] => two_factor_secret
)
[casts:protected] => Array
(
[email_verified_at] => datetime
)
[connection:protected] => mysql
[table:protected] => users
[primaryKey:protected] => id
[keyType:protected] => int
[incrementing] => 1
[with:protected] => Array
(
)
[withCount:protected] => Array
(
)
[perPage:protected] => 15
[exists] => 1
[wasRecentlyCreated] =>
[attributes:protected] => Array
(
[id] => 3
[name] => Esteban
[surname] => Perez
[alias] => Arrow
[email] => [email protected]
[password] => testing1234
[two_factor_secret] =>
[two_factor_recovery_codes] =>
[remember_token] =>
[created_at] => 2021-03-15 03:46:24
[updated_at] => 2021-03-15 03:46:24
)
[original:protected] => Array
(
[id] => 3
[name] => Esteban
[surname] => Perez
[alias] => Arrow
[email] => [email protected]
[password] => testing1234
[two_factor_secret] =>
[two_factor_recovery_codes] =>
[remember_token] =>
[created_at] => 2021-03-15 03:46:24
[updated_at] => 2021-03-15 03:46:24
)
[changes:protected] => Array
(
)
[classCastCache:protected] => Array
(
)
[dates:protected] => Array
(
)
[dateFormat:protected] =>
[appends:protected] => Array
(
)
[dispatchesEvents:protected] => Array
(
)
[observables:protected] => Array
(
)
[relations:protected] => Array
(
)
[touches:protected] => Array
(
)
[timestamps] => 1
[visible:protected] => Array
(
)
[guarded:protected] => Array
(
[0] => *
)
It should be clarified that I did some inserts to see what this returned to me, I was reading several articles and looking at tutorials but I haven't found any solution at the moment, how can I obtain the records of the applications corresponding to the logged in user?
I need to put the equivalent of an 'as' in a with subquery in an eloquent controller since I need to get properties from the same child table.
$userInfo = auth()->user()->id;
$projects = Project::withCount(['project_contents' => function($query){
$query->where('complete', 1);
}, 'project_images'])
->with(['project_images','project_contents'])
->where('user_id', $userInfo)->orderBy('id', 'DESC')-get();
As you can see in the previous code, I am doing two with since I need to obtain the complete properties of those child tables, and I am also doing two withCount to the same tables to obtain the number of columns that belong to the project, in the project_contents table I am doing making a query to get the project_contents that are completed, but I also need to get the project_contents that have another 'type' property that is equal to 'link'.
What I came up with was to do something like this in the same withCount:
withCount(['project_contents' => function($query){
$query->where('complete', 1);
}, 'project_contents'=> function ($query){
$query->where('type', 'link');}, 'project_images'])
but when getting the data from count eloquent doesn't know which count to do since the two queries are directed to the same table and in vuejs it is called with the same name:
project.project_contens_count
emphasizing that in vuejs I made a v-for of projects and call the property project.project_contents_count
is this controller code correct?
$product = Product::find($id)->with('dsa');
using only this
$product = Product::find($id);
It works correctly for me but when I try to add the related table I can't do it and I tried in a thousand ways and nothing... I have related tables both in my innoDB database and in the models...
MODEL
namespace App;
use Illuminate\Database\Eloquent\Model;
class Product extends Model
{
protected $fillable = [
'id', 'nombre', 'apellidos', 'nombreyape', 'nacimiento', 'fallecimiento', 'user_id'
];
public function dsa()
{
return $this->hasMany('App\Dsa', 'di', 'id');
}
}
Dsa model namespace App;
use Illuminate\Database\Eloquent\Model;
class Dsa extends Model
{
protected $fillable = [
'user_id', 'di', 'nombre', 'apellidos', 'enlace'
];
public function product()
{
return $this->belongsTo('App\Product', 'id', 'di');
}
}
using this controller
$product = Product::with('dsa')->find($id);
It works for me to display the entire table using
{{ $product->dsa }}
and it returns me this exactly
[{"id":10,"user_id":21,"di":39,"name":"pepe","surname":"lorenzo","link":"example","created_at":"2018 -10-06 14:50:37","updated_at":"2018-10-06 14:50:37"},{"id":11,"user_id":21,"di":39,name" :"juan","surname":"dented","link":"example","created_at":"2018-10-06 14:51:11","updated_at":"2018-10-06 14: 51:11"}]
but if i try to call something just like the name for example
{{ $product->dsa->nombre }}
I get the following error Property [name] does not exist on this collection instance.