項(xiàng)目-庫(kù)存管理系統(tǒng) Inventory-Management-Project.doc

Skills Required: Any Front End Tool and SQL ServerProject Case Title: Inventory Management System for Drug Store技能需求：任何前端工具與SQL Server項(xiàng)目案例標(biāo)題：藥店庫(kù)存管理系統(tǒng)Learning Objective: 1. Database Modeling 2. Relational Mapping for Database Design3. User Interface designing4. Modular approach5. Separation of Data Logic and the Presentation Logic6. Implementation of the Business process and the Logic7. Development of problem solving approach, problem analysis and using programming logic to build up solutions8. Inter linkage of application modules9. Report Generation10. Project Designing, Development, Testing, Deployment, Demonstration11. Project Documentation and Project Development approach學(xué)習(xí)目標(biāo)：1. 數(shù)據(jù)庫(kù)建模 2. 數(shù)據(jù)庫(kù)設(shè)計(jì)的關(guān)系映射3. 用戶界面設(shè)計(jì)4. 模塊方法5. 數(shù)據(jù)邏輯和顯示邏輯的分離6. 業(yè)務(wù)流程和邏輯的執(zhí)行7. 開(kāi)發(fā)問(wèn)題解決方法，問(wèn)題分析，使用編程邏輯建立解決方案8. 應(yīng)用模塊之間的關(guān)聯(lián)9. 生成報(bào)告10. 項(xiàng)目設(shè)計(jì)，開(kāi)發(fā)，測(cè)試，部署，演示11. 項(xiàng)目文檔和項(xiàng)目開(kāi)發(fā)方式Synopsis:Global Drug, a global chain of drug store needs to manage inventory system for their store selling different type of medicines such as Western Medicines, Traditional Medicines, and Medical accessories. The store operates on a larger scale and work in two shift that is day shift and the night shift. Each shift has a team of 5 salesperson, 1 counter cashier and a shift store manager and a team of 5 Delivery boys. Also, the store supports different range of customers for providing special discount schemes such as VIP customer and Regular customer. The store also launches discount scheme for their customers based on their daily, weekly, monthly sales. But, the schemes are only available to registered customers.大綱： Global Drug 是一家全球藥店連鎖，現(xiàn)在針對(duì)銷售不同類型藥品(如西藥，中藥，醫(yī)保材料)的店面進(jìn)行庫(kù)存管理，該店的運(yùn)行規(guī)模很大，員工也分為早班和晚班。每班都由包括5個(gè)銷售人員，1個(gè)收銀員，一個(gè)值班經(jīng)理，以及一個(gè)5人的送貨團(tuán)隊(duì)組成。此外，該店將客戶分為不同級(jí)別，如VIP客戶和普通客戶，實(shí)行不同的折扣計(jì)劃。折扣計(jì)劃只面向注冊(cè)了的客戶。1. Customer Management: 客戶管理 Customers can register to avail discount scheme and be given unique customer ID Customer can visit store and report any Updates in their profile such as personal details, address, contact details Registered customers can also place order on phone and avail facility of Cash on Delivery payment 客戶可以注冊(cè)，然后使用自己的折扣計(jì)劃，每個(gè)客戶會(huì)分配一個(gè)唯一的客戶ID 客戶可以參觀店面，可以更新自己的個(gè)人信息，包括地址，聯(lián)系方式等 注冊(cè)的客戶還可以通過(guò)電話下訂單，并且可以使用到貨付款2. Store Manager 店長(zhǎng) Create user id for the cashier counter for their respective shift Create and store Salesperson data in the database such as Salesperson ID and the relevant details such as ID, Name, DateofJoining, dateofbirth etc. A manager cannot have more than 5 salesperson in the team at a time, 1 counter cashier Update profile such as personal details Update password Check total inventory Generate reports such as : Sales report per salesperson wise, total daily sales , sales per week, Item wise daily sales, Salesperson with maximum sales record on daily basis, weekly and monthly basis, Daily Average sales Check Inventory based on each item Be able to send Sale requisition to the procurement department for items that reaches their Reorder level Check the status of their requisition status Update the price of items, discount to be offered on the total sales etc Be able to track details of payment for Delivered drugs Generate report Delivery boy wise Be able to see the details of the customer wise order that failed delivery and had to be cancelled 一個(gè)團(tuán)隊(duì)最多能有5個(gè)銷售人員和一個(gè)收銀員 管理本店員工信息(除了創(chuàng)建和刪除,創(chuàng)建和刪除是由人力部門) 更新個(gè)人信息等信息 更改密碼 查看總庫(kù)存（店庫(kù)存） 產(chǎn)生如下的報(bào)告：每個(gè)銷售人員的銷售報(bào)告，日總銷售，周總銷售，每個(gè)品目的日銷售，每天/周/月銷售額最高的銷售人員，日平均銷售 對(duì)于達(dá)到需要再訂購(gòu)的品目，能夠發(fā)送采購(gòu)請(qǐng)求給采購(gòu)部 查看采購(gòu)請(qǐng)求的狀態(tài) 能夠跟蹤已發(fā)貨藥品的詳細(xì)信息（跟蹤訂單） 生成每個(gè)送貨員的報(bào)告 能夠查看每個(gè)客戶的訂單中，交貨失敗，需要取消的訂單的信息。(不管是線上銷售還是線下銷售在訂單商品出庫(kù)之后是不能取消。)（只針對(duì)線下銷售，線上銷售不記入團(tuán)隊(duì)） 備注：修改的收銀員和銷售人員是修改的本店的人員，其他店的員工信息不能修改。所有信息都是本店的。3. Sales Module 銷售模塊 Each salesperson will take order and generate corresponding bills Customer would pay their bill at the cash counter and collect their purchase before exit Telephone order: Salesperson can also take order over the phone from registered customers and generate bills. However the Delivery boy would get cash on delivery from the customer that need to update by the cashier once the payment has been received by him 客戶在收銀臺(tái)付款并獲得購(gòu)買的東西，然后退出，網(wǎng)上銷售(不聯(lián)系團(tuán)隊(duì)) 電話訂單：銷售人員也可以通過(guò)電話接受注冊(cè)用戶的訂單。然后，送貨員會(huì)在貨物送到后收到貨款，到時(shí)候需要收銀員根據(jù)送貨員的反饋更新系統(tǒng)。 備注：線下訂單產(chǎn)生由銷售人員產(chǎn)生，發(fā)送給經(jīng)理，由經(jīng)理產(chǎn)生送貨單，產(chǎn)生送貨單的同時(shí)指定送貨員。4. Store Owner 董事長(zhǎng) Be able to generate the entire report such as Daily Shift wise total sales Weekly Shift wise total sales Monthly shift wise total sales Shift wise total sales in a range such as from a particular month to a specific month Item wise sales of the similar nature as mentioned above Manager wise team report Total value of inventory and also the item wise break up Performance report for the store such as salesperson wise sales details Total sales during the quarter Total discount offered by the store Daily, Weekly, Monthly Total number of registered customers Attendance details for each employee Total salary paid to employees Employees with highest salary, lowest salary Employee reports based on seniority in terms of number of years served at the store Item wise details that offer discount去掉“班次” 能夠生成整個(gè)報(bào)告，如： 每天每個(gè)團(tuán)隊(duì)的總銷售 每周每個(gè)團(tuán)隊(duì)的總銷售 每月每個(gè)團(tuán)隊(duì)的總銷售 注釋：團(tuán)隊(duì)的銷售額根據(jù)“已交付”的訂單屬于哪個(gè)“員工”所屬的“團(tuán)隊(duì)” 每個(gè)團(tuán)隊(duì)在某一段期限內(nèi)的銷售總額，如從某月到某月 以上提到的性質(zhì)類似的品目的銷售 總庫(kù)存以及每個(gè)品目的庫(kù)存 藥店績(jī)效報(bào)告，如每個(gè)銷售人員的銷售信息 季度總銷售 注冊(cè)用戶的總數(shù)量 每個(gè)員工的出勤信息(比如Excel的導(dǎo)入) 付給員工的總工資 工資最高和最低的員工 基于級(jí)別（就在藥店工作的年限而言）的員工報(bào)告 提供折扣的品目信息5. HR Module 人力資源模塊 Recruits each employee and maintain the details of employee such EmployeeID, Name, Address, Contact Details, Dateofbirth, qualification, total experience, basic Salary, commission percentage to be paid based on total sales, Monthly Sales target Update monthly details on Salary to be paid to each employee based on performance and the total sales done 招聘每位員工并維護(hù)員工如下的信息： 員工編號(hào)，姓名，地址，聯(lián)系方式，出生日期，資質(zhì)，總的經(jīng)驗(yàn)，基本工資，銷售提成，月銷售指標(biāo)(指標(biāo)放入團(tuán)隊(duì)) 根據(jù)員工的績(jī)效和總銷售額更新要付給每位員工的月工資信息6. Order Delivery Status for Registered customers 注冊(cè)用戶的訂單交付狀態(tài) Each Delivery boy will have a unique ID When delivery is done, the delivery boy will update the delivery status on the system after he is back to the store and hand over the cash to the counter cashier However, for items that cannot be delivered due to any reason, only the store manager is authorized to cancel the order number and put the items back in the store and this also updates the inventory 每個(gè)送貨員都有一個(gè)唯一的ID 貨送到后，送貨員回到店里后會(huì)在系統(tǒng)里更新交貨狀態(tài)，并將現(xiàn)金交給收銀員(由收銀員錄入，非送貨員) 然而，對(duì)于處于某些原因不能交付的品目，只有店長(zhǎng)有權(quán)限取消訂單號(hào)并將品目放回店里，并更新庫(kù)存7. Inventory cum purchase manager: 庫(kù)存和采購(gòu)經(jīng)理 Keep a track of inventory and place order with the supplier for each item that are about to be below their Reorder level Once the order has been placed, he send the details to the Finance department for payment to the supplier Once the order received has been received, update the inventory 跟蹤庫(kù)存，針對(duì)數(shù)量達(dá)到警戒線下的每個(gè)品目向供應(yīng)商下訂單 一旦下訂單，他要將詳細(xì)信息發(fā)給財(cái)務(wù)部用于支付款項(xiàng)給供應(yīng)商 采購(gòu)的貨物送到后，更新庫(kù)存 備注：加入“店庫(kù)存”和“總庫(kù)存”，“采購(gòu)請(qǐng)求單”針對(duì)“店庫(kù)存”，“采購(gòu)單”針對(duì)“總庫(kù)存”8. Finance Department: 財(cái)務(wù)部門 Releases employee salary based on reports from HR Release payment to supplier based on Purchase order from the Inventory Be able to generate report on total cash in hand Finance department also need to maintain details of monthly expenses such as Total Electricity bills Paid, water bill, logistic bill, store monthly rent 根據(jù)HR的報(bào)告發(fā)放員工工資 根據(jù)庫(kù)存采訂單付款給供應(yīng)商 能夠生成手頭總現(xiàn)金的報(bào)告 財(cái)務(wù)部門還要維護(hù)月支出，如總電費(fèi)，稅費(fèi)，物業(yè)費(fèi)，店面月租金等9. User Management 用戶管理 Each manager is authorized to create Login Details for their cashier and the team of sales person, delivery boy but the login cannot exceed 5 for salesperson, 5 for delivery boys and 1 for cashier Each Salesperson will log in using their id and be given a sales form to use and generate invoice. They will have no access to any other details 每位經(jīng)理都被授權(quán)，能夠?yàn)槭浙y員和團(tuán)隊(duì)里的銷售人員，送貨員創(chuàng)建登陸賬戶，但是登陸賬戶不能超過(guò)5個(gè)銷售人員，5個(gè)送貨員，1個(gè)收銀員 每個(gè)銷售人員使用自己的ID登