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 deleteAgentNumberPattern($agentnumberpatternid = NULL)
{
global $clientRoot;
$result = "";
$am = new AgentManager();
if ($am->isAgentEditor()) {
if (strlen($agentnumberpatternid) > 0) {
$toDelete = new agentnumberpattern();
$toDelete->setagentnumberpatternid($agentnumberpatternid);
if ($toDelete->delete()) {
$result = "Deleted.";
} else {
$result = "Error in deleting agent number pattern record. " . $toDelete->errorMessage();
}
} else {
$result = "No agent number pattern specified to delete.";
}
} else {
$result = "You aren't authorized to edit agent records.";
}
return $result;
}
