* You should have received a copy of the GNU General Public License along
* with this program; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* http://www.gnu.org/copyleft/gpl.html
*
*/
require_once('includes/common.php');
require_once('includes/SI_Project.php');
require_once('includes/SI_Task.php');
require_once('includes/SI_TaskActivity.php');
require_once('includes/SI_PaymentSchedule.php');
checkLogin();
$project = new SI_Project();
$task = new SI_Task();
$ta = new SI_TaskActivity();
$activities = array();
if(!empty($_REQUEST['task_id'])){
$task->get($_REQUEST['task_id']);
$project->get($task->project_id);
if(!$project->hasRights(PROJECT_RIGHT_VIEW)){
fatal_error('Insufficent access rights for this project!');
}
$activities = $ta->retrieveSet("task_id = ".$task->id);
if($activities === FALSE){
$error_msg .= "Error getting list of task time!\n";
debug_message($ta->getLastError());
}
}else{
$output['error'] = 'Invalid parameters for findTasks action';
break;
}
} else {
$tasks = $task->findTasks($params[0]);
}
if ($tasks === false) {
$output['error'] = $task->getLastError();
} else {
$output['tasks'] = $tasks;
}
break;
case 'addTaskActivity':
$project = new SI_Project();
$company = new SI_Company();
$task = new SI_Task();
$item_code = new SI_ItemCode();
$task_activity = new SI_TaskActivity();
$task_activity->start_ts = getTSFromInput($_POST['ta_popup_start_ts']['date'], $_POST['ta_popup_start_ts']['time']);
$task_activity->end_ts = getTSFromInput($_POST['ta_popup_end_ts']['date'], $_POST['ta_popup_end_ts']['time']);
$task_activity->task_id = intval($_POST['ta_popup_task_id']);
$task_activity->user_id = $loggedin_user->id;
$task_activity->text = $_POST['ta_popup_text'];
$task_activity->item_code_id = $_POST['ta_popup_item_code_id'];
$debug_info = "\n\t\t\tPOST = " . print_r($_POST, true) . "\n\n\t\t\tstart_ts = {$task_activity->start_ts}\n\n\t\t\tend_ts = {$task_activity->end_ts}\n\n\t\t\ttask_id = {$task_activity->task_id}\n\n\t\t\tuser_id = {$task_activity->user_id}\n\n\t\t\titem_code_id = {$task_activity->item_code_id}\n\n\t\t\ttext = {$task_activity->text}\n\n\t\t";
$output['debug'] = $debug_info;
if ($task_activity->task_id > 0 || $task_activity->start_ts > 0 || $task_activity->end_ts > 0) {
if ($task_activity->task_id <= 0 || $task_activity->start_ts <= 0 || $task_activity->end_ts <= 0) {
$output['error'] = "Skipping incomplete entry\n";
break;
}
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* http://www.gnu.org/copyleft/gpl.html
*
*/
require_once('includes/common.php');
checkLogin();
require_once('includes/SI_Project.php');
require_once('includes/SI_Task.php');
require_once('includes/SI_TaskActivity.php');
require_once('includes/SI_Expense.php');
require_once('includes/SI_ItemCode.php');
$title = '';
$task_activity = new SI_TaskActivity();
$task = new SI_Task();
$project = new SI_Project();
$user = new SI_User();
$item_code = new SI_ItemCode();
$disabled = false;
if($_REQUEST['mode'] == 'add'){
$title = "Add Time Entry";
if(empty($_REQUEST['task_id'])){
fatal_error("No Task ID specified!\n");
}else{
$task_activity->task_id = $_REQUEST['task_id'];
$task_activity->completed_ts = time();
$task_activity->user_id = $loggedin_user->id;
if($task->get($task_activity->task_id) === FALSE){
fatal_error("Could not retreive task!");
* http://www.gnu.org/copyleft/gpl.html
*
*/
require_once('includes/common.php');
checkLogin();
require_once('includes/SI_Project.php');
require_once('includes/SI_Task.php');
require_once('includes/SI_TaskStatus.php');
require_once('includes/SI_TaskItem.php');
require_once('includes/SI_TaskPriority.php');
require_once('includes/SI_SalesCommissionType.php');
$title = '';
$task = new SI_Task();
$project = new SI_Project();
if($_REQUEST['mode'] == 'add'){
$title = "Add Task";
$task->due_ts = '';
if(empty($_REQUEST['project_id'])){
fatal_error("Error: No Project ID specified!\n");
}else{
$task->project_id = $_REQUEST['project_id'];
if($project->get($task->project_id) === FALSE){
fatal_error("Could not retreive project!");
debug_message($project->getLastError());
}
if(!$project->hasRights(PROJECT_RIGHT_EDIT)){
fatal_error('Insufficent access rights for this project!');
require_once 'includes/common.php';
require_once 'includes/SI_Project.php';
require_once 'includes/SI_Company.php';
require_once 'includes/SI_Task.php';
checkLogin();
$company = new SI_Company();
$project = new SI_Project();
$title = "Create Project";
if ($_POST['save']) {
$project->owner_id = $loggedin_user->id;
$_POST['due_ts'] = getTSFromInput($_POST['due_ts']);
$project->updateFromAssocArray($_POST);
if ($project->add()) {
foreach ($_POST['tasks'] as $task_data) {
if (!empty($task_data['name'])) {
$task = new SI_Task();
$task->name = $task_data['name'];
$task->billable = 'D';
$task->task_status_id = $task_data['status'];
$task->task_priority_id = $task_data['priority'];
$task->project_id = $project->id;
if (!$task->add()) {
$error_msg .= "Error adding task {$task_data['name']} to project\n";
debug_message($task->getLastError());
}
}
}
if (empty($error_msg)) {
goBack();
}
} else {
if(isset($_POST['back'])){
header("Location: ".getCurrentURL('time_import_4.php'));
exit();
}
if(isset($_POST['save'])){
header("Location: ".getCurrentURL('time_import_7.php'));
exit();
}
if($_POST['preview']){
$results = $importer->run();
}
//var_dump($importer);
$task = new SI_Task();
$user = new SI_User();
$ic = new SI_ItemCode();
?>
<? require('header.php'); ?>
<div class="box">
<div class="boxTitle"><h3><?php
echo $title;
?>
</h3><span class="boxTitleRight"> </span><span class="boxTitleCorner"> </span></div><div class="boxContent">
<form name="time_import" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" METHOD="POST" ENCTYPE="multipart/form-data">
<table border="0" cellspacing="5" cellpadding="0" class="form_table">
<tr>
function soap_get_tasks($username, $password)
{
$user = auth_user($username, $password);
if ($user === FALSE) {
return new soap_fault('Client', '', 'Access Denied');
}
$task = new SI_Task();
$tasks = $task->getTasks($user);
if ($tasks == FALSE) {
return new soap_fault('Server', '', $task->getLastError());
}
return object_to_data($tasks, array('id', 'project_id', 'name'));
}
$user = new SI_User();
if ($user->get($user_id) === FALSE) {
$error_msg .= "Error getting user information!\n";
debug_message($user->getLastError());
}
$balance = $user->getBalance();
if ($balance === FALSE) {
$error_msg .= "Error getting your outstanding balance!";
debug_message($loggedin_user->getLastError());
}
$transactions = $user->getTransactions(NULL, 5);
if ($transactions === FALSE) {
$error_msg .= "Error getting your last 5 transactions!";
debug_message($user->getLastError());
}
$task = new SI_Task();
$tasks = $task->getUpcoming($user->id, 0, 0, 10);
if ($tasks === FALSE) {
$error_msg .= "Could not retrieve Upcoming Tasks!\n";
debug_message($task->getLastError());
}
$title = "Home";
require 'header.php';
?>
<script>
function reloadPage(selObj){
var user_id = selObj.options[selObj.selectedIndex].value;
window.location.href = "<?php
echo $_SERVER['PHP_SELF'];
?>
?filter=<?php
* with this program; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* http://www.gnu.org/copyleft/gpl.html
*
*/
require_once('includes/common.php');
checkLogin();
require_once('includes/SI_Project.php');
require_once('includes/SI_Task.php');
require_once('includes/SI_TaskActivity.php');
require_once('includes/SI_ItemCode.php');
$title = '';
$task_activity = new SI_TaskActivity();
$task = new SI_Task();
$project = new SI_Project();
$item_code = new SI_ItemCode();
$num_entries = 5;
$title = "Add Time";
if($_POST['save']){
for($i=0; $i<$num_entries; $i++){
$task_activity = new si_taskactivity();
$task_activity->start_ts = getTSFromInput($_POST[start_ts][$i]['date'], $_POST[start_ts][$i]['time']);
$task_activity->end_ts = getTSFromInput($_POST[end_ts][$i]['date'], $_POST[end_ts][$i]['time']);
$task_activity->task_id = intval($_POST['task_id'][$i]);
$task_activity->user_id = $loggedin_user->id;
$task_activity->text = $_POST['text'][$i];
$task_activity->item_code_id = $_POST['item_code_id'][$i];
if (!isset($_GET['d'])) {
$_GET['d'] = date('d');
}
if ($loggedin_user->hasRight('admin') && isset($_REQUEST['user_id'])) {
$user_id = $_REQUEST['user_id'];
} else {
$user_id = $loggedin_user->id;
}
// Instantiate the Month class
$month = new Month($_GET['y'], $_GET['m'], "Sunday");
// Get the details of the months as timestamps
$last = $month->lastMonth(true);
$next = $month->nextMonth(true);
$thisMonth = $month->thisMonth(true);
// Get the task data
$task = new SI_Task();
$tasks = $task->getCalendarTasks($user_id, $thisMonth, $next, 'day');
if ($tasks === FALSE) {
$error_msg .= "Could not retrieve Tasks!\n";
debug_message($task->getLastError());
}
// Get the activity data
$ta = new SI_TaskActivity();
$activities = $ta->getCalendarActivities($user_id, $thisMonth, $next, 'day');
if ($activities === FALSE) {
$error_msg .= "Could not retrieve activities!\n";
debug_message($ta->getLastError());
}
// Make sure the current date is selected
$sDays = array(new Day(date('Y'), date('m'), date('d')));
// Build the days of the month
$user_id = $loggedin_user->id;
}
if($_REQUEST['filter'] == "all"){
$projects = $project->getMyProjects($user_id, FALSE);
}else{
$_REQUEST['filter'] = "pending";
$projects = $project->getMyProjects($user_id, TRUE);
}
if($projects === FALSE){
$error_msg .= "Could not retrieve your project list!\n";
debug_message($project->getLastError());
}
$task = new SI_Task();
$tasks = $task->getUpcoming($user_id);
if($tasks === FALSE){
$error_msg .= "Could not retrieve Upcoming Tasks!\n";
debug_message($task->getLastError());
}
$company = new SI_Company();
$companies = $company->getCompanysWithBalance();
if($companies === FALSE){
$error_msg .= "Could not retrieve Outstanding Hours list!\n";
debug_message($company->getLastError());
}
$user = new SI_User();
$users = $user->getUnpaidUsers();
function getTask(){
if($this->task_id <= 0){
$this->error = "SI_TaskActivity::getTask(): Task id is not set";
return FALSE;
}
if($this->_task == FALSE){
$task = new SI_Task();
if($task->get($this->task_id) === FALSE){
$this->error = "SI_TaskActivity::getTask(): Error getting task {$this->task_id}: ".$task->getLastError();
return FALSE;
}
$this->_task =& $task;
}
return $this->_task;
}
function run($preview = true)
{
$results = array();
if (is_readable($this->file)) {
$handle = fopen($this->file, "r");
$first_row = true;
while (($data = fgetcsv($handle, 4096, ",")) !== FALSE) {
if ($first_row) {
$first_row = false;
continue;
}
// Process a row
$result = array();
$result['action'] = 'Import';
$result['start_ts'] = strtotime($data[$this->column_mappings[SI_IMPORT_COLUMN_START]]);
if (isset($this->column_mappings[SI_IMPORT_COLUMN_DURATION])) {
// Duration based import
$result['end_ts'] = $result['start_ts'] + floatval($data[$this->column_mappings[SI_IMPORT_COLUMN_DURATION]]) * 60 * 60;
} else {
// Start and end time provided
$result['start_ts'] = strtotime($data[$this->column_mappings[SI_IMPORT_COLUMN_END]]);
}
if (isset($this->column_mappings[SI_IMPORT_COLUMN_COMMENTS])) {
$result['comments'] = $data[$this->column_mappings[SI_IMPORT_COLUMN_COMMENTS]];
} else {
$results['comments'] = '';
}
$user = $data[$this->column_mappings[SI_IMPORT_COLUMN_USER]];
$normalized_user = $this->normalize($user);
if (empty($normalized_user)) {
$normalized_user = '******';
}
if ($this->users[$normalized_user]['action'] == SI_IMPORT_ACTION_SKIP) {
$result['user_id'] = 0;
$result['message'] = "Skipped because no user map for '{$user}' was configured";
$result['action'] = "Skip";
$results[] = $result;
continue;
} else {
$result['user_id'] = $this->users[$normalized_user]['param'];
}
$task = $data[$this->column_mappings[SI_IMPORT_COLUMN_TASK]];
$normalized_task = $this->normalize($task);
if (empty($normalized_task)) {
$normalized_task = '_blank_';
}
if ($this->tasks[$normalized_task]['action'] == SI_IMPORT_ACTION_SKIP) {
$result['task_id'] = 0;
$result['message'] = "Skipped because no task map for '{$task}' was configured";
$result['action'] = "Skip";
$results[] = $result;
continue;
} else {
$result['task_id'] = $this->tasks[$normalized_task]['param'];
}
$task = new SI_Task();
$task->get($result['task_id']);
$ic = $data[$this->column_mappings[SI_IMPORT_COLUMN_ITEMCODE]];
$normalized_ic = $this->normalize($ic);
if (empty($normalized_ic)) {
$normalized_ic = '_blank_';
}
if ($this->item_codes[$normalized_ic]['action'] == SI_IMPORT_ACTION_SKIP) {
$result['item_code_id'] = $task->getDefaultItemCode();
if ($result['item_code_id'] == 0) {
$result['message'] = "Skipped because no item code map for '{$ic}' was configured and no default item code exists for project";
$result['action'] = "Skip";
$results[] = $result;
continue;
} else {
$result['message'] = "Item Code retreived from project";
}
} else {
$result['item_code_id'] = $this->item_codes[$normalized_ic]['param'];
}
if ($result['start_ts'] <= 0 || $result['end_ts'] <= 0) {
$result['message'] = "Invalid start or end time";
$result['action'] = "Skip";
$results[] = $result;
continue;
}
if ($result['start_ts'] > $result['end_ts']) {
$result['message'] = "Start Time is before end time";
$result['action'] = "Skip";
$results[] = $result;
continue;
}
if ($result['end_ts'] - $result['start_ts'] > 12 * 60 * 60) {
$result['message'] = "Length of time is too long, >12 hours";
$result['action'] = "Skip";
$results[] = $result;
continue;
}
$project = new SI_Project();
$company = new SI_Company();
$task = new SI_Task();
$item_code = new SI_ItemCode();
$task_activity = new SI_TaskActivity();
$task_activity->start_ts = $result['start_ts'];
$task_activity->end_ts = $result['end_ts'];
$task_activity->task_id = $result['task_id'];
$task_activity->user_id = $result['user_id'];
$task_activity->text = $result['comments'];
$task_activity->item_code_id = $result['item_code_id'];
if ($task_activity->task_id > 0 || $task_activity->start_ts > 0 || $task_activity->end_ts > 0) {
if ($task_activity->task_id <= 0 || $task_activity->start_ts <= 0 || $task_activity->end_ts <= 0) {
$result['action'] = "Skip";
$result['message'] = "Skipping incomplete entry\n";
$results[] = $result;
continue;
}
} else {
$result['action'] = "Skip";
$result['message'] = "Skipping incomplete entry\n";
$results[] = $result;
continue;
}
if ($task->get($task_activity->task_id) === FALSE) {
$result['action'] = "Skip";
$result['message'] = "Could not retreive task:\n" . $task->getLastError();
$results[] = $result;
continue;
}
if ($project->get($task->project_id) === FALSE) {
$result['action'] = "Skip";
$result['message'] = "Could not retreive project:\n" . $project->getLastError();
$results[] = $result;
continue;
}
$user = new SI_User();
if ($user->get($task_activity->user_id) === FALSE) {
$result['action'] = "Skip";
$result['message'] = "Could not retreive user:\n" . $user->getLastError();
$results[] = $result;
continue;
}
$task_activity->hourly_cost = $user->hourly_rate;
$company = $project->getCompany();
if ($company === FALSE) {
$result['action'] = "Skip";
$result['message'] = "Could not get company information:\n" . $project->getLastError();
$results[] = $result;
continue;
}
$task_activity->hourly_rate = $item_code->getCompanyPrice($company->id, $task_activity->item_code_id);
if ($task_activity->hourly_rate === FALSE) {
$result['action'] = "Skip";
$result['message'] = "Error getting price for this item code:\n" . $item_code->getLastError();
$results[] = $result;
continue;
}
$sct = $task->getSalesCommissionType();
$task_activity->sales_com_type_id = $sct->id;
if (!$preview) {
if (!$task_activity->add()) {
$result['action'] = "Skip";
$result['message'] = "Error adding Task Activity:\n" . $task_activity->getLastError();
}
}
$results[] = $result;
}
}
return $results;
}
}
if (!isset($_GET['d'])) {
$_GET['d'] = date('d');
}
if (!isset($_GET['h'])) {
$_GET['h'] = date('H');
}
if ($loggedin_user->hasRight('admin') && isset($_REQUEST['user_id'])) {
$user_id = $_REQUEST['user_id'];
} else {
$user_id = $loggedin_user->id;
}
// Create a new day
$day = new Day($_GET['y'], $_GET['m'], $_GET['d']);
// Get the task data
$task = new SI_Task();
$tasks = $task->getCalendarTasks($user_id, $day->getTimestamp(), $day->getTimestamp() + 24 * 60 * 60, 'hour');
if ($tasks === FALSE) {
$error_msg .= "Could not retrieve Tasks!\n";
debug_message($task->getLastError());
}
// Get the activity data
$ta = new SI_TaskActivity();
$activities = $ta->getCalendarActivities($user_id, $day->getTimestamp(), $day->getTimestamp() + 24 * 60 * 60, 'hour');
if ($activities === FALSE) {
$error_msg .= "Could not retrieve activities!\n";
debug_message($ta->getLastError());
}
// Make sure the current date is selected
$sHours = array(new Hour(date('Y'), date('m'), date('d'), date('H')));
// Build the hour list for that day
function importGetTasks()
{
global $loggedin_user;
if (!isLoggedIn()) {
$this->error = "User not logged in.";
return false;
}
if (!isset($_SESSION['SureInvoice']['TimeImport'])) {
$this->error = "No import is currently in progress!";
return false;
}
$importer = $_SESSION['SureInvoice']['TimeImport'];
$tasks = $importer->getTasks();
$html = "";
foreach ($tasks as $normalized_name => $data) {
$action_options = "\n\t<option value=" . SI_IMPORT_ACTION_SKIP . " " . selected(SI_IMPORT_ACTION_SKIP, intval($data['action'])) . ">Skip</option>\n\t<option value=" . SI_IMPORT_ACTION_MAP . " " . selected(SI_IMPORT_ACTION_MAP, intval($data['action'])) . ">Map</option>\n\t\t\t";
$map_options = "<option value='0'>Unknown</option>" . SI_Task::getSelectTags($data['param']);
$html .= <<<EOF
<tr>
\t<td>{$data['name']}</td>
\t<td><select name="actions[{$normalized_name}]">
\t\t{$action_options}
\t</select>
\t</td>
\t<td><select name="params[{$normalized_name}]">
\t\t{$map_options}
\t\t</select>
\t</td>
</tr>
EOF;
}
return $html;
}
* http://www.gnu.org/copyleft/gpl.html
*
*/
require_once('includes/common.php');
require_once('includes/SI_PaymentSchedule.php');
require_once('includes/SI_CompanyTransaction.php');
require_once('includes/SI_Project.php');
require_once('includes/SI_Task.php');
require_once('includes/SI_ItemCode.php');
checkLogin('accounting');
$title = '';
$ps = new SI_PaymentSchedule();
$project = new SI_Project();
$task = new SI_Task();
$item_code = new SI_ItemCode();
// Clean up amount
if(!empty($_POST['amount'])){
$_POST['amount'] = preg_replace('/[^0-9\.]/','', $_POST['amount']);
}
if($_REQUEST['mode'] == 'add'){
$title = "Add Scheduled Billing";
$project_id = intval($_REQUEST['project_id']);
$task_id = intval($_REQUEST['task_id']);
if($project_id == 0 && $task_id == 0){
fatal_error("You must provide a task_id or project_id for this scheduled payment!\n");
}
require_once('includes/SI_Project.php');
require_once('includes/SI_Task.php');
require_once('includes/SI_PaymentSchedule.php');
checkLogin();
$project = new SI_Project();
$tasks = array();
if(!empty($_REQUEST['id'])){
$project->get($_REQUEST['id']);
if(!$project->hasRights(PROJECT_RIGHT_VIEW)){
fatal_error('Insufficent access rights for this project!');
}
$task = new SI_Task();
if($_REQUEST['filter'] == "all"){
$tasks = $task->retrieveSet("t.deleted = 'N' AND t.project_id = ".$project->id);
}else{
$tasks = $task->retrieveSet("t.deleted = 'N' AND t.project_id = ".$project->id." AND s.completed = 'N'");
}
if($tasks === FALSE){
$error_msg .= "Error retrieving tasks for project!\n";
debug_message($task->getLastError());
}
}else{
fatal_error("Project ID must be supplied!\n");
}
// Get this projects payment schedule
$ps = new SI_PaymentSchedule();
