Subversion Repositories SmartDukaan

Rev

Rev 36440 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
21292 ashik.ali 1
package com.spice.profitmandi.web.controller;
2
 
23300 amit.gupta 3
import java.time.LocalDateTime;
22495 amit.gupta 4
import java.util.Date;
23273 ashik.ali 5
import java.util.List;
21448 ashik.ali 6
import java.util.Set;
7
 
21292 ashik.ali 8
import javax.servlet.http.HttpServletRequest;
9
 
23786 amit.gupta 10
import org.apache.logging.log4j.LogManager;
23568 govind 11
import org.apache.logging.log4j.Logger;
21292 ashik.ali 12
import org.springframework.beans.factory.annotation.Autowired;
22355 ashik.ali 13
import org.springframework.beans.factory.annotation.Qualifier;
21292 ashik.ali 14
import org.springframework.http.ResponseEntity;
15
import org.springframework.stereotype.Controller;
21692 amit.gupta 16
import org.springframework.transaction.annotation.Transactional;
21309 ashik.ali 17
import org.springframework.web.bind.annotation.RequestBody;
21292 ashik.ali 18
import org.springframework.web.bind.annotation.RequestMapping;
19
import org.springframework.web.bind.annotation.RequestMethod;
20
import org.springframework.web.bind.annotation.RequestParam;
21
 
22
import com.spice.profitmandi.common.ResponseCodeHolder;
23
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
24
import com.spice.profitmandi.common.model.ProfitMandiConstants;
21463 ashik.ali 25
import com.spice.profitmandi.common.model.UserInfo;
22473 ashik.ali 26
import com.spice.profitmandi.common.util.StringUtils;
21740 ashik.ali 27
import com.spice.profitmandi.common.web.util.ResponseSender;
21735 ashik.ali 28
import com.spice.profitmandi.dao.entity.dtr.Brand;
22473 ashik.ali 29
import com.spice.profitmandi.dao.entity.dtr.DistrictMaster;
21735 ashik.ali 30
import com.spice.profitmandi.dao.entity.dtr.Document;
31
import com.spice.profitmandi.dao.entity.dtr.Retailer;
32
import com.spice.profitmandi.dao.entity.dtr.RetailerBrand;
33
import com.spice.profitmandi.dao.entity.dtr.RetailerRegisteredAddress;
34
import com.spice.profitmandi.dao.entity.dtr.Shop;
35
import com.spice.profitmandi.dao.entity.dtr.ShopAddress;
36
import com.spice.profitmandi.dao.entity.dtr.User;
23273 ashik.ali 37
import com.spice.profitmandi.dao.entity.dtr.UserAccount;
21768 amit.gupta 38
import com.spice.profitmandi.dao.entity.dtr.UserRole;
22656 ashik.ali 39
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
21735 ashik.ali 40
import com.spice.profitmandi.dao.entity.user.Address;
22355 ashik.ali 41
import com.spice.profitmandi.dao.entity.user.Cart;
42
import com.spice.profitmandi.dao.entity.user.Counter;
43
import com.spice.profitmandi.dao.entity.user.PrivateDealUser;
44
import com.spice.profitmandi.dao.entity.user.PrivateDealUserAddressMapping;
21768 amit.gupta 45
import com.spice.profitmandi.dao.enumuration.dtr.AccountType;
46
import com.spice.profitmandi.dao.enumuration.dtr.RoleType;
22495 amit.gupta 47
import com.spice.profitmandi.dao.model.RetailerFofoInterest;
21735 ashik.ali 48
import com.spice.profitmandi.dao.repository.dtr.BrandRepository;
22473 ashik.ali 49
import com.spice.profitmandi.dao.repository.dtr.DistrictMasterRepository;
21735 ashik.ali 50
import com.spice.profitmandi.dao.repository.dtr.DocumentRepository;
22473 ashik.ali 51
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
22495 amit.gupta 52
import com.spice.profitmandi.dao.repository.dtr.Mongo;
21735 ashik.ali 53
import com.spice.profitmandi.dao.repository.dtr.RetailerAddressRepository;
54
import com.spice.profitmandi.dao.repository.dtr.RetailerBrandRepository;
55
import com.spice.profitmandi.dao.repository.dtr.RetailerRegisteredAddressRepository;
56
import com.spice.profitmandi.dao.repository.dtr.RetailerRepository;
23786 amit.gupta 57
import com.spice.profitmandi.dao.repository.dtr.RoleRepository;
21735 ashik.ali 58
import com.spice.profitmandi.dao.repository.dtr.ShopAddressRepository;
59
import com.spice.profitmandi.dao.repository.dtr.ShopRepository;
21768 amit.gupta 60
import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
21735 ashik.ali 61
import com.spice.profitmandi.dao.repository.dtr.UserRepository;
21768 amit.gupta 62
import com.spice.profitmandi.dao.repository.dtr.UserRoleRepository;
21735 ashik.ali 63
import com.spice.profitmandi.dao.repository.user.AddressRepository;
22355 ashik.ali 64
import com.spice.profitmandi.dao.repository.user.CartRepository;
65
import com.spice.profitmandi.dao.repository.user.CounterRepository;
66
import com.spice.profitmandi.dao.repository.user.PrivateDealUserAddressMappingRepository;
67
import com.spice.profitmandi.dao.repository.user.PrivateDealUserRepository;
23048 ashik.ali 68
import com.spice.profitmandi.service.user.RetailerService;
21431 ashik.ali 69
import com.spice.profitmandi.web.req.Category;
21426 ashik.ali 70
import com.spice.profitmandi.web.req.CreateRetailerAddressRequest;
71
import com.spice.profitmandi.web.req.CreateRetailerRequest;
72
import com.spice.profitmandi.web.req.RetailerAddBrandRequest;
21292 ashik.ali 73
 
