static fetchReadyShip() {
    return db.query( // ReadyShip departmentID's are 34, 35, and 36. (Excludes MainSkinReadyShip (37))
      'WITH temp AS ( \
        SELECT ProdID, amounts.MatID, InStock, MaterialAmount \
        FROM productmaterials INNER JOIN amounts ON productmaterials.MatID = amounts.MatID \
        WHERE DepID IN (34, 35, 36) AND Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
      ) \
      SELECT CAST(MIN(InStock/MaterialAmount) AS int) AS ReadyShip, ProductName \
      FROM temp INNER JOIN products ON temp.ProdID = products.ProductID \
      WHERE Discontinued = 0 \
      GROUP BY ProductName \
      ORDER BY ProductName'
    );
  }
// each product and returns the minimum number among the materials needed for a product.
each product and returns the minimum number among the materials needed for a product.
each product and returns the minimum number among the materials needed for a product .
static fetchReadyShip() {
    return db.query( 
      'WITH temp AS ( \
        SELECT ProdID, amounts.MatID, InStock, MaterialAmount \
        FROM productmaterials INNER JOIN amounts ON productmaterials.MatID = amounts.MatID \
        WHERE DepID IN (34, 35, 36) AND Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
      ) \
      SELECT CAST(MIN(InStock/MaterialAmount) AS int) AS ReadyShip, ProductName \
      FROM temp INNER JOIN products ON temp.ProdID = products.ProductID \
      WHERE Discontinued = 0 \
      GROUP BY ProductName \
      ORDER BY ProductName'
    );
  }
static fetchReadyShip ( ) { return db . query ( 'WITH temp AS ( \
        SELECT ProdID, amounts.MatID, InStock, MaterialAmount \
        FROM productmaterials INNER JOIN amounts ON productmaterials.MatID = amounts.MatID \
        WHERE DepID IN (34, 35, 36) AND Date = (SELECT DATE(CURRENT_TIMESTAMP() - INTERVAL 8 HOUR)) \
      ) \
      SELECT CAST(MIN(InStock/MaterialAmount) AS int) AS ReadyShip, ProductName \
      FROM temp INNER JOIN products ON temp.ProdID = products.ProductID \
      WHERE Discontinued = 0 \
      GROUP BY ProductName \
      ORDER BY ProductName' ) ; }
each product and returns the minimum number among the materials needed for a product.
each product and returns the minimum number among the materials needed for a product .
// ReadyShip departmentID's are 34, 35, and 36. (Excludes MainSkinReadyShip (37))