| @@ 297-309 (lines=13) @@ | ||
| 294 | * @param void |
|
| 295 | * @return array data |
|
| 296 | */ |
|
| 297 | public function largeProgram() |
|
| 298 | { |
|
| 299 | return $this->getDatabase() |
|
| 300 | ->table('kk_meetings') |
|
| 301 | ->select('id, place') |
|
| 302 | ->select('DATE_FORMAT(start_date, "%Y") AS year') |
|
| 303 | ->select('UNIX_TIMESTAMP(open_reg) AS open_reg') |
|
| 304 | ->select('UNIX_TIMESTAMP(close_reg) AS close_reg') |
|
| 305 | ->where('id = ?', $this->getMeetingId()) |
|
| 306 | ->order('id DESC') |
|
| 307 | ->limit(1) |
|
| 308 | ->fetchField(); |
|
| 309 | } |
|
| 310 | ||
| 311 | /** |
|
| 312 | * Return data for public program |
|
| @@ 317-329 (lines=13) @@ | ||
| 314 | * @param void |
|
| 315 | * @return array data |
|
| 316 | */ |
|
| 317 | public function publicProgram() |
|
| 318 | { |
|
| 319 | return $this->getDatabase() |
|
| 320 | ->table('kk_meetings') |
|
| 321 | ->select('id, place') |
|
| 322 | ->select('DATE_FORMAT(start_date, "%Y") AS year') |
|
| 323 | ->select('UNIX_TIMESTAMP(open_reg) AS open_reg') |
|
| 324 | ->select('UNIX_TIMESTAMP(close_reg) AS close_reg') |
|
| 325 | ->where('id = ?', $this->getMeetingId()) |
|
| 326 | ->order('id DESC') |
|
| 327 | ->limit(1) |
|
| 328 | ->fetchField(); |
|
| 329 | } |
|
| 330 | ||
| 331 | /** |
|
| 332 | * Return data for program badges |
|