29、生鲜电商平台-销售管理设计与架构-白红宇

29、生鲜电商平台-销售管理设计与架构

阅读量：6327 次

发布时间：2019-06-22

本文共 20947 字，大约阅读时间需要 69 分钟。

说明：在Java开源生鲜电商平台中，销售人员我们称为跟餐饮店老板沟通与下载APP的一类地推人员。（所谓地推指的就是一个一个上门拜访。）

由于销售人员有以下几类特性：

1. 时间随意性，他们并不类似技术或者性质人员，需要天天呆在办公室，他们是需要去外面，时间上具有随意性。

2. 行动随意性，他们的行动过于随意，每天也不用来打卡，每天就是按照计划去拜访客户，然后推销生鲜电商APP，让客户来进行下单，那么行为很随意，站在公司的角度

我们是没办法控制这种行为，但是我们也很想知道目前销售人员进度在哪里来了，遇到了什么问题，一般如何解决。

3. 内容随意性，每天早上开会，晚上复盘，很多的时候我们会问今天你们拜访了那些客户，遇到了那些问题，如何解决的，经验进行分享，但是很多时候我们其实不知道内容是真还是假的，因为销售的嘴皮太能说了。

那么如此多的问题，作为技术上，我们应该如何帮助公司呢？对此需要一个管理的销售APP。

1. 技术上设计，会设计到以下几点；

2. 销售人员本身的管理。

