public function has_employees_roles($parents_id, $column_name1, $comparison1, $value1, $delimiter = '', $column_name2 = '', $comparison2 = '', $value2 = '') { $database = $_SESSION['database']; $roles_listing = ''; if (tep_not_null($parents_id)) { $roles_query = $database->query("select roles_id from " . TABLE_ROLES . " where projects_id in (" . $parents_id . ")"); while ($roles_result = $database->fetch_array($roles_query)) { if (tep_not_null($roles_listing)) { $roles_listing .= ','; } $roles_listing .= '' . $roles_result['roles_id']; } } $employee_role = new employee_role(); return $employee_role->get_employees_roles($roles_listing, $column_name1, $comparison1, $value1, $delimiter, $column_name2, $comparison2, $value2); }