Is it possible to combine multiple orWhere() inside one where()? E.g. The following: $query->where(function($query){ $query->where('text1', '=', $_GET['lorem']) ->orWhere('text2', '=', $_GET['lorem']) ->orWhere('text3', '=', $_GET['lorem']) ->orWhere('text4', '=', $_GET['lorem']); }); Would look something like this: $query->where(function($query){ $query->where(['text1' || 'text2' || 'text3' || 'text4'],…
I've got 3 models: Order, OrderItem and Product (for simplicity just showing the relationships): class Order extends BaseModel { use Uuid; protected $casts = [ 'status' => OrderStatuses::class, ]; /** * An Order has multiple OrderItems associated to it. *…
I could not find this in the laravel docs on aggregate relationships I was able to do something like this private function refreshUsers() { $this->users = User::withSum(['taskTimeSessions'=> function ($query) { $query->whereMonth('created_at',$this->month) ->where('is_reconciled',1); }],'session_duration_in_seconds') ->get(); } But now I am trying…
I am new to Laravel and looked already for a similiar thread but I didnt find something. I want to use Eloquent and I got 3 Models and Tables: Testseries, Devices and Users. The Users has a many to many…
Route: Route::get('/posts/{post}', [PostController::class, 'show']); Controller: public function show(Post $post){ $postData = $post->load(['author' => function($query){ $query->select('post_id', 'name'); }]) ->get(['title', 'desc', 'created_date']) ->toArray(); } This returns all the posts in the database, While I only want to get the selected post passed…
I have a User Model and Country Model, and Country belongs to User. I am getting users with country using User model with "with()" method, in different controllers & methods. Users::with('country')->get(); in different controllers. I want Users::get(); It should automatically…
example image data : when the js responds, the data has already been ordered by example image response js : example controller and query : $query = Verifikasi_tte::join('surat_ttes', 'surat_ttes.id', '=', 'verifikasi_ttes.surat_tte_id') ->join('users', 'users.id', '=', 'surat_ttes.user_id') ->join('jenis_surat_ttes', 'jenis_surat_ttes.id', '=', 'surat_ttes.jenis_surat_tte_id') ->select('surat_ttes.id','surat_ttes.klasifikasi','surat_ttes.no_surat','surat_ttes.tgl_surat','surat_ttes.created_at',…
I've scoured the web for this one. What I'm trying to do: I have a table that has a primary id. I need to add a column called ex. order_number that automatically increments starting at 1000 and up from there.…
I have a form on my .blade that has a filed "type_id" and it must a number between 0 and 4 is it possible to create a multiple size? for example 'size:0 || size:1 || size:2 || size:3 || size…
I have 3 tables (members, members3, payout) Payout Table having records with the relationship of both other tables (members, members3) I want to list the records with both table relationships. For example: Members Table (Plan 1) id, name, mobile 1,…