public function has_dependencies($id = 0) { if ($id != 0) { // Create and investigate employee $employee = new employee($id); return $employee->has_dependencies(); } else { $database = $_SESSION['database']; $this->id = $database->prepare_input($this->id); $employee_role_query = $database->query("select 1 from " . TABLE_EMPLOYEES_ROLES . " where employees_id = '" . (int) $this->id . "'"); $employee_role_result = $database->fetch_array($employee_role_query); if (!tep_not_null($employee_role_result)) { // No employee_role found, try for a timesheet (just to be sure) $timesheet_query = $database->query("select 1 from " . TABLE_TIMESHEETS . " where employees_id = '" . (int) $this->id . "'"); $timesheet_result = $database->fetch_array($timesheet_query); return tep_not_null($timesheet_result); } else { // employee_role exists return true; } } }