/** * 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; }
$others = trim(str_replace('"', '', $bits[8])); } echo "{$name} ({$startyear}-{$endyear}) "; $prefix = null; $guid = null; $notes = null; $result = $am->addAgentsFromPartsIfNotExistExt($name, $prefix, $firstname, $middlename, $familyname, $suffix, $startyear, $endyear, $living, $notes, $guid); if ($debug) { print_r($result); } $agentid = $result['agentid']; if (strlen($others) > 0 && strlen($agentid) > 0) { $otherbits = explode("|", $others); foreach ($otherbits as $otherbit) { $othername = explode(":", $otherbit); $an = new agentnames(); $an->setagentid($agentid); $type = $othername[0]; // TODO: Add full range of types. if ($type == "standard" || $type == "Standard Abbreviation") { $an->setType('Standard Abbreviation'); } elseif ($type == "First Initials Last") { $an->setType('First Initials Last'); } else { $an->setType('Also Known As'); } $an->setname($othername[1]); if (!$an->save()) { if (strpos($an->errorMessage(), "Duplicate entry") === FALSE) { // report problems other than duplicate entries echo "Error in saving agent name record: " . $an->errorMessage();
function deleteAgentName($agentnameid = NULL) { global $clientRoot; $result = ""; $am = new AgentManager(); if ($am->isAgentEditor()) { if (strlen($agentnameid) > 0) { $toDelete = new agentnames(); $toDelete->setagentnamesid($agentnameid); if ($toDelete->delete()) { $result = "Deleted."; } else { $result = "Error in deleting agent name record. " . $toDelete->errorMessage(); } } else { $result = "No agent name specified to delete."; } } else { $result = "You aren't authorized to edit agent records."; } return $result; }