Add last-added to HKS.

diff --git a/bin/sync.pl b/bin/sync.pl
index bfa694a8093a5b292bee0634863b9e5758bee282..b8483eef69994a43a7534b560f24ead3230df67e 100644 (file)
--- 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
                        }
                }
        };