public function run() { DB::table('permission_role')->delete(); /* Permissions::create(['name' => 'article.create' , 'display_name' => 'New Article' , 'description' => 'Create a New Article' ]); Permissions::create(['name' => 'article.edit' , 'display_name' => 'Update Article' , 'description' => 'Update an Article' ]); Permissions::create(['name' => 'inboundOrder.create' , 'display_name' => 'New InboundOrder' , 'description' => 'Create a New Inbound Order' ]); Permissions::create(['name' => 'inboundOrder.edit' , 'display_name' => 'Update InboundOrder' , 'description' => 'Update an Inbound Order' ]); Permissions::create(['name' => 'inboundOrderDetail.create', 'display_name' => 'New InboundOrderDetail' , 'description' => 'Create a New Inbound Order Detail']); Permissions::create(['name' => 'inboundOrderDetail.edit' , 'display_name' => 'Update InboundOrderDetail', 'description' => 'Update an Inbound Order Detail' ]); Permissions::create(['name' => 'inventory.create' , 'display_name' => 'New Inventory' , 'description' => 'Create a New Inventory' ]); Permissions::create(['name' => 'inventory.edit' , 'display_name' => 'Update Inventory' , 'description' => 'Update Inventory' ]); Permissions::create(['name' => 'location.create' , 'display_name' => 'New Location' , 'description' => 'Create a New Location' ]); Permissions::create(['name' => 'location.edit' , 'display_name' => 'Update Location' , 'description' => 'Update a Location' ]); Permissions::create(['name' => 'pallet.create' , 'display_name' => 'New Pallet' , 'description' => 'Create a New Pallet' ]); Permissions::create(['name' => 'pallet.edit' , 'display_name' => 'Update Pallet' , 'description' => 'Update a Pallet' ]); Permissions::create(['name' => 'tote.create' , 'display_name' => 'New Tote' , 'description' => 'Create a New Tote' ]); Permissions::create(['name' => 'tote.edit' , 'display_name' => 'Update Tote' , 'description' => 'Update a Tote' ]); Permissions::create(['name' => 'upc.create' , 'display_name' => 'New UPC' , 'description' => 'Create a New UPC' ]); Permissions::create(['name' => 'upc.edit' , 'display_name' => 'Update UPC' , 'description' => 'Update a UPC' ]); Permissions::create(['name' => 'userActivity.create' , 'display_name' => 'New UserActivity' , 'description' => 'Create a New User Activity' ]); Permissions::create(['name' => 'userActivity.edit' , 'display_name' => 'Update UserActivity' , 'description' => 'Update an User Activity' ]); Role::create(['name' => 'receiver' , 'display_name' => 'Receiver' , 'description' => 'Receiver worker at a rework table' ]); Role::create(['name' => 'putAwayReserve', 'display_name' => 'Put Away to reserve' , 'description' => 'Put Away to reserve locations' ]); Role::create(['name' => 'putAwayPick' , 'display_name' => 'Put Away to pick face' , 'description' => 'Put Away to pick face locations' ]); Role::create(['name' => 'replen' , 'display_name' => 'Replen' , 'description' => 'Move Inventory from reserve to pick face locations']); Role::create(['name' => 'poReconcile' , 'display_name' => 'PO Receipt Reconciliator', 'description' => 'Reconcile Receipt POs variances' ]); Role::create(['name' => 'teamLead' , 'display_name' => 'Shift Team Leader' , 'description' => 'Team Lead for the shift' ]); Role::create(['name' => 'super' , 'display_name' => 'Shift Supervisor' , 'description' => 'Supervising the shift' ]); Role::create(['name' => 'manager' , 'display_name' => 'Shift Manager' , 'description' => 'Managing shift activities' ]); Role::create(['name' => 'admin' , 'display_name' => 'Administrator' , 'description' => 'Administrates users of this application']); Role::create(['name' => 'support' , 'display_name' => 'IT Support' , 'description' => 'IT Support for this application' ]); */ $roles = Role::whereRaw("name in ('receiver', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead', 'super', 'manager', 'support')")->get(); $permissions = Permission::whereRaw("name in ('none')")->get(); foreach ($roles as $role) { foreach ($permissions as $permission) { DB::table('permission_role')->insert(['role_id' => $role->id, 'permission_id' => $permission->id]); } } $roles = Role::whereRaw("name in ('teamLead', 'super', 'manager', 'support')")->get(); $permissions = Permission::whereRaw("name in ('article.create', 'article.edit', 'location.create', 'location.edit', 'pallet.create', 'pallet.edit'\n , 'tote.create', 'tote.edit', 'upc.create', 'upc.edit'\n , 'userActivity.create', 'userActivity.edit')")->get(); foreach ($roles as $role) { foreach ($permissions as $permission) { DB::table('permission_role')->insert(['role_id' => $role->id, 'permission_id' => $permission->id]); } } $roles = Role::whereName('support')->get(); $permissions = Permission::whereRaw("name in ('inboundOrder.create', 'inboundOrder.edit', 'inboundOrderDetail.create', 'inboundOrderDetail.edit'\n , 'inventory.create', 'inventory.edit'\n , 'receiptHistory.create', 'receiptHistory.edit', 'userConversation.create', 'userConversation.edit')")->get(); foreach ($roles as $role) { foreach ($permissions as $permission) { DB::table('permission_role')->insert(['role_id' => $role->id, 'permission_id' => $permission->id]); } } }
public function run() { DB::table('role_user')->delete(); /* Role::create(['name' => 'receipt' , 'display_name' => 'Receiver' , 'description' => 'Receiver worker at a rework table' ]); Role::create(['name' => 'putAwayReserve', 'display_name' => 'Put Away to reserve' , 'description' => 'Put Away to reserve locations' ]); Role::create(['name' => 'putAwayPick' , 'display_name' => 'Put Away to pick face' , 'description' => 'Put Away to pick face locations' ]); Role::create(['name' => 'replen' , 'display_name' => 'Replen' , 'description' => 'Move Inventory from reserve to pick face locations']); Role::create(['name' => 'poReconcile' , 'display_name' => 'PO Receipt Reconciliator', 'description' => 'Reconcile Receipt POs variances' ]); Role::create(['name' => 'teamLead' , 'display_name' => 'Shift Team Leader' , 'description' => 'Team Lead for the shift' ]); Role::create(['name' => 'super' , 'display_name' => 'Shift Supervisor' , 'description' => 'Supervising the shift' ]); Role::create(['name' => 'manager' , 'display_name' => 'Shift Manager' , 'description' => 'Managing shift activities' ]); Role::create(['name' => 'admin' , 'display_name' => 'Administrator' , 'description' => 'Administrates users of this application']); Role::create(['name' => 'support' , 'display_name' => 'IT Support' , 'description' => 'IT Support for this application' ]); User::create(['name' => 'worker' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]); User::create(['name' => 'teamLead' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]); User::create(['name' => 'super' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]); User::create(['name' => 'manager', 'email' => '*****@*****.**', 'password' => Hash::make( 'vital123' )]); User::create(['name' => 'admin' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]); User::create(['name' => 'rbowers', 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]); User::create(['name' => 'pneal' , 'email' => '*****@*****.**' , 'password' => Hash::make( 'vital123' )]); */ $roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen')")->get(); $users = User::whereRaw("name in ('worker')")->get(); foreach ($roles as $role) { foreach ($users as $user) { DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]); } } $roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead')")->get(); $users = User::whereRaw("name in ('teamLead')")->get(); foreach ($roles as $role) { foreach ($users as $user) { DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]); } } $roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead', 'super')")->get(); $users = User::whereRaw("name in ('super')")->get(); foreach ($roles as $role) { foreach ($users as $user) { DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]); } } $roles = Role::whereRaw("name in ('receipt', 'putAwayReserve', 'putAwayPick', 'replen', 'poReconcile', 'teamLead', 'super', 'manager')")->get(); $users = User::whereRaw("name in ('manager', 'rbowers')")->get(); foreach ($roles as $role) { foreach ($users as $user) { DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]); } } $roles = Role::whereName('admin')->get(); $users = User::whereRaw("name in ('admin', 'rbowers')")->get(); foreach ($roles as $role) { foreach ($users as $user) { DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]); } } $roles = Role::get(); $users = User::whereName('pneal')->get(); foreach ($roles as $role) { foreach ($users as $user) { DB::table('role_user')->insert(['role_id' => $role->id, 'user_id' => $user->id]); } } }