*/ require_once('includes/common.php'); require_once('includes/SI_Check.php'); require_once('includes/SI_User.php'); require_once('includes/SI_UserTransaction.php'); require_once('includes/SI_TaskActivity.php'); checkLogin(); $activity = new SI_TaskActivity(); $check = new SI_Check(); $user = new SI_User(); if($user->get($_REQUEST['user_id']) === FALSE){ $error_msg .= "Could not retrieve information for User ID ".$_REQUEST['user_id']."!\n"; debug_message($user->getLastError()); } $activities = $user->getActivities($user->id); if($activities === FALSE){ $error_msg .= "Could not retrieve Activity List for User ID ".$user->id."!\n"; debug_message($user->getLastError()); } $commissions = $user->getCommissions($user->id); if($commissions === FALSE){ $error_msg .= "Could not retrieve Commission List for User ID ".$user->id."!\n"; debug_message($user->getLastError()); } if ($_POST['save']){
function getSalesCommissionUser(){ if($this->_sct_user == FALSE){ $sct_user = new SI_User(); if($this->sales_com == 'Y' && $this->sales_com_user_id > 0){ if($sct_user->get($this->sales_com_user_id) === FALSE){ $this->error = "SI_Project::getSalesCommissionUser(): Error getting sales commission user: "******"SI_Project::getSalesCommissionUser(): Invalid sales commission setting: {$this->sales_com}"; return FALSE; } } return $this->_sct_user; }
function loginUser($email, $password) { $user = new SI_User(); $login_user = $user->getUserByLogin($email, $password); if ($login_user === FALSE) { debug_message($user->getLastError()); unset($_SESSION['userObj']); return FALSE; } else { $user->hasRight("admin"); $_SESSION['userObj'] = $login_user; return TRUE; } }
function authenticateUser($email, $password) { session_regenerate_id(); $user = new SI_User(); $login_user = $user->getUserByLogin($email, md5($password)); if ($login_user === FALSE || is_null($login_user)) { $this->error = $user->getLastError(); unset($_SESSION['userObj']); return FALSE; } else { $user->hasRight("admin"); $_SESSION['userObj'] = $login_user; return $login_user; } }
function getUser(){ if($this->user_id <= 0){ $this->error = "SI_TaskActivity::getTask(): User id is not set"; return FALSE; } if($this->_user == FALSE){ $user = new SI_User(); if($user->get($this->user_id) === FALSE){ $this->error = "SI_TaskActivity::getUser(): Error getting user: ".$user->getLastError(); return FALSE; } $this->_user =& $user; } return $this->_user; }
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; }