I use Laravel Eloquent ORM in my project. I need to duplicate a base query in order to create different queries, and as a by-product I have a problem with the order of some JOIN statements. In order to simplify…
I have this relation in my model... $this->hasMany('AppInventory')->where('status',1) ->whereNull('deleted_at') ->where(function($query){ $query ->where('count', '>=', 1) ->orWhere(function($aQuery){ $aQuery ->where('count', '=' , 0) ->whereHas('containers', function($bQuery){ $bQuery->whereIn('status', [0,1]); }); }); }) ->orderBy('updated_at','desc') ->with('address', 'cabin'); And Sql query generated are : select * from `inventories`…
why this is not working?? anything else i need to doo??? (note: i don't want to call any boot method from model). in models its working fine with booted method // route Route::get('/tests', function () { return Test::find(1)->update([ 'name' =>…
so im trying to update my data, and it shows this: IlluminateDatabaseQueryBuilder::cleanBindings(): Argument #1 ($bindings) must be of type array, null given so when i try to look into it, the error is here $tradeSetup->tags()->whereNotIn('user_tag_id', $request->userTag)->delete(); weird thing is, i…
I have the array as below; I'd like to insert each name keys into tableName and get the inserted id. For the steps, each of them will be inserted into another table tableSteps including the last inserted id of the…
I have 6 data in database record but I want to get last 3 data this is my data : criteria_id criteria_name 1 A 2 B 3 C 4 D 5 E 6 F i have tried with this code…
$suppliers = Supplier::with( [ 'purcheses' => function ($query) { $query->with( [ 'payments' => function ($query) { $query->sum('amount'); } ] )->get(); } ] )->latest()->get(); I have a suppliers table with has-many relations with purchases of purchases table with has-many relations with…
So, I want to insert an entire array of values into a particular column and I don't know exactly what to do. Everything I have tried gives me the "Array to string conversion" error. Here is my controller code: public…
I want to get previous and next news order by date. The code below works fine if there is only one news a day. But cannot handle multiple news on the same day. NewsController.php public function detail($slug){ $news = AppNews::active()->where('slug',…
Suppose I have Post model that has is_verified column with smallint datatype, how can I get all records that is verified? One thing to do this is using this: Post::where('is_verified', true)->get(); The code above will produce the following query: select…