36625 amit 74
import com.spice.profitmandi.dao.entity.inventory.State;
75
import com.spice.profitmandi.dao.repository.inventory.StateRepository;
22355 ashik.ali 76
import in.shop2020.model.v1.user.CartStatus;
21302 ashik.ali 77
import io.swagger.annotations.ApiImplicitParam;
78
import io.swagger.annotations.ApiImplicitParams;
79
import io.swagger.annotations.ApiOperation;
80
 
21292 ashik.ali 81
@Controller
22037 amit.gupta 82
@Transactional(rollbackFor=Throwable.class)
21292 ashik.ali 83
public class RetailerController {
84
 
23568 govind 85
	private static final Logger LOGGER=LogManager.getLogger(RetailerController.class);
21292 ashik.ali 86
 
87
	@Autowired
22355 ashik.ali 88
	@Qualifier("userRepository")
22931 ashik.ali 89
	private UserRepository userRepository;
21463 ashik.ali 90
 
91
	@Autowired
22355 ashik.ali 92
	@Qualifier("userUserRepository")
22931 ashik.ali 93
	private com.spice.profitmandi.dao.repository.user.UserRepository userUserRepository;
22355 ashik.ali 94
 
95
	@Autowired
23048 ashik.ali 96
	private RetailerService retailerService;
97
 
98
	@Autowired
22931 ashik.ali 99
	private UserRoleRepository userRoleRepository;
21768 amit.gupta 100
 
101
	@Autowired
23786 amit.gupta 102
	private RoleRepository roleRepository;
103
 
104
	@Autowired
22931 ashik.ali 105
	private ResponseSender<?> responseSender;
21440 ashik.ali 106
 
107
	@Autowired
22931 ashik.ali 108
	private RetailerRepository retailerRepository;
21292 ashik.ali 109
 
21390 ashik.ali 110
	@Autowired
22931 ashik.ali 111
	private BrandRepository brandRepository;
21390 ashik.ali 112
 
113
	@Autowired
22931 ashik.ali 114
	private AddressRepository addressRepository;
21390 ashik.ali 115
 
116
	@Autowired
22931 ashik.ali 117
	private DocumentRepository documentRepository;
21390 ashik.ali 118
 
119
	@Autowired
22931 ashik.ali 120
	private ShopRepository shopRepository;
21390 ashik.ali 121
 
122
	@Autowired
22931 ashik.ali 123
	private UserAccountRepository userAccountRepository;
21768 amit.gupta 124
 
125
	@Autowired
22931 ashik.ali 126
	private RetailerRegisteredAddressRepository retailerRegisteredAddressRepository;
21390 ashik.ali 127
 
128
	@Autowired
22931 ashik.ali 129
	private RetailerAddressRepository retailerAddressRepository;
21426 ashik.ali 130
 
131
	@Autowired
22931 ashik.ali 132
	private ShopAddressRepository shopAddressRepository;
21390 ashik.ali 133
 
134
	@Autowired
22931 ashik.ali 135
	private RetailerBrandRepository retailerBrandRepository;
21390 ashik.ali 136
 
22355 ashik.ali 137
	@Autowired
22931 ashik.ali 138
	private CounterRepository counterRepository;
22355 ashik.ali 139
 
140
	@Autowired
22931 ashik.ali 141
	private PrivateDealUserRepository privateDealUserRepository;
22355 ashik.ali 142
 
143
	@Autowired
22931 ashik.ali 144
	private PrivateDealUserAddressMappingRepository privateDealUserAddressMappingRepository;
22355 ashik.ali 145
 
146
	@Autowired
22931 ashik.ali 147
	private CartRepository cartRepository;
22355 ashik.ali 148
 
22473 ashik.ali 149
	@Autowired
22931 ashik.ali 150
	private DistrictMasterRepository districtMasterRepository;
22473 ashik.ali 151
 
152
	@Autowired
22931 ashik.ali 153
	private FofoStoreRepository fofoStoreRepository;
36625 amit 154
 
155
	@Autowired
156
	private StateRepository stateRepository;
22473 ashik.ali 157
 
158
	@Autowired
22495 amit.gupta 159
	private Mongo mongoClient;
23786 amit.gupta 160
 
21302 ashik.ali 161
	@ApiImplicitParams({
162
		@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", 
163
				required = true, dataType = "string", paramType = "header")
164
	})
