function store() { global $helpdesk_available; if ($helpdesk_available && $this->file_helpdesk_item != 0) { $this->addHelpDeskTaskLog(); } parent::store(); }
function load($oid = null, $strip = false, $skipUpdate = false) { // use parent function to load the given object $loaded = parent::load($oid, $strip); /* ** Update the values of a dynamic task from ** the children's properties each time the ** dynamic task is loaded. ** Additionally store the values in the db. ** Only treat umbrella tasks of dynamics '1'. */ if ($this->task_dynamic == 1 && !$skipUpdate) { // update task from children $this->htmlDecode(); $this->updateDynamics(true); /* ** Use parent function to store the updated values in the db ** instead of store function of this object in order to ** prevent from infinite loops. */ parent::store(); $loaded = parent::load($oid, $strip); } // return whether the object load process has been successful or not return $loaded; }
function store() { $msg = $this->check(); return $msg ? $msg : parent::store(); }
function store() { global $AppUI; // Update the last modified time and user $this->item_modified = db_unix2dateTime(time()); $this->item_summary = strip_tags($this->item_summary); //if type indicates a contact or a user, then look up that phone and email //for those entries switch ($this->item_requestor_type) { case '0': //it's not a user or a contact break; case '1': //it's a system user $sql = "SELECT user_id as id,\n contact_email as email,\n contact_phone as phone,\n CONCAT(contact_first_name,' ', contact_last_name) as name\n FROM users\n LEFT JOIN contacts ON user_contact = contact_id\n WHERE user_id='{$this->item_requestor_id}'"; break; case '2': $sql = "SELECT contact_id as id,\n contact_email as email,\n contact_phone as phone,\n CONCAT(contact_first_name,' ', contact_last_name) as name\n FROM contacts\n WHERE contact_id='{$this->item_requestor_id}'"; break; default: break; } if (isset($sql)) { db_loadHash($sql, $result); $this->item_requestor_email = $result['email']; $this->item_requestor_phone = $result['phone']; $this->item_requestor = $result['name']; } /* if the store is successful, pull the new id value and insert it into the object. */ if ($msg = parent::store()) { return $msg; } else { if (!$this->item_id) { $this->item_id = mysql_insert_id(); } return $msg; } }
function store() { global $AppUI; // Update the last modified time and user //$this->item_created = new CDate(); $this->item_summary = strip_tags($this->item_summary); //if type indicates a contact or a user, then look up that phone and email //for those entries switch ($this->item_requestor_type) { case '0': //it's not a user or a contact break; case '1': //it's a system user $q = new DBQuery(); $q->addTable('users', 'u'); $q->addQuery('u.user_id as id'); $q->addJoin('contacts', 'c', 'u.user_contact = c.contact_id'); $q->addQuery("c.contact_email as email, c.contact_phone as phone, CONCAT(c.contact_first_name,' ', c.contact_last_name) as name"); /* $sql = "SELECT user_id as id, contact_email as email, contact_phone as phone, CONCAT(contact_first_name,' ', contact_last_name) as name FROM users LEFT JOIN contacts ON user_contact = contact_id WHERE user_id='{$this->item_requestor_id}'";*/ break; case '2': $q = new DBQuery(); $q->addTable('contacts', 'c'); $q->addQuery("c.contact_email as email, c.contact_phone as phone, CONCAT(c.contact_first_name,' ', c.contact_last_name) as name"); $q->addWhere('contact_id=' . $this->item_requestor_id); /* $sql = "SELECT contact_id as id, contact_email as email, contact_phone as phone, CONCAT(contact_first_name,' ', contact_last_name) as name FROM contacts WHERE contact_id='{$this->item_requestor_id}'";*/ break; default: break; } if (isset($q)) { $result = $q->loadHash(); $q->clear(); $this->item_requestor_email = $result['email']; $this->item_requestor_phone = $result['phone']; $this->item_requestor = $result['name']; } /* if the store is successful, pull the new id value and insert it into the object. */ if ($msg = parent::store()) { return $msg; } else { if (!$this->item_id) { $this->item_id = mysql_insert_id(); } return $msg; } }