Publicado em 10 de jan.

manter valor da combo

boas people, uma ajuda nesta questão...

este é o código, onde tenho uma combo dinamica na linha 387/401 onde pretendo que cada vez que aplicar o filtro, mantenha o valor na combo, acontece que não está retornando nada, dando esse erro no inicio da página: Notice: Undefined index: TIPO in C:\wamp\www\TMN\tmn1.php on line 4

o código:

<?php require_once('Connections/tool_tmn.php'); ?><?php include('includes/FusionCharts/dynamic/DWFChart.inc.php'); ?>
<?php
session_start();

$_SESSION['TIPO'] = isset($_SESSION['TIPO'])?$_SESSION['TIPO']:$_POST['TIPO'];

// fusion chart # FusionChart29 data include
include('includes/FusionCharts/dynamic/data/fc_FusionChart29_data.php');

// fusion chart # FusionChart30 data include
include('includes/FusionCharts/dynamic/data/fc_FusionChart30_data.php');

// fusion chart # FusionChart31 data include

include('includes/FusionCharts/dynamic/data/fc_FusionChart31_data.php');

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

 if (PHP_VERSION < 6) {
 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 }

 $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 switch ($theType) {
 case "text":
 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
 break;
 case "long":
 case "int":
 $theValue = ($theValue != "") ? intval($theValue) : "NULL";
 break;
 case "double":
 $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
 break;
 case "date":
 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
 break;
 case "defined":
 $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
 break;
 }
 return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Recordset1 = 93;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
 $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$DATA1_Recordset1 = "%";
if (isset($_POST['DATA1'])) {
 $DATA1_Recordset1 = $_POST['DATA1'];
}
$DATA2_Recordset1 = "2100-12-31";
if (isset($_POST['DATA2'])) {
 $DATA2_Recordset1 = $_POST['DATA2'];
}
$teste1_Recordset1 = "AREA";
if (isset($_POST['teste1'])) {
 $teste1_Recordset1 = $_POST['teste1'];
}
$area1_Recordset1 = "MOTOROLA";
if (isset($_POST['area1'])) {
 $area1_Recordset1 = $_POST['area1'];
}
$bsc1_Recordset1 = "%";
if (isset($_POST['bsc1'])) {
 $bsc1_Recordset1 = $_POST['bsc1'];
}
$bts1_Recordset1 = "%";
if (isset($_POST['bts1'])) {
 $bts1_Recordset1 = $_POST['bts1'];
}
$ci1_Recordset1 = "%";
if (isset($_POST['ci1'])) {
 $ci1_Recordset1 = $_POST['ci1'];
}
mysql_select_db($database_tool_tmn, $tool_tmn);
$query_Recordset1 = sprintf("SELECT es_evoldia.DAY, es_evoldia.TIPO, es_evoldia.NOME_FORNECEDOR, es_evoldia.NOME_BSC, es_evoldia.NOME_BTS, es_evoldia.CI, es_evoldia.TRAFEGO, es_evoldia.BLOCKS, es_evoldia.RFLOSSES, es_evoldia.DROPPED, es_evoldia.CSSR, es_evoldia.CDR, es_evoldia.QUEDAS FROM es_evoldia WHERE DAY BETWEEN %s AND %s AND TIPO LIKE %s AND NOME_FORNECEDOR LIKE %s AND NOME_BSC LIKE %s AND NOME_BTS LIKE %s AND CI LIKE %s ORDER BY DAY DESC", GetSQLValueString($DATA1_Recordset1, "date"),GetSQLValueString($DATA2_Recordset1, "date"),GetSQLValueString("%" . $teste1_Recordset1 . "%", "text"),GetSQLValueString("%" . $area1_Recordset1 . "%", "text"),GetSQLValueString("%" . $bsc1_Recordset1 . "%", "text"),GetSQLValueString("%" . $bts1_Recordset1 . "%", "text"),GetSQLValueString("%" . $ci1_Recordset1 . "%", "text"));
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
echo("<hr />" . $query_limit_Recordset1 . "<hr />" . PHP_EOL);
$Recordset1 = mysql_query($query_limit_Recordset1, $tool_tmn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
 $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

 $all_Recordset1 = mysql_query($query_Recordset1);
 $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

mysql_select_db($database_tool_tmn, $tool_tmn);
$query_Recordset2 = "SELECT max(es_date.`DAY`) AS last FROM es_date";
$Recordset2 = mysql_query($query_Recordset2, $tool_tmn) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

mysql_select_db($database_tool_tmn, $tool_tmn);
$query_Recordset3 = "SELECT distinct(es_date.`DAY`) as DAY FROM es_date ORDER BY DAY DESC";
$Recordset3 = mysql_query($query_Recordset3, $tool_tmn) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);

