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…
Need to get record of current month but query return the wrong result.There is only one record in db.but i get wrong count for the current month $data = UserData::select( DB::raw("count(phone) as total") ) ->whereMonth('creation_date', Carbon::now()->month) ->get(); return view('kpidata', compact('data'));…
I have two models EcommerceOrders and Medicines class EcommerceOrders extends Model { use HasFactory; protected $table = 'ecommerce_orders'; protected $fillable = [ 'user_id', 'manager_id', 'first_name', 'last_name', 'phone_number', 'email', 'address', 'city', 'zip_code', 'other_info', 'products', 'total_price', 'qr_code', 'status', 'assigned_to', 'save_client_info', ]; class…
in my Laravel app I have 3 tables : users, documents and type_documents, the user have multiple documents and document have one type_document | Documents | | -------- | | id | | file | | type_document_id| | user_id |…
ServiceCategory has many Service public function services(): HasMany { return $this->hasMany(Service::class, 'category_id'); } Service has many Price public function prices(): HasMany { return $this->hasMany(ServicePrice::class, 'service_id'); } Let's say prices table has a price_value column, how do I get the lowest…