39 lines
1.3 KiB
PHP
39 lines
1.3 KiB
PHP
<?php
|
|
// Ladowanie cen biletow z bazy danych do $settings['tickets']
|
|
// Wymaga: $mdb (Medoo), $settings['tickets'] (struktura z config.php)
|
|
|
|
$_dbStmt = $mdb->query('SELECT * FROM ticket_prices');
|
|
$_dbPrices = [];
|
|
if ($_dbStmt) {
|
|
foreach ($_dbStmt->fetchAll(\PDO::FETCH_ASSOC) as $_row) {
|
|
$_dbPrices[$_row['ticket_id']] = $_row;
|
|
}
|
|
}
|
|
|
|
foreach ($settings['tickets'] as $tid => &$_ticket) {
|
|
if (isset($_dbPrices[$tid])) {
|
|
$_r = $_dbPrices[$tid];
|
|
$_ticket['price'] = (float) ($_r['price'] ?? 0);
|
|
$_ticket['price_weekend'] = (float) ($_r['price_weekend'] ?? 0);
|
|
$_ticket['dynamic_prices'] = [
|
|
'day0' => (float) ($_r['dynamic_price_day0'] ?? 0),
|
|
'day1_2' => (float) ($_r['dynamic_price_day1_2'] ?? 0),
|
|
'day3_7' => (float) ($_r['dynamic_price_day3_7'] ?? 0),
|
|
];
|
|
} else {
|
|
$_ticket['price'] = $_ticket['price'] ?? 0;
|
|
$_ticket['price_weekend'] = $_ticket['price_weekend'] ?? 0;
|
|
$_ticket['dynamic_prices'] = $_ticket['dynamic_prices'] ?? ['day0' => 0, 'day1_2' => 0, 'day3_7' => 0];
|
|
}
|
|
}
|
|
|
|
if (\S::get_session('lower_price_ticket')) {
|
|
foreach ($settings['tickets'] as &$_ticket) {
|
|
$_ticket['price'] = 1.0;
|
|
$_ticket['price_weekend'] = 1.0;
|
|
$_ticket['dynamic_prices'] = ['day0' => 0.0, 'day1_2' => 0.0, 'day3_7' => 0.0];
|
|
}
|
|
}
|
|
|
|
unset($_ticket, $_dbStmt, $_dbPrices, $_r);
|