public function saveProgramm(GymProgramm $programm)
{
$programmId = $programm->getId();
if ($programmId && $this->isProgrammExists($programmId)) {
$this->deleteProgrammContent($programmId);
$this->update('update gym_programm set name=?, description=? where id_gym_programm=?', array($programm->getName(), $programm->getComment(), $programmId));
} else {
$programmId = $this->insert('insert into gym_programm (name, description) values(?, ?)', array($programm->getName(), $programm->getComment()));
}
$ex_num = 0;
/* @var $ex GymProgrammEx */
foreach ($programm->getExercises() as $ex) {
$id_ex = $this->insert('insert into gym_programm_exercises (id_gym_programm, id_gym_ex, name, description, n_order) values (?, ?, ?, ?, ?)', array($programmId, $ex->getId(), $ex->getName(), $ex->getComment(), ++$ex_num));
$set_num = 0;
/* @var $ex GymProgrammEx */
foreach ($ex->getSets() as $set) {
$this->insert('insert into gym_sets (id_gym_programm, id_gym_programm_exercise, value, n_order) values (?, ?, ?, ?)', array($programmId, $id_ex, $set, ++$set_num));
}
}
return $programmId;
}
