Subversion Repositories SmartDukaan

Rev

Rev 32794 | Rev 32817 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 32794 Rev 32795
Line 22... Line 22...
22
import com.spice.profitmandi.common.web.client.RestClient;
22
import com.spice.profitmandi.common.web.client.RestClient;
23
import com.spice.profitmandi.dao.Interface.Campaign;
23
import com.spice.profitmandi.dao.Interface.Campaign;
24
import com.spice.profitmandi.dao.cart.CartService;
24
import com.spice.profitmandi.dao.cart.CartService;
25
import com.spice.profitmandi.dao.entity.auth.AuthUser;
25
import com.spice.profitmandi.dao.entity.auth.AuthUser;
26
import com.spice.profitmandi.dao.entity.auth.PartnerCollectionRemark;
26
import com.spice.profitmandi.dao.entity.auth.PartnerCollectionRemark;
27
import com.spice.profitmandi.dao.entity.catalog.FocusedModel;
-
 
28
import com.spice.profitmandi.dao.entity.catalog.Item;
27
import com.spice.profitmandi.dao.entity.catalog.*;
29
import com.spice.profitmandi.dao.entity.catalog.Scheme;
-
 
30
import com.spice.profitmandi.dao.entity.catalog.TagListing;
-
 
31
import com.spice.profitmandi.dao.entity.cs.Position;
28
import com.spice.profitmandi.dao.entity.cs.Position;
32
import com.spice.profitmandi.dao.entity.cs.Ticket;
29
import com.spice.profitmandi.dao.entity.cs.Ticket;
33
import com.spice.profitmandi.dao.entity.dtr.User;
30
import com.spice.profitmandi.dao.entity.dtr.User;
34
import com.spice.profitmandi.dao.entity.dtr.*;
31
import com.spice.profitmandi.dao.entity.dtr.*;
35
import com.spice.profitmandi.dao.entity.fofo.*;
32
import com.spice.profitmandi.dao.entity.fofo.*;
Line 37... Line 34...
37
import com.spice.profitmandi.dao.entity.transaction.*;
34
import com.spice.profitmandi.dao.entity.transaction.*;
38
import com.spice.profitmandi.dao.entity.user.*;
35
import com.spice.profitmandi.dao.entity.user.*;
39
import com.spice.profitmandi.dao.entity.warehouse.WarehouseInventoryItem;
36
import com.spice.profitmandi.dao.entity.warehouse.WarehouseInventoryItem;
40
import com.spice.profitmandi.dao.entity.warehouse.WarehouseScan;
37
import com.spice.profitmandi.dao.entity.warehouse.WarehouseScan;
41
import com.spice.profitmandi.dao.enumuration.auth.CollectionRemark;
38
import com.spice.profitmandi.dao.enumuration.auth.CollectionRemark;
-
 
39
import com.spice.profitmandi.dao.enumuration.catalog.OfferSchemeType;
42
import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;
40
import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;
43
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
41
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
44
import com.spice.profitmandi.dao.enumuration.dtr.RefferalStatus;
42
import com.spice.profitmandi.dao.enumuration.dtr.RefferalStatus;
45
import com.spice.profitmandi.dao.enumuration.fofo.Gateway;
43
import com.spice.profitmandi.dao.enumuration.fofo.Gateway;
46
import com.spice.profitmandi.dao.enumuration.fofo.PaymentStatus;
44
import com.spice.profitmandi.dao.enumuration.fofo.PaymentStatus;
Line 75... Line 73...
75
import com.spice.profitmandi.service.pricing.PriceDropService;
73
import com.spice.profitmandi.service.pricing.PriceDropService;
76
import com.spice.profitmandi.service.recharge.provider.OxigenRechargeProviderService;
74
import com.spice.profitmandi.service.recharge.provider.OxigenRechargeProviderService;
77
import com.spice.profitmandi.service.recharge.provider.ThinkWalnutDigitalRechargeProviderService;
75
import com.spice.profitmandi.service.recharge.provider.ThinkWalnutDigitalRechargeProviderService;
78
import com.spice.profitmandi.service.scheme.SchemeService;
76
import com.spice.profitmandi.service.scheme.SchemeService;
79
import com.spice.profitmandi.service.serviceConfig.ServiceConfigService;
77
import com.spice.profitmandi.service.serviceConfig.ServiceConfigService;
-
 
78
import com.spice.profitmandi.service.smartping.SmartPingService;
80
import com.spice.profitmandi.service.transaction.CreditNoteService;
79
import com.spice.profitmandi.service.transaction.CreditNoteService;
81
import com.spice.profitmandi.service.transaction.SDCreditService;
80
import com.spice.profitmandi.service.transaction.SDCreditService;
82
import com.spice.profitmandi.service.transaction.TransactionService;
81
import com.spice.profitmandi.service.transaction.TransactionService;
83
import com.spice.profitmandi.service.user.RetailerService;
82
import com.spice.profitmandi.service.user.RetailerService;
84
import com.spice.profitmandi.service.wallet.CommonPaymentService;
83
import com.spice.profitmandi.service.wallet.CommonPaymentService;
Line 151... Line 150...
151
 
150
 
152
    @Autowired
151
    @Autowired
153
    PurchaseMigration purchaseMigration;
152
    PurchaseMigration purchaseMigration;
154
 
153
 
155
    @Autowired
154
    @Autowired
-
 
155
    SmartPingService smartPingService;
-
 
156
 
-
 
157
    @Autowired
156
    private RegionRepository regionRepository;
158
    private RegionRepository regionRepository;
157
 
159
 
158
    @Autowired
160
    @Autowired
159
    private ServiceConfigService serviceConfigService;
161
    private ServiceConfigService serviceConfigService;
160
 
162
 
Line 1004... Line 1006...
1004
    PurchaseReturnService purchaseReturnService;
1006
    PurchaseReturnService purchaseReturnService;
1005
 
1007
 
1006
    @Autowired
1008
    @Autowired
1007
    JavaMailSender javaMailSender;
1009
    JavaMailSender javaMailSender;
1008
 
1010
 
-
 
1011
    @Autowired
-
 
1012
    OfferPayoutRepository offerPayoutRepository;
-
 
1013
 
-
 
1014
    @Autowired
-
 
1015
    OfferRepository offerRepository;
-
 
1016
 
