Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	currency.php
Содержимое	<?php require_once (__DIR__ . '/../autoloader.php'); $page = "business"; $title="РљСѓСЂСЃС‹ РІР°Р»СЋС‚ Р±Р°РЅРєРѕРІ " . App::$config['lang']['cities'][1]; require("../inc/top_new.inc"); if (isset($_GET['data']) && $_GET['data'] <> "") { if (!preg_match("/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/is",$_GET['data'])) { echo "РќРµРІРµСЂРЅС‹Р№ С„РѕСЂРјР°С‚ РґР°С‚С‹"; $data_cur[0] = ""; } else { $data_cur[0] = $_GET['data']; } } else { $data_cur = App::$command ->createCommand(' select data from currency order by data desc limit 0,1 ') ->queryOne(); $data_cur[0] = $data_cur['data']; } $days = App::$command ->createCommand(' select distinct data from currency order by data desc limit 0, 7; select distinct data from currency order by data desc limit 0, 7; ') ->queryAll(); $best_usd_pokup = App::$command ->createCommand("select kurs from currency where ticker='USD' and data = :date and id_bank <> 0 order by kurs desc limit 0, 1") ->bindValue(':date', $data_cur[0]) ->queryOne(); $best_usd_prod = App::$command ->createCommand("select kurs2 from currency where ticker='USD' and data = :date and id_bank <> 0 order by kurs2 asc limit 0, 1") ->bindValue(':date', $data_cur[0]) ->queryOne(); $best_eur_pokup = App::$command ->createCommand("select kurs from currency where ticker='EUR' and data = :date and id_bank <> 0 order by kurs desc limit 0, 1") ->bindValue(':date', $data_cur[0]) ->queryOne(); $best_eur_prod = App::$command ->createCommand("select kurs2 from currency where ticker='EUR' and data = :date and id_bank <> 0 order by kurs2 asc limit 0, 1") ->bindValue(':date', $data_cur[0]) ->queryOne(); $currencyBanks = App::$command ->createCommand('select firma.name as name, firma.id as fid, phone, currency_bank.id as id from currency_bank, firma where id_firm = firma.id and currency_bank.status = 1 order by name') ->queryAll(); ?> <div class="uk-container uk-container-center"> <div class="page-header uk-flex uk-margin-small-bottom uk-flex-wrap uk-flex-middle uk-flex-space-between"> <h1><a href="/busines/currency.php" class="orange"> РљСѓСЂСЃС‹ РІР°Р»СЋС‚ </a> Р±Р°РЅРєРѕРІ <?=App::$config['lang']['cities'][1]?> РЅР° <?=\app\core\helpers\RuDate::getDate($data_cur[0], 'd MMMM');?></h1> <form class="uk-form"> <select name="data" onchange="location.href='?data=' + this.options[this.selectedIndex].value"> <?php foreach ($days as $day) { echo "<option value=\"{$day['data']}\">{$day['data']}</option>"; } ?> </select> </form> </div> <hr class="uk-grid-divider"> <?php if ($data_cur[0] <> "") { ?> <div class="uk-overflow-container"> <table class="uk-table uk-table-hover"> <thead> <tr> <th valign="middle"><strong>Р‘Р°РЅРє</strong></th> <th><em class="p_green">РїРѕРєСѓРїРєР° <strong>$</strong></em></th> <th><em class="orange">РїСЂРѕРґР°Р¶Р° <strong>$</strong></em></th> <th><em class="p_green">РїРѕРєСѓРїРєР° <strong>€</strong></em></th> <th><em class="orange">РїСЂРѕРґР°Р¶Р° <strong>€</strong></em></th> </tr> </thead> <?php foreach ($currencyBanks as $currencyBank) { $r_curs_usd = App::$command ->createCommand("select * from currency where id_bank=:bank_id and ticker='USD' and data = :date") ->bindValue(':date', $data_cur[0]) ->bindValue(':bank_id', $currencyBank['id']) ->queryOne(); $r_curs_eur = App::$command ->createCommand("select * from currency where id_bank=:bank_id and ticker='EUR' and data = :date") ->bindValue(':date', $data_cur[0]) ->bindValue(':bank_id', $currencyBank['id']) ->queryOne(); // var_dump($r_curs_usd); // var_dump($r_curs_eur); // var_dump($currencyBanks); ?> <tr> <td> <a href="/firma.php?id=<?=$currencyBank['fid']?>" target="_blank"><?=$currencyBank['name']?></a> <?php if ($currencyBank['phone'] <> "") echo "С‚РµР». ".$currencyBank['phone'];?></td> <td><?php if ($r_curs_usd['kurs'] == $best_usd_pokup['kurs']) echo "<b>".$r_curs_usd['kurs']."</b>"; else echo $r_curs_usd['kurs'];?> </td> <td><?php if ($r_curs_usd['kurs2'] == $best_usd_prod['kurs2']) echo "<b>".$r_curs_usd['kurs2']."</b>"; else echo $r_curs_usd['kurs2'];?> </td> <td><?php if ($r_curs_eur['kurs'] == $best_eur_pokup['kurs']) echo "<b>".$r_curs_eur['kurs']."</b>"; else echo $r_curs_eur['kurs'];?> </td> <td><?php if ($r_curs_eur['kurs2'] == $best_eur_prod['kurs2']) echo "<b>".$r_curs_eur['kurs2']."</b>"; else echo $r_curs_eur['kurs2'];?> </td> </tr> <?php } $r_cb_usd = App::$command ->createCommand("select * from currency where id_bank='0' and ticker='USD' and data = :data") ->bindValue(':data', $data_cur[0]) ->queryOne(); $r_cb_eur = App::$command ->createCommand("select * from currency where id_bank='0' and ticker='EUR' and data = :data") ->bindValue(':data', $data_cur[0]) ->queryOne(); ?> <tr> <td><b>Р¦Р‘ Р Р¤</b> </td> <td><?=$r_cb_usd['kurs']?> </td> <td> </td> <td><?=$r_cb_eur['kurs']?> </td> <td> </td> </tr> </table> </div> </div> <?php } ?><p><!--<em>* РћРїС‚РёРјР°Р»СЊРЅС‹Рµ РєСѓСЂСЃС‹ РІС‹РґРµР»РµРЅС‹</em>--></p> <?php if ( $_SERVER['QUERY_STRING'] == '' ) { //echo_seo_text(10); } ?> <?php require(__DIR__ . '/../inc/bottom_new.inc'); ?>

/busines/

Имя	Дата	Размер
..	2026-10-02
parser	2020-01-15
cron_banks.php	2020-01-15	7 кб.
cron_banks_old.php	2019-12-16	3 кб.
currency.php	2020-01-16	6 кб.

/busines