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;">
