kenken999/php

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 9if(!isWRAdmin())10{11	$_SESSION["MyURL"]=$_SERVER["SCRIPT_NAME"]."?".$_SERVER["QUERY_STRING"];12	header("Location: ".GetTableLink("webreport"));13	return;14}15 16include('include/xtempl.php');17$xt = new Xtempl();18$_SESSION["webobject"]["table_type"]="custom";19$b_includes = "";20$h_includes = "";21 22$h_includes .= '23	<link rel="stylesheet" href="'.GetRootPathForResources("include/css/jquery-ui.css").'" type="text/css">24	<link rel="stylesheet" href="'.GetRootPathForResources("include/css/dstyle.css").'" type="text/css">25	<link rel="stylesheet" href="'.GetRootPathForResources("include/fancybox/jquery.fancybox.css").'" type="text/css" media="screen">26	27	<script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.min.js").'"></script>28	<script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.dimensions.pack.js").'"></script>29	<script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.easing.js").'"></script>30    <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery.fancybox.pack.js").'"></script>31    <script type="text/javascript" src="'.GetRootPathForResources("include/js/jquery-ui.js").'"></script>32	<script type="text/javascript" src="'.GetRootPathForResources("include/js/json.js").'"></script>33'."\r\n";34 35$xt->assign("h_includes", $h_includes);36 37$b_includes .= '<script type="text/javascript">'."\r\n";38  39$b_includes .= '40$(document).ready(function(){41	$("a#a_editsql").fancybox({42		fitToView: false,43				autoSize: false,44				width : 850,45				height : 550,46				overlayShow: true47	});48	$("a#a_resultsql").fancybox({49		fitToView: false,50				autoSize: false,51				width : 850,52				height : 550,53				overlayShow: true54	});55	$("a#a_addsql").fancybox({56		fitToView: false,57				autoSize: false,58				width : 850,59				height : 550,60				overlayShow: true61	});62	';63 64$b_includes .= alertDialog();65$b_includes .= '$("#backbtn").click(function(){66			window.location = "'.GetTableLink("webreport").'";67			return;68		});69	$("#fancy_overlay").unbind();70	$("#addsql").click(function(){71		$("#a_addsql").click();72	});73	$("#editsql").click(function(){74		$.ajax({75			type: "POST",76			url: "'.GetTableLink("save-admin").'",77			data: {78				name: "getcustomsql",79				output: $("#sql_list option:selected").val(),80				rnd: (new Date().getTime())81			},82			success: function(msg)83			{84				$("#a_editsql").click();85			}86		});87		88	});89	$("#deletesql").click(function(){90		$("#sql_list").change();91		mess="<p>'."Do you really want to delete custom query %s ?".'</p>";92		mess=mess.replace("%s",$("#sql_list option:selected").text());93		$("#alert")94			.html(mess)95			.dialog("option", "buttons", {96				"No": function() { $(this).dialog("close"); },97				"Delete": function() {98					$.ajax({99						type: "POST",100						url: "'.GetTableLink("save-admin").'",101						data: {102							name: "deletesql",103							idsql: $("#sql_list option:selected").val(),104							rnd: (new Date().getTime())105						},106						success: function(msg){107							if ( msg == "OK" ) {108								window.location.reload();109							} else {110								$("#alert").html("<p>"+msg+"</p>").dialog("open");111							}112						},113						error: function() {114							$("#alert").html("<p>'."Try again later".'</p>").dialog("open");115						}116					});				117				}118			})119			.dialog("open");120	});121	$("#resultsql").click(function(){122		$("#sql_list").change();123		$.ajax({124			type: "POST",125			url: "'.GetTableLink("web_query").'",126			data: {127				name: "resultsql",128				output: $("#sql_list option:selected").val(),129				rnd: (new Date().getTime())130			},131			success: function(msg)132			{133				$("#a_resultsql").click();134			}135		});136		137	});138	$("#sql_list").change(function(){139		$.ajax({140			type: "POST",141			url: "'.GetTableLink("save-admin").'",142			data: {143				name: "getcustomsql",144				output: $("#sql_list option:selected").val(),145				rnd: (new Date().getTime())146			},147			success: function(msg)148			{149				$("#sql_content").html(msg);150			}151		});152	});';153 154if(postvalue("name"))155	$b_includes .= '156	$("#sql_list option").each(function(i){157		if($(this).text()=="'.str_replace("\"","\\\"",postvalue("name")).'")158			$(this).attr("selected","yes");159	});160	';161else162	$b_includes .= '163	$("#sql_list").get(0).selectedIndex=0;164	$("#sql_list option:first").attr("selected", "yes");165	';166 167	168$b_includes .= '169	$("#sql_list").change();';170 171 172$arr_custom=WRGetListCustomSQL();173 174$sql_list="<select name=sql_list id=sql_list size=20 style='width:500px;font-size:11pt;'>";175foreach($arr_custom as $value)176	$sql_list.="<option value=\"".$value["id"]."\">".runner_htmlspecialchars($value["sqlname"])."</option>";177$sql_list.="</select>";178 179if(!pre8count($arr_custom))180	$b_includes .= '181		$("#editsql,#deletesql,#resultsql").attr("disabled","disabled")182											.css("color","#847C7C")183											.css("cursor","default");184		185	';186 187$b_includes .= '188});189</script>'."\r\n";190$xt->assign("b_includes", $b_includes);191 192if($wr_is_standalone)193	$xt->assign("saveexit",false);194else195	$xt->assign("saveexit",true);196$xt->assign("wr_pagestylepath", $wr_pagestylepath);	197$xt->assign("sql_list",$sql_list);198$templatefile = GetTemplateName("", "webreport_sql");199$xt->display($templatefile);200?>201