I'm having issues with returning belongs to many relationship. Here is my scenario. I have "Individual" model and "Group" model where each individual can belongs to many groups and each group can belongs to many user. Working with database blueprint…
This is a little complex for me,so I decided to get some help. Taxonomy has : public function products() { return $this->belongsToMany( Product::class, 'term_relationships', 'term_taxonomy_id', 'object_id' ); } And Product has : public function taxonomies() { return $this->belongsToMany( Taxonomy::class, 'term_relationships',…
I am trying to execute some queries which are dependant on each other, so what I want is if any error occurs then rollback all the queries inside transaction. what I've tried so far is DB::transaction(function () use($user,$token,$request) { $billing…
I've got 2 arrays that I've created from a 2 SQL queries. I'm wanting to turn them into a named array,and then complete an array merge the reason for this is that they have different information and are named differently…
I am using laravel 6.I have created a table called 'student', where the value increment of the 'id' column is supposed to happen but is not happening. This is my migration file: <?php use IlluminateDatabaseMigrationsMigration; use IlluminateDatabaseSchemaBlueprint; use IlluminateSupportFacadesSchema; class…
I have this json value that I want to be sorty but for some reason it's not working. [ { "id": 15028, "order_id": 342, "user_id": 3, "status": "1", "priority": "1", "donedate": null, "user": { "id": 3, "name": "Max" } },…
I have a jsonresource but it says undefined constant id class DashboardGraphDataResource extends JsonResource { public function toArray($request) { return [ 'id' => id, 'technology' => technology, 'area' => area, 'totalCapacity' => total_capacity, 'working' => working, 'fileDate' => file_date, 'created_at'…
System Info: OS: Ubuntu 19.10 Laravel Version: 7.0 PHP Version: 7.3.11-0ubuntu0.19.10.4 MySQL Version: mysql Ver 8.0.19-0ubuntu0.19.10.3 for Linux on x86_64 ((Ubuntu)) I am building a small Laravel application and am having an issue with MySQL and relationships. When I try…
I have an array of category , and this categories have many books (belongToMany) how i can get all book sorry about my English category model class category_b extends Model { protected $table = 'categoryb'; protected $attributes = array( 'lang'=>…
Hello Following is my query, but I get error while run it: $out_let_product = OutLet::where('id', Redis::get('out_let_id') )->with( ['products' => function($query){ $query->with(['prices', 'combinations' => function($query){ $query->where('prices.active', '=', '1'); }]); }])->get(); In above code 'prices' and 'combinations' = function in product model.…