File "StaffImport.php"
Full Path: /home/trinadezambia/public_html/admin_panel/app/Imports/StaffImport.php
File size: 9.28 KB
MIME-type: text/x-php
Charset: utf-8
<?php
namespace App\Imports;
use App\Jobs\SendBulkStaffEmail;
use App\Repositories\User\UserInterface;
use App\Services\CachingService;
use App\Services\ResponseService;
use Carbon\Carbon;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Validator;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use App\Repositories\Subscription\SubscriptionInterface;
use App\Models\Role;
use Illuminate\Support\Facades\Hash;
use App\Repositories\Staff\StaffInterface;
use App\Repositories\StaffSupportSchool\StaffSupportSchoolInterface;
use App\Services\SubscriptionService;
use App\Services\UserService;
use App\Repositories\FormField\FormFieldsInterface;
use App\Repositories\ExtraFormField\ExtraFormFieldsInterface;
use Str;
use Throwable;
use TypeError;
class StaffImport implements ToCollection, WithHeadingRow
{
private $roleID;
private $is_send_notification;
public function __construct($roleID, $is_send_notification)
{
$this->roleID = $roleID;
$this->is_send_notification = $is_send_notification;
}
public function collection(Collection $collection)
{
$subscription = app(SubscriptionInterface::class);
$user = app(UserInterface::class);
$cache = app(CachingService::class);
$staff = app(StaffInterface::class);
$staffSupportSchool = app(StaffSupportSchoolInterface::class);
$formFields = app(FormFieldsInterface::class);
$extraFormFields = app(ExtraFormFieldsInterface::class);
$school_id = Auth::user()->school_id;
$validator = Validator::make($collection->toArray(), [
'*.first_name' => 'required',
'*.last_name' => 'required',
'*.mobile' => 'required|numeric|digits_between:1,16',
'*.email' => 'required|email|unique:users,email|distinct',
'*.dob' => 'required|date',
'*.salary' => 'required|numeric',
], [
'*.dob.date' => 'Please ensure that the dob date format you use is either DD-MM-YYYY or MM/DD/YYYY.'
]);
$validator->validate();
if (Auth::user()->school_id) {
$today_date = Carbon::now()->format('Y-m-d');
$subscription = $subscription->builder()->doesntHave('subscription_bill')->whereDate('start_date', '<=', $today_date)->where('end_date', '>=', $today_date)->whereHas('package', function ($q) {
$q->where('is_trial', 1);
})->first();
if ($subscription) {
$systemSettings = $cache->getSystemSettings();
$staff_count = $user->builder()->role('Teacher')->withTrashed()->orWhereHas('roles', function ($q) {
$q->where('custom_role', 1)->whereNot('name', 'Teacher');
})->whereNotNull('school_id')->Owner()->count();
if ($staff_count >= $systemSettings['staff_limit']) {
$message = "The free trial allows only " . $systemSettings['staff_limit'] . " staff.";
ResponseService::errorResponse($message);
}
}
}
$defaultSessionYear = $cache->getDefaultSessionYear();
DB::beginTransaction();
$data = []; // Initialize array for staff support school data
foreach ($collection as $row) {
try {
$role = Role::findOrFail($this->roleID);
$row = $row->toArray();
// Find the index of the key after which to split the array to get extra details
$splitIndex = array_search('salary', array_keys($row)) + 1;
// Get The Extra Details fields if they exist
$extraDetailsFields = array_slice($row, $splitIndex);
$existingUser = $user->builder()->where('email', $row['email'])->first();
$id = $existingUser ? $existingUser->id : null;
$users = $user->updateOrCreate(['id' => $id], [
'first_name' => $row['first_name'],
'last_name' => $row['last_name'],
'mobile' => $row['mobile'],
'email' => $row['email'],
'dob' => date('Y-m-d', strtotime($row['dob'])),
'password' => Hash::make($row['mobile']),
'status' => 0,
'two_factor_enabled' => 0,
'two_factor_secret' => null,
'two_factor_expires_at' => null,
'deleted_at' => '1970-01-01 01:00:00'
]);
$users->assignRole($role);
if ($users->school_id) {
$leave_permission = [
'leave-list',
'leave-create',
'leave-edit',
'leave-delete',
];
$users->givePermissionTo($leave_permission);
}
$staff->updateOrCreate(['user_id' => $users->id], [
'user_id' => $users->id,
'qualification' => null,
'salary' => $row['salary'] ?? 0,
'joining_date' => isset($row['joining_date']) ? date('Y-m-d', strtotime($row['joining_date'])) : null,
'join_session_year_id' => $defaultSessionYear->id
]);
// Initialize extraDetails array
$extraDetails = array();
// Check that Extra Details Exists
if (!empty($extraDetailsFields)) {
$extraFieldName = array_map(static function ($d) {
return str_replace("_", " ", $d);
}, array_keys($extraDetailsFields));
$formFieldsCollection = $formFields->builder()->whereIn('name', $extraFieldName)->get();
$extraFieldValidationRules = [];
foreach ($formFieldsCollection as $field) {
if ($field->is_required) {
$name = strtolower(str_replace(' ', '_', $field->name));
$extraFieldValidationRules[$name] = 'required';
}
}
$extraFieldValidator = Validator::make($row, $extraFieldValidationRules);
$extraFieldValidator->validate();
// Create Extra Details Array for Staff's Extra Form Details
foreach ($extraDetailsFields as $key => $value) {
$formField = $formFieldsCollection->first(function ($data) use ($key) {
return strtolower($data->name) === str_replace("_", " ", strtolower($key));
});
if (!empty($formField)) {
// if Form Field is checkbox then make data in json format
$fieldData = $formField->type == 'checkbox' ? explode(',', $value) : $value;
$extraDetails[] = array(
'user_id' => $users->id,
'form_field_id' => $formField->id,
'data' => (is_array($fieldData)) ? json_encode($fieldData, JSON_THROW_ON_ERROR) : $fieldData,
'school_id' => Auth::user()->school_id ?? null
);
}
}
// Make File Input Array to Store the Null Values
$getFileExtraField = $formFields->builder()->where('type', 'file')->get();
foreach ($getFileExtraField as $value) {
$extraDetails[] = array(
'user_id' => $users->id,
'form_field_id' => $value->id,
'data' => NULL,
'school_id' => Auth::user()->school_id ?? null
);
}
}
// Save extra details to database
if (!empty($extraDetails)) {
$extraFormFields->createBulk($extraDetails);
}
if ($school_id) {
$data[] = array(
'user_id' => $users->id,
'school_id' => $school_id
);
// $staffSupportSchool->upsert($data, ['user_id', 'school_id'], ['user_id', 'school_id']);
}
if ($users->school_id) {
$sendEmail = app(UserService::class);
if ($this->is_send_notification) {
SendBulkStaffEmail::dispatch(Auth::user()->school_id, $users->id);
}
}
} catch (Throwable $e) {
// IF Exception is TypeError and message contains Mail keywords then email is not sent successfully
if (Str::contains($e->getMessage(), ['Failed', 'Mail', 'Mailer', 'MailManager'])) {
DB::commit();
continue;
}
DB::rollBack();
throw $e;
}
}
DB::commit();
return true;
}
}