public function getTaskDepartments(CAppUI $AppUI = null, $taskId) { global $AppUI; if ($AppUI->isActiveModule('departments')) { $q = new w2p_Database_Query(); $q->addTable('departments', 'd'); $q->addTable('task_departments', 't'); $q->addWhere('t.department_id = d.dept_id'); $q->addWhere('t.task_id = ' . (int) $taskId); $q->addQuery('dept_id, dept_name, dept_phone'); $department = new CDepartment(); $department->setAllowedSQL($AppUI->user_id, $q); return $q->loadHashList('dept_id'); } }
public static function getForums(CAppUI $AppUI = null, $projectId) { global $AppUI; if ($AppUI->isActiveModule('forums') && canView('forums')) { $q = new w2p_Database_Query(); $q->addTable('forums'); $q->addQuery('forum_id, forum_project, forum_description, forum_owner, forum_name, forum_message_count, DATE_FORMAT(forum_last_date, "%d-%b-%Y %H:%i" ) forum_last_date, project_name, project_color_identifier, project_id'); $q->addJoin('projects', 'p', 'project_id = forum_project', 'inner'); $q->addWhere('forum_project = ' . (int) $projectId); $q->addOrder('forum_project, forum_name'); return $q->loadHashList('forum_id'); } }
public static function getDepartments(CAppUI $AppUI, $companyId) { $perms = $AppUI->acl(); if ($AppUI->isActiveModule('departments') && canView('departments')) { $q = new w2p_Database_Query(); $q->addTable('departments'); $q->addQuery('departments.*, COUNT(contact_department) dept_users'); $q->addJoin('contacts', 'c', 'c.contact_department = dept_id'); $q->addWhere('dept_company = ' . (int) $companyId); $q->addGroup('dept_id'); $q->addOrder('dept_parent, dept_name'); $department = new CDepartment(); $department->setAllowedSQL($AppUI->user_id, $q); return $q->loadList(); } }
public function getTaskContacts(CAppUI $AppUI = null, $taskId) { global $AppUI; $perms = $AppUI->acl(); if ($AppUI->isActiveModule('contacts') && $perms->checkModule('contacts', 'view')) { $q = new DBQuery(); $q->addTable('contacts', 'c'); $q->addJoin('task_contacts', 'tc', 'tc.contact_id = c.contact_id', 'inner'); $q->leftJoin('departments', 'd', 'dept_id = contact_department'); $q->addWhere('tc.task_id = ' . (int) $taskId); $q->addQuery('c.contact_id, contact_first_name, contact_last_name, contact_email'); $q->addQuery('contact_phone, dept_name'); $q->addWhere('(contact_owner = ' . (int) $AppUI->user_id . ' OR contact_private = 0)'); $department = new CDepartment(); $department->setAllowedSQL($AppUI->user_id, $q); return $q->loadHashList('contact_id'); } }
public static function getContactList(CAppUI $AppUI = null, $deptId) { global $AppUI; if ($AppUI->isActiveModule('contacts') && canView('contacts') && (int) $deptId > 0) { $q = new w2p_Database_Query(); $q->addTable('contacts', 'con'); $q->addQuery('con.contact_id, con.contact_first_name'); $q->addQuery('con.contact_last_name'); $q->addWhere('contact_department = ' . (int) $deptId); $q->addWhere('(contact_owner = ' . (int) $AppUI->user_id . ' OR contact_private = 0)'); $q->addOrder('contact_first_name'); $results = $q->loadHashList('contact_id'); } return $results; }