微信点餐系统-买家订单

实体类-订单表

@Entity
@Data
@DynamicUpdate
public class OrderMaster {
    
    @Id
    private String orderId;
    
    private String buyerName;
    
    private String buyerPhone;
    
    private String buyerAddress;
    
    private String buyerOpenid;
    
    private BigDecimal orderAmount;
    
    private Integer orderStatus = OrderStatusEnum.NEW.getCode();
    
    private Integer payStatus = OrderStatusEnum.NEW.getCode();
    
//    private Date createTime;
    
//    private Date updateTime;
}

订单详情表：

@Entity
@Data
public class OrderDetail {
    @Id
    
    private String detailId;
    
    private String orderId;
    
    private String productId;
    
    private String productName;
    
    private BigDecimal productPrice;
    
    private Integer productQuantity;
    
    private String productIcon;
    
//    private Date createTime;
    
//    private Date updateTime;
}

dao层：

public interface OrderMasterRepository extends JpaRepository {
    Page findByBuyerOpenid(String buyerOpenid, Pageable pageable);
}

public interface OrderDetailRepository extends JpaRepository {
    List findByOrderId(String orderId, Pageable pageable);
}

测试类：

@RunWith(SpringRunner.class)
@SpringBootTest
public class OrderMasterRepositoryTest extends TestCase {
    @Autowired
    private OrderMasterRepository repository;
    private final String OPENID = "10010";
    @Test
    public void saveTest(){
        OrderMaster orderMaster = new OrderMaster();
        orderMaster.setOrderId("123457");
        orderMaster.setBuyerName("张三的订单");
        orderMaster.setBuyerPhone("13754677890");
        orderMaster.setBuyerAddress("仙桃池");
        orderMaster.setBuyerOpenid(OPENID);
        orderMaster.setOrderAmount(new BigDecimal(8.8));
        OrderMaster result = repository.save(orderMaster);
        Assert.assertNotNull(result);
    }
    @Test
    public void testFindByBuyerOpenid() {
        PageRequest request = PageRequest.of(1,3);
        Page result = repository.findByBuyerOpenid(OPENID, request);
        System.out.println(result.getTotalElements());
        Assert.assertNotNull(String.valueOf(0),result.getTotalElements());
    }
}

@RunWith(SpringRunner.class)
@SpringBootTest
public class OrderDetailRepositoryTest extends TestCase {
    @Autowired
    private OrderDetailRepository repository;
    private final String ORDERID="11111111";

    @Test
    public void saveTest(){
        OrderDetail orderDetail = new OrderDetail();
        orderDetail.setDetailId("12348");
        orderDetail.setOrderId(ORDERID);
        orderDetail.setProductIcon("http://xigua.jpg");
        orderDetail.setProductId("1212121");
        orderDetail.setProductName("西瓜粥");
        orderDetail.setProductPrice(new BigDecimal(3.2));
        orderDetail.setProductQuantity(2);
        OrderDetail result = repository.save(orderDetail);
        Assert.assertNotNull(result);
    }
    @Test
    public void testFindByOrderId() {
        PageRequest request = PageRequest.of(0, 3);
        List result = repository.findByOrderId(ORDERID, request);
        Assert.assertNotNull(String.valueOf(0),result.size());
    }
}