function print_chart($params, $line, $option = NULL, $select = 0)
{
global $conn;
$height = 300;
$chart_height = 360;
$max_width = 800;
$chart_width = 900;
if (!isset($params['FILTER'])) {
$params['FILTER'] = NULL;
} elseif (!isset($params['SORT'])) {
$params['SORT'] = NULL;
}
if (!isset($params['GROUP'])) {
$params['GROUP'] = NULL;
}
if (!isset($params['ADD'])) {
$params['ADD'] = NULL;
}
$result = db_mysql_query(select_tbody($params['TABLE'], $params['SORT'], $params['FILTER'], $params['GROUP'], $params['ADD']), $conn);
$max = 0;
$base_arr = array();
$count = db_mysql_num_rows($result);
while ($arr = db_mysql_fetch_array($result)) {
if ($arr[$line['VAL']] >= $max) {
$max = $arr[$line['VAL']];
}
if ($line['DATA'] == 'date') {
$date = explode('-', $arr['datefromto']);
if ($option == 'hour') {
array_push($base_arr, date('H', $date[0]));
$data_arr[$arr[$line['KEY']]][date('H', $date[0])] = $arr[$line['VAL']];
if ($count == 1) {
array_unshift($base_arr, date('H', strtotime('-1 hour', $date[0])));
array_push($base_arr, date('H', strtotime('+1 hour', $date[0])));
}
}
if ($option == 'day') {
array_push($base_arr, date('d.m', $date[0]));
$data_arr[$arr[$line['KEY']]][date('d.m', $date[0])] = $arr[$line['VAL']];
if ($count == 1) {
array_unshift($base_arr, date('d.m', strtotime('-1 day', $date[0])));
array_push($base_arr, date('d.m', strtotime('+1 day', $date[0])));
}
}
if ($option == 'month') {
array_push($base_arr, date('F', $date[0]));
$data_arr[$arr[$line['KEY']]][date('F', $date[0])] = $arr[$line['VAL']];
if ($count == 1) {
array_unshift($base_arr, date('F', strtotime('-1 month', $date[0])));
array_push($base_arr, date('F', strtotime('+1 month', $date[0])));
}
}
if ($option == 'year') {
array_push($base_arr, date('Y', $date[0]));
$data_arr[$arr[$line['KEY']]][date('Y', $date[0])] = $arr[$line['VAL']];
if ($count == 1) {
array_unshift($base_arr, date('Y', strtotime('-1 year', $date[0])));
array_push($base_arr, date('Y', strtotime('+1 year', $date[0])));
}
}
} else {
array_push($base_arr, $arr[$line['DATA']]);
$data_arr[$arr[$line['KEY']]][$arr[$line['DATA']]] = $arr[$line['VAL']];
}
}
foreach ($data_arr as $key => $value) {
if (count($value) == 1) {
array_unshift($data_arr[$key], 0);
array_push($data_arr[$key], 0);
}
}
print "<div class='chart-wrapper'>";
print "<svg version='1.2' xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' class='chart' aria-labelledby='title' role='img' height='100%' width='100%' viewBox='0 0 " . $chart_width . " " . $chart_height . "'>";
print base_chart($base_arr, array(floor($max / 2), $max), $height, $max_width, 50);
if ($select != 0) {
print data_chart($data_arr[$select], 1, $max, $height, $max_width, 50);
} else {
$i = 1;
foreach ($data_arr as $key => $value) {
print data_chart($value, $i, $max, $height, $max_width, 50);
$i++;
}
}
print "</svg>";
if (count($data_arr) > 1) {
print "<ul class='legend'>";
$i = 1;
foreach ($data_arr as $key => $value) {
print "<li><div class='color-box color-" . $i . "'></div>" . $key . "</li>";
$i++;
}
print "</ul>";
}
print "</div>";
}
function tbody($params)
{
global $conn, $modul, $sub_page, $pages;
if (!isset($sub_page) or $sub_page == 0) {
$sub_page = 1;
}
if ($modul == 'content_tree') {
if (isset($params['FILTER'])) {
$arr_tmp = create_tree('content_tree', 0, $params['FILTER']);
} else {
$arr_tmp = create_tree('content_tree', 0);
}
if ($arr_tmp) {
$tbody = "<div class='table-body tree'>";
$tbody .= tree_nav_table($params, 'content', $arr_tmp, tree_get_parents('content_tree', NULL));
$tbody .= "</div><!-- /.table-body -->";
}
} else {
if (!isset($params['FILTER'])) {
$params['FILTER'] = NULL;
} elseif (!isset($params['SORT'])) {
$params['SORT'] = NULL;
}
if (!isset($params['GROUP'])) {
$params['GROUP'] = NULL;
}
if (!isset($params['ADD'])) {
$params['ADD'] = NULL;
}
$result = db_mysql_query(select_tbody($params['TABLE'], $params['SORT'], $params['FILTER'], $params['GROUP'], $params['ADD'], 100), $conn);
if ($sub_page <= 1) {
$sql_sub = "SELECT * FROM information_schema.COLUMNS WHERE TABLE_NAME = '" . $_SESSION['TABLE_PREFIX'] . $modul . "' AND COLUMN_NAME = 'sort_order' ";
$result_sub = db_mysql_query($sql_sub, $conn);
if ($modul == 'content_tree') {
$tbody = "<div class='table-body tree'>";
} else {
if (db_mysql_num_rows($result_sub)) {
$tbody = "<div class='table-body sortable'>";
} else {
$tbody = "<div class='table-body " . $modul . "'>";
}
}
}
while ($arr = db_mysql_fetch_array($result)) {
$tbody .= "<div class='table-row' id='" . $arr['id'] . "' >";
foreach ($params['TABLE'] as $key => $value) {
$data = init($arr[$key], $value, $key);
if ($value == 'activate') {
$tbody .= "<div class='table-cell icon-only " . $key . "'>";
if ($arr[$key]) {
$tbody .= "<a href='#' class='icon-cell " . $key . "_de" . $value . "' data-content='" . $modul . "' id='" . $arr['id'] . "' ><i class='icon-" . $value . "-active'></i>";
} else {
$tbody .= "<a href='#' class='icon-cell " . $key . "_" . $value . "' data-content='" . $modul . "' id='" . $arr['id'] . "' ><i class='icon-" . $value . "'></i>";
}
$tbody .= "</div><!-- /.table-cell -->";
} else {
$tbody .= "<div class='table-cell " . $key . "'>" . $data . "</div><!-- /.table-cell -->";
}
}
if (count(array_filter($params['CONSTRUCT']))) {
$width = 40 + 26 * count(array_filter($params['CONSTRUCT']));
$tbody .= "<div class='table-cell tools' style='width: " . $width . "px;'>";
foreach ($params['CONSTRUCT'] as $key => $value) {
if ($value === true) {
if ($key == 'activate') {
if (!isset($arr['c_default']) or $arr['c_default'] == 0) {
if ($arr['c_active']) {
$tbody .= "<a href='#' class='icon-cell de" . $key . "' data-content='" . $modul . "' id='" . $arr['id'] . "' ><i class='icon-" . $key . "-active'></i>";
} else {
$tbody .= "<a href='#' class='icon-cell " . $key . "' data-content='" . $modul . "' id='" . $arr['id'] . "' ><i class='icon-" . $key . "'></i>";
}
$tbody .= "</a>";
}
} elseif ($key == 'delete') {
if (!isset($arr['c_default']) or $arr['c_default'] == 0) {
$tbody .= "<a href='#' class='icon-cell " . $key . "' data-content='" . $modul . "' id='" . $arr['id'] . "' ><i class='icon-" . $key . "'></i></a>";
}
} else {
$tbody .= "<a href='#' class='icon-cell " . $key . "' data-content='" . $modul . "' id='" . $arr['id'] . "' ><i class='icon-" . $key . "'></i></a>";
}
}
}
$tbody .= "</div><!-- /.table-cell -->";
}
$tbody .= "</div><!-- /.table-row -->";
}
if (ceil($pages) != $sub_page) {
$next_page = $sub_page + 1;
$tbody .= "<form id='next_rows' method='POST'>";
$tbody .= "<input type='hidden' name='modul' value='" . $modul . "'>";
$tbody .= "<input type='hidden' name='params' value='" . serialize($params) . "'>";
$tbody .= "<input type='hidden' name='sub_page' value='" . $next_page . "'>";
$tbody .= "</form>";
}
$tbody .= "</div><!-- /.table-body -->";
}
if (isset($tbody)) {
print $tbody;
}
}
