$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');
