I am learning to use the laravel eloquent and I have this query SELECT SUM(precio_total) FROM `venta` GROUP BY (MONTH(fecha)); So far i wear this $cantidad_venta = Venta::select('SUM(PRECIO_TOTAL) as suma_precio') ->groupBy('MONTH(fecha)') ->get(); I try to go through axios, but it…
Help me little please. I can't filtering single record. May be or not. // In Controller public function show(Post $post) { $post = Post::with(['comments' => function($query) { $query->where('status', 'active'); } ])->find($post); // can't filter comments return view('post.show', ['post' => $post]);…
i have a table which has the fields attachment_id and file_path ,file_path field stores the path from s3 bucket corresponding to the attachment id . is there any way to initialize a method or call an event directly from the…
After spending hours on this, finally I felt to post this question here. I am trying to join tables. Due to some circumstances, I have to use the query in the same way that I have pasted below. select posts.id,…
I've defined a Backpack select_from_array column for the field form_trx in the table transactions. I want to populate the options array for that Backpack column with data that's stored in two columns (called value_store and value_display) of another database table…
I have a model with four relations like as below public function custform_formfields() { return $this->hasOne(FormFieldMapping::class,'field_id','field_id'); } public function custform_fieldtype() { return $this->hasOne(FieldType::class, 'fieldtype_id', 'html_field_type'); } public function custform_forms() { return $this->hasOne(CustomForms::class,'form_id', 'form_id'); } public function custform_options() { return $this->hasOne(FormOptions::class,'option_id',…
im currently making this queue web, so i want to select the longest overall queue time. im able to select the longest queue time per category but somehow when i want to retrieve the longest overall queue time, my model…
form models { //filters search if(isset($filters['search']) ? $filters['search'] : false){ return $query->where('tittle','like','%' . $filters('search') . '%') ->orWhere('body', 'like', '%' .$filters('search') . '%'); } } and from controller "posts" => Post::latest()->filter(request(['search']))->get() and i get Array callback must have exactly two elements…
How should I define two relationships to the same table? Here's a simple example: Person - id - name Deal - id - seller_person_id - buyer_person_id - date - amount On the Person model I can have these relationships: public…
I'm building a booking system in Laravel, look at below image Today is 3, my customers booked in current month 1,6,8,10,12 and 25. I want to send a notification to those who left 6 days from today. I want to…