[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 = $note_id ? 'Edit Note' : 'Add Note';
  64  $titleBlock = new CTitleBlock($ttl, 'notebook.png', $m, $m . '.' . $a);
  65  $titleBlock->addCrumb('?m=' . $m, 'notes list');
  66  $canDelete = $perms->checkModule($m, 'delete');
  67  if ($canDelete && $note_id > 0) {
  68      $titleBlock->addCrumbDelete('delete note', $canDelete, $msg);
  69  }
  70  $titleBlock->show();
  71  
  72  if ($obj->note_project) {
  73      $note_project = $obj->note_project;
  74  }
  75  if ($obj->note_task) {
  76      $note_task = $obj->note_task;
  77      $task_name = $obj->task_name;
  78  } elseif ($note_task) {
  79      $q->clear();
  80      $q->addQuery('task_name');
  81      $q->addTable('tasks');
  82      $q->addWhere('task_id = ' . (int)$note_task);
  83      $task_name = $q->loadResult();
  84  } else {
  85      $task_name = '';
  86  }
  87  
  88  if ($obj->note_company) {
  89      $note_company = $obj->note_company;
  90      $company_name = $obj->company_name;
  91  } elseif ($note_company) {
  92      $q->clear();
  93      $q->addQuery('company_name');
  94      $q->addTable('companies');
  95      $q->addWhere('company_id = ' . (int)$note_company);
  96      $company_name = $q->loadResult();
  97  } else {
  98      $company_name = '';
  99  }
 100  
 101  if (intval(w2PgetParam($_GET, 'company_id', 0))) {
 102      $extra = array('where' => 'project_active = 1 AND project_company = ' . $note_company);
 103  } else {
 104      $extra = array('where' => 'project_active = 1');
 105  }
 106  $project = new CProject();
 107  $projects = $project->getAllowedRecords($AppUI->user_id, 'projects.project_id,project_name', 'project_name', null, $extra, 'projects');
 108  $projects = arrayMerge(array('0' => $AppUI->_('All', UI_OUTPUT_JS)), $projects);
 109  
 110  ?>
 111  <script language="javascript">
 112  function submitIt() {
 113      var f = document.uploadFrm;
 114      f.submit();
 115  }
 116  function delIt() {
 117      if (confirm( "<?php echo $AppUI->_('notesDelete', UI_OUTPUT_JS); ?>" )) {
 118          var f = document.uploadFrm;
 119          f.del.value='1';
 120          f.submit();
 121      }
 122  }
 123  function popTask() {
 124      var f = document.uploadFrm;
 125      if (f.note_project.selectedIndex == 0) {
 126          alert( "<?php echo $AppUI->_('Please select a project first!', UI_OUTPUT_JS); ?>" );
 127      } else {
 128          window.open('./index.php?m=public&a=selector&dialog=1&callback=setTask&table=tasks&task_project='
 129              + f.note_project.options[f.note_project.selectedIndex].value, 'task','left=50,top=50,height=250,width=400,resizable')
 130      }
 131  }
 132  
 133  // Callback function for the generic selector
 134  function setTask( key, val ) {
 135      var f = document.uploadFrm;
 136      if (val != '') {
 137          f.note_task.value = key;
 138          f.task_name.value = val;
 139      } else {
 140          f.note_task.value = '0';
 141          f.task_name.value = '';
 142      }
 143  }
 144  </script>
 145  
 146  <form name="uploadFrm" action="?m=notebook" method="post">
 147      <input type="hidden" name="dosql" value="do_note_aed" />
 148      <input type="hidden" name="del" value="0" />
 149      <input type="hidden" name="note_id" value="<?php echo $note_id; ?>" />
 150      <input type="hidden" name="note_creator" value="<?php echo ($note_id ? $obj->note_creator : $AppUI->user_id); ?>" />
 151      <input type="hidden" name="note_company" value="<?php echo $note_company; ?>" />
 152  <table width="100%" border="0" cellpadding="3" cellspacing="3" class="std">
 153  <tr>
 154      <td width="100%" valign="top" align="center">
 155          <table cellspacing="1" cellpadding="2" width="100%">
 156          <tr>
 157              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Note Title'); ?>:</td>
 158              <td align="left"><input type="text" style="width:400px" class="text" name="note_title" value="<?php echo $obj->note_title; ?>" /></td>
 159          </tr>
 160          <tr>
 161              <td align="right"><?php echo $AppUI->_('Private'); ?>:</td>
 162              <td>
 163                  <input type="checkbox" value="1" name="note_private" <?php echo ($obj->note_private ? 'checked="checked"' : ''); ?> />
 164              </td>
 165          </tr>
 166      <?php if ($note_id) { ?>
 167          <tr>
 168              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Created By'); ?>:</td>
 169              <td align="left" class="hilite"><?php echo $obj->contact_first_name . ' ' . $obj->contact_last_name; ?>, <?php echo $note_created->format($df . ' ' . $tf); ?></td>
 170          </tr>
 171      <?php } ?>
 172      <?php if ($obj->note_modified_by) { ?>
 173          <tr>
 174              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Modified By'); ?>:</td>
 175              <td align="left" class="hilite"><?php echo $obj->modified_first_name . ' ' . $obj->modified_last_name; ?>, <?php echo $note_modified->format($df . ' ' . $tf); ?></td>
 176          </tr>
 177      <?php } ?>
 178          <tr>
 179              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Category'); ?>:</td>
 180              <td align="left">
 181                      <?php echo arraySelect(w2PgetSysVal('NoteCategory'), 'note_category', 'class="text"', $obj->note_category, true); ?>
 182              </td>
 183          </tr>
 184          <tr>
 185              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Status'); ?>:</td>
 186              <td align="left">
 187                      <?php echo arraySelect(w2PgetSysVal('NoteStatus'), 'note_status', 'class="text"', $obj->note_status, true); ?>
 188              </td>
 189          </tr>
 190      <?php if ($company_name) { ?>
 191          <tr>
 192              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Company'); ?>:</td>
 193              <td align="left" class="hilite"><?php echo $company_name; ?></td>
 194          </tr>
 195      <?php } ?>
 196          <tr>
 197              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Project'); ?>:</td>
 198              <td align="left">
 199              <?php
 200  echo arraySelect($projects, 'note_project', 'size="1" class="text" style="width:270px"', $note_project);
 201  ?>
 202              </td>
 203          </tr>
 204  
 205          <tr>
 206              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Task'); ?>:</td>
 207              <td align="left" colspan="2" valign="top">
 208                  <input type="hidden" name="note_task" value="<?php echo $note_task; ?>" />
 209                  <input type="text" class="text" name="task_name" value="<?php echo $task_name; ?>" size="40" disabled="disabled" />
 210                  <input type="button" class="button" value="<?php echo $AppUI->_('select task'); ?>..." onclick="popTask()" />
 211              </td>
 212          </tr>
 213  
 214          <tr>
 215              <td align="right" valign="top" nowrap="nowrap"><?php echo $AppUI->_('Description'); ?>:</td>
 216              <td align="left">
 217  <?php
 218      $oFCKeditor = new FCKeditor('note_body') ;
 219      $oFCKeditor->BasePath = 'lib/fckeditor/';
 220      $oFCKeditor->Value = $obj->note_body;
 221      $oFCKeditor->Height = '400' ;
 222      $oFCKeditor->Create() ;
 223  ?>            
 224              </td>
 225          </tr>
 226  
 227          <tr>
 228              <td align="right" nowrap="nowrap"><?php echo $AppUI->_('Note Doc URL'); ?>:</td>
 229              <td align="left"><input type="field" class="text" name="note_doc_url" style="width:400px" value="<?php echo $obj->note_doc_url ?>" /></td>
 230          </tr>
 231          </table>
 232      </td>
 233  </tr>
 234  <tr>
 235      <td>
 236          <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=notebook';}" />
 237      </td>
 238      <td align="right">
 239          <input type="button" class="button" value="<?php echo $AppUI->_('submit'); ?>" onclick="submitIt()" />
 240      </td>
 241  </tr>
 242  </form>
 243  </table>