<a name="show" href="form.php?class_name=extn_report&<?php
echo "mode={$mode}";
?>
" class="show document_id extn_report_id"><i class="fa fa-refresh"></i></a>
</li>
<li><label>Report Name</label> <?php
$f->text_field_dm('report_name');
?>
</li>
<li><label>Description</label> <?php
$f->text_field_dl('description');
?>
</li>
<li class="display_type"><label> Display Type: </label>
<?php
echo $f->select_field_from_object('display_type', extn_report::extn_report_display_type(), 'option_line_code', 'option_line_value', ${$class}->display_type, 'display_type');
?>
</li>
<li><?php
$f->l_select_field_from_object('module_code', option_header::modules(), 'option_line_code', 'option_line_value', ${$class}->module_code, 'module_code');
?>
</li>
</ul>
</div>
<div id="tabsHeader-2" class="tabContent">
<div>
<ul class="column three_column">
<li><label>Path Id</label> <?php
echo $f->text_field_dr('path_id');
?>
</li>
case 'block':
$block_i = block::find_all();
foreach ($block_i as $block_data) {
$block_id = $block_data->block_id;
$report_a[$block_id] = $block_data->title;
}
break;
case 'view':
$view_i = view::find_all();
foreach ($view_i as $view_data) {
$view_id = $view_data->view_id;
$report_a[$view_id] = $view_data->view_name;
}
break;
case 'extn_report':
$view_i = extn_report::find_all();
foreach ($view_i as $view_data) {
$view_id = $view_data->extn_report_id;
$report_a[$view_id] = $view_data->report_name;
}
break;
}
if (!empty($user_dashboard_config->user_dashboard_config_id)) {
if (empty($user_dashboard_config->user_id)) {
$user->uesr_id = $user->username = null;
} else {
$user = user::find_by_id($user_dashboard_config->user_id);
}
}
}
?>
foreach ($_GET['sort_data'] as $sort_data) {
$report->user_sort[$sort_data['name']] = $sort_data['value'];
}
}
echo '<div id="return_divId">' . $report->show_reportResult() . '</div>';
} else {
return false;
}
}
}
?>
<?php
if (!empty($_GET['viewReportById']) && !empty($_GET['extn_report_id'])) {
$report_i = new extn_report();
$report_i->extn_report_id = $_GET['extn_report_id'];
echo '<div id="return_divId">';
$report_i->reportResultById();
echo '</div>';
}
?>
<?php
if (!empty($_GET['delete']) && $_GET['delete'] == 1) {
echo '<div id="json_delete_fileds">';
$content_name = $_GET['content_name'];
$field_name = $_GET['field_name'];
$result = content::drop_column($content_name, $field_name);
if ($result == 1) {
$svgimg->setProperty('_chart_name', $view->view_name);
$svgimg->setProperty('_chart_width', $chart_width);
$svgimg->setProperty('_chart_height', $chart_height);
$svgimg->setProperty('_chart_type', $chart_type);
$svgimg->result = $result;
$svgimg->legend_name = str_replace('.', '__', $chart_legend);
$svgimg->chart_label = str_replace('.', '__', $chart_label);
$svgimg->chart_value = str_replace('.', '__', $chart_value);
$svg_chart = $svgimg->getSvgChart_forView();
echo '<div id="return_divId">' . $svg_chart . '</div>';
} else {
return false;
}
} else {
if (!empty($_GET['extn_report_id'])) {
$report = new extn_report();
$report->pageno = !empty($_GET['pageno']) ? $_GET['pageno'] : 1;
$report->per_page = !empty($_GET['per_page']) ? $_GET['per_page'] : 20;
$report->extn_report_id = $_GET['extn_report_id'];
if (!empty($_GET['filter_data'])) {
foreach ($_GET['filter_data'] as $filter_data) {
$report->user_filter[$filter_data['name']] = $filter_data['value'];
}
}
if (!empty($_GET['sort_data'])) {
foreach ($_GET['sort_data'] as $sort_data) {
$report->user_sort[$sort_data['name']] = $sort_data['value'];
}
}
$report->update_extn_report_query_by_userInputs();
$report->chart_type = !empty($_GET['chart_type']) ? $_GET['chart_type'] : $report->chart_type;
$block = new block();
$block_i = $block->findAll();
echo '<div id="return_divId">';
foreach ($block_i as $b) {
echo "<option value='{$b->block_id}' >" . $b->title . '</option>';
}
echo '</div>';
} else {
if ($report_type == 'view') {
$view = new view();
$view_i = $view->findAll();
echo '<div id="return_divId">';
foreach ($view_i as $b) {
echo "<option value='{$b->view_id}' >" . $b->view_name . '</option>';
}
echo '</div>';
} else {
if ($report_type == 'report') {
$view = new extn_report();
$view_i = $view->findAll();
echo '<div id="return_divId">';
foreach ($view_i as $b) {
echo "<option value='{$b->extn_report_id}' >" . $b->report_name . '</option>';
}
echo '</div>';
} else {
return false;
}
}
}
}
