parsingphase /
takeAticket
| @@ 496-504 (lines=9) @@ | ||
| 493 | * |
|
| 494 | * @throws \Doctrine\DBAL\DBALException |
|
| 495 | */ |
|
| 496 | public function fetchUndeletedTickets() |
|
| 497 | { |
|
| 498 | $conn = $this->getDbConn(); |
|
| 499 | $statement = $conn->prepare('SELECT * FROM tickets WHERE deleted=0 ORDER BY offset ASC'); |
|
| 500 | $statement->execute(); |
|
| 501 | $tickets = $statement->fetchAll(); |
|
| 502 | $tickets = $this->expandTicketsData($tickets); |
|
| 503 | ||
| 504 | return $tickets; |
|
| 505 | } |
|
| 506 | ||
| 507 | /** |
|
| @@ 514-522 (lines=9) @@ | ||
| 511 | * |
|
| 512 | * @throws \Doctrine\DBAL\DBALException |
|
| 513 | */ |
|
| 514 | public function fetchPerformedTickets() |
|
| 515 | { |
|
| 516 | $conn = $this->getDbConn(); |
|
| 517 | $statement = $conn->prepare('SELECT * FROM tickets WHERE deleted=0 AND used=1 ORDER BY offset ASC'); |
|
| 518 | $statement->execute(); |
|
| 519 | $tickets = $statement->fetchAll(); |
|
| 520 | $tickets = $this->expandTicketsData($tickets); |
|
| 521 | ||
| 522 | return $tickets; |
|
| 523 | } |
|
| 524 | ||
| 525 | /** |
|
| @@ 532-543 (lines=12) @@ | ||
| 529 | * @return array|mixed |
|
| 530 | * @throws \Doctrine\DBAL\DBALException |
|
| 531 | */ |
|
| 532 | public function getQueueEntriesForSongId($songId) |
|
| 533 | { |
|
| 534 | $conn = $this->getDbConn(); |
|
| 535 | $statement = $conn->prepare( |
|
| 536 | 'SELECT * FROM tickets WHERE deleted=0 AND songId=:songId ORDER BY offset ASC' |
|
| 537 | ); |
|
| 538 | $statement->execute(['songId' => $songId]); |
|
| 539 | $tickets = $statement->fetchAll(); |
|
| 540 | $tickets = $this->expandTicketsData($tickets); |
|
| 541 | ||
| 542 | return $tickets; |
|
| 543 | } |
|
| 544 | ||
| 545 | /** |
|
| 546 | * @param $title |
|
