# HG changeset patch # User Matti Hamalainen # Date 1385302258 -7200 # Node ID 46138f8478e569c46ae90157b16f8c8b08baa87c # Parent feed47a72df43e6abdf4c61ece8760441912c0e1 Work on votekey management. diff -r feed47a72df4 -r 46138f8478e5 admajax.php --- a/admajax.php Sun Nov 24 05:18:34 2013 +0200 +++ b/admajax.php Sun Nov 24 16:10:58 2013 +0200 @@ -266,35 +266,69 @@ break; case "voters": - $sqlJoins = ""; + // List of votekeys + echo + "
\n". + "Generate votekeys\n". + "Printable key list\n". + "
\n"; + switch (stGetSetting("voteKeyMode")) { case VOTE_FREELY: - break; + case VOTE_ACTIVATE: + $sql = "SELECT * FROM votekeys ORDER BY votekeys.id ASC"; - case VOTE_ACTIVATE: + $keyLen = stGetSetting("userKeyLength"); + $index = 0; + echo "\n"; + foreach (stExecSQL($sql) as $item) + { + if ($index == 0) + echo "\n"; + + // This funny code is to ensure that the cells are of uniform width + printf("\n", + $item["id"], + str_repeat(" ", $keyLen - strlen($item["key"])).$item["key"]); + + if ($index++ >= 5) + { + echo "\n"; + $index = 0; + } + } + if ($index > 0) + echo "\n"; + + echo "
%03d : ". + "%s
\n"; break; case VOTE_ASSIGN: - $sqlJoins = "LEFT JOIN attendees ON votekeys.voter_id=attendees.id "; + $sql = "SELECT * FROM votekeys ". + "LEFT JOIN attendees ON votekeys.voter_id=attendees.id ". + "ORDER BY votekeys.id ASC"; + + echo + "\n". + " \n". + " \n". + " \n". +// " \n". + " \n". + " \n"; + + $row = 0; + foreach (stExecSQL($sql) as $item) + { + print_r($item); + } + + echo + "
NameGroupsE-mailKey
\n"; break; } - $sql = "SELECT * FROM votekeys ".$sqlJoins."ORDER BY votekeys.id ASC"; - - // List of votekeys - echo - "

Printable key list

\n". - "\n". - " \n". - " \n". - " \n". - " \n". - " \n". - " \n"; - $row = 0; - - echo - "
NameGroupsE-mailKey
\n"; break; case "compos":