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…
I have table Att_Log like this: Emp_ID Date_Att Time_Att E-0123 2024-01-02 08:05:56 E-0123 2024-01-02 17:02:23 E-0124 2024-01-02 21:55:56 E-0124 2024-01-03 06:02:23 the results I expect is like this: Emp_ID Date In_Time Out_Time E-0123 2024-01-02 08:05:56 17:02:23 E-0124 2024-01-02 21:55:56 06:02:23…
I'm looking for a solution of grouping elements from a flat hierarchy into a encapsulated one with the help of JSONata. Given that I have the following input data: [ { "restaurantName": "Pizza Place", "restaurantId": "1", "dishName": "Margherita Pizza", "dishId":…
I have the following array: var a = [ { "box":"1", "product":"Pen", "color":"White" }, { "box":"1", "product":"Pencil", "color":"Blue" }, { "box":"1", "product":"Marker", "color":"Red" }, { "box":"2", "product":"Paper", "color":"White"}, { "box":"2", "product":"GlossPaper", "color":"Yello"}, { "box":"3", "product":"Eraser", "color":"Pink"} ]; I would like…