/** * Save Group Permission into acl_group_permissions */ public static function saveGroupPermission($groupId, $data = array()) { GroupPermissions::where('group_id', '=', $groupId)->delete(); foreach ($data as $val) { $userPermission = UserPermissions::where('permission_id', $val)->find($val); if (!empty($userPermission)) { echo '<pre />'; print_r($userPermission); exit; } $group_permission = new GroupPermissions(); $group_permission->permission_id = $val; $group_permission->group_id = $groupId; $group_permission->value = 1; $group_permission->date_created = new DateTime(); $group_permission->save(); } }
public function run() { DB::table('acl_group_permissions')->truncate(); DB::table('acl_groups')->truncate(); $groups = array(array('name' => 'Super Admin', 'description' => 'Super Admin Account', 'date_created' => new DateTime()), array('name' => 'Admin', 'description' => 'Admin Account', 'date_created' => new DateTime())); DB::table('acl_groups')->insert($groups); $permission = Permission::all(); $grouplist = Group::all(); foreach ($grouplist as $group) { foreach ($permission as $row) { $group_permission = new GroupPermissions(); $group_permission->permission_id = $row->id; $group_permission->group_id = $group->id; $group_permission->save(); } } $operator = array(array('name' => 'Operator', 'description' => 'Operator Account', 'date_created' => new DateTime())); DB::table('acl_groups')->insert($operator); $player = array(array('name' => 'Player', 'description' => 'Player Account', 'date_created' => new DateTime())); DB::table('acl_groups')->insert($player); $this->command->info('Group table seeded!'); }
/** * Manages all models. */ public function actionPermission($id) { $modulesObj = Modules::model(); $allModules = $modulesObj->getCommandBuilder()->createFindCommand($modulesObj->tableSchema, $modulesObj->dbCriteria)->queryAll(); $model = new GroupPermissions(); if (isset($_POST['GroupPermissions'])) { $model->deleteAll('fk_group =' . $id); foreach ($_POST['GroupPermissions'] as $post) { $post['fk_group'] = $id; $model = new GroupPermissions(); $model->attributes = $post; $model->save(); } $this->addMessage('Record updated successfully.'); $this->redirect(array('viewGroup')); } $tempDataModel = GroupPermissions::model()->findAll('fk_group =' . $id); $dataModel = array(); foreach ($tempDataModel as $tempModel) { $dataModel[$tempModel->fk_module] = $tempModel; } $this->render('permissionUpdate', array('allModules' => $allModules, 'model' => $model, 'fk_group' => $id, 'models' => $dataModel)); }