The User model has a one to one relationship with the PhoneNumber class: public function phoneNumber() { return $this->hasOne(PhoneNumber::class); } Yet, if the PhoneNumber table has multiple rows with the same user_id (for example 1), multiple models are returned from the Eloquent statement. $multiplePhoneNumbers = User::find(1)->phoneNumber()->get(); This begs the question, what is the purpose of ..
Category : eloquent–relationship
I want some help of forming queries on Laravel Eloquent I have 4 models in my application Item Model class Item extends Model { use HasFactory; /** * The attributes that are mass assignable. * * @var array */ protected $fillable = [ ‘code’, ‘name’, ‘type’, ‘price’, ‘cost’, ‘reorder_level’, ‘status’ ]; public function grnoteitems() { ..
I have two model. User, Images. How can I get all the users who has images and the image date is between start and end date. Date column name "date". Sourc..
I want to retrieve some data but I don’t know how to. I have a model called student with this many-to-many relationship defined. public function statusuri() { return $this->belongsToMany(Status::class, ‘status_student’) ->withPivot(‘id’, ‘data_inceput’, ‘data_sfarsit’, ‘document’, ‘status_id’, ‘stare_stagiu_id’) ->withTimestamps(); } The structure of the pivot table status_student is this: id data_inceput data_sfarsit document student_id status_id stare_stagiu_id In ..
i am trying to store a complex object in database. There are a lot of relationships like one-to-one and one-to-many. Everything works fine but at the moment i am doing the saving inside the foreach loop, which is not correct. foreach($list as $item){ $objA = new ObjA(); $objA->id = $item[‘id’]; $objA->save(); $objB = new ObjB(); ..
I have many to many relationship and I’m trying to check this company’s shift name already exist or not in database. relation is below. public function shifts() { return $this->belongsToMany(‘AppModelsShift’); } public function companies() { return $this->belongsToMany(‘AppModelsCompany’); } Sourc..
I try a search bar where I wanna type a price like 3000 and I want to show me a range of prices from 3000-3999 and for the others prices as well, 1000-1999, 2000-2999, etc… I have this code which shows me only the exact price I type ->orWhere(‘price’, ‘LIKE’, ‘%’.$request->search.’%’); How do I have ..
I have a DB query like this: $bal = DB::table(‘user_wallet’)->where(‘wallet_id’,$wallet_id)->where(‘user_id’,$user_id)->first(); So it basically gets the row from user_wallet table that has the the wallet_id of $wallet_id variable and user_id of $user_id variable, which returns this as result: Now I wish to do this query with Eloquent but I don’t know what is the proper way. ..
I have 3 Table Like This, One of User Table users id, name second one documents id, type third One clinician_credentials id, user_id, document_id => in this user_id from users table and document_id from documents table I am tried hasManyThrough but did not give perfect data, please suggest to me which one relationship is suitable ..
I have 3 tables like this, One of User table users id, name second one documents id, type third one clinician_credentials id, user_id, document_id => in this user_id from users table and document_id from documents table I am tried hasManyThrough but did not give perfect data. which relationship is suitable in this case? public function ..
I am trying to make a connection between teams and users. Pretty much Latrust looks like an awesome package BUT some things I believe could be explained better. Let’s pick a team (say: team_id = 1): $team = Team::where(‘id’, $request->team_id)->first(); And let’s pick our users from the team: $roles = Role::get(); $users = User::whereRoleIs($roles->pluck(‘name’)->toArray(), $team)->get() ..
I have models: ChatRoomMembers ChatRoom so I want to check if auth user is in chat room my relationships: ChatRoom: public function chatRoomMembers() { return $this->hasMany(ChatRoomMember::class); } ChatRoomMembers: public function chatRoom() { return $this->belongsTo(ChatRoom::class); } public function user() { return $this->belongsTo(User::class); } Sourc..
I have a Laravel Eloquent Model called EmailList and a model called Subscriber. I defined the following hasMany relationship on the EmailList. public function subscribers() { return $this->hasMany(Subscriber::class); } This relationship works fine. I now want to apply a where() condition on the parent and a where() condition on the child. For example, I have ..
I want to find days between 2 dates in Eloquent Query In Laravel. I have Query Like this, $credentials = Documents::whereIn(‘agency_id’, $agency_ids) ->with(‘dp_credential’) ->get()->toArray(); if (count($credentials)) { foreach ($credentials as $val) { if ($val[‘dp_credential’]) { $current_date = new DateTime(date(‘Y-m-d’)); $expiry_date = new DateTime($val[‘dp_credential’][‘expiry_date’]); $interval = $current_date->diff($expiry_date); $days = $interval->format(‘%r%a’); // if you getting days in ..
I really don’t know how to put it. I have two tables Order.php and Product.php, a return $this->hasMany(Product::class, ‘id’); in Order.php and return $this->belongsTo(Order::class, ‘product_id’); in Product.php. In my OrderController public function index() { $orders = Order::latest()->paginate(10); return view(‘admin.order.order’)->with([ ‘orders’ => $orders, ]); } in my view @foreach($orders as $order) <tr data-href="{{ route(‘orders.view’, $order->id) }}"> ..
Property Model: class Property extends Model { use HasFactory; protected $table = ‘properties’; protected $fillable = [‘name’, ‘address’, ‘city’, ‘poskod’, ‘state’, ‘facilities’]; /* Get all the units in this property */ public function units() { return $this->hasMany(Unit::class); } } Unit Model class Unit extends Model { use HasFactory; protected $fillable = [ ‘user_id’, ‘property_id’, ‘type’, ..
Let’s assume I’ve got a User model ("users" table => id, email, userable_id, userable_type) and a Customer model ("customers" table => id, name etc., not important fields). User model has the following: public function userable() { return $this->morphTo(); } Customer model has the following: public function user() { return $this->morphOne(‘AppModelsUser’, ‘userable’); } Everything works fine ..
Please, guys, I need your help. I want to implement a system where a user can be an agent (with a name they desire to call their agency). Also, when it is approved by the admin, many users can belong to this agency during their sign-up process by referencing the agent ID. How do I ..
I have hasMany relationship in my User model; /** * Get the posts for the users. */ public function posts() { return $this->hasMany(Posts::class); //foreign key assigned by user_id } I need to get a foreign id in Eloquent data Controller; use AppModelsUser; $posts = User::find(1)->posts; foreach ($posts as $post) { // } //for example $foreign_key ..
Working on a query in Laravel 8 project for retrieving company details. below is the structure and mysql query. # Getting company param from request. SELECT c.company_name, p.position_name, s.salary FROM tbl_company as c JOIN tbl_company_type as t ON t.id = c.company_type_id JOIN tbl_company_position as p ON p.company_id = c.id JOIN tbl_comapny_salary as s ON s.position_id ..
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..
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, ..
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)’) ..
There is a query that works when strict => false in database.php of Laravel. I don’t want to make strict => false, I want it to remain true. Is there a way to change this query and achieve the same results? Transaction::where(‘contact_id’, 9) ->with(‘allocations’) ->whereHas("allocations", function ($query) { $query->havingRaw(‘transactions.credit > sum(amount)’); $query->groupBy(‘transaction_id’); }) ->orDoesntHave("allocations") ->get(); ..
I have two tables transactions and transaction_allocations. One transaction can have many allocations. Transaction Model Schema::create(‘transactions’, function (Blueprint $table) { $table->bigIncrements(‘id’); $table->timestamps(); $table->foreignId(‘contact_id’)->constrained(); $table->decimal(‘amount’,19,4)->nullable(); }); Allocation Model Schema::create(‘transaction_allocations’, function (Blueprint $table) { $table->bigIncrements(‘id’); $table->timestamp(‘created_at’); $table->foreignId(‘transaction_id’)->nullable()->constrained(); $table->foreignId(‘bill_id’)->nullable()->references(‘id’)->on(‘bills’); $table->decimal(‘amount’,19,4)->nullable(); }); Relationship in Transaction Model public function allocations(){ return $this->hasMany(TransactionAllocation::class); } I need to query all transactions where ..
Web Development Company
Free Hosting Company
