Subversion Repositories SmartDukaan

Rev

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

Rev 33639 Rev 33664
Line 85... Line 85...
85 
import com.spice.profitmandi.service.order.OrderService;
 85 
import com.spice.profitmandi.service.order.OrderService;
86 
import com.spice.profitmandi.service.pricecircular.PriceCircularService;
 86 
import com.spice.profitmandi.service.pricecircular.PriceCircularService;
87 
import com.spice.profitmandi.service.pricing.PriceDropService;
 87 
import com.spice.profitmandi.service.pricing.PriceDropService;
88 
import com.spice.profitmandi.service.recharge.provider.OxigenRechargeProviderService;
 88 
import com.spice.profitmandi.service.recharge.provider.OxigenRechargeProviderService;
89 
import com.spice.profitmandi.service.recharge.provider.ThinkWalnutDigitalRechargeProviderService;
 89 
import com.spice.profitmandi.service.recharge.provider.ThinkWalnutDigitalRechargeProviderService;
90 
import com.spice.profitmandi.service.scheme.InventoryPayoutModel;
 - 
 
91 
import com.spice.profitmandi.service.scheme.SchemeService;
 90 
import com.spice.profitmandi.service.scheme.SchemeService;
92 
import com.spice.profitmandi.service.serviceConfig.ServiceConfigService;
 91 
import com.spice.profitmandi.service.serviceConfig.ServiceConfigService;
93 
import com.spice.profitmandi.service.transaction.CreditNoteService;
 92 
import com.spice.profitmandi.service.transaction.CreditNoteService;
94 
import com.spice.profitmandi.service.transaction.SDCreditService;
 93 
import com.spice.profitmandi.service.transaction.SDCreditService;
95 
import com.spice.profitmandi.service.transaction.TransactionService;
 94 
import com.spice.profitmandi.service.transaction.TransactionService;
Line 102... Line 101...
102 
import com.spice.profitmandi.service.warehouse.WarehouseService;
 101 
import com.spice.profitmandi.service.warehouse.WarehouseService;
103 
import in.shop2020.model.v1.order.OrderStatus;
 102 
import in.shop2020.model.v1.order.OrderStatus;
104 
import in.shop2020.model.v1.order.WalletReferenceType;
 103 
import in.shop2020.model.v1.order.WalletReferenceType;
105 
import org.apache.commons.io.output.ByteArrayOutputStream;
 104 
import org.apache.commons.io.output.ByteArrayOutputStream;
106 
import org.apache.commons.lang.StringUtils;
 105 
import org.apache.commons.lang.StringUtils;
- 
 
 106 
import org.apache.commons.lang3.tuple.Pair;
107 
import org.apache.http.client.methods.CloseableHttpResponse;
 107 
import org.apache.http.client.methods.CloseableHttpResponse;
108 
import org.apache.http.client.methods.HttpPost;
 108 
import org.apache.http.client.methods.HttpPost;
109 
import org.apache.http.conn.HttpHostConnectException;
 109 
import org.apache.http.conn.HttpHostConnectException;
110 
import org.apache.http.entity.StringEntity;
 110 
import org.apache.http.entity.StringEntity;
111 
import org.apache.http.impl.client.CloseableHttpClient;
 111 
import org.apache.http.impl.client.CloseableHttpClient;
Line 144... Line 144...
144 
import java.util.*;
 144 
import java.util.*;
145 
import java.util.Map.Entry;
 145 
import java.util.Map.Entry;
146 
import java.util.stream.Collectors;
 146 
import java.util.stream.Collectors;
147 
import java.util.stream.Stream;
 147 
import java.util.stream.Stream;
148 
 
 148 
 
149 
import static java.util.stream.Collectors.groupingBy;
 - 
 
150 
import static java.util.stream.Collectors.mapping;
 149 
import static java.util.stream.Collectors.*;
151 
 
 150 
 
152 
 
 151 
 
153 
@Component
 152 
@Component
154 
@Transactional(rollbackFor = {Throwable.class, ProfitMandiBusinessException.class})
 153 
@Transactional(rollbackFor = {Throwable.class, ProfitMandiBusinessException.class})
155 
public class ScheduledTasks {
 154 
public class ScheduledTasks {
Line 273... Line 272...
273 
 
