/** * run - display template and edit data * * @access public * */ public function run() { $tpl = new template(); if (isset($_GET['id'])) { $id = (int) $_GET['id']; $project = $this->getProject($id); $helper = new helper(); $language = new language(); $language->setModule('projects'); $lang = $language->readIni(); //Calculate projectdetails $opentickets = $this->getOpenTickets($id); $closedTickets = $project['numberOfTickets'] - $opentickets['openTickets']; if ($project['numberOfTickets'] != 0) { $projectPercentage = round($closedTickets / $project['numberOfTickets'] * 100, 2); } else { $projectPercentage = 0; } if ($project['numberOfTickets'] == NULL) { $project['numberOfTickets'] = 1; } //Post comment $comments = new comments(); if (isset($_POST['comment']) === true) { $values = array('text' => $_POST['text'], 'datetime' => date("Y-m-d H:i:s"), 'userId' => $_SESSION['userdata']['id'], 'moduleId' => $id, 'commentParent' => $_POST['father']); $comments->addComment($values, 'project'); $tpl->setNotification('COMMENT_ADDED', 'success'); } $file = new files(); if (isset($_POST['upload'])) { if (isset($_FILES['file'])) { $file->upload($_FILES, 'project', $id); $tpl->setNotification('FILE_UPLOADED', 'success'); } else { $tpl->setNotification('NO_FILE', 'error'); } } $timesheets = new timesheets(); $language = new language(); $language->setModule('projects'); $lang = $language->readIni(); $data = array(); $months = array(); $results = $timesheets->getProjectHours($id); $allHours = 0; $max = 0; foreach ($results as $row) { if ($row['month'] != NULL) { $data[] = (int) $row['summe']; $months[] = substr($language->lang_echo('MONTH_' . $row['month'] . ''), 0, 3); if ($row['summe'] > $max) { $max = $row['summe']; } } else { $allHours = $row['summe']; } } $steps = 10; if ($max > 100) { $steps = 50; } $max = $max + $steps; $tpl->assign('timesheetsAllHours', $allHours); $chart = ""; $tpl->assign('chart', $chart); //Delete File if (isset($_GET['delFile']) === true) { $file = $_GET['delFile']; $upload = new fileupload(); $upload->initFile($file); $upload->deleteFile($file); $this->deleteFile($file); $this->setNotification('FILE_DELETED', 'success'); } //Delete comment if (isset($_GET['delComment']) === true) { $commentId = (int) $_GET['delComment']; $this->deleteComment($commentId); $this->setNotification('COMMENT_DELETED'); } //Delete account if (isset($_GET['delAccount']) === true) { $accountId = (int) $_GET['delAccount']; $this->deleteAccount($accountId); $this->setNotification('ACCOUNT_DELETED'); } //Timesheets $invEmplCheck = '0'; $invCompCheck = '0'; $projectFilter = $id; $dateFrom = mktime(0, 0, 0, date("m"), '1', date("Y")); $dateFrom = date("Y-m-d", $dateFrom); $dateTo = date("Y-m-d 00:00:00"); $kind = 'all'; $userId = 'all'; if (isset($_POST['kind']) && $_POST['kind'] != '') { $kind = $_POST['kind']; } if (isset($_POST['userId']) && $_POST['userId'] != '') { $userId = $_POST['userId']; } if (isset($_POST['dateFrom']) && $_POST['dateFrom'] != '') { $dateFrom = $helper->timestamp2date($_POST['dateFrom'], 4); } if (isset($_POST['dateTo']) && $_POST['dateTo'] != '') { $dateTo = $helper->timestamp2date($_POST['dateTo'], 4); } if (isset($_POST['invEmpl']) === true) { $invEmplCheck = $_POST['invEmpl']; if ($invEmplCheck == 'on') { $invEmplCheck = '1'; } else { $invEmplCheck = '0'; } } else { $invEmplCheck = '0'; } if (isset($_POST['invComp']) === true) { $invCompCheck = $_POST['invComp']; if ($invCompCheck == 'on') { $invCompCheck = '1'; } else { $invCompCheck = '0'; } } else { $invCompCheck = '0'; } $user = new users(); $employees = $user->getEmployees(); $timesheets = new timesheets(); $projects = new projects(); $tpl->assign('employeeFilter', $userId); $tpl->assign('employees', $employees); $tpl->assign('dateFrom', $helper->timestamp2date($dateFrom, 2)); $tpl->assign('dateTo', $helper->timestamp2date($dateTo, 2)); $tpl->assign('actKind', $kind); $tpl->assign('kind', $timesheets->kind); $tpl->assign('invComp', $invCompCheck); $tpl->assign('invEmpl', $invEmplCheck); $tpl->assign('helper', $helper); $tpl->assign('projectFilter', $projectFilter); $tpl->assign('allTimesheets', $timesheets->getAll($projectFilter, $kind, $dateFrom, $dateTo, $userId, $invEmplCheck, $invCompCheck)); /* 'name' = :name AND 'username' = :username AND 'password' = :password AND 'host' = :host AND 'kind' = :kind */ if (isset($_POST['accountSubmit'])) { $values = array('name' => $_POST['accountName'], 'username' => $_POST['username'], 'password' => $_POST['password'], 'host' => $_POST['host'], 'kind' => $_POST['kind']); $this->addAccount($values, $id); } //Assign vars $ticket = new tickets(); $tpl->assign('imgExtensions', array('jpg', 'jpeg', 'png', 'gif', 'psd', 'bmp', 'tif', 'thm', 'yuv')); $tpl->assign('projectTickets', $this->getProjectTickets($id)); $tpl->assign('projectPercentage', $projectPercentage); $tpl->assign('openTickets', $opentickets['openTickets']); $tpl->assign('project', $project); $files = $file->getFilesByModule('project', $id); $tpl->assign('files', $files); $tpl->assign('numFiles', count($files)); $bookedHours = $this->getProjectBookedHours($id); if ($bookedHours['totalHours'] != '') { $booked = round($bookedHours['totalHours'], 3); } else { $booked = 0; } $tpl->assign('bookedHours', $booked); $bookedDollars = $this->getProjectBookedDollars($id); if ($bookedDollars['totalDollars'] != '') { $dollars = round($bookedDollars['totalDollars'], 3); } else { $dollars = 0; } $tpl->assign('bookedDollars', $dollars); $tpl->assign("bookedHoursArray", $this->getProjectBookedHoursArray($id)); // die($id); $comment = $comments->getComments('project', $_GET['id']); $tpl->assign('comments', $comment); $tpl->assign('numComments', $comments->countComments('project', $_GET['id'])); $tpl->assign('state', $this->state); $tpl->assign('helper', $helper); $tpl->assign('role', $_SESSION['userdata']['role']); $accounts = $this->getProjectAccounts($id); $tpl->assign('accounts', $accounts); $tpl->display('projects.showProject'); } else { $tpl->display('general.error'); } }
/** * run - display template and edit data * * @access public * */ public function run() { $tpl = new template(); $helper = new helper(); $projectObj = new projects(); $user = new users(); $language = new language(); $language->setModule('tickets'); $lang = $language->readIni(); $projects = $projectObj->getUserProjects("open"); $msgKey = ''; if (isset($_POST['save'])) { $values = array('headline' => $_POST['headline'], 'type' => $_POST['type'], 'description' => $_POST['description'], 'priority' => $_POST['priority'], 'projectId' => $_POST['project'], 'editorId' => implode(',', $_POST['editorId']), 'userId' => $_SESSION['userdata']['id'], 'date' => $helper->timestamp2date(date("Y-m-d H:i:s"), 2), 'dateToFinish' => $_POST['dateToFinish'], 'status' => 3, 'browser' => $_POST['browser'], 'os' => $_POST['os'], 'resolution' => $_POST['resolution'], 'version' => $_POST['version'], 'url' => $_POST['url'], 'editFrom' => $_POST['editFrom'], 'editTo' => $_POST['editTo']); if ($values['headline'] === '') { $tpl->setNotification('ERROR_NO_HEADLINE', 'error'); } elseif ($values['description'] === '') { $tpl->setNotification('ERROR_NO_DESCRIPTION', 'error'); } elseif ($values['projectId'] === '') { $tpl->setNotification('ERROR_NO_PROJECT', 'error'); } else { $values['date'] = $helper->timestamp2date($values['date'], 4); $values['dateToFinish'] = $helper->timestamp2date($values['dateToFinish'], 4); $values['editFrom'] = $helper->timestamp2date($values['editFrom'], 4); $values['editTo'] = $helper->timestamp2date($values['editTo'], 4); // returns last inserted id $id = $this->addTicket($values); //Take the old value to avoid nl character $values['description'] = $_POST['description']; $values['date'] = $helper->timestamp2date($values['date'], 2); $values['dateToFinish'] = $helper->timestamp2date($values['dateToFinish'], 2); $values['editFrom'] = $helper->timestamp2date($values['editFrom'], 2); $values['editTo'] = $helper->timestamp2date($values['editTo'], 2); $msgKey = 'TICKET_ADDED'; $tpl->setNotification('TICKET_ADDED', 'success'); //Fileupload if (htmlspecialchars($_FILES['file']['name']) != '') { $upload = new fileupload(); $upload->initFile($_FILES['file']); if ($upload->error == '') { // hash name on server for security reasons $newname = md5($id . time()); //Encrypt filename on server $upload->renameFile($newname); if ($upload->upload() === true) { $fileValues = array('encName' => $upload->file_name, 'realName' => $upload->real_name, 'date' => date("Y-m-d H:i:s"), 'ticketId' => $id, 'userId' => $_SESSION['userdata']['id']); $this->addFile($fileValues); } else { $msgKey = 'ERROR_FILEUPLOAD_' . $upload->error . ''; } } else { $msgKey = 'ERROR_FILEUPLOAD_' . $upload->error . ''; } } /* //Send mail $mail = new mailer(); $row = $projectObj->getProject($values['projectId']); $mail->setSubject(''.$lang['ZYPRO_NEW_TICKET'].' "'.$row['name'].'" '); $username = $user->getUser($_SESSION['userdata']['id']); $url = 'http://'.$_SERVER['HTTP_HOST'].'/index.php?act=tickets.showTicket&id='.$id.''; $mailMsg = "".$lang['NEW_TICKET_MAIL_1']." ".$id." ".$lang['NEW_TICKET_MAIL_2']." ".$username['lastname']." ".$username['firstname']." ".$lang['NEW_TICKET_MAIL_3']." ".$row['name']." ".$lang['NEW_TICKET_MAIL_4']." ".$url." ".$lang['NEW_TICKET_MAIL_5'].""; $mail->setText($mailMsg); if(is_numeric($values['editorId']) === false ){ $mails = $user->getMailRecipients($values['projectId']); }else{ $mails = $user->getSpecificMailRecipients($id); } $to = array(); foreach($mails as $row){ array_push($to, $row['user']); } $mail->sendMail($to); */ } $tpl->assign('values', $values); } $tpl->assign('role', $_SESSION['userdata']['role']); $tpl->assign('availableUsers', $this->getAvailableUsersForTicket()); $tpl->assign('type', $this->getType()); // var_dump($tpl->get)'getAll') $tpl->assign('info', $msgKey); $tpl->assign('projects', $projects); $tpl->assign('objTickets', $this); $tpl->assign('employees', $user->getEmployees()); $tpl->display('tickets.newTicket'); }
/** * run - display template and edit data * * @access public */ public function run() { $tpl = new template(); //Only admins and employees $projects = new projects(); $helper = new helper(); if ($_SESSION['userdata']['role'] == 'admin') { } if (isset($_POST['saveInvoice']) === true) { $invEmpl = ''; $invComp = ''; if (isset($_POST['invoicedEmpl']) === true) { $invEmpl = $_POST['invoicedEmpl']; } if (isset($_POST['invoicedComp']) === true) { $invComp = $_POST['invoicedComp']; } $this->updateInvoices($invEmpl, $invComp); } $invEmplCheck = '0'; $invCompCheck = '0'; $projectFilter = ''; $dateFrom = mktime(0, 0, 0, date("m"), '1', date("Y")); $dateTo = mktime(0, 0, 0, date("m"), date("t"), date("Y")); $dateFrom = date("Y-m-d", $dateFrom); $dateTo = date("Y-m-d 00:00:00", $dateTo); $kind = 'all'; $userId = 'all'; if (isset($_POST['projectFilter']) && $_POST['projectFilter'] != '') { $projectFilter = $_POST['projectFilter']; } if (isset($_POST['kind']) && $_POST['kind'] != '') { $kind = $_POST['kind']; } if (isset($_POST['userId']) && $_POST['userId'] != '') { $userId = $_POST['userId']; } if (isset($_POST['dateFrom']) && $_POST['dateFrom'] != '') { $dateFrom = $helper->timestamp2date($_POST['dateFrom'], 4); } if (isset($_POST['dateTo']) && $_POST['dateTo'] != '') { $dateTo = $helper->timestamp2date($_POST['dateTo'], 4); } if (isset($_POST['invEmpl']) === true) { $invEmplCheck = $_POST['invEmpl']; if ($invEmplCheck == 'on') { $invEmplCheck = '1'; } else { $invEmplCheck = '0'; } } else { $invEmplCheck = '0'; } if (isset($_POST['invComp']) === true) { $invCompCheck = $_POST['invComp']; if ($invCompCheck == 'on') { $invCompCheck = '1'; } else { $invCompCheck = '0'; } } else { $invCompCheck = '0'; } if (isset($_POST['export'])) { $values = array('project' => $projectFilter, 'kind' => $kind, 'userId' => $userId, 'dateFrom' => $dateFrom, 'dateTo' => $dateTo, 'invEmplCheck' => $invEmplCheck, 'invCompCheck' => $invCompCheck); $this->export($values); } $user = new users(); $employees = $user->getEmployees(); $tpl->assign('employeeFilter', $userId); $tpl->assign('employees', $employees); $tpl->assign('dateFrom', $helper->timestamp2date($dateFrom, 2)); $tpl->assign('dateTo', $helper->timestamp2date($dateTo, 2)); $tpl->assign('actKind', $kind); $tpl->assign('kind', $this->kind); $tpl->assign('invComp', $invCompCheck); $tpl->assign('invEmpl', $invEmplCheck); $tpl->assign('helper', $helper); $tpl->assign('projectFilter', $projectFilter); $tpl->assign('allProjects', $projects->getAll()); $tpl->assign('allTimesheets', $this->getAll($projectFilter, $kind, $dateFrom, $dateTo, $userId, $invEmplCheck, $invCompCheck)); $tpl->display('timesheets.showAll'); }