/** * @param int $userId * @param Captions $captions * @return array */ public function GetUserGrants($userId, Captions $captions) { $queryBuilder = new SelectCommand($this->connectionFactory->CreateEngCommandImp()); $queryBuilder->AddField($this->usersTable, $this->users_UserId, FieldType::Number, 'users_user_id'); $queryBuilder->AddField($this->usersTable, $this->users_UserName, FieldType::String, 'users_user_name'); $queryBuilder->AddField($this->userPermsTable, $this->userPerms_UserId, FieldType::Number, 'userperms_user_id'); $queryBuilder->AddField($this->userPermsTable, $this->userPerms_PageName, FieldType::String, 'userperms_pagename'); $queryBuilder->AddField($this->userPermsTable, $this->userPerms_Grant, FieldType::String, 'userperms_grant'); $queryBuilder->SetSourceTableName($this->userPermsTable); $queryBuilder->AddJoin(JoinKind::LeftOuter, $this->usersTable, 'userperms_user_id', $this->users_UserId); $queryBuilder->AddFieldFilter('userperms_user_id', new FieldFilter($userId, '=')); $dataset = new QueryDataset($this->connectionFactory, $this->connectionOptions, $queryBuilder->GetSQL(), array(), array(), array(), 'user_grants'); $dataset->AddField(new StringField('userperms_grant'), false); $dataset->AddField(new StringField('userperms_pagename'), false); $dataset->Open(); $pages = array(); $pages[''] = array('name' => '', 'caption' => $captions->GetMessageString('Application'), 'selectGrant' => false, 'updateGrant' => false, 'insertGrant' => false, 'deleteGrant' => false, 'adminGrant' => false); foreach ($this->tableCaptions as $name => $caption) { $pages[$name] = array('name' => $name, 'caption' => $captions->RenderText($caption), 'selectGrant' => false, 'updateGrant' => false, 'insertGrant' => false, 'deleteGrant' => false, 'adminGrant' => false); } while ($dataset->Next()) { $grant = $dataset->GetFieldValueByName('userperms_grant'); $pageName = $dataset->GetFieldValueByName('userperms_pagename'); if (isset($pages[$pageName])) { $pages[$pageName]['selectGrant'] = $pages[$pageName]['selectGrant'] || StringUtils::SameText($grant, 'select'); $pages[$pageName]['updateGrant'] = $pages[$pageName]['updateGrant'] || StringUtils::SameText($grant, 'update'); $pages[$pageName]['insertGrant'] = $pages[$pageName]['insertGrant'] || StringUtils::SameText($grant, 'insert'); $pages[$pageName]['deleteGrant'] = $pages[$pageName]['deleteGrant'] || StringUtils::SameText($grant, 'delete'); $pages[$pageName]['adminGrant'] = $pages[$pageName]['adminGrant'] || StringUtils::SameText($grant, 'admin'); } } $dataset->Close(); return array_values($pages); }
protected function AddInsertColumns(Grid $grid) { // // Edit column for district_id field // $editor = new MultiLevelComboBoxEditor('district_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $dataset1 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."district"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $dataset1->AddField($field, true); $field = new StringField('state'); $dataset1->AddField($field, false); $field = new StringField('name'); $dataset1->AddField($field, false); $field = new StringField('level_id'); $dataset1->AddField($field, false); $field = new IntegerField('election_div_id'); $dataset1->AddField($field, false); $editor->AddLevel($dataset1, 'id', 'name', $this->RenderText('Political District Name'), new ForeignKeyInfo('abbr', 'state')); $editColumn = new MultiLevelLookupEditColumn('Political District Name', 'district_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for office_id field // $editor = new MultiLevelComboBoxEditor('office_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $selectQuery = 'SELECT op.id office_id, o.title office_title, ed.id election_div_id, ed.name ed_name, ed.phys_addr_state state, concat(d.name, \' - \', o.title) officeTitle FROM office_position op JOIN district d ON op.district_id = d.id JOIN election_div ed ON d.election_div_id = ed.id JOIN office o ON op.office_id = o.id'; $insertQuery = array(); $updateQuery = array(); $deleteQuery = array(); $dataset1 = new QueryDataset(new PgConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'office_title_by_election_div'); $field = new IntegerField('office_id'); $dataset1->AddField($field, false); $field = new StringField('office_title'); $dataset1->AddField($field, false); $field = new IntegerField('election_div_id'); $dataset1->AddField($field, true); $field = new StringField('ed_name'); $dataset1->AddField($field, false); $field = new StringField('state'); $dataset1->AddField($field, false); $field = new StringField('officetitle'); $dataset1->AddField($field, false); $editor->AddLevel($dataset1, 'election_div_id', 'election_div_name', $this->RenderText('Election Division'), new ForeignKeyInfo('abbr', 'election_div_state')); $dataset2 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."office"'); $field = new IntegerField('id'); $field->SetIsNotNull(true); $dataset2->AddField($field, true); $field = new StringField('title'); $field->SetIsNotNull(true); $dataset2->AddField($field, false); $field = new IntegerField('num_positions'); $dataset2->AddField($field, false); $field = new StringField('responsibilities'); $dataset2->AddField($field, false); $field = new IntegerField('term_length_months'); $dataset2->AddField($field, false); $field = new StringField('filing_fee'); $dataset2->AddField($field, false); $field = new BooleanField('partisan'); $dataset2->AddField($field, false); $field = new StringField('age_requirements'); $dataset2->AddField($field, false); $field = new StringField('res_requirements'); $dataset2->AddField($field, false); $field = new StringField('prof_requirements'); $dataset2->AddField($field, false); $field = new IntegerField('salary'); $dataset2->AddField($field, false); $field = new StringField('notes'); $dataset2->AddField($field, false); $field = new IntegerField('office_rank'); $dataset2->AddField($field, false); $dataset2->SetOrderBy('title', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset2, 'id', 'title', $this->RenderText('Office Title'), new ForeignKeyInfo('election_div_id', 'election_div_id')); $editColumn = new MultiLevelLookupEditColumn('Office Title', 'office_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for office_holder_id field // $editor = new MultiLevelComboBoxEditor('office_holder_id_edit', $this->CreateLinkBuilder()); $dataset0 = new TableDataset(new PgConnectionFactory(), GetConnectionOptions(), '"public"."state"'); $field = new StringField('abbr'); $field->SetIsNotNull(true); $dataset0->AddField($field, true); $field = new StringField('name'); $dataset0->AddField($field, false); $editor->AddLevel($dataset0, 'abbr', 'name', $this->RenderText('State'), null); $selectQuery = 'SELECT oh.id, oh.state, concat(oh.last_name, \', \', oh.first_name, \' \', oh.middle_name) AS fullName FROM office_holder oh ORDER BY oh.last_name, oh.first_name'; $insertQuery = array(); $updateQuery = array(); $deleteQuery = array(); $dataset1 = new QueryDataset(new PgConnectionFactory(), GetConnectionOptions(), $selectQuery, $insertQuery, $updateQuery, $deleteQuery, 'officeHolderIDs'); $field = new IntegerField('id'); $dataset1->AddField($field, false); $field = new StringField('state'); $dataset1->AddField($field, false); $field = new StringField('fullname'); $dataset1->AddField($field, false); $dataset1->SetOrderBy('fullname', GetOrderTypeAsSQL(otAscending)); $editor->AddLevel($dataset1, 'id', 'fullname', $this->RenderText('Office Holder Id'), new ForeignKeyInfo('abbr', 'state')); $editColumn = new MultiLevelLookupEditColumn('Office Holder Id', 'office_holder_id', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for position_name field // $editor = new TextEdit('position_name_edit'); $editor->SetSize(25); $editor->SetMaxLength(25); $editColumn = new CustomEditColumn('Position Name', 'position_name', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for term_start field // $editor = new DateTimeEdit('term_start_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Term Start', 'term_start', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for term_end field // $editor = new DateTimeEdit('term_end_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Term End', 'term_end', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for filing_deadline field // $editor = new DateTimeEdit('filing_deadline_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Filing Deadline', 'filing_deadline', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for next_election field // $editor = new DateTimeEdit('next_election_edit', false, 'Y-m-d H:i:s', GetFirstDayOfWeek()); $editColumn = new CustomEditColumn('Next Election', 'next_election', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for notes field // $editor = new TextAreaEdit('notes_edit', 50, 8); $editColumn = new CustomEditColumn('Notes', 'notes', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); // // Edit column for office_rank field // $editor = new TextEdit('office_rank_edit'); $editColumn = new CustomEditColumn('Office Rank', 'office_rank', $editor, $this->dataset); $editColumn->SetAllowSetToNull(true); $this->ApplyCommonColumnEditProperties($editColumn); $grid->AddInsertColumn($editColumn); if ($this->GetSecurityInfo()->HasAddGrant()) { $grid->SetShowAddButton(true); $grid->SetShowInlineAddButton(false); } else { $grid->SetShowInlineAddButton(false); $grid->SetShowAddButton(false); } }