 272 
 
274 
    private static final String[] STOCK_AGEING_MAIL_LIST = new String[]{"uday.singh@smartudkaan.com", "mohinder.mutreja@smartdukaan.com", "ankit.bhatia@smartdukaan.com", "tarun.verma@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "manish.gupta@smartdukaan.com"};
 273 
    private static final String[] STOCK_AGEING_MAIL_LIST = new String[]{"uday.singh@smartudkaan.com", "mohinder.mutreja@smartdukaan.com", "ankit.bhatia@smartdukaan.com", "tarun.verma@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "manish.gupta@smartdukaan.com"};
275 
 
 274 
 
276 
    private static final String[] ITEMWISE_PENDING_INDENT_MAIL_LIST = new String[]{"kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com", "uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "niranjan.kala@smartdukaan.com"};
 275 
    private static final String[] ITEMWISE_PENDING_INDENT_MAIL_LIST = new String[]{"kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com", "uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "niranjan.kala@smartdukaan.com"};
277 
 
 276 
 
278 
    private static final String[] INDENT_TERTIARY_MAIL_LIST = new String[]{"uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com", "vinay.p@smartdukaan.com","deena.nath@smartdukaan.com","shobhit.tandon@smartdukaan.com"};
 277 
    private static final String[] INDENT_TERTIARY_MAIL_LIST = new String[]{"uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com", "vinay.p@smartdukaan.com", "deena.nath@smartdukaan.com", "shobhit.tandon@smartdukaan.com", "ritesh.chauhan1@smartdukaan.com"};
279 
 
 278 
 
280 
    private static final String[] EMPLOYEE_ATTENDANCE_MAIL_LIST = new String[]{"sm@smartdukaan.com", "sm@smartdukaan.com"};
 279 
    private static final String[] EMPLOYEE_ATTENDANCE_MAIL_LIST = new String[]{"sm@smartdukaan.com", "sm@smartdukaan.com"};
281 
 
 280 
 
282 
    private List<OrderStatus> orderStatusList = Arrays.asList(OrderStatus.SUBMITTED_FOR_PROCESSING);
 281 
    private List<OrderStatus> orderStatusList = Arrays.asList(OrderStatus.SUBMITTED_FOR_PROCESSING);
283 
 
 282 
 
Line 1038... Line 1037...
1038 
    @Autowired
 1037 
    @Autowired
1039 
    RedisCacheManager redisFortnightlyCacheManage;
 1038 
    RedisCacheManager redisFortnightlyCacheManage;
1040 
 
 1039 
 
1041 
    @Autowired
 1040 
    @Autowired
1042 
    GstProAuthService gstProAuthService;
 1041 
    GstProAuthService gstProAuthService;
- 
 
 1042 
 
1043 
    public void test() throws Exception {
 1043 
    public void test() throws Exception {
- 
 
 1044 
        List<Pair<Integer, String>> offerList = new ArrayList<>();
- 
 
 1045 
        offerList.add(Pair.of(1448, "860229064166451"));
- 
 
 1046 
        offerList.add(Pair.of(1448, "860229064167590"));
- 
 
 1047 
        offerList.add(Pair.of(1448, "860229064170016"));
- 
 
 1048 
        offerList.add(Pair.of(1448, "860229064182599"));
- 
 
 1049 
        offerList.add(Pair.of(1448, "860229064182813"));
- 
 
 1050 
        offerList.add(Pair.of(1448, "860229064227436"));
- 
 
 1051 
        offerList.add(Pair.of(1448, "860229064227774"));
- 
 
 1052 
        offerList.add(Pair.of(1448, "860229064228590"));
- 
 
 1053 
        offerList.add(Pair.of(1448, "860229064228616"));
- 
 
 1054 
        offerList.add(Pair.of(1448, "860229065757712"));
- 
 
 1055 
        offerList.add(Pair.of(1448, "866018061686957"));
- 
 
 1056 
        offerList.add(Pair.of(1834, "861530062165067"));
- 
 
 1057 
        offerList.add(Pair.of(1834, "861530062195841"));
- 
 
 1058 
        offerList.add(Pair.of(1834, "861530062870823"));
- 
 
 1059 
        offerList.add(Pair.of(1834, "861530063602902"));
- 
 
 1060 
        offerList.add(Pair.of(1834, "861530069716623"));
- 
 
 1061 
        offerList.add(Pair.of(1834, "861530069721201"));
- 
 
 1062 
        offerList.add(Pair.of(1943, "862965063969779"));
- 
 
 1063 
        offerList.add(Pair.of(1967, "356052832042411"));
- 
 
 1064 
        offerList.add(Pair.of(1967, "356052833682363"));
- 
 
 1065 
        offerList.add(Pair.of(1967, "356052833691687"));
- 
 
 1066 
        offerList.add(Pair.of(1967, "356052833738090"));
- 
 
 1067 
        offerList.add(Pair.of(1967, "356052834058977"));
- 
 
 1068 
        offerList.add(Pair.of(1967, "356052834345051"));
- 
 
 1069 
        offerList.add(Pair.of(1967, "356052834409279"));
- 
 
 1070 
        offerList.add(Pair.of(1967, "356052834880578"));
- 
 
 1071 
        offerList.add(Pair.of(1967, "356052835049975"));
- 
 
 1072 
        offerList.add(Pair.of(1967, "356052835171522"));
- 
 
 1073 
        offerList.add(Pair.of(1967, "356052835238230"));
- 
 
 1074 
        offerList.add(Pair.of(1967, "356052835345571"));
- 
 
 1075 
        offerList.add(Pair.of(1967, "356052835351595"));
- 
 
 1076 
        offerList.add(Pair.of(1967, "356052835374316"));
- 
 
 1077 
        offerList.add(Pair.of(1967, "356052835523839"));
- 
 
 1078 
        offerList.add(Pair.of(1967, "356052835637316"));
- 
 
 1079 
        offerList.add(Pair.of(1967, "356052835637340"));
- 
 
 1080 
        offerList.add(Pair.of(1967, "356052835639593"));
- 
 
 1081 
        offerList.add(Pair.of(1967, "356052835649816"));
- 
 
 1082 
        offerList.add(Pair.of(1967, "356052835679789"));
- 
 
 1083 
        offerList.add(Pair.of(1967, "356052835685828"));
- 
 
 1084 
        offerList.add(Pair.of(1967, "356052835708752"));
- 
 
 1085 
        offerList.add(Pair.of(1967, "356052835729444"));
- 
 
 1086 
        offerList.add(Pair.of(1967, "356052835730392"));
- 
 
 1087 
        offerList.add(Pair.of(1967, "356052835968778"));
- 
 
 1088 
        offerList.add(Pair.of(1967, "356052836002833"));
- 
 
 1089 
        offerList.add(Pair.of(1967, "356052836067877"));
- 
 
 1090 
        offerList.add(Pair.of(1967, "356052836116310"));
- 
 
 1091 
        offerList.add(Pair.of(1967, "356052836765306"));
- 
 
 1092 
        offerList.add(Pair.of(1967, "356052837844787"));
- 
 
 1093 
        offerList.add(Pair.of(1967, "356052838415090"));
- 
 
 1094 
        offerList.add(Pair.of(1967, "356052839615995"));
- 
 
 1095 
        offerList.add(Pair.of(1967, "356052839968873"));
- 
 
 1096 
        offerList.add(Pair.of(2590, "862282072349096"));
- 
 
 1097 
        offerList.add(Pair.of(2590, "863055063069272"));
- 
 
 1098 
        offerList.add(Pair.of(2590, "863055063524771"));
- 
 
 1099 
        offerList.add(Pair.of(2590, "863055064402159"));
- 
 
 1100 
        offerList.add(Pair.of(2590, "865303063229514"));
- 
 
 1101 
        offerList.add(Pair.of(2590, "865388070497097"));
- 
 
 1102 
        offerList.add(Pair.of(2590, "865388071543774"));
- 
 
 1103 
        offerList.add(Pair.of(2590, "865883062545150"));
- 
 
 1104 
        offerList.add(Pair.of(2590, "865883065204417"));
- 
 
 1105 
        offerList.add(Pair.of(2590, "865883067203516"));
- 
 
 1106 
        offerList.add(Pair.of(2590, "865883068436958"));
- 
 
 1107 
        offerList.add(Pair.of(2590, "866518077066912"));
- 
 
 1108 
        offerList.add(Pair.of(2590, "866518078367038"));
- 
 
 1109 
        offerList.add(Pair.of(2590, "866518078369216"));
- 
 
 1110 
        offerList.add(Pair.of(2590, "866518078640913"));
- 
 
 1111 
        offerList.add(Pair.of(2590, "866518078777830"));
- 
 
 1112 
        offerList.add(Pair.of(2590, "866518079106039"));
- 
 
 1113 
        offerList.add(Pair.of(2590, "866518079732412"));
- 
 
 1114 
        offerList.add(Pair.of(2590, "868544060022835"));
- 
 
 1115 
        offerList.add(Pair.of(2590, "868938060097518"));
- 
 
 1116 
        offerList.add(Pair.of(2590, "868938060268119"));
- 
 
 1117 
        offerList.add(Pair.of(2590, "868938061524171"));
- 
 
 1118 
        offerList.add(Pair.of(2590, "868938062621315"));
- 
 
 1119 
        offerList.add(Pair.of(2888, "860538070443138"));
- 
 
 1120 
        offerList.add(Pair.of(2888, "860538072146754"));
- 
 
 1121 
        offerList.add(Pair.of(2888, "860538072989955"));
- 
 
 1122 
        offerList.add(Pair.of(2888, "860538072990938"));
- 
 
 1123 
        offerList.add(Pair.of(2888, "860538074608413"));
- 
 
 1124 
        offerList.add(Pair.of(2888, "860538074609650"));
- 
 
 1125 
        offerList.add(Pair.of(2888, "860538074609718"));
- 
 
 1126 
        offerList.add(Pair.of(2888, "860538074610179"));
- 
 
 1127 
        offerList.add(Pair.of(2888, "860538075012631"));
- 
 
 1128 
        offerList.add(Pair.of(2888, "860538075046373"));
- 
 
 1129 
        offerList.add(Pair.of(2888, "860538075048619"));
- 
 
 1130 
        offerList.add(Pair.of(2888, "860538075049674"));
- 
 
 1131 
        offerList.add(Pair.of(2888, "860538075050219"));
- 
 
 1132 
        offerList.add(Pair.of(2888, "860538075104719"));
- 
 
 1133 
        offerList.add(Pair.of(2888, "860538075106177"));
- 
 
 1134 
        offerList.add(Pair.of(2888, "860538075106458"));
- 
 
 1135 
        offerList.add(Pair.of(2888, "860538075107712"));
- 
 
 1136 
        offerList.add(Pair.of(2888, "860538075109056"));
- 
 
 1137 
        offerList.add(Pair.of(2888, "860538075111292"));
- 
 
 1138 
        offerList.add(Pair.of(2888, "861288074171272"));
- 
 
 1139 
        offerList.add(Pair.of(2888, "861288074520072"));
- 
 
 1140 
        offerList.add(Pair.of(2888, "865106074441972"));
- 
 
 1141 
        offerList.add(Pair.of(2888, "865106074450411"));
- 
 
 1142 
        offerList.add(Pair.of(2888, "865106075324854"));
- 
 
 1143 
        offerList.add(Pair.of(2888, "865106075624675"));
- 
 
 1144 
        offerList.add(Pair.of(2888, "865883069364696"));
- 
 
 1145 
        offerList.add(Pair.of(2888, "868544061909170"));
- 
 
 1146 
        offerList.add(Pair.of(2888, "868544063696338"));
- 
 
 1147 
        offerList.add(Pair.of(2888, "868938069806216"));
- 
 
 1148 
        offerList.add(Pair.of(2888, "868938069813451"));
- 
 
 1149 
        offerList.add(Pair.of(2888, "869425071868714"));
- 
 
 1150 
        offerList.add(Pair.of(2888, "869425071884653"));
- 
 
 1151 
        offerList.add(Pair.of(1912, "350592162065959"));
- 
 
 1152 
        offerList.add(Pair.of(1912, "350592162072112"));
- 
 
 1153 
        offerList.add(Pair.of(1912, "350592162087698"));
- 
 
 1154 
        offerList.add(Pair.of(1912, "350592162089553"));
- 
 
 1155 
        offerList.add(Pair.of(1912, "350592162089819"));
- 
 
 1156 
        offerList.add(Pair.of(1912, "350592162090478"));
- 
 
 1157 
        offerList.add(Pair.of(1912, "350592162091476"));
- 
 
 1158 
        offerList.add(Pair.of(1912, "350592162091492"));
- 
 
 1159 
        offerList.add(Pair.of(1912, "350592162093472"));
- 
 
 1160 
        offerList.add(Pair.of(1912, "350592162093498"));
- 
 
 1161 
        offerList.add(Pair.of(1912, "350592162094553"));
- 
 
 1162 
        offerList.add(Pair.of(1912, "350592162095196"));
- 
 
 1163 
        offerList.add(Pair.of(1912, "350592162095618"));
- 
 
 1164 
        offerList.add(Pair.of(1912, "350592162095857"));
- 
 
 1165 
        offerList.add(Pair.of(1912, "350592162095873"));
- 
 
 1166 
        offerList.add(Pair.of(1912, "350592162096251"));
- 
 
 1167 
        offerList.add(Pair.of(1912, "350592162096731"));
- 
 
 1168 
        offerList.add(Pair.of(1912, "350592162096996"));
- 
 
 1169 
        offerList.add(Pair.of(1912, "350592162097234"));
- 
 
 1170 
        offerList.add(Pair.of(1912, "350592162097374"));
- 
 
 1171 
        offerList.add(Pair.of(1912, "350592162097416"));
- 
 
 1172 
        offerList.add(Pair.of(1912, "350592162097713"));
- 
 
 1173 
        offerList.add(Pair.of(1912, "350592162098034"));
- 
 
 1174 
        offerList.add(Pair.of(1912, "350592162098059"));
- 
 
 1175 
        offerList.add(Pair.of(1912, "350592162098190"));
- 
 
 1176 
        offerList.add(Pair.of(1912, "350592162098554"));
- 
 
 1177 
        offerList.add(Pair.of(1912, "350592162098638"));
- 
 
 1178 
        offerList.add(Pair.of(1912, "350592162098851"));
- 
 
 1179 
        offerList.add(Pair.of(1912, "350592162099115"));
- 
 
 1180 
        offerList.add(Pair.of(1912, "350592162099156"));
- 
 
 1181 
        offerList.add(Pair.of(1912, "350592162099537"));
- 
 
 1182 
        offerList.add(Pair.of(1912, "350592162099636"));
- 
 
 1183 
        offerList.add(Pair.of(1912, "350592162099818"));
- 
 
 1184 
        offerList.add(Pair.of(1912, "350592162099875"));
- 
 
 1185 
        offerList.add(Pair.of(1912, "350592162100236"));
- 
 
 1186 
        offerList.add(Pair.of(1912, "350592162100293"));
- 
 
 1187 
        offerList.add(Pair.of(1912, "350592162100475"));
- 
 
 1188 
        offerList.add(Pair.of(1912, "350592162100590"));
- 
 
 1189 
        offerList.add(Pair.of(1912, "350592162100897"));
- 
 
 1190 
        offerList.add(Pair.of(1912, "350592162101390"));
- 
 
 1191 
        offerList.add(Pair.of(1912, "350592162101499"));
- 
 
 1192 
        offerList.add(Pair.of(1912, "350592162101531"));
- 
 
 1193 
        offerList.add(Pair.of(1912, "350592162101655"));
- 
 
 1194 
        offerList.add(Pair.of(1912, "350592162101671"));
- 
 
 1195 
        offerList.add(Pair.of(1912, "350592162101697"));
- 
 
 1196 
        offerList.add(Pair.of(1912, "350592162102034"));
- 
 
 1197 
        offerList.add(Pair.of(1912, "350592162102075"));
- 
 
 1198 
        offerList.add(Pair.of(1912, "350592162102117"));
- 
 
 1199 
        offerList.add(Pair.of(1912, "350592162102232"));
- 
 
 1200 
        offerList.add(Pair.of(1912, "350592162102273"));
- 
 
 1201 
        offerList.add(Pair.of(1912, "350592162102398"));
- 
 
 1202 
        offerList.add(Pair.of(1912, "350592162102638"));
- 
 
 1203 
        offerList.add(Pair.of(1912, "350592162103156"));
- 
 
 1204 
        offerList.add(Pair.of(1912, "350592162103198"));
- 
 
 1205 
        offerList.add(Pair.of(1912, "350592162103370"));
- 
 
 1206 
        offerList.add(Pair.of(1912, "350592162103396"));
- 
 
 1207 
        offerList.add(Pair.of(1912, "350592162105235"));
- 
 
 1208 
        offerList.add(Pair.of(1912, "350592162106258"));
- 
 
 1209 
        offerList.add(Pair.of(1912, "350592162107850"));
- 
 
 1210 
        offerList.add(Pair.of(1912, "350592162108312"));
- 
 
 1211 
        offerList.add(Pair.of(1912, "350592162108478"));
- 
 
 1212 
        offerList.add(Pair.of(1912, "350592162109971"));
- 
 
 1213 
        offerList.add(Pair.of(1912, "350592162110250"));
- 
 
 1214 
        offerList.add(Pair.of(1912, "350592162110292"));
- 
 
 1215 
        offerList.add(Pair.of(1912, "350592162110631"));
- 
 
 1216 
        offerList.add(Pair.of(1912, "350592162110912"));
- 
 
 1217 
        offerList.add(Pair.of(1912, "350592162111373"));
- 
 
 1218 
        offerList.add(Pair.of(1912, "350592162111399"));
- 
 
 1219 
        offerList.add(Pair.of(1912, "350592162111472"));
- 
 
 1220 
        offerList.add(Pair.of(1912, "350592162111670"));
- 
 
 1221 
        offerList.add(Pair.of(1912, "350592162111951"));
- 
 
 1222 
        offerList.add(Pair.of(1912, "350592162111977"));
- 
 
 1223 
        offerList.add(Pair.of(1912, "350592162112470"));
- 
 
 1224 
        offerList.add(Pair.of(1912, "350592162112736"));
- 
 
 1225 
        offerList.add(Pair.of(1912, "350592162112751"));
- 
 
 1226 
        offerList.add(Pair.of(1912, "350592162112819"));
- 
 
 1227 
        offerList.add(Pair.of(1912, "350592162113213"));
- 
 
 1228 
        offerList.add(Pair.of(1912, "350592162113379"));
- 
 
 1229 
        offerList.add(Pair.of(1912, "350592162113593"));
- 
 
 1230 
        offerList.add(Pair.of(1912, "350592162113734"));
- 
 
 1231 
        offerList.add(Pair.of(1912, "350592162113759"));
- 
 
 1232 
        offerList.add(Pair.of(1912, "350592162114914"));
- 
 
 1233 
        offerList.add(Pair.of(1912, "350592162115374"));
- 
 
 1234 
        offerList.add(Pair.of(1912, "350592162115598"));
- 
 
 1235 
        offerList.add(Pair.of(1912, "350592162115879"));
- 
 
 1236 
        offerList.add(Pair.of(1912, "350592162115994"));
- 
 
 1237 
        offerList.add(Pair.of(1912, "350592162116174"));
- 
 
 1238 
        offerList.add(Pair.of(1912, "350592162116356"));
- 
 
 1239 
        offerList.add(Pair.of(1912, "350592162116372"));
- 
 
 1240 
        offerList.add(Pair.of(1912, "350592162116539"));
- 
 
 1241 
        offerList.add(Pair.of(1912, "350592162116778"));
- 
 
 1242 
        offerList.add(Pair.of(1912, "350592162116992"));
- 
 
 1243 
        offerList.add(Pair.of(1912, "350592162117131"));
- 
 
 1244 
        offerList.add(Pair.of(1912, "350592162117271"));
- 
 
 1245 
        offerList.add(Pair.of(1912, "350592162117354"));
- 
 
 1246 
        offerList.add(Pair.of(1912, "350592162117370"));
- 
 
 1247 
        offerList.add(Pair.of(1912, "350592162118337"));
- 
 
 1248 
        offerList.add(Pair.of(1912, "350592162118410"));
- 
 
 1249 
        offerList.add(Pair.of(1912, "350592162406435"));
- 
 
 1250 
        offerList.add(Pair.of(1912, "350592162407052"));
- 
 
 1251 
        offerList.add(Pair.of(1912, "350592162707634"));
- 
 
 1252 
        offerList.add(Pair.of(1912, "350592162710596"));
- 
 
 1253 
        offerList.add(Pair.of(1912, "350592162711214"));
- 
 
 1254 
        offerList.add(Pair.of(1912, "350592162715892"));
- 
 
 1255 
        offerList.add(Pair.of(1912, "350592165298755"));
- 
 
 1256 
        offerList.add(Pair.of(1912, "350592165309792"));
- 
 
 1257 
        offerList.add(Pair.of(1912, "350592167314311"));
- 
 
 1258 
        offerList.add(Pair.of(1912, "350592167316076"));
- 
 
 1259 
        offerList.add(Pair.of(1912, "350592167324872"));
- 
 
 1260 
        offerList.add(Pair.of(1912, "350592167325937"));
- 
 
 1261 
        offerList.add(Pair.of(1912, "350592167326133"));
- 
 
 1262 
        offerList.add(Pair.of(1912, "350592167327552"));
- 
 
 1263 
        offerList.add(Pair.of(1912, "350592167327917"));
- 
 
 1264 
        offerList.add(Pair.of(1912, "350592167328238"));
- 
 
 1265 
        offerList.add(Pair.of(1912, "350592167328535"));
- 
 
 1266 
        offerList.add(Pair.of(1912, "350592167328550"));
- 
 
 1267 
        offerList.add(Pair.of(1912, "350592167328717"));
- 
 
 1268 
        offerList.add(Pair.of(1912, "350592167328931"));
- 
 
 1269 
        offerList.add(Pair.of(1912, "350592167329558"));
- 
 
 1270 
        offerList.add(Pair.of(1912, "350592167329772"));
- 
 
 1271 
        offerList.add(Pair.of(1912, "350592167329970"));
- 
 
 1272 
        offerList.add(Pair.of(1912, "350592167330416"));
- 
 
 1273 
        offerList.add(Pair.of(1912, "350592167330697"));
- 
 
 1274 
        offerList.add(Pair.of(1912, "350592167330853"));
- 
 
 1275 
        offerList.add(Pair.of(1912, "350592167330911"));
- 
 
 1276 
        offerList.add(Pair.of(1912, "350592167331018"));
- 
 
 1277 
        offerList.add(Pair.of(1912, "350592167331059"));
- 
 
 1278 
        offerList.add(Pair.of(1912, "350592167331232"));
- 
 
 1279 
        offerList.add(Pair.of(1912, "350592167331299"));
- 
 
 1280 
        offerList.add(Pair.of(1912, "350592167331398"));
- 
 
 1281 
        offerList.add(Pair.of(1912, "350592167331513"));
- 
 
 1282 
        offerList.add(Pair.of(1912, "350592167332172"));
- 
 
 1283 
        offerList.add(Pair.of(1912, "350592167332271"));
- 
 
 1284 
        offerList.add(Pair.of(1912, "350592167332651"));
- 
 
 1285 
        offerList.add(Pair.of(1912, "350592167333097"));
- 
 
 1286 
        offerList.add(Pair.of(1912, "350592167333238"));
- 
 
 1287 
        offerList.add(Pair.of(1912, "350592167333477"));
- 
 
 1288 
        offerList.add(Pair.of(1912, "350592167333550"));
- 
 
 1289 
        offerList.add(Pair.of(1912, "350592167333618"));
- 
 
 1290 
        offerList.add(Pair.of(1912, "350592167333790"));
- 
 
 1291 
        offerList.add(Pair.of(1912, "350592167334038"));
- 
 
 1292 
        offerList.add(Pair.of(1912, "350592167334673"));
- 
 
 1293 
        offerList.add(Pair.of(1912, "350592167334731"));
- 
 
 1294 
        offerList.add(Pair.of(1912, "350592167334772"));
- 
 
 1295 
        offerList.add(Pair.of(1912, "350592167335290"));
- 
 
 1296 
        offerList.add(Pair.of(1912, "350592167335415"));
- 
 
 1297 
        offerList.add(Pair.of(1912, "350592167335514"));
- 
 
 1298 
        offerList.add(Pair.of(1912, "350592167336694"));
- 
 
 1299 
        offerList.add(Pair.of(1912, "350592167336736"));
- 
 
 1300 
        offerList.add(Pair.of(1912, "350592167336751"));
- 
 
 1301 
        offerList.add(Pair.of(1912, "350592167336850"));
- 
 
 1302 
        offerList.add(Pair.of(1912, "350592167337098"));
- 
 
 1303 
        offerList.add(Pair.of(1912, "350592167337338"));
- 
 
 1304 
        offerList.add(Pair.of(1912, "350592167337692"));
- 
 
 1305 
        offerList.add(Pair.of(1912, "350592167337916"));
- 
 
 1306 
        offerList.add(Pair.of(1912, "350592167338054"));
- 
 
 1307 
        offerList.add(Pair.of(1912, "350592167338179"));
- 
 
 1308 
        offerList.add(Pair.of(1912, "350592167338336"));
- 
 
 1309 
        offerList.add(Pair.of(1912, "350592167338377"));
- 
 
 1310 
        offerList.add(Pair.of(1912, "350592167338492"));
- 
 
 1311 
        offerList.add(Pair.of(1912, "350592167338534"));
- 
 
 1312 
        offerList.add(Pair.of(1912, "350592167338617"));
- 
 
 1313 
        offerList.add(Pair.of(1912, "350592167338799"));
- 
 
 1314 
        offerList.add(Pair.of(1912, "350592167338815"));
- 
 
 1315 
        offerList.add(Pair.of(1912, "350592167338898"));
- 
 
 1316 
        offerList.add(Pair.of(1912, "350592167339052"));
- 
 
 1317 
        offerList.add(Pair.of(1912, "350592167339078"));
- 
 
 1318 
        offerList.add(Pair.of(1912, "350592167339094"));
- 
 
 1319 
        offerList.add(Pair.of(1912, "350592167339110"));
- 
 
 1320 
        offerList.add(Pair.of(1912, "350592167339151"));
- 
 
 1321 
        offerList.add(Pair.of(1912, "350592167339177"));
- 
 
 1322 
        offerList.add(Pair.of(1912, "350592167339193"));
- 
 
 1323 
        offerList.add(Pair.of(1912, "350592167339219"));
- 
 
 1324 
        offerList.add(Pair.of(1912, "350592167339235"));
- 
 
 1325 
        offerList.add(Pair.of(1912, "350592167339359"));
- 
 
 1326 
        offerList.add(Pair.of(1912, "350592167339375"));
- 
 
 1327 
        offerList.add(Pair.of(1912, "350592167339557"));
- 
 
 1328 
        offerList.add(Pair.of(1912, "350592167339854"));
- 
 
 1329 
        offerList.add(Pair.of(1912, "350592167339979"));
- 
 
 1330 
        offerList.add(Pair.of(1912, "350592167339995"));
- 
 
 1331 
        offerList.add(Pair.of(1912, "350592167340035"));
- 
 
 1332 
        offerList.add(Pair.of(1912, "350592167340092"));
- 
 
 1333 
        offerList.add(Pair.of(1912, "350592167340290"));
- 
 
 1334 
        offerList.add(Pair.of(1912, "350592167340415"));
- 
 
 1335 
        offerList.add(Pair.of(1912, "350592167340597"));
- 
 
 1336 
        offerList.add(Pair.of(1912, "350592167340878"));
- 
 
 1337 
        offerList.add(Pair.of(1912, "350592167340910"));
- 
 
 1338 
        offerList.add(Pair.of(1912, "350592167341157"));
- 
 
 1339 
        offerList.add(Pair.of(1912, "350592167341215"));
- 
 
 1340 
        offerList.add(Pair.of(1912, "350592167341454"));
- 
 
 1341 
        offerList.add(Pair.of(1912, "350592167341496"));
- 
 
 1342 
        offerList.add(Pair.of(1912, "350592167341678"));
- 
 
 1343 
        offerList.add(Pair.of(1912, "350592167341694"));
- 
 
 1344 
        offerList.add(Pair.of(1912, "350592167341777"));
- 
 
 1345 
        offerList.add(Pair.of(1912, "350592167341793"));
- 
 
 1346 
        offerList.add(Pair.of(1912, "350592167341819"));
- 
 
 1347 
        offerList.add(Pair.of(1912, "350592167341850"));
- 
 
 1348 
        offerList.add(Pair.of(1912, "350592167341934"));
- 
 
 1349 
        offerList.add(Pair.of(1912, "350592167342015"));
- 
 
 1350 
        offerList.add(Pair.of(1912, "350592167342155"));
- 
 
 1351 
        offerList.add(Pair.of(1912, "350592167342254"));
- 
 
 1352 
        offerList.add(Pair.of(1912, "350592167342379"));
- 
 
 1353 
        offerList.add(Pair.of(1912, "350592167342510"));
- 
 
 1354 
        offerList.add(Pair.of(1912, "350592167342593"));
- 
 
 1355 
        offerList.add(Pair.of(1912, "350592167342619"));
- 
 
 1356 
        offerList.add(Pair.of(1912, "350592167342650"));
- 
 
 1357 
        offerList.add(Pair.of(1912, "350592167342833"));
- 
 
 1358 
        offerList.add(Pair.of(1912, "350592167342858"));
- 
 
 1359 
        offerList.add(Pair.of(1912, "350592167342874"));
- 
 
 1360 
        offerList.add(Pair.of(1912, "350592167343054"));
- 
 
 1361 
        offerList.add(Pair.of(1912, "350592167343070"));
- 
 
 1362 
        offerList.add(Pair.of(1912, "350592167343112"));
- 
 
 1363 
        offerList.add(Pair.of(1912, "350592167343393"));
- 
 
 1364 
        offerList.add(Pair.of(1912, "350592167343419"));
- 
 
 1365 
        offerList.add(Pair.of(1912, "350592167343435"));
- 
 
 1366 
        offerList.add(Pair.of(1912, "350592167343476"));
- 
 
 1367 
        offerList.add(Pair.of(1912, "350592167343591"));
- 
 
 1368 
        offerList.add(Pair.of(1912, "350592167343658"));
- 
 
 1369 
        offerList.add(Pair.of(1912, "350592167343690"));
- 
 
 1370 
        offerList.add(Pair.of(1912, "350592167343799"));
- 
 
 1371 
        offerList.add(Pair.of(1912, "350592167343856"));
- 
 
 1372 
        offerList.add(Pair.of(1912, "350592167343872"));
- 
 
 1373 
        offerList.add(Pair.of(1912, "350592167343898"));
- 
 
 1374 
        offerList.add(Pair.of(1912, "350592167343955"));
- 
 
 1375 
        offerList.add(Pair.of(1912, "350592167344177"));
- 
 
 1376 
        offerList.add(Pair.of(1912, "350592167344235"));
- 
 
 1377 
        offerList.add(Pair.of(1912, "350592167344458"));
- 
 
 1378 
        offerList.add(Pair.of(1912, "350592167344730"));
- 
 
 1379 
        offerList.add(Pair.of(1912, "350592167344854"));
- 
 
 1380 
        offerList.add(Pair.of(1912, "350592167345034"));
- 
 
 1381 
        offerList.add(Pair.of(1912, "350592167345117"));
- 
 
 1382 
        offerList.add(Pair.of(1912, "350592167345158"));
- 
 
 1383 
        offerList.add(Pair.of(1912, "350592167345190"));
- 
 
 1384 
        offerList.add(Pair.of(1912, "350592167345356"));
- 
 
 1385 
        offerList.add(Pair.of(1912, "350592167345398"));
- 
 
 1386 
        offerList.add(Pair.of(1912, "350592167345414"));
- 
 
 1387 
        offerList.add(Pair.of(1912, "350592167345539"));
- 
 
 1388 
        offerList.add(Pair.of(1912, "350592167345695"));
- 
 
 1389 
        offerList.add(Pair.of(1912, "350592167345711"));
- 
 
 1390 
        offerList.add(Pair.of(1912, "350592167345737"));
- 
 
 1391 
        offerList.add(Pair.of(1912, "350592167345919"));
- 
 
 1392 
        offerList.add(Pair.of(1912, "350592167346214"));
- 
 
 1393 
        offerList.add(Pair.of(1912, "350592167346255"));
- 
 
 1394 
        offerList.add(Pair.of(1912, "350592167346354"));
- 
 
 1395 
        offerList.add(Pair.of(1912, "350592167346792"));
- 
 
 1396 
        offerList.add(Pair.of(1912, "350592167347014"));
- 
 
 1397 
        offerList.add(Pair.of(1912, "350592167347774"));
- 
 
 1398 
        offerList.add(Pair.of(1912, "350592167440538"));
- 
 
 1399 
        offerList.add(Pair.of(1912, "350592167445792"));
- 
 
 1400 
        offerList.add(Pair.of(1912, "350592167446634"));
- 
 
 1401 
        offerList.add(Pair.of(1912, "350592167447012"));
- 
 
 1402 
        offerList.add(Pair.of(1912, "350592167447194"));
- 
 
 1403 
        offerList.add(Pair.of(1912, "350592168757997"));
- 
 
 1404 
        offerList.add(Pair.of(1912, "350592168834911"));
- 
 
 1405 
        offerList.add(Pair.of(1912, "350592168835058"));
- 
 
 1406 
        offerList.add(Pair.of(1912, "350592168835173"));
- 
 
 1407 
        offerList.add(Pair.of(1912, "350592168851774"));
- 
 
 1408 
        offerList.add(Pair.of(1912, "350592168869412"));
- 
 
 1409 
        offerList.add(Pair.of(1912, "350592168879197"));
- 
 
 1410 
        offerList.add(Pair.of(1912, "350592168880039"));
- 
 
 1411 
        offerList.add(Pair.of(1912, "350592168908772"));
- 
 
 1412 
        offerList.add(Pair.of(1912, "350592168920710"));
- 
 
 1413 
        offerList.add(Pair.of(1912, "355358276015610"));
- 
 
 1414 
        offerList.add(Pair.of(1912, "355358276019430"));
- 
 
 1415 
        offerList.add(Pair.of(1912, "355358276019539"));
- 
 
 1416 
        offerList.add(Pair.of(1912, "355358276019737"));
- 
 
 1417 
        offerList.add(Pair.of(1912, "355358276020735"));
- 
 
 1418 
        offerList.add(Pair.of(1912, "355358276020750"));
- 
 
 1419 
        offerList.add(Pair.of(1912, "355358276021279"));
- 
 
 1420 
        offerList.add(Pair.of(1912, "355358276022632"));
- 
 
 1421 
        offerList.add(Pair.of(1912, "355358276024174"));
- 
 
 1422 
        offerList.add(Pair.of(1912, "355358276032292"));
- 
 
 1423 
        offerList.add(Pair.of(1912, "355358276036616"));
- 
 
 1424 
        offerList.add(Pair.of(1912, "355358276044974"));
- 
 
 1425 
        offerList.add(Pair.of(1912, "355358276047290"));
- 
 
 1426 
        offerList.add(Pair.of(1912, "355358276047779"));
- 
 
 1427 
        offerList.add(Pair.of(1912, "355358276048611"));
- 
 
 1428 
        offerList.add(Pair.of(1912, "355358276049015"));
- 
 
 1429 
        offerList.add(Pair.of(1912, "355358276051532"));
- 
 
 1430 
        offerList.add(Pair.of(1912, "355358276051979"));
- 
 
 1431 
        offerList.add(Pair.of(1912, "355358276052878"));
- 
 
 1432 
        offerList.add(Pair.of(1912, "355358276053256"));
- 
 
 1433 
        offerList.add(Pair.of(1912, "355358276053439"));
- 
 
 1434 
        offerList.add(Pair.of(1912, "355358276053470"));
- 
 
 1435 
        offerList.add(Pair.of(1912, "355358276054197"));
- 
 
 1436 
        offerList.add(Pair.of(1912, "355358276054411"));
- 
 
 1437 
        offerList.add(Pair.of(1912, "355358276054536"));
- 
 
 1438 
        offerList.add(Pair.of(1912, "355358276054817"));
- 
 
 1439 
        offerList.add(Pair.of(1912, "355358276055210"));
- 
 
 1440 
        offerList.add(Pair.of(1912, "355358276055897"));
- 
 
 1441 
        offerList.add(Pair.of(1912, "355358276055970"));
- 
 
 1442 
        offerList.add(Pair.of(1912, "355358276056499"));
- 
 
 1443 
        offerList.add(Pair.of(1912, "355358276056572"));
- 
 
 1444 
        offerList.add(Pair.of(1912, "355358276057190"));
- 
 
 1445 
        offerList.add(Pair.of(1912, "355358276057299"));
- 
 
 1446 
        offerList.add(Pair.of(1912, "355358276059410"));
- 
 
 1447 
        offerList.add(Pair.of(1912, "355358276059832"));
- 
 
 1448 
        offerList.add(Pair.of(1912, "355358276061119"));
- 
 
 1449 
        offerList.add(Pair.of(1912, "355358276067116"));
- 
 
 1450 
        offerList.add(Pair.of(1912, "355358276067637"));
- 
 
 1451 
        offerList.add(Pair.of(1912, "355358276067975"));
- 
 
 1452 
        offerList.add(Pair.of(1912, "355358276068056"));
- 
 
 1453 
        offerList.add(Pair.of(1912, "355358276068577"));
- 
 
 1454 
        offerList.add(Pair.of(1912, "355358276068593"));
- 
 
 1455 
        offerList.add(Pair.of(1912, "355358276069674"));
- 
 
 1456 
        offerList.add(Pair.of(1912, "355358276069732"));
- 
 
 1457 
        offerList.add(Pair.of(1912, "355358276071878"));
- 
 
 1458 
        offerList.add(Pair.of(1912, "355358276072272"));
- 
 
 1459 
        offerList.add(Pair.of(1912, "355358276072652"));
- 
 
 1460 
        offerList.add(Pair.of(1912, "355358276073130"));
- 
 
 1461 
        offerList.add(Pair.of(1912, "355358276073296"));
- 
 
 1462 
        offerList.add(Pair.of(1912, "355358276073650"));
- 
 
 1463 
        offerList.add(Pair.of(1912, "355358276074476"));
- 
 
 1464 
        offerList.add(Pair.of(1912, "355358276074732"));
- 
 
 1465 
        offerList.add(Pair.of(1912, "355358276074815"));
- 
 
 1466 
        offerList.add(Pair.of(1912, "355358276076430"));
- 
 
 1467 
        offerList.add(Pair.of(1912, "355358276079095"));
- 
 
 1468 
        offerList.add(Pair.of(1912, "355358276079699"));
- 
 
 1469 
        offerList.add(Pair.of(1912, "355358276079897"));
- 
 
 1470 
        offerList.add(Pair.of(1912, "355358276716555"));
- 
 
 1471 
        offerList.add(Pair.of(1912, "355358276722637"));
- 
 
 1472 
        offerList.add(Pair.of(1912, "355358276724310"));
- 
 
 1473 
        offerList.add(Pair.of(1912, "355358276729996"));
- 
 
 1474 
        offerList.add(Pair.of(1912, "355358276730218"));
- 
 
 1475 
        offerList.add(Pair.of(1912, "355358276730994"));
- 
 
 1476 
        offerList.add(Pair.of(1912, "355358276732230"));
- 
 
 1477 
        offerList.add(Pair.of(1912, "355358276733592"));
- 
 
 1478 
        offerList.add(Pair.of(1912, "355358276734517"));
- 
 
 1479 
        offerList.add(Pair.of(1912, "355358276736611"));
- 
 
 1480 
        offerList.add(Pair.of(1912, "355358276738591"));
- 
 
 1481 
        offerList.add(Pair.of(1912, "355480685059235"));
- 
 
 1482 
        offerList.add(Pair.of(1912, "355480686961116"));
- 
 
 1483 
        offerList.add(Pair.of(1912, "355480686961876"));
- 
 
 1484 
        offerList.add(Pair.of(1912, "355480686962890"));
- 
 
 1485 
        offerList.add(Pair.of(1912, "355480686965034"));
- 
 
 1486 
        offerList.add(Pair.of(1912, "355480686966115"));
- 
 
 1487 
        offerList.add(Pair.of(1912, "355480687449277"));
- 
 
 1488 
        offerList.add(Pair.of(1912, "355480687491337"));
- 
 
 1489 
        offerList.add(Pair.of(1912, "355480687491394"));
- 
 
 1490 
        offerList.add(Pair.of(1912, "355480687491576"));
- 
 
 1491 
        offerList.add(Pair.of(1912, "355480687491592"));
- 
 
 1492 
        offerList.add(Pair.of(1912, "355480687491675"));
- 
 
 1493 
        offerList.add(Pair.of(1912, "355480687491717"));
- 
 
 1494 
        offerList.add(Pair.of(1912, "355480687491972"));
- 
 
 1495 
        offerList.add(Pair.of(1912, "355480687492038"));
- 
 
 1496 
        offerList.add(Pair.of(1912, "355480687492095"));
- 
 
 1497 
        offerList.add(Pair.of(1912, "355480687492376"));
- 
 
 1498 
        offerList.add(Pair.of(1912, "355480687492418"));
- 
 
 1499 
        offerList.add(Pair.of(1912, "355480687492517"));
- 
 
 1500 
        offerList.add(Pair.of(1912, "355480687492673"));
- 
 
 1501 
        offerList.add(Pair.of(1912, "355480687492699"));
- 
 
 1502 
        offerList.add(Pair.of(1912, "355480687492731"));
- 
 
 1503 
        offerList.add(Pair.of(1912, "355480687492756"));
- 
 
 1504 
        offerList.add(Pair.of(1912, "355480687492897"));
- 
 
 1505 
        offerList.add(Pair.of(1912, "355480687492913"));
- 
 
 1506 
        offerList.add(Pair.of(1912, "355480687492939"));
- 
 
 1507 
        offerList.add(Pair.of(1912, "355480687493051"));
- 
 
 1508 
        offerList.add(Pair.of(1912, "355480687493077"));
- 
 
 1509 
        offerList.add(Pair.of(1912, "355480687493119"));
- 
 
 1510 
        offerList.add(Pair.of(1912, "355480687493192"));
- 
 
 1511 
        offerList.add(Pair.of(1912, "355480687493234"));
- 
 
 1512 
        offerList.add(Pair.of(1912, "355480687493515"));
- 
 
 1513 
        offerList.add(Pair.of(1912, "355480687493630"));
- 
 
 1514 
        offerList.add(Pair.of(1912, "355480687493713"));
- 
 
 1515 
        offerList.add(Pair.of(1912, "355480687493739"));
- 
 
 1516 
        offerList.add(Pair.of(1912, "355480687493796"));
- 
 
 1517 
        offerList.add(Pair.of(1912, "355480687493853"));
- 
 
 1518 
        offerList.add(Pair.of(1912, "355480687494398"));
- 
 
 1519 
        offerList.add(Pair.of(1912, "355480687494497"));
- 
 
 1520 
        offerList.add(Pair.of(1912, "355480687494570"));
- 
 
 1521 
        offerList.add(Pair.of(1912, "355480687494653"));
- 
 
 1522 
        offerList.add(Pair.of(1912, "355480687494711"));
- 
 
 1523 
        offerList.add(Pair.of(1912, "355480687494851"));
- 
 
 1524 
        offerList.add(Pair.of(1912, "355480687494877"));
- 
 
 1525 
        offerList.add(Pair.of(1912, "355480687494935"));
- 
 
 1526 
        offerList.add(Pair.of(1912, "355480687495015"));
- 
 
 1527 
        offerList.add(Pair.of(1912, "355480687495114"));
- 
 
 1528 
        offerList.add(Pair.of(1912, "355480687495130"));
- 
 
 1529 
        offerList.add(Pair.of(1912, "355480687495411"));
- 
 
 1530 
        offerList.add(Pair.of(1912, "355480687495510"));
- 
 
 1531 
        offerList.add(Pair.of(1912, "355480687495536"));
- 
 
 1532 
        offerList.add(Pair.of(1912, "355480687495593"));
- 
 
 1533 
        offerList.add(Pair.of(1912, "355480687495650"));
- 
 
 1534 
        offerList.add(Pair.of(1912, "355480687495775"));
- 
 
 1535 
        offerList.add(Pair.of(1912, "355480687496013"));
- 
 
 1536 
        offerList.add(Pair.of(1912, "355480687496179"));
- 
 
 1537 
        offerList.add(Pair.of(1912, "355480687496237"));
- 
 
 1538 
        offerList.add(Pair.of(1912, "355480687496393"));
- 
 
 1539 
        offerList.add(Pair.of(1912, "355480687496435"));
- 
 
 1540 
        offerList.add(Pair.of(1912, "355480687496518"));
- 
 
 1541 
        offerList.add(Pair.of(1912, "355480687496575"));
- 
 
 1542 
        offerList.add(Pair.of(1912, "355480687496658"));
- 
 
 1543 
        offerList.add(Pair.of(1912, "355480687496815"));
- 
 
 1544 
        offerList.add(Pair.of(1912, "355480687496872"));
- 
 
 1545 
        offerList.add(Pair.of(1912, "355480687496898"));
- 
 
 1546 
        offerList.add(Pair.of(1912, "355480687496914"));
- 
 
 1547 
        offerList.add(Pair.of(1912, "355480687496930"));
- 
 
 1548 
        offerList.add(Pair.of(1912, "355480687497011"));
- 
 
 1549 
        offerList.add(Pair.of(1912, "355480687497037"));
- 
 
 1550 
        offerList.add(Pair.of(1912, "355480687497193"));
- 
 
 1551 
        offerList.add(Pair.of(1912, "355480687497235"));
- 
 
 1552 
        offerList.add(Pair.of(1912, "355480687497359"));
- 
 
 1553 
        offerList.add(Pair.of(1912, "355480687497417"));
- 
 
 1554 
        offerList.add(Pair.of(1912, "355480687497433"));
- 
 
 1555 
        offerList.add(Pair.of(1912, "355480687497474"));
- 
 
 1556 
        offerList.add(Pair.of(1912, "355480687497490"));
- 
 
 1557 
        offerList.add(Pair.of(1912, "355480687497532"));
- 
 
 1558 
        offerList.add(Pair.of(1912, "355480687497599"));
- 
 
 1559 
        offerList.add(Pair.of(1912, "355480687497896"));
- 
 
 1560 
        offerList.add(Pair.of(1912, "355480687498571"));
- 
 
 1561 
        offerList.add(Pair.of(1912, "355480687498779"));
- 
 
 1562 
        offerList.add(Pair.of(1912, "355480687498993"));
- 
 
 1563 
        offerList.add(Pair.of(1912, "355480687499033"));
- 
 
 1564 
        offerList.add(Pair.of(1912, "355480687499090"));
- 
 
 1565 
        offerList.add(Pair.of(1912, "355480687499157"));
- 
 
 1566 
        offerList.add(Pair.of(1912, "355480687499272"));
- 
 
 1567 
        offerList.add(Pair.of(1912, "355480687499298"));
- 
 
 1568 
        offerList.add(Pair.of(1912, "355480687499538"));
- 
 
 1569 
        offerList.add(Pair.of(1912, "355480687499595"));
- 
 
 1570 
        offerList.add(Pair.of(1912, "355480687499637"));
- 
 
 1571 
        offerList.add(Pair.of(1912, "355480687499694"));
- 
 
 1572 
        offerList.add(Pair.of(1912, "355480687499751"));
- 
 
 1573 
        offerList.add(Pair.of(1912, "355480687499959"));
- 
 
 1574 
        offerList.add(Pair.of(1912, "355480687499991"));
- 
 
 1575 
        offerList.add(Pair.of(1912, "355480687500095"));
- 
 
 1576 
        offerList.add(Pair.of(1912, "355480687500111"));
- 
 
 1577 
        offerList.add(Pair.of(1912, "355480687500293"));
- 
 
 1578 
        offerList.add(Pair.of(1912, "355480687500319"));
- 
 
 1579 
        offerList.add(Pair.of(1912, "355480687500392"));
- 
 
 1580 
        offerList.add(Pair.of(1912, "355480687500434"));
- 
 
 1581 
        offerList.add(Pair.of(1912, "355480687500517"));
- 
 
 1582 
        offerList.add(Pair.of(1912, "355480687500772"));
- 
 
 1583 
        offerList.add(Pair.of(1912, "355480687500830"));
- 
 
 1584 
        offerList.add(Pair.of(1912, "355480687500897"));
- 
 
 1585 
        offerList.add(Pair.of(1912, "355480687500970"));
- 
 
 1586 
        offerList.add(Pair.of(1912, "355480687501010"));
- 
 
 1587 
        offerList.add(Pair.of(1912, "355480687501036"));
- 
 
 1588 
        offerList.add(Pair.of(1912, "355480687501077"));
- 
 
 1589 
        offerList.add(Pair.of(1912, "355480687501119"));
- 
 
 1590 
        offerList.add(Pair.of(1912, "355480687501218"));
- 
 
 1591 
        offerList.add(Pair.of(1912, "355480687501317"));
- 
 
 1592 
        offerList.add(Pair.of(1912, "355480687501358"));
- 
 
 1593 
        offerList.add(Pair.of(1912, "355480687501556"));
- 
 
 1594 
        offerList.add(Pair.of(1912, "355480687501697"));
- 
 
 1595 
        offerList.add(Pair.of(1912, "355480687501853"));
- 
 
 1596 
        offerList.add(Pair.of(1912, "355480687501978"));
- 
 
 1597 
        offerList.add(Pair.of(1912, "355480687502059"));
- 
 
 1598 
        offerList.add(Pair.of(1912, "355480687502091"));
- 
 
 1599 
        offerList.add(Pair.of(1912, "355480687502133"));
- 
 
 1600 
        offerList.add(Pair.of(1912, "355480687502570"));
- 
 
 1601 
        offerList.add(Pair.of(1912, "355480688566350"));
- 
 
 1602 
        offerList.add(Pair.of(1912, "355480688568653"));
- 
 
 1603 
        offerList.add(Pair.of(1912, "355480688569370"));
- 
 
 1604 
        offerList.add(Pair.of(1912, "355480688570378"));
- 
 
 1605 
        offerList.add(Pair.of(1912, "355480688572374"));
- 
 
 1606 
        offerList.add(Pair.of(1912, "355480688573976"));
- 
 
 1607 
        offerList.add(Pair.of(1912, "355480688574131"));
- 
 
 1608 
        offerList.add(Pair.of(1912, "355480688576334"));
- 
 
 1609 
        offerList.add(Pair.of(1912, "355480688577936"));
- 
 
 1610 
        offerList.add(Pair.of(1912, "355480688578470"));
- 
 
 1611 
        offerList.add(Pair.of(1912, "355480688579452"));
- 
 
 1612 
        offerList.add(Pair.of(1912, "355480688580179"));
- 
 
 1613 
        offerList.add(Pair.of(1912, "355480688586572"));
- 
 
 1614 
        offerList.add(Pair.of(1912, "355480688586879"));
- 
 
 1615 
        offerList.add(Pair.of(1912, "355480688587075"));
- 
 
 1616 
        offerList.add(Pair.of(1912, "355480688587539"));
- 
 
 1617 
        offerList.add(Pair.of(1912, "355480688588230"));
- 
 
 1618 
        offerList.add(Pair.of(1912, "355480688588354"));
- 
 
 1619 
        offerList.add(Pair.of(1912, "355480688588438"));
- 
 
 1620 
        offerList.add(Pair.of(1912, "355480688588537"));
- 
 
 1621 
        offerList.add(Pair.of(1912, "355480688589873"));
- 
 
 1622 
        offerList.add(Pair.of(1912, "355480688590699"));
- 
 
 1623 
        offerList.add(Pair.of(1912, "355480688591150"));
- 
 
 1624 
        offerList.add(Pair.of(1912, "355480688591291"));
- 
 
 1625 
        offerList.add(Pair.of(1912, "355480688591473"));
- 
 
 1626 
        offerList.add(Pair.of(1912, "355480688591879"));
- 
 
 1627 
        offerList.add(Pair.of(1912, "355480688591952"));
- 
 
 1628 
        offerList.add(Pair.of(1912, "355480688592695"));
- 
 
 1629 
        offerList.add(Pair.of(1912, "355480688593198"));
- 
 
 1630 
        offerList.add(Pair.of(1912, "355480688593339"));
- 
 
 1631 
        offerList.add(Pair.of(1912, "355480688593693"));
- 
 
 1632 
        offerList.add(Pair.of(1912, "355480688594618"));
- 
 
 1633 
        offerList.add(Pair.of(1912, "355480688594998"));
- 
 
 1634 
        offerList.add(Pair.of(1912, "355480688595094"));
- 
 
 1635 
        offerList.add(Pair.of(1912, "355480688595193"));
- 
 
 1636 
        offerList.add(Pair.of(1912, "355480688595276"));
- 
 
 1637 
        offerList.add(Pair.of(1912, "355480688595516"));
- 
 
 1638 
        offerList.add(Pair.of(1912, "355480688595557"));
- 
 
 1639 
        offerList.add(Pair.of(1912, "355480688595870"));
- 
 
 1640 
        offerList.add(Pair.of(1912, "355480688596175"));
- 
 
 1641 
        offerList.add(Pair.of(1912, "355480688596217"));
- 
 
 1642 
        offerList.add(Pair.of(1912, "355480688596373"));
- 
 
 1643 
        offerList.add(Pair.of(1912, "355480688596555"));
- 
 
 1644 
        offerList.add(Pair.of(1912, "355480688596894"));
- 
 
 1645 
        offerList.add(Pair.of(1912, "355480688597017"));
- 
 
 1646 
        offerList.add(Pair.of(1912, "355480688597215"));
- 
 
 1647 
        offerList.add(Pair.of(1912, "355480688597272"));
- 
 
 1648 
        offerList.add(Pair.of(1912, "355480688597330"));
- 
 
 1649 
        offerList.add(Pair.of(1912, "355480688597355"));
- 
 
 1650 
        offerList.add(Pair.of(1912, "355480688597371"));
- 
 
 1651 
        offerList.add(Pair.of(1912, "355480688597439"));
- 
 
 1652 
        offerList.add(Pair.of(1912, "355480688597678"));
- 
 
 1653 
        offerList.add(Pair.of(1912, "355480688597835"));
- 
 
 1654 
        offerList.add(Pair.of(1912, "355480688597876"));
- 
 
 1655 
        offerList.add(Pair.of(1912, "355480688598072"));
- 
 
 1656 
        offerList.add(Pair.of(1912, "355480688598114"));
- 
 
 1657 
        offerList.add(Pair.of(1912, "355480688598197"));
- 
 
 1658 
        offerList.add(Pair.of(1912, "355480688598254"));
- 
 
 1659 
        offerList.add(Pair.of(1912, "355480688598379"));
- 
 
 1660 
        offerList.add(Pair.of(1912, "355480688598619"));
- 
 
 1661 
        offerList.add(Pair.of(1912, "355480688598650"));
- 
 
 1662 
        offerList.add(Pair.of(1912, "355480688598817"));
- 
 
 1663 
        offerList.add(Pair.of(1912, "355480688598858"));
- 
 
 1664 
        offerList.add(Pair.of(1912, "355480688598916"));
- 
 
 1665 
        offerList.add(Pair.of(1912, "355480688599013"));
- 
 
 1666 
        offerList.add(Pair.of(1912, "355480688599153"));
- 
 
 1667 
        offerList.add(Pair.of(1912, "355480688599278"));
- 
 
 1668 
        offerList.add(Pair.of(1912, "355480688599310"));
- 
 
 1669 
        offerList.add(Pair.of(1912, "355480688599351"));
- 
 
 1670 
        offerList.add(Pair.of(1912, "355480688599435"));
- 
 
 1671 
        offerList.add(Pair.of(1912, "355480688599492"));
- 
 
 1672 
        offerList.add(Pair.of(1912, "355480688599534"));
- 
 
 1673 
        offerList.add(Pair.of(1912, "355480688599575"));
- 
 
 1674 
        offerList.add(Pair.of(1912, "355480688599591"));
- 
 
 1675 
        offerList.add(Pair.of(1912, "355480688599658"));
- 
 
 1676 
        offerList.add(Pair.of(1912, "355480688599799"));
- 
 
 1677 
        offerList.add(Pair.of(1912, "355480688599898"));
- 
 
 1678 
        offerList.add(Pair.of(1912, "355480688599955"));
- 
 
 1679 
        offerList.add(Pair.of(1912, "357375370735057"));
- 
 
 1680 
        offerList.add(Pair.of(1912, "357375370738598"));
- 
 
 1681 
        offerList.add(Pair.of(1912, "357375370741295"));
- 
 
 1682 
        offerList.add(Pair.of(1912, "357375370741758"));
- 
 
 1683 
        offerList.add(Pair.of(1912, "357375370742152"));
- 
 
 1684 
        offerList.add(Pair.of(1912, "357375370742251"));
- 
 
 1685 
        offerList.add(Pair.of(1912, "357375370742616"));
- 
 
 1686 
        offerList.add(Pair.of(1912, "357375370744273"));
- 
 
 1687 
        offerList.add(Pair.of(1912, "357375370745015"));
- 
 
 1688 
        offerList.add(Pair.of(1912, "357375370746310"));
- 
 
 1689 
        offerList.add(Pair.of(1912, "357375370746419"));
- 
 
 1690 
        offerList.add(Pair.of(1912, "357375370751013"));
- 
 
 1691 
        offerList.add(Pair.of(1912, "357375370751617"));
- 
 
 1692 
        offerList.add(Pair.of(1912, "357375370752193"));
- 
 
 1693 
        offerList.add(Pair.of(1912, "357375370754819"));
- 
 
 1694 
        offerList.add(Pair.of(1912, "357375370779535"));
- 
 
 1695 
        offerList.add(Pair.of(1912, "357375370780954"));
- 
 
 1696 
        offerList.add(Pair.of(1912, "357375370781390"));
- 
 
 1697 
        offerList.add(Pair.of(1912, "357375370781937"));
- 
 
 1698 
        offerList.add(Pair.of(1912, "357375370781952"));
- 
 
 1699 
        offerList.add(Pair.of(1912, "357375370782133"));
- 
 
 1700 
        offerList.add(Pair.of(1912, "357375370783552"));
- 
 
 1701 
        offerList.add(Pair.of(1912, "357375370783875"));
- 
 
 1702 
        offerList.add(Pair.of(1912, "357375370784659"));
- 
 
 1703 
        offerList.add(Pair.of(1912, "357375370785052"));
- 
 
 1704 
        offerList.add(Pair.of(1912, "357375370785136"));
- 
 
 1705 
        offerList.add(Pair.of(1912, "357375370785938"));
- 
 
 1706 
        offerList.add(Pair.of(1912, "357375370786415"));
- 
 
 1707 
        offerList.add(Pair.of(1912, "357375370787090"));
- 
 
 1708 
        offerList.add(Pair.of(1912, "357375370788130"));
- 
 
 1709 
        offerList.add(Pair.of(1912, "357375370788775"));
- 
 
 1710 
        offerList.add(Pair.of(1912, "357375370789559"));
- 
 
 1711 
        offerList.add(Pair.of(1912, "357375370789633"));
- 
 
 1712 
        offerList.add(Pair.of(1912, "357375370789716"));
- 
 
 1713 
        offerList.add(Pair.of(1912, "357375370790094"));
- 
 
 1714 
        offerList.add(Pair.of(1912, "357375370790334"));
- 
 
 1715 
        offerList.add(Pair.of(1912, "357375370790631"));
- 
 
 1716 
        offerList.add(Pair.of(1912, "357375370790698"));
- 
 
 1717 
        offerList.add(Pair.of(1912, "357375370791050"));
- 
 
 1718 
        offerList.add(Pair.of(1912, "357375370791639"));
- 
 
 1719 
        offerList.add(Pair.of(1912, "357375370792439"));
- 
 
 1720 
        offerList.add(Pair.of(1912, "357375370792991"));
- 
 
 1721 
        offerList.add(Pair.of(1912, "357375370793155"));
- 
 
 1722 
        offerList.add(Pair.of(1912, "357375370794773"));
- 
 
 1723 
        offerList.add(Pair.of(1912, "357375370794856"));
- 
 
 1724 
        offerList.add(Pair.of(1912, "357375370796158"));
- 
 
 1725 
        offerList.add(Pair.of(1912, "357375370796919"));
- 
 
 1726 
        offerList.add(Pair.of(1912, "357375370797057"));
- 
 
 1727 
        offerList.add(Pair.of(1912, "357375370797933"));
- 
 
 1728 
        offerList.add(Pair.of(1912, "357375370798733"));
- 
 
 1729 
        offerList.add(Pair.of(1912, "357375370798998"));
- 
 
 1730 
        offerList.add(Pair.of(1912, "357375370799319"));
- 
 
 1731 
        offerList.add(Pair.of(1912, "357375370800471"));
- 
 
 1732 
        offerList.add(Pair.of(1912, "357375370801057"));
- 
 
 1733 
        offerList.add(Pair.of(1912, "357375370802337"));
- 
 
 1734 
        offerList.add(Pair.of(1912, "357375370804838"));
- 
 
 1735 
        offerList.add(Pair.of(1912, "357375370805017"));
- 
 
 1736 
        offerList.add(Pair.of(1912, "357375370805272"));
- 
 
 1737 
        offerList.add(Pair.of(1912, "357375370809159"));
- 
 
 1738 
        offerList.add(Pair.of(1912, "357375370810173"));
- 
 
 1739 
        offerList.add(Pair.of(1912, "357375370810512"));
- 
 
 1740 
        offerList.add(Pair.of(1912, "357375370814597"));
- 
 
 1741 
        offerList.add(Pair.of(1912, "357375370819315"));
- 
 
 1742 
        offerList.add(Pair.of(1912, "357375370827490"));
- 
 
 1743 
        offerList.add(Pair.of(1912, "357375370832755"));
- 
 
 1744 
        offerList.add(Pair.of(1912, "357375370833811"));
- 
 
 1745 
        offerList.add(Pair.of(1912, "357375370839594"));
- 
 
 1746 
        offerList.add(Pair.of(1912, "357375370839750"));
- 
 
 1747 
        offerList.add(Pair.of(1912, "357375370840956"));
- 
 
 1748 
        offerList.add(Pair.of(1912, "357375370841095"));
- 
 
 1749 
        offerList.add(Pair.of(1912, "357375370841731"));
- 
 
 1750 
        offerList.add(Pair.of(1912, "357375370841772"));
- 
 
 1751 
        offerList.add(Pair.of(1912, "357375370841830"));
- 
 
 1752 
        offerList.add(Pair.of(1912, "357375370841939"));
- 
 
 1753 
        offerList.add(Pair.of(1912, "357375370842416"));
- 
 
 1754 
        offerList.add(Pair.of(1912, "357375370842473"));
- 
 
 1755 
        offerList.add(Pair.of(1912, "357375370842754"));
- 
 
 1756 
        offerList.add(Pair.of(1912, "357375370843273"));
- 
 
 1757 
        offerList.add(Pair.of(1912, "357375370843919"));
- 
 
 1758 
        offerList.add(Pair.of(1912, "357375370844214"));
- 
 
 1759 
        offerList.add(Pair.of(1912, "357375370844610"));
- 
 
 1760 
        offerList.add(Pair.of(1912, "357375370845070"));
- 
 
 1761 
        offerList.add(Pair.of(1912, "357375370846052"));
- 
 
 1762 
        offerList.add(Pair.of(1912, "357375370847332"));
- 
 
 1763 
        offerList.add(Pair.of(1912, "357375370847654"));
- 
 
 1764 
        offerList.add(Pair.of(1912, "357375370848215"));
- 
 
 1765 
        offerList.add(Pair.of(1912, "357375370848611"));
- 
 
 1766 
        offerList.add(Pair.of(1912, "357375370848678"));
- 
 
 1767 
        offerList.add(Pair.of(1912, "357375370849296"));
- 
 
 1768 
        offerList.add(Pair.of(1912, "357375370849353"));
- 
 
 1769 
        offerList.add(Pair.of(1912, "357375370849437"));
- 
 
 1770 
        offerList.add(Pair.of(1912, "357375370849833"));
- 
 
 1771 
        offerList.add(Pair.of(1912, "357375370849874"));
- 
 
 1772 
        offerList.add(Pair.of(1912, "357375370850534"));
- 
 
 1773 
        offerList.add(Pair.of(1912, "357375370850757"));
- 
 
 1774 
        offerList.add(Pair.of(1912, "357375370850997"));
- 
 
 1775 
        offerList.add(Pair.of(1912, "357375370851417"));
- 
 
 1776 
        offerList.add(Pair.of(1912, "357375370851573"));
- 
 
 1777 
        offerList.add(Pair.of(1912, "357375370851730"));
- 
 
 1778 
        offerList.add(Pair.of(1912, "357375370853694"));
- 
 
 1779 
        offerList.add(Pair.of(1912, "357375370853991"));
- 
 
 1780 
        offerList.add(Pair.of(1912, "357375370855350"));
- 
 
 1781 
        offerList.add(Pair.of(1912, "357375370857133"));
- 
 
 1782 
        offerList.add(Pair.of(1912, "357375370857679"));
- 
 
 1783 
        offerList.add(Pair.of(1912, "357375370858115"));
- 
 
 1784 
        offerList.add(Pair.of(1912, "357375370858354"));
- 
 
 1785 
        offerList.add(Pair.of(1912, "357375370858693"));
- 
 
 1786 
        offerList.add(Pair.of(1912, "357375370858818"));
- 
 
 1787 
        offerList.add(Pair.of(1912, "357375370859253"));
- 
 
 1788 
        offerList.add(Pair.of(1912, "357375370859311"));
- 
 
 1789 
        offerList.add(Pair.of(1912, "357375370859378"));
- 
 
 1790 
        offerList.add(Pair.of(1912, "357375370859618"));
- 
 
 1791 
        offerList.add(Pair.of(1912, "357375370859717"));
- 
 
 1792 
        offerList.add(Pair.of(1912, "357375370864899"));
- 
 
 1793 
        offerList.add(Pair.of(1912, "357375370880598"));
- 
 
 1794 
        offerList.add(Pair.of(1912, "357375370892551"));
- 
 
 1795 
        offerList.add(Pair.of(1912, "357375370906278"));
- 
 
 1796 
        offerList.add(Pair.of(1912, "357375371735379"));
- 
 
 1797 
        offerList.add(Pair.of(1912, "357375371738357"));
- 
 
 1798 
        offerList.add(Pair.of(1912, "357375371738977"));
- 
 
 1799 
        offerList.add(Pair.of(1912, "357375371739298"));
- 
 
 1800 
        offerList.add(Pair.of(1912, "357375371740734"));
- 
 
 1801 
        offerList.add(Pair.of(1912, "357375371751558"));
- 
 
 1802 
        offerList.add(Pair.of(1912, "357375371753216"));
- 
 
 1803 
        offerList.add(Pair.of(1912, "357375371754370"));
- 
 
 1804 
        offerList.add(Pair.of(1912, "357375371756052"));
- 
 
 1805 
        offerList.add(Pair.of(1912, "357375371759551"));
- 
 
 1806 
        offerList.add(Pair.of(1912, "357375371759718"));
- 
 
 1807 
        offerList.add(Pair.of(1912, "357375371763736"));
- 
 
 1808 
        offerList.add(Pair.of(1912, "357375371763819"));
- 
 
 1809 
        offerList.add(Pair.of(1912, "357375371764411"));
- 
 
 1810 
        offerList.add(Pair.of(1912, "357375371764775"));
- 
 
 1811 
        offerList.add(Pair.of(1912, "357375371765038"));
- 
 
 1812 
        offerList.add(Pair.of(1912, "357375371765350"));
- 
 
 1813 
        offerList.add(Pair.of(1912, "357375371765533"));
- 
 
 1814 
        offerList.add(Pair.of(1912, "357375371765657"));
- 
 
 1815 
        offerList.add(Pair.of(1912, "357375371766358"));
- 
 
 1816 
        offerList.add(Pair.of(1912, "357375371767794"));
- 
 
 1817 
        offerList.add(Pair.of(1912, "357375371767836"));
- 
 
 1818 
        offerList.add(Pair.of(1912, "357375371768115"));
- 
 
 1819 
        offerList.add(Pair.of(1912, "357375371768255"));
- 
 
 1820 
        offerList.add(Pair.of(1912, "357375371768339"));
- 
 
 1821 
        offerList.add(Pair.of(1912, "357375371768396"));
- 
 
 1822 
        offerList.add(Pair.of(1912, "357375371768792"));
- 
 
 1823 
        offerList.add(Pair.of(1912, "357375371768990"));
- 
 
 1824 
        offerList.add(Pair.of(1912, "357375371769436"));
- 
 
 1825 
        offerList.add(Pair.of(1912, "357375371769816"));
- 
 
 1826 
        offerList.add(Pair.of(1912, "357375371770251"));
- 
 
 1827 
        offerList.add(Pair.of(1912, "357375371770350"));
- 
 
 1828 
        offerList.add(Pair.of(1912, "357375371770558"));
- 
 
 1829 
        offerList.add(Pair.of(1912, "357375371771770"));
- 
 
 1830 
        offerList.add(Pair.of(1912, "357375371772133"));
- 
 
 1831 
        offerList.add(Pair.of(1912, "357375371773016"));
- 
 
 1832 
        offerList.add(Pair.of(1912, "357375371774295"));
- 
 
 1833 
        offerList.add(Pair.of(1912, "357375371775250"));
- 
 
 1834 
        offerList.add(Pair.of(1912, "357375371776050"));
- 
 
 1835 
        offerList.add(Pair.of(1912, "357375371776217"));
- 
 
 1836 
        offerList.add(Pair.of(1912, "357375371776399"));
- 
 
 1837 
        offerList.add(Pair.of(1912, "357375371777512"));
- 
 
 1838 
        offerList.add(Pair.of(1912, "357375371781399"));
- 
 
 1839 
        offerList.add(Pair.of(1912, "357375371781514"));
- 
 
 1840 
        offerList.add(Pair.of(1912, "357375371784377"));
- 
 
 1841 
        offerList.add(Pair.of(1912, "357375371785499"));
- 
 
 1842 
        offerList.add(Pair.of(1912, "357375371785770"));
- 
 
 1843 
        offerList.add(Pair.of(1912, "357375371789194"));
- 
 
 1844 
        offerList.add(Pair.of(1912, "357375371789996"));
- 
 
 1845 
        offerList.add(Pair.of(1912, "357375371790671"));
- 
 
 1846 
        offerList.add(Pair.of(1912, "357375371791059"));
- 
 
 1847 
        offerList.add(Pair.of(1912, "357375371791893"));
- 
 
 1848 
        offerList.add(Pair.of(1912, "357375371814414"));
- 
 
 1849 
        offerList.add(Pair.of(1912, "357375371816732"));
- 
 
 1850 
        offerList.add(Pair.of(1912, "357375371817359"));
- 
 
 1851 
        offerList.add(Pair.of(1912, "357375371847455"));
- 
 
 1852 
        offerList.add(Pair.of(1912, "357375371848255"));
- 
 
 1853 
        offerList.add(Pair.of(1912, "357375371852950"));
- 
 
 1854 
        offerList.add(Pair.of(1912, "357375371855417"));
- 
 
 1855 
        offerList.add(Pair.of(1912, "357375371856258"));
- 
 
 1856 
        offerList.add(Pair.of(1912, "357375371857454"));
- 
 
 1857 
        offerList.add(Pair.of(1912, "357375371862355"));
- 
 
 1858 
        offerList.add(Pair.of(1912, "357375371862652"));
- 
 
 1859 
        offerList.add(Pair.of(1912, "357375371863270"));
- 
 
 1860 
        offerList.add(Pair.of(1912, "357375371863916"));
- 
 
 1861 
        offerList.add(Pair.of(1912, "357375371864237"));
- 
 
 1862 
        offerList.add(Pair.of(1912, "357375371865119"));
- 
 
 1863 
        offerList.add(Pair.of(1912, "357375371866638"));
- 
 
 1864 
        offerList.add(Pair.of(1912, "357375371868337"));
- 
 
 1865 
        offerList.add(Pair.of(1912, "357375371868436"));
- 
 
 1866 
        offerList.add(Pair.of(1912, "357375371868873"));
- 
 
 1867 
        offerList.add(Pair.of(1912, "357375371869137"));
- 
 
 1868 
        offerList.add(Pair.of(1912, "357375371870291"));
- 
 
 1869 
        offerList.add(Pair.of(1912, "357375371871174"));
- 
 
 1870 
        offerList.add(Pair.of(1912, "357375371872198"));
- 
 
 1871 
        offerList.add(Pair.of(1912, "357375371872271"));
- 
 
 1872 
        offerList.add(Pair.of(1912, "357375371872495"));
- 
 
 1873 
        offerList.add(Pair.of(1912, "357375371873170"));
- 
 
 1874 
        offerList.add(Pair.of(1912, "357375371873857"));
- 
 
 1875 
        offerList.add(Pair.of(1912, "357375371873873"));
- 
 
 1876 
        offerList.add(Pair.of(1912, "357375371874038"));
- 
 
 1877 
        offerList.add(Pair.of(1912, "357375371874111"));
- 
 
 1878 
        offerList.add(Pair.of(1912, "357375371874194"));
- 
 
 1879 
        offerList.add(Pair.of(1912, "357375371874491"));
- 
 
 1880 
        offerList.add(Pair.of(1912, "357375371874772"));
- 
 
 1881 
        offerList.add(Pair.of(1912, "357375371874996"));
- 
 
 1882 
        offerList.add(Pair.of(1912, "357375371875175"));
- 
 
 1883 
        offerList.add(Pair.of(1912, "357375371875274"));
- 
 
 1884 
        offerList.add(Pair.of(1912, "357375371875431"));
- 
 
 1885 
        offerList.add(Pair.of(1912, "357375371875852"));
- 
 
 1886 
        offerList.add(Pair.of(1912, "357375371875894"));
- 
 
 1887 
        offerList.add(Pair.of(1912, "357375371875910"));
- 
 
 1888 
        offerList.add(Pair.of(1912, "357375371876017"));
- 
 
 1889 
        offerList.add(Pair.of(1912, "357375371876231"));
- 
 
 1890 
        offerList.add(Pair.of(1912, "357375371876298"));
- 
 
 1891 
        offerList.add(Pair.of(1912, "357375371876850"));
- 
 
 1892 
        offerList.add(Pair.of(1912, "357375371877718"));
- 
 
 1893 
        offerList.add(Pair.of(1912, "357375371877775"));
- 
 
 1894 
        offerList.add(Pair.of(1912, "357375371877874"));
- 
 
 1895 
        offerList.add(Pair.of(1912, "357375371878237"));
- 
 
 1896 
        offerList.add(Pair.of(1912, "357375371878419"));
- 
 
 1897 
        offerList.add(Pair.of(1912, "357375371879292"));
- 
 
 1898 
        offerList.add(Pair.of(1912, "357375371880571"));
- 
 
 1899 
        offerList.add(Pair.of(1912, "357375371881199"));
- 
 
 1900 
        offerList.add(Pair.of(1912, "357375371882098"));
- 
 
 1901 
        offerList.add(Pair.of(1912, "357375371882296"));
- 
 
 1902 
        offerList.add(Pair.of(1912, "357375371883534"));
- 
 
 1903 
        offerList.add(Pair.of(1912, "357375371884599"));
- 
 
 1904 
        offerList.add(Pair.of(1912, "357375371885331"));
- 
 
 1905 
        offerList.add(Pair.of(1912, "357375371885497"));
- 
 
 1906 
        offerList.add(Pair.of(1912, "357375371885554"));
- 
 
 1907 
        offerList.add(Pair.of(1912, "357375371886214"));
- 
 
 1908 
        offerList.add(Pair.of(1912, "357375371897112"));
- 
 
 1909 
        offerList.add(Pair.of(1912, "357375371897435"));
- 
 
 1910 
        offerList.add(Pair.of(1912, "357375371898433"));
- 
 
 1911 
        offerList.add(Pair.of(1912, "357375371898698"));
- 
 
 1912 
        offerList.add(Pair.of(1912, "357375371915815"));
- 
 
 1913 
        offerList.add(Pair.of(1912, "358177964066850"));
- 
 
 1914 
        offerList.add(Pair.of(1912, "358177964076479"));
- 
 
 1915 
        offerList.add(Pair.of(1912, "358177964102713"));
- 
 
 1916 
        offerList.add(Pair.of(1912, "358177964770519"));
- 
 
 1917 
        offerList.add(Pair.of(1912, "358177964770790"));
- 
 
 1918 
        offerList.add(Pair.of(1912, "358177964773133"));
- 
 
 1919 
        offerList.add(Pair.of(1912, "358177964773778"));
- 
 
 1920 
        offerList.add(Pair.of(1912, "358382749330593"));
- 
 
 1921 
        offerList.add(Pair.of(1912, "358382749330817"));
- 
 
 1922 
        offerList.add(Pair.of(1912, "358382749330874"));
- 
 
 1923 
        offerList.add(Pair.of(1912, "358382749337978"));
- 
 
 1924 
        offerList.add(Pair.of(1912, "358382749356390"));
- 
 
 1925 
        offerList.add(Pair.of(1912, "358382749356812"));
- 
 
 1926 
        offerList.add(Pair.of(1912, "358382749359477"));
- 
 
 1927 
        offerList.add(Pair.of(1912, "358382749359956"));
- 
 
 1928 
        offerList.add(Pair.of(1912, "358382749360012"));
- 
 
 1929 
        offerList.add(Pair.of(1912, "358382749361036"));
- 
 
 1930 
        offerList.add(Pair.of(1912, "358382749361358"));
- 
 
 1931 
        offerList.add(Pair.of(1912, "358382749361374"));
- 
 
 1932 
        offerList.add(Pair.of(1912, "358382749362034"));
- 
 
 1933 
        offerList.add(Pair.of(1912, "358382749363297"));
- 
 
 1934 
        offerList.add(Pair.of(1912, "358382749363412"));
- 
 
 1935 
        offerList.add(Pair.of(1912, "358382749363438"));
- 
 
 1936 
        offerList.add(Pair.of(1912, "358382749363479"));
- 
 
 1937 
        offerList.add(Pair.of(1912, "358382749364618"));
- 
 
 1938 
        offerList.add(Pair.of(1912, "358382749365318"));
- 
 
 1939 
        offerList.add(Pair.of(1912, "358382749365730"));
- 
 
 1940 
        offerList.add(Pair.of(1912, "358382749365755"));
- 
 
 1941 
        offerList.add(Pair.of(1912, "358382749365771"));
- 
 
 1942 
        offerList.add(Pair.of(1912, "358382749366274"));
- 
 
 1943 
        offerList.add(Pair.of(1912, "358382749366415"));
- 
 
 1944 
        offerList.add(Pair.of(1912, "358382749366431"));
- 
 
 1945 
        offerList.add(Pair.of(1912, "358382749366456"));
- 
 
 1946 
        offerList.add(Pair.of(1912, "358382749366696"));
- 
 
 1947 
        offerList.add(Pair.of(1912, "358382749366753"));
- 
 
 1948 
        offerList.add(Pair.of(1912, "358382749366795"));
- 
 
 1949 
        offerList.add(Pair.of(1912, "358382749366852"));
- 
 
 1950 
        offerList.add(Pair.of(1912, "358382749366951"));
- 
 
 1951 
        offerList.add(Pair.of(1912, "358382749367058"));
- 
 
 1952 
        offerList.add(Pair.of(1912, "358382749367157"));
- 
 
 1953 
        offerList.add(Pair.of(1912, "358382749367272"));
- 
 
 1954 
        offerList.add(Pair.of(1912, "358382749367439"));
- 
 
 1955 
        offerList.add(Pair.of(1912, "358382749367579"));
- 
 
 1956 
        offerList.add(Pair.of(1912, "358382749367991"));
- 
 
 1957 
        offerList.add(Pair.of(1912, "358382749368072"));
- 
 
 1958 
        offerList.add(Pair.of(1912, "358382749368114"));
- 
 
 1959 
        offerList.add(Pair.of(1912, "358382749368213"));
- 
 
 1960 
        offerList.add(Pair.of(1912, "358382749368312"));
- 
 
 1961 
        offerList.add(Pair.of(1912, "358382749369013"));
- 
 
 1962 
        offerList.add(Pair.of(1912, "358382749369153"));
- 
 
 1963 
        offerList.add(Pair.of(1912, "358382749369377"));
- 
 
 1964 
        offerList.add(Pair.of(1912, "358382749369450"));
- 
 
 1965 
        offerList.add(Pair.of(1912, "358382749369633"));
- 
 
 1966 
        offerList.add(Pair.of(1912, "358382749370417"));
- 
 
 1967 
        offerList.add(Pair.of(1912, "358382749370458"));
- 
 
 1968 
        offerList.add(Pair.of(1912, "358382749370698"));
- 
 
 1969 
        offerList.add(Pair.of(1912, "358382749370953"));
- 
 
 1970 
        offerList.add(Pair.of(1912, "358382749371118"));
- 
 
 1971 
        offerList.add(Pair.of(1912, "358382749371134"));
- 
 
 1972 
        offerList.add(Pair.of(1912, "358382749371233"));
- 
 
 1973 
        offerList.add(Pair.of(1912, "358382749371977"));
- 
 
 1974 
        offerList.add(Pair.of(1912, "358382749372694"));
- 
 
 1975 
        offerList.add(Pair.of(1912, "358382749373114"));
- 
 
 1976 
        offerList.add(Pair.of(1912, "358382749373213"));
- 
 
 1977 
        offerList.add(Pair.of(1912, "358382749373296"));
- 
 
 1978 
        offerList.add(Pair.of(1912, "358382749373718"));
- 
 
 1979 
        offerList.add(Pair.of(1912, "358382749374138"));
- 
 
 1980 
        offerList.add(Pair.of(1912, "358382749374195"));
- 
 
 1981 
        offerList.add(Pair.of(1912, "358382749374294"));
- 
 
 1982 
        offerList.add(Pair.of(1912, "358382749375234"));
- 
 
 1983 
        offerList.add(Pair.of(1912, "358382749375374"));
- 
 
 1984 
        offerList.add(Pair.of(1912, "358382749375697"));
- 
 
 1985 
        offerList.add(Pair.of(1912, "358382749375812"));
- 
 
 1986 
        offerList.add(Pair.of(1912, "358382749376653"));
- 
 
 1987 
        offerList.add(Pair.of(1912, "358382749376711"));
- 
 
 1988 
        offerList.add(Pair.of(1912, "358382749381372"));
- 
 
 1989 
        offerList.add(Pair.of(1912, "358382749385779"));
- 
 
 1990 
        offerList.add(Pair.of(1912, "358382749391470"));
- 
 
 1991 
        offerList.add(Pair.of(1912, "358382749392338"));
- 
 
 1992 
        offerList.add(Pair.of(1912, "358382749393153"));
- 
 
 1993 
        offerList.add(Pair.of(1912, "358382749394094"));
- 
 
 1994 
        offerList.add(Pair.of(1912, "358382749394698"));
- 
 
 1995 
        offerList.add(Pair.of(1912, "358382749395091"));
- 
 
 1996 
        offerList.add(Pair.of(1912, "358382749395331"));
- 
 
 1997 
        offerList.add(Pair.of(1912, "358382749395612"));
- 
 
 1998 
        offerList.add(Pair.of(1912, "358382749395711"));
- 
 
 1999 
        offerList.add(Pair.of(1912, "358382749396453"));
- 
 
 2000 
        offerList.add(Pair.of(1912, "358382749397196"));
- 
 
 2001 
        offerList.add(Pair.of(1912, "358382749397253"));
- 
 
 2002 
        offerList.add(Pair.of(1912, "358382749397436"));
- 
 
 2003 
        offerList.add(Pair.of(1912, "358382749397675"));
- 
 
 2004 
        offerList.add(Pair.of(1912, "358382749397717"));
- 
 
 2005 
        offerList.add(Pair.of(1912, "358382749397998"));
- 
 
 2006 
        offerList.add(Pair.of(1912, "358382749398111"));
- 
 
 2007 
        offerList.add(Pair.of(1912, "358382749398392"));
- 
 
 2008 
        offerList.add(Pair.of(1912, "358382749398475"));
- 
 
 2009 
        offerList.add(Pair.of(1912, "358382749398533"));
- 
 
 2010 
        offerList.add(Pair.of(1912, "358382749399218"));
- 
 
 2011 
        offerList.add(Pair.of(1912, "358710494639034"));
- 
 
 2012 
        offerList.add(Pair.of(1912, "359197384149648"));
- 
 
 2013 
        offerList.add(Pair.of(1912, "359197384150745"));
- 
 
 2014 
        offerList.add(Pair.of(1912, "359197384155140"));
- 
 
 2015 
        offerList.add(Pair.of(1912, "359197384156668"));
- 
 
 2016 
        offerList.add(Pair.of(1912, "359197384158540"));
- 
 
 2017 
        offerList.add(Pair.of(1912, "359197384158748"));
- 
 
 2018 
        offerList.add(Pair.of(1912, "359197384159027"));
- 
 
 2019 
        offerList.add(Pair.of(1912, "359197384159183"));
- 
 
 2020 
        offerList.add(Pair.of(1912, "359197384159548"));
- 
 
 2021 
        offerList.add(Pair.of(1912, "359197384159688"));
- 
 
 2022 
        offerList.add(Pair.of(1912, "359197384159944"));
- 
 
 2023 
        offerList.add(Pair.of(1912, "359197384161221"));
- 
 
 2024 
        offerList.add(Pair.of(1912, "359197384161684"));
- 
 
 2025 
        offerList.add(Pair.of(1912, "359197384163227"));
- 
 
 2026 
        offerList.add(Pair.of(1912, "359197384163441"));
- 
 
 2027 
        offerList.add(Pair.of(1912, "359197384171543"));
- 
 
 2028 
        offerList.add(Pair.of(1912, "359197384173622"));
- 
 
 2029 
        offerList.add(Pair.of(1912, "359197384173788"));
- 
 
 2030 
        offerList.add(Pair.of(1912, "359197384175502"));
- 
 
 2031 
        offerList.add(Pair.of(1912, "359197384176203"));
- 
 
 2032 
        offerList.add(Pair.of(1912, "359197384176468"));
- 
 
 2033 
        offerList.add(Pair.of(1912, "359197384176682"));
- 
 
 2034 
        offerList.add(Pair.of(1912, "359197384176906"));
- 
 
 2035 
        offerList.add(Pair.of(1912, "359197384254307"));
- 
 
 2036 
        offerList.add(Pair.of(1912, "359197384254646"));
- 
 
 2037 
        offerList.add(Pair.of(1912, "359197384254802"));
- 
 
 2038 
        offerList.add(Pair.of(1912, "359197384254885"));
- 
 
 2039 
        offerList.add(Pair.of(1912, "359197384255767"));
- 
 
 2040 
        offerList.add(Pair.of(1912, "359197384255809"));
- 
 
 2041 
        offerList.add(Pair.of(1912, "359197384255825"));
- 
 
 2042 
        offerList.add(Pair.of(1912, "359197384255965"));
- 
 
 2043 
        offerList.add(Pair.of(1912, "359197384255981"));
- 
 
 2044 
        offerList.add(Pair.of(1912, "359197384257524"));
- 
 
 2045 
        offerList.add(Pair.of(1912, "359197384575966"));
- 
 
 2046 
        offerList.add(Pair.of(1912, "359197386828389"));
- 
 
 2047 
        offerList.add(Pair.of(1912, "359197386831185"));
- 
 
 2048 
        offerList.add(Pair.of(1912, "359197386833900"));
- 
 
 2049 
        offerList.add(Pair.of(1912, "359197386834569"));
- 
 
 2050 
        offerList.add(Pair.of(1912, "359197386837109"));
- 
 
 2051 
        offerList.add(Pair.of(1912, "359197386837646"));
- 
 
 2052 
        offerList.add(Pair.of(1912, "359197386840087"));
- 
 
 2053 
        offerList.add(Pair.of(1912, "359197386844147"));
- 
 
 2054 
        offerList.add(Pair.of(1912, "359197386844188"));
- 
 
 2055 
        offerList.add(Pair.of(1912, "359197386845805"));
- 
 
 2056 
        offerList.add(Pair.of(1912, "359197386845920"));
- 
 
 2057 
        offerList.add(Pair.of(1912, "359197386849062"));
- 
 
 2058 
        offerList.add(Pair.of(1912, "359197386849989"));
- 
 
 2059 
        offerList.add(Pair.of(1912, "359197386851167"));
- 
 
 2060 
        offerList.add(Pair.of(1912, "359197386853106"));
- 
 
 2061 
        offerList.add(Pair.of(1912, "359197386854021"));
- 
 
 2062 
        offerList.add(Pair.of(1912, "359197386854641"));
- 
 
 2063 
        offerList.add(Pair.of(1912, "359197386855507"));
- 
 
 2064 
        offerList.add(Pair.of(1912, "359197386855747"));
- 
 
 2065 
        offerList.add(Pair.of(1912, "359197386856588"));
- 
 
 2066 
        offerList.add(Pair.of(1912, "359197386857768"));
- 
 
 2067 
        offerList.add(Pair.of(1912, "359197386857966"));
- 
 
 2068 
        offerList.add(Pair.of(1912, "359197386858204"));
- 
 
 2069 
        offerList.add(Pair.of(1912, "359197386858824"));
- 
 
 2070 
        offerList.add(Pair.of(1912, "359197386858840"));
- 
 
 2071 
        offerList.add(Pair.of(1912, "359197386858949"));
- 
 
 2072 
        offerList.add(Pair.of(1912, "359197386859020"));
- 
 
 2073 
        offerList.add(Pair.of(1912, "359197386859285"));
- 
 
 2074 
        offerList.add(Pair.of(1912, "359197386859400"));
- 
 
 2075 
        offerList.add(Pair.of(1912, "359197386859749"));
- 
 
 2076 
        offerList.add(Pair.of(1912, "359197386860325"));
- 
 
 2077 
        offerList.add(Pair.of(1912, "359197386860689"));
- 
 
 2078 
        offerList.add(Pair.of(1912, "359197386860945"));
- 
 
 2079 
        offerList.add(Pair.of(1912, "359197386860986"));
- 
 
 2080 
        offerList.add(Pair.of(1912, "359197386861042"));
- 
 
 2081 
        offerList.add(Pair.of(1912, "359197386861240"));
- 
 
 2082 
        offerList.add(Pair.of(1912, "359197386861307"));
- 
 
 2083 
        offerList.add(Pair.of(1912, "359197386861547"));
- 
 
 2084 
        offerList.add(Pair.of(1912, "359197386861869"));
- 
 
 2085 
        offerList.add(Pair.of(1912, "359197386861885"));
- 
 
 2086 
        offerList.add(Pair.of(1912, "359197386861968"));
- 
 
 2087 
        offerList.add(Pair.of(1912, "359197386862065"));
- 
 
 2088 
        offerList.add(Pair.of(1912, "359197386862222"));
- 
 
 2089 
        offerList.add(Pair.of(1912, "359197386862768"));
- 
 
 2090 
        offerList.add(Pair.of(1912, "359197386862941"));
- 
 
 2091 
        offerList.add(Pair.of(1912, "359197386863089"));
- 
 
 2092 
        offerList.add(Pair.of(1912, "359197386863204"));
- 
 
 2093 
        offerList.add(Pair.of(1912, "359197386863220"));
- 
 
 2094 
        offerList.add(Pair.of(1912, "359197386863303"));
- 
 
 2095 
        offerList.add(Pair.of(1912, "359197386863345"));
- 
 
 2096 
        offerList.add(Pair.of(1912, "359197386863386"));
- 
 
 2097 
        offerList.add(Pair.of(1912, "359197386863543"));
- 
 
 2098 
        offerList.add(Pair.of(1912, "359197386863667"));
- 
 
 2099 
        offerList.add(Pair.of(1912, "359197386863683"));
- 
 
 2100 
        offerList.add(Pair.of(1912, "359197386863709"));
- 
 
 2101 
        offerList.add(Pair.of(1912, "359197386863949"));
- 
 
 2102 
        offerList.add(Pair.of(1912, "359197386864145"));
- 
 
 2103 
        offerList.add(Pair.of(1912, "359197386864186"));
- 
 
 2104 
        offerList.add(Pair.of(1912, "359197386864608"));
- 
 
 2105 
        offerList.add(Pair.of(1912, "359197386864681"));
- 
 
 2106 
        offerList.add(Pair.of(1912, "359197386864822"));
- 
 
 2107 
        offerList.add(Pair.of(1912, "359197386865142"));
- 
 
 2108 
        offerList.add(Pair.of(1912, "359197386865365"));
- 
 
 2109 
        offerList.add(Pair.of(1912, "359197386865704"));
- 
 
 2110 
        offerList.add(Pair.of(1912, "359197386865746"));
- 
 
 2111 
        offerList.add(Pair.of(1912, "359197386865829"));
- 
 
 2112 
        offerList.add(Pair.of(1912, "359197386865886"));
- 
 
 2113 
        offerList.add(Pair.of(1912, "359197386866181"));
- 
 
 2114 
        offerList.add(Pair.of(1912, "359197386866223"));
- 
 
 2115 
        offerList.add(Pair.of(1912, "359197386866405"));
- 
 
 2116 
        offerList.add(Pair.of(1912, "359197386866546"));
- 
 
 2117 
        offerList.add(Pair.of(1912, "359197386866603"));
- 
 
 2118 
        offerList.add(Pair.of(1912, "359197386866868"));
- 
 
 2119 
        offerList.add(Pair.of(1912, "359197386867049"));
- 
 
 2120 
        offerList.add(Pair.of(1912, "359197386867346"));
- 
 
 2121 
        offerList.add(Pair.of(1912, "359197386867387"));
- 
 
 2122 
        offerList.add(Pair.of(1912, "359197386867460"));
- 
 
 2123 
        offerList.add(Pair.of(1912, "359197386867825"));
- 
 
 2124 
        offerList.add(Pair.of(1912, "359197386867908"));
- 
 
 2125 
        offerList.add(Pair.of(1912, "359197386868047"));
- 
 
 2126 
        offerList.add(Pair.of(1912, "359197386868161"));
- 
 
 2127 
        offerList.add(Pair.of(1912, "359197386868484"));
- 
 
 2128 
        offerList.add(Pair.of(1912, "359197386868567"));
- 
 
 2129 
        offerList.add(Pair.of(1912, "359197386868906"));
- 
 
 2130 
        offerList.add(Pair.of(1912, "359197386868963"));
- 
 
 2131 
        offerList.add(Pair.of(1912, "359197386869482"));
- 
 
 2132 
        offerList.add(Pair.of(1912, "359197386869524"));
- 
 
 2133 
        offerList.add(Pair.of(1912, "359197386869565"));
- 
 
 2134 
        offerList.add(Pair.of(1912, "359197386869649"));
- 
 
 2135 
        offerList.add(Pair.of(1912, "359197386869821"));
- 
 
 2136 
        offerList.add(Pair.of(1912, "359197386869987"));
- 
 
 2137 
        offerList.add(Pair.of(1912, "359197386870068"));
- 
 
 2138 
        offerList.add(Pair.of(1912, "359197386870142"));
- 
 
 2139 
        offerList.add(Pair.of(1912, "359197386870381"));
- 
 
 2140 
        offerList.add(Pair.of(1912, "359197386870449"));
- 
 
 2141 
        offerList.add(Pair.of(1912, "359197386870647"));
- 
 
 2142 
        offerList.add(Pair.of(1912, "359197386870829"));
- 
 
 2143 
        offerList.add(Pair.of(1912, "359197386870902"));
- 
 
 2144 
        offerList.add(Pair.of(1912, "359197386870944"));
- 
 
 2145 
        offerList.add(Pair.of(1912, "359197386870985"));
- 
 
 2146 
        offerList.add(Pair.of(1912, "359197386871264"));
- 
 
 2147 
        offerList.add(Pair.of(1912, "359197386871363"));
- 
 
 2148 
        offerList.add(Pair.of(1912, "359197386871546"));
- 
 
 2149 
        offerList.add(Pair.of(1912, "359197386871629"));
- 
 
 2150 
        offerList.add(Pair.of(1912, "359197386871868"));
- 
 
 2151 
        offerList.add(Pair.of(1912, "359197386871983"));
- 
 
 2152 
        offerList.add(Pair.of(1912, "359197386872064"));
- 
 
 2153 
        offerList.add(Pair.of(1912, "359197386872080"));
- 
 
 2154 
        offerList.add(Pair.of(1912, "359197386872304"));
- 
 
 2155 
        offerList.add(Pair.of(1912, "359197386872569"));
- 
 
 2156 
        offerList.add(Pair.of(1912, "359197386873542"));
- 
 
 2157 
        offerList.add(Pair.of(1912, "359197386874268"));
- 
 
 2158 
        offerList.add(Pair.of(1912, "359197386874367"));
- 
 
 2159 
        offerList.add(Pair.of(1912, "359197386874383"));
- 
 
 2160 
        offerList.add(Pair.of(1912, "359197386874847"));
- 
 
 2161 
        offerList.add(Pair.of(1912, "359197386875166"));
- 
 
 2162 
        offerList.add(Pair.of(1912, "359571521884491"));
- 
 
 2163 
        offerList.add(Pair.of(1912, "359571521893773"));
- 
 
 2164 
        offerList.add(Pair.of(1912, "359571521902756"));
- 
 
 2165 
        offerList.add(Pair.of(1912, "359571521914256"));
- 
 
 2166 
        offerList.add(Pair.of(1912, "359571521918091"));
- 
 
 2167 
        offerList.add(Pair.of(1912, "359571521924214"));
- 
 
 2168 
        offerList.add(Pair.of(1912, "359571521925732"));
- 
 
 2169 
        offerList.add(Pair.of(1912, "359571521926334"));
- 
 
 2170 
        offerList.add(Pair.of(1912, "359571521930716"));
- 
 
 2171 
        offerList.add(Pair.of(1912, "359571521930955"));
- 
 
 2172 
        offerList.add(Pair.of(1912, "359571521930971"));
- 
 
 2173 
        offerList.add(Pair.of(1912, "359571521931516"));
- 
 
 2174 
        offerList.add(Pair.of(1912, "359571521932118"));
- 
 
 2175 
        offerList.add(Pair.of(1912, "359571521932951"));
- 
 
 2176 
        offerList.add(Pair.of(1912, "359571521932993"));
- 
 
 2177 
        offerList.add(Pair.of(1912, "359571521933652"));
- 
 
 2178 
        offerList.add(Pair.of(1912, "359571521935392"));
- 
 
 2179 
        offerList.add(Pair.of(1912, "359571521935616"));
- 
 
 2180 
        offerList.add(Pair.of(1912, "359571521937158"));
- 
 
 2181 
        offerList.add(Pair.of(1912, "359571521937513"));
- 
 
 2182 
        offerList.add(Pair.of(1912, "359571521937570"));
- 
 
 2183 
        offerList.add(Pair.of(1912, "359571521937778"));
- 
 
 2184 
        offerList.add(Pair.of(1912, "359571521937851"));
- 
 
 2185 
        offerList.add(Pair.of(1912, "359571521937919"));
- 
 
 2186 
        offerList.add(Pair.of(1912, "359571521937950"));
- 
 
 2187 
        offerList.add(Pair.of(1912, "359571521938032"));
- 
 
 2188 
        offerList.add(Pair.of(1912, "359571521938057"));
- 
 
 2189 
        offerList.add(Pair.of(1912, "359571521938198"));
- 
 
 2190 
        offerList.add(Pair.of(1912, "359571521938214"));
- 
 
 2191 
        offerList.add(Pair.of(1912, "359571521938354"));
- 
 
 2192 
        offerList.add(Pair.of(1912, "359571521938651"));
- 
 
 2193 
        offerList.add(Pair.of(1912, "359571521938719"));
- 
 
 2194 
        offerList.add(Pair.of(1912, "359571521938818"));
- 
 
 2195 
        offerList.add(Pair.of(1912, "359571521938917"));
- 
 
 2196 
        offerList.add(Pair.of(1912, "359571521938958"));
- 
 
 2197 
        offerList.add(Pair.of(1912, "359571521938974"));
- 
 
 2198 
        offerList.add(Pair.of(1912, "359571521939139"));
- 
 
 2199 
        offerList.add(Pair.of(1912, "359571521939212"));
- 
 
 2200 
        offerList.add(Pair.of(1912, "359571521939576"));
- 
 
 2201 
        offerList.add(Pair.of(1912, "359571521939691"));
- 
 
 2202 
        offerList.add(Pair.of(1912, "359571521940012"));
- 
 
 2203 
        offerList.add(Pair.of(1912, "359571521940277"));
- 
 
 2204 
        offerList.add(Pair.of(1912, "359571521940376"));
- 
 
 2205 
        offerList.add(Pair.of(1912, "359571521940970"));
- 
 
 2206 
        offerList.add(Pair.of(1912, "359571521941119"));
- 
 
 2207 
        offerList.add(Pair.of(1912, "359571521941937"));
- 
 
 2208 
        offerList.add(Pair.of(1912, "359571521943495"));
- 
 
 2209 
        offerList.add(Pair.of(1912, "359571521944279"));
- 
 
 2210 
        offerList.add(Pair.of(1912, "359571521944691"));
- 
 
 2211 
        offerList.add(Pair.of(1912, "359571521944873"));
- 
 
 2212 
        offerList.add(Pair.of(1912, "359571521945052"));
- 
 
 2213 
        offerList.add(Pair.of(1912, "359571521945177"));
- 
 
 2214 
        offerList.add(Pair.of(1912, "359571521945276"));
- 
 
 2215 
        offerList.add(Pair.of(1912, "359571521945631"));
- 
 
 2216 
        offerList.add(Pair.of(1912, "359571521945797"));
- 
 
 2217 
        offerList.add(Pair.of(1912, "359571521946217"));
- 
 
 2218 
        offerList.add(Pair.of(1912, "359571521946415"));
- 
 
 2219 
        offerList.add(Pair.of(1912, "359571521946670"));
- 
 
 2220 
        offerList.add(Pair.of(1912, "359571521946837"));
- 
 
 2221 
        offerList.add(Pair.of(1912, "359571521946910"));
- 
 
 2222 
        offerList.add(Pair.of(1912, "359571521947199"));
- 
 
 2223 
        offerList.add(Pair.of(1912, "359571521947355"));
- 
 
 2224 
        offerList.add(Pair.of(1912, "359571521947371"));
- 
 
 2225 
        offerList.add(Pair.of(1912, "359571521947751"));
- 
 
 2226 
        offerList.add(Pair.of(1912, "359571521947819"));
- 
 
 2227 
        offerList.add(Pair.of(1912, "359571521948171"));
- 
 
 2228 
        offerList.add(Pair.of(1912, "359571521948692"));
- 
 
 2229 
        offerList.add(Pair.of(1912, "359571521949195"));
- 
 
 2230 
        offerList.add(Pair.of(1912, "359571521949815"));
- 
 
 2231 
        offerList.add(Pair.of(1912, "359571521950433"));
- 
 
 2232 
        offerList.add(Pair.of(1912, "359571521950896"));
- 
 
 2233 
        offerList.add(Pair.of(1912, "359571521951274"));
- 
 
 2234 
        offerList.add(Pair.of(1912, "359571521951555"));
- 
 
 2235 
        offerList.add(Pair.of(1912, "359571521951837"));
- 
 
 2236 
        offerList.add(Pair.of(1912, "359571521952694"));
- 
 
 2237 
        offerList.add(Pair.of(1912, "359571521953056"));
- 
 
 2238 
        offerList.add(Pair.of(1912, "359571521953197"));
- 
 
 2239 
        offerList.add(Pair.of(1912, "359571521953270"));
- 
 
 2240 
        offerList.add(Pair.of(1912, "359571521953619"));
- 
 
 2241 
        offerList.add(Pair.of(1912, "359571521953676"));
- 
 
 2242 
        offerList.add(Pair.of(1912, "359571521953692"));
- 
 
 2243 
        offerList.add(Pair.of(1912, "359571521953858"));
- 
 
 2244 
        offerList.add(Pair.of(1912, "359571521953890"));
- 
 
 2245 
        offerList.add(Pair.of(1912, "359571521954294"));
- 
 
 2246 
        offerList.add(Pair.of(1912, "359571521954419"));
- 
 
 2247 
        offerList.add(Pair.of(1912, "359571521954492"));
- 
 
 2248 
        offerList.add(Pair.of(1912, "359571521954799"));
- 
 
 2249 
        offerList.add(Pair.of(1912, "359571521954815"));
- 
 
 2250 
        offerList.add(Pair.of(1912, "359571521954831"));
- 
 
 2251 
        offerList.add(Pair.of(1912, "359571521954856"));
- 
 
 2252 
        offerList.add(Pair.of(1912, "359571521955119"));
- 
 
 2253 
        offerList.add(Pair.of(1912, "359571521956695"));
- 
 
 2254 
        offerList.add(Pair.of(1912, "359571521956950"));
- 
 
 2255 
        offerList.add(Pair.of(1912, "359571521957057"));
- 
 
 2256 
        offerList.add(Pair.of(1912, "359571521957339"));
- 
 
 2257 
        offerList.add(Pair.of(1912, "359571521957834"));
- 
 
 2258 
        offerList.add(Pair.of(1912, "359571521958113"));
- 
 
 2259 
        offerList.add(Pair.of(1912, "359571521958394"));
- 
 
 2260 
        offerList.add(Pair.of(1912, "359571522322517"));
- 
 
 2261 
        offerList.add(Pair.of(1912, "359571522325734"));
- 
 
 2262 
        offerList.add(Pair.of(1912, "359571522327375"));
- 
 
 2263 
        offerList.add(Pair.of(1912, "359571522328811"));
- 
 
 2264 
        offerList.add(Pair.of(1912, "359571522332292"));
- 
 
 2265 
        offerList.add(Pair.of(1912, "359571522335055"));
- 
 
 2266 
        offerList.add(Pair.of(1912, "359571522339115"));
- 
 
 2267 
        offerList.add(Pair.of(1912, "359571523006655"));
- 
 
 2268 
        offerList.add(Pair.of(1912, "359571523008396"));
- 
 
 2269 
        offerList.add(Pair.of(1912, "359571523016936"));
- 
 
 2270 
        offerList.add(Pair.of(1912, "359571523018536"));
- 
 
 2271 
        offerList.add(Pair.of(1912, "359571523019211"));
- 
 
 2272 
        offerList.add(Pair.of(1912, "359571523021217"));
- 
 
 2273 
        offerList.add(Pair.of(1912, "359571523021274"));
- 
 
 2274 
        offerList.add(Pair.of(1912, "359571523022538"));
- 
 
 2275 
        offerList.add(Pair.of(1912, "359571523022553"));
- 
 
 2276 
        offerList.add(Pair.of(1912, "359571523022751"));
- 
 
 2277 
        offerList.add(Pair.of(1912, "359571523023478"));
- 
 
 2278 
        offerList.add(Pair.of(1912, "359571523023817"));
- 
 
 2279 
        offerList.add(Pair.of(1912, "359571523023916"));
- 
 
 2280 
        offerList.add(Pair.of(1912, "359571523024195"));
- 
 
 2281 
        offerList.add(Pair.of(1912, "359571523029533"));
- 
 
 2282 
        offerList.add(Pair.of(1912, "359571523033311"));
- 
 
 2283 
        offerList.add(Pair.of(1912, "359571523033337"));
- 
 
 2284 
        offerList.add(Pair.of(1912, "359571523034814"));
- 
 
 2285 
        offerList.add(Pair.of(1912, "359571523252531"));
- 
 
 2286 
        offerList.add(Pair.of(1912, "359571523252754"));
- 
 
 2287 
        offerList.add(Pair.of(1912, "359571523252838"));
- 
 
 2288 
        offerList.add(Pair.of(1912, "359571523837190"));
- 
 
 2289 
        offerList.add(Pair.of(1912, "359571523841952"));
- 
 
 2290 
        offerList.add(Pair.of(1912, "359571523842018"));
- 
 
 2291 
        offerList.add(Pair.of(1912, "359571524068316"));
- 
 
 2292 
        offerList.add(Pair.of(1912, "359571524069553"));
- 
 
 2293 
        offerList.add(Pair.of(1912, "359571524071450"));
- 
 
 2294 
        offerList.add(Pair.of(1912, "359571524071799"));
- 
 
 2295 
        offerList.add(Pair.of(1912, "359571524072599"));
- 
 
 2296 
        offerList.add(Pair.of(1912, "359571524072730"));
- 
 
 2297 
        offerList.add(Pair.of(1912, "359571524073076"));
- 
 
 2298 
        offerList.add(Pair.of(1912, "359571524073571"));
- 
 
 2299 
        offerList.add(Pair.of(1912, "359571524075873"));
- 
 
 2300 
        offerList.add(Pair.of(1912, "359571524077614"));
- 
 
 2301 
        offerList.add(Pair.of(1912, "359571524078810"));
- 
 
 2302 
        offerList.add(Pair.of(1912, "359571524080550"));
- 
 
 2303 
        offerList.add(Pair.of(1912, "359571524081970"));
- 
 
 2304 
        offerList.add(Pair.of(1912, "359571524084412"));
- 
 
 2305 
        offerList.add(Pair.of(1912, "359571524085153"));
- 
 
 2306 
        offerList.add(Pair.of(1912, "359571524086656"));
- 
 
 2307 
        offerList.add(Pair.of(1912, "359571524086797"));
- 
 
 2308 
        offerList.add(Pair.of(1912, "359571524087431"));
- 
 
 2309 
        offerList.add(Pair.of(1912, "359571524087837"));
- 
 
 2310 
        offerList.add(Pair.of(1912, "359571524088199"));
- 
 
 2311 
        offerList.add(Pair.of(1912, "359571524089593"));
- 
 
 2312 
        offerList.add(Pair.of(1912, "359571524089973"));
- 
 
 2313 
        offerList.add(Pair.of(1912, "359571524094791"));
- 
 
 2314 
        offerList.add(Pair.of(1912, "359571524094833"));
- 
 
 2315 
        offerList.add(Pair.of(1912, "359571524094874"));
- 
 
 2316 
        offerList.add(Pair.of(1912, "359571524094957"));
- 
 
 2317 
        offerList.add(Pair.of(1912, "359571524095053"));
- 
 
 2318 
        offerList.add(Pair.of(1912, "359571524095335"));
- 
 
 2319 
        offerList.add(Pair.of(1912, "359571524095772"));
- 
 
 2320 
        offerList.add(Pair.of(1912, "359571524095871"));
- 
 
 2321 
        offerList.add(Pair.of(1912, "359571524612097"));
- 
 
 2322 
        offerList.add(Pair.of(1912, "359571524617898"));
- 
 
 2323 
        offerList.add(Pair.of(1912, "359571524633390"));
- 
 
 2324 
        offerList.add(Pair.of(1912, "359571524633879"));
- 
 
 2325 
        offerList.add(Pair.of(1912, "359571524634414"));
- 
 
 2326 
        offerList.add(Pair.of(1912, "359571524766190"));
- 
 
 2327 
        offerList.add(Pair.of(1912, "359571524766216"));
- 
 
 2328 
        offerList.add(Pair.of(1912, "359571527360694"));
- 
 
 2329 
        Map<Integer, Set<String>> offerSerialNumbersMap = offerList.stream().collect(groupingBy(x -> x.getLeft(), mapping(x -> x.getRight(), toSet())));
- 
 
 2330 
        List<Integer> offerIds = new ArrayList(offerSerialNumbersMap.keySet());
- 
 
 2331 
        for (Integer offerId : offerIds) {
- 
 
 2332 
            //if(offerId !=1912) continue;
- 
 
 2333 
            List<OfferPayout> offerPayouts = offerPayoutRepository.selectAllByOfferId(offerId);
- 
 
 2334 
            Set<String> serialNumbersToReverse = offerSerialNumbersMap.get(offerId);
- 
 
 2335 
            Map<Long, Map<String, List<OfferPayout>>> partnerOfferPayouts = offerPayouts.stream().filter(x -> x.getRejectTimestamp() == null && serialNumbersToReverse.contains(x.getSerialNumber()))
- 
 
 2336 
                    .collect(groupingBy(OfferPayout::getFofoId, groupingBy(OfferPayout::getSerialNumber)));
- 
 
 2337 
            for (Entry<Long, Map<String, List<OfferPayout>>> partnerPayoutEntry : partnerOfferPayouts.entrySet()) {
- 
 
 2338 
                int fofoId = partnerPayoutEntry.getKey().intValue();
- 
 
 2339 
                float amount = 0;
- 
 
 2340 
                List<OfferPayout> partnerPayouts = partnerPayoutEntry.getValue().values().stream().map(list -> Collections.max(list, Comparator.comparing(OfferPayout::getAmount))).collect(toList());
- 
 
 2341 
                for (OfferPayout offerPayout : partnerPayouts) {
- 
 
 2342 
                    amount += offerPayout.getAmount();
- 
 
 2343 
                    offerPayout.setStatus(SchemePayoutStatus.REJECTED);
- 
 
 2344 
                    offerPayout.setRejectTimestamp(LocalDateTime.now());
- 
 
 2345 
                }
- 
 
 2346 
                walletService.rollbackAmountFromWallet(fofoId, amount, offerId,
- 
 
 2347 
                        WalletReferenceType.ADDITIONAL_SCHEME, "Payout reversed as amount credited twice", LocalDateTime.now());
- 
 
 2348 
 
- 
 
 2349 
            }
- 
 
 2350 
 
- 
 
 2351 
        }
- 
 
 2352 
 
1044 
        System.out.println(gstProAuthService.getAuthToken("34AACCC1596Q002"));
 2353 
        //System.out.println(gstProAuthService.getAuthToken("34AACCC1596Q002"));
1045 
        //redisFortnightlyCacheManage.getCache("gstAuthToken").evict("34AACCC1596Q002");
 2354 
        //redisFortnightlyCacheManage.getCache("gstAuthToken").evict("34AACCC1596Q002");
1046 
//        LocalDate startDate = LocalDate.of(2024, Month.MAY, 1);
 2355 
//        LocalDate startDate = LocalDate.of(2024, Month.MAY, 1);
1047 
//        List<PriceDropIMEI> priceDropIMEIList = priceDropIMEIRepository.selectAllByCreditedBetween(startDate.atStartOfDay(), startDate.plusMonths(1).atTime(Utils.MAX_TIME));
 2356 
//        List<PriceDropIMEI> priceDropIMEIList = priceDropIMEIRepository.selectAllByCreditedBetween(startDate.atStartOfDay(), startDate.plusMonths(1).atTime(Utils.MAX_TIME));
1048 
//        Set<Integer> inventoryItemIds = priceDropIMEIList.stream().map(x -> x.getInventoryItemId()).collect(Collectors.toSet());
 2357 
//        Set<Integer> inventoryItemIds = priceDropIMEIList.stream().map(x -> x.getInventoryItemId()).collect(Collectors.toSet());
1049 
//        List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
 2358 
//        List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
Line 3759... Line 5068...
3759 
            throw new ProfitMandiBusinessException("loanstament", loanStatement.getLoanId(), "Invalid LoanId");
 5068 
            throw new ProfitMandiBusinessException("loanstament", loanStatement.getLoanId(), "Invalid LoanId");
3760 
        }
 5069 
        }
3761 
    }
 5070 
    }
3762 
 
 5071 
 
3763 
    public void loanSettlement() throws Exception {
 5072 
    public void loanSettlement() throws Exception {
- 
 
 5073 
        List<Loan> blockedLoans = loanRepository.selectAllActiveLoan().stream().filter(x -> x.getFreeDays() >= 365).collect(toList());
3764 
        List<Loan> loans = loanRepository.selectAllActiveLoan();
 5074 
        List<Loan> loans = loanRepository.selectAllActiveLoan().stream().filter(x -> x.getFreeDays() < 365).collect(toList());
- 
 
 5075 
        //Settle blocked loans only when normal loans are settled
- 
 
 5076 
        loans.addAll(blockedLoans);
3765 
 
 5077 
 
3766 
        if (!loans.isEmpty()) {
 5078 
        if (!loans.isEmpty()) {
3767 
 
 5079 
 
3768 
            for (Loan loan : loans) {
 5080 
            for (Loan loan : loans) {
- 
 
 5081 
                double settledAmount = sdCreditService.settleLoan(loan);
3769 
 
 5082 
 
3770 
                UserWallet userWallet = userWalletRepository.selectByRetailerId(loan.getFofoId());
 - 
 
3771 
                SDCreditRequirement sdCreditRequirement = sdCreditRequirementRepository.selectByFofoId(loan.getFofoId());
 - 
 
3772 
 
 - 
 
3773 
                List<LoanStatement> loanStatements = loanStatementRepository.selectByLoanId(loan.getId());
 5083 
                List<SanctionRequest> sanctionRequests = sanctionRequestRepository.selectHoldSanctionByFofoId(loan.getFofoId());
3774 
 
 - 
 
3775 
                LOGGER.info("loanStatements {}", loanStatements);
 5084 
                for (SanctionRequest sanctionRequest : sanctionRequests) {
3776 
 
 - 
 
3777 
                Map<LoanReferenceType, Double> loanStatusAmount = loanStatements.stream().collect(groupingBy(x -> x.getLoanReferenceType(), Collectors.summingDouble(x -> FormattingUtils.serialize(x.getAmount()))));
 - 
 
3778 
 
 - 
 
3779 
                LOGGER.info("loanStatusAmount {}", loanStatusAmount);
 - 
 
3780 
                Double interestAmount = loanStatusAmount.get(LoanReferenceType.INTEREST);
 - 
 
3781 
 
 - 
 
3782 
                if (interestAmount == null) {
 - 
 
3783 
                    interestAmount = (double) 0;
 - 
 
3784 
                }
 - 
 
3785 
                double principalAmount = loanStatusAmount.get(LoanReferenceType.PRINCIPAL);
 - 
 
3786 
                //if it can be settled
 - 
 
3787 
                if (userWallet.getAmount() >= 100 || userWallet.getAmount() > Math.abs(interestAmount + principalAmount)) {
 - 
 
3788 
                    double paidAmount = 0;
 - 
 
3789 
                    if (userWallet.getAmount() > Math.abs(interestAmount)) {
 - 
 
3790 
 
 - 
 
3791 
                        LOGGER.info("interestAmount b {}", interestAmount);
 - 
 
3792 
 
 - 
 
3793 
                        if (interestAmount < 0) {
 - 
 
3794 
                            LOGGER.info("interestAmount a {}", interestAmount);
 - 
 
3795 
 
 - 
 
3796 
                            settledLoanStatement(LoanReferenceType.INTEREST, BigDecimal.valueOf(interestAmount), loan.getFofoId(), loan.getId(), "Amount adjusted against loan", LocalDateTime.now());
 - 
 
3797 
                            loan.setInterestPaid(loan.getInterestPaid().add(BigDecimal.valueOf(interestAmount).abs()));
 - 
 
3798 
 
 - 
 
3799 
                            paidAmount += Math.abs(interestAmount);
 - 
 
3800 
                        }
 - 
 
3801 
 
 - 
 
3802 
                        double userWalletAmount = userWallet.getAmount() - Math.abs(interestAmount);
 - 
 
3803 
 
 - 
 
3804 
                        if (userWalletAmount > Math.abs(principalAmount) && principalAmount < 0) {
 - 
 
3805 
                            settledLoanStatement(LoanReferenceType.PRINCIPAL, BigDecimal.valueOf(principalAmount), loan.getFofoId(), loan.getId(), "Amount adjusted against loan", LocalDateTime.now());
 - 
 
3806 
                            paidAmount += Math.abs(principalAmount);
 - 
 
3807 
                            BigDecimal utilizationAmount = sdCreditRequirement.getUtilizedAmount().subtract(BigDecimal.valueOf(principalAmount).abs());
 - 
 
3808 
                            sdCreditRequirement.setUtilizedAmount(utilizationAmount);
 - 
 
3809 
                            CreditAccount creditAccount = creditAccountRepository.selectByFofoIdAndGateway(loan.getFofoId(), Gateway.SDDIRECT);
 - 
 
3810 
 
 - 
 
3811 
                            creditAccount.setAvailableAmount(sdCreditRequirement.getAvailableLimit().floatValue());
 - 
 
3812 
                            creditAccount.setUpdatedOn(LocalDateTime.now());
 - 
 
3813 
 
 - 
 
3814 
                            loan.setPendingAmount(BigDecimal.ZERO);
 - 
 
3815 
                            loan.setSettledOn(LocalDateTime.now());
 - 
 
3816 
 
 - 
 
3817 
                        } else if (principalAmount < 0) {
 - 
 
3818 
 
 5085 
 
3819 
                            settledLoanStatement(LoanReferenceType.PRINCIPAL, BigDecimal.valueOf(userWalletAmount), loan.getFofoId(), loan.getId(), "Amount adjusted against loan", LocalDateTime.now());
 5086 
                    List<Order> orders = orderRepository.selectAllByTransactionId(sanctionRequest.getTransactionId());
3820 
 
 - 
 
3821 
                            paidAmount += Math.abs(userWalletAmount);
 5087 
                    if (orders.size() == 0) {
3822 
 
 - 
 
3823 
                            BigDecimal utilizationAmount = sdCreditRequirement.getUtilizedAmount().subtract(BigDecimal.valueOf(userWalletAmount)).abs();
 5088 
                        LOGGER.info("Could not find orders - for Sanction Request {}", sanctionRequest);
3824 
 
 - 
 
3825 
                            sdCreditRequirement.setUtilizedAmount(utilizationAmount);
 5089 
                        continue;
3826 
 
 - 
 
3827 
                            CreditAccount creditAccount = creditAccountRepository.selectByFofoIdAndGateway(loan.getFofoId(), Gateway.SDDIRECT);
 - 
 
3828 
 
 - 
 
3829 
                            creditAccount.setAvailableAmount(sdCreditRequirement.getAvailableLimit().floatValue());
 - 
 
3830 
                            creditAccount.setUpdatedOn(LocalDateTime.now());
 5090 
                    }
3831 
 
 5091 
 
- 
 
 5092 
                    if (settledAmount >= sanctionRequest.getPendingAmount().doubleValue()) {
3832 
                            loan.setPendingAmount(
 5093 
                        settledAmount -= sanctionRequest.getPendingAmount().doubleValue();
3833 
                                    loan.getPendingAmount().subtract(BigDecimal.valueOf(userWalletAmount)));
 5094 
                        sanctionRequest.setPendingAmount(BigDecimal.valueOf(0));
3834 
                        }
 5095 
                        this.sendUnholdEmail(orders);
3835 
                        walletService.consumeAmountFromWallet(userWallet.getUserId(), loan.getId(), WalletReferenceType.LOAN_REPAYMENT, "Amount adjusted against loan", (float) Math.abs(paidAmount), LocalDateTime.now());
 - 
 
3836 
                    } else {
 5096 
                    } else {
3837 
                        settledLoanStatement(LoanReferenceType.INTEREST, BigDecimal.valueOf(userWallet.getAmount()), loan.getFofoId(), loan.getId(),
 5097 
                        double pendinAmount = sanctionRequest.getPendingAmount().doubleValue() - settledAmount;
3838 
                                "Amount adjusted against loan", LocalDateTime.now());
 5098 
                        sanctionRequest.setPendingAmount(BigDecimal.valueOf(pendinAmount));
3839 
 
 - 
 
3840 
                        paidAmount += Math.abs(userWallet.getAmount());
 5099 
                        break;
3841 
 
 - 
 
3842 
                        loan.setInterestPaid(loan.getInterestPaid().add(BigDecimal.valueOf(userWallet.getAmount()).abs()));
 - 
 
3843 
                        walletService.consumeAmountFromWallet(userWallet.getUserId(), loan.getId(), WalletReferenceType.LOAN_REPAYMENT,
 - 
 
3844 
                                "Amount adjusted against loan", (float) Math.abs(paidAmount), LocalDateTime.now());
 - 
 
3845 
 
 5100 
 
3846 
                    }
 5101 
                    }
3847 
 
 5102 
 
3848 
 
 - 
 
3849 
                    List<SanctionRequest> sanctionRequests = sanctionRequestRepository.selectHoldSanctionByFofoId(loan.getFofoId());
 - 
 
3850 
 
 - 
 
3851 
                    double settledAmount = paidAmount;
 - 
 
3852 
                    for (SanctionRequest sanctionRequest : sanctionRequests) {
 - 
 
3853 
 
 - 
 
3854 
                        List<Order> orders = orderRepository.selectAllByTransactionId(sanctionRequest.getTransactionId());
 - 
 
3855 
                        if (orders.size() == 0) {
 - 
 
3856 
                            LOGGER.info("Could not find orders - for Sanction Request {}", sanctionRequest);
 - 
 
3857 
                            continue;
 - 
 
3858 
                        }
 - 
 
3859 
 
 - 
 
3860 
                        if (settledAmount >= sanctionRequest.getPendingAmount().doubleValue()) {
 - 
 
3861 
                            settledAmount -= sanctionRequest.getPendingAmount().doubleValue();
 - 
 
3862 
                            sanctionRequest.setPendingAmount(BigDecimal.valueOf(0));
 - 
 
3863 
                            this.sendUnholdEmail(orders);
 - 
 
3864 
                        } else {
 - 
 
3865 
                            double pendinAmount = sanctionRequest.getPendingAmount().doubleValue() - settledAmount;
 - 
 
3866 
                            sanctionRequest.setPendingAmount(BigDecimal.valueOf(pendinAmount));
 - 
 
3867 
                            break;
 - 
 
3868 
 
 - 
 
3869 
                        }
 - 
 
3870 
 
 - 
 
3871 
                    }
 - 
 
3872 
                }
 5103 
                }
3873 
 
 - 
 
3874 
            }
 5104 
            }
3875 
 
 5105 
 
3876 
 
 - 
 
3877 
        }
 5106 
        }
3878 
 
 5107 
 
- 
 
 5108 
 
3879 
    }
 5109 
    }
3880 
 
 5110 
 
3881 
 
 5111 
 
3882 
    private void sendUnholdEmail(List<Order> orders) throws Exception {
 5112 
    private void sendUnholdEmail(List<Order> orders) throws Exception {
3883 
 
 5113 
 
3884 
 
 5114 
 
3885 
        orders.forEach(x -> x.setShipmentHold(false));
 5115 
        orders.forEach(x -> x.setShipmentHold(false));
3886 
        orders = orders.stream().filter(x -> x.getRefundTimestamp() != null).collect(Collectors.toList());
 5116 
        orders = orders.stream().filter(x -> x.getRefundTimestamp() != null).collect(Collectors.toList());
3887 
        if (orders.size() > 0) {
 5117 
        if (orders.size() > 0) {
3888 
 
 5118 
 
3889 
        double totalAmount = orders.stream().collect(Collectors.summingDouble(x -> x.getTotalAmount()));
 5119 
            double totalAmount = orders.stream().collect(Collectors.summingDouble(x -> x.getTotalAmount()));
3890 
 
 5120 
 
3891 
            List<String> authUserEmail = csService.getAuthUserIdByPartnerId(orders.get(0).getRetailerId()).stream().map(x -> x.getEmailId()).collect(Collectors.toList());
 5121 
            List<String> authUserEmail = csService.getAuthUserIdByPartnerId(orders.get(0).getRetailerId()).stream().map(x -> x.getEmailId()).collect(Collectors.toList());
3892 
            authUserEmail.add("vinay.p@smartdukaan.com");
 5122 
            authUserEmail.add("vinay.p@smartdukaan.com");
3893 
            authUserEmail.add("shivam.gupta@smartdukaan.com");
 5123 
            authUserEmail.add("shivam.gupta@smartdukaan.com");
3894 
 
 5124 
 
3895 
            String[] emailTo = authUserEmail.toArray(new String[authUserEmail.size()]);
 5125 
            String[] emailTo = authUserEmail.toArray(new String[authUserEmail.size()]);
3896 
 
 5126 
 
3897 
            String[] ccTo = {"tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com"};
 5127 
            String[] ccTo = {"tarun.verma@smartdukaan.com", "kamini.sharma@smartdukaan.com"};
3898 
 
 5128 
 
3899 
        String subject = "Dispatch held orders of - " + (orders.get(0).getRetailerName());
 5129 
            String subject = "Dispatch held orders of - " + (orders.get(0).getRetailerName());
3900 
        String message = String.format("Dear Team, \n" + "kindly note the material for the " + orders.get(0).getRetailerName() + "of Rs." + totalAmount + "is unhold now and needs to be dispatched.");
 5130 
            String message = String.format("Dear Team, \n" + "kindly note the material for the " + orders.get(0).getRetailerName() + "of Rs." + totalAmount + "is unhold now and needs to be dispatched.");
3901 
        Utils.sendMailWithAttachments(mailSender, emailTo, ccTo, subject, message);
 5131 
            Utils.sendMailWithAttachments(mailSender, emailTo, ccTo, subject, message);
3902 
        }
 5132 
        }
3903 
 
 5133 
 
3904 
 
 5134 
 
3905 
    }
 5135 
    }
3906 
 
 5136 
 
3907 
    private void settledLoanStatement(LoanReferenceType loanReferneceType, BigDecimal amount, int fofoId,
 - 
 
3908 
                                      int loanId, String description, LocalDateTime now) {
 - 
 
3909 
 
 - 
 
3910 
        sdCreditService.createLoanStatement(loanReferneceType, amount.abs(), fofoId, loanId, description, LocalDateTime.now());
 - 
 
3911 
 
 - 
 
3912 
    }
 - 
 
3913 
 
 - 
 
3914 
    private void createUserWalletHistory(int walletId, int userId, WalletReferenceType referenceType, int loanId,
 - 
 
3915 
                                         double interestAmount) {
 - 
 
3916 
        UserWalletHistory uwh = new UserWalletHistory();
 - 
 
3917 
        uwh.setWalletId(walletId);
 - 
 
3918 
        uwh.setFofoId(userId);
 - 
 
3919 
        uwh.setBusinessTimestamp(LocalDateTime.now());
 - 
 
3920 
        uwh.setReferenceType(referenceType);
 - 
 
3921 
        uwh.setReference(loanId);
 - 
 
3922 
        uwh.setTimestamp(LocalDateTime.now());
 - 
 
3923 
        uwh.setAmount((int) -(interestAmount));
 - 
 
3924 
        uwh.setDescription("Amount adjusted against loan");
 - 
 
3925 
        userWalletHistoryRepository.persist(uwh);
 - 
 
3926 
 
 - 
 
3927 
    }
 - 
 
3928 
 
 - 
 
3929 
    public void dailyLoanAlert() throws Exception {
 5137 
    public void dailyLoanAlert() throws Exception {
3930 
        List<Loan> loans = loanRepository.selectAllActiveLoan();
 5138 
        List<Loan> loans = loanRepository.selectAllActiveLoan();
3931 
 
 5139 
 
3932 
        Map<Integer, Double> partnerLoanAmount = new HashMap<>();
 5140 
        Map<Integer, Double> partnerLoanAmount = new HashMap<>();
3933 
 
 5141 
 
Line 4137... Line 5345...
4137 
                "<th style='border:1px solid black;padding: 5px'>State Name</th>\n" +
 5345 
                "<th style='border:1px solid black;padding: 5px'>State Name</th>\n" +
4138 
                "<th style='border:1px solid black;padding: 5px'>Area</th>\n" +
 5346 
                "<th style='border:1px solid black;padding: 5px'>Area</th>\n" +
4139 
                "<th style='border:1px solid black;padding: 5px'>Territory</th>\n" +
 5347 
                "<th style='border:1px solid black;padding: 5px'>Territory</th>\n" +
4140 
                "<th style='border:1px solid black;padding: 5px'>due date</th>\n" +
 5348 
                "<th style='border:1px solid black;padding: 5px'>due date</th>\n" +
4141 
                "<th style='border:1px solid black;padding: 5px'>Days</th>\n" +
 5349 
                "<th style='border:1px solid black;padding: 5px'>Days</th>\n" +
4142 
                "<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n"+
 5350 
                "<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n" +
4143 
                "<th style='border:1px solid black;padding: 5px'>RBM L1</th>\n" +
 5351 
                "<th style='border:1px solid black;padding: 5px'>RBM L1</th>\n" +
4144 
                "<th style='border:1px solid black;padding: 5px'>RBM L2</th>\n" +
 5352 
                "<th style='border:1px solid black;padding: 5px'>RBM L2</th>\n" +
4145 
                "<th style='border:1px solid black;padding: 5px'>Sales L1</th>\n" +
 5353 
                "<th style='border:1px solid black;padding: 5px'>Sales L1</th>\n" +
4146 
                "<th style='border:1px solid black;padding: 5px'>Sales L2</th>\n" +
 5354 
                "<th style='border:1px solid black;padding: 5px'>Sales L2</th>\n" +
4147 
                "</tr>");
 5355 
                "</tr>");
Line 4265... Line 5473...
4265 
        }
 5473 
        }
4266 
        String messageText = this.getMessageForDueDateCross(dueDateCrossLoans);
 5474 
        String messageText = this.getMessageForDueDateCross(dueDateCrossLoans);
4267 
        this.sendMailOfHtmlFormat(googleMailSender, new String[]{"puneet.wahi@smartdukaan.com"}, messageText, null, "Due Date Cross");
 5475 
        this.sendMailOfHtmlFormat(googleMailSender, new String[]{"puneet.wahi@smartdukaan.com"}, messageText, null, "Due Date Cross");
4268 
 
