[Summary view] [Print] [Text view]

   1  <?php /* $Id: links.class.php 56 2008-02-19 18:39:18Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/links/links.class.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  require_once ($AppUI->getSystemClass('w2p'));
   7  require_once ($AppUI->getModuleClass('tasks'));
   8  require_once ($AppUI->getModuleClass('projects'));
   9  require_once ($AppUI->getModuleClass('companies'));
  10  require_once ($AppUI->getModuleClass('admin'));
  11  /**
  12   * Link Class
  13   */
  14  class CNote extends CW2pObject {
  15  
  16  
  17      var $note_id = null;
  18      var $note_parent = null;
  19      var $note_company = null;
  20      var $note_department = null;
  21      var $note_project = null;
  22      var $note_task = null;
  23      var $note_file = null;
  24      var $note_module = null;
  25      var $note_module_name = null;
  26      var $note_record_id = null;
  27      var $note_category = null;
  28      var $note_status = null;
  29      var $note_title = null;
  30      var $note_body = null;
  31      var $note_creator = null;
  32      var $note_created = null;
  33      var $note_modified = null;
  34      var $note_modified_by = null;
  35      var $note_private = null;
  36      var $note_doc_url = null;
  37  
  38  	function CNote() {
  39          $this->CW2pObject('notes', 'note_id');
  40      }
  41  
  42  	function check() {
  43          // ensure the integrity of some variables
  44          $this->note_id = intval($this->note_id);
  45          $this->note_parent = intval($this->note_parent);
  46          $this->note_category = intval($this->note_category);
  47          $this->note_task = intval($this->note_task);
  48          $this->note_project = intval($this->note_project);
  49          $this->note_company = intval($this->note_company);
  50          $this->note_creator = intval($this->note_creator);
  51          $this->note_modified_by = intval($this->note_modified_by);
  52          $this->note_file = intval($this->note_file);
  53          $this->note_record_id = intval($this->note_record_id);
  54          $this->note_module = intval($this->note_module);
  55          $this->note_private = intval($this->note_private);
  56  
  57          return null; // object is ok
  58      }
  59  
  60  	function delete() {
  61          global $w2Pconfig;
  62          $this->_message = "deleted";
  63  
  64          // delete the main table reference
  65          $q = new DBQuery();
  66          $q->setDelete('notes');
  67          $q->addWhere('note_id = ' . (int)$this->note_id);
  68          if (!$q->exec()) {
  69              return db_error();
  70          }
  71          return null;
  72      }
  73  }
  74  ?>