private function analyzeRoutine(Routine $routine, PerformanceStatistic $statistic, $target)
{
$sum = 0;
$min = 30;
$max = 0;
$scores = $routine->getPerformanceScores()->count();
$values = [];
foreach ($routine->getPerformanceScores() as $score) {
$method = 'get' . $target;
$val = $score->{$method}();
$min = min($min, $val);
$max = max($max, $val);
$sum += $val;
$values[] = $val;
}
$avg = $sum / $scores;
$statistic->setAverage($avg);
$statistic->setMin($min);
$statistic->setMax($max);
$statistic->setRange(abs($max - $min));
// median
sort($values);
if ($scores % 2 == 0) {
$lower = floor($scores / 2);
$upper = ceil($scores / 2);
$md = ($values[$lower] + $values[$upper]) / 2;
} else {
$md = $values[ceil($scores / 2)];
}
$statistic->setMedian($md);
// sd + variance
$sum = 0;
foreach ($routine->getPerformanceScores() as $score) {
$method = 'get' . $target;
$sum += pow($val - $avg, 2);
}
$v = 1 / ($scores - 1) * $sum;
$sd = sqrt($v);
$statistic->setVariance($v);
$statistic->setStandardDeviation($sd);
$statistic->setVariabilityCoefficient($sd / $avg * 100);
$statistic->save();
return $statistic;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param ConnectionInterface $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(ConnectionInterface $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aStartgroup !== null) {
if ($this->aStartgroup->isModified() || $this->aStartgroup->isNew()) {
$affectedRows += $this->aStartgroup->save($con);
}
$this->setStartgroup($this->aStartgroup);
}
if ($this->aPerformanceTotalStatistic !== null) {
if ($this->aPerformanceTotalStatistic->isModified() || $this->aPerformanceTotalStatistic->isNew()) {
$affectedRows += $this->aPerformanceTotalStatistic->save($con);
}
$this->setPerformanceTotalStatistic($this->aPerformanceTotalStatistic);
}
if ($this->aPerformanceExecutionStatistic !== null) {
if ($this->aPerformanceExecutionStatistic->isModified() || $this->aPerformanceExecutionStatistic->isNew()) {
$affectedRows += $this->aPerformanceExecutionStatistic->save($con);
}
$this->setPerformanceExecutionStatistic($this->aPerformanceExecutionStatistic);
}
if ($this->aPerformanceChoreographyStatistic !== null) {
if ($this->aPerformanceChoreographyStatistic->isModified() || $this->aPerformanceChoreographyStatistic->isNew()) {
$affectedRows += $this->aPerformanceChoreographyStatistic->save($con);
}
$this->setPerformanceChoreographyStatistic($this->aPerformanceChoreographyStatistic);
}
if ($this->aPerformanceMusicAndTimingStatistic !== null) {
if ($this->aPerformanceMusicAndTimingStatistic->isModified() || $this->aPerformanceMusicAndTimingStatistic->isNew()) {
$affectedRows += $this->aPerformanceMusicAndTimingStatistic->save($con);
}
$this->setPerformanceMusicAndTimingStatistic($this->aPerformanceMusicAndTimingStatistic);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
$affectedRows += 1;
} else {
$affectedRows += $this->doUpdate($con);
}
$this->resetModified();
}
if ($this->scoresScheduledForDeletion !== null) {
if (!$this->scoresScheduledForDeletion->isEmpty()) {
\iuf\junia\model\ScoreQuery::create()->filterByPrimaryKeys($this->scoresScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->scoresScheduledForDeletion = null;
}
}
if ($this->collScores !== null) {
foreach ($this->collScores as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->performanceScoresScheduledForDeletion !== null) {
if (!$this->performanceScoresScheduledForDeletion->isEmpty()) {
\iuf\junia\model\PerformanceScoreQuery::create()->filterByPrimaryKeys($this->performanceScoresScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->performanceScoresScheduledForDeletion = null;
}
}
if ($this->collPerformanceScores !== null) {
foreach ($this->collPerformanceScores as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
