Level 13
You need to add the company_id in Popup, Bias and DiscountCode tables and then create the relationships .
https://laravel.com/docs/8.x/eloquent-relationships#one-to-many
Jul 14, 2021
3
Level 1
Get data with 3 relationships
Hi, I have a relationship on 3 tables, how could I make a query to take the data according to the id I have + the 3 relationships?
$id = Auth::user()->company_id;
$data = Popup::getPopupByCompanyId($id);
$biases = Bias::getBiasByCompanyId($id);
$discounts = DiscountCode::getDiscountsByCompany($id);
$introductionMessages = IntroductionMessage::getDiscountsByCompany($id);
I take them like that now, but how could I make a whereHas all 3? this is relationsship from biases, discount, introduction to Popup model
$table->foreign('company_id')->references('id')->on('companies')->onDelete('cascade');
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->foreign('discount_code_id')->references('id')->on('discount_codes')->onDelete('cascade');
And I can only take all that data with company_id, how could I do a whereHas function in which company_id is the main thing I am guided by and join it after company id data May?
Level 6
if you have set up your model relationship correctly then
$variable=Model_name::with('model_relationship1')->with('model_relationship2')->with('model_relationship3')->get();
Level 1
Call to a member function addEagerConstraints() on null in file
Models
Bias
public function discount_codes()
{
$this->hasMany(DiscountCode::class);
}
DiscountCode
public function biases()
{
$this->belongsTo(Bias::class);
}
Migration
Bias
$table->integer('discount_code_id')->nullable()->unsigned();
$table->foreign('discount_code_id')->references('id')->on('discount_codes')->onDelete('cascade');
Discount Code
$table->increments('id');
$table->string('discount_code')->nullable();
Please or to participate in this conversation.