All pastes #606112 Raw Edit

Something

public text v1 · immutable
·published 2007-07-06 17:37 UTC
rendered paste body
    public function getToBuild() {
      $stock_par = "SELECT p.name,
                           p.sku,
                           p.category,
                           p.ws_box_size,
                           p.choco,
                           s.par,
                           s.qty AS `have`,
                          s.par - s.qty AS `build`
                    FROM stock s
                      INNER JOIN products p ON s.sku=p.sku
                    WHERE s.par
                          AND s.qty < s.par
                    ORDER BY p.sku ASC";

      $store_backlog = "SELECT p.name,
                               p.sku,
                               p.category,
                               p.ws_box_size,
                               p.choco,
                               SUM(sod.par),
                               SUM(sod.have),
                               SUM(getOrder(sod.par, sod.have)) AS `build`
                        FROM store_orders_data sod
                          INNER JOIN products p ON (sod.sku=p.sku)
                          INNER JOIN store_orders so ON (so.orderid=sod.orderid)
                        WHERE
                              storeOrderStatus(getOrder(sod.par, sod.have), sod.ship, sod.receive) IN (0,1)
                              AND sod.receive=0
                              AND getOrder(sod.par, sod.have) NOT IN(0, sod.ship)
                              AND DATEDIFF(CURDATE(), so.date) < 20
                        GROUP BY p.sku
                        ORDER BY p.sku ASC";

      $sql = "($stock_par) UNION ($store_backlog)";
      $result = query($sql);
      $types = Array();
      while ($row = mysql_fetch_assoc($result))
        $types[$row['category']][] = $row;
      return $types;
    }
  }