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.…
in my laravel project i have colorpicker input field where I want to autosave the value in database. In this section I have pasted the script which is running properly. But the problem is this is continue saving the value…
I have about 30+ migration files. When it gets to a migration which contains a column rename: Schema::table('table', function (Blueprint $table) { $table->renameColumn('old_field', 'new_field'); }); It only errors once it gets to this migration (let's say, number 15). It runs…
I'm trying to retrieve some data from my MySQL database, but It's not working using Eloquent (I'm getting 0 rows). I's a very simple query, but is driving me crazy. This is the query in PHP: $slideshowIdList = Media_slideshow::select('idSlideshow') ->whereIn('idMedia',$idList)…
Here my MySQL query (work in phpMyAdmin) : SELECT waktu_kerusakan, workcenter, COUNT(workcenter) AS jumlah_repair FROM repair WHERE year(waktu_kerusakan)='2019' GROUP BY workcenter , month(waktu_kerusakan) BETWEEN 1 and 6 Order By jumlah_repair Desc then, i try in Laravel Syntax like this below…
I have a simple form for adding pages information, the form looks like this as you can see above the prebid input, To add prebids we need to click plus button and pop up appear inside a popo up, I…