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>