mini_auth_record 授权记录表
mini_certify_record 身份验证流水记录表
mini_consume_record 小程序消费记录
mini_employment_risk 小程序用工风险查询报告
mini_employment_risk_aj 小程序用工风险查询案件详情报告
mini_ent_certify_record 企业认证流水记录表
mini_ent_info 企业信息表
mini_member_ent_rel 会员企业关联表
mini_member_info 会员信息表
mini_member_limit 会员额度信息表
mini_member_limit_change 会员额度变更流水表
mini_notice_record 消息通知记录表
mini_order_info 订单基本信息表
mini_order_package_rel 订单套餐信息表
mini_package_info 套餐基本信息表
mini_product_info 产品信息表
mini_product_package_rel 套餐产品信息表
mini_protocol_config 小程序协议配置表
mini_qrcode_info 二维码信息表
------------------------------------------------------------------------
SELECT
o.order_no as '订单编号',
o.pay_amount as '实际支付金额',
o.total_amount as '订单总金额',
o.pay_type as '付款方式',
o.member_id as '会员id',
o.create_time as '下单时间',
o.pay_success_time as '支付成功时间',
p.effective_time as '套餐有效期',
r.package_no as '套餐编号',
p.package_name as '套餐名称'
FROM `mini_order_info` o
LEFT JOIN mini_order_package_rel r
on o.order_no = r.order_no
LEFT JOIN mini_package_info p
on r.package_no = p.package_no
where o.member_id in ('M202205071050412741')
and o.pay_amount in ('0.02')
and o.order_no in ('O202205230422505507')
------------------------------------------------------------------------
SELECT
o.order_no as '订单编号',
o.pay_amount as '实际支付金额',
o.pay_type as '付款方式',
o.member_id as '会员id',
o.create_time as '下单时间',
o.pay_success_time as '支付成功时间',
p.package_name as '套餐名称'
FROM `mini_order_info` o
LEFT JOIN mini_order_package_rel r
on o.order_no = r.order_no
LEFT JOIN mini_package_info p
on r.package_no = p.package_no
where
o.order_no in ('O202205230422505507')
------------------------------------------------------------------------
select * from mini_consume_record mi
where mi.member_id LIKE "%M202205071050412741%"
and mi.query_condition_name LIKE "%金星%"
and mi.consume_time LIKE "%2022-05-12 15:02:35%"
M202205071050412741 member_id
0.02 pay_amount
O202205110215190687 order_on
p.package_name as '套餐名称'
问题1
1.
李秀提出的测试场景:
报告截至日期,是自然时间24点,还是固定时间。--临界点页面怎么跳。
柏罡答复:已24点有效期截至时间点。
金星对应测试结果如下:30天当日24点过后显示 【报告已过期】,当日24点前不过期可以继续查看报告。
--OK没问题
--同步测试用例。???
--同步测试安卓手机???
------------------------------20220530 星期一,今天上线定制信息功能模块,对于表如下。
CREATE TABLE `mini_user_demand` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '业务主键',
`member_id` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`user_name` varchar(10) COLLATE utf8_bin NOT NULL COMMENT '用户姓名',
`phone_no` varchar(11) COLLATE utf8_bin NOT NULL COMMENT '用户手机号',
`ep_name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '企业名称',
`demand_detail` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '需求描述',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='定制需求信息表';