select * from new_lms_customerwallettransaction cwt
join new_lms_customerwallet cw on cw.id = cwt.customer_wallet_id
join crm_app_customer c on c.id = cw.customer_id
where cwt.created_at ::date >= '2025-10-28' and c.id in (649830, 270907, 516056, 406568, 127146, 280781, 148747, 144544, 88286);
 
 
 
select * from ledger_amount where id in (183955829, 183968303, 183956677, 183955077, 183956049, 183967747, 183976131, 183947869, 183956605);
 
select * from ledger_entry  where id in (25773430, 25777103, 25773726, 25773157, 25773519, 25776889, 25779231, 25771430, 25773702)
 
 
 
UPDATE new_lms_customerwallet cw
SET total_amount = COALESCE((
    SELECT SUM(t.amount)
    FROM new_lms_customerwallettransaction t
    WHERE t.customer_wallet_id = cw.id
), 0)
WHERE cw.id IN (14549, 11813, 14377, 14550, 13825, 6432, 14551, 14552, 14553);
 
update loan_app_loan set  last_closing_day ='2025-10-27', last_lms_closing_day ='2025-10-27' where id in (89793, 49313, 92567, 55087, 31546);

c2VsZWN0ICogZnJvbSBuZXdfbG1zX2N1c3RvbWVyd2FsbGV0dHJhbnNhY3Rpb24gY3d0CmpvaW4gbmV3X2xtc19jdXN0b21lcndhbGxldCBjdyBvbiBjdy5pZCA9IGN3dC5jdXN0b21lcl93YWxsZXRfaWQKam9pbiBjcm1fYXBwX2N1c3RvbWVyIGMgb24gYy5pZCA9IGN3LmN1c3RvbWVyX2lkCndoZXJlIGN3dC5jcmVhdGVkX2F0IDo6ZGF0ZSA+PSAnMjAyNS0xMC0yOCcgYW5kIGMuaWQgaW4gKDY0OTgzMCwgMjcwOTA3LCA1MTYwNTYsIDQwNjU2OCwgMTI3MTQ2LCAyODA3ODEsIDE0ODc0NywgMTQ0NTQ0LCA4ODI4Nik7CgoKCnNlbGVjdCAqIGZyb20gbGVkZ2VyX2Ftb3VudCB3aGVyZSBpZCBpbiAoMTgzOTU1ODI5LCAxODM5NjgzMDMsIDE4Mzk1NjY3NywgMTgzOTU1MDc3LCAxODM5NTYwNDksIDE4Mzk2Nzc0NywgMTgzOTc2MTMxLCAxODM5NDc4NjksIDE4Mzk1NjYwNSk7CgpzZWxlY3QgKiBmcm9tIGxlZGdlcl9lbnRyeSAgd2hlcmUgaWQgaW4gKDI1NzczNDMwLCAyNTc3NzEwMywgMjU3NzM3MjYsIDI1NzczMTU3LCAyNTc3MzUxOSwgMjU3NzY4ODksIDI1Nzc5MjMxLCAyNTc3MTQzMCwgMjU3NzM3MDIpCgoKClVQREFURSBuZXdfbG1zX2N1c3RvbWVyd2FsbGV0IGN3ClNFVCB0b3RhbF9hbW91bnQgPSBDT0FMRVNDRSgoCiAgICBTRUxFQ1QgU1VNKHQuYW1vdW50KQogICAgRlJPTSBuZXdfbG1zX2N1c3RvbWVyd2FsbGV0dHJhbnNhY3Rpb24gdAogICAgV0hFUkUgdC5jdXN0b21lcl93YWxsZXRfaWQgPSBjdy5pZAopLCAwKQpXSEVSRSBjdy5pZCBJTiAoMTQ1NDksIDExODEzLCAxNDM3NywgMTQ1NTAsIDEzODI1LCA2NDMyLCAxNDU1MSwgMTQ1NTIsIDE0NTUzKTsKCnVwZGF0ZSBsb2FuX2FwcF9sb2FuIHNldCAgbGFzdF9jbG9zaW5nX2RheSA9JzIwMjUtMTAtMjcnLCBsYXN0X2xtc19jbG9zaW5nX2RheSA9JzIwMjUtMTAtMjcnIHdoZXJlIGlkIGluICg4OTc5MywgNDkzMTMsIDkyNTY3LCA1NTA4NywgMzE1NDYpOw==