public function save_parents($child_version_id = 0, $array = array(), $start_seconds = array(), $end_seconds = array(), $start_line_nums = array(), $end_line_nums = array(), $points = array())
{
// Insert new relationships
$j = 0;
foreach ($array as $version_urn) {
if (isURN($version_urn)) {
$parent_version_id = $this->version_urn_to_version_id($version_urn);
}
if (empty($parent_version_id)) {
continue;
}
$_start_seconds = isset($start_seconds[$j]) ? $start_seconds[$j] : 0;
$_end_seconds = isset($end_seconds[$j]) ? $end_seconds[$j] : 0;
$_start_line_num = isset($start_line_nums[$j]) ? $start_line_nums[$j] : 0;
$_end_line_num = isset($end_line_nums[$j]) ? $end_line_nums[$j] : 0;
$_points = isset($points[$j]) ? $points[$j] : '';
$data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'start_seconds' => $_start_seconds, 'end_seconds' => $_end_seconds, 'start_line_num' => $_start_line_num, 'end_line_num' => $_end_line_num, 'points' => $_points);
$this->db->insert($this->annotations_table, $data);
if (mysql_errno() != 0) {
echo 'MySQL ERROR: ' . mysql_error() . "\n";
}
$j++;
}
return true;
}
public function save_parents($child_version_id, $array = array())
{
$array = array_unique($array);
// Establish new connections
foreach ($array as $version_urn) {
if (isURN($version_urn)) {
$parent_version_id = $this->version_urn_to_version_id($version_urn);
}
if (empty($parent_version_id)) {
continue;
}
$data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id);
$this->db->insert($this->tags_table, $data);
}
return true;
}
public function save_parents($child_version_id, $array = array())
{
$array = array_unique($array);
// Delete previous connections
$this->db->select('*');
$this->db->from($this->tags_table);
$this->db->where('child_version_id', $child_version_id);
$query = $this->db->get();
$result = $query->result();
// Establish new connections
foreach ($array as $version_urn) {
if (isURN($version_urn)) {
$parent_version_id = $this->version_urn_to_version_id($version_urn);
}
if (empty($parent_version_id)) {
continue;
}
$data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id);
$this->db->insert($this->tags_table, $data);
}
return true;
}
public function save_children($parent_version_id = 0, $array = array(), $reference_array = array())
{
if (empty($parent_version_id)) {
throw new Exception('Inalid parent version ID');
}
if (empty($array)) {
return;
}
for ($i = 0; $i < count($array); $i++) {
if (isURN($array[$i])) {
$child_version_id = $this->page_urn_to_content_id($array[$i]);
}
if (empty($child_version_id)) {
continue;
}
$reference_text = isset($reference_array[$i]) ? trim($reference_array[$i]) : '';
$this->db->select('*');
$this->db->from($this->references_table);
$this->db->where('parent_version_id', $parent_version_id);
$this->db->where('child_version_id', $child_version_id);
$query = $this->db->get();
if ($query->num_rows > 0) {
continue;
}
$data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'reference_text' => $reference_text);
$this->db->insert($this->references_table, $data);
}
}
public function save_parents($child_version_id = 0, $array = array(), $sort_numbers = 0)
{
if (count($array) == 0) {
return;
}
// Insert new relationships
$count = 0;
foreach ($array as $version_urn) {
if (isURN($version_urn)) {
$parent_version_id = $this->version_urn_to_version_id($version_urn);
}
if (empty($parent_version_id)) {
continue;
}
$sort_number = @(int) $sort_numbers[$count];
$data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'sort_number' => $sort_number);
$done = $this->db->insert($this->paths_table, $data);
if (mysql_errno() != 0) {
echo 'MySQL ERROR: ' . mysql_error() . "\n";
}
$count++;
}
return true;
}
public function save_parents($child_version_id, $array = array(), $paragraph_num_array = array(), $created_array = array())
{
$array = array_unique($array);
// Establish new connections
$j = 0;
foreach ($array as $version_urn) {
if (isURN($version_urn)) {
$parent_version_id = $this->version_urn_to_version_id($version_urn);
}
if (empty($parent_version_id)) {
continue;
}
$paragraph_num = (int) $paragraph_num_array[$j];
$created = $created_array[$j];
if (empty($created)) {
$created = date('c');
}
$data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'paragraph_num' => $paragraph_num, 'datetime' => $created);
$this->db->insert($this->replies_table, $data);
$j++;
}
return true;
}
