function get_entity_group_list($entitygroup)
{
$list = $entitygroup;
$query = "select * from entity_groups where parent_id=" . $entitygroup;
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
//strList += "," + getEntityGroupList(dbf.rs.getInt("id") + "");
$list .= "," . get_entity_group_list($row['id']);
}
return $list;
}
//require_once 'init2.php';
require_once '../../common/functions.php';
require_once "../../site/includes/sitecommon.php";
/*
* This returns all of the tickers based off of entity group and a 'term'.
*
* This is the script used for the autocomplete control in linechart (et. al.)
*/
db_utility::db_connect();
$entitygroup = "1002";
if (isset($_GET['group']) && $_GET['group'] != 'all') {
$entitygroup = $_GET['group'];
}
$return = array();
$sql = "select entities.ticker,entities.id,entities.full_name ";
$sql .= " from entities ";
$sql .= " join entities_entity_groups on entities.id = entities_entity_groups.entity_id ";
$sql .= " join entity_groups on entities_entity_groups.entity_group_id=entity_groups.id ";
/*
* mysql_real_escape_string to prevent sql injection.
*/
$sql .= " where ticker like '" . mysql_real_escape_string($_REQUEST['term']) . "%' ";
//if (!($entitygroup == 'all'))
// $sql.=" AND entity_groups.id=".$entitygroup;
$sql .= " and entity_groups.id in (" . get_entity_group_list($entitygroup) . ")";
$sql .= " order by ticker asc ";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$return[] = $row;
}
echo json_encode($return);