Opened 6 years ago

Closed 5 years ago

#2027 closed improve feature (fixed)

Add a suggestion feature

Reported by: shevek Owned by: shevek
Priority: major Milestone: 2.3
Component: BW Suggestions Keywords:
Cc:

Description (last modified by shevek)

As outlined in this BW forum thread, we need a tool for suggestions of out members.

This ticket was created to track the necessary changes.

For design of the feature and the data model see the related wiki page.

Change History (25)

comment:1 Changed 6 years ago by shevek

  • Description modified (diff)

comment:2 Changed 6 years ago by shevek

  • Owner set to shevek
  • Status changed from new to assigned

comment:3 Changed 6 years ago by shevek

  • Description modified (diff)
  • Summary changed from Add a decision feature to Add a suggestion feature

comment:4 Changed 5 years ago by shevek

  • Description modified (diff)

comment:5 Changed 5 years ago by shevek

  • Status changed from assigned to to_alpha

Added the first step (provide a voting mechanism) to 1.8.

Deployed on alpha, please test.

comment:6 Changed 5 years ago by shevek

  • Status changed from to_alpha to testing

comment:7 Changed 5 years ago by shevek

  • Milestone changed from unassigned to 1.8

comment:8 Changed 5 years ago by crumbking

In case the tool is members only don't show a link in the menu while not logged in. From the startpage it seems nothing happens...

comment:10 Changed 5 years ago by shevek

  • Milestone 1.8 deleted

I spin off a separate ticket for the voting part to be able to keep this open (see #2034).

comment:11 Changed 5 years ago by shevek

  • Milestone set to 2.1
  • Status changed from testing to needs_work
  • Type changed from unknown to improve feature

comment:12 Changed 5 years ago by shevek

  • Component changed from unknown to BW Suggestions
  • Status changed from needs_work to assigned

comment:13 Changed 5 years ago by shevek

Added a new column to take the thread ID of the thread in the suggestions group for an approved suggestion.

ALTER TABLE  `suggestions` ADD  `threadId` INT( 11 ) NULL AFTER  `state` ;

comment:14 Changed 5 years ago by shevek

  • Status changed from assigned to to_alpha

Updated the table again.

ALTER TABLE `suggestions`
  DROP `votingstart`,
  DROP `votingend`,
  DROP `rankingstarted`,
  DROP `rankingended`;
  
ALTER TABLE  `suggestions` ADD  `laststatechanged` DATE NULL DEFAULT NULL COMMENT  'Stores the last state change to be able to calculate the start of the next phase' AFTER  `modifiedby`;

ALTER TABLE  `suggestions` ADD  `votingend` DATE NULL DEFAULT NULL COMMENT  'Stores the date when the voting ended. Might be useful information.' AFTER  `laststatechanged`;

Everything should work fine up to ranking (excluded).

comment:16 Changed 5 years ago by mahouni

There is an error on the development tab, if I try the link to the topic:

http://alpha.bewelcome.org/suggestions/14

Fatal error: Undefined class constant 'SUGGESTIONS_VOTE' in /var/rox/deployment/alpha.bewelcome.org-ecb7ae2/build/suggestions/suggestions.ctrl.php on line 45

comment:17 Changed 5 years ago by shevek

Fixed now.

comment:18 Changed 5 years ago by shevek

  • Milestone changed from 2.1 to 2.2
  • Status changed from testing to needs_work

Moved to 2.2 to cover the ranking part of the feature and a fix for voting (enable voting with IE).

comment:19 Changed 5 years ago by shevek

Some bugfixes (mainly due to deleted options; for IE 8- users show radio buttons).

comment:20 Changed 5 years ago by shevek

  • Milestone changed from 2.2 to 2.3

Moving the remainder to 2.3.

comment:21 Changed 5 years ago by shevek

Table schema update for the results:

ALTER TABLE `suggestions_options` DROP `result`;
ALTER TABLE  `suggestions_options` ADD  `rank` TINYINT NULL COMMENT  'The resulting rank of the option.',
ADD  `orderHint` INT NULL COMMENT  'The option''s position in the resulting ranks.';
ALTER TABLE  `suggestions_options` ADD  `mutuallyExclusiveWith` TEXT NULL COMMENT 'The list of mutually exclusion options. Comma separated.' AFTER  `deletedBy` ;

The first two new columns store the resulting rank (1 - 4 shown as 'bad' to 'excellent' on the site) and the order of the options.

The third column is necessary to be able to mark an option to be mutually exclusive with other options.

The change is necessary as non mutually exclusive options are allowed and therefore more than on option might win. The list of mutually exclusive options will be taken into account to define the set of winning options.

Last edited 5 years ago by shevek (previous) (diff)

comment:22 Changed 5 years ago by shevek

A new column is needed to store the information if the 'voting starts in five days' message has already been posted.

ALTER TABLE  `suggestions` ADD  `flags` INT NULL DEFAULT NULL COMMENT  'Versatile field. Currently used to store if the voting start message was already posted. ' AFTER  `state` ;

comment:23 Changed 5 years ago by shevek

  • Status changed from needs_work to to_alpha

Implementation is now finished. Setting status accordingly.

comment:24 Changed 5 years ago by shevek

  • Status changed from to_alpha to testing

comment:25 Changed 5 years ago by crumbking

  • Resolution set to fixed
  • Status changed from testing to closed

seems to work.

Note: See TracTickets for help on using tickets.