function GetTechnicianName($sqlserverConnection, $technicianId)
{
$technicianName = "";
$employeeDAO = new EmployeeDAO($sqlserverConnection);
$employeeDAO->showErrors = 1;
$employee = $employeeDAO->RetrieveRecord($technicianId);
if ($employee != null) {
$technicianName = $employee->firstName . " " . $employee->middleName . " " . $employee->lastName;
}
return $technicianName;
}
// Abre a conexao com o banco de dados
$dataConnector = new DataConnector('both');
$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 chamado
$serviceCallDAO = new ServiceCallDAO($dataConnector->mysqlConnection);
$serviceCallDAO->showErrors = 1;
$serviceCall = $serviceCallDAO->RetrieveRecord($serviceCallId);
// 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 = "";
