public function run()
{
DB::table('permissions')->delete();
/*
* select * from permissions;
+----+---------------------------+---------------------------+---------------------------------------------+---------------------+---------------------+
| id | name | display_name | description | created_at | updated_at |
+----+---------------------------+---------------------------+---------------------------------------------+---------------------+---------------------+
| 1 | inboundOrder.index | InboundOrder List | Filtered List of Inbound Orders | 2015-02-19 12:49:53 | 2015-02-19 12:49:53 |
| 2 | inboundOrder.show | InboundOrder Show | Display the Inbound Order screen | 2015-02-19 12:51:25 | 2015-02-19 12:51:25 |
| 3 | inboundOrder.create | New InboundOrder | Create a New Inbound Order | 2015-02-19 12:52:09 | 2015-02-19 12:52:09 |
| 4 | inboundOrder.edit | Update InboundOrder | Update an Inbound Order field values | 2015-02-19 12:52:44 | 2015-02-19 12:52:44 |
| 5 | inboundOrderDetail.index | InboundOrderDetail List | Filtered List of Inbound Order Details | 2015-02-19 21:58:29 | 2015-02-19 21:58:29 |
| 6 | inboundOrderDetail.show | InboundOrderDetail Show | Display the Inbound Order Detail screen | 2015-02-19 21:59:18 | 2015-02-19 21:59:18 |
| 7 | inboundOrderDetail.create | New InboundOrderDetail | Create a New Inbound Order Detail | 2015-02-19 22:00:00 | 2015-02-19 22:00:00 |
| 8 | inboundOrderDetail.edit | Update InboundOrderDetail | Update an Inbound Order Detail field values | 2015-02-19 22:00:49 | 2015-02-19 22:00:49 |
| 9 | article.index | Article List | Filtered List of Articles | 2015-02-19 22:03:57 | 2015-02-19 22:03:57 |
| 10 | article.show | Article Show | Display the Article screen | 2015-02-19 22:04:47 | 2015-02-19 22:04:47 |
| 11 | article.create | New Article | Create a New Article | 2015-02-19 22:05:27 | 2015-02-19 22:05:27 |
| 12 | article.edit | Update Article | Update an Article field values | 2015-02-19 22:06:02 | 2015-02-19 22:06:02 |
| 13 | upc.index | UPC List | Filtered List of UPCs | 2015-02-19 22:09:54 | 2015-02-19 22:09:54 |
| 14 | upc.show | UPC Show | Display the UPC screen | 2015-02-19 22:10:51 | 2015-02-19 22:10:51 |
| 15 | upc.create | New UPC | Create a New UPC | 2015-02-19 22:11:34 | 2015-02-19 22:11:34 |
| 16 | upc.edit | Update UPC | Update a UPC field values | 2015-02-19 22:12:13 | 2015-02-19 22:12:13 |
| 17 | userActivity.create | New UserActivity | Create a new User Activity | 2015-03-05 11:08:45 | 2015-03-05 11:08:45 |
| 18 | userActivity.edit | Update UserActivity | Update a User Activity field values | 2015-03-05 11:09:23 | 2015-03-05 11:09:23 |
| 19 | inventory.create | New Inventory | Create a new Inventory | 2015-03-13 22:50:49 | 2015-03-13 22:50:49 |
| 20 | inventory.edit | Update Inventory | Update a Inventory field values | 2015-03-13 22:50:49 | 2015-03-13 22:50:49 |
| 21 | tote.create | New Tote | Create a new Tote | 2015-03-15 21:18:07 | 2015-03-15 21:18:07 |
| 22 | tote.edit | Update Tote | Update a Tote field values | 2015-03-15 21:18:15 | 2015-03-15 21:18:15 |
| 23 | pallet.create | New Pallet | Create a new Pallet | 2015-03-15 23:34:51 | 2015-03-15 23:34:51 |
| 24 | pallet.edit | Update Pallet | Update a Pallet field values | 2015-03-15 23:34:53 | 2015-03-15 23:34:53 |
| 25 | location.create | New Location | Create a new Location | 2015-03-16 14:24:36 | 2015-03-16 14:24:36 |
| 26 | location.edit | Update Location | Update a Location field values | 2015-03-16 14:24:38 | 2015-03-16 14:24:38 |
+----+---------------------------+---------------------------+---------------------------------------------+---------------------+---------------------+
*/
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' => 'receive', 'display_name' => 'Receive', 'description' => 'Receive UPCs and Articles']);
Permissions::create(['name' => 'receiptHistory.create', 'display_name' => 'New Receipt History', 'description' => 'Create a New Receipt History']);
Permissions::create(['name' => 'receiptHistory.edit', 'display_name' => 'Update Receipt History', 'description' => 'Update a Receipt History']);
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']);
Permissions::create(['name' => 'userConversation.create', 'display_name' => 'New UserConversation', 'description' => 'Create a New User Conversation']);
Permissions::create(['name' => 'userConversation.edit', 'display_name' => 'Update UserConversation', 'description' => 'Update an User Conversation']);
}
/**
* Update the model in the database.
*
* @param array $attributes
* @return bool|int
*/
public function update(array $attributes = [])
{
if (!parent::update($attributes)) {
throw new Exception('Cannot update permission.');
// @codeCoverageIgnore
}
return $this->fresh();
}
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 static function boot()
{
parent::boot();
self::observe(new BaseObservers());
}
/**
* Mantém a compatibilidade com snake_case ao definir atributos
*
* @param string $key
* @param mixed $value
*
* @return $this|void
*/
public function setAttribute($key, $value)
{
$key = snake_case($key);
return parent::setAttribute($key, $value);
}