PHP求助

gxshao

1        Create a database of 60 products, assign each a stock level and a unique Bin location from the range A1 – F10 (see warehouse floorplan).

2        Provide a method for querying a product/bin location which returns the product description, bin location and current stock level.

3        Provide a method for creating an order. An order will always consist of 5 different products chosen by the user.

4        If there is insufficient stock available to fulfil the order display a warning message, otherwise decrease the relevant stock levels and calculate/display the optimum picking route.

The optimum picking route must start from one of the pick stations (P1, P2, P3), and is the shortest number of steps needed to 'pick' all of the products before returning to the original pick station.

5        The picking route, including the chosen starting pick station would usually be included on  the pick sheet so it must be displayed in a way easily interpreted by the picker.

6        The user interface must be web based.

7        Write a short paragraph about the scalability of your solution, i.e. How would the implementation handle a much bigger warehouse?

8        An object oriented approach must be demonstrated.

9         The task must be completed using PHP 5 and mySQL 5.

请教一下这些英文的意思心及如何回答，谢谢。

xinglp

我刚想说,请将中文

gxshao

能不能搞点中文的~哈哈。因为英文太烂了~

gxshao

下面是平面图

Please refer to diagram 1 for an example of a simple warehouse floor plan.

The warehouse consists of 6 racks of product bins A1-F10. Each product bin holds a unique type of product – a product is only accessible by standing directly in front of the product bin.

e.g A 'picker' standing at position 'X' can pick from product bins B6 and C6, whereas a picker standing in position 'Y' cannot pick from anywhere.

The order picking procedure is as follows:
A 'pick sheet' will print at the packing station P1, P2 or P3 & be collected by a picker. The pick sheet lists all products required for an order, the bin location for each product & the  route the picker should follow.
When all items have been picked, the picker returns to the packing station where they collected the original pick sheet & deposits all items.

Note: Pickers can walk directly through the packing stations, but they cannot walk directly through any racking or product bins!

                Y                                                       
        A10        B10                C10        D10                E10        F10       
        A9        B9                C9        D9                E9        F9       
        A8        B8                C8        D8                E8        F8       
        A7        B7                C7        D7                E7        F7       
        A6        B6        X        C6        D6                E6        F6       
        A5        B5                C5        D5                E5        F5       
        A4        B4                C4        D4                E4        F4       
        A3        B3                C3        D3                E3        F3       
        A2        B2                C2        D2                E2        F2       

               A1        B1                C1        D1                E1        F1       

               P1                        P2                        P3               


        Diagram 1:         Simple warehouse floor plan
        Key:                m is the distance in metres.
                        P1, P2, P3 Picking Station coded purple
                        A1-F10 Product bins coded yellow

myjidian

用机器翻译：
1建立一个信息数据库， 60个产品，分配每个股票水平和独特的斌位置范围A1 - F10键（见仓库平面图） 。

2提供的方法查询产品/本的地方，返回的产品说明，本位置和目前的库存水平。

3提供一种方法，创造一个有秩序。的命令，将永远包括5种不同的产品使用者所选择。

4如果没有足够的库存可满足为了显示警告讯息，否则，降低库存水平和相关的计算/显示的最佳选择路线。

最佳选择的路线必须从一个接站（小一，二，三） ，并在最短的一些必要步骤来'挑选'所有的产品，然后再返回原来的挑选站。

5采摘路线，包括选择开始挑选站通常会被列入挑选表，所以它肯定会显示的方式很容易解释的采摘。

6的用户界面必须是基于Web的。

7写短段的可扩展性的解决方案，即如何执行处理一个更大的仓库？

8面向对象的方法必须证明。

9的任务必须完成使用PHP 5和MySQL 5 。

gxshao

如何回答。