I have a bunch of event data which is identified by uid and timestamp. I have a number of aggregation pipelines which will calculate statistics for each user. These work if I run them one at a time, but I…
I sell online courses in my website using WooCommerce. Each course(product) has number of downloadable files. Unfortunately, WooCommerce does not group each product downloads together and make a long list of available downloads. If someone buy several courses, there will…
There is an array of "movements" of elements, about the same, only it can be many times more: Array ( [0] => Array ( [id] => 90415 [oldDate] => 2024-08-27 [newDate] => 2024-08-28 ) [1] => Array ( [id] =>…
I want to create a nested JSON object, something like this: [ { "age": 8, "countAll": 3, "gender": [ { "genderName": "male", "countGender": 2 }, { "genderName": "female", "countGender": 1 }, ] }, { "age": 10, "countAll": 1, "gender": […
I have this collection: $stocks = collect( [ ['sku' => '123', 'batch' => '123', 'qty_total' => 1], ['sku' => '1233', 'batch' => '123', 'qty_total' => 2], ['sku' => '123', 'batch' => '123', 'qty_total' => 3], ['sku' => '5', 'batch' =>…
I want to chunk an array into groups with the last few groups having the biggest size if the array cannot be divided evenly. Like the Euro Cup 2024 qualifiers where there are 53 teams divided into 10 groups with…
I am trying to group the data in my 3d array by one column value (order_id) and merge the subarray values in the products column within each group. Sample data: $ordersGlobal = [ [ "order_id" => "65", "products" => […
I need to group the data from my 2d array into an associative array of associative arrays where d values are the first level keys, and the s values will become the second level keys, and the i values should…
I have a custom taxonomy alphabetical pagination to list terms by first letter. function alpha_pagination() { $array = array( 'A' => __('A',''), 'B' => __('B',''), 'C' => __('C',''), 'D' => __('D',''), 'E' => __('E',''), 'F' => __('F','') ); $html =…
I have Attendance table: EmpId DateEntry AttType E-0001 2024-01-01 08:00:02 IN E-0001 2024-01-01 17:01:00 OUT E-0002 2024-01-01 07:59:02 IN E-0002 2024-01-01 17:00:07 OUT How to query this table into: DateEntry EmpID ClockIn ClockOut 2024-01-01 E-0001 08:00:02 17:01:00 2024-01-01 E-0002 07:59:02…