单户调价

功能描述

针对单个用户进行调价并查询调价记录 项目：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

列表操作

调价

打开修改表单，选择气价信息

查看

查看调价历史记录