1 #include <QMediaPlayer>
3 #include <QApplication>
7 #include <QInputDialog>
15 #include "mainwindow.h"
16 #include "ui_mainwindow.h"
19 #include "formations.h"
21 #include "video_widget.h"
25 string format_timestamp(uint64_t pos)
35 snprintf(buf, sizeof(buf), "%d:%02d:%02d.%03d", hour, min, sec, ms);
39 string get_video_filename(sqlite3 *db, int match_id)
43 int ret = sqlite3_prepare_v2(db, "SELECT video_filename FROM match WHERE match=?", -1, &stmt, 0);
44 if (ret != SQLITE_OK) {
45 fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
49 sqlite3_bind_int64(stmt, 1, match_id);
51 ret = sqlite3_step(stmt);
52 if (ret != SQLITE_ROW) {
53 fprintf(stderr, "SELECT step: %s\n", sqlite3_errmsg(db));
57 if (sqlite3_column_type(stmt, 0) != SQLITE_TEXT) {
60 string filename = (const char *)sqlite3_column_text(stmt, 0);
62 ret = sqlite3_finalize(stmt);
63 if (ret != SQLITE_OK) {
64 fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
70 void save_video_filename(sqlite3 *db, int match_id, const string &filename)
74 int ret = sqlite3_prepare_v2(db, "UPDATE match SET video_filename=? WHERE match=?", -1, &stmt, 0);
75 if (ret != SQLITE_OK) {
76 fprintf(stderr, "SELECT prepare: %s\n", sqlite3_errmsg(db));
80 sqlite3_bind_text(stmt, 1, filename.data(), filename.size(), SQLITE_STATIC);
81 sqlite3_bind_int64(stmt, 2, match_id);
83 ret = sqlite3_step(stmt);
84 if (ret == SQLITE_ROW) {
85 fprintf(stderr, "INSERT step: %s\n", sqlite3_errmsg(db));
89 ret = sqlite3_finalize(stmt);
90 if (ret != SQLITE_OK) {
91 fprintf(stderr, "SELECT finalize: %s\n", sqlite3_errmsg(db));
96 MainWindow::MainWindow(EventsModel *events, PlayersModel *players,
97 FormationsModel *offensive_formations, FormationsModel *defensive_formations,
98 sqlite3 *db, int match_id)
99 : events(events), players(players), offensive_formations(offensive_formations), defensive_formations(defensive_formations), db(db), match_id(match_id)
101 ui = new Ui::MainWindow;
104 string filename = get_video_filename(db, match_id);
105 bool need_save_filename = false;
107 if (!filename.empty() && ui->video->open(filename.c_str())) {
111 // TODO: Probably relativize this path, so that we can move the .db
112 // more easily with the videos.
113 filename = QFileDialog::getOpenFileName(this, "Open video").toUtf8();
114 need_save_filename = true;
116 if (need_save_filename) {
117 save_video_filename(db, match_id, filename);
121 ui->event_view->setModel(events);
122 ui->event_view->setColumnWidth(1, 150);
123 ui->event_view->setColumnWidth(2, 150);
124 connect(ui->event_view->selectionModel(), &QItemSelectionModel::currentRowChanged,
125 [this, events](const QModelIndex ¤t, const QModelIndex &previous) {
126 uint64_t t = events->get_time(current.row());
127 if (t != ui->video->get_position()) {
128 ui->video->seek_absolute(events->get_time(current.row()));
130 // Selection could have changed, so we still need to update.
131 // (Just calling setPosition() would not give us the signal
133 update_ui_from_time(t);
137 ui->player_view->setModel(players);
138 ui->player_view->setColumnWidth(0, 30);
139 ui->player_view->setColumnWidth(1, 20);
140 ui->player_view->horizontalHeader()->setStretchLastSection(true);
142 auto formation_changed = [this](const QModelIndex ¤t, const QModelIndex &previous) {
143 QTimer::singleShot(1, [=]{ // The selection is wrong until the callback actually returns.
144 update_action_buttons(ui->video->get_position());
147 ui->offensive_formation_view->setModel(offensive_formations);
148 ui->defensive_formation_view->setModel(defensive_formations);
149 connect(ui->offensive_formation_view->selectionModel(), &QItemSelectionModel::currentRowChanged, formation_changed);
150 connect(ui->defensive_formation_view->selectionModel(), &QItemSelectionModel::currentRowChanged, formation_changed);
151 connect(ui->offensive_formation_view, &QListView::doubleClicked, [this](const QModelIndex &index) {
152 formation_double_clicked(true, index.row());
154 connect(ui->defensive_formation_view, &QListView::doubleClicked, [this](const QModelIndex &index) {
155 formation_double_clicked(false, index.row());
158 connect(ui->video, &VideoWidget::position_changed, [this](uint64_t pos) {
159 position_changed(pos);
162 // It's not really clear whether PgUp should be forwards or backwards,
163 // but mpv does at least up = forwards, so that's probably standard.
164 QShortcut *pgdown = new QShortcut(QKeySequence(Qt::Key_PageDown), this);
165 connect(pgdown, &QShortcut::activated, [this]() { ui->video->seek(-120000); });
166 QShortcut *pgup = new QShortcut(QKeySequence(Qt::Key_PageUp), this);
167 connect(pgup, &QShortcut::activated, [this]() { ui->video->seek(120000); });
169 connect(ui->minus10s, &QPushButton::clicked, [this]() { ui->video->seek(-10000); });
170 connect(ui->plus10s, &QPushButton::clicked, [this]() { ui->video->seek(10000); });
172 connect(ui->minus2s, &QPushButton::clicked, [this]() { ui->video->seek(-2000); });
173 connect(ui->plus2s, &QPushButton::clicked, [this]() { ui->video->seek(2000); });
174 connect(ui->video, &VideoWidget::mouse_back_clicked, [this]() { ui->video->seek(-2000); });
175 connect(ui->video, &VideoWidget::mouse_forward_clicked, [this]() { ui->video->seek(2000); });
177 connect(ui->minus1f, &QPushButton::clicked, [this]() { ui->video->seek_frames(-1); });
178 connect(ui->plus1f, &QPushButton::clicked, [this]() { ui->video->seek_frames(1); });
180 connect(ui->play_pause, &QPushButton::clicked, [this]() {
183 ui->play_pause->setText("Play (space)");
186 ui->play_pause->setText("Pause (space)");
190 // Needs to be set anew when we modify setText(), evidently.
191 ui->play_pause->setShortcut(QCoreApplication::translate("MainWindow", "Space", nullptr));
194 connect(ui->player_1, &QPushButton::clicked, [this]() { insert_player_event(0); });
195 connect(ui->player_2, &QPushButton::clicked, [this]() { insert_player_event(1); });
196 connect(ui->player_3, &QPushButton::clicked, [this]() { insert_player_event(2); });
197 connect(ui->player_4, &QPushButton::clicked, [this]() { insert_player_event(3); });
198 connect(ui->player_5, &QPushButton::clicked, [this]() { insert_player_event(4); });
199 connect(ui->player_6, &QPushButton::clicked, [this]() { insert_player_event(5); });
200 connect(ui->player_7, &QPushButton::clicked, [this]() { insert_player_event(6); });
203 connect(ui->offense_label, &ClickableLabel::clicked, [this]() { insert_noplayer_event("set_offense"); });
204 connect(ui->catch_, &QPushButton::clicked, [this]() { set_current_event_type("catch"); });
205 connect(ui->throwaway, &QPushButton::clicked, [this, events]() {
206 EventsModel::Status s = events->get_status_at(ui->video->get_position());
207 if (s.attack_state == EventsModel::Status::DEFENSE && s.pull_state == EventsModel::Status::PULL_IN_AIR) {
208 insert_noplayer_event("pull_oob");
210 set_current_event_type("throwaway");
213 connect(ui->drop, &QPushButton::clicked, [this]() { set_current_event_type("drop"); });
214 connect(ui->goal, &QPushButton::clicked, [this]() { set_current_event_type("goal"); });
215 connect(ui->offensive_soft_plus, &QPushButton::clicked, [this]() { set_current_event_type("offensive_soft_plus"); });
216 connect(ui->offensive_soft_minus, &QPushButton::clicked, [this]() { set_current_event_type("offensive_soft_minus"); });
217 connect(ui->pull_or_was_d, &QPushButton::clicked, [this, events]() {
218 EventsModel::Status s = events->get_status_at(ui->video->get_position());
219 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
220 set_current_event_type("pull");
221 } else if (s.pull_state == EventsModel::Status::PULL_IN_AIR) {
222 insert_noplayer_event("pull_landed");
223 } else if (s.pull_state == EventsModel::Status::NOT_PULLING) {
224 set_current_event_type("was_d");
228 // Defensive events (TODO add more)
229 connect(ui->interception, &QPushButton::clicked, [this]() { set_current_event_type("interception"); });
230 connect(ui->defense_label, &ClickableLabel::clicked, [this]() { insert_noplayer_event("set_defense"); });
231 connect(ui->their_throwaway, &QPushButton::clicked, [this]() { insert_noplayer_event("their_throwaway"); });
232 connect(ui->their_goal, &QPushButton::clicked, [this]() { insert_noplayer_event("their_goal"); });
233 connect(ui->their_pull, &QPushButton::clicked, [this, events]() {
234 EventsModel::Status s = events->get_status_at(ui->video->get_position());
235 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
236 insert_noplayer_event("their_pull");
239 connect(ui->our_defense, &QPushButton::clicked, [this]() { set_current_event_type("defense"); });
240 connect(ui->defensive_soft_plus, &QPushButton::clicked, [this]() { set_current_event_type("defensive_soft_plus"); });
241 connect(ui->defensive_soft_minus, &QPushButton::clicked, [this]() { set_current_event_type("defensive_soft_minus"); });
243 connect(ui->offensive_formation, &QPushButton::clicked, [this]() { insert_or_change_formation(/*offense=*/true); });
244 connect(ui->defensive_formation, &QPushButton::clicked, [this]() { insert_or_change_formation(/*offense=*/false); });
247 connect(ui->substitution, &QPushButton::clicked, [this]() { make_substitution(); });
248 connect(ui->stoppage, &QPushButton::clicked, [this, events]() {
249 EventsModel::Status s = events->get_status_at(ui->video->get_position());
251 insert_noplayer_event("restart");
253 insert_noplayer_event("stoppage");
256 connect(ui->unknown, &QPushButton::clicked, [this]() { insert_noplayer_event("unknown"); });
258 QShortcut *key_delete = new QShortcut(QKeySequence(Qt::Key_Delete), this);
259 connect(key_delete, &QShortcut::activated, [this]() { ui->delete_->animateClick(); });
260 connect(ui->delete_, &QPushButton::clicked, [this]() { delete_current_event(); });
263 void MainWindow::position_changed(uint64_t pos)
265 ui->timestamp->setText(QString::fromUtf8(format_timestamp(pos)));
267 ui->video->pause(); // We only played to get a picture.
270 QModelIndex row = events->get_last_event_qt(ui->video->get_position());
271 ui->event_view->scrollTo(row, QAbstractItemView::PositionAtCenter);
273 update_ui_from_time(pos);
276 void MainWindow::insert_player_event(int button_id)
278 uint64_t t = ui->video->get_position();
279 vector<int> team = events->sort_team(events->get_team_at(t));
280 if (unsigned(button_id) >= team.size()) {
283 int player_id = team[button_id];
285 EventsModel::Status s = events->get_status_at(t);
287 ui->event_view->selectionModel()->blockSignals(true);
288 if (s.attack_state == EventsModel::Status::OFFENSE) {
289 // TODO: Perhaps not if that player already did the last catch?
290 ui->event_view->selectRow(events->insert_event(t, player_id, nullopt, "catch"));
292 ui->event_view->selectRow(events->insert_event(t, player_id, nullopt));
294 ui->event_view->selectionModel()->blockSignals(false);
296 update_ui_from_time(t);
299 void MainWindow::insert_noplayer_event(const string &type)
301 uint64_t t = ui->video->get_position();
303 ui->event_view->selectionModel()->blockSignals(true);
304 ui->event_view->selectRow(events->insert_event(t, nullopt, nullopt, type));
305 ui->event_view->selectionModel()->blockSignals(false);
307 update_ui_from_time(t);
310 void MainWindow::set_current_event_type(const string &type)
312 QItemSelectionModel *select = ui->event_view->selectionModel();
313 if (!select->hasSelection()) {
316 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
317 events->set_event_type(row, type);
318 update_ui_from_time(ui->video->get_position());
321 // Formation buttons either modify the existing formation (if we've selected
322 // a formation change event), or insert a new one (if not).
323 void MainWindow::insert_or_change_formation(bool offense)
325 FormationsModel *formations = offense ? offensive_formations : defensive_formations;
326 QListView *formation_view = offense ? ui->offensive_formation_view : ui->defensive_formation_view;
327 if (!formation_view->selectionModel()->hasSelection()) {
328 // This shouldn't happen; the button should not have been enabled.
331 int formation_row = formation_view->selectionModel()->selectedRows().front().row(); // Should only be one, due to our selection behavior.
332 int formation_id = formations->get_formation_id(formation_row);
333 if (formation_id == -1) {
334 // This also shouldn't happen (“Add new…” selected).
338 QItemSelectionModel *select = ui->event_view->selectionModel();
339 if (select->hasSelection()) {
340 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
341 string expected_type = offense ? "formation_offense" : "formation_defense";
342 if (events->get_event_type(row) == expected_type) {
343 events->set_event_formation(row, formation_id);
344 update_ui_from_time(ui->video->get_position());
349 // Insert a new formation event instead (same as double-click on the selected one).
350 events->set_formation_at(ui->video->get_position(), offense, formation_id);
351 update_ui_from_time(ui->video->get_position());
354 void MainWindow::delete_current_event()
356 QItemSelectionModel *select = ui->event_view->selectionModel();
357 if (!select->hasSelection()) {
360 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
361 ui->event_view->selectionModel()->blockSignals(true);
362 events->delete_event(row);
363 ui->event_view->selectionModel()->blockSignals(false);
364 update_ui_from_time(ui->video->get_position());
367 void MainWindow::make_substitution()
369 QItemSelectionModel *select = ui->player_view->selectionModel();
371 for (QModelIndex row : select->selectedRows()) {
372 new_team.insert(players->get_player_id(row.row()));
374 events->set_team_at(ui->video->get_position(), new_team);
375 update_player_buttons(ui->video->get_position());
378 void MainWindow::update_ui_from_time(uint64_t t)
381 update_player_buttons(t);
382 update_action_buttons(t);
385 void MainWindow::update_status(uint64_t t)
387 EventsModel::Status s = events->get_status_at(t);
389 std::string formation = "Not started";
390 if (s.attack_state == EventsModel::Status::OFFENSE) {
391 if (s.offensive_formation != 0) {
392 formation = offensive_formations->get_formation_name_by_id(s.offensive_formation);
394 formation = "Offense";
396 } else if (s.attack_state == EventsModel::Status::DEFENSE) {
397 if (s.defensive_formation != 0) {
398 formation = defensive_formations->get_formation_name_by_id(s.defensive_formation);
400 formation = "Defense";
404 snprintf(buf, sizeof(buf), "%d–%d | %s | %d passes, %d sec possession",
405 s.our_score, s.their_score, formation.c_str(), s.num_passes, s.possession_sec);
406 if (s.stoppage_sec > 0) {
408 snprintf(buf2, sizeof(buf2), "%s (plus %d sec stoppage)", buf, s.stoppage_sec);
409 ui->status->setText(buf2);
411 ui->status->setText(buf);
415 void MainWindow::update_player_buttons(uint64_t t)
417 QPushButton *buttons[] = {
426 const char shortcuts[] = "qweasdf";
428 for (int player_id : events->sort_team(events->get_team_at(t))) {
429 QPushButton *btn = buttons[num_players];
430 string label = players->get_player_name_by_id(player_id) + " (&" + shortcuts[num_players] + ")";
431 char shortcut[2] = "";
432 shortcut[0] = toupper(shortcuts[num_players]);
433 btn->setText(QString::fromUtf8(label));
434 btn->setShortcut(QCoreApplication::translate("MainWindow", shortcut, nullptr));
435 btn->setEnabled(true);
436 if (++num_players == 7) {
440 for (int i = num_players; i < 7; ++i) {
441 QPushButton *btn = buttons[i];
442 btn->setText("No player");
443 btn->setEnabled(false);
447 void MainWindow::update_action_buttons(uint64_t t)
450 QItemSelectionModel *select = ui->offensive_formation_view->selectionModel();
451 if (select->hasSelection()) {
452 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
453 ui->offensive_formation->setEnabled(offensive_formations->get_formation_id(row) != -1);
455 ui->offensive_formation->setEnabled(false);
459 QItemSelectionModel *select = ui->defensive_formation_view->selectionModel();
460 if (select->hasSelection()) {
461 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
462 ui->defensive_formation->setEnabled(defensive_formations->get_formation_id(row) != -1);
464 ui->defensive_formation->setEnabled(false);
468 EventsModel::Status s = events->get_status_at(t);
470 bool has_selection = false;
471 bool has_selection_with_player = false;
473 QItemSelectionModel *select = ui->event_view->selectionModel();
474 if (select->hasSelection()) {
475 has_selection = true;
476 int row = select->selectedRows().front().row(); // Should only be one, due to our selection behavior.
477 has_selection_with_player = events->get_player_id(row).has_value();
479 ui->delete_->setEnabled(has_selection);
482 ui->stoppage->setText("Restart (&v)");
483 ui->stoppage->setShortcut(QCoreApplication::translate("MainWindow", "V", nullptr));
484 ui->catch_->setEnabled(false);
485 ui->throwaway->setEnabled(false);
486 ui->drop->setEnabled(false);
487 ui->goal->setEnabled(false);
488 ui->offensive_soft_plus->setEnabled(false);
489 ui->offensive_soft_minus->setEnabled(false);
490 ui->pull_or_was_d->setEnabled(false);
491 ui->interception->setEnabled(false);
492 ui->their_throwaway->setEnabled(false);
493 ui->our_defense->setEnabled(false);
494 ui->their_goal->setEnabled(false);
495 ui->defensive_soft_plus->setEnabled(false);
496 ui->defensive_soft_minus->setEnabled(false);
497 ui->their_pull->setEnabled(false);
500 ui->stoppage->setText("Stoppage (&v)");
501 ui->stoppage->setShortcut(QCoreApplication::translate("MainWindow", "V", nullptr));
504 // Defaults for pull-related buttons.
505 ui->pull_or_was_d->setText("Pull (&p)");
506 ui->their_pull->setText("Their pull (&p)");
507 ui->pull_or_was_d->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
508 ui->their_pull->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
509 ui->throwaway->setText("Throwaway (&t)");
510 ui->throwaway->setShortcut(QCoreApplication::translate("MainWindow", "T", nullptr));
512 if (s.pull_state == EventsModel::Status::SHOULD_PULL) {
513 ui->pull_or_was_d->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
514 ui->their_pull->setEnabled(s.attack_state == EventsModel::Status::OFFENSE);
516 ui->catch_->setEnabled(false);
517 ui->throwaway->setEnabled(false);
518 ui->drop->setEnabled(false);
519 ui->goal->setEnabled(false);
520 ui->offensive_soft_plus->setEnabled(false);
521 ui->offensive_soft_minus->setEnabled(false);
522 ui->interception->setEnabled(false);
523 ui->their_throwaway->setEnabled(false);
524 ui->our_defense->setEnabled(false);
525 ui->their_goal->setEnabled(false);
526 ui->defensive_soft_plus->setEnabled(false);
527 ui->defensive_soft_minus->setEnabled(false);
530 if (s.pull_state == EventsModel::Status::PULL_IN_AIR) {
531 if (s.attack_state == EventsModel::Status::DEFENSE) {
532 ui->pull_or_was_d->setText("Pull landed (&p)");
533 ui->pull_or_was_d->setShortcut(QCoreApplication::translate("MainWindow", "P", nullptr));
534 ui->pull_or_was_d->setEnabled(true);
536 ui->throwaway->setText("Pull OOB (&t)");
537 ui->throwaway->setShortcut(QCoreApplication::translate("MainWindow", "T", nullptr));
538 ui->throwaway->setEnabled(true);
540 ui->pull_or_was_d->setEnabled(false);
541 ui->throwaway->setEnabled(false);
543 ui->their_pull->setEnabled(false); // We don't track their pull landings; only by means of catch etc.
545 ui->catch_->setEnabled(false);
546 ui->drop->setEnabled(false);
547 ui->goal->setEnabled(false);
548 ui->offensive_soft_plus->setEnabled(false);
549 ui->offensive_soft_minus->setEnabled(false);
550 ui->interception->setEnabled(false);
551 ui->their_throwaway->setEnabled(false);
552 ui->our_defense->setEnabled(false);
553 ui->their_goal->setEnabled(false);
554 ui->defensive_soft_plus->setEnabled(false);
555 ui->defensive_soft_minus->setEnabled(false);
559 // Not pulling, so reuse the pull button for got d-ed.
560 ui->pull_or_was_d->setText("Was d-ed (&z)");
561 ui->pull_or_was_d->setShortcut(QCoreApplication::translate("MainWindow", "Z", nullptr));
562 ui->pull_or_was_d->setEnabled(true);
564 ui->catch_->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
565 ui->throwaway->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
566 ui->drop->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
567 ui->goal->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
568 ui->offensive_soft_plus->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
569 ui->offensive_soft_minus->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player);
570 ui->pull_or_was_d->setEnabled(s.attack_state == EventsModel::Status::OFFENSE && has_selection_with_player); // Was d-ed.
572 ui->interception->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
573 ui->their_throwaway->setEnabled(s.attack_state == EventsModel::Status::DEFENSE);
574 ui->our_defense->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
575 ui->their_goal->setEnabled(s.attack_state == EventsModel::Status::DEFENSE);
576 ui->defensive_soft_plus->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
577 ui->defensive_soft_minus->setEnabled(s.attack_state == EventsModel::Status::DEFENSE && has_selection_with_player);
578 ui->their_pull->setEnabled(false);
581 void MainWindow::formation_double_clicked(bool offense, unsigned row)
583 FormationsModel *formations = offense ? offensive_formations : defensive_formations;
584 int id = formations->get_formation_id(row);
585 if (id == -1) { // “Add new” clicked.
587 QString new_formation_str = QInputDialog::getText(this, "New formation", "Choose name for new formation:", QLineEdit::Normal, "", &ok);
588 if (!ok || new_formation_str.isEmpty()) {
592 id = formations->insert_new(new_formation_str.toStdString());
593 QListView *view = offense ? ui->offensive_formation_view : ui->defensive_formation_view;
594 view->selectionModel()->select(formations->index(formations->get_row_from_id(id), 0), QItemSelectionModel::ClearAndSelect);
595 events->inserted_new_formation(id, new_formation_str.toStdString());
597 events->set_formation_at(ui->video->get_position(), offense, id);
599 update_ui_from_time(ui->video->get_position());