[Summary view] [Print] [Text view]

   1  <?php /* $Id: addedit.php 137 2008-04-04 16:12:02Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/links/addedit.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  $link_id = intval(w2PgetParam($_GET, 'link_id', 0));
   7  
   8  // check permissions for this record
   9  $perms = &$AppUI->acl();
  10  $canAuthor = $perms->checkModule('links', 'add');
  11  $canEdit = $perms->checkModuleItem('links', 'edit', $link_id);
  12  
  13  // check permissions
  14  if (!$canAuthor && !$link_id) {
  15      $AppUI->redirect('m=public&a=access_denied');
  16  }
  17  
  18  if (!$canEdit && $link_id) {
  19      $AppUI->redirect('m=public&a=access_denied');
  20  }
  21  
  22  // load the companies class to retrieved denied companies
  23  require_once ($AppUI->getModuleClass('projects'));
  24  
  25  $link_task = intval(w2PgetParam($_GET, 'link_task', 0));
  26  $link_parent = intval(w2PgetParam($_GET, 'link_parent', 0));
  27  $link_project = intval(w2PgetParam($_GET, 'project_id', 0));
  28  
  29  $q = new DBQuery();
  30  $q->addQuery('links.*');
  31  $q->addQuery('user_username');
  32  $q->addQuery('contact_first_name,    contact_last_name');
  33  $q->addQuery('project_id');
  34  $q->addQuery('task_id, task_name');
  35  $q->addTable('links');
  36  $q->leftJoin('users', 'u', 'link_owner = user_id');
  37  $q->leftJoin('contacts', 'c', 'user_contact = contact_id');
  38  $q->leftJoin('projects', 'p', 'project_id = link_project');
  39  $q->leftJoin('tasks', 't', 'task_id = link_task');
  40  $q->addWhere('link_id = ' . (int)$link_id);
  41  
  42  // check if this record has dependancies to prevent deletion
  43  $msg = '';
  44  $obj = new CLink();
  45  $canDelete = $obj->canDelete($msg, $link_id);
  46  
  47  $obj = null;
  48  $q->loadObject($obj);
  49  // load the record data
  50  if (!$obj && $link_id > 0) {
  51      $AppUI->setMsg('Link');
  52      $AppUI->setMsg('invalidID', UI_MSG_ERROR, true);
  53      $AppUI->redirect();
  54  }
  55  
  56  // setup the title block
  57  $ttl = $link_id ? 'Edit Link' : 'Add Link';
  58  $titleBlock = new CTitleBlock($ttl, 'folder5.png', $m, $m . '.' . $a);
  59  $titleBlock->addCrumb('?m=' . $m, 'links list');
  60  $canDelete = $perms->checkModuleItem($m, 'delete', $link_id);
  61  if ($canDelete && $link_id > 0) {
  62      $titleBlock->addCrumbDelete('delete link', $canDelete, $msg);
  63  }
  64  $titleBlock->show();
  65  
  66  if ($obj->link_project) {
  67      $link_project = $obj->link_project;
  68  }
  69  if ($obj->link_task) {
  70      $link_task = $obj->link_task;
  71      $task_name = $obj->task_name;
  72  } elseif ($link_task) {
  73      $q->clear();
  74      $q->addQuery('task_name');
  75      $q->addTable('tasks');
  76      $q->addWhere('task_id = ' . (int)$link_task);
  77      $task_name = $q->loadResult();
  78  } else {
  79      $task_name = '';
  80  }
  81  
  82  $extra = array('where' => 'project_active = 1');
  83  $project = new CProject();
  84  $projects = $project->getAllowedRecords($AppUI->user_id, 'projects.project_id,project_name', 'project_name', null, $extra, 'projects');
  85  $projects = arrayMerge(array('0' => $AppUI->_('All', UI_OUTPUT_JS)), $projects);
  86  
  87  ?>
  88  <script language="javascript">
  89  function submitIt() {
  90      var f = document.uploadFrm;
  91      f.submit();
  92  }
  93  function delIt() {
  94      if (confirm( "<?php echo $AppUI->_('linksDelete', UI_OUTPUT_JS); ?>" )) {
  95          var f = document.uploadFrm;
  96          f.del.value='1';
  97          f.submit();
  98      }
  99  }
 100  function popTask() {
 101      var f = document.uploadFrm;
 102      if (f.link_project.selectedIndex == 0) {
 103          alert( "<?php echo $AppUI->_('Please select a project first!', UI_OUTPUT_JS); ?>" );
 104      } else {
 105          window.open('./index.php?m=public&a=selector&dialog=1&callback=setTask&table=tasks&task_project='
 106              + f.link_project.options[f.link_project.selectedIndex].value, 'task','left=50,top=50,height=250,width=400,resizable')
 107      }
 108  }
 109  
 110  // Callback function for the generic selector
 111  function setTask( key, val ) {
 112      var f = document.uploadFrm;
 113      if (val != '') {
 114          f.link_task.value = key;
 115          f.task_name.value = val;
 116      } else {
 117          f.link_task.value = '0';
 118          f.task_name.value = '';
 119      }
 120  }
 121  </script>
 122  
 123  <table width="100%" border="0" cellpadding="3" cellspacing="3" class="std">
 124  
 125  <form name="uploadFrm" action="?m=links" method="post">
 126      <input type="hidden" name="dosql" value="do_link_aed" />
 127      <input type="hidden" name="del" value="0" />
 128      <input type="hidden" name="link_id" value="<?php echo $link_id; ?>" />
 129  
 130  <tr>
 131      <td width="100%" valign="top" align="center">
 132          <table cellspacing="1" cellpadding="2" width="60%">
 133          <tr>
 134              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Link Name'); ?>:</td>
 135              <td align="left"><input type="text" class="text" name="link_name" value="<?php echo $obj->link_name; ?>"></td>
 136      <?php if ($link_id) { ?>
 137              <td>
 138                  <a href="<?php echo $obj->link_url; ?>" target="_blank"><?php echo $AppUI->_('go'); ?></a>
 139              </td>
 140          </tr>
 141          <tr>
 142              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Uploaded By'); ?>:</td>
 143              <td align="left" class="hilite"><?php echo $obj->contact_first_name . ' ' . $obj->contact_last_name; ?></td>
 144      <?php } ?>
 145          </tr>
 146                  <tr>
 147                          <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Category'); ?>:</td>
 148                          <td align="left">
 149                                  <?php echo arraySelect(w2PgetSysVal('LinkType'), 'link_category', '', $obj->link_category, true); ?>
 150                          <td>
 151  
 152          <tr>
 153              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Project'); ?>:</td>
 154              <td align="left">
 155              <?php
 156  echo arraySelect($projects, 'link_project', 'size="1" class="text" style="width:270px"', $link_project);
 157  ?>
 158              </td>
 159          </tr>
 160  
 161          <tr>
 162              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Task'); ?>:</td>
 163              <td align="left" colspan="2" valign="top">
 164                  <input type="hidden" name="link_task" value="<?php echo $link_task; ?>" />
 165                  <input type="text" class="text" name="task_name" value="<?php echo $task_name; ?>" size="40" disabled="disabled" />
 166                  <input type="button" class="button" value="<?php echo $AppUI->_('select task'); ?>..." onclick="popTask()" />
 167              </td>
 168          </tr>
 169  
 170          <tr>
 171              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Description'); ?>:</td>
 172              <td align="left">
 173                  <textarea name="link_description" class="textarea" rows="4" style="width:270px"><?php echo $obj->link_description; ?></textarea>
 174              </td>
 175          </tr>
 176  
 177          <tr>
 178              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Link URL'); ?>:</td>
 179              <td align="left"><input type="field" name="link_url" style="width:270px" value="<?php echo $obj->link_url ?>"></td>
 180          </tr>
 181          </table>
 182      </td>
 183  </tr>
 184  <tr>
 185      <td>
 186          <input class="button" type="button" name="cancel" value="<?php echo $AppUI->_('cancel'); ?>" onclick="javascript:if(confirm('<?php echo $AppUI->_('Are you sure you want to cancel?', UI_OUTPUT_JS); ?>')){location.href = './index.php?m=links';}" />
 187      </td>
 188      <td align="right">
 189          <input type="button" class="button" value="<?php echo $AppUI->_('submit'); ?>" onclick="submitIt()" />
 190      </td>
 191  </tr>
 192  </form>
 193  </table>