$orderBy = "s.Id"; } // $orderBy = "s." . $orderBy; $smarty->assign('orderScriptsBy', $orderBy); $q = Doctrine_Query::create()->from('WPTScript s, s.WPTScriptFolder f')->orderBy($orderBy); if ($scriptsFilterField && $scriptsFilterValue) { $q->andWhere('s.' . $scriptsFilterField . ' LIKE ?', '%' . $scriptsFilterValue . '%'); } if ($folderId > -1 && hasPermission('WPTScript', $folderId, PERMISSION_READ)) { $q->andWhere('s.WPTScriptFolderId = ?', $folderId); } else { $q->andWhere('s.UserId = ?', $user_id); } $pager = new Doctrine_Pager($q, $scriptsCurrentPage, $resultsPerPage); $result = $pager->execute(); $shares = getFolderShares($user_id, 'WPTScript'); $smarty->assign('shares', $shares); $smarty->assign('scriptsFilterField', $scriptsFilterField); $smarty->assign('scriptsFilterValue', $scriptsFilterValue); $smarty->assign('scriptsCurrentPage', $scriptsCurrentPage); $smarty->assign('currentPage', $scriptsCurrentPage); $smarty->assign('maxpages', $pager->getLastPage()); $smarty->assign('result', $result); } catch (Exception $e) { error_log("[WPTMonitor] Failed while Listing scripts message: " . $e->getMessage()); print 'Exception : ' . $e->getMessage(); } unset($pager); unset($result); $smarty->display('script/listScripts.tpl'); ?>
$orderBy = "Date"; } else { $orderBy = $_SESSION['orderResultsBy']; } } else { $orderBy = $_REQUEST['orderBy']; } $_SESSION['orderResultsBy'] = $orderBy; $smarty->assign('orderResultsBy', $_SESSION['orderResultsBy']); $smarty->assign('orderResultsByDirection', $_SESSION['orderResultsByDirection']); $smarty->assign('orderResultsByDirectionInv', $orderByDirInv); $smarty->assign('resultsFilterField', $resultsFilterField); $smarty->assign('resultsFilterValue', $resultsFilterValue); $orderBy = 'r.' . $_SESSION['orderResultsBy'] . ' ' . $_SESSION['orderResultsByDirection']; // Get list of job folders that this user has at least read rights to $folderShares = getFolderShares($user_id, 'WPTJob', $ownerId); $folderIds = array(); foreach ($folderShares as $key => $folderShare) { foreach ($folderShare as $k => $share) { $folderIds[] = $k; } } try { $q = Doctrine_Query::create()->from('WPTResult r, r.WPTJob j')->orderBy($orderBy); if ($folderIds) { $q->whereIn('r.WPTJob.WPTJobFolderId', $folderIds); } else { // $q->andWhere('s.UserId = ?', $user_id); $q->andWhere('r.WPTJob.UserId = ?', $user_id); } if ($resultsFilterField && $resultsFilterValue) {
<?php require "login/login.php"; include 'monitor.inc'; if (isset($_REQUEST['id'])) { $alert_id = $_REQUEST['id']; } $user_id = getCurrentUserId(); $folderId = $_REQUEST['folderId']; if (!hasPermission('Alert', $folderId, PERMISSION_UPDATE)) { echo "Invalid Permission"; exit; } global $wptResultStatusCodes; if (isset($alert_id)) { $alertTable = Doctrine_Core::getTable('Alert'); $result = $alertTable->find($alert_id); } else { $result = new Alert(); } $folderTree = getFolderTree($user_id, 'Alert'); $shares = getFolderShares($user_id, 'Alert'); $smarty->assign('folderTree', $folderTree); $smarty->assign('shares', $shares); $smarty->assign('folderId', $folderId); $smarty->assign('alert', $result); $smarty->assign('wptResultStatusCodes', $wptResultStatusCodes); $smarty->display('alert/addAlert.tpl');
$smarty->assign('todStartHourTimestamp', mktime($todStartHour)); $smarty->assign('todEndHourTimestamp', mktime($todEndHour)); // Create jobs list $q = Doctrine_Query::create()->select('j.Id, j.Label')->from('WPTJob j')->orderBy('j.Label')->setHydrationMode(Doctrine_Core::HYDRATE_ARRAY); if ($folderId > -1 && hasPermission('WPTJob', $folderId, PERMISSION_READ)) { $q->andWhere('j.WPTJobFolderId = ?', $folderId); } else { $q->andWhere('j.UserId = ?', $user_id); } if (!$showInactiveJobs) { $q->andWhere('j.Active = ?', true); } //if ($folderId > -1) { // $q->andWhere('j.WPTJobFolderId = ?', $folderId); //} $shares = getFolderShares($userId, 'WPTJob'); $smarty->assign('shares', $shares); $jobs = $q->fetchArray(); $q->free(true); $jobArray = array(); foreach ($jobs as $j) { $i = $j['Id']; $l = $j['Label']; $jobArray[$i] = $l; } $smarty->assign('jobs', $jobArray); // End create jobs list // Start field handling // Add availabe field keys //$availFieldKeysFV = array('FV_TTFB' => 'FV_TTFB', 'FV_Render' => 'FV_Render', 'FV_Doc' => 'FV_Doc', 'FV_Dom' => 'FV_Dom', 'FV_Fully' => 'FV_Fully'); $availFieldKeysFV = array('FV_TTFB', 'FV_Render', 'FV_Doc', 'FV_Dom', 'FV_Fully', 'FV_SI');
} if (!isset($_SESSION['changeNoteFolderId'])) { $_SESSION['changeNoteFolderId'] = getRootFolderForUser($user_id, 'ChangeNote'); } $folderId = $_SESSION['changeNoteFolderId']; $smarty->assign('folderId', $_SESSION['changeNoteFolderId']); $folderTree = getFolderTree($user_id, 'ChangeNote'); $smarty->assign('folderTree', $folderTree); try { $q = Doctrine_Query::create()->from('ChangeNote c, c.ChangeNoteFolder f')->groupBy('c.Id'); if ($folderId > -1 && hasPermission('ChangeNote', $folderId, PERMISSION_READ)) { $q->andWhere('c.ChangeNoteFolderId = ?', $folderId); } else { $q->andWhere('c.UserId = ?', $user_id)->orWhere('c.Public = ?', true); } $pager = new Doctrine_Pager($q, $changeNotesCurrentPage, $resultsPerPage); $result = $pager->execute(); // $changeNoteTable = Doctrine_Core::getTable('ChangeNote'); // $changeNotes = $changeNoteTable->findAll(); $smarty->assign('result', $result); } catch (Exception $e) { error_log("[WPTMonitor] Failed while Listing Change Notes: " . $e->getMessage()); } unset($changeNotes); $smarty->assign('userId', getCurrentUserId()); $shares = getFolderShares($user_id, 'ChangeNote'); $smarty->assign('shares', $shares); $smarty->display('changenote/listChangeNotes.tpl'); ?>
<?php require "login/login.php"; include 'monitor.inc'; $folderId = $_REQUEST['folderId']; if (!hasPermission('ChangeNote', $folderId, PERMISSION_UPDATE)) { echo "Invalid Permission"; exit; } if (isset($_REQUEST['id'])) { $id = $_REQUEST['id']; $changeNoteTable = Doctrine_Core::getTable('ChangeNote'); $changeNote = $changeNoteTable->find($id); } else { $changeNote = new ChangeNote(); } $folderTree = getFolderTree(getCurrentUserId(), 'ChangeNote'); $shares = getFolderShares(getCurrentUserId(), 'ChangeNote'); $smarty->assign('folderTree', $folderTree); $smarty->assign('shares', $shares); $smarty->assign('folderId', $folderId); $smarty->assign('result', $changeNote); $smarty->display('changenote/addChangeNote.tpl');