if (in_array('draft', $_REQUEST['activity_types'])) {
$sql = "SELECT\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "email_draft.*,\n iss_summary,\n sta_color\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "email_draft,\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "issue,\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "status\n WHERE\n iss_sta_id = sta_id AND\n emd_iss_id = iss_id AND\n iss_prj_id = {$prj_id} AND\n";
$sql .= createWhereClause('emd_updated_date', 'emd_usr_id');
$res = $GLOBALS["db_api"]->dbh->getAll($sql, DB_FETCHMODE_ASSOC);
if (PEAR::isError($res)) {
print_r($res);
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
} else {
$data['draft'] = processResult($res, 'emd_updated_date', 'emd_iss_id');
for ($i = 0; $i < count($data['draft']); $i++) {
if (!empty($data['draft'][$i]['emd_unknown_user'])) {
$data['draft'][$i]['from'] = $data['draft'][$i]["emd_unknown_user"];
} else {
$data['draft'][$i]['from'] = User::getFromHeader($data['draft'][$i]['emd_usr_id']);
}
list($data['draft'][$i]['to'], ) = Draft::getEmailRecipients($data['draft'][$i]['emd_id']);
if (empty($data['draft'][$i]['to'])) {
$data['draft'][$i]['to'] = "Notification List";
}
}
}
}
if (in_array('time', $_REQUEST['activity_types'])) {
$sql = "SELECT\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "time_tracking.*,\n ttc_title,\n iss_summary,\n usr_full_name,\n sta_color\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "time_tracking,\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "time_tracking_category,\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "issue,\n " . ETEL_USER_TABLE . ",\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "status\n WHERE\n iss_sta_id = sta_id AND\n ttr_iss_id = iss_id AND\n ttr_ttc_id = ttc_id AND\n ttr_usr_id = usr_id AND\n iss_prj_id = {$prj_id} AND\n";
$sql .= createWhereClause('ttr_created_date', 'ttr_usr_id');
$res = $GLOBALS["db_api"]->dbh->getAll($sql, DB_FETCHMODE_ASSOC);
if (PEAR::isError($res)) {
print_r($res);
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
} else {
$data['time'] = processResult($res, 'ttr_created_date', 'ttr_iss_id');
private function draftActivity()
{
$sql = "SELECT\n {{%email_draft}}.*,\n iss_summary,\n sta_color\n FROM\n {{%email_draft}},\n {{%issue}},\n {{%status}}\n WHERE\n iss_sta_id = sta_id AND\n emd_iss_id = iss_id AND\n iss_prj_id = ? AND\n";
$params = array($this->prj_id);
$this->createWhereClause($sql, $params, 'emd_updated_date', 'emd_usr_id');
$res = DB_Helper::getInstance()->getAll($sql, $params);
$this->processResult($res, 'emd_updated_date', 'emd_iss_id');
foreach ($res as &$draft) {
if (!empty($draft['emd_unknown_user'])) {
$draft['from'] = $draft['emd_unknown_user'];
} else {
$draft['from'] = User::getFromHeader($draft['emd_usr_id']);
}
list($draft['to']) = Draft::getEmailRecipients($draft['emd_id']);
if (empty($draft['to'])) {
$draft['to'] = 'Notification List';
}
}
return $res;
}
/**
* Returns a list of drafts associated with an issue.
*
* @access public
* @param integer $issue_id The ID of the issue.
* @param boolean $show_all If all draft statuses should be shown
* @return array An array of drafts.
*/
function getList($issue_id, $show_all = false)
{
$issue_id = Misc::escapeInteger($issue_id);
$stmt = "SELECT\n emd_id,\n emd_usr_id,\n emd_subject,\n emd_updated_date,\n emd_unknown_user,\n emd_status\n FROM\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "email_draft\n WHERE\n emd_iss_id={$issue_id}\n";
if ($show_all == false) {
$stmt .= "AND emd_status = 'pending'\n";
}
$stmt .= "ORDER BY\n emd_id";
$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 {
for ($i = 0; $i < count($res); $i++) {
$res[$i]["emd_updated_date"] = Date_API::getFormattedDate($res[$i]["emd_updated_date"]);
if (!empty($res[$i]['emd_unknown_user'])) {
$res[$i]['from'] = $res[$i]["emd_unknown_user"];
} else {
$res[$i]['from'] = User::getFromHeader($res[$i]['emd_usr_id']);
}
list($res[$i]['to'], ) = Draft::getEmailRecipients($res[$i]['emd_id']);
if (empty($res[$i]['to'])) {
$res[$i]['to'] = "Notification List";
}
}
return $res;
}
}