/**
* Given an id for an agent, return the list of agent names associated with that agent.
*
* @param agentid the agentid for the agent to find names for.
* @return an array of agentnames containing the names for the specified agent.
*/
public function findAgentNamesByAgentId($agentid)
{
$result = array();
$sql = "select agentnamesid from agentnames where agentid = ? ";
if ($statement = $this->conn->prepare($sql)) {
$statement->bind_param("i", $agentid);
$statement->execute();
$statement->bind_result($agentnameid);
while ($statement->fetch()) {
$an = new agentnames();
$an->load($agentnameid);
$result[] = $an;
}
$statement->close();
} else {
throw new Exception("Query preparation failed for '{$sql}'");
}
return $result;
}
/**
* Obtain agentid or uuid from request and lookup agent.
* @return agent found, or null.
*/
function loadAgentName()
{
$agentname = null;
$agentnameid = preg_replace('[^0-9]', '', array_key_exists("agentnamesid", $_REQUEST) ? $_REQUEST["agentnamesid"] : "");
if (strlen($agentnameid) > 0) {
$agentname = new agentnames();
$agentname->load($agentnameid);
} else {
throw new Exception("No agent name specified.");
}
return $agentname;
}