21309 ashik.ali 165
 
21302 ashik.ali 166
	@ApiOperation(value = "Create Retailer")
167
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER, method=RequestMethod.POST)
22931 ashik.ali 168
	public ResponseEntity<?> createRetailer(HttpServletRequest request, @RequestBody CreateRetailerRequest createRetailerRequest) throws ProfitMandiBusinessException{
22355 ashik.ali 169
		LOGGER.info("request received with body [{}] at url {{}}: ", createRetailerRequest, request.getRequestURL().toString());
22931 ashik.ali 170
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
171
		LOGGER.info("requestAttribute [userInfo={}]", userInfo);
172
		User user = userRepository.selectById(userInfo.getUserId());
173
		this.createRetailer(user, createRetailerRequest);
174
		return responseSender.ok(ResponseCodeHolder.getMessage("RTLR_OK_1000"));
175
 
21440 ashik.ali 176
	}
177
 
21768 amit.gupta 178
	private void createRetailer(User user, CreateRetailerRequest createRetailerRequest) 
22931 ashik.ali 179
			throws ProfitMandiBusinessException{
21390 ashik.ali 180
		Retailer retailer = new Retailer();
21426 ashik.ali 181
		retailer.setName(createRetailerRequest.getName());
182
		retailer.setNumber(createRetailerRequest.getNumber());
183
		retailer.setType(createRetailerRequest.getType());
184
		retailer.setMonthlySaleValue(createRetailerRequest.getMonthlySaleValue());
22732 ashik.ali 185
		retailer.setMonthlySaleVolume(createRetailerRequest.getMonthlySaleVolume());
23035 ashik.ali 186
		retailer.setPrimaryBuyingMode(createRetailerRequest.getPrimaryBuyingMode());
21426 ashik.ali 187
		retailer.setRecharge(createRetailerRequest.getLineOfBusiness().isRecharge());
188
		retailer.setMobile(createRetailerRequest.getLineOfBusiness().isMobile());
189
		retailer.setAccessories(createRetailerRequest.getLineOfBusiness().isAccessories());
21431 ashik.ali 190
		retailer.setOther1(createRetailerRequest.getLineOfBusiness().getOther1());
191
		retailer.setOther2(createRetailerRequest.getLineOfBusiness().getOther2());
22964 ashik.ali 192
		if(createRetailerRequest.getDocumentId() == 0){
193
			retailer.setDocumentId(null);
194
		}else{
23041 ashik.ali 195
			/*Document retailerDocument = documentRepository.selectById(createRetailerRequest.getDocumentId());
22964 ashik.ali 196
			if(retailerRepository.isExistByDocumentId(retailerDocument.getId())){
197
				LOGGER.error("documet is already mapped with another retailer");
198
				throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, retailerDocument.getId(), "DCMNT_1000");
23041 ashik.ali 199
			}*/
200
			retailer.setDocumentId(createRetailerRequest.getDocumentId());
201
			documentRepository.markDocumentAsPersisted(createRetailerRequest.getDocumentId());
21440 ashik.ali 202
		}
22964 ashik.ali 203
		Shop shop = new Shop();
204
		shop.setName(createRetailerRequest.getShop().getName());
205
 
206
		if(createRetailerRequest.getShop().getDocumentId() == 0){
207
			shop.setDocumentId(null);
208
		}else{
23041 ashik.ali 209
			/*final Document shopDocument = documentRepository.selectById(createRetailerRequest.getShop().getDocumentId());
22964 ashik.ali 210
			if(shopRepository.isExistByDocumentId(shopDocument.getId())){
211
				throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, shopDocument.getId(), "DCMNT_1000");
23041 ashik.ali 212
			}*/
213
			shop.setDocumentId(createRetailerRequest.getShop().getDocumentId());
214
			documentRepository.markDocumentAsPersisted(createRetailerRequest.getShop().getDocumentId());
21440 ashik.ali 215
		}
22355 ashik.ali 216
 
217
		com.spice.profitmandi.dao.entity.user.User saholicUser = null;
23042 ashik.ali 218
		boolean foundRetailerFlag = false;
22954 amit.gupta 219
		try {
220
			saholicUser = userUserRepository.selectByEmailId(user.getEmailId());
221
		}catch (ProfitMandiBusinessException e) {
222
			LOGGER.info("User doesnt exist in old system");
223
		}
22355 ashik.ali 224
		if(saholicUser == null){
225
			Cart cart = new Cart();
226
			cart.setCartStatus(CartStatus.ACTIVE);
227
			cartRepository.persist(cart);
228
			saholicUser = new com.spice.profitmandi.dao.entity.user.User();
229
			saholicUser.setEmailId(user.getEmailId());
230
			saholicUser.setName(createRetailerRequest.getName());
231
			saholicUser.setActiveCartId(cart.getId());
23300 amit.gupta 232
			saholicUser.setCreateTimestamp(LocalDateTime.now());
22355 ashik.ali 233
			userUserRepository.persist(saholicUser);
234
		}else{
23042 ashik.ali 235
			foundRetailerFlag = true;
22355 ashik.ali 236
		}
23042 ashik.ali 237
		Retailer foundRetailer = null;
23039 ashik.ali 238
		try{
23042 ashik.ali 239
			foundRetailer = retailerRepository.selectById(saholicUser.getId());
23039 ashik.ali 240
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
23041 ashik.ali 241
			LOGGER.info("Retailer is not registered");
23039 ashik.ali 242
		}
23042 ashik.ali 243
		if(foundRetailer != null){
244
			throw new ProfitMandiBusinessException(ProfitMandiConstants.EMAIL_ID, saholicUser.getEmailId(), "RTLR_1011");
245
		}
22355 ashik.ali 246
		//in.shop2020.model.v1.user.User saholicUser = Utils.createSaholicUser(user.getEmailId()); 
247
		retailer.setId(saholicUser.getId());
21440 ashik.ali 248
		retailerRepository.persist(retailer);
22355 ashik.ali 249
 
22965 ashik.ali 250
		shop.setRetailerId(retailer.getId());
23041 ashik.ali 251
		//LOGGER.info("Shop is persisting ... [{}]",shop);
22965 ashik.ali 252
		shopRepository.persist(shop);
22964 ashik.ali 253
 
21448 ashik.ali 254
		this.addBrandWithRetailer(retailer.getId(), createRetailerRequest.getCategories());
21440 ashik.ali 255
		final Address addressRetailer = this.createAddress(createRetailerRequest.getAddress());
21706 amit.gupta 256
		addressRetailer.setRetaierId(retailer.getId());
22041 amit.gupta 257
		addressRepository.persist(addressRetailer);
22355 ashik.ali 258
 
21440 ashik.ali 259
		final RetailerRegisteredAddress retailerRegisteredAddress = new RetailerRegisteredAddress();
260
		retailerRegisteredAddress.setRetailerId(retailer.getId());
261
		retailerRegisteredAddress.setAddressId(addressRetailer.getId());
262
		retailerRegisteredAddressRepository.persist(retailerRegisteredAddress);
21463 ashik.ali 263
		if(!createRetailerRequest.isShopAddressSameAsRetailerAddress() && createRetailerRequest.getAddress() == null){
264
			throw new ProfitMandiBusinessException(ProfitMandiConstants.ADDRESS, "", "");
21440 ashik.ali 265
		}
21463 ashik.ali 266
		if(createRetailerRequest.isShopAddressSameAsRetailerAddress()){
267
			ShopAddress shopAddress = new ShopAddress();
268
			shopAddress.setShopId(shop.getId());
269
			shopAddress.setAddressId(addressRetailer.getId());
270
			shopAddressRepository.persist(shopAddress);
271
		}else{
272
			final Address addressShop = this.createAddress(createRetailerRequest.getShop().getAddress());
22855 amit.gupta 273
			addressShop.setRetaierId(retailer.getId());
23635 amit.gupta 274
			addressShop.setName(createRetailerRequest.getShop().getName());
22041 amit.gupta 275
			addressRepository.persist(addressShop);
21463 ashik.ali 276
			ShopAddress shopAddress = new ShopAddress();
277
			shopAddress.setShopId(shop.getId());
278
			shopAddress.setAddressId(addressShop.getId());
279
			shopAddressRepository.persist(shopAddress);
280
		}
23273 ashik.ali 281
		UserAccount ua = new UserAccount();
282
		ua.setAccountKey(saholicUser.getId());
283
		ua.setUserId(user.getId());
284
		ua.setType(AccountType.saholic);
21768 amit.gupta 285
		userAccountRepository.persist(ua);
286
 
23273 ashik.ali 287
		UserAccount ua2 = new UserAccount();
288
		ua2.setAccountKey(saholicUser.getActiveCartId());
289
		ua2.setUserId(user.getId());
290
		ua2.setType(AccountType.cartId);
21768 amit.gupta 291
		userAccountRepository.persist(ua2);
292
 
293
		UserRole ur = new UserRole();
23786 amit.gupta 294
		ur.setRoleId(roleRepository.selectByName(RoleType.RETAILER.name()).getId());
21768 amit.gupta 295
		ur.setUserId(user.getId());
296
		userRoleRepository.persist(ur);
22355 ashik.ali 297
 
23042 ashik.ali 298
		if(foundRetailerFlag){
22355 ashik.ali 299
			LOGGER.info("\n\n\n****retailer found\n\n\n");
22604 ashik.ali 300
			PrivateDealUser privateDealUser = null;
301
			try{
302
				privateDealUser = privateDealUserRepository.selectById(saholicUser.getId());
303
			}catch(ProfitMandiBusinessException profitMandiBusinessException){
304
				LOGGER.error("PrivateDealUser not found : ", profitMandiBusinessException);
305
			}
22503 amit.gupta 306
			if(privateDealUser == null) {
307
				privateDealUser = new PrivateDealUser();
308
				privateDealUser.setActive(true);
309
				privateDealUser.setBulkShipmentAmountLimit(50000);
310
				privateDealUser.setId(saholicUser.getId());
311
				privateDealUserRepository.persist(privateDealUser);
312
				PrivateDealUserAddressMapping privateDealUserAddressMapping = new PrivateDealUserAddressMapping();
23332 ashik.ali 313
				privateDealUserAddressMapping.setUserId(retailer.getId());
314
				privateDealUserAddressMapping.setAddressId(addressRetailer.getId());
22503 amit.gupta 315
				privateDealUserAddressMappingRepository.persist(privateDealUserAddressMapping);
316
			}
22355 ashik.ali 317
			if(privateDealUser.getCounterId() == null){
318
				Integer counterId = this.createCounter(user.getEmailId(), createRetailerRequest.getGstNumber(), user.getMobileNumber(), retailer.getName(), addressRetailer.getId());
319
				privateDealUser.setCounterId(counterId);
320
				privateDealUserRepository.persist(privateDealUser);
321
			}
322
		}else{
323
			LOGGER.info("retailer not found");
324
			//gst number intergration with counter
325
			Integer counterId = this.createCounter(user.getEmailId(), createRetailerRequest.getGstNumber(), user.getMobileNumber(), retailer.getName(), addressRetailer.getId());
326
 
327
 
22604 ashik.ali 328
			PrivateDealUser privateDealUser = null;
329
			try{
330
				privateDealUser = privateDealUserRepository.selectById(saholicUser.getId());
331
			}catch(ProfitMandiBusinessException profitMandiBusinessException){
22875 amit.gupta 332
				LOGGER.warn("PrivateDealUser not found");
22604 ashik.ali 333
			}
334
 
22355 ashik.ali 335
			if(privateDealUser != null){
336
				//LOGGER.info("PrivateDealUser found with id [{}]", saholicUser.getId());
337
				privateDealUser.setCounterId(counterId);
338
				privateDealUserRepository.update(privateDealUser);
339
			}else{	
22875 amit.gupta 340
				LOGGER.info("PrivateDealUser not found with id [{}], creating it", saholicUser.getId());
22355 ashik.ali 341
				privateDealUser = new PrivateDealUser();
342
				privateDealUser.setActive(true);
343
				privateDealUser.setBulkShipmentAmountLimit(50000);
344
				privateDealUser.setId(saholicUser.getId());
345
				privateDealUser.setCounterId(counterId);
346
				privateDealUserRepository.persist(privateDealUser);
347
			}
348
			PrivateDealUserAddressMapping privateDealUserAddressMapping = new PrivateDealUserAddressMapping();
23332 ashik.ali 349
			privateDealUserAddressMapping.setUserId(retailer.getId());
350
			privateDealUserAddressMapping.setAddressId(addressRetailer.getId());
22355 ashik.ali 351
			privateDealUserAddressMappingRepository.persist(privateDealUserAddressMapping);
352
 
353
			saholicUser.setAddressId(addressRetailer.getId());
354
			userUserRepository.persist(saholicUser);
355
		}
21292 ashik.ali 356
	}
