<?php
error_reporting(0);
include ( "validate.php" );
include ( "config/config.php" );
include ( "config/groups.php" );
$doNew = $_REQUEST['doNew'];
if ($doNew != null) {
header("Location: view.php");
exit;
}
$doSearch = $_REQUEST['doSearch'];
if ($doSearch != null) {
$searchStr = $_REQUEST['searchStr'];
$searchStr = str_replace("'","''",stripslashes($searchStr));
$indivStr = $_REQUEST['cardStr'];
$groupStr = $_REQUEST['groupStr'];
if (strlen($searchStr) > 0) {
$searchEmpty = 0;
$groupStr = 2;
$sql = "SELECT * FROM IDWorksView WHERE (LastName LIKE '$searchStr%' OR FirstName LIKE '$searchStr%') AND TenantName = '$tenant1name' ORDER BY FirstName";
} else if (strlen($cardStr) > 0) {
$searchEmpty = 0;
$groupStr = 2;
$zerolen = 16 - strlen($cardStr);
$zeros = str_repeat("0", $zerolen);
$cardStr = $zeros.$cardStr;
$sql = "SELECT * FROM IDWorksView WHERE CardText = '$cardStr' AND TenantName = '$tenant1name' ORDER BY FirstName";
} else {
if ($groupStr == 1) {
$searchEmpty = 1;
$sql = "SELECT * FROM IDWorksView WHERE TenantName = '$tenant1name' AND GroupName IN ".$showGroups." ORDER BY TempStart DESC";
} else if ($groupStr == 2) {
$searchEmpty = 1;
$sql = "SELECT * FROM IDWorksView WHERE TenantName = '$tenant1name' ORDER BY TempStart DESC";
} else {
$searchEmpty = 1;
$sql = "SELECT * FROM IDWorksView WHERE TenantName = '$tenant1name' AND GroupName = '$groupStr' ORDER BY TempStart DESC";
}
}
//print_r ($sql); <- Debug SQL
$conn = odbc_connect($DSN,$db_login,$db_pw);
$res = odbc_exec($conn,$sql);
include ("conn.php");
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "
http://www.w3.org/TR/html4/strict.dtd"><html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta http-equiv="pragma" content="no-cache">
<title>List</title>
<script type="text/javascript">
<!--
function setfocus() {
document.forms[0].searchStr.focus();
}
function confirmsubmit() {
var agree=confirm("¿Está seguro?");
if (agree)
return true;
else
return false;
}
//-->
</script>
</head>
<body onload="setfocus();">
<p align="center"><img border="0" src="header.jpg" width="768" height="101"></p>
<table width=600px align=center border=0>
<tr><td colspan=3><hr></td></tr>
<form name="Search" method=post action="list.php">
<tr>
<td width=40px>Nombre</td><td><input type="text" name="searchStr" value="<?php echo str_replace("''","'",$searchStr); ?>" maxlength="64" size="18"> <input type="submit" name="doSearch" value="Buscar"> <input type="submit" name="doNew" value="Nuevo"> <INPUT type="button" value="Salir" onClick="location.href='logout.php'"></td>
<td align=right><img src="php-power-micro.png" border="0" alt="php" /></td>
</tr>
<tr>
<td width=40px>Tarjeta</td><td><input type="text" name="cardStr" value="<?php echo $cardStr; ?>" maxlength="16" size="18"></td>
</tr>
<tr>
<td width=40px>Grupo</td><td>
<select name="groupStr" maxlength="64" style="width: 200px" size="1">
<?PHP
print "<option value='1' ";
if ($groupStr == 1){
print " selected ";
}
print ">Grupos visita</option>";
print "<option value='2' ";
if ($groupStr == 2){
print " selected ";
}
print ">Todo</option>";
//groups from config/groups.php
foreach ($listGroups as $key => $value)
{
print "<option value='".$value."'";
if ($groupStr == $value){
print " selected ";
}
print ">".$value."</option>";
}
?>
</select></td>
</tr>
</form>
<?php
if ($doSearch != null) {
$rows = odbc_num_rows($res);
if ($rows > 0) {
echo "<tr><td height=8></td></tr>";
echo "<tr><td colspan=3><hr></td></tr>";
for ($n = 0; $n < $rows; $n++ ) {
if ($searchEmpty == 1) {
$item = odbc_fetch_array($res);
$date = date("d/m/Y",strtotime($item[TempStart]));
echo "<tr><td colspan=2 width=95%><a href=\"view.php?doRetrieve=true&individualid=$item[IndividualId]\" target=\"_self\">$date - $item[IndividualId] - $item[FirstName] $item[LastName] - $item[Custom07]</a></td><td colspan=1 width=5%><a href=\"delete.php?id=$item[IndividualId]\" target=\"_self\" onClick='return confirmsubmit()'><IMG SRC='delete.gif' width='15' height='15' Border=0 align='right'></a></td></tr>\n";
} else {
$item = odbc_fetch_array($res);
$date = date("d/m/Y",strtotime($item[TempStart]));
echo "<tr><td colspan=2 width=95%><a href=\"view.php?doRetrieve=true&individualid=$item[IndividualId]\" target=\"_self\">$item[FirstName] $item[LastName]</a></td><td colspan=1 width=5%><a href=\"delete.php?id=$item[IndividualId]\" target=\"_self\"><IMG SRC='delete.gif' width='15' height='15' Border=0 align='right'></a></td></tr>\n";
}
//Function to limit search results
//if ($n >= 99) {
// echo "<script type=\"text/javascript\"> alert(\"To many results. Write something else.\"); setfocus(); </script>";
// break;
//}
}
} else {
echo "<script type=\"text/javascript\"> alert(\"Ningun resultado.\"); setfocus(); </script>";
}
}
odbc_close($conn);
?>
</table>
</body>
</html>
