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');
}
}
}