CREATE procedure [dbo].[MssWebGetOrderTasks]
    @inOrderId int,
    @inTaskId int = null
as
set nocount on

select distinct
    Id = Todo.ToDoID,
    [Description] = Tasks.taskdescription,
    Identifier = Todo.Identifier,
    ProfileId = Todo.profileId,
    RolloutId = Todo.rolloutId,
    CompletedBy = dbo.GetSysuserName( Todo.CompletedBy, 1 ),
    Duedate = case
        when Todo.Complete = 1 or Todo.NotApplicableFlag = 1 then Todo.DueDateWhenDischarged
        else Todo.DueDate
    end ,
    OriginalDueDate = Todo.OriginalDueDate,
    CoordinatorId = Todo.TaskUserFID,
    CoordinatorName = dbo.GetSysuserName( Todo.TaskUserFID, 1 ),
    AssignedRoleId = Tasks.coordinatortypeid,
    AssignedRole = Coordinatortype.CoordinatorType,
    DateTimeCompleted = Todo.DateTimeCompleted,
    NotApplicableUserName = dbo.GetSysuserName( Todo.NotApplicableSysUserFID, 1 ),
    NotApplicableDateTime = Todo.NotApplicableDateTime,
    PriorityId = TaskPriority.TaskPriorityID,
    PriorityNumber = TaskPriority.PriorityNumber,
    PriorityDesc = TaskPriority.[Description],
    Note = ToDoNote.Notes,
    DueDays = Todo.dueDays,
    DueType = Todo.dueType,
    DependencyDateId = Todo.DependencyDateId,
    DependencyTaskId =  Todo.DependencyTaskFID,
    CreatedBy = dbo.GetSysuserName( Todo.CreatedBySysuserFID, 1 ),
    CreatedOn = Todo.DateTimeStamp,
    LastChangedBy = dbo.GetSysuserName(Todo.TaskChangedBySysUserFID,1),
    LastChangedOn = Todo.TaskChangedOnDate
from todo
    left outer join Orders on Orders.prikey = Todo.orderid
    left outer join Tasks on Tasks.taskid = Todo.taskid
    left outer join ToDoNote on ToDoNote.ToDoFID = Todo.ToDoID
    left outer join Coordinatortype on Coordinatortype.coordinatortypeid = Tasks.coordinatortypeid
    inner join Profiles on Profiles.ProfileID = Todo.ProfileID
    inner join SecModules on SecModules.ModulePriKey = Profiles.SecModulesFID
    left outer join TaskPriority on Todo.TaskPriorityFID = TaskPriority.TaskPriorityID
where
    Todo.OrderID = @inOrderId
    and (@inTaskId is null or  Todo.ToDoID = @inTaskId);
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderTasks] TO [MssExec]
GO