Changeset 10957

Timestamp:

05/06/2021 06:43:29 AM (4 years ago)

Author:

dd32

Message:

Helpscout: Display Slack user details in the profile information.

Location:

sites/trunk/api.wordpress.org/public_html/dotorg/helpscout

Files:

• common.php (modified) (2 diffs)
• dpo.php (modified) (2 diffs)
• profile.php (modified) (2 diffs)

sites/trunk/api.wordpress.org/public_html/dotorg/helpscout/common.php

@@ -1 +1 @@
 <?php
 
+$wp_init_host = 'https://wordpress.org/';
 $base_dir = dirname( dirname( __DIR__ ) );
 require( $base_dir . '/wp-init.php' );
@@ -25 +26 @@
 
 // get the info from HS
-return json_decode( $data );
+$data = json_decode( $data );
+
+// If this is related to a slack user, fetch their details instead.
+if (
+    isset ( $data->customer->email, $data->ticket->subject ) &&
+    false !== stripos( $data->customer->email, 'slack' ) &&
+    preg_match( '/(\S+)@chat.wordpress.org/i', $data->ticket->subject, $m )
+) {
+    $user = get_user_by( 'slug', $m[1] );
+    if ( $user ) {
+        $data->customer->email = $user->user_email;
+    }
+}
+
+return $data;

sites/trunk/api.wordpress.org/public_html/dotorg/helpscout/dpo.php

@@ -2 +2 @@
 // Add current DPO Export/Erasure status for the customer.
 
-$wp_init_host = 'https://wordpress.org/';
 // $request is the validated HelpScout request.
 $request = include __DIR__ . '/common.php';
@@ -14 +13 @@
 
 // default empty output
-$html = '';
-
+$html  = '';
 $email = $request->customer->email;
 

sites/trunk/api.wordpress.org/public_html/dotorg/helpscout/profile.php

@@ -7 +7 @@
 // default empty output
 $html = '';
+$user = false;
 
 // Look up a user based on email address
@@ -62 +63 @@
 }
 
+// If this is related to a slack user, include the details of the slack account.
+if ( $user || preg_match( '/(\S+@chat.wordpress.org)/i', $request->ticket->subject, $m ) ) {
+
+    if ( $user ) {
+        $slack_user = $wpdb->get_row( $sql = $wpdb->prepare(
+            'SELECT * FROM slack_users WHERE user_id = %d',
+            $user->ID
+        ) );
+    } else {
+        $slack_user = $wpdb->get_row( $sql = $wpdb->prepare(
+            'SELECT * FROM slack_users WHERE profiledata LIKE %s',
+            '%' . $wpdb->esc_like( '"email":"' . $m[1] . '"' ) . '%',
+        ) );
+    }
+
+    if ( $slack_user ) {
+        $slack_data = json_decode( $slack_user->profiledata );
+        $html .= '<hr/>';
+        $html .= '<ul>';
+        $html .= '<li>Slack: <a href="https://wordpress.slack.com/archives/' . $slack_user->dm_id .  '">' . esc_html( $slack_data->profile->display_name_normalized ?? $slack_data->profile->display_name ) . '</a></li>';
+        $html .= '<li>Account ' . ( !empty( $slack_data->deleted ) ? 'Deactivated' : 'Enabled' ) . '</li>';
+        $html .= '<li>Last Updated: ' . gmdate( 'Y-m-d H:i:s', $slack_data->updated ) . '</li>';
+        $html .= '</ul>';
+    }
+}
+
 // response to HS is just HTML to display in the sidebar
 $response = array( 'html' => $html );