$conn = new mysqli($server, $user_ro, $pass_ro, $db);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "select c.child_name_id, c.html_class \n" . "from data_chart.param_input_child c \n" . "where c.option_value = '" . $name_id . "' \n" . "order by c.order_num \n";
if (!$conn->query($sql)) {
$error_arr[] = $conn->error;
}
$result = $conn->query($sql);
while ($row = $result->fetch_assoc()) {
$child_name_id = $row["child_name_id"];
$html_class = $row["html_class"];
$html .= formElemCreate($child_name_id, $html_class);
}
$id_second_part = idFromFirstOptions($html);
$id = idWrapAdd("{$id_first_part} {$id_second_part}");
$def = definitionCreate($id);
$filter_type = $def->info->filter_type;
if (count($error_arr) === 0) {
$conn->commit();
$status = "success";
} else {
$conn->rollback();
$status = "failure";
}
$output = new stdClass();
$output->html = $html;
$output->status = $status;
$output->errorArr = $error_arr;
// $output->debugSQL = $sql;
function categoryHTML($area)
{
require_once SERVER_ROOT . '/php/dist/extension.php';
require_once SERVER_ROOT . '/module/definition/module.php';
require_once SERVER_ROOT . '/module/form_elem/module.php';
require_once SERVER_ROOT . '/module/category/dist/id_from_first_options.php';
$html_class = "m-category";
switch ($area) {
case 'y-axis':
$html_class .= " areatype-axis";
break;
case 'x-axis':
$html_class .= " areatype-axis";
break;
case 'filters':
$html_class .= " areatype-filters";
break;
default:
break;
}
$category_html = formElemCreate("category", null, $area);
$id = idFromFirstOptions($category_html);
$id = idWrapAdd($id);
$def = definitionCreate($id);
$filter_type = $def->info->filter_type;
$filter_wrap_html_class = 'filter-wrap row';
if ($filter_type === 'none') {
$filter_wrap_html_class .= ' hidden';
}
ob_start();
//Function continues...
?>
<div class="<?php
echo $html_class;
?>
">
<div class="category-wrap">
<?php
echo $category_html;
?>
</div>
<div class="<?php
echo $filter_wrap_html_class;
?>
">
<div class="operator-wrap col-xs-4 halfPad-xs">
<?php
echo formElemCreate("filter_operator", "operator");
?>
</div>
<div class="col-xs-8 noPad-xs">
<div class="equal-wrap col-xs-6 halfPad-xs hidden">
<?php
echo formElemCreate("filter_min", "equal");
?>
</div>
<div class="min-wrap col-xs-6 halfPad-xs hidden">
<?php
echo formElemCreate("filter_min", "min");
?>
</div>
<div class="max-wrap col-xs-6 halfPad-xs hidden">
<?php
echo formElemCreate("filter_max", "max");
?>
</div>
</div>
</div>
</div>
<?php
//...function continues.
$html = ob_get_clean();
return $html;
}