357
 
22355 ashik.ali 358
	private Integer createCounter(String emailId, String gstNumber, String mobileNumber, String name, int addressId){
359
		if(gstNumber != null && !gstNumber.isEmpty()){
360
			Counter counter = new Counter();
361
			counter.setEmailId(emailId);
362
			counter.setGstin(gstNumber);
363
			counter.setMobileNumber(mobileNumber);
364
			counter.setName(name);
365
			counter.setAddressId(addressId);
23300 amit.gupta 366
			counter.setCreatedOn(LocalDateTime.now());
22355 ashik.ali 367
			counterRepository.persist(counter);
368
			return counter.getId();
369
		}else{
370
			return null;
371
		}
21463 ashik.ali 372
	}
22355 ashik.ali 373
 
374
 
21448 ashik.ali 375
	private void addBrandWithRetailer(int retailerId, Set<Category> categories)
376
		throws ProfitMandiBusinessException{
377
		for(Category category : categories){
378
			for(com.spice.profitmandi.web.req.Brand brandModel : category.getBrands()){
379
				Brand brand = brandRepository.selectByIdAndName(brandModel.getId(), brandModel.getName());
380
				final RetailerBrand retailerBrand = new RetailerBrand();
381
				retailerBrand.setRetailerId(retailerId);
382
				retailerBrand.setBrandId(brand.getId());
383
				retailerBrandRepository.persist(retailerBrand);
384
			}
385
		}
386
	}
