last_颗粒剂膏方
1、商品订购里面的膏方跳转到开方界面开方，在商品订购列表里需要显示这单
2、五行膏方和服务商、地区地区管理员结算时按照医生实际购买价格计算，和药房结算时按照药材的实际价格结算
3、蔡氏妇科、五行膏方都按照颗粒剂膏方的形式修改
4、蔡氏妇科计算价格和颗粒膏方规则一样，五行膏方还是以固定的价格卖给医生
5、所有颗粒剂都可以开膏方，每单增加金额 辅料20，打包费20，运费10，订单详情里要每条都要显示出来
```sql
USE meridian_portable_public;
ALTER TABLE tb_ai_tongue ADD id_lin VARCHAR(100) DEFAULT NULL COMMENT '对应林老师版本舌象症状id';
ALTER TABLE tb_ai_face ADD id_lin_list VARCHAR(100) DEFAULT NULL COMMENT '对应林老师版本舌象症状id，数组的json格式';
ALTER TABLE tb_ai_pulse ADD id_lin_list VARCHAR(100) DEFAULT NULL COMMENT '对应林老师版本舌象症状id，数组的json格式';
改大小
```
```sql
USE meridian_portable_logic;
ALTER TABLE tb_prescription MODIFY remark VARCHAR(600) COMMENT '医嘱';
ALTER TABLE tb_prescription MODIFY diagnose VARCHAR(600) COMMENT '患者主诉';
ALTER TABLE tb_prescription MODIFY case_history VARCHAR(600) COMMENT '患者现病史';
ALTER TABLE tb_prescription_order MODIFY remark VARCHAR(1500) COMMENT '备注';
ALTER TABLE tb_prescription_order ADD `third_order_id` VARCHAR(200) COMMENT '第三方订单id' AFTER pres_id;
ALTER TABLE tb_prescription_order ADD `fees_pack` FLOAT(10,2) DEFAULT '0.00' COMMENT '打包费' AFTER fees_make;
ALTER TABLE tb_prescription_order ADD `red_packet_id` BIGINT COMMENT '红包id' AFTER fees_red_packet;
ALTER TABLE tb_goods_order ADD `red_packet_id` BIGINT COMMENT '红包id' AFTER fees_red_packet;
ALTER TABLE tb_red_packet ADD `is_occupy` BIGINT COMMENT '红包是否被占用, true: 被占用';
ALTER TABLE tb_prescription_order ADD `is_send` INT COMMENT '是否发送处方';
ALTER TABLE tb_prescription_count_day ADD COLUMN kind_id INT
COMMENT '剂型，颗粒剂膏方按照膏方写入，颗粒剂4：膏方：5' AFTER medicine_pharmacy_id;
UPDATE tb_prescription_count_day SET kind_id = 4 WHERE kind_id = 0;
ALTER TABLE tb_prescription_count_day DROP PRIMARY KEY, ADD PRIMARY KEY(time, pharmacy_id, medicine_pharmacy_id, kind_id);
DROP TABLE IF EXISTS `tb_broadcast`;
CREATE TABLE `tb_broadcast` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '直播名字\r\n',
`lecturer_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讲师名字',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
`time` bigint(20) NULL DEFAULT NULL COMMENT '直播时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;
```