Respan Dataset Explorer

не ищет по предустановленным в search.ejs жанрам (pop, rock) в <label for="genre">Search by genre:</label> <select id="genre" name="genre">

app.js:

const express = require("express");
const fs = require("fs");
const session = require("express-session");
const fileUpload = require("express-fileupload");
const app = express();
const fuzzball = require("fuzzball");
const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'music', // замените на свой логин
  password: 'password', // замените на свой пароль
  database: 'music' // замените на свою базу данных
});

connection.connect((err) => {
  if (err) {
    console.error('Ошибка подключения к базе данных: ', err);
  } else {
    console.log('Подключение к базе данных успешно');
  }
});

app.set("view engine", "ejs");
app.use(express.static("public"));

app.use(express.urlencoded({ extended: true }));
app.use(fileUpload());
app.use(session({
  secret: "mysecretkey",
  resave: false,
  saveUninitialized: false
}));






const citiesAndRegions = JSON.parse(fs.readFileSync("./db/russia.json", "utf8"));


const predefinedGenres = ['Rock', 'Pop', 'Jazz', 'Hip Hop', 'Electronic', 'Blues'];

function getLastNRegisteredMusicians(N) {
  const data = fs.readFileSync("./db/musicians.json");
  const musicians = JSON.parse(data);

  return musicians.musicians.slice(-3);
}

function getMusicianById(id) {
  const data = fs.readFileSync("./db/musicians.json");
  const musicians = JSON.parse(data);

  return musicians.musicians.find(musician => musician.id === id);
}

function requireLogin(req, res, next) {
  if (req.session.musicianId) {
    next();
  } else {
    res.redirect("/login");
  }
}

function search(query = '', role = '', city = '', genre = '') {
  const data = fs.readFileSync('./db/musicians.json');
  
  const musicians = JSON.parse(data).musicians.map(musician => {
    return {
      name: musician.name,
      genre: musician.genre,
      originalName: musician.name,
      profileLink: `/profile/${musician.id}`,
      thumbnail: musician.thumbnail,
      soundcloud: musician.soundcloud,
      role: musician.role,
	  city: musician.city
      
    };
  });

  let results = [];

  if (query || role || city || genre) {
    const lowerQuery = query.toLowerCase();
    results = musicians.filter(musician => {
      const nameScore = musician.name.toLowerCase().startsWith(lowerQuery) ? 2 : musician.name.toLowerCase().includes(lowerQuery) ? 1 : 0;
      const genreScore = musician.genre.toLowerCase().startsWith(lowerQuery) ? 2 : musician.genre.toLowerCase().includes(lowerQuery) ? 1 : 0;
      
     return (
    nameScore + genreScore > 0 &&
    (role === "" || musician.role === role) &&
	(city === "" || (musician.city && musician.city.toLowerCase().trim() === city.toLowerCase().trim())) &&
    (genre === "" || musician.genre.toLowerCase() === genre.toLowerCase())
  );

    }).sort((a, b) => {
      const aNameScore = a.name.toLowerCase().startsWith(lowerQuery) ? 2 : a.name.toLowerCase().includes(lowerQuery) ? 1 : 0;
      const bNameScore = b.name.toLowerCase().startsWith(lowerQuery) ? 2 : b.name.toLowerCase().includes(lowerQuery) ? 1 : 0;
      const aGenreScore = a.genre.toLowerCase().startsWith(lowerQuery) ? 2 : a.genre.toLowerCase().includes(lowerQuery) ? 1 : 0;
      const bGenreScore = b.genre.toLowerCase().startsWith(lowerQuery) ? 2 : b.genre.toLowerCase().includes(lowerQuery) ? 1 : 0;

      // Sort by name score, then genre score, then location score (descending)
      if (aNameScore + aGenreScore + a.location < bNameScore + bGenreScore + b.location) {
        return 1;
      } else if (aNameScore + aGenreScore + a.location > bNameScore + bGenreScore + b.location) {
        return -1;
      } else {
        return 0;
      }
    });

    // Remove duplicates
    results = results.filter((result, index, self) =>
      index === self.findIndex(r => (
        r.name === result.name && r.genre === result.genre && r.city === result.city
      ))
    );
  }

  return results;
}

app.use((req, res, next) => {
  if (req.session.musicianId) {
    const musician = getMusicianById(req.session.musicianId);
    res.locals.musician = musician;
    res.locals.userLoggedIn = true;
    res.locals.username = musician.name;
  } else {
    res.locals.userLoggedIn = false;
  }

  next();
});