mysql_select_db($database_tool_tmn, $tool_tmn);
$query_Recordset4 = "SELECT distinct es_evoldia.TIPO FROM es_evoldia";
$Recordset4 = mysql_query($query_Recordset4, $tool_tmn) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset4 = mysql_num_rows($Recordset4);

// fusion chart #FusionChart29 dynamic filter data

// fusion chart #FusionChart30 dynamic filter data

// fusion chart #FusionChart31 dynamic filter data

$dFCFusionChart29 = new DWFChart("FusionChart29", "MSCombiDY2D", "includes/FusionCharts/charts/", 1000, 400, "", "", "", "", "", "");
$dFCFusionChart29->setVersion("1.1.1");
$dFCFusionChart29->setConfigXML($FusionChart29_dataXML);
$dFCFusionChart29->setCategory($Recordset1, "DAY", "useExport=true", "");
$dFCFusionChart29->addSeries($Recordset1, "TRAFEGO", "", "color='ff6600' seriesName='TRAFEGO' renderAs='Column' parentYAxis='P'", "default", "");
$dFCFusionChart29->addSeries($Recordset1, "QUEDAS", "", "color='ffcc00' seriesName='QUEDAS' renderAs='Line' parentYAxis='P'", "default", "");
$dFCFusionChart29->addSeries($Recordset1, "CDR", "", "color='660066' seriesName='CDR' renderAs='Line' parentYAxis='S'", "default", "");
$dFCFusionChart29->setOrdering('Category', 'asc');
$dFCFusionChart29->prepareData();

$dFCFusionChart30 = new DWFChart("FusionChart30", "MSStackedColumn2DLineDY", "includes/FusionCharts/charts/", 1000, 400, "", "", "", "", "", "");
$dFCFusionChart30->setVersion("1.1.1");
$dFCFusionChart30->setConfigXML($FusionChart30_dataXML);
$dFCFusionChart30->setCategory($Recordset1, "DAY", "useExport=true", "");
$dFCFusionChart30->addSeries($Recordset1, "RFLOSSES", "", "color='ff6600' seriesName='RFLOSSES' renderAs='Column'", "Default Group", "");
$dFCFusionChart30->addSeries($Recordset1, "DROPPED", "", "color='ff9900' seriesName='DROPPED' renderAs='Column'", "Default Group", "");
$dFCFusionChart30->addSeries($Recordset1, "CDR", "", "color='660066' seriesName='CDR' renderAs='Line'", "Default Group", "");
$dFCFusionChart30->setOrdering('Category', 'asc');
$dFCFusionChart30->prepareData();

$dFCFusionChart31 = new DWFChart("FusionChart31", "MSCombiDY2D", "includes/FusionCharts/charts/", 1000, 400, "", "", "", "", "", "");
$dFCFusionChart31->setConfigXML($FusionChart31_dataXML);
$dFCFusionChart31->setCategory($Recordset1, "DAY", "useExport=true", "");
$dFCFusionChart31->addSeries($Recordset1, "BLOCKS", "", "color='ff6600' seriesName='BLOCKS' renderAs='Column' parentYAxis='P'", "default", "");
$dFCFusionChart31->addSeries($Recordset1, "CSSR", "", "color='ff9900' seriesName='CSSR' renderAs='Line' parentYAxis='S'", "default", "");
$dFCFusionChart31->setOrdering('Category', 'asc');
$dFCFusionChart31->prepareData();

