收费
功能描述
抄表完成后可以选择收费
项目:
ReadMeterClient
组件:
MobileChargeList
组件别名:
mobile-charge-list
查询条件
条件描述 | 实际取值字段 |
---|---|
客户编号 | f_userinfo_code |
客户名称 | f_user_name |
客户电话 | f_user_phone |
客户地址 | f_address |
抄表册 | f_book_name |
表箱号 | f_metertitles |
查询列表
,,,,,,,,,,,
字段名称 | 实际取值字段 |
---|---|
客户编号 | f_userinfo_code |
客户姓名 | f_user_name |
表箱号 | f_adjustable_id |
客户电话 | f_user_phone |
用气性质 | f_gasproperties |
表具 | f_meter_brand |
客户地址 | f_address |
上次安检时间 | f_last_checkdate |
Details
查询sql
mobile_getUser.sql
SELECT
i.f_userinfo_code,
i.f_olduserinfo_code,
i.f_userinfo_id,
i.f_user_state,
i.f_user_name,
i.f_user_phone,
i.f_balance,
i.f_idnumber,
i.f_credentials,
i.f_people_num,
i.f_comments,
i.f_book_no,
i.f_createfile_date,
i.f_open_date,
i.version AS userinfo_version,
u.f_user_id,
u.f_userfiles_id,
u.f_remanent_price,
u.f_remanent_gas,
mb.f_book_name,
u.f_remanent_type,
u.f_remanent_money,
u.f_deduction_gas,
u.f_table_state,
u.f_card_id,
u.f_card_password,
u.f_meterid,
u.f_area_code,
u.f_tag,
u.f_meternumber,
u.f_metertitles,
u.f_times,
u.f_iot_times,
u.f_fillcard_times,
u.f_price_id,
u.f_gasbrand_id,
u.f_gasmodel_id,
u.f_user_type,
u.f_gasproperties,
u.f_aroundmeter,
u.f_meter_base,
u.f_initial_base,
u.f_total_gas,
u.f_total_fee,
u.f_whether_hairpin,
u.f_balance_amount,
u.f_balance_gas,
u.version,
u.f_filialeid,
u.f_orgname,
u.f_depid,
u.f_depname,
u.f_input_date,
u.f_hand_date,
u.f_gas_date,
u.f_gas_person,
u.f_position,
-- u.f_gas_date_2,
address.f_address,
address.f_last_check_date f_last_checkdate,
gb.id AS brand_id,
gb.f_meter_type,
gb.f_meter_brand,
gb.f_alias,
gb.f_collection_type,
gb.f_calculation,
gb.f_isdecimal,
gb.f_topup_ceil,
gb.f_hascard,
gm.f_meter_style,
gm.f_coding,
sp.id AS f_stairprice_id,
sp.f_price_type,
sp.f_price_name,
sp.f_version,
u.f_garbage_fee,
u.f_orgid,
ad.f_adjustable_name,
f_meter_book_sort,
ad.f_adjustable_id
FROM
t_userfiles u
LEFT JOIN t_userinfo i ON u.f_userinfo_id = i.f_userinfo_id
LEFT JOIN t_user_address address ON u.f_useraddress_id = address.id
LEFT JOIN t_gasbrand gb ON u.f_gasbrand_id = gb.id
LEFT JOIN t_meter_book mb ON mb.id= u.f_meter_book_num
LEFT JOIN t_gasmodel gm ON u.f_gasmodel_id = gm.id
LEFT JOIN ( SELECT * FROM t_stairprice WHERE { entity.findDialect() == $SqlServer$:$getdate()$,$sysdate$} >= f_perform_date AND { entity.findDialect() == $SqlServer$: $getdate()$,$sysdate$} <= f_end_date AND f_state = '有效' ) sp ON u.f_price_id = sp.f_price_id
AND u.f_filialeid = sp.f_filialeid
LEFT JOIN t_adjustablebox ad ON u.f_adjustable_id = ad.id
WHERE
f_meter_classify = '机表'
AND f_user_state = '正常'
AND u.f_table_state != '换表'
AND u.f_table_state != '无效'
AND {condition}
ORDER BY
u.f_userfiles_id DESC
按钮操作
查询
按条件查询已抄表未缴费用户
列表操作
进入缴费页面
配置说明
没有特殊暂不阐述