public void sendReplenishmentOrder(String mname) {
     //   System.out.println("SendReplenishmentOrder---------" + mname);
        try {
            PreparedStatement stmt = connection.prepareStatement("select stock_number, quantity, max_stock from DepotItem where trim(mname) = trim(?)");
            stmt.setString(1, mname);
            ResultSet rs = stmt.executeQuery();
            DepotItemModel depotItemModel = new DepotItemModel(connection);
            ShippingNoticeModel shippingNoticeModel = new ShippingNoticeModel(connection);
            ShippingListedModel shippingListedModel = new ShippingListedModel(connection);
            int id = getShipId();
            shippingNoticeModel.insert(id, "FEDEX");
            while (rs.next()) {

                //    if(depotItemModel.load(rs.getString("stock_number")))
                //   {
                int difference = rs.getInt("max_stock") - rs.getInt("quantity");
            //    System.out.println("difference: " + difference);

                if (difference > 0) {
            //        System.out.println("inserted: " + rs.getString("stock_number"));
                    shippingListedModel.insert(rs.getString("stock_number"), id, difference);
                    //warehouse sends request to manufacturer/manufacturer sends shipping notice
                }

                //depotItemModel.setQuantity(depotItemModel.getQuantity() - rs.getInt("amount"));
                //   }
            }
            receiveShippingNotice(id);
        } catch (SQLException e) {
            e.printStackTrace();
        }
     //   System.out.println("SendReplenishmentOrder END-------------");
    }