static rollbackAll() {
    return db.query(
      'UPDATE amounts, (SELECT * FROM amounts WHERE Date = \
        (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR - INTERVAL 1 DAY))) AS temp \
      SET amounts.InStock = temp.InStock, amounts.Lost = temp.Lost \
      WHERE amounts.Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
        AND amounts.DepID = temp.DepID AND amounts.MatID = temp.MatID'
    )
  }
// Sets the values in amounts for the current day to be the values of the previous day
Sets the values in amounts for the current day to be the values of the previous day
Sets the values in amounts for the current day to be the values of the previous day
static rollbackAll() {
    return db.query(
      'UPDATE amounts, (SELECT * FROM amounts WHERE Date = \
        (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR - INTERVAL 1 DAY))) AS temp \
      SET amounts.InStock = temp.InStock, amounts.Lost = temp.Lost \
      WHERE amounts.Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
        AND amounts.DepID = temp.DepID AND amounts.MatID = temp.MatID'
    )
  }
static rollbackAll ( ) { return db . query ( 'UPDATE amounts, (SELECT * FROM amounts WHERE Date = \
        (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR - INTERVAL 1 DAY))) AS temp \
      SET amounts.InStock = temp.InStock, amounts.Lost = temp.Lost \
      WHERE amounts.Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
        AND amounts.DepID = temp.DepID AND amounts.MatID = temp.MatID' ) }
Sets the values in amounts for the current day to be the values of the previous day
Sets the values in amounts for the current day to be the values of the previous day