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…
this is my code I want to convert this query in to a common query if ($limit == 0) { $response = WebhookErrorNotification::where('is_error', true)->orderByDesc('id')->get(); } else { $response = WebhookErrorNotification::where('is_error', true)->orderByDesc('id')->limit($limit)->get(); }
It seems that eloquent uses a single query for "with" regardless of how many ids there are Book::with('author')->get(); This would trigger those two queries: SELECT * FROM books; SELECT * FROM authors WHERE id IN (...); The second query may…
[user checks relation] [1]checks table users tablegot this console query to get the result i want but can't figure out how to make it a function in laravel. select DATE(c.check_in), group_concat(users.id), sec_to_time(sum(TIME_TO_SEC(c.check_hours))) AS total_time from users join checks c on…
I used Eloquent query to extract the below table **$ user = User::all() ** id q1 q2 q3 q4 q5 q6 q7 0 0.01 0.8 null 0.9 null 0.9 0.1 1 0.8 null null 1 null 1 null 2 null…
I'm trying to get all posts that has at least 2 comments in the last 48 hours. I'm using the following code: $posts= Post::has( 'comments', '>', 1 )->whereHas( 'comments', function( $comments ) { return $comments->where( 'created_at', '>', Carbon::now()->subDays(2) ); })->get()->toArray();…