Difference between revisions of "Pcrego"

From ProgClub
Jump to: navigation, search
(Notes for ProgClub administrators)
 
(9 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
= Status =
 
= Status =
  
Under way. Not released yet, there's stuff [[#TODO|TODO]].
+
Released into production at ProgClub on 2013-07-26. Latest update on 2016-04-13.
  
 
= Administration =
 
= Administration =
Line 11: Line 11:
 
Members who have contributed to this project. Newest on top.
 
Members who have contributed to this project. Newest on top.
  
* [[User:John|John]]
+
* [[User:John|John Elliot V]]
  
 
Contractors who have contributed to this project. Newest on top.
 
Contractors who have contributed to this project. Newest on top.
Line 21: Line 21:
 
== Copyright ==
 
== Copyright ==
  
Copyright 2013, [[#Contributors|Contributors]].
+
Copyright 2013-2016, [[#Contributors|Contributors]].
  
 
== License ==
 
== License ==
Line 31: Line 31:
 
== Downloads ==
 
== Downloads ==
  
TODO: link to downloads or explain why there aren't any.
+
There are no downloads for this project.
  
 
== Source code ==
 
== Source code ==
Line 45: Line 45:
 
Or if you want the latest version for development purposes:
 
Or if you want the latest version for development purposes:
  
  svn://www.progclub.org/svn/pcrepo/pcrego/trunk
+
  https://www.progclub.org/svn/pcrepo/pcrego/trunk
  
 
== Links ==
 
== Links ==
Line 69: Line 69:
 
The registration system will be a stand-alone PHP application hosted at https://www.progclub.org/members/
 
The registration system will be a stand-alone PHP application hosted at https://www.progclub.org/members/
  
Data will be stored in a MySQL database.
+
Data will be stored in a MySQL database with [https://www.progclub.org/pcrepo/pcrego/trunk/etc/pcregodb/pcregodb.sql?view=markup this schema].
 +
 
 +
Public interface is in /web, e.g. the front controllers:
 +
 
 +
* /web/admin.php -- the front controller for the admin interface
 +
* /web/register.php -- the front controller for the user interface
 +
* /web/ajax.php -- the front controller for AJAX calls
 +
 
 +
The admin/register front controllers load pages which are found in /src/[controller]/page/[page name].
  
 
= Notes =
 
= Notes =
 +
 +
== Notes for ProgClub administrators ==
 +
 +
To release a new version of pcrego:
 +
 +
$ pcrepo-release pcrego
  
 
== Notes for implementers ==
 
== Notes for implementers ==
Line 77: Line 91:
 
If you are interested in incorporating this software into your project, here's what you need to know:
 
If you are interested in incorporating this software into your project, here's what you need to know:
  
* PHP Extensions required:
+
* php 5.3+
** PDO MySQL
+
* php_pdo_mysql
 +
* jQuery 1.9+
 +
* Knockout 2.0+
  
 
== Notes for developers ==
 
== Notes for developers ==
Line 84: Line 100:
 
If you're looking to set up a development environment for this project here's what you need to know:
 
If you're looking to set up a development environment for this project here's what you need to know:
  
* php
+
* php 5.3+
 
* php_pdo_mysql
 
* php_pdo_mysql
* jQuery
+
* jQuery 1.9+
* Knockout
+
* Knockout 2.0+
  
 
= Tasks =
 
= Tasks =
 +
 +
[[Category:Done]]
  
 
== TODO ==
 
== TODO ==
Line 95: Line 113:
 
Things to do, in rough order of priority:
 
Things to do, in rough order of priority:
  
* Create the project in svn
+
Nothing to see here, move along!
* Design the database
 
* Design administrator login form /members/login
 
* Process logout /members/logout
 
* Design administrator account creation form /members/user (can create one account if there are no registered administrator accounts other wise requires administrator login)
 
* Design the registration form /members/apply
 
* Process the registration form
 
* Confirm email address /members/confirm
 
* List accounts awaiting email confirmation for administrators /members/pending
 
* List accounts pending creation for administrators /members/new
 
* List active accounts /members
 
* List ceased accounts for administrators /members/ceased
 
* Process account ceased (administrators can cease active accounts or accounts pending creation by clicking a button next to the user details)
 
* Design the member details edit/update form /members/edit?id=1 (if ID not specified redirect to /members for active members list)
 
* Process member details edit/update
 
 
 
[[Category:TODO]]
 
  
 
== Done ==
 
== Done ==
Line 117: Line 119:
 
Stuff that's done. Latest stuff on top.
 
Stuff that's done. Latest stuff on top.
  
 +
* [[User:John|JE]] 2016-05-09: improved form layout
 +
* [[User:John|JE]] 2016-04-13: fixed member creation script generation (there was a problem where it randomly dropped instructions, highly uncool)
 +
* [[User:John|JE]] 2016-04-13: better validation for usernames
 +
* [[User:John|JE]] 2016-04-13: friendlier/more useful messages (including warning about vcs list volume)
 +
* [[User:John|JE]] 2013-07-26: Design administrator login form /members/login
 +
* [[User:John|JE]] 2013-07-26: Process logout /members/logout
 +
* [[User:John|JE]] 2013-07-26: Design administrator account creation form /members/user (can create one account if there are no registered administrator accounts other wise requires administrator login)
 +
* [[User:John|JE]] 2013-07-26: Design the registration form /members/apply
 +
* [[User:John|JE]] 2013-07-26: Process the registration form
 +
* [[User:John|JE]] 2013-07-26: Confirm email address /members/confirm
 +
* [[User:John|JE]] 2013-07-26: List accounts awaiting email confirmation for administrators /members/pending
 +
* [[User:John|JE]] 2013-07-26: List accounts pending creation for administrators /members/new
 +
* [[User:John|JE]] 2013-07-26: List active accounts /members
 +
* [[User:John|JE]] 2013-07-26: List ceased accounts for administrators /members/ceased
 +
* [[User:John|JE]] 2013-07-26: Process account ceased (administrators can cease active accounts or accounts pending creation by clicking a button next to the user details)
 +
* [[User:John|JE]] 2013-07-26: Design the member details edit/update form /members/edit?id=1 (if ID not specified redirect to /members for active members list)
 +
* [[User:John|JE]] 2013-07-26: Process member details edit/update
 +
* [[User:Brock|BH]] 2013-07-22: created import page, additional user details and form validation
 +
* [[User:Brock|BH]] 2013-07-21: created edit/update page, front-end validation and finishing touches
 +
* [[User:Brock|BH]] 2013-07-19: created members list page with dynamic status dropdown
 +
* [[User:Brock|BH]] 2013-07-18: created pending and new member approval pages
 +
* [[User:Brock|BH]] 2013-07-16: created registration form, confirmation page, listing pending email confirmation members page
 +
* [[User:Brock|BH]] 2013-07-15: created administrator account creation form
 +
* [[User:Brock|BH]] 2013-07-14: created database design, administrator login page, logout page
 +
* [[User:John|JE]] 2013-07-13: Create the project in svn
 
* [[User:John|JE]] 2013-07-13: created project page
 
* [[User:John|JE]] 2013-07-13: created project page
* [[User:Brock|BH]] 2013-07-14: created database design, administrator login page, logout page
 
* [[User:Brock|BH]] 2013-07-15: created administrator account creation form
 
* [[User:Brock|BH]] 2013-07-16: created registration form, confirmation page, listing pending email confirmation members page
 
* [[User:Brock|BH]] 2013-07-18: created pending and new member approval pages
 
* [[User:Brock|BH]] 2013-07-19: created members list page with dynamic status dropdown
 
* [[User:Brock|BH]] 2013-07-21: created edit/update page, front-end validation and finishing touches
 
* [[User:Brock|BH]] 2013-07-22: created import page, additional user details and form validation
 

Latest revision as of 06:45, 21 September 2016

Pcrego is the ProgClub member registration software. That's the software that processes member applications. For other projects see projects.

Status

Released into production at ProgClub on 2013-07-26. Latest update on 2016-04-13.

Administration

Contributors

Members who have contributed to this project. Newest on top.

Contractors who have contributed to this project. Newest on top.

All contributors (members and contractors) have agreed to the terms of the Contributor License Agreement. This excludes any upstream contributors who tend to have different administrative frameworks.

Copyright

Copyright 2013-2016, Contributors.

License

Licensed under the New BSD license.

Resources

Downloads

There are no downloads for this project.

Source code

The repository can be browsed online:

https://www.progclub.org/pcrepo/pcrego

The latest stable released version of the code is available from:

https://www.progclub.org/svn/pcrepo/pcrego/tags/latest

Or if you want the latest version for development purposes:

https://www.progclub.org/svn/pcrepo/pcrego/trunk

Links

Specifications

Functional specification

The functional specification describes what the project does.

I would like a web-based application that accepts new applicants and stores their information in a MySQL database. Applications can have four statuses: awaiting email verification, pending account creation, active and ceased. An administrator will be able to get a report of accounts that are awaiting email verification, pending account creation (in order to configure new accounts), or ceased. Active accounts will be publicly listed on the home page. All four lists will be paginated with the page size being specified in the URL. All four lists will be sortable by: account number, registration date (and termination date for ceased accounts), username, wiki username, first name, last name, email address. The first name, last name and email address will be blank unless the user has given permission to publish their details.

Applicants will need to confirm their email address as part of the application process. So after they fill in the web application form they will receive an email with a link to confirm their email address. The email confirmation is there to prevent spammers from clogging up the system. After the user has confirmed their email address their application will be reported in the administrators' TODO list (pending account creation). Once the new member application has been processed by the administrator the application will be complete and the account will be active. An administrator can 'cease' any active accounts.

Technical specification

The technical specification describes how the project works.

The registration system will be a stand-alone PHP application hosted at https://www.progclub.org/members/

Data will be stored in a MySQL database with this schema.

Public interface is in /web, e.g. the front controllers:

  • /web/admin.php -- the front controller for the admin interface
  • /web/register.php -- the front controller for the user interface
  • /web/ajax.php -- the front controller for AJAX calls

The admin/register front controllers load pages which are found in /src/[controller]/page/[page name].

Notes

Notes for ProgClub administrators

To release a new version of pcrego:

$ pcrepo-release pcrego

Notes for implementers

If you are interested in incorporating this software into your project, here's what you need to know:

  • php 5.3+
  • php_pdo_mysql
  • jQuery 1.9+
  • Knockout 2.0+

Notes for developers

If you're looking to set up a development environment for this project here's what you need to know:

  • php 5.3+
  • php_pdo_mysql
  • jQuery 1.9+
  • Knockout 2.0+

Tasks

TODO

Things to do, in rough order of priority:

Nothing to see here, move along!

Done

Stuff that's done. Latest stuff on top.

  • JE 2016-05-09: improved form layout
  • JE 2016-04-13: fixed member creation script generation (there was a problem where it randomly dropped instructions, highly uncool)
  • JE 2016-04-13: better validation for usernames
  • JE 2016-04-13: friendlier/more useful messages (including warning about vcs list volume)
  • JE 2013-07-26: Design administrator login form /members/login
  • JE 2013-07-26: Process logout /members/logout
  • JE 2013-07-26: Design administrator account creation form /members/user (can create one account if there are no registered administrator accounts other wise requires administrator login)
  • JE 2013-07-26: Design the registration form /members/apply
  • JE 2013-07-26: Process the registration form
  • JE 2013-07-26: Confirm email address /members/confirm
  • JE 2013-07-26: List accounts awaiting email confirmation for administrators /members/pending
  • JE 2013-07-26: List accounts pending creation for administrators /members/new
  • JE 2013-07-26: List active accounts /members
  • JE 2013-07-26: List ceased accounts for administrators /members/ceased
  • JE 2013-07-26: Process account ceased (administrators can cease active accounts or accounts pending creation by clicking a button next to the user details)
  • JE 2013-07-26: Design the member details edit/update form /members/edit?id=1 (if ID not specified redirect to /members for active members list)
  • JE 2013-07-26: Process member details edit/update
  • BH 2013-07-22: created import page, additional user details and form validation
  • BH 2013-07-21: created edit/update page, front-end validation and finishing touches
  • BH 2013-07-19: created members list page with dynamic status dropdown
  • BH 2013-07-18: created pending and new member approval pages
  • BH 2013-07-16: created registration form, confirmation page, listing pending email confirmation members page
  • BH 2013-07-15: created administrator account creation form
  • BH 2013-07-14: created database design, administrator login page, logout page
  • JE 2013-07-13: Create the project in svn
  • JE 2013-07-13: created project page