微信解绑

功能描述

管理微信公众号绑定的用户

项目：manageClient

组件：weChatBind

组件别名：wechat-bind

功能权限

没有特殊暂不阐述

相关表

t_banduser

主要字段说明

微信标识 f_open_id 用户编号 f_userinfo_id 绑定状态 f_band_state 用户姓名 f_user_name 绑定时间 f_band_time 公司名称 f_filiale 用户电话 f_user_phone 用户地址 f_address 绑定身份 f_address

查询列表

查询sql

   	*
   FROM
   	(
   	SELECT
   	    b.id,
   		u.f_userinfo_code,
   		u.f_user_state,
   		u.f_createfile_person,
   		u.f_user_phone,
   		u.f_comments,
   		u.f_idnumber,
   		u.f_balance,
   		b.f_userinfo_id,
   	    b.f_open_id,
   	    b.f_band_state,
           b.f_user_name,
           b.f_address,
           u.f_orgid,
   		u.f_orgname,
   		u.f_depname,
   		u.f_operator,
   		u.f_depid,
   		u.f_operatorid,
   		u.f_createfile_date,
   		g.f_meter_brand,
   		g.f_meter_type,
   		address.f_slice_area AS f_zones,
   		address.f_residential_area,
   		address.f_building,
   		address.f_unit,
   		address.f_floor,
   		address.f_room,
           b.f_band_time
   	FROM t_banduser b
   	LEFT JOIN t_userinfo u ON u.f_userinfo_id = b.f_userinfo_id
   	LEFT JOIN t_userfiles uf ON uf.f_userinfo_id = u.f_userinfo_id
   	LEFT JOIN t_gasbrand g ON uf.f_gasbrand_id = g.id
   	LEFT JOIN t_user_address address ON u.f_userinfo_id = address.f_userinfo_id
   	WHERE
   	f_band_state = '有效' and b.f_userinfo_id is not null

   	) t
   WHERE
       {condition}
   ORDER BY
   	f_userinfo_code DESC