<th valign="top" colspan="2"><strong><?php
echo $AppUI->_($message_id ? 'Edit Message' : 'Add Message');
?>
</strong></th>
</tr>
<?php
if ($message_parent >= 0) {
//check if this is a reply-post; if so, printout the original message
$date = intval($message_info["message_date"]) ? new CDate($message_info["message_date"]) : new CDate();
?>
<tr><td align="right"><?php
echo $AppUI->_('Author');
?>
:</td><td align="left"><?php
echo dPgetUsername($message_info['user_username']);
?>
(<?php
echo $date->format("{$df} {$tf}");
?>
)</td></tr>
<tr><td align="right"><?php
echo $AppUI->_('Subject');
?>
:</td><td align="left"><?php
echo $message_info['message_title'];
?>
</td></tr>
<tr><td align="right" valign="top"><?php
echo $AppUI->_('Message');
?>
$q->addWhere('project_status != 7');
$q->addGroup('project_id');
$q->addOrder('project_name');
$project->setAllowedSQL($AppUI->user_id, $q);
$projects = $q->loadHashList('project_id');
$q->clear();
##############################################
/* gantt is called now by the todo page, too.
** there is a different filter approach in todo
** so we have to tweak a little bit,
** also we do not have a special project available
*/
$caller = defVal(@$_REQUEST['caller'], null);
if ($caller == 'todo') {
$user_id = defVal(@$_REQUEST['user_id'], 0);
$projects[$project_id]['project_name'] = $AppUI->_('Todo for') . ' ' . dPgetUsername($user_id);
$projects[$project_id]['project_color_identifier'] = 'ff6000';
$showLabels = dPgetParam($_REQUEST, 'showLabels', false);
$showPinned = dPgetParam($_REQUEST, 'showPinned', false);
$showArcProjs = dPgetParam($_REQUEST, 'showArcProjs', false);
$showHoldProjs = dPgetParam($_REQUEST, 'showHoldProjs', false);
$showDynTasks = dPgetParam($_REQUEST, 'showDynTasks', false);
$showLowTasks = dPgetParam($_REQUEST, 'showLowTasks', true);
$q = new DBQuery();
$q->addQuery('ta.*');
$q->addQuery('project_name, project_id, project_color_identifier');
$q->addQuery('tp.task_pinned');
$q->addTable('projects', 'pr');
$q->addTable('tasks', 'ta');
$q->addTable('user_tasks', 'ut');
$q->leftJoin('user_task_pin', 'tp', 'tp.task_id = ta.task_id and tp.user_id = ' . $user_id);