$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
 $params = explode("&", $_SERVER['QUERY_STRING']);
 $newParams = array();
 foreach ($params as $param) {
 if (stristr($param, "pageNum_Recordset1") == false &&
 stristr($param, "totalRows_Recordset1") == false) {
 array_push($newParams, $param);
 }
 }
 if (count($newParams) != 0) {
 $queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
 }
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>NSN - TMN Estatísticas</title>
<style type="text/css">

<!--

.head1 {text-align: center;
font-weight: bold;
font-family: Tahoma, Geneva, sans-serif;
font-size: 24px;
color: #006;
}
.head2 {text-align: center;
font-weight: bold;
font-family: Tahoma, Geneva, sans-serif;
font-size: 18px;
color: #006;
}
.head3 {text-align: center;
font-weight: bold;
font-family: Tahoma, Geneva, sans-serif;
font-size: 10px;
color: #006;
}

-->

</style>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="includes/FusionCharts/dynamic/js/FusionCharts.js"></script>
<script type="text/javascript" src="includes/FusionCharts/dynamic/js/FusionChartsExportComponent.js"></script>
</head>

<body>
<table width="1011" border="0" align="center">
 <tr>
 <td width="223"><img src="Images/logo_nsn.JPG" alt="a" width="223" height="120" /></td>
 <td width="873"><img src="Images/nsn1.JPG" alt="d" width="778" height="155" /></td>
 </tr>
 <tr>
 <td height="40" colspan="2"><ul id="MenuBar1" class="MenuBarHorizontal">
 <li><a href="#">Home</a></li>
 <li><a href="#" class="MenuBarItemSubmenu">Estatísticas</a>
 <ul>
 <li><a href="tmn1.php">Evolução Diária</a></li>
 <li><a href="#" class="MenuBarItemSubmenu">KPI's</a>
 <ul>
 <li><a href="tmn2.php">KPI's</a></li>
 <li><a href="tmn3.php">KPI's de GPRS</a></li>
 </ul>
 </li>
 <li><a href="#" class="MenuBarItemSubmenu">Contadores</a>
 <ul>
 <li><a href="tmn4.php">BH</a></li>
 <li><a href="tmn5.php">Total Dia</a></li>
 </ul>
 </li>
 </ul>
 </li>
 <li><a class="MenuBarItemSubmenu" href="#">Inconsistências</a>
 <ul>
 <li><a href="tmn6.php">Diário</a></li>
 <li><a href="#" class="MenuBarItemSubmenu">Por Data</a>
 <ul>
 <li><a href="tmn7.php">Site</a></li>
 <li><a href="tmn8.php">Cell</a></li>
 <li><a href="tmn9.php">DRI</a></li>
 <li><a href="tmn10.php">RTF</a></li>
 <li><a href="tmn11.php">NEI 2G/2G</a></li>
 <li><a href="tmn12.php">NEI 2G/3G</a></li>
 </ul>
 </li>
 <li><a href="#">vs. Padrão</a></li>
 <li><a href="http://10.152.150.21/TMN/OUT/RFExport_Download/">Download RF-Export</a></li>
 </ul>
 </li>
 <li><a href="#">Alarmistica</a></li>
 <li><a href="#">Logout</a></li>
 </ul>
 <img src="Images/logo_tmn.gif" alt="s" width="122" height="36" /></td>
</tr>
 <tr> </tr>
</table>
<table width="1010" border="0" align="center">
 <tr>
 <td class="head1">Estatísticas</td>
 </tr>
 <tr>
 <td height="21"><p class="head2">Evolução Diária</p></td>
 </tr>
 <tr>
 <td height="21" class="head3">Última Actualização: <span class="vbgf"><?php echo $row_Recordset2['last']; ?></span></td>
 </tr>
</table>
<table width="1011" border="0" align="center">
 <tr> </tr>
</table>
<p> <?php

// (FCChart Begin) #FusionChart29 renderFusionChart($dFCFusionChart29, 1000, 400); // #FusionChart29 (FCChart End)

?>
<p>
<?php

// (FCChart Begin) #FusionChart30 renderFusionChart($dFCFusionChart30, 1000, 400); // #FusionChart30 (FCChart End)

?></p>
<p> <?php

// (FCChart Begin) #FusionChart31 renderFusionChart($dFCFusionChart31, 1000, 400); // #FusionChart31 (FCChart End)

