/**
* Method used to get the list of canned email responses available in the
* system.
*
* @access public
* @return array The list of canned email responses
*/
function getList()
{
$stmt = "SELECT\n ere_id,\n ere_title\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "email_response\n ORDER BY\n ere_title ASC";
$res = $GLOBALS["db_api"]->dbh->getAll($stmt, DB_FETCHMODE_ASSOC);
if (PEAR::isError($res)) {
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
return "";
} else {
// get the list of associated projects
for ($i = 0; $i < count($res); $i++) {
$res[$i]['projects'] = implode(", ", array_values(Email_Response::getAssociatedProjects($res[$i]['ere_id'])));
}
return $res;
}
}
