exit; } $nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["gerenciamentoEquipmtPecas"]); if ($nivelAutorizacao <= 1) { DisplayNotAuthorizedWarning(); exit; } // Cria o objeto de mapeamento objeto-relacional $equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection); $equipmentDAO->showErrors = 1; $equipment = new EquipmentDTO(); $equipmentArray = array(); // Histórico do equipamento (cartões de equipamento com este número de série) if ($equipmentCode != 0) { $equipment = $equipmentDAO->RetrieveRecord($equipmentCode); $equipmentArray = $equipmentDAO->RetrieveRecordArray("manufSN='" . $equipment->manufacturerSN . "'"); } if ($serial != '') { $serial = urldecode($serial); $equipmentArray = $equipmentDAO->RetrieveRecordArray("manufSN='" . $serial . "'"); if (sizeof($equipmentArray) > 0) { $equipment = $equipmentArray[0]; $equipmentCode = $equipment->insID; } } $equipmentHistory = ""; foreach ($equipmentArray as $equipmentCard) { $equipmentHistory = $equipmentHistory . '<a href="Frontend/equipamentos/editar.php?equipmentCode=' . $equipmentCard->insID . '">' . $equipmentCard->custmrName . '</a><br/>'; } if ($equipment->insID == 0) { echo '<br/><h1>Equipamento não encontrado</h1><br/>';
$filter2 = "modelo='" . $modelName . "'"; if (empty($model)) { $filter2 = "modelo <> ''"; } // qualquer modelo $filter = $filter1 . " AND " . $filter2; } if ($searchMethod == 3) { $filter1 = "businessPartnerCode='" . $businessPartnerCode . "'"; if (empty($businessPartnerCode)) { $filter1 = "businessPartnerCode <> ''"; } // qualquer cliente $equipment = $equipmentDAO->RetrieveRecord($equipmentCode); $manufSN = $equipment->manufacturerSN; $equipmentArray = $equipmentDAO->RetrieveRecordArray("manufSN='" . $manufSN . "'"); $equipmentEnumeration = ""; foreach ($equipmentArray as $equipment) { if (!empty($equipmentEnumeration)) { $equipmentEnumeration = $equipmentEnumeration . ", "; } $equipmentEnumeration = $equipmentEnumeration . $equipment->insID; } if (empty($equipmentEnumeration)) { $equipmentEnumeration = "0"; } // evita o crash da query, quando a lista está vazia $filter2 = "cartaoEquipamento IN (" . $equipmentEnumeration . ")"; $filter = $filter1 . " AND " . $filter2; } $filter .= " AND dataAbertura >= '" . $startDate . " 00:00' AND dataAbertura <= '" . $endDate . " 23:59'";
$salesPersonDAO->showErrors = 1; // Busca os contratos que se enquadram no filtro aplicado $contractArray = array(); if ($searchMethod == 0 || $searchMethod == 2) { $filter = "contrato.pn='" . $businessPartnerCode . "' AND contrato.encerramento >= '" . $startDate . " 00:00' AND contrato.encerramento <= '" . $endDate . " 23:59'"; if ($contractType > 0) { $filter = $filter . " AND subcontrato.tipoContrato_id=" . $contractType; } if (!empty($contractStatus)) { $filter = $filter . " AND contrato.status IN (" . $contractStatus . ")"; } $joins = "JOIN subContrato ON contrato.id = subContrato.contrato_id JOIN itens ON contrato.id = itens.contrato_id"; $contractArray = $contractDAO->RetrieveRecordArray2($filter, $joins); } if ($searchMethod == 1) { $equipmentArray = $equipmentDAO->RetrieveRecordArray("ItemName LIKE '%" . $model . "%'"); $equipmentEnumeration = ""; foreach ($equipmentArray as $equipment) { if (!empty($equipmentEnumeration)) { $equipmentEnumeration = $equipmentEnumeration . ", "; } $equipmentEnumeration = $equipmentEnumeration . $equipment->insID; } if (empty($equipmentEnumeration)) { $equipmentEnumeration = "0"; } // evita o crash da query, quando a lista está vazia $filter = "itens.codigoCartaoEquipamento IN (" . $equipmentEnumeration . ") AND contrato.encerramento >= '" . $startDate . " 00:00' AND contrato.encerramento <= '" . $endDate . " 23:59'"; if ($contractType > 0) { $filter = $filter . " AND subcontrato.tipoContrato_id=" . $contractType; }
<h3 style="border:0; margin:0;" >TEMPO EM ATENDIMENTO</h3><br/> <h3 style="border:0; margin:0;" >Data inicial: <?php echo $startDate; ?> Data final: <?php echo $endDate; ?> </h3> </div> <div style="clear:both;"><br/><br/></div> <table> <?php // Busca os dados dos equipamentos $equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection); $equipmentDAO->showErrors = 1; $equipmentArray = $equipmentDAO->RetrieveRecordArray("InsId IN (" . $equipmentList . ")"); foreach ($equipmentArray as $equipment) { $equipmentModel = $equipment->itemName; $serialNumber = EquipmentDAO::GetShortDescription($equipment); $salesPersonName = SalesPersonDAO::GetSalesPersonName($dataConnector->sqlserverConnection, $equipment->salesPerson); $spacing = ' '; echo '<tr bgcolor=LIGHTGRAY ><td colspan=5 >Cartão Equipamento: ' . $equipment->insID . $spacing . 'Modelo: ' . $equipmentModel . $spacing . 'Série: ' . $serialNumber . $spacing . 'Departamento: ' . $equipment->instLocation . $spacing . 'Vendedor: ' . $salesPersonName . '</td></tr>'; $serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection); $serviceCallDAO->showErrors = 1; $query = "cartaoEquipamento = " . $equipment->insID . " AND dataAbertura >= '" . $startDate . " 00:00' AND dataAbertura <= '" . $endDate . " 23:59' "; $serviceCallArray = $serviceCallDAO->RetrieveRecordArray($query); $tempoTotalAtendimento = 0; if (sizeof($serviceCallArray) > 0) { echo '<tr bgcolor=WHITE ><td>Chamado</td><td>Defeito</td><td>Data Abertura</td><td>Técnico</td><td>Tempo Atendimento</td></tr>'; } else { echo '<tr bgcolor=WHITE ><td colspan=5 >Nenhum chamado encontrado</td></tr>';
$dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } $nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["gerenciamentoEquipmtPecas"]); if ($nivelAutorizacao <= 1) { DisplayNotAuthorizedWarning(); exit; } // Cria os objetos de mapeamento objeto-relacional $equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection); $equipmentDAO->showErrors = 1; // Traz a lista de equipamentos $cutoffDate = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "limiteListaEquipamentos"); $equipmentArray = $equipmentDAO->RetrieveRecordArray("(status = 'A' OR status = 'L') AND U_InstallationDate > '" . $cutoffDate . "' ORDER BY manufSN"); ?> <h1>Equipamentos (instalados a partir de <?php echo $cutoffDate; ?> )</h1> <script type="text/javascript" > // Traz a lista de equipamentos selecionados pelo usuário (checkboxes marcados) function ObterListaEquipamentos() { var checkedCount = 0; var equipmentList = ''; $("input[type=checkbox]").each( function() {
$dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } // Recupera a configuração de ordenação dos equipamentos $ordenarPorSerieFabrica = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, 'ordenarPorSerieFabrica'); // Busca os equipamentos cadastrados para o parceiro de negócios $equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection); $equipmentDAO->showErrors = 1; if ($ordenarPorSerieFabrica == 'true') { $orderBy = "ORDER BY manufSN"; } else { $orderBy = "ORDER BY internalSN"; } $equipmentArray = $equipmentDAO->RetrieveRecordArray("Customer = '" . $businessPartnerCode . "' " . $orderBy); foreach ($equipmentArray as $equipment) { $attributes = ""; if ($equipment->insID == $equipmentCode) { $attributes = "selected='selected'"; } if ($ordenarPorSerieFabrica == 'true') { $serialNumber = $equipment->manufacturerSN . " (" . $equipment->internalSN . ") "; } else { $serialNumber = $equipment->internalSN . " (" . $equipment->manufacturerSN . ") "; } $status = EquipmentDAO::GetStatusDescription($equipment->status); $location = ""; if (!empty($equipment->instLocation)) { $location = " - " . $equipment->instLocation; }