?>
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>';
}
foreach ($serviceCallArray as $serviceCall) {
$dataAbertura = strtotime($serviceCall->dataAbertura);
}
// Cria os objetos de mapeamento objeto-relacional
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection);
$equipmentDAO->showErrors = 1;
// Busca os dados do chamado
$serviceCall = $serviceCallDAO->RetrieveRecord($serviceCallId);
// Se a data de atendimento é menor que a data de abertura usa esta no lugar
if (strtotime($data) < strtotime($serviceCall->dataAbertura)) {
$data = $serviceCall->dataAbertura;
$hora = $serviceCall->horaAbertura;
}
// Busca os dados do equipamento
$equipment = $equipmentDAO->RetrieveRecord($serviceCall->codigoCartaoEquipamento);
$shortDescription = '<b style="color:cadetblue;display:inline-block;" >' . EquipmentDAO::GetShortDescription($equipment) . '</b>';
$useInstructions = '<a style="display:inline-block;" class="useInstructions" rel="' . $equipment->itemCode . '" ><span class="ui-icon ui-icon-info"></span></a>';
?>
<input type="hidden" name="chamado" value="<?php
echo $serviceCallId;
?>
" />
<input type="hidden" name="data" value="<?php
echo $data;
?>
" />
<input type="hidden" name="hora" value="<?php
echo $hora;
?>
" />
// Busca os dados do técnico
$technicianName = "";
$employeeDAO = new EmployeeDAO($dataConnector->sqlserverConnection);
$employeeDAO->showErrors = 1;
$employee = $employeeDAO->RetrieveRecord($serviceCall->tecnico);
if ($employee != null) {
$technicianName = $employee->firstName . " " . $employee->middleName . " " . $employee->lastName;
}
// Traz as informações do equipamento
$shortDescription = '';
$model = '';
$equipmentDAO = new EquipmentDAO($dataConnector->sqlserverConnection);
$equipmentDAO->showErrors = 1;
$equipment = $equipmentDAO->RetrieveRecord($serviceCall->codigoCartaoEquipamento);
if ($equipment != null) {
$shortDescription = EquipmentDAO::GetShortDescription($equipment);
$model = $equipment->itemName;
}
// Traz as despesas com peças para o chamado de serviço
$pecas = "";
$expenseDAO = new ExpenseDAO($dataConnector->mysqlConnection);
$expenseDAO->showErrors = 1;
$expenseArray = $expenseDAO->RetrieveRecordArray("codigoChamado = " . $serviceCall->id . " AND codigoInsumo IS NULL");
if (sizeof($expenseArray) > 0) {
foreach ($expenseArray as $equipmentPart) {
if (!empty($pecas)) {
$pecas = $pecas . "<br/>";
}
$pecas = $pecas . $equipmentPart->quantidade . " " . $equipmentPart->nomeItem;
}
}
<th> Leituras</th>
<th> Chamados</th>
<th> Consumíveis</th>
</tr>
</thead>
<tbody>
<?php
if (sizeof($equipmentArray) == 0) {
echo '<tr><td colspan="7" align="center" >Nenhum registro encontrado!</td></tr>';
}
foreach ($equipmentArray as $equipment) {
$shortDescription = '<span style="color: CadetBlue;">(Equipamento não encontrado)</span>';
$sla = "";
$comments = "";
if ($equipment != null) {
$shortDescription = '<span style="color: CadetBlue;">' . EquipmentDAO::GetShortDescription($equipment) . '</span>';
if (!empty($equipment->sla)) {
$sla = $equipment->sla . ' horas';
}
if (!empty($equipment->comments)) {
$comments = $equipment->comments;
}
}
?>
<tr>
<td align="center" >
<input type="checkbox" value= "<?php
echo $equipment->insID;
?>
" name="reg[]"/>
</td>
function GetEquipmentInfo($equipment, $contractType)
{
$equipmentInfo = "";
// Busca os dados do equipamento
$modelo = "";
$codigoModelo = "";
$serie = "";
$instLocation = "";
if ($equipment != null) {
$modelo = $equipment->itemName;
$codigoModelo = $equipment->itemCode;
$serie = EquipmentDAO::GetShortDescription($equipment);
$instLocation = $equipment->instLocation;
}
$spacing = ' ';
$equipmentInfo = 'Cartão Equipamento: ' . $equipment->insID . $spacing . 'Modelo: ' . $modelo . $spacing . 'Série: ' . $serie . $spacing . 'Departamento: ' . $instLocation . $spacing . 'Tipo: ' . $contractType;
return $equipmentInfo;
}
