// 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; }