table = Database::get_main_table(TABLE_GRADE_MODEL);
}
/**
* @param array $where_conditions
* @return array
*/
public function get_all($where_conditions = array())
{
return Database::select('*', $this->table, array('where' => $where_conditions, 'order' => 'name ASC'));
}
/**
* @return mixed
*/
public function get_count()
{
$row = Database::select('count(*) as count', $this->table, array(), 'first');
return $row['count'];
}
/**
* Displays the title + grid
*/
public function display()
{
// action links
echo '
';
echo Display::grid_html('grade_model');
}
/**
* Returns a Form validator Obj
* @param string url
* @param string action add, edit
* @return obj form validator obj
*/
public function return_form($url, $action)
{
$form = new FormValidator('grades', 'post', $url);
// Setting the form elements
$header = get_lang('Add');
if ($action == 'edit') {
$header = get_lang('Modify');
}
$form->addElement('header', $header);
$id = isset($_GET['id']) ? intval($_GET['id']) : '';
$form->addElement('hidden', 'id', $id);
$form->addElement('text', 'name', get_lang('Name'), array('size' => '70'));
$form->add_html_editor(
'description',
get_lang('Description'),
false,
false,
array('ToolbarSet' => 'careers', 'Width' => '100%', 'Height' => '250')
);
$form->addElement('label', get_lang('Components'));
//Get components
$nr_items = 2;
$max = 10;
// Setting the defaults
$defaults = $this->get($id);
$components = $this->get_components($defaults['id']);
if ($action == 'edit') {
if (!empty($components)) {
$nr_items = count($components) - 1;
}
}
$form->addElement('hidden', 'maxvalue', '100');
$form->addElement('hidden', 'minvalue', '0');
$renderer = & $form->defaultRenderer();
$component_array = array();
for ($i = 0; $i <= $max; $i++) {
$counter = $i;
$form->addElement('text', 'components['.$i.'][percentage]', null, array('class' => 'span1'));
$form->addElement(
'text',
'components['.$i.'][acronym]',
null,
array('class' => 'span1', 'placeholder' => get_lang('Acronym'))
);
$form->addElement(
'text',
'components['.$i.'][title]',
null,
array('class' => 'span2', 'placeholder' => get_lang('Title'))
);
$form->addElement(
'text',
'components['.$i.'][prefix]',
null,
array('class' => 'span1', 'placeholder' => get_lang('Prefix'))
);
$options = array(0 => 0, 1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5);
$form->addElement('select', 'components['.$i.'][count_elements]', null, $options);
$options = array(0 => 0, 1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5);
$form->addElement('select', 'components['.$i.'][exclusions]', null, $options);
$form->addElement('hidden', 'components['.$i.'][id]');
$template_percentage =
'';
$renderer->setElementTemplate($template_acronym, 'components['.$i.'][title]');
$renderer->setElementTemplate($template_percentage, 'components['.$i.'][percentage]');
$renderer->setElementTemplate($template_acronym, 'components['.$i.'][acronym]');
$renderer->setElementTemplate($template_acronym, 'components['.$i.'][prefix]');
$renderer->setElementTemplate($template_title, 'components['.$i.'][exclusions]');
$renderer->setElementTemplate($template_acronym, 'components['.$i.'][count_elements]');
if ($i == 0) {
$form->addRule('components['.$i.'][percentage]', get_lang('ThisFieldIsRequired'), 'required');
$form->addRule('components['.$i.'][title]', get_lang('ThisFieldIsRequired'), 'required');
$form->addRule('components['.$i.'][acronym]', get_lang('ThisFieldIsRequired'), 'required');
}
$form->addRule('components['.$i.'][percentage]', get_lang('OnlyNumbers'), 'numeric');
$form->addRule(array('components['.$i.'][percentage]', 'maxvalue'), get_lang('Over100'), 'compare', '<=');
$form->addRule(array('components['.$i.'][percentage]', 'minvalue'), get_lang('UnderMin'), 'compare', '>=');
$component_array[] = 'components['.$i.'][percentage]';
}
//New rule added in the formvalidator compare_fields that filters a group of fields in order to compare with the wanted value
$form->addRule($component_array, get_lang('AllMustWeight100'), 'compare_fields', '==@100');
$form->addElement('label', null, get_lang('AllMustWeight100'));
if ($action == 'edit') {
$form->addElement('style_submit_button', 'submit', get_lang('Modify'), 'class="save"');
} else {
$form->addElement('style_submit_button', 'submit', get_lang('Add'), 'class="save"');
}
if (!empty($components)) {
$counter = 0;
foreach ($components as $component) {
foreach ($component as $key => $value) {
$defaults['components['.$counter.']['.$key.']'] = $value;
}
$counter++;
}
}
$form->setDefaults($defaults);
// Setting the rules
$form->addRule('name', get_lang('ThisFieldIsRequired'), 'required');
return $form;
}
/**
* @param $id
* @return array|null
*/
public function get_components($id)
{
$obj = new GradeModelComponents();
if (!empty($id)) {
return $obj->get_all(array('where' => array('grade_model_id = ?' => $id)));
}
return null;
}
/**
* @param $params
* @param bool $show_query
* @return bool
*/
public function save($params, $show_query = false)
{
$id = parent::save($params, $show_query);
if (!empty($id)) {
foreach ($params['components'] as $component) {
if (!empty($component['title']) && !empty($component['percentage']) && !empty($component['acronym'])) {
$obj = new GradeModelComponents();
$component['grade_model_id'] = $id;
$obj->save($component);
}
}
}
//Event::addEvent(LOG_CAREER_CREATE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id());
return $id;
}
/**
* @param array $params
* @return bool|void
*/
public function update($params)
{
parent::update($params);
if (!empty($params['id'])) {
foreach ($params['components'] as $component) {
$obj = new GradeModelComponents();
$component['grade_model_id'] = $params['id'];
if (empty($component['title']) && empty($component['percentage']) && empty($component['acronym'])) {
$obj->delete($component['id']);
} else {
$obj->update($component);
}
}
}
//$params['components']
}
/**
* @param int $id
* @return bool|void
*/
public function delete($id)
{
parent::delete($id);
//Event::addEvent(LOG_CAREER_DELETE, LOG_CAREER_ID, $id, api_get_utc_datetime(), api_get_user_id());
}
public function fill_grade_model_select_in_form(&$form, $name = 'gradebook_model_id', $default_value = null)
{
if (api_get_setting('gradebook.gradebook_enable_grade_model') ==
'false') {
return false;
}
if (api_get_setting('gradebook.teachers_can_change_grade_model_settings') == 'true' || api_is_platform_admin()) {
$grade_models = $this->get_all();
$grade_model_options = array('-1' => get_lang('None'));
if (!empty($grade_models)) {
foreach ($grade_models as $item) {
$grade_model_options[$item['id']] = $item['name'];
}
}
$form->addElement('select', $name, get_lang('GradeModel'), $grade_model_options);
$default_platform_setting = api_get_setting('gradebook.gradebook_default_grade_model_id');
$default = -1;
if ($default_platform_setting == -1) {
if (!empty($default_value)) {
$default = $default_value;
}
} else {
$default = $default_platform_setting;
}
if (!empty($default) && $default != '-1') {
$form->setDefaults(array($name => $default));
}
}
}
}
//@todo move in another file
class GradeModelComponents extends Model
{
public $table;
public $columns = array(
'id',
'title',
'percentage',
'acronym',
'grade_model_id',
'prefix',
'exclusions',
'count_elements'
);
public function __construct()
{
$this->table = Database::get_main_table(TABLE_GRADE_MODEL_COMPONENTS);
}
public function save($params, $show_query = false)
{
$id = parent::save($params, $show_query);
return $id;
}
}