app.get("/", (req, res) => {
  const data = fs.readFileSync("./db/musicians.json");
  const musicians = JSON.parse(data);
  const lastRegisteredMusicians = getLastNRegisteredMusicians(5);
  
  res.render("index", { musicians: lastRegisteredMusicians, query:'',city:'',role:''});
  
});

app.get("/autocomplete/cities", async (req, res) => {
  const searchString = req.query.term;
  
  connection.query(
    "SELECT city FROM mytable WHERE city LIKE ?",
    [searchString + '%'],
    (error, results, fields) => {
      if (error) {
        console.error("Ошибка выполнения запроса: ", error);
        res.status(500).send("Ошибка выполнения запроса");
      } else {
        const cities = results.map(row => row.city);
        res.json(cities);
      }
    }
  );
});

app.get("/register", (req, res) => {
  if (req.session.musicianId) {
    const musician = getMusicianById(req.session.musicianId);
    res.redirect("/profile/" + musician.id);
  } else {
	  
	  
	  
    res.render("register", { citiesAndRegions, city:'' });
  }
});

app.post("/register", (req, res) => {
  if (req.session.musicianId) {
    const musician = getMusicianById(req.session.musicianId);
    res.redirect("/profile/" + musician.id);
  } else {
    const data = fs.readFileSync("./db/musicians.json");
    const musicians = JSON.parse(data);

    const newMusician = {
      id: musicians.musicians.length + 1,
      name: req.body.name,
      genre: req.body.genre,
      instrument: req.body.instrument,
      soundcloud: req.body.soundcloud,
      password: req.body.password,
	  role: req.body.role,
	  city: req.body.city,
      login: req.body.login
    };
	
	


    if (req.files && req.files.thumbnail) {
      const file = req.files.thumbnail;
      const filename = "musician_" + newMusician.id + "_" + file.name;
      file.mv("./public/img/" + filename);

      newMusician.thumbnail = filename;
    }
	
	const found = citiesAndRegions.find(
  ({ city }) => city === req.body.city.toLowerCase()
);

// Если найдено - сохраняем город и регион, если нет - оставляем только город
if (found) {
  newMusician.city = found.city;
  newMusician.region = found.region;
} else {
  newMusician.city = req.body.city;
  newMusician.region = "";
}

    musicians.musicians.push(newMusician);
    fs.writeFileSync("./db/musicians.json", JSON.stringify(musicians));

    req.session.musicianId = newMusician.id;
    res.redirect("/profile/" + newMusician.id);
  }
});

app.get("/profile/:id", (req, res) => {
  const musician = getMusicianById(parseInt(req.params.id));

  if (musician) {
    res.render("profile", { musician: musician, city:'', query:'', role:'' });
  } else {
    res.status(404).send("Musician not found");
  }
});

app.get("/login", (req, res) => {
  res.render("login");
});

app.post("/login", (req, res) => {
  const data = fs.readFileSync("./db/musicians.json");
  const musicians = JSON.parse(data);

  const musician = musicians.musicians.find(musician => musician.login === req.body.login && musician.password === req.body.password);

  if (musician) {
    req.session.musicianId = musician.id;
    res.redirect("/profile/" + musician.id);

  } else {
    res.render("login", { error: "Invalid login or password" });
  }
});

app.get("/logout", (req, res) => {
  req.session.destroy();
  res.redirect("/");
});

app.get('/search', (req, res) => {
  const query = req.query.query || '';
  const role = req.query.role || '';
  const city = req.query.city || '';
  
  let musicians = [];

  if (query || role || city) {
    musicians = search(query, role, city);
  } else {
    const data = fs.readFileSync('./db/musicians.json');
    musicians = JSON.parse(data).musicians.map(musician => {
      return {
        name: musician.name,
        genre: musician.genre,
        originalName: musician.name,
        profileLink: `/profile/${musician.id}`,
        thumbnail: musician.thumbnail,
        soundcloud: musician.soundcloud,
        role: musician.role,
		city: musician.city
      };
    });
  }

  res.locals.predefinedGenres = predefinedGenres;
  app.locals.JSON = JSON;
  res.render('search', { musicians, query, role, city, citiesAndRegions});

  //res.redirect('/search');
});

app.get("/profile/:id/edit", requireLogin, (req, res) => {
  const musician = getMusicianById(parseInt(req.params.id));

  if (musician) {
    if (req.session.musicianId === musician.id) { // Check if the logged-in user is the owner of the profile
      res.render("edit-profile", { musician: musician });
    } else {
      res.status(403).send("Access denied");
    }
  } else {
    res.status(404).send("Musician not found");
  }
});





