function log()
{
$action = $_REQUEST['ajax'];
$pagename = $this->pagename;
$object_id = $this->object_id;
log::insert($pagename, $action, get_current_user_id(), $object_id);
}
/**
* Esta funcion guarda en el log para el sistema de auditoria
* @access public
* @author: fzalazar
* @param $accion: id de la accion
* @param $parametro: descripcion de la accion (opcional)
* @param $torneo: id del torneo (opcional)
* @param $rueda: rueda (opcional)
* @param $fecha: numero de fecha (opcional)
* @param $partido: partido (opcional)
* @return true si pudo insertar en el log, false en caso contrario
* @modificacion: dabiricha (agregado de parametros opcionales: torneo, rueda, fecha y partido)
*/
function registerPartido($accion, $parametro = '', $torneo = 0, $rueda = 0, $fecha = 0, $partido = 0)
{
$log = new log();
$log->id_accion = $accion;
$log->fecha = date("Y/m/d");
$log->hora = date("H:i:s");
$log->parametro = $parametro ? $parametro : NULL;
$log->torneo = $torneo;
$log->rueda = $rueda;
$log->numero_fecha = $fecha;
$log->partido = $partido;
$log->id_usuario = RegistryHelper::getIdUsuario();
return $log->insert();
}
function log()
{
if ($_GET['sub']) {
$pagename = $this->pagename . ' sub ' . $_GET['sub'];
$action = 'view';
} elseif ($_GET['mode']) {
$pagename = $this->pagename . ' sub ' . $_GET['mode'];
$action = 'view';
} elseif ($_GET['action']) {
$pagename = $this->pagename . ' sub ' . $_GET['action'];
$action = 'view';
} else {
$pagename = $this->pagename;
$action = 'view';
}
log::insert($pagename, $action, get_current_user_id(), $action);
}
<?php
include "header.php";
// Handle all the ajax calls
require_once "includes/ajaxHandler.php";
localVars::add("results", displayMessages());
log::insert("Index: View Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Select a Task</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
</ul>
</nav>
{local var="results"}
<ul>
{local var="projectList"}
</ul>
<ul class="pickList">
<li>
<a href="dataEntry/selectForm.php" class="btn">Create new Object</a>
</li>
<?php
include "../header.php";
ini_set('memory_limit', '-1');
if (!isset($engine->cleanGet['MYSQL'])) {
$engine->cleanGet['MYSQL'] = array("listType" => "");
}
// Setup the start of the breadcrumbs and pre-populate what we can
$siteRoot = localvars::get('siteRoot');
$breadCrumbs = array(sprintf('<a href="%s">Home</a>', $siteRoot), sprintf('<a href="%sdataView/list.php">List Objects</a>', $siteRoot));
log::insert("Data View: List", 0, isset($engine->cleanGet['MYSQL']['formID']) ? $engine->cleanGet['MYSQL']['formID'] : 0, $engine->cleanGet['MYSQL']['listType']);
// Figure out what kind of list we're building
switch ($engine->cleanGet['MYSQL']['listType']) {
case 'metadataObjects':
$list = listGenerator::metadataObjects($engine->cleanGet['MYSQL']['formID'], $engine->cleanGet['MYSQL']['objectID']);
break;
case 'selectForm':
$list = listGenerator::createFormSelectList();
localvars::add('subTitle', ' - Select Form');
$breadCrumbs[] = sprintf('<a href="%sdataView/list.php?listType=selectForm">Select Form</a>', $siteRoot);
break;
case 'selectProject':
$list = listGenerator::createProjectSelectList();
localvars::add('subTitle', ' - Select Project');
$breadCrumbs[] = sprintf('<a href="%sdataView/list.php?listType=selectProject">Select Project</a>', $siteRoot);
break;
case 'form':
// $time_start = microtime(true);
$list = listGenerator::createFormObjectList($engine->cleanGet['MYSQL']['formID']);
$form = forms::get($engine->cleanGet['MYSQL']['formID']);
localvars::add('subTitle', ' - ' . $form['title']);
} else {
die(revisions::generateFieldDisplay($revision, $fields));
}
}
###############################################################################################################
// Build the select list
$selectARevision = "";
foreach ($revisions->getSecondaryIDs($engine->cleanGet['MYSQL']['objectID'], 'DESC') as $revisionID) {
$selectARevision .= sprintf('<option value="%s">%s</option>', $revisionID, date('D, M d, Y - h:i a', $revisionID));
}
localVars::add("selectARevision", $selectARevision);
localvars::add("formName", $form['title']);
localvars::add("objectID", $objectID);
localvars::add("currentVersion", revisions::generateFieldDisplay($object, $fields));
} catch (Exception $e) {
log::insert("Data Entry: Revision: Caught Exception", 0, 0, $e->getMessage());
errorHandle::newError($e->getMessage(), errorHandle::DEBUG);
errorHandle::errorMsg($e->getMessage());
}
localVars::add("results", displayMessages());
$engine->eTemplate("include", "header");
?>
<form id="revisionForm" action="" method="post">
{engine name="csrf"}
<input type="hidden" name="revisionID" id="revisionID" value="">
</form>
<header class="page-header">
<h1>{local var="formName"}</h1>
$l->addField(array("field" => "status", "label" => "Status", "type" => "select", "dupes" => TRUE, "options" => array(array("value" => "Librarian", "label" => "Librarian"), array("value" => "Staff", "label" => "Staff"), array("value" => "Student", "label" => "Student", "selected" => TRUE), array("value" => "Systems", "label" => "Systems"))));
return $l;
}
if (isset($engine->cleanPost['MYSQL'][$tableName . "_submit"])) {
log::insert("Admin: Insert New User");
$list = defineList($tableName);
$list->insert();
}
if (isset($engine->cleanPost['MYSQL'][$tableName . "_update"])) {
log::insert("Admin: Update User");
$list = defineList($tableName);
$list->update();
}
$list = defineList($tableName);
localVars::add("results", displayMessages());
log::insert("Admin: View Users Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Manage Users</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/admin/">Admin</a></li>
</ul>
</nav>
$loginFail = TRUE;
} else {
global $engineVars;
if ($engine->login($loginType)) {
log::insert("Login");
if (isset($engine->cleanGet['HTML']['url'])) {
header("Location: " . $engine->cleanGet['HTML']['URL']);
} else {
if (isset($page)) {
header("Location: " . $page . "?" . $qs);
} else {
header("Location: " . $engineVars['WEBROOT']);
}
}
} else {
log::insert("Login Failure");
$loginFail = TRUE;
}
}
}
?>
<html>
<head>
<title>MFCS Login</title>
<link rel="stylesheet" type="text/css" href="/css/login.css"/>
</head>
<body>
<?php
include "../header.php";
try {
if (($accordionList = listGenerator::generateAccordionFormList()) === FALSE) {
throw new Exception("Error generating Form List");
}
localvars::add("accordionList", $accordionList);
} catch (Exception $e) {
errorHandle::errorMsg($e->getMessage());
}
localVars::add("results", displayMessages());
log::insert("Form Creator: View Forms");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Select a Form</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/formCreator/list.php">List Forms</a></li>
</ul>
</nav>
{local var="results"}
<div class="container-fluid">
{local var="accordionList"}
<?php
require "header.php";
log::insert("Admin: View index Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Administrator Actions</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
</ul>
</nav>
<ul class="pickList">
<li>
<a href="projects/" class="btn">Projects</a>
</li>
<li>
<a href="users/" class="btn">Users</a>
</li>
<li>
<a href="watermarks/" class="btn">Watermarks</a>
</li>
</ul>
</section>
<?php
// @TODO there is way too much logic in this file. It needs to be refactored out.
include "../header.php";
$formID = isset($engine->cleanPost['HTML']['id']) ? $engine->cleanPost['HTML']['id'] : (isset($engine->cleanGet['HTML']['id']) ? $engine->cleanGet['HTML']['id'] : NULL);
if (is_empty($formID)) {
$formID = NULL;
}
log::insert("Form Creator: Edit Forms", 0, $formID);
if (isset($engine->cleanPost['MYSQL']['deleteForm'])) {
forms::delete($engine->cleanGet['HTML']['id']);
http::redirect(localvars::get('siteRoot') . 'formCreator/list.php', 301);
}
if (isset($engine->cleanPost['MYSQL']['submitNavigation'])) {
try {
if (navigation::updateFormNav($engine->cleanPost['RAW']['groupings']) === FALSE) {
throw new Exception("Error saving navigation");
}
errorHandle::successMsg("Successfully updated Form Navigation.");
} catch (Exception $e) {
errorHandle::newError("{$e->getFile()}:{$e->getLine()} {$e->getMessage()}", errorHandle::DEBUG);
errorHandle::errorMsg("Error Updating Navigation");
$engine->openDB->transRollback();
$engine->openDB->transEnd();
}
}
if (isset($engine->cleanPost['MYSQL']['submitForm'])) {
$engine->openDB->transBegin();
$form = json_decode($engine->cleanPost['RAW']['form'], TRUE);
$fields = json_decode($engine->cleanPost['RAW']['fields'], TRUE);
$idno = NULL;
// build the search interface, we do this regardless of
try {
$interface = mfcsSearch::buildInterface();
localvars::add("searchInterface", $interface);
} catch (Exception $e) {
log::insert("Data View: Search: Error", 0, 0, $e->getMessage());
errorHandle::errorMsg($e->getMessage());
}
// Make breadcrumbs
$crumbs = '';
foreach ($breadCrumbs as $breadCrumb) {
$crumbs .= "<li>{$breadCrumb}</li>";
}
localvars::add("breadcrumbs", $crumbs);
localVars::add("results", displayMessages());
log::insert("Data View: Search: View Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Search Objects{local var="subTitle"}</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
{local var="breadcrumbs"}
</ul>
</nav>
{local var="results"}
<?php
include "../header.php";
$engine->eTemplate("include", "header");
$stats = new exporting(".");
log::insert("Exporting: View Index");
localvars::add("exportsList", $stats->showExportListing());
?>
<section>
<header class="page-header">
<h1>Exports</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/exports/">Exports</a></li>
</ul>
</nav>
{local var="exportsList"}
</section>
<?php
$engine->eTemplate("include", "footer");
// Project Tab Stuff
//////////
//////////
// Children Tab Stuff
if (($formList = listGenerator::generateFormSelectList($engine->cleanGet['MYSQL']['objectID'])) === FALSE) {
errorHandle::errorMsg("Error getting Forms Listing");
throw new Exception('Error');
} else {
localvars::add("formList", $formList);
}
$childList = listGenerator::generateChildList($engine->cleanGet['MYSQL']['objectID']);
localVars::add("childrenList", is_empty($childList) ? 'No children available' : $childList);
// Children Tab Stuff
//////////
} catch (Exception $e) {
log::insert("Data View: Object: Error", 0, 0, $e->getMessage());
errorHandle::errorMsg($e->getMessage());
}
localvars::add("leftnav", navigation::buildProjectNavigation($engine->cleanGet['MYSQL']['formID']));
localVars::add("results", displayMessages());
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>View Object</h1>
</header>
<div class="container-fluid">
<div class="span3">
{local var="leftnav"}
<?php
include "../header.php";
$engine->eTemplate("include", "header");
log::insert("Stats: View Index Page");
$stats = new mfcsStats(".");
localvars::add("statsList", $stats->showStatFiles());
?>
<section>
<header class="page-header">
<h1>System Stats</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/stats/">Stats</a></li>
</ul>
</nav>
{local var="statsList"}
</section>
<?php
$engine->eTemplate("include", "footer");
if ($builtForm === FALSE) {
throw new Exception("Error building form.");
}
$builtEditTable = forms::buildEditTable($engine->cleanGet['MYSQL']['formID']);
if ($builtForm === FALSE) {
throw new Exception("Error building edit table.");
}
localvars::add("form", $builtForm);
localvars::add("metadataEditTable", $builtEditTable);
localvars::add("formID", $form['ID']);
// localvars::add("leftnav",buildProjectNavigation($engine->cleanGet['MYSQL']['id']));
} catch (Exception $e) {
log::insert("Data Entry: Metadata: Error", 0, 0, $e->getMessage());
errorHandle::errorMsg($e->getMessage());
}
log::insert("Data Entry: Metadata: View Page");
localVars::add("results", displayMessages());
if (!$ajax) {
// Display warning if form is not part of current project
forms::checkFormInCurrentProjects($engine->cleanGet['MYSQL']['formID']);
$engine->eTemplate("include", "header");
}
?>
{local var="projectWarning"}
<section>
<header class="page-header">
<h1>{local var="formName"}</h1>
</header>
<?php
include "../header.php";
try {
if (($formList = listGenerator::generateAccordionFormList(TRUE)) === FALSE) {
throw new Exception("Error getting Forms Listing");
} else {
localvars::add("formList", $formList);
}
} catch (Exception $e) {
errorHandle::errorMsg($e->getMessage());
}
localVars::add("results", displayMessages());
log::insert("Data Entry: Form Select: View Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Select a Form</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/dataEntry/selectForm.php">Select a Form</a></li>
</ul>
</nav>
{local var="results"}
// Get List of existing watermarks
if (!isnull($ID)) {
localVars::add("headerText", "Update Watermark");
localVars::add("submitBtn", '<button type="submit" name="update" class="btn">Update</button><button type="submit" name="delete" class="btn">Delete</button>');
$sql = sprintf("SELECT * FROM `watermarks` WHERE ID='%s' LIMIT 1", $engine->openDB->escape($ID));
$sqlResult = $engine->openDB->query($sql);
if ($sqlResult['result']) {
$row = mysql_fetch_array($sqlResult['result'], MYSQL_ASSOC);
localVars::add("nameVal", $row['name']);
}
} else {
localVars::add("submitBtn", '<button type="submit" name="insert" class="btn">Insert</button>');
localVars::add("headerText", "Add Watermark");
}
localVars::add("results", displayMessages());
log::insert("Admin: View Watermark Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Manage Watermarks</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/admin/">Admin</a></li>
</ul>
</nav>
$l->addField(array('field' => "ID", 'label' => "ID", 'type' => "hidden", 'disabled' => TRUE));
return $l;
}
if (isset($engine->cleanPost['MYSQL'][$tableName . "_submit"])) {
log::insert("Admin: Add Project");
$list = defineList($tableName);
$list->insert();
}
if (isset($engine->cleanPost['MYSQL'][$tableName . "_update"])) {
log::insert("Admin: Update Projects");
$list = defineList($tableName);
$list->update();
}
$list = defineList($tableName);
localVars::add("results", displayMessages());
log::insert("Admin: View Projects Page");
$engine->eTemplate("include", "header");
?>
<section>
<header class="page-header">
<h1>Manage Projects</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/admin/">Admin</a></li>
</ul>
</nav>
if (!$sqlResult['result']) {
errorHandle::newError(__METHOD__ . "() - : " . $sqlResult['error'], errorHandle::DEBUG);
throw new Exception("Error updating object record.");
}
if (($form = forms::get($engine->cleanPost['MYSQL']['form'])) === FALSE) {
throw new Exception("Error retrieving form.");
}
log::insert("Data Entry: Move: Successful Move", $engine->cleanPost['MYSQL']['objectID'], $form['ID'], $engine->cleanPost['MYSQL']['form']);
errorHandle::successMsg("Object Moved.");
localvars::add("originalFormTitle", forms::title($form['ID']));
}
} catch (Exception $e) {
log::insert("Data Entry: Move: Error", 0, 0, $e->getMessage());
errorHandle::errorMsg($e->getMessage());
}
log::insert("Data Entry: Move: Page View");
localVars::add("results", displayMessages());
$engine->eTemplate("include", "header");
?>
{local var="projectWarning"}
<section>
<header class="page-header">
<h1>{local var="formName"}</h1>
</header>
<nav id="breadcrumbs">
<ul class="breadcrumb">
<li><a href="{local var="siteRoot"}">Home</a></li>
<li><a href="{local var="siteRoot"}/dataEntry/selectForm.php">Select a Form</a></li>
if (forms::validID()) {
try {
if (($builtForm = forms::build($engine->cleanGet['MYSQL']['formID'], $engine->cleanGet['MYSQL']['objectID'], $error)) === FALSE) {
throw new Exception("Error building form.");
}
localvars::add("form", $builtForm);
localvars::add("leftnav", navigation::buildProjectNavigation($engine->cleanGet['MYSQL']['formID']));
localvars::add("objectID", $engine->cleanGet['MYSQL']['objectID']);
//////////
// Project Tab Stuff
$selectedProjects = objects::getProjects($engine->cleanGet['MYSQL']['objectID']);
localVars::add("projectOptions", projects::generateProjectChecklist($selectedProjects));
// Project Tab Stuff
//////////
} catch (Exception $e) {
log::insert("Data Entry: Object: Error", $engine->cleanGet['MYSQL']['objectID'], $engine->cleanGet['MYSQL']['formID'], $e->getMessage());
errorHandle::errorMsg($e->getMessage());
}
}
localVars::add("results", displayMessages());
// Display warning if form is not part of current project
forms::checkFormInCurrentProjects($engine->cleanGet['MYSQL']['formID']);
localvars::add("actionHeader", isnull($engine->cleanGet['MYSQL']['objectID']) ? "Add" : "Edit");
localvars::add("parentHeader", isnull($parentObject) ? "" : "<h2>Adding Child to Parent '" . $parentObject['data'][$form['objectTitleField']] . "'</h2>");
$engine->eTemplate("include", "header");
?>
{local var="projectWarning"}
<section>
<header class="page-header">
unset($tmp);
}
if (isset(mfcs::$engine->cleanPost['MYSQL']['submitCopy'])) {
if (!isset(mfcs::$engine->cleanPost['MYSQL']['newTitle']) || is_empty(mfcs::$engine->cleanPost['MYSQL']['newTitle'])) {
throw new Exception("New Form Title is required.");
}
// Get all fields from the forms table except the primary key
$fields = mfcs::$engine->openDB->listFields("forms", FALSE);
// Remove unique field
foreach ($fields as $I => $field) {
if ($field == 'title') {
unset($fields[$I]);
}
}
mfcs::$engine->openDB->transBegin();
log::insert("Form Creator: Copy: ", 0, mfcs::$engine->cleanPost['MYSQL']['formSelect'], mfcs::$engine->cleanPost['MYSQL']['newTitle']);
$sql = sprintf("INSERT INTO `forms` (`title`,`%s`) (SELECT '%s',`%s` FROM `forms` WHERE `ID`='%s' LIMIT 1)", implode('`,`', $fields), mfcs::$engine->cleanPost['MYSQL']['newTitle'], implode('`,`', $fields), mfcs::$engine->cleanPost['MYSQL']['formSelect']);
$sqlResult = mfcs::$engine->openDB->query($sql);
if (!$sqlResult['result']) {
errorHandle::newError("Error copying form - " . $sqlResult['error'], errorHandle::DEBUG);
throw new Exception("Error copying form");
}
errorHandle::successMsg("Form copied successfully.");
mfcs::$engine->openDB->transCommit();
mfcs::$engine->openDB->transEnd();
}
} catch (Exception $e) {
errorHandle::errorMsg($e->getMessage());
mfcs::$engine->openDB->transRollback();
mfcs::$engine->openDB->transEnd();
}