1009
    public void test() throws Exception {
1017
    public void test() throws Exception {
-
 
1018
        List<Long> payoutIds = Arrays.asList(116110, 116111, 116112, 116113, 116113, 116115, 116116, 116117, 116118, 116119, 116552, 116918, 116919, 116920, 116921, 116922, 116923, 116924, 116925, 116926, 116927, 116928, 116929, 116930, 116931, 116932, 116933, 116934, 116935, 116936, 116937, 116938, 116939, 116940, 116941, 116942, 116943, 116944, 116945, 116946, 116947, 117418, 117432, 117433, 117622, 117623, 117624, 117625, 117626, 117627, 117628, 117629, 117631, 117640, 117641, 132798, 132799, 132800, 132801, 132802, 132832, 132833, 132837, 132838, 132839, 132840, 133001, 133002, 133003, 133004, 133005, 133006, 133007, 133008, 133009, 133010, 133011, 133012, 133013, 133014, 133015, 133016, 133017, 133018, 133019, 133024, 133025, 133026, 133027, 133028, 133029, 133030, 133031, 133032, 133033, 133034, 133035, 133036, 133037, 133038, 133094, 133095, 133096, 133097, 133098, 133099, 133100, 133101, 133102, 133103, 133104, 133105, 133106, 133107, 133108, 133109, 133110, 133111, 133112, 133113, 133114, 133115, 133116, 133117, 133118, 133119, 133120, 133121, 133122, 133123, 133124, 133125, 133126, 133127, 133128, 133129, 133130, 133131, 133132, 133133, 133134, 133135, 133136, 133137, 133138, 133139, 133140, 133141, 133142, 133143, 133144, 133145, 133146, 133147, 133148, 133149, 133150, 133151, 133152, 133153, 133154, 133155, 133156, 133157, 133158, 133159, 133160, 133161, 133162, 133163, 133164, 133165, 133166, 133167, 133168, 133169, 133170, 133171, 133172, 133173, 133174, 133175, 133176, 133177, 133178, 133179, 133180, 133181, 133182, 133183, 133184, 133185, 133186, 133187, 133188, 133189, 133190, 133191, 133192, 133193, 133194, 133195, 133506, 133507, 133508, 133509, 133510, 133511, 133512, 133513, 133514, 133519, 133520, 133521, 133522, 133523, 133524, 133525, 133526, 133527, 133528, 133530, 133533, 133534, 133535, 133539, 133540, 133543, 133545, 133546, 133547, 133549, 133550, 133551, 133553, 133555, 133556, 133557, 133558, 133559, 133560, 133561, 133562, 133563, 133564, 133565, 133566, 133567, 133568, 133569, 133570, 133571, 133572, 133573, 133574, 133575, 133576, 133577, 133578, 133579, 133580, 133581, 133582, 133583, 133584, 133585, 133586, 133587, 133588, 133589, 133590, 133591, 133592, 133593, 133594, 133595, 133596, 133597, 133598, 133599, 133600, 133601, 133602, 133603, 133604, 133605, 133606, 133607, 133608, 133609, 133610, 133611, 133612, 133613, 133614, 133615, 133616, 133617, 133618, 133619, 133620, 133621, 133622, 133623, 133624, 133625, 133626, 133627, 133628, 133629, 133630, 133631, 133632, 133633, 133634, 133635, 133636, 133637, 133638, 133639, 133640, 133641, 133642, 133643, 133644, 133645, 133646, 133647, 133648, 133649, 133650, 133651, 133652, 133653, 133654, 133655, 133656, 133657, 133658, 133659, 133660, 133661, 133662, 133663, 133664, 133665, 133666, 133667, 133668, 133669, 133670, 133671, 133672, 133673, 133674, 133675, 133676, 133677, 133678, 133679, 133680, 133681, 133682, 133683, 133684, 133685, 133686, 133687, 133688, 133689, 133690, 133691, 133692, 133693, 133694, 133695, 133696, 133697, 133698, 133699, 133700, 133701, 133702, 133703, 133704, 133705, 133706, 133707, 133708, 133709, 133710, 133711, 133712, 133713, 133714, 133715, 133716, 133717, 133718, 133719, 133720, 133721, 133722, 133723, 133724, 133725, 133726, 133727, 133728, 133729, 133730, 133731, 133732, 133733, 133734, 133735, 133736, 133737, 133738, 133739, 133740, 133741, 133742, 133743, 133744, 133745, 133746, 133747, 133748, 133749, 133750, 133751, 133752, 133753, 133754, 133755, 133756, 133757, 133758, 133858, 133859, 133860, 133861, 133862, 133863, 133864, 133865, 133866, 133867, 133868, 133869, 133870, 133871, 133872, 133873, 133874, 133875, 133876, 133877, 133878, 133879, 133880, 133881, 133882, 133883, 133884, 133885, 133886, 133887, 133888, 133889, 133890, 133891, 133892, 133893, 133894, 133895, 133896, 133897, 133898, 133899, 133900, 133901, 133902, 133903, 133904, 133905, 133906, 133907, 133908, 133909, 133910, 133911, 133912, 133913, 133914, 133915, 133916, 133917, 133918, 133919, 133920, 133921, 133922, 133923, 133924, 133925, 133926, 133927, 133928, 133929, 133930, 133931, 133932, 133933, 133934, 133935, 133936, 133937, 133938, 133939, 133940, 133941, 133942, 133943, 133944, 133945, 133946, 133947, 133948, 133949, 133950, 133951, 133952, 133953, 133954, 133955, 133956, 133957, 133958, 133959, 133960, 133961, 133962, 133963, 134146, 134147, 134148, 134149, 134150, 134151, 134152, 134153, 134155, 134156, 134159, 134163, 134164, 134166, 134167, 134169, 134170, 134173, 134175, 134177, 134180, 134181, 134182, 134184, 134188, 134190, 134191, 134192, 134193, 134197, 134198, 134199, 134203, 134207, 134208, 134211, 134213, 134216, 134218, 134219, 134220, 134221, 134223, 134229, 134231, 134232, 134234, 134242, 134246, 134247, 134248, 134252, 134253, 134254, 134255, 134257, 134258, 134259, 134260, 134261, 134262, 134263, 134264, 134265, 134266, 134267, 134268, 134269, 134270, 134271, 134272, 134273, 134274, 134275, 134276, 134277, 134278, 134279, 134280, 134281, 134282, 134283, 134284, 134285, 134286, 134287, 134288, 134289, 134290, 134291, 134292, 134293, 134294, 134295, 134296, 134297, 134298, 134299, 134300, 134301, 134302, 134303, 134304, 134305, 134306, 134307, 134308, 134309, 134310, 134311, 134312, 134313, 134314, 134315, 134316, 134317, 134318, 134319, 134320, 134321, 134322, 134323, 134324, 134325, 134326, 134327, 134328, 134329, 134330, 134331, 134332, 134333, 134334, 134335, 134336, 134337, 134338, 134339, 134340, 134341, 134342, 134343, 134344, 134345, 134346, 134347, 134348, 134349, 134350, 134356, 134357, 134358, 134449, 134450, 134451, 134452, 134462, 134463, 134464, 134465, 134466, 134467, 134468, 134469, 134470, 134471, 134472, 134473, 134474, 134475, 134476, 134477, 134478, 134478).stream().map(x->(long)x).collect(Collectors.toList());
-
 
1019
        List<OfferPayout> offerPayouts = offerPayoutRepository.selectAllByIds(payoutIds);
-
 
1020
        Map<Integer, List<OfferPayout>> offerPayoutMap = offerPayouts.stream().collect(Collectors.groupingBy(x -> (int) x.getOfferId()));
-
 
1021
        for (Map.Entry<Integer, List<OfferPayout>> offerPayoutEntry : offerPayoutMap.entrySet()) {
-
 
1022
            int offerId = offerPayoutEntry.getKey();
-
 
1023
            List<OfferPayout> offerPayoutList = offerPayoutEntry.getValue();
-
 
1024
            Map<Integer, List<OfferPayout>> partnerOfferPayoutMap = offerPayoutList.stream().collect(Collectors.groupingBy(x -> (int) x.getFofoId()));
-
 
1025
            for (Entry<Integer, List<OfferPayout>> partnerOfferPayoutEntry : partnerOfferPayoutMap.entrySet()) {
-
 
1026
                int fofoId = partnerOfferPayoutEntry.getKey();
-
 
1027
                List<OfferPayout> partnerPayouts = partnerOfferPayoutEntry.getValue();
-
 
1028
                float amount = 0;
-
 
1029
                for (OfferPayout offerPayout : partnerPayouts) {
-
 
1030
                    amount += offerPayout.getAmount();
-
 
1031
                    offerPayout.setStatus(SchemePayoutStatus.REJECTED);
-
 
1032
                    offerPayout.setRejectTimestamp(LocalDateTime.now());
-
 
1033
                }
-
 
1034
                walletService.rollbackAmountFromWallet(fofoId, amount, offerId,
-
 
1035
                        WalletReferenceType.ADDITIONAL_SCHEME, "Imeis returned - " + partnerPayouts.size() + "pc(s)", LocalDateTime.now());
-
 
1036
            }
-
 
1037
        }
-
 
1038
    }
-
 
1039
 
-
 
1040
    public void test1() throws Exception {
1010
        System.out.println("Hello from test");
1041
        System.out.println("Hello from test");
1011
        //this.calculateInterestAccured();
1042
        //this.calculateInterestAccured();
1012
        //sendMailOfHtmlFormat(javaMailSender, new String[]{"amit.gupta@smartdukaan.com"}, "hello", null, "Hello");
1043
        //sendMailOfHtmlFormat(javaMailSender, new String[]{"amit.gupta@smartdukaan.com"}, "hello", null, "Hello");
1013
        //priceDropService.rejectPriceDropsOfApprovedImeis();
1044
        //priceDropService.rejectPriceDropsOfApprovedImeis();
1014
        //Create return
1045
        //Create return
1015
        //this.updatePartnerLimit();
1046
        //this.updatePartnerLimit();
1016
        //creditNoteService.sendCnMails(YearMonth.now().minusMonths(2));
1047
        //creditNoteService.sendCnMails(YearMonth.now().minusMonths(2));
1017
        //orderService.createMissingScratchOffers();
1048
        //orderService.createMissingScratchOffers();
1018
        LocalDateTime debitNoteDate = LocalDate.of(2023, Month.SEPTEMBER, 30).atStartOfDay();
1049
        LocalDateTime debitNoteDate = LocalDate.of(2023, Month.SEPTEMBER, 30).atStartOfDay();
-
 
1050
        System.out.println(smartPingService.getAllAgents());
1019
        Map<Integer, Set<String>> fofoIdImeiReturnMap = new LinkedHashMap<>();
1051
        Map<Integer, Set<String>> fofoIdImeiReturnMap = new LinkedHashMap<>();
1020
        fofoIdImeiReturnMap.put(167996137,new HashSet<>(Arrays.asList("357415663618188","357415663627767","866399066670844","866399066672022","866399066715284","866399066718205","866399066721126","866399066725069","869350065039538","869350065061318","869350065067596","869350065068016","869350065068974","869350065086794","869350065090317","869350065094558","869350065098435","869350065136177","869350065155391")));
1052
        fofoIdImeiReturnMap.put(167996137, new HashSet<>(Arrays.asList("357415663618188", "357415663627767", "866399066670844", "866399066672022", "866399066715284", "866399066718205", "866399066721126", "866399066725069", "869350065039538", "869350065061318", "869350065067596", "869350065068016", "869350065068974", "869350065086794", "869350065090317", "869350065094558", "869350065098435", "869350065136177", "869350065155391")));
1021
        fofoIdImeiReturnMap.put(175135227,new HashSet<>(Arrays.asList("356612600793998","356612600803870","359691642134905","359691642145604","862628060221475","863879060089334","864985065856988","865210064246753","865753067332328","865753069773248","866399065879826","866399066626606","866399066664540","866399066734129","866807068958710","867158063179137","868905064220974","868905065216294","869350065013970","869350065182791")));
1053
        fofoIdImeiReturnMap.put(175135227, new HashSet<>(Arrays.asList("356612600793998", "356612600803870", "359691642134905", "359691642145604", "862628060221475", "863879060089334", "864985065856988", "865210064246753", "865753067332328", "865753069773248", "866399065879826", "866399066626606", "866399066664540", "866399066734129", "866807068958710", "867158063179137", "868905064220974", "868905065216294", "869350065013970", "869350065182791")));
1022
        fofoIdImeiReturnMap.put(175138674,new HashSet<>(Arrays.asList("861831062447822","864920066684790","865753067320703","865753069672200","866807064015176","868905064555858","869916067520178","869916067520632")));
1054
        fofoIdImeiReturnMap.put(175138674, new HashSet<>(Arrays.asList("861831062447822", "864920066684790", "865753067320703", "865753069672200", "866807064015176", "868905064555858", "869916067520178", "869916067520632")));
1023
        fofoIdImeiReturnMap.put(175138823,new HashSet<>(Arrays.asList("861530062830587","861530063587103","861530063599348","861679065410440","864985066215804","864985066876621","865210065762170")));
1055
        fofoIdImeiReturnMap.put(175138823, new HashSet<>(Arrays.asList("861530062830587", "861530063587103", "861530063599348", "861679065410440", "864985066215804", "864985066876621", "865210065762170")));
1024
        fofoIdImeiReturnMap.put(175138863,new HashSet<>(Arrays.asList("356393508712964","356393508722468","356393508722823","356393508723342","356393508723383","356393508724720","356393508728820","356393508744124","356393508745527","356393508747341","356393508748760","356393508759668","356393508762829","356393508775607","356393508793485","356393509343983","356393509344924","356393509345723","356393509351200","356393509352489","356612600709275","356612600709317","356612600712238","356612600713210","356612600716791","356612600719654","356612600720215","356612600720694","356612600721353","356612600721734","356612600722690","356612600722815","356612600724753","356612600725511","356612600725792","356612600726378","356612600726899","356612600727673","356612600727996","356612600730719","356612600733291","356612600733770","356612600733952","356612600737532","356612600738217","356612600738530","356612600740395","356612600747192","356612600748778","356612600749438","356612600750154","356612600752218","356612600752739","356612600756011","356612600757738","356612600758256","356612600758470","356612600758850","356612600758876","356612600761573","356612600804555","356612600812210","356612600817938","356612600824231","356612600826178","356612600827010","356612600827135","356612600827234","356612600827713","356612600829511","356612600829974","356612600830816","356612600830873","356612600831517","356612600833158","356612600834651","356612600836094","356612600837555","356612600928594","356612600930459","356612600942892","356612600959219","356612600965877","356612600966974","356612600967378","356612600969135","356612600973194","356612600974192","356612600974739","356612600975017","356612600975553","356612600977435","356612600980751","356612600980876","356612600981411","356612600981932","356612600981973","356612604433070","356612604454373","356612604455479","356612604455750","356612605269556","356612605278318","356612605280736","356612605281130","356612605286410","356612605289455","356612605289679","356612605290438","356612605290933","356612605291394","356612605292152","356612605293697","356612605294091","356612605294455","356612605294554","356612605295254","356612605296559","356612605296575","356612605296633","356612605297110","356612605710179","356612605715095","356612605716911","356612605717919","356612605718412","356612605718495","356612605718636","356612605718651","356612605718776","356612605718818","356612605718834","356612605718859","356612605718891","356612605718917","356612605718933","356612605718990","356612605719139","356612605719212","356612605719253","356612605719410","357014953177490","357014953186731","357014953187713","357014953187754","357014953188810","357014953189099","357014953189412","357014953189917","357014953190071","357014953191392","357014953191871","357014953191897","357014953191913","357014953191970","357014953192291","357014953192556","357014953193018","357014953193091","357014953193174","357014953193356","358382747351997","358382747523579","358382747523975","358382747555217","358382747557916","358382747572691","358382747573152","358382747575231","358382747575579","358382747575652","358382747576395","358382747576510","358382747576619","358382747576692","358382747576759","358382747576791","358382747576973","358382747576999","358382747577138","358382747577377","358382747577690","358382747577856","358382747578276","358382747578292","358382747584373","358382747584514","359197382621184","359197382647106","359197382647387","359197382648427","359197382648443")));
1056
        fofoIdImeiReturnMap.put(175138863, new HashSet<>(Arrays.asList("356393508712964", "356393508722468", "356393508722823", "356393508723342", "356393508723383", "356393508724720", "356393508728820", "356393508744124", "356393508745527", "356393508747341", "356393508748760", "356393508759668", "356393508762829", "356393508775607", "356393508793485", "356393509343983", "356393509344924", "356393509345723", "356393509351200", "356393509352489", "356612600709275", "356612600709317", "356612600712238", "356612600713210", "356612600716791", "356612600719654", "356612600720215", "356612600720694", "356612600721353", "356612600721734", "356612600722690", "356612600722815", "356612600724753", "356612600725511", "356612600725792", "356612600726378", "356612600726899", "356612600727673", "356612600727996", "356612600730719", "356612600733291", "356612600733770", "356612600733952", "356612600737532", "356612600738217", "356612600738530", "356612600740395", "356612600747192", "356612600748778", "356612600749438", "356612600750154", "356612600752218", "356612600752739", "356612600756011", "356612600757738", "356612600758256", "356612600758470", "356612600758850", "356612600758876", "356612600761573", "356612600804555", "356612600812210", "356612600817938", "356612600824231", "356612600826178", "356612600827010", "356612600827135", "356612600827234", "356612600827713", "356612600829511", "356612600829974", "356612600830816", "356612600830873", "356612600831517", "356612600833158", "356612600834651", "356612600836094", "356612600837555", "356612600928594", "356612600930459", "356612600942892", "356612600959219", "356612600965877", "356612600966974", "356612600967378", "356612600969135", "356612600973194", "356612600974192", "356612600974739", "356612600975017", "356612600975553", "356612600977435", "356612600980751", "356612600980876", "356612600981411", "356612600981932", "356612600981973", "356612604433070", "356612604454373", "356612604455479", "356612604455750", "356612605269556", "356612605278318", "356612605280736", "356612605281130", "356612605286410", "356612605289455", "356612605289679", "356612605290438", "356612605290933", "356612605291394", "356612605292152", "356612605293697", "356612605294091", "356612605294455", "356612605294554", "356612605295254", "356612605296559", "356612605296575", "356612605296633", "356612605297110", "356612605710179", "356612605715095", "356612605716911", "356612605717919", "356612605718412", "356612605718495", "356612605718636", "356612605718651", "356612605718776", "356612605718818", "356612605718834", "356612605718859", "356612605718891", "356612605718917", "356612605718933", "356612605718990", "356612605719139", "356612605719212", "356612605719253", "356612605719410", "357014953177490", "357014953186731", "357014953187713", "357014953187754", "357014953188810", "357014953189099", "357014953189412", "357014953189917", "357014953190071", "357014953191392", "357014953191871", "357014953191897", "357014953191913", "357014953191970", "357014953192291", "357014953192556", "357014953193018", "357014953193091", "357014953193174", "357014953193356", "358382747351997", "358382747523579", "358382747523975", "358382747555217", "358382747557916", "358382747572691", "358382747573152", "358382747575231", "358382747575579", "358382747575652", "358382747576395", "358382747576510", "358382747576619", "358382747576692", "358382747576759", "358382747576791", "358382747576973", "358382747576999", "358382747577138", "358382747577377", "358382747577690", "358382747577856", "358382747578276", "358382747578292", "358382747584373", "358382747584514", "359197382621184", "359197382647106", "359197382647387", "359197382648427", "359197382648443")));
1025
        fofoIdImeiReturnMap.put(175138870,new HashSet<>(Arrays.asList("350923627169328","350923627198863","350923627875049","351336673336049","351336673340546","355724848495830","355724848499154","356455410153452","356455410159277","356612605719956","356612605720194","359508181975748","359508182024801","359691642145406","861831062564667","861831062599507","861831062599762","865753069263646","865753069651063","865821064720405","865821064760781","865821065335666","866399065697467","866399065730789","866399065732082","869350061853536","869350061926514","869350062669832","869350062681233","869350062681373","869350062684294")));
1057
        fofoIdImeiReturnMap.put(175138870, new HashSet<>(Arrays.asList("350923627169328", "350923627198863", "350923627875049", "351336673336049", "351336673340546", "355724848495830", "355724848499154", "356455410153452", "356455410159277", "356612605719956", "356612605720194", "359508181975748", "359508182024801", "359691642145406", "861831062564667", "861831062599507", "861831062599762", "865753069263646", "865753069651063", "865821064720405", "865821064760781", "865821065335666", "866399065697467", "866399065730789", "866399065732082", "869350061853536", "869350061926514", "869350062669832", "869350062681233", "869350062681373", "869350062684294")));
1026
        fofoIdImeiReturnMap.put(175138942,new HashSet<>(Arrays.asList("350031479190473","350250293972177","350250293974942","353140544973073","353397823400224","353397824106911","353397824214244","359118661998473")));
1058
        fofoIdImeiReturnMap.put(175138942, new HashSet<>(Arrays.asList("350031479190473", "350250293972177", "350250293974942", "353140544973073", "353397823400224", "353397824106911", "353397824214244", "359118661998473")));
1027
        fofoIdImeiReturnMap.put(175139107,new HashSet<>(Arrays.asList("351733712184093","351733712368928","353140545077080","353140545590280")));
1059
        fofoIdImeiReturnMap.put(175139107, new HashSet<>(Arrays.asList("351733712184093", "351733712368928", "353140545077080", "353140545590280")));
1028
        fofoIdImeiReturnMap.put(175139176,new HashSet<>(Arrays.asList("359691642003241","359691642003506","359691642010907","359691642019742","359691642061785","359691642068624","359691642076148","359691642083284","359691642115706","359691642115888","359691642134921","359691642137346","359691642137882","359691642138443","359691642141561","359691642141660","359691642141868","359691642142288","359691642144508","359691642144904","359691642146545","359691642147725","359691642151404","359691642151727","359691642152808","359691642179207","359691642179629","866807067510173","866807067519232","869296069014474","869296069015158","869296069020299","869296069020596","869296069021271")));
1060
        fofoIdImeiReturnMap.put(175139176, new HashSet<>(Arrays.asList("359691642003241", "359691642003506", "359691642010907", "359691642019742", "359691642061785", "359691642068624", "359691642076148", "359691642083284", "359691642115706", "359691642115888", "359691642134921", "359691642137346", "359691642137882", "359691642138443", "359691642141561", "359691642141660", "359691642141868", "359691642142288", "359691642144508", "359691642144904", "359691642146545", "359691642147725", "359691642151404", "359691642151727", "359691642152808", "359691642179207", "359691642179629", "866807067510173", "866807067519232", "869296069014474", "869296069015158", "869296069020299", "869296069020596", "869296069021271")));
1029
        fofoIdImeiReturnMap.put(175139180,new HashSet<>(Arrays.asList("865279060303819","865279060948159","866399065674821","866399065696840","866399065701541","866559062503097","866807064663835","866807064664536","866807064664577","866807064683379","866807065123896","869236065764458","869236065883670")));
1061
        fofoIdImeiReturnMap.put(175139180, new HashSet<>(Arrays.asList("865279060303819", "865279060948159", "866399065674821", "866399065696840", "866399065701541", "866559062503097", "866807064663835", "866807064664536", "866807064664577", "866807064683379", "866807065123896", "869236065764458", "869236065883670")));
1030
        fofoIdImeiReturnMap.put(175139187,new HashSet<>(Arrays.asList("351166973169331","351166973171592","356393509346663","356393509355805","356612604544991","356612604545691","357014954899233","357014954901153","357014954934873","357014954935672","357014954937231","357014954937678","357014954938890","359197382629682","359197382647866","359197382647882","359691642142205","862628068228175","863879068173957","864985065825629","866399066067009","866399066075705","866641067104095","867158061549711","867492061861176")));
1062
        fofoIdImeiReturnMap.put(175139187, new HashSet<>(Arrays.asList("351166973169331", "351166973171592", "356393509346663", "356393509355805", "356612604544991", "356612604545691", "357014954899233", "357014954901153", "357014954934873", "357014954935672", "357014954937231", "357014954937678", "357014954938890", "359197382629682", "359197382647866", "359197382647882", "359691642142205", "862628068228175", "863879068173957", "864985065825629", "866399066067009", "866399066075705", "866641067104095", "867158061549711", "867492061861176")));
1031
        fofoIdImeiReturnMap.put(175139223,new HashSet<>(Arrays.asList("350250293971054","353140545612282","863879062572436","864920063982718","864987060011015")));
1063
        fofoIdImeiReturnMap.put(175139223, new HashSet<>(Arrays.asList("350250293971054", "353140545612282", "863879062572436", "864920063982718", "864987060011015")));
1032
        fofoIdImeiReturnMap.put(175139242,new HashSet<>(Arrays.asList("862628066855359","862628068472815","863879060436170","863879061140474","864690068767337","864920067190219")));
1064
        fofoIdImeiReturnMap.put(175139242, new HashSet<>(Arrays.asList("862628066855359", "862628068472815", "863879060436170", "863879061140474", "864690068767337", "864920067190219")));
1033
        fofoIdImeiReturnMap.put(175139261,new HashSet<>(Arrays.asList("865037063916197","865037063921239","866807066673311")));
1065
        fofoIdImeiReturnMap.put(175139261, new HashSet<>(Arrays.asList("865037063916197", "865037063921239", "866807066673311")));
1034
        fofoIdImeiReturnMap.put(175139295,new HashSet<>(Arrays.asList("353305256516622","353305256517703","354849877296808","354849877299240","359691642157203","359691642159746","359691642167608","860374069783197","861530062947282","864985066061448","866399062765986","866399065001280","866399066743625","866726066870570","866807064443717","866807064654396")));
1066
        fofoIdImeiReturnMap.put(175139295, new HashSet<>(Arrays.asList("353305256516622", "353305256517703", "354849877296808", "354849877299240", "359691642157203", "359691642159746", "359691642167608", "860374069783197", "861530062947282", "864985066061448", "866399062765986", "866399065001280", "866399066743625", "866726066870570", "866807064443717", "866807064654396")));
1035
        fofoIdImeiReturnMap.put(175139328,new HashSet<>(Arrays.asList("861784060313035","862628068090153","862628068262117","863879062228856","863879062320554","864985062056681","864985062215402","865210064597296","865210065180431","866132066506233")));
1067
        fofoIdImeiReturnMap.put(175139328, new HashSet<>(Arrays.asList("861784060313035", "862628068090153", "862628068262117", "863879062228856", "863879062320554", "864985062056681", "864985062215402", "865210064597296", "865210065180431", "866132066506233")));
1036
        fofoIdImeiReturnMap.put(175139329,new HashSet<>(Arrays.asList("351733714004521","359118663635321","865279064602331","866399062751085","866399062758882")));
1068
        fofoIdImeiReturnMap.put(175139329, new HashSet<>(Arrays.asList("351733714004521", "359118663635321", "865279064602331", "866399062751085", "866399062758882")));
1037
        fofoIdImeiReturnMap.put(175139333,new HashSet<>(Arrays.asList("864985062090243","864985065791169","864985065840040","864985065844984","866399065642240","866399066060848","866399066707505","866399066753624","869350061832191","869350061851415","869350062255178","869350062608657")));
1069
        fofoIdImeiReturnMap.put(175139333, new HashSet<>(Arrays.asList("864985062090243", "864985065791169", "864985065840040", "864985065844984", "866399065642240", "866399066060848", "866399066707505", "866399066753624", "869350061832191", "869350061851415", "869350062255178", "869350062608657")));
1038
        fofoIdImeiReturnMap.put(175139364,new HashSet<>(Arrays.asList("353305256533601","353305256536968","359691642106465","359691642139300","359749531615929","862628066855631","863653060019751","863653060270255","863879060439919","865279066559992","865821063929064","865821064323424","866807065289937","867158060809637","868666068787083","868905064544076")));
1070
        fofoIdImeiReturnMap.put(175139364, new HashSet<>(Arrays.asList("353305256533601", "353305256536968", "359691642106465", "359691642139300", "359749531615929", "862628066855631", "863653060019751", "863653060270255", "863879060439919", "865279066559992", "865821063929064", "865821064323424", "866807065289937", "867158060809637", "868666068787083", "868905064544076")));
1039
        fofoIdImeiReturnMap.put(175139372,new HashSet<>(Arrays.asList("351166972285419","351166975524178","351166976059059","351166976064158","351166976067094","357014952943934","357014952944353","357014952945574","357014952949154","357014952949196","357014952950657","357014952951937","357014952952950","357014952953214","357014952953750","357014952953990","357014952954550","357014953188570","357014953189578","357014953190576","357014953191152","357014953191236","357014953192572","357014953192796","357014953193836","864985061925787","864985061993587")));
1071
        fofoIdImeiReturnMap.put(175139372, new HashSet<>(Arrays.asList("351166972285419", "351166975524178", "351166976059059", "351166976064158", "351166976067094", "357014952943934", "357014952944353", "357014952945574", "357014952949154", "357014952949196", "357014952950657", "357014952951937", "357014952952950", "357014952953214", "357014952953750", "357014952953990", "357014952954550", "357014953188570", "357014953189578", "357014953190576", "357014953191152", "357014953191236", "357014953192572", "357014953192796", "357014953193836", "864985061925787", "864985061993587")));
1040
        fofoIdImeiReturnMap.put(175139386,new HashSet<>(Arrays.asList("350250292546261","350250293896210","350386305533381","352450543770565","353397822543180","357014953173978","359749531155942","863879068182354","865037067599551","867492060235059","869350061949755")));
1072
        fofoIdImeiReturnMap.put(175139386, new HashSet<>(Arrays.asList("350250292546261", "350250293896210", "350386305533381", "352450543770565", "353397822543180", "357014953173978", "359749531155942", "863879068182354", "865037067599551", "867492060235059", "869350061949755")));
1041
        fofoIdImeiReturnMap.put(175139390,new HashSet<>(Arrays.asList("350339951003118","352450548485607","353397824198728","353397824258225","354849877087843","354849877105843","354849877151664","354849877296162","860607069060599","863879062659092","864848067855947","865037065956555","865865062255872","866807066486896","866807068958298","868701069311433","868905064220750","869076064654809","869350062196075","869350062666473")));
1073
        fofoIdImeiReturnMap.put(175139390, new HashSet<>(Arrays.asList("350339951003118", "352450548485607", "353397824198728", "353397824258225", "354849877087843", "354849877105843", "354849877151664", "354849877296162", "860607069060599", "863879062659092", "864848067855947", "865037065956555", "865865062255872", "866807066486896", "866807068958298", "868701069311433", "868905064220750", "869076064654809", "869350062196075", "869350062666473")));
1042
        fofoIdImeiReturnMap.put(175139392,new HashSet<>(Arrays.asList("354301731104828","354301731181784","860398069424833","861784061894090","864480066119602","864480066130047","866399065988924","866399066060061","866807064683999","867158060809975","867492060235752")));
1074
        fofoIdImeiReturnMap.put(175139392, new HashSet<>(Arrays.asList("354301731104828", "354301731181784", "860398069424833", "861784061894090", "864480066119602", "864480066130047", "866399065988924", "866399066060061", "866807064683999", "867158060809975", "867492060235752")));
1043
        fofoIdImeiReturnMap.put(175139396,new HashSet<>(Arrays.asList("350339951029758","864848067933108","864848067965860","865279060304411","865753067321909","865753068700747","866399066669069","866399066721365","869076064651763","869350061904495","869350062192991")));
1075
        fofoIdImeiReturnMap.put(175139396, new HashSet<>(Arrays.asList("350339951029758", "864848067933108", "864848067965860", "865279060304411", "865753067321909", "865753068700747", "866399066669069", "866399066721365", "869076064651763", "869350061904495", "869350062192991")));
1044
        fofoIdImeiReturnMap.put(175139404,new HashSet<>(Arrays.asList("352450544013585","352450544013940","352450544014344","352450547322587","352450547322744","358142883505941","359749531269867","868905065214570")));
1076
        fofoIdImeiReturnMap.put(175139404, new HashSet<>(Arrays.asList("352450544013585", "352450544013940", "352450544014344", "352450547322587", "352450547322744", "358142883505941", "359749531269867", "868905065214570")));
1045
        fofoIdImeiReturnMap.put(175139410,new HashSet<>(Arrays.asList("350923626587702","350923626677503","350923626689383","350923627241283","350923627259541","351336673333228","351336673334580","351336673344449","352450544501886","352450545460561","352450545826068","353305256494044","353305256519709","356393509343744","356393509347224","357983840349969","357983840350322","357983840350546","357983840351486","357983840352344","357983840352823","357983840352864","357983840353144","357983840357582","357983840359067","359691642108461","359691642174968","863653061135671","863653061177012","863653062654993","863653062669439","864288064103175","864985065813260","865279063733434","865753069777728","866399065698101","866399065717323","866399065719949","866399065726944")));
1077
        fofoIdImeiReturnMap.put(175139410, new HashSet<>(Arrays.asList("350923626587702", "350923626677503", "350923626689383", "350923627241283", "350923627259541", "351336673333228", "351336673334580", "351336673344449", "352450544501886", "352450545460561", "352450545826068", "353305256494044", "353305256519709", "356393509343744", "356393509347224", "357983840349969", "357983840350322", "357983840350546", "357983840351486", "357983840352344", "357983840352823", "357983840352864", "357983840353144", "357983840357582", "357983840359067", "359691642108461", "359691642174968", "863653061135671", "863653061177012", "863653062654993", "863653062669439", "864288064103175", "864985065813260", "865279063733434", "865753069777728", "866399065698101", "866399065717323", "866399065719949", "866399065726944")));
1046
        fofoIdImeiReturnMap.put(175139422,new HashSet<>(Arrays.asList("351166975963533","351166975976295","354849877717662","354849877719742","354849877726705","354849877729444","354849877729642","354849877730046","354849877730665","354849877731903","354849877734063","354849877743221","355724848410193","355724848412058","355724848423378","355724848425316","355724848425357","355724848426454","355724848426595","355724848426736","355724848426777","355724848428617","356393508695383","356393508713046","356393508722385","356393508722542","356393508727806","356393508733424","356393508736880","356393508737680","356393508738902","356393508768206","356393508768560","356393508773263","356393508796926","356612600716692","356612600735577","356612600736195","356612600736997","356612600740155","356612600742854","356612600743613","356612600746616","356612600747051","356612600748455","356612600926655","356612600928131","356612600928230","356612600929675","356612600934873","356612600936019","356612600943858","356612600945135","356612600947453","356612600949996","356612600951455","356612600951810","356612600953758","356612600956934","356612600962254","356612600963393","356612600963419","356612600981551","356612600983375","356612600983912","359691642043445","359691642047909","359691642049368","359691642051380","359691642089901","359691642114766","359691642135084","359691642135241","359691642141223","359691642144565","359691642145109","359691642152600","359691642153160","359691642155645","359691642156841","861530062172105","861530062174382","864985065768787","864985065792944","866807064663710")));
1078
        fofoIdImeiReturnMap.put(175139422, new HashSet<>(Arrays.asList("351166975963533", "351166975976295", "354849877717662", "354849877719742", "354849877726705", "354849877729444", "354849877729642", "354849877730046", "354849877730665", "354849877731903", "354849877734063", "354849877743221", "355724848410193", "355724848412058", "355724848423378", "355724848425316", "355724848425357", "355724848426454", "355724848426595", "355724848426736", "355724848426777", "355724848428617", "356393508695383", "356393508713046", "356393508722385", "356393508722542", "356393508727806", "356393508733424", "356393508736880", "356393508737680", "356393508738902", "356393508768206", "356393508768560", "356393508773263", "356393508796926", "356612600716692", "356612600735577", "356612600736195", "356612600736997", "356612600740155", "356612600742854", "356612600743613", "356612600746616", "356612600747051", "356612600748455", "356612600926655", "356612600928131", "356612600928230", "356612600929675", "356612600934873", "356612600936019", "356612600943858", "356612600945135", "356612600947453", "356612600949996", "356612600951455", "356612600951810", "356612600953758", "356612600956934", "356612600962254", "356612600963393", "356612600963419", "356612600981551", "356612600983375", "356612600983912", "359691642043445", "359691642047909", "359691642049368", "359691642051380", "359691642089901", "359691642114766", "359691642135084", "359691642135241", "359691642141223", "359691642144565", "359691642145109", "359691642152600", "359691642153160", "359691642155645", "359691642156841", "861530062172105", "861530062174382", "864985065768787", "864985065792944", "866807064663710")));
1047
        fofoIdImeiReturnMap.put(175139425,new HashSet<>(Arrays.asList("350386305671629","350386306043125","863653060563873","863653060564970","865037065022895","865037065094795","868905065657356","868905066089856")));
1079
        fofoIdImeiReturnMap.put(175139425, new HashSet<>(Arrays.asList("350386305671629", "350386306043125", "863653060563873", "863653060564970", "865037065022895", "865037065094795", "868905065657356", "868905066089856")));
1048
        fofoIdImeiReturnMap.put(175139426,new HashSet<>(Arrays.asList("359197382598762","359197382619329","359197382623701","359197382629302","359197382630680","359197382637305","359197382641943","359197382645480","359197382647304","359197382647528","860374069742052","861530063115582","862628068090534","862628068266092","863653061146876","863653061150217","866807064452577","867158060215595")));
1080
        fofoIdImeiReturnMap.put(175139426, new HashSet<>(Arrays.asList("359197382598762", "359197382619329", "359197382623701", "359197382629302", "359197382630680", "359197382637305", "359197382641943", "359197382645480", "359197382647304", "359197382647528", "860374069742052", "861530063115582", "862628068090534", "862628068266092", "863653061146876", "863653061150217", "866807064452577", "867158060215595")));
1049
        fofoIdImeiReturnMap.put(175139429,new HashSet<>(Arrays.asList("352094722900948","352094722908982","353305256468261","353305256536604","355724848504375","356612605716879","358382747569358","358382747580439","359197382650704","359197382651967","359691642166485","359691642172160","861530063122463","864848067843141","864848067935947","864985066066827","866132060383811","866399062773725","866399065623760","868666065635608","868666065730581","868666067425545","868666067819143")));
1081
        fofoIdImeiReturnMap.put(175139429, new HashSet<>(Arrays.asList("352094722900948", "352094722908982", "353305256468261", "353305256536604", "355724848504375", "356612605716879", "358382747569358", "358382747580439", "359197382650704", "359197382651967", "359691642166485", "359691642172160", "861530063122463", "864848067843141", "864848067935947", "864985066066827", "866132060383811", "866399062773725", "866399065623760", "868666065635608", "868666065730581", "868666067425545", "868666067819143")));
1050
        fofoIdImeiReturnMap.put(175139431,new HashSet<>(Arrays.asList("860374069332672","862892060190615","863879063992419","864985061894884","865210064232472","865821063930708","865821065112404","866807067509712","867212063822897","867212068439556")));
1082
        fofoIdImeiReturnMap.put(175139431, new HashSet<>(Arrays.asList("860374069332672", "862892060190615", "863879063992419", "864985061894884", "865210064232472", "865821063930708", "865821065112404", "866807067509712", "867212063822897", "867212068439556")));
1051
        fofoIdImeiReturnMap.put(175139440,new HashSet<>(Arrays.asList("354849877295602","354849877296600","861663069285230","864985066226280","864985066330744","866399065940081","866399066065086","866807064443857","866807067122359","867212068441537","867212068443053","869350065159799","869350065160276","869916067368859")));
1083
        fofoIdImeiReturnMap.put(175139440, new HashSet<>(Arrays.asList("354849877295602", "354849877296600", "861663069285230", "864985066226280", "864985066330744", "866399065940081", "866399066065086", "866807064443857", "866807067122359", "867212068441537", "867212068443053", "869350065159799", "869350065160276", "869916067368859")));
1052
        fofoIdImeiReturnMap.put(175139442,new HashSet<>(Arrays.asList("861530062218262","861530062870823","861530062965466","866559062488851","866559062489834","866559062491699")));
1084
        fofoIdImeiReturnMap.put(175139442, new HashSet<>(Arrays.asList("861530062218262", "861530062870823", "861530062965466", "866559062488851", "866559062489834", "866559062491699")));
1053
        fofoIdImeiReturnMap.put(175139449,new HashSet<>(Arrays.asList("359749531470226","359749531473402","359749531625381","359749531637501","359749531767209","861784061890593","865279065935557","865279066560370","866399064536229","866399065066721","866399065302282","866399065699125","866399065717349","866399065734161")));
1085
        fofoIdImeiReturnMap.put(175139449, new HashSet<>(Arrays.asList("359749531470226", "359749531473402", "359749531625381", "359749531637501", "359749531767209", "861784061890593", "865279065935557", "865279066560370", "866399064536229", "866399065066721", "866399065302282", "866399065699125", "866399065717349", "866399065734161")));
1054
        fofoIdImeiReturnMap.put(175139451,new HashSet<>(Arrays.asList("352450547378647","862628068576730","865865067474338","866132066698774","867492062851556","868666065861022")));
1086
        fofoIdImeiReturnMap.put(175139451, new HashSet<>(Arrays.asList("352450547378647", "862628068576730", "865865067474338", "866132066698774", "867492062851556", "868666065861022")));
1055
        fofoIdImeiReturnMap.put(175139452,new HashSet<>(Arrays.asList("350031479647969","350191506027955","350655759940262","351733714485035","353140544946657","353397823356202","353397823400539","355724848507774","864848068287108","864985065787142","864985065837145","868701061018192","869106063245851","869106065767977")));
1087
        fofoIdImeiReturnMap.put(175139452, new HashSet<>(Arrays.asList("350031479647969", "350191506027955", "350655759940262", "351733714485035", "353140544946657", "353397823356202", "353397823400539", "355724848507774", "864848068287108", "864985065787142", "864985065837145", "868701061018192", "869106063245851", "869106065767977")));
1056
        fofoIdImeiReturnMap.put(175139457,new HashSet<>(Arrays.asList("357014950300871","861530062195841","863653061134492","863653061138915","864848068172664","864985065981687","866399062770705","866399065110404","868701063248771")));
1088
        fofoIdImeiReturnMap.put(175139457, new HashSet<>(Arrays.asList("357014950300871", "861530062195841", "863653061134492", "863653061138915", "864848068172664", "864985065981687", "866399062770705", "866399065110404", "868701063248771")));
1057
        fofoIdImeiReturnMap.put(175139459,new HashSet<>(Arrays.asList("352450543885389","352450544527246","354301731188268","359680163322346","866641067145718","868701063374437","869076063987929","869076064359821")));
1089
        fofoIdImeiReturnMap.put(175139459, new HashSet<>(Arrays.asList("352450543885389", "352450544527246", "354301731188268", "359680163322346", "866641067145718", "868701063374437", "869076063987929", "869076064359821")));
1058
        fofoIdImeiReturnMap.put(175139463,new HashSet<>(Arrays.asList("350923626635949","350923626636269","350923626690902","861784060309637","864848068046108","864848068051546","866807064687750","869916067368297")));
1090
        fofoIdImeiReturnMap.put(175139463, new HashSet<>(Arrays.asList("350923626635949", "350923626636269", "350923626690902", "861784060309637", "864848068046108", "864848068051546", "866807064687750", "869916067368297")));
1059
        fofoIdImeiReturnMap.put(175139465,new HashSet<>(Arrays.asList("351613386249440","351613387095180","861663068329336","861663069069253","861784060309918","864985065810969","865753067325041","865753067353860","866807064687131","867212067917156","867212068434714","869350061950019","869350062195671","869350062386452","869916067369071")));
1091
        fofoIdImeiReturnMap.put(175139465, new HashSet<>(Arrays.asList("351613386249440", "351613387095180", "861663068329336", "861663069069253", "861784060309918", "864985065810969", "865753067325041", "865753067353860", "866807064687131", "867212067917156", "867212068434714", "869350061950019", "869350062195671", "869350062386452", "869916067369071")));
1060
        fofoIdImeiReturnMap.put(175139466,new HashSet<>(Arrays.asList("359749531534823","359749531619442","861663069053398","861663069069857","863879062138451","866399065107301","866399065212788","866807067493537","866807067515230","867212063830312","867212068447013","869916067366572")));
1092
        fofoIdImeiReturnMap.put(175139466, new HashSet<>(Arrays.asList("359749531534823", "359749531619442", "861663069053398", "861663069069857", "863879062138451", "866399065107301", "866399065212788", "866807067493537", "866807067515230", "867212063830312", "867212068447013", "869916067366572")));
1061
        fofoIdImeiReturnMap.put(175139467,new HashSet<>(Arrays.asList("350250294009631","350250294416570","351613386626407","351613386634724","351613386881341","351613386881721","866807063687975","866807064692651","867212063830239","867212067915812","867212068434896","867212068443756","867212068445470")));
1093
        fofoIdImeiReturnMap.put(175139467, new HashSet<>(Arrays.asList("350250294009631", "350250294416570", "351613386626407", "351613386634724", "351613386881341", "351613386881721", "866807063687975", "866807064692651", "867212063830239", "867212067915812", "867212068434896", "867212068443756", "867212068445470")));
1062
        fofoIdImeiReturnMap.put(175139468,new HashSet<>(Arrays.asList("863653065382279","864690068728354","864690068728412","865279066339650","866132063736916","866132064179710")));
1094
        fofoIdImeiReturnMap.put(175139468, new HashSet<>(Arrays.asList("863653065382279", "864690068728354", "864690068728412", "865279066339650", "866132063736916", "866132064179710")));
1063
        fofoIdImeiReturnMap.put(175139472,new HashSet<>(Arrays.asList("351613386632884","351613386906387","357415663628286","860374069457230","863879063994217","863879063996659","864848068065868","865037066313699","866399066697367","866807064662399","867212067916190","867212068443236","868905065660756","869236068140771","869350062605497")));
1095
        fofoIdImeiReturnMap.put(175139472, new HashSet<>(Arrays.asList("351613386632884", "351613386906387", "357415663628286", "860374069457230", "863879063994217", "863879063996659", "864848068065868", "865037066313699", "866399066697367", "866807064662399", "867212067916190", "867212068443236", "868905065660756", "869236068140771", "869350062605497")));
1064
        fofoIdImeiReturnMap.put(175139477,new HashSet<>(Arrays.asList("861663068335796","861663069050774","861663069051590","863879061279330","863879062320612","864288064231455","864647061805472","866807063530852","866807063565775","867212063825619","867212068442154")));
1096
        fofoIdImeiReturnMap.put(175139477, new HashSet<>(Arrays.asList("861663068335796", "861663069050774", "861663069051590", "863879061279330", "863879062320612", "864288064231455", "864647061805472", "866807063530852", "866807063565775", "867212063825619", "867212068442154")));
1065
        fofoIdImeiReturnMap.put(175139489,new HashSet<>(Arrays.asList("350031476683801","350031477646419","863653067155012","865037065748796","865037068846316","865210063382351","865279065239570","866399066070789","866559062481237","866641067273452","867492061243532","868652062503601","868666065959727","868666067777804","868701062941111","868701069479172")));
1097
        fofoIdImeiReturnMap.put(175139489, new HashSet<>(Arrays.asList("350031476683801", "350031477646419", "863653067155012", "865037065748796", "865037068846316", "865210063382351", "865279065239570", "866399066070789", "866559062481237", "866641067273452", "867492061243532", "868652062503601", "868666065959727", "868666067777804", "868701062941111", "868701069479172")));
1066
        fofoIdImeiReturnMap.put(175139490,new HashSet<>(Arrays.asList("350031477636618","351733715724002","352120260187174","352953554051643","355724848426439","357014954930939","863653061893972","865821060228742","866399066062984","866399066069989","868652062617484","868666065958901","868905064290456","868905064825012","869076064649502")));
1098
        fofoIdImeiReturnMap.put(175139490, new HashSet<>(Arrays.asList("350031477636618", "351733715724002", "352120260187174", "352953554051643", "355724848426439", "357014954930939", "863653061893972", "865821060228742", "866399066062984", "866399066069989", "868652062617484", "868666065958901", "868905064290456", "868905064825012", "869076064649502")));
1067
        fofoIdImeiReturnMap.put(175139493,new HashSet<>(Arrays.asList("350250294029969","350250294131203","350339951594819","351733715279890","351733715611290","356612605730052","358382747584456","358382747584910","860695063377770","862628066338554","862628067568811","863879066397897","864920064911971","868701063410017","868701067287973")));
1099
        fofoIdImeiReturnMap.put(175139493, new HashSet<>(Arrays.asList("350250294029969", "350250294131203", "350339951594819", "351733715279890", "351733715611290", "356612605730052", "358382747584456", "358382747584910", "860695063377770", "862628066338554", "862628067568811", "863879066397897", "864920064911971", "868701063410017", "868701067287973")));
1068
        fofoIdImeiReturnMap.put(175139496,new HashSet<>(Arrays.asList("350386305879537","860695063378810","863879062651750","864920069103590","865037066073517","865210064600017","865279067176432","865865062952171","866807068662916","866807069402130","867158063179178","867492063171996","868905065232135")));
1100
        fofoIdImeiReturnMap.put(175139496, new HashSet<>(Arrays.asList("350386305879537", "860695063378810", "863879062651750", "864920069103590", "865037066073517", "865210064600017", "865279067176432", "865865062952171", "866807068662916", "866807069402130", "867158063179178", "867492063171996", "868905065232135")));
1069
        fofoIdImeiReturnMap.put(175139505,new HashSet<>(Arrays.asList("352450547876988","353305256493285","354301731180687","862628066338018","863653064984612","865037066073772","865210064252231","865210064255556","865279066156054","866399065988643","867158063267031","867492063304399","869076064640725","869236066123035")));
1101
        fofoIdImeiReturnMap.put(175139505, new HashSet<>(Arrays.asList("352450547876988", "353305256493285", "354301731180687", "862628066338018", "863653064984612", "865037066073772", "865210064252231", "865210064255556", "865279066156054", "866399065988643", "867158063267031", "867492063304399", "869076064640725", "869236066123035")));
1070
        //orderService.createMissingScratchOffers();
1102
        //orderService.createMissingScratchOffers();
1071
        /*LocalDateTime debitNoteDate = LocalDate.of(2023, Month.NOVEMBER, 30).atStartOfDay();
1103
        /*LocalDateTime debitNoteDate = LocalDate.of(2023, Month.NOVEMBER, 30).atStartOfDay();
1072
        fofoIdImeiReturnMap.put(175138983, new HashSet<>(Arrays.asList("353350901603805", "353823611691989", "862869067816608", "862869067931803", "862869067934302", "867022067784724", "867022067840922")));
1104
        fofoIdImeiReturnMap.put(175138983, new HashSet<>(Arrays.asList("353350901603805", "353823611691989", "862869067816608", "862869067931803", "862869067934302", "867022067784724", "867022067840922")));
1073
        fofoIdImeiReturnMap.put(175139377, new HashSet<>(Arrays.asList("350048273593173", "351063314519862", "352950861869717", "352950861876696", "866399064994105", "864480065905886", "864480065906900")));
1105
        fofoIdImeiReturnMap.put(175139377, new HashSet<>(Arrays.asList("350048273593173", "351063314519862", "352950861869717", "352950861876696", "866399064994105", "864480065905886", "864480065906900")));
1074
        fofoIdImeiReturnMap.put(175139404, new HashSet<>(Arrays.asList("867022067841961", "352450547322587", "355056447721856", "355056447740690", "355056447741177", "860605068562631", "863511060840651", "863511060841378", "863511060914118", "863511060961879", "863511061221752", "866755064176375")));
1106
        fofoIdImeiReturnMap.put(175139404, new HashSet<>(Arrays.asList("867022067841961", "352450547322587", "355056447721856", "355056447740690", "355056447741177", "860605068562631", "863511060840651", "863511060841378", "863511060914118", "863511060961879", "863511061221752", "866755064176375")));
Line 1433... Line 1465...
1433
                }
1465
                }
1434
            }
1466
            }
1435
        }
1467
        }
1436
    }
1468
    }
1437
 
1469
 
1438
    public void test1() throws Exception {
1470
    public void test2() throws Exception {
1439
        System.out.println("Starting test");
1471
        System.out.println("Starting test");
1440
        processScheme(LocalDate.of(2023, 05, 06).atStartOfDay(), LocalDate.of(2023, 05, 9).atStartOfDay(), false);
1472
        processScheme(LocalDate.of(2023, 05, 06).atStartOfDay(), LocalDate.of(2023, 05, 9).atStartOfDay(), false);
1441
        /*partnerTypeChangeService.getTypeOnDate(175139287, LocalDate.of(2023,02, 01));
1473
        /*partnerTypeChangeService.getTypeOnDate(175139287, LocalDate.of(2023,02, 01));
1442
        partnerTypeChangeService.getTypeOnDate(175139287, LocalDate.of(2023,03, 01));
1474
        partnerTypeChangeService.getTypeOnDate(175139287, LocalDate.of(2023,03, 01));
1443
        partnerTypeChangeService.getTypeOnDate(175139287, LocalDate.of(2023,04, 01));
1475
        partnerTypeChangeService.getTypeOnDate(175139287, LocalDate.of(2023,04, 01));
Line 3082... Line 3114...
3082
        sb.append("</tbody></table></body></html>");
3114
        sb.append("</tbody></table></body></html>");
3083
 
3115
 
3084
        return sb.toString();
3116
        return sb.toString();
3085
    }
3117
    }
3086
 
3118
 
3087
    private String getMessageForUncontacblePartner(List<PartnerCollectionRemark> pcrs) throws
3119
    private String getMessageForRBMEscalatedPartners(List<PartnerCollectionRemark> pcrs) throws
3088
            ProfitMandiBusinessException {
3120
            ProfitMandiBusinessException {
3089
        StringBuilder sb = new StringBuilder();
3121
        StringBuilder sb = new StringBuilder();
3090
        sb.append("<html><body><p>Alert</p><p>Not Responding Partner:-</p>" + "<br/><table style='border:1px solid black ;padding: 5px';>");
3122
        sb.append("<html><body><p>Alert</p><p>Escalated by RBM-L1:-</p>" + "<br/><table style='border:1px solid black ;padding: 5px';>");
-
 
3123
        sb.append("<tbody>" +
-
 
3124
                "<tr>" +
3091
        sb.append("<tbody>\n" + "	    				<tr>\n" + "	    					<th style='border:1px solid black;padding: 5px'>PartnerName</th>\n" + "	    					<th style='border:1px solid black;padding: 5px'>from</th>\n"
3125
                "<th style='border:1px solid black;padding: 5px'>PartnerName</th>" +
-
 
3126
                "<th style='border:1px solid black;padding: 5px'>Escalated Since</th>" +
-
 
3127
                "<th style='border:1px solid black;padding: 5px'>Message</th>" +
-
 
3128
                "</tr>");
3092
 
3129
 
3093
                + "	    				</tr>");
-
 
3094
        for (PartnerCollectionRemark entry : pcrs) {
3130
        for (PartnerCollectionRemark entry : pcrs) {
3095
 
3131
 
3096
            CustomRetailer customRetailer = retailerService.getFofoRetailer(entry.getFofoId());
3132
            CustomRetailer customRetailer = retailerService.getFofoRetailer(entry.getFofoId());
3097
 
3133
 
3098
            sb.append("<tr>");
3134
            sb.append("<tr>");
3099
            sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
3135
            sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
3100
 
-
 
3101
            sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getCreateTimestamp().format(DateTimeFormatter.ofPattern("dd/MM/yyyy")) + "</td>");
3136
            sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getCreateTimestamp().format(DateTimeFormatter.ofPattern("dd/MM/yyyy")) + "</td>");
-
 
3137
            sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getMessage() + "</td>");
3102
 
3138
 
3103
            sb.append("</tr>");
3139
            sb.append("</tr>");
3104
 
3140
 
3105
        }
3141
        }
3106
 
3142
 
3107
        sb.append("</tbody></table></body></html>");
3143
        sb.append("</tbody></table></body></html>");
3108
 
3144
 
3109
        return sb.toString();
3145
        return sb.toString();
3110
    }
3146
    }
3111
 
3147
 
-
 
3148
    private String getMessageForSalesEscalatedPartners(List<PartnerCollectionRemark> pcrs) throws
-
 
3149
            ProfitMandiBusinessException {
-
 
3150
        StringBuilder sb = new StringBuilder();
-
 
3151
        sb.append("<html><body><p>Alert</p><p>Escalated to Sales Team:-</p>" + "<br/>" +
-
 
3152
                "<table style='border:1px solid black ;padding: 5px';>");
-
 
3153
        sb.append("<tbody>" +
-
 
3154
                "<tr>" +
-
 
3155
                "<th style='border:1px solid black;padding: 5px'>PartnerName</th>" +
-
 
3156
                "<th style='border:1px solid black;padding: 5px'>Escalated Since</th>" +
-
 
3157
                "<th style='border:1px solid black;padding: 5px'>Message</th>" +
-
 
3158
                "</tr>");
-
 
3159
        for (PartnerCollectionRemark entry : pcrs) {
-
 
3160
            CustomRetailer customRetailer = retailerService.getFofoRetailer(entry.getFofoId());
-
 
3161
            sb.append("<tr>");
-
 
3162
            sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
-
 
3163
            sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getCreateTimestamp().format(DateTimeFormatter.ofPattern("dd/MM/yyyy")) + "</td>");
-
 
3164
            sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getMessage() + "</td>");
-
 
3165
            sb.append("</tr>");
-
 
3166
        }
-
 
3167
 
-
 
3168
        sb.append("</tbody></table></body></html>");
-
 
3169
 
-
 
3170
        return sb.toString();
-
 
3171
    }
-
 
3172
 
3112
    public void reverseWallet() throws Exception {
3173
    public void reverseWallet() throws Exception {
3113
        LocalDate localDate = LocalDate.of(2020, 10, 28);
3174
        LocalDate localDate = LocalDate.of(2020, 10, 28);
3114
        List<UserWalletHistory> uwhList = userWalletHistoryRepository.selectAllByDateType(localDate.atStartOfDay(), localDate.plusDays(1).atStartOfDay(), Arrays.asList(WalletReferenceType.SCHEME_IN, WalletReferenceType.SCHEME_OUT));
3175
        List<UserWalletHistory> uwhList = userWalletHistoryRepository.selectAllByDateType(localDate.atStartOfDay(), localDate.plusDays(1).atStartOfDay(), Arrays.asList(WalletReferenceType.SCHEME_IN, WalletReferenceType.SCHEME_OUT));
3115
        for (UserWalletHistory uwh : uwhList) {
3176
        for (UserWalletHistory uwh : uwhList) {
3116
            if (uwh.getBusinessTimestamp().getMonth().equals(Month.SEPTEMBER)) {
3177
            if (uwh.getBusinessTimestamp().getMonth().equals(Month.SEPTEMBER)) {
Line 3643... Line 3704...
3643
    public void reviewUncontactablePartner() throws
3704
    public void reviewUncontactablePartner() throws
3644
            ProfitMandiBusinessException, MessagingException, UnsupportedEncodingException {
3705
            ProfitMandiBusinessException, MessagingException, UnsupportedEncodingException {
3645
 
3706
 
3646
        Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(true);
3707
        Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(true);
3647
 
3708
 
3648
        List<Integer> pcrms = partnerCollectionRemarkRepository.selectMaxRemarkId(new ArrayList<>(customRetailerMap.keySet()));
3709
        List<Integer> partnerLastCollectionRemarkIds = partnerCollectionRemarkRepository.selectMaxRemarkId(new ArrayList<>(customRetailerMap.keySet()));
3649
 
3710
 
3650
        if (!pcrms.isEmpty()) {
3711
        if (!partnerLastCollectionRemarkIds.isEmpty()) {
3651
            Map<Integer, PartnerCollectionRemark> partnerCollectionRemarksMap = partnerCollectionRemarkRepository.selectByIds(pcrms).stream().filter(x -> x.getRemark().equals(CollectionRemark.NOT_RESPONDING)).collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
3712
            List<PartnerCollectionRemark> partnerCollectionRemarks = partnerCollectionRemarkRepository.selectByIds(partnerLastCollectionRemarkIds);
3652
 
3713
 
-
 
3714
            Map<Integer, PartnerCollectionRemark> rbmEscalatedRemarksMap = partnerCollectionRemarks.stream().filter(x -> x.getRemark().equals(CollectionRemark.RBM_ESCALATION)).collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
-
 
3715
            Map<Integer, PartnerCollectionRemark> salesEscalatedRemarksMap = partnerCollectionRemarks.stream().filter(x -> x.getRemark().equals(CollectionRemark.SALES_ESCALATION)).collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
-
 
3716
 
-
 
3717
 
3653
            if (!partnerCollectionRemarksMap.isEmpty()) {
3718
            if (!rbmEscalatedRemarksMap.isEmpty()) {
-
 
3719
                //
3654
                for (Map.Entry<String, Set<Integer>> storeGuyEntry : csService.getAuthUserPartnerIdMapping().entrySet()) {
3720
                for (Map.Entry<String, Set<Integer>> storeGuyEntry : csService.getAuthUserPartnerIdMappingByCategoryIds(Arrays.asList(ProfitMandiConstants.TICKET_CATEGORY_RBM), true).entrySet()) {
-
 
3721
                    List<PartnerCollectionRemark> filteredRows = storeGuyEntry.getValue().stream()
3655
                    List<PartnerCollectionRemark> filteredRows = storeGuyEntry.getValue().stream().map(x -> partnerCollectionRemarksMap.get(x)).filter(x -> x != null).collect(Collectors.toList());
3722
                            .map(x -> rbmEscalatedRemarksMap.get(x)).filter(x -> x != null).collect(Collectors.toList());
3656
                    String subject = "UNCONTACTABLE PARTNERS";
3723
                    String subject = "Partners escalated to RBM-L2";
3657
                    String messageText = this.getMessageForUncontacblePartner(filteredRows);
3724
                    String messageText = this.getMessageForRBMEscalatedPartners(filteredRows);
-
 
3725
 
-
 
3726
                    MimeMessage message = mailSender.createMimeMessage();
-
 
3727
                    MimeMessageHelper helper = new MimeMessageHelper(message, true);
-
 
3728
                    String[] email = new String[]{storeGuyEntry.getKey()};
-
 
3729
 
-
 
3730
                    helper.setSubject(subject);
-
 
3731
                    helper.setText(messageText, true);
-
 
3732
                    helper.setTo(email);
-
 
3733
                    InternetAddress senderAddress = new InternetAddress("noreply@smartdukaan.com", "Smartdukaan Alerts");
-
 
3734
                    helper.setFrom(senderAddress);
-
 
3735
                    mailSender.send(message);
-
 
3736
 
-
 
3737
                    LOGGER.info("filteredRows {}", filteredRows);
-
 
3738
 
-
 
3739
                }
-
 
3740
            }
-
 
3741
            if (!salesEscalatedRemarksMap.isEmpty()) {
-
 
3742
                //
-
 
3743
                for (Map.Entry<String, Set<Integer>> storeGuyEntry : csService.getAuthUserPartnerIdMappingByCategoryIds(Arrays.asList(ProfitMandiConstants.TICKET_CATEGORY_SALES, ProfitMandiConstants.TICKET_CATEGORY_RBM), true).entrySet()) {
-
 
3744
                    List<PartnerCollectionRemark> filteredRows = storeGuyEntry.getValue().stream()
-
 
3745
                            .map(x -> salesEscalatedRemarksMap.get(x)).filter(x -> x != null).collect(Collectors.toList());
-
 
3746
                    String subject = "Partners escalated to Sales";
-
 
3747
                    String messageText = this.getMessageForSalesEscalatedPartners(filteredRows);
3658
 
3748
 
3659
                    MimeMessage message = mailSender.createMimeMessage();
3749
                    MimeMessage message = mailSender.createMimeMessage();
3660
                    MimeMessageHelper helper = new MimeMessageHelper(message, true);
3750
                    MimeMessageHelper helper = new MimeMessageHelper(message, true);
3661
                    String[] email = new String[]{storeGuyEntry.getKey()};
3751
                    String[] email = new String[]{storeGuyEntry.getKey()};
3662
 
3752