this depends on the number of attendees.

split work according the model, view, controller?

many small tasks, that can be tested separately.

merged topic5 and topic1

at the bottom, there is a random topic, without any votes, and missing title, but just the facilitator Facilitator: user3, user12

• create topics
• view already existing nominations
• edit or delete your own topic

by accident, the nomination ended at 0:00 at night, it should have been 12 at noon.
in Firefox, I have 24 hours selection, I think it was Edge where it was with AM/PM which was confusing for me.

This obviously depends on the programming language we use.

When that decision has been made, we can start using the spec (https://github.com/ICCM-EU/BOF/wiki/Specs-of-the-BOF-application) to define unit tests for various issues:

• calculating the order of voted sessions, calculating the rooms and slots
• creating a new user account
• etc

We could prepare the code classes beforehand, with methods that don't have any functionality, but can be called from the test code. This way we have test driven development during the hackathon!

We could even prepare Selenium (http://www.seleniumhq.org/) tests for the UI beforehand, although that would not be very acurate, and the tests would need to be modified during development of the actual screens.

• set dates for nomination and voting
• set names and sizes of rooms
• set the number of slots available

at the moment we only support english

I am proposing PHP. Just because you can install it on any server easily.
I am wondering about https://symfony.com/ as a framework. Or is it too heavy? What about https://www.slimframework.com/? But Symfony is quite a standard.

Another option would be Python, with using Django as a framework.

We had C# in the pre conference workshop day in 2016, so I think we should be using something different than C#.

Any thoughts?

users can create their own username and password

It seems that the ability to volunteer as a leader/facilitator has disappeared from the app.

It is important that each BOF is assigned a leader/facilitator. People should be able to indicate that they can do this during the suggesting phase and the voting phase

The old BOF system would choose from suggested with facilitator first then the rest. And the BOF organizer would track down and assign people to lead those that don’t have a facilitator to make sure each has a facilitator

the admin must define when the voting stage starts, and when the results can be displayed

to prepare the database for a new conference.

should have a dialog to ask if the data should really be deleted

http://bofdev.local/vote or http://bofdev.local/admin show a json error, "Token not found", but it should redirect to the login page

I think the database structure of the old BOF is quite obvious, and not under license restrictions. We could reuse that.

Depending on the decision for programming language and framework, we need to decide how we access the database.

make sure the ids are starting at 0 and are consecutive

instead of reseting the database.

There are tables for it. would need to figure out the best way of doing it.

if you vote on the EuroPrep Workshop, you don't lose a vote.

That should help with creating the schedule, because we know who wants to go there.

But still keep it fair for those who want to attend the EuroPrep workshop, they have as many votes as everyone else.

the admin should be able to rearrange locations, or even replace workshops.

We need to decide how we present the application.

I propose using Bootstrap: http://getbootstrap.com/

We could already prepare mockup screenshots of how the screens should look like for the user.
For example using https://gomockingbird.com/

otherwise there are pasting issues with cells covering multiple lines

at least a download of the csv file already would help

each conference has another colour scheme, and logo.

configure in the database, or in a configuration file.

that should not be allowed, only for logged in users

at the moment we only tell how many full votes are left

Github says:

We found a potential security vulnerability in one of your dependencies.

A dependency defined in ./package-lock.json has known security vulnerabilities and should be updated. 

package-lock.json update suggested: hoek ~> 5.0.3 

this is drawn in by node-sass 4.9.0, and will only be fixed in 5.x: sass/node-sass#2170

How to fix this in general:

 npm outdated
 fix the required version in package.json
 npm install

need to insert Bootstrap into the layout.html

perhaps start with the Login dialog.

then continue with what the other developers are putting in the templates directory.

currently voting during nomination is not visible, but possible

this helps assigning a facilitator if noone volunteered

I want to see my full votes, and my quarter votes at the top

only for those users with admin permissions

• give full vote or quarter vote to topic
• volunteer to be the facilitator

perhaps even add new rooms or drop rooms? just make sure the ids are consecutive, and start at 0

I propose the GPL v3 or later. With this license, anyone selling software based on this code is obliged to also publish the source code under GPL v3 to their customers.

Any other suggestions?

To encourage voting.
Put people on the big display, that have not voted yet.
This would of course only include people that registered into the system in the first place.

to fix typos, or change the text, or just moderation.

more middleware, crsf etc:
https://github.com/tuupola/slim-api-skeleton/blob/master/config/middleware.php#L32-L71

we are running this only on site, not on the internet, therefore this is not urgent

the admin must be able to edit the nominations before the voting stage. he must be able to merge similar nominations.

this does not require a login.

depending on the current stage, different information is required for the page on the projector

• nominations
• votes
• PRIO 2: results: which time slot, which room

would be good to have this on the corner of the main layout

it seems to be not activated by default?

at the moment, the page is reloaded, and you are back at the top of the list
it would be great to either scroll to the topic, or use AJAX for the voting which does not need to reload the page

the format is:

<#room#>,<#workshop#>,<#facilitators#>,<#clean_desc#>,<#votes#>,<#available#>

where clean_desc is without any html tags

votes is the sum of full votes and quarter votes

available is the number of people actually available, that are not booked on another bof already with more votes

this is the algorithm we have used in the past:

definition:

• rounds = number of rounds

• locations = number of locations

• slots available: make sure we have one slot free for the ICCM Prep BOF

• in each workshop, calculate the number of votes of participants, and reset the field round_id, location_id and available

  UPDATE workshop
             SET votes = (SELECT SUM(participant)
                            FROM workshop_participant 
                           WHERE workshop.id=workshop_participant.workshop_id),
                 round_id = NULL,
                 location_id = NULL,
                 available = NULL
  

• for each round, calculate the top votes:

     SELECT id,name, votes
            FROM workshop
           WHERE published=1
           ORDER BY votes desc
           LIMIT 0, $rounds;
  

• and book them:

    UPDATE workshop
    	          SET round_id = {$count},
    	              location_id=1,
    	              available=(SELECT COUNT(ID)
                                   FROM workshop_participant 
                                  WHERE workshop.id=workshop_participant.workshop_id
                                    AND participant=1)
    	        WHERE id={$db->escape_string($row['id'])}
  

• loop through remaining possible slots

    for ($i=$rounds+1 ; $i <= $rounds * $locations ; $i++) {
  

• inside the loop:

  • get highest # votes for unscheduled bof

      $sql="SELECT max(votes)
              FROM workshop 
             WHERE round_id IS NULL 
               AND published=1";
    

  • if no workshops are left, we are done

  • find next bof to book: which bof with the same max(votes) can happen with participants available

      $sql = "SELECT s.id id,s.name,
                     roundsTable.round_id round, 
                     roundsTable.last_location last_location,
                     available,  
                     (SELECT count(*) 
      	              FROM workshop_participant
      	             WHERE workshop_id = s.id
      	               AND participant=1
      	               AND participant_id NOT IN
      	                           (SELECT participant_id
      	                              FROM workshop_participant
      	                              JOIN workshop ON workshop.id=workshop_participant.workshop_id
      	                             WHERE workshop.round_id=roundsTable.round_id
      	                               AND workshop_participant.participant=1)
      	           ) AS available,
      		       (SELECT count(*) 
                        FROM workshop_participant
                       WHERE workshop_id = s.id
                         AND leader=1
                         AND participant_id NOT IN
                             (SELECT participant_id
                                FROM workshop_participant
                                JOIN workshop ON workshop.id=workshop_participant.workshop_id
                               WHERE workshop.round_id=roundsTable.round_id
                                 AND workshop_participant.leader=1)
                      ) AS facilitators
      		FROM workshop AS s
      		LEFT JOIN (SELECT round_id, max(location_id) last_location
      		           FROM workshop
      		           WHERE round_id IS NOT NULL
      		           GROUP BY round_id) AS roundsTable 
      		     ON roundsTable.last_location < ".$locations."
      		WHERE s.round_id is null
      		  AND published=1
      		  AND s.votes = ".$maxVote."
      		ORDER BY available DESC, facilitators DESC, round ASC
      		LIMIT 0,1";
    

    • For each of the results of the previous query:

        UPDATE workshop
                      SET round_id = {$db->escape_string($row['round'])},
                          location_id = ".($db->escape_string($row['last_location']) + 1) .",
                          available = ".($db->escape_string($row['available'])) ."
                    WHERE id={$db->escape_string($row['id'])}";
      

we sometimes have funny configuration of the timezone on the server.
so it is important we know which time is the current time on the server.

User should be able to see workshops that he has proposed and edit nominations

We will prepare the spec in the wiki, just because that is easier for everyone to edit the text.

https://github.com/ICCM-EU/BOF/wiki/Specs-of-the-BOF-application

We can have discussions by adding comments to this issue.