山东大学软件学院项目实训——超市/供应商直销平台day3

周总结

工作总结

项目实训的第一周，进行的内容相对较少，完成了项目的搭建，包括后端和前端的熟悉与搭建，建立了初步的登录页面，结算页面，并实现了相关功能；对数据库的设计进行初步设计，涉及了多个相关数据表并提前加入了部分数据集。

个人工作记录

完成了结算模块的商品查询，相关代码如下：
@RequestMapping(value = {"/Super/AddSingleToCart"}, method = {RequestMethod.POST})//线下查找单个商品结算，添加单个商品
public Map Super_FindSingleGoods(@RequestBody Object obj, HttpServletRequest request){
//前端传到后端商品id super_goods_id,后端查询返回前端查询结果
Map para = (Map)obj;
HttpSession session = request.getSession();
String id = (String)para.get(“goods_id”);//13位
String superid=(String)para.get(“super_id”);
String goodsnumid = id;//商品号
String goodsid = id.substring(0,7);//组id
List List_superGoodsNum = this.superGoodsNumDao.findgoodsbynumid(goodsnumid,superid);
SuperGoodsNum goodsNum = null;
Map data = new HashMap();
if(List_superGoodsNum!=null&&List_superGoodsNum.size()!=0){
goodsNum = List_superGoodsNum.get(0);
data.put(“super_goods_num_id”, goodsnumid);
data.put(“super_goods_price”, goodsNum.getSuper_goods_price());
data.put(“super_goods_name”,goodsNum.getSuper_goods_name());
//data.put(“sessionId”, session.getId());
}else{
//data.put(“ifsuccess”,false);
}
return data;
}
完成了结算模块的订单生成功能，主要是前端将商品清单提交给后端，后端生成相关订单信息并更新商品数量，相关代码如下：
@RequestMapping(value={"/Super/Check"},method = {RequestMethod.POST})//根据前端获取的生成订单
public Map Super_CheckOut(@RequestBody Object obj,HttpServletRequest request){
Map para = (Map)obj;//传递super_id和商品数组
Map data =new HashMap();
String superid =(String)para.get(“superid”);
Double superorderprice = (Double) para.get(“sum_price”);
SuperOrderAck superOrderAck = new SuperOrderAck();
//SimpleDateFormat df = new SimpleDateFormat(“yyyyMMddHHmmss”);//设置日期格式
//String superorderid = df.format(new Date());// new Date()为获取当前系统时间，也可使用当前时间戳
//superOrderAck.setSuper_order_id(superorderid);
superOrderAck.setSuper_id(superid);
superOrderAck.setSuper_order_price(superorderprice);
superOrderAckDao.save(superOrderAck);//生成订单

// String sql = “select max(super_order_id) from super_order_ack1”;
// int superorderid = jdbcTemplate.queryForObject(String.format(“SELECT MAX(super_order_id) FROM super_order_ack1”), int.class);

    //生成订单商品
    List<Map> goodslist=(List<Map>)para.get("goodslist");
    for(int i=0;i<goodslist.size();i++){
        String goodsnumid = ((String)goodslist.get(i).get("goods_num_id")).substring(7,14);//商品id
        String goodsid = ((String)goodslist.get(i).get("goods_num_id")).substring(0,7);
        int goodsstate = (int)goodslist.get(i).get("goods_state");//商品数量
        //获取该商品的数量，并更新数量
        SuperGoodsNum superGoodsNum = this.superGoodsNumDao.findgoodsbyid(goodsid,goodsnumid,superid).get(0);
        int state= superGoodsNum.getSuper_goods_state()-goodsstate;
        superGoodsNum.setSuper_goods_state(state);
        this.superGoodsNumDao.save(superGoodsNum);

        //增加订单的商品
        SuperOrderGoodsAck superOrderGoodsAck = new SuperOrderGoodsAck();
        superOrderGoodsAck.setSuper_goods_id((String)goodslist.get(i).get("goods_num_id"));
        superOrderGoodsAck.setSuper_goods_discount_id(superGoodsNum.getSuper_discount_id());
        superOrderGoodsAck.setSuper_goods_name(superGoodsNum.getSuper_goods_name());
        superOrderGoodsAck.setSuper_goods_num(goodsstate);
        superOrderGoodsAck.setSuper_goods_price(superGoodsNum.getSuper_goods_price());
       // superOrderGoodsAck.setSuper_order_id(superorderid);
        superOrderGoodsAckDao.save(superOrderGoodsAck);
    }
    data.put("ifsuccess",true);//结算成功
    return data;
}

第一周进度相对较慢，在不断校正需求的同时不断优化功能实现和数据库表结构，不过第一周已经基本完成，而且在熟悉框架后进度将加快，同时此次实训项目也是一次提升能力的好机会，相信这次实训会带给没给人不一样的收获。