Server : Apache/2.4.62 (Unix) OpenSSL/1.0.2k-fips System : Linux server1.richineiserver.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : fdshops ( 1003) PHP Version : 8.2.21 Disable Function : NONE Directory : /home/fdshops/public_html/Modules/Essentials/Http/Controllers/ |
<?php
namespace Modules\Essentials\Http\Controllers;
use App\User;
use App\Utils\ModuleUtil;
use DB;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Routing\Controller;
use Modules\Essentials\Entities\EssentialsLeave;
use Modules\Essentials\Entities\EssentialsLeaveType;
use Modules\Essentials\Notifications\LeaveStatusNotification;
use Modules\Essentials\Notifications\NewLeaveNotification;
use Spatie\Activitylog\Models\Activity;
use Yajra\DataTables\Facades\DataTables;
class EssentialsLeaveController extends Controller
{
/**
* All Utils instance.
*/
protected $moduleUtil;
protected $leave_statuses;
/**
* Constructor
*
* @param ProductUtils $product
* @return void
*/
public function __construct(ModuleUtil $moduleUtil)
{
$this->moduleUtil = $moduleUtil;
$this->leave_statuses = [
'pending' => [
'name' => __('lang_v1.pending'),
'class' => 'bg-yellow',
],
'approved' => [
'name' => __('essentials::lang.approved'),
'class' => 'bg-green',
],
'cancelled' => [
'name' => __('essentials::lang.cancelled'),
'class' => 'bg-red',
],
];
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$business_id = request()->session()->get('user.business_id');
if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'essentials_module'))) {
abort(403, 'Unauthorized action.');
}
$can_crud_all_leave = auth()->user()->can('essentials.crud_all_leave');
$can_crud_own_leave = auth()->user()->can('essentials.crud_own_leave');
if (! $can_crud_all_leave && ! $can_crud_own_leave) {
abort(403, 'Unauthorized action.');
}
if (request()->ajax()) {
$leaves = EssentialsLeave::where('essentials_leaves.business_id', $business_id)
->join('users as u', 'u.id', '=', 'essentials_leaves.user_id')
->join('essentials_leave_types as lt', 'lt.id', '=', 'essentials_leaves.essentials_leave_type_id')
->select([
'essentials_leaves.id',
DB::raw("CONCAT(COALESCE(u.surname, ''), ' ', COALESCE(u.first_name, ''), ' ', COALESCE(u.last_name, '')) as user"),
'lt.leave_type',
'start_date',
'end_date',
'ref_no',
'essentials_leaves.status',
'essentials_leaves.business_id',
'reason',
'status_note',
]);
if (! empty(request()->input('user_id'))) {
$leaves->where('essentials_leaves.user_id', request()->input('user_id'));
}
if (! $can_crud_all_leave && $can_crud_own_leave) {
$leaves->where('essentials_leaves.user_id', auth()->user()->id);
}
if (! empty(request()->input('status'))) {
$leaves->where('essentials_leaves.status', request()->input('status'));
}
if (! empty(request()->input('leave_type'))) {
$leaves->where('essentials_leaves.essentials_leave_type_id', request()->input('leave_type'));
}
if (! empty(request()->start_date) && ! empty(request()->end_date)) {
$start = request()->start_date;
$end = request()->end_date;
$leaves->whereDate('essentials_leaves.start_date', '>=', $start)
->whereDate('essentials_leaves.start_date', '<=', $end);
}
return Datatables::of($leaves)
->addColumn(
'action',
function ($row) {
$html = '';
if (auth()->user()->can('essentials.crud_all_leave')) {
$html .= '<button class="tw-dw-btn tw-dw-btn-outline tw-dw-btn-xs tw-dw-btn-error delete-leave" data-href="'.action([\Modules\Essentials\Http\Controllers\EssentialsLeaveController::class, 'destroy'], [$row->id]).'"><i class="fa fa-trash"></i> '.__('messages.delete').'</button>';
}
$html .= ' <button class="tw-dw-btn tw-dw-btn-info tw-text-white tw-dw-btn-xs btn-modal" data-container=".view_modal" data-href="'.action([\Modules\Essentials\Http\Controllers\EssentialsLeaveController::class, 'activity'], [$row->id]).'"><i class="fa fa-edit"></i> '.__('essentials::lang.activity').'</button>';
return $html;
}
)
->editColumn('start_date', function ($row) {
$start_date = \Carbon::parse($row->start_date);
$end_date = \Carbon::parse($row->end_date);
$diff = $start_date->diffInDays($end_date);
$diff += 1;
$start_date_formated = $this->moduleUtil->format_date($start_date);
$end_date_formated = $this->moduleUtil->format_date($end_date);
return $start_date_formated.' - '.$end_date_formated.' ('.$diff.\Str::plural(__('lang_v1.day'), $diff).')';
})
->editColumn('status', function ($row) {
$status = '<span class="label '.$this->leave_statuses[$row->status]['class'].'">'
.$this->leave_statuses[$row->status]['name'].'</span>';
if (auth()->user()->can('essentials.crud_all_leave') || auth()->user()->can('essentials.approve_leave')) {
$status = '<a href="#" class="change_status" data-status_note="'.$row->status_note.'" data-leave-id="'.$row->id.'" data-orig-value="'.$row->status.'" data-status-name="'.$this->leave_statuses[$row->status]['name'].'"> '.$status.'</a>';
}
return $status;
})
->filterColumn('user', function ($query, $keyword) {
$query->whereRaw("CONCAT(COALESCE(u.surname, ''), ' ', COALESCE(u.first_name, ''), ' ', COALESCE(u.last_name, '')) like ?", ["%{$keyword}%"]);
})
->removeColumn('id')
->rawColumns(['action', 'status'])
->make(true);
}
$users = [];
if ($can_crud_all_leave || auth()->user()->can('essentials.approve_leave')) {
$users = User::forDropdown($business_id, false);
}
$leave_statuses = $this->leave_statuses;
$leave_types = EssentialsLeaveType::forDropdown($business_id);
return view('essentials::leave.index')->with(compact('leave_statuses', 'users', 'leave_types'));
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$business_id = request()->session()->get('user.business_id');
$leave_types = EssentialsLeaveType::forDropdown($business_id);
$settings = request()->session()->get('business.essentials_settings');
$settings = ! empty($settings) ? json_decode($settings, true) : [];
$instructions = ! empty($settings['leave_instructions']) ? $settings['leave_instructions'] : '';
$employees = [];
if (auth()->user()->can('essentials.crud_all_leave')) {
$employees = User::forDropdown($business_id, false, false, false, true);
}
return view('essentials::leave.create')->with(compact('leave_types', 'instructions', 'employees'));
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$business_id = request()->session()->get('user.business_id');
if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'essentials_module'))) {
abort(403, 'Unauthorized action.');
}
$can_crud_all_leave = auth()->user()->can('essentials.crud_all_leave');
$can_crud_own_leave = auth()->user()->can('essentials.crud_own_leave');
if (! $can_crud_all_leave && ! $can_crud_own_leave) {
abort(403, 'Unauthorized action.');
}
try {
$input = $request->only(['essentials_leave_type_id', 'start_date', 'end_date', 'reason']);
$input['business_id'] = $business_id;
$input['status'] = 'pending';
$input['start_date'] = $this->moduleUtil->uf_date($input['start_date']);
$input['end_date'] = $this->moduleUtil->uf_date($input['end_date']);
DB::beginTransaction();
if (auth()->user()->can('essentials.crud_all_leave') && ! empty($request->input('employees'))) {
foreach ($request->input('employees') as $user_id) {
$this->__addLeave($input, $user_id);
}
} else {
$this->__addLeave($input);
}
DB::commit();
$output = ['success' => true,
'msg' => __('lang_v1.added_success'),
];
} catch (\Exception $e) {
DB::rollBack();
\Log::emergency('File:'.$e->getFile().'Line:'.$e->getLine().'Message:'.$e->getMessage());
$output = ['success' => false,
'msg' => __('messages.something_went_wrong'),
];
}
return $output;
}
private function __addLeave($input, $user_id = null)
{
$input['user_id'] = ! empty($user_id) ? $user_id : request()->session()->get('user.id');
//Update reference count
$ref_count = $this->moduleUtil->setAndGetReferenceCount('leave');
//Generate reference number
if (empty($input['ref_no'])) {
$settings = request()->session()->get('business.essentials_settings');
$settings = ! empty($settings) ? json_decode($settings, true) : [];
$prefix = ! empty($settings['leave_ref_no_prefix']) ? $settings['leave_ref_no_prefix'] : '';
$input['ref_no'] = $this->moduleUtil->generateReferenceNumber('leave', $ref_count, null, $prefix);
}
$leave = EssentialsLeave::create($input);
$admins = $this->moduleUtil->get_admins($input['business_id']);
\Notification::send($admins, new NewLeaveNotification($leave));
}
/**
* Show the specified resource.
*
* @return Response
*/
public function show()
{
return view('essentials::show');
}
/**
* Show the form for editing the specified resource.
*
* @return Response
*/
public function edit()
{
return view('essentials::edit');
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @return Response
*/
public function update(Request $request)
{
}
/**
* Remove the specified resource from storage.
*
* @return Response
*/
public function destroy($id)
{
$business_id = request()->session()->get('user.business_id');
if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'essentials_module'))) {
abort(403, 'Unauthorized action.');
}
if (! auth()->user()->can('essentials.crud_all_leave')) {
abort(403, 'Unauthorized action.');
}
if (request()->ajax()) {
try {
EssentialsLeave::where('business_id', $business_id)->where('id', $id)->delete();
$output = ['success' => true,
'msg' => __('lang_v1.deleted_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;
}
}
public function changeStatus(Request $request)
{
$business_id = request()->session()->get('user.business_id');
if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'essentials_module')) || ! auth()->user()->can('essentials.approve_leave')) {
abort(403, 'Unauthorized action.');
}
try {
$input = $request->only(['status', 'leave_id', 'status_note']);
$leave = EssentialsLeave::where('business_id', $business_id)
->find($input['leave_id']);
$leave->status = $input['status'];
$leave->status_note = $input['status_note'];
$leave->save();
$leave->status = $this->leave_statuses[$leave->status]['name'];
$leave->changed_by = auth()->user()->id;
$leave->user->notify(new LeaveStatusNotification($leave));
$output = ['success' => true,
'msg' => __('lang_v1.updated_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;
}
/**
* Function to show activity log related to a leave
*
* @return Response
*/
public function activity($id)
{
$business_id = request()->session()->get('user.business_id');
if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'essentials_module'))) {
abort(403, 'Unauthorized action.');
}
$leave = EssentialsLeave::where('business_id', $business_id)
->find($id);
$activities = Activity::forSubject($leave)
->with(['causer', 'subject'])
->latest()
->get();
return view('essentials::leave.activity_modal')->with(compact('leave', 'activities'));
}
/**
* Function to get leave summary of a user
*
* @return Response
*/
public function getUserLeaveSummary()
{
$business_id = request()->session()->get('user.business_id');
$is_admin = $this->moduleUtil->is_admin(auth()->user(), $business_id);
$user_id = $is_admin ? request()->input('user_id') : auth()->user()->id;
if (! (auth()->user()->can('superadmin') || $this->moduleUtil->hasThePermissionInSubscription($business_id, 'essentials_module'))) {
abort(403, 'Unauthorized action.');
}
if (empty($user_id)) {
return '';
}
$query = EssentialsLeave::where('business_id', $business_id)
->where('user_id', $user_id)
->with(['leave_type'])
->select(
'status',
'essentials_leave_type_id',
'start_date',
'end_date'
);
if (! empty(request()->start_date) && ! empty(request()->end_date)) {
$start = request()->start_date;
$end = request()->end_date;
$query->whereDate('start_date', '>=', $start)
->whereDate('start_date', '<=', $end);
}
$leaves = $query->get();
$statuses = $this->leave_statuses;
$leaves_summary = [];
$status_summary = [];
foreach ($statuses as $key => $value) {
$status_summary[$key] = 0;
}
foreach ($leaves as $leave) {
$start_date = \Carbon::parse($leave->start_date);
$end_date = \Carbon::parse($leave->end_date);
$diff = $start_date->diffInDays($end_date) + 1;
$leaves_summary[$leave->essentials_leave_type_id][$leave->status] =
isset($leaves_summary[$leave->essentials_leave_type_id][$leave->status]) ?
$leaves_summary[$leave->essentials_leave_type_id][$leave->status] + $diff : $diff;
$status_summary[$leave->status] = isset($status_summary[$leave->status]) ? ($status_summary[$leave->status] + $diff) : $diff;
}
$leave_types = EssentialsLeaveType::where('business_id', $business_id)
->get();
$user = User::where('business_id', $business_id)
->find($user_id);
return view('essentials::leave.user_leave_summary')->with(compact('leaves_summary', 'leave_types', 'statuses', 'user', 'status_summary'));
}
}