static updateVinyl(date, name, delivered, used){
    let MatID = 54
    if (name === "1105") MatID = 55
    else if (name === "1106") MatID = 56
    else if (name === "Laminate") MatID = 57
    return db.query(
      'INSERT INTO amounts (Date, DepID, MatID, InStock, Lost) \
      VALUES (?, 13, ?, ? - ?, 0) \
      ON DUPLICATE KEY UPDATE InStock = InStock + ? - ?',
      [date, MatID, delivered, used, delivered, used]
    )
  }
// Updates amounts of vinyls. Vinyls cannot be lost, only used.
Updates amounts of vinyls. Vinyls cannot be lost, only used.
Updates amounts of vinyls . Vinyls cannot be lost only used .
static updateVinyl(date, name, delivered, used){
    let MatID = 54
    if (name === "1105") MatID = 55
    else if (name === "1106") MatID = 56
    else if (name === "Laminate") MatID = 57
    return db.query(
      'INSERT INTO amounts (Date, DepID, MatID, InStock, Lost) \
      VALUES (?, 13, ?, ? - ?, 0) \
      ON DUPLICATE KEY UPDATE InStock = InStock + ? - ?',
      [date, MatID, delivered, used, delivered, used]
    )
  }
static updateVinyl ( date , name , delivered , used ) { let MatID = 54 if ( name === "1105" ) MatID = 55 else if ( name === "1106" ) MatID = 56 else if ( name === "Laminate" ) MatID = 57 return db . query ( 'INSERT INTO amounts (Date, DepID, MatID, InStock, Lost) \
      VALUES (?, 13, ?, ? - ?, 0) \
      ON DUPLICATE KEY UPDATE InStock = InStock + ? - ?' , [ date , MatID , delivered , used , delivered , used ] ) }
Updates amounts of vinyls.
Updates amounts of vinyls .