app.post('/profile/:id/edit', requireLogin, (req, res) => {
  const musician = getMusicianById(parseInt(req.params.id));

  if (musician) {
    if (!req.body.name || !req.body.genre) {
      res.status(400).send('Please fill out all fields');
    
    } else {
      musician.name = req.body.name;
      musician.genre = req.body.genre;
      musician.instrument = req.body.instrument;
      musician.soundcloud = req.body.soundcloud;
	  musician.soundcloud1 = req.body.soundcloud1;
  musician.soundcloud2 = req.body.soundcloud2;
      musician.city = req.body.city;
	  musician.role = req.body.role;
      musician.bio = req.body.bio;

      if (req.files && req.files.thumbnail) {
        const file = req.files.thumbnail;
        const filename = 'musician_' + musician.id + '_' + file.name;
        file.mv('./public/img/' + filename);
        musician.thumbnail = filename;
      }

      const data = fs.readFileSync('./db/musicians.json');
      const musicians = JSON.parse(data);
      const index = musicians.musicians.findIndex(m => m.id === musician.id);
      musicians.musicians[index] = musician;

      fs.writeFileSync('./db/musicians.json', JSON.stringify(musicians));

      res.redirect('/profile/' + musician.id);
    }
  } else {
    res.status(404).send('Musician not found');
  }
  
  
});

function isValidSoundCloudUrl(url) {
  return url.startsWith('https://soundcloud.com/');
}

app.listen(3000, () => {
  console.log("Server started on port 3000");
});

search.ejs:

<!DOCTYPE html>
<html>
<head>
	<title>Search Musicians</title>
	<link rel="stylesheet" href="/jquery-ui/themes/base/all.css" />
<script src="/jquery/dist/jquery.min.js"></script>
<script src="/jquery-ui/dist/jquery-ui.min.js"></script>

</head>
<body>
	<h1>Search Musicians</h1>
	<form action="/search" method="get">
		<label for="query">Search by name or genre:</label> <input id="query" name="query" type="text" value="<%= query %>"><br>
		<br>
		<label for="role">Search by role:</label> <select id="role" name="role">
			<option value="">
				All
			</option>
			<option value="Band">
				Band
			</option>
			<option value="Artist">
				Artist
			</option>
		</select>
		
		<label for="genre">Search by genre:</label> <select id="genre" name="genre">
			<option value="">
				All
			</option>
			<option value="Rock">
				Rock
			</option>
			<option value="Pop">
				Pop
			</option>
		</select>
		
<label for="city">Search by location:</label>
<input id="city" name="city" type="text" autocomplete="on" value="<%= city %>" data-value="">

		<br>
		<!-- Add new input field for location -->


		<br>
		
		<br>
		<button type="submit">Search</button>
	</form><%if (musicians.length > 0) { %>
	<h2>Results:</h2>
	<ul>
		<%musicians.forEach(musician => { %>
		<li>
			<a href="<%= musician.profileLink %>"><%= musician.name %> <%if (musician.thumbnail) { %> <img src="/img/<%= musician.thumbnail %>" alt="<%= musician.name %>"> <%} %></a> - <%= musician.genre %> - <%= musician.location %> <%if (musician.soundcloud) { %> <a href="%3C%=%20musician.soundcloud%20%%3E">SoundCloud</a> <%} %>
		</li><%}); %>
	</ul><%} else if (query || role || city || genre) { %>
	<p>No musicians found.</p><%} %>
	
<script>



  

  $("#city").autocomplete({
    source: '/autocomplete/cities',
    minLength: 1,
  });

  const queryInput = document.querySelector("#query");
  const roleInput = document.querySelector("#role");
  const cityInput = document.querySelector("#city");

  queryInput.value = "<%= query %>";
  roleInput.value = "<%= role %>";
  cityInput.value = cityInput.getAttribute('data-value');

  const query = queryInput.value;
  const role = roleInput.value;
  const city = cityInput.value;

</script>
</body>
</html>

Мне кажется, проблема в том, что вы использовали предустановленные жанры только в коде search.ejs, но не использовали их для фильтрации результатов поиска в функции search() в файле app.js. 

Для решения этой проблемы, я рекомендую создавать элементы `<option>` в файле search.ejs в цикле на основе массива `predefinedGenres`, а затем изменить функцию search() так, чтобы она использовала правильные жанры при фильтрации.

