public function get_user_documents() { $userId = Auth::id(); $user_documents = UserDocument::where('user_id', $userId) ->orWhereHas('share_documents', function ($query) use ($userId) { $query->where('users.id', $userId); }) ->with(['share_documents' => function ($query) use ($userId) { $query->where('users.id', $userId); }]) ->latest() ->get(); // $user_documents = $user_documents->map(function ($document) use ($userId) {…
I've been searching and couldn't find any post like the problem I have: I need to set an specific value in a "header", but since there's no record, I can't make it possible. create table Det_TMZF_Authorizations (id int, id_Det_TMZF int,…
I have the following data and MySQL table : CREATE TABLE my_tbl( id INT, dataset_query longtext ); INSERT INTO my_tbl(id, dataset_query) VALUES (1, '{"database":1,"native":{"query":"SELECT * FROM view_1.device","template-tags":{}},"type":"native"}'); INSERT INTO my_tbl(id, dataset_query) VALUES (2, '{"database":1,"native":{"query":"SELECT id, name FROM view_1.request","template-tags":{}},"type":"native"}'); INSERT INTO…
Laravel group by if column value exits then group by perform other wise as it is return records in single laravel query i have tried this $sql = $this->expense->builder()->where('session_year_id',1)->whereNull('staff_id')->orWhereNotNull(function($q){ $q->groupBy('month'); })->get();
at the moment I'm using these functions for my queries: public function Surat_300() { $query = $this->db->query(" SELECT * FROM `ts_300` WHERE `status_surat` = '1' "); return $query->num_rows(); } public function Surat_336_a() { $query = $this->db->query(" SELECT * FROM `ts_336_a`…
I have 2 different databases where i am using MySQL with 2 different database using laravel 9. The 1st database name as stores and 2nd database name as producers . I want to use this 2 different database in my…
For a reason that would take too long to explain, I don't have any heading H2 tags in my articles published on my WordPress, but h3, h4, h5, and h6 yes. So I have to modify all the other tags…
I am developing an application that's used to manage sales business of a company. Their business are multi layer, means a sales person A is managed by another sales person B, and that sales person B is also managed by…
I am trying to write an Eloquent query for a BelongsToMany relationship and where the results return only one distinct result based on the pivot table. See below for example. Installer: Id Name 1 Installer 1 2 Installer 2 State:…
I have a problem as follows; Let's say I have 3 tables like this: tableA ID_name Name Email 1 Alice xx 2 Betty xx 3 Chris xx tableB Id_task id_name Tasks_submitted 1 1 1 2 2 1 3 1 1…