//$childrenlist[] = $ganttTaskFilter;
//print_r($childrenlist);
$childrenlist = $task_child_search->getDeepChildren();
//print_r($childrenlist);
$where .= ' t.task_id IN (' . $ganttTaskFilter . ', ' . implode(', ', $childrenlist) . ')';
}
//else {
// $where = '';
//}
//echo '<pre> $where = ' . $where . '</pre>';
//die;
// 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
if ($caller == 'todo') {
$user_id = defVal(@$_REQUEST['user_id'], 0);
$projects[$project_id]['project_name'] = $AppUI->_('Todo for') . ' ' . dPgetUsernameFromID($user_id);
$projects[$project_id]['project_color_identifier'] = 'ff6000';
$q->addTable('tasks', 't');
$q->innerJoin('projects', 'p', 'p.project_id = t.task_project');
$q->innerJoin('user_tasks', 'ut', 'ut.task_id = t.task_id AND ut.user_id = ' . $user_id);
$q->leftJoin('user_task_pin', 'tp', 'tp.task_id = t.task_id AND tp.user_id = ' . $user_id);
$q->addQuery('t.*, p.project_name, p.project_id, p.project_color_identifier, tp.task_pinned');
$q->addWhere('(t.task_percent_complete < 100 OR t.task_percent_complete IS NULL)');
$q->addWhere('t.task_status = 0');
if (!$showArcProjs) {
$q->addWhere('project_status <> 7');
}
if (!$showLowTasks) {
$q->addWhere('task_priority >= 0');
}
if (!$showHoldProjs) {
<td width="50%">
<table cellspacing="1" cellpadding="2" border="0" width="100%">
<tr>
<td colspan="3"><strong><?php
echo strtoupper($AppUI->_('Assigned Users'));
?>
</strong></td>
</tr>
<tr>
<td colspan="3">
<?php
$s = '';
$s = count($users) == 0 ? "<tr><td bgcolor=#ffffff>" . $AppUI->_('none') . "</td></tr>" : '';
foreach ($users as $row) {
$s .= '<tr>';
$s .= '<td class="hilite">' . dPgetUsernameFromID($row["user_id"]) . '</td>';
$s .= '<td class="hilite"><a href="mailto:' . $row["contact_email"] . '">' . $row["contact_email"] . '</a></td>';
$s .= '</tr>';
}
echo '<table width="100%" cellspacing=1 bgcolor="black">' . $s . '</table>';
?>
</td>
</tr>
<?php
// Pull tasks dependencies
$q->addQuery('td.dependencies_req_task_id, t.task_name');
$q->addTable('tasks', 't');
$q->addTable('task_dependencies', 'td');
$q->addWhere('td.dependencies_req_task_id = t.task_id');
$q->addWhere('td.dependencies_task_id = ' . $task_id);
## add or edit a user preferences
##
$user_id = (int) dPgetParam($_GET, 'user_id', '0');
// Check permissions
if (!$canEdit && $user_id != $AppUI->user_id) {
$AppUI->redirect("m=public&a=access_denied");
}
// load the preferences
$q = new DBQuery();
$q->addQuery('pref_name, pref_value');
$q->addTable('user_preferences');
$q->addWhere('pref_user in (0,' . (int) $user_id . ')');
$q->addOrder('pref_user');
$prefs = $q->loadHashList();
// get the user name
$user = $user_id ? dPgetUsernameFromID($user_id) : 'Default';
$titleBlock = new CTitleBlock('Edit User Preferences', 'myevo-weather.png', $m, "{$m}.{$a}");
if (getPermission('system', 'edit')) {
$titleBlock->addCrumb("?m=system", "system admin");
$titleBlock->addCrumb("?m=system&a=systemconfig", "system configuration");
}
$titleBlock->show();
?>
<script type="text/javascript" language="javascript">
function submitIt() {
var form = document.changeuser;
// Collate the checked states of the task log stuff
var defs = document.getElementById('task_log_email_defaults');
var mask = 0;
if (form.tl_assign.checked)
mask += 1;
<td id="<?php
echo $d['file_task'];
?>
" align="center">
<img src="images/log.gif"/>
</td>
<td nowrap="nowrap" onclick="doViewFile(this)"><?php
echo $d['file_name'];
?>
</td>
<td><?php
echo sprintf('%.2f', $d['file_version']);
?>
</td>
<td nowrap="nowrap"><?php
echo dPgetUsernameFromID($d['file_owner']);
?>
</td>
<td onclick="doViewFile(this)"><?php
echo $d['file_size'];
?>
</td>
<td nowrap="nowrap" onclick="doViewFile(this)"><?php
echo substr($d['file_date'], 0, strrpos($d['file_date'], ':'));
?>
</td>
<td onclick="doViewFile(this)"><?php
echo $d['file_description'];
?>
</td>
<td align="center">
die('You should not access this file directly.');
}
##
## add or edit a user preferences
##
$user_id = dPgetParam($_GET, 'user_id', '0');
// Check permissions
if (!$canEdit && $user_id != $AppUI->user_id) {
$AppUI->redirect("m=public&a=access_denied");
}
// load the preferences
$sql = "\nSELECT pref_name, pref_value\nFROM user_preferences\nWHERE pref_user = {$user_id}\n";
$prefs = db_loadHashList($sql);
// get the user name
if ($user_id) {
$user = dPgetUsernameFromID($user_id);
} else {
$user = "******";
}
$titleBlock = new CTitleBlock('Edit User Preferences', 'myevo-weather.png', $m, "{$m}.{$a}");
$perms =& $AppUI->acl();
if ($perms->checkModule('system', 'edit')) {
$titleBlock->addCrumb("?m=system", "system admin");
$titleBlock->addCrumb("?m=system&a=systemconfig", "system configuration");
}
$titleBlock->show();
?>
<script language="javascript">
function submitIt(){
var form = document.changeuser;
// Collate the checked states of the task log stuff