function delete()
{
global $dPconfig;
$this->_message = "deleted";
addHistory('files', $this->file_id, 'delete', $this->file_name, $this->file_project);
// remove the file from the file system
@unlink("{$dPconfig['root_dir']}/files/{$this->file_project}/{$this->file_real_filename}");
// delete any index entries
$q = new DBQuery();
$q->setDelete('files_index');
$q->addQuery('*');
$q->addWhere("file_id = {$this->file_id}");
if (!$q->exec()) {
$q->clear();
return db_error();
}
// delete the main table reference
$q->clear();
$q->setDelete('files');
$q->addQuery('*');
$q->addWhere("file_id = {$this->file_id}");
if (!$q->exec()) {
$q->clear();
return db_error();
}
$q->clear();
return NULL;
}
/**
* postsave functions are only called after a succesful save. They are
* used to perform database operations after the event.
*/
function resource_postsave()
{
global $other_resources;
global $obj;
$task_id = $obj->task_id;
dprint(__FILE__, __LINE__, 5, "saving resources, {$other_resources}");
if (isset($other_resources)) {
$value = array();
$reslist = explode(';', $other_resources);
foreach ($reslist as $res) {
if ($res) {
list($resource, $perc) = explode('=', $res);
$value[] = array($task_id, $resource, $perc);
}
}
// first delete any elements already there, then replace with this
// list.
$q = new DBQuery();
$q->setDelete('resource_tasks');
$q->addWhere('task_id = ' . $obj->task_id);
$q->exec();
$q->clear();
if (count($value)) {
foreach ($value as $v) {
$q->addTable('resource_tasks');
$q->addInsert('task_id,resource_id,percent_allocated', $v, true);
$q->exec();
$q->clear();
}
}
}
}
public function remove()
{
$q = new DBQuery();
$q->setDelete('modules');
$q->addWhere("mod_directory = 'importers'");
$q->exec();
return true;
}
function remove()
{
$q = new DBQuery();
$q->dropTable('links');
$q->exec();
$q->clear();
$q->setDelete('sysvals');
$q->addWhere('sysval_title = \'LinkType\'');
$q->exec();
}
function testDeleteBD()
{
$q = new DBQuery();
$q->addTable('eap');
$q->setDelete('eap');
$q->addWhere("nome ='Build Teste'");
$q->prepareDelete();
$this->assertEqual($q->exec(), true);
$q->clear();
}
function delete()
{
$q = new DBQuery();
$q->setDelete('risks');
$q->addWhere('risk_id = ' . $this->risk_id);
if (!$q->exec()) {
return db_error();
} else {
return null;
}
}
function delete()
{
global $dPconfig;
$this->_message = "deleted";
// delete the main table reference
$q = new DBQuery();
$q->setDelete('links');
$q->addWhere('link_id = ' . $this->link_id);
if (!$q->exec()) {
return db_error();
}
return NULL;
}
function delete($oid = NULL)
{
$id = $this->user_id;
$result = parent::delete($oid);
if (!$result) {
$acl =& $GLOBALS['AppUI']->acl();
$acl->deleteLogin($id);
$q = new DBQuery();
$q->setDelete('user_preferences');
$q->addWhere('pref_user = ' . $this->user_id);
$q->exec();
$q->clear();
}
return $result;
}
public static function unpinUserTask($userId, $taskId)
{
$q = new DBQuery();
$q->setDelete('user_task_pin');
$q->addWhere('user_id = ' . (int) $userId);
$q->addWhere('task_id = ' . (int) $taskId);
if (!$q->exec()) {
return 'Error unpinning task';
} else {
return true;
}
}
function store()
{
$this->dPTrimAll();
$msg = $this->check();
if ($msg) {
return get_class($this) . '::store-check failed - ' . $msg;
}
if ($this->project_id) {
$ret = db_updateObject('projects', $this, 'project_id', false);
addHistory('projects', $this->project_id, 'update', $this->project_name, $this->project_id);
} else {
$ret = db_insertObject('projects', $this, 'project_id');
addHistory('projects', $this->project_id, 'add', $this->project_name, $this->project_id);
}
//split out related departments and store them seperatly.
$q = new DBQuery();
$q->setDelete('project_departments');
$q->addWhere('project_id=' . $this->project_id);
$q->exec();
$q->clear();
if ($this->project_departments) {
$departments = explode(',', $this->project_departments);
foreach ($departments as $department) {
$q->addTable('project_departments');
$q->addInsert('project_id', $this->project_id);
$q->addInsert('department_id', $department);
$q->exec();
$q->clear();
}
}
//split out related contacts and store them seperatly.
$q->setDelete('project_contacts');
$q->addWhere('project_id=' . $this->project_id);
$q->exec();
$q->clear();
if ($this->project_contacts) {
$contacts = explode(',', $this->project_contacts);
foreach ($contacts as $contact) {
if ($contact) {
$q->addTable('project_contacts');
$q->addInsert('project_id', $this->project_id);
$q->addInsert('contact_id', $contact);
$q->exec();
$q->clear();
}
}
}
return !$ret ? get_class($this) . '::store failed <br />' . db_error() : NULL;
}
public function delete()
{
$q = new DBQuery();
$q->setDelete('forum_visits');
$q->addWhere('visit_message = ' . (int) $this->message_id);
$q->exec();
// No error if this fails, it is not important.
$q->clear();
$q->addTable('forum_messages');
$q->addQuery('message_forum');
$q->addWhere('message_id = ' . (int) $this->message_id);
$forumId = $q->loadResult();
$q->clear();
$q->setDelete('forum_messages');
$q->addWhere('message_id = ' . (int) $this->message_id);
if (!$q->exec()) {
$result = db_error();
} else {
$result = null;
}
$q->clear();
$q->addTable('forum_messages');
$q->addQuery('COUNT(message_id)');
$q->addWhere('message_forum = ' . (int) $forumId);
$messageCount = $q->loadResult();
$q->clear();
$q->addTable('forums');
$q->addUpdate('forum_message_count', $messageCount);
$q->addWhere('forum_id = ' . (int) $forumId);
$q->exec();
$q->clear();
return $result;
}
/**
* Default delete method
*
* Can be overloaded/supplemented by the child class
* @return null|string null if successful otherwise returns and error message
*/
function delete($oid = null, $history_desc = '', $history_proj = 0)
{
$k = $this->_tbl_key;
if ($oid) {
$this->{$k} = intval($oid);
}
if (!$this->canDelete($msg)) {
return $msg;
}
$q = new DBQuery();
$q->setDelete($this->_tbl);
$q->addWhere($this->_tbl_key . " = '" . $this->{$k} . "'");
$result = !$q->exec() ? db_error() : null;
if (!$result) {
// only record history if deletion actually occurred
addHistory($this->_tbl, $this->{$k}, 'delete', $history_desc, $history_proj);
}
$q->clear();
return $result;
}
$cols = 13;
/****
// Let's figure out which tasks are selected
*/
$q = new DBQuery();
$pinned_only = intval(w2PgetParam($_GET, 'pinned', 0));
if (isset($_GET['pin'])) {
$pin = intval(w2PgetParam($_GET, 'pin', 0));
$msg = '';
// load the record data
if ($pin) {
$q->addTable('user_task_pin');
$q->addInsert('user_id', $AppUI->user_id);
$q->addInsert('task_id', $task_id);
} else {
$q->setDelete('user_task_pin');
$q->addWhere('user_id = ' . (int) $AppUI->user_id);
$q->addWhere('task_id = ' . (int) $task_id);
}
if (!$q->exec()) {
$AppUI->setMsg('ins/del err', UI_MSG_ERROR, true);
} else {
$q->clear();
}
$AppUI->redirect('', -1);
}
$AppUI->savePlace();
$durnTypes = w2PgetSysVal('TaskDurationType');
$taskPriority = w2PgetSysVal('TaskPriority');
$task_project = $project_id;
$task_sort_item1 = w2PgetParam($_GET, 'task_sort_item1', '');
function updateAssigned($assigned)
{
// First remove the assigned from the user_events table
global $AppUI;
$q = new DBQuery();
$q->setDelete('user_events');
$q->addWhere('event_id = ' . $this->event_id);
$q->exec();
$q->clear();
if (is_array($assigned) && count($assigned)) {
foreach ($assigned as $uid) {
if ($uid) {
$q->addTable('user_events', 'ue');
$q->addInsert('event_id', $this->event_id);
$q->addInsert('user_id', $uid);
$q->exec();
$q->clear();
}
}
if ($msg = db_error()) {
$AppUI->setMsg($msg, UI_MSG_ERROR);
}
}
}
function delete()
{
$q = new DBQuery();
$q->setDelete('custom_fields_lists');
$q->addWhere("field_id = {$this->field_id}");
$q->exec();
$q->clear();
}
function delete()
{
$q = new DBQuery();
$q->addTable('departments', 'dep');
$q->addQuery('dep.*');
$q->addWhere('dep.dept_parent = ' . $this->dept_id);
$res = $q->exec();
if (db_num_rows($res)) {
$q->clear();
return "deptWithSub";
}
$q->clear();
$q->addTable('projects', 'p');
$q->addQuery('p.*');
$q->addWhere('p.project_department = ' . $this->dept_id);
$res = $q->exec();
if (db_num_rows($res)) {
$q->clear();
return "deptWithProject";
}
// $sql = "DELETE FROM departments WHERE dept_id = $this->dept_id";
$q->clear();
$q->addQuery('*');
$q->setDelete('departments');
$q->addWhere('dept_id = ' . $this->dept_id);
if (!$q->exec()) {
$result = db_error();
} else {
$result = NULL;
}
$q->clear();
return $result;
}
function commit_updates()
{
$q = new DBQuery();
if (count($this->delete_list)) {
$q->setDelete($this->table);
$q->addWhere("queue_id in (" . implode(',', $this->delete_list) . ")");
$q->exec();
$q->clear();
}
$this->delete_list = array();
foreach ($this->update_list as $fields) {
$q->addTable($this->table);
$q->addUpdate('queue_repeat_count', $fields['queue_repeat_count']);
$q->addUpdate('queue_start', $fields['queue_start']);
$q->addWhere('queue_id = ' . $fields['queue_id']);
$q->exec();
$q->clear();
}
$this->update_list = array();
}
protected function commit_updates($batched = false)
{
$q = new DBQuery();
if (count($this->delete_list)) {
$q->setDelete($this->table);
$q->addWhere("queue_id in (" . implode(',', $this->delete_list) . ")");
$q->exec();
$q->clear();
}
$this->delete_list = array();
foreach ($this->update_list as $fields) {
$q->addTable($this->table);
$q->addUpdate('queue_repeat_count', $fields['queue_repeat_count']);
$q->addUpdate('queue_start', $fields['queue_start']);
$q->addWhere('queue_id = ' . $fields['queue_id']);
$q->exec();
$q->clear();
}
$this->update_list = array();
/**
* Finally notify the batch handlers that the batch has been terminated.
* This is done by calling the method EventQueue_<method_name>_batchTerminate.
* Note that at this stage we will have all of the classes loaded, as we will
* have executed the class methods to handle the batch requests.
*/
if ($batched) {
foreach ($this->batch_list as $batcher) {
$method = 'EventQueue_' . $batcher['method'] . '_terminateBatch';
if (method_exists($batcher['class'], $method)) {
$batcher['object']->{$method}();
}
}
}
$this->batch_list = array();
}
function delete()
{
$q = new DBQuery();
$q->setDelete('forum_visits');
$q->addWhere('visit_message = ' . $this->message_id);
$q->exec();
// No error if this fails, it is not important.
$q->clear();
$q->setDelete('forum_messages');
$q->addWhere('message_id = ' . $this->message_id);
if (!$q->exec()) {
$result = db_error();
} else {
$result = NULL;
}
$q->clear();
return $result;
}
function dPsessionGC($maxlifetime)
{
global $dPconfig;
global $AppUI;
dprint(__FILE__, __LINE__, 11, "Session Garbage collection running");
$now = time();
$max = dPsessionConvertTime('max_lifetime');
$idle = dPsessionConvertTime('idle_time');
// Find all the session
$q = new DBQuery();
$q->setDelete('sessions');
$q->addWhere("UNIX_TIMESTAMP() - UNIX_TIMESTAMP(session_updated) > {$idle} OR UNIX_TIMESTAMP() - UNIX_TIMESTAMP(session_created) > {$max}");
$q->exec();
$q->clear();
if (isset($dPconfig['session_gc_scan_queue']) && $dPconfig['session_gc_scan_queue']) {
// We need to scan the event queue. If $AppUI isn't created yet
// And it isn't likely that it will be, we create it and run the
// queue scanner.
if (!isset($AppUI)) {
$AppUI = new CAppUI();
$queue = new EventQueue();
$queue->scan();
}
}
return true;
}
function dPsessionGC($maxlifetime)
{
global $AppUI;
dprint(__FILE__, __LINE__, 11, 'Session Garbage collection running');
$now = time();
$max = dPsessionConvertTime('max_lifetime');
$idle = dPsessionConvertTime('idle_time');
// First pass is to kill any users that are logged in at the time of the session.
$where = 'UNIX_TIMESTAMP() - UNIX_TIMESTAMP(session_updated) > ' . $idle . ' OR UNIX_TIMESTAMP() - UNIX_TIMESTAMP(session_created) > ' . $max;
$q = new DBQuery();
$q->addTable('sessions');
$q->addQuery('session_user');
$q->addWhere($where);
$sql2 = $q->prepare(true);
$q->addTable('user_access_log');
$q->addUpdate('date_time_out', date('Y-m-d H:i:s'));
$q->addWhere('user_access_log_id IN (' . $sql2 . ')');
$q->exec();
$q->clear();
// Now we simply delete the expired sessions.
$q->setDelete('sessions');
$q->addWhere($where);
$q->exec();
$q->clear();
if (dPgetConfig('session_gc_scan_queue')) {
// We need to scan the event queue. If $AppUI isn't created yet
// And it isn't likely that it will be, we create it and run the
// queue scanner.
if (!isset($AppUI)) {
$AppUI = new CAppUI();
$queue = new EventQueue();
$queue->scan();
}
}
return true;
}
} else {
$upd_task->task_parent = $bulk_task_parent;
$upd_task->store();
}
}
}
//Action: Change dependency
if (isset($_POST['bulk_task_dependency']) && $bulk_task_dependency != '') {
if ($upd_task->task_id) {
//If parent is self task
//print_r($bulk_task_dependency);die;
if ($bulk_task_dependency == '0') {
$upd_task->task_dynamic = 0;
$upd_task->store();
$q = new DBQuery();
$q->setDelete('task_dependencies');
$q->addWhere('dependencies_task_id=' . $upd_task->task_id);
$q->exec();
} elseif (!($bulk_task_dependency == $upd_task->task_id)) {
$upd_task->task_dynamic = 31;
$upd_task->store();
$q = new DBQuery();
$q->addTable('task_dependencies');
$q->addReplace('dependencies_task_id', $upd_task->task_id);
$q->addReplace('dependencies_req_task_id', $bulk_task_dependency);
$q->exec();
//Lets recalc the dependency
$dep_task = new CTask();
$dep_task->load($bulk_task_dependency);
if ($dep_task->task_id) {
$dep_task->shiftDependentTasks();
public function delete($oid = null)
{
global $AppUI;
$k = $this->_tbl_key;
if ($oid) {
$this->{$k} = intval($oid);
}
if (!$this->canDelete($msg, $oid ? $oid : $this->file_folder_id)) {
return $msg;
}
$this->{$k} = $this->{$k} ? $this->{$k} : intval($oid ? $oid : $this->file_folder_id);
$q = new DBQuery();
$q->setDelete($this->_tbl);
$q->addWhere($this->_tbl_key . ' = ' . $this->{$k});
if (!$q->exec()) {
$q->clear();
return db_error();
} else {
$q->clear();
return null;
}
}
/**
* Default delete method
*
* Can be overloaded/supplemented by the child class
* @return null|string null if successful otherwise returns and error message
*/
public function delete($oid = null)
{
$k = $this->_tbl_key;
if ($oid) {
$this->{$k} = intval($oid);
}
if (!$this->canDelete($msg)) {
return $msg;
}
$q = new DBQuery();
$q->setDelete($this->_tbl);
$q->addWhere($this->_tbl_key . ' = \'' . $this->{$k} . '\'');
$result = !$q->exec() ? db_error() : null;
if (!$result) {
// only record history if deletion actually occurred
addHistory($this->_tbl, $this->{$k}, 'delete');
}
$q->clear();
return $result;
}
function updateAssigned($cslist, $perc_assign, $del = true, $rmUsers = false)
{
$q = new DBQuery();
// process assignees
$tarr = explode(',', $cslist);
// delete all current entries from $cslist
if ($del == true && $rmUsers == true) {
foreach ($tarr as $user_id) {
$user_id = (int) $user_id;
if (!empty($user_id)) {
$this->removeAssigned($user_id);
}
}
return false;
} else {
if ($del == true) {
// delete all users assigned to this task (to properly update)
$q->setDelete('user_tasks');
$q->addWhere('task_id = ' . $this->task_id);
$q->exec();
$q->clear();
}
}
// get Allocation info in order to check if overAssignment occurs
$alloc = $this->getAllocation('user_id');
$overAssignment = false;
foreach ($tarr as $user_id) {
if (intval($user_id) > 0) {
$perc = $perc_assign[$user_id];
/*
if (dPgetConfig('check_overallocation')
&& $perc > $alloc[$user_id]['freeCapacity']) {
// add Username of the overAssigned User
$overAssignment .= ' ' . $alloc[$user_id]['userFC'];
}
else {
*/
$q->addTable('user_tasks');
$q->addReplace('user_id', $user_id);
$q->addReplace('task_id', $this->task_id);
$q->addReplace('perc_assignment', $perc);
$q->exec();
$q->clear();
// }
}
}
return $overAssignment;
}
$task_sort_order2 = intval(dPgetParam($_GET, 'task_sort_order2', 0));
// if task priority set and items selected, do some work
$task_priority = dPgetParam($_POST, 'task_priority', 99);
$selected = dPgetParam($_POST, 'selected_task', 0);
$q = new DBQuery();
if (is_array($selected) && count($selected)) {
foreach ($selected as $key => $val) {
if ($task_priority == 'c') {
// mark task as completed
$q->addTable('tasks');
$q->addUpdate('task_percent_complete', "'100'");
$q->addWhere('task_id=' . $val);
} else {
if ($task_priority == 'd') {
// delete task
$q->setDelete('tasks');
$q->addWhere('task_id=' . $val);
} else {
if ($task_priority > -2 && $task_priority < 2) {
// set priority
$q->addTable('tasks');
$q->addUpdate('task_priority', $task_priority);
$q->addWhere('task_id=' . $val);
}
}
}
db_exec($q->prepare(true));
echo db_error();
}
}
$AppUI->savePlace();
if (isset($_POST['forcewatch']) && isset($_POST['forcesubmit'])) {
// insert row into forum_watch for forcing Watch
$q->addTable('forum_watch');
$q->addInsert('watch_user', 0);
$q->addInsert('watch_forum', 0);
$q->addInsert('watch_topic', 0);
if (!$q->exec()) {
$AppUI->setMsg(db_error(), UI_MSG_ERROR);
} else {
$AppUI->setMsg("Watch Forced", UI_MSG_OK);
}
$q->clear();
$AppUI->redirect('m=forums&a=configure');
} elseif (isset($_POST['forcesubmit']) && !isset($_POST['forcewatch'])) {
// delete row from forum_watch for unorcing Watch
$q->setDelete('forum_watch');
$q->addWhere('watch_user = 0');
$q->addWhere('watch_forum = 0');
$q->addWhere('watch_topic = 0');
if (!$q->exec()) {
$AppUI->setMsg(db_error(), UI_MSG_ERROR);
} else {
$AppUI->setMsg("Watch Unforced", UI_MSG_OK);
}
$q->clear();
$AppUI->redirect('m=forums&a=configure');
}
// SQL-Query to check if the message should be delivered to all users (forced) (checkbox)
$q->addTable('forum_watch');
$q->addQuery('*');
$q->addWhere('watch_user = 0');
public function unregisterModule($module_value)
{
if ($module_value != '') {
$q = new DBQuery();
$q->setDelete('gacl_axo');
$q->addWhere("value = '{$module_value}'");
$q->exec();
}
}
$q->addInsert('history_action', "add");
$q->addInsert('history_date', str_replace("'", '', $db->DBTimeStamp(time())));
$q->addInsert('history_description', $history_description);
$q->addInsert('history_user', $userid);
$q->addInsert('history_project', $history_project);
$okMsg = 'History added';
} else {
if ($action == 'update') {
$q->addTable('history');
$q->addUpdate('history_description', $history_description);
$q->addUpdate('history_project', $history_project);
$q->addWhere('history_id =' . $history_id);
$okMsg = 'History updated';
} else {
if ($action == 'del') {
$q->setDelete('history');
$q->addWhere('history_id =' . $history_id);
$okMsg = 'History deleted';
}
}
}
if (!$q->exec()) {
$AppUI->setMsg(db_error());
} else {
$AppUI->setMsg($okMsg);
if ($action == 'add') {
$q->clear();
}
$q->addTable('history');
$q->addUpdate('history_item = history_id');
$q->addWhere('history_table = \'history\'');
function deleteModuleItems($mod)
{
//Declaring the return string
$ret = null;
$q = new DBQuery();
//Fetching module-associated ACL ID's
$q->addTable('gacl_axo_map');
$q->addQuery('acl_id');
$q->addWhere("value = '" . $mod . "'");
$acls = $q->loadHashList('acl_id');
$q->clear();
$tables = array('gacl_aco_map' => 'acl_id', 'gacl_aro_map' => 'acl_id', 'gacl_acl' => 'id');
foreach ($acls as $acl => $k) {
//Deleting gacl_aco_map, gacl_aro_map, and gacl_aco_map entries
foreach ($tables as $acl_table => $acl_tab_key) {
$q->setDelete($acl_table);
$q->addWhere($acl_tab_key . ' = ' . $acl);
if (!$q->exec()) {
$ret .= (is_null($ret) ? "\n\t" : '') . db_error();
}
$q->clear();
}
}
//Returning null (no error) or database error message (error)
return $ret;
}