项目-库存管理系统 Inventory-Management-Project.doc

Skills Required: Any Front End Tool and SQL ServerProject Case Title: Inventory Management System for Drug Store技能需求：任何前端工具与SQL Server项目案例标题：药店库存管理系统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学习目标：1. 数据库建模 2. 数据库设计的关系映射3. 用户界面设计4. 模块方法5. 数据逻辑和显示逻辑的分离6. 业务流程和逻辑的执行7. 开发问题解决方法，问题分析，使用编程逻辑建立解决方案8. 应用模块之间的关联9. 生成报告10. 项目设计，开发，测试，部署，演示11. 项目文档和项目开发方式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 是一家全球药店连锁，现在针对销售不同类型药品(如西药，中药，医保材料)的店面进行库存管理，该店的运行规模很大，员工也分为早班和晚班。每班都由包括5个销售人员，1个收银员，一个值班经理，以及一个5人的送货团队组成。此外，该店将客户分为不同级别，如VIP客户和普通客户，实行不同的折扣计划。折扣计划只面向注册了的客户。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 客户可以注册，然后使用自己的折扣计划，每个客户会分配一个唯一的客户ID 客户可以参观店面，可以更新自己的个人信息，包括地址，联系方式等 注册的客户还可以通过电话下订单，并且可以使用到货付款2. Store Manager 店长 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 一个团队最多能有5个销售人员和一个收银员 管理本店员工信息(除了创建和删除,创建和删除是由人力部门) 更新个人信息等信息 更改密码 查看总库存（店库存） 产生如下的报告：每个销售人员的销售报告，日总销售，周总销售，每个品目的日销售，每天/周/月销售额最高的销售人员，日平均销售 对于达到需要再订购的品目，能够发送采购请求给采购部 查看采购请求的状态 能够跟踪已发货药品的详细信息（跟踪订单） 生成每个送货员的报告 能够查看每个客户的订单中，交货失败，需要取消的订单的信息。(不管是线上销售还是线下销售在订单商品出库之后是不能取消。)（只针对线下销售，线上销售不记入团队） 备注：修改的收银员和销售人员是修改的本店的人员，其他店的员工信息不能修改。所有信息都是本店的。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 客户在收银台付款并获得购买的东西，然后退出，网上销售(不联系团队) 电话订单：销售人员也可以通过电话接受注册用户的订单。然后，送货员会在货物送到后收到货款，到时候需要收银员根据送货员的反馈更新系统。 备注：线下订单产生由销售人员产生，发送给经理，由经理产生送货单，产生送货单的同时指定送货员。4. Store Owner 董事长 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去掉“班次” 能够生成整个报告，如： 每天每个团队的总销售 每周每个团队的总销售 每月每个团队的总销售 注释：团队的销售额根据“已交付”的订单属于哪个“员工”所属的“团队” 每个团队在某一段期限内的销售总额，如从某月到某月 以上提到的性质类似的品目的销售 总库存以及每个品目的库存 药店绩效报告，如每个销售人员的销售信息 季度总销售 注册用户的总数量 每个员工的出勤信息(比如Excel的导入) 付给员工的总工资 工资最高和最低的员工 基于级别（就在药店工作的年限而言）的员工报告 提供折扣的品目信息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 招聘每位员工并维护员工如下的信息： 员工编号，姓名，地址，联系方式，出生日期，资质，总的经验，基本工资，销售提成，月销售指标(指标放入团队) 根据员工的绩效和总销售额更新要付给每位员工的月工资信息6. Order Delivery Status for Registered customers 注册用户的订单交付状态 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 每个送货员都有一个唯一的ID 货送到后，送货员回到店里后会在系统里更新交货状态，并将现金交给收银员(由收银员录入，非送货员) 然而，对于处于某些原因不能交付的品目，只有店长有权限取消订单号并将品目放回店里，并更新库存7. Inventory cum purchase manager: 库存和采购经理 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 跟踪库存，针对数量达到警戒线下的每个品目向供应商下订单 一旦下订单，他要将详细信息发给财务部用于支付款项给供应商 采购的货物送到后，更新库存 备注：加入“店库存”和“总库存”，“采购请求单”针对“店库存”，“采购单”针对“总库存”8. Finance Department: 财务部门 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 根据HR的报告发放员工工资 根据库存采订单付款给供应商 能够生成手头总现金的报告 财务部门还要维护月支出，如总电费，税费，物业费，店面月租金等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 每位经理都被授权，能够为收银员和团队里的销售人员，送货员创建登陆账户，但是登陆账户不能超过5个销售人员，5个送货员，1个收银员 每个销售人员使用自己的ID登