create simple php inventory system

Project overview: To create a simple online inventory system : [login to view URL] Total pages: 7 1x main data display page (half completed need to add sorting function) 1x customer service home page 1x customer service edit page (need editing : [login to view URL]) 1x customer service return page 1x warehouse home page (show the list of current records) 1x warehouse edit page 1x warehouse return page functions 1) create login accounts for a) customer service user (only able to edit online inventory section) b) warehouse user (only able to edit warehouse inventory section) c) regular user (view only) ** no need to create admin since i can login to the database and edit data directly 2)fix pagination (let user to select max display , per display by 25 , 50 , 100 , 250 , 500) 3) Customer service update: Qty on hand and Qty sold ONLY ( half completed able to update but maybe need to make a sort for that page and maybe add a csv upload function to replace data too) 4)Warehouse update : physical update ONLY and auto time stamp when row was updated (same function as Customer service update except only for physical inventory data) ==== this part are bit more complicated maybe we can talk about later tonight if you are free ======= **return page: has 2 sections, one part from warehouse and one part from customer each part are separately inputted into the system but viewable by both users 5) warehouse return page : let warehouse user add a return record data: *case no,*date , *partno , *first name , *last name , *RMA, ebay id , address , condition 6)customer return page: let customer user add return record and keep track of open case/issue data: *case no,*RMA no,*date , *partno , *first name , *last name, ebayid, categories , ebay case number,address , note , respond,conclusion date * means require data