javascript - 如何让函数变得简单

Question

也许删除一些逻辑运算符，做一个“检查功能”？

或者将一些逻辑连接在一起？

// 功能

function getTicketPrice(childNumber,adultNumber){

  if (childNumber > 2 && adultNumber > 2) {
    return "-";
  }
    if (childNumber == 2 && adultNumber == 3) {
    return "-";
  }
    if (childNumber == 3 && adultNumber == 2) {
    return "-";
  }  

  var sheet = SpreadsheetApp.openByUrl(url).getSheetByName("Ticket");  
  var row = getTicketPriceChild(childNumber, sheet);
  var col = getTicketPriceAdult(adultNumber, sheet);

    if (row >-1 && col === undefined) {
    return "-";
  }
    if (row === undefined && col >-1) {
    return "-";
  }    

  var value = sheet.getRange(row, col).getValue();

    if(value > 1){
    return value;
  } else {
    return '-';
  }
}

标签： javascriptgoogle-apps-scriptgoogle-sheetsrefactoring

Answer 1

像这样的东西：

function getTicketPrice(childNumber, adultNumber) {
  if ((childNumber > 2 && adultNumber > 2) || (childNumber == 2 && adultNumber == 3) || (childNumber == 3 && adultNumber == 2))
    return "-";

  const sheet = SpreadsheetApp.openByUrl(url).getSheetByName('Ticket');
  const row = getTicketPriceChild(childNumber, sheet);
  const col = getTicketPriceAdult(adultNumber, sheet);

  if ((row > -1 && col === undefined) || (row === undefined && col > -1))
    return "-";

  const value = sheet.getRange(row, col).getValue();
  return value > 1 ? value : "-"
}