This is where I do my php experiments. Right now I'm working on a new project. The following are my plans to automate the reviews procedure for Hyperrhiz and Rhizomes by creating a form-entry site using PHP and MySQL. I've been inspired by Jet's work at Radical Cupcake. Young Jedi, you have surpassed me.
Requirements:
- Two password-protected pages, one for admin and one for reviewers. Admin will enter the initial details and reviewers will be able to submit their reviews online. Hopefully I can work out how to do a couple off email auto-reminders: one to remind the editor when the project/paper has been in review for {n months} and needs to be checked on; and one to notify the editor when a review is posted.
For editor entry:
- name of project
- author
- contact
- date (notify after time passed to check on status of reviews)
- name of reviewer 1
- name of reviewer 2
- status (etc)
- action
- comments 1
- comments 2
For reviewer entry:
- choose name of project from drop-down box
- choose reviewer name from drop-down box
- enter decision
- enter comments
- auto-notify the editor when review is submitted
Tricky:
- email notification
- keying name of project and reviewer name
- keying action & comments
- what about resubmits - new table - how to constrain
- what to do about nulls