<commit_before><?php
require_once(__DIR__ . "/inc/header.php");
$db = get_database();
$sql = "SELECT
            `Person`.`first_name`,
            `Person`.`last_name`,
            `Person`.`email`,
            `CabinetMember`.`position`
        FROM
            `CabinetMember`
                LEFT JOIN `Person` ON
                    `CabinetMember`.`username` = `Person`.`username`";
$cabinet_result = $db->query($sql);
?>
<table class="table table-hover table-striped">
    <thead>
        <tr>
            <th>Position</th>
            <th>Name</th>
            <th>Email</th>
        </tr>
    </thead>
    <tbody>
        <?php while ($cabinet_row = $cabinet_result->fetch_assoc()): ?>
            <tr>
                <td><?=$cabinet_row["position"]?></td>
                <td><?=$cabinet_row["first_name"]?> <?=$cabinet_row["last_name"]?></td>
                <td>
                    <a href="mailto:<?=$cabinet_row["email"]?>">
                        <?=$cabinet_row["email"]?>
                    </a>
                </td>
            </tr>
        <?php endwhile; ?>
    </tbody>
</table>

<?php
require_once(__DIR__ . "/inc/footer.php");
?>
<commit_msg>Sort cabinet members by rank and make table smaller<commit_after><?php
require_once(__DIR__ . "/inc/header.php");
$db = get_database();
$sql = "SELECT
            `Person`.`first_name`,
            `Person`.`last_name`,
            `Person`.`email`,
            `CabinetMember`.`position`
        FROM
            `CabinetMember`
                LEFT JOIN `Person` ON
                    `CabinetMember`.`username` = `Person`.`username`
        ORDER BY
            `CabinetMember`.`rank` ASC,
            `Person`.`last_name` ASC,
            `Person`.`first_name` ASC";
$cabinet_result = $db->query($sql);
?>
<div class="row">
    <div class="col-xs-offset-2 col-xs-8">
        <table class="table table-hover table-striped">
            <thead>
                <tr>
                    <th>Position</th>
                    <th>Name</th>
                    <th>Email</th>
                </tr>
            </thead>
            <tbody>
                <?php while ($cabinet_row = $cabinet_result->fetch_assoc()): ?>
                    <tr>
                        <td><?=$cabinet_row["position"]?></td>
                        <td><?=$cabinet_row["first_name"]?> <?=$cabinet_row["last_name"]?></td>
                        <td>
                            <a href="mailto:<?=$cabinet_row["email"]?>">
                                <?=$cabinet_row["email"]?>
                            </a>
                        </td>
                    </tr>
                <?php endwhile; ?>
            </tbody>
        </table>
    </div>
</div>

<?php
require_once(__DIR__ . "/inc/footer.php");
?>

{'fraction_non_alphanumeric': 0.1755780346820809, 'fraction_numerical': 0.000722543352601156, 'mean_word_length': 1.4375, 'pattern_counts': {'":': 0, '<': 73, '<?xml version=': 0, '>': 77, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '558101', 'n_tokens_mistral': 872, 'n_tokens_neox': 840, 'n_words': 133}