Вот весь код:
| Код |
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<LINK href="dateselector.css" type=text/css rel=stylesheet>
<script language=JavaScript src="popup_lib.js"></SCRIPT>
<script language=JavaScript src="dateselector.js"></SCRIPT>
<script language="JavaScript">
var request = false;
var request2 = false;
try {
request = new XMLHttpRequest();
request2 = new XMLHttpRequest();
} catch (trymicrosoft) {
try {
request = new ActiveXObject("Msxml2.XMLHTTP");
request2 = new ActiveXObject("Msxml2.XMLHTTP");
} catch (othermicrosoft) {
try {
request = new ActiveXObject("Microsoft.XMLHTTP");
request2 = new ActiveXObject("Microsoft.XMLHTTP");
} catch (failed) {
request = false;
request2= false;
}
}
}
if (!request)
alert("Error initializing XMLHttpRequest!");
if (!request2)
alert("Error initializing XMLHttpRequest!");
function doLoad(url1)
{
var url="1.php";
url=url+"?id="+url1;
request.open("GET",url,true);
request.send(null);
request.onreadystatechange=stateChanged;
}
function stateChanged()
{
if (request.readyState==4 || request.readyState=="complete")
{
document.getElementById("txtHint").innerHTML=request.responseText;
}
}
function doLoad2(url1)
{
var url="table.php";
url=url+"?id="+url1;
request.open("GET",url,true);
request.send(null);
request.onreadystatechange=stateChanged2;
}
function stateChanged2()
{
if (request.readyState==4 || request.readyState=="complete")
{
document.getElementById("ttt").innerHTML=request.responseText;
}
}
function changeDisplay(id)
{
var ul = document.getElementById('ul' + id).style;
var li = document.getElementById('li' + id).style;
if ( 'none' == ul.display )
{
ul.display = 'block';
li.listStyleImage = 'url("open.gif")';
}
else
{
ul.display = 'none';
li.listStyleImage = 'url("closed.gif")';
}
}
</script>
</head>
<body onLoad="doLoad('sklad');" onLoad="doLoad2('00001');">
<h3 align="center"><strong><font size="+1" face="Arial, Helvetica, sans-serif">Список
товаров</font></strong>
</h3>
<form action = "17.php" name="myform" method="post" >
<p>Поиск по параметру:
<select name="tip" onChange="doLoad(this.value)" onFocus="doLoad(this.value)" >
<option value="sklad" selected>Склад
<option value="name" >Наименование
<option value="model" >Модель
<option value="date">Дата прихода
<option value="edizm">Единица измерения
<option value="kolvo">Количество
<option value="price">Цена
</select>
<div id="txtHint"></div>
</form>
<p><strong><A href="excel.php">Excel</A></strong><strong><A href="excel.php">Excel</A></strong> </p>
<td width="92%" align="center" valign="top">
<p>
<?php
if ($bp=="ИПРИС - ПЕТЕРБУРГ") $dbname = "BP";
if ($bp=="ИПРИС - МОСКВА") $dbname = "BP_MSK";
if ($bp=="ИПРИС - РОСТОВ") $dbname = "BP_RND";
if ($bp=="ИПРИС - НОВОСИБИРСК") $dbname = "BP_SBR";
if ($bp=="ИПРИС - ЕКАТЕРИНБУРГ" ) $dbname = "BP_eka";
$dbuser = "DBA";
$dbpasswd = "SQL";
setcookie("dbname", $dbname, time() + 3600*24);
$conn=odbc_connect($dbname , $dbuser , $dbpasswd );
if (!$conn)
{
echo ("<P>В настоящий момент сервер базы данных не доступен, поэтому корректное отображение страницы невозможно.</P>");
exit();
}
echo "<table border = 1 width = 100%>";
echo "<tr><td align=left valign=top width=50%>";
$sSQL="SELECT CLASSID, CLASSNAME FROM CLS_GOOD ORDER BY CLASSID ";
$result_tree=odbc_exec($conn, $sSQL);
$k=0;
for ($i=0; $i<odbc_num_rows($result_tree); $i++)
{
$k++;
$f=odbc_fetch_array($result_tree, $i+1);
$v=odbc_fetch_array($result_tree, $i+2);
$o=$f[CLASSID];
$vc=strlen($v[CLASSID]);
$fc=strlen($f[CLASSID]);
$min1=($fc-$vc)/5;
if ($vc>$fc) {
echo "<li id='li$k')'>\n";
echo ("<a id='$o' href=\"javascript: changeDisplay($k); \" onclick='doLoad2(this.id); '><font size=\"2\"><strong>".$f["CLASSNAME"]."</strong></font></A>"." \n");
echo ("</li>");
echo ("<UL id='ul$k' style='display: none;'>\n");
}
if ($vc<$fc) {
echo("<li id = liil>\n");
echo ("<a id='$o' href='#' onclick='doLoad2(this.id); '><font size=\"2\"><strong>".$f["CLASSNAME"]."</strong></font></A>"." \n");
echo ("</li>");
for ($j = 0; $j<$min1; $j++) echo("</UL>\n");
}
if ($vc==$fc) {
echo("<li id = liil1>\n");
echo ("<a id='$o' href='#' onclick='doLoad2(this.id); '><font size=\"2\"><strong>".$f["CLASSNAME"]."</strong></font></A>"." \n");
echo ("</li>");
}
}
echo "</td><td align=left valign=top width=50%>";
echo "<div id='ttt'><div>";
echo "</td></tr></table>";
//odbc_result_all( $result,"BGCOLOR='#c0c0c0' border='1' ");
odbc_close( $conn );
?>
</p>
<p align="center"> </p>
</body>
</html>
|
|