I have an array of categories: [ { categoryId: '01', categoryName: 'Byggmaterial' }, { categoryId: '010', categoryName: 'Bindemedel och bruk' }, { categoryId: '01001', categoryName: 'Cement' }, { categoryId: '01002', categoryName: 'Bruksbindemedel' }, { categoryId: '01003', categoryName: 'Kalkvaror' }, {…
I have an element with title, type, description and so on. I have a DAO that defines all that and functions already created that extract the type for one element only: it's getById(). How can I loop through all the…
ERROR: column "sams_ar_pb_rebuild.plan_units_ty" must appear in the GROUP BY clause or be used in an aggregate function select channel, category, club, week_ending, sum(eligible_units_ty) as "Eligible Units", sum(eligible_revenue_ty)::numeric as "Eligible Revenue", sum(plan_units_ty) as "Plan Units", sum(plan_revenue_ty)::numeric::money as "Plan Revnue", case when…
I want to split an array into rows as evenly as possible, obeying a minimum count per row constraint so that row counts are as close as possible to the minimum and the difference between different row counts is never…
I need to group the data in my 2d array by one column then by another column and sum a third column in each subset. Input data: $orders = [ ["date" => "20230320", "model" => "ABC", "quantity" => 1], ["date"…
As an example I have two arrays: Multidimensional Array 1: $line_items = [ 0 => ['price' => 41.99, 'id' => 12, 'quantity' => 1], 1 => ['price' => 155.95, 'id' => 11, 'quantity' => 1], 2 => ['price' => 21,…
I'm having great difficulty writing this query and cannot find any answers online which could be applied to my problem. I have a couple of tables which looks similar to the below with. Each purchase date corresponds with an item…
I am trying to split an array of space-delimited strings, group by a particular column, then store the data within each group in a more convenient structure. Sample data: $dataArray = [ 0 => "AAAAA 2023 01 25 01:04:00 ID:20fjrjeZZ",…
After sorting the $jobs array by location and territory_id values and then grouping them into arrays, I get an array which looks like the below - note I omitted most of the results inside each array since there's hundreds, but…
I have this array, and I would like to make a new array with date values, but whenever a STOPSALES value is reached, create a new subarray/group, and only store date values. [0]=> string(10) "2023-03-10" [1]=> string(10) "2023-03-11" [2]=> string(10)…