user();
$companies = company::select('id', 'company_name')->get();
$clients = Client::select('id', 'first_name', 'last_name')->get(); //Correction
if ($logged_user->can('view-project'))
{
if (request()->ajax())
{
return datatables()->of(Project::with('client:id,first_name,last_name', 'assignedEmployees')->get())
->setRowId(function ($project)
{
return $project->id;
})
->addColumn('summary', function ($row)
{
return '
';
})
->addColumn('client', function ($row)
{
if ($row->client_id!=NULL) {
return $row->client->first_name.' '.$row->client->last_name;
}else{
return " ";
}
})
->addColumn('assigned_employee', function ($row)
{
$assigned_name = $row->assignedEmployees()->pluck('last_name', 'first_name');
$collection = [];
foreach ($assigned_name as $first => $last)
{
$full_name = $first . ' ' . $last;
array_push($collection, $full_name);
}
return $collection;
})
->addColumn('action', function ($data)
{
$button = '';
$button .= ' ';
if (auth()->user()->can('user-edit'))
{
$button .= '';
$button .= ' ';
}
if (auth()->user()->can('user-delete'))
{
$button .= '';
}
return $button;
})
->rawColumns(['action', 'summary'])
->make(true);
}
return view('projects.project.index', compact('companies', 'clients'));
}
return abort('403', __('You are not authorized'));
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$logged_user = auth()->user();
if ($logged_user->can('store-project'))
{
$validator = Validator::make($request->only('title', 'company_id', 'client_id', 'employee_id', 'project_priority', 'description', 'start_date'
, 'end_date', 'summary'),
[
'title' => 'required',
'company_id' => 'required',
'client_id' => 'required',
'employee_id' => 'required',
'project_priority' => 'required',
'start_date' => 'required',
'end_date' => 'required|after_or_equal:start_date',
]
);
if ($validator->fails())
{
return response()->json(['errors' => $validator->errors()->all()]);
}
$data = [];
$data['summary'] = $request->summary;
$data['title'] = $request->title;
$data['company_id'] = $request->company_id;
$data['client_id'] = $request->client_id;
$data ['start_date'] = $request->start_date;
$data ['end_date'] = $request->end_date;
$data ['description'] = $request->description;
$data ['project_priority'] = $request->project_priority;
$project = Project::create($data);
$employees = $request->input('employee_id');
$project->assignedEmployees()->sync($employees);
$notificable = User::where('role_users_id', 1)
->orWhereIn('id', $employees)
->get();
Notification::send($notificable, new ProjectCreatedNotifiaction($project));
return response()->json(['success' => __('Data Added successfully.')]);
}
return response()->json(['success' => __('You are not authorized')]);
}
/**
* Display the specified resource.
*
* @param Project $project
* @return Response
*/
public function show(Project $project)
{
try
{
$name = DB::table('employee_project')->where('project_id', $project->id)->pluck('employee_id')->toArray();
} catch (Exception $e)
{
$name = null;
}
$logged_user = auth()->user();
if ($logged_user->can('view-project') || in_array($logged_user->id, $name))
{
$company_name = $project->company->company_name ?? '';
$employees = DB::table('employees')->where('company_id', $project->company_id)
->select('employees.id', DB::raw("CONCAT(employees.first_name,' ',employees.last_name) as full_name"))
->get();
return view('projects.project.details', compact('project', 'employees', 'company_name', 'name'));
}
return response()->json(['success' => __('You are not authorized')]);
}
/**
* Show the form for editing the specified resource.
*
* @param Project $project
* @return Response
*/
public function edit($id)
{
if (request()->ajax())
{
$data = Project::findOrFail($id);
return response()->json(['data' => $data]);
}
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param Project $project
* @return Response
*/
public function update(Request $request)
{
$logged_user = auth()->user();
if ($logged_user->can('edit-project'))
{
$id = $request->hidden_id;
$validator = Validator::make($request->only('edit_title', 'edit_client_id', 'edit_project_priority', 'edit_description', 'edit_start_date'
, 'edit_end_date', 'edit_summary', 'edit_project_status', 'edit_project_progress'),
[
'edit_title' => 'required',
'edit_client_id' => 'required',
'edit_project_priority' => 'required',
'edit_start_date' => 'required',
'edit_end_date' => 'required',
]
);
if ($validator->fails())
{
return response()->json(['errors' => $validator->errors()->all()]);
}
$data = [];
$data['summary'] = $request->edit_summary;
$data['title'] = $request->edit_title;
$data['client_id'] = $request->edit_client_id;
$data ['start_date'] = $request->edit_start_date;
$data ['end_date'] = $request->edit_end_date;
if ($request->edit_description)
{
$data ['description'] = $request->edit_description;
}
$data ['project_priority'] = $request->edit_project_priority;
$data ['project_status'] = $request->edit_project_status;
if ($request->edit_project_progress)
{
$data ['project_progress'] = $request->edit_project_progress;
}
Project::find($id)->update($data);
return response()->json(['success' => __('Data is successfully updated')]);
}
return response()->json(['success' => __('You are not authorized')]);
}
/**
* Remove the specified resource from storage.
*
* @param Project $project
* @return Response
*/
public function destroy($id)
{
if (!env('USER_VERIFIED'))
{
return response()->json(['error' => 'This feature is disabled for demo!']);
}
$logged_user = auth()->user();
if ($logged_user->can('delete-project'))
{
Project::whereId($id)->delete();
return response()->json(['success' => __('Data is successfully deleted')]);
}
return response()->json(['success' => __('You are not authorized')]);
}
public function progressStore(Request $request, Project $project)
{
$data = [];
if ($request->project_progress)
{
$data['project_progress'] = $request->project_progress;
}
if ($request->project_priority)
{
$data['project_priority'] = $request->project_priority;
}
if ($request->project_status)
{
$data['project_status'] = $request->project_status;
}
$project->update($data);
$assigned = $project->assignedEmployees()->pluck('id');
if (sizeof($assigned) == 0)
{
$notificable = User::where('role_users_id', 1)
->orWhere('id', $project->client_id)
->get();
Notification::send($notificable, new ProjectUpdatedNotification($project));
} else
{
$notificable = User::where('role_users_id', 1)
->orWhereIn('id', $assigned)
->orWhere('id', $project->client_id)
->get();
Notification::send($notificable, new ProjectUpdatedNotification($project));
}
return response()->json(['success' => __('Data is successfully updated')]);
}
public function notesStore(Request $request, Project $project)
{
$validator = Validator::make($request->only('project_note'),
[
'project_note' => 'required',
]
);
if ($validator->fails())
{
return response()->json(['errors' => $validator->errors()->all()]);
}
$data = [];
$data['project_note'] = $request->project_note;
$project->update($data);
return response()->json(['success' => __('Data is successfully updated')]);
}
}