22524 ashik.ali 387
 
388
	@ApiOperation(value = "Create Fofo Store")
389
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_FOFO_FOFO_STORE, method=RequestMethod.POST)
390
	public ResponseEntity<?> createFofoStore(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.DISTRICT_NAME) String districtName) throws ProfitMandiBusinessException, Exception{
22931 ashik.ali 391
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
392
		LOGGER.info("requestAttribute [userInfo={}]", userInfo);
393
		User user = userRepository.selectById(userInfo.getUserId());
394
		// = userAccountRepository.selectRetailerIdByUserId(user.getId());
23273 ashik.ali 395
		UserAccount userAccounts = userAccountRepository.selectSaholicByUserId(user.getId());
396
		Retailer retailer = retailerRepository.selectById(userAccounts.getAccountKey());
22524 ashik.ali 397
		try{
23786 amit.gupta 398
			userRoleRepository.selectByUserIdAndRoleId(user.getId(), roleRepository.selectByName(RoleType.FOFO.name()).getId());
22931 ashik.ali 399
		}catch(ProfitMandiBusinessException profitMandiBusinessException){
400
			throw new ProfitMandiBusinessException(ProfitMandiConstants.USER_ID, user.getId(), "USR_1013");
401
		}
402
 
403
		boolean foundFofoStore = false;
404
		try{
405
			fofoStoreRepository.selectByRetailerId(retailer.getId());
406
			foundFofoStore = true;
407
		}catch (ProfitMandiBusinessException profitMandiBusinessException) {
22604 ashik.ali 408
 
22524 ashik.ali 409
		}
22931 ashik.ali 410
 
411
		if(foundFofoStore){
412
			throw new ProfitMandiBusinessException(ProfitMandiConstants.RETAILER_ID, retailer.getId(), "USR_1014");
413
		}			
414
 
415
		int retailerAddressId = retailerRegisteredAddressRepository.selectAddressIdByRetailerId(retailer.getId());
416
		Address retailerAddress = addressRepository.selectById(retailerAddressId);
417
 
36625 amit 418
		State state = stateRepository.selectByName(retailerAddress.getState());
419
		DistrictMaster districtMaster = districtMasterRepository.selectByNameAndStateShortName(districtName, state.getShortName());
22931 ashik.ali 420
 
421
		FofoStore fofoStore = new FofoStore();
23786 amit.gupta 422
		String latestStoreCode = fofoStoreRepository.selectLatestStore().getCode();
423
		int latestCodeCounter = Integer.parseInt(latestStoreCode.replaceAll("[A-Z]", ""));
22931 ashik.ali 424
		fofoStore.setId(retailer.getId());
23786 amit.gupta 425
		String fofoStoreCode = StringUtils.generateFofoStoreSequence(districtMaster.getStateShortName() + districtMaster.getShortName(), latestCodeCounter + 1);
22931 ashik.ali 426
		fofoStore.setCode(fofoStoreCode);
36440 amit 427
		fofoStore.setOutletName(retailerAddress.getName());
22931 ashik.ali 428
		fofoStoreRepository.persist(fofoStore);
429
 
430
		return responseSender.ok(ResponseCodeHolder.getMessage("RTLR_OK_1003"));
431
 
22524 ashik.ali 432
	}
