Add a line for "needed to secure qualifiction"/"needed to qualify". SQL cleanups...
authorSteinar H. Gunderson <sgunderson@bigfoot.com>
Sun, 20 Feb 2005 16:54:37 +0000 (16:54 +0000)
committerSteinar H. Gunderson <sgunderson@bigfoot.com>
Sun, 20 Feb 2005 16:54:37 +0000 (16:54 +0000)
bigscreen/fetch_group.cpp
bigscreen/group.h
bigscreen/groupscreen.cpp

index 62fbd50..7bca2f6 100644 (file)
@@ -6,7 +6,7 @@ FetchGroup::FetchGroup(unsigned tournament, unsigned round, unsigned parallel, G
 void FetchGroup::operator() (pqxx::transaction<> &t)
 {
        // note: this _will_ break if any song has more than one short title!
-       pqxx::result res( t.exec("SELECT round,parallel,position,playmode,difficulty,position,songnumber,player,nick,song,title,COALESCE(shorttitle,title) AS shorttitle,artist,chosen,score FROM roundparticipation NATURAL JOIN players NATURAL JOIN scores NATURAL LEFT JOIN songs NATURAL LEFT JOIN songshorttitles WHERE " 
+       pqxx::result res( t.exec("SELECT numqualifying,playmode,difficulty,position,songnumber,player,nick,song,title,COALESCE(shorttitle,title) AS shorttitle,artist,chosen,score FROM rounds NATURAL JOIN roundparticipation NATURAL JOIN players NATURAL JOIN scores NATURAL LEFT JOIN songs NATURAL LEFT JOIN songshorttitles WHERE " 
                "tournament=" + pqxx::to_string(tournament) + " AND " +
                "round=" + pqxx::to_string(round) + " AND " +
                "parallel=" + pqxx::to_string(parallel) + " " +
@@ -19,6 +19,8 @@ void FetchGroup::operator() (pqxx::transaction<> &t)
        // massage the data we get back into a Group object and children
        int curr_player = -1;
        for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
+               curr_group.num_qualifying = i["numqualifying"].as(curr_group.num_qualifying);
+               
                if (i["player"].as(curr_player) != curr_player) {
                        Player p;
 
index 35c89c4..312d71e 100644 (file)
@@ -24,6 +24,7 @@ struct Player {
 
 struct Group {
        unsigned tournament, round, parallel;
+       unsigned num_qualifying;
        std::vector<Player> players;
 };
 
index 7062812..d169bdb 100644 (file)
@@ -341,7 +341,7 @@ void GroupScreen::draw(unsigned char *buf)
                        unsigned y = 540;
                        
                        // see what score this player must beat to lead
-                       unsigned lead_beat = 0, win_beat = 0, qualify_beat = 0;
+                       unsigned lead_beat = 0, win_beat = 0;
                        for (unsigned i = 0; i < group.players.size(); ++i) {
                                if (group.players[i].id == next_player->id)
                                        continue;
@@ -357,13 +357,63 @@ void GroupScreen::draw(unsigned char *buf)
                                win_beat = std::max(win_beat, max_score[i]);
                        }
 
+                       /*
+                        * There's a somewhat subtle point here. Normally, what a player would be interested in
+                        * with regard to qualification would be a set of three values:
+                        *
+                        * 1. How much is the absolute minimum required to qualify, given that all others
+                        *    fail?
+                        * 2. How much will give a reasonable chance of qualifying, given the expected performance
+                        *    of all the others?
+                        * 3. How much will be enough to secure qualification, no matter what?
+                        *
+                        * Given perfect guessing, #2 would be "how much is needed to qualify"; however, it is
+                        * completely impossible to give an exact value for that, and we're not into the guessing
+                        * games. :-) #1 is often so low it's completely unrealistic (ie. far enough from #2 that
+                        * it's not interesting), but #3, the most conservative estimate, is often a good measure.
+                        * #3 is "how much is needed to _secure_ qualification", and that is usually what we
+                        * print out when it's possible.
+                        *
+                        * However, in a few situations, #1 and #3 will be the exact same value, from which it
+                        * follows (from the squeeze law, or just common sense :-) ) that #2 will be the same
+                        * value as #1 and #3. (This usually happens near or at the end of a group.) In that
+                        * case, we know the value we seek (ie. "how much is needed to qualify"), so we drop
+                        * the word "secure" and just print it as-is.
+                        *
+                        * To find #1 and #3, we sort and pick out the values we need to beat in the best and
+                        * the worst case.
+                        */
+                       int qualify_beat_worst_case = -1, qualify_beat_best_case = -1;
+
+                       if (group.num_qualifying > 0) {
+                               std::vector<unsigned> tmp;
+                               
+                               for (unsigned i = 0; i < group.players.size(); ++i) {
+                                       if (group.players[i].id == next_player->id)
+                                               continue;
+                                       tmp.push_back(max_score[i]);
+                               }
+                               std::sort(tmp.begin(), tmp.end());
+                               qualify_beat_worst_case = tmp[tmp.size() - group.num_qualifying];
+                               
+                               std::vector<unsigned> tmp2;
+                               for (unsigned i = 0; i < group.players.size(); ++i) {
+                                       if (group.players[i].id == next_player->id)
+                                               continue;
+                                       tmp2.push_back(min_score[i]);
+                               }
+
+                               std::sort(tmp2.begin(), tmp2.end());
+                               qualify_beat_best_case = tmp2[tmp2.size() - group.num_qualifying];
+                       }
+                       
                        // print out the lines we can attain
-                       if (next_player->total + max_score_this_song > lead_beat) {
+                       if (next_player->total + max_score_this_song > lead_beat && (lead_beat != win_beat)) {
                                int lead_need = std::max(lead_beat - next_player->total + 1, 0U);
                                
                                text = widestring("Needs to lead: ") + widestring(pqxx::to_string(lead_need));
-                               this_width = my_draw_text(text, NULL, 22.0);
-                               my_draw_text(text, buf, 22.0, 400 - this_width/2, y);
+                               this_width = my_draw_text(text, NULL, 18.0);
+                               my_draw_text(text, buf, 18.0, 400 - this_width/2, y);
 
                                y += 30;
                        }
@@ -373,8 +423,23 @@ void GroupScreen::draw(unsigned char *buf)
                                
                                text = widestring("Needs to win: ") + widestring(pqxx::to_string(win_need));
 
-                               this_width = my_draw_text(text, NULL, 22.0);
-                               my_draw_text(text, buf, 22.0, 400 - this_width/2, y);
+                               this_width = my_draw_text(text, NULL, 18.0);
+                               my_draw_text(text, buf, 18.0, 400 - this_width/2, y);
+
+                               y += 30;
+                       }
+
+                       if (next_player->total + max_score_this_song > qualify_beat_worst_case) {
+                               int qual_need = std::max(qualify_beat_worst_case - next_player->total + 1, 0U);
+                               
+                               if (qualify_beat_worst_case == qualify_beat_best_case) {
+                                       text = widestring("Needs to qualify: ") + widestring(pqxx::to_string(qual_need));
+                               } else {
+                                       text = widestring("Needs to secure qualification: ") + widestring(pqxx::to_string(qual_need));
+                               }
+                               
+                               this_width = my_draw_text(text, NULL, 18.0);
+                               my_draw_text(text, buf, 18.0, 400 - this_width/2, y);
 
                                y += 30;
                        }