Всего строк: 72
Сумма: 166 410.00
active: 65 522.00
inactive: 23 511.00
other: 77 377.00
Всего строк: 85
Сумма: 103 262.94
active: 53 320.00
inactive: 30 964.00
other: 0.00
По строкам: 72 → 85 (+13)
По сумме: 166 410.00 → 103 262.94 (−63 147.06)
active: 65 522.00 → 53 320.00 (−12 202.00)
inactive: 23 511.00 → 30 964.00 (+7 453.00)
other → active/inactive: 77 377.00 → 0.00
| Статус | Старые (шт.) | Старые (сумма) | Новые (шт.) | Новые (сумма) | Δ сумма |
|---|---|---|---|---|---|
| active | — | 65 522.00 | 34 | 42 702.94 | −22 819.06 |
| inactive | — | 23 511.00 | 51 | 60 560.00 | +37 049.00 |
| used | — | 0.00 | 0 | 0.00 | 0.00 |
| removed | — | 0.00 | 0 | 0.00 | 0.00 |
| ID | Логин | Имя | Баланс | Net по транзакциям | Active бонусы | Inactive бонусы | |
|---|---|---|---|---|---|---|---|
| 48634 | n-i-a74@yandex.ru | Ирина Новохатская | n-i-a74@yandex.ru | 6 018.65 | 6 018.65 | 3 / 1 595.65 | 2 / 3 766.00 |
| 53630 | tatianamilord@gmail.com | Татьяна Новикова | tatianamilord@gmail.com | 0.00 | -202.06 | 1 / 869.00 | 0 / 0.00 |
| 65866 | elvira_gizzatulina@mail.ru | Эльвира Ачох | elvira_gizzatulina@mail.ru | 0.00 | -22 274.00 | 4 / 19 943.00 | 1 / 278.00 |
| 66152 | Kotik.pes@mail.ru | Андреевна Варвара | Kotik.pes@mail.ru | 16 599.00 | 16 599.00 | 20 / 19 934.00 | 23 / 27 983.00 |
| 71718 | tasyapudelman | Анастасия Пудельман | tasyapudelman@yandex.ru | 0.00 | -1 108.10 | 0 / 0.00 | 1 / 1 421.00 |
| 74333 | nastia.litovka@yandex.ru | Анастасия Пухт | nastia.litovka@yandex.ru | 0.00 | -8 046.71 | 6 / 361.29 | 2 / 3 023.00 |
| 78104 | lutsenko_polina@list.ru | Владлена Кошелева | lutsenko_polina@list.ru | 500.00 | 500.00 | 0 / 0.00 | 5 / 1 206.00 |
| 78251 | pavlova.istu@ya.ru | Екатерина | pavlova.istu@ya.ru | 1 000.00 | 1 000.00 | 0 / 0.00 | 1 / 24.00 |
| 78323 | test_buyer_groom_6716 | Покупатель Тестовый | test-buyer@groom-mir.test | 1 000.00 | 1 000.00 | 0 / 0.00 | 4 / 2 007.00 |
| 78324 | test_ambassador_groom_7408 | Амбассадор Тестовый | test-ambassador@groom-mir.test | 1 000.00 | 1 000.00 | 0 / 0.00 | 6 / 10 952.00 |
| 78325 | test_bm_groom_6055 | Бренд-менеджер Тестовый | test-bm@groom-mir.test | 1 000.00 | 1 000.00 | 0 / 0.00 | 3 / 6 600.00 |
| 78326 | test_captain_groom_9053 | Капитан Тестовый | test-captain@groom-mir.test | 1 000.00 | 1 000.00 | 0 / 0.00 | 3 / 3 300.00 |
Orders to process: 47 --- Order 669638 --- Old bonuses: active=1401 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669641 --- Old bonuses: active=198 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669696 --- Old bonuses: active=20 inactive=0 other=869 Transactions to delete: 2 New bonuses: active=1449 inactive=0 --- Order 669703 --- Old bonuses: active=0 inactive=0 other=1421 Transactions to delete: 1 New bonuses: active=0 inactive=2369 --- Order 669752 --- Old bonuses: active=390 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669753 --- Old bonuses: active=421 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669768 --- Old bonuses: active=200 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669830 --- Old bonuses: active=0 inactive=0 other=375 Transactions to delete: 1 New bonuses: active=0 inactive=1877 --- Order 669895 --- Old bonuses: active=2616 inactive=0 other=0 Transactions to delete: 2 New bonuses: active=3585 inactive=0 --- Order 669920 --- Old bonuses: active=508 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=1525 inactive=0 --- Order 669962 --- Old bonuses: active=4 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=5 inactive=0 --- Order 669964 --- Old bonuses: active=1025 inactive=0 other=615 Transactions to delete: 3 New bonuses: active=0 inactive=0 --- Order 669969 --- Old bonuses: active=204 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669970 --- Old bonuses: active=1642 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=0 inactive=0 --- Order 669992 --- Old bonuses: active=1134 inactive=0 other=1701 Transactions to delete: 2 New bonuses: active=3665 inactive=0 --- Order 669994 --- Old bonuses: active=2372 inactive=0 other=4745 Transactions to delete: 3 New bonuses: active=1186 inactive=0 --- Order 669995 --- Old bonuses: active=1435 inactive=0 other=0 Transactions to delete: 2 New bonuses: active=1904 inactive=0 --- Order 669996 --- Old bonuses: active=3 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=5 inactive=0 --- Order 669999 --- Old bonuses: active=793 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=872 inactive=0 --- Order 670001 --- Old bonuses: active=1760 inactive=0 other=2640 Transactions to delete: 2 New bonuses: active=4400 inactive=0 --- Order 670003 --- Old bonuses: active=1760 inactive=0 other=2640 Transactions to delete: 2 New bonuses: active=4400 inactive=0 --- Order 670006 --- Old bonuses: active=2048 inactive=0 other=0 Transactions to delete: 3 New bonuses: active=583 inactive=0 --- Order 670007 --- Old bonuses: active=497 inactive=0 other=746 Transactions to delete: 2 New bonuses: active=1605 inactive=0 --- Order 670008 --- Old bonuses: active=422 inactive=0 other=632 Transactions to delete: 2 New bonuses: active=1054 inactive=0 --- Order 670010 --- Old bonuses: active=903 inactive=0 other=1355 Transactions to delete: 2 New bonuses: active=2495 inactive=0 --- Order 670013 --- Old bonuses: active=2965 inactive=0 other=4448 Transactions to delete: 2 New bonuses: active=1483 inactive=0 --- Order 670023 --- Old bonuses: active=1009 inactive=0 other=1513 Transactions to delete: 2 New bonuses: active=2522 inactive=0 --- Order 670025 --- Old bonuses: active=25064 inactive=0 other=53677 Transactions to delete: 2 New bonuses: active=14307 inactive=0 --- Order 670037 --- Old bonuses: active=0 inactive=2945 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=3727 --- Order 670099 --- Old bonuses: active=226 inactive=0 other=0 Transactions to delete: 2 New bonuses: active=113 inactive=0 --- Order 670121 --- Old bonuses: active=13592 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=4531 inactive=0 --- Order 670171 --- Old bonuses: active=0 inactive=713 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=2571 --- Order 670176 --- Old bonuses: active=385 inactive=0 other=0 Transactions to delete: 1 New bonuses: active=385 inactive=0 --- Order 670178 --- Old bonuses: active=325 inactive=0 other=0 Transactions to delete: 2 New bonuses: active=671 inactive=0 --- Order 670225 --- Old bonuses: active=200 inactive=0 other=0 Transactions to delete: 2 New bonuses: active=575 inactive=0 --- Order 670253 --- Old bonuses: active=0 inactive=1344 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=1344 --- Order 670265 --- Old bonuses: active=0 inactive=4249 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=4422 --- Order 670290 --- Old bonuses: active=0 inactive=1470 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=1470 --- Order 670293 --- Old bonuses: active=0 inactive=272 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=272 --- Order 670305 --- Old bonuses: active=0 inactive=641 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=641 --- Order 670320 --- Old bonuses: active=0 inactive=529 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=529 --- Order 670327 --- Old bonuses: active=0 inactive=4766 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=4766 --- Order 670330 --- Old bonuses: active=0 inactive=2045 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=2439 --- Order 670332 --- Old bonuses: active=0 inactive=739 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=739 --- Order 670348 --- Old bonuses: active=0 inactive=1098 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=1098 --- Order 670359 --- Old bonuses: active=0 inactive=233 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=233 --- Order 670364 --- Old bonuses: active=0 inactive=2467 other=0 Transactions to delete: 0 New bonuses: active=0 inactive=2467 === SUMMARY === old_active_bonus: 65522 old_inactive_bonus: 23511 old_other_bonus: 77377 new_active_bonus: 53320 new_inactive_bonus: 30964 orders_processed: 47 new_bonus_rows: 54 deleted_old_rows: 72 deleted_transactions: 54 activated_new_rows: 34 errors: 0
Пересчёт завершён. Бэкап и отчёт сохранены в /backups/ и /loyalty_recalc_report_*.txt.