433
 
23048 ashik.ali 434
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_EMAIL_ID_OR_MOBILE_NUMBER, method = RequestMethod.GET)
435
	public ResponseEntity<?> getByEmailIdOrMobileNumber(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.EMAIL_ID_OR_MOBILE_NUMBER) String emailIdOrMobileNumber)  throws ProfitMandiBusinessException{
436
		LOGGER.info("Request Received at url {} with emailIdOrMobileNumber {}", request.getRequestURI(), emailIdOrMobileNumber);
437
		return responseSender.ok(retailerService.getByEmailIdOrMobileNumber(emailIdOrMobileNumber));
438
	}
439
 
21292 ashik.ali 440
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ALL,method=RequestMethod.GET)
21496 ashik.ali 441
	public ResponseEntity<?> getAll(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.PAGE_NUMBER) int pageNumber, @RequestParam(name = ProfitMandiConstants.PAGE_SIZE) int pageSize){
21292 ashik.ali 442
		LOGGER.info("requested url : "+request.getRequestURL().toString());
21496 ashik.ali 443
		return responseSender.ok(retailerRepository.selectAll(pageNumber, pageSize));
21292 ashik.ali 444
	}
445
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ID, method=RequestMethod.GET)
22931 ashik.ali 446
	public ResponseEntity<?> getById(HttpServletRequest request, @RequestParam(name = "id") int id) throws ProfitMandiBusinessException{
21292 ashik.ali 447
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 448
		return responseSender.ok(retailerRepository.selectById(id));
21292 ashik.ali 449
	}
