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