nowDbDate(); $today = $timedate->handle_offset($today, $timedate->dbDayFormat, false); $ListView = new ListView(); $seedProjectTask = new ProjectTask(); $where = "project_task.assigned_user_id='{$current_user->id}'" . " AND (project_task.status IS NULL OR (project_task.status!='Completed' AND project_task.status!='Deferred'))" . " AND (project_task.date_start IS NULL OR project_task.date_start <= '$today')"; $ListView->initNewXTemplate('modules/ProjectTask/MyProjectTasks.html', $current_module_strings); $header_text = ''; if(is_admin($current_user) && $_REQUEST['module'] != 'DynamicLayout' && !empty($_SESSION['editinplace'])) { $header_text = " " . SugarThemeRegistry::current()->getImage("EditLayout","border='0' align='bottom'",null,null,'.gif',$mod_strings['LBL_EDITLAYOUT']) . ''; } $ListView->setHeaderTitle($current_module_strings['LBL_LIST_MY_PROJECT_TASKS'].$header_text); $ListView->setQuery($where, "", "date_due,priority desc", "PROJECT_TASK"); $ListView->processListView($seedProjectTask, "main", "PROJECT_TASK"); ?>