parsingphase /
takeAticket
| @@ 493-501 (lines=9) @@ | ||
| 490 | * |
|
| 491 | * @throws \Doctrine\DBAL\DBALException |
|
| 492 | */ |
|
| 493 | public function fetchUndeletedTickets() |
|
| 494 | { |
|
| 495 | $conn = $this->getDbConn(); |
|
| 496 | $statement = $conn->prepare('SELECT * FROM tickets WHERE deleted=0 ORDER BY offset ASC'); |
|
| 497 | $statement->execute(); |
|
| 498 | $tickets = $statement->fetchAll(); |
|
| 499 | $tickets = $this->expandTicketsData($tickets); |
|
| 500 | ||
| 501 | return $tickets; |
|
| 502 | } |
|
| 503 | ||
| 504 | /** |
|
| @@ 511-519 (lines=9) @@ | ||
| 508 | * |
|
| 509 | * @throws \Doctrine\DBAL\DBALException |
|
| 510 | */ |
|
| 511 | public function fetchPerformedTickets() |
|
| 512 | { |
|
| 513 | $conn = $this->getDbConn(); |
|
| 514 | $statement = $conn->prepare('SELECT * FROM tickets WHERE deleted=0 AND used=1 ORDER BY offset ASC'); |
|
| 515 | $statement->execute(); |
|
| 516 | $tickets = $statement->fetchAll(); |
|
| 517 | $tickets = $this->expandTicketsData($tickets); |
|
| 518 | ||
| 519 | return $tickets; |
|
| 520 | } |
|
| 521 | ||
| 522 | /** |
|
