function GetSerialNumbers($mysqlConnection, $sqlserverConnection, $subContractId)
{
$serialNumbers = "";
$contractItemDAO = new ContractItemDAO($mysqlConnection);
$contractItemDAO->showErrors = 1;
$itemArray = $contractItemDAO->RetrieveRecordArray("subContrato_id = " . $subContractId);
foreach ($itemArray as $contractItem) {
if (!empty($serialNumbers)) {
$serialNumbers = $serialNumbers . ", ";
}
$serialNumbers = $serialNumbers . EquipmentDAO::GetSerialNumber($sqlserverConnection, $contractItem->codigoCartaoEquipamento);
}
return $serialNumbers;
}
?>
</h1>
</div>
<div style="clear:both;">
<br/><br/>
</div>
<?php
foreach ($subContractArray as $subContract) {
$subContractItems = ContractItemDAO::GetItemsByOwner($dataConnector->mysqlConnection, $subContract->id);
$serialNumbers = '';
foreach ($subContractItems as $contractItem) {
if (!empty($serialNumbers)) {
$serialNumbers .= ', ';
}
$serialNumbers .= EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $contractItem->codigoCartaoEquipamento);
}
if (empty($serialNumbers)) {
$serialNumbers = 'Nenhum item encontrado';
}
$chargeArray = $contractChargeDAO->RetrieveRecordArray("subContrato_id = " . $subContract->id);
$bonusArray = $contractBonusDAO->RetrieveRecordArray("subcontrato_id = " . $subContract->id . " ORDER BY de, ate");
echo '<fieldset style="width:650px;" >';
echo ' <legend>' . ContractTypeDAO::GetAlias($dataConnector->mysqlConnection, $subContract->codigoTipoContrato) . '</legend>';
echo ' Itens:<br/>';
echo ' - ' . $serialNumbers;
echo ' <br/><br/>';
echo ' Cobrança:<br/>';
foreach ($chargeArray as $charge) {
$counterName = CounterDAO::GetCounterName($dataConnector->mysqlConnection, $charge->codigoContador);
$fixoReajustado = $charge->fixo * (1 + $adjustmentRate->aliquota / 100);
if (!empty($codigoInsumo)) {
$productionInput = $productionInputDAO->RetrieveRecord($codigoInsumo);
$inputType = $inputTypeArray[$productionInput->tipoInsumo];
$numeroChamado = str_pad($expense->codigoChamado, 4, '0', STR_PAD_LEFT);
$descricao = "<a href='Frontend/chamados/editar.php?id=" . $expense->codigoChamado . "'>" . $inputType . " ( Número do Chamado: " . $numeroChamado . " )</a>";
}
echo '<tr>';
echo ' <td>' . $serviceCall->dataAbertura . '</td>';
echo ' <td>' . $serieEquipamento . '</td>';
echo ' <td>' . $descricao . '</td>';
echo ' <td>' . number_format($expense->totalDespesa, 2, ',', '.') . '</td>';
echo '</tr>';
$somaTotais += $expense->totalDespesa;
}
foreach ($supplyRequestArray as $supplyRequest) {
$equipmentSN = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $supplyRequest->codigoCartaoEquipamento);
$requestItemArray = $requestItemDAO->RetrieveRecordArray("pedidoConsumivel_id=" . $supplyRequest->id);
foreach ($requestItemArray as $requestItem) {
$description = $requestItem->quantidade . ' ' . $requestItem->nomeItem;
echo '<tr>';
echo ' <td>' . $supplyRequest->data . '</td>';
echo ' <td>' . $equipmentSN . '</td>';
echo ' <td>' . $description . '</td>';
echo ' <td>' . number_format($requestItem->total, 2, ',', '.') . '</td>';
echo '</tr>';
$somaTotais += $requestItem->total;
}
}
foreach ($indirectCostArray as $indirectCost) {
$serviceCallArray = $indirectCostDAO->GetDistributedExpenses($indirectCost->id);
$serviceCallCount = sizeof($serviceCallArray);
$indirectCostDAO = new IndirectCostDAO($dataConnector->mysqlConnection);
$indirectCostDAO->showErrors = 1;
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
// Busca os chamados relacionados ao custo indireto
$serviceCallArray = $indirectCostDAO->GetDistributedExpenses($indirectCostId);
if (sizeof($serviceCallArray) == 0) {
echo "<tr>";
echo " <td colspan='5' align='center' >Nenhum registro encontrado!</td>";
echo "</tr>";
exit;
}
foreach ($serviceCallArray as $serviceCallId) {
$serviceCall = $serviceCallDAO->RetrieveRecord($serviceCallId);
$subject = new Text($serviceCall->defeito);
$serialNumber = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $serviceCall->codigoCartaoEquipamento);
?>
<tr>
<td >
<?php
echo str_pad($serviceCall->id, 5, '0', STR_PAD_LEFT);
?>
</td>
<td >
<?php
echo $subject->Truncate(34);
?>
</td>
<td >
<?php
echo $serialNumber;
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;
?>
</h1><br/>
<h1><?php
echo str_pad('_', 60, '_', STR_PAD_LEFT);
?>
</h1>
<div style="clear:both;">
<br/><br/>
</div>
