/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
$new_permissions = array('can_edit_newsletter', 'can_add_newsletter', 'can_delete_newsletter', 'can_view_newsletter');
$roles = Role::whereIn('name', array('admin', 'manager'))->get();
$permissions = Permission::whereIn('name', $new_permissions)->get();
$permission_ids = $permissions->lists('id');
// First detach the permissions from the roles
foreach ($roles as $role) {
$role->detachPermissions($permission_ids);
}
// Now delete the permission altogether
foreach ($permissions as $permission) {
$permission->delete();
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$date = new \DateTime();
$date->modify('+3 days');
$formatted_date_from = $date->format('Y-m-d');
$date->modify('+6 days');
$formatted_date_to = $date->format('Y-m-d');
$dates = createDateRangeArray(strtotime($formatted_date_from), strtotime($formatted_date_to));
$bases = Base::where('center', 1)->get();
$current_gen = Gen::getCurrentGen();
$shiftSessions = ShiftSession::where('active', 1)->get();
$lastShift = Shift::where('gen_id', $current_gen->id)->orderBy('week', 'desc')->first();
$week = $lastShift ? $lastShift->week : 0;
foreach ($dates as $date) {
foreach ($bases as $base) {
foreach ($shiftSessions as $shiftSession) {
$shift = new Shift();
$shift->gen_id = $current_gen->id;
$shift->base_id = $base->id;
$shift->shift_session_id = $shiftSession->id;
$shift->week = $week + 1;
$shift->date = $date;
$shift->save();
}
}
}
$role_ids = Tab::find(35)->roles->pluck('id')->unique()->toArray();
$roles = Role::whereIn('id', $role_ids)->get();
if ($week == 0) {
$week = 1;
}
foreach ($roles as $role) {
$users = $role->users;
foreach ($users as $user) {
send_mail_regis_shift($user, $week, $current_gen, ['*****@*****.**']);
}
}
$this->info('done');
}
public function deleteByIds($ids)
{
$result = Role::whereIn('id', $ids)->delete();
return $result;
}