?></p>
<form id="form1" name="form1" method="post" action="">
 <table width="1200" border="1" align="center" cellpadding="5" cellspacing="0">
 <tr>
 <td colspan="14"><table width="225" border="0" align="left">
 <tr>
 <th bgcolor="#FF9900" scope="col"><a href="export_evoldia1.php?liga1=<?php echo $row_Recordset1['DAY']; ?>&liga2=<?php echo $row_Recordset1['TIPO']; ?>&liga3=<?php echo $row_Recordset1['NOME_FORNECEDOR']; ?>&liga4=<?php echo $row_Recordset1['NOME_BSC']; ?>&liga5=<?php echo $row_Recordset1['NOME_BTS']; ?>&liga6=<?php echo $row_Recordset1['CI']; ?>">Exportar para Excel</a></th>
 </tr>
 </table></td>
 </tr>
 <tr>
 <td colspan="14"><table width="224" border="0" align="left">
 <tr>
 <th bgcolor="#FF9900" scope="col"><a href="tmn1.php">Reset Filtro</a></th>
 </tr>
 </table></td>
 </tr>
 <tr>
 <td colspan="14"> 
 <div align="left"><span style="text-align: left; color: #000;">Records <?php echo ($startRow_Recordset1 + 1) ?> to <?php echo min($startRow_Recordset1 + $maxRows_Recordset1, $totalRows_Recordset1) ?> of <?php echo $totalRows_Recordset1 ?></span><span style="text-align: left"></span><span style="text-align: left"></span></div></td>
 </tr>
 <tr>
 <td colspan="14"><table width="222" border="0" align="left">
 <tr>
 <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, 0, $queryString_Recordset1); ?>">First</a>
 <?php } // Show if not first page ?></td>
 <td><?php if ($pageNum_Recordset1 > 0) { // Show if not first page ?>
 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, max(0, $pageNum_Recordset1 - 1), $queryString_Recordset1); ?>">Previous</a>
 <?php } // Show if not first page ?></td>
 <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, min($totalPages_Recordset1, $pageNum_Recordset1 + 1), $queryString_Recordset1); ?>">Next</a>
 <?php } // Show if not last page ?></td>
 <td><?php if ($pageNum_Recordset1 < $totalPages_Recordset1) { // Show if not last page ?>
 <a href="<?php printf("%s?pageNum_Recordset1=%d%s", $currentPage, $totalPages_Recordset1, $queryString_Recordset1); ?>">Last</a>
 <?php } // Show if not last page ?></td>
 </tr>
 </table></td>
 </tr>
 <tr>
 <td width="100" colspan="2" bgcolor="#CCCCCC"><div align="center">DATA</div></td>
 <td width="75" bgcolor="#CCCCCC"><div align="center">TIPO</div></td>
 <td width="75" bgcolor="#CCCCCC"><div align="center">NOME_FORNECEDOR</div></td>
 <td width="75" bgcolor="#CCCCCC"><div align="center">NOME_BSC</div></td>
 <td width="75" bgcolor="#CCCCCC"><div align="center">NOME_BTS</div></td>
 <td width="75" bgcolor="#CCCCCC"><div align="center">CI</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">TRAFEGO</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">BLOCKS</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">RFLOSSES</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">DROPPED</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">CSSR</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">CDR</div></td>
 <td width="75" rowspan="2" bgcolor="#CCCCCC"><div align="center">QUEDAS</div></td>
 </tr>
 <tr>
 <td bgcolor="#99CCFF"><label for="filtro"></label>
 <input name="filtro" type="submit" class="head2" id="filtro" value="FILTRO" /></td>
 <td bgcolor="#99CCFF" class="dados"><span id="spryselect1">
 <label for="DATA1">De:<br />
 </label>
 <select name="DATA1" id="DATA1">
 <option value=""></option>
 <?php

do {

?>
 <option value="<?php echo $row_Recordset3['DAY']?>"><?php echo $row_Recordset3['DAY']?></option>
 <?php
} while ($row_Recordset3 = mysql_fetch_assoc($Recordset3));
 $rows = mysql_num_rows($Recordset3);
 if($rows > 0) {
 mysql_data_seek($Recordset3, 0);
 $row_Recordset3 = mysql_fetch_assoc($Recordset3);
 }
