/** * 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; }