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 = "";