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(); foreach ($expenseArray as $expense) { $serviceCall = $serviceCallDAO->RetrieveRecord($expense->codigoChamado); $serieEquipamento = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $serviceCall->codigoCartaoEquipamento); $codigoInsumo = $expense->codigoInsumo; $descricao = $expense->quantidade . ' ' . $expense->nomeItem;
// 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) { if (!empty($itemEnumeration)) { $itemEnumeration .= ', '; } $itemEnumeration .= "'" . $reqItem->codigoItem . "'"; } } // busca as solicitações prévias para este consumível ( leva em conta o equipamento e a data) $previousSupplyArray = $supplyRequestDAO->RetrieveRecordArray("codigoCartaoEquipamento = " . $equipmentCode . " AND data < '" . $cutoffDate . "' ORDER BY data DESC"); $consumption = ""; if (sizeof($previousSupplyArray) < 1) { $consumption .= "<tr>"; $consumption .= " <td colspan='6' align='center'>Nenhum registro encontrado!</td>"; $consumption .= "</tr>"; } function GetSupplyReadingsTotal($supplyRequestId, $counterEnumerationXml) { $counterTotal = 0; global $readingDAO; // obtem os medidores de utilização do consumível $xml = simplexml_load_string($counterEnumerationXml); $readingArray = $readingDAO->RetrieveRecordArray("consumivel_id=" . $supplyRequestId); foreach ($readingArray as $reading) { foreach ($xml as $element) {
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(); foreach ($expenseArray as $expense) { $serviceCall = $serviceCallDAO->RetrieveRecord($expense->codigoChamado); $serieEquipamento = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $serviceCall->codigoCartaoEquipamento); $codigoInsumo = $expense->codigoInsumo; $descricao = $expense->quantidade . ' ' . $expense->nomeItem;
<table border="0" cellpadding="0" cellspacing="0" class="sorTable"> <thead> <tr> <th style="width:25%;" > Data</th> <th style="width:65%;" > Descrição</th> <th style="width:10%;" > 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)) { $description .= ' , '; } $description .= $requestItem->quantidade . ' ' . $requestItem->nomeItem; } if (empty($description)) {
$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); } ?> <h1>Solicitações de consumível <?php echo $extraInfo; ?> </h1><br/> <h1><?php echo str_pad('_', 60, '_', STR_PAD_LEFT); ?> </h1> <div style="clear:both;">