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…
Relation public function groups() { return $this->belongsToMany('AppModelsItemGroup','item_to_group','item_id','item_group_id'); } ** How to select all Items that have item_group_id 0 and 9 BOTH?** $zero_and_nine_count = AppModelsItem::with(['groups' => function ($query) { $where[] = ['item_group_id', , 0]; $where[] = ['item_group_id', '=', 9]; $query->where($where); }])->count();…
How can I change this query [email protected]? $query = "select * from nozzle a left join nozzlereading b on a.id = b.nozzle and b.date=" . $date . " where a.meter=" . $meterid; $reading = DB::select($query); My models are Nozzle and…