/**
* Add trainer to training session
*/
public static function addTrainerToTraining($trainer_id, $training_id, $duration_days)
{
$tableObj = new TrainingToTrainer();
$select = $tableObj->select()->from($tableObj->_name, array('doesExist' => 'COUNT(*)'))->setIntegrityCheck(false)->where("trainer_id = {$trainer_id} AND training_id = {$training_id}");
$row = $tableObj->fetchRow($select);
if ($row->doesExist) {
return -1;
} else {
$data['trainer_id'] = $trainer_id;
$data['training_id'] = $training_id;
$data['duration_days'] = $duration_days;
try {
return $tableObj->insert($data);
} catch (Zend_Exception $e) {
error_log($e);
}
}
}
public static function isReferenced($id)
{
require_once 'PersonToTraining.php';
$participant = new PersonToTraining();
$select = $participant->select();
$select->where("person_id = ?", $id);
if ($participant->fetchRow($select)) {
return true;
}
require_once 'TrainingToTrainer.php';
$trainer = new TrainingToTrainer();
$select = $trainer->select();
$select->where("trainer_id = ?", $id);
if ($trainer->fetchRow($select)) {
return true;
}
return false;
}