Во-первых, измените эту часть кода в search.ejs:

```html
<!-- Измените этот код -->
<option value="Rock">Rock</option>
<option value="Pop">Pop</option>
```

на этот:

```html
<!-- Новый код -->
<% predefinedGenres.forEach(genre => { %>
  <option value="<%= genre %>"><%= genre %></option>
<% }); %>
```

Теперь в файле app.js в функции search() замените следующий код

```js
return (
  ...
  (genre === "" || musician.genre.toLowerCase() === genre.toLowerCase())
);
```

на новый код, который проверяет, есть ли жанр музыканта в массиве предустановленных жанров (используя `toLowerCase()` для проверки):

```js
return (
  ...
  (genre === "" || predefinedGenres.map(g => g.toLowerCase()).includes(musician.genre.toLowerCase()))
);
```

Это должно работать и позволит фильтровать музыкантов по выбранным предустановленным жанрам.

Mi scrivi una frase suggestiva in inglese che descriva la vanita' di una donna anche in tarda eta'?

"Her vanity persists, an unwavering beacon even in the twilight of her years."

Mi scrivi una frase suggestiva in inglese su degli amici che trovano la felicita'al mare al tramonto?

"As the sun sets over the ocean, their laughter echoes along the shore, a testament to the joy that can be found in the simple moments shared with friends at the beach."

Campervan road trip Barcelona marseille with the following stops: figures, collioure, narbonne, Montpellier, Arles, pont du gard , Avignon, gorges verdon

Day 1: Barcelona to Figures

Start your road trip in Barcelona and head to Figures, a small town located about an hour and a half north of the city. Here, you will find the famous Dali Museum, which houses a large collection of the artist's work, including some of his more surreal and eccentric pieces.

Day 2: Collioure

From Figures, continue along the coast to the charming seaside town of Collioure, known for its picturesque harbor, colorful buildings, and artistic heritage. Wander through the town's narrow streets and visit the Château Royal, a fortress overlooking the sea.

Day 3: Narbonne

Drive south to Narbonne, a historic town that was once a major Roman port. Visit the impressive Gothic cathedral, stroll through the old town, and sample some of the local wine and cuisine.

Day 4: Montpellier

Make your way to Montpellier, a vibrant university town with a lively cafe culture, excellent restaurants, and a beautiful old town. Take a guided walking tour and learn about the city's history and culture.

Day 5: Arles

Head east to the ancient city of Arles, which was founded by the Greeks and later became an important Roman provincial capital. Explore the UNESCO-listed Roman amphitheater and other ancient ruins, and visit the famous Cafe Van Gogh, where the artist painted some of his most iconic works.

Day 6: Pont du Gard

Drive north to the Pont du Gard, a stunning ancient Roman aqueduct and bridge that spans the Gardon River. Marvel at the engineering ingenuity of the structure, and take a dip in the river below.

Day 7: Avignon

Make your way to the walled city of Avignon, which was once the seat of the Catholic Church. Visit the impressive Palais des Papes, a fortress-like palace that was built in the 14th century, and stroll through the charming old town.

Day 8: Gorges Verdon

End your road trip with a visit to the Gorges Verdon, a breathtaking canyon with crystal-clear water and dramatic rock formations. Take a swim in the turquoise waters, hike along the riverbanks, or rent a kayak and explore the canyon from a different perspective.

Remove days

Campervan road trip from Barcelona to Marseille with stops at Figures, Collioure, Narbonne, Montpellier, Arles, Pont du Gard, Avignon, and Gorges Verdon.

Just stops with description

Here are some stops to consider on a campervan road trip from Barcelona to Marseille:

1. Figures: Visit the Dali Museum, which houses a large collection of the surrealist artist's work.
2. Collioure: A charming seaside town known for its colorful buildings and artistic heritage.
3. Narbonne: A historic town once a major Roman port, with a beautiful cathedral and excellent wine and cuisine.
4. Montpellier: A vibrant university town with a beautiful old town and excellent restaurants.
5. Arles: An ancient city with Roman ruins, including a UNESCO-listed amphitheater, and famous Cafe Van Gogh.
6. Pont du Gard: An impressive ancient Roman aqueduct and bridge that spans the Gardon River.
7. Avignon: A walled city that was once the seat of the Catholic Church, with an impressive fortress-like palace and charming old town.
8. Gorges Verdon: A breathtaking canyon with crystal-clear water and dramatic rock formations, perfect for hiking, swimming, or kayaking.

Add campervan campsite options for narbonne, Montpellier, Avignon, gorges verdon

