[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  $note_id = intval(w2PgetParam($_GET, 'note_id', 0));
   7  
   8  // check permissions for this record
   9  $perms = &$AppUI->acl();
  10  $canEdit = $perms->checkModule($m, 'edit');
  11  if (!$canEdit) {
  12      $AppUI->redirect('m=public&a=access_denied');
  13  }
  14  
  15  // load the companies class to retrieved denied companies
  16  require_once ($AppUI->getModuleClass('projects'));
  17  include ($AppUI->getLibraryClass('fckeditor/fckeditor')); 
  18  
  19  $note_task = intval(w2PgetParam($_GET, 'task_id', 0));
  20  $note_parent = intval(w2PgetParam($_GET, 'note_parent', 0));
  21  $note_project = intval(w2PgetParam($_GET, 'project_id', 0));
  22  $note_company = intval(w2PgetParam($_GET, 'company_id', 0));
  23  
  24  $q = new DBQuery();
  25  $q->addQuery('notes.*');
  26  $q->addQuery('u.user_username');
  27  $q->addQuery('c.contact_first_name, c.contact_last_name');
  28  $q->addQuery('cm.contact_first_name AS modified_first_name, cm.contact_last_name AS modified_last_name');
  29  $q->addQuery('project_id');
  30  $q->addQuery('task_id, task_name');
  31  $q->addQuery('company_id, company_name');
  32  $q->addTable('notes');
  33  $q->leftJoin('users', 'u', 'note_creator = u.user_id');
  34  $q->leftJoin('contacts', 'c', 'u.user_contact = c.contact_id');
  35  $q->leftJoin('users', 'um', 'note_modified_by = um.user_id');
  36  $q->leftJoin('contacts', 'cm', 'um.user_contact = cm.contact_id');
  37  $q->leftJoin('companies', 'co', 'company_id = note_company');
  38  $q->leftJoin('projects', 'p', 'project_id = note_project');
  39  $q->leftJoin('tasks', 't', 'task_id = note_task');
  40  $q->addWhere('note_id = ' . (int)$note_id);
  41  
  42  // check if this record has dependancies to prevent deletion
  43  $msg = '';
  44  $obj = new CNote();
  45  $canDelete = $obj->canDelete($msg, $note_id);
  46  
  47  $obj = null;
  48  $q->loadObject($obj);
  49  // load the record data
  50  if (!$obj && $note_id > 0) {
  51      $AppUI->setMsg('Note');
  52      $AppUI->setMsg('invalidID', UI_MSG_ERROR, true);
  53      $AppUI->redirect();
  54  }
  55  
  56  $df = $AppUI->getPref('SHDATEFORMAT');
  57  $tf = $AppUI->getPref('TIMEFORMAT');
  58  
  59  $note_created = new CDate($obj->note_created);
  60  $note_modified = new CDate($obj->note_modified);
  61  
  62  // setup the title block
  63  $ttl = 'View Note';
  64  $titleBlock = new CTitleBlock($ttl, 'notebook.png', $m, $m . '.' . $a);
  65  $titleBlock->addCrumb('?m=' . $m, 'notes list');
  66  $titleBlock->addCrumb('?m=' . $m . '&a=addedit&note_id=' . $note_id, 'edit note');
  67  $canDelete = $perms->checkModule($m, 'delete');
  68  if ($canDelete && $note_id > 0) {
  69      $titleBlock->addCrumbDelete('delete note', $canDelete, $msg);
  70  }
  71  $titleBlock->show();
  72  
  73  if ($obj->note_project) {
  74      $note_project = $obj->note_project;
  75  }
  76  if ($obj->note_task) {
  77      $note_task = $obj->note_task;
  78      $task_name = $obj->task_name;
  79  } elseif ($note_task) {
  80      $q->clear();
  81      $q->addQuery('task_name');
  82      $q->addTable('tasks');
  83      $q->addWhere('task_id = ' . (int)$note_task);
  84      $task_name = $q->loadResult();
  85  } else {
  86      $task_name = '';
  87  }
  88  
  89  if ($obj->note_company) {
  90      $note_company = $obj->note_company;
  91      $company_name = $obj->company_name;
  92  } elseif ($note_company) {
  93      $q->clear();
  94      $q->addQuery('company_name');
  95      $q->addTable('companies');
  96      $q->addWhere('company_id = ' . (int)$note_company);
  97      $company_name = $q->loadResult();
  98  } else {
  99      $company_name = '';
 100  }
 101  
 102  if (intval(w2PgetParam($_GET, 'company_id', 0))) {
 103      $extra = array('where' => 'project_active = 1 AND project_company = ' . $note_company);
 104  } else {
 105      $extra = array('where' => 'project_active = 1');
 106  }
 107  $project = new CProject();
 108  $projects = $project->getAllowedRecords($AppUI->user_id, 'projects.project_id,project_name', 'project_name', null, $extra, 'projects');
 109  $projects = arrayMerge(array('0' => $AppUI->_('All', UI_OUTPUT_JS)), $projects);
 110  
 111  $categories = w2PgetSysVal('NoteCategory');
 112  $status = w2PgetSysVal('NoteStatus');
 113  ?>
 114  
 115  <table width="100%" border="0" cellpadding="3" cellspacing="3" class="std">
 116  <tr>
 117      <td width="100%" valign="top" align="center">
 118          <table cellspacing="1" cellpadding="2" width="100%">
 119          <tr>
 120              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Note Title'); ?>:</td>
 121              <td align="left" class="hilite"><?php echo $obj->note_title; ?></td>
 122          </tr>
 123          <tr>
 124              <td align="right"><?php echo $AppUI->_('Private'); ?>:</td>
 125              <td>
 126                  <input type="checkbox" disabled="disabled" name="note_private" <?php echo ($obj->note_private ? 'checked="checked"' : ''); ?> />
 127              </td>
 128          </tr>
 129      <?php if ($note_id) { ?>
 130          <tr>
 131              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Created By'); ?>:</td>
 132              <td align="left" class="hilite"><?php echo $obj->contact_first_name . ' ' . $obj->contact_last_name; ?>, <?php echo $note_created->format($df . ' ' . $tf); ?></td>
 133          </tr>
 134      <?php } ?>
 135      <?php if ($obj->note_modified_by) { ?>
 136          <tr>
 137              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Modified By'); ?>:</td>
 138              <td align="left" class="hilite"><?php echo $obj->modified_first_name . ' ' . $obj->modified_last_name; ?>, <?php echo $note_modified->format($df . ' ' . $tf); ?></td>
 139          </tr>
 140      <?php } ?>
 141          <tr>
 142              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Category'); ?>:</td>
 143              <td align="left" class="hilite">
 144                  <?php echo $categories[$obj->note_category]; ?>
 145              </td>
 146          </tr>
 147          <tr>
 148              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Status'); ?>:</td>
 149              <td align="left" class="hilite">
 150                  <?php echo $status[$obj->note_status]; ?>
 151              </td>
 152          </tr>
 153      <?php if ($company_name) { ?>
 154          <tr>
 155              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Company'); ?>:</td>
 156              <td align="left" class="hilite">
 157                  <?php echo $company_name; ?>
 158              </td>
 159          </tr>
 160      <?php } ?>
 161          <tr>
 162              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Project'); ?>:</td>
 163              <td align="left" class="hilite">
 164                  <?php echo $projects[$note_project]; ?>
 165              </td>
 166          </tr>
 167  
 168          <tr>
 169              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Task'); ?>:</td>
 170              <td align="left" class="hilite">
 171                  <?php echo $task_name; ?>
 172              </td>
 173          </tr>
 174  
 175          <tr>
 176              <td align="right" valign="top" nowrap="nowrap"><?php echo $AppUI->_('Description'); ?>:</td>
 177              <td align="left">
 178  <?php
 179      $oFCKeditor = new FCKeditor('note_body') ;
 180      $oFCKeditor->BasePath = 'lib/fckeditor/';
 181      $oFCKeditor->Value = $obj->note_body;
 182      $oFCKeditor->Height = '600' ;
 183      $oFCKeditor->Config['ToolbarStartExpanded'] = false;
 184      $oFCKeditor->Config['ToolbarCanCollapse'] = true;
 185      $oFCKeditor->ToolbarSet = 'Empty';
 186      $oFCKeditor->Create() ;
 187  ?>            
 188              </td>
 189          </tr>
 190  
 191      <?php if (trim($obj->note_doc_url)) { ?>
 192          <tr>
 193              <td align="right" nowrap="nowrap">&nbsp;</td>
 194              <td align="left" nowrap="nowrap"><a href="<?php echo $obj->note_doc_url; ?>" target="_blank"><?php echo $AppUI->_('Note Document'); ?></a></td>
 195          </tr>
 196      <?php } ?>
 197          </table>
 198      </td>
 199  </tr>
 200  </table>