include_once "../DataTransferObjects/RequestItemDTO.php";
include_once "../DataAccessObjects/InventoryItemDAO.php";
include_once "../DataTransferObjects/InventoryItemDTO.php";
include_once "../DataAccessObjects/ReadingDAO.php";
include_once "../DataTransferObjects/ReadingDTO.php";
$supplyRequestId = $_GET['supplyRequestId'];
$cutoffDate = $_GET['cutoffDate'];
// 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;
}
// Cria os objetos de mapeamento objeto relacional
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
$requestItemDAO = new RequestItemDAO($dataConnector->mysqlConnection);
$requestItemDAO->showErrors = 1;
$inventoryItemDAO = new InventoryItemDAO($dataConnector->sqlserverConnection);
$inventoryItemDAO->showErrors = 1;
$readingDAO = new ReadingDAO($dataConnector->mysqlConnection);
$readingDAO->showErrors = 1;
// Busca os dados da solicitação de consumível
$equipmentCode = 0;
$itemEnumeration = '';
$supplyRequest = $supplyRequestDAO->RetrieveRecord($supplyRequestId);
if ($supplyRequest != null) {
    $equipmentCode = $supplyRequest->codigoCartaoEquipamento;
    $reqItemArray = $requestItemDAO->RetrieveRecordArray("pedidoConsumivel_id=" . $supplyRequest->id);
    foreach ($reqItemArray as $reqItem) {
$indirectCostDAO = new IndirectCostDAO($dataConnector->mysqlConnection);
$indirectCostDAO->showErrors = 1;
$indirectCostIdArray = $indirectCostDAO->GetIds("chamadoServico_id IN (" . $callEnumeration . ") GROUP BY custoIndireto_id");
$idEnumeration = "";
foreach ($indirectCostIdArray as $indirectCostId) {
    if (!empty($idEnumeration)) {
        $idEnumeration .= ", ";
    }
    $idEnumeration = $idEnumeration . $indirectCostId;
}
if (empty($idEnumeration)) {
    $idEnumeration = "0";
}
$indirectCostArray = $indirectCostDAO->RetrieveRecordArray("id IN (" . $idEnumeration . ")");
// localiza todos os gastos com consumíveis no período
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
$requestItemDAO = new RequestItemDAO($dataConnector->mysqlConnection);
$requestItemDAO->showErrors = 1;
$pediodFilter = "data >= '" . $startDate . " 00:00' AND data <= '" . $endDate . " 23:59' ";
$supplyRequestArray = $supplyRequestDAO->RetrieveRecordArray("codigoCartaoEquipamento IN (" . $equipmentEnumeration . ") AND " . $pediodFilter);
if (sizeof($expenseArray) < 1 && sizeof($indirectCostArray) < 1 && sizeof($supplyRequestArray) < 1) {
    echo "<tr>";
    echo "    <td colspan='4' align='center'>Nenhum registro encontrado!</td>";
    echo "</tr>";
    exit;
}
$somaTotais = 0;
$productionInputDAO = new ProductionInputDAO($dataConnector->mysqlConnection);
$productionInputDAO->showErrors = 1;
$inputTypeArray = $productionInputDAO->RetrieveInputTypes();
Example #3
0
    $subContract = $_REQUEST["subContract"];
}
// 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;
}
$nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["solicitacaoConsumiveis"]);
if ($nivelAutorizacao <= 1) {
    DisplayNotAuthorizedWarning();
    exit;
}
// Cria o objeto de mapeamento objeto-relacional
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
$id = 0;
$supplyRequest = new SupplyRequestDTO();
if (isset($_REQUEST["id"]) && $_REQUEST["id"] != 0) {
    $id = $_REQUEST["id"];
    $supplyRequest = $supplyRequestDAO->RetrieveRecord($id);
    $equipmentCode = $supplyRequest->codigoCartaoEquipamento;
    // sobrescreve o parâmetro recebido na url caso a solicitação esteja sendo alterada/editada
}
$equipmentInfo = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $equipmentCode);
$defaultEmailAddress = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "emailPadrao");
?>

    <h1>Solicitação de Consumível <?php 