Here are some campsite options for a campervan road trip from Barcelona to Marseille:

1. Narbonne:
- Camping les Floralys: A quiet, family-friendly campsite with shaded pitches and a swimming pool.

2. Montpellier:
- Camping Le Castellas: A beachside campsite with direct access to the beach, a heated pool, and a variety of activities.
- Flower Camping Le Mas de Reilhe: A peaceful, nature-focused campsite with spacious pitches and a friendly atmosphere.

3. Avignon:
- Camping Bagatelle: A large, well-equipped campsite with a restaurant, pool, and playground.
- Camping Les Fontaines: A serene, family-friendly campsite located in the heart of Provence.

4. Gorges Verdon:
- Camping Les Pins: A beautiful campsite located in the middle of pine trees, with swimming pools and an outdoor gym.
- Camping Gorges Du Verdon: A natural setting with amazing views, a pool, and tons of outdoor activities.

Note: It’s always a good idea to check the campsite’s website or contact them prior to booking to ensure they can accommodate a campervan.

find 10 best selling camping lantern from amazon and add review numbers

1. Vont LED Camping Lantern (30,000+ reviews)
2. Etekcity Lantern Camping Lantern (20,000+ reviews)
3. Streamlight 44931 Siege Compact Alkaline LED Hand Lantern (6,000+ reviews)
4. LE LED Camping Lantern (10,000+ reviews)
5. Gold Armour LED Lantern (8,000+ reviews)
6. AYL StarLight 700 - Water Resistant - Shockproof - Long Lasting Up to (4,000+ reviews)
7. Coleman 1000 Lumens LED Lantern with BatteryGuard (1,500+ reviews)
8. MalloMe LED Camping Lantern Flashlights (4,000+ reviews)
9. GearLight LED Lantern with Magnetic Base (3,000+ reviews)
10. Tough Light LED Rechargeable Lantern (3,000+ reviews)

write review article of no 1 product

The Vont LED Camping Lantern is a highly popular product on Amazon, with over 30,000 reviews and an average rating of 4.7 out of 5 stars. This lantern has become a top choice for camping, hiking, power outages, and emergency situations.

One of the standout features of the Vont LED Camping Lantern is its compact and lightweight design. It's easy to pack into a backpack or carry with you on a camping trip. Despite its small size, it is incredibly bright, providing 360-degree illumination with up to 140 lumens of brightness and a distance of up to 30 feet. This makes it ideal for lighting up your campsite or tent.

The lantern is also incredibly durable and long-lasting. It is made of military-grade materials, making it resistant to water, shock, and weather. It also has a long battery life, providing up to 30 hours of continuous use on just one set of batteries.

Another great feature of this lantern is its ease of use. It has push-button operation and a collapsible design that makes it easy to turn on and off, adjust the brightness level, and collapse for storage.

Overall, the Vont LED Camping Lantern is a fantastic choice for anyone in need of a reliable, high-quality lantern for camping or emergency situations. Its compact size, durability, long battery life, and bright illumination make it a great value for its price point. With over 30,000 positive reviews, it's clear that customers are extremely satisfied with their purchase of the Vont LED Camping Lantern.

for no 2 product

The Etekcity Camping Lantern is a highly popular camping lantern on Amazon, with over 20,000 reviews and an average rating of 4.6 out of 5 stars. This lantern has become a top choice for campers, backpackers, and those in need of reliable illumination during power outages or emergency situations.

One of the standout features of the Etekcity Camping Lantern is its brightness. It provides 360-degree illumination with up to 130 lumens of brightness, making it ideal for lighting up a campsite or tent. Additionally, the lantern has three different lighting modes to adjust the brightness level according to your needs.

The lantern is also designed for durability and convenience. It is constructed with military-grade materials, making it water-resistant and able to withstand accidental drops or bumps. The lantern can also be collapsed for easy storage, making it easy to pack and carry with you wherever you go.

Another great feature of the Etekcity Camping Lantern is its versatility. It can be powered by AA batteries or by a USB cable, which is included. This means you can charge the lantern using a power bank or solar panel, which is perfect for longer camping trips.

Finally, the lantern also comes with a two-year warranty, providing extra peace of mind to customers.

Overall, the Etekcity Camping Lantern is a reliable, bright, and versatile lantern that is perfect for camping or emergency situations. Its durability, multiple lighting modes, and collapsible design make it a great value for its price point. With over 20,000 positive reviews, it's clear that customers are extremely satisfied with their purchase of the Etekcity Camping Lantern.