"frameWidth" : 820,
"frameHeight" : 660,
"overlayShow": true,
"hideOnContentClick" : true,
"easingIn" : "easeOutBack",
"easingOut" : "easeInBack"
});
}
';
if ($_SESSION['webreports']['group_fields'][count($_SESSION['webreports']['group_fields']) - 1]["cross_table"] == "true")
$includes .= '$("#row5,#row6").hide();' . "\r\n";
// Settings for style editor. Check dynamic permissions
if (count(GetUserGroups()) < 2 || isset($_SESSION['webreports']['settings']['status']) && $_SESSION['webreports']['settings']['status'] == "private") {
$includes .= '$("td[id=row9]").hide();';
}
if ($wr_is_standalone)
$includes .= '$("td[id=row11]").hide();' . "\n";
if (!$modePrint) {
if (is_wr_project() || is_wr_custom()) {
$includes .= '$("td[id=row1], td[id=row2]").hide();' . "\r\n";
}
if ($_SESSION['webreports']['settings']['title'] == "") {
$includes .= '
for (var i=2; i<=9; i++){
$("td[id=row" + i + "]").hide();
};
$("td[id^=row]").mouseover(function(){
for(var i=0; i<=11; i++) {
if(i == this.id.replace("row", "")) {
$("td[id=row" + i + "]").css("background-color","#92BEEB");
}
else {
$("td[id=row" + i + "]").css("background-color","#F4F7FB");
}
}
});
'."\r\n";
$b_includes .= JumpTo();
if (count(GetUserGroups()) < 2 || $_SESSION['webreports']['settings']['status'] != "public" ) {
$b_includes .= '$("td[id=row9]").hide();'."\r\n";
}
if (is_wr_project() || is_wr_custom()) {
$b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\n";
}
if($wr_is_standalone)
$b_includes .= '$("td[id=row11]").hide();'."\n";
if($_SESSION['webreports']['group_fields'][count($_SESSION['webreports']['group_fields'])-1]["cross_table"]=="true")
$b_includes .= '$("#row5,#row6").hide();'."\r\n";
$rLinks = "var rlinks = {};\r\n";
for($ri = 0; $ri < 10; $ri++)
/* foreach ( $arr_reports as $rpt ) {
/Trecho comentado por Helbert Samuel em 05/03/2015
* Objetivo: Permitir que o usuário tenho acesso ao módulo de relatório, após logar no sistema
* if (( $rpt["owner"] != @$_SESSION["login"] || $rpt["owner"] == "") && $rpt["view"]==0 && $rpt_array['settings']['name']==$rpt["name"])
{
echo "<p>"."Acesso negado"."</p>";
exit();
}
} */
if (!isset($_SESSION["login"])) {
echo "<p>" . "Acesso negado" . "</p>";
exit();
}
if (count(GetUserGroups()) > 1) {
$arr_reports = array();
$arr_reports = GetChartsList();
foreach ($arr_reports as $rpt){
if (( $rpt["owner"] != @$_SESSION["UserID"] || $rpt["owner"] == "") && $rpt["view"] == 0 && $chrt_array['settings']['name'] == $rpt["name"]) {
echo "<p>" . "You don't have permissions to view this chart" . "</p>";
exit();
}
}
}
// process request data, fill session variables
if (!count($_POST) && ( count($_GET) <= 1 )) {
$sess_unset = array();
foreach ($_SESSION as $key => $value)
if (substr($key, 0, strlen($sessPrefix) + 1) == $sessPrefix . "_" &&
$("td[id^=row]").mouseover(function(){
for(var i=0; i<=9; i++) {
if(i == this.id.replace("row", "")) {
$("td[id=row" + i + "]").css("background-color","#92BEEB");
}
else {
$("td[id=row" + i + "]").css("background-color","#F4F7FB");
}
}
});
'."\r\n";
$b_includes .= JumpTo();
if (count(GetUserGroups()) < 2 || isset( $_SESSION['webcharts']['settings']['status'] )
&& $_SESSION['webcharts']['settings']['status'] == "private" ) {
$b_includes .= '$("td[id=row7]").hide();'."\r\n";
}
if (is_wr_project() || is_wr_custom()) {
$b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\r\n";
}
if($wr_is_standalone)
$b_includes .= '$("td[id=row9]").hide();'."\n";
if ($_SESSION['webcharts']['settings']['title'] == "") {
$b_includes .= '
for (var i=2; i<=7; i++){
$("td[id=row" + i + "]").hide();
};
'."\r\n";
for(var i=0; i<=11; i++) {
if(i == this.id.replace("row", "")) {
$("td[id=row" + i + "]").css("background-color","#92BEEB");
}
else {
$("td[id=row" + i + "]").css("background-color","#F4F7FB");
}
}
});
'."\r\n";
$b_includes .= JumpTo();
if (count(GetUserGroups()) < 2
|| isset( $_SESSION['webreports']['settings']['status'] ) && $_SESSION['webreports']['settings']['status'] == "private" ) {
$b_includes .= '$("td[id=row9]").hide();'."\r\n";
}
if (is_wr_project() || is_wr_custom()) {
$b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\r\n";
}
if($wr_is_standalone)
$b_includes .= '$("td[id=row11]").hide();'."\n";
if ($_SESSION['webreports']['settings']['title'] == "") {
$b_includes .= '
for (var i=2; i<=9; i++){
$("td[id=row" + i + "]").hide();
};
'."\r\n";
} else {
$("#alert").html("<p>"+msg+"</p>").dialog("open");
if( thisid == "row8" || thisid == "row9" )
window.location=URL;
}
}
});
}
});
});
</script>'."\r\n";
$b_includes .= '<script type="text/javascript">';
$b_includes .= 'var userGroups = new Array();'."\r\n";
$userGroups = "";
$arrUserGroups = GetUserGroups();
foreach ( $arrUserGroups as $arr ) {
$userGroups .= '<option value="'.$arr[0].'">'.runner_htmlspecialchars($arr[1]).'</option>';
$b_includes .= 'userGroups.push("'.$arr[0].'");'."\r\n";
}
$b_includes .= '</script>';
$arr = @$_SESSION['webcharts']['permissions'];
if ( !empty( $arr ) ) {
$b_includes .= '<script type="text/javascript">
$(document).ready(function(){'."\n";
for ( $i=0; $i < count($arr); $i++ ) {
$b_includes .= '$("#view_prm_"+"'.$arr[$i]["id"].'").get(0).checked = ' . $arr[$i]["view"] . ';'."\n";
$b_includes .= '$("#edit_prm_"+"'.$arr[$i]["id"].'").get(0).checked = ' . $arr[$i]["edit"] . ';'."\n";
$("td[id^=row]").mouseover(function(){
for(var i=0; i<=9; i++) {
if(i == this.id.replace("row", "")) {
$("td[id=row" + i + "]").css("background-color","#92BEEB");
}
else {
$("td[id=row" + i + "]").css("background-color","#F4F7FB");
}
}
});
'."\r\n";
$b_includes .= JumpTo();
if (count(GetUserGroups()) < 2 || $root['settings']['status']!="public" )
{
$b_includes .= '$("td[id=row7]").hide();'."\r\n";
}
if (is_wr_project() || is_wr_custom()) {
$b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\r\n";
}
if($wr_is_standalone)
$b_includes .= '$("td[id=row9]").hide();'."\n";
//if ($root['settings']['title'] == "") {
// $b_includes .= '
// for (var i=2; i<=7; i++){
// $("td[id=row" + i + "]").hide();
// };
// '."\r\n";
$("td[id=row" + i + "]").css("background-color","#92BEEB");
}
else {
$("td[id=row" + i + "]").css("background-color","#F4F7FB");
}
}
});
'."\r\n";
$b_includes .= colorPickerMouse();
$b_includes .= JumpTo();
if (count(GetUserGroups()) < 2 || isset( $root['settings']['status'] )
&& $root['settings']['status'] == "private" ) {
$b_includes .= '$("td[id=row7]").hide();'."\r\n";
}
if (is_wr_project() || is_wr_custom()) {
$b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\r\n";
}
if($wr_is_standalone)
$b_includes .= '$("td[id=row9]").hide();'."\n";
if ($root['settings']['title'] == "") {
$b_includes .= '
for (var i=2; i<=7; i++){
$("td[id=row" + i + "]").hide();
};
'."\r\n";
$tables_admin_db = WRGetTableListAdmin("db");
$tables_admin_project = WRGetTableListAdmin("project");
$tables_admin_custom = WRGetTableListAdmin("custom");
$arr_tables_db = DBGetTablesList();
$arr_tables_project = GetTablesListReport();
$arr_tables_custom = GetTablesListCustom();
$groups = array();
if(!$wr_is_standalone)
$arr_UserGroups = GetUserGroups();
else
{
$arr_UserGroups = array();
foreach(GetUserGroups() as $idx=>$value)
if($value[0]!="Guest")
$arr_UserGroups[]=$value;
}
$group_list="";
$groupSelected="";
$wr_user=postvalue("username");
if($wr_is_standalone)
{
if(postvalue("editid1"))
{
$rs=db_query("select ".AddFieldWrappers("username")." from ".AddTableWrappers("webreport_users")." where ".AddFieldWrappers("id")."=".postvalue("editid1"),$conn);
$data=db_fetch_numarray($rs);
