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; }