--视图 v_order_temp 增加 a.price*a.order_num as subtotal
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '序号', 'No.', 0)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '菜品名称', 'Dish Name', 1)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '菜品单价', 'Price', 2)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '单位', 'Unit', 3)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '数量', 'Number', 4)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '小计', 'Subtotal', 5)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '口味', 'Taste', 6)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '走菜方式', 'Service model', 7)
go
insert into t_title_caption(code, name_ch, name_en, item_index) values('Orderinfo', '备注', 'Remark', 8)
go
--新建视图 v_order_dishes
create view v_order_dishes
as
select
a.id as id,
a.sOrderNo as sOrderNo,
b.name_ch as dishName_ch,
b.name_en as dishName_en,
a.price as price,
a.order_num as order_num,
subtotal as subtotal,
e.name_ch as dishUnitName_ch,
e.name_en as dishUnitName_en,
isnull(c.name_ch, '')+isnull(','+d.name_ch, '') as tasteName_ch,
isnull(c.name_en, '')+isnull(','+d.name_en, '') as tasteName_en,
g.name_ch as servingModeName_ch,
g.name_en as servingModeName_en,
a.remark as remark,
f.name_ch as waiter_ch,
f.name_en as waiter_en,
from t_order_dishes a
left join t_dishes b on a.dish_id = b.id
left join t_taste c on a.taste_id1 = c.id
left join t_taste d on a.taste_id2 = d.id
left join t_dish_unit e on b.dishUnit_id = e.id
left join t_user f on f.id = a.waiter --这里要改
left join t_serving_mode g on a.servingMode_id = g.id
go
--新建视图 v_order
create view v_order
as
select
a.sOrderNo as sOrderNo,
b.customer_name as customer_name,
b.mobile as mobile,
c.name_ch as deskName_ch,
c.name_en as deskName_en,
d.name_ch as dinnerFormName_ch,
