public static function getEntityForMap($entity_id)
{
sfLoader::loadHelpers(array("Asset", "Url"));
$db = Doctrine_Manager::connection();
$sql = "SELECT e.*, i.filename " . "FROM entity e LEFT JOIN image i ON (i.entity_id = e.id AND i.is_featured = 1 AND i.is_deleted = 0) " . "WHERE e.id = ?";
$params = array($entity_id);
$stmt = $db->execute($sql, $params);
$entity = $stmt->fetch(PDO::FETCH_ASSOC);
return NetworkMapTable::prepareEntityData($entity);
}
public function executeAddRelatedEntitiesData($request)
{
$this->setResponseFormat();
$entity_id = $request->getParameter("entity_id");
$num = $request->getParameter("num", 10);
$entity_ids = $request->getParameter("entity_ids");
$rel_ids = $request->getParameter("rel_ids");
$include_cat_ids = (array) $request->getParameter("include_cat_ids");
$data = EntityTable::getAddRelatedEntitiesAndRelsForMap($entity_id, $num, $entity_ids, $rel_ids, $include_cat_ids);
$data = NetworkMapTable::prepareData($data);
return $this->renderText(json_encode($data));
}
