parsingphase /
takeAticket
| @@ 776-792 (lines=17) @@ | ||
| 773 | * |
|
| 774 | * @return null|Source |
|
| 775 | */ |
|
| 776 | public function fetchSourceByName($sourceName) |
|
| 777 | { |
|
| 778 | $source = null; |
|
| 779 | $query = $this->dbConn->createQueryBuilder() |
|
| 780 | ->select('*') |
|
| 781 | ->from('sources') |
|
| 782 | ->where('name = :name') |
|
| 783 | ->setParameter(':name', $sourceName); |
|
| 784 | ||
| 785 | $row = $query->execute()->fetch(PDO::FETCH_ASSOC); |
|
| 786 | ||
| 787 | if ($row) { |
|
| 788 | $source = $this->buildSourceFromDbRow($row); |
|
| 789 | } |
|
| 790 | ||
| 791 | return $source; |
|
| 792 | } |
|
| 793 | ||
| 794 | ||
| 795 | /** |
|
| @@ 799-815 (lines=17) @@ | ||
| 796 | * @param $sourceId |
|
| 797 | * @return null|Source |
|
| 798 | */ |
|
| 799 | public function fetchSourceById($sourceId) |
|
| 800 | { |
|
| 801 | $source = null; |
|
| 802 | $query = $this->dbConn->createQueryBuilder() |
|
| 803 | ->select('*') |
|
| 804 | ->from('sources') |
|
| 805 | ->where('id = :id') |
|
| 806 | ->setParameter(':id', $sourceId); |
|
| 807 | ||
| 808 | $row = $query->execute()->fetch(PDO::FETCH_ASSOC); |
|
| 809 | ||
| 810 | if ($row) { |
|
| 811 | $source = $this->buildSourceFromDbRow($row); |
|
| 812 | } |
|
| 813 | ||
| 814 | return $source; |
|
| 815 | } |
|
| 816 | ||
| 817 | public function fetchPlatformByName($platformName) |
|
| 818 | { |
|
| @@ 817-833 (lines=17) @@ | ||
| 814 | return $source; |
|
| 815 | } |
|
| 816 | ||
| 817 | public function fetchPlatformByName($platformName) |
|
| 818 | { |
|
| 819 | $platform = null; |
|
| 820 | $query = $this->dbConn->createQueryBuilder() |
|
| 821 | ->select('*') |
|
| 822 | ->from('platforms') |
|
| 823 | ->where('name = :name') |
|
| 824 | ->setParameter(':name', $platformName); |
|
| 825 | ||
| 826 | $row = $query->execute()->fetch(PDO::FETCH_ASSOC); |
|
| 827 | ||
| 828 | if ($row) { |
|
| 829 | $platform = $this->buildPlatformFromDbRow($row); |
|
| 830 | } |
|
| 831 | ||
| 832 | return $platform; |
|
| 833 | } |
|
| 834 | ||
| 835 | /** |
|
| 836 | * Fetch all available platforms |
|
| @@ 896-912 (lines=17) @@ | ||
| 893 | * @param $name |
|
| 894 | * @return null|Instrument |
|
| 895 | */ |
|
| 896 | public function fetchInstrumentByName($name) |
|
| 897 | { |
|
| 898 | $instrument = null; |
|
| 899 | $query = $this->dbConn->createQueryBuilder() |
|
| 900 | ->select('*') |
|
| 901 | ->from('instruments') |
|
| 902 | ->where('name = :name') |
|
| 903 | ->setParameter(':name', $name); |
|
| 904 | ||
| 905 | $row = $query->execute()->fetch(PDO::FETCH_ASSOC); |
|
| 906 | ||
| 907 | if ($row) { |
|
| 908 | $instrument = $this->buildInstrumentFromDbRow($row); |
|
| 909 | } |
|
| 910 | ||
| 911 | return $instrument; |
|
| 912 | } |
|
| 913 | ||
| 914 | protected function fetchInstrumentByAbbreviation($abbreviation) |
|
| 915 | { |
|
| @@ 914-930 (lines=17) @@ | ||
| 911 | return $instrument; |
|
| 912 | } |
|
| 913 | ||
| 914 | protected function fetchInstrumentByAbbreviation($abbreviation) |
|
| 915 | { |
|
| 916 | $instrument = null; |
|
| 917 | $query = $this->dbConn->createQueryBuilder() |
|
| 918 | ->select('*') |
|
| 919 | ->from('instruments') |
|
| 920 | ->where('abbreviation = :abbreviation') |
|
| 921 | ->setParameter(':abbreviation', $abbreviation); |
|
| 922 | ||
| 923 | $row = $query->execute()->fetch(PDO::FETCH_ASSOC); |
|
| 924 | ||
| 925 | if ($row) { |
|
| 926 | $instrument = $this->buildInstrumentFromDbRow($row); |
|
| 927 | } |
|
| 928 | ||
| 929 | return $instrument; |
|
| 930 | } |
|
| 931 | ||
| 932 | ||
| 933 | /** |
|
