static fetchPreProduction(){
    return db.query( // Pre-production departmentID's are 13, 18, and 25.
    'SELECT InStock, MaterialName \
    FROM amounts INNER JOIN materials ON amounts.MatID = materials.MaterialID \
    WHERE DepID IN (13, 18, 25) AND Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
    ORDER BY MaterialName')
  }
// Returns the amount of materials in pre-production 
Returns the amount of materials in pre-production
Returns the amount of materials in pre - production
static fetchPreProduction(){
    return db.query( 
    'SELECT InStock, MaterialName \
    FROM amounts INNER JOIN materials ON amounts.MatID = materials.MaterialID \
    WHERE DepID IN (13, 18, 25) AND Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
    ORDER BY MaterialName')
  }
static fetchPreProduction ( ) { return db . query ( 'SELECT InStock, MaterialName \
    FROM amounts INNER JOIN materials ON amounts.MatID = materials.MaterialID \
    WHERE DepID IN (13, 18, 25) AND Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
    ORDER BY MaterialName' ) }
Returns the amount of materials in pre-production
Returns the amount of materials in pre - production
// Pre-production departmentID's are 13, 18, and 25.