function view($dd = false)
{
global $com_name, $html_path, $dv_conf;
$name = $dd['dv_id'];
$document = App::get('document');
dv_add_script('util.js');
/* jQuery */
dv_add_script('jquery.js');
/* Bootstrap */
dv_add_script('bootstrap/bootstrap.js');
dv_add_css('bootstrap/css/bootstrap.css');
/* jQuery-UI */
dv_add_script('jquery-ui/jquery-ui.min.js');
dv_add_css('jquery-ui/smoothness/jquery-ui.min.css');
dv_add_css('font-awesome/css/font-awesome.css');
dv_add_script('excanvas.js');
dv_add_script('jquery-datatables/jquery.dataTables.min.js');
dv_add_css('jquery-datatables/css/jquery.dataTables_themeroller.css');
dv_add_css('jquery-datatables/css/jquery.dataTables_dv.css');
dv_add_script('datatables.plugins.js');
dv_add_script('jqplot/jquery.jqplot.min.js');
dv_add_script('jqplot/plugins.dev');
dv_add_css('jqplot/jquery.jqplot.css');
dv_add_script('spreadsheet.js');
dv_add_css('spreadsheet.css');
dv_add_script('dv-spreadsheet-charts.js');
dv_add_script('dv-spreadsheet-charts-dl.js');
dv_add_script('dv_custom_views.js');
dv_add_css('dv_custom_views.css');
dv_add_script('jquery.lazyload.min.js');
if (isset($dd['show_maps'])) {
dv_add_script('/leaflet/leaflet.js');
dv_add_css('/leaflet/leaflet.css');
dv_add_script('dv_maps.js');
}
dv_add_script('jquery.dv.js');
$dv_conf['settings']['view']['id'] = $dd['dv_id'];
$dv_conf['settings']['view']['type'] = 'spreadsheet';
$dv_conf['settings']['data_url'] = "index.php?option=com_{$com_name}&task=data&db=" . $dd['db_id']['id'] . '&dv=' . $dd['dv_id'];
$dv_conf['settings']['view_url'] = "/dataviewer/view/{$dd['db_id']['id']}/{$dd['dv_id']}/";
// Get the list of IDs if any
$rec_ids = Request::getVar('id', '');
if ($rec_ids != '') {
$dv_conf['settings']['data_url'] .= '&id=' . htmlentities($rec_ids);
$dv_conf['settings']['view_url'] .= '?id=' . htmlentities($rec_ids);
} else {
$dv_conf['settings']['view_url'] .= '?dv_first=1';
}
// Version
$version = isset($dd['version']) ? "&v={$dd['version']}" : '';
$dv_conf['settings']['data_url'] .= $version;
$dv_conf['settings']['view_url'] .= $version;
if ($dd) {
$dv_conf['settings']['show_filter_options'] = isset($dd['filter_options']) ? $dd['filter_options'] : true;
$custom_field_url = '';
$custom_field = Request::getVar('custom_field', false);
if ($custom_field) {
$custom_field_url = '&custom_field=' . $custom_field;
}
// Custom views
$custom_view = Request::getVar('custom_view', false);
$custom_view_url = '';
if ($custom_field) {
$custom_view_url = '&custom_view=' . $custom_field;
}
// overrides
$dv_conf['settings']['limit'] = isset($dd['display_limit']) ? $dd['display_limit'] : $dv_conf['settings']['limit'];
$dv_conf['settings']['hide_data'] = isset($dd['hide_data']);
$dv_conf['settings']['serverside'] = isset($dd['serverside']) && $dd['serverside'] ? true : false;
if (!isset($dd['customizer']) && isset($dv_conf['customizer'])) {
$dd['customizer'] = $dv_conf['customizer'];
}
if (isset($dd['customizer']) && $dd['customizer'] === false) {
unset($dd['customizer']);
}
$dv_conf['settings']['serverside'] = isset($dd['serverside']) && $dd['serverside'] ? true : false;
$sql = query_gen($dd);
$res = get_results($sql, $dd);
// Customizer View
$hide_str = '';
$group_by = '';
$show_customizer = true;
if (isset($dd['customizer'])) {
if (isset($dd['customizer']['show_table']) && !$dd['customizer']['show_table']) {
$hide_str = 'display: none;';
}
if (isset($dd['customizer']['show_customizer']) && !$dd['customizer']['show_customizer']) {
$show_customizer = false;
}
if (isset($dd['group_by'])) {
$arr = explode(',', $dd['group_by']);
foreach ($arr as $a) {
$a = trim($a);
$lbl = isset($dd['cols'][$a]['label']) ? $dd['cols'][$a]['label'] : $a;
$group_by .= '<div class="dv_customizer_group_by_item_div" style="padding: 3px; margin: 5px; border: 1px #EEE solid;"><input type="checkbox" checked="checked" class="dv_customizer_group_by_item" value="' . $a . '" /> <label style="cursor: pointer;">' . str_replace('<br />', ' ', $lbl) . '</label></div>';
}
}
}
$f_data = filter($res, $dd);
$d_arr = json_decode($f_data, true);
if (isset($dd['show_maps'])) {
$document->addScript('//maps.google.com/maps/api/js?sensor=false');
}
$help_file = false;
if (isset($dv_conf['help_file_base_path'])) {
$help_file = $dv_conf['help_file_base_path'] . $name . '/' . $name . '-help.html';
if (!file_exists(JPATH_BASE . $help_file)) {
$help_file = false;
}
}
$return = '';
if (isset($dd['return']) && isset($dd['return']['raw'])) {
$return = $dd['return']['raw'];
} elseif (isset($dd['return'])) {
$return = '<span id="dv_return_link" style="font-size: 1.1em; margin-left: 10px; padding-top: 12px;"><a href="' . $dd['return']['url'] . '"><strong>' . $dd['return']['label'] . '</strong></a></span>';
}
// Filtered Views
$filter = Request::getVar('filter', false);
$filted_view = array();
$filted_view_str = '';
if ($filter !== false) {
$dv_conf['settings']['data_url'] .= '&filter=' . $filter;
$dv_conf['settings']['filters']['fv_vals'] = $filter;
$ff = explode('||', $filter);
foreach ($ff as $f) {
$f = explode('|', $f);
$filted_view[$f[0]] = $f[1];
}
}
?>
<a name="dv_top"></a>
<div id="dv-spreadsheet">
<?php
if (!Request::getVar('show_table_only', false)) {
?>
<div id="dv_title" style="margin: 0;">
<h2 class="ui-corner-all" style="display: inline-block;">
<i class="icon-table"></i>
<?php
print $dd['title'];
?>
</h2>
<h4 id="dv_return_link_container" style="display: inline-block; margin: 0;"><?php
print $return;
?>
</h4>
</div>
<div id="dv-spreadsheet-toolbar" class="ui-corner-top">
<?php
if (!isset($dd['top_menu']['download']['show']) || $dd['top_menu']['download']['show'] != false) {
?>
<button class="btn btn-mini dv-btn-download" data-format="csv" title="Download Data as a spreadsheet">
<i class="icon-download"> </i >
<span class="lbl">Download</span>
</button>
<?php
}
?>
<?php
if (!isset($dd['top_menu']['fullscreen']['show']) || $dd['top_menu']['fullscreen']['show'] != false) {
?>
<button id="dv-btn-fullscreen" class="btn btn-mini" title="Fullscreen" data-screen-mode=''>
<i class="icon-fullscreen"> </i >
<span class="lbl">Fullscreen</span>
</button>
<?php
}
?>
<?php
if (isset($dd['filters']) && count($dd['filters']) > 0) {
?>
<button id="dv-btn-filters" class="btn btn-mini" title="Filter Dialog">
<i class="icon-filter"> </i >
<span class="lbl">Filter Dialog</span>
</button>
<?php
}
?>
<button id="dv-btn-filter-clear-all" class="btn btn-mini" title="Click this to clear all the column filters and the global search">
<i class="icon-remove-circle"> </i >
<span class="lbl">Clear Filters</span>
</button>
<?php
if (!isset($dd['top_menu']['no_wrap']['show']) || $dd['top_menu']['no_wrap']['show'] != false) {
?>
<button id="dv-btn-no-wrap" class="btn btn-mini" title="Disable text wrapping for all cells." data-current="normal">
<i class="icon-text-width"> </i >
<span class="lbl">No-Wrap</span>
</button>
<?php
}
?>
<?php
if (isset($dd['custom_charts']) || isset($dd['charts_list'])) {
?>
<button id="dv-spreadsheet-charts" class="btn btn-mini" title="Display charts">
<i class="icon-bar-chart"> </i >
<span class="lbl">Charts</span>
</button>
<?php
}
?>
<?php
if (isset($dd['show_maps'])) {
?>
<button id="dv-spreadsheet-maps" class="btn btn-mini" title="Display Maps">
<i class="icon-map-marker"></i >
<span class="lbl">Maps</span>
</button>
<?php
}
?>
<?php
if (isset($dd['customizer'])) {
?>
<button id="dv-customizer-btn" class="btn btn-mini" title="Enables users to select a sub-set of columns to view.">
<i class="icon-edit"> </i >
<span class="lbl">Customize DataView</span>
</button>
<?php
}
?>
</div>
<div style="display: none;">
<span id="dv_top_toolbar" class="ui-corner-top" style="padding: 3px 5px 3px 3px; margin: 0; border-style: inset; border-bottom-width: 0px;">
<?php
if ($help_file) {
?>
<button id="dv_show_help">Help</button>
<?php
}
?>
<?php
if (isset($dd['show_maps'])) {
?>
<input type="checkbox" id="dv_maps" class="dv_panel_btn" /><label for="dv_maps">Map</label>
<?php
}
?>
<?php
if (isset($dd['customizer']) && $show_customizer) {
?>
<input type="checkbox" id="" class="dv_panel_btn" /><label for="dv-customizer-btn"></label>
<?php
} elseif (isset($dd['customizer'])) {
?>
<input type="checkbox" id="dv-customizer-btn" class="dv_panel_btn" /><label for="dv-customizer-btn">Customize View</label>
<?php
}
?>
</span>
</div>
<?php
if (isset($dd['custom_charts']) || isset($dd['charts_list'])) {
?>
<div id="dv_charts_panel" style="display: none; clear: both; width: 860px; height: 380px; padding: 5px 10px 10px 5px; margin-top: 0; border: 1px solid #DDD; background: #EEE;" class="ui-corner-bottom dv_top_pannel">
<button id="dv_pdcharts_download_btn" class="btn btn-mini btn-success" title="Download chart as an image" style="float: right; z-index: 1; margin: 3px;">
<i class="icon-download"> </i >
<span class="lbl">Download Chart</span>
</button>
<button id="dv_pdcharts_draw_btn" class="btn btn-mini btn-info" title="Reload charts" style="float: right; z-index: 1; margin: 3px;">
<i class="icon-repeat"> </i >
<span class="lbl">Reload</span>
</button>
<div style="float:left; height: 380px; width: 245px;">
<div id="dv_charts_control_panel" style="padding: 0 5px; ">
<?php
if (isset($dd['charts_list'])) {
?>
<select id="dv_chart_name" style="width: 100%;">
<?php
$pd_id = 0;
foreach ($dd['charts_list'] as $cl) {
?>
<option value="<?php
print $pd_id;
?>
"><?php
print $cl['title'];
?>
</option>
<?php
$pd_id++;
}
?>
</select>
<div id="dv_chart_desc" class=" ui-widget-content ui-corner-all" style="margin-top: 10px; font-size: 0.9em; border-style: inset; padding: 2px; overflow: auto; height: 340px;"></div>
<?php
}
?>
</div>
</div>
<div id="dv_charts_preview_chart" style="height:100%; width:auto; margin-left: 248px;" class="ui-widget-content ui-corner-all">
</div>
</div>
<?php
}
?>
<?php
if (isset($dd['show_maps'])) {
?>
<div id="dv_maps_panel" style="position: relative; display: none; clear: both; width: 800px; height: 300px; padding: 3px 5px 3px 5px; margin-top: 0;" class="ui-widget ui-widget-header ui-corner-bottom dv_top_pannel">
<button class="btn btn-inverse btn-mini" title="Click here to reload the map" id="dv_map_reload" style="float: left;">
<i class="icon-refresh"></i > Reload Map
</button>
<div style="float: right;">
<button data-format="kml" class="btn btn-inverse btn-mini dv-btn-download" style="background: #FAA732; background-image: linear-gradient(to bottom, #FBB450, #F89406); background-repeat: repeat-x;" title="Export location data in KML format">
<i class="icon-download"></i > KML
</button>
<button data-format="kmz" class="btn btn-inverse btn-mini dv-btn-download" style="background: #FAA732; background-image: linear-gradient(to bottom, #FBB450, #F89406); background-repeat: repeat-x;" title="Export location data in KMZ format">
<i class="icon-download"></i > KMZ
</button>
<button data-format="shp" class="btn btn-inverse btn-mini dv-btn-download" style="background: #FAA732; background-image: linear-gradient(to bottom, #FBB450, #F89406); background-repeat: repeat-x;" title="Export location data in SHP format">
<i class="icon-download"></i > SHP
</button>
</div>
<div id="dv_maps_canvas" style="position: absolute; top: 30px; bottom: 8px; left: 5px; right: 8px;" class="ui-widget-content ui-corner-all"></div>
</div>
<?php
}
?>
<?php
if (isset($dd['customizer'])) {
?>
<?php
$full_list = '';
$selected = '';
foreach ($dd['cols'] as $id => $prop) {
if (!isset($prop['hide']) || isset($prop['hide']) && $prop['hide'] != 'hide') {
if (!isset($prop['label'])) {
$prop['label'] = $id;
}
$col_label = str_replace('<br />', ' ', $prop['label']);
$col_label = str_replace('<hr />', ' / ', $col_label);
if (isset($prop['units']) && $prop['units'] != '') {
$col_label = $col_label . ' <small>[' . $prop['units'] . ']</small>';
} elseif (isset($prop['unit']) && $prop['unit'] != '') {
$col_label = $col_label . ' <small>[' . $prop['unit'] . ']</small>';
}
if (isset($dd['customizer']['selected']) && in_array($id, $dd['customizer']['selected'])) {
$first_col = true;
$selected .= '<li data-dv-id="' . $id . '">' . $col_label . '</li>';
} else {
$full_list .= '<li data-dv-id="' . $id . '">' . $col_label . '</li>';
}
}
}
?>
<div id="dv_customizer_panel" style="display: none; clear: both; padding: 5px 10px 10px 5px; margin-top: 0;" class="ui-widget ui-widget-header ui-corner-bottom dv_top_pannel">
<div id="dv_customizer_content" style="height:100%; width:auto;" class="ui-widget-content ui-corner-all">
<div id="dv_customizer_group_by" title="Customizer Group Rows" style="display: none; width: 500px; height: 350px;">
<p>You can use this option to group rows of the views by certain fields to reduce duplicate rows</p>
<div id="dv_customizer_group_by_list"><?php
print $group_by;
?>
</div>
</div>
<p id="dv_customizer_title_container" style="padding-left: 10px;">
New Title: <input id="dv_customizer_view_title" value="<?php
print $dd['title'];
?>
" type="text" style="width: 550px;" />
<input id="dv_customizer_group_by_btn" data-view-url="<?php
print $dv_conf['settings']['view_url'];
?>
" value="Group By [Reduce Duplicates]" type="button" style="display: none; padding: 2px;" />
<input id="dv_customizer_launch_view_btn" data-view-url="<?php
print $dv_conf['settings']['view_url'];
?>
" value="Launch Custom View" type="button" style="display: none; padding: 2px;" />
</p>
<table border="0">
<tr id="dv_customizer_lists_top">
<td style="width: 400px;">Full Columns List</td>
<td style="width: 400px;">Custom List</td>
</tr>
<tr>
<td>
<div class="dv_customizer_lists" style="overflow: auto;">
<ul id="dv_customizer_full_list" class="dv_customizer_col_lists">
<?php
print $full_list;
?>
</ul>
</div>
</td>
<td>
<div class="dv_customizer_lists" style="overflow: auto;">
<ul id="dv_customizer_selected" class="dv_customizer_col_lists">
<?php
print $selected;
?>
</ul>
</div>
</td>
</tr>
</table>
</div>
</div>
<?php
}
?>
<div id="more_information" style="display: none; min-width: 300px;"></div>
<?php
if ($help_file) {
?>
<div id="dv_help_dialog" style="display: none;">
<iframe src="<?php
print $help_file;
?>
" id="modalIframeId" width="100%" height="100%" marginWidth="0" marginHeight="0" frameBorder="0" scrolling="auto" title="Help">IFRAMES not supported by the browser</iframe>
</div>
</div>
<?php
}
?>
<?php
}
//Table Only
?>
<div id="dv-spreadsheet-container" style="margin: 0px; padding; 0px; <?php
print $hide_str;
?>
">
<table id="dv-spreadsheet-tbl" style="margin-top: 0;">
<?php
print '<thead></thead><tfoot><tr>';
$colid = 0;
foreach ($dd['cols'] as $id => $conf) {
if (!isset($conf['hide'])) {
$label = isset($conf['label']) ? $conf['label'] : $id;
$label = str_replace('<br />', ' ', $label);
$label = html_entity_decode(strip_tags($label), ENT_QUOTES, 'UTF-8');
$title = '';
$filter_msg = '';
if ($dv_conf['settings']['serverside']) {
$filter_msg = " \n\nThe dropdown list only shows a limited number of available options. \n\nIf you don't see what you want on the list, please enter a filter text in the text box and then press Enter to bring up more results to match your text.";
} else {
$filter_msg = "\t\n\nClick on the search box to list all the entries in the column";
}
if (isset($conf['filter_hint'])) {
$filter_hint = $conf['filter_hint'];
} else {
if ($d_arr['field_types'][$id] == 'number' || $d_arr['field_types'][$id] == 'numrange') {
$filter_hint = "Enter a number to filter this column by.";
$filter_hint .= " \n\nFollowing filter options are also supported,";
$filter_hint .= "\t\nRange filtering - ( e.g. 15.7 to 25 )";
$filter_hint .= "\t\nLess than, greater than ( e.g. <100 ), (e.g. >25)";
$filter_hint .= "\t\nLess than or equal, greater than or equal ( e.g. <=-12.5 ), (e.g. >=0.3)";
$filter_hint .= "\t\nEqual, not equal and ignore pattern ( e.g. =-2.55 ), ( e.g. !=-2.55 ), ( e.g. !55 )";
} elseif ($d_arr['field_types'][$id] == 'datetime') {
$filter_hint = "Enter a date to filter this column by.";
$filter_hint .= "\t\nRange filtering - ( e.g. 2011-01-25 to 2011-03-25 )";
$filter_hint .= "\t\nLess than, greater than ( e.g. <2011-03-25 ), (e.g. >2011-01-25)";
$filter_hint .= "\t\nLess than or equal, greater than or equal ( e.g. <=2011-03-25 ), (e.g. >=2010-03-25)";
$filter_hint .= "\t\nEqual, not equal and ignore pattern ( e.g. =2009-01-17 ), ( e.g. !=2009-01-17 ), ( e.g. !2009-01 )";
} else {
$filter_hint = "Enter a word or a phrase to filter this column by.";
$filter_hint .= " \n\nFollowing filter options are also supported,";
$filter_hint .= "\t\nExact matches, use '=' ( e.g. =keyword)";
$filter_hint .= "\t\nTo ignore a specific word, use '!=' ( e.g. !=keyword)";
$filter_hint .= "\t\nTo ignore a pattern, use '!' ( e.g. !keyword )";
}
}
$title = $filter_hint . $filter_msg;
if (isset($conf['type']) && $conf['type'] == 'image') {
print '<th><input title="' . $title . '" type="text" placeholder="' . $label . '" disabled=disabled /></th>';
} elseif (isset($filted_view[$id])) {
print '<th><input type="text" placeholder="' . $filted_view[$id] . '" disabled=disabled style="background: yellow;" /></th>';
} else {
print '<th><input title="' . $title . '" type="text" placeholder="' . $label . '" class="search_init" style="background: #FFF;" /><span class="dv-col-clear-filter" style="margin-left: -15px; color: #FFF; cursor: pointer;"><i class="icon-remove-sign"></i></span></th>';
}
}
$colid++;
}
print '</tr></tfoot>';
?>
</table>
</div>
<?php
// Filter dialog show/hide parameter
$dv_show_filters = 'false';
$path = explode('/', Request::path());
if (isset($path[5]) && $path[5] == 'filter_dialog') {
$dv_show_filters = 'true';
}
//Legacy support
if (Request::getVar('show_filters', 'false') === 'true') {
$dv_show_filters = 'true';
}
?>
<!-- Start: Dialog boxes -->
<div id="truncated_text_dialog" style="display: none; overflow: auto;" title="Full Text"></div>
<div id="dv_filters_dialog" title="<?php
print $dd['title'];
?>
: Filters">
<div id="dv_filters_tabs">
<ul></ul>
</div>
</div>
<!-- End: Dialog boxes -->
<script>
dv_data = <?php
print $f_data;
?>
;
dv_settings = <?php
print json_encode($dv_conf['settings']);
?>
;
dv_show_filters = <?php
print $dv_show_filters;
?>
;
dv_settings.show_charts = <?php
print Request::getInt('show_chart', 'undefined');
?>
;
dv_show_customizer = <?php
print $show_customizer ? 'true' : 'false';
?>
;
var dv_show_maps = <?php
print Request::getString('show_map', 'undefined');
?>
;
</script>
<form style="display: none;" id="dv-spreadsheet-dl" method="POST"
action="<?php
print $dv_conf['settings']['data_url'];
?>
&nolimit=true<?php
print $custom_view_url . $custom_field_url;
?>
">
</form>
</div>
<?php
}
}
/**
* Get data as CSV file
*
* @param string $db_name
* @param integer $version
*
* @return string data
*/
public function getCsvData($db_name = '', $version = '', $tmpFile = '')
{
if (!$db_name || !$version) {
return false;
}
mb_internal_encoding('UTF-8');
// component path for "com_dataviewer"
$dv_com_path = PATH_CORE . DS . 'components' . DS . 'com_dataviewer';
require_once $dv_com_path . DS . 'dv_config.php';
require_once $dv_com_path . DS . 'lib' . DS . 'db.php';
require_once $dv_com_path . DS . 'modes' . DS . 'mode_dsl.php';
require_once $dv_com_path . DS . 'filter' . DS . 'csv.php';
$dv_conf = get_conf(NULL);
$dd = get_dd(NULL, $db_name, $version);
$dd['serverside'] = false;
$sql = query_gen($dd);
$result = get_results($sql, $dd);
ob_start();
filter($result, $dd, true);
$csv = ob_get_contents();
ob_end_clean();
if ($csv && $tmpFile) {
$handle = fopen($tmpFile, 'w');
fwrite($handle, $csv);
fclose($handle);
return true;
}
return $csv;
}
function task_data($db_id)
{
global $dv_conf;
$dd = get_dd($db_id);
if (!authorize($dd)) {
print '<br /><p class="error">Sorry, you are not authorized to view this page.</p>';
return;
}
$filter = strtolower(Request::getVar('type', 'json'));
$file = JPATH_COMPONENT . DS . "filter/{$filter}.php";
if (file_exists($file)) {
require_once $file;
}
if ($dd) {
$link = get_db();
$sql = query_gen($dd);
$res = get_results($sql, $dd);
print filter($res, $dd);
exit(0);
} else {
print print "<p class=\"error\">Invalid Request</p>";
exit(1);
}
}