 5476 
 
4269 
 
 5477 
 
4270 
 
 - 
 
4271 
        if (!dueDateCrossLoans.isEmpty()) {
 5478 
        if (!dueDateCrossLoans.isEmpty()) {
4272 
            for (Loan loan : dueDateCrossLoans) {
 5479 
            for (Loan loan : dueDateCrossLoans) {
4273 
 
 5480 
 
4274 
                long noOfdaysBetween = ChronoUnit.DAYS.between(loan.getDueDate().toLocalDate(), LocalDate.now());
 5481 
                long noOfdaysBetween = ChronoUnit.DAYS.between(loan.getDueDate().toLocalDate(), LocalDate.now());
4275 
 
 5482 
 
Line 4801... Line 6008...
4801 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getFormattedBillingDate() + "</td>\n");
 6008 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getFormattedBillingDate() + "</td>\n");
4802 
 
 6009 
 
4803 
            sb.append("</tr>\n");
 6010 
            sb.append("</tr>\n");
4804 
 
 6011 
 
4805 
        }
 6012 
        }
4806 
        List<String> sendTo = Arrays.asList("uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com");
 6013 
        List<String> sendTo = Arrays.asList("uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com", "ritesh.chauhan1@smartdukaan.com");
4807 
 
 6014 
 
4808 
        String[] email = sendTo.toArray(new String[sendTo.size()]);
 6015 
        String[] email = sendTo.toArray(new String[sendTo.size()]);
4809 
        this.sendMailOfHtmlFormat(mailSender, email, sb.toString(), null, subject);
 6016 
        this.sendMailOfHtmlFormat(mailSender, email, sb.toString(), null, subject);
4810 
 
 6017 
 
4811 
    }
 6018 
    }
Line 5187... Line 6394...
5187 
        // Return the constructed HTML message
 6394 
        // Return the constructed HTML message
5188 
        return message;
 6395 
        return message;
5189 
    }
 6396 
    }
5190 
 
 6397 
 
5191 
}
 6398 
}
5192 
// 2284'
 - 
 
5193 

            6399
            
// 2284"

          

          

            -
            
 

            6400
            

          

          

            5194
            

            6401