eb299c9131
Kimai time management system (PHP 5.6 / MySQL) with custom extensions: - Budget tracking (ki_budget) - Change request form (ki_changerequest) - Invoice generation (ki_invoice) - Expense tracking (ki_expenses) - Flexi time (ki_flexitime) - Export, admin panel, timesheets, tasks, summary Database: ~900K time entries, 2,000+ users, 439 projects. Config: includes/autoconf.php — localhost/kimai/kimai
330 lines
15 KiB
PHP
330 lines
15 KiB
PHP
<?php
|
|
/**
|
|
* This file is part of
|
|
* Kimai - Open Source Time Tracking // http://www.kimai.org
|
|
* (c) 2006-2009 Kimai-Development-Team
|
|
*
|
|
* Kimai is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation; Version 3, 29 June 2007
|
|
*
|
|
* Kimai is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with Kimai; If not, see <http://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
$all_column_headers = array('date','from','to','time','dec_time','rate','wage','knd','division','pct','evt','comment','location','trackingnr','user','cleared');
|
|
|
|
|
|
// Determine if the expenses extension is used.
|
|
$expense_ext_available = false;
|
|
if (file_exists('../ki_expenses/private_db_layer_'.$kga['server_conn'].'.php')) {
|
|
include('../ki_expenses/private_db_layer_'.$kga['server_conn'].'.php');
|
|
$expense_ext_available = true;
|
|
}
|
|
include('private_db_layer_'.$kga['server_conn'].'.php');
|
|
|
|
/**
|
|
* Get a combined array with time recordings and expenses to export.
|
|
*
|
|
* @param int $start Time from which to take entries into account.
|
|
* @param int $end Time until which to take entries into account.
|
|
* @param array $users Array of user IDs to filter by.
|
|
* @param array $customers Array of customer IDs to filter by.
|
|
* @param array $projects Array of project IDs to filter by.
|
|
* @param array $events Array of event IDs to filter by.
|
|
* @param bool $limit sbould the amount of entries be limited
|
|
* @param bool $reverse_order should the entries be put out in reverse order
|
|
* @param string $default_location use this string if no location is set for the entry
|
|
* @param int $filter_cleared (-1: show all, 0:only cleared 1: only not cleared) entries
|
|
* @param int $filter_type (-1 show time and expenses, 0: only show time entries, 1: only show expenses)
|
|
* @param int $limitCommentSize should comments be cut off, when they are too long
|
|
* @return array with time recordings and expenses chronologically sorted
|
|
*/
|
|
function xp_get_arr($start,$end,$users = null,$customers = null,$projects = null,$events = null,$limit=false,$reverse_order=false,$default_location='',$filter_cleared=-1,$filter_type=-1,$limitCommentSize=true,$filter_refundable=-1) {
|
|
global $expense_ext_available;
|
|
|
|
$zef_arr = array();
|
|
$exp_arr = array();
|
|
|
|
if ($filter_type != 1)
|
|
$zef_arr = get_arr_zef($start,$end,$users,$customers,$projects,$events,$limit,$reverse_order,$filter_cleared);
|
|
|
|
if ($filter_type != 0 && $expense_ext_available)
|
|
$exp_arr = get_arr_exp($start,$end,$users,$customers,$projects,$limit,$reverse_order,$filter_refundable,$filter_cleared);
|
|
|
|
$result_arr = array();
|
|
|
|
$zef_arr_index = 0;
|
|
$exp_arr_index = 0;
|
|
while ($zef_arr_index < count($zef_arr) && $exp_arr_index < count($exp_arr)) {
|
|
$arr = array();
|
|
if ( (!$reverse_order && ($zef_arr[$zef_arr_index]['zef_in'] > $exp_arr[$exp_arr_index]['exp_timestamp']) ) ||
|
|
( $reverse_order && ($zef_arr[$zef_arr_index]['zef_in'] < $exp_arr[$exp_arr_index]['exp_timestamp']) ) ) {
|
|
|
|
if ($zef_arr[$zef_arr_index]['zef_out'] != 0) {
|
|
// active recordings will be omitted
|
|
$arr['type'] = 'zef';
|
|
$arr['id'] = $zef_arr[$zef_arr_index]['zef_ID'];
|
|
$arr['time_in'] = $zef_arr[$zef_arr_index]['zef_in'];
|
|
$arr['time_out'] = $zef_arr[$zef_arr_index]['zef_out'];
|
|
$arr['zef_time'] = $zef_arr[$zef_arr_index]['zef_time'];
|
|
$arr['zef_duration'] = $zef_arr[$zef_arr_index]['zef_duration'];
|
|
$arr['dec_zef_time'] = sprintf("%01.2f",$zef_arr[$zef_arr_index]['zef_time']/3600);
|
|
$arr['zef_rate'] = $zef_arr[$zef_arr_index]['zef_rate'];
|
|
$arr['wage'] = $zef_arr[$zef_arr_index]['wage'];
|
|
$arr['wage_decimal'] = $zef_arr[$zef_arr_index]['wage_decimal'];
|
|
$arr['pct_kndID'] = $zef_arr[$zef_arr_index]['pct_kndID'];
|
|
$arr['knd_name'] = $zef_arr[$zef_arr_index]['knd_name'];
|
|
$arr['division'] = $zef_arr[$zef_arr_index]['zef_division'];
|
|
$arr['pct_ID'] = $zef_arr[$zef_arr_index]['pct_ID'];
|
|
$arr['pct_name'] = $zef_arr[$zef_arr_index]['pct_name'];
|
|
$arr['pct_comment'] = $zef_arr[$zef_arr_index]['pct_comment'];
|
|
$arr['zef_evtID'] = $zef_arr[$zef_arr_index]['zef_evtID'];
|
|
$arr['evt_name'] = $zef_arr[$zef_arr_index]['evt_name'];
|
|
if ($limitCommentSize)
|
|
$arr['comment'] = addEllipsis($zef_arr[$zef_arr_index]['zef_comment'], 150);
|
|
else
|
|
$arr['comment'] = $zef_arr[$zef_arr_index]['zef_comment'];
|
|
$arr['comment_type'] = $zef_arr[$zef_arr_index]['zef_comment_type'];
|
|
$arr['location'] = $zef_arr[$zef_arr_index]['zef_location'];
|
|
if (empty($arr['location']))
|
|
$arr['location'] = $default_location;
|
|
$arr['trackingnr'] = $zef_arr[$zef_arr_index]['zef_trackingnr'];
|
|
$arr['username'] = $zef_arr[$zef_arr_index]['usr_name'];
|
|
$arr['cleared'] = $zef_arr[$zef_arr_index]['zef_cleared'];
|
|
}
|
|
$zef_arr_index++;
|
|
}
|
|
else {
|
|
$arr['type'] = 'exp';
|
|
$arr['id'] = $exp_arr[$exp_arr_index]['exp_ID'];
|
|
$arr['time_in'] = $exp_arr[$exp_arr_index]['exp_timestamp'];
|
|
$arr['time_out'] = $exp_arr[$exp_arr_index]['exp_timestamp'];
|
|
$arr['zef_time'] = null;
|
|
$arr['zef_apos'] = null;
|
|
$arr['dec_zef_time'] = null;
|
|
$arr['zef_rate'] = null;
|
|
$arr['wage'] = sprintf("%01.2f",$exp_arr[$exp_arr_index]['exp_value']*$exp_arr[$exp_arr_index]['exp_multiplier']);
|
|
$arr['pct_kndID'] = $exp_arr[$exp_arr_index]['pct_kndID'];
|
|
$arr['knd_name'] = $exp_arr[$exp_arr_index]['knd_name'];
|
|
$arr['division'] = $exp_arr[$exp_arr_index]['zef_division'];
|
|
$arr['pct_ID'] = $exp_arr[$exp_arr_index]['pct_ID'];
|
|
$arr['pct_name'] = $exp_arr[$exp_arr_index]['pct_name'];
|
|
if ($limitCommentSize)
|
|
$arr['comment'] = addEllipsis($exp_arr[$exp_arr_index]['exp_comment'],150);
|
|
else
|
|
$arr['comment'] = $exp_arr[$exp_arr_index]['exp_comment'];
|
|
$arr['evt_name'] = $exp_arr[$exp_arr_index]['exp_designation'];
|
|
$arr['comment'] = $exp_arr[$exp_arr_index]['exp_comment'];
|
|
$arr['comment_type'] = $exp_arr[$exp_arr_index]['exp_comment_type'];
|
|
$arr['location'] = $default_location;
|
|
$arr['trackingnr'] = null;
|
|
$arr['username'] = $exp_arr[$exp_arr_index]['usr_name'];
|
|
$arr['cleared'] = $exp_arr[$exp_arr_index]['exp_cleared'];
|
|
$exp_arr_index++;
|
|
}
|
|
$result_arr[] = $arr;
|
|
}
|
|
while ($zef_arr_index < count($zef_arr)) {
|
|
if ($zef_arr[$zef_arr_index]['zef_out'] != 0) {
|
|
// active recordings will be omitted
|
|
$arr = array();
|
|
$arr['type'] = 'zef';
|
|
$arr['id'] = $zef_arr[$zef_arr_index]['zef_ID'];
|
|
$arr['time_in'] = $zef_arr[$zef_arr_index]['zef_in'];
|
|
$arr['time_out'] = $zef_arr[$zef_arr_index]['zef_out'];
|
|
$arr['zef_time'] = $zef_arr[$zef_arr_index]['zef_time'];
|
|
$arr['zef_duration'] = $zef_arr[$zef_arr_index]['zef_duration'];
|
|
$arr['dec_zef_time'] = sprintf("%01.2f",$zef_arr[$zef_arr_index]['zef_time']/3600);
|
|
$arr['zef_rate'] = $zef_arr[$zef_arr_index]['zef_rate'];
|
|
$arr['wage'] = $zef_arr[$zef_arr_index]['wage'];
|
|
$arr['wage_decimal'] = $zef_arr[$zef_arr_index]['wage_decimal'];
|
|
$arr['pct_kndID'] = $zef_arr[$zef_arr_index]['pct_kndID'];
|
|
$arr['knd_name'] = $zef_arr[$zef_arr_index]['knd_name'];
|
|
$arr['division'] = $zef_arr[$zef_arr_index]['zef_division'];
|
|
$arr['pct_ID'] = $zef_arr[$zef_arr_index]['pct_ID'];
|
|
$arr['pct_name'] = $zef_arr[$zef_arr_index]['pct_name'];
|
|
$arr['pct_comment'] = $zef_arr[$zef_arr_index]['pct_comment'];
|
|
$arr['zef_evtID'] = $zef_arr[$zef_arr_index]['zef_evtID'];
|
|
$arr['evt_name'] = $zef_arr[$zef_arr_index]['evt_name'];
|
|
if ($limitCommentSize)
|
|
$arr['comment'] = addEllipsis($zef_arr[$zef_arr_index]['zef_comment'], 150);
|
|
else
|
|
$arr['comment'] = $zef_arr[$zef_arr_index]['zef_comment'];
|
|
$arr['comment_type'] = $zef_arr[$zef_arr_index]['zef_comment_type'];
|
|
$arr['location'] = $zef_arr[$zef_arr_index]['zef_location'];
|
|
if (empty($arr['location']))
|
|
$arr['location'] = $default_location;
|
|
$arr['trackingnr'] = $zef_arr[$zef_arr_index]['zef_trackingnr'];
|
|
$arr['username'] = $zef_arr[$zef_arr_index]['usr_name'];
|
|
$arr['cleared'] = $zef_arr[$zef_arr_index]['zef_cleared'];
|
|
$result_arr[] = $arr;
|
|
}
|
|
$zef_arr_index++;
|
|
}
|
|
while ($exp_arr_index < count($exp_arr)) {
|
|
$arr = array();
|
|
$arr['type'] = 'exp';
|
|
$arr['id'] = $exp_arr[$exp_arr_index]['exp_ID'];
|
|
$arr['time_in'] = $exp_arr[$exp_arr_index]['exp_timestamp'];
|
|
$arr['time_out'] = $exp_arr[$exp_arr_index]['exp_timestamp'];
|
|
$arr['zef_time'] = null;
|
|
$arr['zef_apos'] = null;
|
|
$arr['dec_zef_time'] = null;
|
|
$arr['zef_rate'] = null;
|
|
$arr['wage'] = sprintf("%01.2f",$exp_arr[$exp_arr_index]['exp_value']*$exp_arr[$exp_arr_index]['exp_multiplier']);
|
|
$arr['pct_kndID'] = $exp_arr[$exp_arr_index]['pct_kndID'];
|
|
$arr['knd_name'] = $exp_arr[$exp_arr_index]['knd_name'];
|
|
$arr['pct_ID'] = $exp_arr[$exp_arr_index]['pct_ID'];
|
|
$arr['pct_name'] = $exp_arr[$exp_arr_index]['pct_name'];
|
|
$arr['division'] = $exp_arr[$exp_arr_index]['zef_division'];
|
|
if ($limitCommentSize)
|
|
$arr['comment'] = addEllipsis($exp_arr[$exp_arr_index]['exp_comment'],150);
|
|
else
|
|
$arr['comment'] = $exp_arr[$exp_arr_index]['exp_comment'];
|
|
$arr['evt_name'] = $exp_arr[$exp_arr_index]['exp_designation'];
|
|
$arr['comment'] = $exp_arr[$exp_arr_index]['exp_comment'];
|
|
$arr['comment_type'] = $exp_arr[$exp_arr_index]['exp_comment_type'];
|
|
$arr['username'] = $exp_arr[$exp_arr_index]['usr_name'];
|
|
$arr['cleared'] = $exp_arr[$exp_arr_index]['exp_cleared'];
|
|
$exp_arr_index++;
|
|
$result_arr[] = $arr;
|
|
}
|
|
return $result_arr;
|
|
}
|
|
|
|
/**
|
|
* Merge the expense annotations with the timesheet annotations. The result will
|
|
* be the timesheet array, which has to be passed as the first argument.
|
|
*
|
|
* @param array the timesheet annotations array
|
|
* @param array the expense annotations array
|
|
*/
|
|
function merge_annotations(&$zef_arr,&$exp_arr) {
|
|
|
|
foreach ($exp_arr as $id => $costs) {
|
|
if (!isset($zef_arr[$id]))
|
|
$zef_arr[$id]['costs'] = $costs;
|
|
else
|
|
$zef_arr[$id]['costs'] += $costs;
|
|
}
|
|
}
|
|
|
|
|
|
/**
|
|
* Get annotations for the user sub list. Currently it's just the time, like
|
|
* in the timesheet extension.
|
|
*
|
|
* @param int $start Time from which to take entries into account.
|
|
* @param int $end Time until which to take entries into account.
|
|
* @param array $users Array of user IDs to filter by.
|
|
* @param array $customers Array of customer IDs to filter by.
|
|
* @param array $projects Array of project IDs to filter by.
|
|
* @param array $events Array of event IDs to filter by.
|
|
* @return array Array which assigns every user (via his ID) the data to show.
|
|
*/
|
|
function xp_get_arr_usr($start,$end,$users = null,$customers = null,$projects = null,$events = null) {
|
|
global $expense_ext_available;
|
|
|
|
$arr = get_arr_time_usr($start,$end,$users,$customers,$projects,$events);
|
|
|
|
if ($expense_ext_available) {
|
|
$exp_arr = get_arr_exp_usr($start,$end,$users,$customers,$projects);
|
|
merge_annotations($arr,$exp_arr);
|
|
}
|
|
|
|
return $arr;
|
|
}
|
|
|
|
|
|
/**
|
|
* Get annotations for the customer sub list. Currently it's just the time, like
|
|
* in the timesheet extension.
|
|
*
|
|
* @param int $start Time from which to take entries into account.
|
|
* @param int $end Time until which to take entries into account.
|
|
* @param array $users Array of user IDs to filter by.
|
|
* @param array $customers Array of customer IDs to filter by.
|
|
* @param array $projects Array of project IDs to filter by.
|
|
* @param array $events Array of event IDs to filter by.
|
|
* @return array Array which assigns every customer (via his ID) the data to show.
|
|
*/
|
|
function xp_get_arr_knd($start,$end,$users = null,$customers = null,$projects = null,$events = null) {
|
|
global $expense_ext_available;
|
|
|
|
$arr = get_arr_time_knd($start,$end,$users,$customers,$projects,$events);
|
|
|
|
if ($expense_ext_available) {
|
|
$exp_arr = get_arr_exp_knd($start,$end,$users,$customers,$projects);
|
|
merge_annotations($arr,$exp_arr);
|
|
}
|
|
return $arr;
|
|
}
|
|
|
|
/**
|
|
* Get annotations for the project sub list. Currently it's just the time, like
|
|
* in the timesheet extension.
|
|
*
|
|
* @param int $start Time from which to take entries into account.
|
|
* @param int $end Time until which to take entries into account.
|
|
* @param array $users Array of user IDs to filter by.
|
|
* @param array $customers Array of customer IDs to filter by.
|
|
* @param array $projects Array of project IDs to filter by.
|
|
* @param array $events Array of event IDs to filter by.
|
|
* @return array Array which assigns every project (via his ID) the data to show.
|
|
*/
|
|
function xp_get_arr_pct($start,$end,$users = null,$customers = null,$projects = null,$events = null) {
|
|
global $expense_ext_available;
|
|
|
|
$arr = get_arr_time_pct($start,$end,$users,$customers,$projects,$events);
|
|
|
|
if ($expense_ext_available) {
|
|
$exp_arr = get_arr_exp_pct($start,$end,$users,$customers,$projects);
|
|
merge_annotations($arr,$exp_arr);
|
|
}
|
|
return $arr;
|
|
}
|
|
|
|
/**
|
|
* Get annotations for the task sub list. Currently it's just the time, like
|
|
* in the timesheet extension.
|
|
*
|
|
* @param int $start Time from which to take entries into account.
|
|
* @param int $end Time until which to take entries into account.
|
|
* @param array $users Array of user IDs to filter by.
|
|
* @param array $customers Array of customer IDs to filter by.
|
|
* @param array $projects Array of project IDs to filter by.
|
|
* @param array $events Array of event IDs to filter by.
|
|
* @return array Array which assigns every taks (via his ID) the data to show.
|
|
*/
|
|
function xp_get_arr_evt($start,$end,$users = null,$customers = null,$projects = null,$events = null) {
|
|
$arr = get_arr_time_evt($start,$end,$users,$customers,$projects,$events);
|
|
return $arr;
|
|
}
|
|
|
|
|
|
/**
|
|
* Prepare a string to be printed as a single field in the csv file.
|
|
* @param string $field String to prepare.
|
|
* @param string $column_delimiter Character used to delimit columns.
|
|
* @param string $quote_char Character used to quote strings.
|
|
* @return string Correctly formatted string.
|
|
*/
|
|
function csv_prepare_field($field,$column_delimiter,$quote_char) {
|
|
if (strpos($field,$column_delimiter) === false &&
|
|
strpos($field,$quote_char) === false &&
|
|
strpos($field,"\n") === false)
|
|
return $field;
|
|
|
|
$field = str_replace($quote_char,$quote_char.$quote_char,$field);
|
|
$field = $quote_char.$field.$quote_char;
|
|
|
|
return $field;
|
|
}
|
|
|
|
?>
|