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 string $event_id
* @param integer $batch_id
* @param array $citations
*/
function update_event_citations($event_id, $batch_id, $citations)
{
foreach ($citations as $citation) {
$cite = new RP_Source_Cite();
$cite->source_id = $citation->source_id;
$cite->source_batch_id = $batch_id;
$cite->source_page = $citation->page;
$cite->event_type = $citation->event_type;
$cite->event_role = $citation->role_in_event;
$cite->quay = $citation->quay;
try {
$id = RP_Dao_Factory::get_rp_source_cite_dao($this->credentials->prefix)->insert($cite);
} catch (Exception $e) {
error_log($e->getMessage() . "::" . RP_Persona_Helper::trace_caller(), 0);
echo $e->getMessage();
throw $e;
}
$event_cite = new RP_Event_Cite();
$event_cite->event_id = $event_id;
$event_cite->cite_id = $id;
try {
$id = RP_Dao_Factory::get_rp_event_cite_dao($this->credentials->prefix)->insert($event_cite);
} catch (Exception $e) {
error_log($e->getMessage() . "::" . RP_Persona_Helper::trace_caller(), 0);
echo $e->getMessage();
throw $e;
}
}
}