echo $equipmentInfo;
Example #4
0
        </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>
                <tr>
                    <th style="width:25%;" >&nbsp;Data</th>
                    <th style="width:65%;" >&nbsp;Descrição</th>
                    <th style="width:10%;" >&nbsp;Equip.</th>
                </tr>
            </thead>
            <tbody>
            <?php 
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
$requestItemDAO = new RequestItemDAO($dataConnector->mysqlConnection);
$requestItemDAO->showErrors = 1;
// Busca as solicitações de consumível pendentes
$supplyRequestArray = $supplyRequestDAO->RetrieveRecordArray("status = 2");
// 2 = 'em espera'
if (sizeof($supplyRequestArray) == 0) {
    echo '<tr><td colspan="3" align="center" >Nenhum registro encontrado!</td></tr>';
}
foreach ($supplyRequestArray as $supplyRequest) {
    $equipmentCode = $supplyRequest->codigoCartaoEquipamento;
    $requestItemArray = $requestItemDAO->RetrieveRecordArray("pedidoConsumivel_id=" . $supplyRequest->id);
    $description = "";
    foreach ($requestItemArray as $requestItem) {
        if (!empty($description)) {
Example #5
0
include_once "../../DataAccessObjects/ReadingDAO.php";
include_once "../../DataTransferObjects/ReadingDTO.php";
if (!isset($_REQUEST["acao"])) {
    echo "Erro no processamento da requisição.";
    exit;
}
$acao = $_REQUEST["acao"];
// 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;
}
// Cria o objeto de mapeamento objeto-relacional
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
if ($acao == "store") {
    $id = 0;
    $supplyRequest = new SupplyRequestDTO();
    if (isset($_REQUEST["id"]) && $_REQUEST["id"] != 0) {
        $id = $_REQUEST["id"];
        $supplyRequest = $supplyRequestDAO->RetrieveRecord($id);
    }
    $supplyRequest->codigoCartaoEquipamento = $_REQUEST["equipmentCode"];
    $supplyRequest->data = $_REQUEST["data"];
    $supplyRequest->hora = $_REQUEST["hora"];
    $supplyRequest->status = $_REQUEST["status"];
    $supplyRequest->observacao = $_REQUEST["observacao"];
    $recordId = $supplyRequestDAO->StoreRecord($supplyRequest);
    if ($recordId == null) {
$indirectCostDAO = new IndirectCostDAO($dataConnector->mysqlConnection);
$indirectCostDAO->showErrors = 1;
$indirectCostIdArray = $indirectCostDAO->GetIds("chamadoServico_id IN (" . $callEnumeration . ") GROUP BY custoIndireto_id");
$idEnumeration = "";
foreach ($indirectCostIdArray as $indirectCostId) {
    if (!empty($idEnumeration)) {
        $idEnumeration .= ", ";
    }
    $idEnumeration = $idEnumeration . $indirectCostId;
}
if (empty($idEnumeration)) {
    $idEnumeration = "0";
}
$indirectCostArray = $indirectCostDAO->RetrieveRecordArray("id IN (" . $idEnumeration . ")");
// localiza todos os gastos com consumíveis no período
$supplyRequestDAO = new SupplyRequestDAO($dataConnector->mysqlConnection);
$supplyRequestDAO->showErrors = 1;
$requestItemDAO = new RequestItemDAO($dataConnector->mysqlConnection);
$requestItemDAO->showErrors = 1;
$pediodFilter = "data >= '" . $startDate . " 00:00' AND data <= '" . $endDate . " 23:59' ";
$supplyRequestArray = $supplyRequestDAO->RetrieveRecordArray("codigoCartaoEquipamento = " . $equipmentCode . " AND " . $pediodFilter);
$details = "";
if (sizeof($expenseArray) < 1 && sizeof($indirectCostArray) < 1 && sizeof($supplyRequestArray) < 1) {
    $details .= "<tr>";
    $details .= "    <td colspan='4' align='center'>Nenhum registro encontrado!</td>";
    $details .= "</tr>";
}
$somaTotais = 0;
$productionInputDAO = new ProductionInputDAO($dataConnector->mysqlConnection);
$productionInputDAO->showErrors = 1;
$inputTypeArray = $productionInputDAO->RetrieveInputTypes();
Example #7
0
    $subContract = $_REQUEST["subContract"];
}
// 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;
}
$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);