You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
99 lines
58 KiB
SQL
99 lines
58 KiB
SQL
create table user_orders
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
user bigint not null,
|
|
hospital bigint not null,
|
|
name varchar(50) not null,
|
|
id_number varchar(50) not null,
|
|
phone varchar(30) not null,
|
|
birthday date not null,
|
|
sex tinyint not null comment '1-男 2-女',
|
|
marriage tinyint not null comment '1-是 2-否',
|
|
buy_info text not null,
|
|
type tinyint not null comment '1-个检 2-团检',
|
|
combo varchar(50) not null,
|
|
price decimal(9, 2) not null,
|
|
true_price decimal(9, 2) not null,
|
|
group_price decimal(9, 2) not null,
|
|
pay_type tinyint default 0 not null comment '0-未指定 1-微信 2-会员卡 3-免费',
|
|
transaction varchar(50) null,
|
|
status tinyint not null comment '1-待支付 2-已支付 3-已取消 4-已完成 5-已退款',
|
|
pay_time datetime null,
|
|
refund bigint default 0 not null,
|
|
refund_time datetime null,
|
|
appointment bigint not null,
|
|
appointment_time datetime not null,
|
|
`show` varchar(50) not null,
|
|
appointment_number varchar(50) null,
|
|
appointment_info longtext null,
|
|
exam_number varchar(50) null,
|
|
check_status tinyint default 1 not null comment '1-待检查 2-已检查',
|
|
check_time datetime null,
|
|
referral varchar(50) default '' null,
|
|
created_at timestamp null,
|
|
updated_at timestamp null
|
|
)
|
|
collate = utf8mb4_unicode_ci;
|
|
|
|
create index user_orders_appointment_index
|
|
on user_orders (appointment);
|
|
|
|
create index user_orders_combo_index
|
|
on user_orders (combo);
|
|
|
|
create index user_orders_hospital_index
|
|
on user_orders (hospital);
|
|
|
|
create index user_orders_id_number_index
|
|
on user_orders (id_number);
|
|
|
|
create index user_orders_name_index
|
|
on user_orders (name);
|
|
|
|
create index user_orders_phone_index
|
|
on user_orders (phone);
|
|
|
|
create index user_orders_show_index
|
|
on user_orders (`show`);
|
|
|
|
create index user_orders_user_index
|
|
on user_orders (user);
|
|
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (1, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"},{"id":"3393","name":"视力、血压","price":"0.00"},{"id":"3425","name":"血脂八项","price":"124.20"},{"id":"3426","name":"冠状病毒核酸检测(本院)免费","price":"60.00"},{"id":"3427","name":"冠状病毒核酸检测(本院)自费","price":"60.00"}],"group":{"id":""}}', 1, '1943', 341.06, 0.01, 0.00, 0, null, 3, null, 0, null, 267, '2023-05-31 08:00:00', '23053000000001', null, null, null, 1, null, '', '2023-05-30 10:28:56', '2023-05-30 10:28:56');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (2, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 0, null, 3, null, 0, null, 267, '2023-05-31 08:00:00', '23053000000002', null, null, null, 1, null, '', '2023-05-30 11:09:38', '2023-05-30 11:09:38');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (3, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 0, null, 3, null, 0, null, 273, '2023-05-30 14:00:00', '23053000000003', null, null, null, 1, null, '', '2023-05-30 11:09:52', '2023-05-30 11:09:52');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (4, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 0, null, 3, null, 0, null, 273, '2023-05-30 14:00:00', '23053000000004', null, null, null, 1, null, '', '2023-05-30 11:15:12', '2023-05-30 11:15:12');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (5, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 0, null, 3, null, 0, null, 273, '2023-05-30 14:00:00', '23053000000005', null, null, null, 1, null, '', '2023-05-30 11:15:14', '2023-05-30 11:15:14');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (6, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 0, null, 3, null, 0, null, 273, '2023-05-30 14:00:00', '23053000000006', null, null, null, 1, null, '', '2023-05-30 11:15:16', '2023-05-30 11:15:16');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (7, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"},{"id":"3393","name":"视力、血压","price":"0.00"},{"id":"3425","name":"血脂八项","price":"124.20"},{"id":"3426","name":"冠状病毒核酸检测(本院)免费","price":"60.00"},{"id":"3427","name":"冠状病毒核酸检测(本院)自费","price":"60.00"}],"group":{"id":""}}', 1, '1943', 341.06, 0.01, 0.00, 0, null, 3, null, 0, null, 267, '2023-05-31 08:00:00', '23053000000007', null, null, null, 1, null, '', '2023-05-30 13:23:57', '2023-05-30 13:23:57');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (8, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"},{"id":"3393","name":"视力、血压","price":"0.00"},{"id":"3425","name":"血脂八项","price":"124.20"},{"id":"3426","name":"冠状病毒核酸检测(本院)免费","price":"60.00"},{"id":"3427","name":"冠状病毒核酸检测(本院)自费","price":"60.00"}],"group":{"id":""}}', 1, '1943', 341.06, 0.01, 0.00, 0, null, 3, null, 0, null, 267, '2023-05-31 08:00:00', '23053000000008', null, null, null, 1, null, '', '2023-05-30 13:42:46', '2023-05-30 13:42:46');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (9, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, null, 3, null, 0, null, 278, '2023-05-31 18:00:00', '23053000000009', null, null, null, 1, null, '', '2023-05-30 14:12:51', '2023-05-30 14:12:59');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (10, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"},{"id":"3393","name":"视力、血压","price":"0.00"},{"id":"3425","name":"血脂八项","price":"124.20"},{"id":"3426","name":"冠状病毒核酸检测(本院)免费","price":"60.00"},{"id":"3427","name":"冠状病毒核酸检测(本院)自费","price":"60.00"}],"group":{"id":""}}', 1, '1943', 341.06, 0.01, 0.00, 1, null, 3, null, 0, null, 267, '2023-05-31 08:00:00', '23053000000010', null, null, null, 1, null, '陆予思思', '2023-05-30 14:42:45', '2023-05-30 14:42:47');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (11, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[{"id":"3393","name":"视力、血压","price":"0.00"},{"id":"3398","name":"驾驶证体检","price":"0.00"},{"id":"3436","name":"中医体质辨识","price":"52.00"}],"group":{"id":""}}', 1, '1958', 78.00, 0.01, 0.00, 1, '4200001881202305300809090763', 5, '2023-05-30 14:55:31', 0, '2023-05-30 17:00:17', 279, '2023-06-01 08:00:00', '23053000000011', '35a65e1f-e2ac-4d7b-9251-6b10c5472c41', '{"项目列表":[{"Id":"3393","名称":"视力、血压","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3398","名称":"驾驶证体检","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3414","名称":"无抗凝采血管","价格":"1.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3422","名称":"动脉采血","价格":"25.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3436","名称":"中医体质辨识","价格":"52.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3497","名称":"男性测试项目","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3498","名称":"男性测试项目2","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"35a65e1f-e2ac-4d7b-9251-6b10c5472c41","姓名":"陆予三三","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-01","预约结束日期":"2023-06-02","套餐名称":"男性限定测试套餐","当前状态":"未支付","总计金额":"78.00","预约来源":"微信个人预约","到达日期":"2023-06-01","已收费":true}', null, 1, null, null, '2023-05-30 14:55:12', '2023-05-30 17:00:17');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (12, 1, 1, '陆予九', '130322199409060012', '15232310906', '1994-09-06', 1, 2, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, '4200001853202305309462597922', 5, '2023-05-30 16:02:41', 0, '2023-05-30 16:43:51', 280, '2023-06-02 08:00:00', '23053000000012', '42c22d8d-aa1e-4443-a943-e2e38883cae9', '{"项目列表":[{"Id":"3414","名称":"无抗凝采血管","价格":"1.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3422","名称":"动脉采血","价格":"25.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3497","名称":"男性测试项目","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3498","名称":"男性测试项目2","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"42c22d8d-aa1e-4443-a943-e2e38883cae9","姓名":"陆予九","婚姻状态":"未婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-02","预约结束日期":"2023-06-03","套餐名称":"男性限定测试套餐","当前状态":"未支付","总计金额":"26.00","预约来源":"微信个人预约","到达日期":"2023-06-02","已收费":true}', null, 1, null, 'AAAAA', '2023-05-30 16:02:22', '2023-05-30 16:43:51');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (13, 1, 1, '陆予十', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, '4200001870202305304767033509', 5, '2023-05-30 16:05:00', 0, '2023-05-30 16:42:53', 281, '2023-06-05 08:00:00', '23053000000013', '01edd317-3776-49ae-805f-c01c14aa52b9', '{"项目列表":[{"Id":"3414","名称":"无抗凝采血管","价格":"1.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3422","名称":"动脉采血","价格":"25.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3497","名称":"男性测试项目","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3498","名称":"男性测试项目2","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"01edd317-3776-49ae-805f-c01c14aa52b9","姓名":"陆予十","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-05","预约结束日期":"2023-06-06","套餐名称":"男性限定测试套餐","当前状态":"未支付","总计金额":"26.00","预约来源":"微信个人预约","到达日期":"2023-06-05","已收费":true}', null, 1, null, null, '2023-05-30 16:04:43', '2023-05-30 16:42:53');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (14, 1, 1, '陆予八', '130322199409060012', '15232310906', '1994-09-06', 1, 2, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, '4200001869202305309840726002', 4, '2023-05-30 17:06:45', 0, null, 282, '2023-06-06 08:00:00', '23053000000014', 'e8bdbc3c-9fb6-4143-a627-7be2142a9d20', '{"项目列表":[{"Id":"3414","名称":"无抗凝采血管","价格":"1.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3422","名称":"动脉采血","价格":"25.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3497","名称":"男性测试项目","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3498","名称":"男性测试项目2","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"e8bdbc3c-9fb6-4143-a627-7be2142a9d20","姓名":"陆予八","婚姻状态":"未婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-06","预约结束日期":"2023-06-07","套餐名称":"男性限定测试套餐","当前状态":"未支付","总计金额":"26.00","预约来源":"微信个人预约","到达日期":"2023-06-06","已收费":true}', 'AAAAAAA', 2, '2023-05-30 17:07:37', null, '2023-05-30 17:06:25', '2023-05-30 17:06:46');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (15, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, null, 3, null, 0, null, 283, '2023-06-07 08:00:00', '23053000000015', null, null, null, 1, null, null, '2023-05-30 17:21:02', '2023-05-30 17:21:03');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (16, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[],"group":{"id":""}}', 1, '1943', 4.26, 0.01, 0.00, 1, '4200001863202305305655791592', 5, '2023-05-30 17:25:25', 0, '2023-05-30 17:32:55', 284, '2023-06-08 08:00:00', '23053000000016', '049673e2-ec9a-4c02-ae0d-c29bd6bc88ad', '{"项目列表":[{"Id":"2627","名称":"常规检查","价格":"15.5000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2759","名称":"彩超(肝、胆、脾、肾、膀胱、输尿管、女子宫、附件)","价格":"352.9900","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":"19.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"3261","名称":"尿常规+镜检","价格":"12.6000","优惠方式":"打折","优惠值":"0.0100","自选项目":false}],"预约Id":"049673e2-ec9a-4c02-ae0d-c29bd6bc88ad","姓名":"陆予三三","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-08","预约结束日期":"2023-06-09","套餐名称":"健康体检套餐","当前状态":"未支付","总计金额":"4.26","预约来源":"微信个人预约","到达日期":"2023-06-08","已收费":true}', null, 1, null, null, '2023-05-30 17:25:03', '2023-05-30 17:32:55');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (17, 1, 1, '陆予十', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[],"group":{"id":""}}', 1, '1943', 4.26, 0.01, 0.00, 1, '4200001863202305304225474765', 5, '2023-05-30 17:33:38', 0, '2023-05-30 17:33:56', 284, '2023-06-08 08:00:00', '23053000000017', 'deb2d9fa-fa12-4008-9cdc-8f595809d48d', '{"项目列表":[{"Id":"2627","名称":"常规检查","价格":"15.5000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2759","名称":"彩超(肝、胆、脾、肾、膀胱、输尿管、女子宫、附件)","价格":"352.9900","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":"19.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"3261","名称":"尿常规+镜检","价格":"12.6000","优惠方式":"打折","优惠值":"0.0100","自选项目":false}],"预约Id":"deb2d9fa-fa12-4008-9cdc-8f595809d48d","姓名":"陆予十","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-08","预约结束日期":"2023-06-09","套餐名称":"健康体检套餐","当前状态":"未支付","总计金额":"4.26","预约来源":"微信个人预约","到达日期":"2023-06-08","已收费":true}', null, 1, null, null, '2023-05-30 17:33:18', '2023-05-30 17:33:56');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (18, 1, 1, '陆予十', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[],"group":{"id":""}}', 1, '1943', 4.26, 0.01, 0.00, 1, '4200001863202305309332322462', 5, '2023-05-30 17:40:33', 0, '2023-05-30 17:40:48', 284, '2023-06-08 08:00:00', '23053000000018', '0defebb8-0bd0-461f-8c90-43248449f643', '{"项目列表":[{"Id":"2627","名称":"常规检查","价格":"15.5000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2759","名称":"彩超(肝、胆、脾、肾、膀胱、输尿管、女子宫、附件)","价格":"352.9900","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":"19.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"3261","名称":"尿常规+镜检","价格":"12.6000","优惠方式":"打折","优惠值":"0.0100","自选项目":false}],"预约Id":"0defebb8-0bd0-461f-8c90-43248449f643","姓名":"陆予十","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-08","预约结束日期":"2023-06-09","套餐名称":"健康体检套餐","当前状态":"未支付","总计金额":"4.26","预约来源":"微信个人预约","到达日期":"2023-06-08","已收费":true}', null, 1, null, 'AAAA', '2023-05-30 17:36:14', '2023-05-30 17:40:48');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (19, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '2023-05-30', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"}],"group":{"id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","combo_name":"测试120","combo_id":"C1109","group_name":"百年人寿客户全部","items":[{"id":"2748","name":"盆底彩超"},{"id":"2820","name":"血常规18项"},{"id":"2821","name":"血细胞分析22项"},{"id":"2851","name":"空腹血糖"},{"id":"3012","name":"甲功三项"},{"id":"3489","name":"测试材料费1"},{"id":"3490","name":"测试材料费2"}],"appointment_number":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4"}}', 2, '0', 55.80, 0.01, 0.00, 1, null, 3, null, 0, null, 288, '2023-06-14 08:00:00', '23053000000019', 'd9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4', null, null, 1, null, null, '2023-05-30 18:50:46', '2023-05-30 18:50:47');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (20, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"}],"group":{"id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","combo_name":"测试120","combo_id":"C1109","group_name":"百年人寿客户全部","items":[{"id":"2748","name":"盆底彩超"},{"id":"2820","name":"血常规18项"},{"id":"2821","name":"血细胞分析22项"},{"id":"2851","name":"空腹血糖"},{"id":"3012","name":"甲功三项"},{"id":"3489","name":"测试材料费1"},{"id":"3490","name":"测试材料费2"}],"appointment_number":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4"}}', 2, '0', 92.60, 0.01, 0.00, 1, '4200001854202306017391028977', 2, '2023-06-01 16:37:45', 0, null, 288, '2023-06-14 08:00:00', '23060100000020', 'd9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4', '{"单位名称":"百年人寿客户","批次名称":"2022","部门名称":"全部","分组名称":"登记","项目列表":[{"Id":"2748","名称":"盆底彩超","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2851","名称":"空腹血糖","价格":null,"优惠方式":"打折","优惠值":"0.1491","自选项目":false},{"Id":"3012","名称":"甲功三项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"3406","名称":"口腔全景CR片","价格":"55.8000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3408","名称":"口腔全景CR片(无片)","价格":"36.8000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3489","名称":"测试材料费1","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3490","名称":"测试材料费2","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","姓名":"团检预约测试","婚姻状态":"其他","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-05-27","预约结束日期":"2023-07-01","套餐名称":"测试120","当前状态":"未支付","总计金额":"417.60","预约来源":"微信团检预约","到达日期":"2023-06-14","已收费":false}', null, 1, null, null, '2023-06-01 16:13:49', '2023-06-01 16:37:46');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (21, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[],"group":{"id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","combo_name":"测试120","combo_id":"C1109","group_name":"百年人寿客户全部","items":[{"id":"2748","name":"盆底彩超"},{"id":"2820","name":"血常规18项"},{"id":"2821","name":"血细胞分析22项"},{"id":"2851","name":"空腹血糖"},{"id":"3012","name":"甲功三项"},{"id":"3489","name":"测试材料费1"},{"id":"3490","name":"测试材料费2"}],"appointment_number":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4"}}', 2, '0', 0.00, 0.00, 0.00, 0, null, 3, null, 0, null, 288, '2023-06-14 08:00:00', '23060100000021', 'd9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4', null, null, 1, null, null, '2023-06-01 16:29:39', '2023-06-01 16:29:39');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (22, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[],"group":{"id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","combo_name":"测试120","combo_id":"C1109","group_name":"百年人寿客户全部","items":[{"id":"2748","name":"盆底彩超"},{"id":"2820","name":"血常规18项"},{"id":"2821","name":"血细胞分析22项"},{"id":"2851","name":"空腹血糖"},{"id":"3012","name":"甲功三项"},{"id":"3489","name":"测试材料费1"},{"id":"3490","name":"测试材料费2"}],"appointment_number":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4"}}', 2, '0', 0.00, 0.00, 0.00, 3, '', 5, '2023-06-01 16:39:30', 0, '2023-06-01 16:40:22', 288, '2023-06-14 08:00:00', '23060100000022', 'd9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4', '{"单位名称":"百年人寿客户","批次名称":"2022","部门名称":"全部","分组名称":"登记","项目列表":[{"Id":"2748","名称":"盆底彩超","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2851","名称":"空腹血糖","价格":null,"优惠方式":"打折","优惠值":"0.1491","自选项目":false},{"Id":"3012","名称":"甲功三项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"3489","名称":"测试材料费1","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3490","名称":"测试材料费2","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","姓名":"团检预约测试","婚姻状态":"其他","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-05-27","预约结束日期":"2023-07-01","套餐名称":"测试120","当前状态":"未支付","总计金额":"325.00","预约来源":"微信团检预约","到达日期":"2023-06-14","已收费":false}', null, 1, null, null, '2023-06-01 16:32:40', '2023-06-01 16:40:22');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (23, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[],"group":{"id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","combo_name":"测试120","combo_id":"C1109","group_name":"百年人寿客户全部","items":[{"id":"2748","name":"盆底彩超"},{"id":"2820","name":"血常规18项"},{"id":"2821","name":"血细胞分析22项"},{"id":"2851","name":"空腹血糖"},{"id":"3012","name":"甲功三项"},{"id":"3489","name":"测试材料费1"},{"id":"3490","name":"测试材料费2"}],"appointment_number":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4"}}', 2, '0', 0.00, 0.00, 0.00, 3, '', 5, '2023-06-01 16:46:04', 0, '2023-06-01 16:46:14', 288, '2023-06-14 08:00:00', '23060100000023', 'd9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4', '{"单位名称":"百年人寿客户","批次名称":"2022","部门名称":"全部","分组名称":"登记","项目列表":[{"Id":"2748","名称":"盆底彩超","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2851","名称":"空腹血糖","价格":null,"优惠方式":"打折","优惠值":"0.1491","自选项目":false},{"Id":"3012","名称":"甲功三项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"3489","名称":"测试材料费1","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3490","名称":"测试材料费2","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","姓名":"团检预约测试","婚姻状态":"其他","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-05-27","预约结束日期":"2023-07-01","套餐名称":"测试120","当前状态":"未支付","总计金额":"325.00","预约来源":"微信团检预约","到达日期":"2023-06-14","已收费":false}', null, 1, null, null, '2023-06-01 16:34:11', '2023-06-01 16:46:14');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (24, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"}],"group":{"id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","combo_name":"测试120","combo_id":"C1109","group_name":"百年人寿客户全部","items":[{"id":"2748","name":"盆底彩超"},{"id":"2820","name":"血常规18项"},{"id":"2821","name":"血细胞分析22项"},{"id":"2851","name":"空腹血糖"},{"id":"3012","name":"甲功三项"},{"id":"3489","name":"测试材料费1"},{"id":"3490","name":"测试材料费2"}],"appointment_number":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4"}}', 2, '0', 92.60, 0.01, 0.00, 1, '4200001875202306016475448464', 5, '2023-06-01 16:47:59', 0, '2023-06-01 16:48:40', 289, '2023-06-15 08:00:00', '23060100000024', 'd9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4', '{"单位名称":"百年人寿客户","批次名称":"2022","部门名称":"全部","分组名称":"登记","项目列表":[{"Id":"2748","名称":"盆底彩超","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"2851","名称":"空腹血糖","价格":null,"优惠方式":"打折","优惠值":"0.1491","自选项目":false},{"Id":"3012","名称":"甲功三项","价格":null,"优惠方式":"打折","优惠值":"0.1512","自选项目":false},{"Id":"3406","名称":"口腔全景CR片","价格":"55.8000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3408","名称":"口腔全景CR片(无片)","价格":"36.8000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3489","名称":"测试材料费1","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3490","名称":"测试材料费2","价格":null,"优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"d9f1fa6d-5b2a-4778-a0fe-3bca3b6b3cb4","姓名":"团检预约测试","婚姻状态":"其他","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-05-27","预约结束日期":"2023-07-01","套餐名称":"测试120","当前状态":"未支付","总计金额":"417.60","预约来源":"微信团检预约","到达日期":"2023-06-15","已收费":false}', null, 1, null, null, '2023-06-01 16:47:33', '2023-06-01 16:48:40');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (25, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1943","name":"健康体检套餐","price":"4.26"},"items":[],"group":{"id":""}}', 1, '1943', 4.26, 0.01, 0.00, 1, '4200001875202306012554576392', 5, '2023-06-01 16:52:52', 0, '2023-06-01 16:53:07', 299, '2023-06-30 08:00:00', '23060100000025', 'e65411b9-050b-4782-887a-471e0f52f8d9', '{"项目列表":[{"Id":"2627","名称":"常规检查","价格":"15.5000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2759","名称":"彩超(肝、胆、脾、肾、膀胱、输尿管、女子宫、附件)","价格":"352.9900","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":"19.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"3261","名称":"尿常规+镜检","价格":"12.6000","优惠方式":"打折","优惠值":"0.0100","自选项目":false}],"预约Id":"e65411b9-050b-4782-887a-471e0f52f8d9","姓名":"陆予三三","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-30","预约结束日期":"2023-07-01","套餐名称":"健康体检套餐","当前状态":"未支付","总计金额":"4.26","预约来源":"微信个人预约","到达日期":"2023-06-30","已收费":true}', null, 1, null, null, '2023-06-01 16:52:32', '2023-06-01 16:53:07');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (26, 1, 1, '陆予', '130322199409060012', '15232310906', '1994-09-06', 1, 2, '{"combo":{"id":"1944","name":"2022春季体检套餐","price":"0.21"},"items":[],"group":{"id":""}}', 1, '1944', 0.21, 0.01, 0.00, 1, '4200001869202306017909135918', 5, '2023-06-01 16:55:01', 13, '2023-06-10 23:12:12', 297, '2023-06-28 08:00:00', '23060100000026', '', '{"项目列表":[{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"优惠","优惠值":"25.0000","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"优惠","优惠值":"0.0000","自选项目":false},{"Id":"2749","名称":"腹部彩超","价格":"132.9900","优惠方式":"优惠","优惠值":"132.9800","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":"14.0000","优惠方式":"优惠","优惠值":"14.0000","自选项目":false},{"Id":"2895","名称":"血脂四项","价格":"29.2000","优惠方式":"优惠","优惠值":"29.0000","自选项目":false}],"预约Id":"8c6c3ccb-88be-4204-bf7c-5b828cc0ec1e","姓名":"陆予","婚姻状态":"未婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-28","预约结束日期":"2023-06-29","套餐名称":"2022春季体检套餐","当前状态":"未支付","总计金额":"0.21","预约来源":"微信个人预约","到达日期":"2023-06-28","已收费":true}', null, 1, null, null, '2023-06-01 16:53:45', '2023-06-10 23:12:12');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (27, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1944","name":"2022春季体检套餐","price":"0.21"},"items":[],"group":{"id":""}}', 1, '1944', 0.21, 1.00, 0.00, 1, '4200001878202306106472014572', 3, '2023-06-10 22:04:07', 0, null, 298, '2023-06-29 08:00:00', '23061000000027', '', '{"项目列表":[{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"优惠","优惠值":"25.0000","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"优惠","优惠值":"0.0000","自选项目":false},{"Id":"2749","名称":"腹部彩超","价格":"132.9900","优惠方式":"优惠","优惠值":"132.9800","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":"14.0000","优惠方式":"优惠","优惠值":"14.0000","自选项目":false},{"Id":"2895","名称":"血脂四项","价格":"29.2000","优惠方式":"优惠","优惠值":"29.0000","自选项目":false}],"预约Id":"349757c2-474a-4a79-921d-9226292b809d","姓名":"陆予三三","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-29","预约结束日期":"2023-06-30","套餐名称":"2022春季体检套餐","当前状态":"未支付","总计金额":"0.21","预约来源":"微信个人预约","到达日期":"2023-06-29","已收费":true}', null, 1, null, null, '2023-06-10 22:03:47', '2023-06-10 23:04:22');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (28, 1, 1, '陆予', '130322199409060012', '15232310906', '1994-09-06', 1, 2, '{"combo":{"id":"1944","name":"2022春季体检套餐","price":"0.21"},"items":[],"group":{"id":""}}', 1, '1944', 0.21, 0.01, 0.00, 1, '4200001874202306106949118449', 3, '2023-06-10 22:05:43', 10, '2023-06-10 22:07:02', 324, '2023-06-27 05:00:00', '23061000000028', '', '{"项目列表":[{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"优惠","优惠值":"25.0000","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"优惠","优惠值":"0.0000","自选项目":false},{"Id":"2749","名称":"腹部彩超","价格":"132.9900","优惠方式":"优惠","优惠值":"132.9800","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":"14.0000","优惠方式":"优惠","优惠值":"14.0000","自选项目":false},{"Id":"2895","名称":"血脂四项","价格":"29.2000","优惠方式":"优惠","优惠值":"29.0000","自选项目":false}],"预约Id":"a710c023-8fbd-4bf4-952c-3514b043c511","姓名":"陆予","婚姻状态":"未婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-27","预约结束日期":"2023-06-28","套餐名称":"2022春季体检套餐","当前状态":"未支付","总计金额":"0.21","预约来源":"微信个人预约","到达日期":"2023-06-27","已收费":true}', null, 1, null, null, '2023-06-10 22:05:08', '2023-06-10 23:03:27');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (29, 1, 1, '陆予', '130322199409060012', '15232310906', '1994-09-06', 1, 2, '{"combo":{"id":"1945","name":"测试体检套餐","price":"4.61"},"items":[],"group":{"id":""}}', 1, '1945', 4.61, 0.01, 0.00, 1, '4200001865202306104894982654', 3, '2023-06-10 22:10:21', 11, '2023-06-10 22:10:30', 291, '2023-06-19 08:00:00', '23061000000029', '', '{"项目列表":[{"Id":"2627","名称":"常规检查","价格":"15.5000","优惠方式":"打折","优惠值":"0.0090","自选项目":false},{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2759","名称":"彩超(肝、胆、脾、肾、膀胱、输尿管、女子宫、附件)","价格":"352.9900","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2821","名称":"血细胞分析22项","价格":"19.0000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"2857","名称":"尿生化6项","价格":"36.6000","优惠方式":"打折","优惠值":"0.0100","自选项目":false},{"Id":"3261","名称":"尿常规+镜检","价格":"12.6000","优惠方式":"打折","优惠值":"0.0100","自选项目":false}],"预约Id":"082e5b43-d363-46ea-8c64-261055883c06","姓名":"陆予","婚姻状态":"未婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-06-19","预约结束日期":"2023-06-20","套餐名称":"测试体检套餐","当前状态":"未支付","总计金额":"4.61","预约来源":"微信个人预约","到达日期":"2023-06-19","已收费":true}', null, 1, null, null, '2023-06-10 22:10:02', '2023-06-10 23:00:53');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (30, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, '4200001857202306100716925903', 5, '2023-06-10 22:19:09', 12, '2023-06-10 22:19:22', 298, '2023-06-29 08:00:00', '23061000000030', '', '{"项目列表":[{"Id":"3414","名称":"无抗凝采血管","价格":"1.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3422","名称":"动脉采血","价格":"25.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3497","名称":"男性测试项目","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3498","名称":"男性测试项目2","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"b4ddb308-3727-4d96-bbcc-a6e828ef49de","姓名":"团检预约测试","婚姻状态":"未婚","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-06-29","预约结束日期":"2023-06-30","套餐名称":"男性限定测试套餐","当前状态":"未支付","总计金额":"26.00","预约来源":"微信个人预约","到达日期":"2023-06-29","已收费":true}', null, 1, null, null, '2023-06-10 22:18:50', '2023-06-10 22:19:24');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (31, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '2023-05-30', 1, 2, '{"combo":{"id":"1944","name":"2022春季体检套餐","price":"0.21"},"items":[],"group":{"id":""}}', 1, '1944', 0.21, 0.01, 0.00, 1, '4200001863202306101114595220', 5, '2023-06-10 23:17:57', 14, '2023-06-10 23:18:12', 318, '2023-06-19 05:00:00', '23061000000031', '', '{"项目列表":[{"Id":"2649","名称":"内科一般检查（健康体检）","价格":"25.0000","优惠方式":"优惠","优惠值":"25.0000","自选项目":false},{"Id":"2657","名称":"外科一般检查（健康体检）","价格":"0.0000","优惠方式":"优惠","优惠值":"0.0000","自选项目":false},{"Id":"2749","名称":"腹部彩超","价格":"132.9900","优惠方式":"优惠","优惠值":"132.9800","自选项目":false},{"Id":"2820","名称":"血常规18项","价格":"14.0000","优惠方式":"优惠","优惠值":"14.0000","自选项目":false},{"Id":"2895","名称":"血脂四项","价格":"29.2000","优惠方式":"优惠","优惠值":"29.0000","自选项目":false}],"预约Id":"05fff8e4-8e2b-495b-8d35-38808d30a362","姓名":"团检预约测试","婚姻状态":"未婚","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-06-19","预约结束日期":"2023-06-20","套餐名称":"2022春季体检套餐","当前状态":"未支付","总计金额":"0.21","预约来源":"微信个人预约","到达日期":"2023-06-19","已收费":true}', null, 1, null, null, '2023-06-10 23:17:29', '2023-06-10 23:18:12');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (32, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"}],"group":{"id":""}}', 2, '0', 92.60, 0.01, 0.00, 1, null, 1, null, 0, null, 290, '2023-06-16 08:00:00', '23061000000032', '', null, null, 1, null, null, '2023-06-10 23:29:55', '2023-06-10 23:29:56');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (33, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"}],"group":{"id":""}}', 2, '0', 92.60, 0.01, 0.00, 1, null, 1, null, 0, null, 298, '2023-06-29 08:00:00', '23061000000033', '', null, null, 1, null, null, '2023-06-10 23:32:33', '2023-06-10 23:32:34');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (34, 1, 1, '陆予', '130322199409060012', '15232310906', '1994-09-06', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"}],"group":{"id":""}}', 2, '0', 92.60, 0.01, 0.00, 1, null, 1, null, 0, null, 297, '2023-06-28 08:00:00', '23061000000034', '', null, null, 1, null, null, '2023-06-10 23:33:39', '2023-06-10 23:33:40');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (35, 1, 1, '团检预约测试', '110101198805279357', '12345678901', '1988-05-27', 1, 2, '{"combo":{"id":0,"name":"自选项目","price":0},"items":[{"id":"3406","name":"口腔全景CR片","price":"55.80"},{"id":"3408","name":"口腔全景CR片(无片)","price":"36.80"}],"group":{"id":""}}', 1, '0', 92.60, 0.01, 0.00, 1, '4200001863202306108304916068', 2, '2023-06-10 23:40:31', 0, null, 296, '2023-06-27 08:00:00', '23061000000035', '4bbc3d3a-bbd0-4782-8317-27ff2243ec8a', '{"项目列表":[{"Id":"3406","名称":"口腔全景CR片","价格":"55.8000","优惠方式":"打折","优惠值":"1.0000","自选项目":true},{"Id":"3408","名称":"口腔全景CR片(无片)","价格":"36.8000","优惠方式":"打折","优惠值":"1.0000","自选项目":true}],"预约Id":"4bbc3d3a-bbd0-4782-8317-27ff2243ec8a","姓名":"团检预约测试","婚姻状态":"未婚","证件号码":"110101198805279357","电话号码":"12345678901","预约开始日期":"2023-06-27","预约结束日期":"2023-06-28","套餐名称":"","当前状态":"未支付","总计金额":"92.60","预约来源":"微信个人预约","到达日期":"2023-06-27","已收费":true}', null, 1, null, null, '2023-06-10 23:40:11', '2023-06-10 23:40:31');
|
|
INSERT INTO lkpe.user_orders (id, user, hospital, name, id_number, phone, birthday, sex, marriage, buy_info, type, combo, price, true_price, group_price, pay_type, transaction, status, pay_time, refund, refund_time, appointment, appointment_time, `show`, appointment_number, appointment_info, exam_number, check_status, check_time, referral, created_at, updated_at) VALUES (36, 1, 1, '陆予三三', '130322199409060012', '15232310906', '1994-09-06', 1, 1, '{"combo":{"id":"1958","name":"男性限定测试套餐","price":"26.0"},"items":[],"group":{"id":""}}', 1, '1958', 26.00, 0.01, 0.00, 1, '4200001882202306108911542132', 2, '2023-06-10 23:49:06', 0, null, 358, '2023-07-31 05:00:00', '23061000000036', '13cd639b-3247-40ae-8385-9c8310288e49', '{"项目列表":[{"Id":"3414","名称":"无抗凝采血管","价格":"1.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3422","名称":"动脉采血","价格":"25.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3497","名称":"男性测试项目","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false},{"Id":"3498","名称":"男性测试项目2","价格":"0.0000","优惠方式":"打折","优惠值":"1.0000","自选项目":false}],"预约Id":"13cd639b-3247-40ae-8385-9c8310288e49","姓名":"陆予三三","婚姻状态":"已婚","证件号码":"130322199409060012","电话号码":"15232310906","预约开始日期":"2023-07-31","预约结束日期":"2023-08-01","套餐名称":"男性限定测试套餐","当前状态":"未支付","总计金额":"26.00","预约来源":"微信个人预约","到达日期":"2023-07-31","已收费":true}', null, 1, null, null, '2023-06-10 23:48:47', '2023-06-10 23:49:07');
|