kenken999/php
0
1<?php2ini_set("display_errors","1");3ini_set("display_startup_errors","1");4include("include/dbcommon.php");5header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");6 7include("include/reportfunctions.php");8 9 if( !Security::getUserName() )10 {11 $_SESSION["MyURL"] = GetTableLink("webreport");12 header("Location: ".GetTableLink("login", "", "message=expired"));13 return;14 }15 16Reload_Report(postvalue("rname"));17 18include('include/xtempl.php');19$xt = new Xtempl();20 21if (@$_SESSION['webreports']['settings']['title'] != "") {22 $title=@$_SESSION['webreports']['settings']['title'];23 if(strlen($title)>25)24 $title=substr($title,25)."...";25 $xt->assign("report_title",", "."Title".": ".$title);26} else {27 $xt->assign("report_title","");28}29if (@$_SESSION['webreports']['tables'][0] != "") {30 $stable=@$_SESSION['webreports']['tables'][0];31 if(strlen($stable)>25)32 $stable=substr($stable,25)."...";33 34 $xt->assign("report_table",", "."Table".": ".$stable);35} else {36 $xt->assign("report_table","");37}38 39$xt->assign("b_is_report_save",($_SESSION['webreports']['tmp_active'] != "x")); 40$xt->assign("b_is_report_name",($_SESSION['webreports']['settings']['name'] != ""));41$xt->assign("report_name",$_SESSION['webreports']['settings']['name']);42 43$h_includes = "";44$b_includes = "";45 46$h_includes .= '47 <link rel="stylesheet" href="'.GetRootPathForResources("include/css/dstyle.css").'" type="text/css">48 <link rel="stylesheet" href="'.GetRootPathForResources("include/css/jquery-ui.css").'" type="text/css">49 50 <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.min.js").'"></script>51 <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.dimensions.pack.js").'"></script>52 <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery-ui.js").'"></script>53 <script type="text/javascript" src="'.GetRootPathForResources("include/js/json.js").'"></script>54'."\r\n";55 56$xt->assign("h_includes", $h_includes);57 58$b_includes .= '59<script type="text/javascript">60var timeout = 200;61var closetimer = 0;62var relation_stack = [];63 64$(document).ready(function(){65 66 ';67 $b_includes .= alertDialog();68 $b_includes .= '69 function collect_input_data() {70 var output = {};71 output.permissions = [];72 $("#ugroups").children().each(function(i){73 output.permissions[i] = {74 id : this.value,75 name : this.text.replace(/<|>|<|>/g,""),76 view : $("#view_prm_"+this.value).prop("checked").toString(),77 edit : $("#edit_prm_"+this.value).prop("checked").toString()78 };79 });80 81 return JSON.stringify(output); 82 }83 84 $.each(userGroups, function(i,n){85 var checked = "";86 if ( n >= -1 ) {87 checked = \'checked="true"\';88 }89 guest_d="";';90 91 if($wr_is_standalone)92 $b_includes .='if(n=="Guest")93 guest_d="disabled";';94 $b_includes .= '95 $("#viewBox").append(\'<input id="view_prm_\' + n + \'" type="checkbox" style="display:none;" \' + checked + \' name="add_prm_\' + n + \'">\');96 $("#editBox").append(\'<input id="edit_prm_\' + n + \'" \'+guest_d+\' type="checkbox" style="display:none;" \' + checked + \' name="edit_prm_\' + n + \'">\');97 });98 99 $("#ugroups").change(function(){100 var id = $(this).children(":selected").val();101 $("input[type=checkbox][id^=view_prm_]").hide();102 $("input[type=checkbox][id^=edit_prm_]").hide();103 $("#view_prm_"+id).show();104 $("#edit_prm_"+id).show();105 });106 107 $("#ugroups")[0].selectedIndex = 0;108 $("#ugroups").change(); 109 110 $("#row9")111 .css("cursor", "default")112 .css("font-weight", "bold");113 114 $("td[id^=row]").mouseover(function(){115 for(var i=0; i<=11; i++) {116 if(i == this.id.replace("row", "")) {117 $("td[id=row" + i + "]").css("background-color","#92BEEB");118 }119 else {120 $("td[id=row" + i + "]").css("background-color","#F4F7FB");121 }122 }123 });124 125'."\r\n";126 127$b_includes .= JumpTo();128 129if (count(GetUserGroups()) < 2 || isset( $_SESSION['webreports']['settings']['status'] )130 && $_SESSION['webreports']['settings']['c'] == "private" ) {131 $b_includes .= '$("td[id=row9]").hide();'."\r\n";132}133if (is_wr_project() || is_wr_custom()) {134 $b_includes .= '$("td[id=row1], td[id=row2]").hide();'."\r\n";135}136if($wr_is_standalone)137 $b_includes .= '$("td[id=row11]").hide();'."\n";138 139if ($_SESSION['webreports']['settings']['title'] == "") {140 $b_includes .= '141 for (var i=2; i<=9; i++){142 $("td[id=row" + i + "]").hide();143 };144 '."\r\n";145}146if($_SESSION['webreports']['group_fields'][count($_SESSION['webreports']['group_fields'])-1]["cross_table"]=="true")147 $b_includes .= '$("#row5,#row6").hide();'."\r\n";148 149$rLinks = "var rlinks = {};\r\n";150for($ri = 0; $ri < 10; $ri++)151 $rLinks.= "rlinks['".$ri."'] = '".GetTableLink("webreport".$ri)."';\r\n";152 153$b_includes .= '154 $("#backbtn, td[id^=row], #savebtn, #saveasbtn").click(function(){155 var URL = "'.GetTableLink("webreport").'";156 '.$rLinks.'157 if( this.id == "backbtn" )158 URL = "'.GetTableLink("webreport8").'";159 if( this.id == "saveasbtn" )160 URL = "'.GetTableLink("webreport8", "", "saveas=1").'"; 161 if( this.id.substr(0,3)=="row" && this.id != "row9" )162 URL = rlinks[this.id.replace(\'row\',\'\')];163 if( this.id == "row10" )164 URL = "'.GetTableLink("webreport").'";165 if( this.id == "row11" )166 URL = "'.GetTableLink("menu").'";167 if ( this.id == "row7" )168 URL = "'.GetTableLink("dreport").'?edit=style&rname='.@$_SESSION['webreports']['settings']['name'].'"; 169 170 var output = collect_input_data();171 172 if( this.id == "savebtn" ) {173 $.ajax({174 type: "POST",175 url: "'.GetTableLink("save-state").'",176 data: {177 save: 1,178 web: "webreports",179 name: "permissions",180 str_xml: output,181 rnd: (new Date().getTime())182 },183 success: function(msg){184 if ( msg == "OK" ) {185 $("#alert")186 .html("<p>'."Report Saved".'</p>")187 .dialog("option", "close", function(){188 window.location = "'.GetTableLink("webreport").'";189 })190 .dialog("open");191 } else {192 $("#alert").html("<p>'."Some problems appear during saving".'</p>").dialog("open");193 }194 },195 error: function() {196 $("#alert").html("<p>'."Some problems appear during saving".'</p>").dialog("open");197 }198 });199 }200 thisid=this.id;201 if(this.id != "row9" && this.id !="savebtn") {202 $.ajax({203 type: "POST",204 url: "'.GetTableLink("save-state").'",205 data: {206 name: "permissions",207 web: "webreports",208 str_xml: output,209 rnd: (new Date().getTime())210 },211 success: function(msg){212 if ( msg == "OK" ) {213 window.location = URL;214 } else {215 $("#alert").html("<p>"+msg+"</p>").dialog("open");216 if( thisid == "row10" || thisid == "row11")217 window.location=URL; 218 }219 }220 });221 }222 });223});224</script>'."\r\n";225 226$b_includes .= '<script type="text/javascript">';227$b_includes .= 'var userGroups = new Array();'."\r\n";228$userGroups = "";229$arrUserGroups = GetUserGroups();230foreach ( $arrUserGroups as $arr ) {231 $userGroups .= '<option value="'.$arr[0].'">'.runner_htmlspecialchars($arr[1]).'</option>';232 $b_includes .= 'userGroups.push("'.$arr[0].'");'."\r\n";233} 234$b_includes .= '</script>';235 236$arr = @$_SESSION['webreports']['permissions'];237 238if ( !empty( $arr ) ) {239 $b_includes .= '<script type="text/javascript">240 $(document).ready(function(){'."\n";241 242 for ( $i=0; $i < count($arr); $i++ ) {243 $b_includes .= '$("#view_prm_"+"'.$arr[$i]["id"].'").get(0).checked = ' . $arr[$i]["view"] . ';'."\n";244 $b_includes .= '$("#edit_prm_"+"'.$arr[$i]["id"].'").get(0).checked = ' . $arr[$i]["edit"] . ';'."\n";245 }246 247 $b_includes .= '});248 </script>';249}250$xt->assign("wr_pagestylepath", $wr_pagestylepath);251$xt->assign("b_includes", $b_includes);252$xt->assign("userGroups", $userGroups);253 254$templatefile = GetTemplateName("", "webreport9");255$xt->display($templatefile);256?>