public function search()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.id as users', 'roles.created_at'));
return Datatables::of($roles)->edit_column('users', '{{{ DB::table(\'assigned_roles\')->where(\'role_id\', \'=\', $id)->count() }}}')->add_column('actions', '<a href="javascript:void(0)" id="role_edit" role_id="{{{ $id }}}" class="btn_table btn btn-info"><i class="fa fa-share-square-o"></i> Edit</a>
<a href="javascript:void(0)" id="role_delete" role_id="{{{ $id }}}" class="btn_table btn btn-danger"><i class="fa fa-trash-o"></i> Delete</a>
')->remove_column('id')->make();
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
// Title
$title = Lang::get('admin/roles/title.role_management');
$roles = Role::select(array('roles.id', 'roles.name', 'roles.id as users', 'roles.created_at'))->get();
// Show the page
$this->render('admin.roles/.index', compact('roles', 'title'));
}
public function run()
{
DB::table('users')->delete();
User::create(array('name' => 'Kristijan', 'lozinka' => Hash::make('kristijan'), 'role_id' => Role::select('id')->where('ime', '=', 'Administrator')->first()->id));
User::create(array('name' => 'Andrija', 'lozinka' => Hash::make('andrija'), 'role_id' => Role::select('id')->where('ime', '=', 'Asistent')->first()->id));
User::create(array('name' => 'Hrvoje', 'lozinka' => Hash::make('hrvoje'), 'role_id' => Role::select('id')->where('ime', '=', 'Instruktor')->first()->id));
User::create(array('name' => 'Antun', 'lozinka' => Hash::make('antun'), 'role_id' => Role::select('id')->where('ime', '=', 'Voditelj tečaja')->first()->id));
}
public function tablaRolesPermiso()
{
$id = Input::get("id");
$roles = Role::select("id", "name")->orderBy("id")->get();
$permisos = PermissionRole::where("role_id", "=", $id)->select("id", "state")->orderBy("id")->get();
$html = View::make("dashboard.roles.rolesTablaPermisos")->with(array("roles" => $roles, "permisos" => $permisos, "role" => Input::get("role"), "id" => $id));
$datos = (string) $html;
return Response::json(array("datos" => $datos));
}
public function listRole()
{
if (!Request::ajax()) {
return App::abort(404);
}
$start = Input::has('start') ? (int) Input::get('start') : 0;
$length = Input::has('length') ? Input::get('length') : 10;
$search = Input::has('search') ? Input::get('search') : [];
$roles = Role::select('id', 'name');
if (!empty($search)) {
foreach ($search as $key => $value) {
if (empty($value)) {
continue;
}
$value = ltrim(rtrim($value));
$roles->where($key, 'like', '%' . $value . '%');
}
}
$order = Input::has('order') ? Input::get('order') : [];
if (!empty($order)) {
$columns = Input::has('columns') ? Input::get('columns') : [];
foreach ($order as $value) {
$column = $value['column'];
if (!isset($columns[$column]['name']) || empty($columns[$column]['name'])) {
continue;
}
$roles->orderBy($columns[$column]['name'], $value['dir'] == 'asc' ? 'asc' : 'desc');
}
}
$count = $roles->count();
if ($length > 0) {
$roles = $roles->skip($start)->take($length);
}
$arrRoles = $roles->get()->toArray();
$arrReturn = ['draw' => Input::has('draw') ? Input::get('draw') : 1, 'recordsTotal' => Role::count(), 'recordsFiltered' => $count, 'data' => []];
if (!empty($arrRoles)) {
foreach ($arrRoles as $role) {
$arrReturn['data'][] = array(++$start, $role['id'], $role['name']);
}
}
$response = Response::json($arrReturn);
$response->header('Content-Type', 'application/json');
return $response;
}
public function indexAction()
{
$request = $this->getRequest();
$model = new Role();
$searchForm = new Logic_Role_Form_Filter();
$this->view->form = $searchForm;
$filter = $request->getParam('filter_is_deleted', false);
$ghost = "false";
if ($filter) {
$searchForm->getElement('filter_is_active')->setChecked(false);
$searchForm->getElement('filter_is_deleted')->setChecked(true);
$ghost = "true";
}
$select = $model->select()->from('role')->where('ghost = ' . $ghost);
$page = $request->getParam('page', 1);
$sort = $request->getParam('sort', 'id');
$order = $request->getParam('order', 'asc');
$select->order($sort . ' ' . $order);
$paginator = new Base_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->headers = array('role_name');
$this->view->headScript()->appendFile('/static/js/filtr_active.js');
}
/**
* Show a list of all the roles formatted for Datatables.
*
* @return Datatables JSON
*/
public function getData()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.id as users', 'roles.created_at'));
return Datatables::of($roles)->edit_column('users', '{{{ DB::table(\'assigned_roles\')->where(\'role_id\', \'=\', $id)->count() }}}')->add_column('actions', '<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-default">{{{ Lang::get(\'button.edit\') }}}</a>
<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/delete\' ) }}}" class="iframe btn btn-xs btn-danger">{{{ Lang::get(\'button.delete\') }}}</a>
')->remove_column('id')->make();
}
/**
* Show a list of all the roles formatted for Datatables.
*
* @return Datatables JSON
*/
public function getData()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.id as users', 'roles.created_at', 'roles.updated_at'));
return Datatables::of($roles)->edit_column('created_at', '{{ $created_at->format("Y-m-d h:i:s") }}')->edit_column('updated_at', '{{ $updated_at->format("Y-m-d h:i:s") }}')->edit_column('users', '<span class="label label-success">{{{ DB::table(\'assigned_roles\')->where(\'role_id\', \'=\', $id)->count() }}}</span>')->add_column('actions', '
<div class="btn-group">
<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-primary"><i class="fa fa-pencil"></i> {{ Lang::get("button.edit") }}</a>
@if (!in_array($name, [\'admin\',\'comment\']))
<a href="{{{ URL::to(\'admin/roles/\' . $id . \'/delete\' ) }}}" class="iframe btn btn-xs btn-danger"><i class="fa fa-trash-o"></i> {{ Lang::get("button.delete") }}</a>
@endif
</div>
')->remove_column('id')->remove_column('rn')->make();
}
/**
* Show a list of all the roles formatted for Datatables.
*
* @return Datatables JSON
*/
public function getData()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.id as users', 'roles.created_at'));
if (Api::Enabled()) {
$u = $roles->get();
return Api::make($u->toArray());
} else {
return Datatables::of($roles)->edit_column('users', '{{{ DB::table(\'assigned_roles\')->where(\'role_id\', \'=\', $id)->count() }}}')->add_column('actions', '<div class="btn-group"><a href="{{{ URL::to(\'admin/roles/\' . $id . \'/edit\' ) }}}" class="modalfy btn btn-sm btn-primary">{{{ Lang::get(\'button.edit\') }}}</a>
<a data-row="{{{ $id }}}" data-method="delete" data-table="roles" href="{{{ URL::to(\'admin/roles/\' . $id . \'\' ) }}}" class="ajax-alert-confirm btn btn-sm btn-danger" @if($name == "admin" || $name == "users")disabled@endif>{{{ Lang::get(\'button.delete\') }}}</a></div>
')->make();
}
}
/**
* Pobranie danych roli do wyświetlenia
*
* @param integer $id id roli
* @return Row_Rola wiersz z danymi
*/
public function showRole($id)
{
$modelGroup = new Group();
$select = $modelGroup->select()->from(array('g' => 'group'), array())->joinLeft(array('rg' => 'role_group'), 'rg.id_group = g.id', array())->where('g.ghost = \'f\'')->where('rg.id_role = ?', $id)->columns(array('groups' => new Zend_Db_Expr('array_to_string(array_agg(description),\'<br />\')')))->setIntegrityCheck(false);
$model = new Role();
$cols = array('role_name', 'description', 'groups' => new Zend_Db_Expr('(' . $select . ')'), 'ghost' => new Zend_Db_Expr('CASE WHEN ghost=true THEN \'tak\' ELSE \'nie\' END'));
$select = $model->select()->from(array('r' => 'role'))->columns($cols)->where('r.id = ?', $id);
$data = $model->fetchRow($select);
return $data;
}
/**
* Show a list of all the roles formatted for Datatables.
*
* @return Datatables JSON
*/
public function data()
{
$roles = Role::select(array('roles.id', 'roles.name', 'roles.description', 'roles.id as users', 'roles.created_at'));
return Datatables::of($roles)->edit_column('users', '{{{ DB::table(\'assigned_roles\')->where(\'role_id\', \'=\', $id)->count() }}}')->add_column('actions', '<div class="btn-group">
<button type="button" class="btn btn-xs btn-primary dropdown-toggle" data-toggle="dropdown">
Action <span class="caret"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a href="{{{ URL::to(\'admin/roles/\' . $id ) }}}">{{{ Lang::get(\'button.show\') }}}</a></li>
<li><a href="{{{ URL::to(\'admin/roles/\' . $id . \'/edit\' ) }}}">{{{ Lang::get(\'button.edit\') }}}</a></li>
@if($name == \'admin\')
@else
<li><a href="{{{ URL::to(\'admin/roles/\' . $id . \'/delete\' ) }}}">{{{ Lang::get(\'button.delete\') }}}</a></li>
@endif
</ul>
</div>')->remove_column('id')->make();
}
public function getDataToUserReport()
{
$profileModel = new Profile();
$select = $profileModel->select()->order('id_user');
$profileDataArray = $profileModel->fetchAll($select)->toArray();
$groupModel = new Group();
$select = $groupModel->select();
$groupDataArray = $groupModel->fetchAll($select)->toArray();
foreach ($groupDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$groupDataArray = $tmp;
unset($tmp);
$branchModel = new Branch();
$select = $branchModel->select();
$branchDataArray = $branchModel->fetchAll($select)->toArray();
foreach ($branchDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$branchDataArray = $tmp;
unset($tmp);
$userModel = new User();
$select = $userModel->select();
$userDataArray = $userModel->fetchAll($select)->toArray();
foreach ($userDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$userDataArray = $tmp;
unset($tmp);
$roleModel = new Role();
$select = $roleModel->select();
$roleDataArray = $roleModel->fetchAll($select)->toArray();
foreach ($roleDataArray as $key => $value) {
$tmp[$value['id']] = $value;
}
$roleDataArray = $tmp;
unset($tmp);
$groupArray = array();
foreach ($profileDataArray as $key => $value) {
$data = $this->getAuthorizationsForProfile($value['id']);
foreach ($data as $key2 => $values) {
foreach ($values as $key3 => $privs) {
/* if ($privs['ghost'] === true) {
unset($data[$key2][$key3]);
continue;
}
*/
$tmp = array('login' => '', 'surname' => '', 'first_name' => '', 'group' => '', 'role' => '', 'branch' => '', 'ghost' => '');
if ($key2 === 'group') {
$tmp['group'] = $groupDataArray[$privs['id_group']]['group_name'];
}
if ($key2 === 'role') {
$tmp['role'] = $roleDataArray[$privs['id_role']]['description'];
}
$tmp['login'] = $userDataArray[$value['id_user']]['login'];
$tmp['surname'] = $userDataArray[$value['id_user']]['surname'];
$tmp['first_name'] = $userDataArray[$value['id_user']]['first_name'];
$tmp['branch'] = $branchDataArray[$value['id_branch']]['branch_name'];
$tmp['ghost'] = $userDataArray['ghost'] ? 'NIEAKTYWNY' : 'AKTYWNY';
$groupArray[] = $tmp;
}
}
}
return $groupArray;
}
