Calculate Participant BMI

CALCULATE PARTICIPANT BMI

Custom code description:

Add 2 fields to participant profile form: Height and Weight. Calculate participant bmi (kg/m2).

SQL statements to run:

Copy to Clipboard

INSERT INTO structure_fields(`plugin`, `model`, `tablename`, `field`, `type`, `structure_value_domain`, `flag_confidential`, `setting`, `default`, `language_help`, `language_label`, `language_tag`)
VALUES
('ClinicalAnnotation', 'Participant', 'participants', 'ctrnet_workshop_height_m', 'float_positive',  NULL , '0', '', '', '', 'height m', ''),
('ClinicalAnnotation', 'Participant', 'participants', 'ctrnet_workshop_weight_kg', 'float_positive',  NULL , '0', '', '', '', 'weight kg', ''),
('ClinicalAnnotation', 'Participant', 'participants', 'ctrnet_workshop_bmi', 'float_positive',  NULL , '0', '', '', '', 'bmi', '');

INSERT INTO structure_formats(`structure_id`, `structure_field_id`, `display_column`, `display_order`, `language_heading`, `margin`, `flag_override_label`, `language_label`, `flag_override_tag`, `language_tag`, `flag_override_help`, `language_help`, `flag_override_type`, `type`, `flag_override_setting`, `setting`, `flag_override_default`, `default`, `flag_add`, `flag_add_readonly`, `flag_edit`, `flag_edit_readonly`, `flag_search`, `flag_search_readonly`, `flag_addgrid`, `flag_addgrid_readonly`, `flag_editgrid`, `flag_editgrid_readonly`, `flag_batchedit`, `flag_batchedit_readonly`, `flag_index`, `flag_detail`, `flag_summary`, `flag_float`)
VALUES
((SELECT id FROM structures WHERE alias='participants'),
(SELECT id FROM structure_fields WHERE `model`='Participant' AND `tablename`='participants' AND `field`='ctrnet_workshop_height_m' AND `type`='float_positive' AND `structure_value_domain`  IS NULL  AND `flag_confidential`='0' AND `setting`='' AND `default`='' AND `language_help`='' AND `language_label`='height m' AND `language_tag`=''),
'2', '1', 'body mass Index', '0', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '1', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0'),
((SELECT id FROM structures WHERE alias='participants'),
(SELECT id FROM structure_fields WHERE `model`='Participant' AND `tablename`='participants' AND `field`='ctrnet_workshop_weight_kg' AND `type`='float_positive' AND `structure_value_domain`  IS NULL  AND `flag_confidential`='0' AND `setting`='' AND `default`='' AND `language_help`='' AND `language_label`='weight kg' AND `language_tag`=''),
'2', '2', '', '0', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '1', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0'),
((SELECT id FROM structures WHERE alias='participants'),
(SELECT id FROM structure_fields WHERE `model`='Participant' AND `tablename`='participants' AND `field`='ctrnet_workshop_bmi' AND `type`='float_positive' AND `structure_value_domain`  IS NULL  AND `flag_confidential`='0' AND `setting`='' AND `default`='' AND `language_help`='' AND `language_label`='bmi' AND `language_tag`=''),
'2', '3', '', '0', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0');
    
INSERT IGNORE INTO i18n (id,en,fr)
VALUES
('body mass index', 'BMI', 'BMI'),
('height m', 'Height (m)', 'Taille (m)'),
('weight kg', 'Weight (kg)', 'Poids (kg)'),
('the height can not be equal to zero to calculate the bmi', 'The height can not be equal to zero to calculate the bmi.', 'La hauteur ne peut pas être égale à zéro pour calculer le bmi.'),
('bmi', 'BMI', 'BMI');

ALTER TABLE participants 
    ADD COLUMN ctrnet_workshop_height_m decimal (10,2) DEFAULT NULL,
    ADD COLUMN ctrnet_workshop_weight_kg decimal (10,2) DEFAULT NULL,
    ADD COLUMN ctrnet_workshop_bmi decimal (10,2) DEFAULT NULL;

ALTER TABLE participants_revs
    ADD COLUMN ctrnet_workshop_height_m decimal (10,2) DEFAULT NULL,
    ADD COLUMN ctrnet_workshop_weight_kg decimal (10,2) DEFAULT NULL,
    ADD COLUMN ctrnet_workshop_bmi decimal (10,2) DEFAULT NULL;

CLICK HERE TO VIEW METHOD 1

Copy to Clipboard

<?php
// --------------------------------------------------------------------------------
// Custom Code Example : Calculate body mass index
// --------------------------------------------------------------------------------
// Participant Model Custom
// Path : \app\Plugin\ClinicalAnnotation\Model\Custom
// File Name : Participant.php
// --------------------------------------------------------------------------------

class ParticipantCustom extends Participant
{

var $useTable = 'participants';

var $name = "Participant";

/**
     * Returns true if all fields pass validation.
     *
     * Will validate the currently set data. Use Model::set() or Model::create() to set the active data.
     *
     * @param array $options An optional array of custom options to be made available in the beforeValidate callback
     * @return bool True if there are no errors
     */
    public function validates($options = array())
    {
        // Execute parent model validations
        $result = parent::validates($options);

// Validate that the value 'Height' of the model data to save is not equal to 0 else generate an error (division by 0 error)
        if (array_key_exists('Participant', $this->data) && array_key_exists('ctrnet_workshop_height_m', $this->data['Participant']) && array_key_exists('ctrnet_workshop_weight_kg', $this->data['Participant'])) {
            if (strlen($this->data['Participant']['ctrnet_workshop_height_m']) && empty($this->data['Participant']['ctrnet_workshop_height_m'])) {
                $this->validationErrors['ctrnet_workshop_height_m'][] = 'the height can not be equal to zero to calculate the bmi';
                $result = false;
            }
        }
        
        // Return results
        return $result;
    }

/**
     * Called before each save operation, after validation. Return a non-true result
     * to halt the save.
     *
     * @param array $options Options passed from Model::save().
     * @return bool True if the operation should continue, false if it should abort
     */
    public function beforeSave($options = array())
    {
        // When both 'Height' and 'Weight' fields are part of the model data to save, calculate the BMI (Body Mass Index) and set a new field to save in database table
        if (array_key_exists('Participant', $this->data) && array_key_exists('ctrnet_workshop_height_m', $this->data['Participant']) && array_key_exists('ctrnet_workshop_weight_kg', $this->data['Participant'])) {
            // Get data to save
            $heightM = $this->data['Participant']['ctrnet_workshop_height_m'];
            $weightKg = $this->data['Participant']['ctrnet_workshop_weight_kg'];
            // Calculate BMI
            $bmi = '';
            if (strlen($heightM) && strlen($weightKg)) {
                if ($heightM == 0) {
                    // No validation to do. Already done by model
                }
                $bmi = $weightKg / ($heightM * $heightM);
            }
            // Add the generated value to the data of the model to save
            $this->data['Participant']['ctrnet_workshop_bmi'] = $bmi;
            // Add value to the AppModel::$writableFields to force system to not remove generated value
            // from the data set to save (feature to prevent hacking comparing fields of the displayed form and submitted data)
            $this->addWritableField('ctrnet_workshop_bmi');
        }
        
        // Execute parent model beforeSave()
        $retVal = parent::beforeSave($options);
        
        // Return True if the operation should continue
        return $retVal;
    }
}

CALCULATE PARTICIPANT BMI

Custom code description:

SQL statements to run:

CLICK HERE TO VIEW METHOD 1

About the Author: Amelia Walker

Leave A Comment Cancel reply

Calculate Participant BMI

CALCULATE PARTICIPANT BMI

Custom code description:

SQL statements to run:

CLICK HERE TO VIEW METHOD 1

Share This Story, Choose Your Platform!

About the Author: Amelia Walker

Leave A Comment Cancel reply