/**
* Returns a list of investments for given agent.
* @param Agent $agent
* @return Investment[]
*/
public static function GetAgentsInvestments(Agent $agent)
{
$result = DataBase::GetDbInstance()->ExecuteQueryWithParams("SELECT inv.* FROM #S#investments inv INNER JOIN #S#investments_agents ia ON ia.investments_id=inv.id WHERE ia.agents_id=?", array($agent->GetId()));
if ($result) {
$list = array();
while ($row = DataBase::GetDbInstance()->FetchArray($result)) {
$list[count($list)] = self::BuildInvestment($row);
}
}
return $list;
}
/**
* Add or edit if exists, given agent object.
* @param Agent $ag
*/
public static function AddEditAgent(Agent $ag)
{
$a = self::GetAgent($ag->GetId());
if ($a == null) {
self::AddAgent($ag);
} else {
self::EditAgent($ag);
}
}
