<?php
/**
* Copyright (C) 2009-2012 Alain Peyrat, Alcatel-Lucent
- * Copyright 2012, Franck Villaume - TrivialDev
+ * Copyright 2012-2014, Franck Villaume - TrivialDev
* http://fusionforge.org
*
* This file is part of FusionForge. FusionForge is free software;
echo $HTML->getJavascripts();
echo $HTML->getStylesheets();
+
$report = new ReportPerGroupDocmanDownloads($group_id, $start, $end);
+
if ($report->isError()) {
- echo '<p class="error_msg">'.$report->getErrorMessage().'</p>';
+ echo html_e('p', array('class' => 'error_msg'), $report->getErrorMessage(), false);
} else {
-?>
-
-<form action="<?php echo util_make_url('/docman/') ?>"
- method="get"
- class="align-center">
- <input type="hidden" name="group_id" value="<?php echo $group_id; ?>" />
- <input type="hidden" name="view" value="reporting" />
- <strong><?php echo _('Start Date')._(':'); ?></strong>
- <?php echo report_months_box($report, 'start', $start); ?>
- <strong><?php echo _('End Date')._(':'); ?></strong>
- <?php echo report_months_box($report, 'end', $end); ?>
- <input type="submit" name="submit" value="<?php echo _('Refresh'); ?>" />
-</form>
-<?php
+ echo html_ao('form', array('action' => util_make_uri('/docman/?group_id='.$group_id.'&view=reporting'), 'method' => 'post', 'class' => 'align-center'));
+ echo html_ao('div', array('id' => 'div_form_reporting'));
+ echo html_e('strong', array(), _('Start Date')._(':'), false);
+ echo report_months_box($report, 'start', $start);
+ echo html_e('strong', array(), _('End Date')._(':'), false);
+ echo html_e('input', array('type' => 'submit', 'value' => _('Refresh')));
+ echo html_ac(html_ap() -2);
$data = $report->getData();
if (count($data) == 0) {
- echo '<p class="information">';
- echo _('There have been no viewed documents for this project yet.');
- echo '</p>';
+ echo html_e('p', array('class' => 'information'), _('There have been no viewed documents for this project yet.'), false);
} else {
- echo '<script type="text/javascript">//<![CDATA['."\n";
+ echo '<script type="text/javascript">';
+ echo '//<![CDATA['."\n";
echo 'var ticks = new Array();';
echo 'var values = new Array();';
$arr =& $report->getMonthStartArr();
echo 'jQuery(window).resize(function() {
plot1.replot( { resetAxes: true } );
});'."\n";
- echo '//]]></script>';
+ echo '//]]>';
+ echo '</script>';
echo '<div id="chart1"></div>';
$tabletop = array(_('Folder'), _('Document'), _('User'), _('Date'));
$classth = array('', '', '', '');
echo $HTML->listTableTop($tabletop, false, 'sortable_docman_listfile', 'sortable', $classth);
- for ($i=0; $i<count($data); $i++) {
- $date = preg_replace('/^(....)(..)(..)$/', '\1-\2-\3', $data[$i][2]);
+ for ($i = 0; $i < count($data); $i++) {
$ndg = new DocumentGroup($g, $data[$i][3]);
- $path = $ndg->getPath(true);
- echo '<tr '. $HTML->boxGetAltRowStyle($i) .'>'.
- '<td>'.$path.'</td>'.
- '<td>'. $data[$i][0] .'</td>';
+ $cells = array();
+ $cells[][] = $ndg->getPath(true);
+ $cells[][] = $data[$i][0];
- $userObject = user_get_object($data[$i][1]);
- $cells[][] = util_display_user($userObject->getUnixName(), $data[$i][1], $userObject->getRealName());
+ if ( $data[$i][1] != 100) {
+ $userObject = user_get_object($data[$i][1]);
- echo '<td>'.util_display_user($userObject->getUnixname(), $data[$i][1], $userObject->getRealname()).'</td>';
++ $cells[][] = util_display_user($userObject->getUnixName(), $data[$i][1], $userObject->getRealName());
+ } else {
- echo '<td>'._('Anonymous user').'</td>';
++ $cells[][] = _('Anonymous user');
+ }
- echo '<td class="align-center">'. $date .'</td></tr>';
+ $cells[] = array(preg_replace('/^(....)(..)(..)$/', '\1-\2-\3', $data[$i][2]), 'class' => 'align-center');
+ echo $HTML->multiTableRow(array(), $cells);
}
echo $HTML->listTableBottom();
}
if (function_exists("pg_pconnect")) {
$gfconn = pg_pconnect(pg_connectstring(forge_get_config('database_name'), forge_get_config('database_user'), forge_get_config('database_password'), forge_get_config('database_host'), forge_get_config('database_port')));
if (!$gfconn) {
- print forge_get_config ('forge_name')." Could Not Connect to Database: ".db_error();
+ print forge_get_config('forge_name')." Could Not Connect to Database: ".db_error();
- exit;
+ exit(1);
}
} else {
print("function pg_pconnect doesn't exist: no postgresql interface");
- exit;
+ exit(1);
}
//
* @param string $file File that contains the SQL statements.
* @param int $limit How many rows do you want returned.
* @param int $offset Of matching rows, return only rows starting here.
- * @param int $dbserver ability to spread load to multiple db servers.
+ * @param resource $dbserver ability to spread load to multiple db servers.
* @return int result set handle.
*/
function db_query_from_file($file, $limit = -1, $offset = 0, $dbserver = NULL) {
global $sysdebug_dbquery, $sysdebug_dberrors;
db_connect_if_needed();
- $dbconn = db_switcher($dbserver) ;
+ $dbconn = db_switcher($dbserver);
global $QUERY_COUNT;
$QUERY_COUNT++;
db_error($dbserver) . "), SQL: " . $qstring,
$sysdebug_dbquery ? debug_string_backtrace() : false);
} else {
- error_log('SQL: ' . preg_replace('/\n\t+/', ' ', $qstring));
- error_log('SQL> ' . db_error($dbserver));
+ error_log('SQL: '.preg_replace('/\n\t+/', ' ', $qstring));
+ error_log('SQL> '.db_error($dbserver));
}
return $res;
}
* @param array $params parameters
* @param int $limit How many rows do you want returned.
* @param int $offset Of matching rows, return only rows starting here.
- * @param int $dbserver Ability to spread load to multiple db servers.
+ * @param resource $dbserver Ability to spread load to multiple db servers.
* @return resource result set handle.
*/
-function db_query_params($qstring, $params, $limit = -1, $offset = 0, $dbserver = NULL) {
+function db_query_params($qstring, $params = array(), $limit = -1, $offset = 0, $dbserver = NULL) {
global $sysdebug_dbquery, $sysdebug_dberrors;
db_connect_if_needed();
- $dbconn = db_switcher($dbserver) ;
+ $dbconn = db_switcher($dbserver);
global $QUERY_COUNT;
$QUERY_COUNT++;
db_error($dbserver) . "), SQL: " . $qstring,
print_r(array("params" => $params), 1));
} else {
- error_log('SQL: ' . preg_replace('/\n\t+/', ' ', $qstring));
- error_log('SQL> ' . db_error($dbserver));
+ error_log('SQL: '.preg_replace('/\n\t+/', ' ', $qstring));
+ error_log('SQL> '.db_error($dbserver));
}
return $res;
}
global $sysdebug_dbquery, $sysdebug_dberrors;
db_connect_if_needed();
- $dbconn = db_switcher($dbserver) ;
+ $dbconn = db_switcher($dbserver);
global $QUERY_COUNT;
$QUERY_COUNT++;
* @param array $qpa array(query, array(parameters...))
* @param int $limit How many rows do you want returned.
* @param int $offset Of matching rows, return only rows starting here.
- * @param int $dbserver Ability to spread load to multiple db servers.
+ * @param resource $dbserver Ability to spread load to multiple db servers.
* @return resource result set handle.
*/
function db_query_qpa($qpa, $limit = -1, $offset = 0, $dbserver = NULL) {
/**
* db_begin() - Begin a transaction.
*
- * @param int $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
+ * @param resource $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
* @return bool true.
*/
function db_begin($dbserver = NULL) {
/**
* db_commit - Commit a transaction.
*
- * @param int $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
+ * @param resource $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
* @return bool true on success/false on failure.
*/
function db_commit($dbserver = NULL) {
/**
* db_rollback - Rollback a transaction.
*
- * @param int $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
+ * @param resource $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
* @return bool true on success/false on failure.
*/
function db_rollback($dbserver = NULL) {
/**
* db_free_result - Frees a database result properly.
*
- * @param int $qhandle Query result set handle.
+ * @param resource $qhandle Query result set handle.
* @return bool
*/
function db_free_result($qhandle) {
/**
* db_result_seek - Sets cursor location in a result set.
*
- * @param int Query result set handle.
- * @param int Row number.
+ * @param resource $qhandle Query result set handle.
+ * @param int $row Row number.
* @return boolean True on success
*/
function db_result_seek($qhandle,$row) {
/**
* db_result_reset - Resets cursor location in a result set.
*
- * @param int $qhandle Query result set handle.
+ * @param resource $qhandle Query result set handle.
* @param int $row
* @return boolean True on success
*/
* @param resource $qhandle Query result set handle.
* @param string $table_name Name of the table you inserted into.
* @param string $pkey_field_name Field name of the primary key.
- * @param string $dbserver Server to which original query was made
+ * @param resource $dbserver Server to which original query was made
* @return int id of the primary key or 0 on failure.
*/
function db_insertid($qhandle, $table_name, $pkey_field_name, $dbserver = NULL) {
/**
* db_error - Returns the last error from the database.
*
- * @param int $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
+ * @param resource $dbserver Database server (SYS_DB_PRIMARY, SYS_DB_STATS, SYS_DB_TROVE, SYS_DB_SEARCH)
* @return string error message.
*/
function db_error($dbserver = NULL) {
function db_drop_sequence_if_exists($name) {
if (!db_check_sequence_exists($name)) {
- return;
+ return true;
}
$sql = "DROP SEQUENCE $name";
$res = db_query_params($sql, array());
}
$current = db_result($res, 0, 0);
}
+ return true;
}
function db_int_array_to_any_clause($arr) {
return array($sql, $params, $max);
}
-function db_join_qpa($old_qpa = false, $new_qpa = false) {
+function db_join_qpa($old_qpa = array(), $new_qpa = array()) {
return db_construct_qpa($old_qpa, $new_qpa[0], $new_qpa[1]);
}