db=$db;
}
function delete($id){
$querystatement="DELETE FROM usersearches
WHERE id=".((int) $id);
$queryresult = $this->db->query($querystatement);
echo "success";
}
function save($name,$tabledefid,$userid){
$querystatement="INSERT INTO usersearches (userid,tabledefid,name,type,sqlclause) values (";
$querystatement.=((int) $userid).", ";
$querystatement.="\"".$tabledefid."\", ";
$querystatement.="\"".$name."\", ";
$querystatement.="\"SCH\", ";
$querystatement.="\"".addslashes($_SESSION["tableparams"][$tabledefid]["querywhereclause"])."\")";
$queryresult = $this->db->query($querystatement);
echo "search saved";
}
function get($id){
$querystatement="SELECT sqlclause FROM usersearches
WHERE id=".((int) $id);
$queryresult = $this->db->query($querystatement);
$therecord=$this->db->fetchArray($queryresult);
echo $therecord["sqlclause"];
}
function showSavedSearchList($queryresult,$basepath){
$numrows=$this->db->numRows($queryresult);
?>
db->query($querystatement);
if(!$queryresult) $error = new appError(500,"Cannot retrieve saved search infromation");
$querystatement="SELECT advsearchroleid FROM tabledefs WHERE id=".$tabledefid ;
$tabledefresult = $this->db->query($querystatement);
if(!$tabledefresult) $error = new appError(500,"Cannot retrieve table definition information.");
$tableinfo=$this->db->fetchArray($tabledefresult);
?>
showSavedSearchList($queryresult,$basepath)?>
0)
$securitywhere=" AND roleid IN (".implode(",",$_SESSION["userinfo"]["roles"]).",0)";
$thesearch->showLoad($_GET["tid"],$_GET["base"],$_SESSION["userinfo"]["id"],$securitywhere);
break;
case "getsearch":
$thesearch->get($_GET["id"]);
break;
case "savesearch":
$thesearch->save($_GET["name"],$_GET["tid"],$_SESSION["userinfo"]["id"]);
break;
case "deletesearch":
$thesearch->delete($_GET["id"]);
break;
}//end switch
}?>