roleID != 21 && Auth::user()->roleID != 17 && Auth::user()->roleID != 16 && Auth::user()->roleID != 23) style="display: none;" @endif> @php $previousProjects = DB::table('gcp_projects') ->where('ClientID', $project_detail->ClientID) ->where('SourceID', $project_detail->SourceID) ->where('ProjectID', '!=', $project_detail->ProjectID) // Current project exclude karo ->orderBy('created_at', 'desc') // Order by the latest project first ->first(); $AssignedManager = DB::table('gcp_assigntomanagers') ->where('ProjectID', $project_detail->ProjectID) ->where('IsAssigned', true) ->pluck('ManagerID') ->all(); $user = DB::table('gcp_teams') ->where('IsActive', true) ->whereNotIn('TeamID', $AssignedManager) ->get(); $AssignManager = DB::table('gcp_assigntomanagers') ->where('ProjectID', $project_detail->ProjectID) ->get(); $assignedTeamID = DB::table('gcp_assigntomanagers') ->where('ProjectID', $project_detail->ProjectID) ->where('IsAssigned', true) ->value('ManagerID'); $TeamID = DB::table('gcp_assigntomanagers') ->where('ProjectID', $project_detail->ProjectID) ->where('IsAssigned', true) ->pluck('ManagerID'); $TeamMembers = ''; if ($TeamID != null) { $editorID = DB::table('gcp_users') ->where('roleID', 19) ->where('IsActive', true) ->pluck('UserID'); $WriterAssigned = DB::table('gcp_projectassignments') ->where('ProjectID', $project_detail->ProjectID) ->where('IsAssigned', true) ->pluck('WriterID') ->all(); $array = collect($WriterAssigned, $editorID); $TeamMembers = DB::table('gcp_teammembers') ->leftjoin('gcp_users', 'gcp_users.UserID', '=', 'gcp_teammembers.UserID') ->where('gcp_users.IsActive', '=', true) ->whereIn('gcp_teammembers.TeamID', $TeamID) ->whereNotIn('gcp_users.UserID', $WriterAssigned) ->orderBy('gcp_users.FullName', 'ASC') ->get(); } else { $TeamMembers = DB::table('gcp_users')->where('roleID', '99')->get(); } @endphp

@csrf

TEAM

-- Select Team -- @foreach ($user as $team) TeamID ? 'selected' : '' }}> {{ $team->TeamName }} @endforeach

WRITER NAME

-- Select Writer -- @if (!empty($TeamMembers)) @foreach ($TeamMembers as $writer) UserID ? 'selected' : '' }}> {{ $writer->FullName }} @endforeach @endif

Assign

@if ($previousProjects)

@csrf Assign previous

@endif