单户调价
功能描述
针对单个用户进行调价并查询调价记录 项目:
SaleClient
组件:
UserPriceChangeManage
组件别名:
user-pricechange-manage
查询条件
没有特殊 不做阐述
查询列表
主要查询sql
select *
from (select u.f_userinfo_code,
u.f_olduserinfo_code,
u.f_userinfo_id,
u.version,
f.f_adjustable_id,
f.f_user_id,
f.f_userfiles_id,
f.f_price_id,
u.f_user_name,
u.f_filialeid,
u.f_createfile_date,
u.f_user_phone,
a.id addressid,
a.f_address,
u.f_user_state,
f.f_user_type,
f.f_gasproperties,
f.f_table_state,
f.f_meternumber,
f.f_card_id,
gb.f_meter_brand,
gb.f_collection_type,
gb.f_calculation,
gm.f_meter_style,
sp.f_price_name,
sp.f_price_type,
sp.f_perform_date
from t_userfiles f
LEFT JOIN t_userinfo u on f.f_userinfo_id = u.f_userinfo_id
LEFT JOIN t_user_address a on f.f_useraddress_id = a.id
left join t_gasbrand gb on f.f_gasbrand_id = gb.id
left join t_gasmodel gm on f.f_gasmodel_id = gm.id
LEFT JOIN (SELECT f_price_id,
f_price_name,
f_price_type,
f_perform_date
FROM t_stairprice
WHERE getdate() >= f_perform_date
AND getdate() <= f_end_date
AND f_state = '有效') sp ON sp.f_price_id = f.f_price_id) u
where {condition} and f_table_state in ('正常', '待开通') and f_user_state <> '预备' and f_user_state <> '销户'
ORDER by f_userinfo_id desc
列表操作
调价
打开修改表单,选择气价信息
查看
查看调价历史记录