function siteShowMenu($data)
{
?>
<ul>
<?php
foreach ($data['menu'] as $title => $url) {
if ($data['selected'] == $url) {
$css = 'class="selected"';
} else {
$css = '';
}
?>
<li>
<a <?php
echo $css;
?>
href="<?php
echo \Util\Html::encode($url);
?>
"><?php
echo \Util\Html::encode($title);
?>
</a>
</li>
<?php
}
?>
</ul><?php
}
function adminShowSitemapItem(array $data)
{
?>
<h2>Управление разделом</h2><?php
if (isset($data['new']) && $data['new']) {
/**
* Форма добавления раздела
*/
?>
<h3>Добавление раздела</h3>
<form class="sitemap_edit_form">
<div><span>Шаблон страницы</span>
<select name="template">
<?php
foreach ($data['availableTemplates'] as $template) {
?>
<option value="<?php
echo \Util\Html::encode($template['id']);
?>
"><?php
echo \Util\Html::encode($template['title']);
?>
</option>
<?php
}
?>
</select>
</div>
<div><span>URL страницы</span><em><?php
echo \Util\Html::encode($data['parentUrl']);
?>
</em><input name="url" /></div>
<div><span>Заголовок страницы</span><input name="title"></div>
<div><input type="submit" value="Добавить раздел"></div>
<input type="hidden" name="writemodule" value="admin_sitemap_addItem">
<input type="hidden" name="parentId" value="<?php
echo \Util\Html::encode($data['parentId']);
?>
">
</form>
<?php
} else {
$sitemapItem = $data['sitemapItem'];
if (!empty($sitemapItem)) {
?>
<form class="sitemap_edit_form">
<div><span>Шаблон страницы</span>
<select name="layout">
<?php
foreach ($data['availableTemplates'] as $template) {
?>
<option <?php
if ($sitemapItem['layout'] == $template['id']) {
echo 'selected="selected" ';
}
?>
value="<?php
echo \Util\Html::encode($template['id']);
?>
"><?php
echo \Util\Html::encode($template['title']);
?>
</option>
<?php
}
?>
</select>
</div>
<div><span>Тема страницы</span><input name="template" value="<?php
echo \Util\Html::encode($sitemapItem['template']);
?>
" /></div>
<?php
if ($sitemapItem['parent_id']) {
?>
<div><span>URL страницы</span><em><?php
echo \Util\Html::encode($data['parentUrl']);
?>
</em><input name="url" value="<?php
echo \Util\Html::encode($sitemapItem['name']);
?>
" /></div>
<?php
}
?>
<div><span>Заголовок страницы</span><input name="title" value="<?php
echo \Util\Html::encode($sitemapItem['title']);
?>
" ></div>
<div><input type="submit" value="Сохранить"></div>
<input type="hidden" name="writemodule" value="admin_sitemap_saveItem">
<input type="hidden" name="parentId" value="<?php
echo \Util\Html::encode($data['parentId']);
?>
">
<input type="hidden" name="id" value="<?php
echo \Util\Html::encode($sitemapItem['id']);
?>
">
</form>
<?php
}
?>
<h2>Модули раздела</h2>
<?php
foreach ($data['availableTemplates'][$sitemapItem['layout']]['blocks'] as $id => $block) {
?>
<h3>Блок "<?php
echo \Util\Html::encode($block['name']);
?>
"</h3>
<?php
}
?>
<?php
}
}
public function table($caption = '')
{
return \util\Html::genTable($caption, $this->fields(), $this->records());
}
<?php
require_once __DIR__ . "/bootstrap.php";
$sql = new \sql\Database();
$report = null;
if (isset($_GET['report'])) {
$report = \reports\Report::get($_GET['report']);
$sql->selectDB(\util\Config::$database->tablesDB);
$report->run($sql);
} else {
if (isset($_GET['table'])) {
$sql->selectDB(\util\Config::$database->tablesDB);
$table = $_GET['table'];
$chart = new \reports\Chart();
$chart->setType('Table');
$report = new \reports\Report();
$report->setTitle($table)->setQuery("SELECT * FROM {$table}")->setChart($chart)->run($sql);
} else {
if (isset($_GET['serial'])) {
$report = \reports\Report::unserialize($_GET['serial']);
$sql->selectDB(\util\Config::$database->tablesDB);
$report->run($sql);
}
}
}
if (!is_null($report)) {
$header = new \html\Header();
$header->title(\util\Config::$app->name)->css('css/style.min.css')->js('js/jquery.min.js', 'js/bootstrap.min.js')->addToIncludes($report->script('chart_container'));
$content = "<div id='chart_container' class='chart'></div>";
echo "<!DOCTYPE html>\n<html lang='en'>" . $header->html() . "<body>\n\t\t\t<header>" . \util\Html::genNavbar() . "</header>\n\t\t\t<article>\n\t\t\t\t{$content}\n\t\t\t</article>\n\t\t\t<footer>\n\t\t\t</footer>\n\t\t</body>\n\t</html>";
}
/**
* @var \Core\View\Base $view
*/
?>
<!DOCTYPE html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title><?php
echo \Util\Html::encode($view->getPageTitle());
?>
</title>
<?php
foreach ($view->getJs() as $jsScriptAddress) {
?>
<script type="text/javascript" src="<?php
echo \Util\Html::encode($jsScriptAddress);
?>
"></script>
<?php
}
foreach ($view->getCss() as $cssScriptAddress) {
?>
<link rel="stylesheet" href="<?php
echo \Util\Html::encode($cssScriptAddress);
?>
"/>
<?php
}
?>
</head>
$chart = new \reports\Chart();
$chart->setTitle($title)->setAxisLabels($vAxis, $hAxis)->setColumnNames(array($column1, $column2))->setType($type);
$report = new \reports\Report();
$report->setTitle($title)->setQuery($query)->setChart($chart);
if (isset($_POST['submit_type']) && $_POST['submit_type'] === 'save_report') {
\reports\Report::add($report);
header("Location: run_report.php?report={$title}");
} else {
$serial = $report->serialize();
header("Location: run_report.php?serial={$serial}");
}
exit;
}
}
$header = new \html\Header();
$header->title(\util\Config::$app->name)->css('css/style.min.css')->js('js/jquery.min.js', 'js/bootstrap.min.js');
$form = new \html\FormPanel("Import Spreadsheets", "form-panel", 'md-10', "form-horizontal", "");
foreach ($errors as $err) {
$form->error($err);
}
echo "<header>" . \util\Html::genNavbar() . "</header>";
$form = new \html\FormPanel("Create Report", "form-panel", 'md-10', "form-horizontal", "");
if (isset($_POST['errormsg'])) {
$form->error($_POST['errormsg']);
}
$form->textInput('title', 'Title*', true)->textArea('sql', 'SQL*', true)->select('type', 'Chart Type*', true)->option('AreaChart', 'Area Chart')->option('BarChart', 'Bar Chart')->option('BubbleChart', 'Bubble Chart')->option('CandlestickChart', 'Candlestick Chart')->option('ColumnChart', 'Column Chart')->option('ComboChart', 'Combo Chart')->option('LineChart', 'Line Chart')->option('PieChart', 'Pie Chart')->option('ScatterChart', 'Scatter Chart')->option('SteppedAreaChart', 'Stepped Area Chart')->option('Table', 'Table')->option('Timeline', 'Timeline')->option('Histogram', 'Histogram')->textInput('hAxis', 'hAxis Label')->textInput('vAxis', 'vAxis Label')->textInput('column1', 'Column #1 Name')->textInput('column2', 'Column #2 Name')->numberInput('sortcolumn', 'Sort by Column#', 1)->select('submit_type', 'Submit Type*', true)->option('preview_report', "View Only")->option('save_report', 'Save and View')->button('submit', 'Confirm/Upload', 'btn btn-primary');
$container = new \html\GridDiv("container");
$container->row()->column('md-1')->column('md-10', null, $form->html())->column('md-1');
echo "<!DOCTYPE html>\n<html lang='en'>" . $header->html() . "<body>";
echo "<header>" . \util\Html::genNavbar() . "</header>";
echo $container->html(), "</body></html>";
if (!empty($_POST["spreadsheet"])) {
$file_table = \excel2sql\SqlConvert::convertToSql($_POST['spreadsheet'], \util\Config::$database->tablesDB);
unlink($_POST['spreadsheet']);
}
$sql = new \sql\Database();
$sql->selectDB(\util\Config::$database->tablesDB);
$reports = array();
foreach ($file_table as $tname) {
$chart = new \reports\Chart();
$chart->setType('Table');
$report = new \reports\Report();
$report->setTitle($tname)->setQuery("SELECT * FROM {$tname}")->setChart($chart)->run($sql);
$reports[] = $report;
}
$header = new \html\Header();
$header->title(\util\Config::$app->name)->css('css/style.min.css')->js('js/jquery.min.js', 'js/bootstrap.min.js');
if (!empty($reports)) {
$head = '';
for ($ir = 0; $ir < count($reports); ++$ir) {
$head .= $reports[$ir]->script("chart_container_{$ir}");
}
$content = "";
for ($ir = 0; $ir < count($reports); ++$ir) {
$content .= "<div id=\"chart_container_{$ir}\"></div><br><br>";
}
$header->addToIncludes($head);
} else {
$content = "<div class='box half-width center'>'No tables were Uploaded!'</div>";
}
echo "<!DOCTYPE html>\n<html lang='en'>" . $header->html() . "<body>\n\t\t\t<header>\n\t\t\t\t<noscript>\n\t\t\t\t\tJavaScript must be enabled in order for you to use this service.\n\t\t\t\t\tHowever, it seems JavaScript is either disabled or not supported by your browser.\n\t\t\t\t\tTo use this service, enable JavaScript by changing your browser options,\n\t\t\t\t\tthen try again.\n\t\t\t\t</noscript>" . \util\Html::genNavbar() . "</header>\n\t\t\t<article>\n\t\t\t\t{$content}\n\t\t\t</article>\n\t\t\t<footer>\n\t\t\t</footer>\n\t\t</body>\n\t</html>";
