$expenseArray = $expenseDAO->RetrieveRecordArray("codigoChamado IN (" . $callEnumeration . ")"); // localiza todos os custos indiretos no período $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);
include_once "../../DataAccessObjects/ProductionInputDAO.php"; include_once "../../DataTransferObjects/ProductionInputDTO.php"; // 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 os objetos de mapeamento objeto-relacional $indirectCostDAO = new IndirectCostDAO($dataConnector->mysqlConnection); $indirectCostDAO->showErrors = 1; $productionInputDAO = new ProductionInputDAO($dataConnector->mysqlConnection); $productionInputDAO->showErrors = 1; // Traz os custos indiretos cadastrados $indirectCostArray = $indirectCostDAO->RetrieveRecordArray(); ?> <h1>Administração - Custos Indiretos</h1> <h1><?php echo str_pad('_', 60, '_', STR_PAD_LEFT); ?> </h1> <div style="clear:both;"> <br/><br/> </div> <form id="fLista" name="fLista" action="Frontend/<?php echo $currentDir; ?> /acao.php" method="post"> <div class="clear">