?>
 </select>
 </span>
 <p><span id="spryselect2">
 <label for="DATA2"></label>
 A:<br />
<select name="DATA2" id="DATA2">
 <option value=""></option>
 <?php

do {

?>
 <option value="<?php echo $row_Recordset3['DAY']?>"><?php echo $row_Recordset3['DAY']?></option>
 <?php
} while ($row_Recordset3 = mysql_fetch_assoc($Recordset3));
 $rows = mysql_num_rows($Recordset3);
 if($rows > 0) {
 mysql_data_seek($Recordset3, 0);
 $row_Recordset3 = mysql_fetch_assoc($Recordset3);
 }
?>
 </select>
 <br />

 <span class="selectRequiredMsg">Obrigatório!</span></span></p></td>
 <td bgcolor="#99CCFF"><label for="tipo1"></label>
 <span id="spryselect3">
 <label for="tipo1"></label>
 <select name="tipo1" id="tipo1">
 <option value=""></option>
 <?php

do {

?>
 <option value="<?php echo $row_Recordset4['TIPO']?>" <?php if($row_Recordset4['TIPO']==$_SESSION['TIPO'])echo 'selected'?>><?php echo $row_Recordset4['TIPO']?></option>
 <?php
} while ($row_Recordset4 = mysql_fetch_assoc($Recordset4));
 $rows = mysql_num_rows($Recordset4);
 if($rows > 0) {
 mysql_data_seek($Recordset4, 0);
 $row_Recordset4 = mysql_fetch_assoc($Recordset4);
 }
?>
 </select>
 <span class="selectRequiredMsg"><br />
 Obrigatório.</span></span></td>
 <td width="75" bgcolor="#99CCFF"><label for="area1"></label>
 <input name="area1" type="text" id="area1" size="10" /></td>
 <td width="75" bgcolor="#99CCFF"><label for="bsc1"></label>
 <input name="bsc1" type="text" id="bsc1" size="10" /></td>
 <td width="75" bgcolor="#99CCFF"><label for="bts1"></label>
 <input name="bts1" type="text" id="bts1" size="10" /></td>
 <td width="75" bgcolor="#99CCFF"><label for="ci1"></label>
 <input name="ci1" type="text" id="ci1" size="10" /></td>
 </tr>
 <?php do { ?>
 <tr>
 <td width="100"colspan="2"><?php echo $row_Recordset1['DAY']; ?></td>
 <td width="75"><?php echo $row_Recordset1['TIPO']; ?></td>
 <td width="75"><?php echo $row_Recordset1['NOME_FORNECEDOR']; ?></td>
 <td width="75"><?php echo $row_Recordset1['NOME_BSC']; ?></td>
 <td width="75"><?php echo $row_Recordset1['NOME_BTS']; ?></td>
 <td width="75"><?php echo $row_Recordset1['CI']; ?></td>
 <td width="75"><?php echo $row_Recordset1['TRAFEGO']; ?></td>
 <td width="75"><?php echo $row_Recordset1['BLOCKS']; ?></td>
 <td width="75"><?php echo $row_Recordset1['RFLOSSES']; ?></td>
 <td width="75"><?php echo $row_Recordset1['DROPPED']; ?></td>
 <td width="75"><?php echo $row_Recordset1['CSSR']; ?> %</td>
 <td width="75"><?php echo $row_Recordset1['CDR']; ?> %</td>
 <td width="75"><?php echo $row_Recordset1['QUEDAS']; ?></td>
 </tr>
 <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
 </table>
</form>
<p>  </p>
<p>  </p>
<script type="text/javascript">

<!--

var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["change", "blur"]});
var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2", {validateOn:["change", "blur"]});
var spryselect3 = new Spry.Widget.ValidationSelect("spryselect3", {validateOn:["blur", "change"]});

//-->

</script>
</body>
</html>
<?php
mysql_free_result($Recordset1);

mysql_free_result($Recordset2);

mysql_free_result($Recordset3);

mysql_free_result($Recordset4);
?>

Discussão (3)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

Carregando comentários...