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,…
I've been reading through the documentation at Laravel's website but struggling to piece this all together. We have users who can be assigned to specific roles and/or teams at different times. For example, User A could be assigned to Team…
I want to use sync() for table client_package except some values/fields. It's because I'm displaying checkboxes with client names, that I want to add to a package. So if User has specific permission, he could see specific clients, and it's…
I have 2 columns with one-to-one relation users and doctors: Users _____________ | id | name | |____|______| | 1 | John | |____|______| Doctors _____________________ | id | dep | user_id | |____|_____|_________| | 1 | 2 | 1…
I have a model called RealEstate, this model has a relation with another model called TokenPrice, I needed to access the oldest records of token_prices table using by a simple hasOne relation, So I did it and now my relation…
Is it possible to customize the index of array in Laravel Builder? I need the index is not incremented from 0 but with some integer This is my code: foreach ($members as $member) { $check[$member->id] = TransactionInNon::where('member_id', $member->id) ->whereYear('created_at', $year)…