From ab66bb8a2f4b3b93a00cb370aaefb698742e32b8 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Thu, 11 Apr 2024 23:16:59 +0200
Subject: [PATCH] Add last-added to HKS.

---
 bin/sync.pl | 17 +++++++++++------
 1 file changed, 11 insertions(+), 6 deletions(-)

diff --git a/bin/sync.pl b/bin/sync.pl
index bfa694a..b8483ee 100644
--- a/bin/sync.pl
+++ b/bin/sync.pl
@@ -711,7 +711,7 @@ sub run {
 	}
 	# LOCAL CHANGE FOR HKS 2024
 	# Piece together HKS users.
-	$q = $dbh->prepare('SELECT userid FROM current_reactions WHERE channel=? and ts=? and reaction=?;');
+	$q = $dbh->prepare('SELECT userid, TO_CHAR(last_added, \'YYYY-mm-dd HH24:MI\') AS last_added FROM current_reactions_with_ts WHERE channel=? and ts=? and reaction=? ORDER BY current_reactions_with_ts.last_added;');
 	$q->execute('C06C34L2R6G', '1712686401.430939', 'heart');  # #hks-2024-05-04
 	my @hks_runners = ();
 	while (my $ref = $q->fetchrow_hashref) {
@@ -730,11 +730,16 @@ sub run {
 			$slack_userid_to_slack_name{$userid} = $slack_name;
 		}
 		my $name = $slack_userid_to_real_name{$userid} // $slack_userid_to_slack_name{$userid} // $userid;
-		push @hks_runners, { values => [{ userEnteredValue => { stringValue => $name } }] };
+		push @hks_runners, {
+			values => [
+				{ userEnteredValue => { stringValue => $name } },
+				{ userEnteredValue => { stringValue => $ref->{'last_added'} } },
+			]
+		};
 	}
-	push @hks_runners, { values => [{ userEnteredValue => { stringValue => '' } }] };
-	push @hks_runners, { values => [{ userEnteredValue => { stringValue => '' } }] };
-	push @hks_runners, { values => [{ userEnteredValue => { stringValue => '' } }] };
+	push @hks_runners, { values => [{ userEnteredValue => { stringValue => '' } }, { userEnteredValue => { stringValue => '' } }] };
+	push @hks_runners, { values => [{ userEnteredValue => { stringValue => '' } }, { userEnteredValue => { stringValue => '' } }] };
+	push @hks_runners, { values => [{ userEnteredValue => { stringValue => '' } }, { userEnteredValue => { stringValue => '' } }] };
 	# END LOCAL CHANGE FOR HKS 2024
 	if (scalar @slack_mapping_updates > 0) {
 		my $update = {
@@ -875,7 +880,7 @@ sub run {
 				startRowIndex => 1,
 				endRowIndex => 1 + scalar @hks_runners,
 				startColumnIndex => 0,
-				endColumnIndex => 1
+				endColumnIndex => 2
 			}
 		}
 	};
-- 
2.39.2