/**
* @param string $templatePath
* @param string $target
*/
private function copyAssets($templatePath, $target)
{
try {
$files = $this->configDAO->findConfig($templatePath, 'files');
foreach ($files as $file) {
$this->createDirIfNotExist($target . '/' . $file);
copy($templatePath . $file, $target . '/' . $file);
}
} catch (\InvalidArgumentException $e) {
// Nothing to do
}
}
/**
* @param string $templatePath
* @return \Twig_Environment
*/
public function createInstance($templatePath)
{
$twig = new \Twig_Environment(new \Twig_Loader_Filesystem($templatePath));
try {
$extension = $this->configDAO->findConfig($templatePath, 'extension');
foreach ($extension as $extensionName => $extension) {
$twig->addGlobal($extensionName, new $extension());
}
} catch (\InvalidArgumentException $e) {
// Nothing to do
}
return $twig;
}
/**
* Service endpoint for data web service.
* Determines whether one-time or temporal data is requested
* and returns the data in JSON format
*
*/
public function data($user, $project_id, $redcap_url, $id, $fields)
{
if (in_array($project_id, array_keys(Constants::$pidfiles))) {
// Instantiate new ConfigDAO to hold information from configuration file
$config = new ConfigDAO(Constants::$pidfiles[$project_id]);
$configarr = $config->getConfiguration();
// Pass this information into the dictionary to return the
// items of interest from the dictionary
$dict = new FieldDictionary($project_id, $id, $fields, $configarr[$project_id]);
$configdict = $dict->getDictionary();
// Get the JSON for these fields
$a = $this->getJSON($configdict);
return $a;
} else {
throw new Exception("Sorry, your project is unsupported by DDP at this time.");
}
}
static function GetConfigurationParam($mysqlConnection, $paramName)
{
$configDAO = new ConfigDAO($mysqlConnection);
$configDAO->showErrors = 1;
$configParamArray = $configDAO->RetrieveRecordArray("nomeParametro='" . $paramName . "'");
if (sizeof($configParamArray) != 1) {
return "";
}
$configParam = $configParamArray[0];
return $configParam->valor;
}
exit;
}
// Cria o objeto de mapeamento objeto-relacional
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$id = 0;
$serviceCall = new ServiceCallDTO();
if (isset($_REQUEST["id"]) && $_REQUEST["id"] != 0) {
$id = $_REQUEST["id"];
$serviceCall = $serviceCallDAO->RetrieveRecord($id);
if ($serviceCall == null) {
echo '<br/><h1>Chamado não encontrado</h1><br/>';
exit;
}
}
$defaultEmailAddress = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "emailPadrao");
?>
<h1>Chamado de Serviço</h1><br/>
<h1><?php
echo str_pad('_', 60, '_', STR_PAD_LEFT);
?>
</h1>
<div style="clear:both;">
<br/><br/>
</div>
<script type="text/javascript" >
function ReloadEquipments(options)
{
$("select[name=cartaoEquipamento]").empty();
}
$nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["sinteseFaturamento"]);
if ($nivelAutorizacao <= 1) {
DisplayNotAuthorizedWarning();
exit;
}
// Cria os objetos de mapeamento objeto-relacional
$billingDAO = new BillingDAO($dataConnector->mysqlConnection);
$billingDAO->showErrors = 1;
$mailingDAO = new MailingDAO($dataConnector->mysqlConnection);
$mailingDAO->showErrors = 1;
$contractDAO = new ContractDAO($dataConnector->mysqlConnection);
$contractDAO->showErrors = 1;
// Traz os faturamentos de acordo com o mês e ano de referência
$mesFaturamento = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "mesFaturamento");
$anoFaturamento = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "anoFaturamento");
$billingArray = $billingDAO->RetrieveRecordArray("mesReferencia = '" . $mesFaturamento . "' AND anoReferencia = '" . $anoFaturamento . "'");
?>
<h1>Síntese de Faturamento (<?php
$calendar = new Calendar();
echo $calendar->GetMonthName($mesFaturamento) . ' de ' . $anoFaturamento;
?>
)</h1><br/>
<h1><?php
echo str_pad('_', 64, '_', STR_PAD_LEFT);
?>
</h1>
<div style="clear:both;">
<br/><br/>
</div>
<?php
/*
* Tests correctness of metadata web service.
*/
while (!file_exists('utils')) {
chdir('..');
}
include_once 'utils/db_connect.php';
include_once 'utils/constants.php';
include_once 'exceptions/unsupportedprojectexception.php';
include_once 'fields/redcapfieldformatter.php';
include_once 'dao/ConfigDAO.php';
include_once 'fields/field_dict.php';
$project_id = "1073";
$meta = array();
// Instantiate new ConfigDAO to hold information from configuration file
$config = new ConfigDAO(Constants::$pidfiles[$project_id]);
$configarr = $config->getConfiguration();
foreach ($configarr as $key => $value) {
foreach ($value as $k => $v) {
$meta[] = $v;
}
}
echo json_encode($meta);
$dataConnector = new DataConnector('both');
$dataConnector->OpenConnection();
if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
$nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["gerenciamentoEquipmtPecas"]);
if ($nivelAutorizacao <= 1) {
DisplayNotAuthorizedWarning();
exit;
}
// Cria os objetos de mapeamento objeto-relacional
$equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection);
$equipmentDAO->showErrors = 1;
// Traz a lista de equipamentos
$cutoffDate = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "limiteListaEquipamentos");
$equipmentArray = $equipmentDAO->RetrieveRecordArray("(status = 'A' OR status = 'L') AND U_InstallationDate > '" . $cutoffDate . "' ORDER BY manufSN");
?>
<h1>Equipamentos (instalados a partir de <?php
echo $cutoffDate;
?>
)</h1>
<script type="text/javascript" >
// Traz a lista de equipamentos selecionados pelo usuário (checkboxes marcados)
function ObterListaEquipamentos()
{
var checkedCount = 0;
var equipmentList = '';
include_once "../ClassLibrary/DataConnector.php";
include_once "../DataAccessObjects/EquipmentDAO.php";
include_once "../DataTransferObjects/EquipmentDTO.php";
include_once "../DataAccessObjects/ConfigDAO.php";
include_once "../DataTransferObjects/ConfigDTO.php";
$businessPartnerCode = $_GET['businessPartnerCode'];
$equipmentCode = $_GET['equipmentCode'];
// Abre a conexao com o banco de dados
$dataConnector = new DataConnector('both');
$dataConnector->OpenConnection();
if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
// Recupera a configuração de ordenação dos equipamentos
$ordenarPorSerieFabrica = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, 'ordenarPorSerieFabrica');
// Busca os equipamentos cadastrados para o parceiro de negócios
$equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection);
$equipmentDAO->showErrors = 1;
if ($ordenarPorSerieFabrica == 'true') {
$orderBy = "ORDER BY manufSN";
} else {
$orderBy = "ORDER BY internalSN";
}
$equipmentArray = $equipmentDAO->RetrieveRecordArray("Customer = '" . $businessPartnerCode . "' " . $orderBy);
foreach ($equipmentArray as $equipment) {
$attributes = "";
if ($equipment->insID == $equipmentCode) {
$attributes = "selected='selected'";
}
if ($ordenarPorSerieFabrica == 'true') {
$_config['use_captcha'] = $_POST['use_captcha'];
}
// set $_config['pref_defaults']
$pref_defaults['PREF_THEME'] = $addslashes($_POST['theme']);
$_config['pref_defaults'] = serialize($pref_defaults);
} else {
// don't reset 'site name' and 'contact email'
$_config['default_language'] = $_config_defaults['default_language'];
$_config['max_file_size'] = $_config_defaults['max_file_size'];
$_config['illegal_extentions'] = $_config_defaults['illegal_extentions'];
$_config['latex_server'] = $_config_defaults['latex_server'];
$_config['use_captcha'] = $_config_defaults['use_captcha'];
$_config['pref_defaults'] = $_config_defaults['pref_defaults'];
}
if (!$msg->containsErrors()) {
$configDAO = new ConfigDAO();
foreach ($_config as $name => $value) {
// the isset() is needed to avoid overridding settings that don't get set here (ie. modules)
if (stripslashes($value) != $_config_defaults[$name]) {
$configDAO->Replace($name, $value);
} else {
$configDAO->Delete($name);
}
}
// set $_config['pref_defaults'] into session variable
$pref_defaults = unserialize($_config['pref_defaults']);
if (is_array($pref_defaults)) {
foreach ($pref_defaults as $name => $value) {
$pref_defaults[$name] = $value;
}
}
$action = $_REQUEST["action"];
}
// Abre a conexao com o banco de dados
$dataConnector = new DataConnector('mySql');
$dataConnector->OpenConnection();
if ($dataConnector->mysqlConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
$nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["administracaoSistema"]);
if ($nivelAutorizacao <= 1) {
DisplayNotAuthorizedWarning();
exit;
}
// Cria o objeto de mapeamento objeto-relacional
$configDAO = new ConfigDAO($dataConnector->mysqlConnection);
$configDAO->showErrors = 1;
// Recupera as configurações armazenadas
$paramArray = $configDAO->RetrieveRecordArray();
if ($action == "store") {
foreach ($paramArray as $configParam) {
if (isset($_REQUEST["parametro" . $configParam->id])) {
$configParam->valor = $_REQUEST["parametro" . $configParam->id];
$configDAO->StoreRecord($configParam);
}
}
echo 'Operação efetuada com sucesso!';
exit;
}
function GetInputField($paramDTO)
{
session_start();
$str = ob_get_contents();
ob_end_clean();
unregister_GLOBALS();
// $_user_id could be set in home/ims/ims_import.php
// @see home/ims/ims_import.php
if (isset($_user_id) && $_user_id > 0) {
$_SESSION['user_id'] = $_user_id;
}
/***** end session initilization block ****/
/***** 4. load $_config from table 'config' *****/
require TR_INCLUDE_PATH . 'phpCache/phpCache.inc.php';
// cache library
require TR_INCLUDE_PATH . 'classes/DAO/ThemesDAO.class.php';
require TR_INCLUDE_PATH . 'classes/DAO/ConfigDAO.class.php';
$configDAO = new ConfigDAO();
$rows = $configDAO->getAll();
if (is_array($rows)) {
foreach ($rows as $id => $row) {
$_config[$row['name']] = $row['value'];
}
}
//set the timezone, php 5.3+ problem. http://atutor.ca/atutor/mantis/view.php?id=4409
date_default_timezone_set('UTC');
// define as constants. more constants are defined in include/constants.inc.php
define('EMAIL', $_config['contact_email']);
define('SITE_NAME', $_config['site_name']);
$MaxFileSize = $_config['max_file_size'];
$MaxCourseSize = $_config['max_course_size'];
$MaxFileSize = $_config['max_file_size'];
$IllegalExtentions = explode('|', $_config['illegal_extentions']);
if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
$nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["solicitacaoConsumiveis"]);
if ($nivelAutorizacao <= 1) {
DisplayNotAuthorizedWarning();
exit;
}
// Cria os objetos de mapeamento objeto-relacional
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
$requestItemDAO = new RequestItemDAO($dataConnector->mysqlConnection);
$requestItemDAO->showErrors = 1;
// Traz a lista de consumíveis solicitados
$maxRecordCount = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "limiteListaConsumiveis");
$recCount = $supplyRequestDAO->GetRecordCount();
$boundary = "";
if ($recCount > $maxRecordCount && empty($equipmentCode)) {
$boundary = "LIMIT " . ($recCount - $maxRecordCount) . ", " . $recCount;
}
$filter = "id > 0 ORDER BY id";
if ($equipmentCode != 0) {
$filter = "codigoCartaoEquipamento = " . $equipmentCode;
}
$supplyRequestArray = $supplyRequestDAO->RetrieveRecordArray($filter . ' ' . $boundary);
$extraInfo = "( últimas " . $maxRecordCount . " )";
if (!empty($equipmentCode)) {
$extraInfo = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $equipmentCode);
}
?>
