购物网站需求分析

 购物网站

项目分类

 前台浏览网站

 后台管理网站

 论坛网站

项目组

 STARHO

数据库设计

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 商品       Goods

  商品编号 P   GID

  商品名称    GNAME

  商品单价    GPRICE

  商品库存    GCOUNT

  商品状态    GSTATUS

  商品图像    GPIC

  商品分类编号 F商品类别-商品分类编号 GFID

  供应商编号 F供应商-供应商编号 OID

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 商品类别      GoodStyle

  商品分类编号 P   GFID

  商品分类大名称    GFBIGNAME

  商品分类小名称    GFSMANAME

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 供应商       Offer

  供应商编号 P   OID

  供应商名称    ONAME

  供应商电话    OTEL

  供应商地址    OADDR

  供应商账户    OACCOUNT

  供应商状态    OSTATUS

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 购物车       Buy

  商品编号 F商品-商品编号  BID

  商品数量    BNUM

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 会员       User

  会员编号 P   UID

  会员名称    UNAME

  会员密码    UPASS

  会员昵称    UNICK

  会员性别    USEX

  会员年龄    UAGE

  会员电话    UTEL

  会员一阶区域    UPROVIENCE

  会员二阶区域    UCITY

  会员三阶区域    UPART

  会员头像    UPIC

  会员状态    USTATUS

  会员注册时间    UREGTIME

  会员上次登陆时间   ULASTLOGINTIME

  会员积分    UFEES

  会员余额    ULEFT

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 员工       Emplorer

  员工编号 P   EID

  员工账户    ENAME

  员工姓名    EUSER

  员工性别    ESEX

  员工密码    EPASS

  员工电话    ETEL

  员工住址    EADDR

  员工头像    EPIC

  员工状态    ESTATUS

  职位编号 F职位-职位编号  WID

  员工任职时间    EONTIME

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 职位       Work

  职位编号 P   WID

  职位名称    WNAME

  权限编号 F权限-权限编号  RID

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 权限       Right

  权限编号 P   RID

  权限名称    RNAME

  权限URL     RURL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 订单       PayBILL

  订单编号 P   PID

  会员编号 F会员-会员编号  UID

  收货人     PNAME

  收货地址    PADDR

  收货电话    PTEL

  付款方式    POFFERWAY

  商品总价    PTOTAL

  订单状态    PSTATUS

  审批人  员工编号  EID

  发货人  员工编号  EID

  提交时间    PTIME

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 订单详情      ALL

  订单编号 F订单-订单编号  PID

  商品编号 F商品-商品编号  GID

  商品数量    PNUM

  商品单价    GPRICE

  商品总价    ATOTAL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 采购       Jin

  采购编号 P   JID

  员工编号 F员工-员工编号  EID

  采购总价    JTOTAL

  采购单备注    JBEIZHU

  提交时间    JSENDTIME

  完成时间    JFINITIME

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 采购详单      XLL

  详单编号 P   XID

  采购编号 F采购-采购编号  JID

  供应商编号 F供应商-供应商编号 OID

  商品编号    GID

  商品数量    XNUM

  商品进货价    XPRICE

  商品总价    XTOTAL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 

 公告       Call

  公告编号 P   CID

  公告标题    CTITLE

  公告内容    CCONTENT

  公告时间    CTIME

  公告人  员工编号  EID

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 日志       LOG

  日志编号 P   LID

  登陆时间    LLOGINTIME

  员工编号 F员工-员工编号  EID

  登陆会话    LSESSION

  登陆IP     LLOGINIP

  操作  SQL语句   LSQL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 

 主页       Index

  主页LOGO编号 P   IID

  主页LOGOURL    IURL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 导航栏       Daohang

  导航栏编号 P   DID

  导航栏名称    DNAME

  导航栏URL    DURL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

 页面主题      Theme

  主题编号 P   TID

  主题名称    TNAME

  背景URL     TBGURL

  上部URL     TUURL

  左部URL     TLURL

  右部URL     TRURL

  下部URL     TDURL

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

网站使用角色

 游客

 注册会员

 administrator

 采购经理 审核

 采购员  发起采购单

 销售经理 审核

 销售员  补充订单

===================================================================

运行流程

前台：

1 游客——浏览商品类别——浏览商品信息

2  注册——》注册会员——会员首页

3 会员——浏览商品——》{购买}-》购物车

4 会员——购物车——{添加到订单}——订单

5 会员——充值

 页面——联合查询，模糊查询

后台：

1 订单——》销售员——{补充订单}》销售经理——{审批}》销售员——{发货}》订单

2 采购员——填写》采购表——》采购经理——{审批}》采购员——{开始采购}》采购表——{完成}》采购经理——》商品添加

3 administror——公告——》发布公告

4 administror——员工添加、所谓删除、永久删除

5 采购经理——商品类别添加、修改、删除

6  ——商品添加、修改、删除

7 销售经理——用户查询、状态修改，账户信息通知

8 采购员——商品数量低于警戒线的商品

9  ——新采购单，自动采购单

0 销售员——商品查询

A  ——商品导购

B  ——订单补充并提交

C administror——权限分配表

页面设计

=============前台显示页面=================

 index 首页

 ipage 用户登陆主页

 registe 注册页

 rePay 充值页

 detail 商品信息页

 sort 排序显示页

==============后台管理页面================

 admin 管理登陆页

 manage 管理首页

==============其他========================

 about 网站联系信息

------------------------------------------

流程+页面

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&77

1  首页--》商品类别显示页--》商品信息页

2  首页--》注册页--》注册完成页--{n秒后跳到首页}

3  首页--》登陆区域--》商品类别显示页--》商品信息页--》{购买}-》购物车

4  购物车--》{商品添加、修改、删除}--》生成订单--》提交订单

5  个人购物主页--》充值页--》充值成功页

----------------------------------------------------------------------

登陆页--》管理首页-[销售员]--

登陆页--》管理首页-[销售经理]--

登陆页--》管理首页-[采购员]--

登陆页--》管理首页-[采购经理]--

登陆页--》管理首页-[administrator]--

运用技术

@图片上传

@分页显示

@员工权限分配

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/hhg98/archive/2009/04/03/4024312.aspx