/**
* Fetch all objects. Return an array with the required params
*/
public function test_fetchall_ok()
{
$params = array('weighing' => '50');
$result = evalcomix_tasks::fetch_all($params);
$this->assertIsA($result, 'array');
unset($params, $result);
}
/**
* @param int $oldversion
*/
function xmldb_block_evalcomix_upgrade($oldversion = 201111802)
{
global $DB;
$dbman = $DB->get_manager();
$result = true;
/// Add a new column newcol to the mdl_question_myqtype
if ($oldversion < 2012013005) {
// Define table block_evalcomix to be created
$table = new xmldb_table('block_evalcomix');
// Adding fields to table block_evalcomix
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('courseid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('viewmode', XMLDB_TYPE_CHAR, '10', null, XMLDB_NOTNULL, null, 'evx');
$table->add_field('sendgradebook', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, null, null, '0');
// Adding keys to table block_evalcomix
$table->add_key('id', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// evalcomix savepoint reached
upgrade_block_savepoint(true, 2012013005, 'evalcomix');
}
if ($oldversion < 2012013004) {
// Define table block_evalcomix_tasks to be created
$table = new xmldb_table('block_evalcomix_tasks');
// Adding fields to table block_evalcomix_tasks
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('instanceid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('maxgrade', XMLDB_TYPE_NUMBER, '10, 5', null, null, null, '0');
$table->add_field('weighing', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('timemodified', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
// Adding keys to table block_evalcomix_tasks
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_tasks
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// evalcomix savepoint reached
upgrade_block_savepoint(true, 2012013004, 'evalcomix');
}
if ($oldversion < 2012013004) {
// Define table block_evalcomix_modes to be created
$table = new xmldb_table('block_evalcomix_modes');
// Adding fields to table block_evalcomix_modes
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('taskid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('toolid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('modality', XMLDB_TYPE_CHAR, '7', null, XMLDB_NOTNULL, null, 'teacher');
$table->add_field('weighing', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
// Adding keys to table block_evalcomix_modes
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_modes
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// evalcomix savepoint reached
upgrade_block_savepoint(true, 2012013004, 'evalcomix');
}
if ($oldversion < 2012013004) {
// Define table block_evalcomix_modes_time to be created
$table = new xmldb_table('block_evalcomix_modes_time');
// Adding fields to table block_evalcomix_modes_time
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('modeid', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0');
$table->add_field('timeavailable', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, '0');
$table->add_field('timedue', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, '0');
// Adding keys to table block_evalcomix_modes_time
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_modes_time
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// evalcomix savepoint reached
upgrade_block_savepoint(true, 2012013004, 'evalcomix');
}
//if ($oldversion < 2013110600) {
if ($oldversion < 2012013004) {
// Define table block_evalcomix_modes_extra to be created.
$table = new xmldb_table('block_evalcomix_modes_extra');
// Adding fields to table block_evalcomix_modes_extra.
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('anonymous', XMLDB_TYPE_INTEGER, '1', null, null, null, '0');
$table->add_field('modeid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
// Adding keys to table block_evalcomix_modes_extra.
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_modes_extra.
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// Evalcomix savepoint reached.
//upgrade_block_savepoint(true, 2013110600, 'evalcomix');
upgrade_block_savepoint(true, 2012013004, 'evalcomix');
} else {
}
//if ($oldversion < 2013090502) {
if ($oldversion < 2012013004) {
// Define table block_evalcomix_tools to be created
$table = new xmldb_table('block_evalcomix_tools');
// Adding fields to table block_evalcomix_tools
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('evxid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, '0');
$table->add_field('title', XMLDB_TYPE_TEXT, null, null, XMLDB_NOTNULL, null, null);
$table->add_field('type', XMLDB_TYPE_CHAR, '12', null, XMLDB_NOTNULL, null, 'scale');
$table->add_field('timecreated', XMLDB_TYPE_INTEGER, '10', null, null, null, '0');
$table->add_field('timemodified', XMLDB_TYPE_INTEGER, '10', null, null, null, '0');
$table->add_field('idtool', XMLDB_TYPE_CHAR, '20', null, XMLDB_NOTNULL, null, '0');
// Adding keys to table block_evalcomix_tools
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_tools
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// evalcomix savepoint reached
//upgrade_block_savepoint(true, 2013090502, 'evalcomix');
upgrade_block_savepoint(true, 2012013004, 'evalcomix');
}
if ($oldversion < 2013102505) {
// Define table block_evalcomix_grades to be created.
$table = new xmldb_table('block_evalcomix_grades');
// Adding fields to table block_evalcomix_grades.
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('userid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);
$table->add_field('cmid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);
$table->add_field('finalgrade', XMLDB_TYPE_NUMBER, '10, 5', null, null, null, null);
$table->add_field('courseid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);
// Adding keys to table block_evalcomix_grades.
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_grades.
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// Evalcomix savepoint reached.
upgrade_block_savepoint(true, 2013102505, 'evalcomix');
global $CFG;
include_once $CFG->dirroot . '/blocks/evalcomix/classes/evalcomix_grades.php';
include_once $CFG->dirroot . '/blocks/evalcomix/classes/evalcomix_tasks.php';
include_once $CFG->dirroot . '/blocks/evalcomix/classes/evalcomix_assessments.php';
include_once $CFG->dirroot . '/blocks/evalcomix/classes/evalcomix_modes_extra.php';
include_once $CFG->dirroot . '/blocks/evalcomix/classes/evalcomix_modes_time.php';
if ($tasks = evalcomix_tasks::fetch_all(array())) {
foreach ($tasks as $task) {
echo '<br><br><br>Procesando task: ' . $task->id . '<br>';
echo 'Finalgrades asociados: <br>';
if ($cm = $DB->get_record('course_modules', array('id' => $task->instanceid))) {
$courseid = $cm->course;
if ($assessments = evalcomix_assessments::fetch_all(array('taskid' => $task->id))) {
foreach ($assessments as $assessment) {
$params = array();
//cmid -- userid -- courseid
$params['cmid'] = $task->instanceid;
$params['userid'] = $assessment->studentid;
$params['courseid'] = $courseid;
$finalgrade = evalcomix_grades::get_finalgrade_user_task($params);
echo "finalgrade: {$finalgrade} <br>";
if ($finalgrade !== null) {
if ($gradeObject = evalcomix_grades::fetch($params)) {
$gradeObject->finalgrade = $finalgrade;
$gradeObject->update();
} else {
$params['finalgrade'] = $finalgrade;
$gradeObject = new evalcomix_grades($params);
$gradeObject->insert();
}
} else {
if ($gradeObject = evalcomix_grades::fetch($params)) {
$gradeObject->delete();
}
}
}
}
}
}
}
}
if ($oldversion < 2013111801) {
// Define table block_evalcomix_allowedusers to be created.
$table = new xmldb_table('block_evalcomix_allowedusers');
// Adding fields to table block_evalcomix_allowedusers.
$table->add_field('id', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);
$table->add_field('cmid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);
$table->add_field('assessorid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);
$table->add_field('studentid', XMLDB_TYPE_INTEGER, '10', null, XMLDB_NOTNULL, null, null);
// Adding keys to table block_evalcomix_allowedusers.
$table->add_key('primary', XMLDB_KEY_PRIMARY, array('id'));
// Conditionally launch create table for block_evalcomix_allowedusers.
if (!$dbman->table_exists($table)) {
$dbman->create_table($table);
}
// Evalcomix savepoint reached.
upgrade_block_savepoint(true, 2013111801, 'evalcomix');
}
if ($oldversion < 2013111801) {
// Define field whoassesses to be added to block_evalcomix_modes_extra.
$table = new xmldb_table('block_evalcomix_modes_extra');
$field1 = new xmldb_field('visible', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0');
if (!$dbman->field_exists($table, $field1)) {
$dbman->add_field($table, $field1);
}
$field2 = new xmldb_field('whoassesses', XMLDB_TYPE_INTEGER, '1', null, XMLDB_NOTNULL, null, '0', 'visible');
// Conditionally launch add field whoassesses.
if (!$dbman->field_exists($table, $field2)) {
$dbman->add_field($table, $field2);
}
// Evalcomix savepoint reached.
upgrade_block_savepoint(true, 2013111802, 'evalcomix');
}
if ($oldversion < 2013121700) {
// Define field visible to be added to block_evalcomix_tasks.
$table = new xmldb_table('block_evalcomix_tasks');
$field = new xmldb_field('visible', XMLDB_TYPE_INTEGER, '1', null, null, null, '1', 'timemodified');
// Conditionally launch add field visible.
if (!$dbman->field_exists($table, $field)) {
$dbman->add_field($table, $field);
}
// Evalcomix savepoint reached.
upgrade_block_savepoint(true, 2013121700, 'evalcomix');
}
if ($oldversion < 2014040716) {
// Define field idtool to be added to block_evalcomix_tools.
$table = new xmldb_table('block_evalcomix_tools');
$field = new xmldb_field('idtool', XMLDB_TYPE_CHAR, '40', null, XMLDB_NOTNULL, null, '0', 'timemodified');
// Conditionally launch add field idtool.
if ($dbman->field_exists($table, $field)) {
$dbman->change_field_type($table, $field);
}
// Evalcomix savepoint reached.
upgrade_block_savepoint(true, 2014040716, 'evalcomix');
}
return $result;
}
