/**
* write details of a specific user into $kga
*
* @param integer $user ID of user in table usr
* @global array $kga kimai-global-array
* @return array $kga
* @author th
*
*/
function get_user_config($user)
{
global $kga, $pdo_conn;
$p = $kga['server_prefix'];
if (!$user) {
return;
}
// get values from user record
$pdo_query = $pdo_conn->prepare("SELECT\n `usr_ID`,\n `usr_name`,\n `usr_grp`,\n `usr_sts`,\n `usr_trash`,\n `usr_active`,\n `usr_mail`,\n `pw`,\n `ban`,\n `banTime`,\n `secure`,\n\n `lastProject`,\n `lastEvent`,\n `lastRecord`,\n `timespace_in`,\n `timespace_out`\n\n FROM {$p}usr WHERE usr_ID = ?;");
$result = $pdo_query->execute(array($user));
$row = $pdo_query->fetch(PDO::FETCH_ASSOC);
foreach ($row as $key => $value) {
$kga['usr'][$key] = $value;
}
$kga['conf'] = array_merge($kga['conf'], usr_get_preferences_by_prefix('ui.', $kga['usr']['usr_ID']));
$userTimezone = usr_get_preference('timezone');
if ($userTimezone != '') {
$kga['conf']['timezone'] = $userTimezone;
}
date_default_timezone_set($kga['conf']['timezone']);
}
/**
* write details of a specific user into $kga
*
* @param integer $user ID of user in table usr
* @global array $kga kimai-global-array
* @return array $kga
* @author th
*
*/
function get_user_config($user)
{
global $kga, $conn;
if (!$user) {
return;
}
$table = $kga['server_prefix'] . "usr";
$filter['usr_ID'] = MySQL::SQLValue($user, MySQL::SQLVALUE_NUMBER);
// get values from user record
$columns[] = "usr_ID";
$columns[] = "usr_name";
$columns[] = "usr_grp";
$columns[] = "usr_sts";
$columns[] = "usr_trash";
$columns[] = "usr_active";
$columns[] = "usr_mail";
$columns[] = "pw";
$columns[] = "ban";
$columns[] = "banTime";
$columns[] = "secure";
$columns[] = "lastProject";
$columns[] = "lastEvent";
$columns[] = "lastRecord";
$columns[] = "timespace_in";
$columns[] = "timespace_out";
$conn->SelectRows($table, $filter, $columns);
$rows = $conn->RowArray(0, MYSQL_ASSOC);
foreach ($rows as $key => $value) {
$kga['usr'][$key] = $value;
}
// get values from user configuration (user-preferences)
unset($columns);
unset($filter);
$kga['conf'] = array_merge($kga['conf'], usr_get_preferences_by_prefix('ui.'));
$userTimezone = usr_get_preference('timezone');
if ($userTimezone != '') {
$kga['conf']['timezone'] = $userTimezone;
}
date_default_timezone_set($kga['conf']['timezone']);
}
case "PDF":
$defaults = array('print_comments' => 1, 'print_summary' => 1, 'create_bookmarks' => 1, 'download_pdf' => 1, 'customer_new_page' => 0, 'reverse_order' => 0, 'pdf_format' => 'export_pdf');
$prefs = usr_get_preferences_by_prefix('ki_export.pdf.');
$tpl->assign('prefs', array_merge($defaults, $prefs));
$tpl->display("export_PDF.tpl");
break;
case "XLS":
$defaults = array('reverse_order' => 0);
$prefs = usr_get_preferences_by_prefix('ki_export.xls.');
$tpl->assign('prefs', array_merge($defaults, $prefs));
$tpl->display("export_XLS.tpl");
break;
case "CSV":
$defaults = array('column_delimiter' => ',', 'quote_char' => '"', 'reverse_order' => 0);
$prefs = usr_get_preferences_by_prefix('ki_export.csv.');
$tpl->assign('prefs', array_merge($defaults, $prefs));
$tpl->display("export_CSV.tpl");
break;
case "print":
$defaults = array('print_summary' => 1, 'reverse_order' => 0);
$prefs = usr_get_preferences_by_prefix('ki_export.print.');
$tpl->assign('prefs', array_merge($defaults, $prefs));
$tpl->display("print.tpl");
break;
case "help_timeformat":
$tpl->display("help_timeformat.tpl");
break;
}
?>
