/**
*
*
*/
public function activity_feed()
{
ajx_set_no_back(true);
require_javascript("og/modules/dashboardComments.js");
require_javascript("jquery/jquery.scrollTo-min.js");
$filesPerPage = config_option('files_per_page');
$start = array_var($_GET, 'start') ? (int) array_var($_GET, 'start') : 0;
$limit = array_var($_GET, 'limit') ? array_var($_GET, 'limit') : $filesPerPage;
$order = array_var($_GET, 'sort');
$orderdir = array_var($_GET, 'dir');
$page = (int) ($start / $limit) + 1;
$extra_conditions = " AND jt.type IN ('content_object', 'comment')";
$trashed = array_var($_GET, 'trashed', false);
$archived = array_var($_GET, 'archived', false);
$pagination = ContentDataObjects::listing(array("start" => $start, "limit" => $limit, "order" => $order, "order_dir" => $orderdir, "trashed" => $trashed, "archived" => $archived, "count_results" => false, "extra_conditions" => $extra_conditions, "join_params" => array("jt_field" => "id", "e_field" => "object_type_id", "table" => TABLE_PREFIX . "object_types")));
$result = $pagination->objects;
$total_items = $pagination->total;
if (!$result) {
$result = array();
}
$info = array();
foreach ($result as $obj) {
$info_elem = $obj->getArrayInfo($trashed, $archived);
$instance = Objects::instance()->findObject($info_elem['object_id']);
$info_elem['url'] = $instance->getViewUrl();
if (method_exists($instance, "getText")) {
$info_elem['content'] = $instance->getText();
}
$info_elem['picture'] = $instance->getCreatedBy()->getPictureUrl();
$info_elem['friendly_date'] = friendly_date($instance->getCreatedOn());
$info_elem['comment'] = $instance->getComments();
if ($instance instanceof Contact) {
if ($instance->isCompany()) {
$info_elem['icon'] = 'ico-company';
$info_elem['type'] = 'company';
}
}
$info_elem['isRead'] = $instance->getIsRead(logged_user()->getId());
$info_elem['manager'] = get_class($instance->manager());
$info[] = $info_elem;
}
$listing = array("totalCount" => $total_items, "start" => $start, "objects" => $info);
tpl_assign("feeds", $listing);
}
function list_objects()
{
//alert("debugging. remove this line");ajx_current('empty'); return array() ; //TODO remove this line
/* get query parameters */
$filesPerPage = config_option('files_per_page');
$start = array_var($_GET, 'start') ? (int) array_var($_GET, 'start') : 0;
$limit = array_var($_GET, 'limit') ? array_var($_GET, 'limit') : $filesPerPage;
$order = array_var($_GET, 'sort');
$ignore_context = (bool) array_var($_GET, 'ignore_context');
if ($order == "dateUpdated") {
$order = "updated_on";
} elseif ($order == "dateArchived") {
$order = "archived_on";
} elseif ($order == "dateDeleted") {
$order = "trashed_on";
}
$orderdir = array_var($_GET, 'dir');
$page = (int) ($start / $limit) + 1;
$hide_private = !logged_user()->isMemberOfOwnerCompany();
$typeCSV = array_var($_GET, 'type');
$types = null;
if ($typeCSV) {
$types = explode(",", $typeCSV);
}
$name_filter = mysql_escape_string(array_var($_GET, 'name'));
$linked_obj_filter = array_var($_GET, 'linkedobject');
$object_ids_filter = '';
if (!is_null($linked_obj_filter)) {
$linkedObject = Objects::findObject($linked_obj_filter);
$objs = $linkedObject->getLinkedObjects();
foreach ($objs as $obj) {
$object_ids_filter .= ($object_ids_filter == '' ? '' : ',') . $obj->getId();
}
}
$filters = array();
if (!is_null($types)) {
$filters['types'] = $types;
}
if (!is_null($name_filter)) {
$filters['name'] = $name_filter;
}
if ($object_ids_filter != '') {
$filters['object_ids'] = $object_ids_filter;
}
$user = array_var($_GET, 'user');
$trashed = array_var($_GET, 'trashed', false);
$archived = array_var($_GET, 'archived', false);
/* if there's an action to execute, do so */
if (array_var($_GET, 'action') == 'delete') {
$ids = explode(',', array_var($_GET, 'objects'));
$result = ContentDataObjects::listing(array("extra_conditions" => " AND o.id IN (" . implode(",", $ids) . ") ", "include_deleted" => true));
$objects = $result->objects;
list($succ, $err) = $this->do_delete_objects($objects);
if ($err > 0) {
flash_error(lang('error delete objects', $err));
} else {
Hook::fire('after_object_delete_permanently', $ids, $ignored);
flash_success(lang('success delete objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'delete_permanently') {
$ids = explode(',', array_var($_GET, 'objects'));
//$result = Objects::getObjectsFromContext(active_context(), null, null, true, false, array('object_ids' => implode(",",$ids)));
$objects = Objects::instance()->findAll(array("conditions" => "id IN (" . implode(",", $ids) . ")"));
list($succ, $err) = $this->do_delete_objects($objects, true);
if ($err > 0) {
flash_error(lang('error delete objects', $err));
}
if ($succ > 0) {
Hook::fire('after_object_delete_permanently', $ids, $ignored);
flash_success(lang('success delete objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'markasread') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_mark_as_read_unread_objects($ids, true);
} else {
if (array_var($_GET, 'action') == 'markasunread') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_mark_as_read_unread_objects($ids, false);
} else {
if (array_var($_GET, 'action') == 'empty_trash_can') {
$result = Objects::getObjectsFromContext(active_context(), 'trashed_on', 'desc', true);
$objects = $result->objects;
list($succ, $err) = $this->do_delete_objects($objects, true);
if ($err > 0) {
flash_error(lang('error delete objects', $err));
}
if ($succ > 0) {
flash_success(lang('success delete objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'archive') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_archive_unarchive_objects($ids, 'archive');
if ($err > 0) {
flash_error(lang('error archive objects', $err));
} else {
flash_success(lang('success archive objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'unarchive') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_archive_unarchive_objects($ids, 'unarchive');
if ($err > 0) {
flash_error(lang('error unarchive objects', $err));
} else {
flash_success(lang('success unarchive objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'unclassify') {
$ids = explode(',', array_var($_GET, 'objects'));
$err = 0;
$succ = 0;
foreach ($ids as $id) {
$split = explode(":", $id);
$type = $split[0];
if (Plugins::instance()->isActivePlugin('mail') && $type == 'MailContents') {
$email = MailContents::findById($split[1]);
if (isset($email) && !$email->isDeleted() && $email->canEdit(logged_user())) {
if (MailController::do_unclassify($email)) {
$succ++;
} else {
$err++;
}
} else {
$err++;
}
}
}
if ($err > 0) {
flash_error(lang('error unclassify emails', $err));
} else {
flash_success(lang('success unclassify emails', $succ));
}
} else {
if (array_var($_GET, 'action') == 'restore') {
$errorMessage = null;
$ids = explode(',', array_var($_GET, 'objects'));
$success = 0;
$error = 0;
foreach ($ids as $id) {
$obj = Objects::findObject($id);
if ($obj->canDelete(logged_user())) {
try {
$obj->untrash($errorMessage);
if ($obj->getObjectTypeId() == 11) {
$event = ProjectEvents::findById($obj->getId());
if ($event->getExtCalId() != "") {
$this->created_event_google_calendar($obj, $event);
}
}
ApplicationLogs::createLog($obj, ApplicationLogs::ACTION_UNTRASH);
$success++;
} catch (Exception $e) {
$error++;
}
} else {
$error++;
}
}
if ($success > 0) {
flash_success(lang("success untrash objects", $success));
}
if ($error > 0) {
$errorString = is_null($errorMessage) ? lang("error untrash objects", $error) : $errorMessage;
flash_error($errorString);
}
}
}
}
}
}
}
}
}
}
$filterName = array_var($_GET, 'name');
$result = null;
$context = active_context();
$obj_type_types = array('content_object', 'dimension_object');
if (array_var($_GET, 'include_comments')) {
$obj_type_types[] = 'comment';
}
$type_condition = "";
if ($types) {
$type_condition = " AND name IN ('" . implode("','", $types) . "')";
}
$res = DB::executeAll("SELECT id from " . TABLE_PREFIX . "object_types WHERE type IN ('" . implode("','", $obj_type_types) . "') AND name <> 'file revision' {$type_condition} ");
$type_ids = array();
foreach ($res as $row) {
if (ObjectTypes::isListableObjectType($row['id'])) {
$types_ids[] = $row['id'];
}
}
//Hook::fire('list_objects_type_ids', null, $types_ids);
$type_ids_csv = implode(',', $types_ids);
$extra_conditions = array();
$extra_conditions[] = "object_type_id in ({$type_ids_csv})";
if ($name_filter) {
$extra_conditions[] = "name LIKE '%{$name_filter}%'";
}
//$pagination = Objects::getObjects($context,$start,$limit,$order,$orderdir,$trashed,$archived, $filters,$start, $limit, $obj_type_types);
$pagination = ContentDataObjects::listing(array("start" => $start, "limit" => $limit, "order" => $order, "order_dir" => $orderdir, "trashed" => $trashed, "archived" => $archived, "types" => $types, "count_results" => false, "extra_conditions" => " AND " . implode(" AND ", $extra_conditions), "ignore_context" => $ignore_context));
$result = $pagination->objects;
$total_items = $pagination->total;
if (!$result) {
$result = array();
}
/* prepare response object */
$info = array();
foreach ($result as $obj) {
$info_elem = $obj->getArrayInfo($trashed, $archived);
$instance = Objects::instance()->findObject($info_elem['object_id']);
$info_elem['url'] = $instance->getViewUrl();
/* @var $instance Contact */
if ($instance instanceof Contact) {
if ($instance->isCompany()) {
$info_elem['icon'] = 'ico-company';
$info_elem['type'] = 'company';
}
} else {
if ($instance instanceof ProjectFile) {
$info_elem['mimeType'] = $instance->getTypeString();
}
}
$info_elem['isRead'] = $instance->getIsRead(logged_user()->getId());
$info_elem['manager'] = get_class($instance->manager());
$info_elem['memPath'] = json_encode($instance->getMembersToDisplayPath());
$info[] = $info_elem;
}
$listing = array("totalCount" => $total_items, "start" => $start, "objects" => $info);
ajx_extra_data($listing);
tpl_assign("listing", $listing);
if (isset($reload) && $reload) {
ajx_current("reload");
} else {
ajx_current("empty");
}
}
function general_search()
{
// Init vars
$search_dimension = array_var($_GET, 'search_dimension');
$filteredResults = 0;
$uid = logged_user()->getId();
if (!isset($search_dimension)) {
$members = active_context_members(false);
} else {
if ($search_dimension == 0) {
$members = array();
} else {
$members = array($search_dimension);
}
}
// click on search everywhere
if (array_var($_REQUEST, 'search_all_projects')) {
$members = array();
}
$revisionObjectTypeId = ObjectTypes::findByName("file revision")->getId();
$members_sql = "";
if (count($members) > 0) {
$context_condition = "(EXISTS\r\n\t\t\t\t\t\t\t\t\t\t(SELECT om.object_id\r\n\t\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_PREFIX . "object_members om\r\n\t\t\t\t\t\t\t\t\t\t\tWHERE\tom.member_id IN (" . implode(',', $members) . ") AND so.rel_object_id = om.object_id\r\n\t\t\t\t\t\t\t\t\t\t\tGROUP BY object_id\r\n\t\t\t\t\t\t\t\t\t\t\tHAVING count(member_id) = " . count($members) . "\r\n\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t)";
$context_condition_rev = "(EXISTS\r\n\t\t\t\t\t\t\t\t\t\t(SELECT fr.object_id FROM " . TABLE_PREFIX . "object_members om\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . TABLE_PREFIX . "project_file_revisions fr ON om.object_id=fr.file_id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN " . TABLE_PREFIX . "objects ob ON fr.object_id=ob.id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE fr.file_id = so.rel_object_id AND ob.object_type_id = {$revisionObjectTypeId} AND member_id IN (" . implode(',', $members) . ")\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY object_id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tHAVING count(member_id) = " . count($members) . "\r\n\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t)";
$members_sql = "AND ( " . $context_condition . " OR " . $context_condition_rev . ")";
$this->search_dimension = implode(',', $members);
} else {
$this->search_dimension = 0;
}
$listableObjectTypeIds = implode(",", ObjectTypes::getListableObjectTypeIds());
$can_see_all_tasks_cond = "";
if (!SystemPermissions::userHasSystemPermission(logged_user(), 'can_see_assigned_to_other_tasks')) {
$can_see_all_tasks_cond = " AND IF((SELECT ot.name FROM " . TABLE_PREFIX . "object_types ot WHERE ot.id=o.object_type_id)='task',\r\n\t\t\t (SELECT t.assigned_to_contact_id FROM " . TABLE_PREFIX . "project_tasks t WHERE t.object_id=o.id) = " . logged_user()->getId() . ",\r\n\t\t\t true)";
}
$search_string = trim(array_var($_REQUEST, 'query', ''));
$search_string = mysql_real_escape_string($search_string, DB::connection()->getLink());
$start = array_var($_REQUEST, 'start', 0);
$orig_limit = array_var($_REQUEST, 'limit');
$limit = $orig_limit + 1;
$useLike = false;
if (user_config_option("search_engine") == 'like') {
$useLike = true;
}
if (strlen($search_string) < 4) {
$useLike = true;
}
if (strlen($search_string) > 0) {
$this->search_for = $search_string;
$logged_user_pgs = implode(',', logged_user()->getPermissionGroupIds());
$sql = "\r\n\t\t\tSELECT DISTINCT so.rel_object_id AS id, so.content AS text_match, so.column_name AS field_match\r\n\t\t\tFROM " . TABLE_PREFIX . "searchable_objects so\r\n\t\t\tWHERE " . ($useLike ? " so.content LIKE '%{$search_string}%' " : " MATCH (so.content) AGAINST ('\"{$search_string}\"' IN BOOLEAN MODE) ") . "\r\n\t\t\tAND (EXISTS\r\n\t\t\t\t(SELECT o.id\r\n\t\t\t\t FROM " . TABLE_PREFIX . "objects o\r\n\t\t\t\t\t\t\t WHERE\to.id = so.rel_object_id AND (\r\n\t\t\t\t\t\t\t (o.object_type_id = {$revisionObjectTypeId} AND\r\n\t\t\t\t\t\t\t EXISTS (\r\n\t\t\t\t\t\t\t SELECT group_id FROM " . TABLE_PREFIX . "sharing_table WHERE object_id = ( SELECT file_id FROM " . TABLE_PREFIX . "project_file_revisions WHERE object_id = o.id )\r\n\t\t\t\t\t\t\t\t\tAND group_id IN ({$logged_user_pgs})\r\n\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\tOR (\r\n\t\t\t\t\t\t\t\t\t\t\t\t(EXISTS\r\n\t\t\t\t\t\t\t\t\t\t\t\t(SELECT object_id\r\n\t\t\t\t\t\t\t\t\t\t\t\tFROM " . TABLE_PREFIX . "sharing_table sh\r\n\t\t\t\t\t\t\t\t\t\tWHERE o.id = sh.object_id\r\n\t\t\t\t\t\t\t\t\t\tAND sh.group_id IN (\r\n\t\t\t\t\t\t\t\t\t\t\t{$logged_user_pgs}\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t) AND o.object_type_id IN ({$listableObjectTypeIds}) " . $members_sql . $can_see_all_tasks_cond . "\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\tGROUP BY(id)\t\r\n\t\t\t\t\t\tORDER BY(id) DESC\t\t\t\t\t\t\t\r\n\t\t\t\t\t\tLIMIT {$start}, {$limit}";
$rows = DB::executeAll($sql);
if (!is_array($rows)) {
$rows = array();
}
// show more
$show_more = false;
if (count($rows) > $orig_limit) {
array_pop($rows);
$show_more = true;
}
if ($show_more) {
ajx_extra_data(array('show_more' => $show_more));
}
$search_results = array();
$object_ids = array();
foreach ($rows as $ob_data) {
// basic data
$data = array('id' => $ob_data['id'], 'text_match' => $this->highlightOneResult($ob_data['text_match']), 'field_match' => $ob_data['field_match']);
$object_ids[] = $ob_data['id'];
$search_results[] = $data;
}
if (count($object_ids) > 0) {
$result = ContentDataObjects::listing(array("extra_conditions" => " AND o.id IN (" . implode(",", $object_ids) . ") ", "include_deleted" => true));
$objects = $result->objects;
foreach ($objects as $object) {
foreach ($search_results as $key => $search_result) {
if ($search_result['id'] == $object->getId()) {
$search_results[$key]['name'] = $object->getObjectName();
$class = 'ico-' . $object->getObjectTypeName();
$search_results[$key]['iconCls'] = $class;
$search_results[$key]['url'] = $object->getViewUrl();
continue;
}
}
}
}
$row = "search-result-row-medium";
ajx_extra_data(array('row_class' => $row));
ajx_extra_data(array('search_results' => $search_results));
}
ajx_current("empty");
}
private function processListActions()
{
$linkedObject = null;
if (array_var($_GET, 'action') == 'delete') {
$ids = explode(',', array_var($_GET, 'objects'));
$result = ContentDataObjects::listing(array("extra_conditions" => " AND o.id IN (" . implode(",", $ids) . ") ", "include_deleted" => true));
$objects = $result->objects;
foreach ($objects as $object) {
$object->setDontMakeCalculations(true);
}
$real_deleted_ids = array();
list($succ, $err) = $this->do_delete_objects($objects, false, $real_deleted_ids);
if ($err > 0) {
flash_error(lang('error delete objects', $err));
} else {
Hook::fire('after_object_delete_permanently', $real_deleted_ids, $ignored);
flash_success(lang('success delete objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'delete_permanently') {
$ids = explode(',', array_var($_GET, 'objects'));
$objects = Objects::instance()->findAll(array("conditions" => "id IN (" . implode(",", $ids) . ")"));
$real_deleted_ids = array();
list($succ, $err) = $this->do_delete_objects($objects, true, $real_deleted_ids);
if ($err > 0) {
flash_error(lang('error delete objects', $err));
}
if ($succ > 0) {
Hook::fire('after_object_delete_permanently', $real_deleted_ids, $ignored);
flash_success(lang('success delete objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'markasread') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_mark_as_read_unread_objects($ids, true);
} else {
if (array_var($_GET, 'action') == 'markasunread') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_mark_as_read_unread_objects($ids, false);
} else {
if (array_var($_GET, 'action') == 'empty_trash_can') {
$result = ContentDataObjects::listing(array("select_columns" => array('id'), "raw_data" => true, "trashed" => true));
$objects = $result->objects;
foreach ($objects as $object) {
$object->setDontMakeCalculations(true);
}
if (count($objects) > 0) {
$obj_ids_str = implode(',', array_flat($objects));
$extra_conds = "AND o.id IN ({$obj_ids_str})";
$count = Trash::purge_trash(0, 1000, $extra_conds);
flash_success(lang('success delete objects', $count));
}
} else {
if (array_var($_GET, 'action') == 'archive') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_archive_unarchive_objects($ids, 'archive');
if ($err > 0) {
flash_error(lang('error archive objects', $err));
} else {
flash_success(lang('success archive objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'unarchive') {
$ids = explode(',', array_var($_GET, 'objects'));
list($succ, $err) = $this->do_archive_unarchive_objects($ids, 'unarchive');
if ($err > 0) {
flash_error(lang('error unarchive objects', $err));
} else {
flash_success(lang('success unarchive objects', $succ));
}
} else {
if (array_var($_GET, 'action') == 'unclassify') {
$ids = explode(',', array_var($_GET, 'objects'));
$err = 0;
$succ = 0;
foreach ($ids as $id) {
$split = explode(":", $id);
$type = $split[0];
if (Plugins::instance()->isActivePlugin('mail') && $type == 'MailContents') {
$email = MailContents::findById($split[1]);
if (isset($email) && !$email->isDeleted() && $email->canEdit(logged_user())) {
if (MailController::do_unclassify($email)) {
$succ++;
} else {
$err++;
}
} else {
$err++;
}
}
}
if ($err > 0) {
flash_error(lang('error unclassify emails', $err));
} else {
flash_success(lang('success unclassify emails', $succ));
}
} else {
if (array_var($_GET, 'action') == 'restore') {
$errorMessage = null;
$ids = explode(',', array_var($_GET, 'objects'));
$success = 0;
$error = 0;
foreach ($ids as $id) {
$obj = Objects::findObject($id);
$obj->setDontMakeCalculations(true);
if ($obj->canDelete(logged_user())) {
try {
$obj->untrash($errorMessage);
if ($obj->getObjectTypeId() == 11) {
$event = ProjectEvents::findById($obj->getId());
if ($event->getExtCalId() != "") {
$this->created_event_google_calendar($obj, $event);
}
}
ApplicationLogs::createLog($obj, ApplicationLogs::ACTION_UNTRASH);
$success++;
} catch (Exception $e) {
$error++;
}
} else {
$error++;
}
}
if ($success > 0) {
flash_success(lang("success untrash objects", $success));
}
if ($error > 0) {
$errorString = is_null($errorMessage) ? lang("error untrash objects", $error) : $errorMessage;
flash_error($errorString);
}
}
}
}
}
}
}
}
}
}
if (!array_var($_GET, 'only_result')) {
$ignored = null;
Hook::fire('after_multi_object_action', array('object_ids' => explode(',', array_var($_GET, 'objects')), 'action' => array_var($_GET, 'action')), $ignored);
}
}
