[Summary view] [Print] [Text view]

   1  <?php /* $Id: listtasks.php 40 2008-02-11 12:11:44Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/tasks/listtasks.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  $perms = &$AppUI->acl();
   7  if (!$perms->checkModule('tasks', 'view')) {
   8      $AppUI->redirect('m=public&a=access_denied');
   9  }
  10  $proj = w2PgetParam($_GET, 'project', 0);
  11  $userFilter = w2PgetParam($_GET, 'userFilter', false);
  12  
  13  $q = new DBQuery();
  14  $q->addQuery('t.task_id, t.task_name');
  15  $q->addTable('tasks', 't');
  16  
  17  if ($userFilter) {
  18      $q->addJoin('user_tasks', 'ut', 'ut.task_id = t.task_id');
  19      $q->addWhere('ut.user_id = ' . (int)$AppUI->user_id);
  20  }
  21  if ($proj != 0) {
  22      $q->addWhere('task_project = ' . (int)$proj);
  23  }
  24  $tasks = $q->loadList();
  25  $q->clear();
  26  ?>
  27  
  28  <script language="JavaScript">
  29  function loadTasks() {
  30      var tasks = new Array();
  31      var sel = parent.document.forms['form'].new_task;
  32      while (sel.options.length) {
  33          sel.options[0] = null;
  34      }
  35      sel.options[0] = new Option('[top task]', 0);
  36      
  37    <?php
  38  $i = 0;
  39  foreach ($tasks as $task) {
  40      ++$i;
  41  ?>
  42    sel.options[<?php echo $i; ?>] = new Option("<?php echo $task['task_name']; ?>", <?php echo $task['task_id']; ?>);
  43      <?php
  44  }
  45  ?>
  46  }
  47    
  48  loadTasks();
  49  </script>