public function getList($table, $sort_col = "id", $sort_dir = "up", $page = 0, $limit = 100, $fields = NULL, $safe_fields = false, $where = array(), $search = "")
{
$table_whitelist = array("team", "organization_user", "feed_entry");
if (!in_array($table, $table_whitelist)) {
return array();
}
if (is_null($fields)) {
$fields = "t.*";
$safe_fields = true;
}
$fields_q = DBHandler::createFieldString($fields, "t", $safe_fields);
$sort_dir = $sort_dir == "up" ? "ASC" : "DESC";
$limit = DBHandler::createLimitString($page, $limit);
$where["organization_id"] = $this->organization_id;
if ($table !== "organization_user") {
$where["organization_domain_id"] = $this->organization_domain_id;
}
$where = DBHandler::createWhereString($where, "t");
if (strlen($search)) {
$where = DBHandler::addSearchToWhere($where, "t", $fields, $search);
}
return $this->dbh->query("SELECT {$fields_q} FROM `{$table}` t WHERE {$where[0]} ORDER BY t.`{$sort_col}` {$sort_dir} LIMIT {$limit}", $where[1]);
}
