/** * * Moves the source task before/after the target task; * @param array $data * @return false|array */ public function move($data) { global $USER; if (!$USER->isAuthorized()) { $this->errors->add("AUTH_REQUIRED", Loc::getMessage("TASKS_SORTING_AUTH_REQUIRED")); return false; } $sourceId = isset($data["sourceId"]) ? intval($data["sourceId"]) : 0; $targetId = isset($data["targetId"]) ? intval($data["targetId"]) : 0; $before = isset($data["before"]) && ($data["before"] === true || $data["before"] === "true") ? true : false; $newGroupId = isset($data["newGroupId"]) ? intval($data["newGroupId"]) : null; $newParentId = isset($data["newParentId"]) ? intval($data["newParentId"]) : null; $currentGroupId = isset($data["currentGroupId"]) ? intval($data["currentGroupId"]) : 0; $userId = $USER->getId(); if ($sourceId === $targetId || $sourceId < 1) { return array(); } $sourceTask = new \CTaskItem($sourceId, $userId); if (!$sourceTask->checkCanRead()) { $this->errors->add("SOURCE_TASK_NOT_FOUND", Loc::getMessage("TASKS_SORTING_WRONG_SOURCE_TASK")); return false; } if ($currentGroupId) { $group = \CSocNetGroup::getByID($currentGroupId); $canEdit = \CSocNetFeaturesPerms::currentUserCanPerformOperation(SONET_ENTITY_GROUP, $currentGroupId, "tasks", "edit_tasks"); if (!$group || !$canEdit) { $this->errors->add("GROUP_PERMS_NOT_FOUND", Loc::getMessage("TASKS_SORTING_WRONG_GROUP_PERMISSIONS")); return false; } } /* GROUP_ID and PARENT_ID could be changed after drag&drop manipulations. Target task is not required. Example: We want to move Task 1 after Project. In this case a target task is undefined. Task 1 Project (without tasks) */ $newTaskData = array(); if ($newGroupId !== null) { $newTaskData["GROUP_ID"] = $newGroupId; } if ($newParentId !== null) { $newTaskData["PARENT_ID"] = $newParentId; } if (count($newTaskData)) { $sourceTask->update($newTaskData); } //But it's required for sorting if ($targetId < 1) { return array(); } $targetTask = new \CTaskItem($targetId, $userId); if (!$targetTask->checkCanRead()) { $this->errors->add("TARGET_TASK_NOT_FOUND", Loc::getMessage("TASKS_SORTING_WRONG_TARGET_TASK")); return false; } SortingTable::setSorting($userId, $currentGroupId, $sourceId, $targetId, $before); return array(); }
public static function GetList($arOrder = array(), $arFilter = array(), $arSelect = array(), $arParams = array()) { global $DB, $USER, $USER_FIELD_MANAGER; $bIgnoreErrors = false; $nPageTop = false; $bGetZombie = false; if (!is_array($arParams)) { $nPageTop = $arParams; $arParams = false; } else { if (isset($arParams['nPageTop'])) { $nPageTop = $arParams['nPageTop']; } if (isset($arParams['bIgnoreErrors'])) { $bIgnoreErrors = (bool) $arParams['bIgnoreErrors']; } if (isset($arParams['bGetZombie'])) { $bGetZombie = (bool) $arParams['bGetZombie']; } } $obUserFieldsSql = new CUserTypeSQL(); $obUserFieldsSql->SetEntity("TASKS_TASK", "T.ID"); $obUserFieldsSql->SetSelect($arSelect); $obUserFieldsSql->SetFilter($arFilter); $obUserFieldsSql->SetOrder($arOrder); if (is_array($arParams) && array_key_exists('USER_ID', $arParams) && $arParams['USER_ID'] > 0) { $userID = (int) $arParams['USER_ID']; } else { $userID = is_object($USER) ? intval($USER->GetID()) : 0; } $arFields = array("ID" => "T.ID", "TITLE" => "T.TITLE", "DESCRIPTION" => "T.DESCRIPTION", "DESCRIPTION_IN_BBCODE" => "T.DESCRIPTION_IN_BBCODE", "DECLINE_REASON" => "T.DECLINE_REASON", "PRIORITY" => "T.PRIORITY", "STATUS" => "\n\t\t\t\tCASE\n\t\t\t\t\tWHEN\n\t\t\t\t\t\tT.DEADLINE < " . $DB->CurrentTimeFunction() . " AND T.STATUS != '4' AND T.STATUS != '5' AND (T.STATUS != '7' OR T.RESPONSIBLE_ID != " . $userID . ")\n\t\t\t\t\tTHEN\n\t\t\t\t\t\t'-1'\n\t\t\t\t\tWHEN\n\t\t\t\t\t\tTV.USER_ID IS NULL\n\t\t\t\t\t\tAND\n\t\t\t\t\t\tT.CREATED_BY != " . $userID . "\n\t\t\t\t\t\tAND\n\t\t\t\t\t\t(T.STATUS = 1 OR T.STATUS = 2)\n\t\t\t\t\tTHEN\n\t\t\t\t\t\t'-2'\n\t\t\t\t\tELSE\n\t\t\t\t\t\tT.STATUS\n\t\t\t\tEND\n\t\t\t", "STATUS_COMPLETE" => "\n\t\t\t\tCASE\n\t\t\t\t\tWHEN\n\t\t\t\t\t\tT.STATUS = '5'\n\t\t\t\t\tTHEN\n\t\t\t\t\t\t'2'\n\t\t\t\t\tELSE\n\t\t\t\t\t\t'1'\n\t\t\t\t\tEND\n\t\t\t", "REAL_STATUS" => "T.STATUS", "MULTITASK" => "T.MULTITASK", "RESPONSIBLE_ID" => "T.RESPONSIBLE_ID", "RESPONSIBLE_NAME" => "RU.NAME", "RESPONSIBLE_LAST_NAME" => "RU.LAST_NAME", "RESPONSIBLE_SECOND_NAME" => "RU.SECOND_NAME", "RESPONSIBLE_LOGIN" => "RU.LOGIN", "RESPONSIBLE_WORK_POSITION" => "RU.WORK_POSITION", "RESPONSIBLE_PHOTO" => "RU.PERSONAL_PHOTO", "DATE_START" => $DB->DateToCharFunction("T.DATE_START", "FULL"), "DURATION_FACT" => "(SELECT SUM(TE.MINUTES) FROM b_tasks_elapsed_time TE WHERE TE.TASK_ID = T.ID GROUP BY TE.TASK_ID)", "TIME_ESTIMATE" => "T.TIME_ESTIMATE", "TIME_SPENT_IN_LOGS" => "(SELECT SUM(TE.SECONDS) FROM b_tasks_elapsed_time TE WHERE TE.TASK_ID = T.ID GROUP BY TE.TASK_ID)", "REPLICATE" => "T.REPLICATE", "DEADLINE" => $DB->DateToCharFunction("T.DEADLINE", "FULL"), "DEADLINE_ORIG" => "T.DEADLINE", "START_DATE_PLAN" => $DB->DateToCharFunction("T.START_DATE_PLAN", "FULL"), "END_DATE_PLAN" => $DB->DateToCharFunction("T.END_DATE_PLAN", "FULL"), "CREATED_BY" => "T.CREATED_BY", "CREATED_BY_NAME" => "CU.NAME", "CREATED_BY_LAST_NAME" => "CU.LAST_NAME", "CREATED_BY_SECOND_NAME" => "CU.SECOND_NAME", "CREATED_BY_LOGIN" => "CU.LOGIN", "CREATED_BY_WORK_POSITION" => "CU.WORK_POSITION", "CREATED_BY_PHOTO" => "CU.PERSONAL_PHOTO", "CREATED_DATE" => $DB->DateToCharFunction("T.CREATED_DATE", "FULL"), "CHANGED_BY" => "T.CHANGED_BY", "CHANGED_DATE" => $DB->DateToCharFunction("T.CHANGED_DATE", "FULL"), "STATUS_CHANGED_BY" => "T.CHANGED_BY", "STATUS_CHANGED_DATE" => 'CASE WHEN T.STATUS_CHANGED_DATE IS NULL THEN ' . $DB->DateToCharFunction("T.CHANGED_DATE", "FULL") . ' ELSE ' . $DB->DateToCharFunction("T.STATUS_CHANGED_DATE", "FULL") . ' END ', "CLOSED_BY" => "T.CLOSED_BY", "CLOSED_DATE" => $DB->DateToCharFunction("T.CLOSED_DATE", "FULL"), 'GUID' => 'T.GUID', "XML_ID" => "T.XML_ID", "MARK" => "T.MARK", "ALLOW_CHANGE_DEADLINE" => "T.ALLOW_CHANGE_DEADLINE", "ALLOW_TIME_TRACKING" => 'T.ALLOW_TIME_TRACKING', "MATCH_WORK_TIME" => "T.MATCH_WORK_TIME", "TASK_CONTROL" => "T.TASK_CONTROL", "ADD_IN_REPORT" => "T.ADD_IN_REPORT", "GROUP_ID" => "CASE WHEN T.GROUP_ID IS NULL THEN 0 ELSE T.GROUP_ID END", "FORUM_TOPIC_ID" => "T.FORUM_TOPIC_ID", "PARENT_ID" => "T.PARENT_ID", "COMMENTS_COUNT" => "FT.POSTS", "FORUM_ID" => "FT.FORUM_ID", "SITE_ID" => "T.SITE_ID", "SUBORDINATE" => ($strSql = CTasks::GetSubordinateSql('', $arParams)) ? "CASE WHEN EXISTS(" . $strSql . ") THEN 'Y' ELSE 'N' END" : "'N'", "EXCHANGE_MODIFIED" => "T.EXCHANGE_MODIFIED", "EXCHANGE_ID" => "T.EXCHANGE_ID", "OUTLOOK_VERSION" => "T.OUTLOOK_VERSION", "VIEWED_DATE" => $DB->DateToCharFunction("TV.VIEWED_DATE", "FULL"), "DEADLINE_COUNTED" => "T.DEADLINE_COUNTED", "FORKED_BY_TEMPLATE_ID" => "T.FORKED_BY_TEMPLATE_ID", "FAVORITE" => "CASE WHEN FVT.TASK_ID IS NULL THEN 'N' ELSE 'Y' END", "SORTING" => "SRT.SORT", "DURATION_PLAN_SECONDS" => "T.DURATION_PLAN", "DURATION_TYPE_ALL" => "T.DURATION_TYPE", "DURATION_PLAN" => "\n\t\t\t\tcase \n\t\t\t\t\twhen \n\t\t\t\t\t\tT.DURATION_TYPE = '" . self::TIME_UNIT_TYPE_MINUTE . "' or T.DURATION_TYPE = '" . self::TIME_UNIT_TYPE_HOUR . "' \n\t\t\t\t\tthen\n\t\t\t\t\t\tROUND(T.DURATION_PLAN / 3600, 0)\n\t\t\t\t\twhen\n\t\t\t\t\t\tT.DURATION_TYPE = '" . self::TIME_UNIT_TYPE_DAY . "' or T.DURATION_TYPE = '' or T.DURATION_TYPE is null\n\t\t\t\t\tthen\n\t\t\t\t\t\tROUND(T.DURATION_PLAN / 86400, 0)\n\t\t\t\t\telse\n\t\t\t\t\t\tT.DURATION_PLAN\n\t\t\t\tend\n\t\t\t", "DURATION_TYPE" => "\n\t\t\t\tcase \n\t\t\t\t\twhen \n\t\t\t\t\t\tT.DURATION_TYPE = '" . self::TIME_UNIT_TYPE_MINUTE . "' \n\t\t\t\t\tthen\n\t\t\t\t\t\t'" . self::TIME_UNIT_TYPE_HOUR . "'\n\t\t\t\t\telse\n\t\t\t\t\t\tT.DURATION_TYPE\n\t\t\t\tend\n\t\t\t"); if ($bGetZombie) { $arFields['ZOMBIE'] = 'T.ZOMBIE'; } if (count($arSelect) <= 0 || in_array("*", $arSelect)) { $arSelect = array_keys($arFields); } elseif (!in_array("ID", $arSelect)) { $arSelect[] = "ID"; } // add fields that are NOT selected by default //$arFields["FAVORITE"] = "CASE WHEN FVT.TASK_ID IS NULL THEN 'N' ELSE 'Y' END"; // If DESCRIPTION selected, than BBCODE flag must be selected too if (in_array('DESCRIPTION', $arSelect) && !in_array('DESCRIPTION_IN_BBCODE', $arSelect)) { $arSelect[] = 'DESCRIPTION_IN_BBCODE'; } if (!is_array($arOrder)) { $arOrder = array(); } $arSqlOrder = array(); foreach ($arOrder as $by => $order) { $needle = null; $by = strtolower($by); $order = strtolower($order); if ($by === 'deadline') { if (!in_array($order, array('asc', 'desc', 'asc,nulls', 'desc,nulls'), true)) { $order = 'asc,nulls'; } } else { if ($order !== 'asc') { $order = 'desc'; } } switch ($by) { case 'id': $arSqlOrder[] = " ID " . $order . " "; break; case 'title': $arSqlOrder[] = " TITLE " . $order . " "; $needle = 'TITLE'; break; case 'date_start': $arSqlOrder[] = " T.DATE_START " . $order . " "; $needle = 'DATE_START'; break; case 'created_date': $arSqlOrder[] = " T.CREATED_DATE " . $order . " "; $needle = 'CREATED_DATE'; break; case 'changed_date': $arSqlOrder[] = " T.CHANGED_DATE " . $order . " "; $needle = 'CHANGED_DATE'; break; case 'closed_date': $arSqlOrder[] = " T.CLOSED_DATE " . $order . " "; $needle = 'CLOSED_DATE'; break; case 'start_date_plan': $arSqlOrder[] = " T.START_DATE_PLAN " . $order . " "; $needle = 'START_DATE_PLAN'; break; case 'end_date_plan': $arSqlOrder[] = " T.END_DATE_PLAN " . $order . " "; $needle = 'END_DATE_PLAN'; break; case 'deadline': $orderClause = self::getOrderSql('T.DEADLINE', $order, $default_order = 'asc,nulls', $nullable = true); $needle = 'DEADLINE_ORIG'; if (!is_array($orderClause)) { $arSqlOrder[] = $orderClause; } else { // COLUMN ALIAS COLUMN EXPRESSION $arFields[$orderClause[1]] = $orderClause[0]; if (!in_array($orderClause[1], $arSelect)) { $arSelect[] = $orderClause[1]; } $arSqlOrder[] = $orderClause[2]; // order expression } break; case 'status': $arSqlOrder[] = " STATUS " . $order . " "; $needle = 'STATUS'; break; case 'status_complete': $arSqlOrder[] = " STATUS_COMPLETE " . $order . " "; $needle = 'STATUS_COMPLETE'; break; case 'priority': $arSqlOrder[] = " PRIORITY " . $order . " "; $needle = 'PRIORITY'; break; case 'mark': $arSqlOrder[] = " MARK " . $order . " "; $needle = 'MARK'; break; case 'created_by': $arSqlOrder[] = " CREATED_BY_LAST_NAME " . $order . " "; $needle = 'CREATED_BY_LAST_NAME'; break; case 'responsible_id': $arSqlOrder[] = " RESPONSIBLE_LAST_NAME " . $order . " "; $needle = 'RESPONSIBLE_LAST_NAME'; break; case 'group_id': $arSqlOrder[] = " GROUP_ID " . $order . " "; $needle = 'GROUP_ID'; break; case 'time_estimate': $arSqlOrder[] = " TIME_ESTIMATE " . $order . " "; $needle = 'TIME_ESTIMATE'; break; case 'allow_change_deadline': $arSqlOrder[] = " ALLOW_CHANGE_DEADLINE " . $order . " "; $needle = 'ALLOW_CHANGE_DEADLINE'; break; case 'allow_time_tracking': $arSqlOrder[] = " ALLOW_TIME_TRACKING " . $order . " "; $needle = 'ALLOW_TIME_TRACKING'; break; case 'match_work_time': $arSqlOrder[] = " MATCH_WORK_TIME " . $order . " "; $needle = 'MATCH_WORK_TIME'; break; case 'favorite': $arSqlOrder[] = " FAVORITE " . $order . " "; $needle = 'FAVORITE'; break; case 'sorting': $asc = stripos($order, "desc") === false; $arSqlOrder = array_merge($arSqlOrder, self::getSortingOrderBy($asc)); $needle = "SORTING"; break; default: if (substr($by, 0, 3) === 'uf_') { if ($s = $obUserFieldsSql->GetOrder($by)) { $arSqlOrder[$by] = " " . $s . " " . $order . " "; } } else { CTaskAssert::logWarning('[0x9a92cf7d] invalid sort by field requested: ' . $by); } break; } if ($needle !== null && !in_array($needle, $arSelect)) { $arSelect[] = $needle; } } $arSqlSelect = array(); foreach ($arSelect as $field) { $field = strtoupper($field); if (array_key_exists($field, $arFields)) { $arSqlSelect[$field] = $arFields[$field] . " AS " . $field; } } if (!sizeof($arSqlSelect)) { $arSqlSelect = "T.ID AS ID"; } // First level logic MUST be 'AND', because of backward compatibility // and some requests for checking rights, attached at first level of filter. // Situtation when there is OR-logic at first level cannot be resolved // in general case. // So if there is OR-logic, it is FATAL error caused by programmer. // But, if you want to use OR-logic at the first level of filter, you // can do this by putting all your filter conditions to the ::SUBFILTER-xxx, // except CHECK_PERMISSIONS, SUBORDINATE_TASKS (if you don't know exactly, // what are consequences of this fields in OR-logic of subfilters). if (isset($arFilter['::LOGIC'])) { CTaskAssert::assert($arFilter['::LOGIC'] === 'AND'); } $arSqlSearch = CTasks::GetFilter($arFilter, '', $arParams); if (!$bGetZombie) { $arSqlSearch[] = " T.ZOMBIE = 'N' "; } $r = $obUserFieldsSql->GetFilter(); if (strlen($r) > 0) { $arSqlSearch[] = "(" . $r . ")"; } $strSql = "\n\t\t\tSELECT\n\t\t\t\t" . implode(",\n", $arSqlSelect) . "\n\t\t\t\t" . $obUserFieldsSql->GetSelect(); $keysFiltered = CTasks::GetFilteredKeys($arFilter); $bNeedJoinFavoritesTable = in_array('FAVORITE', $arSelect, true) || array_key_exists('FAVORITE', $arOrder) || in_array('FAVORITE', $keysFiltered, true); $bNeedJoinForumsTable = in_array('COMMENTS_COUNT', $arSelect, true) || in_array('FORUM_ID', $arSelect, true); $bNeedJoinSortingTable = in_array('SORTING', $arSelect, true) || array_key_exists('SORTING', $arOrder) || in_array('SORTING', $keysFiltered, true); $sortingGroupId = is_array($arFilter) && isset($arFilter["GROUP_ID"]) ? intval($arFilter["GROUP_ID"]) : false; $strFrom = "\n\t\t\tFROM\n\t\t\t\tb_tasks T\n\t\t\tINNER JOIN b_user CU ON CU.ID = T.CREATED_BY \n\t\t\tINNER JOIN b_user RU ON RU.ID = T.RESPONSIBLE_ID \n\t\t\tLEFT JOIN b_tasks_viewed TV ON TV.TASK_ID = T.ID \n\t\t\t\tAND TV.USER_ID = " . $userID . " " . ($bNeedJoinSortingTable ? "\n\t\t\t\tLEFT JOIN " . SortingTable::getTableName() . " SRT ON SRT.TASK_ID = T.ID and " . ($sortingGroupId !== false ? "SRT.GROUP_ID = " . $sortingGroupId : "SRT.USER_ID = " . $userID) : "") . ($bNeedJoinFavoritesTable ? "\n\t\t\t\tLEFT JOIN " . FavoriteTable::getTableName() . " FVT ON FVT.TASK_ID = T.ID and FVT.USER_ID = '" . $userID . "'\n\t\t\t\t" : "") . ($bNeedJoinForumsTable ? "\n\t\t\t\tLEFT JOIN b_forum_topic FT ON FT.ID = T.FORUM_TOPIC_ID\n\t\t\t\t" : "") . $obUserFieldsSql->GetJoin("T.ID") . " " . (sizeof($arSqlSearch) ? " WHERE " . implode(" AND ", $arSqlSearch) : "") . " "; $strSql .= $strFrom; $strSqlOrder = ""; DelDuplicateSort($arSqlOrder); for ($i = 0, $arSqlOrderCnt = count($arSqlOrder); $i < $arSqlOrderCnt; $i++) { if ($i == 0) { $strSqlOrder = " ORDER BY "; } else { $strSqlOrder .= ","; } $strSqlOrder .= $arSqlOrder[$i]; } $strSql .= $strSqlOrder; //echo $strSql; if ($nPageTop !== false && is_numeric($nPageTop)) { $strSql = $DB->TopSql($strSql, intval($nPageTop)); } if (is_array($arParams) && array_key_exists("NAV_PARAMS", $arParams) && is_array($arParams["NAV_PARAMS"])) { $nTopCount = intval($arParams['NAV_PARAMS']['nTopCount']); if ($nTopCount > 0) { $strSql = $DB->TopSql($strSql, $nTopCount); $res = $DB->Query($strSql, $bIgnoreErrors, "File: " . __FILE__ . "<br>Line: " . __LINE__); if ($res === false) { throw new TasksException('', TasksException::TE_SQL_ERROR); } $res->SetUserFields($USER_FIELD_MANAGER->GetUserFields("TASKS_TASK")); } else { $res_cnt = $DB->Query("SELECT COUNT(T.ID) as C " . $strFrom); $res_cnt = $res_cnt->Fetch(); $totalTasksCount = (int) $res_cnt["C"]; // unknown by default // Sync counters in case of mistiming CTaskCountersProcessorHomeostasis::onTaskGetList($arFilter, $totalTasksCount); $res = new CDBResult(); $res->SetUserFields($USER_FIELD_MANAGER->GetUserFields("TASKS_TASK")); $rc = $res->NavQuery($strSql, $totalTasksCount, $arParams["NAV_PARAMS"], $bIgnoreErrors); if ($bIgnoreErrors && $rc === false) { throw new TasksException('', TasksException::TE_SQL_ERROR); } } } else { $res = $DB->Query($strSql, $bIgnoreErrors, "File: " . __FILE__ . "<br>Line: " . __LINE__); if ($res === false) { throw new TasksException('', TasksException::TE_SQL_ERROR); } $res->SetUserFields($USER_FIELD_MANAGER->GetUserFields("TASKS_TASK")); } return $res; }