/** * Get log data * * @param integer $revision_to * @param mixed $revision_from * @return array */ function getLogs($revision_to, $revision_from = 'HEAD', $logs_per_query = 100) { // get multiple logs or a single one if (!is_null($revision_from)) { $r = $revision_from . ':' . $revision_to; } else { $r = $revision_to; $this->triggerred_by_handler = true; } // if $string = 'log -r ' . $r . ' --xml --verbose ' . $this->active_repository->getUrl(); $this->execute($string); $log_data = xml2array(implode("\n", $this->output), 1, array('path', 'logentry')); $insert_data = array(); $i = 1; // this is because we get commits from SVN sorted from newest to oldest $logs = is_array($log_data['log']['logentry']) ? array_reverse($log_data['log']['logentry']) : array(); // loop through array of log entries foreach ($logs as $key => $log_entry) { // prevent duplicate entries in case when there are two separate update processes // (like, both scheduled task and aC user triggered the update if (Commits::count("parent_id = '" . $this->active_repository->getId() . "' AND integer_field_1 = '" . $log_entry['attr']['revision'] . "'") > 0) { continue; } // if $paths = array(); $k = 0; foreach ($log_entry['paths']['path'] as $path) { $paths[$k]['path'] = mysql_real_escape_string($path['value']); // paths can contain file names with characters that can break the query $paths[$k]['action'] = $path['attr']['action']; $k++; } // foreach $date = new DateTimeValue($log_entry['date']['value']); $log_date = $date->getYear() . "-" . $date->getMonth() . '-' . $date->getDay() . ' ' . $date->getHour() . ':' . $date->getMinute() . ':' . $date->getSecond(); $commit_message = Commit::analyze_message($log_entry['msg']['value'], $log_entry['author']['value'], $log_entry['attr']['revision'], $this->active_repository, $this->active_project); $insert_data[$i][$key] = "('Commit','Source','" . $this->active_project->getId() . "','" . $this->active_repository->getId() . "','Repository','" . mysql_real_escape_string($commit_message) . "','" . $log_entry['attr']['revision'] . "','" . serialize($paths) . "','" . mysql_real_escape_string($log_entry['author']['value']) . "','{$log_date}', '" . STATE_VISIBLE . "', '" . $this->active_repository->getVisibility() . "')"; $i = count($insert_data[$i]) < $logs_per_query ? $i : $i + 1; } // foreach return array('data' => $insert_data, 'total' => count($logs)); }