Esempio n. 1
0
            </tbody>
            </table>
        </div>
    </div>
</div>
<div class="column">
    <div class="portlet">
        <div class="portlet-header">Histórico de ações</div>
        <div class="portlet-content">
        <?php 
$actionLogDAO = new ActionLogDAO($dataConnector->mysqlConnection);
$actionLogDAO->showErrors = 1;
$loginDAO = new LoginDAO($dataConnector->mysqlConnection);
$loginDAO->showErrors = 1;
// traz o histórico dos dez últimos minutos
$actionArray = $actionLogDAO->RetrieveRecordArray("transacao <> '' AND tipoObjeto = 'trace' AND data > DATE_SUB( NOW(), INTERVAL 10 MINUTE)");
foreach ($actionArray as $action) {
    $login = $loginDAO->RetrieveRecord($action->login_id);
    $username = $login->nome;
    $dataHora = $action->data . ' ' . $action->hora;
    $transacao = $action->transacao;
    echo $username . ' ' . $dataHora . ' - ' . $transacao . "<br/>";
}
?>
        </div>
    </div>
    <div class="portlet" id="pendingSupplies" >
        <div class="portlet-header">Solicitações de consumível pendentes</div>
        <div class="portlet-content">
            <table border="0" cellpadding="0" cellspacing="0" class="sorTable">
            <thead>
Esempio n. 2
0
$loginDAO = new LoginDAO($dataConnector->mysqlConnection);
$loginDAO->showErrors = 1;
$contractDAO = new ContractDAO($dataConnector->mysqlConnection);
$contractDAO->showErrors = 1;
$subContractDAO = new SubContractDAO($dataConnector->mysqlConnection);
$subContractDAO->showErrors = 1;
$contractChargeDAO = new ContractChargeDAO($dataConnector->mysqlConnection);
$contractChargeDAO->showErrors = 1;
$contractBonusDAO = new ContractBonusDAO($dataConnector->mysqlConnection);
$contractBonusDAO->showErrors = 1;
// Traz os dados do contrato
$contract = $contractDAO->RetrieveRecord($contractId);
// Traz o nome do cliente
$clientName = new Text(BusinessPartnerDAO::GetClientName($dataConnector->sqlserverConnection, $contract->pn));
// Traz o historico para o contrato
$actionLogArray = $actionLogDAO->RetrieveRecordArray("(tipoObjeto = 'contrato' AND idObjeto = " . $contractId . ") OR (tipoAgregacao = 'contrato' AND idAgregacao = " . $contractId . ")");
function BuildRowContents($data, $usuario, $acao)
{
    echo '<tr>';
    echo '    <td>' . $data . '</td>';
    echo '    <td>' . $usuario . '</td>';
    echo '    <td>' . $acao . '</td>';
    echo '</tr>';
}
?>

<h1>Contrato: <?php 
echo str_pad($contract->numero, 5, '0', STR_PAD_LEFT);
?>
</h1>
<br/>