01_药房结算价&疾病统计&新增充值余额
# SQL
### 药房结算价 sql
```sql
MonthPayController: ==========159L
ALTER TABLE meridian_portable_logic.tb_goods_order ADD `fees_pharmacy` FLOAT(10,2) DEFAULT '0.00'
COMMENT '药房结算的价格' AFTER fees_petient;
ALTER TABLE meridian_portable_logic.tb_prescription_order ADD `fees_pharmacy` FLOAT(10,2) DEFAULT '0.00'
COMMENT '药房结算的价格' AFTER fees_factor;
ALTER TABLE meridian_portable_public.tb_pay_trade ADD `money_pharmacy` FLOAT(10,2) DEFAULT '0.00'
COMMENT '药房结算的价格' AFTER money_factor;
ALTER TABLE meridian_portable_public.tb_month_pay_detail ADD `money_pharmacy` FLOAT(10,2) DEFAULT '0.00'
COMMENT '药房结算的价格' AFTER money_factor;
# 更新数据
UPDATE tb_goods_order
SET fees_pharmacy = fees_total
WHERE pay_time BETWEEN 1604160000000 AND 1606751999000
UPDATE meridian_portable_public.tb_pay_trade
SET money_pharmacy = money
WHERE pay_time BETWEEN 1604160000000 AND 1606751999000
AND order_type = 'goods'
```
### 疾病统计
```sql
CREATE TABLE IF NOT EXISTS `tb_illness_repetition` (
`illness_id` INT COMMENT '疾病id，对应tb_excel_illness表的id',
`name` VARCHAR(100) COMMENT '疾病名字',
`test_num` INT COMMENT '辩证次数，测试疾病的次数',
`prescription_num` INT COMMENT '开方次数',
`repetition_num` INT COMMENT '复诊次数',
`prescription_people_num` INT COMMENT '单个疾病开过方的总人数',
`repetition_people_num` INT COMMENT '单个疾病复诊过的总人数',
PRIMARY KEY (`illness_id`) USING BTREE
)ENGINE=INNODB DEFAULT CHARSET=utf8;
```
### 新增充值余额
```sql
ALTER TABLE tb_account_money_log
ADD `num_pre` FLOAT(10,2)
COMMENT '上一次的余额或者次数' AFTER num;
UPDATE tb_account_money_log SET num_pre = 0
ALTER TABLE tb_account_money
ADD `money_give` FLOAT(10,2)
COMMENT '赠送的余额' AFTER money;
select * from tb_account_money
UPDATE tb_account_money SET money_give = money, money = 0;
UPDATE tb_account_money_log SET memo = '药方订单赠送余额购买'
WHERE memo = '药方订单余额购买';
UPDATE tb_account_money_log SET memo = '商品订购赠送余额购买'
WHERE memo = '商品订购余额购买';
SELECT * FROM tb_account_money_log WHERE memo = '药方订单余额购买';
SELECT * FROM tb_account_money_log WHERE memo = '商品订购余额购买';
```