HEX
Server: Apache/2.4.46 (Ubuntu)
System: Linux localhost 5.11.0-49-generic #55-Ubuntu SMP Wed Jan 12 17:36:34 UTC 2022 x86_64
User: root (0)
PHP: 7.4.16
Disabled: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
Upload Files
File: /var/www/html/dev-hrms/app/Http/Controllers/GroupController.php
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\EmployeeProfile;
use App\Models\ActualWorkPlace;
use App\Models\AppointmentCategory;
use App\Models\BasicCategory;
use App\Models\Cadre;
use App\Models\Group;
use App\Models\Caste;
use App\Models\Designation;
use App\Models\EmployeeRelation;
use App\Models\Faculty;
use App\Models\Gender;
use App\Models\MaritalStatus;
use App\Models\Appointment;
use App\Models\ParallelReservation;
use App\Models\Religion;
use App\Models\SanctionPost;

use App\Library\UserLib;

class GroupController extends Controller
{
    protected $userLib;
    protected $UserSessionId;
    public function __construct(UserLib $userLib)
    {
        $this->userLib = $userLib;
    }

    
    ### Check Group if Exist
    public function checkGroup(Request $request)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/admin/logout');
        // }
        $Group = $request->input('GroupName');
        $GroupId = $request->input('id');
        $GroupName = Group::where('GroupName', $Group)
            ->orWhere('GroupId', $GroupId)->first();
        if ($GroupName) {
            return response()->json(array("exists" => true));
        } else {
            return response()->json(array("exists" => false));
        }
    }

    ### Store Group
    public function storeGroup(Request $request)
    {
        if (empty(session('UserId'))) {
            return redirect('/admin/logout');
        }
        
        $input = $request->all();
        $data = $input;
        $data['GroupId'] =  $this->userLib->useridGenrator();
        $data['IsDeleted'] = 0;
        $data['Status'] = 1;
        $data['Created_by'] = session('UserId');
        $data['Created_at'] = date('Y-m-d H:i:s', time());
        $data['Updated_by'] = session('UserId');
        $data['Updated_at'] = date('Y-m-d H:i:s', time());

        unset($data['_token']);

        $insert_cadre = Group::insert($data);
        if ($insert_cadre) {
            return response()->json('success');
        } else {
            return response()->json('failed');
        }
    }
    ### Edit Group
    public function editGroup($GroupId)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/admin/logout');
        // }

        $Group = Group::select('tbl_cadre.*')
            ->where('GroupId', $GroupId)
            ->get()->first();
        return response()->json([
            'Status' => 200,
            'Group' => $Group
        ]);
    }

    ### Update Group
    public function updateGroup(Request $request)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/admin/logout');
        // }

        $GroupId = $request->input('GroupId');
        $group_data['GroupName'] = $request->input('GroupName');
        $group_data['Updated_by'] = session('UserId');
        $group_data['Updated_at'] = date('Y-m-d H:i:s', time());

        $update_group = Group::where('GroupId', $GroupId)->update($group_data);
        if ($update_group) {
            return response()->json('success');
        } else {
            return response()->json('failed');
        }
    }

    ### Check Group if Exist in Employee Table
    public function checkEmployeeGroup(Request $request)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/admin/logout');
        // }
        $GroupId = $request->input('GroupId');
        $GetGroup = EmployeeProfile::where('GroupId', $GroupId)
            ->get()
            ->first();

        if ($GetGroup) {
            return response()->json(array("exists" => true));
        } else {
            return response()->json(array("exists" => false));
        }
    }
    #### Delete Group
    public function deleteGroup($GroupId)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/admin/logout');
        // }
        $CreatedDate = date('Y-m-d H:i:s', time());

        $value = array();
        $value['Updated_at'] = $CreatedDate;
        $value['IsDeleted'] = '1';
        $value['Status'] = '0';

        $delete_cadre = Group::where('GroupId', $GroupId)->update($value);
        if ($delete_cadre) {
            return response()->json('status_success');
        } else {
            return response()->json('status_failed');
        }
    }
    #### Restore Group
    public function restoreGroup($GroupId)
    {
        // if (empty($this->UserSessionId)) {
        //     return redirect('/admin/logout');
        // }
        $CreatedDate = date('Y-m-d H:i:s', time());

        $value = array();
        $value['Updated_at'] = $CreatedDate;
        $value['IsDeleted'] = '0';
        $value['Status'] = '1';

        $restore_cadre = Group::where('GroupId', $GroupId)->update($value);
        if ($restore_cadre) {
            return response()->json('status_success');
        } else {
            return response()->json('status_failed');
        }
    }

    #### Delete Permanent Group
    public function destroyGroup($GroupId)
    {
        if (empty($this->UserSessionId)) {
            return redirect('/admin/logout');
        }
        $destroyData = Group::where('GroupId', $GroupId);
        $destroyData->delete();
    }

    #### Change Status Group
    public function changeStatusGroup($GroupId)
    {
        $value = array();
        $data = Group::where('GroupId', $GroupId)->get()->first();
        $Status = $data->Status;

        if ($Status == '1') {
            $value['Status'] = '0';
        } else {
            $value['Status'] = '1';
        }
        $UpdatedDate = date('Y-m-d H:i:s', time());
        $value['Updated_at'] = $UpdatedDate;
        $value['Updated_by'] = session('UserId');
        $change_status_cadre = Group::where('GroupId', $GroupId)->update($value);
        if ($change_status_cadre) {
            return response()->json('status_success');
        } else {
            return response()->json('status_failed');
        }
    }
}