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