SQLSTATE[42S22]: Column not found: 1054 Unknown column 'roles_id' in 'field list' (SQL: insert into permissions (roles_id, user_management_modules, hr_management_modules, finance_modules, calender_modules, configuration_modules, address_modules, vehicles_modules, user_management_read, user_management_write, user_management_create, user_management_delete, user_management_import, user_management_export, hr_management_read, hr_management_write, hr_management_create, hr_management_delete, hr_management_import, hr_management_export, finance_read, finance_write, finance_create, finance_delete, finance_import, finance_export, calender_read, calender_write, calender_create, calender_delete, calender_import, calender_export, configurations_read, configurations_write, configurations_create, configurations_delete, configurations_import, configurations_export, address_read, address_write, address_create, address_delete, address_import, address_export, vehicles_read, vehicles_write, vehicles_create, vehicles_delete, vehicles_import, vehicles_export, updated_at, created_at) values (12, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2018-04-12 16:09:30, 2018-04-12 16:09:30))
Controller.php
public function givepermission(Request $request){
$roles_id=$request->roles_id;
$user_management = Input::get('user_management') == 'on' ? 1 : 0;
// dd($role_id);
$hr_management = Input::get('hr_management') == 'on' ? 1 : 0;
$finance = Input::get('finance') == 'on' ? 1 : 0;
$calender = Input::get('calender') == 'on' ? 1 : 0;
$configurations = Input::get('configurations') == 'on' ? 1 : 0;
$address = Input::get('address') == 'on' ? 1 : 0;
$vehicles = Input::get('vehicles') == 'on' ? 1 : 0;
$user_management_read = Input::get('user_management_read') == 'on' ? 1 : 0;
$user_management_write = Input::get('user_management_write') == 'on' ? 1 : 0;
$user_management_create = Input::get('user_management_create') == 'on' ? 1 : 0;
$user_management_delete = Input::get('user_management_delete') == 'on' ? 1 : 0;
$user_management_import = Input::get('user_management_import') == 'on' ? 1 : 0;
$user_management_export = Input::get('user_management_export') == 'on' ? 1 : 0;
$hr_management_read = Input::get('hr_management_read') == 'on' ? 1 : 0;
$hr_management_write = Input::get('hr_management_write') == 'on' ? 1 : 0;
$hr_management_create = Input::get('hr_management_create') == 'on' ? 1 : 0;
$hr_management_delete = Input::get('hr_management_delete') == 'on' ? 1 : 0;
$hr_management_import = Input::get('hr_management_import') == 'on' ? 1 : 0;
$hr_management_export = Input::get('hr_management_export') == 'on' ? 1 : 0;
$finance_read = Input::get('finance_read') == 'on' ? 1 : 0;
$finance_write = Input::get('finance_write') == 'on' ? 1 : 0;
$finance_create = Input::get('finance_create') == 'on' ? 1 : 0;
$finance_delete = Input::get('finance_delete') == 'on' ? 1 : 0;
$finance_import = Input::get('finance_import') == 'on' ? 1 : 0;
$finance_export = Input::get('finance_export') == 'on' ? 1 : 0;
$calender_read = Input::get('calender_read') == 'on' ? 1 : 0;
$calender_write = Input::get('calender_write') == 'on' ? 1 : 0;
$calender_create = Input::get('calender_create') == 'on' ? 1 : 0;
$calender_delete = Input::get('calender_delete') == 'on' ? 1 : 0;
$calender_import = Input::get('calender_import') == 'on' ? 1 : 0;
$calender_export = Input::get('calender_export') == 'on' ? 1 : 0;
$configurations_read = Input::get('configurations_read') == 'on' ? 1 : 0;
$configurations_write = Input::get('configurations_write') == 'on' ? 1 : 0;
$configurations_create = Input::get('configurations_create') == 'on' ? 1 : 0;
$configurations_delete = Input::get('configurations_delete') == 'on' ? 1 : 0;
$configurations_import = Input::get('configurations_import') == 'on' ? 1 : 0;
$configurations_export = Input::get('configurations_export') == 'on' ? 1 : 0;
$address_read = Input::get('address_read') == 'on' ? 1 : 0;
$address_write = Input::get('address_write') == 'on' ? 1 : 0;
$address_create = Input::get('address_create') == 'on' ? 1 : 0;
$address_delete = Input::get('address_delete') == 'on' ? 1 : 0;
$address_import = Input::get('address_import') == 'on' ? 1 : 0;
$address_export = Input::get('address_export') == 'on' ? 1 : 0;
$vehicles_read = Input::get('vehicles_read') == 'on' ? 1 : 0;
$vehicles_write = Input::get('vehicles_write') == 'on' ? 1 : 0;
$vehicles_create = Input::get('vehicles_create') == 'on' ? 1 : 0;
$vehicles_delete = Input::get('vehicles_delete') == 'on' ? 1 : 0;
$vehicles_import = Input::get('vehicles_import') == 'on' ? 1 : 0;
$vehicles_export = Input::get('vehicles_export') == 'on' ? 1 : 0;
$createPermissionValues2 = array(
'roles_id' => $roles_id,
'user_management_modules'=>$user_management,
'hr_management_modules'=>$hr_management,
'finance_modules'=>$finance,
'calender_modules'=>$calender,
'configuration_modules'=>$configurations,
'address_modules'=>$address,
'vehicles_modules'=>$vehicles,
'user_management_read'=>$user_management_read,
'user_management_write'=>$user_management_write,
'user_management_create'=>$user_management_create,
'user_management_delete'=>$user_management_delete,
'user_management_import'=>$user_management_import,
'user_management_export'=>$user_management_export,
'hr_management_read'=>$hr_management_read,
'hr_management_write'=>$hr_management_write,
'hr_management_create'=>$hr_management_create,
'hr_management_delete'=>$hr_management_delete,
'hr_management_import'=>$hr_management_import,
'hr_management_export'=>$hr_management_export,
'finance_read'=>$finance_read,
'finance_write'=>$finance_write,
'finance_create'=>$finance_create,
'finance_delete'=>$finance_delete,
'finance_import'=>$finance_import,
'finance_export'=>$finance_export,
'calender_read'=>$calender_read,
'calender_write'=>$calender_write,
'calender_create'=>$calender_create,
'calender_delete'=>$calender_delete,
'calender_import'=>$calender_import,
'calender_export'=>$calender_export,
'configurations_read'=>$configurations_read,
'configurations_write'=>$configurations_write,
'configurations_create'=>$configurations_create,
'configurations_delete'=>$configurations_delete,
'configurations_import'=>$configurations_import,
'configurations_export'=>$configurations_export,
'address_read'=>$address_read,
'address_write'=>$address_write,
'address_create'=>$address_create,
'address_delete'=>$address_delete,
'address_import'=>$address_import,
'address_export'=>$address_export,
'vehicles_read'=>$vehicles_read,
'vehicles_write'=>$vehicles_write,
'vehicles_create'=>$vehicles_create,
'vehicles_delete'=>$vehicles_delete,
'vehicles_import'=>$vehicles_import,
'vehicles_export'=>$vehicles_export,
);
Permission::create($createPermissionValues2);
}
Model.php
class Permission extends Model
{
protected $table = 'role_permission';
protected $timestamps=false;
protected $fillable=['id','roles_id','user_management_modules','hr_management_modules','finance_modules','calender_modules',
'configuration_modules','address_modules','vehicles_modules','user_management_read','user_management_write','user_management_create',
'user_management_delete','user_management_import','user_management_export','hr_management_read','hr_management_write',
'hr_management_create','hr_management_delete','hr_management_import','hr_management_export','finance_read','finance_write',
'finance_create','finance_delete','finance_import','finance_export','calender_read','calender_write','calender_create','calender_delete',
'calender_import','calender_export','configurations_read','configurations_write','configurations_create','configurations_delete',
'configurations_import','configurations_export','address_read','address_write','address_create','address_delete','address_import',
'address_export','vehicles_read','vehicles_write','vehicles_create','vehicles_delete','vehicles_import','vehicles_export'];
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire