https://cpstest.hisense.com/score_file/inner_private_file/2025/1/8/XUiohBCkKfDthTVkQr93.xlsx

{"signature":"05c90a1626398564ee39ef821d63b98b48b93a10","encrypt":"wQXbDZVHkKbzCO5obov5XgPddAkMObRF7Xz4FawEMuQHGJfcsoFbmwB9yV4I4URb9RrBxHNiB88uKcCLgfV9n9tlNpJ66Ua03dEUSDGL7_wgxq0aso4yF42xuO0SGxz9","appKey":"HgCpBvH4","nonce":"Wa9yqx","timestamp":"1736604003640"}

https://cpstest.hisense.com/score_file/inner_private_file/2025/1/16/lkKWvroHlPYcRjPihvqX.xlsx

_pk_ref.155.d3c6=%5B%22%22%2C%22%22%2C1738891046%2C%22http%3A%2F%2Fyxpttest.hisense.com%2F%22%5D; _pk_id.156.d3c6=afc30d7f77cfcb4e.1714442173.; _pk_id.155.d3c6=912629653e41d384.1724380517.; authorize=1; BIGipServerPOOL_OCP_JUCLOUD_DEV80=!THtNAT9xYEkp5z7VZekhhPIyzDN0VTqb1m7Hkn7/dA75ypTS1L6zOW2jwHB6ILPhkluXOflTuhUz+Sk=; yxptusername=gonglei.ex; sso_login_user_token=NA1qBKSLZ2xGnBXqJHtWsY9ZlTlNXLzSZY8nL_qC8h6FjJecdAaXBGGkfANXOsAHW7mTpoCYrkvjXCp0zXHuEQ==; manager_token=w4T-aAE4ICLNNu1xxAx9Xw==; manager_token_site=5; JSESSIONID=C20DD957E0698913768CC01895378F1E; normal_user_token=e8dcc3559da24300b5184f1ede7ca9c1523c6723; ssoLoginToken=c7f717fb19eca6545587fe9e23cf7f38ee890086bed0ee694712cedb73f1d0d2; _pk_ses.155.d3c6=1

184aab4c2f1d493bbd5a1096ee1d571f

183e6643013849c9af8808b87f9fb954

314a5836de0043189f65bdb729593cd9

7ca64a26f76f42fab9a86590e57cc926

17fa05b27d41497cafe9ed9f97a4d4ad

https://cpstest.hisense.com/score_file/inner_private_file/2025/4/23/uiI6ixkBRC9Vwq4I1QwJ.xlsx

海信爱家App异常抽奖奖项记录列表

cpstest.hisense.com/score_file/inner_private_file/2025/4/27/UxzAfULelZFjxEJ78pxX.xlsx
海信爱家App影视VIP月卡异常发放券码

https://cpstest.hisense.com/score_file/inner_private_file/2025/7/8/Vn8cinqXm9wyUTmdmLbx.zip

-- 6502104
SELECT count(Distinct(d.user_score_account_id)) FROM user_score_produce_detail d
where d.expire_time = to_date('2026-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
AND d.status = 1
AND d.is_delete = 0;

-- 5477320
SELECT COUNT(a.accountId) FROM
(SELECT d.user_score_account_id accountId ,SUM(d.score) totalscore FROM user_score_produce_detail d
where d.expire_time = to_date('2026-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
AND d.status = 1
AND d.is_delete = 0
GROUP BY d.user_score_account_id) a
WHERE a.totalscore >= 2000;

http://score-center.devapps.hisense.com/user-manage/black/save