CREATE TABLE `sales` (  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自动增加ID',  `phone` varchar(32) DEFAULT NULL COMMENT '手机号码',  `password` varchar(32) DEFAULT NULL COMMENT 'md5加密',  `true_name` varchar(16) DEFAULT NULL,  `status` int(11) DEFAULT NULL COMMENT '1为在职，-1为离职',  `create_time` datetime DEFAULT NULL COMMENT '创建时间',  `last_update_time` datetime DEFAULT NULL COMMENT '更新时间',  `level` int(11) DEFAULT NULL COMMENT '类型1总监 2主管 3职员',  `experience` decimal(12,2) DEFAULT NULL,  `parent_id` bigint(20) DEFAULT NULL COMMENT '直属上级',  PRIMARY KEY (`id`),  KEY `unique_phone` (`phone`)) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='销售人员基本信息';

补充说明；任何人员的管理都会存在一个管理人员的权限问题，最高领导者应该具有查看所有的内容的权限。

3. 销售每天需要写日报，因此销售日报

CREATE TABLE `sales_daily` (  `sd_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',  `sale_id` bigint(20) DEFAULT NULL COMMENT '销售人员ID',  `sd_date` date DEFAULT NULL COMMENT '工作日期',  `task1` decimal(12,2) DEFAULT NULL COMMENT '销售任务',  `task2` int(11) DEFAULT NULL COMMENT '日拜访量',  `sd_street` varchar(256) DEFAULT NULL COMMENT '拜访街道',  `sd_summary` varchar(512) DEFAULT NULL COMMENT '工作总结',  `sd_time` datetime DEFAULT NULL COMMENT '提交时间',  `look_status` int(11) DEFAULT NULL COMMENT '查阅状态(0未读 1已读)',  `look_sale_id` bigint(20) DEFAULT NULL COMMENT '查阅人',  `look_time` datetime DEFAULT NULL COMMENT '查阅时间',  `look_reply` varchar(512) DEFAULT NULL COMMENT '主管回复',  PRIMARY KEY (`sd_id`)) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='销售日报';

说明：主管以及以上的人员都需要进行日报是审批与处理，根据日报反应出来的问题，进行及时的处理。

4. 每天要做什么，怎么做，你需要有一个计划进行。

CREATE TABLE `sales_plan` (  `sp_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID',  `sp_type` tinyint(4) DEFAULT NULL COMMENT '类型(1区域 2销售)',  `sp_fmon` varchar(10) DEFAULT NULL COMMENT '月份',  `sale_id` bigint(20) DEFAULT NULL COMMENT '销售人员ID',  `area_id` bigint(20) DEFAULT NULL COMMENT '区域ID',  `goal_amt` decimal(12,2) DEFAULT NULL COMMENT '销售总目标',  `online_amt` decimal(12,2) DEFAULT NULL COMMENT '线上目标',  `green_amt` decimal(12,2) DEFAULT NULL COMMENT '蔬菜销售',  `register_num` int(11) DEFAULT NULL COMMENT '注册量',  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建人',  `create_time` datetime DEFAULT NULL COMMENT '创建时间',  PRIMARY KEY (`sp_id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='销售计划';

5. 销售过程中，肯定会出现一些其他的特殊情况，这种情况需要销售报备.

CREATE TABLE `sales_reported` (  `sr_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',  `sale_id` bigint(20) DEFAULT NULL COMMENT '销售ID',  `sr_type` tinyint(4) DEFAULT NULL COMMENT '报备类型(1缺填日报 2其他)',  `sr_desc` varchar(512) DEFAULT NULL COMMENT '报备原因',  `sr_time` datetime DEFAULT NULL COMMENT '报备时间',  `look_sale_id` bigint(20) DEFAULT NULL COMMENT '查阅人ID',  `look_status` tinyint(4) DEFAULT NULL COMMENT '查阅状态',  `look_time` datetime DEFAULT NULL COMMENT '查阅时间',  `look_reply` varchar(512) DEFAULT NULL COMMENT '查阅回复',  PRIMARY KEY (`sr_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='销售报备';

6. 对于一个销售人员而言，你每天需要做的事情很多都是陌生拜访，那么拜访，你总应该有个记录吧，无论是否拜访成功

这里是有一个成功率的问题的。不是每个都成功的。

CREATE TABLE `sales_visit` (  `sv_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',  `buyer_id` bigint(20) DEFAULT NULL COMMENT '商家ID',  `sale_id` bigint(20) DEFAULT NULL COMMENT '销售人员ID',  `sv_way` tinyint(4) DEFAULT NULL COMMENT '拜访方式(1预约 2其他)',  `sv_type` tinyint(4) DEFAULT NULL COMMENT '拜访类型(1上门 2电话)',  `sv_logo` varchar(128) DEFAULT NULL COMMENT '门头照',  `sv_address` varchar(256) DEFAULT NULL COMMENT '拜访地址',  `sv_status` tinyint(4) DEFAULT NULL COMMENT '拜访状态(0未 1已)',  `sv_date` date DEFAULT NULL COMMENT '预约日期',  `sv_time` datetime DEFAULT NULL COMMENT '拜访时间',  `sv_remark` varchar(512) DEFAULT NULL COMMENT '拜访感想',  PRIMARY KEY (`sv_id`)) ENGINE=InnoDB AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COMMENT='销售拜访';

7，销售不管有日报还有周报，总结与分析这周的所有问题，成功的也好，失败的也好，需要分享与记录。

CREATE TABLE `sales_weekly` (  `sw_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',  `sale_id` bigint(20) DEFAULT NULL COMMENT '销售ID',  `sw_fmon` varchar(10) DEFAULT NULL COMMENT '月份',  `sw_range` varchar(128) DEFAULT NULL COMMENT '时间范围',  `sw_summary` varchar(1024) DEFAULT NULL COMMENT '本周总结',  `sw_plan` varchar(1024) DEFAULT NULL COMMENT '下周计划',  `need_help` varchar(1024) DEFAULT NULL COMMENT '需求帮助',  `sw_time` datetime DEFAULT NULL COMMENT '填写时间',  `look_status` tinyint(4) DEFAULT NULL COMMENT '查看状态',  `look_sale_id` bigint(20) DEFAULT NULL COMMENT '查看人',  `look_time` datetime DEFAULT NULL COMMENT '查看时间',  `look_reply` varchar(1024) DEFAULT NULL COMMENT '查看回复',  PRIMARY KEY (`sw_id`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='销售周报';

8，最终根据业务的形态构建了系统架构，同时也设计的数据库，最终业务核心代码如下：

日报的核心代码：

/** */@RestController@RequestMapping("/sales")public class DaliyController extends BaseController {    private static final Logger logger = LoggerFactory.getLogger(DaliyController.class);    @Autowired    private DaliyService daliyService;    /**     * 销售人员日报列表     */    @RequestMapping(value = "/getSalesDaliyList", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getSalesDaliyList(HttpServletRequest request, HttpServletResponse response,Long saleId) {        try {            List
     
       biList = daliyService.getSalesDaliyList(saleId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList);        } catch (Exception ex) {            logger.error("[DaliyController][getSalesDaliyList] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 销售人员日报详情     */    @RequestMapping(value = "/getSalesDaliyInfo", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getSalesDaliyInfo(HttpServletRequest request, HttpServletResponse response,Long saleId,String sdDate) {        try {            DaliyVo daliyVo = daliyService.getSalesDaliyInfo(saleId, sdDate);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", daliyVo);        } catch (Exception ex) {            logger.error("[DaliyController][getSalesDaliyInfo] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }    /**     * 添加工作计划     */    @RequestMapping(value = "/insertSalesDaliy", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult insertSalesDaliy(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesDaliy salesDaliy) {        try {            if(salesDaliy == null){                return new JsonResult(JsonResultCode.FAILURE, "参数有误！", "");            }            int result = daliyService.insertSalesDaliy(salesDaliy);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", "");            }        } catch (Exception ex) {            logger.error("[DaliyController][insertSalesDaliy] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 修改工作计划     */    @RequestMapping(value = "/updateSalesDaliy", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult updateSalesDaliy(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesDaliy salesDaliy) {        try {            if(salesDaliy == null){                return new JsonResult(JsonResultCode.FAILURE, "参数有误！", "");            }            if(salesDaliy.getSdId() == null){                return new JsonResult(JsonResultCode.FAILURE, "参数有误！", "");            }            int result = daliyService.updateSalesDaliy(salesDaliy);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "更新信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "更新信息失败", "");            }        } catch (Exception ex) {            logger.error("[DaliyController][updateSalesDaliy] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 今日工作总结     */    @RequestMapping(value = "/updateSalesDaliySummary", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult updateSalesDaliySummary(HttpServletRequest request, HttpServletResponse response,Long saleId,String sdDate,String summary) {        try {            int result = daliyService.updateSalesDaliySummary(saleId, sdDate, summary);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "修改信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "修改信息失败", "");            }        } catch (Exception ex) {            logger.error("[DaliyController][updateSalesDaliySummary] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 添加客户拜访     */    @RequestMapping(value = "/insertSalesVisit", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult insertSalesVisit(HttpServletRequest request, HttpServletResponse response,@RequestBody MultipartFile[] svLogoFile            ,Long saleId,Long buyerId,String svAddress,Short svType,String svRemark) {        try {            if(saleId == null || saleId == 0){                return new JsonResult(JsonResultCode.FAILURE, "参数saleId异常", "");            }            if(buyerId == null || buyerId == 0){                return new JsonResult(JsonResultCode.FAILURE, "参数buyerId异常", "");            }            List
      
        logoList = MultipartFileUtils.getImgPath(request, response, svLogoFile);            SalesVisit salesVisit = new SalesVisit();            salesVisit.setSaleId(saleId);            salesVisit.setBuyerId(buyerId);            if(logoList!=null && logoList.size()>0){                salesVisit.setSvLogo(logoList.get(0));            }            salesVisit.setSvAddress(svAddress);            salesVisit.setSvType(svType);            salesVisit.setSvRemark(svRemark);                        VisitVo vv = daliyService.getVisitInfoById(saleId, buyerId);            if(vv == null){                //直接拜访                salesVisit.setSvWay((short)2);                salesVisit.setSvStatus((short)1);                salesVisit.setSvTime("1");                int result = daliyService.insertSalesVisit(salesVisit);                if(result > 0){                    return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", "");                }else{                    return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", "");                }            }else{                //预约拜访                if(vv.getSvStatus()==0){                    salesVisit.setSvId(vv.getSvId());                    daliyService.updateSalesVisit(salesVisit);                    return new JsonResult(JsonResultCode.SUCCESS, "更新信息成功", "");                }else{                    return new JsonResult(JsonResultCode.FAILURE, "该商家您今天已经拜访过了！", "");                }            }        } catch (Exception ex) {            logger.error("[DaliyController][insertSalesVisit] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 销售人员拜访记录列表     */    @RequestMapping(value = "/getSalesVisitList", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getSalesVisitList(HttpServletRequest request, HttpServletResponse response,Long saleId,Short svType) {        try {            List
       
         biList = daliyService.getSalesVisitList(saleId,svType);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList);        } catch (Exception ex) {            logger.error("[DaliyController][getSalesVisitList] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 销售人员拜访记录详情     */    @RequestMapping(value = "/getSalesVisitInfo", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getSalesVisitInfo(HttpServletRequest request, HttpServletResponse response,Long svId) {        try {            VisitVo visitVo = daliyService.getSalesVisitInfo(svId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", visitVo);        } catch (Exception ex) {            logger.error("[DaliyController][getSalesDaliyInfo] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 主管查看     */    @RequestMapping(value = "/updateLookStatus", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult updateDaliyLookStatus(HttpServletRequest request, HttpServletResponse response,Long saleId,Long sdId,String reply) {        try {            int result = daliyService.updateDaliyLookStatus(saleId, sdId,reply);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "修改信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "修改信息失败", "");            }        } catch (Exception ex) {            logger.error("[DaliyController][updateLookStatus] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 添加工作报备     */    @RequestMapping(value = "/insertSalesReported", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult insertSalesReported(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesReported salesReported) {        try {            int result = daliyService.insertSalesReported(salesReported);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", "");            }        } catch (Exception ex) {            logger.error("[DaliyController][insertSalesReported] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 报备主管查看     */    @RequestMapping(value = "/updateReportedLookStatus", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult updateReportedLookStatus(HttpServletRequest request, HttpServletResponse response,Long saleId,Long srId,String reply) {        try {            int result = daliyService.updateReportedLookStatus(saleId, srId, reply);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "修改信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "修改信息失败", "");            }        } catch (Exception ex) {            logger.error("[DaliyController][updateReportedLookStatus] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 销售人员报备记录列表     */    @RequestMapping(value = "/getSalesReportedList", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getSalesReportedList(HttpServletRequest request, HttpServletResponse response,Long saleId) {        try {            List
        
          biList = daliyService.getSalesReportedList(saleId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList);        } catch (Exception ex) {            logger.error("[DaliyController][getSalesReportedList] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 管理人员查看销售人员报备记录列表     */    @RequestMapping(value = "/getMargeReportedList", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getMargeReportedList(HttpServletRequest request, HttpServletResponse response,Long saleId) {        try {            List
         
           biList = daliyService.getMargeReportedList(saleId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList);        } catch (Exception ex) {            logger.error("[DaliyController][getMargeReportedList] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }}

周报的核心代码：

/** * 销售周报信息 */@RestController@RequestMapping("/sales")public class WeeklyController extends BaseController {    private static final Logger logger = LoggerFactory.getLogger(WeeklyController.class);    @Autowired    private SalesWeeklyService salesWeeklyService;    /**     * 销售人员周报列表     */    @RequestMapping(value = "/getWeeklyList", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getWeeklyList(HttpServletRequest request, HttpServletResponse response,Long saleId) {        try {            List
     
       biList = salesWeeklyService.getWeeklyList(saleId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList);        } catch (Exception ex) {            logger.error("[WeeklyController][getWeeklyList] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 管理员查看周报列表     */    @RequestMapping(value = "/getMargerWeeklyList", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getMargerWeeklyList(HttpServletRequest request, HttpServletResponse response,Long saleId) {        try {            List
      
        biList = salesWeeklyService.getMargerWeeklyList(saleId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", biList);        } catch (Exception ex) {            logger.error("[WeeklyController][getMargerWeeklyList] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 销售人员周报详情     */    @RequestMapping(value = "/getWeeklyVo", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult getWeeklyVo(HttpServletRequest request, HttpServletResponse response,Long swId) {        try {            WeeklyVo weeklyVo = salesWeeklyService.getWeeklyVo(swId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", weeklyVo);        } catch (Exception ex) {            logger.error("[WeeklyController][getWeeklyVo] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 销售人员填写周报时调用     */    @RequestMapping(value = "/findWeeklyVo", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult findWeeklyVo(HttpServletRequest request, HttpServletResponse response,Long saleId) {        try {            WeeklyVo weeklyVo = salesWeeklyService.findWeeklyVo(saleId);            return new JsonResult(JsonResultCode.SUCCESS, "查询信息成功", weeklyVo);        } catch (Exception ex) {            logger.error("[WeeklyController][findWeeklyVo] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }    /**     * 添加销售周报     */    @RequestMapping(value = "/insertSalesWeekly", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult insertSalesWeekly(HttpServletRequest request, HttpServletResponse response,@RequestBody SalesWeekly salesWeekly) {        try {            if(salesWeekly == null){                return new JsonResult(JsonResultCode.FAILURE, "参数有误！", "");            }            int result = salesWeeklyService.insertSalesWeekly(salesWeekly);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "添加信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "添加信息失败", "");            }        } catch (Exception ex) {            logger.error("[WeeklyController][insertSalesWeekly] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }        /**     * 管理员评价     */    @RequestMapping(value = "/updateWeeklyLookStatus", method = { RequestMethod.GET, RequestMethod.POST })    public JsonResult updateWeeklyLookStatus(HttpServletRequest request, HttpServletResponse response,Long saleId,String reply,Long swId) {        try {            int result = salesWeeklyService.updateWeeklyLookStatus(saleId, reply, swId);            if(result > 0){                return new JsonResult(JsonResultCode.SUCCESS, "更新信息成功", "");            }else{                return new JsonResult(JsonResultCode.FAILURE, "跟新信息失败", "");            }        } catch (Exception ex) {            logger.error("[WeeklyController][updateWeeklyLookStatus] exception :", ex);            return new JsonResult(JsonResultCode.FAILURE, "系统错误,请稍后重试", "");        }    }}

转载自-- https://www.cnblogs.com/jurendage/p/9131557.html

转载于:https://www.cnblogs.com/lu-manman/p/10052395.html

你可能感兴趣的文章

atitit.短信验证码破解 v3 p34 识别绕过系统方案规划----业务相关方案手机验证码 .doc...