commonUtil = $commonUtil;
$this->projectUtil = $projectUtil;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (request()->ajax()) {
$business_id = request()->session()->get('user.business_id');
$project_id = request()->get('project_id');
$project = Project::where('business_id', $business_id)
->findOrFail($project_id);
$project_task_time_logs = ProjectTimeLog::where('project_id', $project_id)
->with('task', 'user', 'project')
->select('*');
// check permission for crud time log
$is_admin = $this->commonUtil->is_admin(auth()->user(), $business_id);
$is_lead = $this->projectUtil->isProjectLead(auth()->user()->id, $project_id);
$is_member = $this->projectUtil->isProjectMember(auth()->user()->id, $project_id);
$can_crud = false;
if ($is_admin || $is_lead) {
$can_crud = true;
} elseif ($is_member && (isset($project->settings['members_crud_timelog']) && $project->settings['members_crud_timelog'])) {
$can_crud = true;
}
return Datatables::of($project_task_time_logs)
->addColumn('action', function ($row) use ($can_crud) {
$html = '
';
if ($can_crud) {
$html .= '';
}
$html .= '
';
return $html;
})
->editColumn('task', function ($row) {
$task = '';
if (! empty($row->task)) {
$html = ' ('.$row->task->task_id.')';
$task = $row->task->subject.$html;
}
return $task;
})
->editColumn('start_datetime', '
@format_datetime($start_datetime)
')
->editColumn('end_datetime', '
@format_datetime($end_datetime)
')
->editColumn('work_hour', function ($row) {
$start_datetime = \Carbon::parse($row->start_datetime);
$end_datetime = \Carbon::parse($row->end_datetime);
return $start_datetime->diffForHumans($end_datetime, true);
})
->editColumn('user', function ($row) {
return $row->user?->user_full_name;
})
->removeColumn('id')
->rawColumns(['action', 'task', 'start_datetime', 'end_datetime', 'work_hour', 'user'])
->make(true);
}
return view('project::time_logs.index');
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$project_id = request()->get('project_id');
$task_id = request()->get('task_id', null);
$project_tasks = ProjectTask::taskDropdown($project_id);
$project_members = ProjectMember::projectMembersDropdown($project_id);
//check if user is admin/lead & can add time log for other user
$business_id = request()->session()->get('user.business_id');
$is_admin = $this->commonUtil->is_admin(auth()->user(), $business_id);
$is_lead = $this->projectUtil->isProjectLead(auth()->user()->id, $project_id);
$is_lead_or_admin = false;
if ($is_admin || $is_lead) {
$is_lead_or_admin = true;
}
$added_from = request()->input('added_from');
return view('project::time_logs.create')
->with(compact('project_tasks', 'project_id', 'project_members', 'is_lead_or_admin', 'added_from', 'task_id'));
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
try {
$input = $request->only('project_id', 'project_task_id', 'note');
$input['start_datetime'] = $this->commonUtil->uf_date($request->input('start_datetime'), true);
$input['end_datetime'] = $this->commonUtil->uf_date($request->input('end_datetime'), true);
$input['created_by'] = $request->session()->get('user.id');
//check if time log is creating by admin/lead
$business_id = request()->session()->get('user.business_id');
$is_admin = $this->commonUtil->is_admin(auth()->user(), $business_id);
$is_lead = $this->projectUtil->isProjectLead(auth()->user()->id, $input['project_id']);
if ($is_admin || $is_lead) {
$input['user_id'] = $request->get('user_id');
} else {
$input['user_id'] = $request->session()->get('user.id');
}
ProjectTimeLog::create($input);
$task_timelog_html = '';
$added_from = $request->get('added_from');
if (! empty($added_from) && $added_from == 'task') {
$project_task = ProjectTask::with(['timeLogs', 'timeLogs.user'])
->where('project_id', $input['project_id'])
->findOrFail($input['project_task_id']);
$task_timelog_html = view('project::task.partials.time_log_table_body')
->with(compact('project_task'))
->render();
}
$output = [
'success' => true,
'task_timelog_html' => $task_timelog_html,
'added_from' => $added_from,
'msg' => __('lang_v1.success'),
];
} catch (Exception $e) {
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = [
'success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
/**
* Show the specified resource.
*
* @return Response
*/
public function show()
{
return view('project::show');
}
/**
* Show the form for editing the specified resource.
*
* @return Response
*/
public function edit($id)
{
$project_id = request()->get('project_id');
$project_tasks = ProjectTask::taskDropdown($project_id);
$project_task_time_log = ProjectTimeLog::where('project_id', $project_id)
->findOrFail($id);
$project_members = ProjectMember::projectMembersDropdown($project_id);
//check if user is admin/lead & can add time log for other user
$business_id = request()->session()->get('user.business_id');
$is_admin = $this->commonUtil->is_admin(auth()->user(), $business_id);
$is_lead = $this->projectUtil->isProjectLead(auth()->user()->id, $project_id);
$is_lead_or_admin = false;
if ($is_admin || $is_lead) {
$is_lead_or_admin = true;
}
return view('project::time_logs.edit')
->with(compact('project_tasks', 'project_task_time_log', 'is_lead_or_admin', 'project_members'));
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @return Response
*/
public function update(Request $request, $id)
{
try {
$input = $request->only('note', 'project_task_id');
if (! empty($request->input('start_datetime'))) {
$input['start_datetime'] = $this->commonUtil->uf_date($request->input('start_datetime'), true);
}
if (! empty($request->input('end_datetime'))) {
$input['end_datetime'] = $this->commonUtil->uf_date($request->input('end_datetime'), true);
}
//check if time log is creating by admin/lead
$business_id = request()->session()->get('user.business_id');
$is_admin = $this->commonUtil->is_admin(auth()->user(), $business_id);
$is_lead = $this->projectUtil->isProjectLead(auth()->user()->id, $id);
if ($is_admin || $is_lead) {
$input['user_id'] = $request->get('user_id');
} else {
$input['user_id'] = $request->session()->get('user.id');
}
$project_id = $request->get('project_id');
$project_task_time_log = ProjectTimeLog::where('project_id', $project_id)
->findOrFail($id);
$project_task_time_log->update($input);
$output = [
'success' => true,
'msg' => __('lang_v1.success'),
];
} catch (Exception $e) {
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = [
'success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
/**
* Remove the specified resource from storage.
*
* @return Response
*/
public function destroy($id)
{
try {
$project_task_time_log = ProjectTimeLog::findOrFail($id);
$project_task_time_log->delete();
$output = [
'success' => true,
'msg' => __('lang_v1.success'),
];
} catch (Exception $e) {
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = [
'success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
}