总舵主软件:餐饮沐足洗浴宾馆票务系统对接小程序及app的所有字段

摘要：select tech_type as bh,tech_name as mc from s_tech_type_xy union all select '0','所有类型' order by tech_type--技师类型

---房间信息

select * from v_room_stat_xy where area_code='0001' order by room_code--全部

select * from v_room_stat_xy where area_code='0001' and state_name ='占用' order by room_code--房间占用

select * from v_room_stat_xy where area_code='0001' and state_name ='可供' order by room_code--房间可供

------手牌信息

select * from v_room_type_xy where room_flagn=1 and area_code='0001'---手牌类型

select *,(select hand_code from s_hand_xy where hand_id=v_hand_xy.main_id) as mhand_code from v_hand_xy where hand_type='5' and area_code='0001' order by hand_code--男宾手牌

select *,(select hand_code from s_hand_xy where hand_id=v_hand_xy.main_id) as mhand_code from v_hand_xy where hand_type='5' and area_code='0001' and state_name = '占用' order by hand_code--占用手牌

---技师信息

select tech_type as bh,tech_name as mc from s_tech_type_xy union all select '0','所有类型' order by tech_type--技师类型

select bc,xc,tech_id,state_id,service,sex,tech_type,tech_code,name,mnem,nox_id,state_name,remark,tech_name,dbo.f_get_service_name_xy(service,1) service_name,dbo.f_get_service_name_xy(service,2) start_date,dbo.f_get_service_name_xy(service,3) end_date,case state_id when 0 then '' else dbo.f_fw_fwdx_xy(tech_id) end fwdx,dbo.f_get_fwsj(tech_id,'2025-09-07 11:46:11') as fwsj,state1_id,case state1_id when 0 then '正常' else '加班' end state1_idname from v_Tech_info_xy where area_code='0001'---所有技师

select bc,xc,tech_id,state_id,service,sex,tech_type,tech_code,name,mnem,nox_id,state_name,remark,tech_name,dbo.f_get_service_name_xy(service,1) service_name,dbo.f_get_service_name_xy(service,2) start_date,dbo.f_get_service_name_xy(service,3) end_date,case state_id when 0 then '' else dbo.f_fw_fwdx_xy(tech_id) end fwdx,dbo.f_get_fwsj(tech_id,'2025-09-07 11:49:01') as fwsj,state1_id,case state1_id when 0 then '正常' else '加班' end state1_idname from v_Tech_info_xy where tech_type='04' and state_id='0' and area_code='0001' order by tech_type,tech_code,bc,xc,state_id--技师空闲状态+技师类型

select bc,xc,tech_id,state_id,service,sex,tech_type,tech_code,name,mnem,nox_id,state_name,remark,tech_name,dbo.f_get_service_name_xy(service,1) service_name,dbo.f_get_service_name_xy(service,2) start_date,dbo.f_get_service_name_xy(service,3) end_date,case state_id when 0 then '' else dbo.f_fw_fwdx_xy(tech_id) end fwdx,dbo.f_get_fwsj(tech_id,'2025-09-07 11:50:42') as fwsj,state1_id,case state1_id when 0 then '正常' else '加班' end state1_idname from v_Tech_info_xy where state_id='0' and area_code='0001' order by tech_type,tech_code,bc,xc,state_id --所以技师空闲状态

房间字段

area_code-- 区域编码

room_code --房间编号

romm_type --房间类型id(在软件不显示)

room_name --房间类型名称

state_name-- 房间状态

amount --房间消费金额合计

room_state 房间状态类型id(在软件不显示)

手牌字段

area_code-- 区域编码

hand_code --手牌编号

hand_type --手牌类型id(在软件不显示)

type_name --手牌类型名称

state_name --手牌状态

amount --手牌消费金额合计

hand_state 手牌状态类型id(在软件不显示)

技师字段

tech_coed --技师编号

name--技师名称

state_name --技师状态

tech_type--技师类型ID

tech_name --技师类型名称

service_name --技师服务班次

state1_idname --加班状态

----

select *,fwsj,dbo.f_dengdaitime(goods_id,getdate,nox_id) as ddtime,case is_lunban when 0 then '轮钟' when 1 then '点钟' when 2 then '加钟' when 3 then '轮钟(加班)' when 4 then '点钟(加班)' when 5 then '加钟(加班)' end as lunbanname ,case sex when 0 then '自动' when 1 then '男' when 2 then '女' end as sexname ,(select waiter_code from s_waiter_xy where waiter_id=v_sub_billstate_info_xy.DeductWaiterId ) as waiter_code from v_sub_billstate_info_xy where (flag=0 or flag=5 or flag=2) and goods_id in (select goods_id from tb_goods_info_xy where type_id in (select goods_type from s_Goods_type_xy where is_service=1)) and tech_id=0 and flag=0 and close_datetime is null order by room_code--未安排技师(等待)

--未安排技师字段

area_code--区域编码

hand_code--手牌编码

goods_name--商品名称

waiter_coed--客服名称

select goods_id,flag,nox_id,tech_id,operate_date,room_code,goods_name,tech_code,tech_Date,close_datetime, fwsj,case is_lunban when 0 then '轮钟' when 1 then '点钟' when 2 then '加钟' when 3 then '轮钟(加班)' when 4 then '点钟(加班)' when 5 then '加钟(加班)' end as lunbanname ,case sex when 0 then '自动' when 1 then '男' when 2 then '女' end as sexname ,(select waiter_code from s_waiter_xy where waiter_id=v_sub_billstate_info_xy.DeductWaiterId ) as waiter_code from v_sub_billstate_info_xy where goods_id in (select goods_id from tb_goods_info_xy where type_id in (select goods_type from s_Goods_type_xy where is_service=1)) and close_datetime is null and (flag=0 or flag=5 or flag=2) and tech_id>0 union all select goods_id,flag,nox_id,tech_id,operate_date,room_code,goods_name,tech_code,tech_Date,close_datetime, fwsj,case is_lunban when 0 then '轮钟' when 1 then '点钟' when 2 then '加钟' when 3 then '轮钟(加班)' when 4 then '点钟(加班)' when 5 then '加钟(加班)' end as lunbanname ,case sex when 0 then '自动' when 1 then '男' when 2 then '女' end as sexname ,(select waiter_code from s_waiter_xy where waiter_id=v_sub_billprint_info_account_xy.DeductWaiterId ) as waiter_code from v_sub_billprint_info_account_xy where goods_id in (select goods_id from tb_goods_info_xy where type_id in (select goods_type from s_Goods_type_xy where is_service=1)) and close_datetime is null and (flag=0 or flag=5 or flag=2) and qt_flag=1 and tech_id>0 order by operate_date---项目剩余时间

项目剩余时间字段

goods_name--商品名称

tech_ceod --技师编号

tech_date --技师上钟时间

waiter_coed--客服名称

sexname--性别

fwsj--剩余时间

---

select level_code as bh,level_name as mc from s_member_level order by level_code--会员卡类型

select *,case enable_date when 0 then '永久有效' else CONVERT(varchar(100),DATEADD(day,enable_date,create_date),23) end as yxrq from v_member_info_xy_1 where state=0 order by member_no--会员信息