$equipmentEnumeration = "";
foreach ($itemArray as $contractItem) {
if (!empty($equipmentEnumeration)) {
$equipmentEnumeration = $equipmentEnumeration . ", ";
}
$equipmentEnumeration = $equipmentEnumeration . $contractItem->codigoCartaoEquipamento;
}
if (empty($equipmentEnumeration)) {
$equipmentEnumeration = "0";
}
// evita o crash da query, quando a lista está vazia
// localiza todos as despesas dos chamados no período
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$pediodFilter = "dataAbertura >= '" . $startDate . " 00:00' AND dataAbertura <= '" . $endDate . " 23:59' ";
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray("cartaoEquipamento IN (" . $equipmentEnumeration . ") AND " . $pediodFilter);
$callEnumeration = "";
foreach ($serviceCallArray as $serviceCall) {
if (!empty($callEnumeration)) {
$callEnumeration = $callEnumeration . ", ";
}
$callEnumeration = $callEnumeration . $serviceCall->id;
}
if (empty($callEnumeration)) {
$callEnumeration = "0";
}
$expenseDAO = new ExpenseDAO($dataConnector->mysqlConnection);
$expenseDAO->showErrors = 1;
$expenseArray = $expenseDAO->RetrieveRecordArray("codigoChamado IN (" . $callEnumeration . ")");
// localiza todos os custos indiretos no período
$indirectCostDAO = new IndirectCostDAO($dataConnector->mysqlConnection);
include_once "../ClassLibrary/DataConnector.php";
include_once "../DataAccessObjects/ServiceCallDAO.php";
include_once "../DataTransferObjects/ServiceCallDTO.php";
$indirectCostId = $_GET['indirectCostId'];
// Abre a conexao com o banco de dados
$dataConnector = new DataConnector('mySql');
$dataConnector->OpenConnection();
if ($dataConnector->mysqlConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
// Cria o objeto de mapeamento objeto-relacional
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
// Busca os chamados cadastrados no sistema
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray("id > 0 ORDER BY id");
?>
<form name="fDados" action="Frontend/custoIndireto/acaoDespesaDistribuida.php" method="post" >
<input type="hidden" name="acao" value="store" />
<input type="hidden" name="indirectCostId" value="<?php
echo $indirectCostId;
?>
" />
<label class="left" style="width: 99%;">Chamado<br/>
<select name="serviceCallId" style="width: 96%;">
<option selected='selected' value="0"></option>
<?php
foreach ($serviceCallArray as $serviceCall) {
$subject = new Text($serviceCall->defeito);
}
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'";
if ($technician != 0) {
$filter = $filter . " AND tecnico=" . $technician;
}
if ($status != 0) {
$filter = $filter . " AND status=" . $status;
}
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray($filter . " ORDER BY " . $orderBy . ", fabricante, modelo");
// Busca os Status de chamado cadastrados no sistema
$statusArray = ServiceCallDAO::RetrieveServiceCallStatuses($dataConnector->sqlserverConnection);
// Busca os contadores cadastrados no sistema
$retrievedArray = $counterDAO->RetrieveRecordArray();
$counterArray = array();
foreach ($retrievedArray as $counter) {
$counterArray[$counter->id] = $counter->nome;
}
// Busca os funcionários cadastrados no sistema
$retrievedArray = $employeeDAO->RetrieveRecordArray();
$employeeArray = array();
foreach ($retrievedArray as $employee) {
$employeeArray[$employee->empID] = $employee->firstName . " " . $employee->middleName . " " . $employee->lastName;
}
?>
<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);
$dataAbertura = date("d/m/Y", $dataAbertura);
$tecnico = GetTechnicianName($dataConnector->sqlserverConnection, $serviceCall->tecnico);
$tempoAtendimento = $serviceCall->tempoAtendimento;
$parts = explode(":", $tempoAtendimento, 2);
$tempoTotalAtendimento += (int) $parts[0] + (int) $parts[1] / 60;
echo '<tr bgcolor=WHITE ><td>' . $serviceCall->id . '</td><td>' . $serviceCall->defeito . '</td><td>' . $dataAbertura . '</td><td>' . $tecnico . '</td><td>' . $tempoAtendimento . '</td></tr>';
}
<h3 style="border:0; margin:0;" >HISTÓRICO DE TROCA DE PEÇAS</h3><br/>
<h3 style="border:0; margin:0;" >Período: A partir da aquisição até a presente data</h3>
</div>
<div style="clear:both;"><br/><br/></div>
<table>
<?php
// Busca os dados dos equipamentos
$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>';
echo '<tr bgcolor=WHITE ><td>Chamado</td><td>Data da Troca</td><td>Código Item</td><td>Nome do Item</td><td>Quantidade</td></tr>';
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray("cartaoEquipamento = " . $equipment->insID);
foreach ($serviceCallArray as $serviceCall) {
$chamado = str_pad($serviceCall->id, 5, '0', STR_PAD_LEFT);
$dataTroca = $serviceCall->dataAtendimento;
$expenseArray = $expenseDAO->RetrieveRecordArray("codigoChamado = " . $serviceCall->id . " AND codigoInsumo IS NULL");
foreach ($expenseArray as $expense) {
echo '<tr bgcolor=WHITE ><td>' . $chamado . '</td><td>' . $dataTroca . '</td><td>' . $expense->codigoItem . '</td><td>' . $expense->nomeItem . '</td><td>' . $expense->quantidade . '</td></tr>';
}
}
}
?>
</table>
<div style="clear:both;"><br/></div>
</div>
<div style="clear:both;"><br/></div>
include_once "../DataAccessObjects/ServiceCallDAO.php";
include_once "../DataTransferObjects/ServiceCallDTO.php";
$equipmentCode = $_GET['equipmentCode'];
$cutoffDate = $_GET['cutoffDate'];
// Abre a conexao com o banco de dados
$dataConnector = new DataConnector('mySql');
$dataConnector->OpenConnection();
if ($dataConnector->mysqlConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
// Traz os três últimos chamados para o cartão de equipamento em questão partindo de dataDeCorte (chamados anteriores a dataDeCorte)
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$filter = "cartaoEquipamento = " . $equipmentCode . " AND status <> 1 AND dataAbertura < '" . $cutoffDate . "' ORDER BY dataAbertura DESC, id DESC LIMIT 0, 5";
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray($filter);
if (sizeof($serviceCallArray) == 0) {
echo '<tr><td colspan="2" align="center" >Nenhum registro encontrado!</td></tr>';
}
foreach ($serviceCallArray as $serviceCall) {
?>
<tr>
<td onclick="javascript: BuscarDadosChamadoAnterior('<?php
echo $serviceCall->id;
?>
');" ><?php
echo str_pad($serviceCall->id, 5, '0', STR_PAD_LEFT);
?>
</td>
<td onclick="javascript: BuscarDadosChamadoAnterior('<?php
echo $serviceCall->id;
$dataConnector->OpenConnection();
if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) {
echo 'Não foi possível se connectar ao bando de dados!';
exit;
}
// busca os dados do faturamento
$billingDAO = new BillingDAO($dataConnector->mysqlConnection);
$billingDAO->showErrors = 1;
$billing = $billingDAO->RetrieveRecord($billingId);
$startDate = $billing->dataInicial;
$endDate = $billing->dataFinal;
// localiza todos as despesas dos chamados no período
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$pediodFilter = "dataAbertura >= '" . $startDate . " 00:00' AND dataAbertura <= '" . $endDate . " 23:59' ";
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray("cartaoEquipamento = " . $equipmentCode . " AND " . $pediodFilter);
$callEnumeration = "";
foreach ($serviceCallArray as $serviceCall) {
if (!empty($callEnumeration)) {
$callEnumeration = $callEnumeration . ", ";
}
$callEnumeration = $callEnumeration . $serviceCall->id;
}
if (empty($callEnumeration)) {
$callEnumeration = "0";
}
$expenseDAO = new ExpenseDAO($dataConnector->mysqlConnection);
$expenseDAO->showErrors = 1;
$expenseArray = $expenseDAO->RetrieveRecordArray("codigoChamado IN (" . $callEnumeration . ")");
// localiza todos os custos indiretos no período
$indirectCostDAO = new IndirectCostDAO($dataConnector->mysqlConnection);
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$businessPartnerDAO = new BusinessPartnerDAO($dataConnector->sqlserverConnection);
$businessPartnerDAO->showErrors = 1;
// Traz a lista de chamados cadastrados
$maxRecordCount = ConfigDAO::GetConfigurationParam($dataConnector->mysqlConnection, "limiteListaChamados");
$recCount = $serviceCallDAO->GetRecordCount(null);
$boundary = "";
if ($recCount > $maxRecordCount && empty($equipmentCode)) {
$boundary = "LIMIT " . ($recCount - $maxRecordCount) . ", " . $recCount;
}
$filter = "id > 0 ORDER BY id";
if ($equipmentCode != 0) {
$filter = "cartaoEquipamento = " . $equipmentCode;
}
$serviceCallArray = $serviceCallDAO->RetrieveRecordArray($filter . ' ' . $boundary);
$extraInfo = "( últimos " . $maxRecordCount . " )";
if (!empty($equipmentCode)) {
$extraInfo = EquipmentDAO::GetSerialNumber($dataConnector->sqlserverConnection, $equipmentCode);
}
?>
<h1>Chamados de Serviço <?php
echo $extraInfo;
?>
</h1><br/>
<h1><?php
echo str_pad('_', 60, '_', STR_PAD_LEFT);
?>
</h1>
<div style="clear:both;">
