@@ -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 | } |