账户冻结
条件一:
```
SELECT * FROM user_prisoner_bill
WHERE BALANCE-ABALANCE-BBALANCE-CBALANCE-DBALANCE !=0
```
条件二:系统账户金额和系统银行余额相差的金额,是当天代发的金额和未代扣成功的金额。(早上银行推送账户金额,推送的是前一天的余额)
```
SELECT * FROM(
SELECT ZF_USER_ID,ZF_BH,ROUND(BALANCE/100,2) AS '系统账户金额' ,
IFNULL(`代发金额`,0)AS'代发金额',
IFNULL(`代扣金额`,0)AS'代扣金额',
ROUND(t4.BN_AMOUNT/100,2) AS '本地银行余额',
ROUND(BALANCE/100,2)-IFNULL(`代发金额`,0)+IFNULL(`代扣金额`,0)-ROUND(t4.BN_AMOUNT/100,2) AS '差值',
CASE t1.status WHEN 1 THEN '正常' WHEN 2 THEN '冻结' WHEN 3 THEN '销户' WHEN 4 THEN '销户冻结' END AS '账户状态'
FROM user_prisoner_bill t1
LEFT JOIN(
-- 当天代发金额
SELECT MOD_USER_ID,MOD_ZFBH,SUM(ROUND(MOD_AMOUNT/100,2))AS '代发金额'
FROM user_prisoner_batch_money_operate_detail t1
LEFT JOIN user_prisoner_batch_money_operate t2 ON t1.MOD_GROUP_XH=t2.MOG_XH
WHERE t2.MOG_TRANS_TYPE=1 AND mod_status=5 AND DATEDIFF(NOW(),MOG_CDATE)=0
GROUP BY MOD_USER_ID)t2 ON t1.ZF_USER_ID=t2.MOD_USER_ID
LEFT JOIN(
-- 未处理成功的代扣金额
SELECT MOD_USER_ID,MOD_ZFBH,SUM(ROUND(MOD_AMOUNT/100,2))AS '代扣金额'
FROM user_prisoner_batch_money_operate_detail t1
LEFT JOIN user_prisoner_batch_money_operate t2 ON t1.MOD_GROUP_XH=t2.MOG_XH
WHERE t2.MOG_TRANS_TYPE=2 AND mod_status in(1,6,7)
GROUP BY MOD_USER_ID)t3 ON t1.ZF_USER_ID=t3.MOD_USER_ID
LEFT JOIN user_prisoner_bk_no t4 ON t1.ZF_USER_ID=t4.BN_USER_ID AND BN_STATE=1)t
-- WHERE (`差值`=0 AND `账户状态`!='正常')
-- OR(`差值`!=0 AND `账户状态`='正常')
WHERE zf_bh='3372009944'
```