/**
* 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));
}
