/** * 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); } }