Changeset 12980

Timestamp:

11/27/2023 12:27:16 AM (20 months ago)

Author:

dufresnesteven

Message:

Remembers: Update handler to return name and sort by date of passing.

See: https://meta.trac.wordpress.org/ticket/7175

File:

• sites/trunk/wordpress.org/public_html/wp-content/mu-plugins/pub/wporg-memorial-profiles.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/mu-plugins/pub/wporg-memorial-profiles.php

@@ -12 +12 @@
     global $wpdb;
 
-    $results = $wpdb->get_results( 'SELECT user_id FROM bpmain_bp_xprofile_data WHERE field_id = "476" AND value = "Yes"', ARRAY_A );
+    $date_of_passing_field_id = 483;
+    $memorial_name_field_id   = 484;
 
-    $user_ids = wp_list_pluck( $results, 'user_id' );
+    $query = $wpdb->prepare(
+        '
+        SELECT field_id, value, user_id
+        FROM `bpmain_bp_xprofile_data`
+        WHERE field_id IN ( %d, %d )
+        AND user_id IN (
+            SELECT user_id
+            FROM bpmain_bp_xprofile_data
+            WHERE field_id = 476 AND value = "Yes"
+        )
+        ORDER BY user_id
+        ',
+        $date_of_passing_field_id,
+        $memorial_name_field_id
+    );
 
-    // Grabs user display_name and user_nicename for profile link.
-    return get_users(
+    // Execute the prepared statement
+    $profile_data = $wpdb->get_results( $query, ARRAY_A );
+
+    $user_ids = wp_list_pluck( $profile_data, 'user_id' );
+
+    // Grabs user display_name, user_nicename, ID for profile link.
+    $users = get_users(
         array(
             'blog_id' => 0,
             'include' => $user_ids,
             'fields'  => array(
-                'display_name',
+                'ID',
                 'user_nicename',
             ),
         )
     );
+
+    // Add meta each user in the result
+    foreach ( $users as &$user ) {
+        foreach ( $profile_data as $profile ) {
+            if ( $profile['user_id'] === $user->ID ) {
+
+                if ( $date_of_passing_field_id === (int) $profile['field_id'] ) {
+                    $user->date_passing = $profile['value'];
+                }
+
+                if ( $memorial_name_field_id === (int) $profile['field_id'] ) {
+                    $user->display_name = $profile['value'];
+                }
+            }
+        }
+    }
+
+    // Sort based on date of passing
+    usort(
+        $users,
+        function ( $a, $b ) {
+            $timestampA = strtotime( $a->date_passing );
+            $timestampB = strtotime( $b->date_passing );
+
+            if ( $timestampA === $timestampB ) {
+                return 0;
+            }
+
+            // Use the less than operator for ascending order, or greater than for descending order
+            return ( $timestampA < $timestampB ) ? -1 : 1;
+        }
+    );
+
+    return $users;
 }