PHP程序员站--PHP编程开发平台
 当前位置:主页 >> PHP基础 >> 基础文章 >> 

某公司一份英文php面试题(E文好的一定要看了)

某公司一份英文php面试题(E文好的一定要看了)

来源:phperz.com  作者:phperz.com  发布时间:2009-04-18
TEST OF PROGRAMMING SKILL Requirements 1 Create a database

TEST OF PROGRAMMING SKILL

 

Requirements

 

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.
 

 

Scenario

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!

 

       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


延伸阅读:
入门级PHP程序员面试题(总100分/47题), 看你能回答多少?
PHP笔试题一
PHP笔试题二
6道php面试题,看你会几个
据说是一家大公司的PHP面试题
php程序员面试题
PHP面试题汇总
据说是yahoo的php面试题(E文的哦)
百度面试题集锦
腾讯PHP工程师笔试题
最新文章
推荐阅读
月点击排行榜
PHP程序员站 Copyright © 2007-2010,PHPERZ.COM All Rights Reserved 粤ICP备07503606号