1 #include <QMediaPlayer>
3 #include <QApplication>
5 #include <QVideoWidget>
7 #include <QInputDialog>
14 #include "mainwindow.h"
15 #include "ui_mainwindow.h"
22 string format_timestamp(uint64_t pos)
32 snprintf(buf, sizeof(buf), "%d:%02d:%02d.%03d", hour, min, sec, ms);
36 MainWindow::MainWindow(EventsModel *events, PlayersModel *players) : events(events), players(players)
38 video = new QMediaPlayer;
39 //video->setSource(QUrl::fromLocalFile("/home/sesse/dev/stats/ultimate.mkv"));
40 video->setSource(QUrl::fromLocalFile("/home/sesse/dev/stats/ultimate-prores.mkv"));
43 ui = new Ui::MainWindow;
46 ui->event_view->setModel(events);
47 connect(ui->event_view->selectionModel(), &QItemSelectionModel::currentRowChanged,
48 [this, events](const QModelIndex ¤t, const QModelIndex &previous) {
49 uint64_t t = events->get_time(current.row());
50 if (t != video->position()) {
51 video->setPosition(events->get_time(current.row()));
53 // Selection could have changed, so we still need to update.
54 // (Just calling setPosition() would not give us the signal
56 update_ui_from_time(t);
60 ui->player_view->setModel(players);
61 ui->player_view->setColumnWidth(0, 30);
62 ui->player_view->setColumnWidth(1, 20);
63 ui->player_view->horizontalHeader()->setStretchLastSection(true);
65 connect(video, &QMediaPlayer::positionChanged, [this](uint64_t pos) {
66 position_changed(pos);
69 video->setVideoOutput(ui->video);
71 // It's not really clear whether PgUp should be forwards or backwards,
72 // but mpv does at least up = forwards, so that's probably standard.
73 QShortcut *pgdown = new QShortcut(QKeySequence(Qt::Key_PageDown), this);
74 connect(pgdown, &QShortcut::activated, [this]() { seek(-120000); });
75 QShortcut *pgup = new QShortcut(QKeySequence(Qt::Key_PageUp), this);
76 connect(pgup, &QShortcut::activated, [this]() { seek(120000); });
78 connect(ui->minus10s, &QPushButton::clicked, [this]() { seek(-10000); });
79 connect(ui->plus10s, &QPushButton::clicked, [this]() { seek(10000); });
81 connect(ui->minus2s, &QPushButton::clicked, [this]() { seek(-2000); });
82 connect(ui->plus2s, &QPushButton::clicked, [this]() { seek(2000); });
84 // TODO: Would be nice to actually have a frame...
85 connect(ui->minus1f, &QPushButton::clicked, [this]() { seek(-20); });
86 connect(ui->plus1f, &QPushButton::clicked, [this]() { seek(20); });
88 connect(ui->play_pause, &QPushButton::clicked, [this]() {
91 ui->play_pause->setText("Play (space)");
93 video->setPlaybackRate(1.0);
95 ui->play_pause->setText("Pause (space)");
99 // Needs to be set anew when we modify setText(), evidently.
100 ui->play_pause->setShortcut(QCoreApplication::translate("MainWindow", "Space", nullptr));
103 connect(ui->player_1, &QPushButton::clicked, [this]() { insert_player_event(0); });
104 connect(ui->player_2, &QPushButton::clicked, [this]() { insert_player_event(1); });
105 connect(ui->player_3, &QPushButton::clicked, [this]() { insert_player_event(2); });
106 connect(ui->player_4, &QPushButton::clicked, [this]() { insert_player_event(3); });
107 connect(ui->player_5, &QPushButton::clicked, [this]() { insert_player_event(4); });
108 connect(ui->player_6, &QPushButton::clicked, [this]() { insert_player_event(5); });
109 connect(ui->player_7, &QPushButton::clicked, [this]() { insert_player_event(6); });
112 connect(ui->offense_label, &ClickableLabel::clicked, [this]() { insert_noplayer_event("set_offense"); });
113 connect(ui->catch_, &QPushButton::clicked, [this]() { set_current_event_type("catch"); });
114 connect(ui->throwaway, &QPushButton::clicked, [this, events]() {
115 EventsModel::Status s = events->get_status_at(video->position());
116 if (s.attack_state == EventsModel::Status::DEFENSE && s.pull_state == EventsModel::Status::PULL_IN_AIR) {
117 insert_noplayer_event("pull_oob");
119 set_current_event_type("throwaway");
122 connect(ui->drop, &QPushButton::clicked, [this]() { set_current_event_type("drop"); });
123 connect(ui->goal, &QPushButton::clicked, [this]() { set_current_event_type("goal"); });
124 connect(ui->offensive_soft_plus, &QPushButton::clicked, [this]() { set_current_event_type("offensive_soft_plus"); });
125 connect(ui->offensive_soft_minus, &QPushButton::clicked, [this]() { set_current_event_type("offensive_soft_minus"); });
126 connect(ui->pull, &QPushButton::clicked, [this, events]() {
127 EventsModel::Status s = events->get_status_at(video->position());
128 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
129 set_current_event_type("pull");
130 } else if (EventsModel::Status::PULL_IN_AIR) {
131 insert_noplayer_event("pull_landed");
135 // Defensive events (TODO add more)
136 connect(ui->interception, &QPushButton::clicked, [this]() { set_current_event_type("interception"); });
137 connect(ui->defense_label, &ClickableLabel::clicked, [this]() { insert_noplayer_event("set_defense"); });
138 connect(ui->their_throwaway, &QPushButton::clicked, [this]() { insert_noplayer_event("their_throwaway"); });
139 connect(ui->their_goal, &QPushButton::clicked, [this]() { insert_noplayer_event("their_goal"); });
140 connect(ui->their_pull, &QPushButton::clicked, [this, events]() {
141 EventsModel::Status s = events->get_status_at(video->position());
142 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
143 insert_noplayer_event("their_pull");
146 connect(ui->our_defense, &QPushButton::clicked, [this]() { set_current_event_type("defense"); });
147 connect(ui->defensive_soft_plus, &QPushButton::clicked, [this]() { set_current_event_type("defensive_soft_plus"); });
148 connect(ui->defensive_soft_minus, &QPushButton::clicked, [this]() { set_current_event_type("defensive_soft_minus"); });
151 connect(ui->substitution, &QPushButton::clicked, [this]() { make_substitution(); });
152 connect(ui->stoppage, &QPushButton::clicked, [this, events]() {
153 EventsModel::Status s = events->get_status_at(video->position());
155 insert_noplayer_event("restart");
157 insert_noplayer_event("stoppage");
160 connect(ui->unknown, &QPushButton::clicked, [this]() { insert_noplayer_event("unknown"); });
162 QShortcut *key_delete = new QShortcut(QKeySequence(Qt::Key_Delete), this);
163 connect(key_delete, &QShortcut::activated, [this]() { ui->delete_->animateClick(); });
164 connect(ui->delete_, &QPushButton::clicked, [this]() { delete_current_event(); });
167 void MainWindow::position_changed(uint64_t pos)
169 ui->timestamp->setText(QString::fromUtf8(format_timestamp(pos)));
171 video->setPosition(*buffered_seek);
172 buffered_seek.reset();
175 video->pause(); // We only played to get a picture.
178 QModelIndex row = events->get_last_event_qt(video->position());
179 ui->event_view->scrollTo(row, QAbstractItemView::PositionAtCenter);
181 update_ui_from_time(pos);
184 void MainWindow::seek(int64_t delta_ms)
186 int64_t current_pos = buffered_seek ? *buffered_seek : video->position();
187 uint64_t pos = max<int64_t>(current_pos + delta_ms, 0);
190 video->setPlaybackRate(0.01);
191 video->play(); // Or Qt won't show the seek.
195 void MainWindow::insert_player_event(int button_id)
197 uint64_t t = video->position();
198 vector<int> team = events->sort_team(events->get_team_at(t));
199 if (button_id >= team.size()) {
202 int player_id = team[button_id];
204 EventsModel::Status s = events->get_status_at(t);
206 ui->event_view->selectionModel()->blockSignals(true);
207 if (s.attack_state == EventsModel::Status::OFFENSE) {
208 // TODO: Perhaps not if that player already did the last catch?
209 ui->event_view->selectRow(events->insert_event(t, player_id, "catch"));
211 ui->event_view->selectRow(events->insert_event(t, player_id));
213 ui->event_view->selectionModel()->blockSignals(false);
215 update_ui_from_time(t);
218 void MainWindow::insert_noplayer_event(const string &type)
220 uint64_t t = video->position();
222 ui->event_view->selectionModel()->blockSignals(true);
223 ui->event_view->selectRow(events->insert_event(t, nullopt, type));
224 ui->event_view->selectionModel()->blockSignals(false);
226 update_ui_from_time(t);
229 void MainWindow::set_current_event_type(const string &type)
231 QItemSelectionModel *select = ui->event_view->selectionModel();
232 if (!select->hasSelection()) {
235 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
236 events->set_event_type(row, type);
237 update_ui_from_time(video->position());
240 void MainWindow::delete_current_event()
242 QItemSelectionModel *select = ui->event_view->selectionModel();
243 if (!select->hasSelection()) {
246 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
247 ui->event_view->selectionModel()->blockSignals(true);
248 events->delete_event(row);
249 ui->event_view->selectionModel()->blockSignals(false);
250 update_ui_from_time(video->position());
253 void MainWindow::make_substitution()
255 QItemSelectionModel *select = ui->player_view->selectionModel();
257 for (QModelIndex row : select->selectedRows()) {
258 new_team.insert(players->get_player_id(row.row()));
260 events->set_team_at(video->position(), new_team);
263 void MainWindow::update_ui_from_time(uint64_t t)
266 update_player_buttons(t);
267 update_action_buttons(t);
270 void MainWindow::update_status(uint64_t t)
272 EventsModel::Status s = events->get_status_at(t);
274 const char *offense = "not started";
275 if (s.attack_state == EventsModel::Status::OFFENSE) {
277 } else if (s.attack_state == EventsModel::Status::DEFENSE) {
281 snprintf(buf, sizeof(buf), "%d–%d | %s | %d passes, %d sec possession",
282 s.our_score, s.their_score, offense, s.num_passes, s.possession_sec);
283 if (s.stoppage_sec > 0) {
285 snprintf(buf2, sizeof(buf2), "%s (plus %d sec stoppage)", buf, s.stoppage_sec);
286 ui->status->setText(buf2);
288 ui->status->setText(buf);
292 void MainWindow::update_player_buttons(uint64_t t)
294 QPushButton *buttons[] = {
303 const char shortcuts[] = "qweasdf";
305 for (int player_id : events->sort_team(events->get_team_at(t))) {
306 QPushButton *btn = buttons[num_players];
307 string label = players->get_player_name_by_id(player_id) + " (&" + shortcuts[num_players] + ")";
308 char shortcut[2] = "";
309 shortcut[0] = toupper(shortcuts[num_players]);
310 btn->setText(QString::fromUtf8(label));
311 btn->setShortcut(QCoreApplication::translate("MainWindow", shortcut, nullptr));
312 btn->setEnabled(true);
313 if (++num_players == 7) {
317 for (int i = num_players; i < 7; ++i) {
318 QPushButton *btn = buttons[i];
319 btn->setText("No player");
320 btn->setEnabled(false);
324 void MainWindow::update_action_buttons(uint64_t t)
326 EventsModel::Status s = events->get_status_at(t);
328 bool has_selection = false;
329 bool has_selection_with_player = false;
331 QItemSelectionModel *select = ui->event_view->selectionModel();
332 if (select->hasSelection()) {
333 has_selection = true;
334 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
335 has_selection_with_player = events->get_player_id(row).has_value();
337 ui->delete_->setEnabled(has_selection);
340 ui->stoppage->setText("Restart (&v)");
341 ui->stoppage->setShortcut(QCoreApplication::translate("MainWindow", "V", nullptr));
342 ui->catch_->setEnabled(false);
343 ui->throwaway->setEnabled(false);
344 ui->drop->setEnabled(false);
345 ui->goal->setEnabled(false);
346 ui->offensive_soft_plus->setEnabled(false);
347 ui->offensive_soft_minus->setEnabled(false);
348 ui->pull->setEnabled(false);
349 ui->interception->setEnabled(false);
350 ui->their_throwaway->setEnabled(false);
351 ui->our_defense->setEnabled(false);
352 ui->their_goal->setEnabled(false);
353 ui->defensive_soft_plus->setEnabled(false);
354 ui->defensive_soft_minus->setEnabled(false);
355 ui->their_pull->setEnabled(false);
358 ui->stoppage->setText("Stoppage (&v)");
359 ui->stoppage->setShortcut(QCoreApplication::translate("MainWindow", "V", nullptr));
362 // Defaults for pull-related buttons.
363 ui->pull->setText("Pull (&p)");
364 ui->their_pull->setText("Their pull (&p)");
365 ui->pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
366 ui->their_pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
367 ui->throwaway->setText("Throwaway (&t)");
368 ui->throwaway->setShortcut(QCoreApplication::translate("MainWindow", "T", nullptr));
370 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
371 ui->pull->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
372 ui->their_pull->setEnabled(s.attack_state == EventsModel::Status::OFFENSE);
374 ui->catch_->setEnabled(false);
375 ui->throwaway->setEnabled(false);
376 ui->drop->setEnabled(false);
377 ui->goal->setEnabled(false);
378 ui->offensive_soft_plus->setEnabled(false);
379 ui->offensive_soft_minus->setEnabled(false);
380 ui->interception->setEnabled(false);
381 ui->their_throwaway->setEnabled(false);
382 ui->our_defense->setEnabled(false);
383 ui->their_goal->setEnabled(false);
384 ui->defensive_soft_plus->setEnabled(false);
385 ui->defensive_soft_minus->setEnabled(false);
388 if (s.pull_state == EventsModel::Status::PULL_IN_AIR) {
389 if (s.attack_state == EventsModel::Status::DEFENSE) {
390 ui->pull->setText("Pull landed (&p)");
391 ui->pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
392 ui->pull->setEnabled(true);
394 ui->throwaway->setText("Pull OOB (&t)");
395 ui->throwaway->setShortcut(QCoreApplication::translate("MainWindow", "T", nullptr));
396 ui->throwaway->setEnabled(true);
398 ui->pull->setEnabled(false);
399 ui->throwaway->setEnabled(false);
401 ui->their_pull->setEnabled(false); // We don't track their pull landings; only by means of catch etc.
403 ui->catch_->setEnabled(false);
404 ui->drop->setEnabled(false);
405 ui->goal->setEnabled(false);
406 ui->offensive_soft_plus->setEnabled(false);
407 ui->offensive_soft_minus->setEnabled(false);
408 ui->interception->setEnabled(false);
409 ui->their_throwaway->setEnabled(false);
410 ui->our_defense->setEnabled(false);
411 ui->their_goal->setEnabled(false);
412 ui->defensive_soft_plus->setEnabled(false);
413 ui->defensive_soft_minus->setEnabled(false);
417 ui->catch_->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
418 ui->throwaway->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
419 ui->drop->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
420 ui->goal->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
421 ui->offensive_soft_plus->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
422 ui->offensive_soft_minus->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
423 ui->pull->setEnabled(false);
425 ui->interception->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
426 ui->their_throwaway->setEnabled(s.attack_state == EventsModel::Status::DEFENSE);
427 ui->our_defense->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
428 ui->their_goal->setEnabled(s.attack_state == EventsModel::Status::DEFENSE);
429 ui->defensive_soft_plus->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
430 ui->defensive_soft_minus->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
431 ui->their_pull->setEnabled(false);
434 sqlite3 *open_db(const char *filename)
437 int ret = sqlite3_open(filename, &db);
438 if (ret != SQLITE_OK) {
439 fprintf(stderr, "%s: %s\n", filename, sqlite3_errmsg(db));
444 CREATE TABLE IF NOT EXISTS player (player INTEGER PRIMARY KEY, number VARCHAR, name VARCHAR, gender VARCHAR(1));
445 )", nullptr, nullptr, nullptr); // Ignore errors.
448 CREATE TABLE IF NOT EXISTS match (match INTEGER PRIMARY KEY, description VARCHAR);
449 )", nullptr, nullptr, nullptr); // Ignore errors.
452 CREATE TABLE IF NOT EXISTS event (event INTEGER PRIMARY KEY, match INTEGER, t INTEGER, player INTEGER, type VARCHAR, FOREIGN KEY (player) REFERENCES player(player), FOREIGN KEY (match) REFERENCES match (match));
453 )", nullptr, nullptr, nullptr); // Ignore errors.
455 sqlite3_exec(db, "PRAGMA journal_mode=WAL", nullptr, nullptr, nullptr); // Ignore errors.
456 sqlite3_exec(db, "PRAGMA synchronous=NORMAL", nullptr, nullptr, nullptr); // Ignore errors.
457 sqlite3_exec(db, "PRAGMA foreign_keys=ON", nullptr, nullptr, nullptr); // Ignore errors.
461 int get_match_id(sqlite3 *db, QWidget *parent, int requested_match)
465 bool requested_match_ok = false;
467 // Read the list of matches already in the database.
469 int ret = sqlite3_prepare_v2(db, "SELECT match, description FROM match ORDER BY match", -1, &stmt, 0);
470 if (ret != SQLITE_OK) {
471 fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
475 ret = sqlite3_step(stmt);
476 if (ret == SQLITE_ROW) {
478 snprintf(buf, sizeof(buf), "%s (%d)", sqlite3_column_text(stmt, 1), sqlite3_column_int(stmt, 0));
479 ids.push_back(sqlite3_column_int(stmt, 0));
480 if (ids.back() == requested_match) {
481 requested_match_ok = true;
483 items.push_back(buf);
484 } else if (ret == SQLITE_DONE) {
487 fprintf(stderr, "SELECT step: %s\n", sqlite3_errmsg(db));
491 ret = sqlite3_finalize(stmt);
492 if (ret != SQLITE_OK) {
493 fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
496 items.push_back("Add new…");
498 if (requested_match_ok) {
499 return requested_match;
504 QInputDialog dialog(parent, Qt::WindowFlags());
505 dialog.setWindowTitle("Open game");
506 dialog.setLabelText("Choose game to analyze:");
507 dialog.setComboBoxItems(items);
508 dialog.setTextValue(items[items.size() - 2]);
509 dialog.setOption(QInputDialog::UseListViewForComboBoxItems, true);
510 if (!dialog.exec()) {
513 chosen_str = dialog.textValue();
516 for (unsigned i = 0; i < ids.size(); ++i) {
517 if (chosen_str == items[i]) {
522 // Must be a new game. Get its name and insert it into the database.
524 QString new_game_str = QInputDialog::getText(parent, "New game", "Choose name for new game:", QLineEdit::Normal, "", &ok);
525 if (!ok || new_game_str.isEmpty()) {
529 // Insert the new row into the database.
530 ret = sqlite3_prepare_v2(db, "INSERT INTO match (description) VALUES (?)", -1, &stmt, 0);
531 if (ret != SQLITE_OK) {
532 fprintf(stderr, "INSERT prepare: %s\n", sqlite3_errmsg(db));
536 QByteArray new_game_utf8 = new_game_str.toUtf8();
537 sqlite3_bind_text(stmt, 1, (const char *)new_game_utf8.data(), new_game_utf8.size(), SQLITE_STATIC);
539 ret = sqlite3_step(stmt);
540 if (ret == SQLITE_ROW) {
541 fprintf(stderr, "INSERT step: %s\n", sqlite3_errmsg(db));
545 ret = sqlite3_finalize(stmt);
546 if (ret != SQLITE_OK) {
547 fprintf(stderr, "INSERT finalize: %s\n", sqlite3_errmsg(db));
551 return sqlite3_last_insert_rowid(db);
554 int main(int argc, char *argv[])
556 QApplication app(argc, argv);
557 sqlite3 *db = open_db("ultimate.db");
559 // TODO: do this on-demand instead, from a menu
560 export_to_json(db, "ultimate.json");
562 int requested_match = -1;
564 requested_match = atoi(argv[1]);
567 int match_id = get_match_id(db, nullptr, requested_match);
568 if (match_id <= 0) { // Cancel.
572 MainWindow mainWindow(new EventsModel(db, match_id), new PlayersModel(db));
573 mainWindow.resize(QSize(1280, 720));