public function __invoke(array $input)
{
$userId = $input['userId'];
$startTime = null;
$endTime = null;
$withContactDetails = false;
// make sure that employees are not accessing information for another employee
if (Auth::isEmployee() && Auth::getId() != $userId) {
return InvalidPayload::create('You can only access your own shifts');
}
if (!empty($input['startTime'])) {
$startTime = urldecode($input['startTime']);
}
if (!empty($input['endTime'])) {
$endTime = urldecode($input['endTime']);
}
$Employee = new Employee();
$Manager = new Manager();
// Attempt to load employee
if ($Employee->load($userId)) {
$User = $Employee;
$withContactDetails = isset($_GET['manager']) ? true : false;
} elseif ($Manager->load($userId)) {
$User = $Manager;
$withContactDetails = isset($_GET['employee']) ? true : false;
} else {
return ErrorPayload::create('User not found');
}
$shifts = $User->shifts($startTime, $endTime, $withContactDetails);
if (count($shifts)) {
return SuccessPayload::create($shifts);
} else {
return ErrorPayload::create('No shifts found');
}
}
public function __invoke(array $input)
{
// down
DatabaseManager::schema()->dropIfExists('users');
DatabaseManager::schema()->dropIfExists('shifts');
// up
DatabaseManager::schema()->create('users', function ($table) {
$table->increments('id');
$table->string('name');
$table->enum('role', array('employee', 'manager'));
$table->string('email');
$table->string('phone');
$table->timestamps();
});
// up
DatabaseManager::schema()->create('shifts', function ($table) {
$table->increments('id');
$table->unsignedInteger('manager_id')->nullable();
$table->foreign('manager_id')->references('id')->on('users')->onDelete('set null');
$table->unsignedInteger('employee_id')->nullable();
$table->foreign('employee_id')->references('id')->on('users')->onDelete('set null');
$table->decimal('break', 5, 2);
$table->dateTime('start_time');
$table->dateTime('end_time');
$table->timestamps();
});
// seed database
// create employees
$Employees = [];
$Employees[] = Employee::create(['name' => 'John Doe', 'email' => '*****@*****.**', 'phone' => '123-123-1234']);
$Employees[] = Employee::create(['name' => 'Bob Jones', 'email' => '*****@*****.**', 'phone' => '234-234-1234']);
$Employees[] = Employee::create(['name' => 'Jill Thompson', 'email' => '*****@*****.**', 'phone' => '345-345-1234']);
// create managers
$Managers = [];
$Managers[] = Manager::create(['name' => 'Nathan Mickler', 'email' => '*****@*****.**', 'phone' => '456-456-4567']);
$Managers[] = Manager::create(['name' => 'Elizabeth Jackson', 'email' => '*****@*****.**', 'phone' => '567-567-4567']);
// create four overlapping shifts
$Date = Carbon::createFromFormat('Y-m-d H:i:s', '2015-09-05 00:00:00');
$Shift = Shift::create(['break' => 1, 'start_time' => $Date->copy()->addHours(8)->format('Y-m-d H:i:s'), 'end_time' => $Date->copy()->addHours(17)->format('Y-m-d H:i:s')]);
// assign manager
$Shift->assign($Managers[0]);
$Shift->assign($Employees[0]);
// shift #2
$Date = Carbon::createFromFormat('Y-m-d H:i:s', '2015-09-05 00:00:00');
$Shift = Shift::create(['break' => 1, 'start_time' => $Date->copy()->addHours(5)->format('Y-m-d H:i:s'), 'end_time' => $Date->copy()->addHours(9)->format('Y-m-d H:i:s')]);
// assign manager
$Shift->assign($Managers[0]);
$Shift->assign($Employees[1]);
// shift #3
$Date = Carbon::createFromFormat('Y-m-d H:i:s', '2015-09-05 00:00:00');
$Shift = Shift::create(['break' => 1, 'start_time' => $Date->copy()->addHours(12)->format('Y-m-d H:i:s'), 'end_time' => $Date->copy()->addHours(19)->format('Y-m-d H:i:s')]);
// assign manager
$Shift->assign($Managers[0]);
$Shift->assign($Employees[1]);
// shift #4
$Date = Carbon::createFromFormat('Y-m-d H:i:s', '2015-09-05 00:00:00');
$Shift = Shift::create(['break' => 1, 'start_time' => $Date->copy()->addHours(10)->format('Y-m-d H:i:s'), 'end_time' => $Date->copy()->addHours(15)->format('Y-m-d H:i:s')]);
// assign manager
$Shift->assign($Managers[0]);
$Shift->assign($Employees[2]);
// create random shifts (with random employees and managers)
$Date = Carbon::createFromFormat('Y-m-d H:i:s', '2015-09-07 00:00:00');
for ($days = 0; $days < 28; $days++) {
$Shift = Shift::create(['break' => 1, 'start_time' => $Date->copy()->addDays($days)->addHours(8)->format('Y-m-d H:i:s'), 'end_time' => $Date->copy()->addDays($days)->addHours(17)->format('Y-m-d H:i:s')]);
// assign manager
$Shift->assign($Managers[rand(0, 1)]);
$Shift->assign($Employees[rand(0, 2)]);
}
return SuccessPayload::create(['message' => 'Database Initialized']);
}
public function __invoke(array $input)
{
$employeeId = $input['employeeId'];
$managerId = null;
$break = empty($input['break'] ? 0 : $input['break']);
$startTime = null;
$endTime = null;
// Validate the startTime and endTime variables
if (empty($input['startTime']) || empty($input['endTime'])) {
return InvalidPayload::create('Missing required inputs (startTime and endTime are required');
} else {
$startTime = Carbon::createFromFormat('Y-m-d H:i:s', urldecode($input['startTime']));
$endTime = Carbon::createFromFormat('Y-m-d H:i:s', urldecode($input['endTime']));
}
// validation for start and end times
$error_message = null;
if ($startTime > $endTime) {
$error_message = "startTime must be before endTime";
} elseif ($startTime->diffInHours($endTime) > 24) {
$error_message = "startTime and endTime can not differ by more than 24 hours";
}
if ($error_message) {
return ErrorPayload::create($error_message);
}
// validation for employeeId
$employeeId = null;
if (!empty($input['employeeId'])) {
$employeeId = $input['employeeId'];
// Make sure this is a valid employee
$Employee = new Employee();
if (!$Employee->load($employeeId)) {
return ErrorPayload::create('Employee not found');
} else {
// make sure this employee doesn't have any overlapping shifts that would conflict...
$filters = [];
$filters[] = ['key' => 'employee_id', 'value' => $employeeId];
$Shift = new Shift();
if ($Shifts = $Shift->filter($startTime, $endTime, $filters)) {
foreach ($Shifts as $checkShift) {
if (count($Shifts)) {
return ErrorPayload::create('Creating this shift for this employee would result in overlapping shifts for this employee');
}
}
}
}
}
$managerId = null;
if (!empty($input['managerId'])) {
$managerId = $input['managerId'];
} else {
// NOTE: This would pull the actual managerId in the live application (set self to default if no managerId provided)
// here we are simply going to assume that it is manager 4 since there isn't a login in this sample project
$managerId = Auth::getId();
}
// Make sure this is a valid employee
$Manager = new Manager();
if (!$Manager->load($managerId)) {
return ErrorPayload::create('Manager not found');
}
try {
Shift::create(['manager_id' => $managerId, 'employee_id' => $employeeId, 'break' => $break, 'start_time' => $startTime, 'end_time' => $endTime]);
return SuccessPayload::create(['message' => 'Shift created successfully']);
} catch (\Exception $e) {
return ErrorPayload::create('There was an error creating this shift');
}
}