public function loadArrayByagentid($searchTerm)
{
$returnvalue = array();
$operator = "=";
// change to a like search if a wildcard character is present
if (!(strpos($searchTerm, "%") === false)) {
$operator = "like";
}
if (!(strpos($searchTerm, "_") === false)) {
$operator = "like";
}
$sql = "SELECT agentnumberpatternid FROM agentnumberpattern WHERE agentid {$operator} '{$searchTerm}'";
$preparedsql = "SELECT agentnumberpatternid FROM agentnumberpattern WHERE agentid {$operator} ? ";
if ($statement = $this->conn->prepare($preparedsql)) {
$statement->bind_param("s", $searchTerm);
$statement->execute();
$statement->bind_result($id);
while ($statement->fetch()) {
$obj = new agentnumberpattern();
$obj->load($id);
$returnvalue[] = $obj;
}
$statement->close();
}
return $returnvalue;
}
function loadAgentNumberPattern()
{
$np = null;
$npid = preg_replace('[^0-9]', '', array_key_exists("agentnumberpatternid", $_REQUEST) ? $_REQUEST["agentnumberpatternid"] : "");
if (strlen($npid) > 0) {
$np = new agentnumberpattern();
$np->load($npid);
} else {
throw new Exception("No agent number pattern specified.");
}
return $np;
}
