Getting items lookup and people picker

Forms SharePoint Online
1

I have a custom button when on click I book a desk. On click on the button I want to check if current user has a desk booked (day is a Look up field in dd/MM/yyyy' format). to denote the booking user is Assigned the desk (i.e. Asssigned to field).

ChartGP has generated below. but its not working

const today = new Date().toLocaleDateString('en-GB'); // format date as dd/MM/yyyy
const currentUserID = _spPageContextInfo.userId; // get current user email

pnp.sp.web.lists.getByTitle('Desks').items
  .select('AssignedToID', 'Day/Day', 'Desk')
  .expand('AssignedTo', 'Day')
  .filter(`AssignedToID '${currentUserID}' and Day/Day eq '${today}'`)
  .get()
  .then(items => {
    if (items.length > 0) {
      // user has a desk booked for today
      console.log(`User ${currentUserID} has desk ${items[0].Desk} booked for today.`);
      alert(`User ${currentUserEmail} has desk ${items[0].Desk} booked for today.`);
    } else {
      // user does not have a desk booked for today
      console.log(`User ${currentUserID} does not have a desk booked for today.`);
      alert(`User ${currentUserEmail} does not have a desk booked for today.`);
    }
  })
  .catch(console.log);

Any ideas?

2

Dear @Demmick74,
This is a weird code... I don't recommend using it as it definitely wouldn't work.

It's easy to compare user, but not all users will have their email available, it might need to be retrieved. It's very challenging to compare dates.

This is an approximation of how it might look:

pnp.sp.web.lists.getByTitle('Booking').items
  .select('AssignedTo/EMail', 'Date', 'Desk')
  .expand('AssignedTo')
  .filter("AssignedTo/EMail eq '" + _spPageContextInfo.userEmail + "'")
  .get()
  .then(items => {
    console.log(items);
    var today = new Date();
    today.setHours(0,0,0,0);
    var hasToday = false;
    for(var i = 0; i < items.length; i++){
      var date = new Date(items[i].Date);
      date.setHours(0,0,0,0)
      if(today.valueOf() == date.valueOf()){
        console.log('True');
        hasToday = true;
      }
    }
    if (items.length > 0 && hasToday) {
      // user has a desk booked for today
      alert(`User has desk booked for today.`);
    } else {
      // user does not have a desk booked for today
      alert(`User does not have a desk booked for today.`);
    }
  })
  .catch(console.log);