I am creating a movie series database and have models like so: Series $with=["seasons"] hasMany(AppSeasons) Season $with=["episodes"] belongsTo(AppSeries) hasMany(AppEpisode) Episode belongsTo(AppSeason) Question 1 How can I based on Eloquest Series::all() sort desc by Episode ID ? [ [… seasons: [ [… episodes: [ [id] <—- sort by this ] ] ] ] Question 2 Can ..
Category : eloquent
I’m using Laravel for a project and i want to filter a collection based on custom method written in the model: Controller: $models= Produs::with(‘categorie’) ->with(‘poza’) ->with(‘element_extra.extras’) ->get() ->where(‘id_stare’, 1) ->where(‘categorie.id_restaurant’, $idRestaurant) ->groupBy(‘categorie.denumire’); $produse = $models->filter(function ($produs, $key) { return $produs->isAvailable(); })->values(); Model: class Produs extends Model { protected $table = "elemente"; public $timestamps = false; ..
I have an app consisting of these tables users id name user_location id user_id cities_id cities id state_id country_id name states id country_id name countries id name Then how to get relationship this five table? Sourc..
I am importing data from a CSV in to a database using Laravel and eloquent. Some of the cells contain data between curly brackets, like "{data}" I know the curly brackets are used by Laravel within the blade templates and perhaps why it is not working. Can anyone advise whether it is possible to import ..
[I’m looking for best practice to handle] I have data structure like below: Category Class protected $fillable = [ ‘id’, ‘price’, ‘name’ ]; public function products() { return $this->hasMany(Product::class, ‘category_id’); } Product Class protected $fillable = [ ‘category_id’, ‘price’ ]; public function category { return $this->belongsTo(Category::class, ‘category_id’); } Let’s say I updated price at category. ..
I have this query. Currently, this displays the status_count for the logged users. I want to update this query to display all the statuses from the status table and if the logged user has no record for any statuses to display status_count as 0. $orderStatistics = OrderHeader::select(‘status.id’, ‘status.name’, ‘status.description’, ‘status.type’, ‘status.code’, DB::raw(‘order_status,count(*) as status_count’)) ->leftjoin(‘status’, ..
I have two tables Sensors <?php namespace AppModels; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateDatabaseEloquentModel; use AppModelsMeasurement; class Sensor extends Model { use HasFactory; protected $table = ‘sensors’; public function measurements(){ return $this->hasMany(Measurement::class); } } and Measurements <?php namespace AppModels; use IlluminateDatabaseEloquentFactoriesHasFactory; use IlluminateDatabaseEloquentModel; use AppModelsSensor; class Measurement extends Model { use HasFactory; protected $table = ‘measurements’; public ..
i have a sub contact and i want to make an edit page to edit the sub contacts that related to the id of the contact name i created the edit page but it tells me Property [parent_id] does not exist on this collection instance. the problem is i want to show on the edit ..
I want to update status on confirm click to 1. i am using vue js and laravel. i used axios.post for hit the API. but when i click on confirm to update status, i get error message for route post is not supported. please help me to find my mistake. unconfirmedareas.vue ConfirmArea(index){ var confirmArea = ..
enter image description here I am using laravel 7.4 version. I have updated composer and trying to run project on local but getting error as shown in image. Sourc..
I need help to make a query to get the ids where the values for a specific month are between the start and end dates. The table format is (I can’t change, this is not mine): id | attribute_id | value 1 | 24 | ‘2016-03-01’ 1 | 25 | ‘2020-03-01’ … 24 = start ..
I have a query for adding custom "balance" column using sum of values in relation table. User::withCount([‘transactions as balance’ => function($query) { $query->select(DB::raw(‘sum(credit_movement)’)); }]); This works fine for returning "balance" column. Now, I want to filter the users regarding the "balance" column. ->where(‘balance’, ‘<‘, 0); If I chain it to the query, it won’t work ..
I have a query for adding custom "balance" column using sum of values in relation table. User::withCount([‘transactions as balance’ => function($query) { $query->select(DB::raw(‘sum(credit_movement)’)); }]); This works fine for returning "balance" column. Now, I want to filter the users regarding the "balance" column. ->where(‘balance’, ‘<‘, 0); If I chain it to the query, it won’t work ..
I’m trying to filter users based on withCount() result and with() relationship. By filter, I mean do not return that user at all. User::with(‘info’) ->withCount([‘transactions as balance’ => function($query) { $query->select(DB::raw(‘sum(credit_movement)’)); }]); This works for returning the "info" relationship and "balance" column for user’s balance. Now I want to query based on 2 things. where(‘balance’, ..
I need to store Password as hashed to the database, I was able to has the password but when I submit my form the password stores as un-hashed, Here’s my controller Store Function public function store(Request $request) { $hash = [‘password’ => Hash::make($request)]; //dd($hash); // HASHED PASSWORD WAS DISPLAYED HERE $user = User::create($this->validateRequest()); dd(‘User Created’); ..
i want to sort the values of the table in descending order and the null value is in the first like this: null null 2020-09-27 16:36:17 2020-09-27 18:20:30 2020-09-27 22:45:26 2020-09-28 02:11:14 2020-09-28 10:31:43 I used the following code but it did not work Source::orderBy(‘last_rank_update’, ‘asc’)->get(); how can i achieve that? Sourc..
I’m going to give a brief overview about the app configuration before I go into the query. I am running a Laravel 6 app using MongoDB through Jenssegers MongoDB plugin. So far I have not had to write a raw mongo query and I hope I won’t have to for this one too, I mean, ..
I’m trying to get first element every category. Category Class public function product() { return $this->hasMany(Product::class, ‘category_id’, ‘id’); } public function first_product() { return $this->product()->limit(1); } Here is my query $categories = Category::with(‘first_product’)->get(); I got first product only first element of category. why? Sourc..
I am able to delete photo in local xampp server but I cannot delete photo completely in live server public function delete($id) { $employee=EmployeeContract::find($id); $employee->delete(); Storage::delete($employee->photo); return redirect()->route(’employeecontract.index’); } Sourc..
I have these fields in my table, I want get the data by month of the selected year & type_id, then SUM the amount on each month. Ex: selectYear = 2019 Here is my account_table id | type_id | amount | kind | created_at 1 | 2 | 200 | expense | 2019-01-15 10:14:31 2 ..
I have two models with a many-to-many relationship. FORM and WORKSPACE. So FORM belongsToMany WORKSPACE, and WORKSPACE belongsToMany FORM. Now I need to do a query where I get all FORMs that belong to any of the WORKSPACEs in a collection ($workspaces). Something like this: $forms = Form::whereHas(‘workspaces’, function ($q) use ($workspaces) { $q->whereIn(‘id’, $workspaces); ..
I have a problem with inserting into table where updated_at, created_at, deleted_at have type integer. But as I understood, this columns have default type datetime and when I update note, I have an error like Invalid text representation: 7 ERROR: invalid input syntax for type integer: "2020-09-28 04:21:06". Therefore when I create a new note, ..
I have a problem. I am doing a search function where users will enter the products they want to search via a form and will return the products. This is the form. <form action="{{ route(‘shopAll’) }}"> <input type="text" name="search" placeholder="Search Products…"> <button type="submit"><i class="ti-search"></i></button> </form> Product.php class Product extends Model{ protected $fillable = [ ‘name’,’added_by’, ..
I have a problem. I am doing a search function where users will enter the products they want to search via a form and will return the products. This is the form. <form action="{{ route(‘shopAll’) }}"> <input type="text" name="search" placeholder="Search Products…"> <button type="submit"><i class="ti-search"></i></button> </form> Product.php class Product extends Model{ protected $fillable = [ ‘name’,’added_by’, ..
im stuck adding column actions for edit and delete button with yajra datatables, im using DataTables Service because im wanna add export button too, here is my my datatables code : public function dataTable($query) { return datatables() ->eloquent($query); } /** * Get query source of dataTable. * * @param AppInfoDataTable $model * @return IlluminateDatabaseEloquentBuilder */ ..