Radiation database v2
minor bug fixes to stock_history, stock_usage_probes, stock_disposal_probes. Need to update stock_undo so it can manage to clear multiple events to handle undo of probe (probe creation + waste entry are 2 different events). Reworking UI on DEV to make use of CSS 3 to improve look & feel as well as widening page. Minor issue with monthly_lab/ monthly_actions - had left them 'read' only, so cron job ran them but they made no updates to database - quickly re-ran manually so that changes were stored. Also updated monthly_actions to allow on/off status for stocks, sinks, swabs, temp store decay/resetting. Updated monitors with option to add a calibration certificate file to each calibration event. Updated bin_history to show decay events for temp store decays.
updated to allow staff who have sub-pages to manage these - link was removed when SIPBS site was updated recently.
ODBC/ Oracle interface
updated staff.php to include Oracle/VAX staff number - for PG_DB, below.
PG records database
updated change_supervisor request form to include staff number in email to centre. Reports pending tool updated to display names and use email from central data for supervisors (covers local and external supervisors now without having to maintain separate externals list). Added links to help wiki pages (updated the wiki help for PG DB too).
added getUserStaffNumber($DS_username) to inc_functions_data. Returns staff number from staff_MIS table. Updated inc_functions with PHPDoc comments. Updated inc_form and inc_form_blocks to handle file upload element (new/add + edit). Added inc_file_upload script to handle basic file uploads (for radiation monitors, see above).
updated OS and browser stats to pick up latest browsers/phones, updated breakdown of iPhone/Pad/Pod plus fix for Chrome with vNum greater than 10.
seems several classes were missed from the previous s2 export. Converted list from LTE team and created a new admin/backup script to accept array of class code strings instead of querying db on semester.
The LTE guys added a few updates to the Moodle topic format to allow for collapsible topics and s1/s2 separation, which should help with the usability/ viewing of files in classes with large amounts of content.
Worked on some quizzes on myPlace to check for issues between SPIDER and Moodle quiz options/ question types. Worked out how to get random questions in to the quiz. Rather than being a property of the 'quiz' itself, its achieved via the 'question bank', using 'categories'. By adding some questions to two different categories, there is an option in the 'question bank' to 'add x random questions' from each category in the question bank to the quiz, allowing for a quiz to have random sub-sets of questions.
Second issue was to do with feedback - dragNdrop questions on SPIDER have per option feedback, which has not translated to Moodle's 'matching' question type. The LTE team are already on the case (pointed this out to them a wee while back) so there should be a solution for this at some point soon. Another feedback issue is that the only way I can see to get 'immediate feedback' (feedback shown as soon as you answer each question) is to run the quiz in 'Adaptive mode'. However, this allows the student to retry (submit) the question until they get it right, which isn't quite what we need - have just passed this last issue to the LTE team to see if there is a solution - there may be a setting/option somewhere that I'm just not seeing.
Next week - must get on to the myPlace DEV server (they gave us access a week or two ago now, but been unable to get away from radiation fixes) and test/ sort out any issues with the SPIDER modules that are going to run via the 'translator'.