// Busca os respectivos subcontratos
$subContractEnumeration = SubContractDAO::GetSubcontractsByOwner($dataConnector->mysqlConnection, $contractEnumeration);
// Busca os respectivos equipamentos (itens de contrato)
$itemArray = ContractItemDAO::GetItemsByOwner($dataConnector->mysqlConnection, $subContractEnumeration);
// Verifica se o array está vazio no final, juntamente com $rowCount
$rowCount = 0;
foreach ($itemArray as $contractItem) {
// Verifica se o equipamento já possui leitura nos últimos 5 dias
$filter = "codigoCartaoEquipamento=" . $contractItem->codigoCartaoEquipamento . " AND contador_id=" . $counterId . " AND origemLeitura_id=2 AND data > DATE_SUB( NOW(), INTERVAL 5 DAY)";
$readingArray = $readingDAO->RetrieveRecordArray($filter);
if (sizeof($readingArray) == 0) {
// Nenhuma leitura do equipamento hoje
$equipmentOperator = new EquipmentOperator($dataConnector->sqlserverConnection, $contractItem->businessPartnerCode, $contractItem->codigoCartaoEquipamento);
if ($equipmentOperator->equipmentStatus == 'A' || $equipmentOperator->equipmentStatus == 'L') {
$serialNumber = '<a rel="' . $equipmentOperator->equipmentCode . '" class="itemInfo" >' . $equipmentOperator->serialNumber . '</a>';
$equipmentStatus = EquipmentDAO::GetStatusDescription($equipmentOperator->equipmentStatus);
$telephoneNumber = $equipmentOperator->telephoneNumber;
$reading = '<a href="Frontend/_leitura/editar.php?equipmentCode=' . $equipmentOperator->equipmentCode . '&subContract=0" ><span class="ui-icon ui-icon-alert"></span></a>';
echo '<tr><td>' . $serialNumber . ' (' . $equipmentStatus . ')</td><td>' . $telephoneNumber . '</td><td>' . $reading . '</td></tr>';
$rowCount++;
}
}
}
if (sizeof($itemArray) == 0 || $rowCount == 0) {
// Todas as leituras de hoje foram completadas
echo '<tr><td colspan="3" align="center" >Nenhum registro encontrado!</td></tr>';
}
// Fecha a conexão com o banco de dados
$dataConnector->CloseConnection();
?>
$accessoryList = '';
$accessoriesDAO = new AccessoriesDAO($dataConnector->sqlserverConnection);
$accessoriesDAO->showErrors = 1;
$accessoriesArray = $accessoriesDAO->RetrieveRecordArray("U_InsId=" . $equipmentCode);
foreach ($accessoriesArray as $accessory) {
if (!empty($accessoryList)) {
$accessoryList = $accessoryList . ', ';
}
$accessoryList = $accessoryList . $accessory->amount . ' ' . $accessory->itemName;
}
return $accessoryList;
}
?>
<h1>Cartão de Equipamento (<?php
echo EquipmentDAO::GetStatusDescription($equipment->status);
?>
)</h1><br/>
<h1><?php
echo str_pad('_', 52, '_', STR_PAD_LEFT);
?>
</h1>
<div style="clear:both;">
<br/><br/>
</div>
<script type="text/javascript" >
function GetEquipModelOptions() {
var targetUrl = 'AjaxCalls/GetEquipModelOptions.php?modelId=<?php
echo $equipment->model;
static function GetShortDescription($equipment)
{
$serialNumber = $equipment->manufacturerSN . " (" . $equipment->internalSN . ") ";
$status = EquipmentDAO::GetStatusDescription($equipment->status);
return $serialNumber . $status;
}
