i have developed a pgplsql function to receive array of dates the return the maximum date, but its not able to call the function: select 1, arcfm.array_max_date('{2022-02-03, 2022-06-05}'::timestamp[]) as max_date_time; CREATE OR REPLACE FUNCTION arcfm.array_max_date(in dates_array timestamp[]) RETURNS timestamp LANGUAGE…
I have the following code that case-insensitively groups associative elements in a flat array and sums the related values, but I don't really understand how it works. function add_array_vals($arr) { $sums = []; foreach ( $arr as $key => $val…
I have a database of a the employees of a company that looks like this: { _id: 7698, name: 'Blake', job: 'manager', manager: 7839, hired: ISODate("1981-05-01T00:00:00.000Z"), salary: 2850, department: {name: 'Sales', location: 'Chicago'}, missions: [ {company: 'Mac Donald', location: 'Chicago'},…
I want to sum the value of keys that are the same but in diffrent case. Let's say we have this array <?php $array = ['KEY'=> 5, ,'TEST' => 3,'Test' => 10,'Key'=> 2]; //--- a function to sum //--- print_r($array);…
For four days I am trying to figure out how to solve this, as well as googling it, and was no luck The problem is that I needed to loop through a nested array (for unknown deep) and keep the…
$arr = ['Governance->Policies->Prescriptions->CAS Alerts', 'Users->User Departments->Department Hierarchy', 'Settings->Registrar->Finance', 'Logs->Second Opinion Log']; This is array and I want to convert it into string like below The string should be one it just concate in one string. Governance->Policies Governance->Prescriptions Governance->CAS Alerts Users->User…
I'm looking to push this ObjectId from the Notes Schema: 635b70c1121186eefbbc5718 into the 'notesId' of this other Category Schema: { _id: new ObjectId("635b70c0121186eefbbc5714"), name: 'frenchLessons', creator: new ObjectId("635aa97815faaa052ae9cfce"), notesId: [], __v: 0 } What I did was that I found…
I'm running a query on Mongodb to get the combine data from two different collections: User and Store. User collection has a property named as store_ids, which is an array that contains a list of ObjectIds of each store that…
I have a section in which user can filter different data on drop-down select , I have an array of data as follows. const data = [ { name: 'Trump', country: 'USA', age: 70, IQ: 140, }, { name: 'ID…
Is it possible to customize the index of array in Laravel Builder? I need the index is not incremented from 0 but with some integer This is my code: foreach ($members as $member) { $check[$member->id] = TransactionInNon::where('member_id', $member->id) ->whereYear('created_at', $year)…