@@ -5,9 +5,9 @@ discard block |
||
| 5 | 5 | final class WaterfallCollector extends Collector |
| 6 | 6 | { |
| 7 | 7 | |
| 8 | - public static function getList($total, $offset = 0) |
|
| 9 | - { |
|
| 10 | - $query = " |
|
| 8 | + public static function getList($total, $offset = 0) |
|
| 9 | + { |
|
| 10 | + $query = " |
|
| 11 | 11 | SELECT |
| 12 | 12 | `waterfall`.`id`, |
| 13 | 13 | `waterfall`.`name`, |
@@ -40,8 +40,8 @@ discard block |
||
| 40 | 40 | `watercourse`.`name` |
| 41 | 41 | LIMIT |
| 42 | 42 | {$offset}, {$total}"; |
| 43 | - return self::run_query($query); |
|
| 44 | - } |
|
| 43 | + return self::run_query($query); |
|
| 44 | + } |
|
| 45 | 45 | |
| 46 | 46 | public static function getMapList() |
| 47 | 47 | { |
@@ -74,9 +74,9 @@ discard block |
||
| 74 | 74 | return self::run_query($query); |
| 75 | 75 | } |
| 76 | 76 | |
| 77 | - public static function getListCount() |
|
| 78 | - { |
|
| 79 | - $query = " |
|
| 77 | + public static function getListCount() |
|
| 78 | + { |
|
| 79 | + $query = " |
|
| 80 | 80 | SELECT |
| 81 | 81 | COUNT(1) AS `count` |
| 82 | 82 | FROM |
@@ -89,8 +89,8 @@ discard block |
||
| 89 | 89 | ON `county`.`id` = `waterfall`.`county` |
| 90 | 90 | WHERE |
| 91 | 91 | `waterfall`.`is_public` = '1'"; |
| 92 | - return self::get_count($query); |
|
| 93 | - } |
|
| 92 | + return self::get_count($query); |
|
| 93 | + } |
|
| 94 | 94 | |
| 95 | 95 | public static function getNearbyList($waterfall) |
| 96 | 96 | { |
@@ -137,12 +137,12 @@ discard block |
||
| 137 | 137 | return self::run_row_query($query); |
| 138 | 138 | } |
| 139 | 139 | |
| 140 | - public static function getByAlias($watercourse, $waterfall) |
|
| 141 | - { |
|
| 142 | - $watercourse = self::escape($watercourse); |
|
| 143 | - $waterfall = self::escape($waterfall); |
|
| 140 | + public static function getByAlias($watercourse, $waterfall) |
|
| 141 | + { |
|
| 142 | + $watercourse = self::escape($watercourse); |
|
| 143 | + $waterfall = self::escape($waterfall); |
|
| 144 | 144 | |
| 145 | - $query = " |
|
| 145 | + $query = " |
|
| 146 | 146 | SELECT |
| 147 | 147 | `waterfall`.`id` AS `id`, |
| 148 | 148 | `waterfall`.`name`, |
@@ -192,7 +192,7 @@ discard block |
||
| 192 | 192 | `waterfall`.`is_public` = '1' |
| 193 | 193 | LIMIT 1"; |
| 194 | 194 | |
| 195 | - return self::run_row_query($query); |
|
| 196 | - } |
|
| 195 | + return self::run_row_query($query); |
|
| 196 | + } |
|
| 197 | 197 | |
| 198 | 198 | } |