450
 
451
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_NAME, method=RequestMethod.GET)
22931 ashik.ali 452
	public ResponseEntity<?> getByName(HttpServletRequest request, @RequestParam(name = "name") String name) throws ProfitMandiBusinessException{
21292 ashik.ali 453
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 454
		return responseSender.ok(retailerRepository.selectByName(name));
21292 ashik.ali 455
	}
456
 
457
 
458
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ID,method=RequestMethod.DELETE)
22931 ashik.ali 459
	public ResponseEntity<?> removeById(HttpServletRequest request, @RequestParam(name = "id") int id) throws ProfitMandiBusinessException{
21292 ashik.ali 460
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 461
		retailerRepository.deleteById(id);
462
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
21292 ashik.ali 463
	}
464
 
21426 ashik.ali 465
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_SHOP_ADD, method=RequestMethod.POST)
22931 ashik.ali 466
	public ResponseEntity<?> addShop(HttpServletRequest request, @RequestBody com.spice.profitmandi.web.req.Shop createShop, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 467
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 468
		Document document = documentRepository.selectById(createShop.getDocumentId());
469
		if(shopRepository.isExistByDocumentId(createShop.getDocumentId())){
470
			LOGGER.error("documet is already mapped with another shop");
471
			throw new ProfitMandiBusinessException(ProfitMandiConstants.DOCUMENT_ID, document.getId(), "");
21426 ashik.ali 472
		}
22931 ashik.ali 473
		retailerRepository.selectById(retailerId);
474
		Shop shop = new Shop();
475
		shop.setRetailerId(retailerId);
476
		Address address = this.createAddress(createShop.getAddress());
477
		addressRepository.persist(address);
478
		shop.setAddressId(address.getId());
479
		shop.setDocumentId(document.getId());
480
		shopRepository.persist(shop);
481
		ShopAddress shopAddress = new ShopAddress();
482
		shopAddress.setAddressId(address.getId());
483
		shopAddress.setShopId(shop.getId());
484
		shopAddressRepository.persist(shopAddress);
485
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
486
 
21426 ashik.ali 487
	}
488
 
489
 
21302 ashik.ali 490
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_SHOP_REMOVE, method=RequestMethod.DELETE)
22931 ashik.ali 491
	public ResponseEntity<?> removeShop(HttpServletRequest request, @RequestParam(name = "shopId") int shopId, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21292 ashik.ali 492
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 493
		retailerRepository.removeShop(shopId, retailerId);
494
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
21292 ashik.ali 495
	}
496
 
21426 ashik.ali 497
	private Address createAddress(com.spice.profitmandi.web.req.Address createAddress){
498
		Address address = new Address();
499
		address.setName(createAddress.getName());
500
		address.setLine1(createAddress.getLine1());
501
		address.setLine2(createAddress.getLine2());
502
		address.setLandmark(createAddress.getLandmark());
503
		address.setCity(createAddress.getCity());
504
		address.setState(createAddress.getState());
505
		address.setPinCode(createAddress.getPinCode());
506
		address.setCountry(createAddress.getCountry());
507
		address.setPhoneNumber(createAddress.getPhoneNumber());
508
		return address;
509
	}
21440 ashik.ali 510
 
21426 ashik.ali 511
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ADDRESS_ADD, method=RequestMethod.POST)
22931 ashik.ali 512
	public ResponseEntity<?> addAddress(HttpServletRequest request, @RequestBody CreateRetailerAddressRequest createRetailerAddress) throws ProfitMandiBusinessException{
21426 ashik.ali 513
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 514
		retailerRepository.addAddress(this.createAddress(createRetailerAddress.getAddress()), createRetailerAddress.getRetailerId());
515
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
516
 
21426 ashik.ali 517
	}
21292 ashik.ali 518
 
21426 ashik.ali 519
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ADDRESS_REMOVE, method=RequestMethod.DELETE)
22931 ashik.ali 520
	public ResponseEntity<?> removeAddress(HttpServletRequest request, @RequestParam(name = "addressId") int addressId, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 521
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 522
		retailerRepository.removeAddress(addressId, retailerId);
523
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
21426 ashik.ali 524
	}
525
 
526
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_BRAND_ADD, method=RequestMethod.POST)
22931 ashik.ali 527
	public ResponseEntity<?> addBrand(HttpServletRequest request, @RequestBody RetailerAddBrandRequest retailerAddBrandRequest) throws ProfitMandiBusinessException{
21426 ashik.ali 528
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 529
		retailerRepository.selectById(retailerAddBrandRequest.getRetailerId());
530
		this.addBrandWithRetailer(retailerAddBrandRequest.getRetailerId(), retailerAddBrandRequest.getCategories());
531
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
532
 
21426 ashik.ali 533
	}
