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;
}
}
}
