public function get_source($id, $batch_id, $options)
{
$sql = 'SELECT rs.id AS id,rs.source_title AS title' . ' FROM rp_source rs WHERE rs.id = ? AND rs.batch_id = ? ';
$sql_query = new RP_Sql_Query($sql, $this->prefix);
$sql_query->set($id);
$sql_query->set_number($batch_id);
$row = RP_Query_Executor::execute($sql_query);
$src = new RP_Evidence();
$src->id = $row[0]['id'];
$src->batch_id = $batch_id;
$src->source_title = $row[0]['title'];
$src->citations = RP_Dao_Factory::get_rp_source_cite_dao($this->prefix)->query_by_src($src->id, $batch_id);
$src->persons = $this->get_persons($src, $options);
$src->notes = RP_Dao_Factory::get_rp_source_note_dao($this->prefix)->query_by_src($src->id, $batch_id);
return $src;
}
/**
*
* @param RP_Source_Record $source
*/
function update_src_notes($source)
{
RP_Dao_Factory::get_rp_source_note_dao($this->credentials->prefix)->delete_by_src($source->id, $this->batch_id);
foreach ($source->notes as $note) {
$src_note = new RP_Source_Note();
$src_note->source_id = $source->id;
$src_note->source_batch_id = $this->batch_id;
$src_note->note_rec_id = $note->id;
$src_note->note = $note->text;
try {
$id = RP_Dao_Factory::get_rp_source_note_dao($this->credentials->prefix)->insert($src_note);
} catch (Exception $e) {
error_log($e->getMessage() . "::" . RP_Persona_Helper::trace_caller(), 0);
echo $e->getMessage();
throw $e;
}
}
}
