}
});
</script>';
if ($_SESSION["back_to_menu"])
$xt->assign("back_to_menu", true);
else
$xt->assign("back_to_menu", false);
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
$xt->assign("chart_block", true);
$xt->assign("chart_constructor", $show_dchart);
$xt->assign("load_flash_player", $load_flash_player);
if (!IsStoredProcedure($chrt_array['sql']))
$xt->assign("testAdvSearch", testAdvSearch($chrt_array['tables'][0]));
else
$xt->assign("testAdvSearch", false);
$chart_name_js = jsreplace(postvalue('cname'));
$xt->assign("chart_name_js", $chart_name_js);
$xt->assign("chart_title", runner_htmlspecialchars($chrt_array['title']));
$xt->assign("short_table_name", runner_htmlspecialchars($chrt_array['settings']['short_table_name']));
$xt->assign("short_table_name_js", jsreplace($chrt_array['settings']['short_table_name']));
$xt->assign("ext", "php");
$searchType = (!is_wr_project()) ? GetTableLink("dsearch") : GetTableLink(runner_htmlspecialchars($chrt_array['settings']['short_table_name']), "search");
$xt->assign("searchHref", "href='" . $searchType . "?cname=" . $chart_name_js . "'");
$templatefile = GetTemplateName("", "dchart");
$xt->display($templatefile);
?>
if ( !empty( $arr ) ){
$b_includes .= "<script type='text/javascript'>
$(document).ready(function(){"."\r\n";
for ($i=0; $i < count($arr); $i++) {
$b_includes .= "
tr_elem = $('.condition-row').eq('".$i."');
$(tr_elem).show();
$(tr_elem).find('input, select').each(function(){
this.disabled = false;
});
$(tr_elem).find('select#field_opt').val('".jsreplace($arr[$i]["field_opt"])."');
$(tr_elem).find('input#filter_value').val('".jsreplace($arr[$i]["filter_value"])."');
$(tr_elem).find('input#first_or_value').val('".jsreplace($arr[$i]["first_or_value"])."');
$(tr_elem).find('input#second_or_value').val('".jsreplace($arr[$i]["second_or_value"])."');
$(tr_elem).find('input#third_or_value').val('".jsreplace($arr[$i]["third_or_value"])."');
"."\r\n";
}
$b_includes .= '
tr_elem = $(".condition-row").eq('.count($arr).');
$(tr_elem).show();
$(tr_elem).find("input, select").each(function(){
this.disabled = false;
});
});
</script>'."\r\n";
}
$xt->assign("report_name_preview",$_SESSION['webreports']['settings']['name']);
$xt->assign("b_includes", $b_includes);
$xt->assign("wr_pagestylepath", $wr_pagestylepath);
Reload_Chart(postvalue("cname"));
}
}
include 'include/xtempl.php';
$xt = new Xtempl();
$chrt_array = getChartArray(postvalue("cname"));
if (is_wr_project()) {
include "include/" . $chrt_array['settings']['short_table_name'] . "_variables.php";
}
$show_dchart = '<script type="text/javascript" language="javascript">
//<![CDATA[
var chart = new AnyChart("' . GetRootPathForResources("libs/swf/AnyChart.swf") . '", "' . GetRootPathForResources("libs/swf/Preloader.swf") . '");
chart.width = "780";
chart.height = "570";
var xmlFile = "' . GetTableLink("dchartdata", "", 'cname=' . jsreplace(runner_htmlspecialchars(postvalue('cname')))) . '";
xmlFile += "&ctype=' . $chrt_array['chart_type']['type'] . '";
chart.setXMLFile(xmlFile);
chart.write();
//]]>
</script>';
$load_flash_player = '
<script type="text/javascript">
var svgSupported = window.SVGAngle != undefined;
var str="";
if (!svgSupported)
{
str = "<center>";
str += "' . "" . '<br /><br />";
str += "<a href=\\"http://www.adobe.com/go/getflashplayer\\"><img border=\\"0\\" src=\\"http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\\" /></a><br />";
str += "</center>";
$jscode.="TEXT_MONTH_DEC='".jsreplace("December")."';\r\n";
$jscode.="TEXT_DAY_SU='".jsreplace("Su")."';\r\n";
$jscode.="TEXT_DAY_MO='".jsreplace("Mo")."';\r\n";
$jscode.="TEXT_DAY_TU='".jsreplace("Tu")."';\r\n";
$jscode.="TEXT_DAY_WE='".jsreplace("We")."';\r\n";
$jscode.="TEXT_DAY_TH='".jsreplace("Th")."';\r\n";
$jscode.="TEXT_DAY_FR='".jsreplace("Fr")."';\r\n";
$jscode.="TEXT_DAY_SA='".jsreplace("Sa")."';\r\n";
$jscode.="TEXT_TODAY='".jsreplace("today")."';\r\n";
$jscode .= '
locale_dateformat = "'.$locale_info["LOCALE_IDATE"].'";
locale_datedelimiter = "'.$locale_info["LOCALE_SDATE"].'";
bLoading = false;
TEXT_PLEASE_SELECT = "'.jsreplace("Please select").'";
detect = navigator.userAgent.toLowerCase();
checkIt = function(string)
{
place = detect.indexOf(string) + 1;
thestring = string;
return place;
}
ShowHideControls = function ()
{';
foreach ( $inspect_fields as $fld ) {
if(is_wr_db())
$fld_type=WRGetFieldType($fld['table'].".".$fld['name']);
elseif(is_wr_custom())
$fld_type=WRCustomGetFieldType($fld['table'],$fld['name']);
else
function WRProcessLargeText($text,$field,$recid,$chars,$mode,$strLabel, $isProgectTable = false)
{
if(!$chars)
return $text;
if($mode!=MODE_LIST && $mode!=MODE_PRINT || strlen($text)<$chars+10)
return $text;
if($isProgectTable)
$shortening = GetShorteningForLargeText($text, $cNumberOfChars);
else
$shortening = substr($text,0,$chars);
if($mode==MODE_PRINT)
{
return $shortening."...";
}
// List page
$id="textbox_".GoodFieldName($field).$recid;
$textbox="<span style=\"display:none\" id=\"".$id."\">".runner_htmlspecialchars($text)."</span>";
$link="<a href=# onclick=\"
var offset = $(this).offset();
offset.left -= $(window).scrollLeft();
offset.top -= $(window).scrollTop();
$('#".$id."').clone().dialog(
{
title: '".jsreplace($strLabel)."',
draggable: true,
resizable: true,
bgiframe: true,
modal: false,
minheight:400,
position:[offset.left-50,offset.top-50]
}
);
return false;
\"> "."More"."...</a>";
return $shortening.$link.$textbox;
}
if(!is_numeric($i))
continue;
$b_includes .= '
tr_elem = $(".condition-row").eq('.$i.');
$(tr_elem).show();
$(tr_elem).find("input, select").each(function(){
if ((this.id == "group_by_value" || this.id == "having_value") && !$("#group_by_toggle")[0].checked) {
return;
}
this.disabled = false;
});
$(tr_elem).find("select#field_opt").val(\''.jsreplace($arr[$i]['field_opt']).'\');
$(tr_elem).find("input#filter_value").val(\''.jsreplace($arr[$i]['filter_value']).'\');
$(tr_elem).find("input#first_or_value").val(\''.jsreplace($arr[$i]['first_or_value']).'\');
$(tr_elem).find("input#second_or_value").val(\''.jsreplace($arr[$i]['second_or_value']).'\');
$(tr_elem).find("input#third_or_value").val(\''.jsreplace($arr[$i]['third_or_value']).'\');
sortDir = $(tr_elem).find("select#sort_dir").get(0);
$(sortDir).val("'.($arr[$i]['sort_dir']).'");
sortOrder=$(tr_elem).find("select#sort_order").get(0);
sortOrder.options[sortOrder.options.length]=new Option("","'.($arr[$i]['sort_order']).'");
$(sortOrder).val("'.($arr[$i]['sort_order']).'");
$(tr_elem).find("select#group_by_value").val("'.($arr[$i]['group_by_value']).'");
$(tr_elem).find("input#having_value").val("'.($arr[$i]['having_value']).'");
if(!$(sortDir).val() || $(sortDir).val()=="-1")
$(sortOrder).hide();
else
$(sortOrder).show();
'."\r\n";
}
$b_includes .= '
function WRProcessLargeText($text, $field, $recid, $chars, $mode, $strLabel, $isProgectTable = false)
{
if (!$chars) {
return $text;
}
if ($mode != MODE_LIST && $mode != MODE_PRINT || strlen($text) < $chars + 10) {
return $text;
}
if ($isProgectTable) {
$shortening = GetShorteningForLargeText($text, $cNumberOfChars);
} else {
$shortening = substr($text, 0, $chars);
}
if ($mode == MODE_PRINT) {
return $shortening . "...";
}
// List page
$id = "textbox_" . GoodFieldName($field) . $recid;
$textbox = "<span style=\"display:none\" id=\"" . $id . "\">" . $text . "</span>";
$link = "<a href=# onclick=\"\n\t\n\tvar offset = \$(this).offset();\n\toffset.left -= \$(window).scrollLeft();\n\toffset.top -= \$(window).scrollTop();\n\t\$('#" . $id . "').clone().dialog(\n\t{\ntitle: '" . jsreplace($strLabel) . "',\n\t\tdraggable: true,\n\t\tresizable: true,\n\t\tbgiframe: true,\n\t\tmodal: false,\n\t\tminheight:400,\n\t\tposition:[offset.left-50,offset.top-50]\n\t}\n\t);\n\treturn false;\n\t\"> " . "Más" . "...</a>";
return $shortening . $link . $textbox;
}
function BuildSelectControl($field, $value, $fieldNum = 0, $mode, $id = "", $additionalCtrlParams, &$pageObj)
{
global $conn, $strTableName;
// read control settings
$table = $strTableName;
$strLabel = Label($field);
$is508 = isEnableSection508();
$alt = "";
if (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $is508) {
$alt = ' alt="' . htmlspecialchars($strLabel) . '" ';
}
$cfield = "value_" . GoodFieldName($field) . "_" . $id;
$clookupfield = "display_value_" . GoodFieldName($field) . "_" . $id;
$openlookup = "open_lookup_" . GoodFieldName($field) . "_" . $id;
$ctype = "type_" . GoodFieldName($field) . "_" . $id;
if ($fieldNum) {
$cfield = "value" . $fieldNum . "_" . GoodFieldName($field) . "_" . $id;
$ctype = "type" . $fieldNum . "_" . GoodFieldName($field) . "_" . $id;
}
$addnewitem = false;
$advancedadd = false;
$strCategoryControl = CategoryControl($field, $table);
$categoryFieldId = GoodFieldName(CategoryControl($field, $table));
$bUseCategory = UseCategory($field, $table);
$dependentLookups = GetFieldData($table, $field, "DependentLookups", array());
$lookupType = GetLookupType($field, $table);
$LCType = LookupControlType($field, $table);
$horizontalLookup = GetFieldData($table, $field, "HorizontalLookup", false);
$inputStyle = $additionalCtrlParams['style'] ? 'style="' . $additionalCtrlParams['style'] . '"' : '';
$lookupTable = GetLookupTable($field, $table);
$strLookupWhere = LookupWhere($field, $table);
$lookupSize = SelectSize($field, $table);
if ($LCType == LCT_CBLIST) {
$lookupSize = 2;
}
// simply > 1 for CBLIST
$add_page = GetTableURL($lookupTable) . "_add.php";
$list_page = GetTableURL($lookupTable) . "_list.php";
$strPerm = GetUserPermissions($lookupTable);
// alter "add on the fly" settings
if (strpos($strPerm, "A") !== false) {
$addnewitem = GetFieldData($table, $field, "AllowToAdd", false);
$advancedadd = !GetFieldData($table, $field, "SimpleAdd", false);
if (!$advancedadd) {
$addnewitem = false;
}
}
// alter lookuptype settings
if ($LCType == LCT_LIST && strpos($strPerm, "S") === false) {
$LCType = LCT_DROPDOWN;
}
if ($LCType == LCT_LIST) {
$addnewitem = false;
}
if ($mode == MODE_SEARCH) {
$addnewitem = false;
}
// prepare multi-select attributes
$multiple = "";
$postfix = "";
if ($lookupSize > 1) {
$avalue = splitvalues($value);
$multiple = " multiple";
$postfix = "[]";
} else {
$avalue = array((string) $value);
}
// prepare JS code
$className = "DropDownLookup";
if ($LCType == LCT_AJAX) {
$className = "EditBoxLookup";
} elseif ($LCType == LCT_LIST) {
$className = "ListPageLookup";
} elseif ($LCType == LCT_CBLIST) {
$className = "CheckBoxLookup";
}
// build the control
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// list of values
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($lookupType == LT_LISTOFVALUES) {
// read lookup values
$arr = GetFieldData($table, $field, "LookupValues", array());
// print Type control to allow selecting nothing
if ($lookupSize > 1) {
echo "<input id=\"" . $ctype . "\" type=hidden name=\"" . $ctype . "\" value=\"multiselect\">";
}
// dropdown control
if ($LCType == LCT_DROPDOWN) {
$alt = "";
echo '<select id="' . $cfield . '" size = "' . $lookupSize . '" ' . $alt . 'name="' . $cfield . $postfix . '" ' . $multiple . '>';
if ($lookupSize < 2) {
echo '<option value="">' . mlang_message("PLEASE_SELECT") . '</option>';
} else {
if ($mode == MODE_SEARCH) {
echo '<option value=""> </option>';
}
}
foreach ($arr as $opt) {
$res = array_search((string) $opt, $avalue);
if (!($res === NULL || $res === FALSE)) {
echo '<option value="' . htmlspecialchars($opt) . '" selected>' . htmlspecialchars($opt) . '</option>';
} else {
echo '<option value="' . htmlspecialchars($opt) . '">' . htmlspecialchars($opt) . '</option>';
}
}
echo "</select>";
} elseif ($LCType == LCT_CBLIST) {
echo '<div align=\'left\'>';
$spacer = '<br/>';
if ($horizontalLookup) {
$spacer = ' ';
}
$i = 0;
foreach ($arr as $opt) {
echo '<input id="' . $cfield . '_' . $i . '" type="checkbox" ' . $alt . ' name="' . $cfield . $postfix . '" value="' . htmlspecialchars($opt) . '"';
$res = array_search((string) $opt, $avalue);
if (!($res === NULL || $res === FALSE)) {
echo ' checked="checked" ';
}
echo '/>';
echo ' <b id="data_' . $cfield . '_' . $i . '">' . htmlspecialchars($opt) . '</b>' . $spacer;
$i++;
}
echo '</div>';
}
return;
}
// build table-based lookup
////////////////////////////////////////////////////////////////////////////////////////////
// table-based ajax-lookup control
////////////////////////////////////////////////////////////////////////////////////////////
if ($LCType == LCT_AJAX || $LCType == LCT_LIST) {
////////////////////////////////////////////////////////////////////////////////////////////
// dependent ajax-lookup control
////////////////////////////////////////////////////////////////////////////////////////////
if (UseCategory($field)) {
// ajax dependent dropdown
// get parent value
$celementvalue = "var parVal = ''; var parCtrl = Runner.controls.ControlManager.getAt('" . jsreplace($strTableName) . "', " . $id . ", '" . jsreplace($field) . "', 0).parentCtrl; if (parCtrl){ parVal = parCtrl.getStringValue();};";
if ($LCType == LCT_AJAX) {
echo '<input type="text" categoryId="' . $categoryFieldId . '" autocomplete="off" id="' . $clookupfield . '" name="' . $clookupfield . '" ' . $inputStyle . '>';
} elseif ($LCType == LCT_LIST) {
echo '<input type="text" categoryId="' . $categoryFieldId . '" autocomplete="off" id="' . $clookupfield . '" name="' . $clookupfield . '" readonly ' . $inputStyle . '>';
echo " <a href=# id=" . $openlookup . ">" . mlang_message("SELECT_LIST") . "</a>";
}
echo '<input type="hidden" id="' . $cfield . '" name="' . $cfield . '">';
// add new item link
if ($addnewitem) {
echo " <a href=# id='addnew_" . $cfield . "'>" . mlang_message("ADD_NEW") . "</a>";
}
return;
}
////////////////////////////////////////////////////////////////////////////////////////////
// regular ajax-lookup control
////////////////////////////////////////////////////////////////////////////////////////////
// get the initial value
$lookup_value = "";
$lookupSQL = buildLookupSQL($field, $table, "", $value, false, true, false, true);
$rs_lookup = db_query($lookupSQL, $conn);
if ($data = db_fetch_numarray($rs_lookup)) {
$lookup_value = $data[1];
} elseif (strlen($strLookupWhere)) {
// try w/o WHERE expression
$lookupSQL = buildLookupSQL($field, $table, "", $value, false, true, false, true);
$rs_lookup = db_query($lookupSQL, $conn);
if ($data = db_fetch_numarray($rs_lookup)) {
$lookup_value = $data[1];
}
}
// build the control
if ($LCType == LCT_AJAX) {
if (!strlen($lookup_value) && GetFieldData($strTableName, $field, "freeInput", false)) {
$lookup_value = $value;
}
echo '<input type="text" ' . $inputStyle . ' autocomplete="off" ' . (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $is508 == true ? 'alt="' . $strLabel . '" ' : '') . 'id="' . $clookupfield . '" name="' . $clookupfield . '" value="' . htmlspecialchars($lookup_value) . '">';
} elseif ($LCType == LCT_LIST) {
echo '<input type="text" autocomplete="off" ' . $inputStyle . ' id="' . $clookupfield . '" ' . (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $is508 == true ? 'alt="' . $strLabel . '" ' : '') . 'name="' . $clookupfield . '" value="' . htmlspecialchars($lookup_value) . '" readonly >';
echo " <a href=# id=" . $openlookup . ">" . mlang_message("SELECT_LIST") . "</a>";
}
echo '<input type="hidden" id="' . $cfield . '" name="' . $cfield . '" value="' . htmlspecialchars($value) . '">';
// add new item
if ($addnewitem) {
echo " <a href=# id='addnew_" . $cfield . "'>" . mlang_message("ADD_NEW") . "</a>";
}
return;
}
////////////////////////////////////////////////////////////////////////////////////////////
// classic lookup - start
////////////////////////////////////////////////////////////////////////////////////////////
$lookupSQL = buildLookupSQL($field, $table, "", "", false, false, false);
$rs = db_query($lookupSQL, $conn);
////////////////////////////////////////////////////////////////////////////////////////////
// dependent classic lookup
////////////////////////////////////////////////////////////////////////////////////////////
if ($bUseCategory) {
// print Type control to allow selecting nothing
if ($lookupSize > 1) {
echo "<input id=\"" . $ctype . "\" type=hidden name=\"" . $ctype . "\" value=\"multiselect\">";
}
echo '<select size = "' . $lookupSize . '" id="' . $cfield . '" name="' . $cfield . $postfix . '"' . $multiple . '>';
echo '<option value="">' . mlang_message("PLEASE_SELECT") . '</option>';
echo "</select>";
if ($addnewitem) {
echo " <a href=# id='addnew_" . $cfield . "'>" . mlang_message("ADD_NEW") . "</a>";
}
return;
}
////////////////////////////////////////////////////////////////////////////////////////////
// simple classic lookup
////////////////////////////////////////////////////////////////////////////////////////////
// print control header
if ($lookupSize > 1) {
echo "<input id=\"" . $ctype . "\" type=hidden name=\"" . $ctype . "\" value=\"multiselect\">";
}
if ($LCType != LCT_CBLIST) {
echo '<select size = "' . $lookupSize . '" id="' . $cfield . '" ' . (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $is508 == true ? 'alt="' . $strLabel . '" ' : '') . 'name="' . $cfield . $postfix . '"' . $multiple . '>';
if ($lookupSize < 2) {
echo '<option value="">' . mlang_message("PLEASE_SELECT") . '</option>';
} else {
if ($mode == MODE_SEARCH) {
echo '<option value=""> </option>';
}
}
} else {
echo '<div align=\'left\'>';
$spacer = '<br/>';
if ($horizontalLookup) {
$spacer = ' ';
}
}
// print lookup data
$found = false;
$i = 0;
while ($data = db_fetch_numarray($rs)) {
$res = array_search((string) $data[0], $avalue);
$checked = "";
if (!($res === NULL || $res === FALSE)) {
$found = true;
if ($LCType == LCT_CBLIST) {
$checked = " checked=\"checked\"";
} else {
$checked = " selected";
}
}
if ($LCType == LCT_CBLIST) {
echo '<input id="' . $cfield . '_' . $i . '" type="checkbox" ' . $alt . ' name="' . $cfield . $postfix . '" value="' . htmlspecialchars($data[0]) . '"' . $checked . '/>';
echo ' <b id="data_' . $cfield . '_' . $i . '">' . htmlspecialchars($data[1]) . '</b>' . $spacer;
} else {
echo '<option value="' . htmlspecialchars($data[0]) . '"' . $checked . '>' . htmlspecialchars($data[1]) . '</option>';
}
$i++;
}
// try the same query w/o WHERE clause if current value not found
if (!$found && strlen($value) && $mode == MODE_EDIT && strlen($strLookupWhere)) {
$lookupSQL = buildLookupSQL($field, $table, "", $value, false, true, false, false, true);
$rs = db_query($lookupSQL, $conn);
if ($data = db_fetch_numarray($rs)) {
if ($LCType == LCT_CBLIST) {
echo '<input id="' . $cfield . '_' . $i . '" type="checkbox" ' . $alt . ' name="' . $cfield . $postfix . '" value="' . htmlspecialchars($data[0]) . '" checked="checked"/>';
echo ' <b id="data_' . $cfield . '_' . $i . '">' . htmlspecialchars($data[1]) . '</b>' . $spacer;
} else {
echo '<option value="' . htmlspecialchars($data[0]) . '" selected>' . htmlspecialchars($data[1]) . '</option>';
}
}
}
// print footer
if ($LCType != LCT_CBLIST) {
echo "</select>";
} else {
echo '</div>';
}
// add new item
if ($addnewitem) {
echo " <a href=# id='addnew_" . $cfield . "'>" . mlang_message("ADD_NEW") . "</a>";
}
}
function xt_showchart($params)
{
$width=700;
$height=530;
$chartPreview = "";
if($params["chartPreview"])
$chartPreview = "&chartPreview=true";
if(isset($params["custom1"]))
$width=$params["custom1"];
if(isset($params["custom2"]))
$height=$params["custom2"];
if ($params["resize"])
{
$maxWidth = 400;
$maxHeight = 280;
$r = $maxWidth / $maxHeight;
$r2 = $width / $height;
if (($width > $maxWidth) || ($height > $maxHeight))
{
if ($r2 >= $r)
{ // width
$height = round( $height * $maxWidth / $width );
$width = $maxWidth;
}
else
{
$width = round ( $width * $maxHeight / $height );
$height = $maxHeight;
}
}
}
$showDetails = isset( $params["showDetails"] ) ? $params["showDetails"] : true;
$settings = new ProjectSettings(GetTableByShort($params["chartname"]));
$refresh = $settings->getChartRefreshTime()*60000;
if ($_SERVER["SERVER_PORT"]==443)
$http = "https";
else
$http="http";
?>
<div id='<?php echo $params["chartname"].$params["id"] ?>' style="width:<?php echo $width; ?>px;height:<?php echo $height; ?>px">
<?php if (!$params["singlePage"]) { ?>
<script type="text/javascript" language="javascript" src="libs/js/AnyChart.js"></script>
<script type="text/javascript" language="javascript" src="libs/js/AnyChartHTML5.js"></script>
<script type="text/javascript">
<?php global $useFlashChartLibrary; if (!$useFlashChartLibrary) { ?>
var svgSupported = !!document.createElementNS && !!document.createElementNS('http://www.w3.org/2000/svg', 'svg').createSVGRect;
AnyChart.renderingType = svgSupported ? anychart.RenderingType.SVG_PREFERRED : anychart.RenderingType.FLASH_PREFERRED;
<?php } else { ?>
AnyChart.renderingType = anychart.RenderingType.FLASH_PREFERRED;
<?php } ?>
</script>
<script type="text/javascript" language="javascript">
//<![CDATA[
var chart = new AnyChart('libs/swf/AnyChart.swf','libs/swf/Preloader.swf');
chart.width = '<?php echo $width; ?>';
chart.height = '<?php echo $height; ?>';
chart.wMode='opaque';
chart.id = 'chart_' + '<?php echo $params["chartname"];?>';
var xmlFile = '<?php echo GetTableLink("dchartdata")?>?chartname=<?php echo jsreplace($params["chartname"]).$chartPreview;?>';
xmlFile += '&ctype=<?php echo $params["ctype"];?>';
xmlFile += '&showDetails=<?php echo $showDetails;?>';
xmlFile += '&hasFlash=' + AnyChart.platform.hasRequiredVersion;
chart.setXMLFile(xmlFile);
chart.write('<?php echo $params["chartname"].$params["id"];?>');
<?php
$chartname = jsreplace($params["chartname"]);
if($params["ctype"]=="Gauge")
$refrFunction="Runner.updateGaugeChart(\'".$chartname."\')";
else
$refrFunction="Runner.updateChart(\'".$chartname."\', ".($showDetails ? "true" : "false").")";
if(!$useFlashChartLibrary && ( $params["ctype"]=="2DPie" || $params["ctype"]=="2DDoughnut" || $params["ctype"]=="Funnel" || $params["ctype"]=="OHLC" || $params["ctype"]=="Candle" ))
$refresh="0";
if($refresh!="0" && !isMobile())
echo "setInterval('".$refrFunction."',".$refresh.");";
?>
//]]>
</script>
<?php } ?>
</div>
<?php
}
{
if(is_wr_custom())
$table_name="";
else
$table_name=$arr[$i]["table"].".";
$computed_value = ($arr[$i]["agr_func"]) ?
$arr[$i]["agr_func"]."(".$table_name.$arr[$i]["name"].")" :
$table_name.$arr[$i]["name"];
if ($_SESSION['webcharts']['chart_type']['type']!="ohlc" && $_SESSION['webcharts']['chart_type']['type']!="candlestick")
{
$b_includes .= 'if($("select[id=field' . ($i+1) . ']").val()==\''.jsreplace($computed_value).'\')
$("input[id=series_label_' . ($i+1) . ']").val(\''.jsreplace($arr[$i]["label"]).'\');'."\r\n";
}
else
$b_includes .= '$("input[id=series_label_' . ($i+1) . ']").val(\''.jsreplace($arr[$i]["label"]).'\');'."\r\n";
}
}
$b_includes .= '});
</script>'."\r\n";
if(is_wr_project())
$xt->assign("disable", "disabled");
if ($_SESSION['webcharts']['chart_type']['type']!="gauge" && $_SESSION['webcharts']['chart_type']['type']!="bubble")
$xt->assign("separator","style='display:none'");
if ($_SESSION['webcharts']['chart_type']['type']!="bubble")
$xt->assign("span_style","style='display:none'");
function xt_showchart($params)
{
$width = 700;
$height = 530;
if (array_key_exists("custom1", $params)) {
$width = $params["custom1"];
}
if (array_key_exists("custom2", $params)) {
$height = $params["custom2"];
}
$refresh = GetTableData($params["table"], ".ChartRefreshTime", 10) * 60000;
if ($_SERVER["SERVER_PORT"] == 443) {
$http = "https";
} else {
$http = "http";
}
?>
<div id='<?php
echo $params["chartname"];
?>
'>
<noscript>
<object id="<?php
echo $params['chartname'];
?>
"
name="<?php
echo $params['chartname'];
?>
"
classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
width="100%"
height="100%"
codebase="<?php
echo $http;
?>
://fpdownload.macromedia.com/get/flashplayer/current/swflash.cab">
<param name="movie" value="libs/swf/Preloader.swf" />
<param name="bgcolor" value="#FFFFFF" />
<param name="wmode" value="opaque" />
<param name="allowScriptAccess" value="always" />
<param name="flashvars" value="swfFile=<?php
echo 'dchartdata.php%3Fchartname%3D' . $params['chartname'];
?>
" />
<embed type="application/x-shockwave-flash"
pluginspage="<?php
echo $http;
?>
://www.adobe.com/go/getflashplayer"
src="libs/swf/Preloader.swf"
width="100%"
height="100%"
id="<?php
echo $params['chartname'];
?>
"
name="<?php
echo $params['chartname'];
?>
"
bgColor="#FFFFFF"
allowScriptAccess="always"
flashvars="swfFile=<?php
echo 'dchartdata.php%3Fchartname%3D' . $params['chartname'];
?>
" />
</object>
</noscript>
<script type="text/javascript">
//<![CDATA[
document.write('<center>');
document.write("You need to have Adobe Flash Player 9 (or above) to view the chart.<br /><br />");
document.write("<a href=\"<?php
echo $http;
?>
://www.adobe.com/go/getflashplayer\"><img border=\"0\" src=\"<?php
echo $http;
?>
://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\" /></a><br />");
document.write('</center>');
//]]>
</script>
<script type="text/javascript" language="javascript" src="libs/js/AnyChart.js"></script>
<script type="text/javascript" language="javascript">
//<![CDATA[
var chart = new AnyChart('libs/swf/AnyChart.swf','libs/swf/Preloader.swf');
chart.width = '<?php
echo $width;
?>
';
chart.height = '<?php
echo $height;
?>
';
chart.wMode='opaque';
var xmlFile = 'dchartdata.php?chartname=<?php
echo jsreplace($params["chartname"]);
?>
';
xmlFile += '&ctype=<?php
echo $params["ctype"];
?>
';
chart.setXMLFile(xmlFile);
chart.write('<?php
echo $params["chartname"];
?>
');
if("<?php
echo $refresh;
?>
"!="0")
setInterval('refreshChart()',<?php
echo $refresh;
?>
);
function refreshChart()
{
page='dchartdata.php?chartname=<?php
echo jsreplace($params["chartname"]);
?>
';
params={
action:'refresh',
rndval:Math.random()
};
$.get(page,params,function(xml)
{
var arr = new Array();
arr=xml.split("\n");
for(i=0; i<arr.length;i+=2)
{
chart.removeSeries(arr[i]);
chart.addSeries(arr[i+1]);
chart.updatePointData(arr[i]+"_gauge",arr[i]+"_point",{value: arr[i+1]});
}
chart.refresh();
});
}
//]]>
</script>
</div>
<?php
}
foreach($value["right_fields"] as $k=>$val)
$b_includes .= "rel.right_fields[".$k."]='".$val."';";
}
}
$b_includes .= "option = new Option('".jsreplace($arr_parts[0])."','".jsreplace($arr_parts[1])."');
option.rel=rel;
var objSel=document.getElementById('rel_list');
objSel.options[objSel.length]=option;
if (table_stack['".jsreplace($arr_parts[1])."'] == undefined)
{
table_stack['".jsreplace($arr_parts[1])."'] = 1;
$('#left_tables').append(\"<option value='".jsreplace($arr_parts[1])."'>".$arr_parts[1]."</option>\");
}
else
{
table_stack['".jsreplace($arr_parts[1])."'] = table_stack['".jsreplace($arr_parts[1])."'] + 1;
}
"."\r\n";
$c++;
}
}
else
{
$b_includes .='$("#left_tables").val($("#left_tables")[0].options[1].value);
$("#left_tables").change();';
}
$b_includes .= '});
function live_change(th)
{
var id = th.id.substr(th.id.length-1),
tr = $(th).parent().parent(),
public function buildAJAXLookup($value, $mode)
{
////////////////////////////////////////////////////////////////////////////////////////////
// dependent ajax-lookup control
////////////////////////////////////////////////////////////////////////////////////////////
if ($this->bUseCategory) {
// ajax dependent dropdown
// get parent value
$celementvalue = "var parVal = ''; var parCtrl = Runner.controls.ControlManager.getAt('" . jsreplace($this->pageObject->tName) . "', " . $this->id . ", '" . jsreplace($this->field) . "', 0).parentCtrl; if (parCtrl){ parVal = parCtrl.getStringValue();};";
if ($this->LCType == LCT_AJAX) {
echo '<input type="text" categoryId="' . $this->categoryFieldId . '" autocomplete="off" id="' . $this->clookupfield . '" name="' . $this->clookupfield . '" ' . $this->inputStyle . '>';
} else {
if ($this->LCType == LCT_LIST) {
echo '<input type="text" categoryId="' . $this->categoryFieldId . '" autocomplete="off" id="' . $this->clookupfield . '" name="' . $this->clookupfield . '" readonly ' . $this->inputStyle . '>';
echo " <a href=# id=" . $this->openlookup . ">" . "Select" . "</a>";
}
}
echo '<input type="hidden" id="' . $this->cfield . '" name="' . $this->cfield . '">';
// add new item link
if ($this->addnewitem) {
echo " <a href=# id='addnew_" . $this->cfield . "'>" . "Add new" . "</a>";
}
return;
}
////////////////////////////////////////////////////////////////////////////////////////////
// regular ajax-lookup control
////////////////////////////////////////////////////////////////////////////////////////////
// get the initial value
$lookup_value = "";
$lookupSQL = buildLookupSQL($this->lookupPageType, $this->field, $this->pageObject->tName, "", $value, false, true, false, true);
$this->fillLookupFieldsIndexes();
$rs_lookup = db_query($lookupSQL, $this->conn);
if ($data = db_fetch_numarray($rs_lookup)) {
if ($this->isDisplayFieldEncrypted) {
$lookup_value = $this->ciphererDisplay->DecryptField($this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field, $data[$this->displayFieldIndex]);
} else {
$lookup_value = $data[$this->displayFieldIndex];
}
} elseif (strlen($this->strLookupWhere)) {
// try w/o WHERE expression
$lookupSQL = buildLookupSQL($this->lookupPageType, $this->field, $this->pageObject->tName, "", $value, false, true, false, false);
$rs_lookup = db_query($lookupSQL, $this->conn);
if ($data = db_fetch_numarray($rs_lookup)) {
if ($this->isDisplayFieldEncrypted) {
$lookup_value = $this->ciphererDisplay->DecryptField($this->lookupType == LT_QUERY ? $this->displayFieldName : $this->field, $data[$this->displayFieldIndex]);
} else {
$lookup_value = $data[$this->displayFieldIndex];
}
}
}
// build the control
if ($this->LCType == LCT_AJAX) {
if (!strlen($lookup_value) && ($this->pageObject->pSetEdit->isfreeInput($this->field) || $this->lookupPageType == PAGE_SEARCH)) {
$lookup_value = $value;
}
echo '<input type="text" ' . $this->inputStyle . ' autocomplete="off" ' . (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $this->is508 == true ? 'alt="' . $this->strLabel . '" ' : '') . 'id="' . $this->clookupfield . '" name="' . $this->clookupfield . '" value="' . htmlspecialchars($lookup_value) . '">';
} elseif ($this->LCType == LCT_LIST) {
echo '<input type="text" autocomplete="off" ' . $this->inputStyle . ' id="' . $this->clookupfield . '" ' . (($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $this->is508 == true ? 'alt="' . $this->strLabel . '" ' : '') . 'name="' . $this->clookupfield . '" value="' . htmlspecialchars($lookup_value) . '" readonly >';
echo " <a href=# id=" . $this->openlookup . ">" . "Select" . "</a>";
}
echo '<input type="hidden" id="' . $this->cfield . '" name="' . $this->cfield . '" value="' . htmlspecialchars($value) . '">';
// add new item
if ($this->addnewitem) {
echo " <a href=# id='addnew_" . $this->cfield . "'>" . "Add new" . "</a>";
}
}
function GetLockInfo($strtable, $keys, $links, $pageid)
{
$page = GetTableLink(GetTableURL($strtable), "edit");
$skeys = "";
foreach ($keys as $ind => $val) {
if (strlen($skeys)) {
$skeys .= "&";
}
$skeys .= rawurlencode($val);
}
$where = $this->connection->addFieldWrappers("table") . "=" . $this->connection->prepareString($strtable) . " AND " . $this->connection->addFieldWrappers("keys") . "=" . $this->connection->prepareString($skeys) . " AND " . $this->connection->addFieldWrappers("sessionid") . "<>'" . session_id() . "' AND " . $this->connection->addFieldWrappers("action") . "=1";
$qResult = $this->query($where, $this->connection->addFieldWrappers("id") . " asc");
if ($data = $qResult->fetchAssoc()) {
$sdate = now();
$arrDateTime = db2time($data["startdatetime"]);
$str = mysprintf($this->LockAdmin, array($data["userid"], round(secondsPassedFrom($data["startdatetime"]) / 60, 2)));
if ($links) {
$str .= '<a class="unlock" href="#" onclick="Runner.pages.PageManager.getAt(\'' . runner_htmlspecialchars(jsreplace($strtable)) . '\', ' . $pageid . ').locking.UnlockAdmin(\'' . runner_htmlspecialchars(jsreplace($skeys)) . '\',\'' . $data["sessionid"] . '\',\'no\');return false;">' . "Desbloquear registro" . '</a>';
$str .= '<a class="edit" href="#" onclick="Runner.pages.PageManager.getAt(\'' . runner_htmlspecialchars(jsreplace($strtable)) . '\', ' . $pageid . ').locking.UnlockAdmin(\'' . runner_htmlspecialchars(jsreplace($skeys)) . '\',\'' . $data["sessionid"] . '\',\'yes\');return false;">' . "Editar registro" . '</a>';
}
return $str;
}
return "";
}
function BuildSecondDropdownArray($arrName, $strSQL)
{
global $conn;
echo $arrName . "=new Array();\r\n";
$i = 0;
$rs = db_query($strSQL, $conn);
while ($row = db_fetch_numarray($rs)) {
echo $arrName . "[" . $i * 3 . "]='" . jsreplace($row[0]) . "';\r\n";
echo $arrName . "[" . ($i * 3 + 1) . "]='" . jsreplace($row[1]) . "';\r\n";
echo $arrName . "[" . ($i * 3 + 2) . "]='" . jsreplace($row[2]) . "';\r\n";
$i++;
}
}
$fields_type=array();
$fields_type=WRGetAllCustomFieldType();
}
foreach ($group_fields as $fld) {
if(!is_wr_custom())
$type = WRGetFieldType($fld);
else
$type = $fields_type[$fld];
if ( IsNumberType( $type ) ) {
$b_includes .= "fld_types['" . jsreplace($fld) . "'] = \"number\";"."\r\n";
} elseif ( IsCharType( $type ) ) {
$b_includes .= "fld_types['" . jsreplace($fld) . "'] = \"string\";"."\r\n";
} elseif ( IsDateFieldType( $type ) ) {
$b_includes .= "fld_types['" . jsreplace($fld) . "'] = \"date\";"."\r\n";
}
}
if (is_wr_db()) {
$b_includes .= '
var NEXT_PAGE_URL = "'.GetTableLink("webreport4").'",
PREV_PAGE_URL = "'.GetTableLink("webreport2").'";
'."\r\n";
} else {
$b_includes .= '
var NEXT_PAGE_URL = "'.GetTableLink("webreport4").'",
PREV_PAGE_URL = "'.GetTableLink("webreport0").'";
'."\r\n";
}
function GetLockInfo($strtable, $keys, $links, $pageid)
{
$page = GetTableURL($strtable) . "_edit.php";
$skeys = "";
foreach ($keys as $ind => $val) {
if (strlen($skeys)) {
$skeys .= "&";
}
$skeys .= rawurlencode($val);
}
$rstmp = $this->TableObj->Query(AddFieldWrappers("table") . "=" . db_prepare_string($strtable) . " and " . AddFieldWrappers("keys") . "=" . db_prepare_string($skeys) . " and " . AddFieldWrappers("sessionid") . "<>'" . session_id() . "' and " . AddFieldWrappers("action") . "=1", AddFieldWrappers("id") . " asc");
if ($data = db_fetch_array($rstmp)) {
$sdate = now();
$arrDateTime = db2time($data["startdatetime"]);
$str = mysprintf($this->LockAdmin, array($data["userid"], round(secondsPassedFrom($data["startdatetime"]) / 60, 2)));
if ($links) {
$str .= '<a class="unlock" href="#" onclick="Runner.pages.PageManager.getAt(\'' . htmlspecialchars(jsreplace($strtable)) . '\', ' . $pageid . ').locking.UnlockAdmin(\'' . htmlspecialchars(jsreplace($skeys)) . '\',\'' . $data["sessionid"] . '\',\'no\');return false;">' . "Unlock record" . '</a>';
$str .= '<a class="edit" href="#" onclick="Runner.pages.PageManager.getAt(\'' . htmlspecialchars(jsreplace($strtable)) . '\', ' . $pageid . ').locking.UnlockAdmin(\'' . htmlspecialchars(jsreplace($skeys)) . '\',\'' . $data["sessionid"] . '\',\'yes\');return false;">' . "Edit record" . '</a>';
}
return $str;
} else {
return "";
}
}
function xt_showchart($params)
{
$width = 700;
$height = 530;
$chartPreview = "";
if ($params["chartPreview"]) {
$chartPreview = "&chartPreview=true";
}
if (isset($params["custom1"])) {
$width = $params["custom1"];
}
if (isset($params["custom2"])) {
$height = $params["custom2"];
}
if ($params["dashResize"]) {
if ($params["dashWidth"] && $params["dashHeight"]) {
$width = $params["dashWidth"];
$height = $params["dashHeight"];
} elseif ($params["dashWidth"]) {
$height = round($height * $params["dashWidth"] / $width);
$width = $params["dashWidth"];
} elseif ($params["dashHeight"]) {
$width = round($width * $params["dashHeight"] / $height);
$height = $params["dashHeight"];
}
// adjust the chart size to fit it in the dash cell
$width *= 0.95;
$height *= 0.95;
} elseif ($params["resize"]) {
$maxWidth = 400;
$maxHeight = 280;
$r = $maxWidth / $maxHeight;
$r2 = $width / $height;
if ($width > $maxWidth || $height > $maxHeight) {
if ($r2 >= $r) {
// width
$height = round($height * $maxWidth / $width);
$width = $maxWidth;
} else {
$width = round($width * $maxHeight / $height);
$height = $maxHeight;
}
}
}
$showDetails = isset($params["showDetails"]) ? $params["showDetails"] : true;
$settings = new ProjectSettings(GetTableByShort($params["chartname"]));
$refresh = $settings->getChartRefreshTime() * 1000;
if ($_SERVER["SERVER_PORT"] == 443) {
$http = "https";
} else {
$http = "http";
}
?>
<div id='<?php
echo $params["chartname"] . $params["id"];
?>
' style="width:<?php
echo $width;
?>
px;height:<?php
echo $height;
?>
px">
<?php
if (!$params["singlePage"]) {
?>
<script type="text/javascript" language="javascript" src="libs/js/AnyChart.js"></script>
<script type="text/javascript" language="javascript" src="libs/js/AnyChartHTML5.js"></script>
<script type="text/javascript">
<?php
global $useFlashChartLibrary;
if (!$useFlashChartLibrary) {
?>
var svgSupported = !!document.createElementNS && !!document.createElementNS('http://www.w3.org/2000/svg', 'svg').createSVGRect;
AnyChart.renderingType = svgSupported ? anychart.RenderingType.SVG_PREFERRED : anychart.RenderingType.FLASH_PREFERRED;
<?php
} else {
?>
AnyChart.renderingType = anychart.RenderingType.FLASH_PREFERRED;
<?php
}
?>
</script>
<script type="text/javascript" language="javascript">
//<![CDATA[
var chart = new AnyChart('libs/swf/AnyChart.swf','libs/swf/Preloader.swf');
chart.width = '<?php
echo $width;
?>
';
chart.height = '<?php
echo $height;
?>
';
chart.wMode='opaque';
chart.id = 'chart_' + '<?php
echo $params["chartname"];
?>
';
var xmlFile = '<?php
echo GetTableLink("dchartdata");
?>
?chartname=<?php
echo jsreplace($params["chartname"]) . $chartPreview;
?>
';
xmlFile += '&ctype=<?php
echo $params["ctype"];
?>
';
xmlFile += '&showDetails=<?php
echo $showDetails;
?>
';
xmlFile += '&hasFlash=' + AnyChart.platform.hasRequiredVersion;
<?php
if (isset($params["dash"]) && $params["dash"]) {
?>
xmlFile += '&dashChart=<?php
echo $params["dash"];
?>
';
<?php
}
?>
<?php
if (isset($params["dashTName"]) && $params["dashTName"]) {
?>
xmlFile += '&dashTName=<?php
echo $params["dashTName"];
?>
';
xmlFile += '&dashElName=<?php
echo $params["dashElementName"];
?>
';
xmlFile += '&pageId=<?php
echo $params["id"];
?>
';
$.ajax( {
type: "GET",
url: xmlFile,
dataType: "xml",
success: function( xml ) {
var $xml = $( xml );
Runner.updateDetailsForDashboardChart( $xml.find( "detail_master_keys" ).text(), $xml.find( "detail_page_id" ).text() );
}
});
<?php
}
?>
chart.setXMLFile(xmlFile);
chart.write('<?php
echo $params["chartname"] . $params["id"];
?>
');
<?php
$chartname = jsreplace($params["chartname"]);
if ($params["ctype"] == "Gauge") {
$refrFunction = "Runner.updateGaugeChart(\\'" . $chartname . "\\')";
} else {
$refrFunction = "Runner.updateChart(\\'" . $chartname . "\\', " . ($showDetails ? "true" : "false") . ", " . ($params["dash"] ? "true" : "false") . ")";
}
if (!$useFlashChartLibrary && ($params["ctype"] == "2DPie" || $params["ctype"] == "2DDoughnut" || $params["ctype"] == "Funnel" || $params["ctype"] == "OHLC" || $params["ctype"] == "Candle")) {
$refresh = "0";
}
if ($refresh != "0" && !isMobile()) {
echo "setInterval('" . $refrFunction . "'," . $refresh . ");";
}
?>
//]]>
</script>
<?php
}
?>
</div>
<?php
}
$jscode .= "TEXT_MONTH_OCT='" . jsreplace("Octubre") . "';\r\n";
$jscode .= "TEXT_MONTH_NOV='" . jsreplace("Noviembre") . "';\r\n";
$jscode .= "TEXT_MONTH_DEC='" . jsreplace("Diciembre") . "';\r\n";
$jscode .= "TEXT_DAY_SU='" . jsreplace("DO") . "';\r\n";
$jscode .= "TEXT_DAY_MO='" . jsreplace("L") . "';\r\n";
$jscode .= "TEXT_DAY_TU='" . jsreplace("MAR") . "';\r\n";
$jscode .= "TEXT_DAY_WE='" . jsreplace("MI") . "';\r\n";
$jscode .= "TEXT_DAY_TH='" . jsreplace("J") . "';\r\n";
$jscode .= "TEXT_DAY_FR='" . jsreplace("V") . "';\r\n";
$jscode .= "TEXT_DAY_SA='" . jsreplace("S") . "';\r\n";
$jscode .= "TEXT_TODAY='" . jsreplace("Hoy") . "';\r\n";
$jscode .= '
locale_dateformat = "' . $locale_info["LOCALE_IDATE"] . '";
locale_datedelimiter = "' . $locale_info["LOCALE_SDATE"] . '";
bLoading = false;
TEXT_PLEASE_SELECT = "' . jsreplace("Por favor seleccione") . '";
detect = navigator.userAgent.toLowerCase();
checkIt = function(string)
{
place = detect.indexOf(string) + 1;
thestring = string;
return place;
}
ShowHideControls = function ()
{';
foreach ($inspect_fields as $fld) {
if (is_wr_db()) {
$fld_type = WRGetFieldType($fld['table'] . "." . $fld['name']);
} elseif (is_wr_custom()) {
$fld_type = WRCustomGetFieldType($fld['table'], $fld['name']);
} else {
function xt_showchart($params)
{
$width = 700;
$height = 530;
if (isset($params["custom1"])) {
$width = $params["custom1"];
}
if (isset($params["custom2"])) {
$height = $params["custom2"];
}
$settings = new ProjectSettings(GetTableByShort($params["chartname"]));
$refresh = $settings->getChartRefreshTime() * 60000;
if ($_SERVER["SERVER_PORT"] == 443) {
$http = "https";
} else {
$http = "http";
}
?>
<div id='<?php
echo $params["chartname"];
?>
' style="width:<?php
echo $width;
?>
px;height:<?php
echo $height;
?>
px">
<noscript>
<object id="'.htmlspecialchars(postvalue('cname')).'"
name="'.htmlspecialchars(postvalue('cname')).'"
classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
width="100%"
height="100%"
codebase="http://fpdownload.macromedia.com/get/flashplayer/current/swflash.cab">
<param name="movie" value="libs/swf/Preloader.swf" />
<param name="bgcolor" value="#FFFFFF" />
<param name="allowScriptAccess" value="always" />
<param name="flashvars" value="swfFile=dchartdata.php%3Fcname%3D'.htmlspecialchars(postvalue('cname')).'%26ctype%3D'.$chrt_array['chart_type']['type'].'" />
<embed type="application/x-shockwave-flash"
pluginspage="http://www.adobe.com/go/getflashplayer"
src="libs/swf/Preloader.swf"
width="100%"
height="100%"
id="'.htmlspecialchars(postvalue('cname')).'"
name="'.htmlspecialchars(postvalue('cname')).'"
bgColor="#FFFFFF"
allowScriptAccess="always"
flashvars="swfFile=dchartdata.php%3Fcname%3D'.htmlspecialchars(postvalue('cname')).'%26ctype%3D'.$chrt_array['chart_type']['type'].'" />
</object>
</noscript>
<script type="text/javascript" language="javascript" src="libs/js/AnyChart.js"></script>
<script type="text/javascript" language="javascript" src="libs/js/AnyChartHTML5.js"></script>
<script type="text/javascript">
AnyChart.renderingType = anychart.RenderingType.FLASH_PREFERRED;
var svgSupported = window.SVGAngle != undefined;
if (!svgSupported)
{
//<![CDATA[
document.write('<center>');
document.write("You need to have Adobe Flash Player 9 (or above) to view the chart.<br /><br />");
document.write("<a href=\"<?php
echo $http;
?>
://www.adobe.com/go/getflashplayer\"><img border=\"0\" src=\"<?php
echo $http;
?>
://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\" /></a><br />");
document.write('</center>');
//]]>
}
</script>
<script type="text/javascript" language="javascript">
//<![CDATA[
var chart = new AnyChart('libs/swf/AnyChart.swf','libs/swf/Preloader.swf');
chart.width = '<?php
echo $width;
?>
';
chart.height = '<?php
echo $height;
?>
';
chart.wMode='opaque';
chart.id = 'chart_' + '<?php
echo $params["chartname"];
?>
';
var xmlFile = 'dchartdata.php?chartname=<?php
echo jsreplace($params["chartname"]);
?>
';
xmlFile += '&ctype=<?php
echo $params["ctype"];
?>
';
chart.setXMLFile(xmlFile);
chart.write('<?php
echo $params["chartname"];
?>
');
if("<?php
echo $refresh;
?>
"!="0" && "<?php
echo isMobile();
?>
"=="false")
setInterval('refreshChart()',<?php
echo $refresh;
?>
);
function refreshChart()
{
page='dchartdata.php?chartname=<?php
echo jsreplace($params["chartname"]);
?>
';
params={
action:'refresh',
rndval:Math.random()
};
$.get(page,params,function(xml)
{
var arr = new Array();
arr=xml.split("\n");
for(i=0; i<arr.length;i+=2)
{
chart.removeSeries(arr[i]);
chart.addSeries(arr[i+1]);
chart.updatePointData(arr[i]+"_gauge",arr[i]+"_point",{value: arr[i+1]});
}
chart.refresh();
});
}
//]]>
</script>
</div>
<?php
}
if (testAdvSearch($rpt_array['tables'][0]))
$xt->assign("adv_search_block", true);
$reportName = "";
if (postvalue('rname'))
$reportName = runner_htmlspecialchars(postvalue('rname'));
else
$reportName = runner_htmlspecialchars(@$_SESSION['webreports']['settings']['name']);
$xt->assign("reportName", $reportName);
if (postvalue("q"))
$xt->assign("searchClause", "&q=" . postvalue("q"));
$xt->assign("reportNamejs", jsreplace(postvalue('rname')));
$xt->assign("reportTitle", runner_htmlspecialchars($rpt_array['settings']['title']));
$xt->assign("shortTableName", runner_htmlspecialchars($rpt_array['short_table_name']));
$xt->assign("shortTableNamejs", jsreplace($rpt_array['short_table_name']));
$searchType = (!is_wr_project()) ? GetTableLink("dsearch") : GetTableLink(runner_htmlspecialchars($rpt_array['short_table_name']), "search");
$xt->assign("searchHref", "href='" . $searchType . "?rname=" . $reportName . "'");
$xt->assign("ext", "php");
if (postvalue("param") == "preview")
$preview = "_preview";
switch ($rpt_array['miscellaneous']['type']){
case "stepped" :
$templatefile = GetTemplateName("", "dreport" . $preview);
break;
case "block" :
$templatefile = GetTemplateName("", "dreport1" . $preview);
echo "</tr>\n";
}
//ID3
for ($af = 0, $j = 0; $j < $naf; $j++) {
/*print files*/
$cmd = "{$avssdir}/bin/id3v2-avss -l \"{$path}/" . $allfiles["fname"][$j] . "\" ";
$fp = popen("{$cmd}", "r");
while ($buffer = fgets($fp, 1024)) {
//$buffer=str_replace("'" , "", $buffer);
//$buffer=str_replace("\n" , "", $buffer);
$buffer = chop($buffer);
$x = explode(":", $buffer, 2);
$f = explode(" ", $x[0], 2);
//first word
if (isset($x[1])) {
$x[1] = jsreplace($x[1]);
} else {
$x[1] = "";
}
$TAGS[$j][$f[0]] = $x[1];
if (isset($ID3s[$j])) {
$ID3s[$j] .= "<b>" . $f[0] . ":</b>" . $x[1] . " ";
} else {
$ID3s[$j] = "<b>" . $f[0] . ":</b>" . $x[1] . " ";
}
}
pclose($fp);
}
echo "<form method=post name=filefrm action='{$PHP_SELF}?path=" . urlencode($path) . "&sess={$sess}'>\n";
for ($af = 0, $j = 0; $j < $naf; $j++) {
/*print files*/
$b_includes .= '
NEXT_PAGE_URL = "'.GetTableLink("webreport3").'";
PREV_PAGE_URL = "'.GetTableLink("webreport").'";';
$b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\r\n";
foreach ($arr_tables_custom as $tbl)
{
if(!$tbl["isStorProc"])
{
$selected="";
if ( !empty( $_SESSION['webreports']['tables'] ) )
if ( in_array( $tbl["sqlname"], $_SESSION['webreports']['tables'] ) )
$selected = "selected";
if(postvalue("sqlname")==$tbl["sqlname"])
$selected = "selected";
$b_includes .= "$('<option ".$selected."></option>').attr('value', '".jsreplace($tbl["sqlname"])."').html('".jsreplace(getCaptionTable($tbl["sqlname"]))."').appendTo($('#tables'));"."\r\n";
}
}
$b_includes .= '
}
$("li").css("list-style-type","none");
$(".selected").css("padding-bottom","0px");
if($("#tables").get(0).selectedIndex==-1)
$("#tables").get(0).selectedIndex=0;
//if(li_selected_start!=li_selected)
// $("#row5,#row6").show();
//else if(table_name==$("#tables").val())
// $("#row5,#row6").hide();
empty_table_list();
<input type="text" id="editformatobj_lookupobj_where_' . $cnt . '" name="editformatobj_lookupobj_where_' . $cnt . '" value="' . GetLWWhere($arr['field'],PAGE_REPORT) . '" >
</td>
</tr>';
}
$arr = $_SESSION['webreports']['totals'];
if ( !empty( $arr ) ) {
$b_includes .= '<script type="text/javascript">
$(document).ready(function(){'."\n";
foreach ($arr as $id => $totals) {
if(!is_wr_custom())
$b_includes .= "$('tr[id=".$id."]', '#trt').find('td').eq(1).text('" . jsreplace($totals["table"].".".$totals["name"]) . "');"."\n";
$b_includes .= "$('tr[id=".$id."]', '#trt').find('td').eq(2).find('input').val('" . jsreplace($totals["label"]) . "');"."\n";
$total_name=$totals["name"];
if(is_wr_db())
$total_name=$totals["table"].".".$totals["name"];
if ( !in_array($total_name, $aSelGroupFields) || $is_crosstable_report=="true") {
$b_includes .= '$("tr[id='.$id.']", "#trt").find("td").eq(3).find("input").attr("checked",' . ($totals["show"] == "true" ? "true" : "false") . ');'."\n";
$b_includes .= '$("tr[id='.$id.']", "#trt").find("td").eq(4).find("input").attr("checked",' . ($totals["min"] == "true" ? "true" : "false") . ');'."\n";
$b_includes .= '$("tr[id='.$id.']", "#trt").find("td").eq(5).find("input").attr("checked",' . ($totals["max"] == "true" ? "true" : "false") . ');'."\n";
$b_includes .= '$("tr[id='.$id.']", "#trt").find("td").eq(6).find("input").attr("checked",' . ($totals["sum"] == "true" ? "true" : "false") . ');'."\n";
$b_includes .= '$("tr[id='.$id.']", "#trt").find("td").eq(7).find("input").attr("checked",' . ($totals["avg"] == "true" ? "true" : "false") . ');'."\n";
$b_includes .= '$("tr[id='.$id.']", "#trt").find("td").eq(8).find("input").attr("checked",' . ($totals["curr"] == "true" ? "true" : "false") . ');'."\n";
}
}
$b_includes .= '
arr=new Array;
arr[0]="show"