534
 
535
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_BRAND_REMOVE, method=RequestMethod.DELETE)
22931 ashik.ali 536
	public ResponseEntity<?> removeBrand(HttpServletRequest request, @RequestParam(name = "brandId") int brandId, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 537
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 538
		brandRepository.selectById(brandId);
539
		retailerRepository.selectById(retailerId);
23273 ashik.ali 540
		retailerBrandRepository.deleteByRetailerIdBrandId(retailerId, brandId);
22931 ashik.ali 541
		return responseSender.ok(ResponseCodeHolder.getMessage("API_OK_1001"));
542
 
21426 ashik.ali 543
	}
544
 
545
 
21448 ashik.ali 546
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_DOCUMENT, method=RequestMethod.GET)
22931 ashik.ali 547
	public ResponseEntity<?> getDocumentById(HttpServletRequest request, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21426 ashik.ali 548
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 549
		return responseSender.ok(retailerRepository.selectDocumentById(retailerId));
550
 
21426 ashik.ali 551
	}
552
 
21448 ashik.ali 553
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_REGISTERED_ADDRESS, method=RequestMethod.GET)
22931 ashik.ali 554
	public ResponseEntity<?> getRegisteredAddressById(HttpServletRequest request, @RequestParam(name = "retailerId") int retailerId) throws ProfitMandiBusinessException{
21448 ashik.ali 555
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 556
		return responseSender.ok(retailerRegisteredAddressRepository.selectAddressIdByRetailerId(retailerId));
557
 
21448 ashik.ali 558
	}
559
 
21426 ashik.ali 560
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_SHOP_ALL, method=RequestMethod.GET)
22931 ashik.ali 561
	public ResponseEntity<?> getAllShops(HttpServletRequest request, @RequestParam(name = "id") int id)throws ProfitMandiBusinessException{
21426 ashik.ali 562
		LOGGER.info("requested url : "+request.getRequestURL().toString());
22931 ashik.ali 563
		return responseSender.ok(shopRepository.selectByRetailerId(id));
564
 
21426 ashik.ali 565
	}
566
 
567
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_ADDRESS_ALL, method=RequestMethod.GET)
33249 ranu 568
	public ResponseEntity<?> getAllAddresses(HttpServletRequest request, @RequestParam(name = "id") int id) throws ProfitMandiBusinessException {
21426 ashik.ali 569
		LOGGER.info("requested url : "+request.getRequestURL().toString());
23273 ashik.ali 570
		List<Integer> addressIds = retailerAddressRepository.selectAddressIdsByRetailerId(id);
571
		return responseSender.ok(addressRepository.selectByIds(addressIds));
21426 ashik.ali 572
	}
573
 
574
 
575
	@RequestMapping(value = ProfitMandiConstants.URL_RETAILER_BRAND_ALL, method=RequestMethod.GET)
21431 ashik.ali 576
	public ResponseEntity<?> getAllBrads(HttpServletRequest request, @RequestParam(name = "id") int id){
21426 ashik.ali 577
		LOGGER.info("requested url : "+request.getRequestURL().toString());
21440 ashik.ali 578
		return responseSender.ok(retailerBrandRepository.selectBrandNamesByRetailerId(id));
21426 ashik.ali 579
	}
22495 amit.gupta 580
 
581
	@RequestMapping(value = "/retailer/showFofoInterest", method=RequestMethod.GET)
22931 ashik.ali 582
	public ResponseEntity<?> showFofoInterest(HttpServletRequest request) throws ProfitMandiBusinessException{
22495 amit.gupta 583
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
584
		User user = userRepository.selectById(userInfo.getUserId());
585
		RetailerFofoInterest retailerInterest = new RetailerFofoInterest();
586
		retailerInterest.setCity(user.getCity());
587
		retailerInterest.setMobile(user.getMobileNumber());
588
		retailerInterest.setUserId(userInfo.getUserId());
22876 amit.gupta 589
		if(user.getPinCode()!=null){
590
			retailerInterest.setPinCode(user.getPinCode());
591
		}
22495 amit.gupta 592
		retailerInterest.setInterestShownOn(new Date());
593
		LOGGER.info("requested url : "+request.getRequestURL().toString());
594
		return responseSender.ok(mongoClient.saveRetailerInterestOnFofo(retailerInterest));
595
	}
596
 
597
	@RequestMapping(value = "/retailer/hasRetailerShownInterest", method=RequestMethod.GET)
598
	public ResponseEntity<?> getAllBrads(HttpServletRequest request) throws Throwable{
599
		UserInfo userInfo = (UserInfo)request.getAttribute("userInfo");
600
		LOGGER.info("requested url : "+request.getRequestURL().toString());
601
		return responseSender.ok(mongoClient.hasRetailerShownInterest(userInfo.getUserId()));
602
	}
21426 ashik.ali 603
 
21292 ashik.ali 604
}